Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.b) Treasurer's Report
DIA Beginning Balance 05/01/2015 Receipts Expenditures Payroll City of Scandia Treasurer's Report May 31, 2015 $ 86,137.49 $ 24,025.23 $ 3,038,877.89 $ 15,685.44 -$110,162.72 Adjustments: April HSA -1,000.00 Jahnke HSA part. Fee 1.00 Ending Balance 05/31/2015 $ 2,943,401.61 ************************************************************************ Ending Balance includes the following Investments: Money Market - Rate .25% CD *3136 — Rate .90%, 24 mo., 3/21/2017 CD *3137 — Rate .40% 18 mo., 7/21/2015 Total Undesignated Investments Quinnell CD *3134 — Rate .40%, 18 mo., 8/05/2015 Scandia EDA *6301 Childers Credit, Savings *3110 — Rate .05% Total Designated Investments Submitted by: Colleen Firkus, Treasurer $ 2,115,742.97 $ 303,013.17 $ 314,933.66 $ 2,733,689.80 $ 125,046.74 $ 415.47 $ 5,009.73 $ 130,489.94 CITY OF SCANDIA Expenditure Summary May 2015 Total GENERAL FUND $1,987,342.00 $686,918.03 $294,933.24 $1,300,423.97 34.56% EDA $5,000.00 $345.00 $345.00 $4,655.00 6.90% DEBT SERVICE BLACKTOP PROJECCT 2007 2015 2015 May 2015 % of YTD FIREHALL/PUBLIC WORKS BOND YTD Budget YTD Amt MTD Amt YTD Balance Budget GENERALFUND $42,080.00 $41,370.00 $0.00 $710.00 98.31% Administration & Finance $361,667.00 $137,189.33 $21,505.78 $224,477.67 37.93% City Council $20,121.00 $6,032.80 $0.00 $14,088.20 29.98% Elections $470.00 $300.00 $0.00 $170.00 63.83% Planning & Building $71,700.00 $19,643.26 $4,616.94 $52,056.74 27.40% Police $120,989.00 $309.16 $0.00 $120,679.84 0.26% Fire Dept. $271,516.00 $83,775.96 $23,468.29 $187,740.04 30.85% Public Works $1,039,154.00 $405,946.20 $241,574.51 $633,207.80 39.07% Parks & Recreation $62,246.00 $21,531.23 $1,515.22 $40,714.77 34.59% Community Center $39,479.00 $12,190.09 $2,252.50 $27,288.91 30.88% Total GENERAL FUND $1,987,342.00 $686,918.03 $294,933.24 $1,300,423.97 34.56% EDA $5,000.00 $345.00 $345.00 $4,655.00 6.90% DEBT SERVICE BLACKTOP PROJECCT 2007 $140,188.00 $7,593.75 $0.00 $132,594.25 5.42% 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 $1,155.00 $1,155.00 $31,155.00 3.57% 2013 EQUIPMENT CERTIFICATES $66,020.00 $435.00 $0.00 $65,585.00 0.66% Total Debt Service $280,598.00 $50,553.75 $1,155.00 $230,044.25 CAPITAL IMPROVEMENTS $412,000.00 $0.00 $0.00 $412,000.00 0.00% PARK CAPITAL IMPROVEMENTS $36,000.00 $1,677.20 $1,677.20 $34,322.80 4.66% EQUIPMENT REPLACEMENT $230,000.00 $0.00 $0.00 $230,000.00 0.00% LOCAL ROAD IMPROVEMENT FUND $550,000.00 $23,830.00 $23,830.00 $526,170.00 4.33% 201 SEWER FUND $62,170.00 $20,680.93 $6,434.50 $41,489.07 33.27% UPTOWN SEWER $19,323.00 $4,962.95 $1,462.78 $14,360.05 25.68% Report Total $3,582,433.00 $788,967.86 $329,837.72 $2,793,465.14 22.02% SC 1N DI 1 CASH BALANCES 2015 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL MAY 101 GENERAL $1,509,925 $1,542,192 $1,472,581 $1,394,661 $1,112,532 225 EDA $760 $760 $760 $760 $415 307 BLACKTOP 2007 $267,037 $267,735 $287,055 $279,461 $279,461 310 FIRE HALUPUBLIC WORKS BOND $19,272 $19,321 $0 $0 $0 311 EQUIPMENT CERTIFICATES $9,431 $9,560 $9,560 $9,560 $9,560 312 EQUIPMENT CERTIFICATES $5,085 $5,099 $5,099 $5,099 $3,944 313 EQUIPMENT CERTIFICATES $8,119 $7,684 $7,684 $7,684 $7,684 401 CAPITAL IMPR $297,818 $298,517 $301,157 $301,157 $301,157 404 PARK CAP IMPR $1,055 $1,067 $4,067 $8,117 $7,640 406 EQUIPMENT REPLACEMENT $449,710 $451,023 $451,023 $451,023 $471,023 408 LOCAL ROAD IMPROVEMENT $327,704 $328,137 $328,137 $328,137 $504,307 602 201 SEWER $153,766 $146,838 $153,856 $157,048 $150,969 612 UPTOWN SEWER $941 $1,417 -$1,962 $784 -$329 801 ESCROW $193,112 $61,378 $95,205 $94,387 $95,037 TOTAL $3,243,735 $3,140,727 $3,114,224 $3,037,878 $2,943,401