The URL can be used to link to this page

Home My WebLink About04 05 10 City Council work session . )Jj Today's Topics Discussion · 2011 ClP Projects · Transportation Plan · Equipment Replacement Plan · Park Equipment Replacement Plan · Water Quality Plan · Sanitary Sewer Plan · Water Plan ". .Financia~IrnP~~si .' .... '. . '~""';';~,!,~j,'",,,'jd~~.~'!,\,-\ii~~~~f..~~~J.~,,il' ~ 2011 CIP (cont.) Public Works (Streets/Utilities) - $5,750,000 . Test Wells . Meter Replacement Program . Well No. 10 . Arcadia/CR 21 Intersection Construction . Boudins Street Reconstruction (Phase 1) . Sanitary Sewer Lining . TH 13 Watermain Replacement Public Works (Water Quality) -$350,000 , . WQ SyStem Maintenance and Retrofits' .' ~';'~">li!if.:~t.-/:~..-:1ilr_)~G,~,:~~;!~~t'~~~~;~;~j"::-,i:-~;~':~'-:"}e~'~liOC~..t: ~k; Transportation Plan Based on City Council direction staff has updated the Transportation Plan. While not part of the 2011-2015 OP the updates have reduced the estimated 2010 Tax Levy Bonding from $2.1 million to $901k. This is primarily a result of low bidding costs, federal funding resulting in a reallocation of State Aid Funds and use of alternate fUl)ding sources. ~~~,47~\L~~t:~2-$3~}k:i~;_~-it~'~~t.l:t~.~:.i:::i(J;~/':,",~~~."E~;~~~.~~~ 1 l4j Transportation Plan 2010 - Arcadia/CR 21 Design Only . Utilizes Street Oversize funding instead of bonding 2011 - Arcadia/CR 21 Construction . Includes Right of Way acquisition 2012 - Industrial Park . Includes only basic street restoration to a rural paved street section 2015 - Project Changes '. Downtown South Reconstruction Removed. "" . .. .j" ,;~4l,(")",~~ .Main AvejCR 21jPleasant ProjecfAdde~~ .t 2 ~ O~~ Financial Impacts Adjustments that impact the property tax levy: . Police vehicles are funded in the Revolving Equipment Fund instead of the General Fund . Contribution from General Fund to Revolving Park Equipment Fund is reduced from $100,000 to $50,000 . General Fund Parks Department operating budget is adjusted to reflect maintenance needs versus the incremental increase used historically . Transportation Plan, reflects input,received on 02/16/10 regarding prioritization of. improvement projects ~'~,~~j;~~~.:,;~;;" ~--",!~~.7:: ~.; :,;";~ . :~/ ;~;~:'::'i;:~3:~:t.f~i~~~.~t~~~:\~i: ;J,~i~,;~~nll~~~~~h~1~/ OJ) What's Next? Tonight: April 12 : April 19: Draft CIP Review Planning Commission reviews CIP Public Hearing on 2011-2015 CIP Authorize sale of bonds for 2010 Adopt 2011-2015 CIP Approve issuance & sale of 2010 bonds I June-July: Develop 2011, budget requests; incorporate , , ""';c ~,c' ,; ,. ," ,..,,20:,1 ~~,.~,~~~.~~~,~~~".,..-..d,j,,~, ;,.~"j",",_ ",:.;;J '.i_N't~:f.L4,'~";I.::""-n"-,!;.W't! ':''-hf'.'(,,:r~_'I,v:.1C''~~J~}.y''''';'~lolM~~~&~M-.......'>I'i'It.~J May 3: 3 OX PR.IO~ A '(" t ~ u ~ h'j ~llVNEso1l'> 4646 Dakota Street S.E. Prior Lake, MN 55372-1714 CITY COUNCIL WORK SESSION REPORT MEETING DATE: APRIL 5,2010 PREPARED BY: JERIL YN ERICKSON, FINANCE DIRECTOR STEVE ALBRECHT, PUBLIC WORKS DIRECTOR TOPIC: DRAFT CAPITAL IMPROVEMENT PROGRAM 2011-2015 DISCUSSION: Introduction The purpose of this workshop is to review the proposed 2011-2015 Capital Improvement Program. Preliminary focus is upon the following plans: Transportation, Equipment Replacement and Park Equipment Replacement. The other three plans, while included for information, will receive greater council attention at subsequent work sessions. Historv City staff updates the CIP on an annual basis. The CIP is designed to identify infrastructure improvements needed due to ongoing maintenance and repair and community growth and the associated funding sources. Such projects include City-initiated improvements, county and state road improvements and improvements requested by residents and developers. The 2011-2015 CIP ($25.4 million) is similar in scope to the 2010-2014 CIP ($27.8 million). The 2011-2015 CI P only reflects the City's share of other governmental agency projects. Current Circumstances Staff has updated the CIP and will present the 2011 projects along with following long range plans at the workshop for City Council Consideration: 1) Transportation Plan 2) Equipment Replacement Plan 3) Park Equipment Replacement Plan 4) Water Quality Plan 5) Sanitary Sewer Plan 6) Water Plan The updated draft documents have been included for City Council review. Conclusion The City Council should provide Staff with comments and input on the Draft CIP ISSUES: Transportation Plan Based on City Council comments at the February 16, 2010 Workshop staff has modified the proposed plan. The following project changes are proposed from 2010-2015: www.cityofpriorlake.com Ph0neo95i~Q447,,98GOj Fax 952.447.4245 . 2010: Arcadia/CR 21 Design (Changed funding source from tax levy to Street Oversize Fund) . 2011: Arcadia/CR 21 Construction (Includes ROW Acquisition in 2011 rather than 2010) . 2012: Industrial Park (Includes only basic street restoration to rural paved street rather than urban section) . 2015: Downtown South Project taken out of plan until redevelopment occurs. (CR 21/Main Ave/Pleasant Project added to address CR 21 concerns. Project only includes Pleasant access construction and closing Main to left turns in and out. No bridge or bypass proposed with this project.) Equipment Replacement Plan Historically, the Police vehicles have been budgeted in the General Fund as part of the Police operating budget. Staff has included the Police equipment inventory in the 2011-2022 Equipment Replacement Plan to provide an overall picture of the equipment needs of the City. The funding for the police vehicles will be provided by utilizing fund balance reserves in the Revolving Equipment Fund for several years and incrementally increasing the tax levy in future years if needed to maintain the appropriate fund balance reserves for planned equipment replacement costs. This will result in a reduction in General Fund expenditures by approximately $75,000 on an annual basis, beginning in 2011. Park Equipment Replacement Plan Based on previous fund balance reserve balance discussions, Staff has proposed to limit the growth in the fund balance reserve for the Revolving Park Equipment Fund. Previous plans included an annual General Fund contribution of $100,000 through 2016 to build a fund balance reserve for future park equipment replacement costs. Based on long-term replacement projections prepared by Park Staff, fund balance reserves should be sufficient at this reduced level. This will result in a reduction in General Fund expenditures by approximately $50,000 on an annual basis, beginning in 2011. Previous Park Equipment Replacement Plans also incorporated an incremental increase in the Parks Department operating budget to provide the resources as needed to maintain the existing park system. In addition, Park Staff and the Parks Advisory Committee will be reviewing future park needs based on demographic projections and existing park facilities to determine if any change should be made to the long-term plan. Water Quality Plan This plan has been included for informational purposes. Based on the current rate structure this fund will reach a zero balance sometime in 2015. Staff plans to bring forward a detailed plan for this fund later in 2010 that will include a discussion of the minimum fund balance reserve required and potential rate scenarios. Sanitary Sewer Plan This plan has been included for informational purposes. Based on the current rate structure this fund will reach a zero balance sometime in 2014. At the March 1st City Council Workshop the Council provided comments and direction related 2 to rates and fund balances. Staff plans to bring back a full report and plan for consideration by the City Council in June. Water Plan This plan has been included for informational purposes. Based on the current rate structure this fund will reach a zero balance sometime in 2014. At the March 15t City Council Workshop the Council provided comments and direction related to rates and fund balances. Staff plans to bring back a full report and plan for consideration by the City Council in June. FINANCIAL IMPACT: All items contained in the CIP require City Council approval prior to construction or acquisition. Approval of the CIP does not obligate the City to complete the proposed projects. The 2011 projects and equipment replacement costs will be incorporated into the 2011 budget requests for budgeted funds. Attached for your review is a financial summary that shows the tax levy, debt and fund balance reserve impacts of the proposed CIP. RECOMMENDED The Council should provide comment on the draft document and its various ACTION: elements in order that the approval process can proceed as planned. a i 1 3 2011- 2015 CAPITAL IMPROVEMENT PROGRAM FINANCIAL SUMMARY Debt Balances As of 12/31/2009, the City of Prior Lake had $37,520,000 in debt. The following chart reflects the type of debt that comprises the $37M: Debt Type G.O. Special Assessment Bonds G.O. Tax Increment G.O. Bonds (MV) I G.O. Bonds I Revenue Bonds I G.O. Revenue Bonds I G.O. Capital Improvement Bonds I Total Amount $ 7,265,000 325,000 9,170,000 1,165,000 9,465,000 9,100,000 1,030,000 $ 37,520,000 Purpose Street Improvement Projects Tax Increment Project (EDA) Referendum Projects (Park & Fire Stations) Street Reconstruction Project City Hall & Police Station (EDA) Maintenance Facility & Water Treatment Facility Scott County Cooperative Agreement The 2011-2015 Capital Improvement Program includes projects that are funded by bond proceeds. Bonds are issued for the project costs that the City is funding through tax levies as well as the costs that are specially assessed to property owners. The CIP anticipates $13,307,000 in bonding for projects in the Transportation Plan for 2010-2015 and $1,500,000 for a 500,000 gallon water storage unit in 2013. The following chart reflects all bonding requirements referenced in the CIP and Transportation Plan. The blue line represents the cumulative effect of new debt issued. The red line represents the retirement of existing debt. The green line is the resulting debt balance at the end of each year. i. -: .....-. ~.............. ~, . ---. ~ .~ ~ / -. ~./ ,--- - $40,0 $35,0 $30,0 ,.- $25,0 'iil c: ~ $20,0 E :S $15,0 $10,0 Projected Debt Balances 04.05.2010 ---. $5,0 / $0,0 "I) ,," 10,,1- 10""0 >./>0 ,,<' ,,'0 .(\ 10,,<0 10"q, 1-101-1) 1-10 1-1) 't 't 1-1) 1-10 1-1) 1-10 't 't -Existing Debt --New CiP Debt -Projected Debt ~ Council Work Session - April 5, 2010 - Capital Improvement Plan/Financial Summary Page 1 Prooertv Tax Levies On February 1, 2010, a work session was held to discuss long-range financial planning. The inforrnation provided at that time reflected the impacts of inflationary pressures, personnel contracts, and commitments made in the previous Capital Improvement Plan (2010-2014) on future property tax levies. Subsequent work sessions were held to receive council input on preparing certain components of the draft 2011-2015 CIP: Transportation Plan, Water Plan and Sanitary Sewer Plan. The result of the adjustments being recommended in each of the plans is shown in the Property Tax Projections (next page). The primary adjustments include the following: · Police vehicles are funded in the Revolving Equipment Fund instead of the General Fund · Contribution from General Fund to Revolving Park Equipment Fund is reduced from $100,000 to $50,000 · General Fund Parks Department operating budget is adjusted to reflect maintenance needs versus the incremental increase used historically · Transportation Plan reflects input received on 02/16/10 regarding prioritization of improvement projects In addition, I have factored in two additional 2011 budget considerations to see what the bottom line impact would be on the property tax levy: · General Fund contingency line item is reduced from $69,000 to $30,000 · Utilize $350,000 in General Fund reserves for 2011 versus $250,000 Without any other adjustments to revenues or expenditures, a .39% increase in the property tax levy would be needed to balance the 2011 General Fund budget. This is onlv a oreliminarv estimate. The ouroose for oroviding this information is to mark our orogress on reevaluating service oriorities and addressing fund balance reserve levels. As was noted during the Feb 1 work session, there are many components that comprise the annual budget and property tax levy. It is our goal to review and refine each of these components as we are preparing the 2011 budget and planning for future years. Council Work Session - AprilS, 2010 - Capital Improvement Plan/Financial Summary Page 2 CITY OF PRIOR LAKE COUNCIL WORKSHOP 04,05,2010 PROPERTY TAX PROJECTIONS Proi~cted II Totals 2011 2012 2013 2014 2015 2011 - 2015 Previous Year Tax levy: General 7,020,503 6,967,126 7,159,716 7,642,335 7,904,470 7,020,503 Equipment Fund 260,000 270,000 280,000 290,000 320,000 260,000 Revolving Park Equip Fund Faciiities Management Fund 135,000 Debt 2,798,683 2,881,557 3,081,281 3,225,968 3,211,074 2,798,683 10,079,186 10,118.683 10,520,997 11,158,303 11,570,544 10,079,186 Revenues: Changes in Non-Property Tax Reve (17,198) (20,819) (15,306) (16,812) (20,337) (90,473) (17,198) (20,819) (15,306) (16,812) (20,337) (90,473) Expenditures: Personnel 371,756 265,786 276,396 287,430 298,902 1,500,270 Allocation of Overhead Current Expenditures (11,669) 143,814 133,128 127,122 165,936 558,331 Capital Outlay Capital Outlay - Technology 12,775 12,775 Transfers to Other Funds (Debt) 29,959 53,810 49,400 (135,604) 19,963 17,528 Contingency (39,000) 39,000 Transfer-Rev Park Equip Fund (50,000) (50,000) Fire Relief Assn Contribution Reductions in Expenditures Needed 313,821 463,410 497,925 278,948 484,801 2,038,904 Debt: Existing CIP (60,589) (52,438) (58,638) (109,837) (158,037) (439,539) New CIP 108,000 210,000 154,000 240,000 240,000 952,000 EDA Lease Revenue 15,000 15,000 15,000 15,000 15,000 75,000 Market Referendum 20,463 27,162 34,325 (160,057) 41,363 (36,744) 82,874 199,724 144,687 (14,894) 138,326 550,717 Other Tax Supported Funds: Equipment Fund Levy 10,000 10,000 10,000 30,000 30,000 90,000 Revolving Park Equip Fund Levy (bl Facilities Management Fund Levy (t 135,000 135,000 270,000 Fund Balance: Use of General Fund Reserves (350,000) (250,000) (600,000) Tax levies: General 6,967,126 7,159,716 7,642,335 7,904,470 8,368,934 8,368,934 Equipment Revolving Fund 270,000 280,000 290,000 320,000 350,000 350,000 Revolving Park Equip Fund Facilities Management Fund 135,000 270,000 270,000 Debt Service 2,881,557 3,081.281 3,225,968 3,211,074 3,349,400 3,349,400 10,118,683 10,520,997 11,158,303 11,570,544 12,338,334 12,338,334 Change from Previous Year 39,497 402,314 637,305 412,242 767,790 Breakdown of Change in levies: General (53,377) 192,590 482,618 262,136 464,464 1,348,431 Equipment Revolvin9 Fund 10,000 10,000 10,000 30,000 30,000 90,000 Revolving Park Equip Fund Facilities Management Fund 135,000 135,000 270,000 Debt 82,874 199,724 144,687 (14,894) 138,326 550,717 Total Change 39,497 402,314 637,305 412,242 767,790 2,259,148 General -0,76% 2,76% 6,74% 3.43% 5,88% 19,21% Equipment Revolving Fund 3,85% 3,70% 3,57% 10,34% 9,38% 34,62% Revolving Park Equip Fund 0,00% 0,00% 0,00% 0,00% 0,00% 0,00% Facilities Management Fund 0,00% 0,00% 0,00% 0,00% 0,00% 0,00% Debt 2,96% 6,93% 4,70% -0.46% 4,31% 19,68% Total Change 0,39% 3,98% 6,06% 3,69% 6,64% 22.41% GENERAL FUND RESERVES: Beginning Balance 6,053,435 5,733,435 5,513,435 5,582,435 5,651,435 Ending Balance 5,733,435 5,513,435 5,582,435 5,651,435 5,720,435 Reserve Percentage 44,5% 41,2% 40,8% 39,9% CAPITAL IMPROVEMENT PROGRAM Demands vs. Funding Sources 1/1/10 Cash Six-Year Revenue CIP Construction 2010 Construction 1/1/16 Projected Funding Source Balances Projection (Net) Demands Encumbrances Cash Balances Water Fund 3,844,800 (1,447,559) 3,040,000 330,000 (972,759) Sewer Fund 2,545,200 (2,120,792) 1,731,000 (1,306,592) Water Quality Fund 657,000 941,338 1,711,701 122,000 (235,363) Capital Park Fund 144,000 705,000 279,500 76,000 493,500 Trunk Reserve Fund 1,094,000 1,866,250 155,000 85,000 2,720,250 Street Oversize Fund 513,000 615,000 100,000 20,000 1,008,000 Water Storage Fund 96,000 1,800,000 1,800,000 96,000 Transit Fund 1,708,000 (1,979,176) 153,000 40,000 (464,176) Municipal State Aid 2,600,000 2,135,000 465,000 Project Tax Levy 9,443,066 8,542,000 901,066 Special Assessments 3,780,000 3,480,000 300,000 I ntergovern mental 2,572,000 2,315,000 257,000 TOTALS $ 10,602,000 $ 18,775,127 $ 25,442,201 $ 673,000 $ 3,261,926 Proiect All City Departments GIS Data CITY OF PRIOR LAKE CAPITAL IMPROVEMENT PROGRAM 2011 - 2015 CIP Reference CIP1 Fiber Optic Network Connection CIP2 Public Works (Parks) Field Backstops Basketball Courts Park Appurtenant Equipment Tree Planting Park Signs Picnic Shelter CIP3 CIP4 CIP5 CIP6 CIP7 CIP8 Description Update I acquire GIS data Fiber Optic Network Connection between City Hall, Maintenance Center, Water Treatment Facility and Fire Station No, 1 Backstops / Ag/ime: 2012 - Northwoods Meadows 2013 - Enclave at Cleary Lake Basketball Courts: 2012 - Northwood Meadows 2013 - Enclave at Cleary Lake Numerous park benches, grills, drinking fountains, player benches, pcnic tables, play equipment etc. need to be replaced or additional equipment added each year. Tree planting and replacement in parks and parkways Park Entrance Signs: 2012 - Stonebriar, Northwood Meadows and Spring Lake (2) 2013 - Enclave at Cleary Lake Picnic Shelters: 2012 - Northwood Meadows 2013 - Enclave at Cleary Lake Page 1 of4 Purpose To update the City's digital mapping and asset management database; providing aerial photography and other data that can be used in mapping and other applications by all City departments. Connect WTF and MC to fiber optic network to increase communications abilities and reliability PROJECT DETAIL Cost I Benefit Impact Statement Updated mapping will enable the City to utilize clear and accurate visual references for presenting information and making decisions. Will provide reliable connection from City Hall & maintenance center to WTF for SCADA control and information systems Backstops keep balls in the field of play, Aglime Backstops protect spectators and park users is the safety surface materials used on the from equipment used on fields. Aglime is a safe, infields, maintainable material. Basketball hard court surface areas are very popular among neighborhood children and adults. These items are essential elements to each of the parks in the community. An annual Tree Planting and Replacement Program is needed to replace dead trees and enhance other areas, The signs will be constructed of natural, maintenance-free materials and provide park identification. These courts benefit both the youth and adults of the neighborhood. By purchasing these items for our park system in a timely manner. the City is serving its residents efficiently. Trees add value to parks, neighborhoods and the City, as well as providing benefits to wildlife and the environment. The park signs provide identification for residents and visitors of Prior Lake. Picnic shelters provide shelter from the elements These shelters provide shelter and protection for picnics, gatherings, and summer playground from the elements. recreation activities for children. CITY OF PRIOR LAKE CAPITAL IMPROVEMENT PROGRAM 2011 - 2015 Proiect Play Structures CIP Reference CIP9 Park Equipment Replacement CIP10 Public Works (Streets I Utilities) Test Wells CIP11 Meter Replacement Program CIP12 Well No. 10 CIP13 Street Reconstruction (Co. Rd.) CIP14 Sanitary Improvement CIP15 Watermain Improvements CIP16 Description Purpose Each year, selected neighborhood and community parks being developed will have modular play structures installed providing safe accessible activities for children. Play Structures: 2011 - Stonebriar 2012 - Northwood Meadows 2013 - Enclave at Cleary Lake Park equipment replacement Replace and Renovate park facilities and equipment Drill Test Wells: Cardinal Ridge Park Monitor stormwater and water quality for City well field Water Meter Replacement Program: SR " meters (1,441) Invensys meters (455) PROJECT DETAIL Cost I Benefit Impact Statement Play equipment provides active play areas and provides social activities for children. Renovations necessary to maintain City park system Protect City's wellhead Water meters deteriorate with age. resulting in Implementation of a meter replacement program inaccurate readings. American Water Works will show a decrease in apparent loss and in replacement guidelines estimate a 15-year life on increase in revenue. residential meters. Municipal Well NO.1 0 in Wilderness Ponds Park Construct Well NO.1 0 to provide adequate water supply in case of well failure These are Scott County reconstruction projects. City will participate in storm sewer and other improvements on a cost sharing basis through a 2011 - CR21/Arcadia intersection cooperative agreement. 2012 - CR21/Fountain Hills Signal 2013 - CR44/MainfTH13 intersection 2015 - CR 21/Main Ave/Pleasant, CR 83 Payment Sanitary Sewer improvement project Duluth Avenue easement Improve sanitary sewer main line which services Commercial area, reduce infiltration issues and improve flow Replace CIP watermaln along TH 13 from Rustic Replace old watermain Road to Boudins Street Page 2 of 4 Well is needed to provide City firm pumping capacity and to utilize Water Treatment Facility at full capacity These County Highway Improvement Projects will restore the driving surface and improve storm drainage in these respective areas. Reduction of infiltration and settlements in sanitary sewer which could be cause for sanitary back-ups and impede flow design of main line pipe Currently, this watermain experiences periodic breaks CITY OF PRIOR LAKE CAPITAL IMPROVEMENT PROGRAM 2011-2015 Project Water System Inflow /Infiltration Prevention Street Improvements (City) Pressure Reducing Valves Water Storage Public Works (Water Resources) WQ System Maintenance and Retrofit Prior Lake Outlet Channel JPNMOA CIP Reference Description CIP17 Well and water tower control upgrades CIP18 CIP19 CIP20 CIP21 CIP22 CIP23 Sanitary Sewer Lining 2011 - Boudins,Timothy,Denise,Lois.Natalie 2012 - Industrial Park, Rutgers/Watersedge/Grayling 2013 - Martindale/Carriage Hills Resurfacing, Mushtown/Maple/Panama 2014 - Franklin Trail Resurfacing, Eau Claire/Highland/Marsh/Skyline Pressure Reducing Valves: 2013 - Carriage Hills Water Storage: 500,000 gallons ground storage Maintaining existing structural stormwater practices and adding new treatment. (locations vary) Prior Lake Outlet Channel maintenance / improvements Page 3 of 4 Purpose Improvements will allow staff to coordinate flow to the elevated tanks and make well pump improvements to match the water treatment facility pressure. PROJECT DETAIL Cost / Benefit Impact Statement Altitude valves and well pump modifications will allow staff greater control of the water system, Reduce water infiltration into collection system Reduction of lift station pumping and treatment flow costs to Blue Lake from Met Council To resurface streets to extend usuable life or reconstruct streets to a 7-ton or 9-ton standard. Reduce pressure in lower service areas of the Prior Lake community, Increase water storage on west side of lake. Maintenance, retrofit and creation of storm water ponds to restore and enhance overall system treatment efficiency. Maintenance. retrofit and creation of other structural practices such as; sump manholes, bioretention, infiltration and filtration. To provide maintenance repairs and upgrades for the Prior Lake Outlet Channel. This project is a cooperative effort between the SMSC, PLSLWD, Prior Lake and Shakopee. Improved streets will reduce maintenance for the streets and for vehicles, Reducing pressure in the distribution system will assist in water conservation and water loss. Increase water storage to provide adequate supply for high usage periods, fire protection and system pressure. Provides better water quality by increasing ability to circulate system. Using a targeted maintenance and retrofit program to continually renew and improve the overall water quality system effectivness and cost efficiency. Outlet channel repairs will prevent erosion and restore channel capacity. Project Transit CMAO Grant Bus Purchase CITY OF PRIOR LAKE CAPITAL IMPROVEMENT PROGRAM 2011 - 2015 CIP Reference CIP24 Description Purpose Purchase of 3 additional coach buses for transit Expansion of BlueXpress service to provide purposes. more frequent runs and more routes. Page 40(4 PROJECT DETAIL Cost I Benefit Impact Statement Additional transit capacity will help reduce congestion on regional roads and will help to improve air quality. CITY OF PRIOR LAKE PROJECTS BY DEPARTMENT CAPITAL IMPROVEMENT PROGRAM 2011 - 2015 CIP Project Reference 2011 2012 2013 2014 2015 Total All City Departments GIS Data CIP1 5,000 5,000 5,000 5,000 5,000 25,000 Trunk Reserve Fund 5,000 5,000 5,000 5,000 5,000 25,000 Fiber Optic Network Connection CIP2 200,000 200,000 Water Storage Fund 200,000 200,000 All City Departments Total 5,000 5,000 205,000 5,000 5,000 225,000 Public Works (Parks) Field Backstops CIP3 5,000 5,000 10,000 Capital Park Fund 5,000 5,000 10,000 Basketball Courts CIP4 10,000 10,000 20,000 Capital Park Fund 10,000 10,000 20,000 Park Appurtenant Equipment CIP5 10,000 10,000 20,000 Capital Park Fund 10,000 10,000 20,000 Tree Planting CIP6 10,000 10,000 10,000 10,000 40,000 Capital Park Fund 10,000 10,000 10,000 10,000 40,000 Park Signs CIP7 20,000 5,000 25,000 Capital Park Fund 20,000 5,000 25,000 Picnic Shelter CIP8 25,000 25,000 50,000 Capital Park Fund 25,000 25,000 50,000 Play Structures CIP9 24,500 45,000 45,000 114,500 Capital Park Fund 24,500 45,000 45,000 114,500 Neighborhood Park Replacement CIP10 110,000 150,000 175,000 190,000 240,000 865,000 General Fund-Park Operating 110,000 150,000 175,000 190,000 240,000 865,000 Public Works (Parks) Total 134,500 275,000 285,000 200,000 250,000 1,144,500 Page 1 of 4 CITY OF PRIOR LAKE PROJECTS BY DEPARTMENT CAPITAL IMPROVEMENT PROGRAM 2011 - 2015 CIP Project Reference 2011 2012 2013 2014 2015 Total Public Works (Streets I Utilities) Test Wells CIP11 55,000 55,000 Water Quality Fund 10,000 10,000 Water Fund 45,000 45,000 Meter Replacement Program CIP12 120,000 120,000 120,000 175,000 175,000 710,000 Water Fund 80,000 80,000 80,000 120,000 120,000 480,000 Sewer Fund 40,000 40,000 40,000 55,000 55,000 230,000 Well No. 10 CIP13 600,000 600,000 Water Fund 600,000 600,000 Street Reconstruction (Co. Rd.) CIP14 2,675,000 300,000 1,875,000 3,057,000 7,907,000 Project Levy 910,000 100,000 1,100,000 1,512,000 3,622,000 State 200,000 200,000 County 750,000 500,000 1,250,000 City MSA Funds 715,000 200,000 425,000 795,000 2,135,000 Street Oversize Funds 100,000 100,000 Water Quality Fund 100,000 50,000 150,000 300,000 Water Fund 100,000 100,000 100,000 300,000 Sanitary Improvement CIP15 150,000 150,000 Sewer Fund 150,000 150,000 Watermain Improvements CIP16 200,000 340,000 540,000 Water Fund 200,000 340,000 540,000 Water System CIP17 100,000 100,000 Water Storage Fund 100,000 100,000 Inflow /Infiltration Prevention CIP18 150,000 150,000 251,000 551,000 Sewer Fund 150,000 150,000 251,000 551,000 Page 2 of 4 CITY OF PRIOR LAKE PROJECTS BY DEPARTMENT CAPITAL IMPROVEMENT PROGRAM 2011 - 2015 CIP Project Reference 2011 2012 2013 2014 2015 Total Street Improvements (City) CIP19 1,950,000 3,080,000 1,825,000 3,720,000 10,575,000 Project Levy 840,000 1,180,000 900,000 2,000,000 4,920,000 Special Assessments 560,000 1,250,000 700,000 970,000 3,480,000 Trunk Reserve Funds 50,000 50,000 Water Quality Fund 50,000 100,000 50,000 50,000 250,000 Water Fund 250,000 250,000 125,000 450,000 1,075,000 Sewer Fund 250,000 250,000 50,000 250,000 800,000 Pressure Reducing Valves CIP20 80,000 80,000 Trunk Reserve Fund 80,000 80,000 Water Storage CIP21 1,500,000 1,500,000 Water Storage Fund 1,500,000 1,500,000 Public Works (Streets I Utilities) Total 5,750,000 3,750,000 5,550,000 3,895,000 3,823,000 22,768,000 Public Works (Water Resources) WQ System Maintenance and Retrofits CIP22 350,000 25,000 300,000 40,000 315,000 1,030,000 Water Quality Fund 350,000 25,000 300,000 40,000 315,000 1,030,000 Prior Lake Outlet Channel JPAlMOA CIP23 32,500 32,500 38,188 18,513 121,701 Water Quality Fund 32,500 32,500 38,188 18,513 121,701 Public Works (Water Resources) Total 350,000 57,500 332,500 78,188 333,513 1,151,701 Transit CMAO Grant Bus Purchase (City Share) CIP24 153,000 153,000 Transit Fund 153,000 153,000 Transit Total 153,000 153,000 GRAND TOTALS 6,239,500 4,087,500 6,525,500 4,178,188 4,411,513 25,442,201 Page 3 of 4 CITY OF PRIOR LAKE PROJECTS BY DEPARTMENT CAPITAL IMPROVEMENT PROGRAM 2011 - 2015 CIP Project Reference 2011 2012 2013 2014 2015 Total TOTALS BY FUNDING SOURCES Project Levy 1,750,000 1,280,000 2,000,000 2,000,000 1,512,000 8,542,000 SpecmlAssessmen~ 560,000 1,250,000 700,000 970,000 3,480,000 State 200,000 200,000 County 750,000 500,000 1,250,000 City MSA Funds 715,000 200,000 425,000 795,000 2,135,000 Capital Park Fund 24,500 125,000 110,000 10,000 10,000 279,500 Street Oversize Fund 100,000 100,000 Trunk ReseNe Funds 5,000 55,000 85,000 5,000 5,000 155,000 Water Quality Fund 510,000 157,500 432,500 128,188 483,513 1,711,701 Water Fund 1,275,000 330,000 305,000 570,000 560,000 3,040,000 Sewer Fund 440,000 440,000 240,000 305,000 306,000 1,731,000 Water Storage Fund 100,000 1.700,000 1,800,000 Transit Fund 153,000 153,000 General Fund-Park Operating 110,000 150,000 175,000 190,000 240,000 865,000 6,239,500 4,087,500 6,525,500 4,178,188 4,411,513 25,442,201 Page 4 of 4 CITY OF PRIOR LAKE 2011 - 2036 PARK EQUIPMENT REPLACEMENT PLAN General Fund - Parks Department Use of Funds: 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 202Z 2023 2024 2025 Z026 20Z7 2028 2029 2030 Z031 2032 2033 2034 2035 Workshop 04.05,2010 2036 Parks DeptTotal(l) $ 101,709 $ 148,653 $ 169,331 $ 182,536 $ 238,171 $ 223,318 $ 337,954 $ 256,466 $ 439,475 $ 1,444,108 $ 370,004 $ 1,021,454 $ 602,736 $ 1,067,726 $ 1,144,646 $ 453,392 $ 378,853 $ 606,199 $ 560,538 $ 1,898,928 $ 539,301 $ 473,803 $ 749,365 $ 677,628 $ 369,746 $ 836,518 $ Sources of Funds: Tax Levy<2) Referendum or Private Funding(3) Revolving Park Equip Fund Contribution, Total Source of Funds Change in Fund Balance, $ 8,291 Revolving Park Equipment Fund Use of Funds: Transfer to General Fund, $ Total Use of Funds Sources of Funds: Interest Earnings (2%) General Fund Contribution Tax Levy Total Source of Funds Change in Fund Balance 110,000 110,000 150,000 175,000 190,000 250,000 155,000 150,000 175,000 1,347 $ 5,669 $ 7.464 $ 1,829 $ Z6.682 $ 182,954 337,954 $ $ 10,858 165,000 91,466 256,466 $ 105,000 114,416 175,000 264.475 439,475 $ 9,416 110.000 119,875 $ $ $ 182,954 $ 91,466 $ 264.475 $ 182,954 91,466 264,475 185,000 1,060,000 199,108 1,444,108 $ 175,004 __ 370,004 205,000 215,000 700,000 240,000 n,116,4~4 .,_ 11I,l~13 1 ,U21 ,454 602,736 195,000 199,108 $ 175,004 $ 199,108 175,004 115,000 121,983 6,983 5,440 $ $ 225,000 950,000 (107,274) 1,067,726 $ 116,454 $ 147,736 $ {107,2741 $ 116,454 147,736 (107,274) 125,000 129,449 4,449 54,040 $ 55.121 $ 56.223 $ 57.348 $ 58.495 $ 59.665 $ (72,097) $ 22.950 $(144,600) $ (77.125) $ (49.5641 $ 12.996 $ (13.027) 130,000 134,709 4,040 50,000 5,121 50,000 240,000 190,000 250,000 100,000 110,858 9,875 120,000 125,440 4,709 4,448 54,040 55,121 240,000 $ 6,223 50,000 9,665 50,000 135,000 139,448 235,000 630,000 279,646 1,144,646 245,000 208,392 453,392 255,000 123,853 378,853 $ 265,000 230,000 111,199 606,199 $ 275,000 285,538 560,538 $ 279,646 $ 208,392 $ 123,853 $ 279,646 208,392 123,853 111.199 $ 285,538 $ 111,199 285,538 140,000 149,383 9,383 145,000 151,778 6,778 5,645 6,281 155,000 161,281 160,000 167,283 7,283 285,000 1,415,000 198,928 1,898,928 295,000 244,301 539,301 $ 305,000 168,803 473,803 $ 315,000 434,365 749,365 $ 325,000 352,628 677,628 $ 198,928 $ 244,301 $ 168,803 $ 434,365 $ 352,628 198,928 244,301 168,803 434,365 352,628 165,000 169,918 4,918 170,000 174,338 4,338 175,000 177,938 2,938 180,000 183,121 3,121 185,000 183,096 (1,904) 335,000 34,746 369,746 $ 34,746 $ 34,746 (5,295) 190,000 184,705 345,000 491,518 836,518 $ 491,518 $ 491,518 (2,295) 246,722 $ (130.2641 $ (56.615) $ 31.793 $ 50,082 $ (118,255) $ (29,010) $ (69.964) $ 9,135 $ (251.Z44) $(169.532) $ 149,960 $ (298.8131 $ 195,000 192,705 Beginning Fund Balance $ 202.000 $ 256.040 $ 311.161 $ 367.384 $ 424.73Z $ 483.226 $ 542,891 $ 470.794 $ 493.744 $ 349.144 $ 272.019 $ 222.455 $ 235.451 $ 222.4Z4 $ Ending Fund Balance $ Z56.040 $ 311.161 $ 367.384 $ 424.732 $ 483.226 $ 542.891 $ 470.794 $ 493.744 $ 349.144 $ 272.019 $ 222.455 $ 235,451 $ 2Z2,424 $ 469.146 $ Interest Rate Total Funding from Tax Levies: General Fund - Operating Budget General Fund - Contribution to RPEF Park Equipment Revolving Fund Debt Levy - Referendum 7,348 50,000 8,495 50,000 $ 110,000 $ 150,000 $ 175,000 $ 190,000 $ 240,000 $ 250,000 $ 155,000 $ 165,000 $ 175,000 $ $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ $ $ $ 100,000 105,000 110,000 56,223 58,495 59,665 Total $ 160.000 $ 200.000 $ 225,000 $ 240.000 $ 290.000 $ 300,000 $ 255,O()0 $ 270.000 57,348 (1) Includes costs for community parks as noted in "Community Park Referendum Needs," (2) Includes planned incremental increases per council discussion but at a lower amount due to lower projected needs. (3) Consider referendum or private funding for these improvements, LAKEFRONT .. Play Structure .. Hockey Rinks .. Parking I Roadway MEMORIAL .. Parking . - Plav Structure THE PONDS .. Play Structure .. Parking I Roadway SAND PT. BEACH - Concession . - Parkina I Roadw8'{ THOMAS RYAN MEMORIAL .. Ballfield Renovation .. Play Structure .. Parking WATZL'S BEACH - Concession Total Annual Costs $ 2011 $ 2012 2013 $ $ $ R\CIP\2011.2036 Park Equipment Replacement Plan 2014 2015 2016 $ $ $ $ $ _..!.. $ $ 2017 $ $--- 185,000 $ 195,000 $ 205,000 $ $ 115,000 120,000 125,000 1,060,000 700,000 $ 285.l!Q.Q...._Ll"~~Q,,Q!l.Q ,..$_315.000 $ 1,030,000 2018 $ ~. 2019 2020 545,000 515,000 $ l,060,OOQ $ 215,000 $ $ $ 130,000 240,000 $ 585,000 225,000 150,000 155,645 469.146 $ 338.882 $ 282.268 $ 314,060 $ 338.882 $ 282.268 $ 314.060 $ 364,143 $ 235,000 $ 245,000 $ 255,000 $ $ 145,000 150,000 265,000 $ $ 135,000 140,000 950,000 630,000 $ 1.310.000 $ 1,005.000 __ t 39.0,,0QQ. $ 405.000 $ 155,000 230,000 650,000 $ 2021 COMMUNITY PARK REFERENDUM NEEDS 2024 $ 2022 $ 700,000 2023 24U,000 $ $ 85,000 720,000 145,000 $ 700,000 $ 240.000 $ 950.000 2025 375,000 255,000 630,000 2026 2027 $ $ 2028 $ $ 230,000 $ 230.000 $ 364.143 $ 245.887 $ 275,000 $ $ 245.887 $ 216.878 $ 146,914 $ 156.049 $ (95.195) $ (264,7Z7) $ (114.767) 216.878 $ 146.914 $ 156,049 $ (95.195) $(264.727) $(114.767) $ (413.580) 285,000 $ 295,000 $ 305,000 $ 315,000 $ 325,000 $ 335,000 $ $ $ $ $ $ $ 170,000 175,000 180,000 185,000 190,000 160,000 165,000 1.415,000 435.000 $ 1,~65,OOO $ 465.000 $ 480.000 $ 495.000 $ 510.000 $ 525,000 $ 2029 2030 $ $ 875,000 540,000 $ 1.415.000 $ 2031 Z032 $ $ Z033 $ $ 2034 $ 2035 $ $ 345,000 $ 195,000 540,000 $ 2036 $ $ ZOll .. 2036 TOTAL 15.292.559 6.115.000 5.225.000 4,003.840 15.343,840 $ 51.282 4,003.840 4.003.840 138.260 300.000 2.950,000 , 3.388.260 (615,580) 6.115.000 300.000 2.950.000 5,ZZ5,OOO 14.590.000 TOTAL $ 375,000 875,000 85,000 255,000 240,000 720,000 545,000 145,000 515,000 230,000 540,000 700,000 $ 5.225.000 CITY OF PRIOR LAKE Workshop 04.05.2010 2011 - 2022 EQUIPMENT REPLACEMENT PLAN 2011 - 2022 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Totals Use of Funds: Fire Dept Total 90,000 44,885 28,646 0 0 35,940 73,617 1,000,000 36,681 0 550,000 0 1,859,768 Police Dept Total 73,500 75,000 76,500 78,000 109,500 106,000 82,500 84,000 103,500 87,000 88,500 90,000 1,054,000 Public Works Dept Total, 530.256 277.321 168,723 434,044 686.901 571,294 710.943 624,104 151,119 565,540 370,421 238,387 5.329.055 Total Use of Funds 693,756 397,206 273,869 512,044 796,401 713,234 867.060 1.708,104 291,300 652,540 1,008,921 328,387 8,242,822 Source of Funds: Interest Earnings (2%) 26,348 20,400 20,464 23,396 22,223 16,139 12,197 5,500 2,048 7,263 5,557 7,890 169,423 Annual Equipment Levy 270,000 280,000 290,000 320,000 350,000 380,000 390,000 400,000 410,000 420,000 430,000 440,000 4,380,000 Enterprise Fund Contribution 100,000 100.000 110,000 110,000 120,000 120,000 130,000 130,000 140,000 140,000 140,000 140,000 1,480,000 Bond Proceeds - Referendum 0 0 0 0 0 0 0 1.000.000 0 0 550,000 0 1,550,000 Total Source of Funds 396,348 400,400 420,464 453,396 492,223 516,139 532,197 1,535,500 552,048 567,263 1,125,557 587,890 7,579,423 Change in Fund Balance (297,408) 3.194 146,595 (58,648) (304,179) (197,095) (334,863) (172,604) 260,748 (85.277) 116,636 259,503 (663,399) Beginning Fund Balance 1,317.398 1,019,990 1,023,184 1,169.778 1 ,111 ,130 806.951 609.857 274.994 102,390 363,137 277,860 394,496 Ending Fund Balance 1,019,990 1,023,184 1,169,778 1.111,130 806,951 609,857 274,994 102.390 363.137 277,860 394,496 653,999 Original Levy - CIP 2010-2014 270,000 280,000 290,000 300,000 310,000 320,000 330,000 340,000 350,000 360,000 370,000 380,000 3,060,000 Revised Levy - 04/0512010 270,000 280,000 290,000 320,000 350,000 380,000 390,000 400,000 410,000 420,000 430,000 440,000 3,540,000 Change 0 0 0 20,000 40,000 60,000 60,000 60,000 60,000 60,000 60,000 60,000 480,000 $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 Equipment Replacernent Program Draft 04.05.2010 $0 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 .Fire Dept Total . Public Works Dept Total . Police Dept Total FIRE DEPARTMENT Workshop 04.05.2010 2011 .2022 EQUIPMENT INVENTORY Life Current Eauipment Descriptian Eauip # YEAR SERIAL # COST MILElHR Expt. Value 2011 2012 2013 2014 2015 2016 2017 2018 Z019 Z020 2021 2022 Zodiak Rescue Boat 9290 1991 XDC2453F $ 16,000 15 $ 36,700 $ 90,000 $ $ $ $ $ $ $ $ $ $ -Peterbilt Pumper 9220 1993 1XPBHA8X1PD332698 244,000 51,107 25 320,000 550,000 -Peterbilt Rescue 9215 1993 1XPBH78XXPD332699 218,000 41,470 25 300,000 450,000 -Peterbilt Pumper 9221 1996 1XPGHA8X7TN412503 204,085 25,374 25 320,000 550,000 Scally Trailer-Smoke House N/A 1997 1SSTT1PT2V11SS246 24,780 20 30,900 38,003 Ford F-350 Crew Cab 9270 2000 1 FTSW31 S3YEE27499 41,076 18,603 12 42,308 44,885 Polaris 500 6x6/A TV 9275 2000 4XALL50AZYD418369 8,000 48 15 25,000 Peterbilt Tanker 9260 2001 2NPNHZ8XX1 M498712 145,000 7,526 25 156,817 Ford F-350 9271 2001 1FTSX31S71ED79752 25,452 33,662 12 26,215 28,646 Ford Expedition 9200 2003 1FMPU16L83LB71121 25,390 102,842 12 26,151 Ford F-150 Super Cab 9201 2004 1 FTPW14544KD62092 29,223 59,331 12 30,099 35,940 Ford F-350 Super Cab 9202 2005 1 FTPW14595KE56227 28,957 44,767 12 28,957 35,613 Peterbuilt Pumper 9222 2007 2NPLHZ8X37M682390 319,890 13,255 25 319,890 Ford F-350 Super Cab 9272 2007 1 FTWX31Y28EB35023 23,074 10,981 12 28,113 36,681 E-One 100' Aerial 9280 2007 925,500 5,556 25 925,500 Peterbilt Heavy Rescue 9216 2009 2NPRHN8XXAM794324 424,366 3,125 25 424,366 NEW EQUIPMENT: Rescue Truck (Station #2) Totals $ 90,000 $ 44,885 $ 28,646 $ $ 35,940 $ 73,617 $ 1,000,000 $ 36,681 $ $ 550,000 $ .- Referendum Total 2011 - 2022 $ 1,859.768 9220 = $550,000 (2018) 9215 = $450,000 (2018) 9221 = $550,000 (2021) Research refurbishing options in 2010 Page 3 of7 PUBLIC WORKS DEPARTMENT Workshop 04.05.2010 2011 - 2022 EQUIPMENT INVENTORY 2010 Life Current Equipment Description Equip # YEAR SERIAL # Mileage/Hrs Expt. Value 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 DUMP TRUCKS Miles Sterling Dump (P,W,S) L8511 466 2000 2FZHDJBB5YAB04744 67,643 15 200,000 225,102 Sterling Dump (P,W,S) L8511 467 2000 2FZHDJBB7YAB04745 65,170 15 200,000 231,855 Sterling Dump (P,W,S) L8511 468 2001 2FZAAWAKX1AF83306 58,704 15 200,000 245,975 Sterling Dump (P,W,S) L8511 469 2001 2FZAAWAK11AF83307 57,437 15 200,000 238,810 Sterling Dump (P,W,S) L8511 518 2002 2FZAA WAK92AK06805 65,678 15 200,000 245,975 International Dump (P,W,S)(tandem) 465 2003 IHTWXJ\XT14J083646 61,236 15 207,400 278,728 Sterling Dump (P,W.S)(tandem) 519 2008 2FZHAZDE49AAE8498 13,368 15 207,400 PICK UPSNAN Chev. C1500 (1/2T) 540 1996 1 GCEC14M7TE246454 80,839 12 25,000 26,523 35,644 F350 Ford 4x4 (H) w/Plow1 457 1999 1 FTSF31 F6XED33327 101,093 12 57,000 66,079 F350 Ford 4x4 (H) Utility (crane) 756 1999 1 FDWF37F9XED33326 119,320 10 79,000 81,370 106,169 F350 Ford 4x4 (H)w/plow 543 1999 1FTSF31FXXEC10484 93,548 12 34,500 38,830 F350 Ford 4x4 (H)w/plow 544 1999 1 FTSF31 F3XEC26476 118,084 12 34,500 36,601 F350 Ford 4x4 (H)w/dump 545 1999 1 FDWF37F4XEE98166 72,653 12 59,000 66,405 F350 Ford 4x4 (H)w/dump/plo~ 546 1999 1 FDWF37F9XEE98163 75,391 12 59,000 70,449 F350 Ford 4x4 (H) Utility 750 2000 1 FDWF37S5YEE27427 94,900 10 76,700 106,171 3500 Dodge 4x4 w/dump/plow3 547 2001 BB6MF36W81 M575169 64,350 12 59,000 68,397 F350 Ford 4x4 w/plow4 451 2001 1FTSF31S51ED79753 85,795 10 59,800 61,594 82,777 F-550 Bucket truck 549 2002 1 FDAF56F22ED28193 26,013 20 91,200 130,029 F-350 Ford (H) w/plow 548 2003 1FTSF31F83EA38823 77,506 12 34,500 45,015 Chev 4x4 1/2 T 758 2004 1 GCEK19T94Z315464 66,152 10 25,000 28,982 F-550 w/plow 452 2005 1 FDAF57975ED-26435 36,090 12 57,000 70,103 Ford Ranger 508 2005 1 FTZR45E55-PA97395 47,468 10 18,500 21 ,447 Chev 4x4 1/2 T 541 2006 1 GCEK19Z16Z265893 32,965 10 25,000 31,669 F550 Ford 4x4 w/plow 459 2008 1FDAF57R18EE18372 13,233 12 57,000 76,603 F350 4x4 (club cab)w/plow 453 2009 1FT~31R69EA63787 9,056 12 42,400 58,692 F350 4x4 (4 door) 494 2009 1 FTWX31R39EA63789 8,930 12 33,200 45,957 F350 4x4 utility w/plow 762 2009 1 FTWF31R89EA63788 5,216 10 59,800 78,025 1 Replaced with F550 w/plow 2 New engine - body refurbished 3 New engine - body refurbished 4 Replaced w/utility box UTILITY EQUIPMENT Serco Extend-A-Jet 770 1990 EMSP-6-91101 455 20 57,900 63,269 Ford L8000 Tanker 521 1991 1 FDYK82A3MV A35699 45,950 15 144,400 172,421 Jet-Vac 784 2002 2FZHA T AK62AK46319 49,027 20 260,000 Portable 10" pump DNR 27977 -078 30 21 ,300 Valve Exerciser 763 2007 21984 20 56,775 JLG Electric Lift 551 2007 200152825 20 15,000 EMERGENCY POWER Cat 080-6 Towable 742 2007 D4B00613 72 15 39,000 55,605 Cat 80KW Towable 747 2006 D4P00357 358 15 39,000 53,985 Cat 200KW Towable (Booster Station) 777 1996 085Z13104 130 20 94,000 Cat 80KW Towable 776 1996 2021765 3,706 15 39,000 40,170 Cat 75KW Estate 778 2002 NPF01467 220 30 94,000 Cat 40KW Lime 749 2004 E4724B1/001 105 30 27,000 Cat 40KW Franklin Trl 748 2004 F5283A1/001 100 30 27,000 Cat 300KW (Wells 8 & 9) 746 2006 KPS01979 0 30 72,400 Page 10'3 PUBLIC WORKS DEPARTMENT Workshop 04.05.2010 2011 - 2022 EQUIPMENT INVENTORY 2010 Life Current Equiprnent Description Equip # YEAR SERIAL # Mileage/Hrs Expt. Value 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Cat 100KW Maint. Ctr 745 2006 N4E00311 16 30 36,000 Water Treatment Facility 744 2009 SXC02940 0 30 325,000 Onan 100EN FS #1 9211 1996 G940549015 346 30 35,000 FS #2 Cat Gen 9212 2008 N6D00424 17 30 35,000 PD Gen 9911 2007 46385148 639 60 35,000 City Hall Gen 9913 2008 N3C00696 70 30 28,000 TRAILERS Homemade Trailer 530 1986 DPSMN960962 12 7,219 9,145 Homemade Trailer 480 1988 12 7,300 Towmaster Trailer 479 1999 4KNUT2020XL 161258 12 10,500 10,815 JAA 22' Trailer 533 2000 00082264ROB 12 7,300 7,745 Towmaster Tandem Trailer 482 2004 4KNFZ19244L163143 12 7,900 9,433 Featherlite Trailer 761 2006 4U01ST9256A028847 12 5,980 7,575 Haulin Trailer 554 2006 5NHVHA0156W045768 12 4,000 5,067 Towmaster Trailer 531 2008 4KNUC18218L 162564 12 7,000 9,407 Towmaster Trailer 532 2007 4KNUC18288L 162562 12 7,000 9,407 LOADERS/SKID STEERS JCB Tractor Backhoe5 785 1995 SLPZ14TCSE0436049 4,084 13 115,000 118,450 Melroe Bobcat S185 w/broom 781 2004 525015713 2,717 6 55,000 58,350 69,672 Melroe Bobcat S250 w/blower 501 2006 530912105 2,686 6 60,000 60,000 73,792 Case Loader 721 E w/plow & wing 488 2007 N7F200557 1,049 14 127,403 Cat Loader 938G w/plow & wing 789 2001 00938GJGW502904 4,140 14 156,000 170,465 Cat 257B 502 2008 CA T0257BVSCK07556 1,127 6 35,315 39,747 47,460 5 Will be replaced w/used backhoe ~ Hammer Hoe (new) ~ Plate compactor (new) STREETS/SIDEWALKS Tymco Sweeper6 471 2007 1 HTMPAFN07H433838 14,143 15 158,500 Elgin Sweeper 472 2003 S9112D 3,082 14 147,000 180,791 Holder Sidewalk Plow 506 2009 4DB070947 251 14 80,000 101,342 40" Bituminous Mill 664 2000 231611255 12 25,000 26,523 Erskine Front Blower 665 2002 207600168 10 9,400 9,972 11,908 Directional Safety Sign 664 2003 1A9A5465522228069 20 28,800 Pavement router 454 2003 3112109081 500 20 25,800 Crack Seal Equip 473 2003 03-110-119 426 20 7,000 Stone AP4100 Roller 474 2009 72009191 15 23,400 Message Board for Utility Truck 128006 20 10,000 Box Broom 664 1996 714400101 15 6,200 6,386 6 Research restoration options ANTI-ICING EQUIPMENT Brine Production 2004 SB600 6 9,800 Critical Spot Sprayer 492 2004 15 6,320 8,246 Single Axle Slide-In 493 2007 15 12,000 17,109 Storage Tanks 2007 10 22,000 27,057 Slide-in Sander 455 2003 13839 10 11,900 13,003 Slide-in Sander 490 2006 123148 10 11,900 14,209 Liquid Anti-Ice Unit 495 2009 10 17,200 22,442 TURF CARE JR Turf Truckster Striper 535 1998 98002740 1,646 20 18,000 22,802 Cushman Field Groom w/atch 537 2003 LM21013 1 ,467 10 18,900 21,272 Cushman Truckster 538 2005 2300977 1,513 10 18,000 20,867 Kubota 539 2007 KRTV110071011057 581 10 20,000 24,597 Page 2 of 3 PUBLIC WORKS DEPARTMENT Workshop 04.05.2010 2011 - 2022 EQUIPMENT INVENTORY 2010 Life Current Equipment Description Equip # YEAR SERIAL # Mileage/Hrs Expt. Value 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Toro 5800 504 2001 210000239 4,967 10 77,200 79,516 72" 328D Toro ~iesel w/blower 523 2003 230000114 2,348 8 32,500 34,479 42,405 Case CX100 Tractor 507 2000 C100AS4JJE1014819 3,193 11 48,000 52,451 Seed-A-Vator 665 2000 4 8 10,600 12,657 Aerator AE80 665 1998 445 10 9,700 9,991 Goosen Rake-N-Vac 665 1992 RVT#I-12000 15 17,500 19,696 Sovema Tiller 665 1993 15 7,200 Millcreek Top Dresser 665 1995 21934 10 7,100 7,991 Ditch Mower 665 2006 RBF-1295 15 16,500 22,840 Toro 57000 Sprayer 536 2004 24000016 1,182 10 25,500 32,303 Jacobson HR 9016 503 2008 705291855 810 10 68,400 86,647 Jacobson Turf Cat 524 2008 628-0T 870 8 27,900 33,314 Toro 325D 525 2009 290000139 503 8 27,900 34,313 Tore 3250 526 2009 280000303 435 8 27,900 34,313 John Deere 5525 Tractor 505 2009 LV5525H456371 631 11 28,100 37,764 TREE CARE Vermeer 1250A Chipper 510 1999 1VRN1416XW1007408 1,820 13 28,400 30,130 Rayco Stump Grinder 550 2007 1 R91209127M210026 75 15 17,000 Tree Spade 509 2008 NOVAK 20 39,700 Aerovator Seeder 512 2008 29 15 6,500 BUILDING DEPARTMENT Ford Crown Victoria? 205 2005 2FAHP71W95X166042 69,676 15 12,000 Ford Focus 398 2009 1 FAHP34N09W259206 5,964 10 15,000 ENGINEERING DEPARTMENT Suburban8 399 1999 1GNFK16R6XJ351846 46,036 15 38,000 25,000 Ford Crown Victoria9 405 2005 2FAHP71W75X166041 96,077 10 12,000 REFURBISHING 10,000 15,000 15,000 15,000 20,000 20,000 20,000 FUTURE ADDITIONS Used 1/2 Ton Pick Up (Parks) 10 20,000 Stainless slide-in sander 10 11,900 13,795 Hot patch unit (cost share w/SMSC) trade in existing unit 10 26,000 26,780 Slide in anti-deice liquid slide in (1850 gal) 10 12,800 13,184 Totals $ 530,256 $ 277,321 $168,723 $434,044 $ 686,901 $ 571,294 $ 710,943 $ 624,104 $ 151,119 $ 565,540 $ 370,421 $ 238,387 ? Will be replaced with used economy car 8 Will be replaced with a 1/2 ton pickup 9 Will be replaced with used economy car Total 2011 - 2022 $ 5,329,055 Page 30f3 CITY OF PRIOR LAKE Workshop 04.05.2010 2011 - 2020 SEWER PLAN 2011-2020 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Totals Use of Funds: Operations & Maintenance $ 978,500 $ 1,007,855 $ 1,038,091 $ 1,069,233 $ 1,101,310 $ 1,134,350 $ 1,168,380 $ 1,203,432 $ 1,239,535 $ 1,276,721 11,217,406 MCES Fees 1,252,681 1,321,407 1,397,846 1,481,473 1,523,133 1,565,918 1,609,856 1,654,980 1,701,318 1,748,905 15,257,518 Capital Improvement Projects 440,000 440,000 240,000 305,000 306,000 315,180 324,635 334,374 344,406 354,738 3,404,333 Interfund Transfer 212,688 218,005 223,455 229,041 234,767 240,636 246,652 252,819 259,139 265,618 2,382,819 Existing Debt Service 92.685 96,794 92.696 89,038 371,213 Total Use of Funds 2,976,554 3,084,061 2,992,088 3,173,786 3,165,211 3,256,084 3,349,524 3,445,604 3,544,398 3,645,981 32,633,290 Source of Funds: lastewater Collection Revenue 2,367,621 2,381,072 2,394,522 2.407,972 2.421.422 2.434.873 2.448.323 2.461,773 2,475.224 2,488.674 24,281.476 Total Source of Funds 2,367,621 2.381,072 2,394,522 2,407,972 2,421,422 2,434,873 2,448,323 2,461,773 2,475,224 2,488,674 24,281,476 Change in Fund Balance $ (608,933) $ (702,989) $ (597,566) $ (765.814) $ (743,788) $ (821,211 ) $ (901,201 ) $ (983.831\ $ (1.069,174) $ (1,157.307) $ (8,351,814) Beginning Fund Balance $ 2,112,498 $ 1,503,565 $ 800,576 $ 203,010 $ (562,804) $ (1,306,592) $ (2,127,803) $ (3,029,005) $ (4,012,836) $ (5,082,010) Ending Fund Balance $ 1,503,565 $ 800,576 $ 203,010 $ (562,804) $ (1,306,592) $ (2,127,803) $ (3,029,005) $ (4,012,836) $ (5,082,010) $ (6,239,317) City of Prior Lake 2010-2020 Transportation Plan Year . Improvement 2010 CR421McKenna Road Signal $ 2010 Resurfacing Program (Shady,Rustic,Lords) 2010 CR 21/Arcadia Intersection - Design & ROW 2010 CR 12 Phase 111 2010 CR 21 fCR 42-North) 2nd Phase 2010 Project Totals $ 2011 BoudinsfTimothy/Denise/Lois/Natalie $ 2011 CR 21/Arcadia Intersection 2011 Project Totals $ 2012 Industrial Park (Rural Street Restoration) $ 2012 RutgerslWatersedge/Grayling 2012 CR21/Fountain Hills SiQnal 2012 Proiect Totals $ 2013 Main Ave/TH 13/Ridgemont $ 2013 Martindale/Carriage Hills Resurfacing 2013 Mushtown/Maple/Panama 2013 Project Totals $ 2014 Franklin Trail Resurfacing (CR 44 to Summer) $ 2014 Eau Claire/Hi9hland/Marsh/Skvline 2014 Proiect Totals $ 2015 CR 21/Main Ave/Pleasant $ 2015 CR 83 Coop AQreement Pavment 2015 Project Totals $ 2016 City Street Reconstruction $ 2016 CR 12 Phase IV 2016 TH 13/15oth Street 2016 Project Totals $ 2017 CR 42/TH 13 $ 2017 Citv Street Reconstruction 2017 Project Totals $ 2018 City Street Reconstruction $ 2018 City Street Reconstruction 2018 ProJect Totals $ 2019 City Street Reconstruction $ 2019 ResurfacinQ ProQram (50% State Aid SO 2019 Proiect Totals $ 2020 City Street Reconstruction $ 2020 pro'iect Totals $ MSA 40,000 $ 350,000 75,000 465,000 $ 715,000 715,000 $ 200,000 200.000 $ 425,000 $ 425,000 $ 795,000 $ 795,000 $ 300,000 500,000 800,000 $ 200,000 $ 200,000 $ 400,000 400,000 $ Street Oversizin!l 250,000 100,000 350,000 $ $ 100,000 100,000 $ $ $ $ $ 150,000 150,000 $ $ $ $ $ $ Tax Levv $ 50,000 583,066 213,000 55.000 901,066 $ 840,000 910,000 1,750,000 $ 200,000 980,000 100,000 1,280,000 $ $ 1,100,000 300,000 600,000 2.000,000 $ $ 300,000 1,700.000 2,000,000 $ $ 1,455,000 57,000 1,512,000 $ $ 1,300,000 350,000 1,000,000 2,650.000 $ 1,000,000 1,000,000 2,000,000 $ $ $ 1,000,000 750,000 1,750,000 $ 1.200,000 400.000 1.600,000 $ $ $ 2.100,000 2,100,000 Program Totals $ 4,000,000 $ 600,000 $ 19,543,066 Bond Type Recon $ Recon Recen 429 Recon Recon $ Recon 429 $ 429 Recon Recon $ Recon 429 Recon $ 429 Recon $ 429 429 $ 429 Recon Recon $ 429 429 $ 729 429 $ Recon 429 $ $ Assessments 300.000 $ 300,000 $ Utility Fund $ 113.060 751,150 864,210 $ 500,000 $ 100,000 600,000 $ 500,000 500,000 $ $ 100,000 $ 50,000 125.000 275,000 $ Water Quality $ 72,823 50,000 122,823 $ 50.000 $ 100.000 150,000 $ $ 50,000 $ 50,000 Trunk Fund $ 395,000 395,000 $ 50,000 $ 50,000 $ $ Workshop 04.05.2010 County/ State/Other $ 157,000 $ 100,000 Total City Cost 247,000 796,126 250,000 1,686,973 675.000 3,655,099 $ 1,950,000 2,675,000 4,625,000 560,000 $ $ 560,000 $ 600,000 $ 650,000 $ 1,250,000 $ $ 100,000 $ 600,000 700,000 , $ 100,000 $ 50,000 $ 50,000 100,000 $ 50,000 50.000 $ 150,000 $ 150,000 $ 55,000 $ 30,000 55,000 140,000 $ 55,000 $ 55,000 110,000 $ 55,000 $ 55,000 110,000 $ 55,000 $ 55,000 $ 120,000 $ 120,000 $ 257,000 $ $ $ 750.000 750,000 $ $ 900.000 2,180,000 300.000 3,380,000 $ 700,000 700,000 $ $ 970.000 970.000 $ $ 100,000 $ $ 200,000 $ $ 1.875.000 350,000 1.475.000 3,700,000 $ $ 400,000 3.320,000 3.720.000 $ 740,000 $ 360,000 $ 1,100,000 $ $ 600,000 600,000 $ $ 100,000 $ $ 200,000 $ 3,000,000 S7,000 3,057,000 , $ 2,645,000 1.540,000 1,855,000 6,040,000 ' $ 500,000 $ 500,000 1,000,000 $ 680,000 $ $ 680,000 $ 550,000 $ 500,000 150,000 1,200,000 $ $ 100,000 $ 350.000 450,000 $ $ $ $ 500,000 $ $ $ $ 1,355,000 2.005,000 3,360,000 840,000 $ 840,000 $ R:\CIP\CIP2011-2020 TP Workshop 2010,04.05 350,000 $ 350,000 700,000 $ 400,000 $ 100,000 500.000 $ 900,000 $ 900,000 $ $ 500,000 $ $ 1.905,000 1.655,000 3,560,000 $ $ $ $ $ $ $ $ $ $ $ $ $ 2,335,000 900,000 3,235,000 $ $ 3,960,000 3,960,000. $ 8,000,000 $ 6,789,210 $ 1,207,823 $ 445,000 $ 1,707,000 $ 42,292,099 CITY OF PRIOR LAKE Workshop 04.05.2010 2011 - 2020 WATER PLAN 2011-2020 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Totals Use of Funds: Operations & Maintenance $ 1,667,570 $ 1,717,597 $ 1,769,125 $ 1,822,199 $ 1,876,865 $ 1,933,171 $ 1,991,166 $ 2,050,901 $ 2,112,428 $ 2,175,801 19,116,821 Capital Projects 1,275,000 330,000 305,000 570,000 560,000 500,000 515,000 530,450 546,364 562,754 5,694,568 Interfund Transfer 211,650 215,883 220,201 224,605 229,097 233,679 238,352 243,119 247,982 252,941 2,317,508 Existing Debt Service 560,599 574,308 589,483 810,552 733,514 744.714 755,114 764,714 773,514 786.514 7,093,026 Total Use of Funds 3,714,819 2,837,788 2,883,809 3,427,355 3,399,475 3,411,563 3,499,632 3,589,184 3,680,287 3,778,010 34,221,924 Source of Funds: Water Usage Charge 2,484.867 2,499,452 2,514,037 2,528,622 2,543,206 2,557.791 2,572.376 2,586,961 2,601.546 2,616,130 25,504,989 Total Source of Funds 2,484.867 2,499,452 2,514,037 2,528,622 2,543,206 2,557,791 2,572,376 2,586,961 2,601,546 2,616,130 25,504,989 Change in Fund Balance $ (1,229.952) $ (338,336) $ (369,772) $ (898,734) $ (856,269) $ (853.772) $ (927,256) $ (1,002,223) $ (1,078.741) $ (1,161.880) $ (8,716,935) Beginning Fund Balance $ 2,720,303 $ 1,490,351 $ 1,152,015 $ 782,243 $ (116,490) $ (972,759) $ (1,826,532) $ (2,753,788) $ (3,756,011 ) $ (4,834,752) Ending Fund Balance $ 1,490,351 $ 1,152,015 $ 782,243 $ (116,490) $ (972,759) $ (1,826,532) $ (2,753,788) $ (3,756,011) $ (4,834,752) $ (5,996,632) CITY OF PRIOR LAKE Workshop 04.05.2010 2011 - 2020 WATER QUALITY PLAN 2011-2020 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Totals Use of Funds: Operations & Maintenance $ 265,152 $ 273,847 $ 279,391 $ 293,834 $ 300,640 $ 307,161 $ 313,840 $ 320,682 $ 327,691 $ 334,872 $ 3,017,111 Capital Projects 510.000 157,500 432,500 128.188 483.513 214,049 409,584 200.120 370,655 211,191 3.117,298 Total Use of Funds 775,152 431,347 711,891 422,022 784,153 521,210 723,424 520,801 698,346 546,063 6,134,409 Source of Funds: Interest Earnings (2%) 11,543 5,229 5,759 784 1,603 (4,707) (5,786) (10,832) (11,825) (16,287) (24,520) Charges for Services 427,911 432,618 437,377 442,188 447,052 451,969 456,941 461,967 467,049 472,187 4,497,258 Grants 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 200,000 Bond Proceeds - Referendum 0 0 0 0 0 0 0 0 0 0 0 Total Source of Funds 459,454 457,847 463,135 462,971 468,655 467,262 471,155 471,136 475,224 475,899 4,672,738 Change in Fund Balance $ (315,698) $ 26,499 $ (248,756) $ 40,950 $ (315,499) $ (53,947) $ (252,269) $ (49,665) $ (223,122) $ (70,163) $ (1,461,671) Beginning Fund Balance $ 577,141 $ 261,443 $ 287,942 $ 39,186 $ 80,136 $ (235,363) $ (289,310) $ (541,579) $ (591,245) $ (814,366) Ending Fund Balance $ 261 ,443 $ 287,942 $ 39,186 $ 80,136 $ (235,363) $ (289,310) $ (541,579) $ (591,245) $ (814,366) $ (884,529)