Loading...
5.b) Treasurer's Report � � � � r � . _ � :.�_ r�;���. ���TDIA City of Scandia Treasurer's Report July 31, 2011 Beginning Balance 07/Ol/2011 $1,755,879.76 Receipts 1,060,321.05 Expenditures 58,867.44 Payroll 25,864.28 - 84,731.72 Adjustments: June adjustments recorded - 81.52 Ending Balance 07/31/2011 $ 2,731,387.57 Submitted by: Colleen Firkus, Treasurer � � CITY OF SCANDIA Expenditure Summary Current Period: July 2011 2011 2011 July 2011 %of YTD Budget YTD Amt MTD Amt YTD Balance Budget GENERAL FUND Administration&Finance $348,400.00 $200,097.76 $22,357.16 $148,302.24 57.43% City Council $20,289.00 $15,499.40 $4,384.76 $4,789.60 76.39% Elections $470.00 $470.00 $0.00 $0.00 100.00% Planning&Building $332,808.00 $80,476.90 $10,759.66 $252,331.10 24.18% Police $123,307.00 $59,050.65 $0.00 $64,256.35 47.89% Fire Dept $343,186.00 $171,461.55 $64,256.88 $171,724.45 49.96% Public Works $665,697.00 $243,101.22 $75,053.42 $422,595.78 36.52% Sewer $23,042.00 $7,365.67 $349.00 $15,676.33 31.97% Parks&Recreation $55,882.00 $31,326.28 $6,917.18 $24,555.72 56.06% Community Center $53,864.00 $25,439.42 $7,598.76 $28,424.58 47.23% TOt81 GENERAL FUND 51�966�945.00 $834�288.85 $191�676.82 $1�132�656.15 42.42% DEBT SERVICE Blacktop Project2007 $170,980.00 $17,990.00 $0.00 $152,990.00 10.52% Fire Hall/Public Works Bond $115,143.00 $10,071.25 $0.00 $105,071.75 8.75% Equipment Certificates $40,000.00 $2,500.00 $2,500.00 $37,500.00 6.25% Totel DEBT SERVICE $326,123.00 $30,561.25 a2,500.00 $295,5461.75 8.51% CAPITAL IMPROVEMENTS $18,000.00 $20,173.12 $0.00 -$2,173.12 112.07% PARK CAPITAL IMPROVEMENTS $14,300.00 $5,478.50 $0.00 $8,821.50 38.31% EQUIPMENT REPLACEMENT $238,476.00 $36,975.64 $0.00 $201,500.36 15.50% 201 SEWER FUND $63,508.00 $20,025.64 $3,874.90 $43,482.36 31.53% ReportTotal $2,627,352.00 $947,503.00 $198,051.72 $1,679,849.00 36.06% !�"' ������ CASH BALANCES 2011 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY 101 GENERAL 1,123,598 1,034,272 878,858 806,914 787,142 711,070 1,359,978 307 BLACKTOP 2007 185,677 185,677 186,855 186,855 168,865 168,865 272,719 310 FIRE HALL/PUBLIC WORKS BOND 170,240 170,240 171,621 171,621 161,550 161,550 222,000 311 EQUIPMENT CERTIFICATES 23,242 401 CAPITAL IMPR 186,438 185,892 187,552 187,552 187,552 187,552 206,802 403 SANCTUARY RD IMPR 807 807 807 807 807 807 807 , 404 PARK CAP IMPR 15,182 15,182 15,327 14,810 13,701 9,848 9,848 406 EQUIPMENT REPLACEMENT 120,010 96,843 89,217 89,217 83,651 235,593 345,593 602 201 SEWER 186,552 177,689 185,040 190,438 187,767 191,051 201,012 801 ESCROW 58,212 62,537 43,468 93,428 92,139 89,462 89,387 TOTAL 2,046,717 1,929,140 1,758,745 1,741,642 1,683,175 1,755,799 2,731,388