2025 Adopted RPU Operating Budget Book

(This Page is Left Blank Intentionally)

(This Page is Left Blank Intentionally)

(This Page is Left Blank Intentionally)

(This Page is Left Blank Intentionally)

(This Page is Left Blank Intentionally)

(This Page is Left Blank Intentionally)

Multi-Year Project Total 2025 2026 2027 2028 2029 5-Yr Total Core Services 1 Substation Asset Management Services 80,000 80,000 80,000 80,000 80,000 400,000 2 Arc Flash Assessment Services 40,000 40,000 40,000 40,000 40,000 200,000 3 Vegetation Mgmt Program Improvements 75,000 75,000 75,000 - - 225,000 4 Asbestos Mitigation in Manholes 100,000 100,000 100,000 100,000 100,000 500,000 5 T&D Inspection Services 87,550 100,000 103,000 106,090 109,273 505,913 6 Service Assured-Electric 173,510 175,874 178,273 180,707 183,177 891,541 7 Tree Trimming 1,700,000 1,800,000 1,854,000 1,910,000 1,968,000 9,232,000 8 Allocation - New Services 300,000 317,500 325,225 343,182 351,377 1,637,284 9 Transmission Lines & Equipment Maintenance 50,000 60,000 60,000 70,000 70,000 360,000 10 Distribution Lines & Equipment Maintenance 250,000 257,500 265,225 273,182 281,377 1,567,284 11 Capacitor Bank Controls Replacement 5,000 - - - - 5,000 12 Allocation - Substation Asset Management (Maint) 185,000 200,000 180,000 180,000 180,000 925,000 13 Downtown Electric Reconfiguration Study 80,000 80,000 - - - 160,000 14 DER Hosting Capacity Study - 150,000 220,000 - 300,000 670,000 15 Engineering Records in ImageNow - - - 200,000 - 200,000 16 Transmission LIDAR & Clearance Analysis 270,000 - - - - 270,000 17 Total Core Services - 3,096,060 3,118,374 3,155,498 3,139,979 3,311,827 15,821,737 18 Customer Relations 19 Cayenta Application Enhancements 63,100 100,000 70,000 100,000 100,000 433,100 20 Cayenta Upgrade - - 251,160 - - 251,160 21 Total Customer Relations - 63,100 100,000 321,160 100,000 100,000 684,260 22 Corporate Services 23 Rates Modeling 20,000 20,000 20,000 20,000 20,000 100,000 24 Elec Cost-of-Srvc/Rate Design Study - 100,000 - - 110,000 210,000 25 SAP ERP Requirements/RFP 50,000 - - 200,000 - 250,000 26 SAP FERC Conversion 100,000 - - - - 100,000 27 Vena Support - RVNA 60,000 60,000 60,000 60,000 60,000 300,000 28 Utegration (HPC) Support Contract 75,000 75,000 75,000 80,000 85,000 390,000 29 ImageNow Upgrade - 30,000 - 30,000 - 60,000 30 Sharepoint Site 30,000 30,000 30,000 30,000 30,000 150,000 31 SCADA Pen Test 30,000 33,000 36,000 39,000 42,000 180,000 32 SAP Technical Upgrade - 100,000 - - - 100,000 33 SAP Technical Upgrade - - 75,000 - - 75,000 34 OSI OpenOTS Maint. - 9,500 10,000 10,500 11,000 41,000 35 Data Analytics 75,000 65,000 65,000 65,000 65,000 335,000 36 Allocation - Technology 54,500 99,500 44,500 44,500 44,500 287,500 37 Info Risk & Security/City Shared Infrastructure 14,500 59,500 4,500 4,500 4,500 87,500 38 Business Systems/Applications 40,000 40,000 40,000 40,000 40,000 200,000 39 Total Corporate Services - 494,500 622,000 415,500 579,000 467,500 2,578,500 40 Compliance and Public Affairs 41 WES Emissions Testing - - - 75,000 - 75,000 42 Website Upgrade 150,000 - - - - 150,000 43 Total Compliance and Public Affairs 150,000 - - 75,000 - 225,000 44 Power Resources 45 SLP Decommissioning 275,000 200,000 150,000 125,000 400,000 1,150,000 46 Silver Lake Dam Modification 1,240,000 760,000 - - - 2,000,000 47 Allocation - Power Resources 430,000 490,000 535,000 665,000 500,000 2,620,000 48 Master Plan 150,000 - - - - 150,000 49 Paint Warehouse - 102,000 - - - 102,000 50 Concrete Repairs (Driveway/Stockyard) - 105,600 - - - 105,600 51 Allocation - Facilities 215,000 215,000 220,000 220,000 220,000 1,090,000 52 Total Power Resources 2,310,000 1,872,600 905,000 1,010,000 1,120,000 7,217,600 53 General Management 54 Operating Contingency Fund 360,000 360,000 360,000 360,000 360,000 1,800,000 55 Total General Management 360,000 360,000 360,000 360,000 360,000 1,800,000 56 Total Major Maintenance Plan - External Expenditures - 6,473,660 6,072,974 5,157,158 5,263,979 5,359,327 33,500,079 Rochester Public Utilities Electric Utility 2025 - 2029 Major Maintenance Plan Section 2 - Page 1

