The URL can be used to link to this page

Home My WebLink AboutJuly 25, 2016 201 Annual Budget Operating Budget 201 – 202 Capital Improvement Program Capital Improvements are theprojects thatrequire the expenditureof public fundsfor the acquisition, construction or replacement of the infrastructurenecessary for communities. Capital planning is critical to continuation of essential public services, aswellasbeing an important componentofa community’s economic development program. Thecreation andupdateof multi-year capital plan allowsfor the community toplanfor the current and longererm needsof the constituents. Thisplanis often integrated with the maintenance needs and funding sources that will providefor the delivery of servicestoa community. Capital projects are different from the operating budgets of a City, as they often represent large financial obligations that may span more than one year. The unique nature of capital projects allows for a different presentation to the governing board, than the process used for operational budget discussions. The information and tracking needs of projects requires an adequate system of management, to ensure the impact to the capital plan, as well as the operational budgets. The development of a capital improvement plan is prepared with the following elements: Identification of needs, utilizing strategic plans, comprehensive plans as well as input from citizens, staff and Council. Determination of the projects specific to repair, maintenance, replacement or new construction. Recognition of the revenue sources that will be utilized to fund the planned projects Need for debt issuance for future needs Identification of the need for policy updates or creation It is critical that the full cost of the projects be developed as well as the timing and coordination of the project with other entities, both public and private. The planning process that brings all the impacted parties into play will result in a program that can clearly detail not only the original construction costs, but future year maintenance and operational costs. With this information as a base, the future year plans as well as affordability of the projects can be evaluated, based on more consistent and reliable information, establishing a strong and consistent Capital Improvement Program. Theplan for the City of Shakopee lists theprojects scheduledfor the upcoming5 years, and details the activities for the Capital Funds, includingPark Funds, aswell as theSanitary and SurfaceWater Enterprisefunds. CIP is preparedby the City staffItis then submittedto the CityCouncil for approval, as the 5-year programis utilized by stafffor the long range planning and budgetneeds of the City. 201 Annual Budget Operating Budget Park Reserve Fund Description of Service: The park reserve provides for the acquisition and improvements on City Parks. These services are overseen by the Park and Recreation Director with the help of other staff as required. Goals: 1.Provide public gathering spaces and facilities. CITY OF SHAKOPEE 2017 BUDGET PARK RESERVE FUND 20162016 20142015OriginalRevised2017 ActualBudgetBudgetBudget Actual Revenue Licenses & Permits Park Dedication Fee$ 752,552$ 934,456$ 2,018,028$ 1,300,000$ 1,500,000 Intergovernmental Federal Grant 2,645 150,000- 150,000 - Miscellaneous 2,679 3,430 - - - Interest 33,508 24,708 5,000 5,000 - Contributions 20,000 290,000- 390,000 610,000 Total Revenues 811,384 962,594 2,463,028 1,845,000 2,110,000 Expenditures Riverside Fields/Bluffs 26,631 31 - - - Huber Park 68,301 71,605 - - - Quarry Lake Phase 1 (Park) 31,023 303,224 1,790,000 1,790,000 - Quarry Lake Phase 2 (Trails) - - - 2,000,000- Quarry Lake Phase 3 (Building) - - - 2,200,000- Southbridge Community Park 934,026 170,983 - - - High School Joint Site Development - 600,000- - - Riverview Park - 75,000- - - Tahpah Park Improvements 300,520- - - - Total Expenditures 1,059,981 846,363 2,465,000 1,790,000 4,200,000 Interfund Loan - - --- Transfer In 150,000- - - - Transfer Out (513,995)- - - - Other Financing Sources (Uses) (363,995)- - - - Excess (deficiency) of Sources over Uses $ (248,597)$ (247,764)$ (1,972)$ 55,000$ (2,090,000) Fund Balance- January 1 $ 1,877,028$ 1,628,431$ 1,380,667$ 1,380,667$ 1,360,667 Reserved for Delayed Projects - - (75,000)- - Fund Balance December 31 $ 1,628,431$ 1,380,667$ 1,378,695$ 1,360,667$ (729,333) Delayed Projects: Riverview Park 75,000 Park Reserve Fund Projected Fund Levels 2017-2021 Capital Improvement Program REVENUES:20172018201920202021Unfunded Park Dedication Fees$ 1,500,000$1,700,000$ 500,000 $ 500,000$ 500,000$ - Grants - - - - - 1,900,000 Donations/Misc. 600,000 100,000 150,000 100,000 100,000 500,000 Cost Sharing 10,000 10,000 10,000 10,000 10,000 - Interest - - - - - - Total Revenue 2,110,000 1,810,000 660,000 610,000 610,000 2,400,000 EXPENDITURES: Expenditures per List CIF Huber Park Improvement - - 75,000 - - 2,400,000 Quarry Lake Phase 2 (Trails)2,000,000 - - - - - Quarry Lake Phase 3 (Building)2,200,000 - - - - - Quarry Lake Phase 4 - - - - - 2,000,000 Tahpah Park Improvements - - 300,000 - - - Jennifer Lane Park- 250,000 - - - - Total Expenditures 4,200,000 250,000 375,000 - - 4,400,000 Excess (Deficiency) (2,090,000) 1,560,000 285,000 610,000 610,000(2,000,000) Transfer Out to CIF Southbridge Trail Development- (75,000)- - - - TH 169 Pedestrian Bridge - - -(500,000) - - Fund Balance January 1* 1,360,667 (729,333) 830,667 1,040,667 1,150,667 1,760,667 Fund Balance December 31 $ (729,333)$1,040,667$ (239,333) $ 830,667$ 1,150,667$ 1,760,667 * Balance equals cash balance per cash flow projection with project carry forward. City of Shakopee Capital Improvement Program Project ManagerProject Title: Jamie PolleyQuarry Lake ParkTotal Project Cost:6,200,000 A. Expenditure Items:20172018201920202021Unfunded Land & ROW Construction2,000,0002,000,000 Improvements2,200,000 Engineering/Admin. Total4,200,000----2,000,000 SFunding Source: B. General Fund Capital Improvement Funds1,500,000 Park Reserve Fund3,700,000 Grants (specify) Donations (specify)500,000500,000 State Aid Sanitary Sewer Fund-Base Sanitary Sewer Fund-Flow Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total -4,200,000 - - - 2,000,000 Description This project would provide funding for construction of the restored Aggregate Industries quarry site. Justification This project would develop the facility as recreational amenity for the city. If possible, work would be coordinated with the Watershed District's plans for channel improvements. Other Comments Funding sources include grants and partnerships with committee members. $30,000 Xcel grant, $10,000 Polaris grant in 2006. $150,000DNR grant in 2014. All costs listed are estimates. Due to the inability to obtain public access the grants received in 2005 and 2006 had to be returned. With publicaccess additional grants will be sought by the City and the Waterski Association. $500,000 possible donation from Emerson for the Community Building Operating Costs Costs would depend on scope of development. City of Shakopee Capital Improvement Program Project ManagerProject Title: Jamie PolleyJennifer Lane Neighborhood ParkTotal Project Cost:250,000 A. Expenditure Items:20172018201920202021Unfunded Land & ROW Construction Improvements250,000 Engineering/Admin. Total-250,000---- SFunding Source: B. General Fund Capital Improvement Funds Park Reserve Fund250,000 Grants (specify) Donations (specify) State Aid Sanitary Sewer Fund-Base Sanitary Sewer Fund-Flow Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total 250,000- - - - - Description Futureneighborhood Park off of Jennifer Lane. It is anticipated to get land from the 1st and 2nd developments of Jennifer Lane. Justification Landis obtained from the development. Funding to buildi the park would be from the Park Reserve Fund. Operating Costs The estimated operating costs for asmall neighborhood park is approximately $2500/year. City of Shakopee Capital Improvement Program Project ManagerProject Title: Jamie PolleyHuber Park Improvements; Shelter & Riverbank Total Project Cost:2,475,000 Stabilization A. Expenditure Items:20172018201920202021Unfunded Land & ROW Construction2,400,000 Improvements75,000 Engineering/Admin. Total--75,000--2,400,000 B. Funding Source: General Fund Capital Improvement Funds Park Reserve Fund75,000500,000 Grants (specify)1,900,000 Donations (specify) State Aid Sanitary Sewer Fund-Base Sanitary Sewer Fund-Flow Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total--75,000--2,400,000 Description The addition of a 38' X 50'openair shelter within Huber Park will be used for community rentals and special events. A small shelter is planned for 2019 for daily use. Stabilization of river bank along Huber Park. Shelter design took place in 2013 for $1100, City Council chose to construct the shelter utilizing the $150,000 grant from the SMSC. Construction in 2014. The shelter will resemble the performance stage and support building, Beyond2017-RiverbankStabilization Justification This project addsan addition seasonal rental facility. The small shelter will be built in the NE corner of the playground where the area is pad ready and planned for a small shelter. It also completes the redevelopment of Huber Park by stabilizing the river bank, constructing river overlooks, and reconstructing trail segments. Operating Costs $500year. City of Shakopee Capital Improvement Program Project ManagerProject Title: Jamie PolleyTahpah Park ImprovementsTotal Project Cost:700,000 A. Expenditure Items:20172018201920202021Unfunded Land & ROW Construction400,000 Improvements300,000 Engineering/Admin. Total--300,000--400,000 SFunding Source: B. General Fund Capital Improvement Funds Park Reserve Fund150,000 250,000 Grants (specify)100,000 Donations (specify)150,000 50,000 State Aid Sanitary Sewer Fund-Base Sanitary Sewer Fund-Flow Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total -- 300,000 - - 400,000 Description FutureUnfunded-Baseball field Construction on open fieldto west of stadium, City will apply for a grant from Baseball of America in the amount of $100,000. (Anticipates donation of labor or in house labor for some work.) Justification This project would complete development of Tahpah Park with an additional baseball field in 2016. Other Comments The project for 2016 is contingent onthe joint development of the HS site for grass turf fields. The Parks Department will be extending the outfield fences of fields 5-8 concurrently with the lighting project. Operating Costs The estimated operating costs for additional baseball field is approximately $2,000 per year. Lighting two softball fields with lights would add $800 per year for operating 4 nights per week. 201 Annual Budget Operating Budget Capital Improvement Fund Description of Service: The Capital Improvement Fund is for various infrastructure projects in the City. These services are overseen by the Public Works Director/City Engineer with the help of other staff as required. Goals: 1.Provide improvements to roads and trails. 2.Address needs of the community through planning processes. CITY OF SHAKOPEE, MINNESOTA 2017 BUDGET CAPITAL IMPROVEMENT FUND 20162016 20142015OriginalFinal2017 ActualActualBudgetBudgetBudget Revenue Capital Improvement Fund Levy-$$ -$ -$ 385,000-$ Tax Increment Financing ($2.3M over 9 years)-- 255,556255,600255,600 Franchise Fees-- - 915,000- Special Assessments2,124,944635,0551,070,0001,070,0002,425,000 Intergovernmental Federal Grants1,101,600- - - - State Aid Construction879,6981,070,397971,000971,0001,025,000 SMSC50,000- - - - Interest100,39683,13757,95154,60061,300 Miscellaneous/Donations40,74027,210440,000440,000580,000 Total Revenues4,297,3781,815,7992,794,5072,791,2005,646,900 Expenditures CR 101 Trail ext.343,935- - - - 101 Trail Improvement1,892- -- - Quarry Lake Trail166,3891,600- - - Scenic Heights Trail Repair15,416- - - - Overlay1,161,570817,6151,420,0001,420,0002,020,000 Valley View Road530,460(47,095)- - - Re construction Project1,226,9971,255,764 2,400,000- - CSAH 17/Vierling Inter. Improv.1,809,7326,588- - - Shenandoah Bus. Park. Improv.693,42263,959- - - Vierling Dr- C.R. 69 to Taylor Street- 1,500,000- - - Trail Rehabilitation-- 80,00080,00080,000 Southbridge Traffic Signal Modification 65,126-- - - Reclamation 5,083- 4,380,0004,380,000- CSAH 16 Reconstruction-- 1,500,0001,500,000- 3rd Avenue Reconstruction-- 2,070,0002,070,000- 4th Avenue Reconstruction 75,969-- - - Street Lighting45,236- 250,000250,000- Vierling Drive Payvement Rehab 2,231-- - - Flashing Yellow Lights-County- 105,000- - - CSAH 78/79 Trail Extension- 120,000- - - 17th Avenue Extension West of CR 15- 625,000- - - Lewis Street Parking Lot & Alley- 430,000- - - - CR 79/Vierling Roundabout86,631 - - - County Trail Work50,406- -- - Miscellaneous8,119144,683- - - Total Expenditures6,140,2052,391,5239,700,0009,700,0007,280,000 Transfers In General Fund1,750,0001,396,8221,200,0001,200,000- Sewer-- 310,000310,000370,000 Storm-- 1,735,0001,735,000190,000 Transfers Out(30,664)(321,082)- - - Other Financing Sources (Uses)1,719,3361,075,7403,245,0003,245,000560,000 Excess (deficiency) of Sources over Uses $(123,491)$500,016$(3,660,493)$(3,663,800)$(1,073,100) Fund Balance January 1 $5,753,669$5,630,178$6,130,194$6,130,194$2,386,394 Reserved for Delayed Projects (80,000) Fund Balance 12/31 5,630,1786,130,1942,469,7012,386,3941,313,294 Reserved for Delayed Projects Trail Rehabilitation80,000 Vierling CR 69 to Taylor1,300,000 Vierling CR 69 to Taylor (100% Assessed)(1,300,000) 2015 Delayed Projects 80,000 Capital Improvement Fund Projected Fund Levels 2017-2021 Capital Improvement Program City of Shakopee, Minnesota REVENUES:20172018201920202021Unfunded Capital Improvement Fund Levy385,000 485,000 555,000 655,000 630,000 - Franchise Fees915,000 915,000 945,000 945,000 970,000 - Special Assessments2,425,000 565,000 190,000 100,000 - - County Portion of Project - - 3,000,000- - - TIF (2.3M over 9 years) 255,600 255,600 255,600 255,600 255,600 - Intergovernmental MSA 1,025,000 1,025,000 1,025,000 1,025,000 1,025,000 - SPUC Portion of Project 580,000 640,000 130,000 20,000 25,000 - Federal/MnDOT Funding - - 2,000,000- -1,500,000 Interest 61,300 23,900 13,100 10,500 7,300 - Total Revenue 5,646,900 3,909,500 3,113,700 8,011,100 2,912,900 1,500,000 EXPENDITURES: Expenditures per List CIF Overlay 2,020,000 1,890,000 2,290,000 1,160,000 1,980,000 - Reconstruction Projects 2,400,000 2,740,000 910,000 270,000- - Trail Rehabilitation 80,000 80,000 80,000 80,000 80,000 - - - Flashing Yellow Lights-County 105,000 -- - CSAH 78/79 Trail Extension 120,000 - - - - - 17th Avenue Extension West of CR 15 625,000 - - - - - Lewis Street Parking Lot & Alley 430,000 - - - - - Concrete Alleys - 420,000 - - - - 12th Avenue Trail - - 240,000 - - - l - - 150,000 - Savanna Oaks Park to Southbridge Parkway Trai - - Vierling CR 69 to Taylor 1,500,000 - - - - - TH 169 Pedestrian Bridget - - 3,000,000- - - Reclamation - - - 400,000 - - CSAH 42 Improvments - - 1,200,000- - - CSAH 83 Intersection - - 4,000,000- - - CR 15 Interchange & Trail Improvements - - - - -2,500,000 CR 79 Pedestrian Underpass - - - - -125,000 CSAH 16 Trail Extension - - - - -100,000 Total Expenditures 7,280,000 5,130,000 3,670,000 9,840,000 2,330,000 2,725,000 OTHER FINANCING SOURCE Transfers In Park Reserve Fund - - 75,000 500,000 - - Sewer 370,000 420,000 60,000 10,000 15,000 - Storm 190,000 535,000 100,000 1,020,000 50,000 - Total Other Financing Source 560,000 955,000 235,000 1,530,000 65,000 - (321,300) (298,900) 647,900 (1,225,000) Excess (Deficiency) (1,073,100)(265,500) Fund Balance January 12,386,3941,313,2941,047,794726,494 427,5941,075,494 Fund Balance 12/31$1,313,294$1,047,794$726,494$427,594$ 1,075,494$(149,506) City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyFlashing Yellow Lights-County $105,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction Improvements Engineering/Admin.105,000 Total105,000----- B. Funding Source: General Fund Capital Improvement Fund105,000 Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total105,000----- Description: Retrofit of Traffic Control Signals in Scott County Justification: To Upgrade signals to flashing yellow arrows to various intersections Other Comments: City cost is estimated at $105,000.00 per Scott County. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet improvementsTrail Rehabilitation$400,000.00 A. Expenditure Items:20172018201920202021FUTURE Land & ROW АЎͲЉЉЉАЎͲЉЉЉАЎͲЉЉЉ Construction 75,00075,000 Improvements Engineering/Admin.5,000 5,000 5,000 5,000 5,000 Total80,000 80,000 80,000 80,000 80,000 - B. Funding Source: S General Fund Capital Improvement Fund80,000 80,000 80,000 80,000 80,000 Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total80,00080,00080,00080,00080,000- Description: Rehab existing trails in the city. Justification: Other Comments: Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet improvementsC.R. 78/79 TRAIL EXTENSION$120,000.00 A. Expenditure Items:20172018201920202021FUTURE Land & ROW ЊЉЉͲЉЉЉ Construction Improvements Engineering/Admin.20,000 Total120,000 - - - - - B. Funding Source: S General Fund Capital Improvement Fund120,000 Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total120,000----- Description: Extension of a bituminous trail on the North side of CSAH 78 from CSAH 17 to CSAH 79 and on the East side of CSAH 79 from CSAH 78 to CSAH 16. Justification: Other Comments: This is a County led project. Costs above are estimated City costs only and approximately half of local match on a Federal funded project. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet Construction2017 Bituminous Overlay$2,020,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction1,870,000 Improvements Engineering/Admin.150,000 Total2,020,000----- B. Funding Source: General Fund Capital Improvement Fund1,920,000 Park Reserve Fund Grants (specify) Donations (specify) SPU30,000 State Aid Assessments Sanitary Sewer Fund-Base20,000 Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk50,000 Tax Levy Total2,020,000----- Description: Bituminous overlay of various streets throughout the City. Justification: Continuation of the City's Pavement Preservation Program to maintain existing infrastructure. Other Comments: Bituminous overlays are more cost effective than reconstructing pavements. Streets will be evaluated on a yearly basis and may be moved up or moved back in the CIP. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet Construction2017 Street Reconstruction$2,400,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction2,100,000 Improvements Engineering/Admin.300,000 Total2,400,000----- B. Funding Source: General Fund Capital Improvement Fund1,020,000 Park Reserve Fund Grants (specify) Donations (specify) SPU550,000 State Aid Assessments340,000 Sanitary Sewer Fund-Base350,000 Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base140,000 Storm Drainage Fund-Trunk Tax Levy Total2,400,000----- Description: Street, sanitary sewer, storm sewer and watermain reconstruction: Shakopee Avenue from CSAH 17 to 11th Avenue. Justification: To continue with the rehabilitation of the City's infrastructure. Other Comments: Staff has received several resident communications for this project. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet ConstructionVierling Drive - C.R. 69 to Taylor St.$1,500,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction1,200,000 Improvements Engineering/Admin.300,000 Total1,500,000----- B. Funding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments1,500,000 Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total1,500,000----- Description: The construction of street, utility , sidewalk and trail system from County Road 69 to Taylor Street. Justification: Vierling Drive completion is needed to provide access to commercial property south of Shakopee Town Square and North of the Shakopee By-Pass while completing this east-west collector system. Other Comments: Need to design roadway after future end user is identified. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet ConstructionLewis Street Parking Lot & Alley$430,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction370,000 Improvements Engineering/Admin.60,000 Total430,000----- B. Funding Source: General Fund Capital Improvement Fund170,000 Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments60,000 Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base200,000 Storm Drainage Fund-Trunk Tax Levy Total430,000----- Description: To rehabilitate Lewis Street parking lot and three blocks of downtown alleys. Justification: To rehabilitate parking lot and restore alley pavement with improved drainage Other Comments: Utility companies need to make improvements to their systems in the alleys. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet Construction17th Avenue, from C.R. 15 to 1000 $625,000 feet west A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction500,000 Improvements Engineering/Admin.125,000 Total625,000----- B. Funding Source: General Fund Capital Improvement Fund100,000 Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments525,000 Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total625,000----- Description: Extension of 17th Avenue from County Rd 15 to 1000 feet west. Justification: Development of this area may warrant the extension of 17th Avenue. Other Comments: The County has determined that this should be a county road. Extension of road would be done in conjunction with development. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet Construction2018 Bituminous Overlay$1,890,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction1,770,000 Improvements Engineering/Admin.120,000 Total-1,890,000---- B. Funding Source: General Fund Capital Improvement Fund1,830,000 Park Reserve Fund Grants (specify) Donations (specify) SPU20,000 State Aid Assessments Sanitary Sewer Fund-Base20,000 Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk20,000 Tax Levy Total-1,890,000---- Description: Bituminous overlay of various streets throughout the City. Justification: Continuation of the City's Pavement Preservation Program to maintain existing infrastructure. Other Comments: Bituminous overlays are more cost effective than reconstructing pavements. Streets will be evaluated on a yearly basis and may be moved up or moved back in the CIP. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet Construction2018 Street Reconstruction$2,740,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction2,340,000 Improvements Engineering/Admin.400,000 Total-2,740,000---- B. Funding Source: General Fund Capital Improvement Fund1,060,000 Park Reserve Fund Grants (specify) Donations (specify) SPU620,000 State Aid Assessments460,000 Sanitary Sewer Fund-Base400,000 Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base200,000 Storm Drainage Fund-Trunk Tax Levy Total-2,740,000---- Description: Street, sanitary sewer, storm sewer and watermain reconstruction: Shakopee Avenue from CSAH 17 to Market Street and Dakota Street and Minnesota Street from Shakopee Avenue to 10th Avenue.. Justification: To continue with the rehabilitation of the City's infrastructure. Other Comments: Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet ConstructionConcrete Alleys$420,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction320,000 Improvements Engineering/Admin.100,000 Total-420,000---- B. Funding Source: S General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments105,000 Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base315,000 Storm Drainage Fund-Trunk Tax Levy Total-420,000---- Description: Reconstruct existing alleys with concrete pavement. Justification: To rehabilitate existing alleys and improve drainage. Other Comments: Estimate is for 5 city blocks of alley improvements. Locations to be determined. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet Construction2019 Bituminous Overlay$2,290,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction2,140,000 Improvements Engineering/Admin.150,000 Total--2,290,000--- B. Funding Source: General Fund Capital Improvement Fund2,230,000 Park Reserve Fund Grants (specify) Donations (specify) SPU20,000 State Aid Assessments Sanitary Sewer Fund-Base20,000 Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk20,000 Tax Levy Total--2,290,000--- Description: Bituminous overlay of various streets throughout the City. Justification: Continuation of the City's Pavement Preservation Program to maintain existing infrastructure. Other Comments: Bituminous overlays are more cost effective than reconstructing pavements. Streets will be evaluated on a yearly basis and may be moved up or moved back in the CIP. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet Construction2019 Street Reconstruction$910,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction750000 Improvements Engineering/Admin.160000 Total--910,000--- B. Funding Source: General Fund Capital Improvement Fund490,000 Park Reserve Fund Grants (specify) Donations (specify)110000SPU State Aid Assessments190000 Sanitary Sewer Fund-Base40000 Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base80000 Storm Drainage Fund-Trunk Tax Levy Total--910,000--- Description: Street, sanitary sewer, storm sewer and watermain reconstruction: Scott Street from Levee Drive to 2nd Avenue, Atwood Street from Levee Drive to 1st Avenue; Levee Drive, from Scott Street to Holmes Street and 7th Avenue from Spencer to Sommerville. Justification: To continue with the rehabilitation of the City's infrastructure in the older sections of the Community. Other Comments: Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet Construction12th Avenue Trail$240,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW40,000 Construction160,000 Improvements Engineering/Admin.40,000 Total--240,000--- B. Funding Source: General Fund Capital Improvement Fund240,000 Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total--240,000--- Description: Construct a bituminous trail from CSAH 83 to Quarry Lake Park. Justification: Provide a trail connection from CSAH 83 to Quarry Lake Park. Other Comments: Right of Way Easements will be needed. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyTRAILSavanna Oaks Park to Southbridge $150,000 Parkway Trail A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction130,000 Improvements Engineering/Admin.20,000 Total--150,000--- B. Funding Source: General Fund Capital Improvement Fund75,000 Park Reserve Fund75,000 Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total--150,000--- Description: Provide trail connection to Savana Oaks Park & Dean Lake Trail from other areas of Southbridge. Justification: Trail connection would complete a trail gap in trail system and connect park to other areas of Southbridge. Other Comments: Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet Construction2020 Bituminous Overlay$1,160,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction1,040,000 Improvements Engineering/Admin.120,000 Total---1,160,000-- B. Funding Source: General Fund Capital Improvement Fund1,110,000 Park Reserve Fund Grants (specify) Donations (specify) SPU20,000 State Aid Assessments Sanitary Sewer Fund-Base10,000 Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base20,000 Storm Drainage Fund-Trunk Tax Levy Total---1,160,000-- Description: Bituminous Overlay of various streets throughout the city. Project area to be determined. Justification: Continuation of the City's Pavement Preservation Program to maintain existing infrastructure. Other Comments: Bituminous overlays are more cost effective than reconstructing pavements. Streets will be evaluated on a yearly basis and may be moved up or moved back in the CIP. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet Construction2020 Bituminous Reclamation$400,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction330,000 Improvements Engineering/Admin.70,000 Total---400,000-- B. Funding Source: General Fund Capital Improvement Fund300,000 Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments100,000 Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total---400,000-- Description: Bituminous Reclamation of Vista Ridge Lane and Westridge Drive. Justification: Continuation of the City's Pavement Preservation Program to maintain existing infrastructure. Other Comments: Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet ConstructionCSAH 42 Reconstruction$1,200,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction1,000,000 Improvements Engineering/Admin.200,000 Total---1,200,000-- B. Funding Source: General Fund Capital Improvement Fund200,000 Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base1,000,000 Storm Drainage Fund-Trunk Tax Levy Total---1,200,000-- Description: Reconstruction of CSAH 42 from CSAH 83 to CSAH 17. Justification: Other Comments: Costs above only include City costs. This project is in the County TIP for 2020. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet Construction12th Avenue & CSAH 83 $4,000,000 Improvements A. Expenditure Items:20172018201920202021FUTURE Land & ROW100,000 Construction3,300,000 Improvements Engineering/Admin.600,000 Total---4,000,000-- B. Funding Source: General Fund Capital Improvement Fund1,000,000 Park Reserve Fund Grants (specify) Donations (specify)3,000,000(County + Federal) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total---4,000,000-- Description: 12th Avenue & CSAH 83 Improvements Justification: Increased traffic from economic development and potential Canterbury retail requires intersection improvements. Other Comments: TIF funding may be an option if Canterbury applies for TIF. County has indicated submitting for Federal funding on CSAH 83 and this intersection. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet ConstructionT.H. 169 Pedestrian Bridge$3,000,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction3,000,000 Improvements Engineering/Admin. Total---3,000,000-- B. Funding Source: General Fund Capital Improvement Fund500,000 Park Reserve Fund500,000 Grants (specify) Donations (specify)2,000,000(Federal) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total---3,000,000-- Description: An additional pedestrian bridge east of C.R. 83 over T.H. 169 along PLSLWD channel is needed to complete trail connections. Project is to build a new pedestrian bridge utilizing Federal Aid Highway Funds. Justification: CƚƩƦĻķĻƭƷƩźğƓƭƚƩĬźĭǤĭƌźƭƷƭƷƚĭƩƚƭƭ͵I͵ЊЏВ͵ Other Comments: Coordination meetings are needed with Mn/DOT and Scott County for this project to obtain funding a project is dependent upon receiving Federal funds. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet Construction2021 Bituminous Overlay$1,980,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction1,830,000 Improvements Engineering/Admin.150,000 Total----1,980,000- B. Funding Source: General Fund Capital Improvement Fund1,930,000 Park Reserve Fund Grants (specify) Donations (specify) SPU20,000 State Aid Assessments Sanitary Sewer Fund-Base10,000 Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base20,000 Storm Drainage Fund-Trunk Tax Levy Total----1,980,000- Description: Bituminous Overlay of various streets throughout the city. Justification: Continuation of the City's Pavement Preservation Program to maintain existing infrastructure. Other Comments: Bituminous overlays are more cost effective than reconstructing pavements. Streets will be evaluated on a yearly basis and may be moved up or moved back in the CIP. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet Construction2021 Street Reconstruction$270,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction240,000 Improvements Engineering/Admin.30,000 Total----270,000- B. Funding Source: General Fund Capital Improvement Fund160,000 Park Reserve Fund Grants (specify) Donations (specify) SPU5,000 State Aid Assessments70,000 Sanitary Sewer Fund-Base5,000 Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base30,000 Storm Drainage Fund-Trunk Tax Levy Total----270,000- Description: Street Reconstruction of Park Ridge Drive. A majority of the curb can be protected to significantly lower costs. Sanitary sewer and watermain will not need to be replaced. Justification: To continue with the rehabiliation of the City's infrastructure. Other Comments: Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet ConstructionCR 15 Interchange & Trail $2,500,000 Improvements A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction2,200,000 Improvements Engineering/Admin.300,000 Total-----2,500,000 B. Funding Source: General Fund Capital Improvement Fund1,000,000 Park Reserve Fund Grants (specify)Federal1,100,000 Donations (specify)MnDOT400,000 State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total-----2,500,000 Description: Interchange improvements to improve safety and construct trail connectors along CR 15 from 17th Avenue to Vierling Drive. Justification: Improvements to the Interchange is for safety and to provide safe pedestrian crossings of the CR 15 bridge over TH 169. Other Comments: Would need Federal Grant selection to receive federal funds or MnDOT Cooperative Agreement funding. It is anticipated that this section will be turned back to the City for the County. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet ConstructionCR 79 Pedestrian Underpass$125,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction100,000 Improvements Engineering/Admin.25,000 Total-----125,000 B. Funding Source: General Fund Capital Improvement Fund125,000 Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total-----125,000 Description: To construct a pedestrian underpass under CR 79 for the Upper Valley Drainageway trail. Justification: Safety concerns of crossing a County road of this trail which not as an intersection. Other Comments: Best pricing would be to install the underpass when the County is reconstructing the road. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStreet ConstructionCSAH 16 Trail Extension$100,000 A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction80,000 Improvements Engineering/Admin.20,000 Total-----100,000 B. Funding Source: General Fund Capital Improvement Fund100,000 Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total-----100,000 Description: Construct missing trail segments along CSAH 16 between CSAH 18 and CSAH 21. Justification: Other Comments: The City asked the County to include this in the County TIP. As of now the project is not in the County TIP. Costs above only include City costs. Operating Costs: 201 Annual BudgetOperating Budget ENTERPRISE FUNDS The Enterprise Funds are maintained to account for the operation of the sanitary sewer, storm drainage systems and refuse. Since the operation of these systems is financed by user charges and are self-supporting, they are accounted for in a manner similar to private business. The Storm Drainage Fund was established by Ordinance 176 in 1985. The intent of the City Council is to have a cash balance to at least equal accumulated depreciation. This follows the City Auditor’s recommendation. Accumulated depreciation is a reflection of historical costs of depreciable assets. Replacement cost is expected to be two to two and one half times as much as historical costs. Cash balance is also expected to have approximately 4 months of operating expenditures for cash flow purposes. The City reviews fees annually to determine appropriate revenue levels. Operating Budget 201 Annual Budget Sanitary Sewer Fund Descrition of Services: p Activity in this fund reflects the operations of the Municipal Sanitary Sewer System. This includes repair and maintain current sewer lines, manhole rehabilitation/replacement, repairing lines, GIS/GPS hardware. Goals: Maintain and operate the Municipal Sanitary Sewer System. 1. Continue to comply with Federal and State mandates as they are updated or expanded 2. Undertake reviews and studies of the existing system to ensure that it can meet the expansion needs of the 3. community and commercial/industrial entities. 4. Coordinate with the State and County construction and Capital Improvement Plans, to ensure that rate payers receive hi ghest level of service for the capital commitment 5.Review and maintain rates that meet the current and near future needs of the rate payer. Sanitary Sewer Fund Projected Net Position 2017-2021 Capital Improvement Program City of Shakopee, Minnesota 20172018201920202021 Net position as of January 1 (excluding capital assets) Less: Restricted cash balance Available net position as of January 110,315,3588,218,5587,027,8586,204,9585,546,858 Revenues: Monthly Flat Fee917,500988,1001,058,7001,129,2001,199,800 Flow charges2,335,9002,522,8002,724,6002,867,6003,018,200 City SAC100,000100,000100,000100,000100,000 Trunk Charges50,00050,00050,000 Metro SAC25,00025,00025,00025,00025,000 Interest103,20082,20070,30062,00055,500 Interest on Interfund Loan8,5007,4006,4005,3005,300 Special Assessments Transfer In Total revenue3,540,1003,775,5004,035,0004,189,1004,403,800 Expenses: Operation Expenses693,700707,600721,800736,200750,900 Treatment Costs2,578,2002,713,6002,856,1003,006,0003,163,800 Capital Equipment100,000100,000100,000100,000100,000 Transfer to General Fund125,000125,000125,000125,000125,000 Transfer to City Hall Capital Project Fund500,000---- Projects: Service Replacement-750,000750,000750,000- Trunk Sewer Extensions520,000150,000120,000120,000100,000 SCADA System Upgrades--125,000-- CSAH 18 Sewer Extensio750,000---- n Transfer to Capital Imp. Fund for projects370,000420,00060,00010,00015,000 Total Expenses5,636,9004,966,2004,857,9004,847,2004,254,700 Excess (Deficiency)(2,096,800)(1,190,700)(822,900)(658,100)149,100 CashEstimated Net Position as of December 318,218,5587,027,8586,204,9585,546,8585,695,958 Accumulated Depreciation $14,449,425$15,243,391$16,045,297$16,855,222$17,673,247 57%46%39%33%32% {ğƓźƷğƩǤ{ĻǞĻƩCǒƓķ tƩƚƆĻĭƷĻķ/ğƭŷ\[ĻǝĻƌƭ ЋЉЊАЋЉЋЊ/ğƦźƷğƌLƒƦƩƚǝĻƒĻƓƷtƩƚŭƩğƒ /źƷǤƚŅ{ŷğƉƚƦĻĻͲaźƓƓĻƭƚƷğ ВͲЉЉЉͲЉЉЉ БͲЉЉЉͲЉЉЉ АͲЉЉЉͲЉЉЉ ЏͲЉЉЉͲЉЉЉ ЎͲЉЉЉͲЉЉЉ ЍͲЉЉЉͲЉЉЉ ЌͲЉЉЉͲЉЉЉ ЋͲЉЉЉͲЉЉЉ ЊͲЉЉЉͲЉЉЉ ЋЉЊАЋЉЊБЋЉЊВЋЉЋЉЋЉЋЊ υЉ͵ЎЉCƌğƷυЉ͵ЎЉCƌğƷυЉ͵ЎЉCƌğƷυЉ͵ЎЉCƌğƷυЉ͵ЎЉCƌğƷ БіğƩźğĬƌĻБіğƩźğĬƌĻБіğƩźğĬƌĻЎ͵ЋЎіğƩźğĬƌĻЎ͵ЋЎіğƩźğĬƌĻ ƚƷğƌƩĻǝĻƓǒĻƚƷğƌ9ǣƦĻƓƭĻƭ9ƭƷźƒğƷĻķbĻƷtƚƭźƷźƚƓğƭƚŅ5ĻĭĻƒĬĻƩЌЊ CƌƚǞwĻǝĻƓǒĻǝƭƩĻğƷƒĻƓƷ/ƚƭƷƭ ЋЉЊЎЋЉЋЉ /źƷǤƚŅ{ŷğƉƚƦĻĻͲaźƓƓĻƭƚƷğ ЌͲЎЉЉͲЉЉЉ ЌͲЉЉЉͲЉЉЉ ЋͲЎЉЉͲЉЉЉ ЋͲЉЉЉͲЉЉЉ ЊͲЎЉЉͲЉЉЉ ЊͲЉЉЉͲЉЉЉ ЎЉЉͲЉЉЉ ЋЉЊАЋЉЊБЋЉЊВЋЉЋЉЋЉЋЊ wĻǝĻƓǒĻƭʹCƌƚǞĭŷğƩŭĻƭ9ǣƦĻƓƭĻƭʹƩĻğƷƒĻƓƷ/ƚƭƷƭ CƌğƷCĻĻwĻǝĻƓǒĻǝƭ9ǣƦĻƓƭĻƭΛƌĻƭƭƒƷ/ƚƭƷƭΜ ЋЉЊЎЋЉЋЉ /źƷǤƚŅ{ŷğƉƚƦĻĻͲaźƓƓĻƭƚƷğ ЌͲЎЉЉͲЉЉЉ ЌͲЉЉЉͲЉЉЉ ЋͲЎЉЉͲЉЉЉ ЋͲЉЉЉͲЉЉЉ ЊͲЎЉЉͲЉЉЉ ЊͲЉЉЉͲЉЉЉ ЎЉЉͲЉЉЉ ЋЉЊАЋЉЊБЋЉЊВЋЉЋЉЋЉЋЊ aƚƓƷŷƌǤCƌğƷCĻĻ9ǣƦĻƓƭĻƭƌĻƭƭ ƩĻğƷƒĻƓƷ/ƚƭƷƭ City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneySanitary SewerL-16 Improvements$75,000.00 A. Expenditure Items:20172018201920202021 Land & ROW Construction60,000 Improvements Engineering/Admin.15,000 Total-75,000--- B.SFunding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base75,000 Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total- 75,000 - - - Description: Demolition of old L-16 building. Justification: Other Comments: Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneySanitary SewerTrunk Sewer Extensions$1,010,000.00 A. Expenditure Items:20172018201920202021 Land & ROW Construction520,000150,000120,000120,000100,000 Improvements Engineering/Admin. Total520,000150,000120,000120,000100,000 B.SFunding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk520,000 150,000 120,000 120,000 100,000 Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total520,000 150,000 120,000 120,000 100,000 Description: Extension of trunk sewer through development. As certain areas within the City develop trunk sanitary sewer will need to be extended. Justification: Sewer extension is part of City's sanitary sewer plan and is needed in order for area to develop. Other Comments: Sewer will be extended as area develops. MCES MAY REQUIRE TRUNK COST REIMBURESEMENT FOR ADDITIONAL FLOW AS PER SHAKOPEE/CHASKA INTERCEPTOR COST SHARING AGREEMENT. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneySanitary SewerService Replacement$2,250,000.00 A. Expenditure Items:20172018201920202021 Land & ROW Construction625,000625,000625,000 Improvements Engineering/Admin.125,000125,000125,000 Total-750,000750,000750,000- B.Funding Source: S General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base750,000 750,000 750,000 Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total- 750,000 750,000 750,000 - Description: Replace or line services located on mains that have been lined. Justification: To date, there are 750 services connected to sewer mains that have been lined. Many of the sewer service pipes are over 40 years old. Other Comments: Lining of service pipes will be from the main to appoximately the right of way lines. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneySanitary SewerCSAH 18 Sewer Extension$750,000.00 A. Expenditure Items:20172018201920202021 Land & ROW Construction600,000 Improvements Engineering/Admin.150,000 Total750,000--- B.SFunding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk750,000 Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total750,000 - - - Description: Extend sanitary sewer to serve the Whispering Oaks development. Justification: To eliminate the existing lift station and eliminate flow into the Savage sewer system. Savage Agreement needs to be revised. Other Comments: Need to coordinate with SPUC's booster station to serve area with Shakopee's water. Also need County approval for installing line in County Highway 18 right-of- way. Another alternate route is through Muhlenhardt Road and Horizon Drive. Sewer study of area is recommended. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneySanitary SewerUtility Extension to Maras St. & $2,710,000.00 Hanson Ave. A. Expenditure Items:20172018201920202021 Land & ROW Construction2,210,000 Improvements Engineering/Admin.500,000 Total--2,710,000-- B.SFunding Source: General Fund Capital Improvement Fund920,000 Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments1,740,000 Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base50,000 Storm Drainage Fund-Trunk Tax Levy Total- - 2,710,000 - - Description: Extension of sanitary sewer and water service to the properties adjacent to Maras St. and Hanson Avenue. A majority of the properties will require sanitary sewer grinder pumps. Justification: Other Comments: Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneySanitary SewerSCADA System Upgrades$125,000.00 A. Expenditure Items:20172018201920202021 Land & ROW Construction Improvements105,000 Engineering/Admin.20,000 Total-125,000-- B.SFunding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base125,000 Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total- 125,000 - - Description: To improve the reliability and performance of supervisory control and data acquisition (SCADA) system for major lift stations. Justification: The need for better reliability and data for major lift stations would reuire an upgrade system and use of fiber. Other Comments: Fiber is nearby both L-16 and Southbridge lift stations. Operating Costs: Operating Budget 201 Annual Budget Surface Water Fund Descrition of Services: p The Public Works Department operates and maintains the surface water system for the City of Shakopee which includes 109 miles of storm sewer and 196 ponds. Participate in erosion control projects and implementation of the City’s Water Resource Mana gement Plan. Goals: To provide to protect, enhance, and restore water quality. 1. Plan for annual erosion control and related maintenance of the Pond systems 2. Prepare for needed wetland enhancement projects 3. 4. Address issues as the community infrastructure ages Surface Water Fund Projected Unrestricted Net Position 2017-2021 Capital Improvement Program City of Shakopee, Minnesota 20172018201920202021 Unrestricted Net Position January 112,605,79011,530,99010,922,89010,845,6909,977,290 Revenues: User Fees1,034,8001,086,5001,108,2001,163,6001,186,900 Trunk Charges100,000100,000100,000100,000100,000 Interest100,000100,000100,000100,000100,000 Total Revenue1,234,8001,286,5001,308,2001,363,6001,386,900 Expenses: Operation Expenses834,600859,600885,400912,000939,400 Capital Equipment50,00050,00050,00050,00050,000 Transfer to General Fund125,000125,000125,000125,000125,000 Transfer to City Hall Capital Project Fund500,000- - - - Projects: Annual Erosion Control/Pond Cleaning125,000125,000125,000125,000125,000 PLSL Channel Improvement100,000100,000 - - - Blue Lake Channel Improvements- 100,000- - - Blue Lake Channel Cooperative 100,000- - - - West End300,000 - - - - CSAH 15 Ditch Improvements85,000 - - - - Transfer to Capital Imp. Fund for projects 535,000190,000 100,000 1,020,000 50,000 Total Expense2,309,600 1,894,600 1,385,400 2,232,000 1,289,400 Excess (Deficiency)(1,074,800) (608,100) (77,200) (868,400) 97,500 CashBalance December 31$11,530,990$10,922,890$10,845,690$9,977,290$ 10,074,790 Accumulated Depreciation $13,097,492$13,889,011$14,688,444$15,495,873$ 16,311,375 88%79%74%64%62% {ǒƩŅğĭĻğƷĻƩCǒƓķ tƩƚƆĻĭƷĻķ/ğƭŷ\[ĻǝĻƌƭ ЋЉЊАЋЉЋЊ/ğƦźƷğƌLƒƦƩƚǝĻƒĻƓƷtƩƚŭƩğƒ /źƷǤƚŅ{ŷğƉƚƦĻĻͲaźƓƓĻƚƭƷğ ЊЋͲЉЉЉͲЉЉЉ ЊЉͲЉЉЉͲЉЉЉ БͲЉЉЉͲЉЉЉ ЏͲЉЉЉͲЉЉЉ ЍͲЉЉЉͲЉЉЉ ЋͲЉЉЉͲЉЉЉ ЋЉЊАЋЉЊБЋЉЊВЋЉЋЉЋЉЋЊ ЉіЌ͵ЎіЌ͵ЎіЌ͵ЎіЌ͵Ўі ƚƷğƌwĻǝĻƓǒĻƚƷğƌ9ǣƦĻƓƭĻ/ğƭŷʹ.ğƌğƓĭĻЊЋΉЌЊ City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStorm DrainageAnnual Erosion Control and Pond $750,000.00 Cleaning A. Expenditure Items:20172018201920202021 Land & ROW Construction125,000125,000125,000125,000125,000 Improvements Engineering/Admin.25,00025,00025,00025,00025,000 Total150,000150,000150,000150,000150,000 B.SFunding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base150,000 150,000 150,000 150,000 150,000 Storm Drainage Fund-Trunk Tax Levy Total150,000 150,000 150,000 150,000 150,000 Description: Annual Erosion Control Project and/or annual pond cleaning project. Justification: Areas may need to be fixed to meet NPDES requirements. Ponds may need to be cleaned to meet NPDES requirements. Other Comments: The storm sewer outfalls and ponds must be inspected prior to determining a project area. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStorm DrainagePLSL Channel Improvements$200,000.00 A. Expenditure Items:20172018201920202021 Land & ROW Construction90,00090,000 Improvements Engineering/Admin.10,00010,000 Total100,000100,000--- B.SFunding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk100,000100,000 Tax Levy Total100,000100,000--- Description: Additional capacity and control structures in the Prior Lake/Spring Lake Channel to handle increased run-off due to development. Justification: Existing agreement with Prior Lake/Spring Lake Watershed District (PLSLWD) requires the City to maintain the channel upon the City utilizing the channel for urban development. Increased runoff from development will require a larger channel. Other Comments: This segment will be upgraded when the property develops. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStorm DrainageConstruction of Pollution Prevention $2,000,000 Devices A. Expenditure Items:20172018201920202021FUTURE Land & ROW Construction1,800,000 Improvements Engineering/Admin.200,000 Total-----2,000,000 B.SFunding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base2,000,000 Storm Drainage Fund-Trunk Tax Levy Total- - - - - 2,000,000 Description: Future water quality treatment project. Dependent on future requirements. Potential locations include Market Street, County Road 17, Fuller Street and Adams Street. Justification: This may be mandated in the future. Other Comments: MPCA & EPA Standards requiring additional Pollution Prevention devices has not been mandated. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStorm DrainageBlue Lake Channel Regional Storm $100,000.00 Pond A. Expenditure Items:20172018201920202021 Land & ROW Construction Improvements Engineering/Admin. Total100,000 B.SFunding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total100,000 Description: Regional ponding of storm water, west of CSAH 83 to control storm water rate and quality. Justification: Management of storm water in this area is necessary to prevent flooding and management of water from areas south of the pond. Other Comments: Construction of ponding would be done with development. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStorm DrainageBlue Lake Channel Cooperative $100,000.00 Regional Storm Pond A. Expenditure Items:20172018201920202021 Land & ROW Construction Improvements Engineering/Admin. Total100,000 B.SFunding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total100,000 Description: To construct a Joint Regional Pond with the SMSC on the Blue Lake Channel prior to outletting to the Prior Lake Channel. Justification: Control of storm water by ponding and infiltration prior to the Prior Lake Channel is good management of storm water. Other Comments: Joint Powers Agreement with the SMSC would be necessary on this joint venture. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStorm DrainageWest End Regional Pond & Trunk $300,000.00 Oversizing A. Expenditure Items:20172018201920202021 Land & ROW Construction240,000 Improvements Engineering/Admin.60,000 Total300,000 B.SFunding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk300,000 Tax Levy Total300,000 Description: Additional capacity of ponding and better rate control of drainage entering into the Upper Valley Drainage system. Justification: Contol of water rates are important to manage the system and reducing the potential of flooding downstream. Other Comments: The oversizing of ponds and pipes will be coordinated with development. Operating Costs: City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyStorm DrainageCSAH 15 Ditch Improvements$85,000.00 A. Expenditure Items:20172018201920202021 Land & ROW Construction70,000 Improvements Engineering/Admin.15,000 Total85,000 B.SFunding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total85,000 Description: To remove ditch on the west side of CR 15 to facilitate the placement of trail. Justification: Ditch will not be necessary upon development and storm sewer will allow for curb & gutter and trail placement. Other Comments: Coordination with MnDOT and approval of CH 15 Turnback Agreement is needed. Operating Costs: 201 Annual Budget Operating Budget Equipment Internal Service Fund Description of Service: This fund finances the multi-year Equipment Plan. Financing to purchase equipment is provided by "rent" payments from the operating departments at rates established annually by the Finance Department as part of the budget process. Equipment for the Sewer and Storm Drainage enterprise funds is not included. The Equipment Fund shall "own" and acquire larger pieces of equipment including but not limited to cars, trucks, graders, loaders, tractors and larger mowers or items generally costing $20,000 or more. Establishment: The Equipment Fund was established by Resolution #4077 in 1994. Goals: 1.To segregate funds for the acquisition of equipment to avoid budget problems caused by large purchases in a single year. Business Unit: 7800 – Equipment I.S. Fund 2017 Annual Budget Equipment Internal Service Fund 201620162017 20142015OriginalFinalProposed ActualActualBudgetBudgetBudget Sources Miscellaneous Rentals701,338$ 464,384$ 612,868$ 612,868$ 861,100$ Sale of Assets- 85,405 - - - Interest134,904 63,778 10,000 10,000 10,000 Note repaid95,000 - - - - Total Revenue931,242 613,567 622,868 622,868 871,100 Uses Capital Equipment621,163 2,190,829 1,243,000 1,243,000 1,109,500 Net $ (1,577,262)310,079$ (620,132)$ (620,132)$ (238,400)$ Cash Balance December 317,464,033$ 4,900,827$ 4,280,695$ 4,280,695$ 4,042,295$ Equipment Replacement Projected Fund Levels 2017-2026 Capital Improvement Program City of Shakopee, Minnesota SOURCES2017201820192020202120222023202420252026 Miscellaneous 950,724 969,738 989,133 1,008,916 1,029,094 Rentals 861,100 878,322 895,888 913,806 932,082 Sale of Assets Interest 10,000 10,000 10,000 10,000 10,000 1 0,000 10,000 1 0,000 1 0,000 1 0,000 960,724 979,738 999,133 1,018,916 1,039,094 Total Revenue 871,100 888,322 905,888 923,806 942,082 EXPENDITURES: Uses Capital Equipment 1,230,750 509,000 783,750 1,729,000 2,286,750 1,109,500 1,504,750 778,000 778,000 1,162,000 1,230,750 509,000 783,750 1,729,000 2,286,750 Total Expenditures 1,109,500 1,504,750 778,000 778,000 1,162,000 EXCESS (DEFICIENCY OF SOURCES OVER USES) Cash Balance January 1 3,479,644 3,209,618 3,680,356 3,895,740 3,185,656 4 ,280,695 4 ,042,295 3 ,425,867 3,553,755 3 ,699,562 Balance 12/31$4,042,295$ 3,209,618$ 3,680,356$ 3,895,740$ 3,185,656$ 1,938,000 $ 3,425,867$ 3,553,755$ 3,699,562$ 3,479,644 CITY OF SHAKOPEE Budget 2017 | 10-Year Equipment Projection 2017201820192020202120222023202420252026 EQUIPMENT FUND Police Patrol - Marked255,000260,000159,000216,000270,000275,000163,000 245,000 100,000 150,000 Patrol - Unmarked/Administrative72,00038,00039,000 Patrol - Sargeants 4x4 53,00058,000 48,000 Utility Vehicle Pickup Truck45,000 Fire Pumper Truck1,200,000700,000 Rescue Truck380,000900,000 Truck - Telesquirt1,000,000 Truck - 1-Ton 4x4 With Grass Pak100,000 Chief's Vehicle120,00048,000 46,000 Fire Inspector Vehicle43,000 All-Terrain Vehicle/Grass Pak40,000 Building Inspection Inspection Vehicle30,00031,00035,000 Facilities Truck - Pickup 4x4 w/Plow, Lift Gate50,000 Scissor Lift 15,000 Truck - Pickup 60,000 Engineering Truck - Pickup 4x4 37,00039,00080,000 Natural Resources Truck - Pickup 4x4 35,000 Street Maint Loader220,000225,000 Truck - Single Axle Dump530,000540,000 250,000 520,000 Truck - Pickup39,00040,000 Truck - Pickup 4x4 w/Plow45,000 43,000 Skidsteer Loader4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 Sign Truck70,000 Park Maint Large Mower155,000160,000165,000 150,000 Pickup Truck 4x4 w/Plow47,00048,000 Pickup 4x4 1.5T w/Box Hoist Plow78,000 44,000 Bucket Truck120,000 Tractors19,5007,50019,5007,50019,5007,50019,500 7,500 19,500 7,500 Skidsteer Loaders (2)9,0009,0009,0009,0009,0009,0009,000 9,000 9,000 9,000 Pickup 2x4 1.5T 50,000 Small Mowers (3)21,75021,75021,75021,750 21,750 Stump Grinder 10,000 Enclosed Trailer 20,000 Rotary Blade Grinder 12,500 V-Plow 7,000 Ice Resurfacer 3pt. 15,000 Pickup Truck40,00060,000 Hook Truck w/Equip 240,000 Recreation Minivan30,000 Pickup Truck w/Plow/Lift51,000 Ice Resurfacer 130,000 1,109,5001,504,750 778,000 509,0002,286,750 Total Governmental Funds 778,0001,162,000 1,230,750 783,7501,729,000 9ƨǒźƦƒĻƓƷLƓƷĻƩƓğƌ{ĻƩǝźĭĻCǒƓķ ЍͲЎЉЉͲЉЉЉ ЍͲЉЉЉͲЉЉЉ ЌͲЎЉЉͲЉЉЉ ЌͲЉЉЉͲЉЉЉ ЋͲЎЉЉͲЉЉЉ ЋͲЉЉЉͲЉЉЉ ЊͲЎЉЉͲЉЉЉ ЊͲЉЉЉͲЉЉЉ ЎЉЉͲЉЉЉ ЋЉЊАЋЉЊБЋЉЊВЋЉЋЉЋЉЋЊЋЉЋЋЋЉЋЌЋЉЋЍЋЉЋЎЋЉЋЏЋЉЋАЋЉЋБЋЉЋВЋЉЌЉЋЉЌЊЋЉЌЋЋЉЌЌЋЉЌЍЋЉЌЎЋЉЌЏЋЉЌА 9ǣƦĻƓķźƷǒƩĻƭwĻƨǒĻƭƷĻķwĻƓƷwĻǝĻƓǒĻ/ğƭŷ.ğƌğƓĭĻğƷwĻƨǒĻƭƷĻķwĻƓƷwğƷĻ/ğƭŷ.ğƌğƓĭĻğƷ/ǒƩƩĻƓƷwğƷĻ/ǒƩƩĻƓƷwĻƓƷwĻǝĻƓǒĻ 201 Annual Budget Operating Budget Park and Recreation Asset Internal Service Fund Descriptionof Service: This fund finances the replacementof park assets. Financing toaccomplish this is provided by"rental" paymentsfrom the parkmaintenance division at rates established annually bythe FinanceDepartmentas part of thebudget process. Establishment: The fund was established in 2007. Goals: 1.To segregate funds relating to parks and recreation assets to avoid budget problems caused by large purchases in a single year. Business Unit: 7805 – Park Asset I.S. Fund 2017 Annual Budget Park and Recreation Asset Internal Service Fund 201620162017 20142015OriginalFinalProposed ActualActualBudgetBudgetBudget Sources Rentals437,064$ 374,660$ 385,900$ 385,900$ 684,200$ Other 26,306 5,000 - - - Sale of Assets 1,820 4,280 - - - Interest 37,010 26,248 5,000 5,000 5,000 Donations - - - 250,000 10,000 Total Revenue 502,200 410,188 390,900 640,900 699,200 Uses Trail Overlay - - 65,000 65,000 60,000 Westminster Hockey Rink - 32,653 - - - Lions Park Improvements 221,678 12,652 350,000 - - Lions Park Trail 50,797 - - - - Lions Park Warming House - - - 500,000 - Lions Park Rink - - - - 180,000 Lions Park Playground Equipment - - - 400,000 - Scenic Heights Park Building - 24,039 - - - Tahpah Lighting - 154,697 - - - Tahpah fence extension - 162,507 - - - Field 8 Backstop and Fence-- 20,000 20,000 - Memorial Park Bridge - - 300,000 375,000 - Schleper Stadium- Scoreboard 1,194 - - - - Schleper Field Stadium Seating 26,250 - - - - Schleper field lights/roof - 284,980 - - - Schleper Painting - - - - 125,000 Gazebo Levy Drive - - - - 20,000 Community Center Parking Lot - - - - 200,000 Community Center Bathroom Counters - - - - 100,000 Community Center Curbing 20,903 - - - - Community Center Lift Replacement 34,692 - - - - Community Center Study - 40,650 - - - e Community Center Basketball Hoop Replac - - 50,000 50,000 - Community Center Locker Replacement - - 105,000 105,000 - Backstops - - - - 30,000 SV- Pool Slide 22,491 - - - - SV- Pool Diving Well - - - - 35,000 SV- Pool Slide Pump - - 15,000 - - Skate Park Relocation - - - 200,000 - Playground Equipment - - 75,000 75,000 50,000 Riverview Fence - - 25,000 25,000 - Maps - 453 - - - Total Expenditures 1,005,000 1,815,000 378,005 712,630 800,000 Excess (deficiency) of Sources over Uses $ 124,195$ (302,442)$ (614,100)$ (1,174,100)$ (100,800) Transfer In 210,000 - - - - Net $ 334,195$ (302,442)$ (614,100)$ (1,174,100)$ (100,800) Cash Balance December 31$ 2,290,580$ 2,081,738$ 1,467,638$ 907,638$ 806,838 2017 Annual Budget Park and Recreation Asset Internal Service Fund 2017 - 2021 Capital Improvement Program 20172018201920202021 Revenues: Rent from Park Maintenance$ 372,000$ 372,000$ 372,000$ 372,000$ 372,000 Rent from Building (CC, IA and SV) 312,200 364,100 364,100 364,100 364,100 Interest 5,000 5,000 5,000 5,000 5,000 Donation 10,000 20,000 10,000 10,000 10,000 Total Revenue 699,200 761,100 751,100 751,100 751,100 Expenditures: Recreation Facility Projects: CC Basketball Hoop Replacement - - - - - CC Boiler Replacment - - - 100,000 - CC Parking Lot 200,000 - - - - CC Bathroom Counters 100,000 - - - - SV Main Pool Pump - - 20,000 - - SV Small Drop Slide - - 15,000 - - SV Pool Filter Replacement - - - 50,000 - SV Pool Diving Well 35,000 - - - - SV Pool Slide Pump - - - - 15,000 Total Recreation Facility Projects 335,000 - 35,000 150,000 15,000 Park Facility Projects: Trail Overlay 65,000-- 60,000 60,000 Playground Equipment 50,000 75,000 - - - Playground Equipment (Holmes) - - 80,000 - - Playground Equipment (Hiawatha) - - - 80,000 - Playground Equipment (Huber Park) - - - - 150,000 Benches - 20,000 - - - Fence Replacement - 15,000 - - - Field 8 Backstop & Fence - - - - - Gazebo Levy Drive 20,000 - - - - Lions Park Parking Lot - - - 100,000 - Lions Park Playground Equipment - - - - - Lion's Park Rink 180,000 - - - - YB Interior Chinking - 50,000 - - - Scenic Heights Rink - 30,000 - - - Backstops 30,000 - - - - Bleachers - 15,000 - - - Schleper Painting 125,000 - - - - Memorial Park Bridge--- - - Memorial Park Bathroom Replace - - 250,000 - - Memorial Park Trails - - - 125,000 - Memorial Park Parking Lot - - 100,000 - - Riverview fence - - - - - Skate Park Ramps - - - - - Skate Park Relocation - - - - - Total Park Facility Projects 465,000 265,000 495,000 305,000 150,000 Total Expenditures 800,000 265,000 530,000 455,000 165,000 Excess (Deficiency) (100,800) 496,100 221,100 296,100 586,100 Cash Balance January 1 907,638 806,838 1,302,938 1,524,038 1,820,138 Cash Balance 12/31 806,838 1,302,938 1,524,038 1,820,138 2,406,238 201Annual Budget Operating Budget Governmental Building Asset Internal Service Fund Description of Service: This fund finances the future purchase, major reconstruction, and additions to City owned buildings including City Hall, Library, Public Works, Police, and Fire Stations. Financing to accomplish this is provided by "rental" payments from the operating departments at rates established annually by the Finance Department as part of the budget process. The Building Fund shall "own" and acquire these buildings. Establishment: Council established the Building Fund in 1998. The scope of the fund was expanded in 2000 to include major repairs defined as those without which the building would be unusable for its intended purpose. It was further expanded in 2008 to include energy savings or green initiatives such as lighting upgrades, boiler modifications, etc.. Goals: 1.To segregate funds for the acquisition of buildings to avoid budget problems caused by large purchases in a single year. Business Unit: 7810 – Building I.S. Fund 2017 Annual Budget Governmental Building Asset Internal Service Fund 201620162017 20142015OriginalFinalProposed ActualBudgetBudgetBudget Actual Sources Miscellaneous Rentals635,815$ 517,910$ 533,450$ 533,450$ 610,200$ 10,000 10,000 10,000 Interest 106,253 72,654 Miscellaneous 911 654 - - - Gain (loss) on asset disposal - - - - - Total Revenue 543,450 543,450 620,200 742,979 591,218 Uses Capital Construction Library Exterior Restoration - 90,900 - - - Engineering Building Roof - - - -600,000 Engineering Building Lighting 64,283 - - - - Public Works Building Roof - - - - - Public Works Storage Shed - 110,661 - - - Fire Station 1 Parking Lot - - - -160,000 Fire Station 1 Carpet 23,143 - - - - Fire Station 1 Curb and Grading 15,712 - - - - Fire Station 1 Vierling East Roof - - - - - Fire Station 1 Rooftop Unit 150,000 - -150,000 - Fire Station 2 Concrete Pavement - 79,820 - - - Fire Station 2 Roof 32,515--- - City Hall Electrical Panels 5,982 - - - - City Hall Study 13,555 7,165 - - - City Hall Roof - - - - - City Hall Condenser Unit - -50,000 - - Building Furnishings 34,595 5,700 - - - Total Expenditures 200,000 150,000 760,000 157,270 326,761 Excess (deficiency) of Sources over Uses 343,450 393,450 (139,800) 585,709 264,457 Interfund Loan (500,000) 50,000 50,000 50,000 50,000 Transfer Out City Hall Construction (120,000) - - -(2,040,000) Transfer Out Debt Service (465,000) (466,680) (466,680) (346,680) (340,000) Net $ (379,291)$ (152,223)$ (1,943,230)(73,230)$$ (549,800) Cash Balance December 31$ 5,850,245$ 5,701,935$ 5,628,705$ 3,758,705$ 3,208,905 2017 Annual Budget Governmental Building Asset Internal Service Fund 2017 - 2026 Capital Improvement Program Year/Serv.2017201820192020202120222023202420252026 Police Station-2003 Roof (Built-up)$ 50,000-$$-$-$-$-$-$-$- $ - Rooftop Sallyport unit----- 50,000--- - IT equipment rm. AC unit------ 75,000-- - Boilers (3) 80,000-------- - Fire Station 1-Vierling East-1998 Roof (Ballasted Membrane)---- 200,000---- - Boilers (3) 130,000-------- - Parking Lot160,000-------- - AC condenser unit 100,000-------- - Fire Station 2-Vierling West-2012 2 Rooftop units---- 225,000---- - Engineering Bldg-1974 Roof600,000-------- - Small Rooftop Unit (Southeast)------ 55,000-- - Large Rooftop Unit (Northeast)------- 150,000- - PW Building-2006 Roof--- 800,000----- - 4 Rooftop Units--- 450,000----- - Boilers (2)--- 100,000----- - Library-2003 Roof----- 500,000--- - Grand total by Year$760,000$360,000$-$ 1,350,000-$$425,000$550,000$130,000$150,000 $ - Cash Balance, January 13,758,7053,208,9053,059,1053,269,3053,479,5052,339,7052,124,9051,785,1051,865,3052,215,505 Cash Balance, December 313,208,9053,059,1053,269,3053,479,5052,339,7052,124,9051,785,1051,865,3052,215,505 2,835,705 City of Shakopee Capital Improvement Program 2017-2021 Project Manager:Project Type:Project Title:Total Project Cost: Bruce LoneyBuildingFire Station No. 1-back parking lot $160,000 repaving A. Expenditure Items:20172018201920202021 Land & ROW Construction150,000 Improvements Engineering/Admin.10,000 Total160,000---- B.SFunding Source: General Fund (Building)160,000 Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base Storm Drainage Fund-Trunk Tax Levy Total160,000 - - - - Description: Rehabilitation of Fire Station No. 1 rear parking lot. Justification: Pavement is failing and not supporting weight of fire trucks. Other Comments: Front Parking lot was done previously and as concrete pavement. Operating Costs: OUNTY CARVER C TT SCO Y COUNT 2018 L-16 Improvements BLUE LAKE 101 VANAUGH CA DR 2019 Street Reconstruction FISHER LAKE 17 4TH AVE 4TH AVE 2020 Bituminous 2017 Lewis Street 2017 Bituminous Overlay 69 Parking Lot and Alley Overlay2017 Bituminous 83 UV Overlay 2018 Bituminous INEWOOD DR YP GREENWA 101 169 Overlay P ARK WAYTIMOTHY CT 2021 Bituminous PQ EASTWAY AVE Overlay ALYSHEBA CT 2018 Bituminous 2019 Street 2020 Bituminous Overlay Reconstruction Z Overlay 2A 2A 2018 Street X WY 2B 2B Reconstruction 2C SHAKOPEE AVE 2017 Street Reconstruction JEFFERY P LAC INNOVATION 17 E ALLEN DR 2018 Bituminous 10TH AVE Overlay 10TH AVE10TH AVE 11TH AVE 10TH AVE 2020 12th Avenue & 14 2021 Street 15 CSAH 83 Improvements Reconstruction 2 THOM 11TH AVEAS AVE 11TH AVE11TH AVE 11TH AVE 2018 Bituminous 4 DAVIS CT GOL ST15 Overlay 10 2017 Bituminous 12TH HENNES AVEAUSTIN ST AVE 12TH Overlay 8PRAIRIE12TH AVE AVE 2020 T.H. 169 MENKE MEN KE 2019 12th Avenue Trail LARKSPUR CIR 2019 Bituminous CT Pedestrian Bridge 2017 Street 16 AVECT CT Construction CR 79 Pedestrian 9 Overlay Construction MURPHY DR Underpass 169 12TH AVE7ONYX 5 R 13TH AVE GRANITE DR PRER CIBERWICK DAL DAKOTA SWAKEFIELDCIR EDINGTON 2018 Bituminous MINT CIRCIR2D 2021 Bituminous CIR CIR 2FGR CIDER Overlay APPLEWOOD CIR11132G Overlay T 3B CIR12 WAY FIRESIDE PARKVIEW SAGE I LOV 3WATERFORD CT NG CTCT 13TH AVECT DRWINDSOR DR N ABLU LESTN3C EM LILAC 2019 Bituminous CCN AVEDLADCIR MCT 2019 Sanitary Sewer and CT 169 DASHTON HAR ORC MND Overlay 69 MOUAN DE 2020 Bituminous2019 Bituminous 3D F1 Water Service Extension KWY P NJUNIPER DR OverlayOverlay N 21 Trunk Sewer Extension West of EBUR HBRACTASHBOURNE I 2021 Bituminous SNCIR AD 2019 Savanna Oaks Park ST FDR CSAH 15 O ST Overlay to Southbridge Parkway Trail SUSSEXAVE NE I CT G CR 15 Interchange RD HAN HCA RRIAGE 83 N. OSSUM APPLEBL6 & Trail Improvements CT CHARTREUX NLNBLVDS 169 G AVESUSSEXROV E W.BERKSHIRE 22002211 BBiittuummiinnoouuss RE 2020 Bituminous PL CTHANSEN AVE 169 BULRUSH DOWNING AVE OOvveerrllaayy Overlay 16 WEST EAST 16 CIR 17 2Z 2P2T2XBERK 79 A DONGOLAPOTTOK2V 17TH AVE E 2019 SCADA System SHIREOLD Y 2QKWA 2MCIR DEAN LAKE CAR RI PROVIDENCE DRE GREENWOOD2R OXFORD Upgrades for Lift Stations MORA2RAVEAVE BKISO2N2N TOWNSHIP CT DEANSPLDS 2SN 2U2WWI AVE2Y NN LN AVE 17TH AVE E17TH AVE E WHITEHALL 2017 CSAH 15 Ditch 16 PL 2017 West End Regional A H 16 ARDENNES 17TH AVE ERYMARKTURNBRIDGE AVE2HROCHELLE Improvements 2H CIR 2019 Bituminous ARABNFARIBAULTIT Pond & Trunk Oversizing IA CT 2IE CURVECT CTWINDSOR TURNBRIDGE 2I 2017 Bituminous NEWPORTAVE Overlay CIR 18 MONTECITO 2LGROVE PL 16 2J Overlay 21 18TH FRENCH TRACEAVE EDR 17TH WOOD AVE E 17TH ANT O N AVEQUILT 17THJACK RUSSELL OLIVECT FOX AVE CTANTON RDRUN 2016 PLSL Channel ANUBE AVE D 2020 Bituminous CT FRANCIS LIA CT Improvements LOBE VIEW Overlay CUING BLAZ LNCROSSINGS PRESERVE 2017 17th Avenue, from C.R. 15 ST FRANCIS AVEAL 2021 Bituminous BASS TAR SCT CIR 15 CIR to 1000 feet West Overlay AND GROVELA CIE RALN RD DR JURA WAY THRUSHST VALLEYMOOERS AVE VIEW CTHRUSHSTOAKRIDGE TRL IR 2018 Bituminous 16 OAKRIDGE TRL KA WAY Overlay CT O TIFLAWN CT HILLWO ODRIVER OAKRIDGE VIOLA DRDRBLUFF CIR LN CHESTER CT 77 CT CT 18 LAHOMA ALDEN AVE PAMPASFO 69 CT WILHELM LAKELN PLCT BL R NOLLD K CLARY LN 2018 Bituminous 16 JACKSON TEAL CT Overlay WHISUMMERHILL CSAH 16 DRSTCRANE ST TOWNSHIP CIRCT 2021 Bituminous DR Trail Extension ROCK WOODWARD AVE 17 RIDGE CARRIAGE Overlay S 2017 CSAH 78/79 CIRCIR CORTLAND DANITA Trail Extension CIRDR IRASARUM CT C 78 DANITA 21 MC B 22ND AVE S EL S 130TMOL H SINA ST T W 130TH ST W 78 HOR MOLINA STIZON RIDGE TINTA LN VALLEY VIEW RD RIDGE 2017 Sanitary Sewer CT Extension HOR IZON CIR MAPLE RIDGE DR MAPLE ABBEY 2018 Blue Lake Channel RIDGE PT Ì CT Cooperative Regional Storm Pond LOUISVILLE ST RAVE D TOWNSHIP WILDWOOD VEN 83 ION DOMIN CIR PEACE LANGSTON CIR CT G W 18 2019 Blue Lake Channel 17 Regional Storm Pond PAHA LN 18 CIR 2019 Bituminous D 79 INGTRL IOR LAKE Overlay PR TR PRIOR LAKE WOOD WOOD DUCK TR HERON LONDO 17 15 2020 CSAH 42 Reconstruction 4242 29TH AVE29TH AVE 2017 - 2021 CAPITAL IMPROVEMENT 21 SAKPE DR LAKE O'DOWD PROJECTS MAP WACIPI DR N L SIOUX TRL PENINSULA 2017 UTILITY/MISC IMPROVEMENTS MULBERRY THOLE LAKE CIR 2018 UTILITY/MISC IMPROVEMENTS GRASS NORTON DR 2019 UTILITY/MISC IMPROVEMENTS SYCAMORE CIR LN 2020 Bituminous Reclamation 2020 UTILITY/MISC IMPROVEMENTS 17 2021 UTILITY/MISC IMPROVEMENTS T E 14 150TH S 35TH AVE 14 2017 STREET IMPROVEMENTS 2018 STREET IMPROVEMENTS 2019 STREET IMPROVEMENTS SCHNEIDER LAKE 2020 STREET IMPROVEMENTS 01,4502,900 2021 STREET IMPROVEMENTS 79 Feet LOUISVILLE TOWNSHIP 17 2017 Capital Improvement Plan (CIP) 2017CIP 2017 Capital Improvement Plan (CIP) City maintains roughly 160 miles of streets Review the projects in the current CIP Review the ages of existing streets and inspect streets that are close to an overlay, sealcoat, or reconstruction based on age Review the pavement condition rating of each street and inspect streets that are close to an overlay or reconstruction based on pavement rating 2017 Capital Improvement Plan (CIP) Prepare the CIP trying to balance costs 2017 Capital Improvement Plan (CIP) Review projects in the current CIP Review televising reports and maintenance records Review the age of the existing system Review the need for trunk extensions due to possible development 2017 Capital Improvement Plan (CIP) StreetImprovementProjects 2017 Capital Improvement Plan (CIP) SanitarySewerProjects CityofShakopeeCapitalImprovementProgram 2017-2021 Project Title:Total Project Cost: Project Manager: Bruce LoneyProject Type: Sanitary Sewer Service Replacement$2,250,000.00 A. Expenditure Items:20172018201920202021 Land & ROW625,000625,000625,000 Construction Improvements Engineering/Admin.125,000125,000125,000 Total750,000750,000750,000- B. Funding Source: General Fund750,000750,000750,000 Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments SanitarySewerFund-Base SanitarySewerFund-TrunkStorm DrainageFund-BaseStorm DrainageFund-TrunkTaxLevy Total750,000750,000750,000- Description: Replace or line services located on mains that have been lined. Justification: To date, there are 750 services connected to sewer mains that have been lined. Many of the sewer service pipes are over 40 years old. Other Comments: Lining of service pipes will be from the main to appoximately the right of way lines. Operating Costs: CityofShakopeeCapitalImprovementProgram 2017-2021 Project Title:Total Project Cost: Project Manager: Bruce LoneyProject Type: Sanitary Sewer CSAH 18 Sewer Extension$750,000.00 A. Expenditure Items:20172018201920202021 Land & ROW Construction 600,000 Improvements Engineering/Admin. 150,000 Total750,000--- B. Funding Source: General Fund750,000 Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments SanitarySewerFund-Base SanitarySewerFund-TrunkStorm DrainageFund-BaseStorm DrainageFund-TrunkTaxLevy Total750,000--- Description: Extend sanitary sewer to serve the Whispering Oaks development. Justification: To eliminate the existing lift station and eliminate flow into the Savage sewer system. Savage Agreement needs to be revised. Other Comments: Need to coordinate with SPUC's booster station to serve area with Shakopee's water. Also need County approval for installing line in County Highway 18 right-of-way. Another alternate route is through Muhlenhardt Road and Horizon Drive. Sewer study of area is recommended. Operating Costs: CityofShakopeeCapitalImprovementProgram 2017-2021 Project Title:Total Project Cost: Project Manager: Bruce LoneyProject Type: Sanitary Sewer Utility Extension to Maras St. & $2,710,000.00 Hanson Ave. A. Expenditure Items:20172018201920202021 Land & ROW2,210,000 Construction Improvements Engineering/Admin.500,000 Total--2,710,000-- B. Funding Source: General Fund920,000 Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments1,740,000 Sanitary Sewer Fund-Base Sanitary Sewer Fund-Trunk Storm Drainage Fund-Base50,00 0 Storm Drainage Fund-Trunk Tax Levy Total--2,710,000-- Description: Extension of sanitary sewer and water service to the properties adjacent to Maras St. and Hanson Avenue. A majority of the properties will require sanitary sewer grinder pumps. Justification: Other Comments: Operating Costs: CityofShakopeeCapitalImprovementProgram 2017-2021 Project Title:Total Project Cost: Project Manager: Bruce LoneyProject Type: Sanitary Sewer Trunk Sewer Extensions$1,010,000.00 A. Expenditure Items:20172018201920202021 Land & ROW Construction 520,000150,000120,000120,000100,000 Improvements Engineering/Admin. Total520,000150,000120,000120,000100,000 B. Funding Source: General Fund520,000150,000120,000120,000100,000 Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments SanitarySewerFund-Base SanitarySewerFund-TrunkStorm DrainageFund-BaseStorm DrainageFund-TrunkTaxLevy Total520,000150,000120,000120,000100,000 Description: Extension of trunk sewer through development. As certain areas within the City develop trunk sanitary sewer will need to be extended. Justification: Sewer extension is part of City's sanitary sewer plan and is needed in order for area to develop. Other Comments: Sewer will be extended as area develops. MCES MAY REQUIRE TRUNK COST REIMBURESEMENT FOR ADDITIONAL FLOW AS PER SHAKOPEE/CHASKA INTERCEPTOR COST SHARING AGREEMENT. Operating Costs: 2017 Capital Improvement Plan (CIP) SurfaceWaterProjects CityofShakopeeCapitalImprovementProgram 2017-2021 Project Title:Total Project Cost: Project Manager: Bruce LoneyProject Type: Storm Drainage West End Regional Pond & Trunk $300,000.00 Oversizing A. Expenditure Items:20172018201920202021 Land & ROW Construction 240,000 Improvements Engineering/Admin. 60,000 Total300,000 B. Funding Source: General Fund300,000 Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments SanitarySewerFund-Base SanitarySewerFund-TrunkStorm DrainageFund-BaseStorm DrainageFund-TrunkTaxLevy Total300,000 Description: Additional capacity of ponding and better rate control of drainage entering into the Upper Valley Drainage system. Justification: Contol of water rates are important to manage the system and reducing the potential of flooding downstream. Other Comments: The oversizing of ponds and pipes will be coordinated with development. Operating Costs: CityofShakopeeCapitalImprovementProgram 2017-2021 Project Title:Total Project Cost: Project Manager: Bruce LoneyProject Type: Storm Drainage Blue Lake Channel Regional Storm $100,000.00 Pond A. Expenditure Items:20172018201920202021 Land & ROW Construction Improvements Engineering/Admin. Total100,000 B. Funding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments SanitarySewerFund-Base SanitarySewerFund-TrunkStorm DrainageFund-BaseStorm DrainageFund-TrunkTaxLevy Total100,000 Description: Regional ponding of storm water, west of CSAH 83 to control storm water rate and quality. Justification: Management of storm water in this area is necessary to prevent flooding and management of water from areas south of the pond. Other Comments: Construction of ponding would be done with development. Operating Costs: CityofShakopeeCapitalImprovementProgram 2017-2021 Project Title:Total Project Cost: Project Manager: Bruce LoneyProject Type: Storm Drainage Blue Lake Channel Cooperative $100,000.00 Regional Storm Pond A. Expenditure Items:20172018201920202021 Land & ROW Construction Improvements Engineering/Admin. Total100,000 B. Funding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments SanitarySewerFund-Base SanitarySewerFund-TrunkStorm DrainageFund-BaseStorm DrainageFund-TrunkTaxLevy Total100,000 Description: To construct a Joint Regional Pond with the SMSC on the Blue Lake Channel prior to outletting to the Prior Lake Channel. Justification: Control of storm water by ponding and infiltration prior to the Prior Lake Channel is good management of storm water. Other Comments: Joint Powers Agreement with the SMSC would be necessary on this joint venture. Operating Costs: CityofShakopeeCapitalImprovementProgram 2017-2021 Project Title:Total Project Cost: Project Manager: Bruce LoneyProject Type: Storm Drainage CSAH 15 Ditch Improvements$85,000.00 A. Expenditure Items:20172018201920202021 Land & ROW Construction 70,000 Improvements Engineering/Admin. 15,000 Total85,000 B. Funding Source: General Fund Capital Improvement Fund Park Reserve Fund Grants (specify) Donations (specify) State Aid Assessments SanitarySewerFund-Base SanitarySewerFund-TrunkStorm DrainageFund-BaseStorm DrainageFund-TrunkTaxLevy Total85,000 Description: To remove ditch on the west side of CR 15 to facilitate the placement of trail. Justification: Ditch will not be necessary upon development and storm sewer will allow for curb & gutter and trail placement. Other Comments: Coordination with MnDOT and approval of CH 15 Turnback Agreement is needed. Operating Costs: CapitalEquipment FLEET MANAGEMENT BY SHAKOPEE PUBLIC WORKS DEPARTMENT 2017 BUDGET 2017 Requests Administration • Facility Maintenance • Public Works • Park Maintenance • Sanitary Sewer • Storm Drainage • Street Maintenance • Fire • Police • Parks and Recreation • Ice Arena • Administration Facility Maintenance Scissor Lift: $15,000 • Additionto fleet • Public Works Park Maintenance Hook Truck w/Equipment: $290,000 • Replace2002 Sterling Hook Truck (#111) • Light-Duty Truck 2x4: $50,000 • Replace2007 F550 2x4 (#145) • Retain for seasonal • Enclosed Trailer: $20,000 • Additionto fleet • Ice Resurfacer 3pt. Hitch: $15,000 • Additionto fleet • V-Plow for Skid Steer: $7,000 • Additionto fleet • Public Works Park Maintenance Stump Grinder: $10,000 • Additionto fleet • Rotary Blade Grinder: $12,500 • Additionto fleet • Tractor: $7,500 • Replace –Repurchase Agreement2015 JD5085 (#143) • Skid Steer Loaders (2): $9,000 • Replace –Repurchase Agreement2016 Bobcat (#15416 and #17416) • Sanitary Sewer Eductor: $100,000 • Replace2002 Versa Vac (#140) • Public Works Storm Drainage All-Terrain Utility Vehicle: $32,000 • Additionto the fleet • Portable Steamer: $15,000 • Additionto the fleet • Jack Hammer: $8,000 • Additionto the fleet • Skid Steer Loader w/Tracks: $5,000 • Replace –Repurchase Agreement2016 CAT 287D (#16616) • Tractor: $7,500 • Replace –Repurchase Agreement2015 JD5085 (#17215) • Public Works Street Maintenance Single Axle Dump Truck w/Equipment: $250,000 • Replace2002 Sterling Dump Truck (#101) • Skidsteer Loader: $4,500 • Replace –Repurchase Agreement2016 Bobcat (#14716) • Fire Chief’s Vehicle: $46,000 Replace2010 Ford Explorer (#9503) • Parks and Recreation Ice Arena Ice Resurfacer : $130,000 Replace2007 Olympia Ice Resurfacer (#0700) • Police Marked Patrol (4): $196,000 Replace4 purchased in 2013 (#9131, 9132, 9133, 9134) • Unmarked Patrol (1): $49,000 Replace1 purchased in 2013 (#9135) • 10-Year Projection Click image below to open full document Projected Fund Levels Equipment Replacement Projected Fund Levels 2017-2026 Capital Improvement Program City of Shakopee, Minnesota SOURCES2017201820192020202120222023202420252026 Miscellaneous Rentals878,328895,894913,812932,088950,730969,745989,1401,008,9221,029,1011,049,683 Sale of Assets Interest10,00010,00010,00010,00010,00010,00010,00010,00010,00010,000 Total Revenue888,328905,894923,812942,088960,730979,745999,1401,018,9221,039,1011,059,683 EXPENDITURES: Uses Capital Equipment1,109,5001,504,750778,000778,0001,162,0001,230,750509,000783,7501,729,0002,286,750 Total Expenditures1,109,5001,504,750778,000778,0001,162,0001,230,750509,000783,7501,729,0002,286,750 EXCESS (DEFICIENCY OF SOURCES OVER USES) Cash Balance January 14,045,0713,823,8993,225,0433,370,8553,534,9443,333,6743,082,6683,572,8083,807,9813,118,081 Cash Balance December 31$3,823,899$3,225,043$3,370,855$3,534,944$3,333,674$3,082,668$3,572,808$3,807,981$3,118,081$1,891,014