HomeMy WebLinkAboutCIRI-SXQ-CAEC Soldotna KPB SD Warehouse 2012-EEFINAL ENERGY AUDIT
KPB Warehouse
148 N. Binkley Street
Soldotna, AK 99669
ATTN: Kevin Lyon
Submitted by: Prime Contract:
April 16, 2012
Wisdom and
Associates, Inc.
Contact: Robert Moss, CEA
130 Trading Bay, #320
Kenai, AK 99611
Phone (907) 283-0629
Robert@akinspections.com
Contact: Jerry P. Herring, P.E., C.E.A.
32215 Lakefront Drive
Soldotna, Alaska 99669
Phone (907) 260-5311
akengineer@starband.net
Energy Audit Report
April 16, 2012
pg. 2
Table of Contents
Introduction 4
Executive Summary 6
Methods of Analysis 8
Audit/Building Overview 9
Energy Conservation Measures 10
Operations and Maintenance 22
Benchmark Information 23
Supporting Documentation 32
Equipment Inventory
Benchmark Data
ECM Calculations
Cost Data
Energy Audit Report
April 16, 2012
pg. 3
REPORT DISCLAIMER
This energy audit is intended to identify and recommend potential areas of energy savings,
estimate the value of the savings and approximate the costs to implement the
recommendations. Any modifications or changes made to a building to realize the savings must
be designed and implemented by licensed, experienced professionals in their fields. Lighting
recommendations should all be first analyzed through a thorough lighting analysis to assure that
the recommended lighting upgrades will comply with State of Alaska Statue and well as
Illuminating Engineering Society (IES) recommendations. Wisdom and Associates, Inc. and
Central Alaska Engineering Company bear no responsibility for work performed as a result of
this report.
Payback periods may vary from those forecasted due to the uncertainty of the final installed
design, configuration, equipment selected, and installation costs of recommended Energy
Conservation Measures (ECMs), or the operating schedules and maintenance provided by the
owner. Furthermore, ECMs are typically interactive, so implementation of one ECM may
impact the cost savings from another ECM. Wisdom and Associates, Inc. and Central Alaska
Engineering Company accept no liability for financial loss due to ECMs that fail to meet the
forecasted payback periods.
This audit meets the criteria of a Level 2 Investment Grade Audit (IGA) per the American
Society of Heating, Refrigeration, Air-conditioning Engineers (ASHRAE) and the Association of
Energy Engineers (AEE), and is valid for one year. The life of the IGA may be extended on a
case-by-case basis, at the discretion of AHFC.
IGA’s are the property of the State of Alaska, and may be incorporated into AkWarm-C, the
Alaska Retrofit Information System (ARIS), or other state and/or public information
systems. AkWarm-C is a building energy modeling software developed under contract by
AHFC.
This material is based upon work supported by the Department of Energy under Award Number
DE-EE0000095. This report was prepared as an account of work sponsored by an agency of the
United States Government. Neither the United States Government nor any agency thereof, nor
any of their employees, makes any warranty, express or implied, or assumes any legal liability or
responsibility for the accuracy, completeness, or usefulness of any information, apparatus,
product, or process disclosed, or represents that its use would not infringe privately owned rights.
Reference herein to any specific commercial product, process, or service by trade name,
trademark, manufacturer, or otherwise does not necessarily constitute or imply its endorsement,
recommendation, or favoring by the United States Government or any agency thereof. The
views and opinions of authors expressed herein do not necessarily state or reflect those of the
United States Government or any agency thereof.
Energy Audit Report
April 16, 2012
pg. 4
Introduction
This report is a comprehensive energy study, which included an analysis of major energy
consuming components of the building. The scope of the audit focused on the Kenai Peninsula
Borough Records Warehouse as part of a contract for:
Alaska Housing Finance Corporation Kenai Peninsula Borough
Contact: Rebekah Luhrs Contact: Kevin Lyon
4300 Boniface Parkway 144 N. Binkley Street
Anchorage, AK 99510 Soldotna, AK 99669
Email: rluhrs@ahfc.us Email: klyon@borough.kenai.ak.us
This audit was performed using ARRA funds to promote the use of innovation and technology to
solve energy and environmental problems in a way that improves the State’s economy. This can
be achieved through the wiser and more efficient use of energy. Opportunities for application of
these energy saving methods are discussed in detail throughout this report.
The average annual energy costs at this facility are as follows:
Electricity $16,847.04
Natural Gas $3775.56
Total $20,622.6
Energy Audit Report
April 16, 2012
pg. 5
The potential annual energy cost savings for each energy conservation measure are summarized
in the executive summary along with a more detailed description in the energy conservation
measures section. All calculations are available in the support documentation. This audit is
consistent with an ASHRAE Level 2 audit. The evaluations are based on estimations and
industry standard calculation methods. The cost of each measure for this level of auditing is +
30% until detailed engineering, specifications, and hard proposals are obtained. More detailed
analyses would require engineering simulation models, hard equipment specifications, and
contractor bid pricing.
The comprehensive energy audit covers the 4860 square foot storage/warehouse facility.
Utility information was collected and analyzed for 2 full year’s energy use of the building. The
utility information allows us to analyze the building’s operational characteristics and calculate
energy benchmarks for comparison to industry averages. A computer spreadsheet was used to
calculate benchmarks and to graph utility information (see the Benchmarking section).
An Energy Use Index (EUI) was established for the building. Energy Use Index (EUI) is
expressed in British Thermal Units/square foot/year (BTU/ft2/yr), which is used to compare
energy consumption to similar building types or to track consumption from year to year in the
same building. The EUI is calculated by converting the annual consumption of all energy sources
to BTU’s and dividing by the area (gross square footage) of the building. Blueprints and
drawings are utilized to verify the gross area of the facility. The EUI can be a good indicator of
the relative potential for energy savings. A low EUI indicates less potential for energy savings,
while a high EUI indicates poor building performance, therefore, a high potential for energy
savings.
The site survey provided information for interpreting where energy was spent and finding energy
savings opportunities within the facility. The building site visit was performed to survey all
major building components and systems. The site visit included an inspection of energy
consuming components.
Energy Audit Report
April 16, 2012
pg. 6
Executive Summary
The executive summary provides a snapshot of estimated improvement costs, Net Present Value
savings, breakeven costs and savings to investment ratios.
Energy Conservation Measures Recommendation Table
ECM #Improvement Description Installed
Cost
Annualized
NPV Savings
NPV Savings Over
Improvement Life
Breakeven
Cost SIR
Simple
Payback
(Years)
ROI
1 Install timer on block heater circuits to
limit time on to 30 minutes per hour.$3,186 $4,804 $76,857 $80,043 24.1 1 2413%
2
Replace existing furnace in mezzanine
with 94% AFUE furnace. Install
programmable thermostats for all three
heating systems to reduce average
temperature to 65 degrees.
$6,499 $623 $12,468 $18,967 1.9 9 192%
3 Replace exterior mercury vapor lamps
with 250w metal halide lamps.$2,117 $195 $3,117 $5,234 1.5 7 147%
4
Replace existing 4' 4 lamp T12 fixtures
with 4' 4 lamp T8 fixtures with 25w
lamps and electronic ballasts.
$4,805 $337 $5,396 $10,201 1.1 8 112%
5
Replace existing overhead garage door
with new overhead garage door having a
U value of 0.15 or less.
$3,062 $125 $2,504 $5,566 0.8 14 82%
6
Replace existing 4' 2 lamp T12 fixtures
with 2 lamp T8 fixtures with 25w lamps
and electronic ballasts.
$1,627 $68 $1,090 $2,717 0.7 10 67%
7
Replace existing 8' 2 lamp T12 fixtures
with 4 lamp T8 fixtures with 25w lamps
and electronic ballasts.
$13,979 $533 $8,521 $22,500 0.6 10 61%
8
Replace existing single and double pane
wood windows with windows having a U-
value of 0.3 or less.
$2,775 $26 $527 $3,302 0.2 18 19%
9 Replace existing doors with doors having
a U-value of 0.16 or less.$2,171 $10 $203 $2,374 0.1 19 9%
Total, Cost Effective Measures $40,221 $6,721 $110,683 $150,904 2.8 -275%
10
Add 2.25" Foam insulation to roof
decking. This ECM does not include the
cost of roof removal or replacement.$15,483 ($82)($1,632)$13,851 -0.1 22 -11%
11
Replace existing tank water heater with
on-demand water heater having an
Energy Factor of 0.95 or greater.
$7,454 ($301)($4,510)$2,944 -0.6 >30 -61%
12
Add 1" urethane foam foil board to
exterior wall and side over with
corrugated metal siding. Furring strips
installed 24" o.c. to fasten siding. Foam
boards glued in place.
$80,587 ($3,215)($64,306)$16,281 -0.8 >30 -80%
Total, All Measures $143,745 $3,124 $40,235 $183,980 0.3 -28%
Energy Audit Report
April 16, 2012
pg. 7
The ECM# is the priority ranking of an Energy Conservation Measure.
The Installed Cost is the full upfront cost expected for the improvement.
The Annualized NPV Savings reflects the annualized Net Present Value savings over the life of
the improvement, adjusted for general inflation, fuel price escalation, maintenance, discount rate
and installed cost.
The NPV Savings Over Improvement Life reflects the Net Present Value of cumulative savings
over the life of the improvement, adjusted for general inflation, fuel price escalation,
maintenance, discount rate and installed cost.
The Breakeven Cost is the maximum cost in today’s dollars that could be spent on an
improvement and still be cost effective.
The Savings to Investment Ratio (SIR) is a life-cycle cost measure calculated by dividing the
total savings over the life of a project (expressed in today’s dollars) by its investment costs. The
SIR is an indication of the profitability of a measure; the higher the SIR, the more profitable the
project. An SIR greater than 0 indicates a cost-effective project (i.e. more savings than cost).
The Return on Investment (ROI) listed for each ECM is the net savings of the energy
conservation measure divided by the installed cost listed.
The Simple Payback listed for each ECM is the number of years required to break even on the
investment, adjusted for general inflation, fuel price escalation, maintenance, discount rate and
installed cost.
The total savings listed for cost effective measures and all measures are for estimation purposes
only and cannot be considered 100% accurate because of the interrelation of the ECMs.
Energy Audit Report
April 16, 2012
pg. 8
Method of Analysis
Post site visit work included an evaluation of the information gathered, researching possible
conservation opportunities, organizing the audit into a comprehensive report, and making
recommendations on HVAC, lighting, and building envelope improvements. Collected data was
processed using Microsoft Excel spreadsheets and ASHRAE energy calculations to anticipate
energy usage for each of the proposed energy conservation measures (ECMs). The actual
building energy usage was entered directly from the utility bills provided. The anticipated energy
usage was compared to the historical data to determine energy savings for the proposed ECMs.
It is important to note that the savings represented in this report should not be considered
additive because of the interrelation of energy conservation measures. Implementation of more
than one ECM often affects the savings of other ECMs.
ECMs were determined by identifying the building’s unique properties and finding the most
beneficial energy saving measures available that met the specific needs of the facility. The
building construction type, function, operational schedule, existing conditions, and foreseen
future plans were accounted for in the evaluation and final recommendations. Energy savings are
calculated based on industry standard methods and estimations. Energy consumption is
calculated based on manufacturer’s information when new equipment is proposed.
Cost savings are calculated based on the actual historical energy costs for the facility. Installation
costs include materials and labor costs to estimate the full up-front investment required.
Measures were analyzed based on life-cycle-cost techniques, which include the initial cost of the
improvement, expected life of the improvement, annual energy cost, annual maintenance cost,
and a discount rate of 3.0%/year. Energy cost escalation rates are taken from the current Energy
Price Indices and Discount Factors for Life-Cycle Cost Analysis from the US Department of
Commerce. Maintenance costs are estimated at 2% of fuel cost related to an improvement unless
otherwise noted. Expected life of improvements is taken from industry and government sources.
Future savings are discounted to the present to account for the time-value of money (i.e. money’s
ability to earn interest over time).
All results are dependent on the quality of input data provided, and can only act as an
approximation. In some instances, several methods may achieve the identified savings. This
report is not intended as a final design document. The design professional or other persons
following the recommendations shall accept responsibility and liability for the results.
Energy Audit Report
April 16, 2012
pg. 9
Audit Overview/Building Description
The Kenai Peninsula Borough Warehouse is a concrete block building with flat roof built in
1969. This building houses 2 full time occupants that work from 8 am to 5 pm on weekdays. The
building also serves as a plug station for up to 10 vehicles (reportedl y 4 busses and 6 regular
vehicles on average) for engine block heaters. The building is heated by a gas forced air furnace
and two gas unit heaters.
Energy costs associated with this building are high, especially electricity. This type of building
has unique usage patterns that cause higher than normal energy consumption than buildings of
similar size. The use of engine block heaters on busses and other vehicles causes high electrical
usage.
Energy Audit Report
April 16, 2012
pg. 10
Energy Conservation Measures
Energy conservation measures are those measures which are considered as having the potential
to be cost effective and appropriate energy improvement options for the building. Estimated
costs are taken from the current Craftsman National Estimator and are adjusted for zip code.
Different rates and averages can be applied to this report if requested.
Lighting and electrical improvements are based on usage estimates apparent at the time of the
audit and may not reflect actual usage or occupant behavior. Before committing to a complete
lighting retrofit, it is recommended that a small sample of the new lamps you intend to use be
installed and tested for a time before pursuing all of the recommended changes. Light output,
color rendition, color temperature and personal preference all play a part in a satisfactory lighting
retrofit. The benefit of reduced energy consumption is lost if fixtures have to be re-lamped after
the retrofit or people are not comfortable with a new lighting scheme.
The Return on Investment (ROI) listed for each ECM is the net savings of the energy
conservation measure divided by the installed cost listed. The simple payback listed for each
ECM is the number of years required to break even on the investment, given annual energy cost,
annual maintenance cost, and discount rate.
Energy Audit Report
April 16, 2012
pg. 11
Adjustments may be needed to maintain proper engine temperature with the on/off cycle.
Intermatic ET70815CR Time Switch or similar may work in this application. The lifetime ROI
for this investment is 2413%. This ECM assumes a life expectancy of 16 years for this measure.
ECM #Improvement Description Installed
Cost
Annualized
NPV Savings
NPV Savings Over
Improvement Life
Breakeven
Cost SIR
Simple
Payback
(Years)
1 Install timer on block heater circuits to
limit time on to 30 minutes per hour.$3,186 $4,804 $76,857 $80,043 24.1 1
Energy Audit Report
April 16, 2012
pg. 12
The lifetime ROI for this investment is 192%. This ECM assumes a life expectancy of 20 years
for this measure.
ECM #Improvement Description Installed
Cost
Annualized
NPV Savings
NPV Savings Over
Improvement Life
Breakeven
Cost SIR
Simple
Payback
(Years)
ROI
2
Replace existing furnace in mezzanine
with 94% AFUE furnace. Install
programmable thermostats for all three
heating systems to reduce average
temperature to 65 degrees.
$6,499 $623 $12,468 $18,967 1.9 9 192%
Energy Audit Report
April 16, 2012
pg. 13
The lifetime ROI for this investment is 147%. This ECM assumes a life expectancy of 16 years
for this measure.
ECM #Improvement Description Installed
Cost
Annualized
NPV Savings
NPV Savings Over
Improvement Life
Breakeven
Cost SIR
Simple
Payback
(Years)
ROI
3 Replace exterior mercury vapor lamps
with 250w metal halide lamps.$2,117 $195 $3,117 $5,234 1.5 7 147%
Energy Audit Report
April 16, 2012
pg. 14
The lifetime ROI for this investment is 112%. This ECM assumes a life expectancy of 16 years
for this measure.
ECM #Improvement Description Installed
Cost
Annualized
NPV Savings
NPV Savings Over
Improvement Life
Breakeven
Cost SIR
Simple
Payback
(Years)
ROI
4
Replace existing 4' 4 lamp T12 fixtures
with 4' 4 lamp T8 fixtures with 25w
lamps and electronic ballasts.
$4,805 $337 $5,396 $10,201 1.1 8 112%
Energy Audit Report
April 16, 2012
pg. 15
The lifetime ROI for this investment is 82%. This ECM assumes a life expectancy of 20 years
for this measure.
ECM #Improvement Description Installed
Cost
Annualized
NPV Savings
NPV Savings Over
Improvement Life
Breakeven
Cost SIR
Simple
Payback
(Years)
ROI
5
Replace existing overhead garage door
with new overhead garage door having a
U value of 0.15 or less.
$3,062 $125 $2,504 $5,566 0.8 14 82%
Energy Audit Report
April 16, 2012
pg. 16
The lifetime ROI for this investment is 67%. This ECM assumes a life expectancy of 16 years
for this measure.
ECM #Improvement Description Installed
Cost
Annualized
NPV Savings
NPV Savings Over
Improvement Life
Breakeven
Cost SIR
Simple
Payback
(Years)
ROI
6
Replace existing 4' 2 lamp T12 fixtures
with 2 lamp T8 fixtures with 25w lamps
and electronic ballasts.
$1,627 $68 $1,090 $2,717 0.7 10 67%
Energy Audit Report
April 16, 2012
pg. 17
The lifetime ROI for this investment is 61%. This ECM assumes a life expectancy of 16 years
for this measure.
ECM #Improvement Description Installed
Cost
Annualized
NPV Savings
NPV Savings Over
Improvement Life
Breakeven
Cost SIR
Simple
Payback
(Years)
ROI
7
Replace existing 8' 2 lamp T12 fixtures
with 4 lamp T8 fixtures with 25w lamps
and electronic ballasts.
$13,979 $533 $8,521 $22,500 0.6 10 61%
Energy Audit Report
April 16, 2012
pg. 18
The lifetime ROI for this investment is 19%. This ECM assumes a life expectancy of 20 years
for this measure.
ECM #Improvement Description Installed
Cost
Annualized
NPV Savings
NPV Savings Over
Improvement Life
Breakeven
Cost SIR
Simple
Payback
(Years)
8
Replace existing single and double pane
wood windows with windows having a U-
value of 0.3 or less.
$2,775 $26 $527 $3,302 0.2 18
Energy Audit Report
April 16, 2012
pg. 19
The lifetime ROI for this investment is 9%. This ECM assumes a life expectancy of 20 years for
this measure.
ECM #Improvement Description Installed
Cost
Annualized
NPV Savings
NPV Savings Over
Improvement Life
Breakeven
Cost SIR
Simple
Payback
(Years)
9 Replace existing doors with doors having
a U-value of 0.16 or less.$2,171 $10 $203 $2,374 0.1 19
Energy Audit Report
April 16, 2012
pg. 20
The lifetime ROI for this investment is -11%. This ECM assumes a life expectancy of 20 years
for this measure.
ECM #Improvement Description Installed
Cost
Annualized
NPV Savings
NPV Savings Over
Improvement Life
Breakeven
Cost SIR
Simple
Payback
(Years)
10
Add 2.25" Foam insulation to roof
decking. This ECM does not include the
cost of roof removal or replacement.$15,483 ($82)($1,632)$13,851 -0.1 22
Energy Audit Report
April 16, 2012
pg. 21
This ECM assumes that the existing water heater will need replaced with a water heater that is
similar to the current model over the next 15 years. The lifetime ROI for this investment is -61%.
This ECM assumes a life expectancy of 15 years for this measure.
ECM #Improvement Description Installed
Cost
Annualized
NPV Savings
NPV Savings Over
Improvement Life
Breakeven
Cost SIR
Simple
Payback
(Years)
11
Replace existing tank water heater with
on-demand water heater having an
Energy Factor of 0.95 or greater.
$7,454 ($301)($4,510)$2,944 -0.6 >30
Energy Audit Report
April 16, 2012
pg. 22
The lifetime ROI for this investment is -80%. This ECM assumes a life expectancy of 20 years
for this measure.
ECM #Improvement Description Installed
Cost
Annualized
NPV Savings
NPV Savings Over
Improvement Life
Breakeven
Cost SIR
Simple
Payback
(Years)
12
Add 1" urethane foam foil board to
exterior wall and side over with
corrugated metal siding. Furring strips
installed 24" o.c. to fasten siding. Foam
boards glued in place.
$80,587 ($3,215)($64,306)$16,281 -0.8 >30
Energy Audit Report
April 16, 2012
pg. 23
Operations and Maintenance Measures
Staff Training – Visit www.energystar.gov for free training materials and courses on energy
conservation and awareness for building staff. Live web conferences, animated presentations and
pre-recorded trainings are just some of the tools available. Creating an inclusive strategy that
establishes roles and actions throughout the organization can help to integrate good energy
management practices. When developing an action plan, consider brainstorming with various
departments to identify ways they can contribute.
Portfolio Manager – Consider utilizing EPA’s Portfolio Manager, which is an online system that
allows building personnel to track building performance and improve energy efficiency across
multiple buildings. You can also contact your energy auditor for additional information about
this program. See www.energystar.gov
After Hours – The building manager/operator should be tasked with turning off all non-essential
equipment at night, on weekends, or during other non-occupied times. Power strips can be turned
off during off hours; also power strips can be connected to timers or occupancy sensors. Smart
power strips with built-in occupancy sensors or activity sensors are available.
Plug Loads – Plug loads use up to an estimated 20% of electrical energy in commercial
buildings. Most plugged in devices consume energy even when off. Power is drawn by devices
in passive standby, such as a computer in “sleep” mode or a clock on a microwave, and active
standby such as when a screen saver is on a computer screen or television screen. The majority
of plug loads come from office equipment (computers, printers, copiers, etc.) and appliances
(refrigerators, coffee machines, etc.). As equipment deteriorates or is scheduled for replacement,
it is recommended that it be replaced with EnergyStar certified equipment.
Refrigeration – Most refrigerators, freezers, ice makers and other types of cooling equipment can
benefit from cleaning the evaporator coils. This should be done on a yearly basis to reduce
electrical costs.
Demand Charges – Electrical demand charges are a result of peak KW electrical demand from
the building during a 15 minute period each month. Demand charges make up on average 10.5%
of the electrical bill, which could be further reduced by staggering the times at which the engine
block heater circuits are energized. By staggering the circuit timing the peak KW draw can be
reduced substantially. The amount of reduction in demand charge will depend on how the
circuits are programmed.
Energy Audit Report
April 16, 2012
pg. 24
Benchmark Information
Benchmarking and analysis of the utility bills was used to collect data about the building in terms
of energy usage patterns, consumption, and comparison with similar buildings. Benchmarking
was used to identify energy usage patterns and trends that showed a need for specific
investigation of certain systems. Benchmarking also identified potential issues in how the
building is operated which may lead to energy savings. Analysis of utility data provides a context
for the audit.
The BTU usage of the building per square foot is well above the benchmark of the national
average of similar buildings. Part of this is due to the harsh climate in Alaska, which emphasizes
the need for improvements in the heating system. This is also due in part to the high plug load
from engine block heaters.
Energy Audit Report
April 16, 2012
pg. 25
Electrical usage in terms of BTU per square foot is much higher than the national benchmark for similar
buildings. This emphasizes the importance of reducing the electrical load.
Energy Audit Report
April 16, 2012
pg. 26
The natural gas consumption of this building is above the national average. This is in part due to Alaska’s
harsh climate.
Energy Audit Report
April 16, 2012
pg. 27
The total energy use profile shows the majority of BTUs consumed by the building are from natural gas
which is used exclusively for heating. Electrical usage is second.
Energy Audit Report
April 16, 2012
pg. 28
The energy cost total shows electricity being the majority fuel cost. Electricity is much more expensive
per BTU than natural gas, and an electrical demand charge is being assessed to the building. This
emphasizes the need to reduce electrical consumption.
Energy Audit Report
April 16, 2012
pg. 29
Electrical consumption tracks with Heating Degree Days, which are a measure of the heating load
imposed by the climate. This matches with increased electrical use in the winter months due to more
vehicle plug-ins and increased lighting demand.
Energy Audit Report
April 16, 2012
pg. 30
Natural gas consumption matches very closely with Heating Degree Days, which is to be expected from
normal heating system operation.
Energy Audit Report
April 16, 2012
pg. 31
The Load Factor is the ratio of the average load in kilowatts supplied during a designated period
to the peak or maximum load in kilowatts occurring in that period (usually a month). The Load
Factor takes into account spikes in demand which in turn may cause rate hikes depending on the
rate structure of a particular utility. The lower the load factor, the greater the spikes in demand
and the resulting penalties in demand charges. The average load factor for this building is 0.58.
The percent of the electrical bill caused by demand charges is 9.3%. The amount of electrical
demand from this building is not out of line. However, timing the block heater controls out of
sync will lower the demand charge.
Energy Audit Report
April 16, 2012
pg. 32
Supporting Documentation
This section contains all of the supporting documentation for the audit, which may include all
calculations, assumptions, and worksheets used to generate conclusions.
Equipment Inventory
Designation Location Function Make Model Type Capacity Efficiency Motor
Size Notes Median
Service Life
Est. Remaining
Useful Life
Furnace Mezzanine Heating Rheem Criterion
II Gas 83,000 80%
Heats the
mezzanine, ofice
space and storage
area
20 15
New Space
Heater Garage Bay Heating Modine Hot Dawg Gas 100,000 80%Serves the back
garage bay 20 15
Old Space
Heater Storage Area Heating Modine 05J09127 Gas 105,000 80%On lowest
thermostat setting, 20 0
Water
Heater Mezzanine DHW Super Eagle G51-
50T63-4N Gas 63,000 70%Provides all DHW 15 0
Humidifier Mezzanine Humidity Control Carnes Serves document
storage 20 0
Energy Audit Report
April 16, 2012
pg. 33
Benchmark Data
Building Designation:Electric Meter #Square footage of conditioned area:4608Gas Meter #Number of billing periods24Year:MonthDays in Billing PeriodElectric KWHElectric Demand KWElectric Cost $/KWHElectric CostDemand CostElectric MMBtu Load Factor% of bill from demandGas Usage ThermsGas Cost $Gas Unit Cost $/ThermGas MMBtuJan-093411,23221.00$0.22$2,495.00$147.0038.330.665.9%759.0$796.00$1.0575.90Feb-09299,92124.00$0.23$2,305.00$172.0033.860.597.5%682.0$716.00$1.0568.20Mar-09289,68722.00$0.23$2,227.00$154.0033.060.666.9%562.0$592.00$1.0556.20Apr-093010,99124.00$0.19$2,063.00$171.0037.510.648.3%455.0$482.00$1.0645.50May-09289,75723.00$0.19$1,872.00$163.0033.300.638.7%187.0$205.00$1.1018.70Jun-09324,02610.00$0.22$873.00$74.0013.740.528.5%77.0$92.00$1.197.70Jul-09313,72412.00$0.23$858.00$83.0012.710.429.7%37.0$50.00$1.353.70Aug-09283,36413.00$0.24$819.00$89.0011.480.3910.9%38.0$51.00$1.343.80Sep-09324,48911.00$0.21$965.00$80.0015.320.538.3%55.0$69.00$1.255.50Oct-09305,39515.00$0.19$1,025.00$106.0018.410.5010.3%213.0$232.00$1.0921.30Nov-09336,67514.00$0.18$1,170.00$100.0022.780.608.5%481.0$509.00$1.0648.10Dec-09319,85620.00$0.17$1,649.00$144.0033.640.668.7%510.0$539.00$1.0651.00Jan-103211,45521.00$0.15$1,661.00$154.0039.100.719.3%529.0$466.00$0.8852.90Feb-10299,85920.00$0.15$1,479.00$147.0033.650.719.9%644.0$564.00$0.8864.40Mar-102810,22622.00$0.15$1,544.00$160.0034.900.6910.4%471.0$416.00$0.8847.10Apr-10298,93519.00$0.18$1,566.00$146.0030.500.689.3%361.0$326.00$0.9036.10May-10348,91419.00$0.17$1,554.00$141.0030.420.579.1%236.0$217.00$0.9223.60Jun-10284,62215.00$0.21$966.00$117.0015.770.4612.1%47.0$54.00$1.154.70Jul-10313,66410.00$0.21$763.00$73.0012.510.499.6%47.0$53.00$1.134.70Aug-10313,83911.00$0.21$799.00$80.0013.100.4710.0%60.0$77.00$1.286.00Sep-10304,02611.00$0.21$831.00$84.0013.740.5110.1%55.0$73.00$1.335.50Oct-10305,62816.00$0.19$1,058.00$120.0019.210.4911.3%247.0$226.00$0.9124.70Nov-10328,53618.00$0.17$1,437.00$137.0029.130.629.5%327.0$290.00$0.8932.70Dec-103010,46321.00$0.16$1,715.00$161.0035.710.699.4%535.0$456.00$0.8553.50#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00Montly Average30.427470.1717.17#DIV/0!$1,403.92$125.1325.50#DIV/0!#DIV/0!317.29$314.63#DIV/0!31.73Total730179,284N/AN/A$33,694.00$3,003.00611.90N/AN/A7,615.00$7,551.00N/A761.50Monthly BenchmarkOccupancyWarehouse and Storage ........8.51635223.1936% DifferenceSize1,001 to 10,000 Square Feet299.37%136.80%Energy Use Index Form 1Natural Gas ElectricityKPB SD Warehouse
Energy Audit Report
April 16, 2012
pg. 34
Energy Audit Report
April 16, 2012
pg. 35
Climate & Fuel Assumptions
Client Name:KPB SD Warehouse Address:
Square Footage 4608
Days
Occupied
per Year State HDD CDD
Avg.
Temp
365 Alaska 10,942 0 35.0
Fuels
Natural Gas $1.03 $ Per CCF $1.00 Per Therm
Oil $ Per Gallon $0.00 Per Therm
Electricity $0.19 $ per KWH $5.57 Per Therm
Propane $ per Gallon $0.00 Per Therm
Wood $ Per Cord $0.00 Per Therm
Coal $ Per Ton $0.00 Per Therm
Electrical Demand Charge $7.29 Kw/Month
City
Kenai 9 N
Client Information
Energy Audit Report
April 16, 2012
pg. 36
Discount, Fuel Escalation, and Inflation Assumptions
1 = Yes Real Discount Rate (i) . . . . . . . . . . .2005 - 2040 . . . . . . . . 3.0%
0 = No Electricity. . . . . . . . . . . . . . . . . . . . .2005 - 2015 . . .2.7%
IOU Electricity Source*1 (Investor Owned Utility)2016 - 2025 . . .3.1%
POU Electricity Source**0 2026 - 2040 . . .4.7%
Natural Gas Fuel?1 Natural Gas . . . . . . . . . . . . . . . . . . . . . . . .2005 - 2015 . . .1.3%
Propane Fuel?0 And other fossil fuels 2016 - 2025 . . .6.5%
Oil Fuel?0 2026 - 2040 . . .10.3%
Maintenance . . . . . . . . . . . . . . . . . .2005 - 2040 . . . . . . . . 3.0%
Inflation 2005 - 2040 . . . . . . . . 3.0%
* IOU = Invester Owned Utility
** POU = Publicly Owned Utility
F U E L P R I C E E S C A L A T I O N I N F O R M A T I O N:
Select value and key in above as decimal fraction.
Years:
Electricity 2005 - 2015 . . .2.7%0.027
(Investor-Owned)2016 - 2025 . . .3.1%0.031
2026 - 2040 . . .4.7%0.047
Electricity 2005 - 2015 . . .2.7%0.027
(Public Owned)2016 - 2025 . . .3.1%0.031
2026 - 2040 . . .4.7%0.047
Natural Gas 2005 - 2015 . . .1.3%0.013
2016 - 2025 . . .6.5%0.065
2026 - 2040 . . .10.3%0.103
Oil 2005 - 2015 . . .1.3%0.013
2016 - 2025 . . .6.5%0.065
2026 - 2040 . . .10.3%0.103
Propane 2005 - 2015 . . .Assume same as natural gas
2016 - 2025 . . .
2026 - 2040 . . .
Energy Audit Report
April 16, 2012
pg. 37
ECM #1 Calculations
Equipement Description
Number of Like Equipement 10 10
Equipement Wattage 1500 1500
Hours on per Week 50 25
Cost of Retrofit $318.56
Total KWH Cost $7,410.00 $3,705.00
Total Demand Cost $1,312.20 $1,312.20
Total Yearly Cost $8,722.20 $5,017.20
Yearly Savings $3,705.00
Total Retrofit Cost $3,185.60
Payback Period 0.9 years
Plug in engine block heater for trucks parked in garage bays.
Retrofit Description Install timer on block heater circuits to limit time on to 30 minutes per hour.
Adjustments may be needed to maintain proper engine temperature with the
on/off cycle. Intermatic ET70815CR Time Switch or similar.
Energy Audit Report
April 16, 2012
pg. 38
---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$0-$ $8,722$8,722(1+i)^-nCostsCosts2,012$3,186$0-$ $3,705$3,705(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$3,186------$3,1861.00$3,186$3,1862,0130008,9588,9580.978,6978,696.80$ 2,0130003,8053,8050.973,694$6,8801,817$ 2,0140009,2009,2000.948,67117,368$ 2,0140003,9083,9080.943,683$10,5636,805$ 2,0150009,4489,4480.928,64626,014$ 2,0150004,0134,0130.923,673$14,23611,778$ 2,0160009,7039,7030.898,62134,635$ 2,0160004,1224,1220.893,662$17,89816,737$ 2,01700010,00410,0040.868,62943,265$ 2,0170004,2494,2490.863,666$21,56421,701$ 2,01800010,31410,3140.848,63851,903$ 2,0180004,3814,3810.843,669$25,23326,670$ 2,01900010,63410,6340.818,64660,549$ 2,0190004,5174,5170.813,673$28,90531,643$ 2,02000010,96310,9630.798,65569,203$ 2,0200004,6574,6570.793,676$32,58236,622$ 2,02100011,30311,3030.778,66377,866$ 2,0210004,8014,8010.773,680$36,26241,605$ 2,02200011,65411,6540.748,67186,538$ 2,0220004,9504,9500.743,683$39,94546,593$ 2,02300012,01512,0150.728,68095,217$ 2,0230005,1045,1040.723,687$43,63251,586$ 2,02400012,38712,3870.708,688103,906$ 2,0240005,2625,2620.703,691$47,32256,583$ 2,02500012,77112,7710.688,697112,602$ 2,0250005,4255,4250.683,694$51,01761,586$ 2,02600013,16713,1670.668,705121,307$ 2,0260005,5935,5930.663,698$54,71466,593$ 2,02700013,78613,7860.648,849130,156$ 2,0270005,8565,8560.643,759$58,47371,683$ 2,02800014,43414,4340.628,995139,151$ 2,0280006,1316,1310.623,821$62,29476,857$ 2,02900015,11215,1120.619,143148,294$ 2,0290006,4196,4190.613,884$66,17882,117$ 2,03000015,82315,8230.599,294157,588$ 2,0300006,7216,7210.593,948$70,12687,463$ 2,03100016,56616,5660.579,448167,036$ 2,0310007,0377,0370.574,013$74,13992,897$ 2,03200017,34517,3450.559,604176,640$ 2,0320007,3687,3680.554,079$78,21898,421$ 2,03300018,16018,1600.549,762186,402$ 2,0330007,7147,7140.544,147$82,365104,037$ 2,03400019,01419,0140.529,923196,325$ 2,0340008,0778,0770.524,215$86,580109,745$ 2,03500019,90719,9070.5110,087206,412$ 2,0350008,4568,4560.514,285$90,865115,547$ 2,03600020,84320,8430.4910,253216,665$ 2,0360008,8548,8540.494,355$95,220121,445$ 2,03700021,82321,8230.4810,423227,088$ 2,0370009,2709,2700.484,427$99,647127,440$ 2,03800022,84822,8480.4610,595237,682$ 2,0380009,7059,7050.464,500$104,148133,534$ 2,03900023,92223,9220.4510,770248,452$ 2,03900010,16210,1620.454,575$108,723139,729$ 2,04000025,04725,0470.4410,947259,399$ 2,04000010,63910,6390.444,650$113,373146,026$ 2,04100026,22426,2240.4211,128270,527$ 2,04100011,13911,1390.424,727$118,100152,427$ 2,04200027,45627,4560.4111,312281,839$ 2,04200011,66311,6630.414,805$122,905158,934$ Totals:$0$0$0$470,831$470,831$281,839=30-year LCCTotals:$3,186$0$0$199,999$203,185$122,905=30-year LCC
Energy Audit Report
April 16, 2012
pg. 39
ECM #2 Calculations
System 1 - Location Served:
Fuel Type AFUE Thermostat
Setpoint
Full Load KW
(Electric Only)
Mo/Yr Operation
(Electric Only)Cost
Existing Natural Gas 80.00%70.0 0.0 N/A
Proposed Natural Gas 94.00%65.0 0.0 $6,498.58
System 2 - Location Served:
Fuel Type AFUE Thermostat
Setpoint
Full Load KW
(Electric Only)
Mo/Yr Operation
(Electric Only)Cost
Existing Natural Gas 80.00%70.0 N/A
Proposed Natural Gas 80.00%65.0
System 3 - Location Served:
Fuel Type AFUE Thermostat
Setpoint
Full Load KW
(Electric Only)
Mo/Yr Operation
(Electric Only)Cost
Existing Natural Gas 80.00%70.0 N/A
Proposed Natural Gas 80.00%65.0
Heating Data
60
Volume Served
60
Description
of Retrofit
Combines 4 garage bay unit heaters
Replace existing furnace in mezzanine with 94% AFUE furnace. Install programmable
thermostats for all three heating systems to reduce average temperature to 65 degrees.
10
Volume Served
30
Description
of Retrofit
Volume Served
30
Description
of Retrofit
10
Estimated Demand Charges (electric)
Estimated Savings per Year
$0.00
$3,333.47
$747.71
$6,498.58Estimated Cost of Heating System
Replacements
New Heating SystemsExisting Heating Systems
3327 2,580.74
$1.00
70
Average Cost Per Therm of Heating Fuels,
proportional to volume
Average Thermostat Setpoint, proportional
to volume
Therms required to heat the building over
1 year
Estimated Cost over 1 year $2,585.76
Average AFUE of All Heating Systems,
proportional to volume 80.00%
Heating System Summary
$1.00
65
$0.00
88.40%
Energy Audit Report
April 16, 2012
pg. 40
---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$333,333$ $0$3,367(1+i)^-nCostsCosts2,012$6,499$262,586$ $0$2,612(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$6,499------$6,4991.00$6,499$6,4992,013343,37703,4110.973,3123,311.79$ 2,0130272,61902,6460.972,569$9,068(5,756)$ 2,0140353,42103,4560.943,2586,569$ 2,0140272,65302,6810.942,527$11,594(5,025)$ 2,0150363,46503,5020.923,2049,774$ 2,0150282,68802,7160.922,486$14,080(4,306)$ 2,0160383,51003,5480.893,15212,926$ 2,0160292,72302,7520.892,445$16,525(3,599)$ 2,0170393,73803,7770.863,25816,184$ 2,0170302,90002,9300.862,527$19,053(2,868)$ 2,0180403,98104,0210.843,36819,552$ 2,0180313,08803,1190.842,612$21,665(2,113)$ 2,0190414,24004,2810.813,48123,033$ 2,0190323,28903,3210.812,700$24,365(1,332)$ 2,0200424,51604,5580.793,59826,631$ 2,0200333,50303,5360.792,791$27,156(525)$ 2,0210434,80904,8530.773,71930,350$ 2,0210343,73103,7640.772,885$30,041309$ 2,0220455,12205,1670.743,84534,195$ 2,0220353,97304,0080.742,982$33,0231,171$ 2,0230465,45505,5010.723,97438,169$ 2,0230364,23104,2670.723,083$36,1062,063$ 2,0240485,80905,8570.704,10842,277$ 2,0240374,50604,5430.703,187$39,2922,984$ 2,0250496,18706,2360.684,24646,523$ 2,0250384,79904,8370.683,294$42,5863,937$ 2,0260506,58906,6400.664,39050,913$ 2,0260395,11105,1500.663,405$45,9914,921$ 2,0270527,26807,3200.644,69855,611$ 2,0270405,63805,6780.643,644$49,6365,975$ 2,0280538,01608,0700.625,02960,640$ 2,0280416,21806,2600.623,901$53,5377,103$ 2,0290558,84208,8970.615,38366,023$ 2,0290436,85906,9020.614,176$57,7128,311$ 2,0300579,75309,8100.595,76271,785$ 2,0300447,56507,6090.594,470$62,1829,603$ 2,03105810,757010,8160.576,16877,953$ 2,0310458,34408,3900.574,785$66,96610,987$ 2,03206011,865011,9260.556,60384,556$ 2,0320479,20409,2510.555,122$72,08812,468$ 2,03306213,088013,1500.547,06991,625$ 2,03304810,152010,2000.545,483$77,57114,053$ 2,03406414,436014,4990.527,56799,192$ 2,03405011,198011,2470.525,870$83,44115,751$ 2,03506615,922015,9880.518,101107,293$ 2,03505112,351012,4020.516,284$89,72517,568$ 2,03606817,562017,6300.498,673115,966$ 2,03605313,623013,6760.496,728$96,45319,513$ 2,03707019,371019,4410.489,285125,251$ 2,03705415,026015,0800.487,203$103,65521,596$ 2,03807221,367021,4390.469,941135,192$ 2,03805616,574016,6300.467,711$111,36623,826$ 2,03907423,567023,6410.4510,643145,835$ 2,03905718,281018,3390.458,256$119,62226,213$ 2,04007625,995026,0710.4411,395157,230$ 2,04005920,164020,2230.448,839$128,46128,769$ 2,04107928,672028,7510.4212,200169,431$ 2,04106122,241022,3020.429,464$137,92531,506$ 2,04208131,626031,7070.4113,063182,493$ 2,04206324,532024,5950.4110,133$148,05834,436$ Totals:$0$1,633$332,329$0$333,962$182,493=30-year LCCTotals:$6,499$1,267$257,786$0$265,552$148,058=30-year LCC
Energy Audit Report
April 16, 2012
pg. 41
ECM #3 Calculations
Space Description
Number of Fixtures 2 2
Lamps per Fixture 1 1
Lamp Type Mercury Vapor Metal Halide
Fixture Wattage 455 279.7
Hours on per Week 84 84
Cost of New Lamp
Cost of New Fixture $1,058.56
Total KWH Cost $755.23 $464.26
Total Demand Cost $79.61 $48.94
Total Yearly Cost $834.83 $513.19
Yearly Savings $321.64
Total Retrofit Cost $2,117.12
Payback Period 6.6 years
Exterior
Replace exterior mercury vapor lamps with 250w metal halide lamps.Retrofit Description
Energy Audit Report
April 16, 2012
pg. 42
---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$17-$ $835$852(1+i)^-nCostsCosts2,012$2,117$10-$ $513$523(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$2,117------$2,1171.00$2,117$2,1172,01301708578750.97849849.10$ 2,01301105275380.97522$2,639(1,790)$ 2,01401808818980.948471,696$ 2,01401105415520.94520$3,160(1,464)$ 2,01501809049230.928442,540$ 2,01501105565670.92519$3,679(1,139)$ 2,01601909299480.898423,382$ 2,01601205715820.89518$4,196(814)$ 2,01701909589770.868434,225$ 2,01701205896010.86518$4,714(490)$ 2,01802009871,0070.848435,068$ 2,01801206076190.84518$5,233(165)$ 2,01902101,0181,0380.818445,912$ 2,01901306266380.81519$5,752161$ 2,02002101,0491,0700.798456,757$ 2,02001306456580.79519$6,271486$ 2,02102201,0821,1040.778467,603$ 2,02101306656780.77520$6,791812$ 2,02202201,1151,1380.748478,450$ 2,02201406866990.74520$7,3111,138$ 2,02302301,1501,1730.728479,297$ 2,02301407077210.72521$7,8321,465$ 2,02402401,1861,2090.7084810,146$ 2,02401507297430.70521$8,3541,792$ 2,02502501,2221,2470.6884910,995$ 2,02501507517670.68522$8,8762,119$ 2,02602501,2601,2860.6685011,845$ 2,02601607757900.66522$9,3982,446$ 2,02702601,3201,3460.6486412,708$ 2,02701608118270.64531$9,9292,779$ 2,02802701,3821,4080.6287813,586$ 2,02801608498660.62539$10,4693,117$ 2,02902801,4461,4740.6189214,478$ 2,02901708899060.61548$11,0173,461$ 2,03002801,5141,5430.5990615,384$ 2,03001709319480.59557$11,5743,810$ 2,03102901,5861,6150.5792116,305$ 2,03101809759930.57566$12,1404,165$ 2,03203001,6601,6900.5593617,241$ 2,03201901,0211,0390.55575$12,7154,525$ 2,03303101,7381,7690.5495118,192$ 2,03301901,0691,0880.54585$13,3004,892$ 2,03403201,8201,8520.5296619,158$ 2,03402001,1191,1380.52594$13,8945,264$ 2,03503301,9051,9380.5198220,140$ 2,03502001,1711,1920.51604$14,4985,642$ 2,03603401,9952,0290.4999821,139$ 2,03602101,2261,2470.49614$15,1126,027$ 2,03703502,0892,1240.481,01422,153$ 2,03702101,2841,3050.48624$15,7356,418$ 2,03803602,1872,2230.461,03123,184$ 2,03802201,3441,3660.46634$16,3696,815$ 2,03903702,2902,3270.451,04724,231$ 2,03902301,4081,4300.45644$17,0137,218$ 2,04003802,3972,4350.441,06525,296$ 2,04002301,4741,4970.44654$17,6677,629$ 2,04103902,5102,5490.421,08226,377$ 2,04102401,5431,5670.42665$18,3328,045$ 2,04204102,6282,6680.411,09927,477$ 2,04202501,6151,6400.41676$19,0088,469$ Totals:$0$818$0$45,065$45,883$27,477=30-year LCCTotals:$2,117$503$0$27,703$30,323$19,008=30-year LCC
Energy Audit Report
April 16, 2012
pg. 43
ECM #4 Calculations
Space Description
Number of Fixtures 11 11
Lamps per Fixture 4 4
Lamp Type 4' T12 4'T8
Fixture Wattage 195.6 88.5
Hours on per Week 45 45
Cost of New Lamp
Cost of New Fixture $436.83
Total KWH Cost $956.60 $432.82
Total Demand Cost $188.22 $85.16
Total Yearly Cost $1,144.82 $517.98
Yearly Savings $626.84
Total Retrofit Cost $4,805.13
Payback Period 7.7 years
Office Areas
Retrofit Description Replace existing 4' 4 lamp T12 fixtures with 4' 4 lamp T8 fixtures with
25w lamps and electronic ballasts.
Energy Audit Report
April 16, 2012
pg. 44
---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$23-$ $1,145$1,168(1+i)^-nCostsCosts2,012$4,805$10-$ $518$528(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$4,805------$4,8051.00$4,805$4,8052,01302401,1761,1990.971,1641,164.39$ 2,01301105325430.97527$5,332(4,168)$ 2,01402401,2071,2320.941,1612,325$ 2,01401105465570.94525$5,857(3,532)$ 2,01502501,2401,2650.921,1583,483$ 2,01501105615720.92524$6,381(2,898)$ 2,01602601,2741,2990.891,1544,638$ 2,01601205765880.89522$6,903(2,266)$ 2,01702701,3131,3400.861,1565,793$ 2,01701205946060.86523$7,426(1,633)$ 2,01802701,3541,3810.841,1576,950$ 2,01801206136250.84523$7,950(1,000)$ 2,01902801,3961,4240.811,1588,108$ 2,01901306316440.81524$8,473(366)$ 2,02002901,4391,4680.791,1599,266$ 2,02001306516640.79524$8,998269$ 2,02103001,4841,5130.771,16010,426$ 2,02101406716850.77525$9,523904$ 2,02203101,5301,5600.741,16111,587$ 2,02201406927060.74525$10,0481,539$ 2,02303201,5771,6090.721,16212,750$ 2,02301407147280.72526$10,5742,176$ 2,02403301,6261,6590.701,16313,913$ 2,02401507367500.70526$11,1002,813$ 2,02503401,6761,7100.681,16415,077$ 2,02501507587740.68527$11,6273,450$ 2,02603501,7281,7630.661,16516,243$ 2,02601607827980.66527$12,1544,088$ 2,02703601,8091,8450.641,18417,427$ 2,02701608198350.64536$12,6904,737$ 2,02803701,8951,9310.621,20418,630$ 2,02801708578740.62545$13,2355,396$ 2,02903801,9842,0210.611,22319,853$ 2,02901708979150.61553$13,7886,066$ 2,03003902,0772,1160.591,24321,096$ 2,03001809409570.59562$14,3506,746$ 2,03104002,1742,2150.571,26322,359$ 2,03101809841,0020.57571$14,9227,438$ 2,03204102,2772,3180.551,28323,643$ 2,03201901,0301,0490.55581$15,5028,140$ 2,03304302,3842,4260.541,30424,947$ 2,03301901,0781,0980.54590$16,0928,854$ 2,03404402,4962,5400.521,32526,272$ 2,03402001,1291,1490.52600$16,6929,580$ 2,03504502,6132,6580.511,34727,619$ 2,03502001,1821,2030.51609$17,30110,318$ 2,03604702,7362,7820.491,36928,988$ 2,03602101,2381,2590.49619$17,92111,067$ 2,03704802,8642,9120.481,39130,379$ 2,03702201,2961,3180.48629$18,55011,829$ 2,03804902,9993,0480.461,41331,792$ 2,03802201,3571,3790.46640$19,19012,602$ 2,03905103,1403,1910.451,43633,228$ 2,03902301,4211,4440.45650$19,83913,389$ 2,04005203,2873,3400.441,46034,688$ 2,04002401,4871,5110.44660$20,50014,188$ 2,04105403,4423,4960.421,48336,172$ 2,04102401,5571,5820.42671$21,17115,001$ 2,04205603,6043,6590.411,50837,679$ 2,04202501,6311,6560.41682$21,85315,826$ Totals:$0$1,122$0$61,798$62,920$37,679=30-year LCCTotals:$4,805$508$0$27,961$33,274$21,853=30-year LCC
Energy Audit Report
April 16, 2012
pg. 45
ECM #5 Calculations
Component Framed
Section
Insulated
Section Component Framed
Section
Insulated
Section
Total R-Values 0 0 Total R-Values 0 0
Total U-Values 0.0000 #DIV/0!Total U-Values 0.0000 #DIV/0!
Percentage of Framing 100.00%Percentage of Framing 100.00%
Composite U-Value of Assembly 0.0000 Composite U-Value of Assembly 0.0000
Window U-value Window U-value
Wall Square Footage Wall Square Footage
Window Square Footage Window Square Footage
Door Square Footage 144 Door Square Footage 144
Door U Value 0.55 Door U-Value 0.15
Opaque Wall Area 0 Opaque Wall Area 0
Composite U-value for entire assembly 0.5500 Composite U-value for entire assembly 0.1500
Composite R-Value for entire assembly 1.8182 Composite R-Value for entire assembly 6.6667
Heating System Served System 1 Heating System Served System 1
Heat Loss in BTU/h 2772.00 Heat Loss in BTU/h 756.00Original
Heating
Proposed
Heating
Savings -
Original Heating
Savings -
Proposed Yearly Cost $304.12 Yearly Cost $82.94 $70.59 $221.18 $161.35
Cost of Proposed Upgrade $3,062.18
Above Grade Wall - Original Above Grade Wall - Proposed
Assembly 4 Assembly 4
Energy Audit Report
April 16, 2012
pg. 46
---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2012$0304$ $0$304(1+i)^-nCostsCosts2012$3,062$083$ $0$83(1+i)^-nCostsCosts2012$0------$01.00$0-$ 2012$3,062------$3,0621.00$3,062$3,0622013030803080.97299299.11$ 201300840840.9782$3,144(2,845)$ 20140031203120.94294593$ 201400850850.9480$3,224(2,631)$ 20150031603160.92289883$ 201500860860.9279$3,303(2,420)$ 20160032003200.892851,167$ 201600870870.8978$3,380(2,213)$ 20170034103410.862941,461$ 201700930930.8680$3,461(1,999)$ 20180036303630.843041,766$ 201800990990.8483$3,544(1,778)$ 20190038703870.813152,080$ 20190010601060.8186$3,629(1,549)$ 20200041204120.793252,405$ 20200011201120.7989$3,718(1,313)$ 20210043904390.773362,742$ 20210012001200.7792$3,810(1,068)$ 20220046704670.743483,089$ 20220012701270.7495$3,905(815)$ 20230049804980.723603,449$ 20230013601360.7298$4,003(554)$ 20240053005300.703723,821$ 20240014501450.70101$4,104(284)$ 20250056405640.683844,205$ 20250015401540.68105$4,209(4)$ 20260060106010.663974,602$ 20260016401640.66108$4,317285$ 20270066306630.644265,028$ 20270018101810.64116$4,433595$ 20280073107310.624565,484$ 20280019901990.62124$4,558926$ 20290080708070.614885,972$ 20290022002200.61133$4,6911,281$ 20300089008900.595236,494$ 20300024302430.59143$4,8331,661$ 20310098109810.575607,054$ 20310026802680.57153$4,9862,068$ 2032001,08301,0830.555997,654$ 20320029502950.55163$5,1502,504$ 2033001,19401,1940.546428,295$ 20330032603260.54175$5,3252,971$ 2034001,31701,3170.526878,983$ 20340035903590.52187$5,5123,471$ 2035001,45301,4530.517369,719$ 20350039603960.51201$5,7134,006$ 2036001,60201,6020.4978810,507$ 20360043704370.49215$5,9284,579$ 2037001,76701,7670.4884411,351$ 20370048204820.48230$6,1585,193$ 2038001,94901,9490.4690412,255$ 20380053205320.46247$6,4045,851$ 2039002,15002,1500.4596813,223$ 20390058605860.45264$6,6686,555$ 2040002,37202,3720.441,03714,260$ 20400064706470.44283$6,9517,308$ 2041002,61602,6160.421,11015,370$ 20410071307130.42303$7,2548,116$ 2042002,88502,8850.411,18916,558$ 20420078707870.41324$7,5788,980$ Totals:$0$0$30,320$0$30,320$16,558=30-year LCCTotals:$3,062$0$8,269$0$11,331$7,578=30-year LCC
Energy Audit Report
April 16, 2012
pg. 47
ECM #6 Calculations
Space Description
Number of Fixtures 6 6
Lamps per Fixture 2 2
Lamp Type 4' T12 4' T8
Fixture Wattage 97.8 45.5
Hours on per Week 45 45
Cost of New Lamp
Cost of New Fixture $271.22
Total KWH Cost $260.89 $121.38
Total Demand Cost $51.33 $23.88
Total Yearly Cost $312.22 $145.26
Yearly Savings $166.97
Total Retrofit Cost $1,627.32
Payback Period 9.7 years
Retrofit Description
Warehouse, Mezzanine, Hallway
Replace existing 4' 2 lamp T12 fixtures with 2 lamp T8 fixtures with
25w lamps and electronic ballasts.
Energy Audit Report
April 16, 2012
pg. 48
---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$6-$ $312$318(1+i)^-nCostsCosts2,012$1,627$3-$ $145$148(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$1,627------$1,6271.00$1,627$1,6272,0130603213270.97318317.56$ 2,0130301491520.97148$1,775(1,458)$ 2,0140703293360.94317634$ 2,0140301531560.94147$1,922(1,288)$ 2,0150703383450.92316950$ 2,0150301571610.92147$2,069(1,119)$ 2,0160703473540.893151,265$ 2,0160301621650.89146$2,216(951)$ 2,0170703583650.863151,580$ 2,0170301671700.86147$2,362(782)$ 2,0180703693770.843151,895$ 2,0180301721750.84147$2,509(614)$ 2,0190803813880.813162,211$ 2,0190401771810.81147$2,656(445)$ 2,0200803924000.793162,527$ 2,0200401831860.79147$2,803(276)$ 2,0210804054130.773162,844$ 2,0210401881920.77147$2,950(107)$ 2,0220804174260.743173,160$ 2,0220401941980.74147$3,09863$ 2,0230904304390.723173,477$ 2,0230402002040.72147$3,245232$ 2,0240904434520.703173,794$ 2,0240402062100.70148$3,393402$ 2,0250904574660.683184,112$ 2,0250402132170.68148$3,540572$ 2,0260904714810.663184,430$ 2,0260402192240.66148$3,688742$ 2,02701004935030.643234,753$ 2,0270502302340.64150$3,838914$ 2,02801005175270.623285,081$ 2,0280502402450.62153$3,9911,090$ 2,02901005415510.613345,415$ 2,0290502522560.61155$4,1461,268$ 2,03001105665770.593395,754$ 2,0300502642680.59158$4,3041,449$ 2,03101105936040.573446,098$ 2,0310502762810.57160$4,4641,634$ 2,03201106216320.553506,448$ 2,0320502892940.55163$4,6271,821$ 2,03301206506620.543566,804$ 2,0330503023080.54165$4,7932,011$ 2,03401206816930.523617,165$ 2,0340603173220.52168$4,9612,204$ 2,03501207137250.513677,532$ 2,0350603323370.51171$5,1322,401$ 2,03601307467590.493737,906$ 2,0360603473530.49174$5,3052,600$ 2,03701307817940.483798,285$ 2,0370603633700.48176$5,4822,803$ 2,03801308188310.463858,671$ 2,0380603813870.46179$5,6613,009$ 2,03901408568700.453929,062$ 2,0390603984050.45182$5,8433,219$ 2,04001408979110.443989,460$ 2,0400704174240.44185$6,0293,432$ 2,04101509399530.424059,865$ 2,0410704374440.42188$6,2173,648$ 2,04201509839980.4141110,276$ 2,0420704574640.41191$6,4083,868$ Totals:$0$306$0$16,854$17,160$10,276=30-year LCCTotals:$1,627$142$0$7,841$9,611$6,408=30-year LCC
Energy Audit Report
April 16, 2012
pg. 49
ECM #7 Calculations
Space Description
Number of Fixtures 32 32
Lamps per Fixture 2 4
Lamp Type 8'T12 4'T8
Fixture Wattage 169.7 88.5
Hours on per Week 45 45
Cost of New Lamp
Cost of New Fixture $436.83
Total KWH Cost $2,414.36 $1,259.11
Total Demand Cost $475.05 $247.74
Total Yearly Cost $2,889.41 $1,506.85
Yearly Savings $1,382.56
Total Retrofit Cost $13,978.56
Payback Period 10.1 years
Warehouse, Storage Area, Mezzanine
Retrofit Description Replace existing 8' 2 lamp T12 fixtures with 4 lamp T8 fixtures with
25w lamps and electronic ballasts.
Energy Audit Report
April 16, 2012
pg. 50
---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$58-$ $2,889$2,947(1+i)^-nCostsCosts2,012$13,979$30-$ $1,507$1,537(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$13,979------$13,9791.00$13,979$13,9792,01306002,9673,0270.972,9392,938.78$ 2,01303101,5481,5790.971,533$15,511(12,572)$ 2,01406103,0483,1090.942,9305,869$ 2,01403201,5891,6210.941,528$17,039(11,170)$ 2,01506303,1303,1930.922,9228,791$ 2,01503301,6321,6650.921,524$18,563(9,772)$ 2,01606503,2143,2790.892,91411,705$ 2,01603401,6761,7100.891,520$20,083(8,378)$ 2,01706703,3143,3810.862,91614,621$ 2,01703501,7281,7630.861,521$21,604(6,982)$ 2,01806903,4173,4860.842,91917,541$ 2,01803601,7821,8180.841,522$23,126(5,586)$ 2,01907103,5233,5940.812,92220,463$ 2,01903701,8371,8740.811,524$24,650(4,187)$ 2,02007303,6323,7050.792,92523,387$ 2,02003801,8941,9320.791,525$26,175(2,788)$ 2,02107503,7443,8200.772,92826,315$ 2,02103901,9531,9920.771,527$27,702(1,387)$ 2,02207803,8603,9380.742,93029,245$ 2,02204102,0132,0540.741,528$29,23015$ 2,02308003,9804,0600.722,93332,178$ 2,02304202,0762,1170.721,530$30,7601,419$ 2,02408204,1044,1860.702,93635,114$ 2,02404302,1402,1830.701,531$32,2912,823$ 2,02508504,2314,3160.682,93938,053$ 2,02504402,2062,2510.681,533$33,8244,230$ 2,02608704,3624,4490.662,94240,995$ 2,02604602,2752,3200.661,534$35,3585,637$ 2,02709004,5674,6570.642,98943,984$ 2,02704702,3822,4290.641,559$36,9167,067$ 2,02809304,7824,8740.623,03847,021$ 2,02804802,4942,5420.621,584$38,5018,521$ 2,02909605,0065,1020.613,08750,108$ 2,02905002,6112,6610.611,610$40,1109,998$ 2,03009805,2425,3400.593,13753,245$ 2,03005102,7342,7850.591,636$41,74611,499$ 2,031010105,4885,5890.573,18756,432$ 2,03105302,8622,9150.571,662$43,40813,024$ 2,032010405,7465,8500.553,23959,671$ 2,03205402,9973,0510.551,689$45,09814,574$ 2,033010806,0166,1230.543,29262,963$ 2,03305603,1373,1930.541,717$46,81416,149$ 2,034011106,2996,4090.523,34566,308$ 2,03405803,2853,3430.521,744$48,55917,749$ 2,035011406,5956,7090.513,39969,707$ 2,03505903,4393,4990.511,773$50,33119,376$ 2,036011706,9057,0220.493,45473,162$ 2,03606103,6013,6620.491,802$52,13321,029$ 2,037012107,2297,3500.483,51076,672$ 2,03706303,7703,8330.481,831$53,96422,708$ 2,038012507,5697,6940.463,56780,240$ 2,03806503,9474,0120.461,860$55,82424,415$ 2,039012807,9258,0530.453,62583,865$ 2,03906704,1334,2000.451,891$57,71526,150$ 2,040013208,2978,4290.443,68487,549$ 2,04006904,3274,3960.441,921$59,63627,913$ 2,041013608,6878,8230.423,74491,293$ 2,04107104,5304,6010.421,953$61,58929,705$ 2,042014009,0959,2360.413,80595,098$ 2,04207304,7434,8170.411,984$63,57331,525$ Totals:$0$2,832$0$155,973$158,804$95,098=30-year LCCTotals:$13,979$1,477$0$81,341$96,796$63,573=30-year LCC
Energy Audit Report
April 16, 2012
pg. 51
ECM #8 Calculations
Component Framed
Section
Insulated
Section Component Framed
Section
Insulated
Section
Total R-Values 0 0 Total R-Values 0 0
Total U-Values 0.0000 #DIV/0!Total U-Values 0.0000 #DIV/0!
Percentage of Framing 100.00%Percentage of Framing 100.00%
Composite U-Value of Assembly 0.0000 Composite U-Value of Assembly 0.0000
Window U-value 0.81 Window U-value 0.3
Wall Square Footage Wall Square Footage
Window Square Footage 67 Window Square Footage 67
Door Square Footage Door Square Footage
Door U Value Door U-Value
Opaque Wall Area 0 Opaque Wall Area 0
Composite U-value for entire assembly 0.8100 Composite U-value for entire assembly 0.3000
Composite R-Value for entire assembly 1.2346 Composite R-Value for entire assembly 3.3333
Heating System Served System 1 Heating System Served System 1
Heat Loss in BTU/h 1899.45 Heat Loss in BTU/h 703.50Original
Heating
Proposed
Heating
Savings -
Original Heating
Savings -
Proposed Yearly Cost $208.39 Yearly Cost $77.18 $65.69 $131.21 $95.72
Cost of Proposed Upgrade $2,775.28
Above Grade Wall - Original Above Grade Wall - Proposed
Assembly 2 Assembly 2
Energy Audit Report
April 16, 2012
pg. 52
---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2012$0208$ $0$208(1+i)^-nCostsCosts2012$2,775$077$ $0$77(1+i)^-nCostsCosts2012$0------$01.00$0-$ 2012$2,775------$2,7751.00$2,775$2,7752013021102110.97205204.95$ 201300780780.9776$2,851(2,646)$ 20140021402140.94202407$ 201400790790.9475$2,926(2,519)$ 20150021702170.92198605$ 201500800800.9273$2,999(2,394)$ 20160021902190.89195800$ 201600810810.8972$3,071(2,272)$ 20170023402340.862021,001$ 201700870870.8675$3,146(2,145)$ 20180024902490.842081,210$ 201800920920.8477$3,223(2,014)$ 20190026502650.812161,425$ 201900980980.8180$3,303(1,878)$ 20200028202820.792231,648$ 20200010501050.7983$3,386(1,738)$ 20210030103010.772301,879$ 20210011101110.7785$3,471(1,592)$ 20220032003200.742382,117$ 20220011901190.7488$3,559(1,442)$ 20230034103410.722462,363$ 20230012601260.7291$3,651(1,287)$ 20240036303630.702552,618$ 20240013501350.7094$3,745(1,127)$ 20250038703870.682632,881$ 20250014301430.6898$3,842(961)$ 20260041204120.662723,154$ 20260015301530.66101$3,943(790)$ 20270045404540.642923,445$ 20270016801680.64108$4,051(606)$ 20280050105010.623123,758$ 20280018601860.62116$4,167(409)$ 20290055305530.613344,092$ 20290020502050.61124$4,291(199)$ 20300061006100.593584,450$ 20300022602260.59133$4,42327$ 20310067306730.573844,834$ 20310024902490.57142$4,566268$ 20320074207420.554115,244$ 20320027502750.55152$4,718527$ 20330081808180.544405,684$ 20330030303030.54163$4,881804$ 20340090209020.524716,155$ 20340033403340.52174$5,0551,100$ 20350099509950.515046,660$ 20350036903690.51187$5,2421,418$ 2036001,09801,0980.495407,200$ 20360040704070.49200$5,4421,758$ 2037001,21101,2110.485787,778$ 20370044904490.48214$5,6562,122$ 2038001,33601,3360.466198,397$ 20380049504950.46229$5,8852,512$ 2039001,47301,4730.456639,061$ 20390054605460.45246$6,1312,930$ 2040001,62501,6250.447109,771$ 20400060206020.44263$6,3943,377$ 2041001,79201,7920.4276110,532$ 20410066406640.42282$6,6763,856$ 2042001,97701,9770.4181511,346$ 20420073207320.41302$6,9784,369$ Totals:$0$0$20,776$0$20,776$11,346=30-year LCCTotals:$2,775$0$7,695$0$10,470$6,978=30-year LCC
Energy Audit Report
April 16, 2012
pg. 53
ECM #9 Calculations
Component Framed
Section
Insulated
Section Component Framed
Section
Insulated
Section
Total R-Values 0 0 Total R-Values 0 0
Total U-Values 0.0000 #DIV/0!Total U-Values 0.0000 #DIV/0!
Percentage of Framing 100.00%Percentage of Framing 100.00%
Composite U-Value of Assembly 0.0000 Composite U-Value of Assembly 0.0000
Window U-value Window U-value
Wall Square Footage Wall Square Footage
Window Square Footage Window Square Footage
Door Square Footage 63 Door Square Footage 63
Door U Value 0.55 Door U-Value 0.16
Opaque Wall Area 0 Opaque Wall Area 0
Composite U-value for entire assembly 0.5500 Composite U-value for entire assembly 0.1600
Composite R-Value for entire assembly 1.8182 Composite R-Value for entire assembly 6.2500
Heating System Served System 1 Heating System Served System 1
Heat Loss in BTU/h 1212.75 Heat Loss in BTU/h 352.80Original
Heating
Proposed
Heating
Savings -
Original Heating
Savings -
Proposed Yearly Cost $133.05 7871.8 Yearly Cost $38.71 $32.94 $94.35 $68.83
Cost of Proposed Upgrade $2,170.94
Above Grade Wall - Original
Assembly 1 Assembly 1
Above Grade Wall - Proposed
Energy Audit Report
April 16, 2012
pg. 54
---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2012$0133$ $0$133(1+i)^-nCostsCosts2012$2,171$039$ $0$39(1+i)^-nCostsCosts2012$0------$01.00$0-$ 2012$2,171------$2,1711.00$2,171$2,1712013013501350.97131130.86$ 201300390390.9738$2,209(2,078)$ 20140013701370.94129260$ 201400400400.9437$2,246(1,987)$ 20150013801380.92127386$ 201500400400.9237$2,283(1,897)$ 20160014001400.89124511$ 201600410410.8936$2,319(1,809)$ 20170014901490.86129639$ 201700430430.8637$2,357(1,718)$ 20180015901590.84133772$ 201800460460.8439$2,396(1,623)$ 20190016901690.81138910$ 201900490490.8140$2,436(1,526)$ 20200018001800.791421,052$ 202000520520.7941$2,477(1,425)$ 20210019201920.771471,199$ 202100560560.7743$2,520(1,320)$ 20220020402040.741521,352$ 202200590590.7444$2,564(1,213)$ 20230021802180.721571,509$ 202300630630.7246$2,610(1,101)$ 20240023202320.701631,671$ 202400670670.7047$2,657(986)$ 20250024702470.681681,840$ 202500720720.6849$2,706(866)$ 20260026302630.661742,014$ 202600770770.6651$2,757(743)$ 20270029002900.641862,200$ 202700840840.6454$2,811(611)$ 20280032003200.621992,399$ 202800930930.6258$2,869(470)$ 20290035303530.612142,613$ 20290010301030.6162$2,931(318)$ 20300038903890.592292,841$ 20300011301130.5967$2,998(156)$ 20310042904290.572453,086$ 20310012501250.5771$3,06917$ 20320047404740.552623,348$ 20320013801380.5576$3,145203$ 20330052205220.542813,629$ 20330015201520.5482$3,227403$ 20340057605760.523013,930$ 20340016801680.5287$3,314616$ 20350063606360.513224,252$ 20350018501850.5194$3,408844$ 20360070107010.493454,597$ 20360020402040.49100$3,5081,089$ 20370077307730.483694,966$ 20370022502250.48107$3,6161,350$ 20380085308530.463955,362$ 20380024802480.46115$3,7311,631$ 20390094109410.454235,785$ 20390027402740.45123$3,8541,931$ 2040001,03801,0380.444546,239$ 20400030203020.44132$3,9862,253$ 2041001,14401,1440.424866,724$ 20410033303330.42141$4,1272,597$ 2042001,26201,2620.415207,244$ 20420036703670.41151$4,2782,966$ Totals:$0$0$13,265$0$13,265$7,244=30-year LCCTotals:$2,171$0$3,859$0$6,030$4,278=30-year LCC
Energy Audit Report
April 16, 2012
pg. 55
ECM #10 Calculations
Component Framed
Section
Insulated
Section Component Framed
Section
Insulated
Section
Air film 0.61 0.61 Air film 0.61 0.61
Sheathing 2.5 2.5 Sheathing 2.5 2.5
3" EPS Insulation 12 12 3" EPS Insulation 12 12
Roof Covering 1 1 Roof Covering 1 1
Air film 0.17 0.17 Air film 0.17 0.17
2.25" Insulation, R16.7 16.7 16.7
Total R-Values 16.28 16.28 Total R-Values 32.98 32.98
Total U-Values 0.0614 0.0614 Total U-Values 0.0303 0.0303
Percentage of Framing 0.00%100.00%Percentage of Framing 0.00%100.00%
Composite U-Value of Assembly 0.0614 Composite U-Value of Assembly 0.0303
Skylight U-value Skylight U-value
Ceiling Square Footage 4608 Ceiling Square Footage 4608
Skylight Square Footage Skylight Square Footage
Opaque Ceiling Area 4608 Opaque Ceiling Area 4608
Composite U-value for entire assembly 0.0614 Composite U-value for entire assembly 0.0303
Composite R-Value for entire assembly 16.2800 Composite R-Value for entire assembly 32.9800
Heating System Served System 1 Heating System Served System 1
Heat Loss in BTU/h 9906.63 Heat Loss in BTU/h 4890.24
Original
Heating
System
Proposed
Heating
System
Savings -
Original Heating
System
Savings -
Proposed
Heating
System
Yearly Cost $1,086.89 Yearly Cost $536.52 $456.62 $550.36 $401.48
Cost of Proposed Upgrade $15,482.76
Assembly 1 Assembly 1
Ceiling - ProposedCeiling - Original
Energy Audit Report
April 16, 2012
pg. 56
---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2012$01,087$ $0$1,087(1+i)^-nCostsCosts2012$15,483$0537$ $0$537(1+i)^-nCostsCosts2012$0------$01.00$0-$ 2012$15,483------$15,4831.00$15,483$15,483201301,10101,1010.971,069########20130054305430.97528$16,010(14,941)$ 2014001,11501,1150.941,0512,120$ 20140055105510.94519$16,529(14,409)$ 2015001,13001,1300.921,0343,154$ 20150055805580.92510$17,040(13,886)$ 2016001,14501,1450.891,0174,171$ 20160056505650.89502$17,542(13,371)$ 2017001,21901,2190.861,0515,223$ 20170060206020.86519$18,061(12,838)$ 2018001,29801,2980.841,0876,310$ 20180064106410.84537$18,597(12,288)$ 2019001,38301,3830.811,1247,434$ 20190068206820.81555$19,152(11,719)$ 2020001,47201,4720.791,1628,596$ 20200072707270.79574$19,726(11,130)$ 2021001,56801,5680.771,2029,798$ 20210077407740.77593$20,319(10,521)$ 2022001,67001,6700.741,24311,041$ 20220082408240.74613$20,933(9,892)$ 2023001,77901,7790.721,28512,325$ 20230087808780.72634$21,567(9,242)$ 2024001,89401,8940.701,32913,654$ 20240093509350.70656$22,223(8,569)$ 2025002,01702,0170.681,37415,028$ 20250099609960.68678$22,901(7,873)$ 2026002,14802,1480.661,42016,448$ 2026001,06101,0610.66701$23,602(7,154)$ 2027002,37002,3700.641,52117,969$ 2027001,17001,1700.64751$24,353(6,384)$ 2028002,61402,6140.621,62919,598$ 2028001,29001,2900.62804$25,157(5,559)$ 2029002,88302,8830.611,74421,342$ 2029001,42301,4230.61861$26,018(4,676)$ 2030003,18003,1800.591,86823,210$ 2030001,57001,5700.59922$26,940(3,730)$ 2031003,50703,5070.572,00025,210$ 2031001,73101,7310.57987$27,927(2,717)$ 2032003,86903,8690.552,14227,352$ 2032001,91001,9100.551,057$28,985(1,632)$ 2033004,26704,2670.542,29429,646$ 2033002,10602,1060.541,132$30,117(471)$ 2034004,70704,7070.522,45632,103$ 2034002,32302,3230.521,213$31,330773$ 2035005,19205,1920.512,63134,733$ 2035002,56302,5630.511,299$32,6282,105$ 2036005,72605,7260.492,81737,550$ 2036002,82702,8270.491,391$34,0193,531$ 2037006,31606,3160.483,01740,567$ 2037003,11803,1180.481,489$35,5085,059$ 2038006,96706,9670.463,23043,797$ 2038003,43903,4390.461,595$37,1026,695$ 2039007,68407,6840.453,45947,256$ 2039003,79303,7930.451,708$38,8108,446$ 2040008,47608,4760.443,70550,961$ 2040004,18404,1840.441,829$40,63910,322$ 2041009,34909,3490.423,96754,928$ 2041004,61504,6150.421,958$42,59712,331$ 20420010,312010,3120.414,24859,176$ 2042005,09005,0900.412,097$44,69414,482$ Totals:$0$0$108,357$0$108,357$59,176=30-year LCCTotals:$15,483$0$53,488$0$68,971$44,694=30-year LCC
Energy Audit Report
April 16, 2012
pg. 57
ECM #11 Calculations
Incoming Water Temperature 40
System 1 - Location Served:
Fuel Type AFUE Thermostat
Setpoint
Full Load KW
(Electric Only)
Mo/Yr Operation
(Electric Only)Cost
Existing Natural Gas 70.00%120.0 N/A
Proposed Natural Gas 95.00%120.0 $7,454.46
Domestic Water Heating Data
Gallons Hot
Water/yr
33,613
33,613
Description
of Retrofit
Replace existing tank water heater with on-demand water heater having an Energy
Factor of 0.5 or greater. This ECM assumes water heater will need replaced in the next
Existing Proposed
$0.00 $0.00
N/A $84.37
320.00 235.79
Average Cost Per Therm of Heating Fuels;
proportional
Average Thermostat Setpoint; proportional
Estimated Cost over 1 year $320.62
Estimated Cost of Replacements $7,454.46
120
Estimated Demand Charges (electric)
70.00%95.00%
$1.00 $1.00
120
Estimated Yearly Savings
Domestic Water Heating System Summary
Average AFUE of Domestic Hot Water
Systems; proportional
$236.25
Therms required for Domestic Hot Water
over 1 year
Energy Audit Report
April 16, 2012
pg. 58
---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$263321$ $0$584(1+i)^-nCostsCosts2,012$7,454$75236$ $0$311(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$7,454------$7,4541.00$7,454$7,4542,01327132505960.97579578.63$ 2,01307723903160.97307$7,761(7,183)$ 2,014027932906080.945731,152$ 2,01407924203220.97312$8,073(6,921)$ 2,015028833306210.925681,720$ 2,01508124603270.97318$8,391(6,671)$ 2,016029633806340.895632,284$ 2,01608424903330.97323$8,714(6,430)$ 2,017030536006650.865732,857$ 2,01708626503510.97341$9,055(6,198)$ 2,018031438306970.845843,441$ 2,01808928203710.97360$9,415(5,974)$ 2,019032440807320.815954,036$ 2,01909230103920.97381$9,796(5,760)$ 2,020033443407680.796064,642$ 2,02009432004140.97402$10,199(5,556)$ 2,021034446308060.776185,260$ 2,02109734104380.97425$10,624(5,364)$ 2,022035449308460.746305,890$ 2,022010036304630.97450$11,074(5,184)$ 2,023036452508890.726426,532$ 2,023010338704900.97476$11,549(5,017)$ 2,024037555909340.706557,187$ 2,024010641205180.97503$12,052(4,865)$ 2,025038759509820.686697,856$ 2,025010943805480.97532$12,584(4,728)$ 2,026039863401,0320.666828,538$ 2,026011346705800.97563$13,147(4,609)$ 2,027041069901,1090.647129,250$ 2,027011651506310.97613$13,760(4,510)$ 2,028042377101,1940.627449,994$ 2,028012056806880.97668$14,427(4,434)$ 2,029043585001,2860.6177810,772$ 2,029012362707500.97728$15,155(4,384)$ 2,030044893801,3860.5981411,586$ 2,030012769108180.97794$15,950(4,364)$ 2,03104621,03501,4960.5785312,439$ 2,031013176208930.97867$16,817(4,377)$ 2,03204761,14101,6170.5589513,335$ 2,032013584109760.97947$17,764(4,429)$ 2,03304901,25901,7490.5494014,275$ 2,033013992801,0660.971,035$18,799(4,525)$ 2,03405051,38801,8930.5298815,262$ 2,03401431,02301,1660.971,132$19,931(4,669)$ 2,03505201,53102,0510.511,03916,302$ 2,03501471,12801,2760.971,238$21,169(4,868)$ 2,03605351,68902,2240.491,09417,396$ 2,03601521,24501,3960.971,356$22,525(5,129)$ 2,03705511,86302,4140.481,15318,549$ 2,03701561,37301,5290.971,484$24,009(5,460)$ 2,03805682,05502,6230.461,21619,765$ 2,03801611,51401,6750.971,626$25,636(5,870)$ 2,03905852,26702,8520.451,28421,049$ 2,03901661,67001,8360.971,782$27,418(6,369)$ 2,04006022,50003,1030.441,35622,405$ 2,04001711,84202,0130.971,954$29,372(6,967)$ 2,04106202,75803,3780.421,43423,839$ 2,04101762,03202,2080.972,143$31,516(7,677)$ 2,04206393,04203,6810.411,51625,355$ 2,04201812,24102,4220.972,352$33,867(8,512)$ Totals:$0$12,902$31,964$0$44,866$25,355=30-year LCCTotals:$7,454$3,653$23,552$0$34,660$33,867=30-year LCC
Energy Audit Report
April 16, 2012
pg. 59
ECM #12 Calculations
Component Framed
Section
Insulated
Section Component Framed
Section
Insulated
Section
Air Film 0.17 0.17 Air Film 0.17 0.17
Concrete Block 1.11 1.11 Concrete Block 1.11 1.11
2.5" EPS 10 2.5" EPS 10
2X3 studs, 24" o.c.3.125 2X3 studs, 24" o.c.3.125
Wall Covering 0.45 0.45 Wall Covering 0.45 0.45
Air Film 0.61 0.61 Air Film 0.61 0.61
1" Foil Face Insulation on Exterior Of Wall 0 7.2
Siding 0.5 0.5
Total R-Values 5.465 12.34 Total R-Values 5.965 20.04
Total U-Values 0.1830 0.0810 Total U-Values 0.1676 0.0499
Percentage of Framing 10.00%90.00%Percentage of Framing 10.00%90.00%
Composite U-Value of Assembly 0.0912 Composite U-Value of Assembly 0.0617
Window U-value Window U-value
Wall Square Footage 5700 Wall Square Footage 5700
Window Square Footage Window Square Footage
Door Square Footage Door Square Footage
Door U Value Door U-Value
Opaque Wall Area 5700 Opaque Wall Area 5700
Composite U-value for entire assembly 0.0912 Composite U-value for entire assembly 0.0617
Composite R-Value for entire assembly 10.9611 Composite R-Value for entire assembly 16.2141
Heating System Served System 1 Heating System Served System 1
Heat Loss in BTU/h 18200.75 Heat Loss in BTU/h 12304.09Original
Heating
Proposed
Heating
Savings -
Original Heating
Savings -
Proposed Yearly Cost $1,996.86 Yearly Cost $1,349.92 $1,148.87 $646.94 $471.93
Cost of Proposed Upgrade $80,587.00
Above Grade Wall - Original Above Grade Wall - Proposed
Assembly 3 Assembly 3
Energy Audit Report
April 16, 2012
pg. 60
---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2012$01,997$ $0$1,997(1+i)^-nCostsCosts2012$80,587$01,350$ $0$1,350(1+i)^-nCostsCosts2012$0------$01.00$0-$ 2012$80,587------$80,5871.00$80,587$80,587201302,02302,0230.971,964########2013001,36701,3670.971,328$81,915(79,951)$ 2014002,04902,0490.941,9313,895$ 2014001,38501,3850.941,306$83,220(79,325)$ 2015002,07602,0760.921,9005,795$ 2015001,40301,4030.921,284$84,505(78,710)$ 2016002,10302,1030.891,8687,663$ 2016001,42101,4210.891,263$85,768(78,104)$ 2017002,23902,2390.861,9329,595$ 2017001,51401,5140.861,306$87,073(77,478)$ 2018002,38502,3850.841,99711,592$ 2018001,61201,6120.841,350$88,424(76,831)$ 2019002,54002,5400.812,06513,658$ 2019001,71701,7170.811,396$89,820(76,162)$ 2020002,70502,7050.792,13515,793$ 2020001,82901,8290.791,444$91,263(75,470)$ 2021002,88102,8810.772,20818,001$ 2021001,94801,9480.771,493$92,756(74,755)$ 2022003,06803,0680.742,28320,284$ 2022002,07402,0740.741,543$94,299(74,015)$ 2023003,26803,2680.722,36122,645$ 2023002,20902,2090.721,596$95,895(73,251)$ 2024003,48003,4800.702,44125,086$ 2024002,35302,3530.701,650$97,545(72,460)$ 2025003,70603,7060.682,52427,609$ 2025002,50502,5050.681,706$99,251(71,642)$ 2026003,94703,9470.662,61030,219$ 2026002,66802,6680.661,764$101,016(70,797)$ 2027004,35404,3540.642,79433,013$ 2027002,94302,9430.641,889$102,905(69,891)$ 2028004,80204,8020.622,99336,006$ 2028003,24603,2460.622,023$104,928(68,922)$ 2029005,29705,2970.613,20539,210$ 2029003,58103,5810.612,166$107,094(67,884)$ 2030005,84205,8420.593,43242,642$ 2030003,95003,9500.592,320$109,414(66,772)$ 2031006,44406,4440.573,67546,317$ 2031004,35604,3560.572,484$111,898(65,581)$ 2032007,10807,1080.553,93550,252$ 2032004,80504,8050.552,660$114,559(64,306)$ 2033007,84007,8400.544,21454,467$ 2033005,30005,3000.542,849$117,408(62,941)$ 2034008,64708,6470.524,51358,980$ 2034005,84605,8460.523,051$120,459(61,479)$ 2035009,53809,5380.514,83363,813$ 2035006,44806,4480.513,267$123,726(59,913)$ 20360010,521010,5210.495,17568,988$ 2036007,11207,1120.493,499$127,224(58,236)$ 20370011,604011,6040.485,54274,530$ 2037007,84507,8450.483,747$130,971(56,441)$ 20380012,799012,7990.465,93580,465$ 2038008,65308,6530.464,012$134,983(54,518)$ 20390014,118014,1180.456,35686,821$ 2039009,54409,5440.454,297$139,280(52,459)$ 20400015,572015,5720.446,80693,627$ 20400010,527010,5270.444,601$143,881(50,254)$ 20410017,176017,1760.427,288100,915$ 20410011,611011,6110.424,927$148,808(47,893)$ 20420018,945018,9450.417,805108,720$ 20420012,807012,8070.415,276$154,084(45,364)$ Totals:$0$0$199,076$0$199,076$108,720=30-year LCCTotals:$80,587$0$134,580$0$215,167$154,084=30-year LCC
Energy Audit Report
April 16, 2012
pg. 61
Cost Data
Energy Audit Report
April 16, 2012
pg. 62
Energy Audit Report
April 16, 2012
pg. 63