Loading...
5.b) Treasurer's Report�CANDIA Beginning Balance 02/01/2014 Receipts Expenditures Payroll City of Scandia Treasurer's Report February 28, 2014 $ 141,987.52 $ 24,571.54 Adjustments: Sales & Use Tax adj. Ending Balance 02/28/2014 $ 2,999,659.80 $ 16,633.78 -$166,559.06 +$32.00 $ 2,849,766.52 ********************************************************* Ending Balance includes the following Investments: Money Market - Rate .25% Savings *3110 — Rate .05% CD *3134 — Rate .50%, 18 mo., 8/05/2015 CD *3136 — Rate .50%, 24 mo., 3/21/2015 CD *3137 — Rate .40% 18 mo., 7/21/2015 Submitted by: Colleen Firkus, Treasurer $ 2,094,179.18 $ 5,005.23 (Childers Credit) $ 124,426.96 (Quinnell) $ 301,131.56 $ 313,367.99 GENERALFUND Administration & Finance City Council Elections Planning & Building Police Fire Dept Public Works Sewer Parks & Recreation Community Center Total GENERAL FUND DEBT SERVICE BLACKTOP PROJECT 2007 FIREHALUPUBLIC WORKS BOND 2010 EQUIPMENT CERTIFICATES 2011 EQUIPMENT CERTIFICATES 2013 EQUIPMENT CERTIFICATES Total Debt Service CAPITAL IMPROVEMENTS PARK CAPITAL IMPROVEMENTS EQUIPMENT REPLACEMENT 201 SEWER FUND UPTOWN SEWER CITY OF SCANDIA Expenditure Summary February 2014 2014 2014 February 2014 % of YTD YTD Budget YTD Amt MTD Amt YTD Balance Budget $344,543.00 $57,877.81 $25,448.74 $286,665.19 $18,839.00 $4,486.01 $0.00 $14,352.99 $6,110.00 $0.00 $0.00 $6,110.00 $166,200.00 $14,334.13 -$1,345.31 $151,865.87 $122,068.00 $60,823.74 $0.00 $61,244.26 $309,404.00 $109,271.19 $41,455.83 $200,132.81 $876,097.00 $161,034.71 $51,770.22 $715,062.29 $0.00 $0.00 $0.00 $0.00 $56,031.00 $16,720.88 $9,804.31 $39,310.12 $39,707.00 $7,635.99 $5,199.53 $32,071.01 $1,938,999.00 $432,184.46 $132,333,32$1,506,814.54 $150,388.00 $7,157.35 $0.00 $61,092.65 $0.00 $0.00 $150,388.00 $47,500.00 $41,640.00 $0.00 $0.00 $200,000.00 $0.00 $6,814.03 $41,640.00 $166,281.97 $43,330.00 $2,237.23 $41,960.00 $18,442.77 $0.00 $1,370.00 $33,300.00 $0.00 $0.00 $33,300.00 $66,460.00 $0.00 $0.00 $66,460.00 $335,118.00 $41,960.00 $0.00 $293,158.00 $68,250.00 $7,157.35 $6,057.35 $61,092.65 $47,500.00 $0.00 $0.00 $47,500.00 $200,000.00 $0.00 $0.00 $200,000.00 $173,096.00 $6,814.03 $3,540.54 $166,281.97 $20,680.00 $2,237.23 $789.93 $18,442.77 16.80% 23.81% 0.00% 8.62% 49.83% 35.32% 18.38% 0.00% 29.84% 19.23% 22.29% 0.00% 0.00% 96.84% 0.00% 0.00% 10.49% 0.00% 0.00% 3.94% 10.82% Report Total $2,783,643.00 $490,353.07 $142,721.14 $2,293,289.93 17.62% - j: SCANDIA 2014 CASH BALANCES END OF MONTH FUND JANUARY FEBRUARY 101 GENERAL $1,470,985 $1,332,163 307 BLACKTOP 2007 $252,830 $261,576 310 FIRE HALL/PUBLIC WORKS BOND $12,367 $18,555 311 EQUIPMENT CERTIFICATES $2,370 $4,774 312 EQUIPMENT CERTIFICATES $3,810 $5,520 313 EQUIPMENT CERTIFICATES -$10,825 -$10,825 401 CAPITAL IMPR $229,882 $224,526 404 PARK CAP IMPR $7,956 $7,984 406 EQUIPMENT REPLACEMENT $643,815 $644,474 408 LOCAL ROAD IMPROVEMENT $0 $0 602 201 SEWER $180,286 $177,762 612 UPTOWN SEWER -$595 -$1,384 801 ESCROW $211,708 $188,920 TOTAL $3,004,588 $2,854,045