Loading...
5.b) Treasurer's Report . � �. �) .-, � � ,_ ,�;-� � � �CANDIA City of Scandia Treasurer's Report November 30, 2012 Beginning Balance 11/O1/2012 $2,278,880.13 Receipts 17,382.45 Expenditures $ 1506474.59 Payroll 20,359.66 - 526,834.25 Adjustments: Safe Deposit Box 35.00 Ending Balance 11/30/2012 $ 1,769,463.33 Submitted by: Colleen Firkus, Treasurer SCANDIA, MN Expenditure Summary November 2012 2012 2012 November 2012 %of YTD Budget YTD Amt MTD Amt YTD Balance Budget GENERAL FUND Administration 8 Finance $366,686.00 $355,356.14 $24,823.56 $7,309.69 96.91% City Council $18,839.00 $13,15428 $0.00 $4,684.72 73.74% Elections $5,370.00 $6,034.71 $2,768.93 -$664.71 112.38% Planning&Building $150,061.00 $248,385.33 $14,858.20 -$98,324.33 165.52% Police $116,560.00 $56,371.79 $0.00 $60,188.21 48.36% Fire Dept $294,447.00 $198,054.07 $9,226.93 $96,392.93 67.26% Public Works $798,101.00 $668,194.09 $36,316.64 $129,906.91 83.72% Parks&Recreation $50,982.00 $43,623.07 $3,462.19 $7,358.93 85.57% Community Center $48,164.00 $37,655.36 $2,979.88 $10,508.64 78.18% Total GENERAL FUND $1,848,210.00 $1,626,842.40 $94,436.33 $217,347.43 88.02% DEBT SERVICE Blacktop Project 2007 $165,850.00 $165,850.00 $150,425.00 $0.00 100.00% Fire Hall/Public Works Bond $116,675.00 $116,675.00 $108,337.50 $0.00 100.00% Equipment Certificate 2010 $80,425.00 $82,532.71 $37,132.71 -$2,107.71 102.62% Total DEBT SERVICE $362,950.00 $365,057.71 E295,895.21 -52,107.71 100.58% CAPITAL IMPROVEMENTS $99,601.00 $99,601.00 $0.00 $0.00 100.00% PARK CAPITAL IMPROVEMENTS $4,000.00 $74.50 $74.50 $3,925.50 1.86% EQUIPMENT REPLACEMENT $0.00 $93,913.28 $0.00 -$93,913.28 0.00% 201 SEWER FUND $61,360.00 $79,166.08 $10,991.74 -$17,806.08 129.02% UPTOWN SEWER $109,584.00 $159,249.04 $123,322.70 -$49,665.04 145.32% Report Total $2,485,705.00 52,423,904.01 5524,720.48 E57,780.82 97.51% �;���,, SCANDIA � CASH BALANCES 2012 =ND OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER 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 796,710 307 BLACKTOP 2007 $225,554 $225,554 $230,373 $230,373 $214,948 $214,948 $303,232 $303,232 $303,232 304,920 154,495 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 122,187 311 EQUIPMENT CERTIFICATES -$36 -$36 $98 $98 $98 $98 $39,589 $39,589 $39,589 39,589 2,457 401 CAPITAL IMPR $226,052 $226,052 $227,405 $127,804 $127,804 $127,804 $181,605 $181,605 $181,605 181,605 181,605 403 SANCTUARY RD IMPR $807 $807 $0 $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 12,862 406 EQUIPMENT REPLACEMENT $345,593 $139,827 $141,280 $141,280 $141,280 $221,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 162,757 612 UPTOWN SEWER $0 -$52 -$90 $97,953 $92,911 $88,746 $87,254 $89,937 $73,578 70,876 -52,447 801 ESCROW $134,807 $134,807 $183,752 $164,649 $164,649 $142,214 $188,750 $189,725 $264,725 270,325 167,996 TOTAL E2,580,905 t2,181,638 52,787,935 52.021,460 57,936,935 5�,850,121 52,920,309 52,467,523 52,424,444 2,279,358 1,769,902