Loading...
5.b) Treasurer's Report���CANDIA Beginning Balance 03/01/2015 Receipts Expenditures Payroll City of Scandia Treasurer's Report March 31, 2015 $ 65.518.98 $ 25,631.95 $ 3,140,727.23 $ 64.646.85 -$ 91,150.93 Adjustments: Select Acct. draw delayed $ 1,000.00 Savings Interest .63 Adjusting JE .43 Ending Balance 03/31/2015 $ 3,115,224.21 ************************************************************************ Ending Balance includes the following Investments: Money Market - Rate .25% $ 2,357,157.41 CD *3136 — Rate .90%, 24 mo., 3/21/2017 $ 303,013.17 CD *3137 — Rate .40% 18 mo., 7/21/2015 $ 314.623.35 Total Undesignated Investments $ 2,974,793.93 Quinnell CD *3134 — Rate .40%,18 mo., 8/05/2015 $ 124,924.90 Scandia EDA *6301 $ 760.47 Childers Credit, Savings *3110 —Rate .05% $ 5.009.73 Total Designated Investments $ 130,695.10 Submitted by: Colleen Firkus, Treasurer CITY OF SCANDIA Expenditure Summary March 2015 Total GENERAL FUND $1,987,342.00 $272,378.06 -$57,955.32 $1,714,963.94 13.71% EDA 2015 2015 March 2015 % of YTD DEBT SERVICE YTD Budget YTD Amt MTD Amt YTD Balance Budget GENERALFUND $140,188.00 $0.00 $0.00 $140,188.00 0.00% Administration & Finance $361,667.00 $73,205.93 $12,911.28 $288,461.07 20.24% City Council $20,121.00 $1,648.04 -$4,385.00 $18,472.96 8.19% Elections $470.00 $300.00 $0.00 $170.00 63.83% Planning & Building $71,700.00 $11,401.59 -$770.12 $60,298.41 15.90% Police $120,989.00 $309.16 -$62,653.00 $120,679.84 0.26% Fire Dept. $271,516.00 $38,474.34 -$5,316.75 $233,041.66 14.17% Public Works $1,039,154.00 $123,056.27 $6,517.14 $916,097.73 11.84% Parks & Recreation $62,246.00 $16,610.62 -$3,147.94 $45,635.38 26.69% Community Center $39,479.00 $7,372.11 -$1,110.93 $32,106.89 18.67% Total GENERAL FUND $1,987,342.00 $272,378.06 -$57,955.32 $1,714,963.94 13.71% EDA $5,000.00 $0.00 $0.00 $5,000.00 0.00% DEBT SERVICE $36,000.00 $0.00 $0.00 $36,000.00 0.00% BLACKTOP PROJECCT 2007 $140,188.00 $0.00 $0.00 $140,188.00 0.00% FIREHALL/PUBLIC WORKS BOND $0.00 $0.00 $0.00 $0.00 0.00% 2010 EQUIPMENT CERTIFICATES $42,080.00 $41,370.00 $0.00 $710.00 98.31% 2011 EQUIPMENT CERTIFICATES $32,310.00 $0.00 $0.00 $32,310.00 0.00% 2013 EQUIPMENT CERTIFICATES $66,020.00 $435.00 $0.00 $65,585.00 0.66% Total Debt Service $280,598.00 $41,805.00 $0.00 $238,793.00 CAPITAL IMPROVEMENTS $412,000.00 $0.00 $0.00 $412,000.00 0.00% PARK CAPITAL IMPROVEMENTS $36,000.00 $0.00 $0.00 $36,000.00 0.00% EQUIPMENT REPLACEMENT $230,000.00 $0.00 $0.00 $230,000.00 0.00% LOCAL ROAD IMPROVEMENT FUND $550,000.00 $0.00 $0.00 $550,000.00 0.00% 201 SEWER FUND $62,170.00 $11,347.33 -$1,137.96 $50,822.67 18.25% UPTOWN SEWER $19,323.00 $2,321.36 -$1,017.57 $17,001.64 12.01% Report Total $3,582,433.00 $327,851.75 -$60,110.85 $3,254,581.25 9.15% SCANDIA 2015 FUND 101 GENERAL 225 EDA 307 BLACKTOP 2007 310 FIRE HALL/PUBLIC WORKS BOND 311 EQUIPMENT CERTIFICATES 312 EQUIPMENT CERTIFICATES 313 EQUIPMENT CERTIFICATES 401 CAPITAL IMPR 404 PARK CAP IMPR 406 EQUIPMENT REPLACEMENT 408 LOCAL ROAD IMPROVEMENT 602 201 SEWER 612 UPTOWN SEWER 801 ESCROW TOTAL CASH BALANCES END OF MONTH JANUARY FEBRUARY $1,509,925 $1,542,192 $760 $267,037 $19,272 $9,431 $5,085 $8,119 $297,818 $1,055 $449,710 $327,704 $153,766 $941 $193,112 $3,243,735 $760 $267,735 $19,321 $9,560 $5,099 $7,684 $298,517 $1,067 $451,023 $328,137 $146,838 $1,417 $61,378 $3,140,727 MARCH $1,472,581 $760 $287,055 $0 $9,560 $5,099 $7,684 $301,157 $4,067 $451,023 $328,137 $153,856 -$1,962 $95,205 $3,114,224