Loading...
5.b) Treasurer's Report " ✓ �' �� ��-t J . �.., z � '��C.��DI�. City of Scandia Treasurer's Report July 31, 2012 Beginning Balance 07/O l/2012 $1,849,644.29 Receipts 1,173,102.08 Expenditures $ 66,26523 Payroll 36,648.58 - 102,913.81 Adjustments: Safe Deposit Box + 35.00 State Surcharges -349.50 Ending Balance 07/31/2012 $ 2,919,518.06 Submitted by: Colleen Firkus, Treasurer CITY OF SCANDIA Expenditure Summary July 2012 2012 2012 July 2012 %of YTD Budget YTD Amt MTD Amt YTD Balance Budget GENERALFUND Administration&Finance $305,085.15 $217,465.06 $30,699.42 $87,620.09 71.28% City Council $18,839.00 $8,769.52 $4,384.76 $10,069.48 46.55% Elections $5,370.00 $550.81 $80.81 $4,819.19 10.26% Planning 8�Building $150,061.00 $112,541.36 $7,208.73 $37,519.64 75.00% Police $116,560.00 $309.36 $0.00 $116,250.64 0.27% Fire Dept $294,447.00 $119,763.58 $11,503.13 $174,683.42 40.67% Public Works $798,277.00 $275,075.71 $25,335.11 $523,201.29 34.46% Sewer $0.00 $0.00 $0.00 $0.00 0.00% Parks&Recreation $50,982.00 $26,718.80 $5,786.08 $24,263.20 52.41% Community Center $48,164.00 $23,705.84 $2,558.77 $24,458.16 49.22% Total GENERAL FUND $1,787,785.15 $784,900.04 $87,556.81 $1,002,885.11 43.90% DEBT SERVICE Blacktop Project 2007 $165,850.00 $15,425.00 $0.00 $150,425.00 9.30% Fire HaIl/Public Works Bond $116,675.00 $8,337.50 $0.00 $108,337.50 7.15% Equipment Certificate 2010 $80,425.00 $45,400.00 $2,480.00 $35,025.00 56.45% Total DEBT SERVICE $362,950.00 $66,682.50 $2,480.00 $293,787.50 24.30% 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,91328 $0.00 -$93,913.28 0.00% 201 SEWER FUND $61,360.00 $36,520.00 $11,384.98 $24,840.00 59.52% UPTOWN SEWER $109,584.00 $12,333.74 $1,492.03 $97,250.26 11.26% ReportTotal $2,425,280.15 $1,096,430.56 $102,913.82 $1,328,849.59 45.21°/a ,---_��, t�,;. , -..J' �'i � SCANDI�1 CASH BALANCES 2012 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY 101 GENERAL 1,247,805 1,084,087 995,528 876,014 828,418 683,664 1,468,340 307 BLACKTOP 2007 225,554 225,554 230,373 230,373 214,948 214,948 303,232 310 FIRE HALL/PUBLIC WORKS BOND 177,379 177,379 178,468 178,468 170,130 170,131 230,527 311 EQUIPMENT CERTIFICATES -36 -36 98 98 98 98 39,589 401 CAPITAL IMPR 226,052 226,052 227,405 127,804 127,804 127,804 181,605 403 SANCTUARY RD IMPR 807 807 0 0 0 0 0 404 PARK CAP IMPR 12,848 12,848 12,936 12,936 12,936 12,936 12,936 406 EQUIPMENT REPLACEMENT 345,593 139,827 141,280 141,280 141,280 221,280 221,280 602 201 SEWER 210,096 180,364 192,184 191,885 183,761 188,299 186,794 612 UPTOWN SEWER 0 -52 -90 97,953 92,911 88,746 87,254 801 ESCROW 134,807 134,807 183,752 164,649 164,649 142,214 188,750 TOTAL 2,580,905 2,181,638 2,161,935 2,021,460 1,936,935 1,850,121 2,920,309