Multi-Year Project Total 2025 2026 2027 2028 2029 5-Yr Total 1 Core Services 2 OSI SCADA Version Upgrade 10,000 290,000 290,000 - - 590,000 3 Web-Based Service Application 25,000 - - - - 25,000 4 OSI Simulator 161,291 - - - - 161,291 5 Backyard Aerial Lift - 200,000 - - - 200,000 6 Underground Cable Tester - 57,000 - - - 57,000 7 Allocation - New Services 1,330,901 1,366,521 1,407,646 1,451,336 1,491,085 7,047,489 8 New Service Installations 833,205 858,201 883,947 910,466 937,780 4,423,599 9 Distribution Lines & Equipment - Capital 329,012 338,882 349,049 359,520 370,306 1,746,769 10 Property Damage - Repair/Replace 114,437 114,437 118,000 123,000 123,000 592,874 11 T&D Equipment Upgrade/Replace 54,247 55,000 56,650 58,350 60,000 284,247 12 Load Management Installations 7,500 7,500 7,500 7,500 7,500 37,500 13 Substation/Shop Test Equipment Upgrade/Repl 30,000 40,000 40,000 40,000 40,000 190,000 14 Substation Spares and Replacements 20,000 20,000 20,000 20,000 20,000 100,000 15 Northern Hills Sub Control Building Improvement - 81,500 - - - 81,500 16 Vacuum Interrupter Tester - 50,000 - - - 50,000 17 Allocation - Substation Asset Management Capital 220,000 220,000 215,000 215,000 215,000 1,085,000 18 Metering/Shop Test Equipment Upgrade/Repl 45,000 70,000 35,000 40,000 40,000 230,000 19 Primary Metering Replacement - Kemps 28,000 - - - - 28,000 20 AMI MDM 273,973 - - - - - - 21 AMI Headend 892,922 143,258 - - - - 143,258 22 AMI Meter Installation Service 9,668,824 4,032,539 4,032,539 601,202 - - 8,666,280 23 AMI General Implementation Services 5,695,796 639,504 1,515,110 1,535,263 - - 3,689,877 24 AMI MDM Subscription 570,301 - - - - - - 25 AMI Headend Subscription 1,272,894 - - - - - - 26 Allocation - Metering 150,000 358,500 370,200 380,000 392,000 1,650,700 27 Q11 - W.C. to new St. Bridget Sub ROW 600,000 - - - - 600,000 28 Replace 20kA, 161kV Circuit Breakers 10,000 210,000 220,000 230,000 240,000 910,000 29 6th St SE Bridge 1,200,000 150,000 850,000 200,000 - - 1,200,000 30 CSAH 44 and Hwy 14 Interchange 1,045,000 500,000 525,000 - - - 1,025,000 31 N Broadway between Elton Hills & the Bri 700,000 - - - - 700,000 32 Mayo Downtown Feeder Rework 100,000 100,000 200,000 1,100,000 1,500,000 3,000,000 33 Q6 Galloping Dampers 125,000 - - - - 125,000 34 Q6 NESC Clearance Mitigation W of E River 70,000 - - - - 70,000 35 Fiber Replacement Silver Lake 70,000 - - - - 70,000 36 DMC - BRT Route Corridor 400,000 - - - - 400,000 37 DMC - BRT West Transit Village 100,000 - - - - 100,000 38 Grid North Partners-N Roch 345kV Line 432,000 1,855,000 12,000,000 9,000,000 8,000,000 31,287,000 39 New Mayo Feeders 1,300,000 - - - - 1,300,000 40 65th St - 50th to 60th Ave 400,000 - - - - 400,000 41 Westside Subst Expansion - - 5,000,000 - - 5,000,000 42 55th St NW Fdr W of 60th Ave - - 250,000 250,000 - 500,000 43 20th St SW - 1st Ave to Mayowood Rd - - 200,000 300,000 - 500,000 44 Eastwood Rd - Marion to Harbor Dr - - - 100,000 900,000 1,000,000 45 13th & 14th St NW - 11th Ave to Broadway - - - - 300,000 300,000 46 25th St SW - - - - 1,000,000 1,000,000 47 11th Ave E - 4th St SE to Silver Creek Bridge - - 150,000 150,000 - 300,000 48 Feeder 306 Install - - - 250,000 250,000 500,000 49 Feeder 615 Install - 400,000 300,000 - - 700,000 50 Feeder 913 Install - - 350,000 350,000 - 700,000 51 Feeder 914 Install - - - 600,000 200,000 800,000 52 Feeder 1315 Install - - 350,000 350,000 - 700,000 53 Feeder 1602 Install - - 300,000 500,000 - 800,000 54 Feeder 1914 Install - 1,100,000 1,000,000 - - 2,100,000 55 Downtown New Duct Systems - 1,272,727 1,272,727 1,909,091 2,545,455 7,000,000 56 Q2 Rebuild from Bear Creek - RCTC - - 300,000 500,000 - 800,000 57 Q4 Rebuild from BV Sub to Salem Rd - 300,000 700,000 - - 1,000,000 58 Q7 Rebuild to Grade B - - 200,000 300,000 700,000 1,200,000 59 Volt/VAR Optimization - - - 100,000 100,000 200,000 60 Capacitor Control Replacement (10/yr) - - - 150,000 150,000 300,000 61 Fiber - Marion to Cty PW/St Bridget Twr to WC - 300,000 - - - 300,000 62 EV Bus Charging Expansion - 100,000 100,000 400,000 - 600,000 63 50th Ave NW - 19th St to Valleyhigh - - 800,000 1,500,000 - 2,300,000 64 Eastwood Rd SE - - - 700,000 - 700,000 65 TH 14E and S Broadway Intersection - 350,000 - - - 350,000 66 Feeder Extension 50th Ave - S of 50th St NW 170,000 70,000 50,000 50,000 - - 170,000 67 E Center Street 650,000 100,000 550,000 - - - 650,000 68 18th Ave SW - Mayowood to 40th 1,175,000 75,000 550,000 550,000 - - 1,175,000 Rochester Public Utilities Electric Utility 2025 - 2029 Capital Improvement Plan Section 2 - Page 2

