Loading...
5.b) Treasurer's Report . J; 6 �, G►^�'T� ���.t � v��.�_»f� � . .. . _ City of Scandia � Treasurer's Repoi-t � I May 31, 2009 � Beginning Balance OS/O l/09 1,060,779.17 p Receipts ]7,149.l 1 � Expenditures 79,710.01 � Payroll 18.658.36 - 98,368.37 p Adjustments: � Ending Balance OS/31/09 979,559.91 I Submitted by: Colleen Firkus, Treast►rer � CITY OF SCANDIA *Expenditure Guideline Summary Current Period: May 2009 YTD YTD MTD Enc °/a Description Budget Amount Amount Current Balance of Budget Fund 101 GENERAL FUND Dept 41000 Administration 8 Finance $347,719 00 $151,512.42 $33,189.47 $0.00 $196,206.58 43.57% Dept 41110 City Council $19,883.00 $5,397 26 $250.00 $0.00 $14,485.74 27.15% Dept 41410 Elections $495.00 $470 00 $0 00 $0.00 $25.00 94.95°/a Dept 41910 Planning 8 Building $200,327 00 $48,617 77 $17,06670 $0.00 $151,709 23 24.27% Dept 42100 Police $117,366 00 $0 38 $0.00 $0 00 $117,365.62 0.00% Dept 42200 Fire Dept $353,145 00 $54,694.80 -$23,179.01 $0.00 $298,450 20 15.49% Dept 43000 Public Works $586,271.00 $103,049 37 $23,073.33 $0.00 $483,221.63 17 58% Dept 43210 Sewer&Water $27,330.00 $5,182 67 $3,086.98 $0.00 $22,147 33 18.96% Dept 45000 Parks&Recreation $67,445.00 $24,647.18 $8,435.44 $0.00 $42,797.82 36.54% Dept45180 Community Center $56,651.00 $15,212 00 $3,040.17 $0.00 $41,439.00 26.85% Fund 101 GENERAL FUND $1,776,632.00 $408,783.85 $64,963.08 $0.00 $1,367,848.15 23.01% Fund 304 BLACKTOP PROJECT 2004 $247,920.00 $3,960.00 $0.00 $0.00 $243,960.00 1.60% Fund 307 BLACKTOP PROJECCT 2007 $181,038.00 $23,018.75 $0 00 $0.00 $158,019.25 12.71°/a Fund 310 FIREHALUPUBLIC WORKS BOND $111,140.00 $13,495.00 $0.00 $0.00 $97,645.00 12.14% Fund 401 CAPITAL IMPROVEMENTS $23,000.00 $0 00 $0.00 $0.00 $23,000.00 0.00% Fund 404 PARK ACQUISITION AND DEV $40,000 00 $0 00 $0.00 $0.00 $40,000.00 0.00% Fund 406 EQUIPMENT REPLACEMENT $25,000.00 $OAO $0 00 $0 00 $25,000.00 0.00% Fund 602 201 SEWER FUND $66,329-00 $6,139 44 $2,549 30 $0.00 $60,189.56 9.26% Report Total $2,471,059.00 $455,397.04 $67,512.38 $0.00 $2,015,661.96 18.43% ���� ��:�n:��-��;�. CASH BALANCES 2009 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY I 101 GENERAL 579,977 471,002 323,188 255,164 174,659 � 301 DEBT SERVICE 291,052 291,052 158,459 340,201 339,061 � 401 CAPITAL IMPR 2o5,2so 2o5,zao zo7,37� 2i2,�ao 2i2,iao � 402 ROAD CONSTRUCTION 5i,662 51,662 �97,07� 0 0 � 403 SANCTUARY RD IMPR -�9,925 -19,926 -19,925 -19,925 -19,926 � 404 PARK CAP IMPR 34,681 34,681 34,681 35,579 35,579 A 406 EQUIPMENT REPLACEMENT a9,o77 a9,o77 a9,o7� 50,0�7 50,0�7 � 602 201 SEWER 117,599 110,023 118,805 126,716 126,002 ( 801 ESCROW a8,777 a6,777 62,027 62,027 62,027 � TOTAL 1,358,180 1,239,629 1,130,754 1,061,920 979,560 p� . CITY OF SCANDIA 06/05/09 5 05 PM �� ,�4, Page 1 # Cash Balances w � �� �.����� � R � Current Period: May 2009 MTD MTD Current 1 FUND Descr Account Debit Credit Balance � Cash � GENERAL FUND G 101-10100 $15,484.46 $95,989.07 $174,659.20 � DEBT SERVICE G 301-10100 $0.00 $0.00 $0.00 � BLACKTOP PROJECT 2002 G 302-10100 $0.00 $0.00 -$0.50 � BLACKTOP PROJECT 2004 G 304-10100 $0.00 $0 00 $162,685.43 � BLACKTOP PROJECCT 2007 G 307-10100 $0.00 $1,140 00 $22,304.56 � FIREHALL/PUBIIC WORKS BOND G 310-10100 $0.00 $0 00 $154,071.67 � CAPITAL IMPROVEMENTS G 401-10100 $0.00 $0.00 $212,140.26 � ROAD CONSTRUCTION G 402-10100 $0.00 $0 00 $0.00 � SANCTUARY G 403-10100 $0.00 $0 00 -$19,925.50 � PARK ACQUISITION AND DEV G 404-10100 $0.00 $0 00 $35,579.48 � EQUIPMENT REPLACEMENT G 406-10100 $0.00 $0.00 $50,016.64 � 201 SEWER FUND G 602-10100 $1,834.65 $2,549.30 $126,001.77 � ESCROW G 801-10100 $0.00 $0.00 $62,027.00 � Total Cash $17,319.11 $99,678 37 $979,560.01 � INVESTMENT IN ESCROW 1 BLACKTOP PROJECT 2004 G 304-10200 $0.00 $0 00 $0.00 1 Total INVESTMENT IN ESCROW $0.00 $0 00 $0.00 � Investments 1 GENERAL FUND G 101-10400 $0.00 $0.00 $0.00 � Total Investments $0.00 $0 00 $0.00 � Misc Receivables 1 GENERAL FUND G 101-10425 $0.00 $0.00 $0.00 � DEBT SERVICE G 301-10A25 $0.00 $0.00 $0.00 I BLACKTOP PROJECT 2002 G 302-10425 $0.00 $0.00 $0.00 � BLACKTOP PROJECT 2004 G 304-10425 $0.00 $0.00 $0.00 1 BLACKTOP PROJECCT 2007 G 307-10425 $0.00 $0.00 $0.00 1 FIREHALL/PUBLIC WORKS BOND G 310-10425 $0.00 $0.00 $0.00 I ROAD CONSTRUCTION G 402-10425 $0 00 $0 00 $0 00 1 SANCTUARY G 403-10425 $0.00 $0 00 $0.00 1 PARK ACQUISITION AND DEV G 404-10425 $0.00 $0.00 $0.00 1 201 SEWER FUND G 602-10425 $0.00 $0.00 $0.00 1 Total Misc Receivables $0.00 $0.00 $0.00 � ACCRUED INTEREST RECEIVABLE 1 GENERAL FUND G 101-10430 $0.00 $0 00 $0 00 1 BLACKTOP PROJECCT 2007 G 307-10430 $0.00 $0.00 $0.00 I FIREHALL/PUBLIC WORKS BOND G 310-10430 $0 00 $0 00 $0 00 1 ROAD CONSTRUCTION G 402-10430 $0.00 $0 00 $0.00 1 SANCTUARY G 403-10430 $0.00 $0 00 $0.00 1 Total ACCRUED INTEREST RECEIVABLE $0 00 $0.00 $0.00 1 Interest Receivable on Invest 1 GENERAL FUND G 101-10450 $0.00 $0 00 $0.00 I Total Interest Receivable on Invest $0.00 $0 00 $0.00 I