Attachment 1 ENERGY AUDIT MASTER.xlsx
XLSX spreadsheet 29 KB Posted
- Attached to
- LED Lighting Conversion State and local contract opportunity
- Solicitation number
- 25-BM14
- Issued by
- Dane County, Wisconsin
About this file
This document is an Energy Audit Master spreadsheet detailing energy efficiency improvement opportunities across multiple municipal facilities, including Station 1, Fleet Maintenance, City Hall, Westside, Public Works, and Museum. The comprehensive audit evaluates energy conservation measures (ECMs) across lighting, HVAC equipment, HVAC controls, and water fixtures, with proposed improvements aimed at reducing energy consumption, increasing efficiency, and generating cost savings. The audit includes detailed assessments for each facility, documenting annual building savings, total project costs, available incentives, net costs, and simple payback periods.
The audit also includes a solar installation analysis for three municipal locations: Fleet Maintenance, Public Works, and Station 1, with proposed solar array sizes ranging from 100 kW to 182.5 kW and projected annual energy savings between 13,520 and 25,716 kWh. The solar projects have estimated total costs between $300,000 and $547,500, with potential tax credits and Focus rebates reducing net project costs. The proposed improvements are primarily funded through Capital Improvement Program (CIP) funds and Building Maintenance (BM) funds, with most projects scheduled for implementation between 2025 and 2028. The solar installations have projected return on investment (ROI) periods of 15.4 to 16.2 years, and are strategically planned to coincide with planned roof replacements.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| 25-BM LED Lighting Conversion Bid.pdf | ||
| Fire station 1 First Floor Plan 200_500BW.pdf | ||
| Firestation 1 lighting floor plan 2.pdf | ||
| RFB 25-BM14 LED Lighting Conversion.pdf | ||
| WCSB 1st floor light power area A.pdf | ||
| WCSB 1st floor power area B.pdf | ||
| 25-BM14 Notice of Intent to Award Letter.pdf | ||
| Firestation 1 lighting floor plan.pdf | ||
| 25-BM14 Sign in Log.pdf | ||
| Fire Station 1 Second Floor Plan 201_500BW.pdf | ||
| 25-BM14 Draft Contract.pdf | ||
| Fleet Lighting Plan.pdf | ||
| WCSB 1st floor lighting area B.pdf | ||
| WCSB 2nd floor light power area B.pdf | ||
| 25-BM14 QA.pdf | ||
| LED Fixture Schedule 2025.xlsx | XLSX spreadsheet |
Show all 16
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 .