Loading...
5.b) Treasurer's Report . . � �� �-} . �� _�:�� �+�ANDIA City of Scandia Treasurer's Report October 31, 2012 Beginning Balance 10/O1/2012 $2,424,002.90 Receipts 39,101.56 Expenditures $ 151,676.73 Payroll 32,512.60 - 184,189.33 Adjustments: Safe Deposit Box - 35.00 Ending Balance 10/31/2012 $ 2,278,880.13 Submitted by: Colleen Firkus, Treasurer . . SCANDIA MN , Expenditure Summary October 2012 2012 2012 October 2012 %of YTD Budget YTD Amt MTD Amt YTD Balance Budget GENERALFUND Administration& Finance $342,045.66 $330,532.58 $53,570.38 $11,513.08 96.63% City Council $18,839.00 $13,154.28 $4,384.76 $5,684.72 69.82% Elections $5,370.00 $3,265.78 $0.00 $2,104.22 60.82% Planning 8�Building $150,061.00 $233,527.13 $11,330.78 -$83,466.13 155.62% Police $116,560.00 $56,371.79 $0.00 $60,188.21 48.36% Fire Dept $294,447.00 $188,827.14 $21,471.22 $105,619.86 64.13% Public Works $798,101.00 $631,877.45 $79,776.91 $166,223.55 79.17% Sewer $0.00 $13.56 $0.21 -$13.56 0.00% Parks 8 Recreation $50,982.00 $40,160.88 $2,139.16 $10,821.12 78.77% Community Center $48,164.00 $34,675.48 $2,436.84 $13,488.52 71.99% Total GENERAL FUND $1,824,569.66 $1,532,406.07 $175,110.26 $292,163.59 83.99% 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 $0.00 $35,025.00 56.45% Total DEBT SERVICE $362,950.00 $66,682.50 $0.00 $293,787.50 24.30% CAPITAL IMPROVEMENTS $99,601.00 $99,601.00 $0.00 $0.00 100.00% PARK CAPITAL IMPROVEMENTS $4,000.00 $0.00 $0.00 $4,000.00 0.00% EQUIPMENT REPLACEMENT $0.00 $93,913.28 $0.00 -$93,913.28 0.00% 201 SEWER FUND $61,360.00 $68,174.34 $6,293.55 -$6,814.34 111.11% UPTOWN SEWER $109,584.00 $35,926.34 $2,802.27 $73,657.66 32.78% Report Total $2,462,064.66 $1,899,183.53 $184,206.08 $562,881.13 77.14°/a \ l . '`?1..�.��.f��.. � �CANDIA ', �.� CASH BALANCES 2012 =ND OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER 101 GENERAL $1,247,805 $1,084,087 $995,528 $876,014 $828,418 $683,664 $1,468,340 $1,032,040 $925,297 775,270 307 BLACKTOP 2007 $225,554 $225,554 $230,373 $230,373 $214,948 $214,948 $303,232 $303,232 $303,232 304,920 310 FIRE HALUPUBLIC WORKS BOND $177,379 $177,379 $178,468 $178,468 $170,130 $170,131 $230,527 $230,527 $230,527 230,527 311 EQUIPMENT CERTIFICATES -$36 -$36 $98 $98 $98 $98 $39,589 $39,589 $39,589 39,589 401 CAPITAL IMPR $226,052 $226,052 $227,405 $127,804 $127,804 $127,804 $181,605 $181,605 $181,605 181,605 403 SANCTUARY RD IMPR $807 $807 $0 $0 $0 $0 $0 $0 $0 0 404 PARK CAP IMPR $12,848 $12,848 $12,936 $12,936 $12,936 $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 $221,280 $221,280 221,280 602201 SEWER $210,096 $180,364 $192,184 $191,885 $183,761 $188,299 $186,794 $166,651 $171,673 172,028 612 UPTOWN SEWER $0 -$52 -$90 $97,953 $92,911 $88,746 $87,254 $89,937 $73,578 70,876 801 ESCROW $134,807 $134,807 $183,752 $164,649 $164,649 $142,214 $188,750 $189,725 $264,725 270,325 TOTAL 52,580,905 $2,181,638 $2,161,935 $2,021,460 $1,936,935 $1,850,121 52,920,309 $2,467,523 52,424,444 2,279,356