Loading...
5. 2017 budget discussion Staff Report Date of Meeting: August 3, 2016 To: City Council From: Neil Soltis, Administrator Re: 2017 budget – preliminary discussions The information provided is based on a series of assumptions with the net result being a baseline budget. A baseline budget represents the steady state of operations for each department. This reflects the resources required for a department to provide the same level of service in the current year, before any new priorities or funding requests. Specifically included are full year salary, benefits, and other normal operating expenses, (including an allocation for capital expenses). Salary expenses in the baseline include open positions for the year (positions that have been open for one year should not be included). Re-occurring overtime and other non-base compensation costs are included. The budgetary revenue and expenditure amounts used in the information presented are based on the 2016 budgeted, 2014 actual, 2015 actual and the 2017 - 2020 Capital Improvement Programs as adjusted for the factors that are included in the assumptions. The goals in order to move forward with the budget are the following 1. Get consensus on the assumptions to be used moving forward 2. Look at the impact on property taxes and expenditures in each Fund 3. Discuss the identified variables or changes to the steady state 4. Discuss other changes to the programs, activities, or services provided Based on this discussion, the budgetary information will be recast for further refinement at future meetings. CITY OF SCANDIA2017 BUDGET ASSUMPTIONS AND VARIABLES Pay structure - merit step increases for non-bargaining unit employees 2% Pay structure - bargaining unit employees 2% Mayor & Council wages increase based on Ordinance 156 2.5% Health insurance - 10% increase - League recommendation is 10-15%: Proposed renewal increase ranges from 3-5% depending on age group and deductible increased from $1,500 to $1,750 6% PERA contribution rates - no change in rate 0% Social security & medicare - no change in rate 0% Workers Compensation - League range 4 - 8% increase 8% Assessor - contract + 200 additional building permits @ $10 / League of Minnesota Cities dues increase 3% Property insurance - League range 2 - 3% increase 3% Liability Insurance - League 2% increase 3% Auto damage & liability - League range 3 - 7% increase 3% Xcel - electricity - appplied for 6.4% increase in 2016 and 1.7% in 2017 6.50% Lakes Area Television support -12.00% Building permits - no change from 2016 budget - $25,000 less than 2016 projectedContract with Sheriff Department - estimated increase 3.50%Wage allocations Administrator - 20% to PlanningPublic Works Director - 12.5% 201 systems, 5% uptown systemPublic Works staff - 10% 201 systems, 3% uptown systemPT Parks - 20% to Park Improvement fund for lighted ballfield maintenance Transfer from General Fund to Local Road Improvement FundAudited 12/31/2015 unassigned fund balance 1,737,134$ Less 2016 transfer (347,724)$ 1,389,410$ Less: 50% of expenditures before transfer 876,184$ Transfer to Local road Improvement Fund 513,226$ ASSUMPTIONS \\SERVER\SharedDocs\Departments\Finance\Budget\2017\assumptions.xlsx 2015 2016 2017Transfer to Local road Improvement Fund per Fund Balance Policy 335,932$ 347,724$ 523,200$ 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Projected 2015 Budget 2016 budget 2017 ProposedFund balance - 12/31 $1,329,553 $1,594,415 $1,715,890 $1,746,587 $1,517,894 $1,523,793 $1,393,396 $1,198,113Revenue$1,999,526 $2,170,437 $2,070,197 $1,944,186 $1,778,614 $1,795,244 $1,748,439 $1,944,186Expenditures$1,923,649 $1,905,575 $1,948,722 $1,913,489 $2,007,307 $1,987,341 $2,101,630 $2,263,968 $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 GENERAL FUND SUMMARY 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Projected 2015 budget 2016 Budget 2017 ProposedOther Financing Sources $4,569 $7,042 $- $- $- $- $- $-Other Income and Transfers in $34,606 $30,075 $40,369 $46,603 $19,000 $19,458 $14,000 $16,500Fines & Forfeitures $17,818 $11,534 $13,468 $12,711 $12,000 $12,000 $12,000 $12,000Charges for Service $242,431 $229,801 $230,767 $67,281 $62,267 $62,204 $69,048 $68,100Intergovernmental Services $18,918 $43,083 $53,530 $83,337 $49,700 $34,732 $42,146 $50,800Licenses and permits $54,657 $100,007 $90,704 $138,741 $115,700 $80,230 $91,295 $90,400Other Taxes $8,900 $14,414 $17,249 $38,864 $21,800 $21,802 $21,802 $21,800Property Taxes $1,601,493 $1,724,724 $1,633,710 $1,583,779 $1,498,147 $1,564,818 $1,498,148 $1,481,168 $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 GENERAL FUND REVENUE SUMMARY 2014 2015 2016 2017Tax Levy for Local road Improvement Fund 127,704$ 345,000$ 581,142$ 580,000$ 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Projected 2015 budget 2016 Budget 2017 ProposedEconomic Development Authority $1,000 $- $5,000 $2,500 $- $5,000Local Road Improvement $345,000 $581,142 $345,000 $581,142 $580,000Capital Improvement Fund $100,000 $91,296 $222,104 $30,000 $30,000 $30,000 $30,000 $30,000Debt Service Fund $351,564 $343,003 $327,506 $272,691 $148,582 $272,691 $148,582 $116,739General Fund $1,603,610 $1,736,775 $1,620,464 $1,569,818 $1,498,147 $1,564,818 $1,498,148 $1,481,168 $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 TAX LEVY 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Projected 2015 budget 2016 Budget 2017 ProposedTransfers$80,000 $99,900 $300,000 $356,522 $347,724 $220,000 $347,724 $523,200Personal Service $524,440 $529,128 $559,416 $568,674 $607,000 $611,927 $619,021 $628,888Capital Outlay $76,806 $84,212 $4,716 $18,525 $12,800 $6,700 $13,000 $4,000Contractual Services $1,091,660 $1,014,750 $905,138 $895,284 $894,133 $954,683 $936,630 $921,980Materials & Supplies $161,816 $179,044 $179,526 $101,869 $145,650 $194,031 $185,255 $185,900 $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 EXPENDITURE SUMMARY BY OBJECT Public Works Expenditures includes the transfer to the Local Road Improvement Fund 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Projected 2015 budget 2016 Budget 2017 ProposedPublic works $731,967 $847,491 $1,055,613 $1,029,107 $1,125,324 $1,039,155 $1,197,153 $1,364,191Community Center $42,538 $36,808 $42,439 $37,759 $36,300 $39,480 $40,261 $38,100Parks & Recreation $48,045 $59,385 $59,802 $56,589 $53,300 $62,244 $60,879 $62,500Fire$273,150 $276,840 $258,138 $224,038 $221,215 $271,515 $232,959 $234,200Police$117,172 $116,384 $121,113 $115,642 $116,200 $120,989 $116,197 $120,500Planning & Building $296,202 $204,125 $71,066 $105,206 $94,900 $71,700 $96,206 $97,000Elections$6,035 $470 $5,827 $1,172 $6,150 $470 $6,150 $1,300City Council $17,949 $17,801 $18,406 $19,578 $26,500 $20,121 $26,976 $19,462Administration & Finance $401,664 $347,730 $316,393 $351,783 $327,418 $361,667 $324,849 $326,715 $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 EXPENDITURE SUMMARY BY DEPARTMENT CITY OF SCANDIA2017 BUDGET ASSUMPTIONS AND VARIABLES ADMINISTRATIONOrdinance codification 9,000$ Website upgrade - provide for custom background and 3 sets of banners using Scandia images 3,000$ Data technology replacements and upgrades Purchase firewall appliance 2,200$ Replace switch with gigabit ethernet switch 2,500$ Replace 2011 Dell server 7,000$ PLANNING - COMPREHENSIVE PLAN UPDATE (SPLIT 80% 2017 / 20% 2018)Comprehensive Plan basic update - $40,000 32,000$ Update on major issues - $55,000 44,000$ Complete comprehensive plan update - $70,000 56,000$ PARKS & RECREATIONBike route signage - recommended by PRC 1,800$ Lilleskogen fill - recommended by PRC 2,000$ Lilleskogen - wetland restoration - $2,000 included in 2016 - 2020 CIP 3,500$ PUBLIC WORKSAdd 2 additional layers to GIS (culverts and guardrails)1,000$ Upgrade GIS to be able to view from mobile devices 2,000$ Purchase GPS capture device 11,000$ Add Asset management software 15,000$ Purchase used roller for patching 8,000$ PAY STRUCTUREModify base pay fromn levels established in 2013 - $1% increase = $1,600 ? EDAAdd funding to match County predevelopment loan fund - recommended by EDA 5,000$ POTENTIAL ITEMS FOR ADDITIONAL FUNDING \\SERVER\SharedDocs\Departments\Finance\Budget\2017\assumptions.xlsx 2015 2016 2016 2016 2017Actual6 months Projected Budget Budget Revenues 146,067$ 15,253$ 34,647$ -$ 14,209$ Expenditures 390,188$ -$ -$ -$ 77,000$ Net Revenues (Expenditures) (244,121)$ 15,253$ 34,647$ -$ (62,791)$ Fund Balance - January 1 287,055$ 42,934$ 42,934$ 42,934$ 77,581$ Fund Balance - December 31 42,934$ 58,187$ 77,581$ 42,934$ 14,790$ Transfer special assessments to Local Road Improvement fund ($77,000) Revenues 44,220$ -$ -$ 43,010$ -$ Expenditures 42,080$ 40,710$ 43,010$ 43,010$ 10,060$ Net Revenues (Expenditures) 2,140$ (40,710)$ (43,010)$ -$ (10,060)$ Fund Balance - January 1 50,930$ 53,070$ 53,070$ 53,070$ 10,060$ Fund Balane - December 31 53,070$ 12,360$ 10,060$ 53,070$ (0)$ Transfer balance to 2015 Fire Tanker Equipment Certificate ($10,060) Revenues 33,946$ -$ 32,744$ 32,744$ -$ Expenditures 32,310$ 593$ 31,185$ 31,185$ 8,294$ Net Revenues (Expenditures) 1,636$ (593)$ 1,559$ 1,559$ (8,294)$ Fund Balance - January 1 5,099$ 5,099$ 6,735$ 6,735$ 8,294$ Fund Balane - December 31 6,735$ 4,507$ 8,294$ 8,294$ -$ Transfer balance to Equipment Replacement Fund ($8,294) Revenues 69,352$ -$ 69,092$ 69,092$ 68,023$ Expenditures 66,515$ 61,330$ 65,883$ 65,823$ 65,063$ Net Revenues (Expenditures) 2,837$ (61,330)$ 3,209$ 3,269$ 2,960$ Fund Balance - January 1 7,684$ 7,684$ 10,521$ 10,521$ 13,790$ Fund Balance - December 31 10,521$ (53,646)$ 13,730$ 13,790$ 16,750$ Revenues -$ -$ 49,056$ 49,056$ 48,739$ Expenditures -$ 46,720$ 46,720$ 46,720$ 46,064$ Net Revenues (Expenditures) -$ (46,720)$ 2,336$ 2,336$ 2,675$ Fund Balance - January 1 -$ -$ -$ -$ 2,336$ Fund Balance - December 31 -$ (46,720)$ 2,336$ 2,336$ 5,011$ FUND BALANCE 2013 FIRE TRUCK/DUMP TRUCK EQUIPMENT CERTIFICATE (FUND 313) 2011DUMP TRUCK EQUIPMENT CERTIFICATES (FUND 312) DEBT SERVICE (FUNDS 307 - 315) 2007 BLACKTOP (FUND 307) 2015 FIRE TANKER EQUIPMENT CERTIFICATE (FUND 315) FUND BALANCE FUND BALANCE FUND BALANCE 2010 FIRE RESCUE TRUCK EQUIPMENT CERTIFICATES (FUND 311) FUND BALANCE CAPITAL IMPROVEMENTS (FUND 401) 2015 2016 2016 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025Actual6 months Projected Budget Proposed Proposed Proposed Proposed Proposed Proposed Proposed Proposed Proposed Revenue 30,967$ -$ 66,000$ 50,700$ 130,000$ 30,000$ 30,000$ 30,000$ -$ -$ -$ -$ -$ Expenditures 10,375$ 2,370$ 55,000$ 40,000$ 200,000$ -$ 100,000$ 30,000$ -$ -$ -$ -$ -$ Net Revenues (Expenditures)20,592$ (2,370)$ 11,000$ 10,700$ (70,000)$ 30,000$ (70,000)$ -$ -$ -$ -$ -$ -$ Balance January 1 335,466$ 335,466$ 356,058$ 254,165$ 367,058$ 297,058$ 327,058$ 257,058$ 257,058$ 257,058$ 257,058$ 257,058$ 257,058$ Balance December 31 356,058$ 333,096$ 367,058$ 264,865$ 297,058$ 327,058$ 257,058$ 257,058$ 257,058$ 257,058$ 257,058$ 257,058$ 257,058$ Interfund Loan from (to) Park Capital Fund (35,000)$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ 5,000$ Advance from (to) 201 Sewer Fund 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ 2,639$ CASH BALANCE 12/31 289,389$ 309,028$ 308,728$ 247,667$ 286,306$ 224,945$ 233,585$ 241,224$ 243,863$ 246,502$ 249,141$ 251,781$ Fire Roof replacement 100,000$ Warning sirens 30,000$ Log House LandingBoat ramp 55,000$ 40,000$ 205th Street - bound aggregate improvement 200,000$ -$ 55,000$ 40,000$ 200,000$ -$ 100,000$ 30,000$ -$ -$ -$ -$ -$ FUND BALANCE EXPENDITURES BY DEPARTMENT PARK CAPITAL IMPROVEMENTS (FUND 404) 2015 2016 2016 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025AccountDescriptionActual6 months Projected Budget Proposed Proposed Proposed Proposed Proposed Proposed Proposed Proposed Proposed Revenue 26,393$ 5,220$ 8,450$ 33,720$ 43,900$ 18,700$ 8,700$ 48,700$ 8,700$ 8,700$ 8,700$ 8,700$ 8,700$ Expenditures 47,273$ -$ 8,000$ 32,500$ 35,200$ 10,000$ -$ 40,000$ -$ -$ -$ -$ -$ Net Revenues (Expenditures)(20,879)$ 5,220$ 450$ 1,220$ 8,700$ 8,700$ 8,700$ 8,700$ 8,700$ 8,700$ 8,700$ 8,700$ 8,700$ Balance January 1 1,067$ (19,812)$ (19,812)$ (18,592)$ (9,892)$ (1,192)$ 7,508$ 16,208$ 24,908$ 33,608$ 33,608$ 42,308$ Balance December 31 (19,812)$ (19,362)$ (18,592)$ (9,892)$ (1,192)$ 7,508$ 16,208$ 24,908$ 33,608$ 42,308$ 42,308$ 51,008$ Advance from (to) Capital Improvement fund 35,000$ (6,000)$ (6,000)$ (6,000)$ (6,000)$ (6,000)$ (6,000)$ (5,000)$ CASH BALANCE 12/31 15,188$ 9,638$ 10,408$ 12,338$ 15,038$ 17,738$ 20,438$ 24,138$ 32,838$ 41,538$ 50,238$ 58,938$ Undesignated Revenue 27$ 27$ 50$ 20$ -$ -$ -$ -$ -$ -$ -$ -$ -$ ExpenditureNet 27$ 27$ 50$ 20$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Balance 1/1 10,582$ (1,837)$ (1,837)$ (1,837)$ (1,787)$ (1,787)$ (1,787)$ (1,787)$ (1,787)$ (1,787)$ Transfer (12,446)$ Balance 12/31 (1,837)$ (1,810)$ (1,787)$ (1,817)$ (1,787)$ (1,787)$ (1,787)$ (1,787)$ (1,787)$ (1,787)$ -$ -$ -$ LilleskogenRevenue 12,617$ 3,093$ 6,000$ 31,000$ 41,200$ 16,000$ 6,000$ 46,000$ 6,000$ 6,000$ 6,000$ Expenditure (47,273)$ -$ (25,000)$ (35,200)$ (10,000)$ -$ (40,000)$ -$ -$ Net (34,656)$ 3,093$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ -$ -$ Balance 1/1 (11,379)$ (31,000)$ (31,000)$ (31,000)$ (25,000)$ (19,000)$ (13,000)$ (7,000)$ (1,000)$ 5,000$ 11,000$ 17,000$ 17,000$ Transfer 15,035$ Balance 12/31 (31,000)$ (27,907)$ (25,000)$ (25,000)$ (19,000)$ (13,000)$ (7,000)$ (1,000)$ 5,000$ 11,000$ 17,000$ 17,000$ 17,000$ Wayne JohnsonRevenue 2,400$ 2,100$ 2,400$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ Expenditure (8,000)$ (7,500)$ (2,200)$ Net 2,400$ 2,100$ (5,600)$ (4,800)$ 500$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ 2,700$ Balance 1/1 -$ 13,025$ 13,025$ 13,025$ 7,425$ 7,925$ 10,625$ 13,325$ 16,025$ 18,725$ 21,425$ 24,125$ 26,825$ Transfer 10,625$ Balance 12/31 13,025$ 15,125$ 7,425$ 8,225$ 7,925$ 10,625$ 13,325$ 16,025$ 18,725$ 21,425$ 24,125$ 26,825$ 29,525$ LilleskogenParking lot 47,273$ Picnic shelter -$ 25,000$ 25,000$ Woodland plantings and fencing 1,200$ entrance signs 5,000$ Park benches 4,000$ Boardwalks 5,000$ Interpretive sign & kiosk 5,000$ 47,273$ -$ -$ 25,000$ 35,200$ 10,000$ -$ -$ -$ -$ -$ -$ -$ Wayne JohnsonBleacher improvements 8,000$ 8,000$ -$ -$ 8,000$ 8,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Skating rinkZamboni replacement 40,000$ -$ -$ -$ -$ -$ -$ -$ 40,000$ -$ -$ -$ -$ -$ Tennis court replacement 60,000$ Lilleskogen - wetland restoration 2,000$ 1,800$ 5,800$ 2,000$ 1,500$ 1,000$ -$ -$ 2,000$ 61,800$ 5,800$ 2,000$ 1,500$ 1,000$ -$ -$ -$ GENERAL FUND PARKS CAPITAL IMPROVEMENT PROJECTS FUND BALANCE FUND DESIGNATIONS IMPROVEMENTS BY LOCATION EQUIPMENT REPLACEMENT (FUND 406) 2015 2016 2016 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025AccountDescriptionActual6 months Projected Adopted Proposed Proposed Proposed Proposed Proposed Proposed Proposed Proposed Proposed Revenue 236,523$ 29,195$ 29,650$ 206,000$ 209,294$ -$ -$ -$ -$ 200,000$ 250,000$ -$ 700,000$ Expenditures 216,938$ -$ 115,000$ 315,000$ 310,000$ 130,500$ 87,000$ -$ 25,500$ 240,000$ 250,000$ 67,500$ 700,000$ Net Revenues (Expenditures)19,585$ 29,195$ (85,350)$ (109,000)$ (100,706)$ (130,500)$ (87,000)$ -$ (25,500)$ (40,000)$ -$ (67,500)$ -$ Balance January 1 451,023$ 451,023$ 470,608$ 470,608$ 385,258$ 284,552$ 154,052$ 67,052$ 67,052$ 41,552$ 1,552$ 1,552$ (65,948)$ Balance December 31 470,608$ 480,218$ 385,258$ 361,608$ 284,552$ 154,052$ 67,052$ 67,052$ 41,552$ 1,552$ 1,552$ (65,948)$ (65,948)$ Public WorksReplace 2002 Sterling dump truck & plow -$ -$ 200,000$ 200,000$ Replace 2009 John Deere 1445 mower w broom & blower 25,000$ Replace 2008 Ford F350 + plow 30,000$ Replace 2008 Ford Ranger 25,500$ Replace 2010 Tiger ditch rear mower 15,000$ Replace 2011 Tiger ditch boom mower 12,000$ Replace 1999 John Deere 6410 Tractor 60,000$ Replace 2011 Ford F250 + plow 25,500$ Replace 2012 New Holland skid loader and trailer 200,000$ Replace 2011 Mack dump truck & plow 40,000$ Replace 2009 John Deere 1445 mower w broom & blower 25,000$ Replace Tiger ditch rear mower 15,000$ Replace Tiger ditch boom mower 12,000$ Replace patching equipment 15,500$ Fire SCBA & Masks -$ 98,000$ 98,000$ SCBA Air Compressor -$ 17,000$ 17,000$ Replace 1995 Ford - Grass Rig #5175 -$ 85,000$ Radio replacement 75,000$ Replace 2003 Peterbuilt Tanker - #5178 250,000$ Replace engine on 2000 Pumper truck - #5176 700,000$ -$ 115,000$ 315,000$ 310,000$ 130,500$ 87,000$ -$ 25,500$ 240,000$ 250,000$ 67,500$ 700,000$ FUND BALANCE SUMMARY EXPENDITURES BY DEPARTMENT LOCAL ROAD IMPROVEMENT (FUND 408) 2014 2015 2016 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025AccountDescriptionActualActualProjectedBudgetProposedProposedProposedProposedProposedProposedProposedProposedProposed Revenue 328,137$ 703,246$ 950,366$ 949,366$ 1,180,700$ 594,700$ 580,500$ 580,500$ 580,500$ 580,500$ 580,500$ 580,000$ 580,000$ Expenditures -$ 628,427$ 1,140,000$ 1,250,000$ -$ 800,000$ -$ 925,000$ -$ 1,050,000$ -$ 700,000$ -$ Net Revenues (Expenditures)328,137$ 74,819$ (189,634)$ (300,634)$ 1,180,700$ (205,300)$ 580,500$ (344,500)$ 580,500$ (469,500)$ 580,500$ (120,000)$ 580,000$ Balance January 1 -$ 328,137$ 402,956$ 327,704$ 213,322$ 1,394,022$ 1,188,722$ 1,769,222$ 1,424,722$ 2,005,222$ 1,535,722$ 2,116,222$ 1,996,222$ Balance December 31 328,137$ 402,956$ 213,322$ 27,070$ 1,394,022$ 1,188,722$ 1,769,222$ 1,424,722$ 2,005,222$ 1,535,722$ 2,116,222$ 1,996,222$ 2,576,222$ 236th, 237th Novak & Oldfield Old Marine Trail 199th & Parkview 202nd, Orwell & Orwell Ct.228th & Mallard NOTES Transfer in balance from 2007 blacktop Special Assessments 77,000$ 14,200$ Transfer from General Fund per fund balance policy 325,173$ 347,724$ 347,724$ 523,200$ FUND BALANCE SUMMARY 2018 ($165,000)2019 ($215,000)2020 ($215,000) 2017 ($205,000)2016 ($175,000) 240th ST. N. BIG M A N N I N G T R . N . LAKEMARINE M AY BE R R Y TR AIL MA X W I L L A V E . O L I N D A T R A I L STATE HWY. 97 CO . R D . 1 5 OAKHILLRD. L O F T O N A V E . N . H W Y . 9 5 CO.RD.52 ST . C R O I X R I V E R C .S .A .H . 3 H W Y .9 5 220th ST. R A I L R O A D ST . C R O I X R I V E R R A I L R O A D LAKE MANNING WHITE LAKEROCK LAKEBONE NIELSENLAKE LAKE GERMAN LAKE SYLVAN LAKESEA LAKEGOOSE LAKE FISH B A Y M A RIN E LAKE LONG LAKE HAY LAKE SAND LA K E AL I C E 240th ST. N. 240th ST. N. 230th ST.N. SCANDIA TR. N.SCANDIA TR. N. SCANDIA TR. N. STATE HWY. 97 STATE HWY. 97 L O F T O N A V E . N . KI R K AV E . KI R K A V E . 220thST. N. CO . R D . 1 5 C. S . A . H . 1 M A N N I N G T R . N . 238th ST. N. M E L A NIE T R. N. 228th ST. N. MA L L A R D AV E . M E A D O W B R O O K A V E . N . 230th ST. N. 236thST. N. OAKHILLRD. M O R G A N A V E . N . 236th ST. N. ST. N. 237th N O V A K A V E .N . N O L A N A V E . N . O L D F I E L D A V E . N . ORENRD.N. O L D F I E L D A V E . N . ST . C R O I X T R . N . S T .C R O I X T R .N . OAKHILLRD.N. O X B O R O A V E .N . 2 0 2 n d S T .N. O R W E L L A V E. N. 197th ST. O R W E L L C T . OLD MARIN E TR. N. OL I N D A T R . N . C. S . A . H 3 188thST.N. N O R E L L A V E .N . 182nd ST.N.181st ST.N. MAPLE ST.M A R G O A V E .N . NE W G A T E A V E . N . 185th ST. N.OA K G R E E N AV E . N . C .S .A .H .3 OL D M A R I N E T R . N . A V E . N . P A R A D E OLD MARINETR.N. QU A N T A V E . N . CO. RD. 4OSTRUM TR. L A K A M A G A TRAILN. L A K A M A G A 196th ST. N. T R A I L 20 5 t h ST. N. CO. RD. 50192nd ST. N. M E A D O W B R O O K A V E . N . MAYBERRY TRAIL 2 0 5 t h S T .N . 195th ST. N. 2 0 9 T H CITY HALL P O M R O Y A V E . N . P E A B O D Y T R . N . PILARRD.N. PILARRD. N. N O LA N A VE.N. OZ A R K A V E 199th ST N P A R K V I E W L N 218th ST. N. 2 3 9 t h S T .N . NO V A K A V E . N . PO M R O Y AV E N U E N . PI C K E T T AV E N U E N . PR I M R O S E LA N E N . MANNINGTR, CT, CR 228th ST. N. 191st ST. N. 185th ST. N. 202nd ST. N. KI R B Y A V E . N . 213thST.N. 215th ST. N. 216th ST. N. 217th ST. N. PE N R O S E AV E N U E N . 215th ST N. PE N N F I E L D AV E . N . PA RR ISH RO AD N. O L I N D A L N .N . 209th ST. N. O D E L L MEADOWBROOK CIR. P A R I S A V E O D E L L C T N E W B E R R Y AVE NB.CT. K I R K C T . 207th ST. N. KI R K L A N G L E Y 180th ST. N. OZARKCT 209THST.N. O R E N 2 13th 2 14thOLAND A V E O L G I L V I E A V E . N . 223rd P E R K IN S A V E 2 0 9 t h S T NQU A D R A N T AV E . N . QUALITYTR. 20 5 t h C T . 1 9 7 t h S T N OX B O R O L N O S T R U M P A R K V I E W A V E . 197th LOFTONCT. O R L O D R . 238th ST. N. 235th ST. N. AVE.N OXBORO CIR. 213TH Q U I N E L L A V E . N . 232nd ST. N. 190th189th L A R K S P U R A V E .N L A Y T O N A V E .N 1 8 7 t hL A M A R 192nd 186th QU E N T I N A V E . N . QU A R R Y A V E . N . 235thST. N. M E A D O W R I D G E C I R C L E TRAILLANE M E A D O W R I D G E S T .N .O A K H I L L C T .N .97 COUNTY 97 97 95 95 95 COUNTY COUNTY COUNTY COUNTY COUNTY COUNTY COUNTY COUNTY COUNTY COUNTY COUNTY K H I L L L C C T N 202020222024 20182016 2018 2022 2020 2024 2016 2021 ($75,000) (QUINNELL AVE, 236TH, 237TH, NOVAK)2022 ($125,000)NEED TO PLAN IMPROVEMENTS 20262028 2028 2026 SEAL COAT Bolton & Menk, Inc. 2015, All Rights ReservedcH:\SCND\_Mapping\Maps\Streets\DWG\Scandia_CIP_Map.dwg 8/18/2015 2:31:01 PM CHASKA, MN RAMSEY, MN MAPLEWOOD, MN BAXTER, MN ROCHESTER, MNMANKATO, MN FAIRMONT, MN SLEEPY EYE, MN BURNSVILLE, MN WILLMAR, MN AMES, IA SPENCER, IA DES MOINES, IA FARGO, ND FIGURE NO. 1AUGUST, 2015 FEETSCALE 0 36001800HORZ. CAPITAL IMPROVEMENT PLAN - STREETSCITY OF SCANDIA, MINNESOTA RECONSTRUCT 201 SEWER SYSTEMS 2015 2016 2016 2015 2016 2017 2018 2019 2020 2021 2022AccountDescriptionActual6-months Projected Adopted Adopted Proposed Proposed Proposed Proposed Proposed Proposed Revenue 75,095$ 28,657$ 77,200$ 74,550$ 74,550$ 74,550$ 74,550$ 74,550$ 74,550$ 74,551$ 74,552$ Expenditures 101,178$ 29,156$ 88,116$ 62,170$ 81,254$ 101,511$ 101,511$ 107,911$ 100,911$ 100,911$ 100,911$ Net Revenues (Expenditures)(26,082)$ (500)$ (10,916)$ 12,380$ (6,704)$ (26,961)$ (26,961)$ (33,361)$ (26,361)$ (26,360)$ (26,359)$ Add Depreciation 33,785$ 33,786$ 33,786$ 30,200$ 35,000$ 35,000$ 35,000$ 35,000$ 35,000$ 35,000$ Less Capitalized expenditures (102,650)$ -$ -$ -$ -$ (65,500)$ -$ -$ -$ -$ (700,000)$ Cash Flow (94,947)$ 33,287$ 22,871$ 12,380$ 23,496$ (57,461)$ 8,039$ 1,639$ 8,639$ 8,640$ (691,359)$ Balance January 1 923,227$ 923,227$ 897,145$ 923,227$ 897,145$ 886,229$ 859,269$ 832,308$ 798,948$ 772,587$ 746,228$ Balance December 31 897,145$ 922,728$ 886,229$ 947,988$ 890,441$ 859,269$ 832,308$ 798,948$ 772,587$ 746,228$ 719,869$ Cash balance - December 31 51,185$ 74,056$ 74,681$ 16,595$ 24,634$ 26,274$ 34,913$ 43,554$ (647,805)$ Anderson / EricksonDrainfield 47,459$ 200,000$ Bliss Lift station control upgrades 47,459$ Lift statino antenna 7,732$ Bliss Lift Station 1 - control panel 27,500$ Bliss Lift Station 2 - control panel 27,500$ Bliss Lift Station 2 - pump 1 5,250$ Bliss Lift Station 2 - pump 2 5,250$ Nitrate treatment 500,000$ 102,650$ -$ -$ -$ -$ 65,500$ -$ -$ -$ -$ 700,000$ FUND BALANCE SUMMARY CAPITAL EXPENDITURES UPTOWN SEWER SYSTEM (FUND 612) 2015 2016 2016 2015 2016 2017 2018 2019 2020 2021 2022Actual6 months Projected Budget Budget Proposed Proposed Proposed Proposed Proposed Proposed Revenue 18,183$ 4,735$ 18,200$ 19,717$ 18,000$ 18,000$ 18,000$ 18,000$ 18,000$ 18,000$ 18,000$ Expenditures 16,820$ 8,306$ 18,301$ 19,323$ 15,969$ 20,418$ 20,400$ 20,400$ 20,400$ 20,400$ 20,400$ Net Revenues (Expenditures)1,362$ (3,571)$ (101)$ 394$ 2,031$ (2,418)$ (2,400)$ (2,400)$ (2,400)$ (2,400)$ (2,400)$ Add Depreciation 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ 4,876$ Less Loan repayment to Capital Imp Fund (2,639)$ (2,639)$ (2,639)$ (2,639)$ (2,639)$ (2,639)$ (2,639)$ (2,639)$ (2,639)$ Less Capitalized expenditures -$ -$ -$ -$ -$ (500)$ -$ -$ (500)$ -$ (4,900)$ Cash Flow 3,599$ 1,305$ 4,775$ 2,631$ 4,268$ (681)$ (163)$ (163)$ (663)$ (163)$ (5,063)$ Balance January 1 155,188$ 166,189$ 162,386$ 155,188$ 162,386$ 171,937$ 170,575$ 170,249$ 169,923$ 168,598$ 168,272$ Balance December 31 162,386$ 168,799$ 171,937$ 160,450$ 170,922$ 170,575$ 170,249$ 169,923$ 168,598$ 168,272$ 158,146$ Cash balance (144)$ 4,631$ 1,887$ 3,950$ (163)$ 1,724$ 3,287$ (326)$ (3,339)$ Drainfield blower 500$ 500$ 500$ Replace Uptown pump 1 1,100$ Replace Uptown pump 2 1,100$ Replace Drainfield pump 1 1,100$ Replace Drainfield pump 2 1,100$ -$ -$ -$ -$ -$ 500$ -$ -$ 500$ -$ 4,900$ FUND BALANCE SUMMARY CAPITAL EXPENDITURES ECONOMIC DEVELOPMENT AUTHORITY 2015 2016 2015 2016 2017AccountDescriptionActualProjectedAdoptedAdoptedProposed Revenue 5,001$ -$ 5,000$ -$ -$ Expenditures 365$ 325$ 5,000$ 500$ 500$ Net Revenues (Expenditures)4,636$ (325)$ -$ (500)$ (500)$ Balance January 1 760$ 5,396$ 5,071$ Balance December 31 5,396$ 5,071$ -$ (500)$ 4,571$ FUND BALANCE