Loading...
5.b) Treasurer's Report (May 31, 2012) J L /^ J J� � ' `�:� ` t SC�TDI� City of Scandia Treasurer's Report May 31, 2012 Beginning Balance OS/O1/2012 $2,021,079.47 Receipts 43,322.80 Expenditures $ 106,755.55 Payroll 21,092.45 - 127,848.00 Adjustments: Quarterly Bldg Permit Surcharge payment adj. - 60.00 Ending Balance OS/31/2012 $ 1,936,494.27 Submitted by: Colleen Firkus, Treasurer � ,^Lr' -1. '; �n , 9 � ��7 T- � . S�111�1�lt� CASH BALANCES 2012 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY 101 GENERAL 1,247,805 1,084,087 995,528 876,014 828,418 307 BLACKTOP 2007 225,554 225,554 230,373 230,373 214,948 310 FIRE HALL/PUBLIC WORKS BOND 177,379 177,379 178,468 178,468 170,130 311 EQUIPMENT CERTIFICATES -36 -36 98 98 98 401 CAPITAL IMPR 226,052 226,052 227,405 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 406 EQUIPMENT REPLACEMENT 345,593 139,827 141,280 141,280 141,280 602 201 SEWER 210,096 180,364 192,184 191,885 183,761 612 UPTOWN SEWER 0 -52 -90 97,953 92,911 801 ESCROW 134,807 134,807 183,752 164,649 164,649 TOTAL 2,580,905 2,181,638 2,161,935 2,021,460 1,936,935 , CITY OF SCANDIA Expenditure Summary May 2012 2012 2012 May 2012 %of YTD Budget YTD Amt MTD Amt YTD Balance Budget GENERALFUND Administration& Finance $280,444.81 $164,967.47 $36,926.18 $115,477.34 58.82% 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 8 Building $150,061.00 $79,465.44 $17,229.10 $70,595.56 52.96% Police $116,560.00 $309.36 $0.00 $116,250.64 0.27% Fire Dept $294,447.00 $55,796.32 $12,045.02 $238,650.68 18.95% Public Works $798,277.00 $167,381.75 $18,501.98 $630,895.25 20.97% Sewer $0.00 $0.00 $0.00 $0.00 0.00% Parks& Recreation $50,982.00 $17,920.53 $3,103.23 $33,061.47 35.15% CommunityCenter $48,164.00 $16,427.35 $2,290.06 $31,736.65 34.11% Total GENERAL FUND $1,763,144.81 $507,122.98 $90,095.57 $1,256,021.83 28.76% 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 a296,267.5 23.27% CAPITAL IMPROVEMENTS $99,601.00 $99,601.00 $0.00 $0.000 100.00% 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 $18,561.80 $8,947.54 $42,798.20 30.25% UPTOWN SEWER $109,584.00 $6,677.57 $5,042.38 $102,906.43 6.09% Report Total $2,400,639.81 $792,559.13 $127,84T.99 $1,608,080.68 33.01%