Multi-Year Project Total 2025 2026 2027 2028 2029 5-Yr Total Rochester Public Utilities Electric Utility 2025 - 2029 Capital Improvement Plan 69 DMC - South Broadway from 4th St to 9th St - 50,000 200,000 200,000 - 450,000 70 Replace 161kV Disconnect Switches 535,000 90,000 100,000 110,000 115,000 120,000 535,000 71 Replace 20kA, 161kV Circuit Breakers - 200,000 205,000 210,000 220,000 835,000 72 Kemps Metering Repl & 406 Reconfiguration 115,000 - - - - 115,000 73 Bamber Valley Sub Capacitor Bank - - - 225,000 - 225,000 74 NE Substation - - 300,000 1,500,000 2,500,000 4,300,000 75 Allocation - Distribution Expansion 2,565,814 2,642,788 2,722,072 2,803,734 2,887,846 13,622,254 76 Feeder Extensions 117,656 125,000 140,000 150,000 170,000 702,656 77 Feeder Rebuilds 113,131 130,000 140,000 150,000 160,000 693,131 78 Transmission Projects 45,253 48,000 50,000 55,000 58,000 256,253 79 Substation Projects 185,535 200,000 210,000 225,000 240,000 1,060,535 80 Road Projects 135,757 140,000 160,000 180,000 200,000 815,757 81 Road Projects - DMC 95,030 100,000 110,000 120,000 130,000 555,030 82 Manhole Switch Replacements 99,555 105,000 110,000 115,000 120,000 549,555 83 Cable Replacement 226,262 250,000 260,000 275,000 300,000 1,311,262 84 Manhole Repair/Replace 248,889 275,000 280,000 290,000 300,000 1,393,889 85 Distribution Transformers 859,797 777,788 732,072 681,734 614,846 3,666,237 86 Overhead to Underground Conversion 316,767 360,000 380,000 400,000 420,000 1,876,767 87 Pole Replacements 54,303 57,000 60,000 62,000 65,000 298,303 88 Upgrades Due to Electrification 67,879 75,000 90,000 100,000 110,000 442,879 89 GIS Utility Network Implementation 150,000 - - - - 150,000 90 Designer XI Implementation - 500,000 - - - 500,000 91 Dual Sensor Drone - - - 15,000 - 15,000 92 Survey GPS Replacement - - - - 30,000 30,000 93 Fiber Manager Replacement - 80,000 - - - 80,000 94 AMI OMS Integration - - 100,000 - - 100,000 95 OMS Replacement - - 825,000 - - 825,000 96 Small Drone Replacement 15,000 12,500 - - - 27,500 97 Impervious Data Acquisition - 25,000 - - - 25,000 98 Service Territory Payments 385,832 426,999 488,610 572,627 682,195 2,556,263 99 Service Territory Payments - SMMPA Reimbursement (191,675) (211,437) (241,364) (282,397) (336,052) (1,262,925) 100 Total Core Services 23,149,710 15,174,964 20,647,247 33,723,856 26,251,891 24,195,029 119,992,987 101 Customer Relations 102 DSM Rebate Software - - 30,000 - - 30,000 103 DSM Rebate Software Subscription - - 825,000 - - 825,000 104 Customer Portal Replacement 100,000 - - - - 100,000 105 Add't Kiosk Locations - - 41,400 - - 41,400 106 Phone Tech Upgrade - 85,000 - - - 85,000 107 Customer Portal Subscription - 515,000 - - - 515,000 108 Total Customer Relations - 100,000 600,000 896,400 - - 1,596,400 109 Compliance & Public Affairs 110 AED's 50,000 - - - - 50,000 111 Total Compliance & Public Affairs - 50,000 - - - - 50,000 112 Corporate Services 113 SAP ERP/HCM - 750,000 1,800,000 1,050,000 - 3,600,000 114 Work Management Solution - - 700,000 - - 700,000 115 Vena Subscription 343,575 - - - - 343,575 116 SAP ERP Subscription - 3,350,605 - - - 3,350,605 117 Racking Replacement in Stockyard - 2024 20,000 20,000 20,000 20,000 20,000 100,000 118 Business Intelligence/Reporting 45,000 45,000 45,000 45,000 45,000 225,000 119 PRI to SIP - 40,000 - - - 40,000 120 SCADA Upgrade - 150,000 - - - 150,000 121 Community Room Tech Refresh 100,000 - - - - 100,000 122 Teams Conference Room 50,000 - - - - 50,000 123 Data Analytics Subscription 16,000 50,000 - - - 66,000 124 Data Analytics License Purchase - - 350,000 - - 350,000 125 Allocation - Technology 806,000 821,000 691,000 601,000 586,000 3,505,000 126 Network Management 406,000 211,000 251,000 191,000 266,000 1,325,000 127 Server Management - 210,000 210,000 210,000 120,000 750,000 128 Operation Technology 400,000 400,000 230,000 200,000 200,000 1,430,000 129 Total Corporate Services - 1,380,575 5,226,605 3,606,000 1,716,000 651,000 12,580,180 130 Power Resources 131 Lake Zumbro Hydro Controls Upgrade - - - - - - 131 Firm Dispatchable Generation 120,000,000 12,000,000 24,000,000 24,000,000 48,000,000 12,000,000 120,000,000 132 Solar - 10,000,000 10,000,000 50,000,000 30,000,000 100,000,000 133 Storage - 20,000,000 90,000,000 80,000,000 10,000,000 200,000,000 134 2030 RESOURCE PLAN 2,000,000 - - - - - - 134 Allocation - Power Resources 100,000 125,000 250,000 200,000 600,000 1,275,000 Section 2 - Page 3

