Loading...
5.b Treasurers ReportSCANDIIA Beginning Balance 07/01/2016 Receipts Expenditures Payroll Adjustments: Ending Balance 7/31/2016 City of Scandia Treasurer's Report 7/31/2016 Ending Balance includes the following Investments: $ 572,923.57 $ 25,483.65 $ 2,351,951.07 $ 1,273,351.12 $ (598,407.22) $ 3,026,894.97 Checking *102 $ 13,048.77 Money Market *105 - Rate .25% $ 2,390,641.75 CD *3136 — Rate .90%, 24 mo., 3/21/2017 $ 306,439.75 CD *3137 — Rate .80% 18 mo., 1/21/2017 $ 317,779.47 Total Undesignated Funds $ 3,027,909.74 Scandia EDA *6301 $ 5,070.47 Total Designated Funds $ 5,070.47 Checks in Transit $ (6,085.24) Deposits in Transit $ Total Funds $ 3,026,894.97 Submitted by: Colleen Firkus, Treasurer SCANDILA City of Scandia Expenditure Summary July 2016 2016 YTD Budget % of YTD GENERAL FUND 2016 YTD Budget 2016 YTD Amount 2016 MTD Amount Balance Budget Administration & Finance $324,848.00 $190,259.58 $21,771.94 $134,588.42 5857% City Council $26,97600 $8,826.52 $4,384.76 $18,149.48 3272% Elections $6,150.00 $60000 $0.00 $5,550.00 976% Planning & Building $96,206.00 $51,839.65 $9,89077 $44,36635 5388% Police $116,197.00 $30936 $0.00 $115,887.64 0.27% Fire Department $240,576.00 $75,422.87 $9,874.04 $165,15313 3135% Public Works $1,197,15300 $591,848.36 $368,626.67 $605,30464 49.44% Parks & Recreation $60,879.00 $28,74373 $3,102.84 $32,13527 47.21% Community Center $40,261.00 $20.289.65 $3.842.59 $19,971 35 50.40% Total General Fund $2,109,246.00 $968,139.72 $421,493.61 $1,141,106.28 45.90% EDA $0.00 $325.00 $000 -$325.00 000% DEBT 2010 EQUIPMENT CERTIFICATES $43,010.00 $40,710.00 $000 $2,300.00 94.65% 2011 EQUIPMENT CERTIFICATES $31,185.00 $59250 $0.00 $30,592.50 190% 2013 EQUIPMENT CERTIFICATES $65,82300 $60,895.00 -$435.00 $4,928.00 92 51 % 2015 EQUIPMENT CERTIFICATE $46,72000 $47,020.50 -$300.50 10064;0 $186,738.00 $149,218.00 -$435.00 $37,520.00 79.91% CAPITAL IMPROVEMENTS $40,00000 $2,37000 $000 $37,630.00 593% PARK CAPITAL IMPROVEMENTS $38,500.00 $0.00 $0.00 $38,500.00 000% EQUIPMENT REPLACEMENT $315,000.00 $000 $000 $315,000.00 000% LOCAL ROAD IMPROVEMENT FUP $1,250,000 00 $820,67469 $514,77771 $429,325.31 6565% 201 SEWER FUND $50,730.00 $32,556.96 $3,400.81 $18,173.04 64.18% UPTOWN SEWER $16,035.00 $9,01005 $704,26 $7.02495 56.19":', Report Total $4,006,249.00 $1,982,294.42 $939,941.39 $2,023,954.58 49.48% Sim SCANIllA CASH BALANCES 2016 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY 101 GENERAL $1,737,452 $1,639,251 $1,548,904 $1,483,118 $1,429,801 $1,344,311 1,776,519 225 EDA $5,395 $5,395 $5,396 $5,070 $5,070 $5,070 5,070 307 BLACKTOP 2007 $42,934 $42,934 $42,934 $57,829 $58,187 $58,187 67,914 311 EQUIPMENT CERTIFICATES $12,360 $12,360 $12,360 $12,360 $12,360 $12,360 12,360 312 EQUIPMENT CERTIFICATES $6,735 $6,735 $6,735 $6,735 $6,143 $6,143 22,510 313 EQUIPMENT CERTIFICATES $10,521 $10,086 $10,086 $10,086 $10,086 -$50,809 -15,828 315 EQUIPMENT CERTIFICATES $0 -$2,010 -$2,010 -$2,010 -$2,010 -$47,021 -23,643 401 CAPITAL IMPR $290,627 $289,390 $289,270 $289,270 $287,020 $287,020 307,660 404 PARK CAP IMPR $15,188 $15,188 $15,280 $16,030 $20,230 $20,380 17,380 406 EQUIPMENT REPLACEMENT $470,608 $470,608 $499,258 $499,258 $499,258 $499,258 499,258 408 LOCAL ROAD IMPROVEMENT $444,981 $402,956 $395,563 $392,240 $389,808 $97,790 227,821 602201 SEWER $58,473 $47,447 $51,642 $56,707 $52,283 $57,774 65,817 612 UPTOWN SEWER -$5,307 $2,640 $1,101 -$957 $1,717 $680 2,110 801 ESCROW $101,798 $83,597 $74,737 $66,746 $62,945 $60,808 61,947 TOTAL $3,191,766 $3,026,576 $2,951,256 $22892,481 $2,832,898 $2,351,951 $3,026,895