#3F 2009 Note Issue Evaluation Matrix - Exhibit VJJW-9/9/2009
Exhibit V
City of Janesville
Proposed 2009 Note Issue - Project Evaluation Matrix Sorted by Fund and Average Weighted Score
Evaluation Criteria
Service
Total
Score
Maintain an
Established
Supporting a
Fiscal Impact
Quality of Life
Other Projects
Primary
Relationship to
Local Economy
Health & Safety
Outside Funding
Stimulate/Sustain
Weighted Total
Necessary Service
Project DescriptionPrimary FundFund CostTotalAverageTotalAverageTotalAverageTotalAverageTotalAverageTotalAverageTotalAverageTotalAverage
Average Weighted
Group
1Street Maintenance and ImprovementsGeneral Fund$750,000924.18632.86733.32954.32884.00683.09813.68964.366812,904132.00
1Ruger Avenue Bridge (Eng.)General Fund$100,000873.95753.41693.14894.05723.27542.45803.64924.186422,782115.92
12008 Flood RepairsGeneral Fund$370,000803.81743.52572.71823.90803.81592.81833.95813.866212,654115.39
1Fire Station #1 Construction (year 2)General Fund$1,000,000843.82663.00703.181004.55753.41512.32411.861004.556092,689112.04
1Ambulance Replacement (2000 model)General Fund$200,000934.23673.05431.951044.73914.14401.82281.271004.555872,631109.63
1New and Replacement SidewalksGeneral Fund$450,000803.64642.91582.64803.64803.64612.77562.55773.505782,528105.33
1Public Safety EquipmentGeneral Fund$80,000853.86703.18462.09894.05723.27502.27311.41964.365592,487103.63
1Transit Services Center Construction (year 4)General Fund$425,000522.36663.00683.09833.77773.50592.68974.41994.506242,479103.29
1Curb and Gutter Replacement & ReconstructionGeneral Fund$390,000743.36612.77572.59843.82723.27632.86642.91904.095872,476103.17
1Boat, Motor, Trailer Replacement (Fire)General Fund$32,000803.64703.18411.86873.95733.32351.59291.32884.005222,35498.08
1ERP Phase III (Billing, Licensing, Special Assess.)General Fund$100,000371.68632.86542.45894.05693.14713.23281.27904.095202,14189.21
1Downtown Parking StructureGeneral Fund$2,750,000381.73592.68753.41663.00723.27592.68301.36572.594742,07986.63
1Youth Sports FacilityGeneral Fund$500,000351.59572.59592.68542.45823.73492.23743.36582.644871,98482.67
Group 1 General Fund Subtotal$7,147,000
2Building MaintenanceGeneral Fund$500,000693.14622.82592.68813.68622.82602.73321.45944.275382,33197.13
2Transit Capital ProjectsGeneral Fund$21,600542.45783.55522.36773.50663.00452.05863.91823.735612,32897.00
2E. Milwaukee St. Pedestrian UnderpassGeneral Fund$195,000743.36612.77502.27632.86703.18431.95693.14572.595072,23893.25
2Technology EnhancementsGeneral Fund$100,000341.55663.00532.41894.05673.05632.86301.36823.735022,09687.33
2Property Acquisitions (neighborhood/downtown)General Fund$500,000502.27622.82582.64542.45693.14512.32512.32502.274632,03384.71
2Replace Playground EquipmentGeneral Fund$70,000562.55683.09351.59663.00793.59321.45291.32813.684632,01583.96
2GIS EnhancementsGeneral Fund$25,000351.59652.95482.18753.41582.64602.73331.50793.594701,95581.46
2Bike Trail (Tripp Road to Eau Claire Road)General Fund$60,000371.68632.86502.27482.18853.86472.14612.77592.684681,93980.79
2Parking Lot - Parker & Court StreetsGeneral Fund$75,000321.45532.41542.45472.14431.95421.91261.18431.953531,57971.77
2Tallman House RepairsGeneral Fund$250,000331.50381.73542.45492.23673.05321.45261.18793.593921,59466.42
2Skate Board ParkGeneral Fund$50,000251.14502.27341.55331.50642.91261.18673.05261.183391,41358.88
Group 2 General Fund Subtotal$1,846,600
General Fund Total$8,993,600
1Library Radio Frequency Identification (Phase II)Hedberg Public Library$350,000321.41622.64472.00662.77662.86532.18261.14672.864341,84473.76
Group 1 Hedberg Public Library Subtotal$350,000
2General Building Repairs - Hedberg Public LibraryHedberg Public Library$50,000461.95783.32572.45843.59773.36431.73291.27954.095272,26698.52
2Library Multimedia Equipment (Prog./Train./Mtg.. Rms.)Hedberg Public Library$15,000261.25542.45361.60582.65612.90331.45271.30562.553651,54573.57
Group 2 Hedberg Public Library Subtotal$65,000
Hedberg Public Library Total$415,000
1New Landfill - Construction of Phase 2Sanitation$325,000843.82642.91592.68974.41783.55703.18421.91984.456142,663110.96
1New Landfill - Phase 3 Const, & Leachate UpgradesSanitation$1,180,000863.91592.68622.82954.32733.32703.18431.951034.686132,639109.96
1Horizontal Gas CollectionSanitation$30,000863.91633.00552.50934.23753.41703.18462.09984.456082,624109.91
1Closure of Phase ISanitation?783.90552.75542.70814.05653.25663.30412.05874.355492,365107.50
1Landfill Scale/Scalehouse ReplacementSanitation$140,000673.05673.05562.55894.24582.64552.50421.91934.235472,360107.27
Group 1 Sanitation Fund Subtotal$1,675,000
2Landfill/Compost Site PavingSanitation$60,000522.36522.36542.45632.86462.09421.91361.64663.004271,86777.79
2Roll-off ContainersSanitation$30,000502.63442.32371.95482.53392.05361.89341.79512.683541,55373.95
Group 2 Sanitation Fund Subtotal$90,000
Sanitation Fund Total$1,765,000
JJW-9/9/2009
Exhibit V
City of Janesville
Proposed 2009 Note Issue - Project Evaluation Matrix Sorted by Fund and Average Weighted Score
Evaluation Criteria
Service
Total
Score
Maintain an
Established
Supporting a
Fiscal Impact
Quality of Life
Other Projects
Primary
Relationship to
Local Economy
Health & Safety
Outside Funding
Stimulate/Sustain
Weighted Total
Necessary Service
Project DescriptionPrimary FundFund CostTotalAverageTotalAverageTotalAverageTotalAverageTotalAverageTotalAverageTotalAverageTotalAverage
Average Weighted
Group
1Street Lights - New Streets and SubdivisionsSpecial Assessment$15,000793.59843.82552.50793.59693.14612.771064.82703.186272,686111.92
1Stormwater Drainage StructuresSpecial Assessment$250,000573.17472.61462.56603.33472.61452.50412.28543.004161,820101.11
1Street ExtensionsSpecial Assessment$48,000512.32803.64663.00693.14552.50652.951004.55552.505632,37999.13
12008 Flood Repairs - StormwaterStormwater$40,000934.23763.45612.77914.14843.82582.64904.09924.186702,879119.96
1Stornwater Manhole rehab./ReplacementStormwater$300,000793.59652.95602.73904.09663.00743.36431.95904.095892,559106.63
1E. RiverwallStormwater$50,000643.56512.83452.50653.61512.83382.11372.06593.284301,91595.75
1Highridge ErosionStormwater$575,000693.45613.05492.45663.30592.95391.95371.85582.904572,08894.91
Group 1 Stormwater Fund Subtotal$1,278,000
2PineviewStormwater$25,000533.12482.82392.29553.24402.35372.18311.82452.653661,64796.88
2Palmer DriveStormwater$25,000543.18482.82392.29563.29422.47372.18311.82472.763721,67087.89
2Arbor Ridge OutfallsStormwater$150,000533.12472.76392.29543.18392.29372.18311.82452.653631,63185.84
2Pole Camera for Storm Sewer InspectionsStormwater$20,000532.41642.91341.55793.59472.14431.95311.41713.234381,92180.04
Group 2 Stormwater Fund Subtotal$220,000
Stormwater Fund Total$1,498,000
1Development Incentives (TIF #27)TIF$315,000301.50663.30924.60673.35562.80502.50582.90603.005002,139106.95
1Development Incentives (TIF #26)TIF$200,000301.50683.40924.60653.25562.80502.50592.95623.105032,14797.59
Group 1 TIF Fund Subtotal$515,000
TIF Fund Total$515,000
1Sewer LateralsWastewater$50,000743.36863.91632.86894.05743.36652.95773.67793.596312,741125.30
1Inflow/Infiltration ReductioonWastewater$125,000783.55733.32592.68944.27723.27663.00411.95924.185972,619119.73
1Sewer Main Repair/ReplacementWastewater$50,000914.14713.23602.73954.32783.55683.09422.00974.416252,757115.48
1Sewer ExtensionsWastewater$250,000743.36763.45632.86833.77723.27622.82703.33733.325962,604109.07
1Interceptor Sewer ExtensionsWastewater?683.40633.15562.80793.95653.25572.85532.79743.705372,327106.38
Group 1 Wastewater Fund Subtotal$475,000
Wastewater Fund Total$475,000
1North Zone Reservoir RepairWater$150,000934.23713.23602.73974.41783.55552.50452.14984.456202,751125.05
1Lead Water Service ReplacementWater$350,000974.41693.14562.55934.23763.45753.41452.141004.556342,779116.40
1Undersized Water Main ReplacementWater$376,000853.86683.09612.77964.36763.45763.45482.29994.506322,729114.30
1Water Main ReinforcementWater$610,000873.95683.09612.77974.41743.36703.18452.14964.366212,715113.72
1Water Manhole and Valve ReplacementWater$157,000783.55713.23602.73894.05723.27823.73462.19954.326162,647110.87
1Water Main/Service InsulationWater$350,000853.86693.14572.59944.27723.27652.95452.14954.326042,643110.70
1Water Transmission MainsWater?663.30633.15542.70783.90673.35592.95402.11814.055292,289104.64
1Subdivision Water Main ExtensionsWater?633.15663.30542.70773.85613.05552.75492.58773.855232,259103.27
1Water LateralsWater?603.00683.40542.70773.85592.95592.95492.58753.755222,251102.90
Group 1 Water Fund Subtotal$1,993,000
2East Side Water Tower (Land Acquisition)Water$300,000783.55632.86632.86914.14773.50492.23462.19924.185802,537115.98
Group 2 Water Fund Subtotal$300,000
Water Fund Total$2,293,000
Grand Total$15,954,600
Group 1 - Priority projects that need to be funded because of prior funding commitment, continuation of a previously funded project, or a public safety need.
Group 2 - All projects not Priority 1