The URL can be used to link to this page

Home My WebLink AboutCAC-KEB-CAEC Nanwalek English Bay School 2012-EEFINAL ENERGY AUDIT Nanwalek School Alexandrovsky Street Nanwalek, AK 99603 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 23 Benchmark Information 24 Supporting Documentation 30 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 Nanwalek School 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 $26,990.52 Propane $20,610.96 Total $47,601.48 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 14,832 square foot school. 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 Highlighted measures are overlapping and cannot be combined. ECM #Improvement Description Installed Cost Annualized NPV Savings NPV Savings Over Improvement Life Breakeven Cost SIR Simple Payback (Years) ROI 1 Replace existing incandescent lamps with 18w compact fluorescent lamps.$114 $103 $1,648 $1,762 14.5 2 1452% 2 Replace existing T12 fixture in Room 309 with T8 fixture and 25w lamp.$261 $32 $519 $780 2.0 6 199% 3 Replace existing T8 lamps with 25w lamps throughout.$9,828 $1,177 $18,825 $28,653 1.9 6 192% 4 Add 6 inches blown cellulose to attic space.$19,814 $939 $18,781 $38,595 0.9 13 95% 5 Replace single pane & single pane w. storm wood windows with windows having a U value of 0.3 or less. $751 $24 $488 $1,239 0.6 15 65% 6 Replace existing metal halide fixtures in shop and gym with T5 Hi Bay fixtures with six 54w lamps. $14,617 $234 $3,744 $18,361 0.3 13 26% 7 Replace (3) UMS 65-80 circulation pumps with equivalent variable speed, permanent magnet motors. $12,274 $172 $2,582 $14,856 0.2 13 21% 8 Replace existing propane boilers with (2) oil fired boilers $144,429 $1,517 $30,333 $174,762 0.2 18 21% 9 Replace existing propane boilers with (2) 95% AFUE propane boilers.$62,028 $507 $10,149 $72,177 0.2 19 16% Total, Cost Effective Measures $264,116 $4,706 $87,069 $351,185 0.3 33% 10 Replace motor serving gym air handler (HV- 1) with motor having an efficiency of 86.5% or greater. $2,381 ($4)($66)$2,315 0.0 16 -3% 11 Add 4" EPS foam to below grade wall.$32,449 ($468)($9,355)$23,094 -0.3 25 -29% 12 Replace double pane wood windows w/o Argon gas with windows having a U value of 0.3 or less. $2,195 ($41)($814)$1,381 -0.4 26 -37% Total, All Measures $301,141 $4,193 $76,834 $377,975 0.3 26% 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 Nanwalek School was originally built in 1977 with additions and alternations in 1984. This building was originally heated by two oil fired boilers which were replaced with propane boilers when fuel leaks became an issue. This is unfortunate from an energy standpoint since oil carries about 40% more BTUs per gallon. Replacement of the existing boilers with both high efficiency propane and oil fired boilers has been listed as separate ECMs. The current propane boilers serve the heating and the majority of the domestic hot water load for the building. Auxiliary domestic hot water for the kitchen is provided by an electric tank water heater. Interior lighting is provided by T8 fluorescent fixtures and metal halide lights. Exterior lighting is provided by high pressure sodium lighting. The school currently serves nearly 70 students and also serves as a community center for the town. Because of the remoteness of the location of this building an additional cost factor has been added to the projected costs, based on the Alaska Department of Education and Early Development Geographic Area Cost Factor. This building has an electrical demand meter and demand KW usage was noted in the benchmark information provided. However, no demand cost was provided with the benchmark information. If this building is in fact being assessed a KW demand charge that will increase the savings of the electrical improvements. This report can be re-figured with new paybacks if a demand charge rate is available. 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. Energy Audit Report April 16, 2012 pg. 11 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 1 Replace existing incandescent lamps with 18w compact fluorescent lamps.$114 $103 $1,648 $1,762 14.5 2 1452% Energy Audit Report April 16, 2012 pg. 12 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 2 Replace existing T12 fixture in Room 309 with T8 fixture and 25w lamp.$261 $32 $519 $780 2.0 6 199% Energy Audit Report April 16, 2012 pg. 13 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 existing T8 lamps with 25w lamps throughout.$9,828 $1,177 $18,825 $28,653 1.9 6 192% Energy Audit Report April 16, 2012 pg. 14 This ECM assumes a life expectancy of 20 years for this measure. Before insulating, seal all air leakage points into the attic, and maintain proper ventilation after additional insulation is installed. Access to all attic areas during the field audit was not possible; verify insulation levels to ensure payback before proceeding with this ECM. ECM #Improvement Description Installed Cost Annualized NPV Savings NPV Savings Over Improvement Life Breakeven Cost SIR Simple Payback (Years) ROI 4 Add 6 inches blown cellulose to attic space.$19,814 $939 $18,781 $38,595 0.9 13 95% Energy Audit Report April 16, 2012 pg. 15 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 single pane & single pane w. storm wood windows with windows having a U value of 0.3 or less. $751 $24 $488 $1,239 0.6 15 65% Energy Audit Report April 16, 2012 pg. 16 This ECM assumes a life expectancy of 16 years for this measure. It is recommended that fixtures capable of multi-level switching be installed which would provide more uniform light coverage at lower wattage levels. A typical 6 lamp T5 replacement fixture could be controlled to provide 2, 4, or 6 lamps on at a time depending on need. This will increase energy savings significantly over this estimate. ECM #Improvement Description Installed Cost Annualized NPV Savings NPV Savings Over Improvement Life Breakeven Cost SIR Simple Payback (Years) ROI 6 Replace existing metal halide fixtures in shop and gym with T5 Hi Bay fixtures with six 54w lamps. $14,617 $234 $3,744 $18,361 0.3 13 26% Energy Audit Report April 16, 2012 pg. 17 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) ROI 7 Replace (3) UMS 65-80 circulation pumps with equivalent variable speed, permanent magnet motors. $12,274 $172 $2,582 $14,856 0.2 13 21% Energy Audit Report April 16, 2012 pg. 18 This ECM assumes a life expectancy of 20 years for this measure. This measure overlaps with ECM #9. ECM #Improvement Description Installed Cost Annualized NPV Savings NPV Savings Over Improvement Life Breakeven Cost SIR Simple Payback (Years) ROI 8 Replace existing propane boilers with (2) oil fired boilers $144,429 $1,517 $30,333 $174,762 0.2 18 21% Energy Audit Report April 16, 2012 pg. 19 This ECM assumes a life expectancy of 20 years for this measure. This measure overlaps with ECM #8. ECM #Improvement Description Installed Cost Annualized NPV Savings NPV Savings Over Improvement Life Breakeven Cost SIR Simple Payback (Years) ROI 9 Replace existing propane boilers with (2) 95% AFUE propane boilers.$62,028 $507 $10,149 $72,177 0.2 19 16% Energy Audit Report April 16, 2012 pg. 20 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) ROI 10 Replace motor serving gym air handler (HV- 1) with motor having an efficiency of 86.5% or greater. $2,381 ($4)($66)$2,315 0.0 16 -3% Energy Audit Report April 16, 2012 pg. 21 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 11 Add 4" EPS foam to below grade wall.$32,449 ($468)($9,355)$23,094 -0.3 25 -29% Energy Audit Report April 16, 2012 pg. 22 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 12 Replace double pane wood windows w/o Argon gas with windows having a U value of 0.3 or less. $2,195 ($41)($814)$1,381 -0.4 26 -37% 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. Air Handlers – Filters and coils should be cleaned/replaced periodically to ensure proper airflow. Dirty filter/coils decrease heat transfer ability and efficiency of the system. Belts should be checked regularly and tightened when necessary. Controls – The building operational systems are currently controlled by a central control system. Controls on a building of this type can be one of the largest savers or wasters of energy, depending on how the controls are setup and maintained. Annual calibration, maintenance and updates are essential to a properly performing system that saves money. 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 17% more the national average of similar buildings. This is reasonably good considering the climate the building is located in. Energy Audit Report April 16, 2012 pg. 25 Electrical usage in terms of BTU per square foot is 13% higher than the national average. The high cost per KWH of electricity makes pursuing reductions in electrical usage worthwhile. Energy Audit Report April 16, 2012 pg. 26 The total energy use profile shows the majority of BTUs consumed by the building are from propane which is used exclusively for heating. Electrical usage is second. Energy Audit Report April 16, 2012 pg. 27 The energy cost total shows that electricity is the majority fuel cost even though more BTUs of propane are consumed. Energy Audit Report April 16, 2012 pg. 28 Electrical consumption increased slightly over the benchmark period. This building also has a significant base load in the summer. Energy Audit Report April 16, 2012 pg. 29 Propane usage is uneven due to the fact that only one delivery occurred during the benchmark period. Energy Audit Report April 16, 2012 pg. 30 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 Boiler 1 Utility Room Heating Weil McLain EGH 115 PI Gas 500,000 BTU/h 82%In series 20 10 Boiler 2 Utility Room Heating Weil McLain EGH 115 PI Gas 500,000 BTU/h 82%In series 20 10 DHW Kitchen Domestic Hot Water American E61-30H- 045D Electric 4.5 KW 99%15 12 Room 302 AHU 302 Heat/Ventilation Trane TUVAO7V H2AS11S N14G12 Fan Coil 0.16 20 0 Room 102 CUH 102 Heat/Ventilation Tane UHSA018 58 AAAA Fan Coil 0.4 20 0 Room 312 CUH 312 Heat/Ventilation Nesbitt N/A Fan Coil 0.2 20 0 Room 304 CUH 304 Heat/Ventilation Trane B15A004 Fan Coil 0.03 20 0 Room 305 CUH 305 Heat/Ventilation Trane B15A005 Fan Coil 0.03 20 0 HV1 Utility Room Gym Heat/Ventilation Trane TV08AGO DOARRO 2 Fan Coil 2 HV3 Utility Room Office Heat/Ventilation Trane TUDB03A GOD1ARR 02 Fan Coil 0.33 20 0 HV4 Utility Room Entrance/Hallway Heat/Ventilation Trane N/A Fan Coil 0.75 20 0 AHU 1 Shop Shop Heat/Ventilation Trane N/A Fan Coil N/A 20 0 Room 110 AHU Libraray Library Heat/Ventilation Pace SCF858M 1 Fan Coil 0.5 20 0 Laundry, Art Room, Science Room, 110 Ladies Restroom, Mens 110 Restroom Exhaust Exhaust Penn Zephyr Z-7 Fan 15 0 Ladies 300 Restroom, Mens 300 Restroom Exhaust Penn Zephyr Z-8 Fan 15 0 Energy Audit Report April 16, 2012 pg. 31 Benchmark Data Building Designation:Electric Meter # Square footage of conditioned area:14832 Gas Meter # Number of billing periods 24 Year: Month Days in Billing Period Electric KWH Electric Demand KW Electric Cost $/KWH Electric Cost Demand Cost Electric MMBtu Load Factor % of bill from demand Jul-08 31 10,520 32.80 $0.16 $1,684.00 35.90 0.43 0.0% Aug-08 28 8,240 26.80 $0.16 $1,336.00 28.12 0.46 0.0% Sep-08 32 8,400 30.00 $0.19 $1,622.00 28.67 0.36 0.0% Oct-08 30 21,680 34.44 $0.18 $3,814.00 73.99 0.87 0.0% Nov-08 32 15,040 30.00 $0.18 $2,702.00 51.33 0.65 0.0% Dec-08 29 12,600 32.80 $0.22 $2,818.00 43.00 0.55 0.0% Jan-09 31 13,840 31.60 $0.22 $3,059.00 47.24 0.59 0.0% Feb-09 31 11,360 29.28 $0.22 $2,542.00 38.77 0.52 0.0% Mar-09 32 11,480 29.40 $0.18 $2,114.00 39.18 0.51 0.0% Apr-09 27 12,520 27.88 $0.18 $2,272.00 42.73 0.69 0.0% May-09 33 11,800 38.80 $0.18 $2,162.00 40.27 0.38 0.0% Jun-09 29 6,440 27.36 $0.20 $1,294.00 21.98 0.34 0.0% Jul-09 26 9,504 28.00 $0.19 $1,832.00 32.44 0.54 0.0% Aug-09 28 10,240 25.64 $0.19 $1,954.00 34.95 0.59 0.0% Sep-09 33 9,763 30.00 $0.17 $1,665.00 33.32 0.41 0.0% Oct-09 27 21,401 34.96 $0.16 $3,404.00 73.04 0.94 0.0% Nov-09 33 15,346 44.00 $0.16 $2,503.00 52.38 0.44 0.0% Dec-09 27 14,299 46.60 $0.15 $2,139.00 48.80 0.47 0.0% Jan-10 32 14,005 46.60 $0.15 $2,090.00 47.80 0.39 0.0% Feb-10 25 12,640 40.08 $0.15 $1,862.00 43.14 0.53 0.0% Mar-10 37 11,407 43.32 $0.17 $1,996.00 38.93 0.30 0.0% Apr-10 26 18,874 40.48 $0.16 $3,073.00 64.42 0.75 0.0% May-10 33 18,353 41.92 $0.16 $3,001.00 62.64 0.55 0.0% Jun-10 28 5,189 38.28 $0.20 $1,043.00 17.71 0.20 0.0% #DIV/0!0.00 #DIV/0!#DIV/0! #DIV/0!0.00 #DIV/0!#DIV/0! #DIV/0!0.00 #DIV/0!#DIV/0! #DIV/0!0.00 #DIV/0!#DIV/0! #DIV/0!0.00 #DIV/0!#DIV/0! #DIV/0!0.00 #DIV/0!#DIV/0! #DIV/0!0.00 #DIV/0!#DIV/0! #DIV/0!0.00 #DIV/0!#DIV/0! #DIV/0!0.00 #DIV/0!#DIV/0! #DIV/0!0.00 #DIV/0!#DIV/0! #DIV/0!0.00 #DIV/0!#DIV/0! #DIV/0!0.00 #DIV/0!#DIV/0! Montly Average 30.00 12705.88 34.63 #DIV/0!$2,249.21 $0.00 43.37 #DIV/0!#DIV/0! Total 720 304,941 N/A N/A $53,981.00 $0.00 1,040.76 N/A N/A Monthly Benchmark Occupancy Education ....................38.376811 % Difference Size 10,001 to 100,000 Square Feet 113.00% Nanwalek School Energy Use Index Form 1 Electricity Energy Audit Report April 16, 2012 pg. 32 Propane Usage Gallons Propane Cost Propane Cost per Gallon Propane MMBtu HDD CCD Production Btu/Sq. Ft Cost $/Sq Ft 0.0 0.00 #DIV/0!0.00 2,421 $0.11 0.0 0.00 #DIV/0!0.00 1,896 $0.09 0.0 0.00 #DIV/0!0.00 1,933 $0.11 0.0 0.00 #DIV/0!0.00 4,989 $0.26 0.0 0.00 #DIV/0!0.00 3,461 $0.18 0.0 0.00 #DIV/0!0.00 2,899 $0.19 0.0 0.00 #DIV/0!0.00 3,185 $0.21 0.0 0.00 #DIV/0!0.00 1139 2,614 $0.17 0.0 0.00 #DIV/0!0.00 1179 2,642 $0.14 0.0 0.00 #DIV/0!0.00 881 2,881 $0.15 0.0 0.00 #DIV/0!0.00 631 2,715 $0.15 0.0 0.00 #DIV/0!0.00 481 1,482 $0.09 #DIV/0!0.00 334 2,187 $0.12 0.0 0.00 #DIV/0!0.00 372 2,356 $0.13 17,559.0 41,222.00 2.35 1,603.66 523 110,368 $2.89 0.0 0.00 #DIV/0!0.00 692 4,925 $0.23 0.0 0.00 #DIV/0!0.00 1084 3,531 $0.17 0.0 0.00 #DIV/0!0.00 1136 3,290 $0.14 0.0 0.00 #DIV/0!0.00 1131 3,223 $0.14 0.0 0.00 #DIV/0!0.00 955 2,909 $0.13 0.0 0.00 #DIV/0!0.00 1139 2,625 $0.13 0.0 0.00 #DIV/0!0.00 889 4,343 $0.21 0.0 0.00 #DIV/0!0.00 662 4,223 $0.20 0.0 0.00 #DIV/0!0.00 471 1,194 $0.07 0.0 0.00 #DIV/0!0.00 0 $0.00 #DIV/0!0.00 0 $0.00 #DIV/0!0.00 0 $0.00 #DIV/0!0.00 0 $0.00 #DIV/0!0.00 0 $0.00 #DIV/0!0.00 0 $0.00 #DIV/0!0.00 0 $0.00 #DIV/0!0.00 0 $0.00 #DIV/0!0.00 0 $0.00 #DIV/0!0.00 0 $0.00 #DIV/0!0.00 0 $0.00 #DIV/0!0.00 0 $0.00 731.63 1717.58 #DIV/0!66.82 380.53 0.00 0.00 7,429 $0.27 17559.00 41222.00 #DIV/0!1603.66 13699.00 0.00 0.00 178,292 $6.42 6,308 117.76% EUIPropane Energy Audit Report April 16, 2012 pg. 33 Climate & Fuel Assumptions Client Name:Nanwalek School Address: Square Footage 14832 Days Occupied per Year State HDD CDD Avg. Temp 365 Alaska 9,831 0 38.0 Fuels Natural Gas $0.00 $ Per CCF $0.00 Per Therm Oil $2.35 $ Per Gallon $1.68 Per Therm Electricity $0.18 $ per KWH $5.19 Per Therm Propane $2.35 $ per Gallon $2.57 Per Therm Wood $ Per Cord $0.00 Per Therm Coal $ Per Ton $0.00 Per Therm Electrical Demand Charge Kw/Month City Tutka Bay Lagoon Client Information Energy Audit Report April 16, 2012 pg. 34 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?0 Propane . . . . . . . . . . .. . . . . . . . . . .2005 - 2015 . . .1.3% Propane Fuel?1 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. 35 ECM #1 Calculations Space Description Number of Fixtures 5 5 Lamps per Fixture 1 1 Lamp Type Incandescent Compact Fluorescent Fixture Wattage 60 18 Hours on per Week 56 56 Cost of New Lamp $22.70 Cost of New Fixture Total KWH Cost $154.63 $46.39 Total Demand Cost $0.00 $0.00 Total Yearly Cost $154.63 $46.39 Yearly Savings $108.24 Total Retrofit Cost $113.50 Payback Period 1.0 years Retrofit Description Incandescent lamps - Restroom 302, Girls Gym Restroom, Coat Room, Coat Room Replace existing incandescent lamps wiith 18w compact fluorescent lamps. Energy Audit Report April 16, 2012 pg. 36 ---------------------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.PropaneElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.PropaneElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$3-$ $155$158(1+i)^-nCostsCosts2,012$114$1-$ $46$47(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$114------$1141.00$114$1142,0130301591620.97157157.27$ 2,01301048490.9747$161(3)$ 2,0140301631660.94157314$ 2,01401049500.9447$208106$ 2,0150301671710.92156470$ 2,01501050510.9247$255216$ 2,0160301721750.89156626$ 2,01601052530.8947$301325$ 2,0170401771810.86156782$ 2,01701053540.8647$348434$ 2,0180401831870.84156939$ 2,01801055560.8447$395544$ 2,0190401891920.811561,095$ 2,01901057580.8147$442653$ 2,0200401941980.791571,252$ 2,02001058590.7947$489763$ 2,0210402002040.771571,408$ 2,02101060610.7747$536872$ 2,0220402072110.741571,565$ 2,02201062630.7447$583982$ 2,0230402132170.721571,722$ 2,02301064650.7247$6301,092$ 2,0240402202240.701571,879$ 2,02401066670.7047$6771,202$ 2,0250502262310.681572,036$ 2,02501068690.6847$7241,312$ 2,0260502332380.661572,194$ 2,02601070710.6647$7721,422$ 2,0270502442490.641602,354$ 2,02701073750.6448$8201,534$ 2,0280502562610.621632,516$ 2,02801077780.6249$8681,648$ 2,0290502682730.611652,682$ 2,02902080820.6150$9181,764$ 2,0300502812860.591682,849$ 2,03002084860.5950$9681,881$ 2,0310502942990.571713,020$ 2,03102088900.5751$1,0192,000$ 2,0320603073130.551733,193$ 2,03202092940.5552$1,0712,122$ 2,0330603223280.541763,369$ 2,03302097980.5453$1,1242,245$ 2,0340603373430.521793,548$ 2,0340201011030.5254$1,1782,370$ 2,0350603533590.511823,730$ 2,0350201061080.5155$1,2332,498$ 2,0360603703760.491853,915$ 2,0360201111130.4955$1,2882,627$ 2,0370603873930.481884,103$ 2,0370201161180.4856$1,3442,759$ 2,0380704054120.461914,294$ 2,0380201221240.4657$1,4022,892$ 2,0390704244310.451944,488$ 2,0390201271290.4558$1,4603,028$ 2,0400704444510.441974,685$ 2,0400201331350.4459$1,5193,166$ 2,0410704654720.422004,886$ 2,0410201391420.4260$1,5793,306$ 2,0420804874940.412045,089$ 2,0420201461480.4161$1,6403,449$ Totals:$0$152$0$8,347$8,498$5,089=30-year LCCTotals:$114$45$0$2,504$2,663$1,640=30-year LCC Energy Audit Report April 16, 2012 pg. 37 ECM #2 Calculations Space Description Number of Fixtures 1 1 Lamps per Fixture 1 1 Lamp Type T12 T8 Fixture Wattage 55 24 Hours on per Week 168 168 Cost of New Lamp Cost of New Fixture $260.89 Total KWH Cost $85.04 $37.11 Total Demand Cost $0.00 $0.00 Total Yearly Cost $85.04 $37.11 Yearly Savings $47.93 Total Retrofit Cost $260.89 Payback Period 5.4 years Room 309 T12 Fixture Replace existing T12 fixtures in Room 309 with T8 fixtures and 25w lamp. Retrofit Description 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.PropaneElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.PropaneElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$2-$ $85$87(1+i)^-nCostsCosts2,012$261$1-$ $37$38(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$261------$2611.00$261$2612,01302087890.978686.50$ 2,01301038390.9738$299(212)$ 2,01402090920.9486173$ 2,01401039400.9438$336(164)$ 2,01502092940.9286259$ 2,01501040410.9238$374(115)$ 2,01602095970.8986345$ 2,01601041420.8937$411(67)$ 2,017020981000.8686430$ 2,01701043430.8637$449(18)$ 2,0180201011030.8486516$ 2,01801044450.8437$48630$ 2,0190201041060.8186602$ 2,01901045460.8138$52479$ 2,0200201071090.7986688$ 2,02001047480.7938$561127$ 2,0210201101120.7786775$ 2,02101048490.7738$599176$ 2,0220201141160.7486861$ 2,02201050510.7438$637224$ 2,0230201171200.7286947$ 2,02301051520.7238$674273$ 2,0240201211230.70861,034$ 2,02401053540.7038$712322$ 2,0250201251270.68861,120$ 2,02501054550.6838$750370$ 2,0260301281310.66871,207$ 2,02601056570.6638$787419$ 2,0270301341370.64881,295$ 2,02701059600.6438$826469$ 2,0280301411430.62891,384$ 2,02801061630.6239$865519$ 2,0290301471500.61911,475$ 2,02901064660.6140$904570$ 2,0300301541570.59921,567$ 2,03001067690.5940$945622$ 2,0310301621650.57941,661$ 2,03101070720.5741$986675$ 2,0320301691720.55951,756$ 2,03201074750.5542$1,027729$ 2,0330301771800.54971,853$ 2,03301077790.5442$1,070784$ 2,0340301851890.52981,952$ 2,03401081820.5243$1,113839$ 2,0350301941970.511002,052$ 2,03501085860.5144$1,156896$ 2,0360302032070.491022,153$ 2,03602089900.4944$1,201953$ 2,0370402132160.481032,257$ 2,03702093940.4845$1,2461,011$ 2,0380402232260.461052,362$ 2,03802097990.4646$1,2911,070$ 2,0390402332370.451072,468$ 2,0390201021030.4547$1,3381,130$ 2,0400402442480.441082,577$ 2,0400201071080.4447$1,3851,192$ 2,0410402562600.421102,687$ 2,0410201121130.4248$1,4331,254$ 2,0420402682720.411122,799$ 2,0420201171190.4149$1,4821,317$ Totals:$0$83$0$4,591$4,674$2,799=30-year LCCTotals:$261$36$0$2,003$2,301$1,482=30-year LCC Energy Audit Report April 16, 2012 pg. 39 ECM #3 Calculations Space Description Number of Fixtures 488 488 Lamps per Fixture 1 1 Lamp Type T8 T8 Fixture Wattage 32 25 Hours on per Week 56 56 Cost of New Lamp Cost of New Fixture $20.14 Total KWH Cost $8,048.86 $6,288.17 Total Demand Cost $0.00 $0.00 Total Yearly Cost $8,048.86 $6,288.17 Yearly Savings $1,760.69 Total Retrofit Cost $9,828.32 Payback Period 5.6 years T8 lamps throughout Retrofit Description Replace existing lamps in 4' T8 fixtures with 25w lamps. 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.PropaneElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.PropaneElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$161-$ $8,049$8,210(1+i)^-nCostsCosts2,012$9,828$126-$ $6,288$6,414(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$9,828------$9,8281.00$9,828$9,8282,013016608,2668,4320.978,1868,186.40$ 2,013013006,4586,5870.976,396$16,224(8,038)$ 2,014017108,4898,6600.948,16316,349$ 2,014013306,6326,7660.946,377$22,601(6,252)$ 2,015017608,7198,8940.928,14024,489$ 2,015013706,8116,9490.926,359$28,960(4,471)$ 2,016018108,9549,1350.898,11632,606$ 2,016014206,9957,1370.896,341$35,301(2,696)$ 2,017018709,2329,4180.868,12440,730$ 2,017014607,2127,3580.866,347$41,648(919)$ 2,018019209,5189,7100.848,13248,862$ 2,018015007,4367,5860.846,353$48,002860$ 2,019019809,81310,0110.818,14057,001$ 2,019015507,6667,8210.816,359$54,3612,641$ 2,0200204010,11710,3210.798,14765,149$ 2,020015907,9048,0630.796,365$60,7264,423$ 2,0210210010,43110,6410.778,15573,304$ 2,021016408,1498,3130.776,371$67,0976,207$ 2,0220216010,75410,9700.748,16381,467$ 2,022016908,4028,5710.746,377$73,4747,993$ 2,0230223011,08711,3100.728,17189,638$ 2,023017408,6628,8360.726,383$79,8589,780$ 2,0240230011,43111,6610.708,17897,816$ 2,024017908,9309,1100.706,389$86,24711,569$ 2,0250236011,78512,0220.688,186106,002$ 2,025018509,2079,3920.686,396$92,64313,360$ 2,0260243012,15112,3940.668,194114,196$ 2,026019009,4939,6830.666,402$99,04415,152$ 2,0270251012,72212,9730.648,327122,523$ 2,027019609,93910,1350.646,505$105,54916,974$ 2,0280258013,32013,5780.628,461130,984$ 2,0280202010,40610,6080.626,610$112,16018,825$ 2,0290266013,94614,2120.618,598139,583$ 2,0290208010,89511,1030.616,718$118,87720,705$ 2,0300274014,60114,8750.598,738148,321$ 2,0300214011,40711,6210.596,826$125,70422,617$ 2,0310282015,28715,5700.578,879157,200$ 2,0310221011,94312,1640.576,937$132,64124,559$ 2,0320291016,00616,2970.559,023166,223$ 2,0320227012,50512,7320.557,049$139,69026,533$ 2,0330299016,75817,0580.549,169175,392$ 2,0330234013,09213,3260.547,164$146,85328,539$ 2,0340308017,54617,8540.529,318184,710$ 2,0340241013,70813,9490.527,280$154,13330,577$ 2,0350318018,37118,6880.519,469194,179$ 2,0350248014,35214,6000.517,398$161,53132,648$ 2,0360327019,23419,5610.499,623203,802$ 2,0360256015,02715,2820.497,518$169,04934,753$ 2,0370337020,13820,4750.489,779213,581$ 2,0370263015,73315,9960.487,640$176,68936,893$ 2,0380347021,08421,4320.469,938223,519$ 2,0380271016,47216,7430.467,764$184,45339,066$ 2,0390358022,07522,4330.4510,099233,618$ 2,0390279017,24617,5260.457,890$192,34341,276$ 2,0400368023,11323,4810.4410,263243,881$ 2,0400288018,05718,3450.448,018$200,36143,521$ 2,0410379024,19924,5790.4210,430254,311$ 2,0410296018,90619,2020.428,148$208,50945,802$ 2,0420391025,33725,7270.4110,599264,911$ 2,0420305019,79420,1000.418,281$216,79048,121$ Totals:$0$7,888$0$434,484$442,372$264,911=30-year LCCTotals:$9,828$6,163$0$339,441$355,432$216,790=30-year LCC Energy Audit Report April 16, 2012 pg. 41 ECM #4 Calculations Component Framed Section Insulated Section Component Framed Section Insulated Section air film 0.61 0.61 air film 0.61 0.61 R-38 insulation 0 38 R-38 insulation 0 38 trusses 6.25 0 trusses 6.25 0 drywall 0.56 0.56 drywall 0.56 0.56 air film 0.17 0.17 air film 0.17 0.17 6" cellulose blown over top 19 19 Total R-Values 7.59 39.34 Total R-Values 26.59 58.34 Total U-Values 0.1318 0.0254 Total U-Values 0.0376 0.0171 Percentage of Framing 10.00%90.00%Percentage of Framing 10.00%90.00% Composite U-Value of Assembly 0.0361 Composite U-Value of Assembly 0.0192 Skylight U-value Skylight U-value Ceiling Square Footage 10338 Ceiling Square Footage 10338 Skylight Square Footage Skylight Square Footage Opaque Ceiling Area 10338 Opaque Ceiling Area 10338 Composite U-value for entire assembly 0.0361 Composite U-value for entire assembly 0.0192 Composite R-Value for entire assembly 27.7372 Composite R-Value for entire assembly 52.1169 Heating System Served System 1 Heating System Served System 1 Heat Loss in BTU/h 11926.81 Heat Loss in BTU/h 6347.57 Original Heating System Proposed Heating System Savings - Original Heating System Savings - Proposed Heating System Yearly Cost $3,278.45 Yearly Cost $1,744.83 $1,506.06 $1,533.63 $1,323.76 Cost of Proposed Upgrade $19,813.60 Assembly 1 Assembly 1 Ceiling - ProposedCeiling - Original 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.PropaneElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.PropaneElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2012$03,278$ $0$3,278(1+i)^-nCostsCosts2012$19,814$01,745$ $0$1,745(1+i)^-nCostsCosts2012$0------$01.00$0-$ 2012$19,814------$19,8141.00$19,814$19,814201303,32103,3210.973,224########2013001,76801,7680.971,716$21,530(18,305)$ 2014003,36403,3640.943,1716,395$ 2014001,79001,7900.941,688$23,217(16,822)$ 2015003,40803,4080.923,1199,514$ 2015001,81401,8140.921,660$24,877(15,363)$ 2016003,45203,4520.893,06712,582$ 2016001,83701,8370.891,632$26,510(13,928)$ 2017003,67703,6770.863,17215,753$ 2017001,95701,9570.861,688$28,198(12,444)$ 2018003,91603,9160.843,27919,032$ 2018002,08402,0840.841,745$29,943(10,910)$ 2019004,17004,1700.813,39122,423$ 2019002,21902,2190.811,805$31,747(9,324)$ 2020004,44104,4410.793,50625,929$ 2020002,36402,3640.791,866$33,613(7,684)$ 2021004,73004,7300.773,62529,554$ 2021002,51702,5170.771,929$35,543(5,988)$ 2022005,03705,0370.743,74833,303$ 2022002,68102,6810.741,995$37,538(4,235)$ 2023005,36505,3650.723,87637,178$ 2023002,85502,8550.722,063$39,600(2,422)$ 2024005,71405,7140.704,00741,186$ 2024003,04103,0410.702,133$41,733(547)$ 2025006,08506,0850.684,14445,329$ 2025003,23803,2380.682,205$43,9381,391$ 2026006,48006,4800.664,28449,613$ 2026003,44903,4490.662,280$46,2183,395$ 2027007,14807,1480.644,58854,201$ 2027003,80403,8040.642,442$48,6605,541$ 2028007,88407,8840.624,91359,114$ 2028004,19604,1960.622,615$51,2757,840$ 2029008,69608,6960.615,26164,376$ 2029004,62804,6280.612,800$54,07510,301$ 2030009,59209,5920.595,63470,010$ 2030005,10505,1050.592,999$57,07412,936$ 20310010,580010,5800.576,03476,044$ 2031005,63105,6310.573,211$60,28515,759$ 20320011,670011,6700.556,46182,505$ 2032006,21106,2110.553,439$63,72318,781$ 20330012,872012,8720.546,91989,424$ 2033006,85006,8500.543,682$67,40622,018$ 20340014,197014,1970.527,40996,833$ 2034007,55607,5560.523,943$71,34925,484$ 20350015,660015,6600.517,935104,768$ 2035008,33408,3340.514,223$75,57229,196$ 20360017,273017,2730.498,497113,265$ 2036009,19309,1930.494,522$80,09433,171$ 20370019,052019,0520.489,099122,364$ 20370010,140010,1400.484,843$84,93737,427$ 20380021,014021,0140.469,744132,108$ 20380011,184011,1840.465,186$90,12341,985$ 20390023,178023,1780.4510,435142,543$ 20390012,336012,3360.455,553$95,67646,867$ 20400025,566025,5660.4411,174153,717$ 20400013,606013,6060.445,947$101,62352,094$ 20410028,199028,1990.4211,966165,683$ 20410015,008015,0080.426,369$107,99257,691$ 20420031,104031,1040.4112,814178,498$ 20420016,554016,5540.416,820$114,81263,686$ Totals:$0$0$326,844$0$326,844$178,498=30-year LCCTotals:$19,814$0$173,950$0$193,763$114,812=30-year LCC Energy Audit Report April 16, 2012 pg. 43 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 0.7 Window U-value 0.3 Wall Square Footage Wall Square Footage Window Square Footage 14 Window Square Footage 14 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.7000 Composite U-value for entire assembly 0.3000 Composite R-Value for entire assembly 1.4286 Composite R-Value for entire assembly 3.3333 Heating System Served System 1 Heating System Served System 1 Heat Loss in BTU/h 313.60 Heat Loss in BTU/h 134.40Original Heating Proposed Heating Savings - Original Heating Savings - Proposed Yearly Cost $86.20 7871.8 Yearly Cost $36.94 $31.89 $49.26 $42.52 Cost of Proposed Upgrade $751.43 Above Grade Wall - Original Assembly 1 Assembly 1 Above Grade Wall - Proposed 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.PropaneElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.PropaneElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2012$086$ $0$86(1+i)^-nCostsCosts2012$751$037$ $0$37(1+i)^-nCostsCosts2012$0------$01.00$0-$ 2012$751------$7511.00$751$75120130870870.978584.78$ 201300370370.9736$788(703)$ 201400880880.9483168$ 201400380380.9436$823(655)$ 201500900900.9282250$ 201500380380.9235$859(608)$ 201600910910.8981331$ 201600390390.8935$893(562)$ 201700970970.8683414$ 201700410410.8636$929(515)$ 20180010301030.8486500$ 201800440440.8437$966(465)$ 20190011001100.8189590$ 201900470470.8138$1,004(415)$ 20200011701170.7992682$ 202000500500.7940$1,044(362)$ 20210012401240.7795777$ 202100530530.7741$1,084(307)$ 20220013201320.7499876$ 202200570570.7442$1,127(251)$ 20230014101410.72102978$ 202300600600.7244$1,170(193)$ 20240015001500.701051,083$ 202400640640.7045$1,216(133)$ 20250016001600.681091,192$ 202500690690.6847$1,262(70)$ 20260017001700.661131,305$ 202600730730.6648$1,311(6)$ 20270018801880.641211,425$ 202700810810.6452$1,36263$ 20280020702070.621291,554$ 202800890890.6255$1,418137$ 20290022902290.611381,693$ 202900980980.6159$1,477216$ 20300025202520.591481,841$ 20300010801080.5963$1,540300$ 20310027802780.571591,999$ 20310011901190.5768$1,608391$ 20320030703070.551702,169$ 20320013201320.5573$1,681488$ 20330033803380.541822,351$ 20330014501450.5478$1,759592$ 20340037303730.521952,546$ 20340016001600.5283$1,843703$ 20350041204120.512092,755$ 20350017601760.5189$1,932823$ 20360045404540.492232,978$ 20360019501950.4996$2,028950$ 20370050105010.482393,217$ 20370021502150.48103$2,1301,087$ 20380055305530.462563,474$ 20380023702370.46110$2,2401,233$ 20390060906090.452743,748$ 20390026102610.45118$2,3581,390$ 20400067206720.442944,042$ 20400028802880.44126$2,4841,558$ 20410074107410.423154,356$ 20410031803180.42135$2,6181,738$ 20420081808180.413374,693$ 20420035003500.41144$2,7631,930$ Totals:$0$0$8,594$0$8,594$4,693=30-year LCCTotals:$751$0$3,683$0$4,435$2,763=30-year LCC Energy Audit Report April 16, 2012 pg. 45 ECM #6 Calculations Space Description Number of Fixtures 22 22 Lamps per Fixture 1 1 Lamp Type MH T5 Fixture Wattage 446.2 346.7 Hours on per Week 56 56 Cost of New Lamp Cost of New Fixture $664.40 Total KWH Cost $5,059.61 $3,931.35 Total Demand Cost $0.00 $0.00 Total Yearly Cost $5,059.61 $3,931.35 Yearly Savings $1,128.26 Total Retrofit Cost $14,616.80 Payback Period 13.0 years Gym/Shop metal halide Retrofit Description Replace existing metal halide fixtures in shop and gym with T5 Hi Bay fixtrues with six 54w lamps. 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.PropaneElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.PropaneElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$101-$ $5,060$5,161(1+i)^-nCostsCosts2,012$14,617$79-$ $3,931$4,010(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$14,617------$14,6171.00$14,617$14,6172,013010405,1965,3000.975,1465,146.06$ 2,01308104,0374,1180.973,999$18,615(13,469)$ 2,014010705,3375,4440.945,13110,277$ 2,01408304,1474,2300.943,987$22,602(12,325)$ 2,015011105,4815,5910.925,11715,394$ 2,01508604,2584,3440.923,976$26,578(11,184)$ 2,016011405,6295,7420.895,10220,496$ 2,01608804,3734,4620.893,964$30,543(10,046)$ 2,017011705,8035,9200.865,10725,603$ 2,01709104,5094,6000.863,968$34,511(8,907)$ 2,018012105,9836,1040.845,11230,715$ 2,01809404,6494,7430.843,972$38,483(7,768)$ 2,019012406,1686,2930.815,11735,832$ 2,01909704,7934,8900.813,976$42,458(6,627)$ 2,020012806,3606,4880.795,12240,953$ 2,020010004,9415,0410.793,979$46,438(5,484)$ 2,021013206,5576,6890.775,12646,080$ 2,021010305,0955,1970.773,983$50,421(4,341)$ 2,022013606,7606,8960.745,13151,211$ 2,022010605,2535,3580.743,987$54,408(3,197)$ 2,023014006,9707,1100.725,13656,347$ 2,023010905,4155,5240.723,991$58,399(2,052)$ 2,024014407,1867,3300.705,14161,488$ 2,024011205,5835,6950.703,995$62,394(905)$ 2,025014907,4087,5570.685,14666,634$ 2,025011505,7565,8720.683,998$66,392242$ 2,026015307,6387,7910.665,15171,785$ 2,026011905,9356,0540.664,002$70,3941,391$ 2,027015807,9978,1550.645,23477,019$ 2,027012206,2146,3360.644,067$74,4612,558$ 2,028016208,3738,5350.625,31982,338$ 2,028012606,5066,6320.624,133$78,5943,744$ 2,029016708,7668,9340.615,40587,743$ 2,029013006,8126,9420.614,200$82,7944,949$ 2,030017209,1799,3510.595,49393,236$ 2,030013407,1327,2660.594,268$87,0626,174$ 2,031017709,6109,7870.575,58298,818$ 2,031013807,4677,6050.574,337$91,3997,419$ 2,0320183010,06210,2440.555,672104,490$ 2,032014207,8187,9600.554,407$95,8068,684$ 2,0330188010,53410,7230.545,764110,254$ 2,033014608,1858,3320.544,479$100,2849,969$ 2,0340194011,03011,2230.525,857116,111$ 2,034015108,5708,7210.524,551$104,83611,275$ 2,0350200011,54811,7480.515,952122,063$ 2,035015508,9739,1280.514,625$109,46112,603$ 2,0360206012,09112,2960.496,049128,113$ 2,036016009,3959,5540.494,700$114,16113,952$ 2,0370212012,65912,8710.486,147134,260$ 2,037016509,83610,0010.484,776$118,93715,322$ 2,0380218013,25413,4720.466,247140,507$ 2,0380170010,29810,4680.464,854$123,79116,715$ 2,0390225013,87714,1020.456,348146,855$ 2,0390175010,78210,9570.454,933$128,72418,131$ 2,0400232014,52914,7610.446,452153,307$ 2,0400180011,28911,4690.445,013$133,73719,570$ 2,0410238015,21215,4500.426,556159,863$ 2,0410185011,82012,0050.425,094$138,83121,032$ 2,0420246015,92716,1730.416,663166,526$ 2,0420191012,37512,5660.415,177$144,00822,517$ Totals:$0$4,959$0$273,122$278,080$166,526=30-year LCCTotals:$14,617$3,853$0$212,217$230,687$144,008=30-year LCC Energy Audit Report April 16, 2012 pg. 47 ECM #7 Calculations Horsepower Motor Loading Efficiency KW Operating Hours/yr Yearly KW Demand Yearly KW Demand Cost Yearly KWH Consumption Yearly KWH Cost Totals Existing 2.25 80 80 1.68 8760 20.14 $0.00 14,704 $2,602.55 $2,602.55 Proposed 2.25 50 80 1.05 8760 12.59 $0.00 9,190 $1,626.59 $1,626.59 Savings 7.55 $0.00 5,514 $975.96 $975.96 Installed Cost $12,274.00 Payback (years)12.58 Description of Improvement Motor #1 Replace (3) UMS 65-80 circulation pumps with equivalent variable speed, permanent magnet motors. 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.PropaneElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.PropaneElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$52-$ $2,603$2,655(1+i)^-nCostsCosts2,012$12,274$33-$ $1,627$1,659(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$12,274------$12,2741.00$12,274$12,2742,01305402,6732,7260.972,6472,647.02$ 2,01303401,6711,7040.971,654$13,928(11,281)$ 2,01405502,7452,8000.942,6395,286$ 2,01403501,7161,7500.941,650$15,578(10,292)$ 2,01505702,8192,8760.922,6327,918$ 2,01503601,7621,7970.921,645$17,223(9,305)$ 2,01605902,8952,9540.892,62410,543$ 2,01603701,8101,8460.891,640$18,863(8,320)$ 2,01706002,9853,0450.862,62713,170$ 2,01703801,8661,9030.861,642$20,505(7,335)$ 2,01806203,0773,1400.842,62915,799$ 2,01803901,9231,9620.841,643$22,148(6,349)$ 2,01906403,1733,2370.812,63218,431$ 2,01904001,9832,0230.811,645$23,793(5,362)$ 2,02006603,2713,3370.792,63421,065$ 2,02004102,0452,0860.791,647$25,440(4,374)$ 2,02106803,3733,4410.772,63723,702$ 2,02104202,1082,1500.771,648$27,088(3,386)$ 2,02207003,4773,5470.742,63926,342$ 2,02204402,1732,2170.741,650$28,738(2,396)$ 2,02307203,5853,6570.722,64228,984$ 2,02304502,2412,2860.721,651$30,389(1,405)$ 2,02407403,6963,7700.702,64431,628$ 2,02404602,3102,3560.701,653$32,042(413)$ 2,02507603,8113,8870.682,64734,275$ 2,02504802,3822,4290.681,654$33,696579$ 2,02607903,9294,0080.662,64936,925$ 2,02604902,4562,5050.661,656$35,3521,573$ 2,02708104,1144,1950.642,69239,617$ 2,02705102,5712,6220.641,683$37,0352,582$ 2,02808404,3074,3900.622,73642,353$ 2,02805202,6922,7440.621,710$38,7453,608$ 2,02908604,5094,5950.612,78045,133$ 2,02905402,8182,8720.611,738$40,4824,651$ 2,03008904,7214,8100.592,82547,958$ 2,03005502,9513,0060.591,766$42,2485,710$ 2,03109104,9435,0340.572,87150,830$ 2,03105703,0893,1460.571,794$44,0426,787$ 2,03209405,1755,2690.552,91853,747$ 2,03205903,2353,2930.551,823$45,8667,881$ 2,03309705,4195,5160.542,96556,712$ 2,03306103,3873,4470.541,853$47,7198,993$ 2,034010005,6735,7730.523,01359,725$ 2,03406203,5463,6080.521,883$49,60210,123$ 2,035010305,9406,0430.513,06262,787$ 2,03506403,7133,7770.511,914$51,51611,271$ 2,036010606,2196,3250.493,11165,898$ 2,03606603,8873,9530.491,945$53,46012,438$ 2,037010906,5116,6200.483,16269,060$ 2,03706804,0704,1380.481,976$55,43713,624$ 2,038011206,8186,9300.463,21372,273$ 2,03807004,2614,3310.462,008$57,44514,829$ 2,039011607,1387,2540.453,26575,539$ 2,03907204,4614,5330.452,041$59,48616,053$ 2,040011907,4737,5930.443,31978,857$ 2,04007404,6714,7450.442,074$61,56017,298$ 2,041012307,8257,9470.423,37282,230$ 2,04107704,8904,9670.422,108$63,66818,562$ 2,042012608,1928,3190.413,42785,657$ 2,04207905,1205,1990.412,142$65,81019,847$ Totals:$0$2,551$0$140,488$143,038$85,657=30-year LCCTotals:$12,274$1,594$0$87,805$101,673$65,810=30-year LCC Energy Audit Report April 16, 2012 pg. 49 ECM #8 Calculations System 1 - Location Served: Fuel Type AFUE Thermostat Setpoint Full Load KW (Electric Only) Mo/Yr Operation (Electric Only)Cost Existing Propane 82.00%70.0 N/A Proposed Oil 80.00%70.0 $144,428.00 Heating Data 100 Volume Served 100 Description of Retrofit Boiler Replace existing propane boilers with (2) oil fired boilers. $13,795.26 Average AFUE of All Heating Systems, proportional to volume 82.00% Heating System Summary $1.68 70 $0.00 80.00% $2.57 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 $144,428.00Estimated Cost of Heating System Replacements New Heating SystemsExisting Heating Systems 8018 8,218.45 Estimated Demand Charges (electric) Estimated Savings per Year $0.00 $20,631.01 $6,835.75 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.OilElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$41320,631$ $0$21,044(1+i)^-nCostsCosts2,012$144,428$27613,795$ $0$14,071(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$144,428------$144,4281.00$144,428$144,4282,01342520,899021,3240.9720,70320,703.12$ 2,013028413,975014,2590.9713,843$158,271(137,568)$ 2,014043821,171021,6090.9420,36841,071$ 2,014029314,156014,4490.9413,620$171,891(130,820)$ 2,015045121,446021,8970.9220,03961,110$ 2,015030114,340014,6420.9213,399$185,290(124,180)$ 2,016046421,725022,1890.8919,71580,825$ 2,016031114,527014,8370.8913,183$198,473(117,648)$ 2,017047823,137023,6150.8620,371101,196$ 2,017032015,471015,7910.8613,621$212,094(110,898)$ 2,018049324,641025,1340.8421,049122,245$ 2,018032916,477016,8060.8414,075$226,169(103,924)$ 2,019050726,243026,7500.8121,750143,995$ 2,019033917,548017,8870.8114,544$240,713(96,717)$ 2,020052327,948028,4710.7922,475166,471$ 2,020035018,688019,0380.7915,028$255,741(89,271)$ 2,021053829,765030,3030.7723,225189,696$ 2,021036019,903020,2630.7715,530$271,271(81,575)$ 2,022055531,700032,2540.7424,000213,696$ 2,022037121,197021,5670.7416,048$287,319(73,623)$ 2,023057133,760034,3310.7224,802238,498$ 2,023038222,574022,9560.7216,584$303,903(65,406)$ 2,024058835,955036,5430.7025,630264,128$ 2,024039324,042024,4350.7017,138$321,041(56,913)$ 2,025060638,292038,8980.6826,487290,615$ 2,025040525,604026,0100.6817,711$338,753(48,137)$ 2,026062440,781041,4050.6627,373317,989$ 2,026041727,269027,6860.6618,304$357,056(39,067)$ 2,027064344,981045,6240.6429,284347,273$ 2,027043030,077030,5070.6419,581$376,638(29,365)$ 2,028066249,614050,2760.6231,331378,604$ 2,028044333,175033,6180.6220,950$397,587(18,984)$ 2,029068254,724055,4060.6133,522412,125$ 2,029045636,592037,0480.6122,415$420,002(7,877)$ 2,030070260,361061,0630.5935,868447,994$ 2,030047040,361040,8310.5923,984$443,9864,008$ 2,031072466,578067,3020.5738,381486,375$ 2,031048444,519045,0020.5725,664$469,65016,725$ 2,032074573,436074,1810.5541,072527,447$ 2,032049849,104049,6020.5527,464$497,11430,333$ 2,033076881,000081,7670.5443,954571,401$ 2,033051354,162054,6750.5429,390$526,50544,897$ 2,034079189,343090,1330.5247,040618,441$ 2,034052959,740060,2690.5231,454$557,95860,482$ 2,035081498,545099,3590.5150,344668,785$ 2,035054565,894066,4380.5133,664$591,62277,163$ 2,0360839108,6950109,5340.4953,883722,669$ 2,036056172,681073,2410.4936,030$627,65295,017$ 2,0370864119,8910120,7540.4857,673780,342$ 2,037057880,167080,7440.4838,564$666,216114,126$ 2,0380890132,2390133,1290.4661,731842,073$ 2,038059588,424089,0190.4641,278$707,494134,579$ 2,0390917145,8600146,7760.4566,077908,150$ 2,039061397,532098,1440.4544,184$751,677156,473$ 2,0400944160,8830161,8280.4470,731978,881$ 2,0400631107,5770108,2090.4447,295$798,973179,909$ 2,0410972177,4540178,4270.4275,7151,054,596$ 2,0410650118,6580119,3080.4250,628$849,601204,995$ 2,04201,002195,7320196,7340.4181,0521,135,648$ 2,0420670130,8800131,5490.4154,197$903,797231,851$ Totals:$0$20,219$2,056,799$0$2,077,018$1,135,648=30-year LCCTotals:$144,428$13,520$1,375,311$0$1,533,260$903,797=30-year LCC Energy Audit Report April 16, 2012 pg. 51 ECM #9 Calculations System 1 - Location Served: Fuel Type AFUE Thermostat Setpoint Full Load KW (Electric Only) Mo/Yr Operation (Electric Only)Cost Existing Propane 82.00%70.0 N/A Proposed Propane 95.00%70.0 $62,028.39 Heating Data 100 Volume Served 100 Description of Retrofit Boiler Replace existing propane boilers with (2) 95% AFUE propane boilers. $17,807.82 Average AFUE of All Heating Systems, proportional to volume 82.00% Heating System Summary $2.57 70 $0.00 95.00% $2.57 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 $62,028.39Estimated Cost of Heating System Replacements New Heating SystemsExisting Heating Systems 8018 6,920.80 Estimated Demand Charges (electric) Estimated Savings per Year $0.00 $20,631.01 $2,823.19 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.PropaneElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.PropaneElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$41320,631$ $0$21,044(1+i)^-nCostsCosts2,012$62,028$35617,808$ $0$18,164(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$62,028------$62,0281.00$62,028$62,0282,01342520,899021,3240.9720,70320,703.12$ 2,013036718,039018,4060.9717,870$79,898(59,195)$ 2,014043821,171021,6090.9420,36841,071$ 2,014037818,274018,6520.9417,581$97,479(56,408)$ 2,015045121,446021,8970.9220,03961,110$ 2,015038918,511018,9010.9217,297$114,776(53,666)$ 2,016046421,725022,1890.8919,71580,825$ 2,016040118,752019,1530.8917,017$131,793(50,968)$ 2,017047823,137023,6150.8620,371101,196$ 2,017041319,971020,3840.8617,583$149,376(48,181)$ 2,018049324,641025,1340.8421,049122,245$ 2,018042521,269021,6940.8418,169$167,545(45,300)$ 2,019050726,243026,7500.8121,750143,995$ 2,019043822,652023,0900.8118,774$186,319(42,324)$ 2,020052327,948028,4710.7922,475166,471$ 2,020045124,124024,5750.7919,400$205,719(39,248)$ 2,021053829,765030,3030.7723,225189,696$ 2,021046525,692026,1570.7720,047$225,766(36,070)$ 2,022055531,700032,2540.7424,000213,696$ 2,022047927,362027,8410.7420,716$246,482(32,786)$ 2,023057133,760034,3310.7224,802238,498$ 2,023049329,140029,6330.7221,408$267,889(29,392)$ 2,024058835,955036,5430.7025,630264,128$ 2,024050831,035031,5420.7022,123$290,013(25,885)$ 2,025060638,292038,8980.6826,487290,615$ 2,025052333,052033,5750.6822,863$312,875(22,260)$ 2,026062440,781041,4050.6627,373317,989$ 2,026053935,200035,7390.6623,628$336,503(18,514)$ 2,027064344,981045,6240.6429,284347,273$ 2,027055538,826039,3810.6425,277$361,780(14,507)$ 2,028066249,614050,2760.6231,331378,604$ 2,028057242,825043,3960.6227,043$388,823(10,219)$ 2,029068254,724055,4060.6133,522412,125$ 2,029058947,236047,8240.6128,935$417,758(5,632)$ 2,030070260,361061,0630.5935,868447,994$ 2,030060652,101052,7070.5930,960$448,718(724)$ 2,031072466,578067,3020.5738,381486,375$ 2,031062557,467058,0920.5733,129$481,8474,528$ 2,032074573,436074,1810.5541,072527,447$ 2,032064363,387064,0300.5535,452$517,29910,149$ 2,033076881,000081,7670.5443,954571,401$ 2,033066369,915070,5780.5437,939$555,23816,163$ 2,034079189,343090,1330.5247,040618,441$ 2,034068277,117077,7990.5240,603$595,84122,600$ 2,035081498,545099,3590.5150,344668,785$ 2,035070385,060085,7630.5143,455$639,29629,490$ 2,0360839108,6950109,5340.4953,883722,669$ 2,036072493,821094,5450.4946,510$685,80636,863$ 2,0370864119,8910120,7540.4857,673780,342$ 2,0370746103,4840104,2300.4849,781$735,58744,755$ 2,0380890132,2390133,1290.4661,731842,073$ 2,0380768114,1430114,9110.4653,284$788,87053,203$ 2,0390917145,8600146,7760.4566,077908,150$ 2,0390791125,9000126,6910.4557,035$845,90562,245$ 2,0400944160,8830161,8280.4470,731978,881$ 2,0400815138,8680139,6830.4461,052$906,95771,924$ 2,0410972177,4540178,4270.4275,7151,054,596$ 2,0410839153,1710154,0110.4265,354$972,31182,285$ 2,04201,002195,7320196,7340.4181,0521,135,648$ 2,0420864168,9480169,8120.4169,960$1,042,27293,376$ Totals:$0$20,219$2,056,799$0$2,077,018$1,135,648=30-year LCCTotals:$62,028$17,453$1,775,342$0$1,854,823$1,042,272=30-year LCC Energy Audit Report April 16, 2012 pg. 53 ECM #10 Calculations Horsepower Motor Loading Efficiency KW Operating Hours/yr Yearly KW Demand Yearly KW Demand Cost Yearly KWH Consumption Yearly KWH Cost Totals Existing 2 70 80 1.31 8760 15.67 $0.00 11,436 $2,024.20 $2,024.20 Proposed 2 70 86.5 1.21 8760 14.49 $0.00 10,577 $1,872.10 $1,872.10 Savings 1.18 $0.00 859 $152.11 $152.11 Installed Cost $2,381.19 Payback (years)15.65 Description of Improvement Motor #2 Replace motor serving gym air handler (HV-1) with motor having an efficiency of 86.5% or greater. 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.PropaneElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.PropaneElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$40-$ $2,024$2,065(1+i)^-nCostsCosts2,012$2,381$37-$ $1,872$1,910(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$2,381------$2,3811.00$2,381$2,3812,01304202,0792,1210.972,0592,058.79$ 2,01303901,9231,9610.971,904$4,285(2,226)$ 2,01404302,1352,1780.942,0534,112$ 2,01404001,9752,0140.941,899$6,184(2,072)$ 2,01504402,1932,2370.922,0476,159$ 2,01504102,0282,0690.921,893$8,077(1,918)$ 2,01604602,2522,2970.892,0418,200$ 2,01604202,0832,1250.891,888$9,965(1,765)$ 2,01704702,3222,3690.862,04310,243$ 2,01704302,1472,1910.861,890$11,855(1,611)$ 2,01804802,3942,4420.842,04512,288$ 2,01804502,2142,2580.841,891$13,746(1,458)$ 2,01905002,4682,5180.812,04714,335$ 2,01904602,2822,3280.811,893$15,639(1,304)$ 2,02005102,5442,5960.792,04916,384$ 2,02004702,3532,4010.791,895$17,534(1,150)$ 2,02105302,6232,6760.772,05118,435$ 2,02104902,4262,4750.771,897$19,431(996)$ 2,02205402,7052,7590.742,05320,488$ 2,02205002,5012,5520.741,899$21,330(842)$ 2,02305602,7882,8440.722,05522,543$ 2,02305202,5792,6310.721,900$23,230(687)$ 2,02405802,8752,9330.702,05724,600$ 2,02405302,6592,7120.701,902$25,132(533)$ 2,02505902,9643,0230.682,05926,658$ 2,02505502,7412,7960.681,904$27,036(378)$ 2,02606103,0563,1170.662,06128,719$ 2,02605702,8262,8830.661,906$28,942(223)$ 2,02706303,1993,2620.642,09430,813$ 2,02705802,9593,0170.641,937$30,879(66)$ 2,02806503,3503,4150.622,12832,941$ 2,02806003,0983,1580.621,968$32,84794$ 2,02906703,5073,5740.612,16235,104$ 2,02906203,2443,3060.612,000$34,847257$ 2,03006903,6723,7410.592,19737,301$ 2,03006403,3963,4600.592,032$36,879422$ 2,03107103,8453,9160.572,23339,534$ 2,03106603,5563,6210.572,065$38,944590$ 2,03207304,0254,0980.552,26941,803$ 2,03206803,7233,7900.552,099$41,043760$ 2,03307504,2154,2900.542,30644,109$ 2,03307003,8983,9670.542,133$43,176933$ 2,03407804,4134,4900.522,34346,453$ 2,03407204,0814,1530.522,167$45,3431,109$ 2,03508004,6204,7000.512,38148,834$ 2,03507404,2734,3470.512,202$47,5461,288$ 2,03608204,8374,9190.492,42051,254$ 2,03607604,4744,5500.492,238$49,7841,470$ 2,03708505,0645,1490.482,45953,713$ 2,03707804,6844,7620.482,275$52,0581,655$ 2,03808705,3035,3900.462,49956,213$ 2,03808104,9044,9850.462,311$54,3701,843$ 2,03909005,5525,6420.452,54058,753$ 2,03908305,1355,2180.452,349$56,7192,034$ 2,04009305,8135,9050.442,58161,334$ 2,04008605,3765,4620.442,387$59,1062,228$ 2,04109506,0866,1810.422,62363,957$ 2,04108805,6295,7170.422,426$61,5322,425$ 2,04209806,3726,4700.412,66666,622$ 2,04209105,8935,9840.412,465$63,9972,625$ Totals:$0$1,984$0$109,268$111,252$66,622=30-year LCCTotals:$2,381$1,835$0$101,057$105,273$63,997=30-year LCC Energy Audit Report April 16, 2012 pg. 55 ECM #11 Calculations Component Framed Section Insulated Section Component Framed Section Insulated Section Concrete Wall 0.8 0.8 Concrete Wall 0.8 0.8 Foam/Fiberglass Insulation 10 10 Foam/Fiberglass Insulation 10 10 Add 2" Foam insulation to exterior 16 16 Total R-Values 10.8 10.8 Total R-Values 26.8 26.8 Total U-Values 0.0926 0.0926 Total U-Values 0.0373 0.0373 Percentage of Framing 100.00%Percentage of Framing 100.00% Composite U-Value of Assembly 0.0926 Composite U-Value of Assembly 0.0373 Composite R-Value of Assembly 10.8000 Composite R-Value of Assembly 26.8000 Average Height Of Wall 5.56 Average Height Of Wall 5.56 Wall Length 522.5 Wall Length 522.5 Distance from Grade to top of wall 1.87 Distance from Grade to top of wall 1.87 Wall Square Footage - Below Grade 1928.025 Wall Square Footage - Below Grade 1928.025 Wall Square Footage - Above Grade 977.075 Wall Square Footage - Above Grade 977.075 Total Square Footage 2905.1 Total Square Footage 2905.1 Ground R-Value 7.22 Ground R-Value 7.22 Total Below Ground R-Value 18.0216 Total Below Ground R-Value 34.0216 Total Above Grade R-Value 10.8000 Total Above Grade R-Value 26.8000 Above Grade Heat Loss BTU/h 2,895.04 Above Grade Heat Loss BTU/h 1,166.66 Below Grade Heat Loss BTU/h 3,423.48 Below Grade Heat Loss BTU/h 1,813.46 Total Below Grade Wall Heat Loss BTU/h 6,318.52 Total Below Grade Wall Heat Loss BTU/h 2,980.11 Heating System Served System 1 Heating System Served System 1 Original Heating System Proposed Heating System Savings - Original Heating System Savings - Proposed Heating System Yearly Cost $1,736.84 Yearly Cost $819.18 $707.08 $917.66 $792.09 Cost of Proposed Upgrade $32,449.00 Below Grade Wall - Original Assembly 1 Below Grade Wall - Proposed Assembly 1 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.PropaneElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.PropaneElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2012$01,737$ $0$1,737(1+i)^-nCostsCosts2012$32,449$0819$ $0$819(1+i)^-nCostsCosts2012$0------$01.00$0-$ 2012$32,449------$32,4491.00$32,449$32,449201301,75901,7590.971,708########20130083008300.97806$33,255(31,546)$ 2014001,78201,7820.941,6803,388$ 20140084108410.94792$34,047(30,659)$ 2015001,80501,8050.921,6525,040$ 20150085208520.92779$34,826(29,786)$ 2016001,82901,8290.891,6256,665$ 20160086308630.89766$35,593(28,927)$ 2017001,94801,9480.861,6808,346$ 20170091909190.86792$36,385(28,040)$ 2018002,07402,0740.841,73710,083$ 20180097809780.84819$37,205(27,122)$ 2019002,20902,2090.811,79611,879$ 2019001,04201,0420.81847$38,052(26,173)$ 2020002,35302,3530.791,85713,737$ 2020001,11001,1100.79876$38,928(25,191)$ 2021002,50602,5060.771,92015,657$ 2021001,18201,1820.77906$39,834(24,177)$ 2022002,66902,6690.741,98617,643$ 2022001,25901,2590.74937$40,770(23,127)$ 2023002,84202,8420.722,05319,696$ 2023001,34001,3400.72968$41,739(22,043)$ 2024003,02703,0270.702,12321,819$ 2024001,42801,4280.701,001$42,740(20,921)$ 2025003,22403,2240.682,19524,014$ 2025001,52001,5200.681,035$43,775(19,761)$ 2026003,43303,4330.662,27026,284$ 2026001,61901,6190.661,071$44,846(18,562)$ 2027003,78703,7870.642,43128,714$ 2027001,78601,7860.641,146$45,992(17,278)$ 2028004,17704,1770.622,60331,317$ 2028001,97001,9700.621,228$47,220(15,902)$ 2029004,60704,6070.612,78734,105$ 2029002,17302,1730.611,315$48,534(14,430)$ 2030005,08205,0820.592,98537,090$ 2030002,39702,3970.591,408$49,942(12,853)$ 2031005,60505,6050.573,19640,286$ 2031002,64402,6440.571,508$51,450(11,164)$ 2032006,18206,1820.553,42343,709$ 2032002,91602,9160.551,614$53,064(9,355)$ 2033006,81906,8190.543,66647,374$ 2033003,21603,2160.541,729$54,793(7,419)$ 2034007,52107,5210.523,92551,300$ 2034003,54703,5470.521,851$56,644(5,345)$ 2035008,29608,2960.514,20455,503$ 2035003,91303,9130.511,983$58,627(3,124)$ 2036009,15109,1510.494,50160,005$ 2036004,31604,3160.492,123$60,750(745)$ 20370010,093010,0930.484,82164,825$ 2037004,76004,7600.482,274$63,0241,802$ 20380011,133011,1330.465,16269,988$ 2038005,25105,2510.462,435$65,4584,529$ 20390012,279012,2790.455,52875,516$ 2039005,79205,7920.452,607$68,0667,450$ 20400013,544013,5440.445,92081,435$ 2040006,38806,3880.442,792$70,85810,578$ 20410014,939014,9390.426,33987,775$ 2041007,04607,0460.422,990$73,84813,927$ 20420016,478016,4780.416,78994,564$ 2042007,77207,7720.413,202$77,05017,514$ Totals:$0$0$173,154$0$173,154$94,564=30-year LCCTotals:$32,449$0$81,667$0$114,116$77,050=30-year LCC Energy Audit Report April 16, 2012 pg. 57 ECM #12 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.42 Window U-value 0.3 Wall Square Footage Wall Square Footage Window Square Footage 52 Window Square Footage 52 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.4200 Composite U-value for entire assembly 0.3000 Composite R-Value for entire assembly 2.3810 Composite R-Value for entire assembly 3.3333 Heating System Served System 1 Heating System Served System 1 Heat Loss in BTU/h 698.88 Heat Loss in BTU/h 499.20Original Heating Proposed Heating Savings - Original Heating Savings - Proposed Yearly Cost $192.11 Yearly Cost $137.22 $118.44 $54.89 $47.38 Cost of Proposed Upgrade $2,194.84 Above Grade Wall - Original Above Grade Wall - Proposed Assembly 2 Assembly 2 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.PropaneElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.PropaneElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2012$0192$ $0$192(1+i)^-nCostsCosts2012$2,195$0137$ $0$137(1+i)^-nCostsCosts2012$0------$01.00$0-$ 2012$2,195------$2,1951.00$2,195$2,1952013019501950.97189188.94$ 20130013901390.97135$2,330(2,141)$ 20140019701970.94186375$ 20140014101410.94133$2,463(2,088)$ 20150020002000.92183558$ 20150014301430.92131$2,593(2,036)$ 20160020202020.89180737$ 20160014401440.89128$2,721(1,984)$ 20170021502150.86186923$ 20170015401540.86133$2,854(1,931)$ 20180022902290.841921,115$ 20180016401640.84137$2,991(1,876)$ 20190024402440.811991,314$ 20190017501750.81142$3,133(1,819)$ 20200026002600.792051,519$ 20200018601860.79147$3,280(1,761)$ 20210027702770.772121,732$ 20210019801980.77152$3,432(1,700)$ 20220029502950.742201,951$ 20220021102110.74157$3,589(1,637)$ 20230031403140.722272,179$ 20230022502250.72162$3,751(1,572)$ 20240033503350.702352,413$ 20240023902390.70168$3,919(1,505)$ 20250035703570.682432,656$ 20250025502550.68173$4,092(1,436)$ 20260038003800.662512,907$ 20260027102710.66179$4,271(1,364)$ 20270041904190.642693,176$ 20270029902990.64192$4,463(1,287)$ 20280046204620.622883,464$ 20280033003300.62206$4,669(1,205)$ 20290051005100.613083,772$ 20290036403640.61220$4,889(1,117)$ 20300056205620.593304,102$ 20300040104010.59236$5,125(1,023)$ 20310062006200.573544,456$ 20310044304430.57253$5,378(922)$ 20320068406840.553794,835$ 20320048804880.55270$5,648(814)$ 20330075407540.544055,240$ 20330053905390.54290$5,938(698)$ 20340083208320.524345,674$ 20340059405940.52310$6,248(574)$ 20350091809180.514656,139$ 20350065506550.51332$6,580(441)$ 2036001,01201,0120.494986,637$ 20360072307230.49356$6,936(299)$ 2037001,11601,1160.485337,170$ 20370079707970.48381$7,316(146)$ 2038001,23101,2310.465717,741$ 20380088008800.46408$7,72417$ 2039001,35801,3580.456118,353$ 20390097009700.45437$8,161192$ 2040001,49801,4980.446559,007$ 2040001,07001,0700.44468$8,629379$ 2041001,65201,6520.427019,709$ 2041001,18001,1800.42501$9,130579$ 2042001,82301,8230.4175110,459$ 2042001,30201,3020.41536$9,666794$ Totals:$0$0$19,152$0$19,152$10,459=30-year LCCTotals:$2,195$0$13,680$0$15,875$9,666=30-year LCC Energy Audit Report April 16, 2012 pg. 59 Cost Data Energy Audit Report April 16, 2012 pg. 60 Energy Audit Report April 16, 2012 pg. 61 Energy Audit Report April 16, 2012 pg. 62