Multi-Year Project Total 2025 2026 2027 2028 2029 5-Yr Total Rochester Public Utilities Electric Utility 2025 - 2029 Capital Improvement Plan 135 Allocation - Fleet 821,320 851,179 993,142 1,007,518 764,324 4,437,483 136 UPS #3 Main Replacement - BUCC 75,600 - - - - 75,600 137 Mezzanine T&D Clean Room - 69,000 - - - 69,000 138 Stock Yard Concrete - 158,400 - - - 158,400 139 Culverts at SE Section - 182,400 - - - 182,400 140 Replace EV Charger - - 180,000 - - 180,000 141 BUCC CRAC Unit Replacement - - 66,000 - - 66,000 142 UPS Charger Unit #4 - - 79,200 - - 79,200 143 SCADA CRAC Unit Replacement - - - 78,000 - 78,000 144 Warehouse Window Replacements - - - 297,000 - 297,000 145 Concrete NE Section Phase 1 - - - 198,000 - 198,000 146 Substation HVAC Syst Phase 1 - - - 168,000 - 168,000 147 Concrete NE Section Phase 2 - - - - 198,000 198,000 148 Substation HVAC Syst Phase 2 - - - - 120,000 120,000 149 Allocation - Facilities 30,000 30,000 30,000 30,000 30,000 150,000 150 Total Power Resources 122,000,000 13,026,920 55,415,979 125,598,342 179,978,518 53,712,324 427,732,083 151 General Management 152 Mayo Bold Forward Unbound Contigency 1,000,000 - - - - 1,000,000 153 Project Contingency Fund 800,000 800,000 800,000 800,000 800,000 4,000,000 154 Total General Management - 1,800,000 800,000 800,000 800,000 800,000 5,000,000 155 Total External Expenditures 145,149,710 31,532,459 82,689,831 164,624,598 208,746,409 79,358,353 566,951,650 156 Less: Bonding (12,432,000) (55,855,000) (141,000,000) (187,000,000) (60,000,000) (456,287,000) 157 Less: Non-cash Subscription Assets (276,075) (3,156,230) (660,000) - - (4,092,305) 158 Less: Contributions in Aid of Construction (3,395,000) (624,350) (615,081) (631,295) (647,974) (5,913,700) 159 Net Capital External Expenditures (Rate Funded) 145,149,710 15,429,384 23,054,251 22,349,518 21,115,113 18,710,379 100,658,645 160 Total Internal Expenditures (Capital Labor) 9,087,157 8,985,857 10,842,013 10,608,476 7,251,754 46,775,257 161 Net Capital Expenditures 145,149,710 24,516,541 32,040,108 33,191,530 31,723,589 25,962,133 147,433,902 Section 2 - Page 4

(This Page is Left Blank Intentionally)

(This Page is Left Blank Intentionally)

(This Page is Left Blank Intentionally)

(This Page is Left Blank Intentionally)

(This Page is Left Blank Intentionally)

(This Page is Left Blank Intentionally)

(This Page is Left Blank Intentionally)

RkJQdWJsaXNoZXIy NTk0MTg2