Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.b) Treasurer's Report
Beginning Balance 07/01/2015 Receipts Expenditures Payroll City of Scandia Treasurer's Report July 31, 2015 $_ 166,593.67 $ 28,174.12 $ 2,798,532.54 $ 1,475,931.59 -$194,767.79 Adjustments: State Surcharges -$1,162.61 Ending Balance 07/31/2015 $ 4,078,533.73 ************************************************************************ Ending Balance includes the following Investments: Money Market - Rate .25% CD *3136 — Rate .90%, 24 mo., 3/21/2017 CD *3137 — Rate .80% 18 mo., 1/21/2017 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 $ 3,285,811.95 $ 303,689.76 $ 315,247.73 $ 3,904,749.44 $ 125,046.74 $ 2,895.47 $ 5,010.36 $ 132,952.57 CITY OF SCANDIA Expenditure Summary July 2015 Total GENERAL FUND $1,987,342.00 $937,656.65 $168,632.88 $1,049,685.35 47.18% EDA $5,000.00 $365.00 $20.00 $4,635.00 7.30% DEBT SERVICE BLACKTOP PROJECCT 2007 2015 2015 July 2015 % of YTD FIREHALLIPUBLIC WORKS BOND YTD Budget YTD Amt MTD Amt YTD Balance Budget GENERALFUND $42,080.00 $42,080.00 $710.00 $0.00 100.00% Administration & Finance $361,667.00 $187,083.51 $20,793.81 $174,583.49 51.73% City Council $20,121.00 $10,632.94 $4,600.14 $9,488.06 52.84% Elections $470.00 $300.00 $0.00 $170.00 63.83% Planning & Building $71,700.00 $38,460.19 $11,150.60 $33,239.81 53.64% Police $120,989.00 $309.16 $0.00 $120,679.84 0.26% Fire Dept. $271,516.00 $103,572.56 $8,302.69 $167,943.44 38.15% Public Works $1,039,154.00 $551,468.80 $116,885.83 $487,685.20 53.07% Parks & Recreation $62,246.00 $27,748.82 $3,005.42 $34,497.18 44.58% Community Center $39,479.00 $18,080.67 $3,894.39 $21,398.33 45.80% Total GENERAL FUND $1,987,342.00 $937,656.65 $168,632.88 $1,049,685.35 47.18% EDA $5,000.00 $365.00 $20.00 $4,635.00 7.30% DEBT SERVICE BLACKTOP PROJECCT 2007 $140,188.00 $7,593.75 $0.00 $132,594.25 5.42% FIREHALLIPUBLIC WORKS BOND $0.00 $0.00 $0.00 $0.00 0.00% 2010 EQUIPMENT CERTIFICATES $42,080.00 $42,080.00 $710.00 $0.00 100.00% 2011 EQUIPMENT CERTIFICATES $32,310.00 $1,155.00 $0.00 $31,155.00 3.57% 2013 EQUIPMENT CERTIFICATES $66,020.00 $61,055.00 $0.00 $4,965.00 92.48% 2015 EQUIPMENT CERTIFICATES $0.00 $2,000.00 $0.00 -$2,000.00 0.00% Total Debt Service $280,598.00 $113,883.75 $710.00 $173,714.25 CAPITAL IMPROVEMENTS $412,000.00 $0.00 $0.00 $412,000.00 0.00% PARK CAPITAL IMPROVEMENTS $36,000.00 $6,710.08 $1,627.88 $29,289.92 18.64% EQUIPMENT REPLACEMENT $230,000.00 $0.00 $0.00 $230,000.00 0.00% LOCAL ROAD IMPROVEMENT FUND $550,000.00 $61,795.00 $5,534.50 $488,205.00 11.24% 201 SEWER FUND $62,170.00 $27,818.34 $3,336.38 $34,351.66 44.75% UPTOWN SEWER $19,323.00 $6,473.56 $522.31 $12,849.44 33.50% Report Total $3,582,433.00 $1,154,702.38 $180,383.95 $2,427,730.62 32.23% SC,4NDJA. CASH BALANCES 2015 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY 101 GENERAL $1,509,925 $1,542,192 $1,472,561 $1,394,661 $1,112,532 $1,061,983 1,773,440 225 EDA $760 $760 $760 $760 $415 $416 2,896 307 BLACKTOP 2007 $267,037 $267,735 $287,055 $279,461 $279,461 $279,461 352,871 310 FIRE HALUPUBLIC WORKS BOND $19,272 $19,321 $0 $0 $0 $0 0 311 EQUIPMENT CERTIFICATES $9,431 $9,560 $9,560 $9,560 $9,560 $9,560 30,874 312 EQUIPMENT CERTIFICATES $5,085 $5,099 $5,099 $5,099 $3,944 $3,944 20,907 313 EQUIPMENT CERTIFICATES $8,119 $7,684 $7,684 $7,684 $7,684 -$52,936 -18,276 315 EQUIPMENT CERTIFICATES -$2,000 213,000 401 CAPITAL IMPR $297,818 $298,517 $301,157 $301,157 $301,157 $301,157 316,157 404 PARK CAP IMPR $1,055 $1,067 $4,067 $8,117 $7,640 $4,235 2,757 406 EQUIPMENT REPLACEMENT $449,710 $451,023 $451,023 $451,023 $471,023 $471,023 471,023 408 LOCAL ROAD IMPROVEMENT $327,704 $328,137 $328,137 $328,137 $504,307 $471,877 669,871 602 201 SEWER $153,766 $146,838 $153,856 $157,048 $150,969 $156,617 161,906 612 UPTOWN SEWER $941 $1,417 -$1,962 $784 -$329 -$1,317 2,229 801 ESCROW $193,112 $61,378 $95,205 $94,367 $95,037 $94,512 86,586 TOTAL $3,243,735 $3,140,727 $3,114,224 $3,037,878 $2,943,401 $2,798,533 $4,086,240