Loading...
5.b) March Treasurer's ReportSCANDIA Beginning Balance 03/01/2014 Receipts Expenditures Payroll Adjustments: Ending Balance 3/31/2014 City of Scandia Treasurer's Report March 31, 2014 $ 2,849,766.52 $ 24,858.86 $ 100,318.05 $ 25,581.22 -$125,899.27 $ 2,748,726.11 ********************************************************* 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,732,491.17 $ 5,005.86 (Childers Credit) $ 124,426.96 (Quinnell) $ 301,502.82 $ 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 FIREHALLIPUBLIC WORKS BOND 2010 EQUIPMENT CERTIFICATES 2011 EQUIPMENT CERTIFICATES 2013 EQUIPMENT CERTIFICATES Total Debt Service CITY OF SCANDIA Expenditure Summary March 2014 2014 2014 March 2014 % of YTD YTD Budget YTD Amt MTD Amt YTD Balance Budget $344,543.00 $65,939.32 $8,061.51 $278,603.68 $18,839.00 $207.01 -$4,279.00 $18,631.99 $6,110.00 $470.00 $470.00 $5,640.00 $166,200.00 $2,335.64 -$11,998.49 $163,864.36 $122,068.00 $309.74 -$60,514.00 $121,758.26 $309,404.00 $122,140.94 $12,869.75 $187,263.06 $1,076,097.00 $388,900.08 $227,865.37 $687,196.92 $0.00 $0.00 $0.00 $0.00 $56,031.00 $17,577.59 $856.71 $38,453.41 $39,707.00 $8,829.43 $1,193.44 $30,877.57 $2,138,999.00 $606,709.75 $174,525.29 $1,532,289.25 19.14% 1.10% 7.69% 1.41% 0.25% 39.48% 36.14% 0.00% 31.37% 22.24% 28.36% $150,388.00 $68,250.00 $0.00 -$345.00 $0.00 9.98% $150,388.00 $47,500.00 0.00% $41,640.00 $47,500.00 $0.00 EQUIPMENT REPLACEMENT $0.00 $0.00 $41,640.00 $200,000.00 0.00% $43,330.00 $173,096.00 $41,960.00 $2,652.38 $0.00 5.47% $1,370.00 $20,680.00 96.84% $33,300.00 $17,459.23 $0.00 $0.00 $33,300.00 0.00% $66,460.00 $0.00 $0.00 $66,460.00 0.00% $335,118.00 $41,960.00 $0.00 $293,158.00 CAPITAL IMPROVEMENTS $68,250.00 $6,812.35 -$345.00 $61,437.65 9.98% 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 $173,096.00 $9,466.41 $2,652.38 $163,629.59 5.47% UPTOWN SEWER $20,680.00 $3,220.77 $983.54 $17,459.23 15.57% Report Total $2,983,643.00 $668,169.28 $177,816.21 $2,315,473.72 22.39% SCANDIAl CASH BALANCES 2014 END OF MONTH FUND JANUARY FEBRUARY MARCH 101 GENERAL $1,470,985 $1,332,163 $1,030,717 307 BLACKTOP 2007 $252,830 $261,576 $261,576 310 FIRE HALL/PUBLIC WORKS BOND $12,367 $18,555 $18,555 311 EQUIPMENT CERTIFICATES $2,370 $4,774 $6,874 312 EQUIPMENT CERTIFICATES $3,810 $5,520 $3,420 313 EQUIPMENT CERTIFICATES -$10,825 -$10,825 $5,291 401 CAPITAL IMPR $229,882 $224,526 $223,771 404 PARK CAP IMPR $7,956 $7,984 $7,984 406 EQUIPMENT REPLACEMENT $643,815 $644,474 $628,358 408 LOCAL ROAD IMPROVEMENT $0 $0 $200,000 602 201 SEWER $180,286 $177,762 $185,889 612 UPTOWN SEWER -$595 -$1,384 -$4,975 801 ESCROW $211,708 $188,920 $181,268 TOTAL $3,004,588 $2,854,045 $2,748,726