Shawano Municipal Utilities Commission

SPECIAL SHAWANO MUNICIPAL UTILITIES COMMISSION AGENDA TUESDAY, OCTOBER 15, 2024 4:00 PM SHAWANO MUNICIPAL UTILITIES BUILDING, 122 N. SAWYER STREET, SHAWANO, WI I. CALL TO ORDER II. PLEDGE OF ALLEGIANCE III. ROLL CALL IV. 2025 BUDGET - Possible Approval Requested V. EQUIPMENT PURCHASE - Approval Requested VI. ADJOURNMENT DISABLED ACCESSIBLE (Contact City Clerk prior to meeting if require additional services.) It is possible that members of and possibly a quorum of members of other governmental bodies of the municipality may be in attendance at the above-stated meeting to gather information; no action will be taken by any governmental body at the above-stated meeting other than the governmental body specifically referred to above in this notice. Page 1 of 40  SHA MUNICIPAL UTILITIES 0 2025 DRAFT BUDGET Page 2 of 40  Shawano Municipal Utilities 2025 Budget Table of Contents Operating Summaries: Rate of Return ..................................................................................................... SMU Operating Budget Summary ...... Electric Budget ............................. ... Technology Budget. Construction Budget ............................................................................................... Page 3 of 40  Shawano Municipal Utilities Rate of Return Electric - Excludes Contributed Estimated Prelim Budget Year Ended Year Ended Year Ended Year Ended Average Rate Base 12/31/2022 12/31/2023 12/31/2024 12/31/2025 Add Average: UtilityPlant in Service ‘ $ 27,267,972 $ 27,637,816 $ 41,872,597 $ 42,268,713 Material & Supplies 493,876 566,671 608,962 627,231 27,761,848 28,204,487 42,481,559 42,895,944 Less Average: Customer Advances Construction (49,032) (55,764) (63,404) (72,090) Regulatory Liability (29,250) (9,750) ~ - Reserve for Depreciation (13,581,386) (13,950,564) (15,337,783) (16,847,004) (13,659,668) (14,016,078) (15,401,187) (16,919,094) Average Net Rate Base 14,102,180 14,188,409 27,080,372 25,976,849 Net Operating income (Loss) :5 390,932 $ 267,299 $ 102,197 $ 1,366,798 Rate of Return 2.77% 1.88% 0.38% 5.26% Operating Inc/Avg Net Rate Base Authorized Rate of Return 5.00% 5.00% 5.00% 6.20% Variance -2.23% —3.12% -4.62% 094% Notes: Estimated 2025 ROR for pending rate case Page 4 of 40  Shawano Municipal Utilities 2025 Operating Budget Summary Proposed 2022 2023 2024 2025 Increase % Electric Department Actual Actual Budget Budget (Decrease) Change Operating Revenues $ 23,691,182 $ 24,932,189 $ 25,710,634 $ 26,603,513 $ 892,879 3.5% Other Revenues 329,162 1,216,689 665,107 440,431 (224,676) -33.8% Total Revenues 24,020,344 26,148,878 26,375,741 27,043,944 668,203 2.5% Purchased Power 19,594,943 20,609,579 21,365,041 20,517,252 (847,789) -4.0% Operating & Maintenance Expenses 2,095,003 2,530,896 2,474,301 2,588,128 113,827 4.6% Depreciation & Amortization Expense 1,018,509 957,938 1,195,000 1,305,225 110,225 92% Taxes 712,931 718,006 858,178 965,570 107,392 12.5% Other Expenses 275,787 666,897 978,948 754,173 (224,775) 23.0% Total Expenses 23,697,173 25,483,316 26,871,468 26,130,348 (741,120) —2.8% Net income (Loss) 8 323,171 $ 665,562 $ (495,727) $ 913,596 $ 1,409,323 284.3% Technology Department Total Revenues $ 324,779 $ 380,835 $ 416,211 $ 438,513 $ 22,302 5.4% Purchased Services 28,799 29,074 34,660 25,974 (8,686) —25.1% Operating & Maintenance Expenses 163,459 188,893 218,726 208,344 (10,382) -4.7% Depreciation & Amortization Expense 59,030 59,198 57,691 61,464 3,773 6.5% ~ - — Taxes 0.0% Total Expenses 251,288 277,165 311,077 295,782 (15,295) —4.9% Net Income (Loss) 73,491 103,670 105,134 142,731 37,597 35.8% — Appropriation to Municipality (108,000) (108,000) (108,000) (108,000) 00% Retained Earnings Increase (Decrease) $ (34,509) $ (4,330) $ (2,866) $ 34,731 $ 37,597 35.8% Total Utility Total Revenues $ 24,345,123 $ 26,529,713 $ 26,791,952 $ 27,482,457 $ 690,505 2.6% Purchase Power& Sen/ice Expenses 19,623,742 20,638,653 21,399,701 20,543,226 (856,475) —4.0% Operating & Maintenance Expenses 2,258,462 2,719,789 2,693,027 2,796,472 103,445 3.8% Depreciation & Amortization Expense 1,077,539 1,017,136 1,252,691 1,366,689 113,998 9.1% Taxes 712,931 718,006 858,178 965,570 107,392 12.5% Other Expenses 275,787 666,897 978,948 754,173 (224,775) 23.0% — Earnings (Loss) Appropriation Net income Retained to increase (Decrease) Municipality $ 396,662 (108,000) 288,662 $ 769,232 (108,000) $ 661,232 (498,593) (390,593) (108,000) $ 948,327 1,056,327 (108,000) $ 1,446,920 370.4% 290.2% 0.0% Page 5 of 40  Shawano Municipal Utllltles 10/2/2024 - Electrlc Budget 2025 PRELIMINARY Actual Actual Budget Projected Budget % 2022 2023 2024 2024 Adjust 2025 Inc(Dec) Sales of Power Residential Revenues RG1, R62 4,050,910 4,203,034 4,321,065 4,189,878 301,671 4,491,549 7.2% General Service Revenues GS1 1,274,372 1,310,262 1,356,374 1,328,327 95,640 1,423,967 7.2% Large General Service Revenues G5 1,719,761 1,760,294 1,822,330 1,753,489 126,521 1,880,010 7.2% Small Power CP1 888,343 863,239 942,286 767,397 55,253 822,650 7.2% Large Power CP2 2,886,946 2,908,997 3,104,871 2,810,126 202,329 3,012,455 7.2% Industrial Power TOD CP3 7,018,386 7,194,336 7,368,817 7,353,808 529,474 7,883,282 7.2% Large IndustrialTOD CP4 5,569,942 6,400,964 6,503,472 6,311,786 454,449 6,766,235 7.2% Field LightingRevenues FL1 59,371 60,159 61,242 65,713 4,731 70,444 7.2% Street Lighting Revenues M81 223,151 230,904 230,177 235,934 16,987 252,921 7.2% Total Power Sales Revenue 23,691,182 24,932,189 25,710,634 24,816,458 1,787,055 26,603,513 7.2% Purchased Power Expense 19,594,943 20,609,579 21,365,041 20,217,494 299,758 20,517,252 1.5% GROSS PROFIT ON SALES 4,096,239 4,322,610 4,345,593 4,598,963 1,487,297 6,086,260 32.3% Other Operating Revenues Customer Discounts Forfeited 30,445 44,881 45,500 38,051 761 38,812 20% Rent Electric Property 73,601 90,596 91,387 82,061 1,641 83,702 2.0% Other Revenues 17,091 16,053 16,294 16,612 332 16,944 2.0% Total Other Operating Revenues 121,136 151,530 153,181 138,724 2,734 139,459 2.0% Other Operating 6 Maintenance Expenses Supervision Expense 67,509 69,323 79,764 69,653 3,562 73,215 5.1% Station Expense 69,091 70,857 69,283 72,400 3,314 75,714 4.6% Overhead Line Expense 169,513 173,190 190,991 217,478 (11) 217,466 0.0% Underground Line Expense 60,158 87,480 77,465 76,477 3,897 80,374 51% Street Lighting 8,212 10,312 9,622 8,815 20 8,835 0.2% Meter Expense 67,186 70,321 63,308 90,693 (1,191) 89,502 4.3% Customer Installations 329 1,274 1,537 1,172 (46) 1,126 -3.9% MiscDistributionExpenses 263,040 310,620 269,785 322,555 7,026 329,580 2.2% Rents 1,950 42,222 48,805 35,565 (31,900) 3,684 —89.6% Distribution Operation Exp (580-5t 706,989 835,599 810,560 894,827 (15,331) 879,496 —1.7% - 3.2% Maintenance Supervision & Engine 31,753 32,564 37,504 32,779 1,048 33,827 - Maintenance Station Equipment 861 15,672 7,783 5,719 (85) 5,634 -1.5% - Maintenance Overhead Lines 47,112 97,529 67,184 130,858 859 131,717 0.7% Maintenance - Underground Lines 24,450 34,372 33,059 28,509 1,647 30,156 5.8% — Maintenance Line Transi 12,297 11,606 13,905 15,899 400 16,300 2.5% - Maintenance Street nghts 1,600 21,534 4,306 17,434 705 18,139 40% — 150 531 Maintenance Meters 125 147 452 79 17.4% Distribution Maintenance Exp (59!) 118,198 213,424 163,891 231,650 4,654 236,304 2.0% Total Dlstrlbutlon 08M Expense 825,187 1,049,023 974,451 1,126,477 (10,677) 1,115,799 09% Meter Reading Expenses 36,916 38,776 39,339 39,304 208 39,513 0.5% Billing Expenses 189,339 199,776 202,180 202,698 5,145 207,843 2.5% UncolleciibleAccounts 5,028 19,511 3,443 3,717 74 3,791 2.0% -— - Advertising Insurance Office Administrative Outside Sales Admin Expenses Supplies Expenses Services Transferred (911-916) Expenses Property Liability &&General Worker's Medical Salaries Compensation 30,903 69,489 292,537 (208,525) 9,566 15,545 10,731 35,919 385,771 For Administrative 94,626 10,616 (220,783) 15,141 17,228 31,879 78,092 304,542 484,926 Use Only (245,726) 32,836 9,500 18,089 15,746 70,160 46,033 429,750 478,544 32,494 13,773 10,860 10,325 38,196 66,927 502,098 397,106 (230,299) 15,689 434 243 764 305 5,450 3,564 6,250 (22,126) 38,960 (252,425) 403,356 507,548 32,737 70,491 29,462 10,630 11,294 1.6% 113.9% 9.6% 3.0% 2.0% 4.0% 0.7% 5.3% 30% 1.1% Page 6 of 40  Shawano Municipal Utilities 10/2l2024 ~ Electric Budget 2025 PRELIMINARY Actual Actual Budget Projected Budget % 2022 2023 2024 2024 Adjust 2025 Inc(Dec) Pension 95,025 115,617 123,312 125,561 2,109 127,670 1.7% - insurance Life 2,706 3,348 3,027 3,855 77 3,932 2.0% School Expense 50,931 45,377 53,232 37,048 914 37,962 2.5% Miscellaneous Employee Benefit 20,570 71,948 27,793 33,861 677 34,538 20% Regulatory Commission Expense 80,686 28,903 73,318 63,637 (34,734) 28,903 54.6% Miscellaneous General Expense 29,614 47,324 40,614 52,488 3,573 56,061 6.8% - Maintenance General Plant 115,065 95,026 74,132 5,931 80,063 8.0% 78,660 Administrative 8 General Expense 1,028,966 1,213,194 1,245,388 1,221,736 (11,185) 1,210,551 09% Total Admin & Sales Expenses 1,269,816 1,481,873 1,499,850 1,477,780 (5,453) 1,472,327 —0.4% Total Admin and Dist 08M Expens 2,095,003 2,530,896 2,474,301 2,604,256 (16,130) 2,588,126 -0.6% Depreciation 8. Amortization (4034 1,018,509 957,938 1,195,000 1,206,636 98,589 1,305,225 8.2% Taxes (403) 712,931 718,006 858,178 822,598 142,972 965,570 17.4% Total Operating Expenses 3,826,443 4,206,840 4,527,479 4,633,490 225,431 4,858,921 0 Net Operating Income (Loss) 390,933 267,300 (28,705) 102,197 1,264,600 1,366,798 0 Non-Operating Income Non-UtilityOperating 2,767 10,765 10,765 39,347 (25,610) 13,737 —65.1% Jobbing Income 122,758 34,487 98,691 58,087 58,087 0.0% Misc Electric Contr Funds 55,452 48,355 16,284 20,217 20,217 0.0% — — — Misc Credits to Surplus 688,633 0.0% Interest & Dividend income 21,843 273,233 376,500 352,416 (143,484) 208,932 -40.7% Change in value of Investment 5,206 9,686 9,686 - - 0.0% Total Non-Operating Income 208,026 1,065,159 511,926 470,066 (169,094) 300,972 -36.0% Non-Operating Expenses — - Contributed Plant Amortization (19,501) (19,501) 0.0% Contributed Plant Deprec Exp 34,434 47,220 35,358 36,284 36,284 0.0% Lobbying Cost 4,459 4,512 4,512 4,645 4,645 0.0% Interest Revenue Bond 208,047 869,566 752,857 (107,481) 645,376 44.3% ~ ~ Bond Debt Expense 355,293 0.0% Amort of Debt Premium - (880) (880) (880) 0.0% Jobbing Expense 68,096 44,363 54,716 47,385 47,385 0.0% Misc Interest Expense 263 4,019 4,140 4,012 4,012 0.0% Misc Debits Surplus 180,989 - - - 0.0% Approp. of funds to Municipality 7,047 22,944 11,536 17,351 17,351 0.0% Total Non-Operating Expense 275,787 666,897 978,948 861,654 (107,481) 754,173 42.5% NET INCOME l (LOSS) $ 323,171 665,562 $ (495,727) $ (289,391) $ 1,202,987 $ 913,596 415.7% For AdminislrntiveUse Only Page 7 of 40  Shawano Municipal Utilities 9/25/2024 2025 Operating Budget - PRELIMINAR) Technology Department Actual Actual Budget Projected Budget 2022 2023 2024 2024 Adjust 2025 Operating Revenues Fiber Optic Revenue 211.671 196,016 208,842 210,825 (3,745) 207,080 ~ IT Services Software & Licenses 25,281 24,722 35,846 35,846 7,098 42,944 - IT Services Hardware 40,674 49,868 47,786 (1.112) 49,330 50.442 — 40,022 103,000 115,500 118,776 12,145 130,921 IT Servlces Services - — IT Sen/ices Network Hardware 7,131 7,230 8.237 8,237 8,237 Total Operating Revenues 324,779 380,835 416,211 424,125 14,387 438,513 Operating Expenses Purchased Internet Services 28,799 29,074 34,660 25,465 509 25,974 IT Purchases - Software & Licensir 27,823 40,937 40,862 44,791 (2,500) 42,291 - IT Purchases Hardware 23,044 22,588 542 27,629 40.200 27.087 - IT Purchases Network 2,987 5,504 5,880 50 2,544 2.494 IT Purchases - Support Services 64,741 71,270 75,000 68,600 10,506 79,106 Supervision Expense 303 ~ - Station Expense Overhead Line Expense 1.547 142 142 833 (154) 679 — Underground Line Expense 1,440 70 1.080 452 452 Misc DistributionExpenses 419 370 24 394 Rents 6,687 8,482 6,676 8,493 170 8.663 Office Supplies & Expense 1,236 424 936 1,173 23 1,197 Property Insurance 825 718 750 690 47 737 Fringe Benefit Expense 32,502 35,903 40,500 34,917 6.814 41.731 5,000 - School Expense Miscellaneous General Expense 211 1.438 725 733 15 748 — Maintenance General Plant 416 697 975 2,130 43 2,173 Total Operating Expenses 192,258 217,968 253.386 217,777 16,541 234,318 Depreciation & Amortization 59,030 59,198 57,691 61,464 61,464 Total Expenses 251.288 277,166 311,077 279,241 16,541 295,782 Net Operating Income 73,491 103,670 105,134 144.884 (2.153) 142,731 Other Expenses Appropriation of Income to Municip 108,000 108,000 108,000 108,000 108,000 — Total Other Expenses 108.000 108,000 108,000 108,000 108,000 Net Income (Loss) $ (34,509) (4,330) (2.866) $ 36,884 $ (2,153) $ 34,731 Page 8 of 40 For AdminlstrationUse Only  SHAWANO MUNICIPALUTILITIES 10—7—2024 2025 CONSTRUCTION BUDGET BUDGET Electric Budget 2024 FINANCINGSOURCE & PROJECT NAME Budget OPERATIONS OUTSIDE ~ O~25~O1 OMS (Outage Management System) License Open Point $ 25,000 02502 Demolition of 125 N Andrews St 30,000 — Sub-total $ 55,000 E—25-01 Tools & Safety $ 30,000 $ 30,000 E—25-02 Transformer Purchase 150,000 145,000 E-25-03 Work Orders: 1000.1002, 1006.1010, 1015 250,000 265,000 E~25~04 Electric Meter Purchase 20,000 48,000 E~25~05 Vehicle & Equipment Purchase 235,000 235,000 E-24~06 Engel Drive 600 A Loop 340,000 133,258 E-24-07 Pole Replacement 75,000 75,000 E—24—08 OH to URD Conversions 75,000 E—24—08Aarrowcast Upgrades 100,000 100,000 E—24—09 Cutout Replacements 140,000 140,000 E-24—10 New Building Equipment 150,000 50,000 Sub~total $ 1,558,000 133,258 Electric Sources and Uses of Funds Net Income (Add Back Bond Interest) $ 1,558,972 Bond Payments (875,376) Depreciation Expense 1,305,225 Less: 2025 Capital Projects (1,424,742) Total Sources Remaining $ 564,079 Carried Over from Previous Budgets - 9/30/2023 8/31/2024 Difference Cash on Hand $ 4,643,345 $ 4,235,145 (408,200) Technology Budget lT-24-01 Fiber Cable Replacements/Additions 30,000 $ 30,000 IT—24-02 Fiber Hub Upgrades 5,000 5,000 , $ 35,000 TechnologLSources and Uses of Funds Net Operating Income $ 142,731 Depreciation Expense 61,454 Less: 2025 Capital Projects (35,000) 2011 Bond Payments in 2025 (108,000) Cash Reserved for Funds (Soft, Hard, Network) (29,773) Page 9 of 40 Cash Cash Administrative Hand For ononHand Reserved General Only Use $3 231,561 9/30/2023 111,951 97,004 $8/31/2023 128,404 Difference (134,557) 16.453  SHA MUNICIPAL UTILITIES 0 2025 OFFICE BUDGET Page 10 of 40  Year Ended December 31, 2025 Project No. 0-25-01 NAME OF PROJECT: OMS License for Open Point DEPARTMENT Of?ce Work to be performed by: SMU PERSONNEL LOCATION SMU Building CONTRACTOR DESCRIPTION OF PROJECT AND REASONS WHY PROJECT IS REQUIRED: NET CONSTRUCTION EXPENDITURE $ 25,000.00 MAN HOURS REQUIRED NEW CONSTRUCTION Esllmaled by: R Koepp REMOVAL 8/28/2024 TOTAL PROJECT Page 1 Page 11 of 40  NAMEOF PROJECT: OMS License for Open Point Year Ended December 81, Project No. 0-25—01 NET CONSTRUCTION EXPENDITURE: DETAIL OF‘ESTIMATED QUANTITY MEASURE DESCRIPTION OMS License TOTAL DIRECT COSTS $ 25,000.00 % P 8. W ON 5 % CONTINGENCIES 0N S % CONTINGENCIES ON 5 REMOVAL COST SUBTOTAL 25,000.00 SALVAGE (Subtract) = Page 12 of 40 Page 2  Year Ended December 31, 2025 Project No. 0-25-02 NAME OF PROJECT: DemoIitionof 125 N Andrews Street DEPARTMENT Of?ce Work to be pe?ormad by: SMU PERSONNEL LOCATION SMU Building CONTRACTOR DESCRIPTION OF PROJECT AND REASONS WHYPROJECT IS REQUIRED: II1 NET CONSTRUCTION EXPENDITURE 3? 30,000.00 MAN HOURS REQUIRED NEW CONSTRUCTION Estimated by: R Koepp REMOVAL 8/2024 TOTAL PROJECT Page 3 Page 13 of 40  NAME OF PROJECT: Demolition of 125 N Andrews Street Year Ended December 31, Project No. 0-25-02 DETAIL OF ESTIMATED NET CONSTRUCTION EXPENDITURE: QUANTITY MEASURE DESCRIPTION COST EACH TOTAL COST Costs DEInolition TOTAL DIRECT COSTS 5 w % P 8| W ON $— % CONTINGENCIES ON $ % CONTINGENCIESON $ REMOVAL COST SUBTOTAL 30,000.00 SALVAGE Page 14 of 40 Page 4  SHA MUNICIPAL UTILITIES 0 2025 ELECTRIC BUDGET Page 15 of 40  Year Ended December 31, 2025 Project No. E—25-01 NAMEOF PROJECT: TOOLS & SAFETY EQUIPMENT DEPARTMENT ELECTRIC Work to be performed by: SMU PERSONNEL LOCATION CITY CONTRACTOR DESCRIPTION OF PROJECT AND REASONS WHY PROJECT IS REQUIRED: ' J 9921‘ baggie NET CONSTRUCTION EXPENDITURE $ 30,000.00 MAN HOURS REQUIRED NEW CONSTRUCTION Estimated by: R. KOEPP REMOVAL CONSTRUCTION TOTAL Date: 08/23/24 Page 16 of 40 Page 1  NAME OF PROJECT: TOOLS & SAFETY EQUIPMENT Year Ended December 31, 2025 Project No. E-25-01 DETAILOF ESTIMATED NET CONSTRUCTION EXPENDITURE: QUANTITY MEASURE DESCRIPTION COST EACH TOTAL COST ..I9. TOTAL DIRECT COSTS s 30,000.00 % P 8. W ON 5 % CONTINGENCIES ON $ "/oCONTINGENCIES 0N $ REMOVAL COST SU BTOTAL 30,000.00 Page 17 of 40 Page 2  Year Ended December 31, 2025 Project NO. E—25—02 NAMEOF PROJECT: TRANSFORMER PURCHASE DEPARTMENT ELECTRIC Work to he performed by: SMU PERSONNEL X ’ LOCATION CITY CONTRACTOR DESCRIPTION OF PROJECT AND REASONS WHY PROJECT IS REQUIRED: I tREI?Q.§ZSR§HEI.IIHI§§.?f? NET CONSTRUCTION EXPENDITURE $ 145,000.00 MANHOURS REQUIRED NEW CONSTRUCTION TOTAL REMOVAL MAINTENANCE PROJECT CONSTRUCTION TOTAL Esllmaled by: Page 3 Date: 03/23/24 R. KOEPP Page 18 of 40  NAMEOF PROJECT: TRANSFORMER PURCHASE Year Ended December 31, 2025 Project No. 525-02 DETAIL OF ESTIMATED NET CONSTRUCTION EXPENDITURE: QUANTITY MEASURE DESCRIPTION COST EACH TOTAL COST ”WSW" .......................................... 25 kva sin le hase 240/120 volt ole mount 75 kva, singlephase, 240/120 volt padmount 45 kva three phase 4800/240 volt padmounl 1500000 15000000: three hase 208Yl120vo|t admount TOTAL DIRECT COSTS s 145,000.00 % P & W ON 5 " % CONTINGENCIES Page 4 SALVAGE SUBTOTAL $ REMOVAL ON NET COST (Subtract) cousmucnon 3 145,000.00 145,000.00 Page 19 of 40 5552030055  Year Ended December 31, 2025 Project No. E—25-03 NAME OF PROJECT: WO'S: 1000, 1002, 1006, 1010.1015, PTIEXI.,and EqquA Moves DEPARTMENT ELECTRIC Work (0 he performed by: SMU PERSONNEL LOCATION CITY CONTRACTOR DESCRIPTION OF PROJECT ANDREASONS WHYPROJECT IS REQUIRED: costs for an rima extensions The bud eted amounts are based on a 5 ear avera e 20192023 NET CONSTRUCTION EXPENDITURE $ 265,000.00 CONSTRUCTIONTOTAL REMOVAL TOTAL MAINTENANCE PROJECT NEWCONSTRUCTION Es?mated by: Page 5 Date: R. KOEPP 08/22/24 Page 20 of 40  NAME OF PROJECT: WO's: 1000,1002,1006,1010,1015,Pri Ext, and Equip. Moves Year Ended December 31, 2025 Project No. E'25‘03 DETAIL 0F ESTIMATED NET CONSTRUCTION EXPENDITURE: QUANTITY MEASURE DESCRIPTION COST EACH TOTAL COST 16 900.00,: TOTAL DIRECT COSTS $ 265,000.00 % CONTINGENCIES Page 6 0N REMOVAL ON NET$ SUBTOTAL SALVAGE COST (Subtract) , CONSTRUCTIONEXPENDITURE $ Page 21 of 40 265,000.00 265,000.00  Year Ended December 31, 2025 Project No. E-25-O4 NAME OF PROJECT: Electric Meter Purchase DEPARTMENT ELECTRIC Work to be pertormed by: SMU PERSONNEL LOCATION CITY CONTRACTOR DESCRIPTION OF PROJECT AND REASONS WHY PROJECT IS REQUIRED: .Ih' haggt' If th h it T to be replaced with a newer version of the existingmeter that allows for better outage management Inthe future. interrupted. NET CONSTRUCTION EXPENDITURE $ 48,000.00 MAN HOURS REQUIRED NEW CONSTRUCTION Estimated by: R. KOEPP REMOVAL CONSTRUCTION TOTAL Date: 08/23/24 Page 22 of 40 Page 7  NAME OF PROJECT: Electric Meter Purchase Year Emlod December 31, 2025 Project No. E-25-04 DETAIL OF ESTIMATED NET CONSTRUCTION EXPENDITURE: QUANTITV MEASURE DESCRIPTION COST EACH TOTAL COST Sin 16 Phase 200 A Electric Meter w/ Disconnect TOTAL DIRECT COSTS S 48,000.00 "/oF 8- W ON 3 % CONTINGENCIES ON 5 % CONTINGENCIES ON 5 REMOVAL COST SUBTOTAL 48,000.00 Page 23 of 40 Page 8  Year Ended December 31, 2025 Project No. E-25~05 NAMEOF PROJECT; VEHICLE & EQUIPMENT PURCHASE DEPARTMENT ELECTRIC Work to be performed by: SMU PERSONNEL LOCATION CITY CONTRACTOR DESCRIPTION OF PROJECT AND REASONS WHYPROJECT Is REQUIRED: bqueI. ..Th..'.. IsforthepurchaseofvehIclesandmotorIzedeqUIpment............................................................................................... .......................... Expecteddeliveryis end of year 2025. SMU Vehicle Summary 231 37' Bucket Truck 2011 2025 221 MiniExcavator 2009 2029 $50 000 208 Bad e Caravan 2019 2034 Skid Street NET CONSTRUCTION EXPENDITURE 235,000.00 MANHOURS REQUIRED NEW TOTAL REMOVAL MAINTENANCE TOTAL CONSTRUCTION PROJECT CONSTRUCTION Estimated by: Page 9 Date: 08/28/24 R. KOEPP Page 24 of 40  NAME OF PROJECT: VEHICLE & EQUIPMENT PURCHASE Year Ended December 31, 2025 Project No. E»25-05 DETAIL 0F ESTIMATED NET CONSTRUCTION EXPENDITURE: QUANTITY MEASURE DESCRIPTION COST EACH TOTAL COST TOTAL DIRECT COSTS $ M “laP 8. W ON 5 % CONTINGENCIESON Page 10 SUBTOTAL SALVAGE NET$ REMOVAL COST (Subtract) EXPENDITURE $ CONSTRUCTION 235,000.00 235,000.00 Page 25 of 40  Year Ended December 31, 2025 Project No. E—25-06 NAME OF PROJECT: Engel Drive 600 A Loop DEPARTMENT ELECTRIC Work to be performed by: SMU PERSONNEL X LOCATION CITY CONTRACTOR DESCRIPTION OF PROJECT AND REASONS WHYPROJECT IS REQUIRED: line runningENValong EngeIDrive. The current 600 A line along Engel Drive ends at the Shawano County Work Relea: NET CONSTRUCTION EXPENDITURE $ 340,000‘00 REMOVAL NEW CONSTRUCTION TOTAL PROJECT MAINTENANCE CONSTRUCTION TOTAL Estimated by: Page 11Date: RTKOEPP 08/28/24 Page 26 of 40  NAMEOF PROJECT: Engel Drive 600 A Loop Year Ended December 31. 2025 Project No. E-25-06 DETAIL OF ESTIMATED NET CONSTRUCTION EXPENDITURE: QUANTITY MEASURE DESCRIPTION COST EACH TOTAL COST 25,350.00 150 000 00 150 000.00 _ TOTAL DIRECT COSTS $ 340,000.00 CONTINGENCIESON ”laCONTINGENCIES0N 10 % Page 12 SALVAGE REMOVAL NET$ COST (Sublract) CONSTRUCTIONEXPENDITURE SUBTOTAL340,000.00 .. 340,000.00 Page 27 of 40 s  Year Ended December 31, 2025 Project No. E-25-07 NAME OF PROJECT: Pole Replacement DEPARTMENT ELECTRIC Work to be performed by: SMU PERSONNEL LOCATION CITY CONTRACTOR DESCRIPTION OF PROJECT AND REASONS WHY PROJECT IS REQUIRED: This bud 6! Item includes Ihe re Iacemenl of 30 oles that were Iound to be in need of re Iacement durin the NET CONSTRUCTION EXPENDITURE $ 75,000.00 MAN HOURS REQUIRED NEW CONSTRUCTION Esllmaled by: R, KOEPP REMOVAL CONSTRUCTION TOTAL Date: 08/28/24 Page 28 of 40 Page 13  NAME OF PROJECT: Pole Replacement Year Ended Dncemhur 31, 2025 ProjecI No. E’25’07 DETAIL 0F ESTIMATED NET CONSTRUCTION EXPENDITURE: QUANTITY MEASURE DESCRIPTION COST EACH I TOTAL COST TOTAL DIRECT COSTS $ 75,000.00 % P 8: W ON S % CONTINGENCIES ON $ % CONTINGENCIES ON $ REMOVAL COST SUBTOTAL 75,000.00 Page 29 of 40 Page 14  Year Ended December 31, 2025 Project No. E—25-08 NAMEOF PROJECT: Aarrowcast Upgrades DEPARTMENT ELECTRIC Work to be performed by: SMU PERSONNEL LOCATION CITY CONTRACTOR DESCRIPTION OF PROJECT AND REASONS WHY PROJECT IS REQUIRED: This budget ilem cunsisls of upgradingIhe infrastructure serving Ihe Aarrowcasl 12 kV Subslalion NET CONSTRUCTION EXPENDITURE $ 100,000,00 MAN HOURS REQUIRED NEW CONSTRUCTION 160 Esllmaled by: R. KOEPP REMOVAL CONSTRUCTION TOTAL 160 Date: 08/28/24 Page 15 Page 30 of 40  NAMEOF PROJECT: Aarrowcast Upgrades Year Ended December 31, 2025 Project No. E-25«08 DETAIL 0F ESTIMATED NET CONSTRUCTION EXPENDITURE: QUANTITY MEASURE DESCRIPTION COST EACH TOTAL COST Aarrowcast Upgrades 100.000.00 TOTAL DIRECT COSTS S 100,000.00 "/nP a.W ON 5 % CONTINGENCIES 0N $ % CONTINGENCIES ON 5 REMOVAL COST SUBTOTAL 100,000.00 Page 31 of 40 Page 16  Year Ended December 31, 2025 Project No. E-25—09 NAME OF PROJECT: Cutout Replacements DEPARTMENT ELECTRIC Work to be performed by: smu PERSONNEL LOCATION CITY CONTRACTOR DESCRIPTION OF PROJECT AND REASONS WHY PROJECT IS REQUIRED: NET CONSTRUCTION EXPENDITURE $ 140,000.00 MAN HOURS REQUIRED NEW CONSTRUCTION Estlmated by: R. KOEPP REMOVAL CONSTRUCTION TOTAL I Date: 08/28/24 Page 32 of 40 Page 17  NAME OF PROJECT: Cutout Replacements Year Ended December 31, 2025 Project No. E'25'09 DETAIL 0F ESTIMATED NET CONSTRUCTION EXPENDITURE: QUANTITY MEASURE DESCRIPTION COST EACH TOTAL COST TOTAL DIRECT COSTS $ 100.000000 20 % P & w ON $ 10 % CONTINGENCIES 0N 5 % CONTINGENCIES ON $_— _— REMOVAL COST 40.000.00 SUBTOTAL 140,000.00 Page 18 NET Page 33 of 40  Year Ended December 31, 2025 Project No. E-25-10 NAMEOF PROJECT: New Building Equipment DEPARTMENT ELECTRIC Work (0 he periormed by: SMU PERSONNEL LOCATION CITY CONTRACTOR DESCRIPTION OF PROJECT AND REASONS WHY PROJECT IS REQUIRED: NET CONSTRUCTION EXPENDITURE $ 25,000.00 MAN HOURS REQUIRED NEw CONSTRUCTION Estimated by: R. KOEPP REMOVAL CONSTRUCTION TOTAL Date: 08/28/24 TOTAL PROJECT Page 19 Page 34 of 40  NAME OF PROJECT: New Building Equipment Year Ended December 31, 2025 Project No. 525-10 DETAIL 0F ESTIMATED NET CONSTRUCTION EXPENDITURE: QUANTITY MEASURE DESCRIPTION COST EACH TOTAL COST TOTAL DIRECT cOSTs 5 25,000.00 % P & w 0N s % CONTINGENCIES ON 3 % CONTINGENCIESON 5 REMOVAL COST SUBTOTAL 25,000.00 Page 20 $ Page 35 of 40  SHA MUNICIPAL UTILITIES 0 2025TECHNOLOGY BUDGET Page 36 of 40  Year Ended December 31, 2025 Project NO. IT-25-01 NAMEOF PROJECT: Fiber Cable Replacement/Additions DEPARTMENT Technology Work to be pe?ormed by: smu PERSONNEL LOCATION SMU Of?ce CONTRACTOR X DESCRIPTION OF PROJECT AND REASONS WHY PROJECT IS REQUIRED: .Th H91 fibernetwotk to the followinglocations u the MadVault and Gatherin Termination Locations :RemovelClean NET CONSTRUCTION EXPENDITURE $ 30,000.00 MAN HOURS REQUIRED NEWCONSTRUCTION Estlmated by: T BISTERFELDT REMOVAL CONSTRUCTION TOTAL Date: 8/28/2024 TOTAL PROJECT Page 1 Page 37 of 40  NAME OF PROJECT: Fiber Cable Replacement/Additions Year Ended December 31, Project No. IT-25—01 DETAIL OF ESTIMATED NET CONSTRUCTIONEXPENDITURE: QUANTITY MEASURE DESCRIPTION COST EACH TOTAL COST l Fiber Cable Replacements/Additions 30,000.00: TOTAL DIRECT COSTS $ 30,000‘00 % P & W ON $ % CONTINGENCIESON $ % CONTINGENCIESON $ REMOVAL COST SUBTOTAL 30.000‘00 Page 38 of 40 Page 2  Year Ended December 31, 2025 Project No. IT-25-02 NAME OF PROJECT: Fiber Hub Upgrades DEPARTMENT Technology Work to be performed by: SMU PERSONNEL LOCATION SMU Of?ce CONTRACTOR DESCRIPTION OF PROJECT AND REASONS WHY PROJECT IS REQUIRED: ‘Th' 9 ne at West Shawano Substation in 2020. hubs.Similar to work that was done NET CONSTRUCTION EXPENDITURE 5 5,000t00 MAN HOURS REQUIRED NEW CONSTRUCTION Estlmatad by: T BISTERFELDT REMOVAL CONSTRUCTION TOTAL Data: 8/28/2024 TOTAL PROJECT Page 3 Page 39 of 40  NAME OF PROJECT: Fiber Hub Upgrades Year Ended December 31, Project No. IT-25-02 DETAIL 0F ESTIMATED NET CONSTRUCTION EXPENDITURE: QUANTITY MEASURE DESCRIPTION COST EACH TOTAL COST TOTAL DIRECT COSTS $ 5,000.00 % P & W ON 5 % CONTINGENCIES ON S % CONTINGENCIES ON 5 REMOVAL COST S UBTOTAL 5,000.00 SALVAGE (subtracI) Page 40 of 40 Page 4