Loading...
5.b) Treasurer's ReportY SAND Beginning Balance 04/01/2015 Receipts Expenditures Payroll Adjustments: Savings Interest City of Scandia Treasurer's Report April 30, 2015 $ 105,210.29 $ 27,040.78 $ 3,115 224.21 $ 55,905.38 -$132,251.07 .63 Ending Balance 04/30/2015 $ 3,038,877.89 ************************************************************************ 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,280,545.86 $ 303,013.17 $ 314,933.66 $ 2,898,492.69 $ 124,924.90 760.47 5,009.73 $ 130,695.10 CITY OF SCANDIA Expenditure Summary April 2015 Total GENERAL FUND $1,987,342.00 $391,984.79 $119,606.73 $1,595,357.21 19.72% EDA $5,000.00 $0.00 $0.00 $5,000.00 0.00% DEBT SERVICE BLACKTOP PROJECCT 2007 2015 2015 April 2015 % of YTD 2010 EQUIPMENT CERTIFICATES YTD Budget YTD Amt MTD Amt YTD Balance Budget GENERALFUND $32,310.00 $0.00 $0.00 $32,310.00 0.00% Administration & Finance $361,667.00 $115,683.55 $42,477.62 $245,983.45 31.99% City Council $20,121.00 $6,032.80 $4,384.76 $14,088.20 29.98% Elections $470.00 $300.00 $0.00 $170.00 63.83% Planning & Building $71,700.00 $15,026.32 $3,624.73 $56,673.68 20.96% Police $120,989.00 $309.16 $0.00 $120,679.84 0.26% Fire Dept. $271,516.00 $60,307.67 $21,833.33 $211,208.33 22.21% Public Works $1,039,154.00 $164,371.69 $41,315.42 $874,782.31 15.82% Parks & Recreation $62,246.00 $20,016.01 $3,405.39 $42,229.99 32.16% Community Center $39,479.00 $9,937.59 $2,565.48 $29,541.41 25.17% Total GENERAL FUND $1,987,342.00 $391,984.79 $119,606.73 $1,595,357.21 19.72% EDA $5,000.00 $0.00 $0.00 $5,000.00 0.00% DEBT SERVICE BLACKTOP PROJECCT 2007 $140,188.00 $7,593.75 $7,593.75 $132,594.25 5.42% 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 $49,398.75 $7,593.75 $231,199.25 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 $14,246.43 $2,899.10 $47,923.57 22.92% UPTOWN SEWER $19,323.00 $3,500.17 $1,178.81 $15,822.83 18.11% Report Total $3,582,433.00 $459,130.14 $131,278.39 $3,123,302.86 12.82% CASH BALANCES 2015 END OF MONTH FUND JANUARY FEBRUARY MARCH APRIL 101 GENERAL $1,509,925 $1,542,192 $1,472,581 $1,394,661 225 EDA $760 $760 $760 $760 307 BLACKTOP 2007 $267,037 $267,735 $287,055 $279,461 310 FIRE HALL/PUBLIC WORKS BOND $19,272 $19,321 $0 $0 311 EQUIPMENT CERTIFICATES $9,431 $9,560 $9,560 $9,560 312 EQUIPMENT CERTIFICATES $5,085 $5,099 $5,099 $5,099 313 EQUIPMENT CERTIFICATES $8,119 $7,684 $7,684 $7,684 401 CAPITAL IMPR $297,818 $298,517 $301,157 $301,157 404 PARK CAP IMPR $1,055 $1,067 $4,067 $8,117 406 EQUIPMENT REPLACEMENT $449,710 $451,023 $451,023 $451,023 408 LOCAL ROAD IMPROVEMENT $327,704 $328,137 $328,137 $328,137 602 201 SEWER $153,766 $146,838 $153,856 $157,048 612 UPTOWN SEWER $941 $1,417 -$1,962 $784 801 ESCROW $193,112 $61,378 $95,205 $94,387 TOTAL $3,243,735 $3,140,727 $3,114,224 $3,037,878