## City Council Agenda Monday, July 13, 2026 ## 4:00 PM ## Roseville Fire Station In accordance with Minnesota Statutes §13D.02 and City policy, Council and Commission members may attend meetings remotely up to three times per calendar year. (Times listed are approximate – please note that items may be earlier or later than listed on the agenda) 4:00 p.m. 1. Roll Call ## Voting & Seating Order: Groff, Strahan, Schroeder, Bauer, and Roe 4:01 p.m. 2. Pledge of Allegiance 4:02 p.m. 3. Approve Agenda 4:03 p.m. 4. Public Comment 4:08 p.m. 5. Recognitions and Donations 4:13 p.m. 6. Items Removed from Consent Agenda ## 7. Business Items 4:15 p.m. a. Discuss 2027 City Budget ## 8. Council Direction on Councilmember Initiated Agenda Items ## 9. Approval of City Council Minutes ## 10. Approve Consent Agenda ## 11. Future Agenda Review, Communications, Reports, and Announcements - Council ## and City Manager 7.00 p.m. 12. Adjourn Page 1 of 192 ## REQUEST FOR COUNCIL ACTION Date: 7/13/2026 Item No.: 7.a. ## Department Approval City Manager Approval ## Item Description: Discuss 2027 City Budget Page 1 of 3 1 2Background 3As part of the 2027 budget development process, the July 13 work session provides City 4Council with an opportunity to review and discuss departmental budget requests before 5development of the City Manager's recommended budget. This discussion builds on the 6April 20, 2026, work session when the City Manager provided an initial overview of 7anticipated budget pressures and sought Council feedback on budget priorities. At that 8meeting, Council requested an additional opportunity to review departmental requests as 9the budget process continued. 10During the July 13 work session, Council will review departmental budget requests, the 11services and outcomes those requests support, their alignment with the Strategic Plan and 12City Manager goals, and the estimated impact on taxpayers. The discussion is intended to 13provide Council with additional context regarding departmental needs and priorities and to 14gather feedback that will help inform development of the City Manager's recommended 152027 budget. 16Based on the preliminary financial analysis prepared by the Finance Director and City 17Manager, fully funding the current service levels approved in the 2026 budget, together with 18all departmental requests as submitted, would require an estimated 11.95% levy increase. 19This estimate reflects projected increases in personnel costs, including the addition of 4.5 ## 20FTEs (Police Sergeant, Police Department Investigative Aide, Parks Maintenance worker, 21Recreation Coordinator, and part-time Volunteer Coordinator), contractual services, 22supplies, equipment, and other operating expenses. 23It is important to recognize several key points regarding this estimate: 241. The estimate includes the ongoing cost of the 22 public safety positions approved as 25part of the 2026 budget. Those investments were intentionally made in 2026 and 26continue into future budget years. 272. The 11.95% estimate is not the City Manager's proposed levy. Rather, it 28represents the financial impact of funding all departmental requests before any 29organizational prioritization or budget balancing has occurred. 303. The purpose of this discussion is to provide Council with an understanding of 31departmental needs and to gather feedback on priorities. That feedback, together 32with additional financial analysis and organizational prioritization, will inform the City Page 2 of 192 Page 2 of 3 33Manager's recommended budget, which will be presented to the City Council on 34August 24, 2026. 35At this stage of the budget process, the projected levy increase should be viewed as a 36planning estimate rather than a recommendation. Between now and presentation of the 37recommended budget, staff will continue refining revenue and expenditure projections, 38evaluating organizational priorities, and identifying opportunities to balance community 39expectations, service levels, and taxpayer impacts. The July 13 work session is an 40important step in that process and provides Council with an opportunity to help shape the 41City Manager's recommended 2027 budget before it is presented later this summer. 42Greater detail about 2027 Budget Department requests and their impacts to taxpayer are 43included as attachment in the packet. 44 45Policy Objectives 46This budget discussion is directly tied to the strategic plan's City Operations strategic 47direction. The success indicator for Goal #3 - Resource allocation meets operational needs 48while advancing strategic priorities states the following: 49• Budgeting includes prioritization of strategic goals while balancing operational needs 50• Decision-makers report having the right information to allocate resources effectively. 51 52 ## 53Equity Impact Summary 54The budget development process considers how proposed investments support equitable 55access to City services, compliance with accessibility requirements, and the City's Strategic 56Plan. Council feedback received during this work session will help inform development of a 57recommended budget that serves the needs of the community. 58 59Budget Implications 60No budget action is requested as part of this agenda item. The financial information 61presented reflects a preliminary analysis of departmental budget requests and estimated 622027 operating costs. Based on current assumptions, funding all departmental requests as 63submitted would require an estimated 11.95% levy increase. This estimate is intended to 64inform Council's discussion and does not represent the City Manager's recommended 65budget. The recommended 2027 budget will be presented to the City Council on August 24, 662026, following additional financial analysis, organizational prioritization, and budget 67refinement. 68 69Staff Recommendations 70Receive the presentation, discuss the departmental budget requests and preliminary 71financial analysis, and provide feedback to the City Manager to inform development of the 72recommended 2027 budget. 73 ## 74Requested Council Action 75Receive the presentation, discuss the departmental budget requests and preliminary 76financial analysis, and provide feedback to the City Manager to inform development of the 77recommended 2027 budget. Page 3 of 192 Page 3 of 3 78 79 Prepared by: ## Attachments: ## 1. City Budget Memo ## 2. Department Budget Memos ## 3. Budget Scenario Presentation ## 4. 2027-2036 CIP ## 5. 2037-2046 CIP 80 Page 4 of 192 Page 1 ## City Manager’s Office ## Memo ## To: Roseville City Council ## cc: Rachael Tierney, City Attorney ## From: Patrick Trudgeon, City Manager ## Sam Magureanu, Finance Director Date: July 13, 2026 ## Re: 2027 Budget ## INTRODUCTION Effectively summarizing the key drivers of the previous budget is essential for building a clear and informed foundation for the upcoming financial planning cycle. By highlighting the major factors that influenced past spending and revenue outcomes, we improve transparency, support data-driven decision-making, and ensure that leadership and stakeholders share a consistent understanding of the forces shaping our fiscal position. A concise summary also helps identify trends, clarify assumptions, and guide strategic adjustments for the year ahead. ## 2026 FINAL BUDGET HIGHLIGHTS The 2026 gross levy totaled $33,048,741, representing an increase of $2,331,282 or 7.59% over the 2025 gross levy. The primary cost driver in the 2026 budget is increased personnel spending due to the addition of 22 public safety positions. Fifteen of these positions are firefighters whose costs are partially offset by the SAFER grant awarded in 2025. The SAFER grant is a three-year award that funds 75% of the new firefighters’ costs in the first two years and 35% in the third year, not to exceed $3,930,039 over the grant period. After accounting for the grant funding, $388,015 of new property tax levy was added in 2026 to cover the remaining firefighter personnel costs. The remaining seven new public safety positions were added to the Police Department (four patrol officers, two patrol sergeants, and one civilian Records Supervisor). These positions are partially offset by the 2025 COPS grant, which covers the salary of one new patrol officer. As a result, a total of $836,000 in new tax levy was added to the 2026 budget to support these police personnel costs. In addition to the personnel costs noted above, the 2026 budget also introduced utility franchise revenues generated from fees added to residents’ monthly energy bills. These revenues were primarily introduced to support several capital funds. By using franchise fee revenues to cover Page 5 of 192 Page 2 a portion of capital needs, the City was able to free up existing tax levy dollars and reduce the size of the levy increase that was ultimately approved. ## 2027 PROPOSED BUDGET UPDATE In March 2026, the Finance Director and City Manager began compiling data to develop an early estimate of the key cost drivers for the 2027 budget. This initial review focused on maintaining existing programs, staffing, and service levels as approved in the 2026 budget. The preliminary information—shared with the City Council at the April 20, 2026 work session— indicated a minimum projected levy increase of 9.36%. Since that time, City staff have refined their requests to better align with anticipated operating and capital needs, as well as the City’s 2026–2029 Strategic Plan. ## 2027 PROPOSED BUDGET/LEVY AND COMMUNITY IMPACT This section provides a high-level overview of the proposed 2027 levy and the projected impact on Roseville taxpayers. Detailed departmental budget memos and analysis are included as attachments. The proposed 2027 levy reflects an increase of 11.95%, or $3,948,974, over the prior year. 4.78% 5.99% 8.68% 5.38% 7.59% 11.95% 0.00% 2.00% 4.00% 6.00% 8.00% 10.00% 12.00% 14.00% 202220232024202520262027 ## City of Roseville Gross Levy Increase/Decrease History A median-valued home, assessed at $382,000, paid approximately $1,621.69 or $135.14 Monthly in City property taxes in 2026. For 2027, based on the projected tax rate increase and an anticipated 4.76% increase in median market value, that same home is estimated to pay $1,918.37 or $159.86 Monthly—an increase of $296.69 or 18.21% over 2026. Page 6 of 192 Page 3 ## Taxable Market ValueCity TaxTaxable Market ValueCity Tax 250,0001,061.31$ 261,9001,255.48$ 194.17$ 16.18$ 382,0001,621.69$ 400,1831,918.37$ 296.69$ 24.72$ 450,0001,910.36$ 471,4202,259.86$ 349.50$ 29.13$ 500,0002,122.63$ 523,8002,510.96$ 388.33$ 32.36$ 650,0002,759.41$ 680,9403,264.25$ 504.83$ 42.07$ 800,0003,396.20$ 838,0804,017.54$ 621.34$ 51.78$ ## Increase/Decrease ## Monthly ## Increase/Decrease ## Tax Year 2026Tax Year 2027 ## RESIDENTIAL SINGLE HOME - Median Market Value Change 4.76% It is important to note that general property tax levies support only the City’s governmental operations. They do not fund Enterprise Funds, which rely primarily on utility user charges. As a result, enterprise operations do not impact property tax levies. A summary of the preliminary proposed levy by fund and category is presented in the table below. Page 7 of 192 Page 4 ## GOVERNMENTAL FUNDS ## REVENUE HIGHLIGTS – Total Budgeted Revenues $73,271,133. The total budget includes $36,997,715.12 Property Tax Revenues. ## • Intergovernmental Revenues Intergovernmental revenues remain relatively flat overall, increasing 5.53percent or $314,160. However, changes vary considerably at the fund and account level. A significant driver is a $1,785,000 decrease in the budgeted use of Municipal State Aid ## (MSA) within the Pavement Management Program Capital Fund. MSA usage fluctuates annually depending on the scheduled street improvement projects. In contrast, General Fund intergovernmental revenues increase by $974,160, primarily due to a full-year allocation of the SAFER grant for the Fire Department ($578,596 more than 2026) as well as additional police and state grants. The 2027 budget further incorporates revenues from several grants, including the COPS grant, State Navigator grant, Crisis Response, and BCA Opioid grant. • Licenses & Permits Licenses and Permits revenues remain relatively stable overall, increasing 8.95 percent (or $166,437). Approximately $172,000 of this increase is attributable to the Community Development Fund, reflecting budget adjustments that align more closely with recent actual revenue trends. • Charges for Services Charges for Services revenues remain relatively stable overall, increasing 4.78 percent (or $346,079). Approximately $139,127 of this increase is attributable to projected revenues for the License and Passport Center, which are anticipated to rise in alignment with projected budgeted expenditures. • Miscellaneous Miscellaneous Revenues show a significant increase in the 2027 budget of $12,606,454. The primary driver of this change is the anticipated issuance of $14,500,000 in bond proceeds to support construction of the new Passport and License Center building. Page 8 of 192 Page 5 $36,997,715 51% $2,050,000 3% $5,991,362 8% $2,026,770 3% $7,581,629 10% $82,500 0% $2,720,000 4% $- 0% $240,000 0% $329,634 0% $15,251,523 21% ## Governmental Funds Revenues by Type ## General Property TaxesTax IncrementsIntergovernmental Revenue ## Licenses & PermitsCharges for ServicesFines and Forfeits ## Franchise FeesSpecial AssessmentsTransfer In ## Investment IncomeMiscellaneous Additional details on Revenues are presented in the attached department memos. ## EXPENDITURES HIGLIGHTS – Total Budgeted Expenditures $78,394,215. The total budget includes $27,275,275 Capital Expenditures. ## • Personnel Cost Personnel Costs are projected to increase by $3,883,782, or 11.86%, in 2027. The most significant drivers for this growth are within the Police and Fire Departments. Police Department personnel costs are increasing by $1,924,341, reflecting the following: ✓ Two new positions: One additional Detective and the addition of an Investigation Aid in Police Administration. ✓ Implementation of the 2027 pay schedule and employee promotions ✓ Substantial increase in the overtime budget due to paid family leave utilization, detective on-call compensation, and expanded in-person training requirements. The Fire Department is experiencing a $1,056,844 increase in personnel costs, primarily attributable to multiple staff promotions and rising overtime needs. Additionally, the budget includes 15 new positions totaling $2,330,398, partially offset by SAFER grant funding that covers 75% ($1,747,798.43) of these costs, leaving a 25% City share of $582,599.48. The Parks and Recreation Department is proposing to add 1 new Park Maintenance position and 1 new Recreation Coordinator position for the Nature Center. Page 9 of 192 Page 6 The Administration Department is proposing to add a part-time (0.5 FTE) Volunteer Coordinator position to assist in volunteer management. ## • Contractual Services Contractual Services a $613,891 increase or 11.18%. Approximately $392,000 relates to the AXON Police Contract. ## • Capital Outlay The large increase of $15,344,776 includes $14,500,000 for the new Passport and ## License Center building $36,635,566 47% $1,527,773 2% $6,103,314 8% $882,000 1% $5,645,287 7% $27,275,275 35% $325,000 0% ## Governmental Funds Expenditures by Type ## Personnel ServicesSupplies & MaterialsContractual Services ## UtilitiesOther ChargesCapital Outlay ## Transfers Out Additional Expenditures detail presented in the attached department memos. 5,017,688 6% 25,200,143 32% 3,759,330 5%7,317,191 9% 4,699,077 6% 3,616,660 5% 2,210,000 3% 323,703 0% 3,065,000 4% 23,185,425 30% ## How Property Tax Dollars are Spent ## General Government ## Public Safety ## Streets & Highways ## Culture & Recreation ## Economic Development ## Miscellaneous Expenditures ## Debt Service: Principal ## Interest & Fiscal Charges ## Streets & Highways Construction Page 10 of 192 Page 7 ## GOVERNMENTAL FUNDS SUMMARY ## 2025 Actual2025 Budget2026 Budget2027 Budget 2026 to 2027 ## Budget Change % 2026 to 2027 Change $ ## Revenues ## General Property Taxes29,756,07330,717,45933,048,74136,997,71511.95%3,948,974 ## Tax Increments2,191,4802,305,0002,185,0002,050,000-6.18%(135,000) ## Intergovernmental Revenue3,093,1203,031,5405,677,2025,991,3625.53%314,160 ## Licenses & Permits2,295,6502,067,5101,860,3332,026,7708.95%166,437 ## Charges for Services7,556,6546,913,6227,235,5507,581,6294.78%346,079 ## Fines and Forfeits96,82970,00080,00082,5003.13%2,500 ## Franchise Fees303,776354,0002,720,0002,720,0000.00%- ## Special Assessments157,10083,00083,000--100.00%(83,000) ## Investment Income2,443,188316,718558,389329,634-40.97%(228,755) ## Miscellaneous2,851,1381,021,9632,645,06915,251,523476.60%12,606,454 ## Total Revenues50,745,00746,880,81256,093,28473,031,13330.20%16,937,849 ## Expenditures ## Personnel Services28,714,42128,486,29832,751,78436,635,56611.86%3,883,782 ## Supplies & Materials1,359,7801,543,1651,486,8651,527,7732.75%40,908 ## Contractual Services5,410,0555,707,3755,489,4236,103,31411.18%613,891 ## Utilities876,960902,935912,700882,000-3.36%(30,700) ## Other Charges4,707,4935,236,4825,698,4065,645,287-0.93%(53,119) ## Capital Outlay7,355,5068,864,44512,132,50027,275,275124.81%15,142,775 ## Total Expenditures48,424,21550,740,70058,471,67878,069,21533.52%19,597,537 ## Other Financing Sources (Uses) ## Transfers In2,572,363700,000240,000240,0000.00%- ## Transfers Out4,091,038200,000240,000325,00035.42%85,000 ## Total Other Financing Sources (Uses) 6,663,401900,000480,000565,00017.71%85,000 ## Beginning Fund Balance45,853,87546,655,99346,655,99344,277,599-5.10%(2,378,394) ## Net Income Change802,117(3,359,888)(2,378,394)(5,123,082)115.40%(2,744,688) ## Ending Fund Balance46,655,99343,296,10544,277,59939,154,517-11.57%(5,123,082) Page 11 of 192 Page 8 ## ENTERPRISE FUNDS SUMMARY (UTILITY FUNDS AND GOLF COURSE FUND) Detail analysis presented in the attached department memos. ## 2025 Actual2025 Budget2026 Budget2027 Budget 2026 to 2027 Budget Change % $ Change ## Revenues ## Intergovernmental Revenue567,287.74204,690.00154,665.00--100.00%(154,665) ## Charges for Services21,582,278.9322,671,950.0024,733,179.0025,515,941.573.16%782,763 ## Investment Income464,924.9312,500.0092,500.0075,000.00-18.92%(17,500) ## Miscellaneous522,596.94212,000.0054,000.0054,000.000.00%- ## Total Revenues23,137,088.5423,101,140.0025,034,344.0025,644,941.572.44%610,598 ## Expenditures ## Personnel Services2,498,081.632,467,940.002,574,134.002,757,866.657.14%183,733 ## Supplies & Materials631,999.26545,540.00615,540.00701,200.0013.92%85,660 ## Contractual Services1,659,257.731,715,680.001,686,513.001,810,135.007.33%123,622 ## Utilities10,532,149.6610,702,720.0011,257,938.0011,828,819.005.07%570,881 ## Other Charges1,147,078.421,504,710.001,528,671.001,797,511.0017.59%268,840 ## Capital Outlay4,496,043.726,236,000.007,474,000.008,079,000.008.09%605,000 ## Total Expenditures20,964,610.4223,172,590.0025,136,796.0026,974,531.657.31%1,837,736 ## Other Financing Sources (Uses) ## Transfers In82,168.5968,000.0066,000.0085,000.0028.79%19,000 ## Transfers Out---- ## Total Other Financing Sources (Uses)82,168.5968,000.0066,000.0085,000.0028.79%19,000 ## Beginning Fund Balance59,144,61261,399,25961,399,25961,362,807-0.06%(36,452) ## Net Income Change2,254,647(3,450)(36,452)(1,244,590)3314.33%(1,208,138) ## Ending Fund Balance61,399,25961,395,80961,362,80760,118,217-2.03%(1,244,590) ## HISTORICAL TAX ANALYSIS 335,400 349,900 360,500 378,600 382,000 400,183 4.32%3.03%5.02% 0.90% 4.76% - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 202220232024202520262027 Projected ## Home ValueChangeLinear (Home Value) ## Median Single Family Home Valuation Changes Last Five Years Page 12 of 192 Page 9 ## HOW DO WE COMPARE - RAMSEY COUNTY $1,290.70 $1,283.90 $1,358.68 $1,546.96 $1,621.69 $1,918.37 $(6.80) $74.78 $188.28 $74.72 $296.69 (500.00) - 500.00 1,000.00 1,500.00 2,000.00 2,500.00 202220232024202520262027 Projected ## City Property TaxChangeLinear (City Property Tax) City Property Tax Last Five Years on a Median Single Family Home 5,002 5,232 9,490 9,993 10,590 11,037 12,644 12,841 13,108 22,374 23,479 26,939 35,637 40,142 ## FALCON HEIGHTS ## NORTH OAKS ## ARDEN HILLS ## ST. ANTHONY ## LITTLE CANADA ## TOWN OF WHITE BEAR ## NORTH ST. PAUL ## MOUNDS VIEW ## VADNAIS HEIGHTS ## NEW BRIGHTON ## WHITE BEAR LAKE ## SHOREVIEW ## ROSEVILLE ## MAPLEWOOD - 5,000 10,000 15,000 20,000 25,000 30,000 35,000 40,000 45,000 ## 2024 Ramsey County Cities Population Page 13 of 192 Page 10 3.88% 6.37% 6.89% 7.03% 7.94% 8.01% 8.01% 8.74% 8.96% 9.18% 9.65% 10.95% 11.73% 12.50% ## FALCON HEIGHTS ## NEW BRIGHTON ## MOUNDS VIEW ## TOWN OF WHITE BEAR ## MAPLEWOOD ## NORTH ST. PAUL ## ROSEVILLE ## SHOREVIEW ## WHITE BEAR LAKE ## VADNAIS HEIGHTS ## ST. ANTHONY ## LITTLE CANADA ## NORTH OAKS ## ARDEN HILLS 0.00%2.00%4.00%6.00%8.00%10.00%12.00%14.00% ## Ramsey County Cities - Net Tax Levy Percent Change Final 2025 to Final 2026 St. ## Ant ho ny ## Little ## Cana da ## Falcon ## Height s ## Mounds ## View ## North ## Oaks ## Town of ## White ## Bear ## White ## Bear ## Lake ## North St. ## Paul ## Shoreview ## Arden ## Hills ## New ## Brig hton ## Vadnais ## Heights ## MaplewoodRoseville ## Per Capita 290.72 516.41 576.25 587.01 596.80 602.26 630.36 681.43 689.16 714.60 720.39 730.93 855.71 919.94 - 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 1,000.00 ## Ramsey County Cities Tax Levy per Capita Page 14 of 192 Page 11 ## HOW DO WE COMPARE – COMPARABLE CITIES ## CountyMunicipality20252026$ Change% Change ## Hennepin Brooklyn Center26,371,74127,633,3721,261,6314.78% ## AnokaFridley21,677,59522,960,4001,282,8055.92% ## Hennepin Richfield29,907,56931,749,3811,841,8126.16% ## WashingtonOakdale19,127,12820,319,7821,192,6546.24% ## AnokaCoon Rapids38,373,08241,295,3812,922,2997.62% ## Hennepin St. Louis Park48,785,53252,529,0173,743,4857.67% ## Hennepin Minnetonka55,124,69359,486,1184,361,4257.91% ## RamseyMaplewood31,823,65634,349,8562,526,2007.94% ## Hennepin Edina58,750,85463,427,6734,676,8197.96% ## RamseyRoseville30,352,60332,783,9152,431,3128.01% ## DakotaEagan52,862,15557,540,7004,678,5458.85% ## DakotaBurnsville52,886,98757,711,6234,824,6369.12% Final Levy 2025 to 2026 Changes 30,588 31,126 32,500 36,400 36,593 40,700 50,000 54,000 54,450 64,290 64,500 68,000 ## Oakdale ## Fridley ## Brooklyn Center ## Roseville ## Richfield ## Maplewood ## St. Louis Park ## Minnetonka ## Edina ## Coon Rapids ## Burnsville ## Eagan - 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 ## Population Page 15 of 192 Page 12 4.78% 5.92% 6.16% 6.24% 7.62% 7.67% 7.91% 7.94% 7.96% 8.01% 8.85% 9.12% ## Brooklyn Center ## Fridley ## Richfield ## Oakdale ## Coon Rapids ## St. Louis Park ## Minnetonka ## Maplewood ## Edina ## Roseville ## Eagan ## Burnsville 0.00%1.00%2.00%3.00%4.00%5.00%6.00%7.00%8.00%9.00%10.00% 2025 to 2026 Levy Increase/Decrease $20,319,782 $22,960,400 $27,633,372 $31,749,381 $32,783,915 $34,349,856 $41,295,381 $52,529,017 $57,540,700 $57,711,623 $59,486,118 $63,427,673 ## Oakdale ## Fridley ## Brooklyn Center ## Richfield ## Roseville ## Maplewood ## Coon Rapids ## St. Louis Park ## Eagan ## Burnsville ## Minnetonka ## Edina $- $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 $70,000,000 ## Final 2026 Net Levy Page 16 of 192 Page 13 ## CAPITAL ASSETS BUDGETARY LEVY IMPACT The City of Roseville maintains a wide range of capital assets that support the delivery of high-quality services to our community. These assets include streets and pathways, parks, buildings, utility systems, vehicles, and equipment that residents rely on every day. Managing these resources responsibly is essential to maintaining our community’s safety, functionality, and long-term financial stability. To plan for the future, the City uses a 20-year capital planning approach that identifies major asset replacements, maintenance needs, and strategic investments. This long-range planning helps ensure that essential infrastructure remains in good condition, minimizes unexpected costs, and allows the City to align capital needs with available funding. By taking a proactive approach, Roseville can continue to provide reliable services while maintaining strong financial stewardship on behalf of residents and businesses. For fiscal year 2026, the City’s gross levy for capital infrastructure totaled $2,833,000, representing 8.57% of the overall City levy of $33,048,741. The recommended preliminary gross levy for capital infrastructure in 2027 is $3,080,650, an increase of $247,650 compared to the prior year. This increase reflects an estimated 0.75% impact on the total levy, based on the assumption that approximately $330,487 corresponds to a 1% levy change in the proposed 2027 preliminary budget. ## Coon ## Rapids ## OakdaleFridleyMaplewoodEagan ## Brooklyn ## Center ## RichfieldBurnsvilleRoseville St. ## Louis ## Park ## MinnetonkaEdina ## Per Capita 642 664 738 844 846 850 868 895 901 1,051 1,102 1,165 - 200 400 600 800 1,000 1,200 1,400 ## Taxes Per Capita Page 17 of 192 Page 14 The recommended increase in capital levy reflects an assessment of projected cash and reserve needs across all capital funds, ensuring that sufficient resources are available to support the full schedule of CIP investments. ## Inflationary Costs The 2027–2046 CIP plan incorporates a new expenditure line item to capture inflationary costs for the next 19 years, starting in 2028. This addition is essential because the proposed 20-year CIP relies on present-day cost estimates and does not factor in future inflation impacts. The inflation adjustment is applied on a compounding basis. A 1% increase is added each year, meaning the inflation factor is 1% in the first year, 2% in the second year, 3% in the third year, and so on. Each annual increase is calculated as a percentage of the total budgeted expenditure. A detailed schedule of the proposed 2027-2046 CIP is attached to this report. Page 18 of 192 ## Department Budget Memo: ## Community Development ## Budget Summary ## Total Proposed Budget: $2,599,076.94 2026 Adopted Budget: $2,500,621.00 Year over year change: +$98,455.94 (+3.94%) ## Key Changes and Drivers ## Cost Increases: ## Personnel • Personnel increases include step increases and COLA adjustments ## Supplies & Materials • Minor increases in clothing costs to reflect anticipated staff turnover • Postage increases to reflect actual spending (namely for nuisance compliance). ## Contractual/Professional Services • Professional service cost increases due to inflationary impacts on software licenses (Accela), Metro-Inet contracts, and administrative and communications internal service charges • Additional funding was included to accommodate 2050 comprehensive planning consultant services • Additional funding was included in anticipation of increased EDA attorney support and cost ## Cost Reductions/Containment: • Minor equipment decreases to reflect computer replacement schedule (only one computer scheduled for replacement in 2027) Page 19 of 192 • Reductions in motor fuel and vehicle maintenance costs due to newer, electrical vehicles comprising 50% of fleet (2 of 4 vehicles) • Telephone savings by moving mobile devices to a new service plan through T-Mobile • Advertising and printing costs within the Planning Division decreased due to a reduction in land use applications • Training decreases in the Planning Division to reflect actual spending • Costs for energy audit, energy squad, and home advisor visits through CEE were removed from EDA operating fund 725 and will be funded from existing fund balance in fund 722 (Abatements) based on EDA direction from May 11, 2026 Opportunities for revenue enhancement: • Certain permit revenues were adjusted upwards to reflect anticipated permit activity increases based on pipeline projects and improved economic conditions • Future fee schedule updates may include increases to certain fees that are based on staff time to align with personnel increases ## Advancing the Strategic Plan This budget helps Community Development advance the city’s strategic plan by: ## Community and Civic Engagement • As the city prepares its 2050 comprehensive planning update, we anticipate several community engagement efforts to inform the community about the plan update. ## Economic Vitality • The Economic Development Authority (EDA) provides support and guidance for Local Affordable Housing Aide (LAHA) programming to advance housing options for residents at all income levels and housing types. ## Reliable and Sustainable Infrastructure • An anticipated replacement of a 10-year old inspection vehicle with an electric vehicle will support the city’s climate action plan (if we can’t acquire an electric vehicle off the State contract, we’ll delay one year). Page 20 of 192 ## Department Budget Memo: Public ## Works - Non-Utility Funds ## Budget Summary ## Total Proposed Budget: $5,213,520.09 2026 Adopted Budget: $4,956,218.00 Year over year change: $257,302.09 (+5.19%) ## Key Changes and Drivers ## Cost Increases: ## Personnel • Personnel increases include step increases and COLA adjustments • Increased overtime costs for planned events such as Rosefest ## Supplies/Materials • We do not anticipate any increases in supplies and material cost ## Contractual/Professional Services • Increased cost of GIS software • Increased building maintenance costs related to increased HVAC, overhead door and other miscellaneous repairs to better reflect actual costs • Increased costs in street lighting repairs • Increased Right of Way (ROW) tree removal costs • One-time cost for hiring a consultant for Transportation Plan update as part of the Comprehensive Plan update ## Budget Function ## PW Administration ## Category2026 Budget2027 Proposed$ Change% ChangeStreets ## ExpendituresStreet Lighting ## Personnel2,635,163.002,743,222.09108,059.094.10%Building Maintenance ## Supplies & Materials378,200.00348,370.00(29,830.00)-7.89%Central Garage ## Contractual Services1,315,528.001,459,680.00144,152.0010.96%Environmental ## Utilities393,300.00393,300.00-0.00%Engineering ## Other Charges234,027.00268,948.0034,921.0014.92% ## Total4,956,218.005,213,520.09257,302.095.19% ## Revenues - Excludes Property Tax ## Special Assesments ## Licenses & Permits121,250.00125,700.004,450.003.67% ## Intergovernmental501,000.00501,000.00-0.00% ## Charges for Services65,000.0065,000.00-0.00% ## Miscellaneous8,500.0079,500.0071,000.00835.29% ## Interest Earnings10,000.0010,000.00-0.00% ## Total705,750.00781,200.0075,450.0010.69% ## Organizational Responsibility: Public Works Director Page 21 of 192 ## Cost Reductions/Containment: • Reduced supplies by budgeting for less bituminous patching due to better pavement conditions because of investments in pavement rehabilitation projects • New vendor for janitorial supplies Opportunities for revenue enhancement: • The city will be providing additional engineering services for the City of Falcon Heights next year ## Advancing the Strategic Plan This budget helps Public Works advance the city’s strategic plan by: ## Reliable and Sustainable Infrastructure • Investments in city facilities and street lighting helps meet the goal of implementing a funding strategy that prioritizes key capital improvements that are planned, regularly assessed and evolve based on city values and changing community needs. ## City Operations • Investments in GIS technology will help improve operations by improving efficiency and capacity of staff to deliver high quality services. • Investments in workforce development and compensation will attract and retain staff leading to reduced turnover, higher quality of service, and departmental sustainability. ## Economic Vitality • Investments in updating the transportation plan, in cooperation with the 2050 comprehensive plan update, to help meet the goal of developing and advocating for safe, intentional, multi-modal transportation systems throughout Roseville. Page 22 of 192 ## Department Budget Memo: Public ## Works - Utility Funds ## Budget Summary ## Total Proposed Budget: $25,049,633.79 2026 Adopted Budget: $23,395,953.00 Year over year change: $1,653,680.79 (+7.07%) ## Key Changes and Drivers ## Cost Increases: ## Personnel • Personnel increases include step increases and COLA adjustments • Increased overtime cost due to planned events such as Rosefest ## Supplies/Materials • Increased cost of water supplies such as pipes, hydrants and valves • Increased cost of postage due to additional mailing related to meter replacements ## Contractual/Professional Services • Increased cost of GIS software • Increased cost of some specialized storm sewer maintenance (underground Best ## Management Practices - BMP’s) Increased Saint Paul Regional Water Services (SPRWS) costs for purchasing water ## • Increased Metropolitan Council Environmental Services cost for wastewater services ## Budget Function ## Water ## Category2026 Budget2027 Proposed$ Change% ChangeSewer ## ExpendituresStorm ## Personnel2,037,199.002,158,181.79120,982.795.94% ## Supplies & Materials488,400.00570,400.0082,000.0016.79% ## Contractual Services772,505.00831,005.0058,500.007.57% ## Utilities11,240,138.0011,811,019.00570,881.005.08% ## Other Charges1,449,711.001,685,028.00235,317.0016.23% ## Capital Outlay7,408,000.007,994,000.00586,000.007.91% ## Total23,395,953.0025,049,633.791,653,680.797.07% ## Revenues - Excludes Property Tax ## Charges for Services23,145,474.0023,779,535.42634,061.422.74% ## Miscellaneous47,000.0047,000.00-0.00% ## Interest Earnings90,000.0075,000.00(15,000.00)-16.67% ## Transfer In ## Total23,282,474.0023,901,535.42619,061.422.66% ## Organizational Responsibility: Public Works Director Page 23 of 192 ## Cost Reductions/Containment: • Decrease the fuel budget to more accurately reflect actual usage • Evaluating the purchase of leak detection equipment so this can be done with staff instead of an outside vendor Opportunities for revenue enhancement: • Increased utility revenues through increase in utility rates ## Advancing the Strategic Plan This budget helps Public Works advance the city’s strategic plan by: ## Reliable and Sustainable Infrastructure • Investments in water, sewer and storm sewer maintenance operations helps meet the goal of implementing a funding strategy that prioritizes key capital improvements that are planned, regularly assessed and evolve based on city values and changing community needs. ## City Operations • Investments in GIS technology will help improve operations by improving efficiency and capacity of staff to deliver high quality services. • Investments in workforce development and compensation will attract and retain staff leading to reduced turnover, higher quality of service, and departmental sustainability. Page 24 of 192 ## Department Budget Memo: Parks and ## Recreation ## Budget Summary ## Total Proposed Budget: $8,112,358.86 ## Total Projected Revenue: $3,837,625.00 2026 Adopted Budget: $7,379,406.00 Year over year change: $732,952.86 (+9.93%) ## Key Changes and Drivers ## Cost Increases: ## Personnel • Steps and COLA adjustments for full-time and seasonal employees • Recreation Coordinator position • Park Maintenance position • Increased seasonal staffing at the Roseville Skating Center due to reduced contract maintenance, increased open skate participation, expanded banquet room rentals, and growth in Roseville Skate School programming. ## Supplies and Materials • Increases associated with inflation and operational costs. ## Contractual/Professional Services ## • Consultant to lead Parks and Recreation System Master Plan ## Budget Function ## Recreation Administration ## Category2026 Budget2027 Proposed$ Change% ChangeRecreation Fee Programs ## ExpendituresRecreation Non Fee ## Personnel4,740,131.005,265,864.86525,733.8611.09%Nature Center ## Supplies & Materials532,005.00535,985.003,980.000.75%Skating Center ## Contractual Services1,122,750.001,335,955.00213,205.0018.99%Activity Center ## Utilities480,800.00448,800.00(32,000.00)-6.66%Park Maintenenace ## Other Charges437,720.00440,754.003,034.000.69%Golf Course ## Capital Outlay66,000.0085,000.0019,000.0028.79% ## Total7,379,406.008,112,358.86732,952.869.93% ## Revenues - Excludes Property Tax ## Charges for Services541,000.00658,300.00117,300.0021.68% ## Non Fee Programs35,350.0043,900.008,550.0024.19% ## Recreation Fee Programs1,433,895.001,468,225.0034,330.002.39% ## Nature Center109,500.00118,500.009,000.008.22% ## Skating Center1,380,700.001,438,700.0058,000.004.20% ## Interest27,500.0025,000.00(2,500.00)-9.09% ## Transfer In66,000.0085,000.0019,000.0028.79% ## Total3,593,945.003,837,625.00243,680.006.78% ## Organizational Responsibility: Parks and Recreation Director Page 25 of 192 • Inflationary increases across multiple service categories, including entertainment and event support services • Additional professional services support for specialized maintenance activities associated with aging infrastructure, regulatory requirements, and evolving community expectations ## Cost Reductions/Containment: • Staff continue to actively evaluate operations to identify efficiencies, reduce costs, and maximize the value provided to residents. • The department is evaluating the installation of electronic access controls at park buildings and warming houses, which could further reduce staffing needs associated with facility access and monitoring. • Staff will pilot a new facility rental model that eliminates routine on-site staffing for many rentals, reducing personnel costs while maintaining customer service expectations. • A new custodial approach at the Roseville Skating Center has reduced contracted cleaning costs. Seasonal staff are now performing portions of this work while also supporting banquet room set-up and event operations. • Implementation of a new recreation management software system is expected to generate approximately $35,000 in annual savings compared to the previous platform. • Recent capital improvements at the Roseville Skating Center have reduced utility consumption, allowing operational funds to be redirected toward service delivery and staffing needs. • Several recreation programs that were experiencing declining participation have been reduced or discontinued. Staff resources have been reallocated to emerging programs and activities with higher demand and stronger cost recovery potential • Supplies and materials for the Natural Resources Management program will be paid for primarily with the Conservation Partners Legacy grant fund • Budget factors in a three-week shut down of Roseville Skating Center Ice Arena (revenue loss of approximately $35,000) for completion of roof, boards, and painting. Utilizes fee increases, and savings to keep levy impact consistent with the 2026 budget despite shut down. These efforts reflect the department's ongoing commitment to balancing high-quality services with responsible stewardship of taxpayer resources. ## Opportunities for Revenue Enhancement: • Fees in all fee-based recreational programs, golf, and skating programs will be increased to offset cost of operation. • Facility rental space prices will increase an average of 5% in 2027. • Increased greens fees by .50-.75 cents • Increased cart rental fees • Increased sponsorship efforts in several areas including: • Zamboni wrap Page 26 of 192 • Rosefest sponsorship • Summer concert sponsorship • Dance program growth has yielded additional revenue. • Skating school programs have grown, increasing revenue. ## Advancing the Strategic Plan This budget helps Parks and Recreation advance the city’s strategic plan by: ## Parks and Natural Environment • Expands environmental education, outdoor recreation opportunities, and community engagement through Harriet Alexander Nature Center programming ensuring all residents in the community have access to natural environment spaces. • Improves stewardship of park assets through enhanced preventative maintenance, inspection programs, and asset management practices that are thoughtfully planned, sustainably funded and well maintained. ## Responsive Services and Community Engagement • Expands recreation programming, community events, and entertainment opportunities to meet changing community needs. • Initiates a Parks and Recreation System Master Plan update to guide future investments and ensure community engagement occurs to inform priorities in long- term planning. ## Reliable and Sustainable Infrastructure • Improves the department's ability to proactively maintain parks, buildings, trails, and recreation infrastructure. • Supports data-driven asset replacement planning and long-term capital investment decisions. Page 27 of 192 ## Department Budget Memo: Fire ## Budget Summary ## Total Proposed Budget: $7,867,104.71 2026 Adopted Budget: $6,709,161.00 Year over year change: $1,157,943.71 (+17.26%) ## Key Changes and Drivers ## Cost Increases: ## Personnel • Personnel increases include the continuation of the city’s commitment to the additional 15 firefighters that are moderately funded with the FEMA SAFER grant. • Personnel increases include COLA adjustments and step increases. • These costs do not include the new contract with the firefighter union, Local 5051. • The overtime budget has been adjusted to better align with actual operational costs and service demands. Overtime costs continue to be impacted by several factors, including Paid Family and Medical Leave (PFML), workers’ compensation claims, instructor and field training responsibilities, state training mandates, recruitment and retention challenges and contractual obligations such as on-call detective pay. ## Supplies/Materials • Supply and equipment costs have increased to support staff growth. • There is an increase of about 20% in uniform replacement, station equipment and disposables, and operating supplies. ## Contractual/Professional Services • Increases occurred in contractual and professional services as 2027 will be the first full year with the growth of our additional staffing. ## Budget Function ## Fire Administration ## Category2026 Budget2027 Proposed$ Change% ChangeFire Operations ## ExpendituresEmergency Management ## Personnel6,229,708.007,286,552.151,056,844.1516.96% ## Supplies & Materials115,500.00140,000.0024,500.0021.21% ## Contractual Services208,500.00257,000.0048,500.0023.26% ## Utilities46,400.0047,400.001,000.002.16% ## Other Charges109,053.00136,152.5627,099.5624.85% ## Total6,709,161.007,867,104.711,157,943.7117.26% ## Revenues - Excludes Property Tax ## Licenses & Permits181,540.00171,000.00(10,540.00)-5.81% ## Intergovernmental1,509,202.002,127,798.43618,596.4340.99% ## Charges for Services64,500.0061,000.00(3,500.00)-5.43% Court Fines-2,500.002,500.00#DIV/0! ## Miscellaneous6,000.005,000.00(1,000.00)-16.67% ## Total1,761,242.002,367,298.43606,056.4334.41% ## Organizational Responsibility: Fire Chief Page 28 of 192 • These items include department training costs, embedded mental health specialist, required annual medical exams, medical direction from Regions EMS, software and records management system subscriptions, and station and equipment maintenance. ## Cost Reductions/Containment: • Conference requests will remain stable year over year. • Increased usage of the electric fire engine while responding to calls will reduce fuel costs and support the city’s sustainability goals. • Emergency management budgeting remained neutral or had slight decreases. Opportunities for revenue enhancement: • The multi-family licensing fees have remained consistent with no increase since 2023. • We recently dedicated a full-time employee to multi-family licensing and expect increased capacity to increase the number of licenses the city processes annually. • Additionally, with inflationary costs and staff time considered, there may be an opportunity to increase this fee to collect additional revenue. ## Advancing the Strategic Plan This Budget helps the Fire Department advance the city’s strategic plan by: ## Responsive Services and Safety: • A larger workforce allows Fire to respond to community emergency calls more appropriately with improved response times, operational efficiency, and customer service. • Additional staffing allows for more proactive safety efforts, including prevention planning and early intervention to support the community’s needs. • Investing in necessary equipment and supplies and materials increases the safety of firefighters when responding to calls. ## City Operations • Leveraging our contractual services such as our mental health specialist and annual exams will ensure our firefighters stay mentally, emotionally and physically fit for duty and increase our ability to attract, retain and develop our staff. ## Reliable and Sustainable Infrastructure: • A full year of usage of the electric fire engine will advance our climate action plan goals by lowering the department’s carbon footprint and use of fuel. Page 29 of 192 ## Department Budget Memo: Police ## Budget Summary ## Total Proposed Budget: $17,285,338.17 2026 Adopted Budget: $14,804,130.00 ## Year Over Year Change: + $2,481,208.17 (+16.76%) ## Key Changes and Drivers ## Cost Increases: ## Personnel • Much of the budget increase is driven by contractual obligations associated with Police Department collective bargaining agreements, including step increases and COLA adjustments. • Funding is included for an Investigative Aide position to support investigative operations, manage the growing volume of digital evidence, and improve case processing efficiency, consistent with recommendations from the Axtell staffing study and the Police Department’s five-year work plan. • Funding is included for a Detective position to address increasing case volume and investigative complexity, consistent with recommendations from the Axtell staffing study and the Police Department’s five-year work plan. • The overtime budget has been adjusted to better align with historical expenditures and current operational demands. Unlike many other industries, law enforcement must maintain minimum staffing levels 24/7 to ensure emergency response capabilities are not compromised. As a result, absences due to Paid Family and Medical Leave (PFML), injuries, training requirements, vacancies, and turnover must be covered to sustain required service levels. In addition, overtime is impacted by contractual obligations such as on-call detective coverage, increased ## Budget Function ## Police ## Category2026 Budget2027 Proposed$ Change% Change ## Expenditures ## Personnel12,867,372.0014,791,713.171,924,341.1714.96% ## Supplies & Materials470,500.00515,500.0045,000.009.56% ## Contractual Services1,013,658.001,514,775.00501,117.0049.44% ## Other Charges452,600.00463,350.0010,750.002.38% ## Total14,804,130.0017,285,338.172,481,208.1716.76% ## Revenues - Excludes Property Tax ## Special Assesments ## Licenses & Permits40,000.0040,000.00-0.00% ## Intergovernmental1,372,000.001,576,564.00204,564.0014.91% ## Charges for Services292,000.00302,000.0010,000.003.42% ## Court Fines80,000.0080,000.00-0.00% ## Miscellaneous25,000.0036,000.0011,000.0044.00% ## Total1,809,000.002,034,564.00225,564.0012.47% ## Organizational Responsibility: Chief of Police Page 30 of 192 training requirements associated with hiring and retention efforts, and workers’ compensation-related absences. • The budget includes annualized funding for a position approved during 2026 that was not fully reflected in the prior-year budget. ## Supplies/Materials • Operational costs continue to increase due to inflationary pressures. • Facility maintenance and operational costs continue to increase due to the age of the Police Department facility, deferred maintenance needs, and increasing space demands. • Minor equipment increases are tied to the computer replacement schedule and additional computers needed within PD. • Supply and equipment costs have increased to support staffing growth and expanded operational requirements. • Uniform costs are tied to inflationary increases, staffing increases, as well as additional PPE required for OSHA and state mandates. ## Contractual/Professional Services • Implementation of the new Axon Record Management System (RMS) and technology platform, including body-worn camera and digital evidence management systems, Taser replacement programs, and related technology services. • Dispatch service costs continue to increase due to rising regional public safety communication and emergency dispatch expenses. • Professional service costs increased due to inflationary impacts including wellness consultant fees, firearm destruction costs, investigative software, drone software, cell phone extraction system upgrades, officer training tracking, and increased costs to meet accreditation and POST mandated requirements. • Increased consultant fees for Animal Control Hearing Officer (no longer offered by the Humane Society). • Increased software costs for mobile Computer Aided Software to address security risks due to recent increase in cyber-attacks. ## Cost Reductions/Containment: • The Department continues to leverage grants and external partnerships to reduce reliance on local tax-supported funding. Several positions are partially or fully supported through grants or partner funding agreements, including the Violent Crime Detective, Auto Theft Investigator, two School Resource Officers, two Retail ## Crime Officers, Social Worker, and Housing Navigator positions. Additional grant and outside funding has supported accreditation efforts, bullet-resistant vest reimbursements, and the acquisition of a rescue vehicle through the Police Foundation. • Staff continue to review cell phone plans, software subscriptions, and technology contracts to identify opportunities for long-term cost savings and operational efficiencies. • With the planned implementation of a new Axon Records Management System (RMS) in 2028, the Department anticipates reducing or eliminating several redundant software platforms and services that will be consolidated under the new system. • Reserve officer program funding is on hold while the program is reimagined. Page 31 of 192 • The Department continues to evaluate operational processes, technology usage, and service delivery models to identify efficiencies while maintaining service levels and public safety response capabilities. Opportunities for revenue enhancement: • The State of Minnesota is reinstating some funding for mandated training costs that were reduced in 2025, which will help offset some training increases. • The Department will continue pursuing grant opportunities and reimbursement programs to offset operational costs, enhance service delivery, and reduce the impact on the local tax levy. • Future fee schedule updates may include additional adjustments related to actual licensing costs (e.g. massage therapy licensing). ## Advancing the Strategic Plan This budget helps the Police Department advance the city’s strategic plan by: ## Responsive Services and Safety: • Continued investment in public safety technology, including real-time data systems, records management tools, and operational technology that improve situational awareness, response times, operational efficiency, and customer service. • Continued implementation of the five-year Police Department staffing plan based on recommendations from the Axtell staffing study, including the addition of investigative staff to address increasing workload demands, improve case follow-up capacity, and support proactive policing efforts. • Ongoing pursuit of state, federal, and regional grant opportunities to enhance public safety operations, training, equipment, and technology while helping reduce the financial impact on local taxpayers. • Investment in training, technology, and operational resources ensures the department can adapt to evolving community expectations, maintain transparency, and deliver responsive public safety services. • Continued investment in investigative resources, digital evidence management, and crime analysis capabilities to ensure the department has the personnel, technology, and information necessary to respond effectively to emerging public safety challenges. ## City Operations: • Investment in the new Axon Records Management System (RMS) and other public safety technologies to streamline operations, improve information sharing, enhance reporting capabilities, and increase organizational efficiency. • Continued investment in employee wellness initiatives, training, workforce development, and retention strategies to attract and retain high-quality officers and professional staff while supporting long-term organizational sustainability. Page 32 of 192 ## Department Budget Memo: ## Administration ## Budget Summary ## Total Proposed Budget: $4,270,031.16 2026 Adopted Budget: $4,169,245.00 Year over year change: $100,786.16 (+2.42%) ## Key Changes and Drivers ## Cost Increases: ## Personnel • A requested part-time Volunteer Coordinator position • Step increases and COLA adjustments • Appropriate calculation of overtime for Police Department attendance at council meetings. • It also includes medical insurance and other benefits such as PFML. ## Supplies/Materials • No changes are proposed for office supplies and materials. Although inflation may affect the cost, it is anticipated that budgets/purchases will be able to be adjusted or delayed remaining within the allocated amount. • Minor equipment increases are tied to the computer replacement schedule. • An increase in volunteer recognition costs reflects an increase in the number of volunteers. ## Contractual/Professional Services • Professional service costs increased due to inflationary impacts across several services and contracts including minutes, software, website hosting, legal services, Metro-Inet contracts, and background checks. ## Category2026 Budget2027 Proposed$ Change% ChangeBudget Function ## ExpendituresCouncil ## Personnel1,858,962.001,999,290.16140,328.167.55%Fire Relief ## Supplies & Materials4,100.004,100.00-0.00%Administration ## Contractual Services1,769,155.001,711,594.00(57,561.00)-3.25%Elections ## Other Charges537,028.00555,047.0018,019.003.36%Communications ## Total4,169,245.004,270,031.16100,786.162.42% ## Revenues - Excludes Property Tax ## Special Assesments ## Licenses & Permits245,543.00246,070.00527.000.21% ## Charges for Services1,329,105.001,427,177.0098,072.007.38% ## Miscellaneous87,000.0087,000.00-0.00% ## Transfer In200,000.00200,000.00-0.00% ## Total1,861,648.001,960,247.0098,599.005.30% ## Organizational Responsibility: City Council & City Manager Page 33 of 192 • Costs also include a single financial audit in addition to the annual audit that is conducted due to federal requirements. • Contract maintenance category also includes increases for services that are conducted on a multi-year schedule. These include a market study and pay equity reporting requirements. • Election administration costs are expected to increase due to additional election judges, precincts, and enhanced security measures. • Additional funding was included for website accessibility and WCAG 2.0 compliance training and updates. • Memberships (both organizational such as LMC, Metro Cities, and personal memberships such as MCMA), legal notices, and other minor operational costs continue to have inflationary increases. ## Cost Reductions/Containment: • The community survey was removed from the 2027 budget as it occurs every two years. • The wellness plan was reduced to reflect the reduction in reimbursement funds received in addition to feedback received during the strategic planning process. This program will be reevaluated in 2026-2027 to ensure it meets the needs and desired impacts before adding additional resources. • The number and type of conferences were reduced. • Employee development training was reduced to reflect the ability to do some of the training in-house. • Staff is exploring a pilot project to determine whether AI-generated meeting minutes could reduce staff time or long-term costs. • More accurate personnel allocation calculations were used in Communications budget. Opportunities for revenue enhancement: Future fee schedule updates may include additional adjustments related to licensing costs, specifically massage therapy licensing, as part of a broader initiative currently under review. ## Advancing the Strategic Plan This budget helps Administration advance the city’s strategic plan by: ## Community and Civic Engagement: • Improves access to City information through website accessibility, translation services, and communications that help residents stay informed, engaged, and connected to city decisions. ## City Operations • Invests in technology, workforce development, compensation planning and organizational improvements that help employees be more nimble, forward thinking, and work more efficiently to support high-quality public service delivery. Page 34 of 192 ## Responsive Services & Safety • Supports transparent government through secure elections, legal compliance, and accessible communication that strengthens public trust and accountability. Page 35 of 192 ## Department Budget Memo: Finance ## Budget Summary ## Total Proposed Budget: $4,087,555 2026 Adopted Budget: $3,893,967 Year over year change: $193,588 (+4.97%) ## Key Changes and Drivers ## Cost Increases: ## Personnel • Costs increase due to three positions being reclassified to move from their current grade to the new higher grade resulting in an additional total impact of $7,534. • The budget also includes COLA and step increases for all eligible employees. ## Supplies/Materials • A 3% increase is included to account for ongoing inflationary pressures on operational costs. • Postage for the License Center increases by $7,000, reflecting actual usage trends and rising volume. ## Contractual/Professional Services • A 3% increase is applied for inflation • A scheduled $1,945 increase for BS&A in 2027 • A $6,000 for a new platform for CIP budget. The CIP platform was implemented in 2026 as an unbudgeted item. • $275 for GFOA new PAFR certification. • Transfers Out: The transfer amount remains unchanged for 2027 and continues to represent the annual operating cost contribution to the General Fund from the License Center. ## Budget Function ## Finance ## Category2026 Budget2027 Proposed$ Change% ChangeCentral Services ## ExpendituresGeneral Insurance ## Personnel3,078,8673,241,502162,6355.28%License Center ## Supplies & Materials66,85068,2681,4182.12%Lawful Gambling ## Contractual Services371,490382,19010,7002.88% ## Utilities10,00010,3003003.00% ## Other Charges166,760185,29618,53611.12% ## Transfer Out200,000200,000-0.00% ## Total3,893,9674,087,555193,5884.97% ## Revenues - Excludes Property Tax ## Charges for Services2,621,0002,760,127139,1275.31% ## Interest Earnings12,13412,134-0.00% ## Transfer In ## Total2,633,1342,772,261139,1275.28% ## Organizational Responsibility: Finance Director Page 36 of 192 ## Cost Reductions/Containment: • Cost containment has been addressed by limiting budgetary increases to anticipated inflationary pressures, and in some cases, maintaining costs at flat levels where feasible. • All current expenditures associated with operating the Finance Department and the License Center remain essential to maintaining service levels, meeting statutory requirements, and supporting the City’s core financial functions. • These operations continue to rely on baseline staffing, technology systems, and contractual services that cannot be reduced without negatively impacting service delivery, internal controls, or compliance. • As a result, the 2027 budget reflects the continuation of existing cost structures. Opportunities for revenue enhancement: • The 2027 revenues are driven primarily by License Center charges for services and follow State and Federal guidance. • These have been projected to increase in line with operational cost adjustments, resulting in a balanced budget in which revenues are expected to match expenditure. ## Advancing the Strategic Plan This budget helps Finance advance the city’s strategic plan by: ## Community and Civic Engagement: • Introducing the Popular Annual Financial Report (PAFR) to provide residents with a more accessible, user-friendly overview of the City’s financial activities and to enhance transparency and community understanding. ## City Operations: • Continuing to explore and implement technology solutions that improve efficiency and service delivery. The 2027 Budget includes the rollout of a new Capital Improvement Plan (CIP) platform designed to streamline processes, enhance project tracking, and support long-term financial planning. Page 37 of 192 ## City Of Roseville ## Budget and Strategic Plan Follow up July 2026 Page 38 of 192 1.Purpose of our meeting ## 2.2027 Budget Scenario and Impact ## 3.2027 Department Budget Presentations 4.Discussion and feedback 5.Budget Timeline 6.Wrap up ## Agenda Page 39 of 192 1.Share necessary information for council to make informed decisions 2.Council receive department budget request without changes from the City Manager 3.Guide early development of the recommended budget ## This is directly tied to Strategic Plan City Operations – Goal #3 Success Indicators ØBudgeting includes prioritization of strategic goals while balancing operational needs. ØDecision-makers report having the right information to allocate resources effectively. Purpose of our meeting Page 40 of 192 1.Where are we today? •High-level overview of the final 2026 levy 2.What makes up the Budget Scenario? •High level overview of the proposed levy scenario ## •Governmental Funds Revenues and Expenditures •How the money is spent 3.What does this mean for taxpayers? •Projected taxes and impact for single family homes 4.How do we compare? •Historical trends and data ## 5.Capital Assets Budget Levy Impact ## •Police Vehicle & Equipment Fund ## •General Facilities Fund ## 2027 Budget Scenario and Impact Page 41 of 192 Where are we today? 1.Gross Levy: $33.05M, up $2.33M (7.59%) from 2025 2.Primary Cost Driver: Addition of 22 public safety positions §Fire Department: 15 new firefighters supported by the 2025 SAFER grant (75% funding in years 1-2, 35% in year 3; up to $3.93M total). §Police Department: 7 new positions (4 patrol officers, 2 sergeants, 1 civilian supervisor). One patrol officer offset by the 2025 COPS grant 1.Franchise Fees: Help fund capital needs, which in turn reduced the amount of levy increase required ## 2026 Budget Highlights Page 42 of 192 Where are we today? 1.April baseline estimate: A status quo budget projected a minimum 9.36% levy increase for 2027. 2.Since April, departments submitted budget requests that have been aligned with the 2026-2029 Strategic Plan 3.Including all department requests the preliminary levy impact would be an increase of 11.95% or $3,948,974.12 ## 2027 Budget Snapshot Page 43 of 192 ## 2027 Budget Scenario and Impact 1.Where are we today? 2.What makes up the Budget Scenario? 3.What does this mean for taxpayers? 4.How do we compare? ## 5.Capital Assets Budget Levy Impact Page 44 of 192 ## 2027 Levy Scenario by Fund and Category What makes up the Budget Scenario? Page 45 of 192 What makes up the Budget Scenario? ## REVENUE HIGHLIGHTS – Total Budgeted Revenues $73,271,133 Page 46 of 192 ## Revenue Changes What makes up the Budget Scenario? 1.Intergovernmental Revenues – an increase of $314,160 2.License & Permits – Increase of $166,437 3.Charges for Services – Increase of $346,079 4.Miscellaneous – Increase $12,606,454 (includes $14.5M bond proceeds) Page 47 of 192 ## EXPENDITURES HIGHLIGHTS – Total Budgeted Expenditures $78,394,215 What makes up the Budget Scenario? Page 48 of 192 ## Expenditure Changes 1.Personnel Cost – an increase of $3,883,782 2.Contractual Services – an increase of $613,891 3.Capital Outlay – an increase of $15,142,775 (includes $14,500,000 for the new Passport and License Center) What makes up the Budget Scenario? Page 49 of 192 ## Governmental Funds Expenditures in 2027 Proposed Budget by Function Page 50 of 192 ## Budget Summary – ## Governmental ## Funds What makes up the Budget Scenario? Page 51 of 192 1.Where are we today? 2.What makes up the Budget Scenario? 3.What does this mean for taxpayers? 4.How do we compare? ## 5.Capital Assets Budget Levy Impact ## 2027 Budget Scenario and Impact Page 52 of 192 ## Median Home Impact What does this mean for taxpayers? ## NOTE: Property Tax Levies Support only the City’s Governmental Operations, NOT Enterprise Funds, which rely primarily on utility user charges. ## Median Valued Home ($400,183) Total City Tax per month $159.86 Page 53 of 192 Home Valuations – Last 5 years 202220232024202520262027 Projected - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 335,400 349,900 360,500 378,600 382,000 400,183 4.32%3.03%5.02%0.90%4.76% ## Median Single Family Home Valuation Change Last Five Years ## Home ValueChangeLinear(Home Value) What does this mean for taxpayers? Page 54 of 192 Levy Increases  – Last 5 years What does this mean for taxpayers? Page 55 of 192 Property Taxes – Last 5 years What does this mean for taxpayers? 202220232024202520262027 Projected - 500.00 1,000.00 1,500.00 2,000.00 2,500.00 (500.00) $ 1,290.70 $ 1,283.90 $ 1,358.68 $ 1,546.96 $ 1,621.69 $ 1,918.37 $ (6.80) $ 74.78 $ 188.28 $ 74.72 $ 296.69 City Property Tax Last Five Years on a Median Single Family Home ## City Property TaxChangeLinear(City Property Tax) Page 56 of 192 1.Where are we today? 2.What makes up the Budget Scenario? 3.What does this mean for taxpayers? 4.How do we compare? ## 5.Capital Assets Budget Levy Impact ## 2027 Budget Scenario and Impact Page 57 of 192 How do we compare? - 5,000 10,000 15,000 20,000 25,000 30,000 35,000 40,000 45,000 ## Falcon Heights ## North Oaks ## Arden Hills ## St. Anthony ## Little Canada ## Town of White Bear ## North St. Paul ## Mounds View ## Vadnais Heights ## New Brighton ## White Bear Lake ## Shoreview ## Roseville ## Maplewood 5,002 5,232 9,490 9,993 10,590 11,037 12,644 12,841 13,108 22,374 23,479 26,939 35,637 40,142 ## 2024 Ramsey County Cities Population Page 58 of 192 0.00%2.00%4.00%6.00%8.00%10.00%12.00%14.00% ## Falcon Heights ## New Brighton ## Mounds View ## Town of White Bear ## Maplewood ## North St. Paul ## Roseville ## Shoreview ## White Bear Lake ## Vadnais Heights ## St. Anthony ## Little Canada ## North Oaks ## Arden Hills 3.88% 6.37% 6.89% 7.03% 7.94% 8.01% 8.01% 8.74% 8.96% 9.18% 9.65% 10.95% 11.73% 12.50% Ramsey County Cities - Net Tax Levy Percent Change Final 2025 to Final 2026 This comparison excludes the EDA Levy since not all communities have an EDA levy. How do we compare? Page 59 of 192 290.72 516.41 576.25 587.01 596.80 602.26 630.36 681.43 689.16 714.60 720.39 730.93 855.71 919.94Per Capita ## St. AnthonyLittle Canada ## Falcon ## Heights ## Mounds ## View ## North Oaks Town of ## White Bear ## White Bear ## Lake North St. ## Paul ## ShoreviewArden Hills ## New ## Brighton ## Vadnais ## Heights ## MaplewoodRoseville - 100.00 200.00 300.00 400.00 500.00 600.00 700.00 800.00 900.00 1,000.00 ## Ramsey County Cities Tax Levy per Capita How do we compare? Page 60 of 192 - 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 ## Oakdale ## Fridley ## Brooklyn Center ## Roseville ## Richfield ## Maplewood ## St. Louis Park ## Minnetonka ## Edina ## Coon Rapids ## Burnsville ## Eagan 30,588 31,126 32,500 36,400 36,593 40,700 50,000 54,000 54,450 64,290 64,500 68,000 ## 2024 Comparable Cities Population How do we compare? Page 61 of 192 0.00%1.00%2.00%3.00%4.00%5.00%6.00%7.00%8.00%9.00%10.00% ## Brooklyn Center ## Fridley ## Richfield ## Oakdale ## Coon Rapids ## St. Louis Park ## Minnetonka ## Maplewood ## Edina ## Roseville ## Eagan ## Burnsville 4.78% 5.92% 6.16% 6.24% 7.62% 7.67% 7.91% 7.94% 7.96% 8.01% 8.85% 9.12% Comparable Cities - Net Tax Levy Percent Change Final 2025 to Final 2026 How do we compare? Page 62 of 192 How do we compare? 642.33 664.31 737.66 843.98 846.19 850.26 867.64 894.75 900.66 1,050.58 1,101.59 1,164.88Per Capita Coon RapidsOakdaleFridleyMaplewoodEaganBrooklyn CenterRichfieldBurnsvilleRosevilleSt. Louis ParkMinnetonkaEdina - 200.00 400.00 600.00 800.00 1,000.00 1,200.00 1,400.00 ## Comparable Cities Tax Levy per Capita Page 63 of 192 How do we compare? Page 64 of 192 ## 2027 Budget Scenario and Impact 1.Where are we today? 2.What makes up the Budget Scenario? 3.What does this mean for taxpayers? 4.How do we compare? ## 5.Capital Assets Budget Levy Impact Page 65 of 192 ## Capital Assets Budget Levy Impact Page 66 of 192 ## Capital Assets Budget Levy Impact Page 67 of 192 ## Assumes: 2027 - $150,000 Levy increase – New Levy $450,000 2028 - $100,000 Levy increase – New Levy $550,000 2029 - $100,000 Levy Increase – New Levy $650,000 2030 - $100,000 Levy increase – New Levy $750,000 2031 to 2036 – Levy flat at $750,000 ## Capital Assets Budget Levy Impact Page 68 of 192 No Change in Levy – at $300,000 for the next 10 years ## Capital Assets Budget Levy Impact Page 69 of 192 ## Capital Assets Budget Levy Impact Page 70 of 192 Levy Forecast – 3 Year outlook ## Assumptions: Ø6% for personnel cost Ø3% to 4% for all other ØRevenues were projected conservatively based on actual trends (licenses and permits, charges for services) or in line with expectations (grants) ØCapital Asset Levies were increased to meet projected needs Page 71 of 192 ## Key Considerations •Prior decisions create ongoing costs ## Previous Investments •Protecting the city's existing assets & infrastructure ## Stewardship •Maintain the services residents expect ## Service Levels •Balance taxpayer impacts with long-term community needs ## Community Impact Page 72 of 192 ## Q & A Questions? ## 2027 Budget Scenario –  Questions Page 73 of 192 ## Department Budget ## Presentations Page 74 of 192 ## Community Development Page 75 of 192 ## 2027 Budget Update - Community Development Budget at-a-Glance The proposed 2027 budget increases 3.94% over 2026. Increases are a result of personnel costs, inflationary impacts in services and supplies, comprehensive planning consulting services, and EDA attorney cost. What the numbers don’t tell you: This budget prioritizes advancement of the city’s tax base through development and planning, while aligning with regional needs through the 2050 comprehensive planning process. It increases legal support for LAHA programming to address community housing needs. We also advance the climate equity action plan in fleet upgrades. ## 2026 Budget2027 BudgetChangeStrategic Priorities $2,500,621$2,599,076.94 3.94% ## Economic Vitality ## Community & Civic Engagement Page 76 of 192 ## 2027 Budget Update - Community Development ## Key Investments ## InvestmentWhy it MattersOutcome ## Comp Plan ## Update Required by law, informs city land use decisions. Comprehensive strategy for land use in the city. ## EDA Legal ## Services Increased legal expertise to inform EDA on programming. Funds are programmed and expensed in a way that meets community needs. ## Scheduled Fleet ## Upgrade Outdated fleet has increased maintenance cost, utilize competitive state contract pricing. Electric fleet supports goals in the climate equity action plan and reduces fuel cost. Page 77 of 192 ## 2027 Budget Update - Community Development ## Decision Making We choose toInstead of....Because... Budget 2050 comprehensive plan as a technical update A broad community visioning process Envision Roseville and recent strategic planning efforts Electric fleet upgradesKeeping current vehicleCompetitive state contract pricing, lower fleet maintenance cost, less fuel usage and support climate equity action plan Reduce training and conferences budget Maintaining historical funding levels Staff are more selective of development opportunities and the areas they want strengthen Reallocate funding to continue home energy programs Relying on levy support to fund a non-essential service for Roseville homeowners Residents are more likely to make energy conscious decisions by utilizing the program Page 78 of 192 ## 2027 Budget Update - Community Development ## Strategic Plan Alignment Strategic PriorityHow this budget advances it Economic VitalityEDA support for LAHA programing that supports community needs at various levels of the housing continuum. ## Community & Civic ## Engagement Keeping community informed during the development of the 2050 comprehensive plan. ## Reliable and Sustainable ## Infrastructure Continues fleet upgrade with electric vehicles to support the city's sustainability goals. 2027 will begin the 2050 comprehensive plan process which will extend through 2028, contributing to overall efforts that strengthen our tax base. 2027 will develop and implement new LAHA programming ensuring Roseville expenses its funds in ways that address Roseville specific needs. ## Key Take-Aways Page 79 of 192 ## Public Works ## Non-Utility Funds Page 80 of 192 ## 2027 Budget Update - Public Works Non-Utility Funds Budget at-a-Glance The proposed 2027 budget increases 5.19% over 2026. Most increases are driven by contractual obligations related to technology, facilities maintenance and personnel cost. New investments are focused on the 2050 comprehensive plan. The budget invest in city streets and organizational facility needs. What the numbers don’t tell you: Residents interact with our Public Works services everyday. This includes infrastructure, engineering and city sustainability efforts. This budget enhances and improves that experience. Street and building investments are required to maintain resident satisfaction with our existing services. ## 2026 Budget2027 BudgetChangeStrategic Priorities $4,956,218$5,213,520.095.19% ## City Operations ## Reliable and Sustainable Infrastructure ## Economic Vitality Page 81 of 192 ## 2027 Budget Update - Public Works Non-Utility Funds ## Key Investments ## InvestmentWhy it MattersOutcome 2050 ## Transportation ## Plan Required part of the 2050 comprehensive plan. People have multi-modal options to connect to places they want and need. Increase in facility maintenance cost To maintain city operations, facilities require maintenance to remain functional. Less service delivery interruptions to meet community need. Page 82 of 192 ## 2027 Budget Update - Public Works Non-Utility Funds ## Decision Making We choose toInstead of....Because... Reduce bituminous patching Keep ordering moreInvestments in pavement rehabilitation have improved pavement conditions. Changed janitorial supply vendor Keeping previous vendorWe realized cost savings and maintained product reliability Page 83 of 192 ## 2027 Budget Update - Public Works Non-Utility Funds ## Strategic Plan Alignment Strategic PriorityHow this budget advances it City OperationsGIS technology improves efficiency and capacity. ## Reliable & Sustainable ## Infrastructure Long range plan for facility and street lighting needs. Economic VitalityUpdating transportation plan to include multi-modal transportation systems. City Hall and Police Department require investment to maintain existing building functionality to remain operational. Long range planning investments (2050 Comp plan and facility needs assessments) are required to help us be more informed when making decisions about investment in our infrastructure. ## Key Take-Aways Page 84 of 192 ## Public Works ## Utility Funds Page 85 of 192 ## 2027 Budget Update - Public Works Utility Funds Budget at-a-Glance The proposed 2027 budget increases 7.07% over 2026. Most increases are driven by contractual obligations for specialized services and operating cost. The budget invest in water management, delivery infrastructure, and treatment. What the numbers don’t tell you: Residents interact with our utilities everyday. This budget enhances and improves that experience. Infrastructure investments are required to maintain resident satisfaction with our water and sewer delivery and stormwater management. ## 2026 Budget2027 BudgetChangeStrategic Priorities $23,395,953$25,049,633.797.07% ## City Operations ## Reliable and Sustainable Infrastructure Page 86 of 192 ## 2027 Budget Update - Public Works Utility Funds ## Key Investments ## InvestmentWhy it MattersOutcome Investment in maintaining stormwater infrastructure These services treat the water that is a part of our lakes, rivers and wetlands throughout the city. Improves water quality and residents' quality of life. Page 87 of 192 ## 2027 Budget Update - Public Works Utility Funds ## Decision Making We choose toInstead of....Because... Purchase leak detection equipment Using a contracting vendorWill create cost savings for the City Page 88 of 192 ## 2027 Budget Update - Public Works Utility Funds ## Strategic Plan Alignment Strategic PriorityHow this budget advances it City OperationsGIS technology improves efficiency and capacity. ## Reliable & Sustainable ## Infrastructure Long range plan for stormwater management and water and sewer delivery needs of the city. Investments are needed to maintain a reliable utility system. When utilities don’t function, the community knows, and it impacts their quality of life. ## Key Take-Aways Page 89 of 192 ## Parks and Recreation Page 90 of 192 ## 2027 Budget Update - Parks and Recreation Budget at-a-Glance The proposed 2027 budget increases 9.93% over 2026. Most increases are driven by personnel, new positions, and an update to the parks master plan. Other increases have largely been offset by revenue increases. The new investments are focused on supporting the increase in parks and natural spaces in the system and including community in the development of the master plan update. The budget continues investing in the core services to plan and maintain our Parks and Natural Environment. What the numbers don’t tell you: Parks and Recreation has experienced significant growth in facilities, amenities, programming, and community expectations Parks has added three parks, six park buildings, expanded Cedarholm's operations into a year-round facility, added approximately seven miles of trails, significantly expanded natural resource management efforts, and experienced substantial growth in recreation programming and Nature Center participation – while adding only one FTE in the past 11 years. ## 2026 Budget2027 BudgetChangeStrategic Priorities $7,379,406$8,112,358.869.93% ## Parks and Natural Environment ## Responsive Services ## Reliable & Sustainable Infrastructure ## Community & Civic Engagement Page 91 of 192 ## 2027 Budget Update - Parks and Recreation ## Key Investments ## InvestmentWhy it MattersOutcome High quality programs and infrastructure, while limiting levy impact All programs and services are evaluated for cost recovery and community value. Modest fee increases where appropriate, ongoing program and service evaluation, and improved alignment between cost, demand, and community benefit. Parks and ## Recreation System ## Master Plan Update Current plan is outdated and doesn’t represent the current state of the system or community needs. New plan will align with Comprehensive Plan process. More planful use of resources to ensure that the City’s investment aligns with the needs of the community. ## Recreation ## Coordinator Increases in programming in areas of opportunity and creates an employee development pipeline. Growth for in demand Nature Center and other recreation programs and improved staff development. ## Park Maintenance staff Better support for system growth and focus on preservation of forestry and natural resources. Improved operational response time to growing pathway and park building needs. Increased proactive maintenance. Page 92 of 192 ## 2027 Budget Update - Parks and Recreation ## Decision Making We choose toInstead of....Because... Update aging systems to be more efficient, effective, and save money. Maintaining the status quoIt yields improved customer experience and cost savings. Proactively invest in sustainable and cost saving infrastructure. Continuing reliance on traditional fossil fuels, or piecemeal repairs. It yields future cost savings and aligns with the City’s sustainability goals. Review and update fees and program costs Holding all fees flat despite rising costs Helps offset expenses & reduce the levy burden, while maintaining access to core services. Strategically invest in planning and staffing resources to ensure a nimble and forward- thinking P&R offerings Accepting reduced level of service, outdated planning, or falling behind neighboring communities. High quality parks and recreation programming is an economic driver and builds a more connected and healthy community. Page 93 of 192 ## 2027 Budget Update - Parks and Recreation ## Strategic Plan Alignment Strategic PriorityHow this budget advances it ## Parks and Natural ## Environment Increases nature programming and spaces for community to access and creates long range plan. ## Responsive Services and Safety Expands programming, events, and entertainment opportunities to respond to community needs. Reliable & ## Sustainable ## Infrastructure Uses data driven asset planning to proactively maintain the parks system. ## Community and Civic ## Engagement Engages community to inform long range planning of the parks system. Invests in organizational needs to ensure high level of service, capitalizes on current trends and needs, and supports a sustainable culture. Addresses immediate needs while developing long range plan where community input informs the future of our parks and recreation system. ## Key Take-Aways Page 94 of 192 ## Fire Page 95 of 192 ## 2027 Budget Update - Fire Budget at-a-Glance The proposed 2027 budget increases 17.26% over 2026. Most increases are driven by an continued implementation in the firefighter workforce (15) and their related supplies, materials, and training cost. The new investments are focused on improving emergency response times, improving workplace culture – staffing levels, and ability to proactively create a safer community. The budget continues investing in the core services to create a safe community. What the numbers don’t tell you: Establish staffing plan to address a greater than 40% increase in call volume over the last five years. Previous staffing model led to burnout and fatigue due to higher call volume per staffed firefighter and units; as well as slower response times. Establishes capacity and readiness for future emergency service demands and more appropriate response. More flexibility to prioritize community outreach and preventative emergency response planning and other non-emergency efforts. ## 2026 Budget2027 BudgetChangeStrategic Priorities $6,709,161$7,867,104.7117.26% ## City Operations ## Responsive Services and Safety Page 96 of 192 ## 2027 Budget Update - Fire ## Key Investments ## InvestmentWhy it MattersOutcome ## Continued implementation of workforce High call volume and emergency units oversaturated and out of position was leading to delayed response to emergencies and not providing appropriate personnel for emergencies. Better overall response and response times leading to a safer community. Supplies and equipment for new employee’s Staff increased by 40%, needs such as uniforms, subscriptions, equipment and operating supplies. With appropriate resources, Fire can better support community needs. Page 97 of 192 ## 2027 Budget Update - Fire ## Decision Making We choose toInstead of....Because... Reduce opportunities for conference participation. Maintaining status quo of training and development budget Still allow for training opportunities, but reformat how, when, and where we participate ## Increase EV engine usage when possible Continue response in gas powered vehicles Leading to more call distribution and less fuel cost ## Emergency ## Management ## Budgeting Maintain existing costs and look for potential reductions Look for opportunities and collaboration with emergency management training and projects Page 98 of 192 ## 2027 Budget Update - Fire ## Strategic Plan Alignment Strategic PriorityHow this budget advances it City OperationsCreates a multi-year resource allocation strategy for the workforce. ## Responsive Services and ## Safety Expands staff capacity to respond to high call volume, reduce delays, and provide appropriate response personnel for emergencies. Expanded capacity allows for appropriate readiness and better overall response to community emergency needs. Workforce development plan allows for better long-term city planning for resource allocation. ## Key Take-Aways Page 99 of 192 ## Police Page 100 of 192 ## 2027 Budget Update - Police Budget at-a-Glance ## 2026 Budget2027 BudgetChangeStrategic Priorities $14,804,130$17,285,338.1716.76% ## City Operations ## Responsive Services & Safety The proposed 2027 budget represents a 16.76% increase over 2026. The majority of the increase is driven by contractual obligations, including collective bargaining agreements, annual personnel costs, and targeted investments in investigative staffing and public safety technology. What the numbers don’t tell you: The Police Department continues to aggressively pursue grants and strategic partnerships to offset costs, reduce the impact on the local tax levy, and support innovation in policing. As policing becomes increasingly technology- and data-driven, the Department is investing in employees, training, and modern technology systems to improve operational efficiency, enhance transparency, and better serve the community. Page 101 of 192 ## 2027 Budget Update - Police ## Key Investments ## InvestmentWhy it MattersOutcome Add Detective Expands staff capacity & ## supports Axtell Study recommendations/five-year plan. Improve case follow-up, investigative capacity, and overall effectiveness. Add Investigative AideExpands staff capacity and ## supports Axtell Study recommendations/five-year plan. Improve operations and case outcomes. Provides critical investigative support. ## Axon RMS & ## Technology Upgrades Modernizes core public safety technology and replaces aging systems. Improved efficiency, stronger cybersecurity, and better service. ## Overtime Budget ## Adjustment Reflects current service demands, employee leave, and contractual obligations. Maintains service levels, and supports uninterrupted public safety operations. Page 102 of 192 ## 2027 Budget Update - Police ## Decision Making We choose toInstead of....Because... ## Implement the Axtell recommendations through a phased five-year plan Implement all recommendations immediately Balances operational needs with fiscal responsibility and reduces the impact on taxpayers Aggressively pursue grants and outside funding​ Fund all initiatives through the tax levy Maximizes outside funding, minimizes the burden on taxpayers, and supports investments in staffing, technology and community safety Invest in the Axon public safety technology platform and RMS Continue operating aging, disconnected systems Modernizes critical technology, strengthens cybersecurity, improves operational efficiency, and provides more predictable long-term costs Page 103 of 192 ## 2027 Budget Update - Police ## Strategic Plan Alignment Strategic PriorityHow this budget advances it ## City OperationsInvest in Records Management System to replace aging systems and improve operational efficiency. Responsive Services & SafetyTechnology investments improve situational awareness, response times, operational efficiency, and customer service. The 2027 budget implements the next phase of the five-year staffing plan and invests in critical technology upgrades, including the Axon RMS. Our focus is to make strategic investments today that strengthen public safety and prepare the department for tomorrow's challenges. ## Key Take-Aways Page 104 of 192 ## Administration Page 105 of 192 ## 2027 Budget Update - Administration Budget at-a-Glance The proposed 2027 budget increases 2.42% over 2026. Most increases are driven by contractual obligations, inflation, and regulatory requirements, while new investments are focused on strengthening volunteer engagement, ensuring secure elections, and improving accessibility for all residents. The budget continues investing in the core services that support every department and enables the City to deliver reliable services to residents. What the numbers don’t tell you: Residents may not see every service funded through this budget, but they experience the results through transparent government, better communication, secure elections, and an organization that is equipped to serve the community effectively, to communicate clearly, conduct secure elections, support employees, meet legal requirements, and provide accountable government. ## 2026 Budget2027 BudgetChangeStrategic Priorities $4,169,245$4,270,031.162.42% ## City Operations ## Community & Civic Engagement Page 106 of 192 ## 2027 Budget Update - Administration ## Key Investments ## InvestmentWhy it MattersOutcome ## PT Volunteer ## Coordinator Expands staff capacity & leverages community resources and strengthens community partnerships More volunteers supporting city programs and services ## Website ## Accessibility Required by law, removes barriers to information Improved access to city information and services ElectionsImproves trust in process, government Ensure accurate and secure elections Market StudyAligns compensation with the labor market Attracts and retains a high-performing workforce Page 107 of 192 ## 2027 Budget Update - Administration ## Decision Making We choose toInstead of....Because... Maintain technology replacement​ Delay purchasesReduce operational risk, maintain ef ficiency​ Keep newsletter frequency​Reduce number of issuesHigh resident readership​ Continue legal support in negotiations​ Reduce city attorney participation in negotiations Minimize liability​ ## Scale back Wellness ## Program​ Continue funding for the program Funding changes and feedback highlighted need for intentional strategy before more investments​ ## Delay Employee records management system​ Purchase a new software solution​ Maximize existing software until we outgrow it​ ## Pilot AI-assisted meeting minutes​ Continue status quoEvaluate opportunities to improve ef ficiency and reduce costs​ Page 108 of 192 ## 2027 Budget Update - Administration ## Strategic Plan Alignment Strategic PriorityHow this budget advances it City OperationsExpands staff capacity & leverages community resources, invest in technology, and compensation planning. ## Community & Civic ## Engagement Removes barriers and increase accessibility to information ## Responsive Services and Safety Manage operational risk, administer secure elections and support core services in other departments. This budget supports 250 regular employees, 180 seasonal, and 2,154 volunteers. It also supports 5 core city functions (communications, legal services, administration, city council, and elections). Administration provides the people, systems, and organizational support that enable every department to deliver high-quality service, implement council priorities, and serve the community effectively. ## Key Take-Aways Page 109 of 192 ## Finance Page 110 of 192 ## 2027 Budget Update - Finance Budget at-a-Glance The proposed 2027 budget increases 4.97% over 2026. Most increases are driven by personnel cost increases, inflation, and a new CIP software implementation. The budget continues investing in the core services that support every department’s financial needs that enables the City to deliver reliable services to residents. What the numbers don’t tell you: The organization and the residents may not see every detail of all the finance functions in this budget, but they experience the results through transparent fiscal accountability, better communication, and a Finance department that is equipped to deliver services successfully. ## 2026 Budget2027 BudgetChangeStrategic Priorities $3,893,967$4,087,5554.97% ## City Operations ## Community & Civic Engagement Page 111 of 192 ## 2027 Budget Update - Finance ## Key Investments ## InvestmentWhy it MattersOutcome PlanIt! SoftwareImprove internal and external communication about the Capital Improvement Budget. Improved transparency and efficient data tracking ## Staffing ## Reclassifications More efficient operations with better cross training better aligned with job duties. Better support to residents and promotes employee retention ## Popular Annual ## Financial Report ## (PAFR) Improve internal and external communication about the city’s finances and financial reporting. Improved transparency and clarity Page 112 of 192 ## 2027 Budget Update - Finance ## Decision Making We choose toInstead of....Because... Implement PlanIT!Continuing usage of excel spreadsheets Improves interdepartmental efficiencies, timely and accurately captures new data, and provides clear information to residents Continue to use current tools and staff processes for development of operational budget Investing in a softwareIt allows for internal assessment No additional staff request for license center Asking for additional FTEWe’re monitoring impact of new leave legislation and exploring P/T employee’s ability to increase hours to support operational needs as they arise Page 113 of 192 ## 2027 Budget Update - Finance ## Strategic Plan Strategic PriorityHow this budget advances it City OperationsExpands staff capacity with improved technology and better long-term financial planning. ## Community & Civic ## Engagement ## The Popular Annual Financial Report provides residents with better access to city’s financial activities. This budget proposal improves internal processes and financial transparency by increasing accessibility of city finances to the community This budget proposal is essential to maintain service levels meeting statutory requirements and supporting city core financial functions ## Key Take-Aways Page 114 of 192 ## Q & A Questions? ## 2027 Department Budget Page 115 of 192 ØFunding decisions made in the 2026 budget - especially for public safety positions - create ongoing costs that will impact 2027–2029 ØThe current estimate shows a tax levy increase of $3.9 million; this is the updated look at the 2027 budget. ØAs the 2027 budget process evolves, new information may raise or lower the required levy amount ## 2027 Budget – Final Thoughts Page 116 of 192 ØFactors that could increase the levy üSettled union contracts for firefighters and police leadership ØFactors that could reduce the levy üIdentification of new revenue sources üCost shifts, reductions, or potential budget cuts ØThis presentation should be viewed as an updated snapshot of the 2027 budget scenario, not a final decision ØWhile planning, the City Council should remain open to needs for 2027 but also remain realistic about financial constraints. ## 2027 Budget Estimate – Final Thoughts Page 117 of 192 ## 2027 Budget Timeline ** This is directly tied to the ## Strategic Plan City Operations – Goal #3 objectives •By 2028 budget year develop a multi-year financial forecast for operations to plan for necessary resources. ## Budget Process TimelineDate Started Budget process and identified budget drivers March 2026 Leadership team collaboration to identify budget themes** April 2026 Council workshop discussionApril 2026 ## City Manager and Department Head Leadership review budget requests June 2026 Follow up council workshop discussionJuly 2026 Present preliminary budgetAugust 2026 ## Receive Finance Commission budget recommendations September 2026 Adopt preliminary levySeptember 2026 Continued conversation to adopt final budgetSept – Dec 2026 Page 118 of 192 2027 through 2036 ## Capital Improvement Plan ## Roseville, MN ## Sources and Uses of Funds Details Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 260 Community Development Vehicle ## & Equipment Fund Beginning Balance 0 0 0 0 0 0 0 0 0 0 ## Revenues and Other Fund Sources ## Revenue Fund Balance 0 100,000 45,000 0 0 0 0 45,000 45,000 0 Total 0 100,000 45,000 0 0 0 0 45,000 45,000 0 ## Other Fund Sources Fund Balance 45,000 0 0 0 0 0 0 0 0 0 Total 45,000 0 0 0 0 0 0 0 0 0 Total Revenues and Other Fund Sources 45,000 100,000 45,000 0 0 0 0 45,000 45,000 0 Total Funds available 45,000 100,000 45,000 0 0 0 0 45,000 45,000 0 ## Expenditures and Uses ## Capital Projects & Equipment ## Community Development Inspection vehicle - 2017 Ford ## Escape ## CD-001 45,000 0 0 0 0 0 0 0 0 0 Online Permit/Schedul. Software CD-002 0 100,000 0 0 0 0 0 0 0 0 Inspection vehicle - 2019 Ford ## Ranger ## CD-003 0 0 45,000 0 0 0 0 0 0 0 Inspection vehicle - 2023 Ford ## Lightening ## CD-004 0 0 0 0 0 0 0 45,000 0 0 Inspection vehicle - 2025 Ford ## Lightening ## CD-005 0 0 0 0 0 0 0 0 45,000 0 Total 45,000 100,000 45,000 0 0 0 0 45,000 45,000 0 ## Other Uses Total Expenditures and Uses 45,000 100,000 45,000 0 0 0 0 45,000 45,000 0 Change in Fund Balance 0 0 0 0 0 0 0 0 0 0 ## Ending Balance 0 0 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 1 / 41 Page 119 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 400 Police Vehicle & Equipment Fund Beginning Balance 376,703 332,703 121,309 86,345 191,797 30,712 253,980 349,211 361,695 462,354 ## Revenues and Other Fund Sources ## Revenue Franchise Fees 264,000 264,000 264,000 264,000 264,000 264,000 264,000 264,000 264,000 264,000 MSA, Debt, Fees 19,000 0 0 0 0 19,000 0 19,000 0 0 Sale of Assets 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 Tax Levy 450,000 550,000 650,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 Total 763,000 844,000 944,000 1,044,000 1,044,000 1,063,000 1,044,000 1,063,000 1,044,000 1,044,000 ## Other Fund Sources Total Revenues and Other Fund Sources 763,000 844,000 944,000 1,044,000 1,044,000 1,063,000 1,044,000 1,063,000 1,044,000 1,044,000 Total Funds available 1,139,703 1,176,703 1,065,309 1,130,345 1,235,797 1,093,712 1,297,980 1,412,211 1,405,695 1,506,354 ## Expenditures and Uses ## Capital Projects & Equipment ## Police Vehicle & Equipment Marked Squads (6 per year) P-001 276,000 276,000 276,000 276,000 276,000 276,000 276,000 276,000 276,000 276,000 ## Unmarked Detective Vehicles (2 per year) ## P-002 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 CSO Vehicle P-003 0 50,000 0 0 50,000 0 0 50,000 0 0 Comm Relations / Admin Vehicle P-004 0 0 50,000 0 50,000 0 0 50,000 0 50,000 Crime Scene Vehicle P-005 0 53,000 0 0 0 0 53,000 0 0 0 Park Patrol/Response Vehicle P-006 0 0 32,000 0 0 0 0 0 32,000 0 ## Squad/Vehicle Conversion and ## Outfitting p-007 194,000 254,000 211,000 194,000 241,000 194,000 224,000 241,000 194,000 211,000 ## Stop Sticks and Tire Deflation ## Devices ## P-008 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Radar Units (2 per year) P-009 7,700 7,700 7,700 7,700 7,700 7,700 7,700 7,700 7,700 7,700 Radio Equipment (4 squad and 4 portable) ## P-010 52,000 52,000 52,000 52,000 30,000 30,000 30,000 30,000 30,000 30,000 Defibrillators (AEDs) P-011 1,000 1,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 Computers and Printers (fleet) P-012 0 0 0 0 200,000 0 0 0 0 200,000 Mobile Electronics P-013 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 Speed Notification Signs P-014 2,000 5,000 5,000 0 2,000 0 10,000 0 0 2,000 Tracking/Surveillance Technology P-015 5,500 0 0 0 0 5,500 0 0 0 0 Replacement K-9 P-016 0 21,000 21,000 0 0 0 0 0 21,000 21,000 Less Lethal Equipment P-017 26,000 26,000 26,000 26,000 26,000 26,000 26,000 26,000 26,000 26,000 Long Guns P-018 15,000 15,000 43,750 43,750 15,000 15,000 15,000 15,000 43,750 43,750 Sidearms P-019 9,000 9,000 9,000 66,000 9,000 9,000 9,000 9,000 9,000 9,000 Tactical Gear P-020 26,000 26,000 26,000 26,000 26,000 26,000 26,000 26,000 26,000 26,000 ## Produced Using Plan-It CIP SoftwarePage 2 / 41 Page 120 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 PPE and EMS Equipment P-021 4,000 4,000 4,000 4,000 10,000 10,000 4,000 4,000 4,000 4,000 Drone Equipment P-022 8,000 28,000 8,000 8,000 28,000 8,000 8,000 28,000 8,000 8,000 ## Rapid Identification Technology ## (IBIS) ## P-023 0 3,000 0 0 3,000 0 0 3,000 0 0 Crime Scene Equipment P-024 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 Fitness and Wellness Room P-025 13,000 5,000 5,000 5,000 8,000 5,000 5,000 5,000 8,000 5,000 K-9 Training Equipment P-026 12,000 12,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 Evidence Room (office) P-027 4,000 4,000 8,000 8,000 0 0 15,000 0 0 16,000 ## Conference Rooms Audio/Video ## Technology ## P-028 0 10,000 0 10,000 0 10,000 0 10,000 0 10,000 Roll Call Equipment P-029 0 8,000 0 0 0 0 8,000 0 0 0 Investigation Briefing Room P-030 0 0 0 10,000 0 0 0 0 10,000 0 Shredder P-031 7,800 0 0 0 0 0 0 0 0 0 Office Furniture (office) P-033 12,000 12,000 16,000 16,000 16,000 20,000 20,000 20,000 20,000 20,000 Patrol Area Cubicles P-034 0 18,000 0 0 0 0 0 18,000 0 0 Appliances (office) P-035 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 Detention Room P-036 0 3,000 0 0 0 0 0 4,000 0 0 Total 807,000 1,034,700 950,450 902,450 1,147,700 792,200 886,700 972,700 865,450 1,115,450 ## Other Uses Inflation 10% 0 0 0 0 0 0 0 0 0 111,545 Inflation 9% 0 0 0 0 0 0 0 0 77,891 0 Inflation 8% 0 0 0 0 0 0 0 77,816 0 0 Inflation 7% 0 0 0 0 0 0 62,069 0 0 0 Inflation 6% 0 0 0 0 0 47,532 0 0 0 0 Inflation 5% 0 0 0 0 57,385 0 0 0 0 0 Inflation 4% 0 0 0 36,098 0 0 0 0 0 0 Inflation 3% 0 0 28,514 0 0 0 0 0 0 0 Inflation 2% 0 20,694 0 0 0 0 0 0 0 0 Total 0 20,694 28,514 36,098 57,385 47,532 62,069 77,816 77,891 111,545 Total Expenditures and Uses 807,000 1,055,394 978,964 938,548 1,205,085 839,732 948,769 1,050,516 943,341 1,226,995 Change in Fund Balance -44,000 -211,394 -34,964 105,452 -161,085 223,268 95,231 12,484 100,659 -182,995 ## Ending Balance 332,703 121,309 86,345 191,797 30,712 253,980 349,211 361,695 462,354 279,359 ## Produced Using Plan-It CIP SoftwarePage 3 / 41 Page 121 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 401 Fire Vehicle & Equipment Fund Beginning Balance 1,376,043 745,543 618,848 1,033,061 908,150 1,295,561 1,712,258 1,952,878 1,946,967 1,389,181 ## Revenues and Other Fund Sources ## Revenue Investment Income 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Sale of Assets 20,000 40,000 0 18,000 5,000 15,000 0 0 0 0 Tax Levy 455,000 473,200 492,128 511,813 532,286 553,577 575,720 598,749 622,699 647,607 Total 480,000 518,200 497,128 534,813 542,286 573,577 580,720 603,749 627,699 652,607 ## Other Fund Sources Bond Proceeds 0 0 0 0 0 0 0 0 4,000,000 0 Total 0 0 0 0 0 0 0 0 4,000,000 0 Total Revenues and Other Fund Sources 480,000 518,200 497,128 534,813 542,286 573,577 580,720 603,749 4,627,699 652,607 Total Funds available 1,856,043 1,263,743 1,115,976 1,567,874 1,450,436 1,869,138 2,292,978 2,556,627 6,574,666 2,041,788 ## Expenditures and Uses ## Capital Projects & Equipment ## Fire Vehicle & Equipment ## Apparatus: Medical First Response Vehicle #3 ## F-004 0 0 0 0 0 0 0 50,000 0 0 ## Apparatus: Medical First Response Vehicle #1 ## F-005 0 0 0 0 0 0 0 340,000 0 0 ## Apparatus: Medical First Response Vehicle #2 ## F-006 340,000 0 0 0 0 0 0 0 275,000 0 Apparatus: Foam Response Trailer F-007 0 0 0 0 85,000 0 0 0 0 0 Apparatus: Ladder Truck F-008 0 0 0 0 0 0 0 0 2,000,000 0 ## Apparatus: Command Response ## Vehicle ## F-009 0 95,000 0 95,000 0 95,000 0 95,000 0 95,000 Apparatus: Rescue Boat F-010 0 0 0 0 0 0 0 0 0 45,000 Physical Fitness Training Equipment F-011 0 0 0 0 7,500 0 0 0 0 17,000 Records Management System (RMS) F-012 40,000 0 0 0 0 0 0 0 45,000 0 ## Self Contained Breathing Apparatus ## (SCBA) ## F-013 0 495,250 0 0 0 0 0 0 0 0 Smoke Ventilation Fans F-014 0 8,000 0 0 0 0 0 8,000 0 0 Power Equipment F-015 16,500 0 0 0 0 10,000 0 0 0 0 Personal Protective Equipment F-016 0 0 0 350,000 0 0 0 0 350,000 0 EMS Equipment F-017 235,000 0 0 0 0 0 250,000 0 0 0 Medical Equipment - Durable Goods F-018 7,000 0 0 0 0 7,000 0 0 0 0 Training Equipment F-019 5,500 0 0 0 0 15,000 0 0 0 0 ## Thermal Imaging Camera - ## Firefighting ## F-020 6,500 0 0 7,850 0 0 7,850 0 0 7,850 ## Produced Using Plan-It CIP SoftwarePage 4 / 41 Page 122 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## Portable/Mobile Communication ## Radios ## F-021 370,000 0 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 ## Emergency Mgmt Preparedness - ## EOC ## F-022 45,000 0 0 45,000 0 0 0 0 45,000 0 Firefighting Equipment F-023 5,000 0 0 0 0 5,000 0 0 0 0 Water Emergency Equipment F-024 5,000 0 0 0 0 6,000 0 0 0 0 Apparatus Based IT Infrastructure F-025 35,000 0 10,000 0 35,000 0 10,000 0 35,000 0 ## Emergency Response - Air ## Monitoring Equipment ## F-026 0 10,000 0 6,500 0 0 0 0 6,500 0 Rescue-Extrication Equipment F-027 0 0 40,000 0 0 0 0 40,000 0 0 Nozzles & Fire hose F-028 0 10,000 0 0 0 0 20,000 0 0 0 Therapy K9 F-029 0 0 0 0 0 0 0 15,000 0 0 Fire Administration - Furniture F-030 0 0 0 0 0 0 20,000 0 0 0 Training Room Furniture F-031 0 0 0 15,000 0 0 0 0 0 0 Conference Room Furniture F-032 0 0 0 5,000 0 0 0 0 0 5,000 Kitchen appliances F-033 0 0 0 0 10,000 0 0 0 0 10,000 Day Room Chairs F-035 0 0 0 15,000 0 0 0 0 0 0 ## Audio Visual Equipment - ## Stationwide ## F-036 0 0 6,500 0 0 0 0 6,500 0 0 Washer & Dryer - Second Floor F-037 0 0 14,000 0 0 0 0 0 0 0 Bed Mattresses F-038 0 14,000 0 0 0 0 0 0 0 14,000 Apparatus: Fire Engine - Pumper F-040 0 0 0 0 0 0 0 0 2,000,000 0 Apparatus: Utility Apparatus F-041 0 0 0 85,000 0 0 0 0 0 0 Total 1,110,500 632,250 80,500 634,350 147,500 148,000 317,850 564,500 4,766,500 203,850 ## Other Uses Debt Service 0 0 0 0 0 0 0 0 350,000 350,000 Inflation 10% 0 0 0 0 0 0 0 0 0 20,385 Inflation 2% 0 12,645 0 0 0 0 0 0 0 0 Inflation 3% 0 0 2,415 0 0 0 0 0 0 0 Inflation 4% 0 0 0 25,374 0 0 0 0 0 0 Inflation 5% 0 0 0 0 7,375 0 0 0 0 0 Inflation 6% 0 0 0 0 0 8,880 0 0 0 0 Inflation 7% 0 0 0 0 0 0 22,250 0 0 0 Inflation 8% 0 0 0 0 0 0 0 45,160 0 0 Inflation 9% 0 0 0 0 0 0 0 0 68,985 0 Total 0 12,645 2,415 25,374 7,375 8,880 22,250 45,160 418,985 370,385 Total Expenditures and Uses 1,110,500 644,895 82,915 659,724 154,875 156,880 340,100 609,660 5,185,485 574,235 Change in Fund Balance -630,500 -126,695 414,213 -124,911 387,411 416,697 240,620 -5,911 -557,786 78,372 ## Produced Using Plan-It CIP SoftwarePage 5 / 41 Page 123 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## Ending Balance 745,543 618,848 1,033,061 908,150 1,295,561 1,712,258 1,952,878 1,946,967 1,389,181 1,467,553 ## Produced Using Plan-It CIP SoftwarePage 6 / 41 Page 124 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 402 Parks & Recreation Vehicle & ## Equipment Fund Beginning Balance 452,995 412,995 251,775 226,572 -20,664 293,990 212,611 148,355 -8,441 -88,287 ## Revenues and Other Fund Sources ## Revenue Investment Income 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 Tax Levy 302,000 311,060 320,392 330,004 339,904 350,101 360,604 360,604 360,604 360,604 Total 303,000 312,060 321,392 331,004 340,904 351,101 361,604 361,604 361,604 361,604 ## Other Fund Sources Total Revenues and Other Fund Sources 303,000 312,060 321,392 331,004 340,904 351,101 361,604 361,604 361,604 361,604 Total Funds available 755,995 725,055 573,167 557,576 320,240 645,091 574,215 509,959 353,163 273,317 ## Expenditures and Uses ## Capital Projects & Equipment ## Parks & Recreation Vehicles & Equipment Ford F350 with Plow (2016) #530 PR-002 0 0 0 0 0 60,000 0 0 0 0 Ford 3/4-ton (2012) #506 PR-003 0 50,000 0 0 0 0 0 0 0 50,000 Ford F350 Dump (2016) #528 PR-005 70,000 0 0 0 0 0 70,000 0 0 0 Water truck (1/2 cost) (2019) #510 PR-006 0 0 75,000 0 0 0 0 0 0 0 Bobcat Toolcat (2006) #511 PR-007 0 55,000 0 0 0 0 0 0 0 0 GMC Savana (2012) #517 PR-009 0 0 0 70,000 0 0 0 0 0 0 Ford 350 w. plow (2014) #515 PR-010 0 0 0 70,000 0 0 0 0 0 0 Ford with plow (2014) #516 PR-011 0 0 0 70,000 0 0 0 0 0 0 Zero Turn Replace (Arb.) (1999) PR-012 0 0 9,500 0 0 0 0 0 0 0 Ford F350 (2016) #532 PR-013 70,000 0 0 0 0 50,000 0 0 0 0 Kromer field liner (2003) #534 PR-014 0 0 0 0 0 0 0 60,000 0 0 Ford Passenger van (2006) #535 PR-015 0 0 0 0 0 0 0 50,000 0 0 John Deere tractor (2020) #545 PR-016 0 0 0 30,000 0 0 0 0 0 0 Ford Passenger van (2006) #560 PR-017 0 0 0 0 0 0 0 50,000 0 0 Jeep Patriot (2013) #409 PR-018 0 20,000 0 0 0 0 0 0 0 0 ## Skating Center/Golf Plow Truck (2012) ## PR-019 0 0 0 0 0 15,000 0 0 0 0 OVAL: Zamboni (2020) #550 PR-020 0 0 0 225,000 0 0 0 0 0 0 Arena: Zamboni (2014) #556 PR-021 0 0 0 0 0 0 0 0 115,000 0 GOLF TRANSFER TO Golf fund PR-022 0 0 0 0 0 0 0 0 40,000 0 ## John Deere 3046R Tractor (2022) #504 ## PR-023 0 0 0 0 0 35,000 0 0 0 0 Toro 4000 Mower (2023) #509 PR-024 0 0 0 0 0 0 80,000 0 0 0 Toro 4000 Mower (2013) #513 PR-025 0 0 0 0 0 0 80,000 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 7 / 41 Page 125 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 John Deere loader (2018) #553 PR-027 0 80,000 0 0 0 0 0 0 0 0 Toro 16' mower (2023) #536 PR-028 0 0 0 0 0 0 0 200,000 0 0 portable generator #538 PR-029 0 0 0 3,000 0 0 0 0 0 0 Towmaster trailer (2021) #543 PR-030 0 0 9,000 0 0 0 0 0 0 0 Toro groundmaster (2017) #546 PR-031 0 0 0 0 0 0 0 0 0 85,000 Towmaster trailer (2000) #548 PR-032 15,000 0 0 0 0 0 0 0 15,000 0 Smithco sweeper (1992) #565 PR-033 0 0 8,000 0 0 0 0 0 0 0 Mower blade sharpener (2015) PR-034 0 0 0 0 15,000 0 0 0 0 0 Holder C70SC snow machine (2022) #505 ## PR-035 0 0 0 0 0 0 0 0 195,000 0 Holder Snow machine (2015) #518 PR-036 0 0 0 0 0 195,000 0 0 0 0 ## MT Trackless snow/sidewalk machine (2020) #585 ## PR-037 0 0 195,000 0 0 0 0 0 0 0 Park security systems PR-038 75,000 0 0 0 0 0 0 0 0 0 Pickup sander (2013) PR-039 0 0 0 0 0 8,000 0 0 0 0 GOLF TRANSFER TO Golf fund equip PR-040 63,000 114,000 20,000 39,000 0 35,000 84,000 70,000 0 14,000 Total 293,000 319,000 316,500 507,000 15,000 398,000 314,000 430,000 365,000 149,000 ## Other Uses Inflation 10% 0 0 0 0 0 0 0 0 0 14,900 Inflation 2% 0 6,380 0 0 0 0 0 0 0 0 Inflation 3% 0 0 9,495 0 0 0 0 0 0 0 Inflation 4% 0 0 0 20,280 0 0 0 0 0 0 Inflation 5% 0 0 0 0 750 0 0 0 0 0 Inflation 6% 0 0 0 0 0 23,880 0 0 0 0 Inflation 7% 0 0 0 0 0 0 21,980 0 0 0 Inflation 8% 0 0 0 0 0 0 0 34,400 0 0 Inflation 9% 0 0 0 0 0 0 0 0 32,850 0 Transfers Out to Fund 620 Golf 50,000 147,900 20,600 50,960 10,500 10,600 89,880 54,000 43,600 15,400 Total 50,000 154,280 30,095 71,240 11,250 34,480 111,860 88,400 76,450 30,300 Total Expenditures and Uses 343,000 473,280 346,595 578,240 26,250 432,480 425,860 518,400 441,450 179,300 Change in Fund Balance -40,000 -161,220 -25,203 -247,236 314,654 -81,379 -64,256 -156,796 -79,846 182,304 ## Ending Balance 412,995 251,775 226,572 -20,664 293,990 212,611 148,355 -8,441 -88,287 94,017 ## Produced Using Plan-It CIP SoftwarePage 8 / 41 Page 126 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 403 Public Works Vehicle & Equipment ## Fund Beginning Balance 1,081,785 920,285 406,985 435,935 705,998 691,799 920,777 662,697 599,887 394,033 ## Revenues and Other Fund Sources ## Revenue Franchise Fees 285,000 285,000 285,000 285,000 285,000 285,000 285,000 285,000 285,000 285,000 Investment Income 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 Tax Levy 100,000 105,000 110,250 115,763 121,551 127,628 134,010 140,710 147,746 155,133 Total 389,500 394,500 399,750 405,263 411,051 417,128 423,510 430,210 437,246 444,633 ## Other Fund Sources Total Revenues and Other Fund Sources 389,500 394,500 399,750 405,263 411,051 417,128 423,510 430,210 437,246 444,633 Total Funds available 1,471,285 1,314,785 806,735 841,198 1,117,049 1,108,927 1,344,287 1,092,907 1,037,133 838,666 ## Expenditures and Uses ## Capital Projects & Equipment ## Public Works Vehicle and Equipment ## Graphtec/SignMate Sign Equipment (Sign Shop) (2012) #100 ## PW-001 0 30,000 0 0 0 0 0 0 0 0 ## Turf Maker 550 Hydro Seeder (2017) #108 ## PW-002 0 0 0 0 0 40,000 0 0 0 0 ## Bobcat HB980 Hydraulic Breaker ## (2007) #111 A05 ## PW-004 0 0 0 0 0 10,000 0 0 0 0 ## Bobcat 78" Fork Grapple (2006) ## #111 A06 ## PW-005 0 0 0 0 0 10,000 0 0 0 0 Bobcat 2.5" Slot Mill (2012) #111 ## A09 ## PW-006 20,000 0 0 0 0 0 0 0 0 0 ## Kage SB96 Snow Pusher (2013) #111 ## A10 ## PW-007 0 0 0 10,000 0 0 0 0 0 0 ## Bobcat 68" Angle Broom (2014) ## #111 A11 ## PW-008 0 0 10,000 0 0 0 0 0 0 0 ## Virnig VBW-72-HF33 Snow Blower ## (2017) #111 A15 ## PW-009 14,000 0 0 0 0 0 0 0 0 0 Bobcat 72" Sweeper (2018) #111 ## A16 ## PW-010 0 0 0 0 0 0 0 10,000 0 0 Bobcat 24PLA Millhead (2018) #111 ## A17 ## PW-011 0 20,000 0 0 0 0 0 0 0 0 ## Bobcat HB980 Pallet Fork (2019) ## #111 A19 ## PW-013 0 0 10,000 0 0 0 0 0 0 1,100 Rapid Router (2021) #111 A20 PW-014 0 15,000 0 0 0 0 0 0 15,000 0 ## Virnig Pickup Broom (2022) #111 ## A21 ## PW-015 0 0 10,000 0 0 0 0 0 10,000 0 ## Produced Using Plan-It CIP SoftwarePage 9 / 41 Page 127 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## Stanley PD45131 Post Pounder ## (2016) #111 A03 ## PW-016 0 0 0 0 0 0 0 0 0 10,000 Virnig Snowblower (2024) #111 A23 PW-017 0 0 0 0 0 0 0 12,000 0 0 Bobcat S76 (2020) #111 PW-018 87,000 0 0 0 0 0 0 87,000 0 0 ## Kubota M110GXDTC Tractor (2015) #116 ## PW-020 0 0 60,000 0 0 0 0 0 0 0 ## Towmaster T-20D Trailer (2024) #117 ## PW-021 0 0 0 0 0 0 0 25,000 0 0 ## Stepp SPHOJ-2.0 Patch Trailer (2017) #123 ## PW-022 0 0 0 0 0 50,000 0 0 0 0 ## Sullair 260 CFM Air Compressor (2011) #129 ## PW-023 40,000 0 0 0 0 0 0 0 0 0 ## Trafifix Scorpion Attenuator (2017) #137 ## PW-025 0 0 0 0 0 7,500 0 0 0 0 ## Towmaster T-16DT Trailer (2017) #153 ## PW-027 20,000 0 0 0 0 0 0 0 0 0 ## Bomag BW120SL5 Roller (2018) #157 ## PW-028 0 0 0 0 0 0 0 0 0 50,000 Cimline 150DH Melter (2017) #166 PW-029 0 0 60,000 0 0 0 0 0 0 0 Scale Tec (2021) #177 PW-031 0 0 0 0 0 0 0 0 0 10,000 Brine Tank 3000 Gallons #180 PW-033 0 0 0 0 0 0 0 0 25,000 0 LeeBoy 635 Grader (1992) #519 PW-035 0 0 30,000 0 0 0 0 0 0 0 Bobcat T76 (2024) #131 PW-036 0 0 0 0 25,000 0 0 0 0 0 Generac light tower Magnum ## MLT4060KV (2013) #210 ## PW-037 0 0 0 0 0 0 0 2,500 0 0 ## Genie GS2646 Man Lift (2007) #90225 ## PW-038 0 0 0 0 0 0 0 2,500 0 0 Nissan PL40 Forklift (2006) #90125 PW-039 0 0 0 0 0 0 0 2,500 0 0 Eng. Large format scanner/copier- bought in 25 instead of 26 ## PW-041 0 0 0 0 0 0 12,000 0 0 0 Eng. Total Station PW-042 0 0 0 35,000 0 0 0 0 0 0 Eng. Utility Locator - Metrotech PW-043 0 0 0 0 0 0 10,000 0 0 0 Garage: 2 Post lift 2002 PW-044 0 10,000 0 0 0 0 0 0 0 0 Garage: Air compressor PW-045 0 0 0 0 0 0 0 0 10,000 0 Garage: Band saw PW-046 0 0 0 10,000 0 0 0 0 0 0 Garage: Brake lathe PW-047 0 0 0 25,000 0 0 0 0 0 0 Garage: Drill Press PW-049 0 10,000 0 0 0 0 0 0 0 0 Garage: Jib crane (overhead motor & trolly) ## PW-052 0 10,000 0 0 0 0 0 0 0 0 Garage: Lubrication filling heads, reels, hose (5) ## PW-053 0 10,000 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 10 / 41 Page 128 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Garage: Lubrication tank pumps (3) PW-054 0 10,000 0 0 0 0 0 0 0 0 Garage: Tire Balancer PW-055 0 0 20,000 0 0 0 0 0 0 0 Garage: Tire changer PW-056 0 0 20,000 0 0 0 0 0 0 0 Eng. Office furniture PW-057 0 0 0 0 10,000 0 0 0 0 0 Maintenance: Office furniture PW-058 0 0 0 0 10,000 0 0 0 0 0 Street Signs-large order every 15 years ## PW-060 0 0 0 0 0 0 0 0 0 100,000 GMC Sierra 2500 (2024) #102 PW-061 0 0 0 0 0 0 0 0 0 60,000 Ford F550 (2024) #103 PW-062 0 0 0 0 0 0 0 0 0 83,000 Western Star 4700SF (2023) #106 PW-063 0 0 0 0 0 0 0 315,000 0 0 Case 621F Loader (2016) #107 PW-064 0 400,000 0 0 0 0 0 0 0 0 International HV507 (2020) #109 PW-065 0 0 0 0 315,000 0 0 0 0 0 Western Star 4700SF (2020) #112 PW-066 0 0 0 0 0 0 315,000 0 0 0 Ford F250 (2020) #118 PW-067 0 0 0 0 0 60,000 0 0 0 0 Ford F250 (2022) #124 PW-068 0 0 0 0 0 0 0 0 65,000 0 ## Western Star 4700SF Tandem (2018) #125 ## PW-069 365,000 0 0 0 0 0 0 0 0 0 Ford F250 (2016) #128 PW-070 0 60,000 0 0 0 0 0 0 0 0 Ford F600 (2022) #134 PW-071 0 0 0 0 0 0 0 0 150,000 0 Western Star 47X (2024) #148 PW-073 0 0 0 0 0 0 0 0 315,000 0 ## Freightliner M2 106 Boom Truck (2018) #152 ## PW-074 0 0 0 0 0 0 300,000 0 0 0 International 7400 SFA (2016) #155 PW-075 0 315,000 0 0 0 0 0 0 0 0 Ford F350 (Shop truck) (2004) #203 PW-076 5,000 0 0 0 0 0 0 0 0 0 Chevrolet Equinox (2015) #301 PW-077 0 0 45,000 0 0 0 0 0 0 0 Chevrolet Equinox (2017) #302 PW-078 0 0 45,000 0 0 0 0 0 0 0 GMC Sierra (2018) #303 PW-079 0 0 0 50,000 0 0 0 0 0 0 Ford F150 (2015) #305 PW-080 0 0 50,000 0 0 0 0 0 0 0 ## Mitsubishi Outlander Hybrid (2019) #310 ## PW-081 0 0 0 0 45,000 0 0 0 0 0 Total 551,000 890,000 360,000 130,000 405,000 177,500 637,000 456,500 590,000 314,100 ## Other Uses Inflation 10% 0 0 0 0 0 0 0 0 0 31,410 Inflation 2% 0 17,800 0 0 0 0 0 0 0 0 Inflation 3% 0 0 10,800 0 0 0 0 0 0 0 Inflation 4% 0 0 0 5,200 0 0 0 0 0 0 Inflation 5% 0 0 0 0 20,250 0 0 0 0 0 Inflation 6% 0 0 0 0 0 10,650 0 0 0 0 Inflation 7% 0 0 0 0 0 0 44,590 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 11 / 41 Page 129 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Inflation 8% 0 0 0 0 0 0 0 36,520 0 0 Inflation 9% 0 0 0 0 0 0 0 0 53,100 0 Total 0 17,800 10,800 5,200 20,250 10,650 44,590 36,520 53,100 31,410 Total Expenditures and Uses 551,000 907,800 370,800 135,200 425,250 188,150 681,590 493,020 643,100 345,510 Change in Fund Balance -161,500 -513,300 28,950 270,063 -14,199 228,978 -258,080 -62,810 -205,854 99,123 ## Ending Balance 920,285 406,985 435,935 705,998 691,799 920,777 662,697 599,887 394,033 493,156 ## Produced Using Plan-It CIP SoftwarePage 12 / 41 Page 130 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 404 Finance Equipment Fund Beginning Balance 46,237 61,837 31,870 55,268 80,269 102,260 125,617 155,222 187,838 222,702 ## Revenues and Other Fund Sources ## Revenue Investment Income 500 500 500 500 500 500 500 500 500 500 Tax Levy 20,000 21,400 22,898 24,501 26,216 28,051 30,015 32,116 34,364 36,769 Total 20,500 21,900 23,398 25,001 26,716 28,551 30,515 32,616 34,864 37,269 ## Other Fund Sources Total Revenues and Other Fund Sources 20,500 21,900 23,398 25,001 26,716 28,551 30,515 32,616 34,864 37,269 Total Funds available 66,737 83,737 55,268 80,269 106,985 130,811 156,132 187,838 222,702 259,971 ## Expenditures and Uses ## Capital Projects & Equipment ## Finance Budget Software F-002 0 50,000 0 0 0 0 0 0 0 0 Computer replacements F-003 4,900 850 0 0 4,500 4,900 850 0 0 4,500 Total 4,900 50,850 0 0 4,500 4,900 850 0 0 4,500 ## Other Uses Inflation 10% 0 0 0 0 0 0 0 0 0 450 Inflation 2% 0 1,017 0 0 0 0 0 0 0 0 Inflation 5% 0 0 0 0 225 0 0 0 0 0 Inflation 6% 0 0 0 0 0 294 0 0 0 0 Inflation 7% 0 0 0 0 0 0 60 0 0 0 Total 0 1,017 0 0 225 294 60 0 0 450 Total Expenditures and Uses 4,900 51,867 0 0 4,725 5,194 910 0 0 4,950 Change in Fund Balance 15,600 -29,967 23,398 25,001 21,991 23,357 29,605 32,616 34,864 32,319 ## Ending Balance 61,837 31,870 55,268 80,269 102,260 125,617 155,222 187,838 222,702 255,021 ## Produced Using Plan-It CIP SoftwarePage 13 / 41 Page 131 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 405 Administration Equipment Fund Beginning Balance 91,233 69,233 62,283 55,676 49,431 43,566 38,101 33,057 28,454 24,314 ## Revenues and Other Fund Sources ## Revenue Investment Income 500 500 500 500 500 500 500 500 500 500 Tax Levy 20,000 20,600 21,218 21,855 22,510 23,185 23,881 24,597 25,335 26,095 Total 20,500 21,100 21,718 22,355 23,010 23,685 24,381 25,097 25,835 26,595 ## Other Fund Sources Total Revenues and Other Fund Sources 20,500 21,100 21,718 22,355 23,010 23,685 24,381 25,097 25,835 26,595 Total Funds available 111,733 90,333 84,001 78,031 72,441 67,251 62,482 58,154 54,289 50,909 ## Expenditures and Uses ## Capital Projects & Equipment ## Administration Voting Equipment ADM-001 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 Data Practices Software ADM-002 15,000 0 0 0 0 0 0 0 0 0 Furniture Replacement ADM-003 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 Total 42,500 27,500 27,500 27,500 27,500 27,500 27,500 27,500 27,500 27,500 ## Other Uses Inflation 10% 0 0 0 0 0 0 0 0 0 2,750 Inflation 2% 0 550 0 0 0 0 0 0 0 0 Inflation 3% 0 0 825 0 0 0 0 0 0 0 Inflation 4% 0 0 0 1,100 0 0 0 0 0 0 Inflation 5% 0 0 0 0 1,375 0 0 0 0 0 Inflation 6% 0 0 0 0 0 1,650 0 0 0 0 Inflation 7% 0 0 0 0 0 0 1,925 0 0 0 Inflation 8% 0 0 0 0 0 0 0 2,200 0 0 Inflation 9% 0 0 0 0 0 0 0 0 2,475 0 Total 0 550 825 1,100 1,375 1,650 1,925 2,200 2,475 2,750 Total Expenditures and Uses 42,500 28,050 28,325 28,600 28,875 29,150 29,425 29,700 29,975 30,250 Change in Fund Balance -22,000 -6,950 -6,607 -6,245 -5,865 -5,465 -5,044 -4,603 -4,140 -3,655 ## Ending Balance 69,233 62,283 55,676 49,431 43,566 38,101 33,057 28,454 24,314 20,659 ## Produced Using Plan-It CIP SoftwarePage 14 / 41 Page 132 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 406 Street Light Maintenance Fund Beginning Balance 359,519 418,019 508,319 212,019 -103,981 -14,731 87,419 189,344 315,344 250,594 ## Revenues and Other Fund Sources ## Revenue Franchise Fees 96,000 96,000 96,000 96,000 96,000 96,000 96,000 96,000 96,000 96,000 Investment Income 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Tax Levy 0 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 Total 101,000 126,000 126,000 126,000 126,000 126,000 126,000 126,000 126,000 126,000 ## Other Fund Sources Total Revenues and Other Fund Sources 101,000 126,000 126,000 126,000 126,000 126,000 126,000 126,000 126,000 126,000 Total Funds available 460,519 544,019 634,319 338,019 22,019 111,269 213,419 315,344 441,344 376,594 ## Expenditures and Uses ## Capital Projects & Equipment ## Street Lights New Intersection Lighting SL-001 35,000 35,000 35,000 35,000 35,000 0 0 0 0 0 227447 - Overlook Dr SL-011 7,500 0 0 0 0 0 0 0 0 0 ## Lighting System - County Road C, ## Cleveland - Snelling ## SL-014 0 0 205,000 0 0 0 0 0 0 0 Lighting System - Patton Rd SL-015 0 0 0 20,000 0 0 0 0 0 0 ## Lighting System - Terminal Rd/ ## B2Bridge ## SL-016 0 0 0 35,000 0 0 0 0 0 0 Lighting System - Larpentuer SL-017 0 0 0 280,000 0 0 0 0 0 0 ## Lighting System - Cty Rd B2, ## Fairview-Snelling ## SL-018 0 0 0 55,000 0 0 0 0 0 0 ## Lighting System - City Hall Parking ## Lot & Pathway ## SL-019 0 0 90,000 0 0 0 0 0 0 0 ## Lighting System - Cty C & Civic ## Center Drive ## SL-020 0 0 80,000 0 0 0 0 0 0 0 184399 - Midland View Ct SL-021 0 0 0 0 0 22,500 0 0 0 0 Ped. RRFB @ Cty Rd D & Millwood SL-022 0 0 0 0 0 0 12,500 0 0 0 Speed Display Sign Cnty D SL-023 0 0 0 0 0 0 10,000 0 0 0 Lighting System - Twin Lake Ph 1 SL-024 0 0 0 0 0 0 0 0 170,000 0 Lighting System - Twin Lake Ph 2 SL-025 0 0 0 0 0 0 0 0 5,000 0 227448 - Langton Lake Rd SL-026 0 0 0 0 0 0 0 0 0 30,000 Total 42,500 35,000 410,000 425,000 35,000 22,500 22,500 0 175,000 30,000 ## Other Uses Inflation 10% 0 0 0 0 0 0 0 0 0 3,000 Inflation 2% 0 700 0 0 0 0 0 0 0 0 Inflation 3% 0 0 12,300 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 15 / 41 Page 133 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Inflation 4% 0 0 0 17,000 0 0 0 0 0 0 Inflation 5% 0 0 0 0 1,750 0 0 0 0 0 Inflation 6% 0 0 0 0 0 1,350 0 0 0 0 Inflation 7% 0 0 0 0 0 0 1,575 0 0 0 Inflation 9% 0 0 0 0 0 0 0 0 15,750 0 Total 0 700 12,300 17,000 1,750 1,350 1,575 0 15,750 3,000 Total Expenditures and Uses 42,500 35,700 422,300 442,000 36,750 23,850 24,075 0 190,750 33,000 Change in Fund Balance 58,500 90,300 -296,300 -316,000 89,250 102,150 101,925 126,000 -64,750 93,000 ## Ending Balance 418,019 508,319 212,019 -103,981 -14,731 87,419 189,344 315,344 250,594 343,594 ## Produced Using Plan-It CIP SoftwarePage 16 / 41 Page 134 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 408 Pathway & Parking Lot ## Maintenance Fund Beginning Balance 636,077 625,477 461,965 502,447 330,241 319,841 316,032 330,401 342,553 249,879 ## Revenues and Other Fund Sources ## Revenue Franchise Fees 365,000 365,000 365,000 365,000 365,000 365,000 365,000 365,000 365,000 365,000 Investment Income 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Tax Levy 0 23,000 26,450 30,418 34,980 40,227 46,261 53,200 61,180 70,358 Total 370,000 393,000 396,450 400,418 404,980 410,227 416,261 423,200 431,180 440,358 ## Other Fund Sources Total Revenues and Other Fund Sources 370,000 393,000 396,450 400,418 404,980 410,227 416,261 423,200 431,180 440,358 Total Funds available 1,006,077 1,018,477 858,415 902,865 735,221 730,068 732,293 753,601 773,733 690,237 ## Expenditures and Uses ## Capital Projects & Equipment ## Pathway & Parking Pathway maintenance PP-001 225,000 225,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 Pathway construction - NEW PP-002 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 BNSF Railway lease payment PP-003 16,300 16,300 16,300 16,300 16,300 16,300 16,300 16,300 16,300 16,300 ## PARKLOT-001 Acorn Park East 2 ## Parking Lots (2020) ## PP-004 0 0 0 0 0 0 0 0 35,000 0 ## PARKLOT-002 Acorn Park West ## Parking Lot (2020) ## PP-005 0 0 0 0 0 0 0 0 35,000 0 ## PARKLOT-004 Autumn Grove Park ## Parking Lot (2016) ## PP-006 0 0 0 0 0 0 0 0 0 35,000 ## PARKLOT-005 Bruce Russell Park ## Parking Lot (2005) ## PP-007 0 0 0 0 0 25,000 0 0 0 0 ## PARKLOT-008 Central Park Dale ## West (Soccer Fields) North Parking Lot (2017) ## PP-010 0 0 0 0 0 20,000 0 0 0 0 ## PARKLOT-010/039 Central Park ## Lexington East/North Parking Lots (2008) ## PP-012 0 0 0 90,000 0 0 0 0 0 0 ## PARKLOT-011 Central Park Victoria ## East (Ballfields) Parking Lot (2016) ## PP-013 0 0 0 0 30,000 0 0 0 0 0 ## PARKLOT-012 Central Park Victoria ## West (Lions) North Parking Lot (2005) ## PP-014 25,000 0 0 0 0 0 0 0 0 0 ## PARKLOT-013 Central Park Victoria ## West (Foundation) South Parking Lot (2021) ## PP-015 0 0 0 0 0 0 0 0 35,000 0 ## Produced Using Plan-It CIP SoftwarePage 17 / 41 Page 135 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## PARKLOT-014 Evergreen Park ## Parking Lot (2000) ## PP-016 0 20,000 0 0 0 0 0 0 0 0 ## PARKLOT-021 Oasis Park Parking Lot (2016) ## PP-022 0 0 0 0 20,000 0 0 0 0 0 ## PARKLOT-022 Reservoir Woods ## Parking Lot (2000) ## PP-023 0 20,000 0 0 0 0 0 0 0 0 ## PARKLOT-023 Rosebrook Park North ## Parking Lot (2002) ## PP-024 35,000 0 0 0 0 0 0 0 0 0 ## PARKLOT-026 Roseville Fire Station #1 Lexington Driveway (2012) ## PP-027 0 0 0 0 0 0 30,000 0 0 0 ## PARKLOT-027 Roseville Fire Station #1 Parking Lot (2015) ## PP-028 0 0 0 0 0 0 0 0 30,000 0 ## PARKLOT-028 Dog Park (Kent St ## Ramsey County) Parking Lot (2000) ## PP-029 0 20,000 0 0 0 0 0 0 0 0 ## PARKLOT-031 Roseville Police ## Department Driveway (2004) ## PP-030 0 10,000 0 0 0 0 0 0 0 0 ## PARKLOT-033 Public Works Yard (2006) ## PP-032 0 0 0 0 0 0 0 0 0 70,000 ## PARKLOT-035 Roseville Skating ## Center South Parking Lot (2010) ## PP-034 0 0 0 115,000 0 0 0 0 0 0 ## PARKLOT-036 Sandcastle Park ## Parking Lot (2004) ## PP-035 0 0 0 0 0 0 0 15,000 0 0 ## PARKLOT-037 Veterans Park (VFW) ## Parking Lot (1995) ## PP-036 0 35,000 0 0 0 0 0 0 0 0 ## PARKLOT-038 Villa Park North (B- ## Dale) Parking Lot (2016) ## PP-037 0 0 0 0 0 0 0 0 0 25,000 ## PARKLOT-040 License Center Mall Parking Lot (east 2022) ## PP-038 0 120,000 0 0 0 0 0 0 0 0 ## PARKLOT-041 Owasso Cherrywood Ballfield (2017) ## PP-039 0 0 0 0 0 0 0 20,000 0 0 Pathway Rating (ICON) PP-040 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Total 356,300 521,300 321,300 526,300 371,300 366,300 351,300 356,300 456,300 451,300 ## Other Uses Inflation 10% 0 0 0 0 0 0 0 0 0 47,560 Inflation 2% 0 10,912 0 0 0 0 0 0 0 0 Inflation 3% 0 0 10,368 0 0 0 0 0 0 0 Inflation 4% 0 0 0 22,024 0 0 0 0 0 0 Inflation 5% 0 0 0 0 19,780 0 0 0 0 0 Inflation 6% 0 0 0 0 0 23,436 0 0 0 0 Inflation 7% 0 0 0 0 0 0 26,292 0 0 0 Inflation 8% 0 0 0 0 0 0 0 30,448 0 0 ## Produced Using Plan-It CIP SoftwarePage 18 / 41 Page 136 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Inflation 9% 0 0 0 0 0 0 0 0 43,254 0 Other Operating 24,300 24,300 24,300 24,300 24,300 24,300 24,300 24,300 24,300 24,300 Total 24,300 35,212 34,668 46,324 44,080 47,736 50,592 54,748 67,554 71,860 Total Expenditures and Uses 380,600 556,512 355,968 572,624 415,380 414,036 401,892 411,048 523,854 523,160 Change in Fund Balance -10,600 -163,512 40,482 -172,206 -10,400 -3,809 14,369 12,152 -92,674 -82,802 ## Ending Balance 625,477 461,965 502,447 330,241 319,841 316,032 330,401 342,553 249,879 167,077 ## Produced Using Plan-It CIP SoftwarePage 19 / 41 Page 137 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 409 Central Services Equipment Fund Beginning Balance 231,581 217,081 202,211 187,572 173,180 159,052 145,205 131,656 118,423 105,524 ## Revenues and Other Fund Sources ## Revenue Investment Income 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 Tax Levy 40,000 40,800 41,616 42,448 43,297 44,163 45,046 45,947 46,866 47,804 Total 44,000 44,800 45,616 46,448 47,297 48,163 49,046 49,947 50,866 51,804 ## Other Fund Sources Total Revenues and Other Fund Sources 44,000 44,800 45,616 46,448 47,297 48,163 49,046 49,947 50,866 51,804 Total Funds available 275,581 261,881 247,827 234,020 220,477 207,215 194,251 181,603 169,289 157,328 ## Expenditures and Uses ## Capital Projects & Equipment ## Central Services Postage Machine Lease CS-001 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 Copier/Printer/Scanner Lease CS-002 54,000 54,000 54,000 54,000 54,000 54,000 54,000 54,000 54,000 54,000 Total 58,500 58,500 58,500 58,500 58,500 58,500 58,500 58,500 58,500 58,500 ## Other Uses Inflation 10% 0 0 0 0 0 0 0 0 0 5,850 Inflation 2% 0 1,170 0 0 0 0 0 0 0 0 Inflation 3% 0 0 1,755 0 0 0 0 0 0 0 Inflation 4% 0 0 0 2,340 0 0 0 0 0 0 Inflation 5% 0 0 0 0 2,925 0 0 0 0 0 Inflation 6% 0 0 0 0 0 3,510 0 0 0 0 Inflation 7% 0 0 0 0 0 0 4,095 0 0 0 Inflation 8% 0 0 0 0 0 0 0 4,680 0 0 Inflation 9% 0 0 0 0 0 0 0 0 5,265 0 Total 0 1,170 1,755 2,340 2,925 3,510 4,095 4,680 5,265 5,850 Total Expenditures and Uses 58,500 59,670 60,255 60,840 61,425 62,010 62,595 63,180 63,765 64,350 Change in Fund Balance -14,500 -14,870 -14,639 -14,392 -14,128 -13,847 -13,549 -13,233 -12,899 -12,546 ## Ending Balance 217,081 202,211 187,572 173,180 159,052 145,205 131,656 118,423 105,524 92,978 ## Produced Using Plan-It CIP SoftwarePage 20 / 41 Page 138 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 410 General Facilities Replacement ## Fund Beginning Balance 4,060,388 1,000,297 -1,253,498 -1,718,254 -1,365,620 -2,038,451 -2,209,547 -4,547,703 -4,770,009 -4,991,120 ## Revenues and Other Fund Sources ## Revenue Fees 77,184 77,184 77,184 77,184 77,184 77,184 77,184 77,184 77,184 77,184 Investment Income 10,000 0 0 0 0 0 0 0 0 0 Tax Levy 748,650 748,650 748,650 748,650 748,650 748,650 748,650 748,650 748,650 748,650 Total 835,834 825,834 825,834 825,834 825,834 825,834 825,834 825,834 825,834 825,834 ## Other Fund Sources Bonds LC 14,500,000 0 0 0 0 0 0 0 0 0 Bonds PW Center 0 64,000,000 0 0 0 0 0 0 0 0 Donation - SC4200 50,000 0 0 0 0 0 0 0 0 0 Total 14,550,000 64,000,000 0 0 0 0 0 0 0 0 Total Revenues and Other Fund Sources 15,385,834 64,825,834 825,834 825,834 825,834 825,834 825,834 825,834 825,834 825,834 Total Funds available 19,446,222 65,826,131 -427,664 -892,420 -539,786 -1,212,617 -1,383,713 -3,721,869 -3,944,175 -4,165,286 ## Expenditures and Uses ## Capital Projects & Equipment ## General Facilities Equipment Replacement CM-01 0 5,000 0 1,000 0 1,000 0 5,000 0 1,000 Council Furniture CM-02 40,000 0 0 0 0 0 0 0 0 0 Council Control/Sound System CM-03 10,000 0 2,500 0 2,500 0 10,000 0 2,500 0 Council: camera replacement CM-04 0 25,000 0 0 0 0 0 0 50,000 0 Liebert condensing unit (IT Server ## Room) ## GEN-001 0 0 0 0 0 0 0 60,000 0 0 Liebert AHV (IT Server Room) GEN-002 0 0 0 0 0 0 0 30,000 0 0 UPS - IT Server Room GEN-003 0 0 0 0 0 0 50,000 0 0 0 Campus: Security Cameras GF-001 30,000 30,000 30,000 0 0 0 0 0 0 0 ## Campus: Network Access Devices - previously IT ## GF-002 30,425 29,244 3,000 35,000 33,000 33,000 33,000 33,000 33,000 33,000 ## City Hall/PD: Replace Rooftop Heat/ ## AC - 30 TON City Hall ## GF-004 140,000 0 0 0 0 0 0 0 0 0 ## City Hall/PD: Replace Rooftop Heat/ ## AC - 50 TON City Hall ## GF-005 175,000 0 0 0 0 0 0 0 0 0 ## City Hall/PD: Air Handler System City ## Hall ## GF-006 435,000 0 0 0 0 0 0 0 0 0 ## City Hall/PD: Variable Control ## Motors (180 Valve) ## GF-007 25,000 25,000 25,000 25,000 25,000 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 21 / 41 Page 139 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## City Hall/PD: Misc Work Station ## Upgrades ## GF-008 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 ## City Hall/PD: Conference Room ## Upgrades ## GF-010 10,000 10,000 10,000 10,000 10,000 0 0 0 0 0 Campus: Door Card Reader GF-011 0 0 35,000 0 0 0 0 0 0 0 ## MF: Make Up Air Units (Maintenance ## Garage) ## GF-013 0 35,000 0 0 0 0 0 0 35,000 0 City Hall/PD: Water heaters GF-014 10,000 0 0 0 0 0 0 0 0 0 City Hall/PD: Replace boiler City Hall GF-015 0 0 0 0 0 0 0 0 60,000 0 ## City Hall/PD: Police & PW garage Co2/No2 detectors ## GF-016 10,000 0 0 0 0 10,000 0 0 0 0 MF: Alerton Controls in PW Facility GF-017 0 0 20,000 0 0 0 0 0 0 0 ## City Hall/PD: Update HVAC Controls - Software ## GF-018 7,500 0 0 0 7,500 0 0 0 7,500 0 City Hall/PD: Update Flooring CH/PD GF-019 20,000 20,000 20,000 20,000 0 0 0 0 0 0 ## MF: Update Flooring Maintenance ## Facility ## GF-020 0 0 0 0 0 0 0 30,000 0 0 ## City Hall/PD: workstation replacement city hall ## GF-022 0 0 0 0 0 0 0 0 350,000 0 ## City Hall/PD: Overhead door replacement - CH/PD/Main ## GF-023 25,000 25,000 25,000 25,000 0 0 0 0 0 0 MF: Roof - North Garage GF-025 0 0 0 0 0 0 0 120,000 0 0 MF: Roof - PW Garage GF-026 0 0 0 0 0 0 0 175,000 0 0 ? Card access system replacement GF-028 0 0 0 50,000 0 0 0 0 0 0 ## City Hall/PD: Replace new Roof City ## Hall ## GF-029 0 0 0 0 0 0 225,000 0 0 0 ## City Hall/PD: Emergency generator ## City Hall ## GF-030 0 0 375,000 0 0 0 0 0 0 0 MF: Emergency generator GF-031 0 100,000 0 0 0 0 0 0 0 0 ## MF: Tables and chairs Maintenance ## Facility ## GF-033 0 0 20,000 0 0 0 0 0 20,000 0 MF: Fuel system tank replacement GF-034 0 215,000 0 0 0 0 0 0 20,000 0 MF: Maintenance Yard Security Gate GF-035 0 30,000 0 0 0 0 0 0 0 0 City Hall/PD: Paint walls city hall GF-036 0 0 25,000 0 0 0 25,000 0 0 0 MF: Paint walls Maintenance Facility GF-037 0 15,000 0 15,000 0 0 0 0 15,000 0 ## City Hall/PD: Light Fixture ## Conversion ## GF-038 0 0 75,000 0 0 0 0 0 0 0 City Hall/PD: Elevator (Kone) GF-039 0 70,000 0 0 0 0 0 0 0 0 ## City Hall/PD: Police Elevator (Shindler 2003) ## GF-040 0 0 90,000 0 0 0 0 0 0 0 PF: Brimhall gymnasium GF-049 0 0 0 12,000 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 22 / 41 Page 140 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 PF - Central Park gymnasium GF-050 0 0 0 0 12,000 0 0 0 0 0 PF - Gymnastics Center Equipment GF-051 12,000 0 0 0 0 0 0 20,000 0 0 Campus Facility Assessment GF-053 30,000 0 0 0 0 0 0 0 0 0 ## City Hall/PD: Replace Sallyport ## Floors ## GF-054 155,000 0 0 0 0 0 0 0 0 0 ## City Hall/PD: Rehab Lower Garage ## Floor ## GF-055 0 355,000 0 0 0 0 0 0 0 0 ## City Hall/PD: Lower Garage ## Bathroom Upgrade ## GF-056 0 0 0 0 30,000 0 0 0 0 0 City Hall/PD: PD Bathroom Upgrade GF-057 0 0 60,000 0 0 0 0 0 0 0 ## City Hall/PD: Willow Room ## Equipment Upgrades ## GF-058 0 0 10,000 0 0 0 0 0 0 0 ## New Maintenance Operations ## Center ## GF-060 0 64,000,000 0 0 0 0 0 0 0 0 ## New License/Passport Center & ## Dance Studio ## GF-061 14,500,000 0 0 0 0 0 0 0 0 0 SC: Arena: Concrete Floor (2008) GF-070 0 0 0 0 125,000 0 0 0 0 0 ## GOLF: TRANSFER TO FUND ## 620-BLDG IMPROVEMENTS ## GF-151 69,500 620,000 35,500 10,000 17,000 30,000 70,000 34,500 87,000 55,000 ## Fire Station: Painting/wall paper in various areas of Fire Station ## GF-152 0 2,000 2,000 0 0 5,000 24,500 0 0 13,000 ## Fire Station: Carpeting in various areas of Fire Station ## GF-153 0 0 0 0 8,800 0 8,000 0 0 25,000 Fire Station: Shift office counter tops GF-154 0 3,500 0 0 0 0 0 0 0 0 Fire Station: Exercise room-flooring GF-155 0 0 0 0 0 30,000 0 0 0 0 Fire Station: Bay painting GF-156 30,000 0 0 0 0 0 0 0 0 0 Fire Station: Exterior gate & Controls GF-157 0 0 0 0 0 0 40,000 0 0 0 ## Fire Station: Laundry Room Washer & dryer- gear ## GF-159 20,000 0 0 0 0 0 0 0 0 0 Fire Station: Station Roof GF-160 0 0 0 0 0 0 575,000 0 0 0 ## Fire Station: Apparatus High ## Pressure Washer ## GF-161 0 0 0 0 0 0 0 0 0 18,000 ## Fire Station: Fire Station access control ## GF-164 0 0 0 0 0 0 25,000 0 0 0 Fire Station: Security system GF-165 3,000 0 3,000 0 0 0 45,000 0 0 0 Fire Station: Station Alerting system GF-166 0 0 0 0 0 0 0 0 0 125,000 ## Fire Station: Apparatus Bay Air ## Compressor ## GF-167 0 0 0 3,500 0 0 0 0 0 0 ## Fire Station: Overhead door replacement ## GF-168 0 0 0 0 0 100,000 0 0 0 0 Fire Station: Bi-fold door operators GF-169 0 120,000 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 23 / 41 Page 141 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## Fire Station: Bi-Fold Door Paint and ## Maintenance ## GF-170 0 0 0 0 0 0 0 40,000 0 0 Fire Station: Make-up air units GF-172 0 0 0 0 0 0 150,000 0 0 0 Fire Station: Chiller GF-173 0 0 0 0 0 0 300,000 0 0 0 Fire Station: Heat pumps (24) GF-174 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 ## Fire Station: Water to Water Heat ## Pump ## GF-175 0 0 0 0 0 0 0 150,000 0 0 Fire Station: Boiler and boiler pump GF-176 0 0 0 0 0 300,000 0 0 0 0 Fire Station: Core Loop Pump GF-177 0 0 0 0 0 0 25,000 0 0 0 Fire Station: Heat loop pump GF-178 0 0 0 0 0 0 10,000 0 0 0 Fire Station: Exhaust fans GF-179 0 0 0 0 0 0 10,000 0 0 0 Fire Station: Cabinet Unit Heaters GF-180 0 0 0 0 0 0 0 0 0 25,000 ## Fire Station: Emergency Power ## Generator ## GF-181 0 0 0 0 0 0 250,000 0 0 0 Fire Station: Campus loop pump GF-182 0 0 0 0 0 0 0 0 0 10,000 Fire Station: Fluid cooler fan GF-183 0 0 0 0 0 0 8,000 0 0 0 Fire Station: Heat zone pumps (6) GF-184 0 0 0 0 0 0 0 30,000 0 0 Fire Station: Concrete Exterior GF-185 0 10,000 0 0 10,000 0 0 10,000 0 0 Fire Station: Lighting - exterior and interior ## GF-186 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 ## Fire Station: Apparatus Bay Air ## Monitoring Sensors ## GF-188 25,000 0 0 0 0 0 0 0 0 0 SC: Arena: Refrigeration System SC-1068 0 0 15,000 0 900,000 0 0 0 0 0 SC: Arena: Fluid Cooler (2008) SC-1069 0 0 0 0 125,000 0 0 0 0 0 SC: OVAL: Soft Starts SC-1084 0 0 0 0 0 0 0 0 0 35,000 SC: Snow Melt Pit Arena-Stainless SC-1137 0 20,000 0 0 0 0 0 0 0 0 SC - Fire Alarm System SC-131 0 0 0 0 0 0 0 0 25,000 0 SC - Floor Scrubber SC-138 0 0 0 0 0 0 0 0 15,000 0 SC: Water Heater- Domestic H20 SC-2054 0 0 0 0 0 13,000 0 0 0 0 SC: Water Heater- Zamboni (2007) SC-2055 0 0 0 0 13,000 0 0 0 0 0 SC: Water Storage Tank SC-2056 0 0 0 13,000 0 0 0 0 0 0 SC: Arena: Dasher Boards SC-2071 300,000 0 0 0 0 0 0 0 0 0 SC: Arena: Scoreboard Large SC-2073 0 0 25,000 0 0 0 0 0 0 0 Arena: Restroom Remodeling SC-2077 0 250,000 0 0 0 0 0 0 0 0 SC: Drinking Fountains SC-2134 0 0 0 12,000 0 0 0 0 0 0 SC: Ice Edgers-Arena SC-2135 0 0 0 0 0 0 10,000 0 0 0 ## SC: Banquet Restroom Update (Upper) ## SC-2142 0 30,000 0 0 0 0 0 0 0 0 SC: Walking Track Flooring SC-2147 0 0 0 0 0 0 0 75,000 0 0 ## Produced Using Plan-It CIP SoftwarePage 24 / 41 Page 142 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 SC: OVAL and BR Elevator SC-2148 0 130,000 0 0 0 0 0 0 0 0 SC: Arena: Paint Ceiling/Beams SC-2149 250,000 0 0 0 0 0 0 0 0 0 SC: Arena: Bleacher Updates SC-2150 100,000 0 0 0 0 0 0 0 0 0 SC: OVAL Brine Pumping Systems SC-3092 0 0 0 195,000 0 0 0 0 0 0 ## OVAL Mechanical System Analysis & ## Implementation ## SC-3201 0 0 0 0 25,000 250,000 400,000 0 0 0 SC: Banquet Ceiling Tiles SC-4008 15,000 0 0 0 0 0 0 0 0 0 SC: OVAL Exterior Lighting SC-4080 265,000 0 0 0 0 0 0 0 0 0 SC: OVAL: lobby rubber flooring SC-4081 0 0 0 0 0 0 0 50,000 0 0 SC: OVAL: Micro Processors SC-4083 0 0 0 0 0 0 0 0 0 80,000 SC: OVAL: Snow Melt Pit SC-4089 0 0 0 0 50,000 0 0 0 0 0 ## SC: OVAL Safety Pad and Fence ## System ## SC-4095 0 0 0 0 0 0 450,000 0 0 0 ## SC: OVAL: Repair Support Column and replace Netting ## SC-4111 0 0 100,000 0 0 0 0 0 0 0 SC: Banquet Ctr: Flooring SC-4118 0 0 45,000 0 0 0 0 0 0 45,000 ## SC: Banquet Ctr Wall and Window ## Covering ## SC-4119 0 0 25,000 0 0 0 0 0 0 0 SC: Banquet Ctr: Divider Wall SC-4123 0 60,000 0 0 0 0 0 0 0 0 SC: Banquet Ctr: Tables SC-4126 10,000 10,000 0 0 0 0 0 0 0 0 SC: Bandy/OVAL Netting SC-4133 0 0 0 0 0 0 0 0 0 20,000 SC: Ice Edgers-OVAL SC-4136 0 0 0 0 0 0 10,000 0 0 0 SC: AV System Banquet Rooms SC-4139 0 0 0 0 0 0 0 0 25,000 0 Rubber for outside of OVAL SC-4141 35,000 0 0 0 0 0 0 0 0 0 ## SC: Banquet Hallway/Gen office/ ## Timing Room Flooring Replacement ## SC-4146 0 0 0 0 0 0 30,000 0 0 0 SC: Updates to OVAL Lobby SC-4200 100,000 0 0 0 0 0 0 0 0 0 SC: Exterior Painting SC-5053 0 0 0 0 0 0 50,000 0 0 0 SC: County Road C Sign SC-5060 0 0 0 0 0 0 0 0 40,000 0 SC: Arena: Roof SC-5067 400,000 0 0 0 0 0 0 0 0 0 ## SC: OVAL: Skate Park and Inline ## Hockey Rink/Other Seasonal ## Activities ## SC-5090 50,000 50,000 0 0 0 0 25,000 0 0 0 SC: Banquet and Lobby Roofs SC-5117 750,000 0 0 0 0 0 0 0 0 0 SC: Skate Sharpeners Arena/OVAL SC-5140 0 0 0 0 0 0 0 0 30,000 0 SC: Security/Keyless Entry System SC-5144 100,000 0 0 0 0 0 0 0 0 0 SC- Ductwork Cleaning SC-60132 0 0 0 0 0 0 0 0 30,000 0 SC: South Entry RTU (2007) SC-6057 0 0 30,000 0 0 0 0 0 0 0 SC: Arena: Mezzanine HP (2009) SC-6066 65,000 0 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 25 / 41 Page 143 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 SC: OVAL: Lobby RTU SC-6082 0 0 95,000 0 0 0 0 0 0 0 ## SC: Banquet Ctr: Fitness Room RTU (2007) ## SC-6116 0 40,000 0 0 0 0 0 0 0 0 Banquet Ctr: Rose Room Heat Pump SC-6120 85,000 0 0 0 0 85,000 0 0 0 0 SC: Banquet Ctr: Fireside Room HP SC-6121 45,000 0 0 0 0 0 0 0 0 0 Total 18,410,925 66,363,244 1,229,500 455,000 1,422,300 885,500 2,887,000 891,000 873,500 513,500 ## Other Uses Inflation 10% 0 0 0 0 0 0 0 0 0 51,350 Inflation 2% 0 47,265 0 0 0 0 0 0 0 0 Inflation 3% 0 0 36,885 0 0 0 0 0 0 0 Inflation 4% 0 0 0 18,200 0 0 0 0 0 0 Inflation 5% 0 0 0 0 71,115 0 0 0 0 0 Inflation 6% 0 0 0 0 0 53,130 0 0 0 0 Inflation 7% 0 0 0 0 0 0 202,090 0 0 0 Inflation 8% 0 0 0 0 0 0 0 71,280 0 0 Inflation 9% 0 0 0 0 0 0 0 0 78,615 0 Transfers Out to Fund 620 Golf 35,000 669,120 24,205 0 5,250 58,300 74,900 85,860 94,830 49,500 Total 35,000 716,385 61,090 18,200 76,365 111,430 276,990 157,140 173,445 100,850 Total Expenditures and Uses 18,445,925 67,079,629 1,290,590 473,200 1,498,665 996,930 3,163,990 1,048,140 1,046,945 614,350 Change in Fund Balance -3,060,091 -2,253,795 -464,756 352,634 -672,831 -171,096 -2,338,156 -222,306 -221,111 211,484 ## Ending Balance 1,000,297 -1,253,498 -1,718,254 -1,365,620 -2,038,451 -2,209,547 -4,547,703 -4,770,009 -4,991,120 -4,779,636 ## Produced Using Plan-It CIP SoftwarePage 26 / 41 Page 144 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 411 Park Improvement Fund Beginning Balance 3,334,951 3,152,951 1,828,091 1,790,645 1,512,614 1,231,066 322,898 353,177 54,604 -467 ## Revenues and Other Fund Sources ## Revenue Investment Income 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 Property Taxes 885,000 902,700 920,754 939,169 957,952 977,112 996,654 1,016,587 1,036,919 1,057,657 Total 895,000 912,700 930,754 949,169 967,952 987,112 1,006,654 1,026,587 1,046,919 1,067,657 ## Other Fund Sources Donations PIP-30030 0 700,000 0 0 0 0 0 0 0 0 Grant - PIP90002 200,000 100,000 0 0 0 0 0 0 0 0 Total 200,000 800,000 0 0 0 0 0 0 0 0 Total Revenues and Other Fund Sources 1,095,000 1,712,700 930,754 949,169 967,952 987,112 1,006,654 1,026,587 1,046,919 1,067,657 Total Funds available 4,429,951 4,865,651 2,758,845 2,739,814 2,480,566 2,218,178 1,329,552 1,379,764 1,101,523 1,067,190 ## Expenditures and Uses ## Capital Projects & Equipment ## Park Improvement Fund Park Irrigation System 0 50,000 0 50,000 0 0 0 0 0 0 ## Acorn Park Tennis and Basketball ## Courts ## PIP-10001 50,000 0 0 0 175,000 0 0 0 50,000 0 ## Applewood Park - 1/2 Court basketball ## PIP-10002 0 20,000 0 0 50,000 0 0 0 0 0 ## Autumn Grove Tennis Court and ## Basketball Courts ## PIP-10003 0 0 0 0 0 175,000 0 0 0 0 ## Bruce Russell Tennis Courts (2) and ## Basketball Court ## PIP-10004 0 0 0 0 0 175,000 0 0 0 0 ## Central Park Victoria: 2 lighted tennis, coated fence ## PIP-10005 0 0 0 50,000 0 0 0 175,000 0 0 Evergreen Park Pickleball Courts PIP-10006 0 100,000 0 0 0 0 0 50,000 0 0 Howard Johnson Tennis Court PIP-10007 0 0 175,000 0 0 0 0 0 50,000 0 Lexington Park Basketball Court PIP-10008 0 0 0 0 0 175,000 0 0 0 0 Owasso Hills: 1/2 court basketball PIP-10009 0 15,000 0 0 0 0 0 50,000 0 0 Pioneer Basketball Court PIP-10010 15,000 0 0 0 0 0 50,000 0 0 0 ## Keya Park Tennis and Basketball ## Courts ## PIP-10011 0 0 175,000 0 0 0 0 0 50,000 0 Rosebrook Park: 2 lighted tennis, coated fence ## PIP-10012 0 0 0 0 175,000 0 0 0 0 0 Sandcastle Park PIP-10013 0 0 0 0 50,000 0 0 0 0 0 Valley Park Basketball Court PIP-10014 15,000 0 0 0 0 0 50,000 0 0 0 Aŋpétu Téča Tennis Courts PIP-10015 0 175,000 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 27 / 41 Page 145 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Acorn Park Building PIP-20001 0 0 0 12,500 0 0 0 0 0 0 Applewood Shade Structure PIP-20002 0 0 0 0 0 40,000 0 0 0 0 Arb Maintenance Facility PIP-20004 0 0 0 0 0 7,500 0 0 0 0 Arboretum Center PIP-20005 0 0 0 0 0 0 15,000 0 0 0 Autumn Grove Park Building PIP-20007 0 0 0 0 0 0 0 0 0 25,000 ## Central Park Foundation (Victoria ## West) ## PIP-20010 0 0 0 0 0 0 250,000 0 0 0 Central Park Lexington Restrooms PIP-20011 0 618,000 0 0 0 0 0 0 0 0 ## Central Park Victoria Ballfields ## Pavillion Shelter ## PIP-20012 0 0 0 0 250,000 0 0 0 0 0 ## Evergreen Ballfields Concession & ## Storage Building ## PIP-20014 0 0 0 20,000 0 0 0 0 0 0 Evergreen neighborhood shelter PIP-20015 7,000 0 0 12,500 0 0 0 0 0 0 Central Park FORParks (Dale Street) PIP-20016 0 0 0 0 0 250,000 0 0 0 0 HANC Facility and Grounds PIP-20017 0 70,000 0 0 0 15,000 0 0 0 0 Central Park Jaycees Picnic Shelter PIP-20018 0 0 0 0 0 250,000 0 0 0 0 Langton Lake Shade Structure PIP-20019 0 0 5,000 0 0 0 0 0 0 0 Lexington Park Building PIP-20021 0 0 0 0 0 7,000 0 0 0 25,000 ## Central Park Lions Pavilion (Victoria ## Side) ## PIP-20022 0 0 0 0 0 0 250,000 0 0 0 Mapleview Park Shelter PIP-20023 0 0 50,000 0 0 0 0 0 0 0 Oasis Park Building PIP-20024 0 0 0 0 0 0 0 0 0 15,000 ## Owasso Ballfields Concession ## Building ## PIP-20025 10,000 0 0 0 0 0 0 0 0 0 Pioneer Pergola PIP-20026 0 0 5,000 0 0 0 0 0 0 0 Reservoir Woods Overlook PIP-20027 0 0 0 5,000 0 0 0 0 0 0 Rosebrook Park Building PIP-20030 0 0 0 0 0 0 7,000 0 0 20,000 Sandcastle Park Building PIP-20031 0 0 0 0 0 5,500 0 0 0 0 Shirle Klaus Pavillion PIP-20032 0 0 0 0 0 20,000 0 0 0 0 Veterans Park Restrooms PIP-20033 0 10,000 0 0 0 0 0 0 0 0 Villa Park Building PIP-20034 0 0 0 0 0 0 5,500 0 0 15,000 Park Buildings General PIP-20035 0 0 0 0 0 0 0 75,000 0 0 Park Building Roofs PIP-20036 0 0 0 0 0 0 0 72,000 72,000 0 Park Building HVAC PIP-20037 0 0 0 0 0 0 0 15,000 15,000 0 Park Building Flooring PIP-20038 0 0 0 0 0 0 0 0 15,000 15,000 Park Building Bathrooms PIP-20039 0 0 15,000 15,000 0 0 0 0 0 0 Park Building Interior Painting PIP-20041 0 0 0 0 0 0 0 0 24,000 0 Park Building Exterior Painting PIP-20042 45,000 0 0 0 0 0 0 0 0 45,000 Park Building Appliances PIP-20043 0 0 15,000 15,000 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 28 / 41 Page 146 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Park Building AV Updates PIP-20044 25,000 0 0 0 0 0 0 0 0 0 Acorn - 2014 PIP-30001 0 0 0 0 0 0 0 155,000 0 0 Bruce Russell - 2015 PIP-30004 0 0 0 0 0 0 0 0 125,000 0 Central Park Dale Street Playground PIP-30006 300,000 0 0 0 0 0 0 0 0 0 Central Park Victoria West - 2015 PIP-30007 0 0 0 0 0 0 0 0 0 225,000 Central Park Victori ballfields - 2014 PIP-30008 0 0 0 0 0 0 0 105,000 0 0 Evergreen - 2010 PIP-30009 0 0 0 0 0 135,000 0 0 0 0 Howard Johnson - 2014 PIP-30010 0 0 0 0 0 0 0 135,000 0 0 Langton Lake @ Ballfields - 2014 PIP-30011 0 0 0 0 0 0 0 0 155,000 0 Langton Lake @ C2 - 2015 PIP-30012 0 0 0 0 0 0 0 0 0 95,000 Villa Park (Lower) PIP-30014 0 185,000 0 0 0 0 0 0 0 0 Maple View - 2016 PIP-30015 0 0 0 0 0 0 0 0 0 95,000 Materion - 2014 PIP-30016 0 0 0 0 0 0 0 105,000 0 0 Oasis - 2015 PIP-30018 0 0 0 0 0 0 0 0 155,000 0 Upper Villa - 2016 PIP-30027 0 0 0 0 0 0 0 0 0 95,000 Valley Park Playground PIP-30028 0 155,000 0 0 0 0 0 0 0 0 Veterans Playground PIP-30029 0 200,000 0 0 0 0 0 0 0 0 Nature Playground PIP-30030 0 700,000 0 0 0 0 0 0 0 0 ## Central Park Sand Volley Ball Court: 4 sand courts ## PIP-40001 40,000 100,000 0 0 0 0 0 0 0 0 Acorn: Baseball Fields PIP-50001 0 0 0 0 10,000 0 0 0 0 10,000 ## Upper Villa Park: Softball Field & ## Lighting ## PIP-50004 0 0 0 0 30,000 0 0 0 0 10,000 Concordia: Softball Field PIP-50005 0 0 0 0 0 0 0 0 0 10,000 Concordia: Baseball Field PIP-50006 0 0 0 0 0 0 0 0 0 10,000 CP Dale Street Athletic Fields PIP-50008 0 0 0 85,000 0 85,000 0 0 0 0 ## CP Dale Street Athletic: Black Vinyl ## Fence ## PIP-50009 0 75,000 0 0 0 0 0 0 0 20,000 CP Lexington: Softball Fields PIP-50011 0 0 0 75,000 0 20,000 0 0 0 0 CP Victoria: Softball Fields PIP-50012 30,000 0 0 40,000 0 100,000 0 0 0 30,000 CP Victoria: Netting over play area PIP-50013 0 0 0 0 10,000 0 0 0 0 0 CP Victoria: Lighting PIP-50014 0 0 0 0 150,000 0 0 0 0 0 Evergereen: Baseball Field NW PIP-50016 0 0 0 0 0 40,000 0 0 0 0 Evergreen: Batting Cage PIP-50017 0 0 0 0 0 3,000 0 0 0 0 Langton Lake: Baseball Fields PIP-50018 0 20,000 0 0 0 20,000 0 0 10,000 0 Langton Lake: Multi-Purpose PIP-50019 0 0 0 50,000 0 0 0 0 0 10,000 Legion Field: Baseball Field PIP-50021 0 10,000 0 0 0 0 10,000 0 0 0 Owasso Ballfields: Baseball Field PIP-50023 150,000 0 0 0 0 15,000 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 29 / 41 Page 147 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## Rosebrook: Multi-Purpose (Soccer) ## Fields ## PIP-50025 75,000 75,000 0 0 0 0 0 0 0 0 Rosebrook: Lighting PIP-50027 0 0 100,000 0 0 0 0 0 0 0 CP Amphitheater Irrigation PIP-60002 25,000 0 0 0 0 0 0 0 0 0 CP Dale Street: Bridge PIP-70001 0 0 0 0 0 0 0 0 40,000 0 CP Frog Pond: Bridge PIP-70002 0 0 0 0 0 0 0 40,000 0 0 CP Vict. Ballfields: Bridge PIP-70003 0 0 0 0 40,000 0 0 0 0 0 HANC: Boardwalk Phase I PIP-70005 0 0 0 500,000 0 0 0 0 0 0 Langton Lake: Boardwalk PIP-70006 0 0 75,000 0 0 0 0 0 0 0 Langton Lake: Bridge PIP-70007 0 0 75,000 0 0 0 0 0 0 0 Park Buildings: Tables & Chairs PIP-80003 0 0 0 0 0 0 25,000 0 0 0 Park Pathway Lighting: General PIP-80004 0 50,000 0 0 0 0 0 0 0 0 CP Amphitheater Sound System PIP-80006 40,000 0 0 0 0 0 0 0 0 0 General Items (see below) PIP-90001 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 Natural Resources PIP-90002 250,000 150,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 Total 1,277,000 2,978,000 940,000 1,180,000 1,190,000 1,788,000 912,500 1,227,000 1,011,000 1,020,000 ## Other Uses Inflation 10% 0 0 0 0 0 0 0 0 0 102,000 Inflation 2% 0 59,560 0 0 0 0 0 0 0 0 Inflation 3% 0 0 28,200 0 0 0 0 0 0 0 Inflation 4% 0 0 0 47,200 0 0 0 0 0 0 Inflation 5% 0 0 0 0 59,500 0 0 0 0 0 Inflation 6% 0 0 0 0 0 107,280 0 0 0 0 Inflation 7% 0 0 0 0 0 0 63,875 0 0 0 Inflation 8% 0 0 0 0 0 0 0 98,160 0 0 Inflation 9% 0 0 0 0 0 0 0 0 90,990 0 Total 0 59,560 28,200 47,200 59,500 107,280 63,875 98,160 90,990 102,000 Total Expenditures and Uses 1,277,000 3,037,560 968,200 1,227,200 1,249,500 1,895,280 976,375 1,325,160 1,101,990 1,122,000 Change in Fund Balance -182,000 -1,324,860 -37,446 -278,031 -281,548 -908,168 30,279 -298,573 -55,071 -54,343 ## Ending Balance 3,152,951 1,828,091 1,790,645 1,512,614 1,231,066 322,898 353,177 54,604 -467 -54,810 ## Produced Using Plan-It CIP SoftwarePage 30 / 41 Page 148 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 590 Street Replacement Fund Beginning Balance 5,623,401 5,383,401 5,930,761 5,607,511 5,197,511 4,697,761 4,222,761 3,760,261 3,280,261 2,782,761 ## Revenues and Other Fund Sources ## Revenue Franchise Fees 1,360,000 1,360,000 1,360,000 1,360,000 1,360,000 1,360,000 1,360,000 1,360,000 1,360,000 1,360,000 Interest 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 ## MSA 1,415,000 2,077,000 1,125,000 0 500,000 500,000 0 0 0 0 Total 2,825,000 3,487,000 2,535,000 1,410,000 1,910,000 1,910,000 1,410,000 1,410,000 1,410,000 1,410,000 ## Other Fund Sources Total Revenues and Other Fund Sources 2,825,000 3,487,000 2,535,000 1,410,000 1,910,000 1,910,000 1,410,000 1,410,000 1,410,000 1,410,000 Total Funds available 8,448,401 8,870,401 8,465,761 7,017,511 7,107,511 6,607,761 5,632,761 5,170,261 4,690,261 4,192,761 ## Expenditures and Uses ## Capital Projects & Equipment ## Storm ## Toro Goundmaster Polor Trac ## 7210-D(2021) #110 ## STM-001 0 0 0 0 45,000 0 0 0 0 0 Total 0 0 0 0 45,000 0 0 0 0 0 ## Street Replacement Mill & overlay - local streets ST-001 1,650,000 1,650,000 1,650,000 1,750,000 1,750,000 1,750,000 1,750,000 1,750,000 1,750,000 1,850,000 ## MSA - County Road D, Cleveland - ## Fairview ## ST-002 250,000 0 0 0 0 0 0 0 0 0 MSA - Albert, Commerce Pathway ST-003 0 0 250,000 0 0 0 0 0 0 0 ## MSA - Lexington & Roselawn Signal ## Repalcement ## ST-004 0 150,000 0 0 0 0 0 0 0 0 MSA - Rice, Larpentuer - Cty B ST-005 375,000 350,000 0 0 0 0 0 0 0 0 ## MSA - Rice Street, CR B2-South ## Owasso ## ST-007 125,000 375,000 375,000 0 0 0 0 0 0 0 ## MSA - 27-04 2027 PMP (Centerpointe, Roselawn) ## ST-009 500,000 0 0 0 0 0 0 0 0 0 MSA - B2/Cleveland Signal ST-010 0 75,000 0 0 0 0 0 0 0 0 ## MSA - Lexington Pathway, County ## B2-Brooks ## ST-011 0 0 0 0 0 500,000 0 0 0 0 ## MSA - 29-04 2029 PMP - TBD ST-012 0 0 500,000 0 0 0 0 0 0 0 MSA - 31-04 2031 PMP (Woodhill, ## Civic Center) ## ST-013 0 0 0 0 500,000 0 0 0 0 0 ## MSA - Victoria Pathway, County C- ## County D ## ST-014 165,000 282,000 0 0 0 0 0 0 0 0 Total 3,065,000 2,882,000 2,775,000 1,750,000 2,250,000 2,250,000 1,750,000 1,750,000 1,750,000 1,850,000 ## Other Uses Inflation 10% 0 0 0 0 0 0 0 0 0 185,000 ## Produced Using Plan-It CIP SoftwarePage 31 / 41 Page 149 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Inflation 2% 0 57,640 0 0 0 0 0 0 0 0 Inflation 3% 0 0 83,250 0 0 0 0 0 0 0 Inflation 4% 0 0 0 70,000 0 0 0 0 0 0 Inflation 5% 0 0 0 0 114,750 0 0 0 0 0 Inflation 6% 0 0 0 0 0 135,000 0 0 0 0 Inflation 7% 0 0 0 0 0 0 122,500 0 0 0 Inflation 8% 0 0 0 0 0 0 0 140,000 0 0 Inflation 9% 0 0 0 0 0 0 0 0 157,500 0 Total 0 57,640 83,250 70,000 114,750 135,000 122,500 140,000 157,500 185,000 Total Expenditures and Uses 3,065,000 2,939,640 2,858,250 1,820,000 2,409,750 2,385,000 1,872,500 1,890,000 1,907,500 2,035,000 Change in Fund Balance -240,000 547,360 -323,250 -410,000 -499,750 -475,000 -462,500 -480,000 -497,500 -625,000 ## Ending Balance 5,383,401 5,930,761 5,607,511 5,197,511 4,697,761 4,222,761 3,760,261 3,280,261 2,782,761 2,157,761 ## Produced Using Plan-It CIP SoftwarePage 32 / 41 Page 150 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 600 Sanitary Sewer Capital Fund Beginning Balance 0 0 0 0 0 0 0 0 0 0 ## Revenues and Other Fund Sources ## Revenue Fees 2,237,000 2,759,100 2,415,350 1,304,160 1,342,950 1,353,090 1,341,780 1,362,420 1,626,280 1,544,400 Total 2,237,000 2,759,100 2,415,350 1,304,160 1,342,950 1,353,090 1,341,780 1,362,420 1,626,280 1,544,400 ## Other Fund Sources Total Revenues and Other Fund Sources 2,237,000 2,759,100 2,415,350 1,304,160 1,342,950 1,353,090 1,341,780 1,362,420 1,626,280 1,544,400 Total Funds available 2,237,000 2,759,100 2,415,350 1,304,160 1,342,950 1,353,090 1,341,780 1,362,420 1,626,280 1,544,400 ## Expenditures and Uses ## Capital Projects & Equipment ## Parks & Recreation Vehicles & Equipment Water truck (1/2 cost) (2019) #510 PR-006 0 0 75,000 0 0 0 0 0 0 0 Total 0 0 75,000 0 0 0 0 0 0 0 ## Public Works Vehicle and Equipment ## Trafifix Scorpion Attenuator (2017) #137 ## PW-025 0 0 0 0 0 7,500 0 0 0 0 Bobcat T76 (2024) #131 PW-036 0 0 0 0 25,000 0 0 0 0 0 Generac light tower Magnum ## MLT4060KV (2013) #210 ## PW-037 0 0 0 0 0 0 0 2,500 0 0 ## Genie GS2646 Man Lift (2007) #90225 ## PW-038 0 0 0 0 0 0 0 2,500 0 0 Nissan PL40 Forklift (2006) #90125 PW-039 0 0 0 0 0 0 0 2,500 0 0 Total 0 0 0 0 25,000 7,500 0 7,500 0 0 ## Sanitary ## Sreco-Flexible EMSP-6 Easement Machine (2005) #215 ## SAN-006 0 95,000 0 0 0 0 0 0 0 0 Rover Sewer Camera (2019) #241 SAN-014 0 290,000 0 0 0 0 0 0 0 0 #xx GPS Unit SAN-016 0 0 4,000 0 0 0 0 0 0 0 Asset Management System SAN-022 50,000 0 0 0 0 0 0 0 0 0 Replace/Upgrade SCADAsystem SAN-023 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 I & I reduction SAN-024 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 Lift Station - Brenner upgrade, no gen ## SAN-025 400,000 0 0 0 0 0 0 0 0 0 ## Lift Station - Center Street upgrade, no gen ## SAN-026 60,000 400,000 0 0 0 0 0 0 0 0 Lift Station - Fulham Rehab SAN-031 0 60,000 635,000 0 0 0 0 0 0 0 Sewer main repairs (lining) SAN-038 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 Rubber Tire Backhoe SAN-039 0 65,000 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 33 / 41 Page 151 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Ford F350 (2022) #202 SAN-041 0 0 0 0 0 0 0 0 73,000 0 ## Chevrolet Silverado Flatbed Crane (2022) #209 ## SAN-042 0 0 0 0 0 0 0 0 165,000 0 Ford F250 (2017) #223 SAN-046 73,000 0 0 0 0 0 0 0 0 0 ## Caterpillar M315D Wheeled Back Hoe (2008) #211 ## SAN-047 0 134,000 0 0 0 0 0 0 0 0 Total 1,837,000 2,298,000 1,893,000 1,254,000 1,254,000 1,254,000 1,254,000 1,254,000 1,492,000 1,254,000 ## Storm ## Rotobec PC018B Grapple 360 Mini Excavator (2014) #225 A13 ## STM-019 0 0 7,000 0 0 0 0 0 0 0 Lift Station Condition Analysis STM-037 0 0 0 0 0 0 0 0 0 50,000 Total 0 0 7,000 0 0 0 0 0 0 50,000 ## Water ## Caterpillar CVP75 Vibratory Plate Compactor (2015) #211 A14 ## WT-003 0 7,000 0 0 0 0 0 0 0 0 ## Caterpillar H65ES Hydraulic Breaker ## (2014) #225 A12 ## WT-005 0 0 5,000 0 0 0 0 0 0 0 Caterpillar 305E Excavator (2015) #225 ## WT-007 0 0 40,000 0 0 0 0 0 0 0 ## Bomag BMP8500 Compactor (2017) #237 ## WT-009 0 0 0 0 0 15,000 0 0 0 0 Water AMR meter system replacements ## WT-017 400,000 400,000 325,000 0 0 0 0 0 0 100,000 Total 400,000 407,000 370,000 0 0 15,000 0 0 0 100,000 ## Other Uses Inflation 10% 0 0 0 0 0 0 0 0 0 140,400 Inflation 9% 0 0 0 0 0 0 0 0 134,280 0 Inflation 8% 0 0 0 0 0 0 0 100,920 0 0 Inflation 7% 0 0 0 0 0 0 87,780 0 0 0 Inflation 6% 0 0 0 0 0 76,590 0 0 0 0 Inflation 5% 0 0 0 0 63,950 0 0 0 0 0 Inflation 4% 0 0 0 50,160 0 0 0 0 0 0 Inflation 3% 0 0 70,350 0 0 0 0 0 0 0 Inflation 2% 0 54,100 0 0 0 0 0 0 0 0 Total 0 54,100 70,350 50,160 63,950 76,590 87,780 100,920 134,280 140,400 Total Expenditures and Uses 2,237,000 2,759,100 2,415,350 1,304,160 1,342,950 1,353,090 1,341,780 1,362,420 1,626,280 1,544,400 Change in Fund Balance 0 0 0 0 0 0 0 0 0 0 ## Ending Balance 0 0 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 34 / 41 Page 152 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 610 Water Capital Fund Beginning Balance 0 0 0 0 0 0 0 0 0 0 ## Revenues and Other Fund Sources ## Revenue Fees 1,612,000 4,701,180 1,615,040 1,711,840 1,642,200 3,208,090 1,769,780 1,803,060 1,715,660 1,775,400 Total 1,612,000 4,701,180 1,615,040 1,711,840 1,642,200 3,208,090 1,769,780 1,803,060 1,715,660 1,775,400 ## Other Fund Sources Total Revenues and Other Fund Sources 1,612,000 4,701,180 1,615,040 1,711,840 1,642,200 3,208,090 1,769,780 1,803,060 1,715,660 1,775,400 Total Funds available 1,612,000 4,701,180 1,615,040 1,711,840 1,642,200 3,208,090 1,769,780 1,803,060 1,715,660 1,775,400 ## Expenditures and Uses ## Capital Projects & Equipment ## Public Works Vehicle and Equipment ## Trafifix Scorpion Attenuator (2017) #137 ## PW-025 0 0 0 0 0 7,500 0 0 0 0 Bobcat T76 (2024) #131 PW-036 0 0 0 0 25,000 0 0 0 0 0 Generac light tower Magnum ## MLT4060KV (2013) #210 ## PW-037 0 0 0 0 0 0 0 2,500 0 0 ## Genie GS2646 Man Lift (2007) #90225 ## PW-038 0 0 0 0 0 0 0 2,500 0 0 Nissan PL40 Forklift (2006) #90125 PW-039 0 0 0 0 0 0 0 2,500 0 0 Total 0 0 0 0 25,000 7,500 0 7,500 0 0 ## Sanitary #xx GPS Unit SAN-016 0 0 4,000 0 0 0 0 0 0 0 Asset Management System SAN-022 50,000 0 0 0 0 0 0 0 0 0 Replace/Upgrade SCADAsystem SAN-023 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 Rubber Tire Backhoe SAN-039 0 65,000 0 0 0 0 0 0 0 0 ## Caterpillar M315D Wheeled Back Hoe (2008) #211 ## SAN-047 0 133,000 0 0 0 0 0 0 0 0 Total 54,000 202,000 8,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 ## Storm ## Rotobec PC018B Grapple 360 Mini Excavator (2014) #225 A13 ## STM-019 0 0 7,000 0 0 0 0 0 0 0 Total 0 0 7,000 0 0 0 0 0 0 0 ## Water ## Caterpillar CVP75 Vibratory Plate Compactor (2015) #211 A14 ## WT-003 0 7,000 0 0 0 0 0 0 0 0 ## Caterpillar H65ES Hydraulic Breaker ## (2014) #225 A12 ## WT-005 0 0 5,000 0 0 0 0 0 0 0 Caterpillar 305E Excavator (2015) #225 ## WT-007 0 0 40,000 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 35 / 41 Page 153 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Felling Ft7t Trailer (2021) #236 WT-008 0 0 0 0 10,000 0 0 0 0 0 ## Bomag BMP8500 Compactor (2017) #237 ## WT-009 0 0 0 0 0 15,000 0 0 0 0 ## EH Wachs 77-000-38 Standard LX ## Valve Maintenance Trailer (2018) #240 ## WT-010 0 110,000 0 0 0 0 0 0 0 0 Trench Box - main 10'x8' WT-015 0 30,000 0 0 0 0 0 0 0 0 Trench Box GME 5'x3' WT-016 0 0 0 0 15,000 0 0 0 0 0 Water AMR meter system replacements ## WT-017 400,000 400,000 325,000 0 0 0 0 0 0 100,000 Water Booster Station WT-018 0 2,400,000 0 0 0 0 140,000 0 0 0 Elevated storage tank repainting contract ## WT-019 98,000 10,000 10,000 10,000 10,000 1,500,000 10,000 10,000 10,000 10,000 Water Tower Mixing Equipment WT-022 0 0 0 12,000 0 0 0 0 0 0 AH Meter Pits WT-023 0 350,000 0 350,000 0 0 0 0 0 0 Water Main Replacement WT-026 1,000,000 1,100,000 1,100,000 1,100,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 ## RAM 3500 (2022) #206 WT-029 0 0 0 0 0 0 0 73,000 0 0 Ford Transit 150 (2019) #208 WT-030 60,000 0 0 0 0 0 0 0 60,000 0 ## GMC C5500 Water Break (2008) #213 ## WT-032 0 0 0 170,000 0 0 0 0 0 0 Ford F250 (2017) #221 WT-033 0 0 73,000 0 0 0 0 0 0 0 Ford F350 (2022) #222 WT-034 0 0 0 0 0 0 0 75,000 0 0 Total 1,558,000 4,407,000 1,553,000 1,642,000 1,535,000 3,015,000 1,650,000 1,658,000 1,570,000 1,610,000 ## Other Uses Inflation 2% 0 92,180 0 0 0 0 0 0 0 0 Inflation 3% 0 0 47,040 0 0 0 0 0 0 0 Inflation 4% 0 0 0 65,840 0 0 0 0 0 0 Inflation 5% 0 0 0 0 78,200 0 0 0 0 0 Inflation 6% 0 0 0 0 0 181,590 0 0 0 0 Inflation 7% 0 0 0 0 0 0 115,780 0 0 0 Inflation 8% 0 0 0 0 0 0 0 133,560 0 0 Inflation 9% 0 0 0 0 0 0 0 0 141,660 0 Inflation 10% 0 0 0 0 0 0 0 0 0 161,400 Total 0 92,180 47,040 65,840 78,200 181,590 115,780 133,560 141,660 161,400 Total Expenditures and Uses 1,612,000 4,701,180 1,615,040 1,711,840 1,642,200 3,208,090 1,769,780 1,803,060 1,715,660 1,775,400 Change in Fund Balance 0 0 0 0 0 0 0 0 0 0 ## Ending Balance 0 0 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 36 / 41 Page 154 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 620 Golf Vehicle & Equipment Fund Beginning Balance 0 0 0 0 0 0 0 0 0 0 ## Revenues and Other Fund Sources ## Revenue Transfer from Fund 402 50,000 147,900 20,600 50,960 10,500 10,600 89,880 54,000 43,600 15,400 Transfer from Fund 410 35,000 669,120 24,205 0 5,250 58,300 74,900 85,860 94,830 49,500 Total 85,000 817,020 44,805 50,960 15,750 68,900 164,780 139,860 138,430 64,900 ## Other Fund Sources Total Revenues and Other Fund Sources 85,000 817,020 44,805 50,960 15,750 68,900 164,780 139,860 138,430 64,900 Total Funds available 85,000 817,020 44,805 50,960 15,750 68,900 164,780 139,860 138,430 64,900 ## Expenditures and Uses ## Capital Projects & Equipment ## Golf ## Golf Shared with RSC Ford F150 Truck (2012) ## G-001 0 0 0 0 0 0 0 0 40,000 0 ## Golf: Gas Pump / Tank: Replacement - 1967 ## G-002 0 20,000 0 0 0 0 0 0 0 0 Golf: Zero Turn Mower - 2008 G-003 0 0 0 0 0 0 0 0 0 14,000 Golf: Fairway Mower -2008 G-004 0 125,000 0 0 0 0 0 0 0 0 Golf: Greens Mower - 2000 G-005 0 0 0 0 0 0 0 50,000 0 0 Golf: Greens/tee mower - 2002 G-006 0 0 0 0 0 0 44,000 0 0 0 ## Golf: Turf Equipment/Aerators - 2001 ## G-007 0 0 0 39,000 0 0 0 0 0 0 Golf: Cushman #1 & 2 - 2014 and 1988 ## G-009 50,000 0 0 0 0 0 0 0 0 0 Golf: Utility Vehicle #2 2022 G-010 0 0 0 0 0 0 40,000 0 0 0 ## Golf: Course Safety Netting Replacement 1997 ## G-012 0 0 0 0 0 35,000 0 20,000 0 0 Golf: Top Dresser Tufco - 1993 G-013 0 0 20,000 0 0 0 0 0 0 0 Golf Com Bldg: Cameras G-014 15,000 0 0 0 0 0 0 0 0 0 Golf: Operational Power Equipment G-015 0 0 0 0 10,000 0 0 0 0 0 ## Golf: Com Bldg Kitchen Equipment 2018 ice ## G-016 10,000 0 0 10,000 0 10,000 0 0 0 0 ## Golf: Com Bldg Paint Interior/ ## Exterior ## G-017 0 15,000 14,500 0 0 20,000 0 14,500 0 0 Golf: Com Bldg Furnace / AC - 2018 G-018 0 0 0 0 0 0 70,000 0 0 0 Golf: Com Bldg Roof Replace - 2018 G-019 0 0 0 0 0 0 0 0 0 30,000 Golf: Com Bldg Carpeting/Flooring G-020 0 19,000 0 0 0 0 0 0 17,000 0 ## Golf: Com Bldg Furn. Replace. - 2018 ## Tables then Chairs ## G-021 0 10,000 9,000 0 0 0 0 10,000 0 10,000 ## Produced Using Plan-It CIP SoftwarePage 37 / 41 Page 155 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Golf: Replace Shop G-022 0 600,000 0 0 0 0 0 0 0 0 Golf: Shop /Upgrades/Paint - 2018 G-023 0 0 0 0 0 0 0 25,000 0 0 Golf: Sidewalk/Exterior Repairs 2018 G-024 10,000 0 0 0 0 0 0 10,000 0 0 ## Golf: Course Improvements, ## Landscaping ## G-025 0 0 0 0 5,000 0 0 0 0 5,000 Golf: Irrigation system upgrades G-028 0 12,000 0 0 0 0 0 0 70,000 0 Total 85,000 801,000 43,500 49,000 15,000 65,000 154,000 129,500 127,000 59,000 ## Other Uses Inflation 10% 0 0 0 0 0 0 0 0 0 5,900 Inflation 9% 0 0 0 0 0 0 0 0 11,430 0 Inflation 8% 0 0 0 0 0 0 0 10,360 0 0 Inflation 7% 0 0 0 0 0 0 10,780 0 0 0 Inflation 6% 0 0 0 0 0 3,900 0 0 0 0 Inflation 5% 0 0 0 0 750 0 0 0 0 0 Inflation 4% 0 0 0 1,960 0 0 0 0 0 0 Inflation 3% 0 0 1,305 0 0 0 0 0 0 0 Inflation 2% 0 16,020 0 0 0 0 0 0 0 0 Total 0 16,020 1,305 1,960 750 3,900 10,780 10,360 11,430 5,900 Total Expenditures and Uses 85,000 817,020 44,805 50,960 15,750 68,900 164,780 139,860 138,430 64,900 Change in Fund Balance 0 0 0 0 0 0 0 0 0 0 ## Ending Balance 0 0 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 38 / 41 Page 156 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## 640 Storm Sewer Capital Fund Beginning Balance 0 0 0 0 0 0 0 0 0 0 ## Revenues and Other Fund Sources ## Revenue Fees 2,389,000 2,501,040 2,205,230 2,198,560 2,669,100 2,497,890 2,235,230 2,843,100 2,631,260 3,502,400 Total 2,389,000 2,501,040 2,205,230 2,198,560 2,669,100 2,497,890 2,235,230 2,843,100 2,631,260 3,502,400 ## Other Fund Sources Total Revenues and Other Fund Sources 2,389,000 2,501,040 2,205,230 2,198,560 2,669,100 2,497,890 2,235,230 2,843,100 2,631,260 3,502,400 Total Funds available 2,389,000 2,501,040 2,205,230 2,198,560 2,669,100 2,497,890 2,235,230 2,843,100 2,631,260 3,502,400 ## Expenditures and Uses ## Capital Projects & Equipment ## Public Works Vehicle and Equipment ## Kubota M110GXDTC Tractor (2015) #116 ## PW-020 0 0 60,000 0 0 0 0 0 0 0 ## Trafifix Scorpion Attenuator (2017) #137 ## PW-025 0 0 0 0 0 7,500 0 0 0 0 Bobcat T76 (2024) #131 PW-036 0 0 0 0 25,000 0 0 0 0 0 Generac light tower Magnum ## MLT4060KV (2013) #210 ## PW-037 0 0 0 0 0 0 0 2,500 0 0 ## Genie GS2646 Man Lift (2007) #90225 ## PW-038 0 0 0 0 0 0 0 2,500 0 0 Nissan PL40 Forklift (2006) #90125 PW-039 0 0 0 0 0 0 0 2,500 0 0 Total 0 0 60,000 0 25,000 7,500 0 7,500 0 0 ## Sanitary #xx GPS Unit SAN-016 0 0 4,000 0 0 0 0 0 0 0 Asset Management System SAN-022 50,000 0 0 0 0 0 0 0 0 0 Replace/Upgrade SCADAsystem SAN-023 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 Rubber Tire Backhoe SAN-039 0 65,000 0 0 0 0 0 0 0 0 ## Caterpillar M315D Wheeled Back Hoe (2008) #211 ## SAN-047 0 133,000 0 0 0 0 0 0 0 0 Total 54,000 202,000 8,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 ## Storm ## Toro Goundmaster Polor Trac ## 7210-D(2021) #110 ## STM-001 0 0 0 0 45,000 0 0 0 0 0 ## Tiger 9119404J Flail Mower (2015) ## #116F ## STM-003 0 0 0 25,000 0 0 0 0 0 0 ## Bay Lynx Machinability SW35 10'/15' (2015) #116PPlow a ## STM-004 40,000 0 0 0 0 0 0 0 0 0 Bobcat S650 (2019) #126 STM-005 0 87,000 0 0 0 0 0 85,000 0 0 ## Produced Using Plan-It CIP SoftwarePage 39 / 41 Page 157 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## Amazing Machine AM960-03 Pressure Washer (2019) #130 ## STM-006 0 0 25,000 0 0 0 0 0 0 0 ## Toro GrandStand 74519 Mower (2018) #140 ## STM-008 0 11,000 0 0 0 0 0 11,000 0 0 ## Toro GrandStand 74519 Mower (2018) #160 ## STM-009 0 0 11,000 0 0 0 0 0 0 0 ## Ver-Mac PCMS -320 Sign Board (2020) #163 ## STM-010 0 0 0 0 0 0 0 0 0 20,000 Bobcat UV34 (2025) #10125 STM-011 0 0 0 0 0 0 0 0 25,000 0 ## Towmaster T-14DT Trailer (2019) #165 ## STM-012 0 0 0 0 15,000 0 0 0 0 0 ## Wild Cat LS177A Compost Turner (1997) #168 ## STM-013 450,000 0 0 0 0 0 0 0 0 0 ## Tennant M-S30 Sweeper (2020) #171 ## STM-014 0 0 0 0 0 0 0 0 50,000 0 ## PJ Trailer U1 182 Mow Trailer (2018) #176 ## STM-015 0 10,000 0 0 0 0 0 0 0 0 ## Rotobec PC018B Grapple 360 Mini Excavator (2014) #225 A13 ## STM-019 0 0 7,000 0 0 0 0 0 0 0 Lift Station - Arona Upgrades STM-029 0 0 0 0 0 0 0 0 0 250,000 Lift Station - Generator for St Croix STM-031 0 0 0 0 0 0 0 0 0 180,000 Lift Station - Millwood Upgrades STM-033 0 250,000 0 0 0 0 0 0 0 0 Lift Station Condition Analysis STM-037 0 0 0 0 0 0 0 0 0 25,000 Plan - Update stormwater mgmt plan ## STM-039 60,000 0 0 0 0 0 0 0 0 0 Projects - Bubbler System STM-040 0 0 0 0 0 10,000 0 0 0 0 Projects - Fountain - Frog Pond STM-041 0 0 0 0 10,000 0 0 0 0 0 ## Projects - Storm Infrastructure Rehabilitation (70%) STM-042 1,200,000 1,300,000 1,400,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 ## Projects - Water Quality Device Rehabilitation (30%) ## STM-043 585,000 585,000 585,000 585,000 585,000 585,000 585,000 585,000 585,000 585,000 Case 721G Loader (2019) #122 STM-048 0 0 0 0 358,000 0 0 0 0 0 Elgin Pelican P Sweeper (2017) #132 STM-049 0 0 0 0 0 250,000 0 0 0 0 ## Freightliner M2 106 Tru Vac (2020) #139 ## STM-050 0 0 0 0 0 0 0 0 0 305,000 Western Star 4700SF (2025) #145 STM-051 0 0 0 0 0 0 0 365,000 0 0 Western Star 47X (2025) #147 STM-052 0 0 0 0 0 0 0 0 0 315,000 ## Elgin Pelican NP Sweeper (2020) #167 ## STM-053 0 0 0 0 0 0 0 0 250,000 0 Ford F550 (2019) #178 STM-054 0 0 0 0 0 0 0 75,000 0 0 Total 2,335,000 2,243,000 2,028,000 2,110,000 2,513,000 2,345,000 2,085,000 2,621,000 2,410,000 3,180,000 ## Produced Using Plan-It CIP SoftwarePage 40 / 41 Page 158 of 192 Source Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 ## Water ## Caterpillar CVP75 Vibratory Plate Compactor (2015) #211 A14 ## WT-003 0 7,000 0 0 0 0 0 0 0 0 ## Caterpillar H65ES Hydraulic Breaker ## (2014) #225 A12 ## WT-005 0 0 5,000 0 0 0 0 0 0 0 Caterpillar 305E Excavator (2015) #225 ## WT-007 0 0 40,000 0 0 0 0 0 0 0 Total 0 7,000 45,000 0 0 0 0 0 0 0 ## Other Uses Inflation 2% 0 49,040 0 0 0 0 0 0 0 0 Inflation 3% 0 0 64,230 0 0 0 0 0 0 0 Inflation 4% 0 0 0 84,560 0 0 0 0 0 0 Inflation 5% 0 0 0 0 127,100 0 0 0 0 0 Inflation 6% 0 0 0 0 0 141,390 0 0 0 0 Inflation 7% 0 0 0 0 0 0 146,230 0 0 0 Inflation 8% 0 0 0 0 0 0 0 210,600 0 0 Inflation 9% 0 0 0 0 0 0 0 0 217,260 0 Inflation 10% 0 0 0 0 0 0 0 0 0 318,400 Total 0 49,040 64,230 84,560 127,100 141,390 146,230 210,600 217,260 318,400 Total Expenditures and Uses 2,389,000 2,501,040 2,205,230 2,198,560 2,669,100 2,497,890 2,235,230 2,843,100 2,631,260 3,502,400 Change in Fund Balance 0 0 0 0 0 0 0 0 0 0 ## Ending Balance 0 0 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 41 / 41 Page 159 of 192 2037 through 2046 ## Capital Improvement Plan ## Roseville, MN ## Sources and Uses of Funds Details Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 260 Community Development Vehicle ## & Equipment Fund Beginning Balance 0 0 0 0 0 0 0 0 0 0 ## Revenues and Other Fund Sources ## Revenue Fund Balance 45,000 100,000 45,000 0 0 0 0 45,000 45,000 0 Total 45,000 100,000 45,000 0 0 0 0 45,000 45,000 0 ## Other Fund Sources Total Revenues and Other Fund Sources 45,000 100,000 45,000 0 0 0 0 45,000 45,000 0 Total Funds available 45,000 100,000 45,000 0 0 0 0 45,000 45,000 0 ## Expenditures and Uses ## Capital Projects & Equipment ## Community Development Inspection vehicle - 2017 Ford ## Escape ## CD-001 45,000 0 0 0 0 0 0 0 0 0 Online Permit/Schedul. Software CD-002 0 100,000 0 0 0 0 0 0 0 0 Inspection vehicle - 2019 Ford ## Ranger ## CD-003 0 0 45,000 0 0 0 0 0 0 0 Inspection vehicle - 2023 Ford ## Lightening ## CD-004 0 0 0 0 0 0 0 45,000 0 0 Inspection vehicle - 2025 Ford ## Lightening ## CD-005 0 0 0 0 0 0 0 0 45,000 0 Total 45,000 100,000 45,000 0 0 0 0 45,000 45,000 0 ## Other Uses Total Expenditures and Uses 45,000 100,000 45,000 0 0 0 0 45,000 45,000 0 Change in Fund Balance 0 0 0 0 0 0 0 0 0 0 ## Ending Balance 0 0 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 1 / 33 Page 160 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 400 Police Vehicle & Equipment Fund Beginning Balance 279,360 336,570 390,826 413,435 416,957 255,839 335,937 243,048 284,402 354,149 ## Revenues and Other Fund Sources ## Revenue Franchise Fees 264,000 264,000 264,000 264,000 264,000 264,000 264,000 264,000 264,000 264,000 MSA, Debt, Fees 0 0 19,000 0 19,000 0 0 0 0 0 Sale of Assets 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 Tax Levy 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 750,000 Total 1,044,000 1,044,000 1,063,000 1,044,000 1,063,000 1,044,000 1,044,000 1,044,000 1,044,000 1,044,000 ## Other Fund Sources Total Revenues and Other Fund Sources 1,044,000 1,044,000 1,063,000 1,044,000 1,063,000 1,044,000 1,044,000 1,044,000 1,044,000 1,044,000 Total Funds available 1,323,360 1,380,570 1,453,826 1,457,435 1,479,957 1,299,839 1,379,937 1,287,048 1,328,402 1,398,149 ## Expenditures and Uses ## Capital Projects & Equipment ## Police Vehicle & Equipment Marked Squads (6 per year) P-001 276,000 276,000 276,000 276,000 276,000 276,000 276,000 276,000 276,000 276,000 ## Unmarked Detective Vehicles (2 per year) ## P-002 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 CSO Vehicle P-003 50,000 0 0 50,000 0 0 50,000 0 0 0 Comm Relations / Admin Vehicle P-004 0 0 50,000 0 50,000 0 0 50,000 0 0 Crime Scene Vehicle P-005 0 53,000 0 0 0 0 53,000 0 0 0 Park Patrol/Response Vehicle P-006 0 0 0 0 0 0 0 0 32,000 0 ## Squad/Vehicle Conversion and ## Outfitting p-007 224,000 224,000 211,000 224,000 211,000 194,000 254,000 211,000 194,000 241,000 ## Stop Sticks and Tire Deflation ## Devices ## P-008 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Radar Units (2 per year) P-009 7,700 7,700 7,700 7,700 7,700 7,700 7,700 7,700 7,700 7,700 Radio Equipment (4 squad and 4 portable) ## P-010 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 Defibrillators (AEDs) P-011 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 14,000 Computers and Printers (fleet) P-012 0 0 0 0 200,000 0 0 0 0 0 Mobile Electronics P-013 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 Speed Notification Signs P-014 0 10,000 0 0 2,000 0 10,000 0 0 0 Tracking/Surveillance Technology P-015 5,500 0 0 0 0 5,500 0 0 0 0 Less Lethal Equipment P-017 26,000 26,000 26,000 26,000 26,000 26,000 26,000 26,000 26,000 26,000 Long Guns P-018 15,000 15,000 15,000 15,000 43,750 43,750 15,000 15,000 15,000 15,000 Sidearms P-019 9,000 9,000 66,000 9,000 9,000 9,000 9,000 9,000 9,000 9,000 Tactical Gear P-020 26,000 26,000 26,000 26,000 26,000 26,000 26,000 26,000 26,000 26,000 PPE and EMS Equipment P-021 10,000 10,000 4,000 4,000 4,000 4,000 10,000 10,000 4,000 4,000 ## Produced Using Plan-It CIP SoftwarePage 2 / 33 Page 161 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 Drone Equipment P-022 28,000 8,000 8,000 28,000 8,000 8,000 28,000 8,000 8,000 28,000 ## Rapid Identification Technology ## (IBIS) ## P-023 3,000 0 0 3,000 0 0 3,000 0 0 0 Crime Scene Equipment P-024 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 Fitness and Wellness Room P-025 5,000 5,000 15,000 5,000 5,000 5,000 8,000 5,000 5,000 5,000 Evidence Room (office) P-027 0 0 20,000 0 0 20,000 0 0 20,000 20,000 ## Conference Rooms Audio/Video ## Technology ## P-028 0 10,000 0 10,000 0 10,000 0 10,000 0 0 Roll Call Equipment P-029 0 8,000 0 0 0 0 0 0 0 0 Investigation Briefing Room P-030 0 0 0 10,000 0 0 0 0 0 0 Shredder P-031 7,800 0 0 0 0 0 0 0 0 0 Office Furniture (office) P-033 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 Patrol Area Cubicles P-034 0 0 0 18,000 0 0 0 0 0 0 Appliances (office) P-035 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 3,500 Detention Room P-036 0 0 0 5,000 0 0 0 0 0 0 Total 889,000 883,700 920,700 912,700 1,064,450 830,950 971,700 849,700 818,700 853,700 ## Other Uses Inflation 20% 0 0 0 0 0 0 0 0 0 170,740 Inflation 19% 0 0 0 0 0 0 0 0 155,553 0 Inflation 18% 0 0 0 0 0 0 0 152,946 0 0 Inflation 17% 0 0 0 0 0 0 165,189 0 0 0 Inflation 16% 0 0 0 0 0 132,952 0 0 0 0 Inflation 15% 0 0 0 0 159,668 0 0 0 0 0 Inflation 14% 0 0 0 127,778 0 0 0 0 0 0 Inflation 13% 0 0 119,691 0 0 0 0 0 0 0 Inflation 12% 0 106,044 0 0 0 0 0 0 0 0 Inflation 11% 97,790 0 0 0 0 0 0 0 0 0 Total 97,790 106,044 119,691 127,778 159,668 132,952 165,189 152,946 155,553 170,740 Total Expenditures and Uses 986,790 989,744 1,040,391 1,040,478 1,224,118 963,902 1,136,889 1,002,646 974,253 1,024,440 Change in Fund Balance 57,210 54,256 22,609 3,522 -161,118 80,098 -92,889 41,354 69,747 19,560 ## Ending Balance 336,570 390,826 413,435 416,957 255,839 335,937 243,048 284,402 354,149 373,709 ## Produced Using Plan-It CIP SoftwarePage 3 / 33 Page 162 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 401 Fire Vehicle & Equipment Fund Beginning Balance 1,467,553 951,354 1,161,206 1,176,861 253,104 615,517 402,186 493,342 841,117 791,259 ## Revenues and Other Fund Sources ## Revenue Investment Income 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Tax Levy 673,511 700,452 728,470 757,608 787,913 819,429 852,206 886,295 921,747 958,616 Total 678,511 705,452 733,470 762,608 792,913 824,429 857,206 891,295 926,747 963,616 ## Other Fund Sources Bond Proceeds 0 0 0 0 0 0 0 0 2,000,000 0 Total 0 0 0 0 0 0 0 0 2,000,000 0 Total Revenues and Other Fund Sources 678,511 705,452 733,470 762,608 792,913 824,429 857,206 891,295 2,926,747 963,616 Total Funds available 2,146,064 1,656,806 1,894,676 1,939,469 1,046,017 1,439,946 1,259,392 1,384,637 3,767,864 1,754,875 ## Expenditures and Uses ## Capital Projects & Equipment ## Fire Vehicle & Equipment ## Apparatus: Medical First Response Vehicle #3 ## F-004 340,000 0 0 0 0 0 0 0 0 0 ## Apparatus: Medical First Response Vehicle #1 ## F-005 0 0 0 0 0 340,000 0 0 0 0 ## Apparatus: Medical First Response Vehicle #2 ## F-006 0 0 0 0 0 0 340,000 0 0 0 ## Apparatus: Command Response ## Vehicle ## F-009 0 95,000 0 95,000 0 95,000 0 95,000 0 0 Physical Fitness Training Equipment F-011 0 0 0 7,500 0 0 0 0 18,000 0 Records Management System (RMS) F-012 0 0 0 0 50,000 0 0 0 0 0 ## Self Contained Breathing Apparatus ## (SCBA) ## F-013 0 0 0 495,250 0 0 0 0 0 0 Smoke Ventilation Fans F-014 0 0 0 8,000 0 0 0 0 0 0 Power Equipment F-015 12,000 0 0 0 0 12,000 0 0 0 0 Personal Protective Equipment F-016 0 0 0 350,000 0 0 0 0 0 0 EMS Equipment F-017 0 0 250,000 0 0 0 0 0 250,000 0 Medical Equipment - Durable Goods F-018 8,000 0 0 0 0 8,000 0 0 0 0 Training Equipment F-019 0 0 0 15,000 0 0 0 0 0 0 ## Portable/Mobile Communication ## Radios ## F-021 370,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 ## Emergency Mgmt Preparedness - ## EOC ## F-022 0 0 0 45,000 0 0 0 0 45,000 0 Firefighting Equipment F-023 5,000 0 0 0 0 0 0 0 0 0 Water Emergency Equipment F-024 6,000 0 0 0 0 6,000 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 4 / 33 Page 163 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 Apparatus Based IT Infrastructure F-025 10,000 0 35,000 0 10,000 0 35,000 0 10,000 0 ## Emergency Response - Air ## Monitoring Equipment ## F-026 0 5,000 0 6,500 0 5,000 0 0 6,500 0 Rescue-Extrication Equipment F-027 0 0 0 40,000 0 0 0 0 40,000 0 Nozzles & Fire hose F-028 0 20,000 0 0 0 0 20,000 0 0 0 Therapy K9 F-029 0 0 0 0 0 0 0 15,000 0 0 Fire Administration - Furniture F-030 0 0 0 0 0 0 0 20,000 0 0 Training Room Furniture F-031 0 0 0 15,000 0 0 0 0 0 0 Kitchen appliances F-033 0 0 10,000 0 0 0 0 10,000 0 0 Kitchen Furniture F-034 10,000 0 0 0 0 0 0 0 0 0 Day Room Chairs F-035 0 0 0 0 0 15,000 0 0 0 0 ## Audio Visual Equipment - ## Stationwide ## F-036 0 0 6,500 0 0 0 0 0 0 0 Washer & Dryer - Second Floor F-037 0 0 14,000 0 0 0 0 0 0 0 Bed Mattresses F-038 0 0 0 0 0 0 0 14,000 0 0 Dorm Structures F-039 0 0 0 0 0 55,000 0 0 0 0 Apparatus: Fire Engine - Pumper F-040 0 0 0 0 0 0 0 0 2,000,000 0 Apparatus: Utility Apparatus F-041 0 0 0 85,000 0 0 0 0 0 0 Total 761,000 130,000 325,500 1,172,250 70,000 546,000 405,000 164,000 2,379,500 10,000 ## Other Uses Debt Service 350,000 350,000 350,000 350,000 350,000 350,000 350,000 350,000 525,000 525,000 Inflation 11% 83,710 0 0 0 0 0 0 0 0 0 Inflation 12% 0 15,600 0 0 0 0 0 0 0 0 Inflation 13% 0 0 42,315 0 0 0 0 0 0 0 Inflation 14% 0 0 0 164,115 0 0 0 0 0 0 Inflation 15% 0 0 0 0 10,500 0 0 0 0 0 Inflation 16% 0 0 0 0 0 141,760 0 0 0 0 Inflation 17% 0 0 0 0 0 0 11,050 0 0 0 Inflation 18% 0 0 0 0 0 0 0 29,520 0 0 Inflation 19% 0 0 0 0 0 0 0 0 72,105 0 Inflation 20% 0 0 0 0 0 0 0 0 0 2,000 Total 433,710 365,600 392,315 514,115 360,500 491,760 361,050 379,520 597,105 527,000 Total Expenditures and Uses 1,194,710 495,600 717,815 1,686,365 430,500 1,037,760 766,050 543,520 2,976,605 537,000 Change in Fund Balance -516,199 209,852 15,655 -923,757 362,413 -213,331 91,156 347,775 -49,858 426,616 ## Ending Balance 951,354 1,161,206 1,176,861 253,104 615,517 402,186 493,342 841,117 791,259 1,217,875 ## Produced Using Plan-It CIP SoftwarePage 5 / 33 Page 164 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 402 Parks & Recreation Vehicle & ## Equipment Fund Beginning Balance 94,015 276,909 -106,287 122,542 209,406 234,060 555,064 538,758 611,262 603,966 ## Revenues and Other Fund Sources ## Revenue Investment Income 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 Tax Levy 360,604 360,604 360,604 360,604 360,604 360,604 360,604 360,604 360,604 360,604 Total 361,604 361,604 361,604 361,604 361,604 361,604 361,604 361,604 361,604 361,604 ## Other Fund Sources Total Revenues and Other Fund Sources 361,604 361,604 361,604 361,604 361,604 361,604 361,604 361,604 361,604 361,604 Total Funds available 455,619 638,513 255,317 484,146 571,010 595,664 916,668 900,362 972,866 965,570 ## Expenditures and Uses ## Capital Projects & Equipment ## Parks & Recreation Vehicles & Equipment Puppet Wagon PR-001 0 20,000 0 0 0 0 0 0 0 0 Ford F350 with Plow (2016) #530 PR-002 0 0 0 70,000 0 0 0 0 0 0 Ford 3/4-ton (2012) #506 PR-003 0 0 0 0 0 0 0 50,000 0 0 Ford F350 Dump (2016) #528 PR-005 0 0 0 0 70,000 0 0 0 0 0 Water truck (1/2 cost) (2019) #510 PR-006 0 0 0 0 0 0 75,000 0 0 0 Bobcat Toolcat (2006) #511 PR-007 0 55,000 0 0 0 0 0 0 0 0 GMC Savana (2012) #517 PR-009 0 70,000 0 0 0 0 0 0 0 0 Ford 350 w. plow (2014) #515 PR-010 0 70,000 0 0 0 0 0 0 0 0 Ford with plow (2014) #516 PR-011 0 70,000 0 0 0 0 0 0 0 0 Zero Turn Replace (Arb.) (1999) PR-012 0 0 9,500 0 0 0 0 0 0 0 Ford F350 (2016) #532 PR-013 0 0 0 50,000 0 0 0 0 0 0 Ford Passenger van (2006) #535 PR-015 0 0 0 0 0 0 0 0 55,000 55,000 Ford Passenger van (2006) #560 PR-017 0 0 0 0 0 0 0 0 55,000 55,000 ## Skating Center/Golf Plow Truck (2012) ## PR-019 0 0 0 15,000 0 0 0 0 0 0 ## John Deere 3046R Tractor (2022) #504 ## PR-023 0 0 0 0 0 35,000 0 0 0 0 Toro 4000 Mower (2023) #509 PR-024 0 0 0 0 0 0 80,000 0 0 0 Toro 4000 Mower (2013) #513 PR-025 0 0 0 0 0 0 80,000 0 0 0 John Deere loader (2018) #553 PR-027 0 80,000 0 0 0 0 0 0 0 0 Toro 16' mower (2023) #536 PR-028 0 0 0 0 0 0 0 0 200,000 200,000 portable generator #538 PR-029 0 3,000 0 0 0 0 0 0 0 0 Towmaster trailer (2021) #543 PR-030 0 9,000 0 0 0 0 0 0 0 0 Holder C70SC snow machine (2022) #505 ## PR-035 0 0 0 0 0 0 0 195,000 0 0 ## Produced Using Plan-It CIP SoftwarePage 6 / 33 Page 165 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 Holder Snow machine (2015) #518 PR-036 0 0 0 0 195,000 0 0 0 0 0 ## MT Trackless snow/sidewalk machine (2020) #585 ## PR-037 0 195,000 0 0 0 0 0 0 0 0 Pickup sander (2013) PR-039 0 0 0 8,000 0 0 0 0 0 0 GOLF TRANSFER TO Golf fund equip PR-040 78,000 38,000 54,000 44,000 14,000 0 44,000 0 0 0 ## Vermeer BC1500 Chipper (2017) #52317 ## PR-041 83,000 0 0 0 0 0 0 0 0 0 Total 161,000 610,000 63,500 187,000 279,000 35,000 279,000 245,000 310,000 310,000 ## Storm Brush Mower Attachment STM-027 0 22,000 0 0 0 0 0 0 0 0 Total 0 22,000 0 0 0 0 0 0 0 0 ## Other Uses Inflation 11% 17,710 0 0 0 0 0 0 0 0 0 Inflation 12% 0 75,840 0 0 0 0 0 0 0 0 Inflation 13% 0 0 8,255 0 0 0 0 0 0 0 Inflation 14% 0 0 0 26,180 0 0 0 0 0 0 Inflation 15% 0 0 0 0 41,850 0 0 0 0 0 Inflation 16% 0 0 0 0 0 5,600 0 0 0 0 Inflation 17% 0 0 0 0 0 0 47,430 0 0 0 Inflation 18% 0 0 0 0 0 0 0 44,100 0 0 Inflation 19% 0 0 0 0 0 0 0 0 58,900 0 Inflation 20% 0 0 0 0 0 0 0 0 0 62,000 Transfers Out to Fund 620 Golf 0 36,960 61,020 61,560 16,100 0 51,480 0 0 0 Total 17,710 112,800 69,275 87,740 57,950 5,600 98,910 44,100 58,900 62,000 Total Expenditures and Uses 178,710 744,800 132,775 274,740 336,950 40,600 377,910 289,100 368,900 372,000 Change in Fund Balance 182,894 -383,196 228,829 86,864 24,654 321,004 -16,306 72,504 -7,296 -10,396 ## Ending Balance 276,909 -106,287 122,542 209,406 234,060 555,064 538,758 611,262 603,966 593,570 ## Produced Using Plan-It CIP SoftwarePage 7 / 33 Page 166 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 403 Public Works Vehicle & Equipment ## Fund Beginning Balance 493,154 -42,912 283,222 458,508 -89,286 78,500 408,386 432,872 778,648 843,134 ## Revenues and Other Fund Sources ## Revenue Franchise Fees 285,000 285,000 285,000 285,000 285,000 285,000 285,000 285,000 285,000 285,000 Investment Income 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 Tax Levy 162,889 171,034 179,586 179,586 179,586 179,586 179,586 179,586 179,586 179,586 Total 452,389 460,534 469,086 469,086 469,086 469,086 469,086 469,086 469,086 469,086 ## Other Fund Sources Total Revenues and Other Fund Sources 452,389 460,534 469,086 469,086 469,086 469,086 469,086 469,086 469,086 469,086 Total Funds available 945,543 417,622 752,308 927,594 379,800 547,586 877,472 901,958 1,247,734 1,312,220 ## Expenditures and Uses ## Capital Projects & Equipment ## Public Works Vehicle and Equipment ## Graphtec/SignMate Sign Equipment (Sign Shop) (2012) #100 ## PW-001 0 0 0 0 30,000 0 0 0 0 0 Bobcat 2.5" Slot Mill (2012) #111 ## A09 ## PW-006 20,000 0 0 0 0 0 0 0 0 0 ## Kage SB96 Snow Pusher (2013) #111 ## A10 ## PW-007 10,000 0 0 0 0 0 0 0 0 0 ## Bobcat 68" Angle Broom (2014) ## #111 A11 ## PW-008 0 10,000 0 0 0 0 0 0 0 0 ## Virnig VBW-72-HF33 Snow Blower ## (2017) #111 A15 ## PW-009 14,000 0 0 0 0 0 0 0 0 0 Bobcat 72" Sweeper (2018) #111 ## A16 ## PW-010 0 0 0 0 0 10,000 0 0 0 0 Bobcat 24PLA Millhead (2018) #111 ## A17 ## PW-011 0 20,000 0 0 0 0 0 0 0 0 ## Virnig TRPB90C Tree Puller (2018) ## #111 A18 ## PW-012 0 10,000 0 0 0 0 0 0 0 0 ## Bobcat HB980 Pallet Fork (2019) ## #111 A19 ## PW-013 0 0 10,000 0 0 0 0 0 0 0 Rapid Router (2021) #111 A20 PW-014 0 0 0 0 0 15,000 0 0 0 0 ## Virnig Pickup Broom (2022) #111 ## A21 ## PW-015 0 0 0 0 0 10,000 0 0 0 0 Virnig Snowblower (2024) #111 A23 PW-017 0 0 0 0 0 0 0 12,000 0 0 Bobcat S76 (2020) #111 PW-018 0 0 0 0 87,000 0 0 0 0 0 ## Kubota M110GXDTC Tractor (2015) #116 ## PW-020 0 0 60,000 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 8 / 33 Page 167 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## Towmaster T-20D Trailer (2024) #117 ## PW-021 0 0 0 0 0 0 0 25,000 0 0 ## Sullair 260 CFM Air Compressor (2011) #129 ## PW-023 0 0 0 0 40,000 0 0 0 0 0 ## Husqvarna Walk Behind Saw (2022) #133 ## PW-024 0 0 0 0 0 0 10,000 0 0 0 ## Trafifix Scorpion Attenuator (2017) #137 ## PW-025 7,500 0 0 0 0 0 0 0 0 0 Wacker RD-12 Roller (2013) #141 PW-026 0 0 25,000 0 0 0 0 0 0 0 ## Towmaster T-16DT Trailer (2017) #153 ## PW-027 20,000 0 0 0 0 0 0 0 0 0 Cimline 150DH Melter (2017) #166 PW-029 0 0 0 0 60,000 0 0 0 0 0 ## Towmaster T-9DT Trailer (2019) #172 ## PW-030 0 0 10,000 0 0 0 0 0 0 0 ## VariTech SB-600 Brine Maker (2020) #179 ## PW-032 0 20,000 0 0 0 0 0 0 0 0 Brine Tank 4000 Gallons #181 PW-034 0 25,000 0 0 0 0 0 0 0 0 Bobcat T76 (2024) #131 PW-036 0 25,000 0 0 0 0 0 0 25,000 0 Generac light tower Magnum ## MLT4060KV (2013) #210 ## PW-037 0 0 0 0 0 0 0 2,500 0 0 ## Genie GS2646 Man Lift (2007) #90225 ## PW-038 0 0 0 0 0 0 0 2,500 0 0 Nissan PL40 Forklift (2006) #90125 PW-039 0 0 0 0 0 0 0 2,500 0 0 Eng. GPS System PW-040 40,000 0 0 0 0 0 0 0 0 0 Eng. Large format scanner/copier- bought in 25 instead of 26 ## PW-041 0 0 0 12,000 0 0 0 0 0 0 Eng. Total Station PW-042 0 0 0 30,000 0 0 0 0 0 0 Eng. Utility Locator - Metrotech PW-043 0 0 0 0 0 0 10,000 0 0 0 Garage: Band saw PW-046 0 0 0 0 0 10,000 0 0 0 0 Garage: Brake lathe PW-047 0 0 0 0 0 25,000 0 0 0 0 Garage: Column Lifts rehab/replace PW-048 0 0 0 75,000 0 0 0 0 0 0 Garage: Drill Press PW-049 0 10,000 0 0 0 0 0 0 0 0 Garage: Drive-on hoist rehab PW-050 10,000 0 0 0 0 0 0 0 0 0 Garage: Hydraulic Press PW-051 10,000 0 0 0 0 0 0 0 0 0 Garage: Tire Balancer PW-055 0 0 20,000 0 0 0 0 0 0 0 Garage: Tire changer PW-056 0 0 20,000 0 0 0 0 0 0 0 Eng. Office furniture PW-057 0 0 10,000 0 0 0 0 0 0 0 Maintenance: Office furniture PW-058 0 0 10,000 0 0 0 0 0 0 0 Western Star 4700SF (2023) #106 PW-063 0 0 0 0 0 0 0 0 0 315,000 Case 621F Loader (2016) #107 PW-064 0 0 0 400,000 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 9 / 33 Page 168 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 International HV507 (2020) #109 PW-065 0 0 0 0 0 0 315,000 0 0 0 Western Star 4700SF (2020) #112 PW-066 0 0 0 0 0 0 0 0 315,000 0 Ford F250 (2020) #118 PW-067 0 0 0 0 0 0 0 60,000 0 0 ## Western Star 4700SF Tandem (2018) #125 ## PW-069 365,000 0 0 0 0 0 0 0 0 0 Ford F250 (2016) #128 PW-070 0 0 0 60,000 0 0 0 0 0 0 International 7400 SFA (2013) #144 PW-072 311,000 0 0 0 0 0 0 0 0 0 International 7400 SFA (2016) #155 PW-075 0 0 0 315,000 0 0 0 0 0 0 Chevrolet Equinox (2015) #301 PW-077 0 0 45,000 0 0 0 0 0 0 0 Chevrolet Equinox (2017) #302 PW-078 0 0 0 0 45,000 0 0 0 0 0 GMC Sierra (2018) #303 PW-079 0 0 0 0 0 50,000 0 0 0 0 Ford F150 (2015) #305 PW-080 0 0 50,000 0 0 0 0 0 0 0 ## Mitsubishi Outlander Hybrid (2019) #310 ## PW-081 0 0 0 0 0 0 45,000 0 0 0 Vermeer BC1800XL (2026) #11326 PW-082 83,000 0 0 0 0 0 0 0 0 0 Total 890,500 120,000 260,000 892,000 262,000 120,000 380,000 104,500 340,000 315,000 ## Other Uses Inflation 11% 97,955 0 0 0 0 0 0 0 0 0 Inflation 12% 0 14,400 0 0 0 0 0 0 0 0 Inflation 13% 0 0 33,800 0 0 0 0 0 0 0 Inflation 14% 0 0 0 124,880 0 0 0 0 0 0 Inflation 15% 0 0 0 0 39,300 0 0 0 0 0 Inflation 16% 0 0 0 0 0 19,200 0 0 0 0 Inflation 17% 0 0 0 0 0 0 64,600 0 0 0 Inflation 18% 0 0 0 0 0 0 0 18,810 0 0 Inflation 19% 0 0 0 0 0 0 0 0 64,600 0 Inflation 20% 0 0 0 0 0 0 0 0 0 63,000 Total 97,955 14,400 33,800 124,880 39,300 19,200 64,600 18,810 64,600 63,000 Total Expenditures and Uses 988,455 134,400 293,800 1,016,880 301,300 139,200 444,600 123,310 404,600 378,000 Change in Fund Balance -536,066 326,134 175,286 -547,794 167,786 329,886 24,486 345,776 64,486 91,086 ## Ending Balance -42,912 283,222 458,508 -89,286 78,500 408,386 432,872 778,648 843,134 934,220 ## Produced Using Plan-It CIP SoftwarePage 10 / 33 Page 169 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 404 Finance Equipment Fund Beginning Balance 255,020 289,424 331,069 376,613 -33,843 6,526 46,386 90,935 136,479 182,023 ## Revenues and Other Fund Sources ## Revenue Investment Income 500 500 500 500 500 500 500 500 500 500 Tax Levy 39,343 42,097 45,044 45,044 45,044 45,044 45,044 45,044 45,044 45,044 Total 39,843 42,597 45,544 45,544 45,544 45,544 45,544 45,544 45,544 45,544 ## Other Fund Sources Total Revenues and Other Fund Sources 39,843 42,597 45,544 45,544 45,544 45,544 45,544 45,544 45,544 45,544 Total Funds available 294,863 332,021 376,613 422,157 11,701 52,070 91,930 136,479 182,023 227,567 ## Expenditures and Uses ## Capital Projects & Equipment ## Finance Financial Software: Upgrade F-001 0 0 0 400,000 0 0 0 0 0 0 Computer replacements F-003 4,900 850 0 0 4,500 4,900 850 0 0 4,500 Total 4,900 850 0 400,000 4,500 4,900 850 0 0 4,500 ## Other Uses Inflation 11% 539 0 0 0 0 0 0 0 0 0 Inflation 12% 0 102 0 0 0 0 0 0 0 0 Inflation 14% 0 0 0 56,000 0 0 0 0 0 0 Inflation 15% 0 0 0 0 675 0 0 0 0 0 Inflation 16% 0 0 0 0 0 784 0 0 0 0 Inflation 17% 0 0 0 0 0 0 145 0 0 0 Inflation 20% 0 0 0 0 0 0 0 0 0 900 Total 539 102 0 56,000 675 784 145 0 0 900 Total Expenditures and Uses 5,439 952 0 456,000 5,175 5,684 995 0 0 5,400 Change in Fund Balance 34,404 41,645 45,544 -410,456 40,369 39,860 44,549 45,544 45,544 40,144 ## Ending Balance 289,424 331,069 376,613 -33,843 6,526 46,386 90,935 136,479 182,023 222,167 ## Produced Using Plan-It CIP SoftwarePage 11 / 33 Page 170 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 405 Administration Equipment Fund Beginning Balance 20,661 864 -1,751 -3,811 -5,290 -6,163 -6,404 -3,060 997 5,796 ## Revenues and Other Fund Sources ## Revenue Investment Income 500 500 500 500 500 500 500 500 500 500 Tax Levy 26,878 27,685 28,515 29,371 30,252 31,159 32,094 33,057 34,049 35,070 Total 27,378 28,185 29,015 29,871 30,752 31,659 32,594 33,557 34,549 35,570 ## Other Fund Sources Total Revenues and Other Fund Sources 27,378 28,185 29,015 29,871 30,752 31,659 32,594 33,557 34,549 35,570 Total Funds available 48,039 29,049 27,264 26,060 25,462 25,496 26,190 30,497 35,546 41,366 ## Expenditures and Uses ## Capital Projects & Equipment ## Administration Voting Equipment ADM-001 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 Data Practices Software ADM-002 15,000 0 0 0 0 0 0 0 0 0 Furniture Replacement ADM-003 2,500 2,500 2,500 2,500 2,500 2,500 0 0 0 0 Total 42,500 27,500 27,500 27,500 27,500 27,500 25,000 25,000 25,000 25,000 ## Other Uses Inflation 11% 4,675 0 0 0 0 0 0 0 0 0 Inflation 12% 0 3,300 0 0 0 0 0 0 0 0 Inflation 13% 0 0 3,575 0 0 0 0 0 0 0 Inflation 14% 0 0 0 3,850 0 0 0 0 0 0 Inflation 15% 0 0 0 0 4,125 0 0 0 0 0 Inflation 16% 0 0 0 0 0 4,400 0 0 0 0 Inflation 17% 0 0 0 0 0 0 4,250 0 0 0 Inflation 18% 0 0 0 0 0 0 0 4,500 0 0 Inflation 19% 0 0 0 0 0 0 0 0 4,750 0 Inflation 20% 0 0 0 0 0 0 0 0 0 5,000 Total 4,675 3,300 3,575 3,850 4,125 4,400 4,250 4,500 4,750 5,000 Total Expenditures and Uses 47,175 30,800 31,075 31,350 31,625 31,900 29,250 29,500 29,750 30,000 Change in Fund Balance -19,797 -2,615 -2,060 -1,479 -873 -241 3,344 4,057 4,799 5,570 ## Ending Balance 864 -1,751 -3,811 -5,290 -6,163 -6,404 -3,060 997 5,796 11,366 ## Produced Using Plan-It CIP SoftwarePage 12 / 33 Page 171 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 406 Street Light Maintenance Fund Beginning Balance 343,594 447,394 531,394 561,344 510,644 579,144 629,744 755,744 881,744 847,094 ## Revenues and Other Fund Sources ## Revenue Franchise Fees 96,000 96,000 96,000 96,000 96,000 96,000 96,000 96,000 96,000 96,000 Investment Income 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Tax Levy 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 Total 126,000 126,000 126,000 126,000 126,000 126,000 126,000 126,000 126,000 126,000 ## Other Fund Sources Total Revenues and Other Fund Sources 126,000 126,000 126,000 126,000 126,000 126,000 126,000 126,000 126,000 126,000 Total Funds available 469,594 573,394 657,394 687,344 636,644 705,144 755,744 881,744 1,007,744 973,094 ## Expenditures and Uses ## Capital Projects & Equipment ## Street Lights 227447 - Josephine Woods SL-027 20,000 0 0 0 0 0 0 0 0 0 Ped. RRFB @ Dale St & Nature Ctr SL-028 0 25,000 0 0 0 0 0 0 0 0 Ped. RRFB @ Hamline & Garden SL-030 0 12,500 0 0 0 0 0 0 0 0 227445 - Perimeter Drive SL-031 0 0 25,000 0 0 0 0 0 0 0 227445 - Rice St SL-032 0 0 10,000 0 0 0 0 0 0 0 Ped. RRFB @ Lydia & Lincoln - EAST SL-033 0 0 25,000 0 0 0 0 0 0 0 Ped. RRFB @ Lydia & Lincoln - WEST SL-034 0 0 25,000 0 0 0 0 0 0 0 Lighting System - Twin Lake Ph 3 SL-035 0 0 0 155,000 0 0 0 0 0 0 Ped. RRFB @ Hamline & Belmont SL-036 0 0 0 0 25,000 0 0 0 0 0 ## Ped. RRFB @ Victoria St & Central ## Park ## SL-037 0 0 0 0 25,000 0 0 0 0 0 227447 - Wheaton Woods SL-038 0 0 0 0 0 15,000 0 0 0 0 ## Ped. RRFB @ Lexington Ave & ## Central Park ## SL-039 0 0 0 0 0 25,000 0 0 0 0 ## Ped. RRFB @ Lexington Ave & ## Josephine Park ## SL-040 0 0 0 0 0 25,000 0 0 0 0 ## Lighting System - Terrace Dr/Twin ## Lakes Trail #1 ## SL-041 0 0 0 0 0 0 0 0 135,000 0 Total 20,000 37,500 85,000 155,000 50,000 65,000 0 0 135,000 0 ## Other Uses Inflation 11% 2,200 0 0 0 0 0 0 0 0 0 Inflation 12% 0 4,500 0 0 0 0 0 0 0 0 Inflation 13% 0 0 11,050 0 0 0 0 0 0 0 Inflation 14% 0 0 0 21,700 0 0 0 0 0 0 Inflation 15% 0 0 0 0 7,500 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 13 / 33 Page 172 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 Inflation 16% 0 0 0 0 0 10,400 0 0 0 0 Inflation 19% 0 0 0 0 0 0 0 0 25,650 0 Total 2,200 4,500 11,050 21,700 7,500 10,400 0 0 25,650 0 Total Expenditures and Uses 22,200 42,000 96,050 176,700 57,500 75,400 0 0 160,650 0 Change in Fund Balance 103,800 84,000 29,950 -50,700 68,500 50,600 126,000 126,000 -34,650 126,000 ## Ending Balance 447,394 531,394 561,344 510,644 579,144 629,744 755,744 881,744 847,094 973,094 ## Produced Using Plan-It CIP SoftwarePage 14 / 33 Page 173 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 408 Pathway & Parking Lot ## Maintenance Fund Beginning Balance 167,078 234,373 198,349 137,926 185,698 236,522 287,167 381,467 429,084 611,529 ## Revenues and Other Fund Sources ## Revenue Franchise Fees 365,000 365,000 365,000 365,000 365,000 365,000 365,000 365,000 365,000 365,000 Investment Income 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Tax Levy 80,911 93,048 107,005 123,056 141,514 162,741 187,152 215,225 247,509 284,635 Total 450,911 463,048 477,005 493,056 511,514 532,741 557,152 585,225 617,509 654,635 ## Other Fund Sources Total Revenues and Other Fund Sources 450,911 463,048 477,005 493,056 511,514 532,741 557,152 585,225 617,509 654,635 Total Funds available 617,989 697,421 675,354 630,982 697,212 769,263 844,319 966,692 1,046,593 1,266,164 ## Expenditures and Uses ## Capital Projects & Equipment ## Pathway & Parking Pathway maintenance PP-001 250,000 250,000 270,000 270,000 270,000 270,000 270,000 270,000 270,000 270,000 Pathway construction - NEW PP-002 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 BNSF Railway lease payment PP-003 16,300 16,300 16,300 16,300 16,300 16,300 16,300 16,300 16,300 16,300 ## PARKLOT-006 Cedarholm Golf ## Course Parking Lot (2019) ## PP-008 0 100,000 0 0 0 0 0 0 0 0 ## PARKLOT-007 Central Park Dale East ## (Nature Center) Parking Lot (2022) ## PP-009 0 0 0 0 0 30,000 0 0 0 0 ## PARKLOT-009 Central Park Dale ## West (Arboretum) South Parking Lot (2022) ## PP-011 0 0 0 0 0 20,000 0 0 0 0 ## PARKLOT-016 Howard Johnson Park ## Parking Lot (2024) ## PP-017 0 0 0 0 0 0 0 20,000 0 0 ## PARKLOT-017 Langton Lake Park ## East Parking Lot (2021) ## PP-018 0 0 0 0 10,000 0 0 0 0 0 ## PARKLOT-018 Langton Lake Park West (S lot off C2) Parking Lot (2021) ## PP-019 0 0 0 0 25,000 0 0 0 0 0 ## PARKLOT-019 Langton Lake Park ## North (Baseball/Soccer) Parking Lot (2020) ## PP-020 0 0 0 25,000 0 0 0 0 0 0 ## PARKLOT-020 Lexington Park (off ## Cty B) Parking Lot (2023) ## PP-021 0 0 0 0 0 0 30,000 0 0 0 ## PARKLOT-024 Rosebrook Park ## (Wading Pool) Parking Lot (2026) ## PP-025 0 0 0 0 0 0 0 0 0 100,000 ## PARKLOT-025 Roseville City Hall ## Parking Lot (2019) ## PP-026 0 0 110,000 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 15 / 33 Page 174 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## PARKLOT-032 Roseville Police ## Department Parking Lot (2019) ## PP-031 0 0 0 0 0 0 0 20,000 0 0 ## PARKLOT-034 Roseville Skating ## Center North Parking Lot (2024) ## PP-033 0 0 0 0 0 0 0 50,000 0 0 Pathway Rating (ICON) PP-040 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Total 321,300 421,300 451,300 366,300 376,300 391,300 371,300 431,300 341,300 441,300 ## Other Uses Inflation 11% 38,016 0 0 0 0 0 0 0 0 0 Inflation 12% 0 53,472 0 0 0 0 0 0 0 0 Inflation 13% 0 0 61,828 0 0 0 0 0 0 0 Inflation 14% 0 0 0 54,684 0 0 0 0 0 0 Inflation 15% 0 0 0 0 60,090 0 0 0 0 0 Inflation 16% 0 0 0 0 0 66,496 0 0 0 0 Inflation 17% 0 0 0 0 0 0 67,252 0 0 0 Inflation 18% 0 0 0 0 0 0 0 82,008 0 0 Inflation 19% 0 0 0 0 0 0 0 0 69,464 0 Inflation 20% 0 0 0 0 0 0 0 0 0 93,120 Other Operating 24,300 24,300 24,300 24,300 24,300 24,300 24,300 24,300 24,300 24,300 Total 62,316 77,772 86,128 78,984 84,390 90,796 91,552 106,308 93,764 117,420 Total Expenditures and Uses 383,616 499,072 537,428 445,284 460,690 482,096 462,852 537,608 435,064 558,720 Change in Fund Balance 67,295 -36,024 -60,423 47,772 50,824 50,645 94,300 47,617 182,445 95,915 ## Ending Balance 234,373 198,349 137,926 185,698 236,522 287,167 381,467 429,084 611,529 707,444 ## Produced Using Plan-It CIP SoftwarePage 16 / 33 Page 175 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 409 Central Services Equipment Fund Beginning Balance 92,979 80,804 69,019 57,647 46,701 36,205 26,180 16,646 7,626 -859 ## Revenues and Other Fund Sources ## Revenue Investment Income 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 Tax Levy 48,760 49,735 50,730 51,744 52,779 53,835 54,911 56,010 57,130 58,272 Total 52,760 53,735 54,730 55,744 56,779 57,835 58,911 60,010 61,130 62,272 ## Other Fund Sources Total Revenues and Other Fund Sources 52,760 53,735 54,730 55,744 56,779 57,835 58,911 60,010 61,130 62,272 Total Funds available 145,739 134,539 123,749 113,391 103,480 94,040 85,091 76,656 68,756 61,413 ## Expenditures and Uses ## Capital Projects & Equipment ## Central Services Postage Machine Lease CS-001 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 4,500 Copier/Printer/Scanner Lease CS-002 54,000 54,000 54,000 54,000 54,000 54,000 54,000 54,000 54,000 54,000 Total 58,500 58,500 58,500 58,500 58,500 58,500 58,500 58,500 58,500 58,500 ## Other Uses Inflation 11% 6,435 0 0 0 0 0 0 0 0 0 Inflation 12% 0 7,020 0 0 0 0 0 0 0 0 Inflation 13% 0 0 7,602 0 0 0 0 0 0 0 Inflation 14% 0 0 0 8,190 0 0 0 0 0 0 Inflation 15% 0 0 0 0 8,775 0 0 0 0 0 Inflation 16% 0 0 0 0 0 9,360 0 0 0 0 Inflation 17% 0 0 0 0 0 0 9,945 0 0 0 Inflation 18% 0 0 0 0 0 0 0 10,530 0 0 Inflation 19% 0 0 0 0 0 0 0 0 11,115 0 Inflation 20% 0 0 0 0 0 0 0 0 0 11,700 Total 6,435 7,020 7,602 8,190 8,775 9,360 9,945 10,530 11,115 11,700 Total Expenditures and Uses 64,935 65,520 66,102 66,690 67,275 67,860 68,445 69,030 69,615 70,200 Change in Fund Balance -12,175 -11,785 -11,372 -10,946 -10,496 -10,025 -9,534 -9,020 -8,485 -7,928 ## Ending Balance 80,804 69,019 57,647 46,701 36,205 26,180 16,646 7,626 -859 -8,787 ## Produced Using Plan-It CIP SoftwarePage 17 / 33 Page 176 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 410 General Facilities Replacement ## Fund Beginning Balance -4,779,636 -5,020,512 -4,462,918 -4,160,274 -3,871,951 -6,027,492 -5,964,358 -18,238,429 -17,493,425 -16,746,131 ## Revenues and Other Fund Sources ## Revenue Fees 77,184 77,184 77,184 77,184 77,184 77,184 77,184 77,184 77,184 77,184 Tax Levy 748,650 748,650 748,650 748,650 748,650 748,650 748,650 748,650 748,650 748,650 Total 825,834 825,834 825,834 825,834 825,834 825,834 825,834 825,834 825,834 825,834 ## Other Fund Sources Total Revenues and Other Fund Sources 825,834 825,834 825,834 825,834 825,834 825,834 825,834 825,834 825,834 825,834 Total Funds available -3,953,802 -4,194,678 -3,637,084 -3,334,440 -3,046,117 -5,201,658 -5,138,524 -17,412,595 -16,667,591 -15,920,297 ## Expenditures and Uses ## Capital Projects & Equipment ## General Facilities Equipment Replacement CM-01 0 1,000 0 5,000 0 1,000 0 1,000 1,000 5,000 Council Furniture CM-02 0 0 0 0 0 40,000 0 0 0 0 Council Control/Sound System CM-03 2,500 0 10,000 0 2,500 0 0 0 0 0 Council: camera replacement CM-04 0 0 0 0 0 0 30,000 0 0 0 ## Campus: Network Access Devices - previously IT ## GF-002 33,000 33,000 33,000 33,000 33,000 33,000 33,000 33,000 33,000 33,000 ## City Hall/PD: Replace Rooftop Heat/ ## AC-Police ## GF-003 0 0 0 0 0 275,000 0 0 0 0 ## City Hall/PD: Misc Work Station ## Upgrades ## GF-008 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 City Hall/PD: Heating boilers Police GF-012 0 0 70,500 0 0 0 0 0 0 0 City Hall/PD: Water heaters GF-014 0 0 25,000 0 0 0 0 0 0 0 ## City Hall/PD: Police & PW garage Co2/No2 detectors ## GF-016 10,000 0 0 0 0 10,000 0 0 0 0 ## City Hall/PD: Update HVAC Controls - Software ## GF-018 0 0 7,500 0 0 0 7,500 0 0 0 City Hall/PD: Update Flooring CH/PD GF-019 0 0 0 0 0 100,000 0 0 0 0 City Hall/PD: Update Restrooms CH GF-021 0 0 0 0 100,000 0 0 0 0 0 ## City Hall/PD: workstation replacement city hall ## GF-022 0 0 0 350,000 0 0 0 0 0 0 ## City Hall/PD: Overhead door replacement - CH/PD/Main ## GF-023 0 0 0 0 0 25,000 0 0 0 0 MF: Roof - Parks Garage GF-024 0 0 150,000 0 0 0 0 0 0 0 City Hall/PD: Paint walls city hall GF-036 25,000 0 0 0 25,000 0 0 0 0 0 MF: Paint walls Maintenance Facility GF-037 0 0 0 15,000 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 18 / 33 Page 177 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## City Hall/PD: Light Fixture ## Conversion ## GF-038 0 0 0 0 0 75,000 0 0 0 0 MF: Pressure Washer GF-041 10,000 0 0 0 0 0 0 0 0 0 PF: Brimhall gymnasium GF-049 50,000 0 0 0 0 0 0 0 0 0 PF - Central Park gymnasium GF-050 0 50,000 0 0 0 0 0 0 0 0 PF - Gymnastics Center GF-052 50,000 0 0 0 0 0 0 0 0 0 ## GOLF: TRANSFER TO FUND ## 620-BLDG IMPROVEMENTS ## GF-151 30,000 37,000 14,500 20,000 20,000 0 0 0 0 0 ## Fire Station: Painting/wall paper in various areas of Fire Station ## GF-152 0 0 6,000 0 13,000 0 0 6,000 0 0 ## Fire Station: Carpeting in various areas of Fire Station ## GF-153 0 0 0 0 10,000 0 0 0 0 0 Fire Station: Shift office counter tops GF-154 0 5,000 0 0 0 0 0 0 0 0 Fire Station: Bay painting GF-156 0 0 0 0 0 35,000 0 0 0 0 ## Fire Station: Laundry Room Washer & dryer- gear ## GF-159 20,000 0 0 0 0 0 0 0 0 0 ## Fire Station: Apparatus High ## Pressure Washer ## GF-161 0 0 0 0 0 0 0 0 0 18,000 Fire Station: Security system GF-165 0 0 3,500 0 3,500 0 3,500 0 3,500 3,500 Fire Station: Heat pumps (24) GF-174 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 Fire Station: Concrete Exterior GF-185 10,000 0 0 10,000 0 0 10,000 0 0 0 Fire Station: Lighting - exterior and interior ## GF-186 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 ## Fire Station: Apparatus Bay Air ## Monitoring Sensors ## GF-188 25,000 0 0 0 0 0 0 0 0 0 SC: Snow Melt Pit Arena-Stainless SC-1137 0 0 0 0 0 0 30,000 0 0 0 ## SC: Arena: Rubber flooring - changing area ## SC-2063 0 0 15,000 0 0 0 0 0 0 0 SC: Arena: Rubber flooring - locker rooms ## SC-2064 0 0 20,000 0 0 0 0 0 0 0 SC: Ice Edgers-Arena SC-2135 0 0 0 0 0 0 12,000 0 0 0 SC: OVAL Refrigeration Plant SC-3091 0 0 0 0 1,560,000 0 0 0 0 0 ## SC: OVAL Concrete Refrigeration ## Rink ## SC-3093 0 0 0 0 0 0 11,000,000 0 0 0 ## SC: OVAL: Chemical Treatment ## System ## SC-3114 0 20,000 0 0 0 0 0 0 0 0 SC: OVAL: Scoreboard SC-4079 350,000 0 0 0 0 0 0 0 0 0 ## SC: OVAL Perimeter Paving/ ## Drainage System ## SC-4094 0 0 0 0 232,000 0 0 0 0 0 ## SC: OVAL Safety Pad and Fence ## System ## SC-4095 0 0 0 0 450,000 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 19 / 33 Page 178 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## SC: Banquet Ctr Wall and Window ## Covering ## SC-4119 25,000 0 0 0 0 0 0 0 0 0 SC: Banquet Ctr: Divider Wall SC-4123 0 0 0 0 25,000 0 0 0 0 0 SC: Ice Edgers-OVAL SC-4136 0 0 0 0 0 0 12,000 0 0 0 Rubber for outside of OVAL SC-4141 0 0 0 0 0 35,000 0 0 0 0 SC: OVAL Divder Pads SC-4143 40,000 0 0 0 0 0 0 0 0 0 SC: Parking Lot Lighting - North SC-5058 0 0 0 1 0 0 0 0 0 0 SC: South Entry RTU (2007) SC-6057 27,000 0 0 0 0 0 0 0 0 0 ## SC: Arena: Roof Top units (2) (2008) (Reznor Units) ## SC-6062 195,000 0 0 0 0 0 0 0 0 0 SC: Arena: Mezzanine HP (2009) SC-6066 0 0 65,000 0 0 0 0 0 0 0 SC: Arena: Locker Room RTU (2008) SC-6072 0 0 0 0 0 0 30,000 0 0 0 ## SC: Banquet Ctr: Fitness Room RTU (2007) ## SC-6116 0 40,000 0 0 0 0 0 0 0 0 SC: Banquet Ctr: Fireside Room HP SC-6121 0 0 0 0 45,000 0 0 0 0 0 SC: Raider Room Heat Pump SC-6122 0 0 0 0 25,000 0 0 0 0 0 Total 931,000 214,500 448,500 461,501 2,572,500 657,500 11,196,500 68,500 66,000 88,000 ## Other Uses Inflation 11% 102,410 0 0 0 0 0 0 0 0 0 Inflation 12% 0 25,740 0 0 0 0 0 0 0 0 Inflation 13% 0 0 58,305 0 0 0 0 0 0 0 Inflation 14% 0 0 0 64,610 0 0 0 0 0 0 Inflation 15% 0 0 0 0 385,875 0 0 0 0 0 Inflation 16% 0 0 0 0 0 105,200 0 0 0 0 Inflation 17% 0 0 0 0 0 0 1,903,405 0 0 0 Inflation 18% 0 0 0 0 0 0 0 12,330 0 0 Inflation 19% 0 0 0 0 0 0 0 0 12,540 0 Inflation 20% 0 0 0 0 0 0 0 0 0 17,600 Transfers Out to Fund 620 Golf 33,300 28,000 16,385 11,400 23,000 0 0 0 0 0 Total 135,710 53,740 74,690 76,010 408,875 105,200 1,903,405 12,330 12,540 17,600 Total Expenditures and Uses 1,066,710 268,240 523,190 537,511 2,981,375 762,700 13,099,905 80,830 78,540 105,600 Change in Fund Balance -240,876 557,594 302,644 288,323 -2,155,541 63,134 -12,274,071 745,004 747,294 720,234 ## Ending Balance -5,020,512 -4,462,918 -4,160,274 -3,871,951 -6,027,492 -5,964,358 -18,238,429 -17,493,425 -16,746,131 -16,025,897 ## Produced Using Plan-It CIP SoftwarePage 20 / 33 Page 179 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 411 Park Improvement Fund Beginning Balance -54,811 107,149 367,159 998,319 1,414,527 1,445,337 1,884,547 2,680,857 3,403,867 4,195,177 ## Revenues and Other Fund Sources ## Revenue Investment Income 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 Property Taxes 1,078,810 1,078,810 1,078,810 1,078,810 1,078,810 1,078,810 1,078,810 1,078,810 1,078,810 1,078,810 Total 1,088,810 1,088,810 1,088,810 1,088,810 1,088,810 1,088,810 1,088,810 1,088,810 1,088,810 1,088,810 ## Other Fund Sources Total Revenues and Other Fund Sources 1,088,810 1,088,810 1,088,810 1,088,810 1,088,810 1,088,810 1,088,810 1,088,810 1,088,810 1,088,810 Total Funds available 1,033,999 1,195,959 1,455,969 2,087,129 2,503,337 2,534,147 2,973,357 3,769,667 4,492,677 5,283,987 ## Expenditures and Uses ## Capital Projects & Equipment ## Park Improvement Fund ## Acorn Park Tennis and Basketball ## Courts ## PIP-10001 0 0 0 0 175,000 0 0 0 0 0 ## Applewood Park - 1/2 Court basketball ## PIP-10002 15,000 0 0 0 0 0 0 0 0 0 ## Autumn Grove Tennis Court and ## Basketball Courts ## PIP-10003 0 50,000 0 0 0 0 0 0 0 0 ## Bruce Russell Tennis Courts (2) and ## Basketball Court ## PIP-10004 0 50,000 0 0 0 0 0 0 0 0 ## Central Park Victoria: 2 lighted tennis, coated fence ## PIP-10005 0 0 0 50,000 0 0 0 0 0 0 Evergreen Park Pickleball Courts PIP-10006 0 0 0 0 175,000 0 0 0 0 0 Lexington Park Basketball Court PIP-10008 0 50,000 0 0 0 0 0 0 0 0 Rosebrook Park: 2 lighted tennis, coated fence ## PIP-10012 50,000 0 0 0 0 0 0 0 0 0 Acorn Park Building PIP-20001 0 15,000 0 0 0 0 0 0 0 0 Arboretum Fountain PIP-20006 0 0 0 0 0 0 0 60,000 0 0 Central Park Amphitheater PIP-20009 0 0 0 250,000 0 0 0 0 0 0 ## Evergreen Ballfields Concession & ## Storage Building ## PIP-20014 0 12,500 0 0 0 0 0 0 0 0 Evergreen neighborhood shelter PIP-20015 0 12,500 0 0 0 0 0 0 0 0 HANC Facility and Grounds PIP-20017 0 15,000 0 0 0 0 0 0 0 0 Park Building Flooring PIP-20038 0 0 30,000 30,000 0 0 0 0 0 0 Park Building Exterior Painting PIP-20042 45,000 0 0 0 0 0 0 0 0 0 Central Park Lexington Park - 2016 PIP-30005 300,000 0 0 0 0 0 0 0 0 0 Midland Gardents - 2019 PIP-30017 0 0 125,000 0 0 0 0 0 0 0 Owasso Hills Park - 1998 PIP-30020 0 0 0 0 155,000 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 21 / 33 Page 180 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 Pioneer - 1998 PIP-30021 0 0 0 0 155,000 0 0 0 0 0 Keya - 2023 PIP-30022 0 0 0 0 0 155,000 0 0 0 0 Rosebrook - 2000 PIP-30023 0 0 0 0 0 155,000 0 0 0 0 Tamarack - 2017 PIP-30025 155,000 0 0 0 0 0 0 0 0 0 Unity Park - 2018 PIP-30026 0 155,000 0 0 0 0 0 0 0 0 ## Central Park Sand Volley Ball Court: 4 sand courts ## PIP-40001 0 20,000 0 0 0 0 0 0 0 0 Upper Villa Bocce: 2 lanes PIP-40002 0 0 0 1 0 0 0 0 0 0 Central Park Bocce Ball Courts PIP-40003 0 0 0 1 0 0 0 0 0 0 Villa Park Bocce PIP-40006 0 10,000 0 0 0 0 0 0 0 0 ## CP Dale Street Athletic: Black Vinyl ## Fence ## PIP-50009 20,000 0 0 0 0 0 0 0 0 0 CP Victoria: Softball Fields PIP-50012 0 0 0 0 10,000 0 0 0 0 0 Langton Lake: Baseball Fields PIP-50018 0 0 0 10,000 0 0 0 0 0 0 CP Lexington Marquee Sign PIP-80001 0 100,000 0 0 0 0 0 0 0 0 General Items (see below) PIP-90001 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 Natural Resources PIP-90002 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 Total 835,000 740,000 405,000 590,002 920,000 560,000 250,000 310,000 250,000 250,000 ## Other Uses Inflation 11% 91,850 0 0 0 0 0 0 0 0 0 Inflation 12% 0 88,800 0 0 0 0 0 0 0 0 Inflation 13% 0 0 52,650 0 0 0 0 0 0 0 Inflation 14% 0 0 0 82,600 0 0 0 0 0 0 Inflation 15% 0 0 0 0 138,000 0 0 0 0 0 Inflation 16% 0 0 0 0 0 89,600 0 0 0 0 Inflation 17% 0 0 0 0 0 0 42,500 0 0 0 Inflation 18% 0 0 0 0 0 0 0 55,800 0 0 Inflation 19% 0 0 0 0 0 0 0 0 47,500 0 Inflation 20% 0 0 0 0 0 0 0 0 0 50,000 Total 91,850 88,800 52,650 82,600 138,000 89,600 42,500 55,800 47,500 50,000 Total Expenditures and Uses 926,850 828,800 457,650 672,602 1,058,000 649,600 292,500 365,800 297,500 300,000 Change in Fund Balance 161,960 260,010 631,160 416,208 30,810 439,210 796,310 723,010 791,310 788,810 ## Ending Balance 107,149 367,159 998,319 1,414,527 1,445,337 1,884,547 2,680,857 3,403,867 4,195,177 4,983,987 ## Produced Using Plan-It CIP SoftwarePage 22 / 33 Page 181 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 590 Street Replacement Fund Beginning Balance 2,157,760 1,514,260 852,260 171,760 -527,240 -1,296,490 -2,032,490 -2,786,990 -3,559,990 -4,351,490 ## Revenues and Other Fund Sources ## Revenue Franchise Fees 1,360,000 1,360,000 1,360,000 1,360,000 1,360,000 1,360,000 1,360,000 1,360,000 1,360,000 1,360,000 Interest 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 Total 1,410,000 1,410,000 1,410,000 1,410,000 1,410,000 1,410,000 1,410,000 1,410,000 1,410,000 1,410,000 ## Other Fund Sources Total Revenues and Other Fund Sources 1,410,000 1,410,000 1,410,000 1,410,000 1,410,000 1,410,000 1,410,000 1,410,000 1,410,000 1,410,000 Total Funds available 3,567,760 2,924,260 2,262,260 1,581,760 882,760 113,510 -622,490 -1,376,990 -2,149,990 -2,941,490 ## Expenditures and Uses ## Capital Projects & Equipment ## Storm ## Toro Goundmaster Polor Trac ## 7210-D(2021) #110 ## STM-001 0 0 0 0 45,000 0 0 0 0 0 Total 0 0 0 0 45,000 0 0 0 0 0 ## Street Replacement Mill & overlay - local streets ST-001 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 Total 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 ## Other Uses Inflation 11% 203,500 0 0 0 0 0 0 0 0 0 Inflation 12% 0 222,000 0 0 0 0 0 0 0 0 Inflation 13% 0 0 240,500 0 0 0 0 0 0 0 Inflation 14% 0 0 0 259,000 0 0 0 0 0 0 Inflation 15% 0 0 0 0 284,250 0 0 0 0 0 Inflation 16% 0 0 0 0 0 296,000 0 0 0 0 Inflation 17% 0 0 0 0 0 0 314,500 0 0 0 Inflation 18% 0 0 0 0 0 0 0 333,000 0 0 Inflation 19% 0 0 0 0 0 0 0 0 351,500 0 Inflation 20% 0 0 0 0 0 0 0 0 0 370,000 Total 203,500 222,000 240,500 259,000 284,250 296,000 314,500 333,000 351,500 370,000 Total Expenditures and Uses 2,053,500 2,072,000 2,090,500 2,109,000 2,179,250 2,146,000 2,164,500 2,183,000 2,201,500 2,220,000 Change in Fund Balance -643,500 -662,000 -680,500 -699,000 -769,250 -736,000 -754,500 -773,000 -791,500 -810,000 ## Ending Balance 1,514,260 852,260 171,760 -527,240 -1,296,490 -2,032,490 -2,786,990 -3,559,990 -4,351,490 -5,161,490 ## Produced Using Plan-It CIP SoftwarePage 23 / 33 Page 182 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 600 Sanitary Sewer Capital Fund Beginning Balance 0 0 0 0 0 0 0 0 0 0 ## Revenues and Other Fund Sources ## Revenue Fees 1,455,765 2,591,680 1,504,030 1,429,560 1,511,100 1,918,640 1,860,300 1,620,730 2,021,810 1,564,800 Total 1,455,765 2,591,680 1,504,030 1,429,560 1,511,100 1,918,640 1,860,300 1,620,730 2,021,810 1,564,800 ## Other Fund Sources Total Revenues and Other Fund Sources 1,455,765 2,591,680 1,504,030 1,429,560 1,511,100 1,918,640 1,860,300 1,620,730 2,021,810 1,564,800 Total Funds available 1,455,765 2,591,680 1,504,030 1,429,560 1,511,100 1,918,640 1,860,300 1,620,730 2,021,810 1,564,800 ## Expenditures and Uses ## Capital Projects & Equipment ## Parks & Recreation Vehicles & Equipment Water truck (1/2 cost) (2019) #510 PR-006 0 0 0 0 0 0 75,000 0 0 0 Total 0 0 0 0 0 0 75,000 0 0 0 ## Public Works Vehicle and Equipment ## Trafifix Scorpion Attenuator (2017) #137 ## PW-025 7,500 0 0 0 0 0 0 0 0 0 Bobcat T76 (2024) #131 PW-036 0 25,000 0 0 0 0 0 0 25,000 0 Generac light tower Magnum ## MLT4060KV (2013) #210 ## PW-037 0 0 0 0 0 0 0 2,500 0 0 ## Genie GS2646 Man Lift (2007) #90225 ## PW-038 0 0 0 0 0 0 0 2,500 0 0 Nissan PL40 Forklift (2006) #90125 PW-039 0 0 0 0 0 0 0 2,500 0 0 Total 7,500 25,000 0 0 0 0 0 7,500 25,000 0 ## Sanitary Sand Bucket 24" 315D #211A SAN-004 0 0 0 0 0 0 10,000 0 0 0 ## Sreco-Flexible EMSP-6 Easement Machine (2005) #215 ## SAN-006 0 0 0 0 0 0 95,000 0 0 0 ## Himoinsa/Iveco Hiw-40r Towable Generator (2004) #235 ## SAN-012 0 90,000 0 0 0 0 0 0 0 0 Rover Sewer Camera (2019) #241 SAN-014 0 290,000 0 0 0 0 0 0 0 0 ## Pioneer PPAT66S12 6" Trash Pump (2020) #20125 ## SAN-015 0 0 0 0 0 0 0 0 20,000 0 #xx GPS Unit SAN-016 0 0 4,000 0 0 0 0 0 0 0 Asset Management System SAN-022 50,000 0 0 0 0 0 0 0 0 0 Replace/Upgrade SCADAsystem SAN-023 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 I & I reduction SAN-024 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 Lift Station - Josephine Rehab SAN-033 0 0 0 0 60,000 400,000 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 24 / 33 Page 183 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## Lift Station - Wagner Rehab, no generator ## SAN-036 0 0 0 0 0 0 0 60,000 400,000 0 Sewer main repairs (lining) SAN-038 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 Western Star 4700 900 ECO (2025) #20425 ## SAN-040 0 650,000 0 0 0 0 0 0 0 0 Ford F350 (2014) #217 SAN-044 0 5,000 0 0 0 0 0 0 0 0 Ford F250 (2017) #223 SAN-046 0 0 73,000 0 0 0 0 0 0 0 ## Caterpillar M315D Wheeled Back Hoe (2008) #211 ## SAN-047 0 0 0 0 0 0 134,000 0 0 0 Total 1,304,000 2,289,000 1,331,000 1,254,000 1,314,000 1,654,000 1,493,000 1,314,000 1,674,000 1,254,000 ## Storm ## Rotobec PC018B Grapple 360 Mini Excavator (2014) #225 A13 ## STM-019 0 0 0 0 0 0 0 7,000 0 0 Lift Station Condition Analysis STM-037 0 0 0 0 0 0 0 0 0 50,000 Total 0 0 0 0 0 0 0 7,000 0 50,000 ## Water ## Caterpillar CVP75 Vibratory Plate Compactor (2015) #211 A14 ## WT-003 0 0 0 0 0 0 7,000 0 0 0 ## Caterpillar H65ES Hydraulic Breaker ## (2014) #225 A12 ## WT-005 0 0 0 0 0 0 0 5,000 0 0 Caterpillar 305E Excavator (2015) #225 ## WT-007 0 0 0 0 0 0 0 40,000 0 0 ## Bomag BMP8500 Compactor (2017) #237 ## WT-009 0 0 0 0 0 0 15,000 0 0 0 Total 0 0 0 0 0 0 22,000 45,000 0 0 ## Other Uses Inflation 20% 0 0 0 0 0 0 0 0 0 260,800 Inflation 19% 0 0 0 0 0 0 0 0 322,810 0 Inflation 18% 0 0 0 0 0 0 0 247,230 0 0 Inflation 17% 0 0 0 0 0 0 270,300 0 0 0 Inflation 16% 0 0 0 0 0 264,640 0 0 0 0 Inflation 15% 0 0 0 0 197,100 0 0 0 0 0 Inflation 14% 0 0 0 175,560 0 0 0 0 0 0 Inflation 13% 0 0 173,030 0 0 0 0 0 0 0 Inflation 12% 0 277,680 0 0 0 0 0 0 0 0 Inflation 11% 144,265 0 0 0 0 0 0 0 0 0 Total 144,265 277,680 173,030 175,560 197,100 264,640 270,300 247,230 322,810 260,800 Total Expenditures and Uses 1,455,765 2,591,680 1,504,030 1,429,560 1,511,100 1,918,640 1,860,300 1,620,730 2,021,810 1,564,800 Change in Fund Balance 0 0 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 25 / 33 Page 184 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## Ending Balance 0 0 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 26 / 33 Page 185 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 610 Water Capital Fund Beginning Balance 0 0 0 0 0 0 0 0 0 0 ## Revenues and Other Fund Sources ## Revenue Fees 2,854,365 2,126,880 1,997,840 2,010,960 2,124,050 2,243,440 2,327,130 2,151,730 2,152,710 2,294,400 Total 2,854,365 2,126,880 1,997,840 2,010,960 2,124,050 2,243,440 2,327,130 2,151,730 2,152,710 2,294,400 ## Other Fund Sources Total Revenues and Other Fund Sources 2,854,365 2,126,880 1,997,840 2,010,960 2,124,050 2,243,440 2,327,130 2,151,730 2,152,710 2,294,400 Total Funds available 2,854,365 2,126,880 1,997,840 2,010,960 2,124,050 2,243,440 2,327,130 2,151,730 2,152,710 2,294,400 ## Expenditures and Uses ## Capital Projects & Equipment ## Public Works Vehicle and Equipment ## Trafifix Scorpion Attenuator (2017) #137 ## PW-025 7,500 0 0 0 0 0 0 0 0 0 Bobcat T76 (2024) #131 PW-036 0 25,000 0 0 0 0 0 0 25,000 0 Generac light tower Magnum ## MLT4060KV (2013) #210 ## PW-037 0 0 0 0 0 0 0 2,500 0 0 ## Genie GS2646 Man Lift (2007) #90225 ## PW-038 0 0 0 0 0 0 0 2,500 0 0 Nissan PL40 Forklift (2006) #90125 PW-039 0 0 0 0 0 0 0 2,500 0 0 Total 7,500 25,000 0 0 0 0 0 7,500 25,000 0 ## Sanitary Sand Bucket 24" 315D #211A SAN-004 0 0 0 0 0 0 10,000 0 0 0 ## Pioneer PPAT66S12 6" Trash Pump (2020) #20125 ## SAN-015 0 0 0 0 0 0 0 0 20,000 0 #xx GPS Unit SAN-016 0 0 4,000 0 0 0 0 0 0 0 Asset Management System SAN-022 50,000 0 0 0 0 0 0 0 0 0 Replace/Upgrade SCADAsystem SAN-023 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 ## Caterpillar M315D Wheeled Back Hoe (2008) #211 ## SAN-047 0 0 0 0 0 0 133,000 0 0 0 Total 54,000 4,000 8,000 4,000 4,000 4,000 147,000 4,000 24,000 4,000 ## Storm ## Rotobec PC018B Grapple 360 Mini Excavator (2014) #225 A13 ## STM-019 0 0 0 0 0 0 0 7,000 0 0 Total 0 0 0 0 0 0 0 7,000 0 0 ## Water ## Caterpillar CVP75 Vibratory Plate Compactor (2015) #211 A14 ## WT-003 0 0 0 0 0 0 7,000 0 0 0 ## Caterpillar H65ES Hydraulic Breaker ## (2014) #225 A12 ## WT-005 0 0 0 0 0 0 0 5,000 0 0 ## Produced Using Plan-It CIP SoftwarePage 27 / 33 Page 186 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 Caterpillar 305E Excavator (2015) #225 ## WT-007 0 0 0 0 0 0 0 40,000 0 0 Felling Ft7t Trailer (2021) #236 WT-008 0 0 0 0 10,000 0 0 0 0 0 ## Bomag BMP8500 Compactor (2017) #237 ## WT-009 0 0 0 0 0 0 15,000 0 0 0 ## EH Wachs 77-000-38 Standard LX ## Valve Maintenance Trailer (2018) #240 ## WT-010 0 110,000 0 0 0 0 0 0 0 0 Water Booster Station WT-018 1,000,000 0 0 0 0 0 0 0 0 0 Elevated storage tank repainting contract ## WT-019 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 Water Main Replacement WT-026 1,500,000 1,750,000 1,750,000 1,750,000 1,750,000 1,750,000 1,750,000 1,750,000 1,750,000 1,750,000 ## RAM 3500 (2022) #206 WT-029 0 0 0 0 0 0 0 0 0 73,000 Ford Transit 150 (2019) #208 WT-030 0 0 0 0 0 0 60,000 0 0 0 ## GMC C5500 Water Break (2008) #213 ## WT-032 0 0 0 0 0 170,000 0 0 0 0 Ford F250 (2017) #221 WT-033 0 0 0 0 73,000 0 0 0 0 0 Ford F350 (2022) #222 WT-034 0 0 0 0 0 0 0 0 0 75,000 Total 2,510,000 1,870,000 1,760,000 1,760,000 1,843,000 1,930,000 1,842,000 1,805,000 1,760,000 1,908,000 ## Other Uses Inflation 11% 282,865 0 0 0 0 0 0 0 0 0 Inflation 12% 0 227,880 0 0 0 0 0 0 0 0 Inflation 13% 0 0 229,840 0 0 0 0 0 0 0 Inflation 14% 0 0 0 246,960 0 0 0 0 0 0 Inflation 15% 0 0 0 0 277,050 0 0 0 0 0 Inflation 16% 0 0 0 0 0 309,440 0 0 0 0 Inflation 17% 0 0 0 0 0 0 338,130 0 0 0 Inflation 18% 0 0 0 0 0 0 0 328,230 0 0 Inflation 19% 0 0 0 0 0 0 0 0 343,710 0 Inflation 20% 0 0 0 0 0 0 0 0 0 382,400 Total 282,865 227,880 229,840 246,960 277,050 309,440 338,130 328,230 343,710 382,400 Total Expenditures and Uses 2,854,365 2,126,880 1,997,840 2,010,960 2,124,050 2,243,440 2,327,130 2,151,730 2,152,710 2,294,400 Change in Fund Balance 0 0 0 0 0 0 0 0 0 0 ## Ending Balance 0 0 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 28 / 33 Page 187 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 620 Golf Vehicle & Equipment Fund Beginning Balance 0 0 0 0 0 0 0 0 0 0 ## Revenues and Other Fund Sources ## Revenue Transfer from Fund 402 0 36,960 61,020 61,560 16,100 0 51,480 0 0 0 Transfer from Fund 410 33,300 28,000 16,385 11,400 23,000 0 0 0 0 0 Total 33,300 64,960 77,405 72,960 39,100 0 51,480 0 0 0 ## Other Fund Sources Total Revenues and Other Fund Sources 33,300 64,960 77,405 72,960 39,100 0 51,480 0 0 0 Total Funds available 33,300 64,960 77,405 72,960 39,100 0 51,480 0 0 0 ## Expenditures and Uses ## Capital Projects & Equipment ## Golf Golf: Zero Turn Mower - 2008 G-003 0 0 0 0 14,000 0 0 0 0 0 Golf: Greens Mower - 2000 G-005 0 0 44,000 0 0 0 0 0 0 0 Golf: Greens/tee mower - 2002 G-006 0 0 0 44,000 0 0 0 0 0 0 ## Golf: Turf Equipment/Aerators - 2001 ## G-007 0 21,000 0 0 0 0 0 0 0 0 Golf: Cushman #1 & 2 - 2014 and 1988 ## G-009 0 0 0 0 0 0 44,000 0 0 0 Golf: Operational Power Equipment G-015 0 0 10,000 0 0 0 0 0 0 0 ## Golf: Com Bldg Kitchen Equipment 2018 ice ## G-016 0 10,000 0 10,000 0 0 0 0 0 0 ## Golf: Com Bldg Paint Interior/ ## Exterior ## G-017 30,000 0 14,500 0 20,000 0 0 0 0 0 ## Golf: Com Bldg Furn. Replace. - 2018 ## Tables then Chairs ## G-021 0 15,000 0 0 0 0 0 0 0 0 Golf: Irrigation system upgrades G-028 0 12,000 0 10,000 0 0 0 0 0 0 Total 30,000 58,000 68,500 64,000 34,000 0 44,000 0 0 0 ## Other Uses Inflation 17% 0 0 0 0 0 0 7,480 0 0 0 Inflation 15% 0 0 0 0 5,100 0 0 0 0 0 Inflation 14% 0 0 0 8,960 0 0 0 0 0 0 Inflation 13% 0 0 8,905 0 0 0 0 0 0 0 Inflation 12% 0 6,960 0 0 0 0 0 0 0 0 Inflation 11% 3,300 0 0 0 0 0 0 0 0 0 Total 3,300 6,960 8,905 8,960 5,100 0 7,480 0 0 0 Total Expenditures and Uses 33,300 64,960 77,405 72,960 39,100 0 51,480 0 0 0 Change in Fund Balance 0 0 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 29 / 33 Page 188 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## Ending Balance 0 0 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 30 / 33 Page 189 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 ## 640 Storm Sewer Capital Fund Beginning Balance 0 0 0 0 0 0 0 0 0 0 ## Revenues and Other Fund Sources ## Revenue Fees 2,461,425 2,756,320 2,850,990 2,404,260 2,563,350 3,016,000 2,637,180 2,965,930 3,729,460 2,536,800 Total 2,461,425 2,756,320 2,850,990 2,404,260 2,563,350 3,016,000 2,637,180 2,965,930 3,729,460 2,536,800 ## Other Fund Sources Total Revenues and Other Fund Sources 2,461,425 2,756,320 2,850,990 2,404,260 2,563,350 3,016,000 2,637,180 2,965,930 3,729,460 2,536,800 Total Funds available 2,461,425 2,756,320 2,850,990 2,404,260 2,563,350 3,016,000 2,637,180 2,965,930 3,729,460 2,536,800 ## Expenditures and Uses ## Capital Projects & Equipment ## Public Works Vehicle and Equipment ## Kubota M110GXDTC Tractor (2015) #116 ## PW-020 0 0 60,000 0 0 0 0 0 0 0 ## Trafifix Scorpion Attenuator (2017) #137 ## PW-025 7,500 0 0 0 0 0 0 0 0 0 Bobcat T76 (2024) #131 PW-036 0 25,000 0 0 0 0 0 0 25,000 0 Generac light tower Magnum ## MLT4060KV (2013) #210 ## PW-037 0 0 0 0 0 0 0 2,500 0 0 ## Genie GS2646 Man Lift (2007) #90225 ## PW-038 0 0 0 0 0 0 0 2,500 0 0 Nissan PL40 Forklift (2006) #90125 PW-039 0 0 0 0 0 0 0 2,500 0 0 Total 7,500 25,000 60,000 0 0 0 0 7,500 25,000 0 ## Sanitary Sand Bucket 24" 315D #211A SAN-004 0 0 0 0 0 0 10,000 0 0 0 ## Pioneer PPAT66S12 6" Trash Pump (2020) #20125 ## SAN-015 0 0 0 0 0 0 0 0 20,000 0 #xx GPS Unit SAN-016 0 0 4,000 0 0 0 0 0 0 0 Asset Management System SAN-022 50,000 0 0 0 0 0 0 0 0 0 Replace/Upgrade SCADAsystem SAN-023 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 ## Caterpillar M315D Wheeled Back Hoe (2008) #211 ## SAN-047 0 0 0 0 0 0 133,000 0 0 0 Total 54,000 4,000 8,000 4,000 4,000 4,000 147,000 4,000 24,000 4,000 ## Storm ## Toro Goundmaster Polor Trac ## 7210-D(2021) #110 ## STM-001 0 0 0 0 45,000 0 0 0 0 0 ## Tiger 9119404J Flail Mower (2015) ## #116F ## STM-003 0 0 0 0 0 0 0 0 25,000 0 ## Bay Lynx Machinability SW35 10'/15' (2015) #116PPlow a ## STM-004 0 0 0 0 0 40,000 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 31 / 33 Page 190 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 Bobcat S650 (2019) #126 STM-005 0 0 0 0 85,000 0 0 0 0 0 ## Amazing Machine AM960-03 Pressure Washer (2019) #130 ## STM-006 0 0 0 20,000 0 0 0 0 0 0 ## Toro GrandStand 74519 Mower (2018) #140 ## STM-008 0 0 0 0 0 11,000 0 0 0 0 ## Toro GrandStand 74519 Mower (2018) #160 ## STM-009 11,000 0 0 0 0 0 0 0 0 0 Bobcat UV34 (2025) #10125 STM-011 0 0 0 0 0 0 0 0 25,000 0 ## Towmaster T-14DT Trailer (2019) #165 ## STM-012 0 0 0 0 0 0 15,000 0 0 0 ## Wild Cat LS177A Compost Turner (1997) #168 ## STM-013 0 0 0 0 0 450,000 0 0 0 0 ## PJ Trailer U1 182 Mow Trailer (2018) #176 ## STM-015 0 10,000 0 0 0 0 0 0 0 0 ## Rotobec PC018B Grapple 360 Mini Excavator (2014) #225 A13 ## STM-019 0 0 0 0 0 0 0 7,000 0 0 Brush Mower Attachment STM-027 0 22,000 0 0 0 0 0 0 0 0 Lift Station - St. Croix Upgrade STM-035 0 0 0 0 0 0 0 0 950,000 0 Lift Station Condition Analysis STM-037 0 0 0 0 0 0 0 0 0 25,000 Mount Ridge Storm Station Upgrade STM-038 0 0 370,000 0 0 0 0 0 0 0 Plan - Update stormwater mgmt plan ## STM-039 60,000 0 0 0 0 0 0 0 0 0 Projects - Bubbler System STM-040 0 0 0 0 0 10,000 0 0 0 0 Projects - Fountain - Frog Pond STM-041 0 0 0 0 10,000 0 0 0 0 0 ## Projects - Storm Infrastructure Rehabilitation (70%) STM-042 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 ## Projects - Water Quality Device Rehabilitation (30%) ## STM-043 585,000 585,000 585,000 585,000 585,000 585,000 585,000 585,000 585,000 585,000 ## Elgin Crosswind J Regene 3381d (2011) #121 ## STM-047 0 315,000 0 0 0 0 0 0 0 0 Western Star 4700SF (2025) #145 STM-051 0 0 0 0 0 0 0 365,000 0 0 Total 2,156,000 2,432,000 2,455,000 2,105,000 2,225,000 2,596,000 2,100,000 2,457,000 3,085,000 2,110,000 ## Water ## Caterpillar CVP75 Vibratory Plate Compactor (2015) #211 A14 ## WT-003 0 0 0 0 0 0 7,000 0 0 0 ## Caterpillar H65ES Hydraulic Breaker ## (2014) #225 A12 ## WT-005 0 0 0 0 0 0 0 5,000 0 0 Caterpillar 305E Excavator (2015) #225 ## WT-007 0 0 0 0 0 0 0 40,000 0 0 Total 0 0 0 0 0 0 7,000 45,000 0 0 ## Other Uses ## Produced Using Plan-It CIP SoftwarePage 32 / 33 Page 191 of 192 Source Project # 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 Inflation 11% 243,925 0 0 0 0 0 0 0 0 0 Inflation 12% 0 295,320 0 0 0 0 0 0 0 0 Inflation 13% 0 0 327,990 0 0 0 0 0 0 0 Inflation 14% 0 0 0 295,260 0 0 0 0 0 0 Inflation 15% 0 0 0 0 334,350 0 0 0 0 0 Inflation 16% 0 0 0 0 0 416,000 0 0 0 0 Inflation 17% 0 0 0 0 0 0 383,180 0 0 0 Inflation 18% 0 0 0 0 0 0 0 452,430 0 0 Inflation 19% 0 0 0 0 0 0 0 0 595,460 0 Inflation 20% 0 0 0 0 0 0 0 0 0 422,800 Total 243,925 295,320 327,990 295,260 334,350 416,000 383,180 452,430 595,460 422,800 Total Expenditures and Uses 2,461,425 2,756,320 2,850,990 2,404,260 2,563,350 3,016,000 2,637,180 2,965,930 3,729,460 2,536,800 Change in Fund Balance 0 0 0 0 0 0 0 0 0 0 ## Ending Balance 0 0 0 0 0 0 0 0 0 0 ## Produced Using Plan-It CIP SoftwarePage 33 / 33 Page 192 of 192