Loading...
5.b) Treasurer's Report (June 30, 2012) • �✓ / YJ � . ...... .., . < - -..V.. f"� `...x., ����� City of Scandia Treasurer's Report June 30, 2012 Beginning Balance 06/O1/2012 $1,936,494.27 Receipts 29,623.62 Expenditures $ 93,707.78 Payroll 22,730.82 - 116,438.60 Adjustments: Safe Deposit Box - 35.00 Ending Balance 06/30/2012 $ 1,849,644.29 Submitted by: Colleen Firkus, Treasurer CITY OF SCANDIA Expenditure Summary June 2012 2012 2012 June 2012 %of YTD Budget YTD Amt MTD Amt YTD Balance Budget GENERALFUND Administration 8 Finance $292,764.98 $186,765.64 $21,798.17 $105,999.34 63.79% City Council $18,839.00 $4,384.76 $0.00 $14,454.24 23.27% Elections $5,370.00 $470.00 $0.00 $4,900.00 8.75% Planning S Building $150,061.00 $105,332.63 $25,867.19 $44,728.37 70.19% Police $116,560.00 $309.36 $0.00 $116,250.64 0.27% Fire Dept $294,447.00 $108,260.45 $52,464.13 $186,186.55 36.77% Public Works $798,277.00 $249,740.60 $82,358.85 $548,536.40 31.28% Sewer $0.00 $0.00 $0.00 $0.00 0.00% Parks S Recreation $50,982.00 $20,932.72 $3,012.19 $30,04928 41.06% Community Center $48,164.00 $21,147.07 $4,719.72 $27,016.93 43.91% Total GENERAL FUND $1,775,464.98 $697,343.23 $190,220.25 $1,078,121.75 39.28% DEBT SERVICE Blacktop Project 2007 $165,850.00 $15,425.00 $15,425.00 $150,425.00 9.30% Fire Hall/Public Works Bond $116,675.00 $8,337.50 $8,337.50 $108,337.50 7.15% Equipment Certificates $80,425.00 $42,920.00 $0.00 $37,505.00 53.37% Total DEBT SERVICE $362,950.00 $66,682.50 $23,762.50 $296,267.5 23.27°/a CAPITAL IMPROVEMENTS $99,601.00 $99,601.00 $0.00 $0.000 100.00°/a PARK CAPITAL IMPROVEMENTS $4,000.00 $0.00 $0.00 $4,000.00 0.00% EQUIPMENT REPLACEMENT $0.00 $93,913.28 -$111,852.00 -$93,913.28 0.00 SEWER FUND $61,360.00 $25,135.02 $6,573.22 $36,224.98 40.96% UPTOWN SEWER $109,584.00 $10,841.71 $4,164.14 $98,742.29 9.89% ReportTotal $2,412,959.98 $993,516.74 $200,957.61 $1,419,443.24 41.17% , � 4 ' ' I`tiTTi)IA CASH BALANCES 2012 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE 101 GENERAL 1,247,805 1,084,087 995,528 876,014 828,418 683,664 307 BLACKTOP 2007 225,554 225,554 230,373 230,373 214,948 214,948 310 FIRE HALUPUBLIC WORKS BOND 177,379 177,379 178,468 178,468 170,130 170,131 311 EQUIPMENT CERTIFICATES -36 -36 98 98 98 98 401 CAPITAL IMPR 226,052 226,052 227,405 127,804 127,804 127,804 403 SANCTUARY RD IMPR 807 807 0 0 0 404 PARK CAP IMPR 12,848 12,848 12,936 12,936 12,936 12,936 406 EQUIPMENT REPLACEMENT 345,593 139,827 141,280 141,280 141,280 221,280 602 201 SEWER 210,096 180,364 192,184 191,885 183,761 188,299 612 UPTOWN SEWER 0 -52 -90 97,953 92,911 88,746 801 ESCROW 134,807 134,807 183,752 164,649 164,649 142,214 TOTAL 2,580,905 2,181,638 2,161,935 2,021,460 1,936,935 1,850,121