Attachment 1 Energy Audit Master.XLSX
XLSX spreadsheet 23 KB Posted
- Attached to
- LED Lighting Conversion State and local contract opportunity
- Solicitation number
- RFB-25-BM14-0-2025/MV
- Issued by
- Dane County, Wisconsin
About this file
This document is an energy audit master spreadsheet for a municipal energy efficiency project across multiple facilities in Wisconsin, including Station 1, Fleet Maintenance, City Hall, Westside, Public Works, and Museum locations. The comprehensive energy audit details multiple potential improvement projects focused on lighting, HVAC equipment, water fixtures, and solar installations, with specific recommendations for LED lighting replacements, heat pump installations, water fixture upgrades, and solar panel implementations. The audit evaluates each project's annual building savings, total costs, incentives, net costs, and simple payback periods, with most projects targeting CIP (Capital Improvement Program) or BM (Building Maintenance) fund allocations for implementation between 2025-2035.
The financial analysis reveals significant potential energy savings and cost reductions, with solar installations planned for Fleet Maintenance, Public Works, and Station 1 totaling approximately $993,082.50. Each solar project demonstrates conservative annual energy savings ranging from $13,520 to $25,716, with return on investment periods between 15.4 and 16.2 years. The projects are supported by tax credits and Focus rebates, helping offset initial installation costs. Funding sources include CIP funds, tax credits, and potential grants, with specific budget allocations noted for various improvements across different municipal facilities. The audit recommends strategic upgrades that balance energy efficiency, operational improvements, and long-term cost savings.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| 25-BM14 Draft Contract.PDF | ||
| 25-BM14 LED Lighting Conversion.PDF | ||
| Firestation 1 Lighting Floor Plan.PDF | ||
| WCSB 1st Floor Power Area B.PDF | ||
| WCSB 1st Floor Lighting Area B.PDF | ||
| Firestation 1 Lighting Floor Plan 2.PDF | ||
| Fleet Lighting Plan.PDF | ||
| WCSB 1st Floor Light & Power Area A.PDF | ||
| WCSB 2nd Floor Light & Power Area B.PDF |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
ENERGY EFFICIENCY
| Added to 2026-2035 CIP | Fund via BM fund (Focus rebates) | |||||||||||
| STATION 1 | ||||||||||||
| ECR no. | Area of Work | ECR Title | Reason for Evaluation | Annual Building Savings | Total Cost | Incentives | Net Costs | Simple Payback Years | CIP / BM Fund | Notes | ||
| Remove from request to Ben | 1 | Lighting | Replace Fluorescent Lighting with LED Alternative | Inefficient Lighting | $1,519 | $6,015 | $1,260 | $4,755 | 3.1 | CIP | 282 lights need replacing; 50% reduction in power draw; unsure if pricing includes fixture upgrade/replacement. Already included in 2025 CIP | lump sum for lighting in station 1, Fleet, Westside lighting replacements |
| 2 | HVAC Equipment | Replace Furnaces with Heat Pump Alternative | Inefficient Equipment | $418 | $50,000 | $630 | $49,370 | 118.1 | CIP (28/29) | ECM blower motor (x4) + 3 ton HP (x2) + 6 ton HP (x2). Confirm if this unit is on the roof (Jon). | ||
| Energy efficient generator - MSA grant in 2025? | Jon is requesting this for CIP 2026 | |||||||||||
| 3 | HVAC Control | Implement Demand Control Ventilation to Reduce Heating and Cooling Needs | Lack of HVAC control | $628 | $7,500 | $860 | $6,640 | 10.6 | CIP (28/29) | $239,803 | ||
| 4 | HVAC Control | Install Programmable Thermostats to Reduce Heating and Cooling Needs | Lack of HVAC control | $95 | $1,100 | $360 | $740 | 7.8 | BM Fund (2025) | |||
| 5 | Water Fixtures | Replace Water Fixtures with Low Flow Alternative | Inefficient Equipment | $849 | $2,570 | 3.0 | ||||||
| Low Cost ECM Total | $2,659 | $64,615 | $3,110 | $61,505 | 23 | |||||||
| FLEET MAINTENANCE | ||||||||||||
| ECR no. | Area of Work | ECR Title | Reason for Evaluation | Annual Building Savings | Total Cost | Incentives | Net Costs | Simple Payback Years | CIP / BM Fund | Notes | ||
| 1 | Lighting | Replace Fluorescent Lamps with LED Alternative | Inefficient Lighting | $1,250 | $6,627 | $430 | $6,198 | 5.0 | CIP | 80 lights need replacing; 50% reduction in power draw; unsure if pricing includes fixture upgrade/replacement. Already included in 2025 CIP | ||
| 2 | Lighting | Replace Exterior CFL with LED Alternative | Inefficient Lighting | $103 | $184 | $48 | $136 | 1.3 | CIP | 24 lights need replacing; 50% reduction in power draw; unsure if pricing includes fixture upgrade/replacement. Already included in 2025 CIP | ||
| 3 | Lighting Control | Install Dual Technology Occupancy Sensors in Bathrooms | Inefficient Lighting Control | $56 | $320 | $19 | $301 | 5.4 | BM Fund | Can install internally w/BM staff | ||
| 4 | HVAC equipment | Replace Hot Water Heater with Heat Pump Alternative | Inefficient Equipment | $81 | $5,700 | $100 | $5,600 | 69.0 | CIP (27) | The DHW heater is overdue for replacement (installed 2006). Natural gas powered DHW would cost $4500, so really there is only an increased cost of $1200 to upgrade to heat pump. Look into this - need to have regular usage of heat pump to prevent issues. Check with PD/FD on how often we use hot water heater. | *did not include hot water heater upgrades in CIP | |
| 5 | HVAC Control | Use Demand Control Ventilation for RTUs | Lack of HVAC control | $720 | $5,000 | $860 | $4,140 | 5.8 | CIP (27) | RTU DCV automatically adjusts the ventilation rate based on the needs of the space, optimizing energy efficiency and indoor air quality. Is this for the garage area? We believe we already have venitallation controls for offices & breakroom. ROSE TO CHECK WITH KEVIN. Lump w/city Hall | ||
| 6 | Water Fixtures | Replace Water Fixtures with Low Flow Alternative | Inefficient Equipment | $167 | $660 | 4.0 | ||||||
| Low Cost ECM Total | $2,211 | $17,831 | $1,456 | $16,375 | 7.4 | *hot water heater heat pump upgrade for multiple facilities + HVAC controls | ||||||
| CITY HALL | ||||||||||||
| ECR no. | Area of Work | ECR Title | Reason for Evaluation | Annual Building Savings | Total Cost | Incentives | Net Costs | Simple Payback Years | CIP / BM Fund | Notes | ||
| 1 | Lighting | Install controls for lighting, vending and exhaust fans | Inefficient Lighting | $482 | $885 | $155 | $731 | 1.5 | BM Fund | Men & women's basement locker rooms, PD conference room, stairwell, 1st floor breakroom. Jon will look into this. Locker rooms were recently remodeled - may have lighting sensors installed. May need to contract out exhaust fans on sensors. | ||
| 2 | HVAC Equipment | Install a Heat Pump Type Domestic Hot Water Heater | Inefficient Equipment | $191 | $6,900 | $100 | $6,800 | 35.6 | CIP | 2 existing water heaters. Do a bit more research. Already in CIP for 2026; $65,000 budgeted) | ||
| 3 | HVAC Equipment | Install a Condensing Boiler for Building Heating Hot Water | Inefficient Equipment | $1,918 | $62,000 | $10,000 | $52,000 | 27.1 | CIP | Modulate between 90 - 180 deg F, between OAT of -20 - 60 deg F (compared to always 160F with existing unit). Scheduled for spring 2025. $236000. Highly efficient natural gas boiler. | ||
| 4 | HVAC Control | Install Variable Frequency Drives for HHW Distribution | Lack of HVAC control | $311 | $3,092 | $240 | $2,852 | 9.2 | CIP (27) | Lump w/fleet | ||
| 5 | HVAC Control | Install Variable Frequency Drives for Cooling Tower Fan | Lack of HVAC control | $764 | $4,200 | $800 | $3,400 | 4.5 | CIP (27) | Lump w/fleet | ||
| 6 | HVAC Control | Install Variable Frequency Drives for AHU-1 Fans | Lack of HVAC control | $709 | $6,300 | $360 | $5,940 | 8.4 | CIP (27) | Lump w/fleet | ||
| 7 | HVAC Control | Correct Simulataneous Heating and Cooling with Controls Improvements | Lack of HVAC control | $2,264 | $8,000 | $1,875 | $6,125 | 2.7 | CIP | Heat Pumps provide heating and cooling to office spaces through ventilation system; Perimeter radiation provides heating from boiler --> Two systems do not interact through BAS. *ALREADY CORRECTED BY HELM IN 2024* | ||
| 8 | Water Fixtures | Replace Water Fixtures with Low Flow Alternative | Inefficient Equipment | $1,086 | $3,988 | 3.7 | ||||||
| Low Cost ECM Total | $6,639 | $91,377 | $13,529 | $77,848 | 11.7 | |||||||
| WESTSIDE | ||||||||||||
| ECR no. | Area of Work | ECR Title | Reason for Evaluation | Annual Building Savings | Total Cost | Incentives | Net Costs | Simple Payback Years | CIP / BM Fund | Notes | ||
| 1 | Lighting | Replace Fluorescent Lighting with LED alternative and Add Controls in Select Spaces | Inefficient Lighting | $7,746 | $16,635 | $4,707 | $11,928 | 1.5 | CIP | 555 lights need replacing; 55% reduction in power draw; unsure if pricing includes fixture upgrade/replacement. Already included in 2025 CIP | ||
| 2 | HVAC Control | Correct Building Heating Plant Controls to Improve Operation | Lack of HVAC control | $6,664 | $9,750 | $0 | $9,750 | 1.5 | CIP | Boilers are capable of condensing, but are not operating that way. Johnson Controls was out recently - confirm if they fixed this (Jon). | ||
| 3 | HVAC Control | Reduce Ventilation to Community Spaces during Unoccupied Periods | Lack of HVAC control | $781 | $3,000 | $430 | $2,570 | 3.3 | CIP | Use occupancy sensors to control lighting and HVAC operation - occupied / unoccupied heating and cooling setpoints; Also use to control for ventilation and compare indoor CO2 to outdoor. Lump with city hall & fleet | ||
| 4 | HVAC Control | Correct Chilled Water Distribution Pump Operation | Lack of HVAC control | $191 | $1,500 | $0 | $1,500 | 7.9 | CIP | Current estimated wasted run-time of motor (25% loaded) - Occupied Hours below 60 deg F: 1805 hours. Johnson Controls was out recently - confirm if they fixed this (Jon). | ||
| Hot water heater replacement lumped into City hall HWH replacement. Consider heat pumps? | ||||||||||||
| 5 | Water Fixtures | Replace Water Fixtures with Low Flow Alternative | Inefficient Equipment | $2,337 | $4,725 | 2.0 | ||||||
| Low Cost ECM Total | $15,381 | $30,885 | $5,137 | $25,748 | 1.7 | |||||||
| PUBLIC WORKS | ||||||||||||
| ECR no. | Area of Work | ECR Title | Reason for Evaluation | Annual Building Savings | Total Cost | Incentives | Net Costs | Simple Payback Years | CIP / BM Fund | Notes | ||
| 1 | Lighting | Replace Fluorescent and Metal Halide Lamps with LED Alternative | Inefficient Lighting | $1,573 | $20,000 | $2,220 | $17,780 | 11.3 | CIP 27/28 | 93 lights need replacing; 50% reduction in power draw; unsure if pricing includes fixture upgrade/replacement. | ||
| 2 | HVAC Equipment | Replace Gas Hot Water Heater with Heat Pump Alternative | Inefficient Equipment | $56 | $5,400 | $100 | $5,300 | 94.0 | CIP | Already in CIP for 2026. lumped in with City Hall & Westside. | ||
| 3 | HVAC Control | Enable Demand Control Ventilation for Furnaces | Lack of HVAC control | $923 | $5,000 | $860 | $4,140 | 4.5 | CIP (27) | Lump in | ||
| 4 | HVAC Control | Install Dual Technology Occupancy Sensors in Bathrooms | Lack of HVAC control | $82 | $240 | $48 | $192 | 2.3 | BM Fund | 1st floor men & women's bathrooms | ||
| Energy efficient windows / better insulated garage doors for 2027 already in CIP | ||||||||||||
| 5 | Water Fixtures | Replace Water Fixtures with Low Flow Alternative | Inefficient Equipment | $181 | $1,090 | 6.0 | ||||||
| Low Cost ECM Total | $2,634 | $30,640 | $3,228 | $27,412 | 10.4 | |||||||
| Controls savings & cost: | $4,836 | $34,092 | ||||||||||
| MUSEUM | ||||||||||||
| ECR no. | Area of Work | ECR Title | Reason for Evaluation | Annual Building Savings | Total Cost | Incentives | Net Costs | Simple Payback Years | CIP / BM Fund | Notes | ||
| 1 | Lighting | Replace Basement Lights with LED alternative | Inefficient Lighting | $28 | $1,500 | $33 | $1,467 | 51.7 | BM Fund (26/27) | 13 lights need replacing; 50% reduction in power draw; unsure if pricing includes fixture upgrade/replacement | Were these upgraded earlier this year? Our staff replaced lighting/fixtures in basement. ~6 bulbs replaced in basement; can likely do the rest in house. | |
| 2 | Lighting | Install Dual Technology Occupancy Sensor to Control Bath Lighting and Fan | Inefficient Lighting Control | $74 | $470 | $245 | $226 | 3.0 | BM Fund | 1st floor men & women's bathrooms; can install internally | ||
| 3 | HVAC Equipment | Replace Dehumidifier with an ENERGY STAR Alternative | Inefficient Equipment | $67 | $250 | $0 | $250 | 3.8 | CIP (28) | Permanent system connected to furnace. Existing unit doesn't reach all basement areas where collections are stored. | What type of dehumidifier is in the museum? Permanent or moveable? | |
| 4 | HVAC Equipment | Replace Electric Water Heater with a Heat Pump Alternative | Inefficient Equipment | $140 | $4,750 | $100 | $4,650 | 33.2 | CIP (28) | Items 3-5 --> $25,000 | ||
| 5 | HVAC Equipment | Replace Furnace and AC with an Air-Source Heat Pump | Inefficient Equipment | $287 | $10,000 | $240 | $9,760 | 34.0 | CIP (28) | 6 ton HP (x1) | ||
| 6 | HVAC Control | Install Programmable Thermostat to Operate HVAC System | Lack of HVAC control | $46 | $200 | $60 | $140 | 3.0 | BM Fund | one thermostat | ||
| 7 | Water Fixtures | Replace Water Fixtures with Low Flow Alternative | Inefficient Equipment | $147 | $660 | 4.5 | ||||||
| Low Cost ECM Total | $642 | $17,170 | $678 | $16,492 | 25.7 |
SOLAR
| FLEET MAINTENANCE | PUBLIC WORKS | STATION 1 | ||||||
| Size | 182.5 | kW | Size | 172 | kW | Size | 100 | kW |
| Production | 239,226 | kWh/yr | Production | 227,445 | kWh/yr | Production | 125,774 | kWh/yr |
| Annual Energy Savings | $ 25,716.80 | (conservative) | Annual Energy Savings | $ 24,450.34 | (conservative) | Annual Energy Savings | $ 13,520.71 | (conservative) |
| Cost | $ 547,500.00 | (conservative) | Cost | $ 516,000.00 | (conservative) | Cost | $ 300,000.00 | (conservative) |
| Tax Credit | $ (139,612.50) | (conservative) | Tax Credit | $ (131,580.00) | (conservative) | Tax Credit | $ (76,500.00) | (conservative) |
| Focus Rebate | $ (9,125.00) | Focus Rebate | $ (8,600.00) | Focus Rebate | $ (5,000.00) |
| TOTAL | $ 398,762.50 | TOTAL | $ 375,820.00 | TOTAL | $ 218,500.00 | |||
| ROI | 15.5 | years | ROI | 15.4 | years | ROI | 16.2 | years |
| Roof installed in 2007, replace in 2027 | Metal roof in good condition. Very long lifespan. | CIP 2032 (move roof replacement to 2032 and add solar to this item.) | ||||||
| Fleet roof & solar replacement in 2030 CIP - $775,000 | Solar in CIP 2032 - $450,000 (planning/design/install) | $500,000 for roof & solar (includes planning/design & installation) | ||||||
| *add to 2032 CIP due to uncertainty with future use case of existing PW facility |
| *remove duplications of roof replacements and lump in with solar installations. | |
| $ 993,082.50 | |
| 239802.75 | |
| $ 1,232,885.25 |
File details come from the government source that posted it. Updated .