Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
COMMITTEE OF THE WHOLE Packet 08232022
CITY OF MUSKEGO COMMITTEE OF THE WHOLE AGENDA 08/23/2022 5:00 PM Muskego City Hall, W182 S8200 Racine Avenue CALL TO ORDER ROLL CALL STATEMENT OF PUBLIC NOTICE APPROVAL OF AGENDA APPROVAL OF MINUTES i"PSC4 of KEGO Approval of Committee of the Whole Minutes from May 24, 2022 COWM.2022.05.24 (draft).docx NEW BUSINESS Discuss Refuse & Recycling Container Placements 2023 Capital Projects Fund Budgets: • Human Resources: Page 5 • Information Technology: Pages 6 - 9 • Library: Pages 28 - 29 • Police Department: Pages 15 - 21 Proposed 5-Year Capital Project Plan 2023-2027.pdf HR - Post -hire Onboarding Budgeting Document.pdf IT - Capital_Budget_Memo _2023.pdf Police - Capital Projects Memo.pdf COMMUNICATIONS AND MISCELLANEOUS BUSINESS AS AUTHORIZED BY LAW ADJOURNMENT The Committee of the Whole may possibly reconvene immediately following the Common Council meeting of the same date to continue work on agenda items. NOTICE 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. ALSO, UPON REASONABLE NOTICE, EFFORTS WILL BE MADE TO ACCOMMODATE THE NEEDS OF DISABLED INDIVIDUALS THROUGH APPROPRIATE AIDS AND SERVICES. FOR ADDITIONAL INFORMATION OR TO REQUEST THIS SERVICE, CONTACT MUSKEGO CITY HALL, (262) 679-4100. CITY OF MUSKEGO ' Cq of COMMITTEE OF THE WHOLE MINUTES May 24, 2022 .1.1 USKEGO 5:30 PM Muskego City Hall, W182 S8200 Racine Avenue � *AMENDED CALL TO ORDER Mayor Petfalski called the meeting to order at 5:30 p.m. ROLL CALL Present: Alderpersons Wolfe, Terrence, Hammel, Schroeder, Kubacki, and Madden. Also present: City Attorney Warchol, Public Works and Development Director Kroeger, Utilities Superintendent Kloskowski, Assistant Utility Superintendent Bourdo, and Assistant Deputy Clerk -Treasurer Crisp. Absent: Alderperson Kapusta STATEMENT OF PUBLIC NOTICE Ms. Crisp stated that the meeting was noticed in accordance with the open meeting law. APPROVAL OF AGENDA Alderperson Kubacki moved to approve. Alderperson Madden seconded; motion carried. APPROVAL OF MINUTES Alderperson Hammel moved to approve the Committee of the Whole Minutes from March 22, 2022. Alderperson Kubacki seconded; motion carried. NEW BUSINESS Review the draft/final Water Policies Policy #1: Private Water Trust Connection Policy Policy #2: Service Connection Policy Policy #3: Water main Relay Assessment Policy Mr. Kroeger stated his goal tonight is to finalize the policies so that at the next meeting (June 14, 2022) they can be voted on without further discussion. Concerning the Policy #1, a sliding scale was discussed wherein during the first five years the Trust owners would pay the full cost to replace watermains in case of failure. Another proposal was made and discussed — if replacement is needed due to a system K failure the Trust owners would be 100% responsible for the first five years, with a 10% stepdown per year for the next 10 years so that year 16 would be 0%. Alderperson Kubacki made a motion that the Trust owners would be responsible to pay 100% for any replacement for system failure in the first five years with a 10% reduction each year thereafter until the 15t" year. Alderperson Madden seconded. Motion carried; 5 in favor, 1 opposed. Mayor Petfalski suggested a break at this point to conduct the other meetings scheduled. Alderperson Madden made a motion to adjourn. Alderperson Terrence seconded; motion carried. Meeting was adjourned at 6:15 PM. Mayor Petfalski reconvened the meeting at 6:29 PM. Concerning Policy #2, a suggestion was that we would leave the policy as it is. If the well fails, property owner will need to hook up. Connection is required at point of sale of home. Concerning Policy #3, there were no comments and it was agreed to go with Option 3 (not to assess residents — the Utility to cover all costs). Investigation regarding the Process for taking over a Private Water System Mr. Kroeger stated that they are talking to WDNR and the PSC for all what is needed. *Discussion on offer to purchase part of tax key number MSKC2198157 from Jason Stark Mr. Kroeger went over some history of what had been done on the property which was done without any approvals. Property owner was sent a letter which prompted the Offer to Purchase. After a brief discussion, the members agreed to reject the Offer. COMMUNICATIONS AND MISCELLANEOUS BUSINESS AS AUTHORIZED BY LAW ADJOURNMENT The Committee of the Whole may possibly reconvene immediately following the Common Council meeting of the same date to continue work on agenda items. Alderperson Kubacki moved to adjourn. Alderperson Madden seconded; motion carried. Meeting was adjourned at 6:43 p.m. Minutes taken and transcribed by Ms. Crisp. 3 � & Cry w USKEGO PROPOSED 5-YEAR CAPITAL PLAN 2023 - 2027 Prepared by City of Muskego Finance & Administration Department Tuesday, August 23rd, 2022 W182 S8200 Racine Avenue, Muskego, WI 53150 Waukesha County, Wisconsin (262) 679-4100 4 Table of Contents 5-Year Capital Improvements Program 2023 — 2027 2023 Capital Expenditure Summary.................................................................... 1 Summary of All Projects...................................................................................... 2 Detailed 5-Year Project Description.................................................................... 3 HumanResource.........................................................................................5 - Post -Hire Onboarding Solution...................................................5 Information Technology.............................................................................6 - Wireless Cameras...................................................................... 6 - Fiber Buildout.............................................................................7 - External Vulnerability Assessment.............................................8 - Copier Replacements.................................................................9 - Disaster Recovery......................................................................10 - Switches.....................................................................................11 - Firewall.......................................................................................12 - Storage Area Network (SAN).....................................................13 - Siren Updates.............................................................................14 Police.......................................................................................................... 15 - Radios...................................................................................... 15 - Body Worn Cameras................................................................ 16 - Tactical Vests........................................................................... 17 Rifle Shields.............................................................................. 18 - Ballistic Helmets....................................................................... 19 - Protective Masks...................................................................... 20 - Suburban Critical Incident Team Vehicle (2020 approval) ....... 21 - Motorcycle................................................................................ 22 - Handguns................................................................................. 23 - Ammunition............................................................................... 24 - 911 Dispatch Upgrade............................................................. 25 Table of Contents 5-Year Capital Improvements Program 2023 — 2027 TC Volunteer Fire Department................................................................. 26 — Various Equipment & Vehicles ................................................. 26 Library........................................................................................................ 28 — Additional Study Rooms........................................................... 28 — Public Restroom Renovation.................................................... 29 — Storage Shed............................................................................ 30 Parking Lot Repair/Repave...................................................... 31 Amphitheater Improvements (amount TBD)............................. 32 — Roof Replacement.................................................................... 33 StorageShed............................................................................ 34 — Wayfinding Signage (amount TBD).......................................... 35 Keycard Access Building Conversion ....................................... 36 Public Works & Development — Plan Division ........................................ 37 — Entrance Signs with Club Groups ............................................. 37 Public Works & Development — Engineering Division ........................... 38 — Light Pole - Painting................................................................. 38 — Road Program.......................................................................... 39 — Hillendale Drive........................................................................ 40 — Candlewood Subdivision.......................................................... 41 Public Works & Development — DPW Division ....................................... 42 — Pick-up Truck Replacement..................................................... 42 — Small Equipment...................................................................... 43 — Liebherr Excavator................................................................... 44 — Leaf Sucker Machine............................................................... 45 Old Loomis Bridge Guardrail .................................................... 46 — Salt Shed.................................................................................. 47 MiniExcavator.......................................................................... 48 M Table of Contents 5-Year Capital Improvements Program 2023 — 2027 Public Works Division (continued) — Asphalt Paver........................................................................... 49 — Cold Storage............................................................................ 50 WaterUtility............................................................................................... 51 Truck (Water & Sewer).............................................................. 51 — Scada Security (Water & Sewer) ............................................... 52 Meters....................................................................................... 53 FillingStation............................................................................. 54 — Well Rehab................................................................................ 55 Relay Water Mains.................................................................... 56 — Water Tower Painting................................................................ 57 Relay Water Laterals................................................................. 58 — Hillendale Booster Station......................................................... 59 SewerUtility............................................................................................... 60 CameraTruck............................................................................ 60 — Camera Truck Software............................................................ 61 Scada Security (Water & Sewer) ............................................... 62 — Lift Station Upgrades................................................................. 63 — Private Property I & I................................................................ 64 Generator.................................................................................. 65 SpecialRevenue Funds............................................................................ 66 Storm Water — Kelsey Drive Area Study .................................. 66 — Park Dedication/Improvements — Various Projects .................. 67 7 CITY OF MUSKEGO - 2023 BUDGET CAPITAL EXPENDITURE SUMMARY PROJECT DEPARTMENT CAPITAL EXPENDITURE PARK DEDICATION WORKING CAPITAL TOTAL FUNDING Landfill Landfill Utilities POST -HIRE ONBOARDING SOLUTION HUMAN RESOURCES $40,000 $40,000 WIRELESS CAMERAS INFORMATION TECHNOLOGY $55,000 $55,000 FIBER BUILDOUT INFORMATION TECHNOLOGY $15,000 $15,000 EXTERNAL VULNERABILITY ASSESSMENT INFORMATION TECHNOLOGY $15,000 $15,000 COPIER REPLACEMENTS INFORMATION TECHNOLOGY $30,000 $30,000 RADIOS POLICE $22,500 $22,500 BODY WORN CAMERAS POLICE $75,871 $75,871 TACTICAL VESTS POLICE $8,260 $8,260 RIFLE SHIELDS POLICE $6,650 $6,650 BALLISTIC HELMETS POLICE $15,600 $15,600 PROTECTIVE MASKS POLICE $14,475 $14,475 SUBURBAN CRITICAL INCIDENT TEAM VEHICLE (SCIT) POLICE $7,500 $7,500 TCVFD EQUIPMENT (Council approval R#089-2021 10/12/21) TC VOLUNTEER FIRE DEPT $345,000 $345,000 ADDITIONAL STUDY ROOMS LIBRARY $75,000 $75,000 PUBLIC RESTROOM RENOVATION LIBRARY $75,000 $75,000 ENTRANCE SIGNS WITH CLUB GROUPS PW&D - PLAN DIVISION $25,000 $25,000 LIGHT POLES - PAINTING PW&D - ENGINEERING $52,000 $52,000 ROAD PROGRAM PW&D - ENGINEERING $1,000,000 $1,000,000 PICKUP TRUCK REPLACEMENT PW&D - PUBLIC WORKS $45,000 $45,000 SMALL EQUIPMENT PW&D - PUBLIC WORKS $5,000 $5,000 LIEBHERR EXCAVATOR PW&D - PUBLIC WORKS $350,000 $350,000 LEAF SUCKER MACHINE PW&D - PUBLIC WORKS $80,000 $80,000 OLD LOOMIS BRIDGE GUARDRAIL PW&D - PUBLIC WORKS $75,000 $75,000 SCADA SECURITY WATER & SEWER UTILITY $35,640 $35,640 METERS WATER UTILITY $200,000 $200,000 FILLING STATION WATER UTILITY $100,000 $100,000 WELL REHAB WATER UTILITY $150,000 $150,000 CAMERA TRUCK SEWER UTILITY $500,000 $500,000 CAMERA TRUCK SOFTWARE SEWER UTILITY $35,000 $35,000 LIFT STATION UPGRADES SEWER UTILITY $40,000 $40,000 PRIVATE PROPERTY I & I (MMSD Reimbursement) SEWER UTILITY $900,000 $900,000 GENERATOR SEWER UTILITY $100,000 $100,000 PARKS PROJECTS PARK DEDICATION $601,500 $601,500 TOTAL CAPITAL PROJECTS $2,432,856 $601,500 $2,060,640 $5,094,996 Page 1 A. PROJECT IDENTIFICATION 1. Project Name: 2. Department: 3. Description: CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM 2023 - 2027 Totals Summary of All Projects All Departments B. EXPENDITURE SCHEDULE Suboroi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 2,961,610 1,083,996 509,691 506,691 430,361 430,871 1,368,000 877,500 128,500 150,000 91,000 121,000 40,000 0 0 0 0 40,000 1,270,000 0 580,000 280,000 410,000 0 0 0 0 0 0 0 18,420,000 2,415,000 1,425,000 3,980,000 5,475,000 5,125,000 35,640 0 17,820 17,820 0 0 7,464,341 718,500 1,005,090 1,942,251 854,500 2,944,000 TOTAL 31,559,591 5,094,996 3,666,101 6,876,762 7,260,861 8,660,871 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fund Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Expenditure 401 Capital Borrowing 605 Water Borrowing 206 WRLF Residual 220 Capital Improvement/TIF 210 Landfill 202 Park Dedication 203 Park Improvements 215 Conservation Funds 216 Stormwater Funds 601 Other Funding - MMSD 0 0 0 0 0 0 2,549,960 467,820 820,820 435,320 603,000 223,000 1,214,960 692,820 190,820 135,320 98,000 98,000 0 0 0 0 0 0 9,722,000 1,000,000 0 1,315,500 2,462,500 4,944,000 9,010,000 0 550,000 3,580,000 2,080,000 2,800,000 0 0 0 0 0 0 0 0 0 0 0 0 6,572,920 2,034,356 1,854,461 610,871 1,767,361 305,871 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40,000 0 0 0 0 40,000 2,449,751 900,000 250,000 799,751 250,000 250,000 TOTAL 31,559,591 5,094,996 3,666,101 6,876,762 7,260,861 8,660,871 Check Total 0.00 0 0 0 0 0 D. ANNUAL OPERATING IMPACT (if anv) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5. Net impact 0 0 0 0 0 0 Page 2 9 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION 2023 - 2027 Page Totals 2023 2024 2025 2026 2027 General Government Human Resources Post -Hire Onboarding Solution Total Information Technology Wireless Cameras Fiber Buildout External Vulnerabiltiy Assessment Copier Replacements Disaster Recovery Switches Firewal I Storage Area Network (SAN) Siren Updates Total Total General Government jPublic Safety 5 40,000 40,000 40,000 40,000 6 76,000 55,000 21,000 7 50,000 15,000 35,000 - 8 33,000 15,000 - 18,000 9 30,000 30,000 - - 10 30,000 - 30,000 11 25,000 25,000 - 12 25,000 - 25,000 13 135,000 - 135,000 14 15,000 - - - - 15,000 419,000 115,000 111,000 25,000 18,000 150,000 459,000 155,000 111,000 25,000 18,000 150,000 Police Department Radios 15 112,500 22,500 - 90,000 - - Body Worn Cameras 16 379,355 75,871 75,871 75,871 75,871 75,871 Tactical Vests 17 8,260 8,260 - - - - Rifle Shields 18 6,650 6,650 Ballistic Helmets 19 15,600 15,600 Protective Masks 20 14,475 14,475 - Suburban Critical Incident Team Vehicle (SCIT) 21 15,000 7,500 7,500 Motorcycle 22 30,000 - 30,000 - Handguns 23 18,000 - 18,000 Ammunition 24 100,000 100,000 911 Dispatch Upgrade 25 549,751 - - 549,751 - - Total 1,249,591 150,856 113,371 833,622 75,871 75,871 TC Volunteer Fire Department Various Equipment & Vehicles 26-27 345,000 345,000 - - - - Total Public Safety 1,594,591 495,856 113,371 833,622 75,871 75,871 Recreation & Education Library Additional Study Rooms 28 75,000 75,000 - - - - Public Restroom Renovation 29 75,000 75,000 - Storage Shed 30 7,590 - 7,590 Parking Lot Repair/Repave 31 199,500 199,500 Amphitheater Improvements (amount TBD) 32 - - - Roof Replacement 33 180,000 180,000 Wayfinding Signage (amount TBD) 34 - - - Public Furniture 35 46,490 46,490 Keycard Access Building Conversion 36 40,000 - - - 40,000 Total 623,580 150,000 207,090 180,000 86,490 Total Recreation & Education 623,580 150,000 207,090 180,000 86,490 - Public Works & Development Planning Division Entrance Signs with Club Groups 37 50,000 25,000 25,000 - - Total 50,000 25,000 25,000 - - - Page 3 10 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION 2023 - 2027 Page Totals 2023 2024 2025 2026 2027 Public Works & Development continued Engineerinq Division Light Pole - Painting Road Program Hillendale Drive Candlewood Subdivision Total Public Works Division Pickup Truck Replacement Small Equipment Liebherr Excavator Leaf Sucker Machine Old Loomis Bridge Guardrail Salt Shed Mini Excavator Asphalt Paver Cold Storage Total Total Public Works & Development Total General Fund Utilities Water Utility Truck (Water & Sewer) Scada Security (Water & Sewer) Meters Filling Station Well Rehab Relay Water Mains Water Tower - Painting Relay Water Laterals Hillendale Booster Station Total Sewer Utility Camera Truck Camera Truck Software Scada Security (Water & Sewer) Lift Station Upgrades Private Property I & I (MMSD Funding) Generator Total 38 208,000 52,000 52,000 52,000 52,000 39 2,000,000 1,000,000 - - 1,000,000 40 1,675,000 - 175,000 1,500,000 41 2,200,000 - - 200,000 2,000,000 6,083,000 1,052,000 227,000 52,000 2,752,000 2,000,000 42 305,000 45,000 75,000 65,000 45,000 75,000 43 25,000 5,000 5,000 5,000 5,000 5,000 44 350,000 350,000 - - - - 45 80,000 80,000 46 75,000 75,000 - 47 300,000 - 300,000 48 100,000 100,000 - 49 85,000 - 85,000 50 400,000 - - - 400,000 - 1,720,000 555,000 480,000 70,000 535,000 80,000 7,853,000 1,632,000 732,000 122,000 3,287,000 2,080,000 10,530,171 2,432,856 1,163,461 1,160,622 3,467,361 2,305,871 51 111,500 - 23,000 42,500 23,000 23,000 52 53,460 17,820 17,820 17,820 - - 53 1,000,000 200,000 200,000 200,000 200,000 200,000 54 100,000 100,000 - - - - 55 300,000 150,000 100,000 50,000 - - 56 8,510,000 - 550,000 3,580,000 2,080,000 2,300,000 57 860,000 480,000 - 380,000 - 58 125,000 - 125,000 - - 59 500,000 - - - - 500,000 11,559,960 467,820 1,370,820 4,015,320 2,683,000 3,023,000 60 611,500 500,000 23,000 42,500 23,000 23,000 61 35,000 35,000 - - - - 62 53,460 17,820 17,820 17,820 - - 63 415,000 40,000 150,000 75,000 75,000 75,000 64 1,900,000 900,000 250,000 250,000 250,000 250,000 65 100,000 100,000 - - - - 3,114,960 1,592,820 440,820 385,320 348,000 348,000 Total Utilities 14,674,920 2,060,640 1,811,640 4,400,640 3,031,000 3,371,000 Special Revenue Funds Storm Water - Kelsey Drive Area Study 66 40,000 - - - - 40,000 Park Dedication 67-68 6,314,500 601,500 691,000 1,315,500 762,500 2,944,000 Total Speciail Revenue 6,354,500 601,500 691,000 1,315,500 762,500 2,984,000 GRAND TOTAL 1 31,559,591 5,094,996 3,666,101 6,876,762 7,260,861 8,660,871 Page 4 11 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.01.6504 A. PROJECT IDENTIFICATION 1. Project Name: Post -hire Onboarding Solution 2. Department: Human Resources 3. Description: Workflow system for the process to be completed when new employees are hired , including: system; Assignment of tasks; Assembly of onboarding packet; and Follow-up tasks to complete performance evaluations. B. EXPENDITURE SCHEDULE Suboroi. Expend. catepory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 40,000 40,000 1 0 1 0 1 0 1 0 TOTAL 40,000 40,000 0 0 0 0 C. FUNDING SOURCE(S) Fund Revenue catepory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 401 Trnsfr w/in CPF GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Fd Bal State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40,000 40,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 1 0 TOTAL 40,000 40,000 0 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 5 12 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.14.6523 A. PROJECT IDENTIFICATION 1. Project Name: Wireless Cameras 2. Department: Information Technology/Parks /PW&D 3. Description: Expand current Wirelss cameras into following locations: 2023 - Old Town hall (2-$9k), Bluhm (8-$23k), Box Horn Boat launch (2-$14k) City Hall External Parking & Drop Box (3-$9K) Includes licensing upgrade for ssytem to accomade more cameras. 2024 - Durham Boat Launch ($9k) & Lake Denoon ($12k) B. EXPENDITURE SCHEDULE Suboroi. Expend, cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 76,000 55,000 21,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 76,000 55,000 21,000 0 0 0 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 401 Capital Project Fund GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 76,000 55,000 21,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 76,000 55,000 21,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 6 13 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.14.6527 A. PROJECT IDENTIFICATION 1. Project Name: Fiber Buildout to Parks 2. Department: IT 3. Description: 2023 - Idle Isle 2024 - Park Arthur B. EXPENDITURE SCHEDULE Subprol. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 50,000 15,000 35,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 50,000 15,000 35,000 0 0 0 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50,000 15,000 35,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 50,000 15,000 35,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 7 14 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name: External Vulnerability Assessment 2. Department: Information Technology 3. Description: Security Audit - Penetration Testing 410.08.90.14.6525 B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 33,000 0 15,000 0 0 18,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 33.000 15.000 0 0 18.000 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 33,000 15,000 0 0 18,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 33,000 15,000 0 0 18,000 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 8 15 CITY OF MUSKEGO, WISCONSIN DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.14.6503 A. PROJECT IDENTIFICATION 1. Project Name: Copier Replacments 2. Department: Information Technology 3. Description: Keeping our coping fleet up and operational helps everyone with the city do their jobs more effectively and efficiently. 4 Replacements - Public Works & Development, Recreation, Mayor & Library. B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 30,000 30,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 30,000 30,000 0 0 0 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 0 0 0 0 0 0 410 Capital Project Fund 0 0 0 0 0 0 401 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 Other Fund Balance 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 30,000 30,000 0 0 0 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds 0 0 0 0 0 Other Source 0 0 0 0 0 TOTAL 30,000 30,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 9 16 TOTAL 30,000 30,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 9 16 0 0 0 0 0 0 0 0 Page 9 16 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.14.6529 A. PROJECT IDENTIFICATION 1. Project Name: Disaster Recovery 2. Department: Information Technology 3. Description: Beginning stage planning disaster recovery/off site backups. B. EXPENDITURE SCHEDULE SUbproi. EXoend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue cateaory 0 0 0 0 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30,000 0 30,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL D. ANNUAL OPERATING IMPACT 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: (if any) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 10 17 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.14.6514 A. PROJECT IDENTIFICATION 1. Project Name: Switches 2. Department: Information Technology 3. Description: New switches for Library. B. EXPENDITURE SCHEDULE Subprol. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Services 25,000 0 25,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 0 0 0 0 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 0 0 0 0 0 0 410 Capital Project Fund 0 0 0 0 0 0 401 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 Other Fund Balance 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 25,000 0 25,000 0 0 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds Other Source TOTAL D. ANNUAL OPERATING IMPACT 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 TOTAL D. ANNUAL OPERATING IMPACT 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 25,000 0 25,000 0 0 0 (if any) 0 0 0 0 0 0 0 0 0 0 Page 11 18 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.14.6512 A. PROJECT IDENTIFICATION 1. Project Name: Firewall Replacements 2. Department: Information Technology 3. Description: B. EXPENDITURE SCHEDULE Suborol. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Other - City Firewall Other - 911 Replace 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25,000 0 0 25,000 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 25,000 0 0 25 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25,000 0 0 25,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 25,000 0 0 25,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 12 19 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.14.6511 A. PROJECT IDENTIFICATION 1. Project Name: Host/San Replacment 2. Department: Information Technology 3. Description: Replace/increase our current capicity for storge and computing resources for city funcations. B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 135,000 0 0 0 0 0 0 0 0 135,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 135,000 0 0 0 0 0 0 135,000 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 135,000 0 0 0 0 135,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 135,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 135,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 13 20 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.14.6526 A. PROJECT IDENTIFICATION 1. Project Name: Siren 2. Department: Information Technology 3. Description: Updates. B. EXPENDITURE SCHEDULE Subproi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 15,000 0 0 0 0 15,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue cateaory 0 0 0 0 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 15,000 0 0 0 0 15,000 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 0 0 0 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 14 21 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.91.20.6507 A. PROJECT IDENTIFICATION 1. Project Name: Radios 2. Department: Police/TCVFD/IT Department 3. Description: B. EXPENDITURE SCHEDULE Subaroi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 112,500 22,500 0 90,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 112,500 22,500 0 90,000 0 0 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 112,500 22,500 0 90,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 112,500 22,500 0 90,000 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 15 22 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name: Body Worn Cameras 2. Department: Police 3. Description: Replace body worn camera system/ALPR/Cloud Storage/Squad Cameras 10-year program - locked in price. 410.08.91.20.6512 B. EXPENDITURE SCHEDULE SUbproi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 379,355 75,871 75,871 75,871 75,871 75,871 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue cateaory 379,355 75,871 75,871 75,871 75,871 75,871 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 379,355 75,871 75,871 75,871 75,871 75,871 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 1 0 TOTAL 379,355 75,871 75,871 75,871 75,871 75,871 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 0 2. Materials 0 3. Total Cost 0 4. Offsetting Rev or Savings 0 5. Net impact 0 0 0 0 0 0 E. DESCRIPTION HISTORY Original Date: Revised Date: 23 Page 16 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.91.20.6508 A. PROJECT IDENTIFICATION 1. Project Name: Tactical Vests 2. Department: Police 3. Description: Tactical vest replacements. B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 8,260 8,260 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 8,260 8,260 0 0 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8,260 8,260 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL D. ANNUAL OPERATING IMPACT 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: (if any) 8,260 8,260 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 17 24 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.91.20.6509 A. PROJECT IDENTIFICATION 1. Project Name: Rifle Shields 2. Department: Police 3. Description: Rifle Rated Shields for every squad. B. EXPENDITURE SCHEDULE Subproi. Expend, category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 6,650 6,650 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 6,650 6,650 0 0 0 0 C. FUNDING SOURCE(S) Fund Revenue cateqory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6,650 6,650 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 6,650 6,650 0 0 0 0 D. ANNUAL OPERATING IMPACT 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: (if any) 0 0 0 0 0 0 0 0 0 0 Page 18 25 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.91.20.6524 A. PROJECT IDENTIFICATION 1. Project Name: Ballistic Helmets 2. Department: Police 3. Description: Ballistic Helmets with crowd control face shields. B. EXPENDITURE SCHEDULE SUbproi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 15,600 15,600 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue cateaory 0 0 0 0 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 0 0 0 0 0 0 401 Capital Project Fund 0 0 0 0 0 0 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 Other Fund Balance 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 15,600 15,600 0 0 0 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds Other Source TOTAL D. ANNUAL OPERATING IMPACT 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 TOTAL D. ANNUAL OPERATING IMPACT 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 15,600 15,600 0 0 0 0 0 0 0 0 0 0 Page 19 26 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.91.20.6529 A. PROJECT IDENTIFICATION 1. Project Name: Protective Masks 2. Department: Police 3. Description: Gas Masks B. EXPENDITURE SCHEDULE Suboroi. Expend. catepory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 14,475 0 14,475 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue catepory 14,475 14,475 0 0 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 14,475 14,475 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 14,475 14,475 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 20 27 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.91.20.6528 A. PROJECT IDENTIFICATION 1. Project Name: Suburban Critical Incident Team Vehicle (SCIT) 2. Department: Police Department 3. Description: Purchase of a Rescue Vehicle for Civilian and Tactical Personnel during emergency and tactical situations. The purchase will occur in 2020, however the payment will be split over 5 years. The cost is estimated because fund raising is taking place before purchase. B. EXPENDITURE SCHEDULE Subproi. Expend. catepory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 15,000 7,500 7,500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 15,000 7,500 7,500 0 0 0 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 15,000 7,500 7,500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 15,000 7,500 7,500 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5. Net impact 0 0 0 0 0 0 E. DESCRIPTION HISTORY Original Date: Revised Date: Page 21 28 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.91.20.6530 A. PROJECT IDENTIFICATION 1. Project Name: Motorcycle Unit 2. Department: Police 3. Description: Motorcycle Unit B. EXPENDITURE SCHEDULE SUbproi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 30,000 0 30,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue cateaory 30,000 0 30,000 0 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Trnsfr w/in CPF 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Fd Bal State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30,000 0 30,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 30,000 0 30,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 22 29 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.91.20.6523 A. PROJECT IDENTIFICATION 1 Project Name: Handgun 2. Department: Police Department 3. Description: Replace handguns. B. EXPENDITURE SCHEDULE SUbproi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 18,000 0 0 18,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue cateaory 18,000 0 0 18,000 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18,000 0 0 18,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 18,000 0 0 18,000 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 23 30 0 0 0 0 0 0 0 0 Page 23 30 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.91.20.6521 A. PROJECT IDENTIFICATION 1 Project Name• Ammunition 2. Department: Police 3. Description: Ammunition replacement. B. EXPENDITURE SCHEDULE SUbproi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 100,000 0 0 100,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue cateaory 100,000 0 0 100,000 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100,000 0 0 100,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL D. ANNUAL OPERATING IMPACT 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 Page 24 31 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.91.20.6551 A. PROJECT IDENTIFICATION 1. Project Name: 911 Dispatch Center Upgrade 2. Department: Police/TCVFD 3. Description: 911 Update/Upgrade (all 3 agencies reviewing). B. EXPENDITURE SCHEDULE SUbproi. EXoend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 549,751 0 0 549,751 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 549,751 0 0 549,751 C. FUNDING SOURCE(S) Fund Revenue cateaory 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 549,751 0 0 549,751 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 549,751 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 0 0 549,751 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5. Net impact C E. DESCRIPTION HISTORY Original Date: Revised Date: 25 0 0 0 0 0 0 0 32 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 401.08.91.21.65XX A. PROJECT IDENTIFICATION 1. Project Name: Equipment/Vehicle 2. Department: Tess Corners Volunteer Fire Department 3. Description: Detail provided on following page. of the TCVFD B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 20,000 20,000 0 0 0 0 325,000 325,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 345,000 345,000 0 0 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 0 0 0 0 0 0 410 Capital Project Fund 0 0 0 0 0 0 401 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 206 WRLF Residual 0 0 0 0 0 0 220 Capital Improvement 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 345,000 345,000 0 0 0 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds 0 0 0 Other Source 0 0 0 TOTAL 345,000 345,000 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 TOTAL 345,000 345,000 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 26 33 CITY OF MUSKEGO, WISCONSIN TESS CORNERS VOLUNTEER FIRE DEPARTMENT DETAILED PROJECT LISTING PROJECT NAME DESCRIPTION ACCOUNT# AMOUNT TOTAL 2023 2024 2025 2026 2027 Pagers Replacement for Fire Pagers 410.08.91.21.6503 Fire Hose Replacement of Fire Hose (25 sets) 410.08.91.21.6509 Fire Helmets Replacement of Fire Helmets that expire over a 3-year period 410.08.91.21.6510 Fire Gear Replacement of Fire Gear 410.08.91.21.6511 Fire Hose Testing 410.08.91.21.6509 Rescue Vehicle Ambulance 410.08.91.21.6502 Vehicle Technology CAD / Modem Update 410.08.91.21.6505 Tanker Replacement of year 2000 tanker 410.08.91.21.6514 Engine Replacement of Fire Pumper. Current Pumper was purchased in 1996 410.08.91.21.6501 Defibrillators Roll X-Series 410.08.91.21.6513 TOTAL EXPENDITURES EXPENDITURE SCHEDULE 7,000 7,000 0 0 0 0 5,000 5,000 0 0 0 0 8,000 8,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 325,000 325,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 345,000 i 345,000 1 0 0 0 0 GO Borrowing Landfill Funds Reserve Funds Other Source TOTAL FUNDING SOURCE FUNDING SOURCE 0 0 0 0 0 0 345,000 345,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 345,000 345,000 0 0 0 0 34 Page 27 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.71.6516 A. PROJECT IDENTIFICATION 1. Project Name: Additional Study Rooms 2. Department: Library 3. Description: 2023: Create Additional Study Rooms. Needs assessment of rooms based on stategic planning feedback, 2022 patron survey, and statistical usage data. B. EXPENDITURE SCHEDULE SUbproi. EXoend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 75,000 75,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 75,000 75,000 0 0 0 0 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Trnsfr w/in CPF 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Fd Bal State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 75,000 75,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 1 0 TOTAL 75,000 75,000 0 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5. Net impact 0 0 0 0 0 0 E. DESCRIPTION HISTORY Original Date: Revised Date: Page 28 35 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.71.6515 A. PROJECT IDENTIFICATION 1. Project Name: Public Restroom Renovation 2. Department: Library 3. Description: Full renovation of the family restroom and non-structural updates to the other restrooms. Restrooms are original to the library and deteriorating. Family restroom needs ADA updates. B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 75,000 75,000 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 75,000 75,000 0 0 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 0 0 0 0 0 0 401 Trnsfr w/in CPF 0 0 0 0 0 0 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 Other Fund Fd Bal 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 75,000 75,000 0 0 0 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds 0 0 0 Other Source 0 0 0 TOTAL 75,000 75,000 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 TOTAL 75,000 75,000 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 29 36 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.71.6517 A. PROJECT IDENTIFICATION 1. Project Name: Storage Shed 2. Department: Library 3. Description: 12x12 Storage Shed. Outdoor cold storage. B. EXPENDITURE SCHEDULE Subproi. Expend. cateqory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7,590 0 7,590 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 7,590 0 7,590 0 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7,590 0 7,590 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 7,590 0 7,590 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 30 37 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No A. PROJECT IDENTIFICATION 1. Project Name: Parking Lot Repair/Repave 2. Department: Library 3. Description: 410.08.90.71.6504 Parking lot repaving and maintenance to assist with leveling and slope. Parking lot is original to the building (24 years old). Last asphalt sealing was in 2019. B. EXPENDITURE SCHEDULE SUbproi. EXoend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 199,500 0 199,500 0 0 0 TOTAL 199,500 0 199,500 0 0 C. FUNDING SOURCE(S) Fund Revenue cateaory 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 401 Capital Project Fund GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 199,500 0 199,500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 1 0 TOTAL 199,500 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 0 199,500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5. Net impact 0 E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 Page 31 38 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.71.6518 A. PROJECT IDENTIFICATION 1. Project Name: Wayfinding Signage 2. Department: Library 3. Description: Signage to assist patrons in locating key service areas where there is currently no signage or ineffective signage. 2024 Cost is TBD as signage study is in progress in 2022. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2023 2024 2025 2026 2027 F Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 0 0 0 0 0 C. FUNDING SOURCE(S) Fund Revenue category 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 0 0 0 0 0 0 410 Capital Project Fund 0 0 0 0 0 0 401 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 Other Fund Balance 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 0 0 0 0 0 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds 0 0 0 0 0 Other Source 1 0 1 0 1 0 1 0 1 0 TOTAL 0 0 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 32 39 TOTAL 0 0 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 32 39 0 0 0 0 0 0 0 0 Page 32 39 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.71.6519 A. PROJECT IDENTIFICATION 1. Project Name: Amphitheater Improvements 2. Department: Library 3. Description: Improvements include shade structure and sidewalk leading to amphitheater for safe access. 2024: Amount TBD B. EXPENDITURE SCHEDULE Subproi. Expend, cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 0 0 0 0 0 0 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Library Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 0 0 0 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 33 40 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.71.6520 A. PROJECT IDENTIFICATION 1. Project Name: Roof Repair/Replacement 2. Department: Library 3. Description: Replace the existing roof. Roof is original to building and will be 25 years old in 2025. B. EXPENDITURE SCHEDULE SUbproi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 180,000 0 0 180,000 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue cateaory :� e 0 0 0 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Trnsfr w/in CPF 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Fd Ball State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 180,000 0 0 180,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 34 41 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.71.6511 A. PROJECT IDENTIFICATION 1. Project Name: Public Furniture 2. Department: Library 3. Description: 2026: Public Meeting Room Chairs & Board Room Furniture. Furniture being replaced original to the building (26 years old). B. EXPENDITURE SCHEDULE Subnroi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 46,490 0 0 0 46,490 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 46,490 0 0 0 46,490 0 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 401 Capital Project Fund GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 46,490 0 0 0 46,490 0 0 0 0 0 0 0 0 0 0 0 0 0 Stormwater Funds 0 0 0 0 0 0 Other Source 0 0 0 0 0 0 TOTAL 46,490 0 0 0 46,490 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 35 42 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.14.6525 A. PROJECT IDENTIFICATION 1. Project Name: Door Updates/Keycard Access Building Conversion 2. Department: Library 3. Description: Conversion to keycard building access to support public building security. 2026: Estimates pending official proposals. B. EXPENDITURE SCHEDULE SUbproi. EXoend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40,000 0 0 0 40,000 0 TOTAL 40,000 0 0 0 40,000 0 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40,000 0 0 0 40,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 1 0 TOTAL 40,000 0 0 0 40,000 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5. Net impact 0 0 0 0 0 0 E. DESCRIPTION HISTORY Original Date: Revised Date: Page 36 43 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.18.6502 A. PROJECT IDENTIFICATION 1. Project Name: Entrance Signs with Club Groups 2. Department: PW&D - Planning Division 3. Description: 4 Entrance Signs 2023 - 2 Signs 2024 - 2 Signs B. EXPENDITURE SCHEDULE Subproi. EXoend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50,000 25,000 25,000 0 0 0 TOTAL 50,000 25,000 25,000 0 0 0 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Trnsfr w/in CPF 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance 261 Other Fund Fd Bal State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50,000 25,000 25,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 50,000 25,000 25,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 37 44 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.91.19.6520 A. PROJECT IDENTIFICATION 1. Project Name: Light Pole Painting 2. Department: PW&D - Engineering 3. Description: Janesville - 104 light poles need to be removed, powder coated at DPW yard and reinstalled 2023 - 26 poles 2024 - 26 poles 2025 - 26 poles 2026 - 26 poles B. EXPENDITURE SCHEDULE Subprol. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 208,000 52,000 52,000 52,000 52,000 0 TOTAL 208,000 52,000 52,000 52,000 52,000 0 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 208,000 52,000 52,000 52,000 52,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 208,000 52,000 52,000 52,000 52,000 0 D. ANNUAL OPERATING IMPACT 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: Page 38 45 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 401.08.91.19.6501 A. PROJECT IDENTIFICATION 1. Project Name: Road Program 2. Department: DPW -Engineering 3. Description: Every 3 years, to make the request for an extra $1 million for the road program. This should help the City of Muskego to catch up on road work B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2,000,000 1,000,000 0 0 1,000,000 0 0 0 0 0 0 TOTAL 2,000,000 1,000,000 0 0 1,000,000 C. FUNDING SOURCE(S) Fund Revenue category 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 0 0 0 0 0 0 401 Capital Project Fund 0 0 0 0 0 0 GO Borrowing 1,000,000 1,000,000 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 401 Other Fund Balance 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 1,000,000 0 0 0 1,000,000 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds 0 0 0 0 0 Other Source 0 0 0 0 0 TOTAL 2,000,000 1,000,000 0 0 1,000,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 39 46 TOTAL 2,000,000 1,000,000 0 0 1,000,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 39 46 0 0 0 0 0 0 0 0 Page 39 46 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No A. PROJECT IDENTIFICATION 410.08.91.19.6507 1. Project Name: Hillendale Drive (Field Drive to Racine Avenue) 2. Department: PW&D - Engineering 3. Description: This project would be done through WisDOT Local Program. The City of Muskego wants to use funds from the 2023-2026 Bipartisan Infrastructure Law (BIL) program. This portion of Hillendale Drive needs to be fully reconstructed with a potential new horizontal alignment for the intersection of Field Drive and Hillendale Drive. There is major drainage issues that need to be fixed in this area as well. The City of Muskego submitted a BIL application for this project. Typical cost (Design - 100% Municipality, Construction - 80% WisDOT/20% Municipality) B. EXPENDITURE SCHEDULE Sub,oroi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,675,000 0 175,000 0 1,500,000 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 1,675,000 0 175,000 0 1,500,000 0 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source - TIF 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,500,000 0 0 0 1,500,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 175,000 0 175,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 1,675,000 0 175,000 0 1,500,000 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 40 47 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.90.19.6512 A. PROJECT IDENTIFICATION 1. Project Name: Candlewood Subdivision 2. Department: DPW -Engineering 3. Description: The City of Muskego is looking into possible funding sources. However it has been difficult since this is a subdivision and does not have significant traffic numbers or a major street. The subdivsion was constructed with fly ash in the road base which has cause major heaving of the road. The entire subdivision needs to have a full road reconstruction (base and pavement). B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2,200,000 0 0 0 200,000 2,000,000 0 0 0 0 0 0 1 0 1 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue catepory 2,200,000 0 0 0 200,000 2,000,000 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Trnsfr w/in CPF 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Fd Bal State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2,200,000 0 0 0 200,000 2,000,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 1 0 0 1 0 1 0 TOTAL 2,200,000 0 0 0 200,000 2,000,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5. Net impact 0 E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 48 Page 41 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.93.51.6507 A. PROJECT IDENTIFICATION 1. Project Name: Pickup Truck Replacement 2. Department: PW&D - Public Works Division 3. Description: 2023 - 1/2 Ton Pickup 2024 - 1 Ton Pickup with dumpbed and Plow 2025 - 3/4 Ton Pickup 2026 - 1/2 Ton Pickup 2027 - 1 Ton Pickup with dumpbed and Plow B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other Contingency 0 0 0 0 0 0 305,000 45,000 75,000 65,000 45,000 75,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 305,000 45,000 75,000 65,000 45,000 75,000 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 305,000 45,000 75,000 65,000 45,000 75,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 305,000 45,000 75,000 65,000 45,000 75,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 42 49 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.93.51.6532 A. PROJECT IDENTIFICATION 1. Project Name: Small Equipment/Tools 2. Department: PW&D - Public Works Division 3. Description: 2023 - Misc small equipment 2024 - Misc small equipment 2025 - Misc small equipment 2026 - Misc small equipment 2027 - Misc small equipment B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 25,000 5,000 5,000 5,000 5,000 5,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 25,000 5,000 5,000 5,000 5,000 5,000 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Trnsfr w/in CPF 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Fd Bal State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25,000 5,000 5,000 5,000 5,000 5,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 25,000 5,000 5,000 5,000 5,000 5,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 43 50 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.93.51.6542 A. PROJECT IDENTIFICATION 1. Project Name: Liebherr Excavator 2. Department: PW&D - Public Works Division 3. Description: Replacement of Liebherr Excavator. B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 350,000 350,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 350,000 350,000 0 0 0 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 0 0 0 0 0 0 410 Capital Project Fund 0 0 0 0 0 0 401 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 Other Fund Balance 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 350,000 350,000 0 0 0 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds 0 0 0 0 0 Other Source 0 0 0 0 0 TOTAL 350,000 350,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 44 51 TOTAL 350,000 350,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 44 51 0 0 0 0 0 0 0 0 Page 44 51 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.93.51.6526 A. PROJECT IDENTIFICATION 1. Project Name: Leaf Sucker Machine 2. Department: PW&D - Public Works Division 3. Description: Replace Leaf Sucker equipment (this is a 1 man piece of equipment compared to 4-man). B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 80,000 80,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 80,000 80,000 0 0 0 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 0 0 0 0 0 0 410 Capital Project Fund 0 0 0 0 0 0 401 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 Other Fund Balance 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 80,000 80,000 0 0 0 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds 0 0 0 0 0 Other Source 0 0 0 0 0 TOTAL 80,000 80,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 45 52 TOTAL 80,000 80,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 45 52 0 0 0 0 0 0 0 0 Page 45 52 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.93.51.6551 A. PROJECT IDENTIFICATION 1. Project Name: Old Loomis Bridge Guardrail 2. Department: PW&D - Public Works Division 3. Description: Old Loomis Bridge needs Guardrail. The slopes constructed are steeper than anticipated and guardrail is required. B. EXPENDITURE SCHEDULE Subprol. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 75,000 75,000 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 75,000 75,000 0 0 0 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 75,000 75,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 75,000 75,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 46 53 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.93.51.6518 A. PROJECT IDENTIFICATION 1. Project Name: Salt Shed Roof 2. Department: PW&D - Public Works Division 3. Description: Replacement of old Salt Shed. B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 300,000 0 300,000 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 300,000 0 300,000 0 0 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 0 0 0 0 0 0 410 Capital Project Fund 0 0 0 0 0 0 401 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 Other Fund Balance 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 300,000 0 300,000 0 0 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds 0 0 0 0 0 Other Source 0 0 0 0 0 TOTAL 300,000 0 300,000 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 47 54 TOTAL 300,000 0 300,000 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 47 54 0 0 0 0 0 0 0 0 Page 47 54 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.93.51.6540 A. PROJECT IDENTIFICATION 1. Project Name: Mini Excavator 2. Department: PW&D - Public Works Division 3. Description: Replacement of mini excavator B. EXPENDITURE SCHEDULE Suboroi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 100,000 0 100,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue cateaory 100,000 0 100,000 0 0 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 0 0 0 0 0 0 410 Trnsfr w/in CPF 0 0 0 0 0 0 401 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 Other Fund Fd Bal 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 100,000 0 100,000 0 0 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds 0 0 0 0 0 Other Source 0 0 0 0 0 TOTAL 100,000 0 100,000 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 48 55 TOTAL 100,000 0 100,000 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 48 55 0 0 0 0 0 0 0 0 Page 48 55 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.93.51.6538 A. PROJECT IDENTIFICATION 1. Project Name: Asphalt Paver 2. Department: PW&D - Public Works Division 3. Description: Replacement of Asphalt Paver B. EXPENDITURE SCHEDULE SUbproi. EXoend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 85,000 0 0 0 85,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 85,000 0 0 0 85,000 0 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Trnsfr w/in CPF 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Fd Bal State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source (bb $) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 85,000 0 0 0 85,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 85,000 0 0 0 85,000 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 49 56 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 410.08.93.51.6539 A. PROJECT IDENTIFICATION 1. Project Name: Cold Storage 2. Department: PW&D - Public Works Division 3. Description: Additional Cold Storage need at DPW. B. EXPENDITURE SCHEDULE Subproi. Expend. cateqory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 400,000 0 0 0 400,000 0 0 0 0 0 0 TOTAL 400,000 0 0 0 400,000 C. FUNDING SOURCE(S) Fund Revenue category 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 0 0 0 0 0 0 410 Trnsfr w/in CPF 0 0 0 0 0 0 401 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 Other Fund Fd Bal 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 400,000 0 0 0 400,000 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds 0 0 0 0 0 Other Source 0 0 0 0 0 TOTAL 400,000 0 0 0 400,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 50 57 TOTAL 400,000 0 0 0 400,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 50 57 0 0 0 0 0 0 0 0 Page 50 57 A. PROJECT IDENTIFICATION 1. Project Name: 2. Department: 3. Description: B. EXPENDITURE SCHEDULE SUbproi. Expend. cateaory CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 605.00.00.00.1962 Truck PW&D - Water Utility Division 2023 - No Truck Requested 2024 - P/U Truck $46,000 split 50/50 Wtr/Swr 2025 - Crane Truck $85,000 (every 25 years) split 50/50 Wtr/Swr 2026 - P/U Truck $46,000 split 50/50 Wtr/Swr 2027 - P/U Truck $46,000 split 50/50 Wtr/Swr TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other - 25% DPW 0 0 0 0 0 0 111,500 0 23,000 42,500 23,000 23,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 111,500 0 23,000 42,500 23,000 23,000 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 111,500 0 23,000 42,500 23,000 23,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 111,500 0 23,000 42,500 23,000 23,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5. Net impact 0 0 0 0 0 0 E. DESCRIPTION HISTORY Original Date: Revised Date: 58 Page 51 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 605.00.00.00.1926 A. PROJECT IDENTIFICATION 1. Project Name: SCADA Security 2. Department: PW&D - Water Utility Division 3. Description: Back up Scada system for security against cyber attack 50/50 split between Sewer and Water B. EXPENDITURE SCHEDULE SUbgroi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 53,460 17,820 0 17,820 17,820 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 53,460 17,820 17,820 17,820 0 0 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 53,460 17,820 17,820 17,820 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 53,460 17,820 17,820 17,820 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 52 59 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 605.00.00.00.1953 A. PROJECT IDENTIFICATION 1. Project Name: Meters 2. Department: PW&D - Water Utility Division 3. Description: The number of water meters needed is going up due to new construction and the increase number of water meter replacements that are necessary. B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 1,000,000 200,000 0 200,000 200,000 0 200,000 200,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 0 0 0 0 0 0 1,000,000 200,000 200,000 200,000 200,000 200,000 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 1,000,000 200,000 200,000 200,000 200,000 200,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 1,000,000 200,000 200,000 200,000 200,000 200,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 53 60 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 605.00.00.00.00.1960 Struct Impr A. PROJECT IDENTIFICATION 1. Project Name: Construct Filling Station 2. Department: PW&D - Water Utility Division 3. Description: Construct a meter station that would allow accurate tracking of all water sold to contractors that currently connect at a hydrant near the City Garage. B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100,000 100,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 100,000 100,000 0 0 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 100,000 100,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 100,000 100,000 0 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 54 61 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 605.00.00.00.1935 A. PROJECT IDENTIFICATION 1. Project Name: Well Rehabs 2. Department: PW&D - Water Utility Division 3. Description: Well rehab consists of removino the pump from the well and inspectina. repairina or replacina 2023 - Well #13 Iron ifilter the pump as necessary. It also includes treatment to the well, which usually would consist of - medium replacement treating the well with chemicals and some sort of mechanical cleaning. Televising of the bore 2024 - Well #9 hole would usually be included. DNR recommends this to be done every 10 years. The pumps 2025 - Well #8 have never been removed for maintenance or rehab. - Abandonment B. EXPENDITURE SCHEDULE SUbproi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 300,000 150,000 100,000 50,000 0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 1 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue cateaory 300,000 150,000 100,000 50,000 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 300,000 150,000 100,000 50,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 300,000 150,000 100,000 50,000 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 55 62 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 605.00.00.00.1951 A. PROJECT IDENTIFICATION 1. Project Name: Relay Water Mains 2. Department: PW&D - Water Utility Division 3. Description: Replace aging water mains in older areas that are beginning to show signs of age. They would likely be assessed to the adjacent owners but a portion would be paid by the Utility and we would still have to budget for it as we allow a repayment plan. This plan will be more refined as areas of concern are identified more. Areas of concern include Lake Lore, Lake Brittany, Guernsey Meadows, and Kristin Downs. Work with Road Program. B. EXPENDITURE SCHEDULE SUbproi. Expend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other - Bldg Repair 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,210,000 0 550,000 280,000 380,000 0 0 0 0 0 0 0 7,300,000 0 0 3,300,000 1,700,000 2,300,000 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 1 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue cateaory 8,510,000 0 550,000 3,580,000 2,080,000 2,300,000 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8,510,000 0 550,000 3,580,000 2,080,000 2,300,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 1 0 TOTAL 8,510,000 0 550,000 3,580,000 2,080,000 2,300,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 56 63 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: Struct Impr A. PROJECT IDENTIFICATION 1. Project Name: Water Tower - Painting 2. Department: PW&D - Water Utility Division 3. Description: Paint Water Towers 605.54.06.50.5702 Approximately every 15 years. 2024 - Hillendale Drive Tower (This will be adjusted based on 2020 inspection) Full inside and outside painting. Well #12 Storage Tank repainting 2026 - Commerce Water Tower B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60,000 0 30,000 0 30,000 0 0 0 0 0 0 0 800,000 0 450,000 0 350,000 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 860,000 0 480,000 0 380,000 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 860,000 0 480,000 0 380,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 860,000 0 480,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 380,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 57 64 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 605.00.00.00.1952 A. PROJECT IDENTIFICATION 1. Project Name: Relay Water Laterals 2. Department: PW&D - Water Utility Division 3. Description: Replace failing water laterals in Weatherwood Courts subdivision. They appear to be failing B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 125,000 0 0 125,000 0 0 0 0 0 0 0 TOTAL 125,000 0 0 125,000 0 C. FUNDING SOURCE(S) Fund Revenue category 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 125,000 0 0 125,000 0 0 601 Sewer Working Cap. 0 0 0 0 0 0 410 Capital Project Fund 0 0 0 0 0 0 401 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 Other Fund Balance 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 0 0 0 0 0 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds 0 0 0 0 0 Other Source 0 0 0 0 0 TOTAL 125,000 0 0 125,000 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 58 65 TOTAL 125,000 0 0 125,000 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 58 65 0 0 0 0 0 0 0 0 Page 58 65 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 605.00.00.00.1941 A. PROJECT IDENTIFICATION 1. Project Name: Hillendale Booster Station 2. Department: PW&D - Water Utility Division 3. Description: Will boost zone along Hillendale and Racine. Thus far, residents in this area have not shown B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 500,000 0 0 0 0 500,000 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 500,000 0 0 0 0 0 0 500,000 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 500,000 0 0 0 0 500,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 500,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 500,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 59 66 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name: Truck 2. Department: PW&1 3. Description: 2023 - Jet Vac Truck $500,000 (every 15 years) Sewer Only 2024 - P/U Truck $46,000 split 50/50 Wtr/Swr 2025 - Crane Truck $85,000 (every 25 years) split 50/50 Wtr/Swr 2026 - P/U Truck $46,000 split 50/50 Wtr/Swr 2027 - P/U Truck $46,000 split 50/50 Wtr/Swr 601.00.00.00.1922 B. EXPENDITURE SCHEDULE Subproi. Expend. cateq'ory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other - 25% DPW 0 0 0 0 0 0 611,500 500,000 23,000 42,500 23,000 23,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 TOTAL 611,500 500,000 23,000 42,500 23,000 23,000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 611,500 500,000 23,000 42,500 23,000 23,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 611,500 500,000 23,000 42,500 23,000 23,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 60 67 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 601.00.00.00.00.1918 A. PROJECT IDENTIFICATION 1. Project Name: Camera Truck Software 2. Department: PW&D - Sewer Utility Division 3. Description: 2021 - 1 Ton Truck $55,000 split 50/50 Wtr/Swr due to accident. B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 35,000 35,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 35,000 35,000 0 0 0 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 35,000 35,000 0 0 0 0 410 Capital Project Fund 0 0 0 0 0 0 401 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 Other Fund Balance 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 0 0 0 0 0 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds 0 0 0 0 0 Other Source 0 0 0 0 0 TOTAL 35,000 35,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 61 68 TOTAL 35,000 35,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 61 68 0 0 0 0 0 0 0 0 Page 61 68 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 601.00.00.00.1925 A. PROJECT IDENTIFICATION 1. Project Name: SCADA Maintenance 2. Department: PW&D - Sewer Utility Division 3. Description: Back up Scada system for security against cyber attack B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 53,460 17,820 17,820 0 17,820 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 53,460 17,820 17,820 17,820 0 0 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 53,460 17,820 17,820 17,820 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL D. ANNUAL OPERATING IMPACT 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 53,460 17,820 17,820 17,820 0 0 0 0 0 0 0 0 Page 62 69 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 601.00.00.00.1924 A. PROJECT IDENTIFICATION 1. Project Name: Lift Station Upgrades 2. Department: PW&D - Sewer Utility Division 3. Description: 2023 - Replace VFD at McShane Lift Station 2024 - Replace Scrubber at McShane Lift Station 2025 - McShane HVAC Replacement 2026 - Woods HVAC Replacement 2027 - Jensen Lift Station B. EXPENDITURE SCHEDULE SUbproi. EXoend. cateaory TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 415,000 40,000 150,000 75,000 75,000 75,000 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 415,000 40,000 150,000 75,000 75,000 75,000 C. FUNDING SOURCE(S) Fund Revenue cateaory 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 415,000 40,000 150,000 75,000 75,000 75,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 415,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 000 150,000 75,000 75 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5. Net impact 0 E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 Page 63 70 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No A. PROJECT IDENTIFICATION 1. Project Name: Private Property I & 1 2. Department: PW&D - Sewer Utility. 601.65.00.00.6516 3. Description: MMSD is requiring the City of Muskego to spend approximately $1.8 million by 2023 or the City will lose the MMSD funds. B. EXPENDITURE SCHEDULE Subpro/. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,900,000 900,000 250,000 250,000 250,000 250,000 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 1 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 1,900,000 900,000 250,000 250,000 250,000 250,000 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 250,000 0 250,000 1,900,000 900,000 250,000 250,000 TOTAL 1,900,000 900,000 250,000 250,000 250,000 250,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 64 71 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 601.00.00.00.1927 A. PROJECT IDENTIFICATION 1. Project Name: Generator 2. Department: PW&D - Sewer Utility Division 3. Description: 2023 - New Portable Generator B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 100,000 100,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 100,000 100,000 0 0 0 0 100 Gen Fd Op Budget 0 0 0 0 0 0 605 Water Working Cap. 0 0 0 0 0 0 601 Sewer Working Cap. 100,000 100,000 0 0 0 0 410 Capital Project Fund 0 0 0 0 0 0 401 GO Borrowing 0 0 0 0 0 0 Water Borrowing 0 0 0 0 0 0 Sewer Borrowing 0 0 0 0 0 0 100 Gen Fund Balance 0 0 0 0 0 0 Other Fund Balance 0 0 0 0 0 0 State Aid 0 0 0 0 0 0 210 Landfill Funds 0 0 0 0 0 0 202 Park Ded. Funds 0 0 0 0 0 0 Forfeiture Funds 0 0 0 0 0 0 Stormwater Funds 0 0 0 Other Source 0 0 0 TOTAL 100,000 100,000 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 TOTAL 100,000 100,000 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 65 72 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 216.08.00.00.6505 A. PROJECT IDENTIFICATION 1. Project Name: Kelsey Drive Area Study 2. Department: PW&D Storm Water Special Revenue 3. Description: A study needs to be done to determine the stormwater/drainage around Kelsey Drive. B. EXPENDITURE SCHEDULE Subproi. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing 0 0 0 0 0 0 0 0 0 0 0 0 40,000 0 0 0 0 40,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 40,000 0 0 0 C. FUNDING SOURCE(S) Fund Revenue category 0 0 0 40,000 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Ded. Funds Forfeiture Funds 216 Stormwater Funds 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40,000 0 0 0 TOTAL 40,000 0 0 0 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 40,000 0 40,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 66 73 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: 202 & 203.08.94.74.XXXX A. PROJECT IDENTIFICATION 1. Project Name: Parks Projects 2. Department: PW&D Park Dedication Special Revenue 3. Description: See following page for itemized listing. B. EXPENDITURE SCHEDULE Subprol. Expend. category TOTAL 2023 2024 2025 2026 2027 Equipment Vehicle Replacement Stormwater Arch/Engineering Land/ROW/Site Prep Construction Testing Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2,944,000 0 0 691,000 0 0 6,314,500 601,500 1,315,500 762,500 TOTAL C. FUNDING SOURCE(S) Fund Revenue category 6,314,500 601,500 691,000 1,315,500 762,500 2,944,000 100 Gen Fd Op Budget 605 Water Working Cap. 601 Sewer Working Cap. 410 Capital Project Fund 401 GO Borrowing Water Borrowing Sewer Borrowing 100 Gen Fund Balance Other Fund Balance State Aid 210 Landfill Funds 202 Park Dedication & 203 Park Improvement Stormwater Funds Other Source 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5,022,000 0 0 1,315,500 762,500 2,944,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,292,500 601,500 691,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL 6,314,500 601,500 691,000 1,315,500 762,500 2,944,000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 2. Materials 3. Total Cost 4. Offsetting Rev or Savings 5. Net impact E. DESCRIPTION HISTORY Original Date: Revised Date: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Page 67 74 CITY OF MUSKEGO, WISCONSIN PARK DEDICATION SPECIAL REVENUE PROGRAM FUND DETAILED PROJECT LISTING PROJECT NAME LOCATION AND DESCRIPTION ACCOUNT# AMOUNT TOTAL 2023 1 2024 2025 2026 2027 202.08.94.74. EXPENDITURE SCHEDULE All Fields (Baseball, Rugby, Soccer, Football) Baseball: Park Arthur Field Turf Care Field 1, 2, and 3 Baseball: Park Arthur Field 4 Turf (Donation/City = $250,000) Baseball: Park Arthur Field 4 Safety Improvements Baseball: Horn Field safety improvements Baseball: Jensen Field safety improvements Baseball: Kurth Field safety improvements Baseball: Denoon Field safety improvements Baseball: Bluhm Field safety improvements Rugby Field: Bluhm Safety Improvements Soccer Field: Safety Improvements Football Field: Safety Improvements West Park Arthur Developed 6530 6530 6530 6570 6577 6575 6571 6572 6572 6584 6584 6530 $27,000 $3,000 $9,000 $3,000 $9,000 $3,000 $250,000 $0 $0 $250,000 $0 $0 $7,500 $7,500 $0 $0 $0 $0 $35,000 $7,000 $7,000 $7,000 $7,000 $7,000 $15,000 $3,000 $3,000 $3,000 $3,000 $3,000 $22,500 $4,500 $4,500 $4,500 $4,500 $4,500 $20,000 $4,000 $4,000 $4,000 $4,000 $4,000 $37,500 $7,500 $7,500 $7,500 $7,500 $7,500 $5,000 $0 $2,500 $0 $2,500 $0 $10,000 $0 $5,000 $0 $5,000 $0 $10,000 $0 $5,000 $0 $5,000 $0 $2,900,000 $0 $0 $0 $0 $2,900,000 Splash Pad Veterans Park (Splash Pad) 6576 $450,000 $0 $0 $0 $450,000 $0 Parks - Tennis Court/Pickle Court/Basketball Schmidt Freedom Square 6582 6536 $120,000 $0 $0 $120,000 $0 $0 $120,000 $0 $120,000 $0 $0 $0 Dog Park Moorland Park - (Donation/City =$25,000) 6586 $25,000 $25,000 $0 $0 $0 $0 Playground Sets Veterans Park (New Playground Set) Bluhm (New Playground Set) Misc. Playground replacement equipment Wood chips for all playgrounds 6576 6572 6584 6584 $425,000 $425,000 $0 $0 $0 $0 $65,000 $0 $0 $65,000 $0 $0 $25,000 $5,000 $5,000 $5,000 $5,000 $5,000 $50,000 $10,000 $10,000 $10,000 $10,000 $10,000 Boat Ramps Idle Isle (Concrete Boat Ramps) 6579 $150,000 $0 $150,000 $0 $0 $0 Future Trails Martin Drive (Lannon Drive to Oakhill Trail) Veterans Boardwalk 6573 6573 $835,000 $0 $83,500 $751,500 $0 $0 $100,000 $0 $0 $0 $100,000 $0 Park Structures and Lots SandHill Park - Permanent Bathrooms Moorland Park - Pavilion with Bathrooms (water and sewer hookup) Kurth Park - seating and shade by playground Manchester Park - Pavilion by playground 6501 6586 6575 6578 $85,000 $0 $0 $85,000 $0 $0 $250,000 $0 $250,000 $0 $0 $0 $25,000 $0 $25,000 $0 $0 $0 $150,000 $0 $0 $0 $150,000 $0 Box Horn Storage Building Box Horn Building/Landscaping 6585 $0 $0 $0 $0 $0 $0 TOTAL EXPENDITURES $6,214,500 $501,500 $691,000 $1,315,500 $762,500 $2,944,000 GO Borrowing Park Dedication (Landfill Funds) Park Improvements (Subdivider Fees) Other Source - Sports Organizations TOTAL FUNDING SOURCE FUNDING SOURCE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 75 Page 68 Human Resources Post -hire Onboarding Process Overview "Post -hire Onboarding" represents the process that needs to be completed when new employees are hired at an organization. The "post -hire" part is related to where the process typically starts — after a candidate has been selected for hire. We typically start at this point because most organizations already have a system in place to post job requisitions, accept job applications and supporting documents and conduct the interview process. OPG-3 has developed systems to provide this functionality but it would be considered out of scope for the Post -hire Onboarding menu solution. The framework of the menu solution includes the following core components: • Task assignment for initial onboarding activity including o Recording results of background and/or reference checks o Setting up new employee in Finance/HR system o Setting up employee for payroll • Assignment of provisioning tasks using standard provision lists that can be customized by department and/or role and can be updated using a maintenance form moving forward • Assembly of onboarding packet (required paperwork that must be completed) using Laserfiche to pre -fill standard fields, allowing new employees to complete the packet ahead of time and submit on or before their first day of employment • Follow-up tasks to complete performance evaluations A prerequisite to implement the menu solution is to have the HR Infrastructure menu solution in place. The HR Infrastructure solution provides the well -structured file plan (folder structure, standardized naming conventions, metadata schema and retention) and business processes to handle employee name change, termination and rehire. If the HR Infrastructure solution is not in place, it can be combined with the Post -hire Onboarding solution as a single project. Process Summary Where the process will begin with Laserfiche may be different for each organization. Common starting points are: • Recording results of background and/or reference check • Creating and submitting offer letter • Acceptance of offer Background and Reference Check 1. Process is initiated when a candidate has been selected to be hired (new employee or employee changing role) 2. A Laserfiche form is completed to kick-off the process a. Summary information is provided i. Employee Name and demographic information ii. Job, Supervisor,etc. iii. Required information will be finalized through consultation with the county OPC-3 CONFIDENTIAL Muskego — Post -Hire Onboarding Enterprise Transformation Page 1 76 3. Tasks to complete background and reference checks a. Can be assigned to a queue or to specific people based on job/etc. i. Routing logic will be finalized through consultation with the Muskego b. Assigned user completes task form and indicates whether candidate has passed 4. If candidate fails either check, process stops and forms are saved to repository with proper retention Offer Letter 1. If candidate passes background and reference check, an offer letter is generated 2. Task to complete offer letter form is assigned a. Can be assigned to a queue or to specific people based on job/etc. i. Routing logic will be finalized through consultation with the Muskego 3. Offer letter form includes all information required to generate letter a. Upon submission, Laserfiche applies information to Offer Letter template and emails offer letter to candidate i. Can CC HR as well in case there are any follow-up questions about send/receipt b. Candidate responds via email i. Accepts — move on to next step ii. Rejects — process ends, and all documents are kept in repository with proper retention iii. Counter-offers — HR discusses counteroffer and determines response 1. Update Offer Letter form and submit 2. Reject counteroffer Onboarding Once the employee has accepted the position and passed the initial prerequisite checks, the onboarding process begins. The order of the steps below may change for a specific organization but, in general, they will all need to be completed. 1. Task is assigned to set start date and setup employee in Caselle a. Can use Laserfiche Connector profiles to paste information into Casselle i. May use multiple profiles for multiple screens ii. Process different for existing employee changing role b. Can utilize API or web service if available through Casselle 2. Task is assigned to payroll to set up employee to be paid a. Provided with information needed to complete task b. Laserfiche Connector profile may be used to paste information into Casselle c. Can utilize API or web service if available through Casselle 3. Provisioning a. Step needs input from IT, Finance and Department head b. OPG-3 will work with Muskego to set up standard provisions by dept/role i. Can create list of standard provisions by department and/or role ii. Will create "maintenance" form so standard provisions list can be updated/modified for existing roles and new lists can be created for new roles c. Will start with standard provisions OPC-3 CONFIDENTIAL Muskego — Post -Hire Onboarding Enterprise Transformation Page 2 77 i. HR and/or Dept. Head can add remove provisions as needed d. Provisioning tasks will be looping i. 1 task with multiple items per department ii. Can check off items as they're completed, and system will remove them from task iii. HR has oversight so they can answer questions about the process 4. Onboarding paperwork a. OPG-3 will consult with County to develop standardized packets b. Onboarding packet assembled based on role i. HR/Dept Head can add/remove items to be included c. Laserfiche will "prepopulate" packet with standard information wherever possible d. Employee will complete packet i. Can be emailed as PDF form to be completed electronically ii. Can be provided as web form so packet can be completed online (requires Participant License) iii. Can be printed and completed physically e. Employee submits completed paperwork i. Can email completed PDF packet ii. Can be uploaded to web form (requires Forms Portal) iii. Can be signed and submitted via form submission (requires Participant License) iv. Can be signed and submitted via DocuSign (requires DocuSign licenses) v. Can be signed and submitted via signing tool other than DocuSign with API (would require scope change) Pricing OPG-3 does not foresee any additional needs for Laserfiche licensing to accommodate this project. This means that all costs below are ONE TIME COSTS. Project Hours Rate Extended HR Infrastructure with Backfile 50 $185 $9,250 Post -Hire Onboarding Solution 150 $185 $27,750 Total: $37,000 OPC-3 CONFIDENTIAL Muskego — Post -Hire Onboarding Enterprise Transformation Page 3 78 Crty of imSKEGO To: Committee of the Whole Information Technology Department Barbara Loudon Memo cc Mayor Rick Petfalski, Sharon Mueller, Director of Finance & Administration From: Barbara Loudon, Director of Information Technology Date: July 22, 2022 Re: Proposed IT Department 2023 Capital Budget City Network Build Outl Cameras in Parks- Continues: We have currently completed the build out of cameras in 7 parks which is currently 38 cameras. The cameras have proven to be a useful tool, to help curb vandalism and safety in our parks. Our plan will continue to be a phased approach to help plan for budgeting of this project. Attached is the plan Scott and I have discussed for the next phases of implementation. For our 2023 budget cycle, we are proposing cameras in the following parks: 2023- Park Cameras Old Town Hall- (2 cameras)- ($9,000) Bluhm Park- (8 Cameras) — ($23,000) Box Horn Boat Launch (2) — ($14,000) 2023 City Hall External Cameras - Provide 3 external cameras for staff parking and the drop box out front.-$9,000.00 2023 Capital Project Total Park -Camera Build out $46,000 City Hall External $9,000 79 2024- Park Cameras Durham Boat Launch- (9,000) Lake Denoon- Adding Cameras- ($12,000) MFP (Copier) Replacements MFP stand for multi -function printing. This includes, scanning to email, faxes, scanning, copying, etc. Keeping our coping fleet up and operational helps everyone with the city do their jobs more effectively and efficiently. We are looking into a phased approach into buying copiers. There are some departments that are heavier users then others. Many depts usage is between 7,000 to 8,500 sheets a month. The Depts that I would want to replace in 2023 are the following, based on usage: Community Development, Recreation, Mayor and Library 2023 Capital Project Total 4 copier replacements 30,000 80 External Vulnerability Assessment- (Last one completed in 2019) Our last security audit test was helpful in many ways, and we have made some security changes based on that assessment. As cyber indents counite to evolve, we must pro- actively do the best we can to migrate these risks. These type of assessment helps us to understand our current exposure related to providing externally available, internet-based IT services, as well as internal controls They also provide measurable data for our audits and cyber insurances. With the installation and reconfiguration of our new fiber connection, this would be a reasonable time to address any configuration issues that may have been missed during the change over and keep us up to date on best practices as this is a changing slope. We should consider this type of assessment on a regular schedule. This would serve as proof that we do conduct our own audits for compliance with other vendors as well as State level agencies. Project Cost: _ 2023 Capital Project I Security Audit $15,000 Idle Isle Internet connection build out -for stability: As this park becomes busier, and more services being offered to residents. The cameras and pay stations are increasing critical as functions of the park. Our current setup is showing signs of limitations. We are asking for a coax connection (from Spectrum) to be run at Idle Isle for a more stable connection for the camera's and pay stations. This will help cellular connections for pay stations when park is busy or cellular network is congested. Wireless would be the "backup" connection. JW 2023 Capital Project Tot4 Idle Isle Build Out- Spectrum Price (Approx.) $16,500.00 rum '/2 of project ($8,000.00) Misc. Costs, Firewall, one-time fees, etc. $6,500.00 81 Proposed 5-Year Capital Budget Plan 5 Year Projects 2023 2024 2025 13noir�2027 Security Audit -Penetration testing $15,000 $18,000 xpan fireless Camera i� Parks/City-Outside City $55,000 $21,000 Ima Hall Multi -Function Printer/Copiers $30,000 City Firewall Replacement -A 25 00 - New Switches -Library 25,000 &Radio UpgradAHolding for -FE PD- 911- update/upgrade (all 3 agencies -working on) $549,751.44 nrBeginning stage planning DR/Off Site Backupsvm� Fiber Buildout to Parks (2023-Idle) (2024- Arthur) $15,000 $35,000 Replacement SAN/HOSTS $135,000 Siren Updates $15,000 Security Access on Lift Stations/Wells-SCADA over 5 $35, 640 dk$35, 64MR35, 640 Jg�_ W., 2k CPq ,! MUSKEGO POLICE DEPARTMENT Body Worn and Squad Cameras: Chief of Police Stephen Westphal V� 1 / I recommend signing an agreement with Axon to provide body worn cameras (BWCs), squad cameras, automated license plater readers (ALPR), and a cloud based digital evidence platform known as "Evidence.com." to meet and sustain the needs of the Muskego Police Department. History: The Muskego Police Department has operated with squad cameras since 2011 and BWCs since 2019. Recording devices are no longer a "want" they are necessity in 2022 policing for transparency and liability. We have classified numerous complaints as unfounded as a direct result of our recordings. The Waukesha County DA's office and our municipal court has saved countless hours in courtroom testimony due to access to our digital recordings. The trend for law enforcement is more recording tools because they help deter liability and provide more transparency in chaotic situations. We have operated squad cameras with Arbitrator software and hardware while our BWCs are a Safariland product with Vievu software. The Muskego Police Department previously chose a smaller vendor due to, in large part, to cost savings, but the company is now defunct and replacement cameras are no longer available. Our current BWCs are breaking and nearing their end life. We currently are responsible for all the recordings, storage, transmission, and chain of custody for every single recording. A simple traffic crash could result in citizen open records, District Attorney, municipal court, and defense attorney requests for video from each squad camera, each officer's BWC, and even Ring doorbell video that we collect and maintain as evidence. I attached photographs depicting a sampling of the process of categorizing and inventorying the myriad of disks and thumb drives we use to store our digital evidence to demonstrate the need for modernization and increased efficiency. License plate readers (LPRs) have been part of our fleet for several years including a 2021 Capital budget request for $27,000 for purchase to increase our inventory to 2 LPRs. This technology gives the police department the ability to timestamp vehicles throughout southeast Wisconsin as well as give instantaneous data about stolen vehicles or wanted individuals in our city. The Axon proposal upgrades all of our vehicles to latest technology in squad cameras which includes LPRs in every squad camera. The City of Muskego currently utilizes and manages 10 terabytes of digital storage for the Muskego Police Department. We experienced an outage of in our software systems in June of 2022 that resulted in our inability to access our digital evidence for several days. Our own Information Technology staff is currently responsible for the upkeep and maintenance of all those software and hardware systems. Barb and Sam spent several days identifying and correcting the issues tying up our internal resources for the entire city. Evidence.com: Cloud digital storage is the way of the future and dramatically increases our capabilities and service to our citizens. Officers now collect digital evidence from a variety of proprietary W182 S8200 Racine Avenue, Muskego, WI 53150 (262) 679-4130 Fax (262) 679-4113 83 software systems from the Ring doorbell application, to Kohl's surveillance, and surveillance from Tailspin Bar and Grill which is downloaded to disk or thumb drive. Copies of the digital evidence are created and inventoried by hand for our evidence room, the DAs office and even sometimes defense discovery. We are required to provide any of this material due to open records requests which we currently complete by hand with a police clerk and our Administrative Assistant. Officers, with Evidence.com, will now be able to send a secure link to any of our citizens for remote upload from their squad cellular phone. All squad and BWC footage will automatically be categorized and uploaded to a cloud based secure digital site. Release of any of the material is done via secure links to invitees and will greatly enhance the responsiveness and service to our citizenry. Our internal Information technology staff and evidence inventory staff will no longer be responsible for maintenance and upkeep of our digital storage freeing them for other duties and responsibilities throughout the city. 10 terabytes of digital storage will be repurposed for future growth in other areas in the city. In 2019, they city purchased additional digital storage for $17,164 with an annual maintenance cost of $3700. Bidding: We started seeking vendors for BWC replacement earlier this year. We interviewed 3 different vendors including AdvaTech, WatchGuard, and Axon with goal of a one vendor solution. We eliminated Advatech from contention due to the fact they are new to BWC market and they did not offer a digital cloud -based storage system as part of their proposal. They had zero municipalities in the State of Wisconsin using their product at the time of their proposal. 84 We compared the proposals from WatchGuard and Axon on the embedded document and all of our police and IT staff agree that Axon is the right choice for the future of our department due to Axon being the leader in the industry, offering a 10-year option, and that many agencies are already congruent in the technology including: Waukesha, Waukesha County, Brookfield, New Berlin, West Allis, and Racine. West Allis previously signed a 5-year option and are now currently dealing with significant price increases in their renegotiations due to not locking in prices long term. Axon, initially, provided a bid of $98,729 annually for 10 years. Through our own negotiations and use of bids from both New Berlin and WatchGuard Axon dropped their bid to $75,870.97 annually for 10 years which covers warranties, continually upgrades, digital storage, and all maintenance costs. The agreement with Axon will provide a long-term one vendor solution at a fixed predictable cost. The increased efficiency and capabilities directly contribute to the long-term vision of the police department. 11 Muskego Vendor Muskego Axon Muskego AXON Comparison.xlsx BWCupdate.pdf Fleet3update.pdf Ballistic Helmets: Currently, our squads have ballistic helmets and the product shelf life of 5 years expired on 01/05/22. Due to the ballistic helmets being past their expiration date, I am proposing the department purchase new ballistic helmets for all department vehicles. There are twenty-one vehicles in our fleet and this equipment is essential to help protect the officers in a critical incident. Each helmet costs $500.50 and is through a company we have recently used for purchasing ballistic helmets for the Suburban Critical Incident Team. One of the upsides we have identified with this company is that the shelf life of the ballistic helmets is 10 years instead of 5 years. The total cost of the helmets is $10,510.50. I am also requesting tactical face shields to protect the officers in the event the helmets are used for protection during any civil unrest. The last several years of civil unrest in southeast Wisconsin have shown that law enforcement face shields are critical in the protection of the officers. If there is an incident in Muskego or elsewhere that causes some type of civil unrest, our officers need to have the protective equipment available to them to protect their faces. Each tactical face shield is $190.00 for a total of $3,990.00. To protect the helmets and face shields there is a combat helmet bag to store them in. Especially since the shelf life is 10 years for the equipment, we will want them to be in a bag to keep them from getting damaged during that 10 years. Each protective bag is $48.00. The total for the protective bags is $1008.00. 85 The total purchase amount for all the equipment is $15,508.50. The quote is embedded below. 11 Capital Budget Request Quote.pdf Protective Gas Masks: Events of the past few years have demonstrated the increased need for protective mask availability. We currently have Pepperball, pepper spray, and tear gas (OC) in our inventory. We work in conjunction with our combined critical incident team and civil disturbance unit where our officers have been exposed to these irritants. matter of for gas masks.doc Tactical Vests: We have been using tactical vests as part of our critical incident teams for the past 20 years which provide the highest level of defense to officers in critical incidents. Two of our vest are nearing their expiration. matter of for tactical vests.doc 86 Rifle Shields: The events of the past few years have clearly demonstrated the need for easily accessible rifle rated shield protection in every vehicle. The prices have also come down as well as the weight making rifle rated shields the expectation in the law enforcement community. We need 7 additional rifle rated shields to ensure we have this protection at every call. D Quote #Q38180.pdf Respectfully submitted, Stephen Westphal Chief of Police 87