The URL can be used to link to this page

COMMITTEE OF THE WHOLE Packet - 8/27/2013 CITY OF MUSKEGO COMMITTEE OF THE WHOLE AGENDA August 27, 2013 5:00 PM City Hall, W182 S8200 Racine Avenue CALL TO ORDER PLEDGE OF ALLEGIANCE ROLL CALL STATEMENT OF PUBLICE NOTICE APPROVAL OF AGENDA APPROVAL OF MINUTES FROM August 13 and August 15, 2013 NEW BUSINESS 1. Muskego's 50th Anniversary Celebration Update 2. Capital Projects Fund Budgets - Expenditure and Borrowing 3. Establishing a Segregated Fund for Park & Rec Maintenance/Repairs Funded by Landfill for Use after Landfill is Closed (Ald. Soltysiak) COMMUNICATIONS AND MISCELLANEOUS BUISNESS AS AUTHORIZED BY LAW ADJOURNMENT Possible reconvening of the Committee of the Whole immediately following 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, MUSKEGO CITY HALL, (262) 679-4100. 2012 2013 2013 2013 2014 ACCOUNT Prior Year Adopted Current Annual Future NUMBER ACCOUNT DESCRIPTION Actual Budget YTD Projection Projection 7/31/13 See 5-yr REVENUES:for detail 410.08.00.00.4150 GOVERNMENT GRANTS 0 88,120 88,120 88,120 0 410.08.00.00.4542 OTHER FINANCING SOURCES 0 5,300 12,000 26,400 0 410.08.00.00.4552 SALE OF EQUIPMENT 6,175 0 0 0 0 TOTAL REVENUES: 6,175 93,420 100,120 114,520 0 EXPENDITURES: MAYOR / FINANCE & ADMINISTRATION 410.08.90.01.6502 RECODIFICATION - MAYOR 0 0 0 0 45,000 410.08.90.02.6503 SIRE/D.M.S. SOFTWARE - CARRYOVER 56,233 0 5,025 5,025 0 410.08.90.02.6506 INSIGHT VOTING MACHINE 4,950 7,000 0 7,000 7,000 410.08.90.03.6502 CITY HALL RENOVATIONS - MAYOR 5,114 0 34,855 50,000 0 410.08.90.03.6503 UPGRADE FINANCIAL SOFTWARE-CARRYOVER 33,475 0 0 0 0 410.08.90.03.6504 MAIL/POSTAGE MACHINE 3,668 0 0 0 0 TOTAL MAYOR / FINANCE & ADMINISTRATION: 103,440 7,000 39,880 62,025 52,000 ASSESSOR 410.08.90.04.6502 IAS SOFTWARE UPGRADE 0 0 0 0 60,700 COURT 410.08.90.08.6501 COURT PROGRAM 53,535 0 0 0 0 NON-DEPARTMENTAL 410.08.90.06.6504 STUDIO IMPROVEMENTS - CABLE 6,811 0 0 0 0 410.08.90.06.6505 MULTI-CAMERA STUDIO UPGRADE 0 40,000 0 40,000 0 TOTAL NON-DEPARTMENTAL: 6,811 40,000 0 40,000 0 BUILDING MAINTENANCE 410.08.90.09.6502 REPLACE VEHICLE 18,202 0 0 0 0 INFORMATION TECHNOLOGY 410.08.90.14.6502 SERVER REPLACEMENT 12,561 0 0 0 12,000 410.08.90.14.6505 COPIER REPLACEMENTS 8,666 0 0 0 0 410.08.90.14.6506 CIVICPLUS WEBSITE 12,392 12,392 12,392 12,392 12,392 410.08.90.14.6507 TELEPHONE SYSTEM UPGRADE 0 75,000 70,054 75,000 0 410.08.90.14.6508 BACKUP SYSTEM REPLACEMENT 0 21,500 17,011 21,500 0 410.08.90.14.6509 NETWORK STORAGE 0 13,400 12,502 13,400 0 410.08.90.14.6510 GIS MAPPING SOFTWARE 0 22,000 0 0 0 410.08.90.14.6512 FIREWALL REPLACEMENTS 0 0 0 0 25,000 410.08.90.14.6516 VIRTUAL SERVER LICENSING 0 0 0 0 8,000 410.08.90.14.6517 WIRELESS NETWORK EXPANSION 0 0 0 0 6,000 TOTAL INFORMATION TECHNOLOGY: 33,619 144,292 111,959 122,292 63,392 COMMUNITY DEVELOPMENT - PLANNING DIVISION 410.08.90.18.6502 GATEWAY SIGNAGE 36,203 0 0 0 0 410.08.90.18.6507 TRAIL PLANNING 280,558 0 0 0 0 410.08.90.18.6509 UTILITY TERRAIN VEHICLE 0 12,500 12,215 12,215 0 TOTAL CDD - PLANNING: 316,761 12,500 12,215 12,215 0 CITY OF MUSKEGO - CAPITAL EXPENDITURE FUND PROJECTED 2014 BUDGET August 27, 2013 Page 1 2012 2013 2013 2013 2014 ACCOUNT Prior Year Adopted Current Annual Future NUMBER ACCOUNT DESCRIPTION Actual Budget YTD Projection Projection 7/31/13 See 5-yr CITY OF MUSKEGO - CAPITAL EXPENDITURE FUND PROJECTED 2014 BUDGET August 27, 2013 EXPENDITURES (Continued): POLICE 410.08.91.20.6503 CJIS 5,648 0 0 0 0 410.08.91.20.6504 CARPETING - UPDATED QUOTE 8,286 0 0 0 0 410.08.91.20.6505 SPEED LIMIT SIGNS/POLES - ALDERMAN REQ 7,995 0 0 0 0 410.08.91.20.6506 CROSSMATCH FINGERPRINTING SYSTEM 10,233 0 0 0 0 410.08.91.20.6507 REPLACE PORTABLE RADIOS 0 558,904 0 0 603,904 410.08.91.20.6510 NON-LETHAL WEAPONS 0 7,500 5,246 7,500 0 410.08.91.20.6514 SECURITY AND SURVILANCE SYSTEM UPGRADE 0 0 0 0 228,821 410.08.91.20.6515 MUSKEGO FIRING RANGE REPAIR 0 0 0 55,020 0 410.08.91.20.6516 RADIO & TELEPHONE LOGGER UPGRADE 0 0 0 0 15,000 410.08.91.20.6517 TAHOE 0 0 0 0 41,825 TOTAL POLICE: 32,162 566,404 5,246 62,520 889,550 VOLUNTEER FIRE SERVICES 410.08.91.21.6501 REPLACEMENT PUMPER 0 0 0 0 515,866 410.08.91.21.6503 COPY MACHINE/PAGERS/COMPUTERS 61,265 60,000 18,250 60,000 416,900 TOTAL VOLUNTEER FIRE SERVICES: 61,265 60,000 18,250 60,000 932,766 D.P.W. - ENGINEERING DIVISION 410.08.91.19.6508 WOODS RAOD BRIDGE RECONSTRUCTION 0 0 0 0 75,000 D.P.W. 410.08.93.51.6504 INTERSECTION STUDY 0 0 885 5,900 0 410.08.93.51.6507 PICK-UP TRUCK REPLACEMENT 0 60,000 41,715 45,000 0 410.08.93.51.6509 CRUZ AIR 0 275,000 241,546 241,546 0 410.08.93.51.6510 ROADSIDE MOWER DECK 0 0 0 0 10,000 410.08.93.51.6511 RIDING LAWN MOWER 0 0 0 0 6,000 TOTAL D.P.W.: 0 335,000 284,146 292,446 16,000 LIBRARY 410.08.90.71.6503 WIRELESS NETWORK EXPANSION 0 5,300 0 5,300 0 410.08.90.71.6504 MEETING ROOM IMPROVEMENTS 0 0 0 0 15,500 410.08.90.71.6505 FIRE ALARM PANEL REPLACEMENT 0 0 0 0 11,000 TOTAL LIBRARY: 0 5,300 0 5,300 26,500 PARKS 410.08.94.72.6507 3/4 TON DUMP TRUCK REPLACEMENT 35,778 0 0 0 0 410.08.94.72.6508 TRI-DECK ROTARY MOTOR 14,700 0 0 0 0 410.08.94.72.6510 COMMERCIAL OUT FRONT MOWER 0 0 0 0 21,600 410.08.94.72.6511 BOXHORN LAUNCH 181,425 0 0 0 0 410.08.94.72.6512 SHOP IMPROVEMENTS 0 0 0 0 22,883 TOTAL PARKS: 231,903 0 0 0 44,483 TOTAL EXPENDITURES: 857,696 1,170,496 471,696 656,798 2,160,391 Page 2 2012 2013 2013 2013 2014 ACCOUNT Prior Year Adopted Current Annual Future NUMBER ACCOUNT DESCRIPTION Actual Budget YTD Projection Projection 7/31/13 See 5-yr CITY OF MUSKEGO - CAPITAL EXPENDITURE FUND PROJECTED 2014 BUDGET August 27, 2013 OTHER FINANCING SOURCES/(USES): 410.20.00.00.8209 TRF FROM CABLE ACCOUNT 0 40,000 0 40,000 0 410.20.00.00.8210 TRF FROM LANDFILL ACCOUNT 0 1,075,000 0 1,075,000 1,485,000 TOTAL OTHER FINANCING SOURCES/(USES): 0 1,115,000 0 1,115,000 1,485,000 -851,521 37,924 -371,576 572,722 -675,391 FUND BALANCE END OF YEAR 2011: 1,005,224 FUND BALANCE END OF YEAR 153,702 191,626 -217,874 726,424 51,033 NET REVENUES OVER/(UNDER) EXPENDITURES: Page 3 2012 2013 2013 2013 2014 ACCOUNT Prior Year Adopted Current Annual Future NUMBER ACCOUNT DESCRIPTION Actual Budget YTD Projection Projection 7/31/13 REVENUES: 401.08.00.00.4150 GOVERNMENT GRANTS 0 0 0 0 0 401.08.00.00.4531 INTEREST ON INVESTMENTS 1,899 5,000 0 1,000 0 401.08.00.00.4542 MISCELLANEOUS REIMBURSEMENT 0 0 0 0 0 TOTAL REVENUES: 1,899 5,000 0 1,000 0 EXPENDITURES: COMMUNITY DEVELOPMENT/DPW-ENGINEERING 401.08.91.19.6504 PHASE II DURHAM RECONSTRUCTION 316,249 0 0 0 0 401.08.91.19.6507 TESS CORNERS ADDITIONAL EXP 328,811 0 5,949 5,949 0 401.08.91.19.6518 JANESVILLE ROAD RECONSTRUCTION 876,116 1,718,000 1,819,496 3,206,675 885,000 401.08.91.19.6519 PIONEER DRIVE RECONSTRUCTION 1,793,568 0 0 18,543 0 401.08.91.19.6520 NORTHERN GEAR INCENTIVE 0 0 325,000 325,000 0 401.08.91.19.6523 WOODS TRAIL 599,530 30,000 0 0 0 401.08.91.19.6521 LAKE PROPERTY ACQUISITION 22,348 0 0 0 0 TOTAL COMMUNITY DEVELOPMENT/DPW-ENGINEERING: 3,936,622 1,748,000 2,150,445 3,556,167 885,000 CONSERVATION & DEVELOPMENT SPECIAL REVENUE 401.30.00.00.9215 BORST PROPERTY - Net DNR Funding 0 0 0 0 0 TOTAL EXPENDITURES: 3,936,622 1,748,000 2,150,445 3,556,167 885,000 OTHER FINANCING SOURCES/(USES): 401.20.00.00.8902 PROCEEDS FROM L-T DEBT 0 0 0 0 0 401.20.00.00.8605 TRF FROM WATER UTILITY FUND 0 0 0 0 0 401.20.00.00.8210 TRF FROM LANDFILL FUND 0 0 0 0 0 401.30.00.00.9215 TRF TO CONSERVATION FUND 822,180 0 0 0 0 401.30.00.00.9605 TRF TO WATER UTILITY FUND 0 0 0 0 0 TOTAL OTHER FINANCING SOURCES/(USES): -822,180 0 0 0 0 NET REVENUES OVER/(UNDER) -4,756,903 -1,743,000 -2,150,445 -3,555,167 -885,000 FUND BALANCE END OF YEAR 2011: 9,397,124 PROJECTED FUND BALANCE END OF YEAR: 4,640,221 5,852 2,489,776 1,085,054 200,054 WATER UTILITY - BORROWED FUNDING 605.00.00.00.2805 GO NOTE TRANSFER FUNDING 1,074,761 0 0 0 0 605.00.00.00.1953 METERS 37,839 75,000 0 50,000 100,000 605.00.00.00.1962 TRUCK 0 58,750 10,349 58,750 68,750 605.00.00.00.1980 RADIOS 0 28,790 0 0 28,790 605.00.00.00.1989 INDUSTRIAL PARK PIPING 0 0 0 0 129,000 605.00.00.00.1990 BELLE CHASSE PHASE III WELL SITE 0 0 0 0 120,000 605.00.00.00.1972 JANESVILLE ROAD RECONSTRUCTION 135,359 81,050 154,810 264,610 0 605.00.00.00.1988 PIONEER DRIVE RECONSTRUCTION 76,187 0 0 0 0 TOTAL WATER UTILITY EXPENDITURES: 249,385 243,590 165,159 373,360 446,540 GO NOTE REMAINING FUNDS 825,376 452,015 5,475 TOTAL CAPITAL BORROWING SURPLUS/(DEFICIT)205,529 CITY OF MUSKEGO - CAPITAL BORROWING FUND August 27, 2013 PROJECTED 2014 BUDGET Page 1 Borrowing CITY OF MUSKEGO DEBT ISSUANCE - CAPITAL ASSETS INFRASTRUCTURE 2014 PROJECTION Total Estimated YTD 2013 Completed 2012 2011 Total Balance / Project Cost - Description Account Balance Retainage Balance Project Cost Estimate Borrowed Funds Status Durham Drive 401.08.91.19.6504 $315,187.37 $1,061.51 $2,846,189.39 $3,162,438.27 $0.00 $3,162,438.27 605.00.00.00.1987 $0.00 $0.00 $133,779.00 $133,779.00 $0.00 $133,779.00 Capitalize Janesville Road 401.08.91.19.6518 $876,116.18 $0.00 $993,967.70 $1,870,083.88 $3,206,675.34 $5,076,759.22 605.00.00.00.1972 $135,359.40 $0.00 $5,606.25 $140,965.65 $264,610.40 $405,576.05 CIP Lalonde Pioneer 401.08.91.19.6519 $1,728,780.44 $64,787.27 $26,646.17 $1,820,213.88 $18,542.95 $1,838,756.83 Capitalize 605.00.00.00.1988 $76,187.12 $0.00 $745.75 $76,932.87 $0.00 $76,932.87 Capitalize Wolf Woods Trail 401.08.91.19.6523 $576,540.82 $22,989.52 $26,072.50 $625,602.84 $0.00 $625,602.84 Capitalize Musson Tess Corners 401.08.91.19.6507 $288,979.74 $39,830.93 $0.00 $328,810.67 $5,949.40 $334,760.07 CIP Borst Property 215.20.00.00.8401 $822,180.00 $0.00 $0.00 $822,180.00 $0.00 $822,180.00 Capitalize Northern Gear Incentive 401.08.91.19.6520 $0.00 $0.00 $0.00 $0.00 $325,000.00 $325,000.00 Capitalize Water Utility Meters 605.00.00.00.1953 $37,839.00 $0.00 $0.00 $37,839.00 $50,000.00 $87,839.00 Water Utility Truck 605.00.00.00.1962 $0.00 $0.00 $0.00 $0.00 $58,750.00 $58,750.00 Capitalize $12,948,374.15 Interest/Lake Prop Exp/2010 Fund Bal -$14,556.85 2011 Debt Issue $14,500,000.00 2013 Projected Excess/Deficit $1,537,069.00 $1,331,540.00 2014 Projected Excess/Deficit $205,529.00 December 31, 2013 YTD Estimate 2014 Proposed Capital Capital Assets ‐ Summary.xlsx CITY OF MUSKEGO SPECIAL REVENUE FUNDS 2014 PROPOSED BUDGET 2012 2013 2013 2013 2014 ACCOUNT PRIOR YR ADOPTED AMENDED ANNUAL PROPOSED NUMBER ACCOUNT TITLE ACTUAL BUDGET BUDGET PROJECTION BUDGET April 26, 2013 PARK DEDICATION: 202.08.94.74.4140 DNR GRANTS 42,667 0 0 57,299 32,000 202.08.94.74.4350 BOAT LAUNCH LAKE DENOON 3,807 3,700 3,700 3,700 3,700 202.08.94.74.4351 BOAT LAUNCH DURHAM 2,633 3,000 3,000 3,000 3,000 202.08.94.74.4352 BOAT LAUNCH LITTLE MUSKEGO L 368 400 400 400 400 202.08.94.74.4355 BOAT LAUNCH BOXHORN 2,935 3,300 3,300 3,300 3,300 202.08.94.74.4531 INTEREST ON INVESTMENTS 312 300 300 300 300 202.08.94.74.4536 PEPSI PAYMENT 00000 202.08.94.74.4537 PARKS DEPT-WATER BUGS PYMT 7,114 7,078 7,078 7,078 7,078 202.08.94.74.4538 PARK ARTHUR BB FIELD SPONSOR 31,250 145,000 145,000 197,000 0 202.08.94.74.4560 LANDFILL HOST FEES 232,960 146,835 146,835 146,835 146,835 202.20.00.00.8210 TRANSFER FROM LANDFILL FUND 0 1,652,210 1,652,210 1,652,210 1,365,360 202.08.94.74.6530 PARKS - PARK ARTHUR 177,962 1,061,000 1,061,000 1,098,000 714,000 202.08.94.74.6531 PARKS - PARK ARTHUR BB FIELD 32,659 145,000 145,000 65,000 0 202.08.94.74.6535 PARKS - MILL VALLEY SOFTBALL 0 55,000 55,000 55,000 29,500 202.08.94.74.6538 PARKS - TOWN HALL 00000 202.08.94.74.6570 PARKS - HORN PARK 6,027 0 0 0 34,200 202.08.94.74.6571 PARKS - DENOON PARK 56000140,000 202.08.94.74.6572 PARKS - BLUHM PARK 00000 202.08.94.74.6573 PARKS - OFF ROAD TRAILS 949 292,500 292,500 292,500 990,000 202.08.94.74.6575 PARKS - KURTH PARK 0 13,700 13,700 13,700 0 202.08.94.74.6577 PARKS - JENSEN PARK 0 10,000 10,000 0 0 202.08.94.74.6579 PARKS - IDLE ISLE 12,693 112,050 112,050 70,350 73,700 202.08.94.74.6581 PARKS - LIONS 0 10,000 10,000 10,000 0 202.08.94.74.6582 PARKS - SCHMIDT 0 10,000 10,000 10,000 24,077 202.08.94.74.6584 PARKS - OTHER EXPENSES (wood chips/cans) 2,695 14,160 14,160 14,160 79,960 202.08.94.74.6585 PARKS - BOXHORN 74 50,000 50,000 50,000 14,000 202.08.94.74.6586 PARKS - MOORLAND 0 25,000 25,000 20,000 0 REVENUES Total 324,045 1,961,823 1,961,823 2,071,122 1,561,973 EXPENDITURES Total 233,115 1,798,410 1,798,410 1,698,710 2,099,437 PARK DEDICATION Total 90,930 163,413 163,413 372,412 (537,464) FUND BALANCE: 214,646 293,146 293,146 587,058 49,594 Note: $37,000 is reserved for future lauch related maintenance. Page 1 CITY OF MUSKEGO SPECIAL REVENUE FUNDS 2014 PROPOSED BUDGET 2012 2013 2013 2013 2014 ACCOUNT PRIOR YR ADOPTED AMENDED ANNUAL PROPOSED NUMBER ACCOUNT TITLE ACTUAL BUDGET BUDGET PROJECTION BUDGET April 26, 2013 STORM WATER: 216.01.00.00.4531 INTEREST ON INVESTMENTS 614 450 450 450 450 216.01.00.00.4560 LANDFILL HOST FEES 500,000 0 0 0 623,215 216.20.00.00.8210 TRANSFER FROM LANDFILL FUND 00000 216.01.00.00.5805 ATTORNEY 00000 216.08.00.00.5101 SALARIES AND WAGES 12,587 12,852 12,852 12,852 13,238 216.08.00.00.5201 FICA 946 983 983 983 1,012 216.08.00.00.5202 PENSION 747 855 855 855 881 216.08.00.00.5203 HEALTH INSURANCE 1,094 1,389 1,389 1,250 1,344 216.08.00.00.5204 LIFE INSURANCE 10 10 10 10 12 216.08.00.00.5229 HEALTH ALLOWANCE 0 0 0 240 240 216.08.00.00.6503 URBAN RURAL DRAINAGE 37,118 300,000 300,000 0 967,000 216.08.00.00.6557 NR 216 COMPLIANCE MS4 10,782 12,000 12,000 12,000 12,000 216.30.00.00.9301 TRANSFER TO DEBT SERVICE FUND 100,000 75,361 75,361 75,361 0 REVENUES Total 500,614 450 450 450 623,665 EXPENDITURES Total 163,283 403,450 403,450 103,551 995,726 STORM WATER Total 337,330 (403,000)(403,000)(103,101)(372,061) FUND BALANCE: 525,162 107,404 107,404 422,061 50,000 Page 1 CITY OF MUSKEGO SPECIAL REVENUE FUNDS 2014 PROPOSED BUDGET 2012 2013 2013 2013 2014 ACCOUNT PRIOR YR ADOPTED AMENDED ANNUAL PROPOSED NUMBER ACCOUNT TITLE ACTUAL BUDGET BUDGET PROJECTION BUDGET April 26, 2013 210.03.00.00.4531 INTEREST ON INVESTMENTS 6,588 3,000 3,000 4,500 3,000 210.03.00.00.4542 MISCELLANEOUS REIMBURSEMENT 43,292 45,024 45,024 45,024 46,825 210.03.00.00.4560 LANDFILL HOST FEES 1,089,162 900,165 900,165 900,165 900,165 210.03.00.00.5805 ATTORNEY 0 5,000 5,000 0 5,000 210.03.00.00.5815 ENGINEERING FEES 0 3,000 3,000 0 3,000 210.03.00.00.5816 LANDFILL OVERSITE AUDIT 76,296 84,000 84,000 78,000 80,000 210.03.00.00.6055 LANDFILL NEGOTIATING COMM. 0 2,500 2,500 0 2,500 210.03.00.00.6057 ADMINISTRATIVE CHARGES 5,000 5,000 5,000 5,000 5,000 210.30.00.00.9202 TRANSFER TO PARK DEDICATION 0 1,652,210 1,652,210 1,652,210 1,365,360 210.30.00.00.9214 WELL TESTING-TRF TO LANDFILL 00000 210.30.00.00.9215 LAND CONSERV-TRF TO LANDFILL 00000 210.30.00.00.9216 TRANSFER TO STORMWATER FUND 0000623,215 210.30.00.00.9401 TRF TO CAPITAL PROJECTS FUND 00000 210.30.00.00.9410 TRF TO CAPITAL EQUIP FUND 0 1,075,000 1,075,000 1,075,000 1,485,000 REVENUES Total 1,139,042 948,189 948,189 949,689 949,990 EXPENDITURES Total 81,296 2,826,710 2,826,710 2,810,210 3,569,075 LANDFILL Total 1,057,746 (1,878,521)(1,878,521)(1,860,521)(2,619,085) FUND BALANCE: 4,970,639 2,422,167 2,422,167 3,110,118 491,033 Page 1 PROPOSED 2014 CAPITAL PROJECT PLAN & 5-YEAR PROJECT SUMMARY Prepared by City of Muskego Finance & Administration Department Thursday, August 15, 2013 W182 S8200 Racine Avenue, Muskego, WI 53150-0749 Waukesha County, Wisconsin (262) 679-4100 Table of Contents 2014 Capital Improvements Program I Summary of All Projects .......................................................................... 1 Detailed 5-Year Project Description ......................................................... 2 2014 Capital Expenditure Summary ........................................................ 4 Mayor .......................................................................................................... 6  Recodification .................................................................................. 6 Finance & Administration ......................................................................... 7  Insight Voting Machine .................................................................... 7 Assessor .................................................................................................... 8  Revaluation ...................................................................................... 8 Information Technology ........................................................................... 9  Server Replacement ......................................................................... 9  Firewall Replacements ..................................................................... 10  CivicPlus Website ............................................................................. 11  Virtual Server Licensing ................................................................... 12  Wireless Network Expansion ............................................................ 13 Cable Club ............................................................................................................. 14  Unknown .......................................................................................... 14 Police Department ................................................................................................. 15  Replace Portable Radios (Including DPW, Utlity & Parks) .............. 15  Security and Surveillance System Upgrade .................................... 16  Muskego Firing Range Repair ......................................................... 17  Radio and Telephone Logger Upgrade ........................................... 18  Police K-9 ........................................................................................ 19 Table of Contents 2014 Capital Improvements Program II TC Volunteer Fire Department ............................................................................. 20  Equipment (Computers, Pagers, Radios & Pumper Replace) ......... 20 Public Works / Engineering .................................................................................. 21  Janesville Road Reconstruction ....................................................... 21  Woods Road Bridge Reconstruction ................................................ 22  Roadside Lawn Mower ..................................................................... 23  Riding Lawn Mower .......................................................................... 24 Storm Water Management Special Revenue Fund ............................................ 25  Storm Water Project Listing .............................................................. 25 Library .................................................................................................................... 27  Meeting Room Improvements .......................................................... 27  Fire Alarm Panel Replacement ........................................................ 28 Parks & Recreation ............................................................................................... 29  Shop Improvements ......................................................................... 29  Commercial Out-Front Mower .......................................................... 30 Park Dedication Fund ........................................................................................... 31  Various Park Project Listing ............................................................. 31 Water Utility ........................................................................................................... 34  Meters .............................................................................................. 34  Truck Replacement .......................................................................... 35  Riding Lawn Mower .......................................................................... 36  Replace Portable Radios .................................................................. 37  Industrial Park Piping From Water Tower ........................................ 38  Belle Chasse Phase III Well Site ...................................................... 39 Table of Contents 2014 Capital Improvements Program III Sewer Utility ........................................................................................................... 40  Truck Replacement ......................................................................... 40  Riding Lawn Mower ......................................................................... 41  Replace Portable Radios ................................................................. 42  Private Property I & I ....................................................................... 43  Lift Station Upgrades ....................................................................... 44 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM 2014 - 2018 Totals A. PROJECT IDENTIFICATION 1. Project Name:Summary of All Projects 2. Department:All Departments 3. Description: ju EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 3,170,597 1,668,397 701,700 400,500 322,500 77,500 Vehicle Replacement 1,560,013 607,691 282,500 130,000 94,822 445,000 Stormwater 000000 Arch/Engineering 622,000 172,000 250,000 200,000 0 0 Land/ROW/Site Prep 620,000 20,000 0 250,000 350,000 0 Construction 24,095,744 4,376,360 1,803,650 1,699,773 2,105,961 14,110,000 Testing 000000 Other 282,460 167,460 65,000 50,000 0 0 TOTAL 30,350,814 7,011,908 3,102,850 2,730,273 2,873,283 14,632,500 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.395,500 3,000 185,000 67,500 70,000 70,000 601 Sewer Working Cap.643,040 200,540 120,000 172,500 20,000 130,000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 13,331,540 1,331,540 0 0 0 12,000,000 Water Borrowing 1,000,000 0 0 300,000 700,000 0 Sewer Borrowing 000000 100 Gen Fund Balance 000000 261 Other Fund Fd Bal-GIS 000000 State Aid 000000 210 Landfill Funds 14,730,734 5,226,828 2,797,850 2,190,273 2,083,283 2,432,500 202 Park Ded. Funds 000000 209 Cable Funds 000000 503 Library Funds 000000 Other Funding - Grants 250,000 250,000 0 0 0 0 TOTAL 30,350,814 7,011,908 3,102,850 2,730,273 2,873,283 14,632,500 Check Total 000000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 000000 2. Materials 000000 3. Total Cost 000000 4. Offsetting Rev or Savings 5,000 5,000 0 0 0 0 5. Net impact (5,000) (5,000) 0 0 0 0 E. DESCRIPTION HISTORY Page 1 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION 2014 - 2018 Totals 2014 2015 2016 2017 2018 General Government City Hall/Mayor Facilities Planning - - - - - - Recodification 45,000 45,000 - - - - Total 45,000 45,000 - - - - Finance & Administration Voting Machine 35,000 7,000 7,000 7,000 7,000 7,000 Total 35,000 7,000 7,000 7,000 7,000 7,000 Assessor Upgrade IAS Assessment Software 160,700 60,700 50,000 50,000 - - Total 160,700 60,700 50,000 50,000 - - Information Technology Server Replacements 33,000 12,000 6,000 6,000 - 9,000 Firewall Replacements 25,000 25,000 - - - - CivicPlus Website 12,392 12,392 - - - - Virtual Server Licensing 8,000 8,000 - - - - Wireless Network Expansion 6,000 6,000 - - - - Microsoft Exchange Upgrade 5,000 - 5,000 - - - Switch Replacements 22,000 - - 22,000 - - Storage Area Network (SAN)35,000 - - - 35,000 - Email Archiving 6,500 - - - 6,500 - Multi-Funtion Print Device Replacements 5,000 - - - 5,000 - Core Switch 8,000 - - - - 8,000 Total 165,892 63,392 11,000 28,000 46,500 17,000 Cable Club MPAG Multi-Camera Studio Upgrade - - - - - - Total General Government 406,592 176,092 68,000 85,000 53,500 24,000 Public Safety Police Department Replace Porable Radios 603,904 603,904 - - - - Security and Surveillance System Upgrade 228,821 228,821 - - - - Muskego Firing Range Repair (2013?)- - - - - - Radio and Telephone Logger Upgrade 15,000 15,000 - - - - Tahoe (2013 Approved Police K-9)'41,825 41,825 - - - - HVAC 100,000 - 100,000 - - - PSAP Upgrade 140,000 - 140,000 - - - Automatic License Plate Reader 30,500 - - 30,500 - - Replace Boat 15,000 - - - 15,000 - Police Facility 12,000,000 - - - - 12,000,000 Total 13,175,050 889,550 240,000 30,500 15,000 12,000,000 TC Volunteer Fire Department Various Equipment/Vehicles 1,477,766 932,766 65,000 65,000 65,000 350,000 Total Public Safety 14,652,816 1,822,316 305,000 95,500 80,000 12,350,000 Page 2 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION 2014 - 2018 Totals 2014 2015 2016 2017 2018 Transportation DPW-Engineering Janesville Road Reconstruction 885,000 885,000 - - - - Woods Road Bridge Reconstruction 375,000 75,000 300,000 - - - Moorland & Woods Intersection Improv.775,000 - 100,000 675,000 - - Hillendale Drive Phase I & II 4,350,000 - 150,000 450,000 1,750,000 2,000,000 Total 6,385,000 960,000 550,000 1,125,000 1,750,000 2,000,000 Department of Public Works (DPW) Roadside Mower Deck 10,000 10,000 - - - - Riding Lawn Mower 6,000 6,000 - - - - Pickup Truck Replacement 40,000 - 40,000 - - - Motor Grader 100,000 - 100,000 - - - Skid Loader 50,000 - 50,000 - - - Replace Roof (DPW & Util)100,000 - 100,000 - - - Light Duty Boom Truck 80,000 - 80,000 - - - Asphalt Roller 50,000 - - 50,000 - - Front End Loader 170,000 - - 170,000 - - Cargo Van 60,000 - - 60,000 - - Back Hoe 50,000 - - - 50,000 - Total 716,000 16,000 370,000 280,000 50,000 - Total Transportaion 7,101,000 976,000 920,000 1,405,000 1,800,000 2,000,000 Recreation & Education Library Meeting Room Improvements 15,500 15,500 - - - - Fire Alarm Panel Replacement 11,000 11,000 - - - - Self-Check Unit 20,000 - 20,000 - - - Total 46,500 26,500 20,000 - - - Parks and Rec - Operations Shop Improvements 61,267 22,883 12,650 19,773 5,961 - Commercial Out-Front Mower 21,600 21,600 - - - - S-10 Pick-up Truck 22,500 - 22,500 - - - Kubota M4500 Tractor Cab 8,700 - 8,700 - - - Crew Cab (Ford)35,000 - - 35,000 - - 1 Ton Dump Truck Replacement w/ plow 109,822 - - - 54,822 55,000 Toro Goundsmaster 5910 89,000 - - - 89,000 - Shop Drill Press 3,500 - - - - 3,500 Total 351,389 44,483 43,850 54,773 149,783 58,500 Total Recreation & Education 397,889 70,983 63,850 54,773 149,783 58,500 Conservation & Development Community Development City Hall Site Improvements 100,000 - 100,000 - - - Total 100,000 - 100,000 - - - Total Conservation & Development 100,000 - 100,000 - - - Total General Fund 22,658,297 3,045,391 1,456,850 1,640,273 2,083,283 14,432,500 Page 3 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION 2014 - 2018 Totals 2014 2015 2016 2017 2018 Utilities Water Utility Meters 350,000 100,000 100,000 50,000 50,000 50,000 Truck 146,250 68,750 20,000 17,500 20,000 20,000 Riding Lawn Mower 3,000 3,000 - - - - Portable Radios 28,790 28,790 - - - - Industrial Park Piping from Water Tower 129,000 129,000 - - - - Belle Chasse Phase III Well Site 120,000 120,000 - - - - Replace Roof-DPW & Utilities 50,000 - 50,000 - - - Water Tower Cleaning & Inspections 15,000 - 15,000 - - - Water Tower - Painting 600,000 - - 300,000 300,000 - Hillendale Booster Station 400,000 - - - 400,000 - Total 1,842,040 449,540 185,000 367,500 770,000 70,000 Sewer Utility Truck 246,250 68,750 120,000 17,500 20,000 20,000 Riding Lawn Mower 3,000 3,000 - - - - Portable Radios 28,790 28,790 - - - - Private Property I & I 250,000 250,000 - - - - Lift Station Upgrades 315,000 100,000 - 105,000 - 110,000 Replace Roof-DPW & Utilities 50,000 - - 50,000 - - Total 893,040 450,540 120,000 172,500 20,000 130,000 Total Utilities 2,735,080 900,080 305,000 540,000 790,000 200,000 Special Revenue Funds Park Dedication 3,990,437 2,099,437 1,341,000 550,000 - - Storm Water Management 967,000 967,000 - - - - Total 4,957,437 3,066,437 1,341,000 550,000 - - GRAND TOTAL 30,350,814 7,011,908 3,102,850 2,730,273 2,873,283 14,632,500 Page 4 CAPITAL PARK STORM WORKING PROJECT DEPARTMENT BORROWING DEDICATION WATER CAPITAL TOTAL (Landfill Funding)(Operations) FACILITIES PLANNING MAYOR $0 $0 RECODIFICATION MAYOR $45,000 $45,000 INSIGHT VOTING MACHINE FINANCE & ADMINISTRATION $7,000 $7,000 IAS ASSESSMENT SOFTWARE UPGRADE ASSESSOR $60,700 $60,700 SERVER REPLACEMENTS INFORMATION TECHNOLOGY $12,000 $12,000 FIREWALL REPLACEMENTS INFORMATION TECHNOLOGY $25,000 $25,000 CIVICPLUS WEBSITE INFORMATION TECHNOLOGY $12,392 $12,392 VIRTUAL SERVER LICENSING INFORMATION TECHNOLOGY $8,000 $8,000 WIRELESS NETWORK EXPANSION INFORMATION TECHNOLOGY $6,000 $6,000 CABLE CLUB REQUEST CABLE CLUB $0 $0 REPLACE PORTABLE RADIOS POLICE/DPW/P&R $603,904 $603,904 SECURITY AND SURVEILLANCE SYSTEM UPGRADE POLICE $228,821 $228,821 MUSKEGO FIRING RANGE REPAIR (MOVE TO 2013?)POLICE $0 $0 RADIO AND TELEPHONE LOGGER UPGRADE POLICE $15,000 $15,000 TAHOE (2013 APPROVED POLICE K-9) POLICE $41,825 $41,825 RADIOS/PAGERS/COMPUTERS/PUMBER REPLACE TC VOLUNTEER FIRE DEPT $932,766 $932,766 JANESVILLE ROAD RECONSTRUCTION DPW-ENGINEERING $885,000 $885,000 WOODS ROAD BRIDGE RECONSTRUCTION DPW-ENGINEERING $75,000 $75,000 ROADSIDE LAWN MOWER DPW $10,000 $10,000 RIDING LAWN MOWER DPW/WATER & SEWER UTILITY $6,000 $6,000 MEETING ROOM IMPROVEMENTS LIBRARY $15,500 $15,500 FIRE ALARM PANEL REPLACEMENT LIBRARY $11,000 $11,000 SHOP IMPROVEMENTS PARKS & RECREATION $22,883 $22,883 COMMERCIAL OUT-FRONT MOWER PARKS & RECREATION $21,600 $21,600 METERS WATER UTILITY $100,000 $100,000 TRUCK WATER UTILITY $25,000 $25,000 TRUCK - 25% DPW REIMBURSEMENT WATER UTILITY $43,750 $43,750 RIDING LAWN MOWER DPW/WATER & SEWER UTILITY $3,000 $3,000 REPLACE PORTABLE RADIOS WATER UTILITY $28,790 $28,790 INDUSTRIAL PARK PIPING FROM WATER TOWER WATER UTILITY $129,000 $129,000 BELLE CHASSE PHASE III WELL SITE WATER UTILITY $120,000 $120,000 TRUCK SEWER UTILITY $25,000 $25,000 TRUCK - 25% DPW REIMBURSEMENT SEWER UTILITY $43,750 $43,750 RIDING LAWN MOWER DPW/WATER & SEWER UTILITY $3,000 $3,000 REPLACE PORTABLE RADIOS SEWER UTILITY $28,790 $28,790 PRIVATE PROPERTY I & I** SEWER UTILITY $250,000 $250,000 LIFT STATION UPGRADES SEWER UTILITY $100,000 $100,000 PARK PROJECTS - SEE PAGES 77-78 PARK DEDICATION $2,099,437 $2,099,437 STORM WATER PROJECT - SEE PAGE 80 STORM WATER MANAGEMENT $967,000 $967,000 ** MMSD Reimbursement. TOTAL CAPITAL PORJECTS $2,160,391 $0 $1,331,540 $2,099,437 $967,000 $453,540 $7,011,908 (Library/Cable Funding) CITY OF MUSKEGO - 2014 BUDGET CAPITAL EXPENDITURE SUMMARY August 27, 2013 CAPITAL EXPENDITURE (Landfill Funding) (Landfill Funding) Page 5 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Recodification 2. Department:Mayor 3. Description: B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 45,000 45,000 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 45,000 45,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 401 Trnsfr w/in CPF 000000 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 45,000 45,000 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 45,000 45,000 0000 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 000000 E. DESCRIPTION HISTORY Original Date:8/13/2009 Revised Date: 410.08.90.01.6502 Page 6 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Insight Voting Machine 2. Department:Finance & Administration 3. Description:8 Insight optical scan voting machines are requested for the seven polling places, with one back-up machine. The City purchased the existing Eagle voting machines in 1996. The Eagle machines had an expected life of 10 years. Each machine is $6,000, which includes the tabulator, ballot box and memory pack. Request 5 additional purchases in years 2014 - 2018. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 35,000 7,000 7,000 7,000 7,000 7,000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 35,000 7,000 7,000 7,000 7,000 7,000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 35,000 7,000 7,000 7,000 7,000 7,000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 35,000 7,000 7,000 7,000 7,000 7,000 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 000000 E. DESCRIPTION HISTORY Original Date:8/13/2009 Revised Date: 410.08.90.02.6506 Page 7 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Upgrade IAS Assessment Software 2. Department:Assessor 3. Description:Upgrade IAS assessment software to iasWorld. 2015/2016 Interior inspections in conjunction with yearly maint contract & 2017 reval. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 60,700 60,700 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 100,000 0 50,000 50,000 0 0 TOTAL 160,700 60,700 50,000 50,000 0 0 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 160,700 60,700 50,000 50,000 0 0 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 160,700 60,700 50,000 50,000 0 0 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 000000 Note: E. DESCRIPTION HISTORY Interior inspections should be budgeted starting in 2015/2016 for the 2017 revaluation. Next Tyler contract cycle will include yearly maint., reval. And interior inspections. Original Date: Revised Date: 410.08.90.04.6502 Page 8 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Server Replacement 2. Department:Information Technology 3. Description:2014: Esxi2 & Library Management 2015: Esxi3 2016: Esxi1 2017 2018: Esxi2 & MBG B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 33,000 12,000 6,000 6,000 0 9,000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 33,000 12,000 6,000 6,000 0 9,000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 33,000 12,000 6,000 6,000 0 9,000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 33,000 12,000 6,000 6,000 0 9,000 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 000000 E. DESCRIPTION HISTORY Original Date:8/8/2003 Revised Date:7/10/2009 8/11/2011 410.08.90.14.6502 Page 9 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Firewall Replacements 2. Department:Information Technology 3. Description:Replace the Fortinet Fortigate 200A, 50B and Fortianalyzer. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 25,000 25,000 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 25,000 25,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 25,000 25,000 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 25,000 25,000 0000 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 000000 E. DESCRIPTION HISTORY Original Date:8/8/2003 Revised Date:7/30/2012 410.08.90.14.6512 Page 10 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:CivicPlus Website 2. Department:Information Technology 3. Description:Remaining installments due per contract. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 12,392 12,392 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other Contingency 000000 TOTAL 12,392 12,392 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 12,392 12,392 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 12,392 12,392 0000 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 000000 E. DESCRIPTION HISTORY Original Date:7/10/2009 Revised Date:7/30/2012 410.08.90.14.6506 Page 11 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Virtual Server Licensing 2. Department:Information Technology 3. Description:Additional licensing required to add an additional server to the existing virtual server environment. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 8,000 8,000 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 8,000 8,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 8,000 8,000 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 8,000 8,000 0000 D. ANNUAL OPERATING IMPACT (if any) 1. Personnel 0 2. Materials 0 3. Total Cost 0 4. Offsetting Rev or Savings 00 5. Net impact 000000 E. DESCRIPTION HISTORY Original Date:7/10/2009 Revised Date:7/30/2012 410.08.90.14.6516 Page 12 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Wireless Network Expansion 2. Department:Information Technology 3. Description:Replace wireless local area network equipment at city hall and expand wireless network capabilities to the Police Department and DPW facilities. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 6,000 6,000 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 6,000 6,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 6,000 6,000 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Library Funds 000000 Other Source 000000 TOTAL 6,000 6,000 0000 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 000000 E. DESCRIPTION HISTORY Original Date:7/10/2009 Revised Date:7/30/2012 410.08.90.14.6517 Page 13 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name: 2. Department:Cable Club 3. Description: B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 000000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 000000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 000000 202 Park Ded. Funds 000000 Cable Funds 000000 Stormwater Funds 000000 Other Source-Cable 000000 TOTAL 000000 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 000000 E. DESCRIPTION HISTORY Original Date:8/1/2002 Revised Date:8/8/2003 7/13/2004 410.08.90.06.6504 Page 14 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Replace Portable Radios 2. Department:All Departments 3. Description:Upgrade the entire two-way radio system from analog to digital to stay current with the Waukesha County Communication System. DPW 28 6 Utility 11 2 Police 19 37 Parks 9 8 Tornado 1 11 Fire Base 1 0 + Graphic User Interface = $125,000 B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 603,904 603,904 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 603,904 603,904 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 603,904 603,904 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 603,904 603,904 0000 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 000000 E. DESCRIPTION HISTORY Original Date:9/3/2008 Revised Date:8/1/2012 8/1/2013 401.08.91.20.6507 Mobile @$4,615 x 69 = $318,435 Hand-Held @ $3,407 x 64 = $218,048 Page 15 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Security and Survilance System Upgrade 2. Department:Police Department/City Hall 3. Description:City Hall camera system - $68,616.38. Replacement of 16 cameras and an additional 9 cameras - $96,000.87. Proximity door locks for Police Department and City Hall - $64,203.75. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 228,821 228,821 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 228,821 228,821 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 228,821 228,821 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 228,821 228,821 0000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date: 410.08.91.20.6514 Page 16 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Muskego Firing Range Repair 2. Department:Police Department 3. Description:Three berms are in various stages of failure and require major repairs. (Requested move to 2013) B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 000000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 000000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 401 Trnsfr w/in CPF 000000 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 000000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 000000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date: DETAILED PROJECT DESCRIPTION 410.08.91.20.6515 Page 17 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Radio and Telephone Logger Upgrade 2. Department:Police Department 3. Description:Purchase a new logger (recorder) cabable of recording the new digital telephone and digital radio system. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 15,000 15,000 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 15,000 15,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 15,000 15,000 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 15,000 15,000 0000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date:8/1/2002 Revised Date:9/18/2003 410.08.91.20.6516 Page 18 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Tahoe 2. Department:Police Department 3. Description:2013 - Establish a police K-9 unit for the Police Department. 2014 - Replace Tahoe used for K-9 - $38,825 (Aldermen added $3,000 for 4-wheel drive). B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 000000 Vehicle Replacement 41,825 41,825 0000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 41,825 41,825 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 41,825 41,825 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 41,825 41,825 0000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date: 410.08.91.20.6517 Page 19 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Equipment 2. Department:Tess Corners Volunteer Fire Department 3. Description:2014: Notebook/Desktop Computers (5@$3,750 + 2@$850) = $20,450 Pager Replacements (10 @ $545) = $5,450 Mobile Radios (110 @ $3,500 + $6,000 installation in offices & vehicles) = $391,000 Pumper/Tanker 1 @ $515,866 B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 611,900 416,900 65,000 65,000 65,000 0 Vehicle Replacement 865,866 515,866 0 0 0 350,000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 1,477,766 932,766 65,000 65,000 65,000 350,000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 1,477,766 932,766 65,000 65,000 65,000 350,000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 1,477,766 932,766 65,000 65,000 65,000 350,000 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 000000 E. DESCRIPTION HISTORY Original Date:8/13/2009 Revised Date: 401.08.91.21.6504 Page 20 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Janesville Road Reconstruction 2. Department:DPW-Engineering 3. Description:2012: WE Energies utility burying Lannon/Racine $1,535,490 (+/- 20%). Added extra $100k for burying utilities outside of ROW in commercial zones. AT&T utility burying Lannon/Racine $25,000. Approximately 12 commercial and 13 residential properties will need conversion to buried utilitie resulting costs to help them convert (budgeted $3,500 per property = $87,500). 2013: Approximately $1,260,000 for streetscaping + $500,000 contingency ($240k removed since County Federal grant will take care of 80% of path costs now). B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 000000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 885,000 885,000 0000 Testing 000000 Other 000000 TOTAL 885,000 885,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 885,000 885,000 0000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 000000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source - TIF 000000 TOTAL 885,000 885,000 0000 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 000000 E. DESCRIPTION HISTORY Original Date:9/1/2008 Revised Date:8/13/2009 401.08.91.19.6518 Page 21 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Woods Road Bridge Reconstruction 2. Department:DPW- Engineering 3. Description:Design and reconstruction of the existing Woods Road bridge (near Lannon Drive). Existing bridge is beginning to fail and we currently have a weight restriction on the bridge. If the bridge begins to fail at a pace any faster than it is now, we may need to move construction ahead of the planned year of 2015. A grant has been applied for and will reduce these numbers dramatically if received. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 000000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 75,000 75,000 0000 Land/ROW/Site Prep 000000 Construction 300,000 0 300,000 0 0 0 Testing 000000 Other 000000 TOTAL 375,000 75,000 300,000 0 0 0 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 401 Trnsfr w/in CPF 000000 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 375,000 75,000 300,000 0 0 0 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 375,000 75,000 300,000 0 0 0 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 000000 E. DESCRIPTION HISTORY Original Date:7/31/2012 Revised Date: 401/410.08.91.19.6508 Page 22 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Roadside Mower Deck 2. Department:Public Works 3. Description:Replace existing mower deck attachment that has reached the end of its useful life. Used for mowing roadsides and ditches. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 10,000 10,000 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other Contingency 000000 TOTAL 10,000 10,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 10,000 10,000 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 10,000 10,000 0000 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 000000 E. DESCRIPTION HISTORY Original Date:7/24/2013 Revised Date: 410.08.93.51.6510 Page 23 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Riding Lawn Mower 2. Department:Public Works 3. Description:Replace existing zero turn riding mower used for mowing City Garage, Lift Stations and Wells. Existing mower has reached the end of it's useful life. Total Cost is $12,000 with 50/50 split between DPW and Utilities DPW share is $6,000 B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 6,000 6,000 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 6,000 6,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 6,000 6,000 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 6,000 6,000 0000 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 000000 E. DESCRIPTION HISTORY Original Date:7/24/2013 Revised Date: 410.08.93.51.6511 Page 24 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Storm Water Projects 2. Department:Stormwater/Engineering 3. Description:Listing - following page. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 000000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 97,000 97,000 0000 Land/ROW/Site Prep 20,000 20,000 0000 Construction 850,000 850,000 0000 Testing 000000 Other 000000 TOTAL 967,000 967,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 967,000 967,000 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 967,000 967,000 0000 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 000000 E. DESCRIPTION HISTORY Original Date:8/8/2003 Revised Date:8/24/2003 7/7/2005 216.08.00.00.XXXX 25 CITY OF MUSKEGO, WISCONSIN STORM WATER MANAGEMENT SPECIAL REVENUE PROGRAM FUND DETAILED PROJECT LISTING PROJECT NAME DESCRIPTION ACCOUNT # TOTAL 2014 2015 2016 2017 2018 216.08.00.00. Richdorf Culvert Replacement Replace existing corrugated metal pipe with a larger reinforced concrete box culvert to 6505 702,000 702,000 0000 alleviate flooding that is experienced at Circle and Richdorf. Gold Drive Storm Sewer Install new concrete storm sewer and swale to alleviate flooding of homes on Gold Dr. 6506 150,000 150,000 0 0 00 and Island Dr. There is a small chance this will still be constructed in 2013. Pioneer Drive Storm Sewer Install new concrete storm sewer and swale to alleviate flooding of homes on Pioneer Dr. 6507 115,000 115,000 0000 This may still be constructed in 2013. TOTAL EXPENDITURES 967,000 967,000 0000 GO Borrowing 0 00000 Landfill Funds 0 00000 Park Ded. Funds 0 00000 Other Source 0 00000 TOTAL FUNDING SOURCE 0 00000 AMOUNT EXPENDITURE SCHEDULE FUNDING SOURCE Page 26 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Meeting Room Improvements 2. Department:Library 3. Description:14 rectangular tables and four round tables to replace older, heavier tables. The new tables would be lighter, fold up and roll on wheels, making it easier for the Library and City maintenance staff and public using the rooms to move them. LCD Projector, speakers, screen, and mounting equipment for public meeting room 4. The existing projector is at the end of its useful life, and a mounted system would provide easier access for the public and staff. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 15,500 15,500 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other Contingency 000000 TOTAL 15,500 15,500 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 401 Trnsfr w/in CPF 000000 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 15,500 15,500 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 15,500 15,500 0000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date: 410.08.90.71.6504 DETAILED PROJECT DESCRIPTION Page 27 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Fire Alarm Panel Replacement 2. Department:Library 3. Description:Replacement of existing fire alarm panel and annunciator to new XLS system components. All MXL series addressable field devices to remain. The existing panel is original to the building and is at the end of its useful life. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 11,000 11,000 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 11,000 11,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 11,000 11,000 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 11,000 11,000 0000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date: 410.08.90.71.6505 Page 28 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Shop Improvements 2. Department:Parks & Recreation 3. Description:Replace lunch room floor and 2 overhead insulated garage doors (20' x 12') @ Parks Headquarters. Upgrade lighting system from 10 sodium fixtures to 16 fluorescent and replace 1992 HVAC system (3 furnaces & 1 AC) @ PHQB in 2014. Director switched HVAC replacements to exterior repais of building (7/2/10). Cost estimates confirmed for 3-years worth of shop implrovements. Painting of PHQB exterior B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 000000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 61,267 22,883 12,650 19,773 5,961 0 Testing 000000 Other 000000 TOTAL 61,267 22,883 12,650 19,773 5,961 0 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 61,267 22,883 12,650 19,773 5,961 0 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 61,267 22,883 12,650 19,773 5,961 0 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 000000 E. DESCRIPTION HISTORY Original Date:8/1/2008 Revised Date:8/13/2009 410.08.94.72.6512 Page 29 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A PROJECT IDENTIFICATION 1. Project Name:Commercial Out Front Mower 2. Department:Parks & Recreation 3. Description:Replace 2001 out-front mower in 2011. Replace 2002 out-front mower in 2013. Replace out-front mower in 2014 (not in 2013). B EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 21,600 21,600 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 21,600 21,600 0000 C FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 21,600 21,600 0000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 21,600 21,600 0000 D ANNUAL OPERATING IMPACT (if any) 1. Personnel 0 2. Materials 0 3. Total Cost 0 4. Offsetting Rev or Savings 5,000 5,000 5. Net impact (5,000) (5,000)0000 E.DESCRIPTION HISTORY Original Date:8/1/2005 Revised Date:8/13/2009 410.08.94.72.6510 Page 30 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Parks Projects 2. Department:Park Dedication 3. Description:Listing - following page. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 000000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 3,910,477 2,019,477 1,341,000 550,000 0 0 Testing 000000 Other 79,960 79,960 0000 TOTAL 3,990,437 2,099,437 1,341,000 550,000 0 0 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 3,990,437 2,099,437 1,341,000 550,000 0 0 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 3,990,437 2,099,437 1,341,000 550,000 0 0 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 000000 E. DESCRIPTION HISTORY Original Date:7/6/2012 Revised Date: 202.08.94.74.XXXX Page 31 CITY OF MUSKEGO, WISCONSIN PARK DEDICATION SPECIAL REVENUE PROGRAM FUND DETAILED PROJECT LISTING PROJECT NAME DESCRIPTION ACCOUNT # TOTAL 2014 2015 2016 2017 2018 202.08.94.74. Baseball Field Restoration 2014=Mill Valley I, II, III & Horn / 2015=Bay Lane I, II & Denoon (top-dressing) 6535/6570/6571/6588 90,000 59,000 31,000 0 0 0 Boxhorn Warehouse Improvements Painting, rain gutters, aluminum trim, service doors, removal of built on narrow 6585 14,000 14,000 0 000 room, railings and misc. Parking lot striping to be done by DPW (2013 or 2014). Quote from Lang Construction received in 2012. Overhead door already replaced. Lease for 50% storage space of warehouse with gun club expires June, 2014. Denoon Park Paving Current asphalt failed in many areas. Road/parking lots/basketball court areas in 6571 140,000 140,000 0 0 0 0 dire need of asphalt repair. Was reflected in 2013 park satisfaction surveys. This paving work will be done with the city paving program. Paving will be 3.5' and will required 10,000 square yards. Engineering work done in house. Playground Fibar Wood Chips Need to be added to all playgrounds for safety reasons. Unlike regular wood chips, 6589 67,000 67,000 0 000 fibar wood chips are rounded wood chips and are ADA compliant, along with being approved for playground surfacing. All 11 sites will require a total of 1,807 yards of fibar wood chips at a depth of between 10"-12". Future Trails (Install & Eng. Services) After this year's trail installation, costs will be determined for future years. 6573 0 0 0 0 00 2015 - Lannon Road (Janesville to Martin) 2016 - Hillendale (Racine to College) w/ grant & College Ave. (Martin to Hillendale) 2017 - Martin Road (Lannon to College) & Bay Lane Drive (Janesville to Woods) 2018 - Racine Avenue (Hillendale to Janesville) Parks Garbage Cans Remaining 2013 cans to replace rest of garbage barrels in all parks (50-55 gal). 6584 12,960 12,960 0 0 0 0 Horn Park Ballfield Drainage Fix Install 6" PVC pipe with basin and grate from 3rd base dugout to connect with basin 6570 4,700 4,700 0 0 0 0 behind 1st base dugout. Includes building up 3rd base bullpen and drainage under home plate. Hwy. OO Trail Install 8' wide recreation trail along Hwy. OO from Durham Drive to Hwy. 36. This 6573 700,000 700,000 0 0 0 0 Amounts avail by 8/27 cost includes engineering services from Waukesha County. Idle Isle Fishing Pier & Path Paving Fishing pier grant status will be known in late fall of 2013. Trail paving was held off 6579 73,700 73,700 0 0 0 0 so that both jobs (new ADA fishing pier/paved trail) could be done at the same time since trail connection was going to change a bit to a 90-degree access to the pier. Path = 117x2 = 234 sq. yd. x $26.20 = $9,700. Pier = $64,000 EXPENDITURE SCHEDULE AMOUNT Page 32 CITY OF MUSKEGO, WISCONSIN PARK DEDICATION SPECIAL REVENUE PROGRAM FUND DETAILED PROJECT LISTING PROJECT NAME DESCRIPTION ACCOUNT # TOTAL 2014 2015 2016 2017 2018 202.08.94.74. EXPENDITURE SCHEDULE AMOUNT Park Arthur West Grading - Phase I Demolition, Grading, Stone Installation, Seed & Erosion Control - $664,000 / 6530 2,574,000 714,000 1,310,000 550,000 0 0 Engineering Services - $50,000 Utilities - $430,000 / Engineering Services - $40,000 Site Improvements - $800,000 (does not include College Ave entrance/sport league donations) / Engineering Services - $40,000 Paved Entrances to Schmidt Park Pave both entrances to Schmidt Park (50' - off Conrad Ct. & 140' off Fleetwood Rd. = 6582 24,077 24,077 0 0 0 0 Amounts avail by 8/27 200 sq. yds.) WE-Energies Trail Expansion DPW will install a traffic bond trail from County Park to Big Bend border. Big Bend 6573 40,000 40,000 0000 installing their trail in 2013 from border to their main park (about 2.7 miles). Cost for traffic bond and soil sterilant to prevent weed growth. This project is 8,800 if (almost 2 miles) and could be phased in over 2014/2015 depending on DPW's schedule/time. Woods Road Trail Install Woods Road trail from Racine Avenue west to Windover Drive (south side). 6573 250,000 250,000 0 0 0 0 Trail is 4,300 if (1 mile). Engineering services will be done in-house. TOTAL EXPENDITURES 3,990,437 2,099,437 1,341,000 550,000 0 0 GO Borrowing 000000 Landfill Funds 000000 Park Ded. Funds 000000 Other Source 000000 TOTAL FUNDING SOURCE 000000 FUNDING SOURCE Page 33 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Meters 2. Department:Water Utility 3. Description: B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 350,000 100,000 100,000 50,000 50,000 50,000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 350,000 100,000 100,000 50,000 50,000 50,000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.250,000 0 100,000 50,000 50,000 50,000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 100,000 100,000 0000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 000000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 350,000 100,000 100,000 50,000 50,000 50,000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date: 605.00.00.00.1953 Page 34 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Truck 2. Department:Water Utility 3. Description:2014 - Dump Truck $50,000 split 50/50 Wtr/Swr 2015 - P/U Truck $40,000 split 50/50 Wtr/Swr 2016 - P/U Truck $35,000 split 50/50 Wtr/Swr #29 2017 - P/U Truck $40,000 split 50/50 Wtr/Swr 2018 - P/U Truck $40,000 split 50/50 Wtr/Swr 2024 - Confined Space Truck every 15 years split 50/50 Wtr/Swr B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 000000 Vehicle Replacement 102,500 25,000 20,000 17,500 20,000 20,000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other - 25% DPW 43,750 43,750 0000 TOTAL 146,250 68,750 20,000 17,500 20,000 20,000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.77,500 0 20,000 17,500 20,000 20,000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 68,750 68,750 0000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 000000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 146,250 68,750 20,000 17,500 20,000 20,000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date: 605.00.00.00.1962 Page 35 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Riding Lawn Mower 2. Department:Water Utility 3. Description:Replace existing zero turn riding mower used for mowing City Garage, Lift Stations and Wells. Existing mower has reached the end of it's useful life. Total Cost is $12,000 with 50/50 split between DPW and Utilities DPW share is $6,000 B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 3,000 3,000 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 3,000 3,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.3,000 3,000 0000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 000000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 3,000 3,000 0000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date: 605.00.00.00.1962 Page 36 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Portable Radios 2. Department:Water Utility 3. Description: Utility 11 2 50/50 Split - Water/Sewer B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 28,790 28,790 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 28,790 28,790 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 28,790 28,790 0000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 000000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 28,790 28,790 0000 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 000000 E. DESCRIPTION HISTORY Original Date:9/14/2005 Revised Date: Mobile @$4,615 x 11 = $50,765 Hand-Held @ $3,407 x 2 = $6,814 605.56.09.35.6067 Page 37 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Industrial Park Piping from Water Tower 2. Department:Water Utility 3. Description:9/12/12 R&M Estimate of $104,000 per Utility Superintendent need to increase by $25,000 B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 000000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 129,000 129,000 0000 Testing 000000 Other 000000 TOTAL 129,000 129,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 129,000 129,000 0000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 000000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 129,000 129,000 0000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date: 605.00.00.00.1989 Page 38 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Belle Chasse Phase III Well Site 2. Department:Water Utility 3. Description:Purchase of site for a future City well. Site was previously tested and should provide a very good well site. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 00000 0 Vehicle Replacement 00000 0 Stormwater 00000 0 Arch/Engineering 00000 0 Land/ROW/Site Prep 00000 0 Construction 120,000 120,000 0 0 0 0 Testing 00000 0 Other 00000 0 TOTAL 120,000 120,000 0 0 0 0 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 00000 0 605 Water Working Cap.00000 0 601 Sewer Working Cap.00000 0 410 Trnsfr w/in CPF 00000 0 401 GO Borrowing 120,000 120,000 0 0 0 0 Water Borrowing 00000 0 Sewer Borrowing 00000 0 100 Gen Fund Balance 00000 0 Other Fund Fd Bal 00000 0 State Aid 00000 0 210 Landfill Funds 00000 0 202 Park Ded. Funds 00000 0 Forfeiture Funds 00000 0 Stormwater Funds 00000 0 Other Source 00000 0 TOTAL 120,000 120,000 0 0 0 0 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 00000 0 E. DESCRIPTION HISTORY Original Date: Revised Date: 605.00.00.00.1990 Page 39 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Truck 2. Department:Sewer Utility 3. Description:2014 - Dump Truck $50,000 split 50/50 Wtr/Swr 2015 - P/U Truck $40,000 split 50/50 Wtr/Swr 2016 - P/U Truck $35,000 split 50/50 Wtr/Swr #29 2017 - P/U Truck $40,000 split 50/50 Wtr/Swr 2018 - P/U Truck $40,000 split 50/50 Wtr/Swr 2024 - Confined Space Truck every 15 years split 50/50 Wtr/Swr B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 000000 Vehicle Replacement 202,500 25,000 120,000 17,500 20,000 20,000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other - 25% DPW 43,750 43,750 0000 TOTAL 246,250 68,750 120,000 17,500 20,000 20,000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.246,250 68,750 120,000 17,500 20,000 20,000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 000000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 246,250 68,750 120,000 17,500 20,000 20,000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date:7/25/2013 601.00.00.00.1922 Page 40 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Riding Lawn Mover 2. Department:Sewer Utility 3. Description:Replace existing zero turn riding mower used for mowing City Garage, Lift Stations and Wells. Existing mower has reached the end of it's useful life. Total Cost is $12,000 with 50/50 split between DPW and Utilities DPW share is $6,000 B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 3,000 3,000 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 3,000 3,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.3,000 3,000 0000 401 Trnsfr w/in CPF 000000 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 000000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 3,000 3,000 0000 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 000000 E. DESCRIPTION HISTORY Original Date:7/24/2013 Revised Date: 601.00.00.00.1927 Page 41 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Portable Radios 2. Department:Sewer Utility 3. Description: Utility 11 2 B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 28,790 28,790 0000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 000000 Testing 000000 Other 000000 TOTAL 28,790 28,790 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.28,790 28,790 0000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 000000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 28,790 28,790 0000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date: Mobile @$4,615 x 11 = $50,765 Hand-Held @ $3,407 x 2 = $6,814 601.65.00.00.6221 Page 42 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Private Property I & I 2. Department:Sewer Utility 3. Description:Will be reimbursed by the MMSD, B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 000000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 250,000 250,000 0000 Testing 000000 Other 000000 TOTAL 250,000 250,000 0000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.000000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 000000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source-MMSD 250,000 250,000 0000 TOTAL 250,000 250,000 0000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date: 601.65.00.00.6516 Page 43 CITY OF MUSKEGO, WISCONSIN CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A. PROJECT IDENTIFICATION 1. Project Name:Lift Station Upgrades 2. Department:Sewer Utlilty 3. Description:Upgrade control modules and panels and place in an above ground enclosure. B. EXPENDITURE SCHEDULE Subproj. Expend. category TOTAL 2014 2015 2016 2017 2018 Equipment 000000 Vehicle Replacement 000000 Stormwater 000000 Arch/Engineering 000000 Land/ROW/Site Prep 000000 Construction 315,000 100,000 0 105,000 0 110,000 Testing 000000 Other 000000 TOTAL 315,000 100,000 0 105,000 0 110,000 C. FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 000000 605 Water Working Cap.000000 601 Sewer Working Cap.315,000 100,000 0 105,000 0 110,000 410 Trnsfr w/in CPF 000000 401 GO Borrowing 000000 Water Borrowing 000000 Sewer Borrowing 000000 100 Gen Fund Balance 000000 Other Fund Fd Bal 000000 State Aid 000000 210 Landfill Funds 000000 202 Park Ded. Funds 000000 Forfeiture Funds 000000 Stormwater Funds 000000 Other Source 000000 TOTAL 315,000 100,000 0 105,000 0 110,000 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 000000 E. DESCRIPTION HISTORY Original Date: Revised Date:7/25/2013 601.00.00.00.1924 Page 44 SUPPLEMENTAL INFORMATION 5-YEAR CAPITAL PLAN 2014 - 2018 Thursday, August 15, 2013 City of Muskego - Finance & Administration Department W182 S8200 Racine Avenue, Muskego, WI 53150-0749 Waukesha County, Wisconsin (262) 679-4100 Table of Contents 5-Year Capital Improvements Program Supplemental Information I Finance & Administration ........................................................................ 1 Information Technology ........................................................................... 2 Police .......................................................................................................... 6 Parks & Recreation ................................................................................... 8 Page 1 Memo To: Committee of the Whole Cc: Mayor Kathy A. Chiaverotti From: Sharon Mueller, Finance & Administration Director Date: August 15, 2013 Re: 2014 Capital Budget The information provided below outlines the requested 5-year Capital Plan for the Finance & Administration Department. Project 2014 2015 2016 2017 2018 Insight Voting Machines $ 7,000 $ 7,000 $ 7,000 $ 7,000 $ 7,000 Insight Voting Machines: With the exception of three insight voting machines purchased in 2008, 2010 and 2012, the current optical scan voting machines used at the polling places were purchased in 1996. It is recommended by Waukesha County as well as the Government Accountability Board (GAB) that the optical scan voting machines be replaced sooner rather than later due to the enhanced features allowing for a more accurate tabulation of votes, updated technology and increased risk of equipment failure with the outdated machines. The cost for each insight voting machine, including the ballot box, memory pack, carrying case and one-year warranty should not exceed $7,000. In addition to the purchase price is an annual maintenance fee of $280.00 each, which is already included in the General Fund Operating budget. Five machines are due for replacement. Please note the newly elected Waukesha County Clerk has formed a task force committee to select an outside consulting firm to study the county’s election process and equipment. To date, two firms have met the initial interview requirements of the committee. Both firms have indicated that with the exception of one company’s product, moving away from the insight voting machines would be a number of years down the road. Updates with this process will be communicated to the Finance Committee. Finance & Administration Department Information Technology Department John Wisniewski Director of Information Technology (262) 679‐4150 jwisniewski@cityofmuskego.org Memo To: Committee of the Whole Cc: Mayor Kathy Chiaverotti; Sharon Mueller, Director of Finance & Administration From: John Wisniewski, Director of Information Technology Date: July 24, 2013 Re: Proposed IT Department 2014 Capital Budget Firewall Replacements The primary city firewall and the library firewall are network devices which protect the city network from intrusions by foreign and or other untrusted networks. These devices act as a barrier to control network traffic into and out of the organizations internet connected network and provide segmentation and routing of the internal network. The existing city firewall devices have reached the end of their product lifecycle and no longer support current or future releases of the operating system or firmware. Maintaining current operating system and firmware updates is imperative on these devices to ensure stability and to maintain current intrusion detection and prevention protocols that are continually evolving as more sophisticated security threats emerge throughout the Internet. The existing firewall devices are 7 years old and have become increasingly more unstable and have exhibited recent signs of impending hardware failure, resulting in disruptions to daily public safety, library, and general city operations. I am recommending replacing both firewalls with modern firewall solutions that can provide the city with the following capabilities:  Malware & antivirus signature detection  File & data filtering  User integration & authentication  Threat prevention and detection  Web content & URL filtering  VPN & remote access  Granular reporting Page 2 Project Cost: 2014 Capital Project Total Primary Firewall Replacement $22,000 Library Firewall Replacement $3,000 Total $25,000 Virtual Server Host Replacement The physical computing power required for the city virtual server environment is supplied by three physical server hosts that currently operate as a cluster of memory and cpu resources for 34 virtual servers. The virtual server environment is configured for high availability however a physical server host failure could significantly impact city operations. Due to the importance and mission critical nature of these servers to all city operations, it is strongly recommended that these servers are replaced on a 4 year rotating cycle. Project Cost: 2014 Capital Project Total Virtual Server Host Replacement $6,000 Total $6,000 Library Network Management Server The library public access network, which is segregated from the city network, is comprised of public access PC’s, WCFLS online catalog PC’s, in addition to print management and wireless systems. This network has become increasingly more complex as the library has made recent investments in technology to create operational efficiencies and to serve an increasingly more sophisticated customer. At present this network lacks management tools that are necessary to effectively and efficiently manage these network resources. I am recommending the implementation of an enterprise management server which will be used to manage, update, and deploy windows updates, antivirus, policy, authentication, dynamic IP addressing, and printing. This server will also be required for library application virtualization initiatives planned for 2014. Project Cost: 2014 Capital Project Total Library Server $6,000 Total $6,000 CivicPlus Website In 2014 the final installment of the city’s new CivicPlus website is due per the terms of the CivicPlus contact approved by Common Council resolution #37-2012. Project Cost: 2014 Capital Project Total Website Installment $12,392 Total $12,392 Page 3 Server Virtualization Host Licensing The city currently replicates all virtual servers on a daily basis from the city’s primary storage area network located in the police department to a storage area network located at city hall. This purpose of this replication is to provide the city with continuity of business operations and disaster recovery in the event the city’s primary data center was rendered inoperable. In an effort to provide for more geographic separation between the primary data center and the replica virtual server environment and to provide true rapid disaster recovery, I am proposing the relocation of the storage area network located at city hall to the public library and the acquisition of additional virtual server licensing that will be required to add an additional virtual server host at the public library. This additional virtual server host will provide the computing power to the replica servers in the event all production virtual server hosts were rendered inoperable. Project Cost: 2014 Capital Project Total Virtual Server Licensing $8,000 Total $8,000 Wireless Network City departments currently utilize technology based workflows or systems that could greatly be improved by, or will soon require, wireless connectivity to the city network. At present the only city facility with a city wireless network is city hall. This wireless network is based on residential grade equipment and was designed to provide temporary wireless networking capabilities for the 2010 paperless packet initiative until the city could fund the acquisition of proper equipment. The wireless network equipment at city hall has proven to be unreliable, unstable, and is not suitable for city business. Based on the organizations current need for reliable wireless network connectivity, I am recommending the installation of an enterprise wireless network that will provide staff with wireless network connectivity at all city facilities with the exception of the parks garage. This wireless network will also serve as the foundation for future mobility initiatives and will allow for the possibility of publicly available internet access at city hall. Project Cost: 2014 Capital Project Total Wireless Network $6,000 Total $6,000 Page 4 Proposed 5-Year Capital Budget Plan 5 Year Projects 2014 2015 2016 2017 2018 Server Replacements $12,000 $6,000 $6,000 $9,000 Firewalls $25,000 Switches $22,000 Core Switch $8,000 Email Archive $6,500 Virtualization Licensing $8,000 Microsoft Exchange Upgrade $5,000 CivicPlus Website $12,392 Multi-Function Printer/Copiers $5,000 City Wireless Network $6,000 Storage Area Network $35,000 Totals $63,392 $ 11,000 $28,000 $46,500 $17,000 Page 5 TO: Mayor Chiaverotti FROM: Captain John Z. La Tour DATE: August 1, 2013 (amended) RE: Radio Upgrade Costs In a memo I wrote to the Finance Committee regarding Waukesha County Communication’s Infrastructure dated September 3, 2008, (see attached). I informed all interested parties of the County’s intention to upgrade the radio system from the current analog system to an all-digital system. At that time the City of Muskego chose to continue with annual payments to the County to off-set the City’s fair share payment of the infrastructure. The current status of the project is now in the design phase. There are still numerous issues that need to be addressed. Several of the issues that directly affect our community are: the addition of an antenna in the southeast portion of the county to provide proper signal for public safety radios; the integration of the radio-activated tornado sirens and the ability to digitally transmit the necessary tones to activate the fire department’s knox-box system. After the system design is complete, a written Request for Proposal (RFP) will be drafted. According to Waukesha County officials, they are hopeful to release the RFP in the first quarter of 2013, with the winning bid being awarded mid-year 2013. Implementation of the new system will then begin. In order to manage the entire communications system, the GUI (Graphic User Interface) will have to be replaced to operate the digital radio system, and control the fire department’s knox-box system. The City of Muskego utilizes two types of radios; hand-held and mobile. Upon reviewing the status of the two-way radios currently utilized by the City of Muskego, I have determined that the current number of radios is as follows: Page 6 Mobile Hand-Held D.P.W. 28 6 Utility 11 2 Police (veh.+base) 19 37 Park & Rec. 9 8 Tornado 1 11 Fire Base 1 Total: 69 64 I spoke with the area Motorola representative to obtain current pricing for mobile and hand-held radios that would be compatible with the new digital system. The current state-bid price for a mid-grade mobile unit is $4615.00 and a mid-grade hand-held unit is $3407.00. 69 mobile units X $4615.00 = $318,435.00 64 hand-held units X $3407.00 = $218,048.00 Graphic User Interface $125,000.00 Total: $661,483.00 Page 7 PARKS AND RECREATION DEPARTMENT CAPITAL EQUIPMENT BUDGET – 5 YEAR PLAN 2014-2018 2014 Capital Budget Request (Year 1) 1. Replace 2002 1-ton Dump and Plow Attachment (replacement in 2018) $35,000. 2. Shop Improvements  Upgrade lighting system from 10 sodium fixtures to 16 fluorescent $ 3,435.  Flooring-1,100 sq. ft./2 garage doors (not approved for 2013) $19,448. 3. Replace Out-front Mower (current year 2002) $16,600. Justification: All mowers are an integral part of our operation. Because of mowing requirements, all the pieces need to be in working order at all times. If one piece goes down, it puts the strain on other mowers. We currently mow 55+ acres of parkland/public open space. Mower is 12 years old. Sale of 2002 mower estimated at $5,000 (reflected in cost to the right) TOTAL $39,483. 2015 Capital Budget Request (Year 2) 1. Replace a ¼-ton Park Patrol Truck with 4-wheel Drive (current year 2006) $22,500. 2. Shop Improvements  Exterior repairs (tuckpointing, remove/replace lintels, remove large chimney to roof line & terminate) $12,650. 3. New Tractor Cab for Kubota M4500 $ 8,700. TOTAL $43,850. 2016 Capital Budget Request (Year 3) 1. Replace 2003 Ford Crew Cab $35,000. 2. Shop Improvements  Roofing of PHQB $19,773. TOTAL $54,773. Page 8 2017 Capital Budget Request (Year 4) 1. Replace 1998 1-ton Dump Truck (with plow) $54,822. *this replaces the F-350 with an F-550 2. Purchase New Toro Groundsmaster 5910 $89,000. 3. Shop Improvements * Painting of the PHQB exterior $ 5,961. TOTAL $149,783. 2018 Capital Budget Request (Year 5) 1. Replace 2002 1-ton Dump and Plow Attachment (replacement in 2018) $55,000. 2. Shop drill press (Ellis model 9400) with accessories $ 3,500. 3. 72” clam shell bucket attachment (branch pick-up) $ 3,500. TOTAL $62,000. 5-YEAR GRAND TOTAL $349,889. Page 9