Loading...
5.b) Treasurer's ReportCANDIA Beginning Balance 01/01/2014 Receipts Expenditures Payroll Adjustments: Sales & Use Tax Ending Balance 01/31/2014 City of Scandia Treasurer's Report January 31, 2014 $ 218,837.28 $ 28.794.65 $ 3,134,673.39 $ 112,650.34 -$247,631.93 -$32.00 $ 2,999,659.80 ********************************************************* Ending Balance includes the following Investments: Money Market - Rate .25% Savings *3110 — Rate .05% CD *3134 — Rate .50%, 18 mo., 2/05/14 CD *3136 — Rate .50%, 24 mo., 3/21/2015 CD *3137 — Rate .40% 18 mo., 7/21/2015 Submitted by: Colleen Firkus, Treasurer $ 2,215,927.41 $ 5,005.23 (Childers Credit) $ 124,270.35 (Quinnell) $ 301,131.56 $ 313,367.99 CITY OF SCANDIA Expenditure Summary January 2014 Total GENERAL FUND $1,938,999.00 $299,851.14 $299,851.14 $1,639,147.86 15.46% DEBT SERVICE BLACKTOP PROJECT 2007 2014 2014 January 2014 % of YTD FIREHALL/PUBLIC WORKS BOND YTD Budget YTD Amt MTD Amt YTD Balance Budget GENERALFUND $43,330.00 $41,960.00 $41,960.00 $1,370.00 96.84% Administration & Finance $344,543.00 $32,429.07 $32,429.07 $312,113.93 9.41% City Council $18,839.00 $4,486.01 $4,486.01 $14,352.99 23.81% Elections $6,110.00 $0.00 $0.00 $6,110.00 0.00% Planning & Building $166,200.00 $15,679.44 $15,679.44 $150,520.56 9.43% Police $122,068.00 $60,823.74 $60,823.74 $61,244.26 49.83% Fire Dept $309,404.00 $67,815.36 $67,815.36 $241,588.64 21.92% Public Works $876,097.00 $109,264.49 $109,264.49 $766,832.51 12.47% Sewer $0.00 $0.00 $0.00 $0.00 0.00% Parks & Recreation $56,031.00 $6,916.57 $6,916.57 $49,114.43 12.34% Community Center $39,707.00 $2,436.46 $2,436.46 $37,270.54 6.14% Total GENERAL FUND $1,938,999.00 $299,851.14 $299,851.14 $1,639,147.86 15.46% DEBT SERVICE BLACKTOP PROJECT 2007 $150,388.00 $0.00 $0.00 $150,388.00 0.00% FIREHALL/PUBLIC WORKS BOND $41,640.00 $0.00 $0.00 $41,640.00 0.00% 2010 EQUIPMENT CERTIFICATES $43,330.00 $41,960.00 $41,960.00 $1,370.00 96.84% 2011 EQUIPMENT CERTIFICATES $33,300.00 $0.00 $0.00 $33,300.00 0.00% 2013 EQUIPMENT CERTIFICATES $66,460.00 $0.00 $0.00 $66,460.00 0.00% Total Debt Service $335,118.00 $41,960.00 $41.960.00 $293,158.00 12.49% CAPITAL IMPROVEMENTS $68,250.00 $1,100.00 $1,100.00 $67,150.00 1.61% PARK CAPITAL IMPROVEMENTS $47,500.00 $0.00 $0.00 $47,500.00 0.00% EQUIPMENT REPLACEMENT $200,000.00 $0.00 $0.00 $200,000.00 0.00% 201 SEWER FUND $172,096.00 $3,273.49 $3,273.49 $168,822.51 1.90% UPTOWN SEWER $20,680.00 $1,447.30 $1,447.30 $19,232.70 7.00% Report Total $2,782,643 $347,631.93 $347,631.93 $2,435,011.07 12.49% SCANDIA CASH BALANCES 2014 END OF MONTH FUND JANUARY 101 GENERAL $1,470,985 307 BLACKTOP 2007 $252,830 310 FIRE HALUPUBLIC WORKS BOND $12,367 311 EQUIPMENT CERTIFICATES $2,370 312 EQUIPMENT CERTIFICATES $3.810 313 EQUIPMENT CERTIFICATES $10,825 401 CAPITAL IMPR $229,882 404 PARK CAP IMPR $7,956 406 EQUIPMENT REPLACEMENT $643,815 408 LOCAL ROAD IMPROVEMENT $0 602 201 SEWER $180,286 612 UPTOWN SEWER -$595 801 ESCROW $211,708 TOTAL $3,004,588