Loading...
5.b) Treasurers Reportv. SCANDIIA Beginning Balance 06/01/2015 Receipts Expenditures Payroll City of Scandia Treasurer's Report June 30, 2015 $ 156,021.95 $ 30.403.45 $ 2,943.401.61 $ 41 557.33 -$186,425.40 Adjustments: Jahnke HSA part. Fee -1.00 Ending Balance 06/30/2015 $ 2,798,532.54 ************************************************************************ Ending Balance includes the following Investments: Money Market - Rate .25% CD *3136 — Rate .90%, 24 mo., 3/21/2017 CD *3137 — Rate .40% 18 mo., 7/21/2015 Total Undesignated Investments Quinnell CD *3134 — Rate .40%, 18 mo., 8/05/2015 Scandia EDA *6301 Childers Credit, Savings *3110 — Rate .05% Total Designated Investments Submitted by: Colleen Firkus, Treasurer $ 2,027,788.37 $ 303,689.76 $ 314,933.66 $ 2,646,411.79 $ 125,046.74 $ 415.47 $ 5,010.36 $ 130,472.57 GENERALFUND Administration & Finance City Council Elections Planning & Building Police Fire Dept. Public Works Parks & Recreation Community Center Total GENERAL FUND EDA DEBT SERVICE BLACKTOP PROJECCT 2007 FIREHALL/PUBLIC WORKS BOND 2010 EQUIPMENT CERTIFICATES 2011 EQUIPMENT CERTIFICATES 2013 EQUIPMENT CERTIFICATES 2015 EQUIPMENT CERTIFICATE Total Debt Service CAPITAL IMPROVEMENTS PARK CAPITAL IMPROVEMENTS EQUIPMENT REPLACEMENT LOCAL ROAD IMPROVEMENT FUND 201 SEWER FUND UPTOWN SEWER CITY OF SCANDIA Expenditure Summary June 2015 2015 2015 June 2015 % of YTD YTD Budget YTD Amt MTD Amt YTD Balance Budget $361,667.00 $166,289.70 $29,100.37 $195,377.30 $20,121.00 $6,032.80 $0.00 $14,088.20 $470.00 $300.00 $0.00 $170.00 $71,700.00 $27,309.59 $7.666.33 $44,390.41 $120,989.00 $309.16 $0.00 $120,679.84 $271,516.00 $95,269.87 $11,493.91 $176,246.13 $1,039,154.00 $434,582.97 $28,636.77 $604,571.03 $62,246.00 $24,743.40 $3,212.17 $37,502.60 $39,479.00 $14,186.28 $1,996.19 $25,292.72 $1,987,342.00 $769,023.77 $82,105.74 $1,218,318.23 $5,000.00 $345.00 $0.00 $4,655.00 $140,188.00 $7,593.75 $0.00 $132,594.25 $0.00 $0.00 $0.00 $0.00 $42,080.00 $41,370.00 $0.00 $710.00 $32,310.00 $1,155.00 $0.00 $31,155.00 $66,020.00 $61,055.00 $60,620.00 $4,965.00 $0.00 $2,000.00 $2,000.00 -$2,000.00 $280,598.00 $113,173.75 $62,620.00 $167,424.25 $412,000.00 $0.00 $0.00 $412,000.00 $36,000.00 $5,082.20 $3,405.00 $30,917.80 $230,000.00 $0.00 $0.00 $230,000.00 $550,000.00 $56,260.50 $32,430.50 $493,739.50 $62,170.00 $24,481.96 $3,801.03 $37,688.04 $19,323.00 $5,951.25 $988.30 $13,371.75 45.98% 29.98% 63.83% 38.09% 0.26% 35.09% 41.82% 39.75% 35.93% 38.70% 6.90% 5.42% 0.00% 98.31% 3.57% 92.48% 0.00% 0.00% 14.12% 0.00% 10.23% 39.38% 30.80% Report Total $3,582,433.00 $974,318.43 $185,350.57 $2,608,114.57 27.20% *u . :SCAN DIA CASH BALANCES 2015 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE 101 GENERAL $1,509,925 $1,542,192 $1,472,581 $1,394,661 $1,112,532 $1,061,983 225 EDA $760 $760 $760 $760 $415 $416 307 BLACKTOP 2007 $267,037 $267,735 $287,055 $279,461 $279,461 $279,461 310 FIRE HALL/PUBLIC WORKS BOND $19,272 $19,321 $0 $0 $0 $0 311 EQUIPMENT CERTIFICATES $9,431 $9,560 $9,560 $9,560 $9,560 $9,560 312 EQUIPMENT CERTIFICATES $5,085 $5,099 $5,099 $5,099 $3,944 $3,944 313 EQUIPMENT CERTIFICATES $8,119 $7,684 $7,684 $7,684 $7,684 -$52,936 315 EQUIPMENT CERTIFICATES -$2,000 401 CAPITAL IMPR $297,818 $298,517 $301,157 $301,157 $301,157 $301,157 404 PARK CAP IMPR $1,055 $1,067 $4,067 $8,117 $7,640 $4,235 406 EQUIPMENT REPLACEMENT $449,710 $451,023 $451,023 $451,023 $471,023 $471,023 408 LOCAL ROAD IMPROVEMENT $327,704 $328,137 $328,137 $328,137 $504,307 $471,877 602 201 SEWER $153,766 $146,838 $153,856 $157,048 $150,969 $156,617 612 UPTOWN SEWER $941 $1,417 -$1,962 $784 -$329 -$1,317 801 ESCROW $193,112 $61,378 $95,205 $94,387 $95,037 $94,512 TOTAL $3,243,735 $3,140,727 $3,114,224 $3,037,878 $2,943,401 $2,798,533