The URL can be used to link to this page

Home My WebLink AboutCIRI-HOM-CAEC Nikolaevsk School 2012-EEFINAL ENERGY AUDIT Nikolaevsk School 65524 Nikolaevsk Road Nikolaevsk, AK 99556 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 24 Benchmark Information 25 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 Nikolaevsk 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 $32,290.75 Oil $34,290.75 Total $66,555.25 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 23,905 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 ECM #Improvement Description Installed Cost Annualized NPV Savings NPV Savings Over Improvement Life Breakeven Cost SIR Simple Payback (Years) ROI 1 Replace exisiting exterior incandescent lamps with 18w compact fluorescent lamps rated for cold weather. $98 $319 $5,107 $5,205 52.2 1 5217% 2 Replace existing interior incandescent lamps with 18w compact fluorescent lamps.$235 $150 $2,394 $2,629 10.2 2 1019% 3 Replace 4' 4 lamp T12 gym security lights with 4' 4 lamp T8 fixtures and 25w lamps.$1,747 $539 $8,622 $10,369 4.9 3 493% 4 Replace existing lamps in T8 fixtures with 25w lamps.$19,327 $1,330 $21,272 $40,599 1.1 8 110% 5 Replace current Grundfos UP65-160 circulation pumps in original utility room with equivalent permanent magnet, variable speed pump. $7,060 $448 $6,713 $13,773 1.0 8 95% 6 Replace 5hp air handler motor in original utility room with minimum 89.5% efficient motor. $2,744 $153 $2,288 $5,032 0.8 9 83% 7 Add additional R-16 insulation to old portion of school cathedral ceiling. This improvement does not include the cost of re-roofing. This measure should only be done at the time of a planned change in roof materials in order to be cost effective. $27,216 $960 $19,191 $46,407 0.7 14 71% 8 Replace 5hp air handler motor in classroom addition utility room with minimum 89.5% efficient motor. $2,744 $20 $303 $3,047 0.1 14 11% Total, Cost Effective Measures $61,169 $3,917 $65,890 $127,059 1.1 108% 9 Replace 3hp air handler motor in classroom addition utility room with minimum 89.5% efficient motor. $1,977 ($10)($149)$1,828 -0.1 17 -8% 10 Replace existing metal halide lights with T5 Hi Bay lights with 54w lamps and electronic ballasts. $19,489 ($131)($2,093)$17,396 -0.1 19 -11% 11 Replace existing boilers with 95% AFUE boilers. This ECM is based on savings over the existing boilers already being re-fit to burn natural gas. $101,799 ($930)($18,603)$83,196 -0.2 23 -18% 12 Add 6" blown fiberglass to accessible attic.$35,266 ($1,118)($22,365)$12,901 -0.6 >30 -63% 13 Add 2 inches insulation to exterior of foundation wall around entire building.$30,448 ($1,383)($27,667)$2,781 -0.9 >30 -91% Total, All Measures $250,148 $344 ($4,987)$245,161 0.0 -2% 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 Nikolaevsk school was originally constructed 1975, with additional classrooms added in 1985 and a gymnasium/locker room expansion thereafter. At the time of the audit the school was being heated by to oil fired boilers that will be converted to natural gas within the next year. Therefore all heating and shell improvements are based on burning natural gas rather than oil, which because of it’s much lower cost-per-therm creates longer paybacks than if oil was used as the comparison fuel. The building is served by three different air handlers, one for the original section, one for the classroom additions and one for the gymnasium. Domestic hot water is provided by the boilers as well. Interior lighting is mostly T8 fluorescent with some incandescent and CFL. Exterior lighting is mostly high pressure sodium with some incandescent. 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. Special cold weather lamps will be required for outdoor use. ECM #Improvement Description Installed Cost Annualized NPV Savings NPV Savings Over Improvement Life Breakeven Cost SIR Simple Payback (Years) ROI 1 Replace exisiting exterior incandescent lamps with 18w compact fluorescent lamps rated for cold weather. $98 $319 $5,107 $5,205 52.2 1 5217% 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 interior incandescent lamps with 18w compact fluorescent lamps.$235 $150 $2,394 $2,629 10.2 2 1019% 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 4' 4 lamp T12 gym security lights with 4' 4 lamp T8 fixtures and 25w lamps.$1,747 $539 $8,622 $10,369 4.9 3 493% Energy Audit Report April 16, 2012 pg. 14 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 lamps in T8 fixtures with 25w lamps.$19,327 $1,330 $21,272 $40,599 1.1 8 110% Energy Audit Report April 16, 2012 pg. 15 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 5 Replace current Grundfos UP65-160 circulation pumps in original utility room with equivalent permanent magnet, variable speed pump. $7,060 $448 $6,713 $13,773 1.0 8 95% Energy Audit Report April 16, 2012 pg. 16 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 6 Replace 5hp air handler motor in original utility room with minimum 89.5% efficient motor. $2,744 $153 $2,288 $5,032 0.8 9 83% Energy Audit Report April 16, 2012 pg. 17 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 7 Add additional R-16 insulation to old portion of school cathedral ceiling. This improvement does not include the cost of re-roofing. This measure should only be done at the time of a planned change in roof materials in order to be cost effective. $27,216 $960 $19,191 $46,407 0.7 14 71% Energy Audit Report April 16, 2012 pg. 18 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 8 Replace 5hp air handler motor in classroom addition utility room with minimum 89.5% efficient motor. $2,744 $20 $303 $3,047 0.1 14 11% Energy Audit Report April 16, 2012 pg. 19 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 9 Replace 3hp air handler motor in classroom addition utility room with minimum 89.5% efficient motor. $1,977 ($10)($149)$1,828 -0.1 17 -8% Energy Audit Report April 16, 2012 pg. 20 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 over the ice 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 10 Replace existing metal haside lights with T5 Hi Bay lights with 54w lamps and electronic ballasts. $19,489 ($131)($2,093)$17,396 -0.1 19 -11% Energy Audit Report April 16, 2012 pg. 21 This ECM assumes a life expectancy of 20 years for this measure. This measure is based on existing boiler already being refit with natural gas burners. The breakeven cost of $83,196, which is the savings over the life of the proposed improvement, would be much greater if compared to the original oil burners. This ECM is also based on a gas rate of $1.03 per therm, which may be more or less than actually charged once the new burners are online. Once the new gas rate is known this ECM can be re-figured to determine savings. ECM #Improvement Description Installed Cost Annualized NPV Savings NPV Savings Over Improvement Life Breakeven Cost SIR Simple Payback (Years) ROI 11 Replace existing boilers with 95% AFUE boilers. This ECM is based on savings over the existing boilers already being re-fit to burn natural gas. $101,799 ($930)($18,603)$83,196 -0.2 23 -18% 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 Add 6" blown fiberglass to accessible attic.$35,266 ($1,118)($22,365)$12,901 -0.6 >30 -63% Energy Audit Report April 16, 2012 pg. 23 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 13 Add 2 inches insulation to exterior of foundation wall around entire building.$30,448 ($1,383)($27,667)$2,781 -0.9 >30 -91% Energy Audit Report April 16, 2012 pg. 24 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 digital direct controls 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. 25 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 50% more 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. Replacement of the burners on the existing boiler system to natural gas won’t decrease the BTUs needed to heat the building, but will decrease the cost. Energy Audit Report April 16, 2012 pg. 26 Electrical usage in terms of BTU per square foot is slightly 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. 27 The total energy use profile shows the majority of BTUs consumed by the building are from oil which is used exclusively for heating. Electrical usage is second. Energy Audit Report April 16, 2012 pg. 28 The energy cost total shows a nearly even split in cost between oil and electrical. Once natural gas comes on line the fossil fuel cost will be considerably smaller than the electrical cost by proportion. Energy Audit Report April 16, 2012 pg. 29 Oil consumption tracks closely with Heating Degree Days, which are a measure of the heating load imposed by the climate. Oil usage is uneven due to the fact that oil deliveries did not occur every month. Energy Audit Report April 16, 2012 pg. 30 Electrical consumption has increased slightly over the last 2 year period. Electrical consumption also tracks with heating degree days. This is because winter is the time when the school is most heavily in use. 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.38, which is not particularly good. The percent of the electrical bill caused by demand charges is 16.5%. The amount of electrical demand from this building is slightly elevated. Reduction in demand will occur with improved electrical efficiency. 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 Boiler 1 Utility Room Heating Weil McLain BL 686 SW HWB 1428 MMBTU/ h 80%In series 20 0 Boiler 2 Utility Room Heating Weil McLain BL 686 SW HWB 1429 MMBTU/80%In series 20 0 Addition AHU Utility Room Air Handling General Electric 5KC184A B210A 83%5 15 0 Addition AHU Utility Room Air Handling General Electric N/A N/A 3 15 0 Gymnasium AHU Gym Utility Room Air Handling Trane K01G067 50C 5 Serve Gym 15 0 CUH 1 Gym Heat Distribution Modine CR-06 Fan Coil 620 CFM N/A From Plans 15 0 UH 1 Gym Locker Heat Distribution Modine HS-18 Fan Coil 340 CFM N/A From Plans 15 0 UH 2 Gym Heat Distribution Modine V-139 Fan Coil 2660 CFM N/A From Plans 15 0 Original AHU Utility Room Air Handling Teco BECSFD 78.50%5 15 0 EF1 Classrooms Exhaust Penn BB45 500 CFM From Plans 15 0 EF1 - Gym Gym Exhaust Greenheck BDF-80 560 CFM From Plans 15 0 Energy Audit Report April 16, 2012 pg. 33 Benchmark Data Building Designation:Electric Meter # Square footage of conditioned area:23905 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 30 5,940 38.00 $0.17 $996.00 $277.40 20.27 0.22 27.9% Aug-08 33 17,400 61.00 $0.14 $2,473.00 $445.30 59.39 0.36 18.0% Sep-08 28 17,820 61.00 $0.17 $3,038.00 $445.30 60.82 0.43 14.7% Oct-08 29 19,260 65.00 $0.17 $3,275.00 $474.50 65.73 0.43 14.5% Nov-08 31 19,440 60.00 $0.17 $3,262.00 $438.00 66.35 0.44 13.4% Dec-08 32 17,220 62.00 $0.21 $3,629.00 $452.60 58.77 0.36 12.5% Jan-09 31 20,460 64.00 $0.21 $4,235.00 $467.20 69.83 0.43 11.0% Feb-09 28 18,480 62.00 $0.21 $3,964.00 $452.60 63.07 0.44 11.4% Mar-09 31 17,040 59.00 $0.17 $2,902.00 $430.70 58.16 0.39 14.8% Apr-09 29 12,720 56.00 $0.18 $2,261.00 $408.80 43.41 0.33 18.1% May-09 31 13,680 53.00 $0.17 $2,378.00 $386.90 46.69 0.35 16.3% Jun-09 32 8,880 31.00 $0.17 $1,551.00 $226.30 30.31 0.37 14.6% Jul-09 29 6,960 36.00 $0.19 $1,308.00 $262.80 23.75 0.28 20.1% Aug-09 30 12,900 56.00 $0.18 $2,316.00 $408.80 44.03 0.32 17.7% Sep-09 31 17,580 60.00 $0.15 $2,636.00 $438.00 60.00 0.39 16.6% Oct-09 30 19,440 65.00 $0.15 $2,900.00 $474.50 66.35 0.42 16.4% Nov-09 33 23,160 65.00 $0.15 $3,359.00 $474.50 79.05 0.45 14.1% Dec-09 29 17,100 64.00 $0.13 $2,298.00 $467.20 58.36 0.38 20.3% Jan-10 29 20,520 68.00 $0.13 $2,689.00 $496.40 70.03 0.43 18.5% Feb-10 27 18,240 66.00 $0.13 $2,435.00 $481.80 62.25 0.43 19.8% Mar-10 34 21,960 64.00 $0.15 $3,296.00 $467.20 74.95 0.42 14.2% Apr-10 30 19,440 62.00 $0.15 $2,964.00 $452.60 66.35 0.44 15.3% May-10 29 17,760 65.00 $0.16 $2,780.00 $474.50 60.61 0.39 17.1% Jun-10 33 9,720 40.00 $0.16 $1,584.00 $292.00 33.17 0.31 18.4% #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.38 16380.00 57.63 #DIV/0!$2,688.71 $420.66 55.90 #DIV/0!#DIV/0! Total 729 393,120 N/A N/A $64,529.00 $10,095.90 1,341.72 N/A N/A Monthly Benchmark Occupancy Education ....................61.852594 % Difference Size 10,001 to 100,000 Square Feet 90.38% Electricity Nikolaevsk School Energy Use Index Form 1 Energy Audit Report April 16, 2012 pg. 34 Oil Usage GallonsOil CostOil Cost per GallonOil MMBtu0.00$0.00#DIV/0!0.001,590.00$6,580.00$4.14222.600.00$0.00#DIV/0!0.001,406.00$3,464.00$2.46196.841,337.00$3,220.00$2.41187.180.00$0.00#DIV/0!0.004,310.00$8,614.00$2.00603.402,390.00$4,344.00$1.82334.601,795.00$3,352.50$1.87251.301,200.00$2,361.00$1.97168.001,542.00$2,980.00$1.93215.881,106.00$2,412.00$2.18154.840.00$0.00#DIV/0!0.00708.00$1,722.00$2.4399.120.00$0.00#DIV/0!0.001,284.00$2,955.00$2.30179.760.00$0.00#DIV/0!0.002,303.00$5,474.00$2.38322.422,112.00$5,382.00$2.55295.681,657.00$4,104.00$2.48231.982,500.00$6,591.00$2.64350.000.00$0.00#DIV/0!0.001,864.00$5,026.00$2.70260.960.00$0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.00#DIV/0!0.001212.67$2,857.56#DIV/0!169.7729104.00$68,581.50#DIV/0!4074.5958.56725289.88%Oil Usage GallonsHDDCCDProductionBtu/Sq. FtCost $/Sq Ft848$0.0411,796$0.102,544$0.1393810,984$0.14113210,606$0.1412642,459$0.15137628,163$0.18119216,636$0.17118912,945$0.128518,844$0.0961510,984$0.104547,745$0.06300994$0.053695,988$0.105032,510$0.1169010,295$0.1211143,307$0.14109615,929$0.10118115,299$0.1193612,309$0.10114817,777$0.148602,776$0.1265413,452$0.124671,388$0.070$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.00509.140.000.009,441$0.1118329.000.000.00226,576$2.706,308149.65%EUI Energy Audit Report April 16, 2012 pg. 35 Climate & Fuel Assumptions Client Name:Nikolaevsk School Address: Square Footage 23905 Days Occupied per Year State HDD CDD Avg. Temp 365 Alaska 10,745 0 35.3 Fuels Natural Gas $1.04 $ Per CCF $1.01 Per Therm Oil $2.36 $ Per Gallon $1.69 Per Therm Electricity $0.16 $ per KWH $4.81 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.52 Kw/Month City Homer 8 NW 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 Space Description Number of Fixtures 5 5 Lamps per Fixture 1 1 Lamp Type Incandescent CFL Fixture Wattage 60 18 Hours on per Week 168 168 Cost of New Lamp $19.58 Cost of New Fixture Total KWH Cost $429.81 $128.94 Total Demand Cost $27.07 $8.12 Total Yearly Cost $456.88 $137.06 Yearly Savings $319.82 Total Retrofit Cost $97.90 Payback Period 0.3 years Retrofit Description Replace exsiting exterior incandescent lamps with 18w compact fluorescent lamps rated for cold weather. Exterior Incandescents 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$9-$ $457$466(1+i)^-nCostsCosts2,012$98$3-$ $137$140(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$98------$981.00$98$982,0130904694790.97465464.69$ 2,0130301411440.97139$237227$ 2,01401004824920.94463928$ 2,0140301451470.94139$376552$ 2,01501004955050.924621,390$ 2,0150301481510.92139$515875$ 2,01601005085190.894611,851$ 2,0160301521560.89138$6531,198$ 2,01701105245350.864612,312$ 2,0170301571600.86138$7911,520$ 2,01801105405510.844622,774$ 2,0180301621650.84138$9301,844$ 2,01901105575680.814623,236$ 2,0190301671700.81139$1,0692,167$ 2,02001205745860.794623,698$ 2,0200301721760.79139$1,2072,491$ 2,02101205926040.774634,161$ 2,0210401781810.77139$1,3462,815$ 2,02201206106230.744634,624$ 2,0220401831870.74139$1,4853,139$ 2,02301306296420.724645,088$ 2,0230401891930.72139$1,6243,464$ 2,02401306496620.704645,552$ 2,0240401951990.70139$1,7643,789$ 2,02501306696820.684656,017$ 2,0250402012050.68139$1,9034,114$ 2,02601406907040.664656,482$ 2,0260402072110.66140$2,0434,440$ 2,02701407227360.644736,955$ 2,0270402172210.64142$2,1844,771$ 2,02801507567710.624807,435$ 2,0280402272310.62144$2,3285,107$ 2,02901507928070.614887,923$ 2,0290502372420.61146$2,4755,448$ 2,03001608298440.594968,419$ 2,0300502492530.59149$2,6245,796$ 2,03101608688840.575048,923$ 2,0310502602650.57151$2,7756,148$ 2,03201709099250.555129,435$ 2,0320502732780.55154$2,9296,507$ 2,03301709519680.545209,956$ 2,0330502852900.54156$3,0856,871$ 2,03401809961,0130.5252910,485$ 2,0340502993040.52159$3,2437,241$ 2,03501801,0431,0610.5153811,022$ 2,0350503133180.51161$3,4057,618$ 2,03601901,0921,1100.4954611,569$ 2,0360603283330.49164$3,5688,000$ 2,03701901,1431,1620.4855512,124$ 2,0370603433490.48167$3,7358,389$ 2,03802001,1971,2170.4656412,688$ 2,0380603593650.46169$3,9048,784$ 2,03902001,2531,2730.4557313,261$ 2,0390603763820.45172$4,0769,185$ 2,04002101,3121,3330.4458313,844$ 2,0400603944000.44175$4,2519,593$ 2,04102201,3741,3950.4259214,436$ 2,0410604124190.42178$4,42910,007$ 2,04202201,4381,4600.4160215,037$ 2,0420704314380.41180$4,60910,428$ Totals:$0$448$0$24,663$25,111$15,037=30-year LCCTotals:$98$134$0$7,399$7,631$4,609=30-year LCC Energy Audit Report April 16, 2012 pg. 39 ECM #2 Calculations Space Description Number of Fixtures 12 12 Lamps per Fixture 1 1 Lamp Type 60w Incandescents CFL Fixture Wattage 60 18 Hours on per Week 27 27 Cost of New Lamp $19.58 Cost of New Fixture Total KWH Cost $165.78 $49.74 Total Demand Cost $64.97 $19.49 Total Yearly Cost $230.76 $69.23 Yearly Savings $161.53 Total Retrofit Cost $234.96 Payback Period 1.5 years Interior Incandescent Lamps Replace existing interior incandescent lamps with 18w compact fluorescent lamps. Retrofit Description 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$5-$ $231$235(1+i)^-nCostsCosts2,012$235$1-$ $69$71(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$235------$2351.00$235$2352,0130502372420.97235234.70$ 2,01301071730.9770$305(71)$ 2,0140502432480.94234469$ 2,01401073740.9470$37693$ 2,0150502502550.92233702$ 2,01502075770.9270$446257$ 2,0160502572620.89233935$ 2,01602077790.8970$515419$ 2,0170502652700.862331,168$ 2,01702079810.8670$585582$ 2,0180602732780.842331,401$ 2,01802082840.8470$655746$ 2,0190602812870.812331,634$ 2,01902084860.8170$725909$ 2,0200602902960.792341,868$ 2,02002087890.7970$7951,072$ 2,0210602993050.772342,102$ 2,02102090920.7770$8651,236$ 2,0220603083150.742342,336$ 2,02202092940.7470$9361,400$ 2,0230603183240.722342,570$ 2,02302095970.7270$1,0061,564$ 2,0240703283340.702342,804$ 2,024020981000.7070$1,0761,728$ 2,0250703383450.682353,039$ 2,0250201011030.6870$1,1471,892$ 2,0260703483550.662353,274$ 2,0260201051070.6670$1,2172,057$ 2,0270703653720.642393,513$ 2,0270201091120.6472$1,2892,224$ 2,0280703823890.622433,755$ 2,0280201151170.6273$1,3622,394$ 2,0290804004070.612474,002$ 2,0290201201220.6174$1,4352,566$ 2,0300804194260.592514,252$ 2,0300201261280.5975$1,5112,742$ 2,0310804384460.572554,507$ 2,0310201311340.5776$1,5872,920$ 2,0320804594670.552594,766$ 2,0320301381400.5578$1,6653,101$ 2,0330904804890.542635,028$ 2,0330301441470.5479$1,7433,285$ 2,0340905035120.522675,296$ 2,0340301511540.5280$1,8243,472$ 2,0350905275360.512715,567$ 2,0350301581610.5181$1,9053,662$ 2,0360905515610.492765,843$ 2,0360301651680.4983$1,9883,855$ 2,03701005775870.482806,123$ 2,0370301731760.4884$2,0724,051$ 2,03801006046140.462856,408$ 2,0380301811840.4685$2,1574,251$ 2,03901006336430.452906,698$ 2,0390301901930.4587$2,2444,453$ 2,04001106636730.442946,992$ 2,0400301992020.4488$2,3334,659$ 2,04101106947050.422997,291$ 2,0410302082110.4290$2,4224,869$ 2,04201107267380.413047,595$ 2,0420302182210.4191$2,5135,081$ Totals:$0$226$0$12,456$12,683$7,595=30-year LCCTotals:$235$68$0$3,737$4,040$2,513=30-year LCC Energy Audit Report April 16, 2012 pg. 41 ECM #3 Calculations Space Description Number of Fixtures 4 4 Lamps per Fixture 4 4 Lamp Type T12 T8 Fixture Wattage 195.6 91 Hours on per Week 168 168 Cost of New Lamp Cost of New Fixture $436.83 Total KWH Cost $1,120.95 $521.50 Total Demand Cost $70.60 $32.85 Total Yearly Cost $1,191.55 $554.35 Yearly Savings $637.20 Total Retrofit Cost $1,747.32 Payback Period 2.7 years Retrofit Description Gym Security Lights Replace 4' 4 lamp T12 gym security lights with 4' 4 lamp T8 fixtures and 25w lamps. 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$24-$ $1,192$1,215(1+i)^-nCostsCosts2,012$1,747$11-$ $554$565(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$1,747------$1,7471.00$1,747$1,7472,01302501,2241,2480.971,2121,211.91$ 2,01301105695810.97564$2,311(1,099)$ 2,01402501,2571,2820.941,2082,420$ 2,01401205855960.94562$2,873(453)$ 2,01502601,2911,3170.921,2053,625$ 2,01501206006130.92561$3,434191$ 2,01602701,3261,3520.891,2024,827$ 2,01601206176290.89559$3,993834$ 2,01702801,3671,3940.861,2036,030$ 2,01701306366490.86560$4,5531,477$ 2,01802801,4091,4370.841,2047,233$ 2,01801306566690.84560$5,1132,121$ 2,01902901,4531,4820.811,2058,438$ 2,01901406766890.81561$5,6732,765$ 2,02003001,4981,5280.791,2069,645$ 2,02001406977110.79561$6,2343,410$ 2,02103101,5441,5750.771,20710,852$ 2,02101407187330.77562$6,7964,056$ 2,02203201,5921,6240.741,20812,060$ 2,02201507417560.74562$7,3584,702$ 2,02303301,6411,6740.721,21013,270$ 2,02301507647790.72563$7,9215,349$ 2,02403401,6921,7260.701,21114,481$ 2,02401607878030.70563$8,4845,996$ 2,02503501,7451,7800.681,21215,693$ 2,02501608128280.68564$9,0486,645$ 2,02603601,7991,8350.661,21316,906$ 2,02601708378540.66564$9,6127,293$ 2,02703701,8831,9200.641,23318,138$ 2,02701708768930.64573$10,1867,952$ 2,02803801,9722,0100.621,25319,391$ 2,02801809179350.62583$10,7698,622$ 2,02903902,0652,1040.611,27320,664$ 2,02901809609790.61592$11,3619,303$ 2,03004102,1622,2020.591,29421,957$ 2,03001901,0061,0250.59602$11,9639,995$ 2,03104202,2632,3050.571,31423,272$ 2,03101901,0531,0720.57612$12,57410,698$ 2,03204302,3702,4130.551,33624,608$ 2,03202001,1021,1220.55621$13,19611,412$ 2,03304402,4812,5250.541,35725,965$ 2,03302101,1541,1750.54632$13,82712,138$ 2,03404602,5972,6430.521,37927,344$ 2,03402101,2081,2300.52642$14,46912,876$ 2,03504702,7202,7670.511,40228,746$ 2,03502201,2651,2870.51652$15,12113,625$ 2,03604802,8472,8960.491,42530,171$ 2,03602301,3251,3470.49663$15,78414,387$ 2,03705002,9813,0310.481,44831,619$ 2,03702301,3871,4100.48674$16,45715,161$ 2,03805103,1213,1730.461,47133,090$ 2,03802401,4521,4760.46684$17,14215,948$ 2,03905303,2683,3210.451,49534,585$ 2,03902501,5201,5450.45696$17,83716,747$ 2,04005503,4223,4760.441,51936,104$ 2,04002501,5921,6170.44707$18,54417,560$ 2,04105603,5823,6390.421,54437,648$ 2,04102601,6671,6930.42718$19,26318,386$ 2,04205803,7513,8090.411,56939,217$ 2,04202701,7451,7720.41730$19,99319,225$ Totals:$0$1,168$0$64,321$65,489$39,217=30-year LCCTotals:$1,747$543$0$29,924$32,215$19,993=30-year LCC Energy Audit Report April 16, 2012 pg. 43 ECM #4 Calculations Space Description Number of Fixtures 1112 1112 Lamps per Fixture 1 1 Lamp Type 4' T8 4' T8 Fixture Wattage 32 25 Hours on per Week 27 27 Cost of New Lamp $17.38 Cost of New Fixture Total KWH Cost $8,193.43 $6,401.12 Total Demand Cost $3,211.10 $2,508.67 Total Yearly Cost $11,404.53 $8,909.79 Yearly Savings $2,494.74 Total Retrofit Cost $19,326.56 Payback Period 7.7 years T8 fixtures throughout. Retrofit Description Replace existing lamps in T8 fixtures with 25w lamps. 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$228-$ $11,405$11,633(1+i)^-nCostsCosts2,012$19,327$178-$ $8,910$9,088(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$19,327------$19,3271.00$19,327$19,3272,0130235011,71211,9470.9711,59911,599.40$ 2,013018409,1509,3340.979,062$28,389(16,789)$ 2,0140242012,02912,2710.9411,56623,166$ 2,014018909,3979,5860.949,036$37,425(14,259)$ 2,0150249012,35312,6030.9211,53334,699$ 2,015019509,6519,8460.929,010$46,435(11,736)$ 2,0160257012,68712,9440.8911,50046,199$ 2,016020109,91210,1120.898,985$55,420(9,220)$ 2,0170264013,08013,3450.8611,51157,711$ 2,0170207010,21910,4260.868,993$64,413(6,702)$ 2,0180272013,48613,7580.8411,52269,233$ 2,0180213010,53610,7490.849,002$73,415(4,182)$ 2,0190281013,90414,1840.8111,53380,766$ 2,0190219010,86211,0820.819,010$82,425(1,659)$ 2,0200289014,33514,6240.7911,54492,310$ 2,0200226011,19911,4250.799,019$91,444866$ 2,0210298014,77915,0770.7711,555103,865$ 2,0210233011,54611,7790.779,027$100,4713,394$ 2,0220307015,23715,5440.7411,566115,431$ 2,0220239011,90412,1440.749,036$109,5075,924$ 2,0230316015,71016,0260.7211,577127,009$ 2,0230247012,27312,5200.729,045$118,5528,457$ 2,0240325016,19716,5220.7011,588138,597$ 2,0240254012,65412,9080.709,053$127,60510,991$ 2,0250335016,69917,0340.6811,599150,196$ 2,0250262013,04613,3080.689,062$136,66713,529$ 2,0260345017,21717,5620.6611,610161,806$ 2,0260270013,45013,7200.669,071$145,73816,069$ 2,0270355018,02618,3810.6411,798173,604$ 2,0270278014,08314,3600.649,217$154,95518,649$ 2,0280366018,87319,2390.6211,989185,593$ 2,0280286014,74415,0300.629,366$164,32121,272$ 2,0290377019,76020,1370.6112,183197,777$ 2,0290295015,43715,7320.619,518$173,84023,937$ 2,0300388020,68921,0770.5912,381210,157$ 2,0300303016,16316,4660.599,672$183,51226,645$ 2,0310400021,66122,0610.5712,581222,738$ 2,0310312016,92317,2350.579,829$193,34129,397$ 2,0320412022,67923,0910.5512,785235,523$ 2,0320322017,71818,0400.559,988$203,32932,194$ 2,0330424023,74524,1690.5412,992248,515$ 2,0330331018,55118,8820.5410,150$213,47935,036$ 2,0340437024,86125,2980.5213,203261,718$ 2,0340341019,42319,7640.5210,315$223,79437,924$ 2,0350450026,03026,4800.5113,417275,135$ 2,0350352020,33620,6870.5110,482$234,27640,859$ 2,0360464027,25327,7170.4913,635288,770$ 2,0360362021,29121,6540.4910,652$244,92843,842$ 2,0370478028,53429,0110.4813,856302,626$ 2,0370373022,29222,6650.4810,825$255,75346,873$ 2,0380492029,87530,3670.4614,081316,707$ 2,0380384023,34023,7240.4611,001$266,75449,953$ 2,0390507031,27931,7860.4514,310331,016$ 2,0390396024,43724,8330.4511,179$277,93353,083$ 2,0400522032,74933,2710.4414,542345,558$ 2,0400408025,58525,9930.4411,361$289,29456,264$ 2,0410538034,28834,8260.4214,778360,337$ 2,0410420026,78827,2080.4211,545$300,84059,497$ 2,0420554035,90036,4530.4115,018375,355$ 2,0420433028,04728,4790.4111,733$312,57362,782$ Totals:$0$11,177$0$615,626$626,803$375,355=30-year LCCTotals:$19,327$8,732$0$480,958$509,016$312,573=30-year LCC Energy Audit Report April 16, 2012 pg. 45 ECM #5 Calculations Horsepower Motor Loading Efficiency KW Operating Hours/yr Yearly KW Demand Yearly KW Demand Cost Yearly KWH Consumption Yearly KWH Cost Totals Existing 4 80 80 2.98 4380 35.81 $269.28 13,070 $2,143.47 $2,412.74 Proposed 4 50 80 1.87 4380 22.38 $168.30 8,169 $1,339.67 $1,507.96 Savings 13.43 $100.98 4,901 $803.80 $904.78 Installed Cost $7,059.67 Payback (years)7.80 Description of Improvement Replace current Grundfos UP65-160 circulation pumps in original utility room with equivalent permanent magnet, variable speed pump. 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 CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$48-$ $2,413$2,461(1+i)^-nCostsCosts2,012$7,060$30-$ $1,508$1,538(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$7,060------$7,0601.00$7,060$7,0602,01305002,4782,5280.972,4542,453.97$ 2,01303101,5491,5800.971,534$8,593(6,139)$ 2,01405102,5452,5960.942,4474,901$ 2,01403201,5901,6220.941,529$10,123(5,222)$ 2,01505302,6132,6660.922,4407,341$ 2,01503301,6331,6660.921,525$11,648(4,307)$ 2,01605402,6842,7380.892,4339,774$ 2,01603401,6781,7110.891,521$13,168(3,394)$ 2,01705602,7672,8230.862,43512,209$ 2,01703501,7301,7650.861,522$14,690(2,481)$ 2,01805802,8532,9110.842,43814,647$ 2,01803601,7831,8190.841,524$16,214(1,567)$ 2,01905902,9413,0010.812,44017,087$ 2,01903701,8381,8760.811,525$17,739(652)$ 2,02006103,0333,0940.792,44219,529$ 2,02003801,8951,9340.791,526$19,265264$ 2,02106303,1273,1900.772,44521,974$ 2,02103901,9541,9940.771,528$20,7931,180$ 2,02206503,2243,2880.742,44724,421$ 2,02204102,0152,0550.741,529$22,3232,098$ 2,02306703,3243,3900.722,44926,870$ 2,02304202,0772,1190.721,531$23,8533,017$ 2,02406903,4273,4950.702,45229,322$ 2,02404302,1422,1850.701,532$25,3863,936$ 2,02507103,5333,6040.682,45431,775$ 2,02504402,2082,2520.681,534$26,9194,856$ 2,02607303,6423,7150.662,45634,232$ 2,02604602,2762,3220.661,535$28,4555,777$ 2,02707503,8143,8890.642,49636,728$ 2,02704702,3832,4300.641,560$30,0156,713$ 2,02807703,9934,0700.622,53639,264$ 2,02804802,4952,5440.621,585$31,6007,664$ 2,02908004,1804,2600.612,57741,842$ 2,02905002,6132,6630.611,611$33,2118,631$ 2,03008204,3774,4590.592,61944,461$ 2,03005102,7362,7870.591,637$34,8489,613$ 2,03108504,5834,6670.572,66247,123$ 2,03105302,8642,9170.571,664$36,51110,611$ 2,03208704,7984,8850.552,70549,827$ 2,03205402,9993,0530.551,690$38,20211,626$ 2,03309005,0235,1130.542,74952,576$ 2,03305603,1403,1960.541,718$39,92012,656$ 2,03409205,2605,3520.522,79355,369$ 2,03405803,2873,3450.521,746$41,66513,704$ 2,03509505,5075,6020.512,83958,208$ 2,03506003,4423,5010.511,774$43,43914,768$ 2,03609805,7665,8640.492,88561,092$ 2,03606103,6043,6650.491,803$45,24215,850$ 2,037010106,0376,1380.482,93164,024$ 2,03706303,7733,8360.481,832$47,07416,949$ 2,038010406,3206,4240.462,97967,003$ 2,03806503,9504,0150.461,862$48,93618,066$ 2,039010706,6176,7250.453,02770,030$ 2,03906704,1364,2030.451,892$50,82819,202$ 2,040011006,9287,0390.443,07673,106$ 2,04006904,3304,3990.441,923$52,75120,355$ 2,041011407,2547,3680.423,12676,233$ 2,04107104,5344,6050.421,954$54,70521,528$ 2,042011707,5957,7120.413,17779,410$ 2,04207304,7474,8200.411,986$56,69122,719$ Totals:$0$2,365$0$130,242$132,606$79,410=30-year LCCTotals:$7,060$1,478$0$81,401$89,939$56,691=30-year LCC Energy Audit Report April 16, 2012 pg. 47 ECM #6 Calculations Horsepower Motor Loading Efficiency KW Operating Hours/yr Yearly KW Demand Yearly KW Demand Cost Yearly KWH Consumption Yearly KWH Cost Totals Existing 5 70 78.5 3.33 4380 39.91 $300.15 14,568 $2,389.21 $2,689.36 Proposed 5 70 89.5 2.92 4380 35.01 $263.26 12,778 $2,095.57 $2,358.83 Savings 4.91 $36.89 1,791 $293.65 $330.54 Installed Cost $2,743.62 Payback (years)8.30 Description of Improvement Motor #2 Replace 5hp air handler motor in original utility room with minimum 89.5% efficient motor. 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$54-$ $2,689$2,743(1+i)^-nCostsCosts2,012$2,744$47-$ $2,359$2,406(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$2,744------$2,7441.00$2,744$2,7442,01305502,7622,8170.972,7352,735.32$ 2,01304902,4232,4710.972,399$5,143(2,407)$ 2,01405702,8372,8940.942,7285,463$ 2,01405002,4882,5380.942,392$7,535(2,072)$ 2,01505902,9132,9720.922,7208,183$ 2,01505202,5552,6070.922,385$9,920(1,738)$ 2,01606102,9923,0520.892,71210,894$ 2,01605302,6242,6770.892,379$12,299(1,405)$ 2,01706203,0853,1470.862,71513,609$ 2,01705502,7052,7600.862,381$14,680(1,071)$ 2,01806403,1803,2440.842,71716,326$ 2,01805602,7892,8460.842,383$17,063(737)$ 2,01906603,2793,3450.812,72019,046$ 2,01905802,8762,9340.812,385$19,449(403)$ 2,02006803,3803,4490.792,72221,768$ 2,02006002,9653,0250.792,388$21,836(68)$ 2,02107003,4853,5550.772,72524,493$ 2,02106203,0573,1180.772,390$24,226267$ 2,02207203,5933,6660.742,72727,221$ 2,02206303,1523,2150.742,392$26,619602$ 2,02307403,7053,7790.722,73029,951$ 2,02306503,2493,3150.722,395$29,013937$ 2,02407703,8193,8960.702,73332,683$ 2,02406703,3503,4170.702,397$31,4101,273$ 2,02507903,9384,0170.682,73535,419$ 2,02506903,4543,5230.682,399$33,8091,609$ 2,02608104,0604,1410.662,73838,156$ 2,02607103,5613,6320.662,401$36,2101,946$ 2,02708404,2514,3350.642,78240,939$ 2,02707303,7283,8020.642,440$38,6512,288$ 2,02808604,4514,5370.622,82743,766$ 2,02807603,9043,9790.622,480$41,1302,635$ 2,02908904,6604,7490.612,87346,639$ 2,02907804,0874,1650.612,520$43,6502,989$ 2,03009204,8794,9700.592,92049,558$ 2,03008004,2794,3590.592,561$46,2113,347$ 2,03109405,1085,2020.572,96752,525$ 2,03108304,4804,5630.572,602$48,8133,712$ 2,03209705,3485,4450.553,01555,540$ 2,03208504,6914,7760.552,644$51,4574,083$ 2,033010005,5995,7000.543,06458,604$ 2,03308804,9114,9990.542,687$54,1454,459$ 2,034010305,8635,9660.523,11361,717$ 2,03409005,1425,2320.522,731$56,8754,842$ 2,035010606,1386,2440.513,16464,881$ 2,03509305,3845,4770.512,775$59,6515,231$ 2,036010906,4276,5360.493,21568,096$ 2,03609605,6375,7330.492,820$62,4715,626$ 2,037011306,7296,8410.483,26771,364$ 2,03709905,9026,0000.482,866$65,3366,027$ 2,038011607,0457,1610.463,32074,684$ 2,038010206,1796,2810.462,912$68,2496,435$ 2,039011907,3767,4960.453,37478,059$ 2,039010506,4706,5740.452,960$71,2096,850$ 2,040012307,7237,8460.443,42981,488$ 2,040010806,7746,8820.443,008$74,2167,272$ 2,041012708,0868,2120.423,48584,973$ 2,041011107,0927,2030.423,057$77,2737,700$ 2,042013108,4668,5960.413,54288,514$ 2,042011507,4257,5400.413,106$80,3798,135$ Totals:$0$2,636$0$145,174$147,810$88,514=30-year LCCTotals:$2,744$2,312$0$127,331$132,387$80,379=30-year LCCwith No ChangeImprovement Cost Energy Audit Report April 16, 2012 pg. 49 ECM #7 Calculations Component Framed Section Insulated Section Component Framed Section Insulated Section Air Film 0.61 0.61 Air Film 0.61 0.61 Decking 0.5 0.5 Decking 0.5 0.5 2" EPS 8 8 2" EPS 8 8 Decking 0.5 0.5 Decking 0.5 0.5 Roof Covering 0.5 0.5 Roof Covering 0.5 0.5 Air Film 0.17 0.17 Air Film 0.17 0.17 2.25" Urethane Foam Board 16 16 Total R-Values 10.28 10.28 Total R-Values 26.28 26.28 Total U-Values 0.0973 0.0973 Total U-Values 0.0381 0.0381 Percentage of Framing 0.00%100.00%Percentage of Framing 0.00%100.00% Composite U-Value of Assembly 0.0973 Composite U-Value of Assembly 0.0381 Skylight U-value Skylight U-value Ceiling Square Footage 8100 Ceiling Square Footage 8100 Skylight Square Footage Skylight Square Footage Opaque Ceiling Area 8100 Opaque Ceiling Area 8100 Composite U-value for entire assembly 0.0973 Composite U-value for entire assembly 0.0381 Composite R-Value for entire assembly 10.2800 Composite R-Value for entire assembly 26.2800 Heating System Served System 1 Heating System Served System 1 Heat Loss in BTU/h 27341.44 Heat Loss in BTU/h 10695.21 Original Heating System Proposed Heating System Savings - Original Heating System Savings - Proposed Heating System Yearly Cost $3,028.84 Yearly Cost $1,184.80 $997.72 $1,844.04 $1,552.88 Cost of Proposed Upgrade $27,215.78 Assembly 1 Assembly 1 Ceiling - ProposedCeiling - Original 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 CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2012$03,029$ $0$3,029(1+i)^-nCostsCosts2012$27,216$01,185$ $0$1,185(1+i)^-nCostsCosts2012$0------$01.00$0-$ 2012$27,216------$27,2161.00$27,216$27,216201303,06803,0680.972,979########2013001,20001,2000.971,165$28,381(25,402)$ 2014003,10803,1080.942,9305,909$ 2014001,21601,2160.941,146$29,527(23,619)$ 2015003,14903,1490.922,8818,790$ 2015001,23201,2320.921,127$30,654(21,864)$ 2016003,18903,1890.892,83411,624$ 2016001,24801,2480.891,108$31,763(20,139)$ 2017003,39703,3970.862,93014,554$ 2017001,32901,3290.861,146$32,909(18,355)$ 2018003,61803,6180.843,03017,583$ 2018001,41501,4150.841,185$34,094(16,511)$ 2019003,85303,8530.813,13320,716$ 2019001,50701,5070.811,225$35,319(14,603)$ 2020004,10304,1030.793,23923,955$ 2020001,60501,6050.791,267$36,586(12,631)$ 2021004,37004,3700.773,34927,304$ 2021001,70901,7090.771,310$37,896(10,592)$ 2022004,65404,6540.743,46330,767$ 2022001,82001,8200.741,355$39,251(8,484)$ 2023004,95604,9560.723,58134,347$ 2023001,93901,9390.721,401$40,652(6,304)$ 2024005,27805,2780.703,70238,050$ 2024002,06502,0650.701,448$42,100(4,050)$ 2025005,62205,6220.683,82841,878$ 2025002,19902,1990.681,497$43,597(1,719)$ 2026005,98705,9870.663,95845,836$ 2026002,34202,3420.661,548$45,145690$ 2027006,60406,6040.644,23950,074$ 2027002,58302,5830.641,658$46,8043,271$ 2028007,28407,2840.624,53954,614$ 2028002,84902,8490.621,776$48,5796,034$ 2029008,03408,0340.614,86159,474$ 2029003,14303,1430.611,901$50,4808,994$ 2030008,86208,8620.595,20564,680$ 2030003,46603,4660.592,036$52,51712,163$ 2031009,77409,7740.575,57470,254$ 2031003,82303,8230.572,180$54,69715,557$ 20320010,781010,7810.555,96976,223$ 2032004,21704,2170.552,335$57,03219,191$ 20330011,892011,8920.546,39282,615$ 2033004,65204,6520.542,500$59,53323,083$ 20340013,116013,1160.526,84589,461$ 2034005,13105,1310.522,678$62,21027,250$ 20350014,467014,4670.517,33096,791$ 2035005,65905,6590.512,867$65,07831,713$ 20360015,957015,9570.497,850104,641$ 2036006,24206,2420.493,071$68,14836,493$ 20370017,601017,6010.488,406113,047$ 2037006,88506,8850.483,288$71,43741,611$ 20380019,414019,4140.469,002122,050$ 2038007,59407,5940.463,521$74,95847,091$ 20390021,414021,4140.459,640131,690$ 2039008,37608,3760.453,771$78,72952,961$ 20400023,619023,6190.4410,323142,013$ 2040009,23909,2390.444,038$82,76759,246$ 20410026,052026,0520.4211,055153,068$ 20410010,191010,1910.424,324$87,09265,977$ 20420028,735028,7350.4111,839164,907$ 20420011,240011,2400.414,631$91,72373,184$ Totals:$0$0$301,958$0$301,958$164,907=30-year LCCTotals:$27,216$0$118,118$0$145,333$91,723=30-year LCC Energy Audit Report April 16, 2012 pg. 51 ECM #8 Calculations Horsepower Motor Loading Efficiency KW Operating Hours/yr Yearly KW Demand Yearly KW Demand Cost Yearly KWH Consumption Yearly KWH Cost Totals Existing 5 70 82.5 3.16 4380 37.98 $285.60 13,862 $2,273.37 $2,558.97 Proposed 5 70 89.5 2.92 4380 35.01 $263.26 12,778 $2,095.57 $2,358.83 Savings 2.97 $22.34 1,084 $177.81 $200.14 Installed Cost $2,743.62 Payback (years)13.71 Description of Improvement Motor #3 Replace 5hp air handler motor in classrooms addition utility room with minimum 89.5% efficient motor. 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 CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$51-$ $2,559$2,610(1+i)^-nCostsCosts2,012$2,744$47-$ $2,359$2,406(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$2,744------$2,7441.00$2,744$2,7442,01305302,6282,6810.972,6032,602.70$ 2,01304902,4232,4710.972,399$5,143(2,540)$ 2,01405402,6992,7530.942,5955,198$ 2,01405002,4882,5380.942,392$7,535(2,337)$ 2,01505602,7722,8280.922,5887,786$ 2,01505202,5552,6070.922,385$9,920(2,135)$ 2,01605802,8472,9040.892,58010,366$ 2,01605302,6242,6770.892,379$12,299(1,933)$ 2,01705902,9352,9940.862,58312,949$ 2,01705502,7052,7600.862,381$14,680(1,731)$ 2,01806103,0263,0870.842,58515,535$ 2,01805602,7892,8460.842,383$17,063(1,529)$ 2,01906303,1203,1830.812,58818,122$ 2,01905802,8762,9340.812,385$19,449(1,326)$ 2,02006503,2163,2810.792,59020,713$ 2,02006002,9653,0250.792,388$21,836(1,124)$ 2,02106703,3163,3830.772,59323,305$ 2,02106203,0573,1180.772,390$24,226(921)$ 2,02206903,4193,4880.742,59525,901$ 2,02206303,1523,2150.742,392$26,619(718)$ 2,02307103,5253,5960.722,59828,498$ 2,02306503,2493,3150.722,395$29,013(515)$ 2,02407303,6343,7070.702,60031,099$ 2,02406703,3503,4170.702,397$31,410(311)$ 2,02507503,7473,8220.682,60333,701$ 2,02506903,4543,5230.682,399$33,809(108)$ 2,02607703,8633,9400.662,60536,306$ 2,02607103,5613,6320.662,401$36,21096$ 2,02708004,0454,1240.642,64738,954$ 2,02707303,7283,8020.642,440$38,651303$ 2,02808204,2354,3170.622,69041,644$ 2,02807603,9043,9790.622,480$41,130513$ 2,02908504,4344,5180.612,73444,377$ 2,02907804,0874,1650.612,520$43,650727$ 2,03008704,6424,7290.592,77847,155$ 2,03008004,2794,3590.592,561$46,211945$ 2,03109004,8604,9500.572,82349,978$ 2,03108304,4804,5630.572,602$48,8131,165$ 2,03209205,0895,1810.552,86952,847$ 2,03208504,6914,7760.552,644$51,4571,390$ 2,03309505,3285,4230.542,91555,762$ 2,03308804,9114,9990.542,687$54,1451,618$ 2,03409805,5785,6760.522,96258,725$ 2,03409005,1425,2320.522,731$56,8751,849$ 2,035010105,8415,9420.513,01161,735$ 2,03509305,3845,4770.512,775$59,6512,085$ 2,036010406,1156,2190.493,05964,795$ 2,03609605,6375,7330.492,820$62,4712,324$ 2,037010706,4026,5100.483,10967,904$ 2,03709905,9026,0000.482,866$65,3362,567$ 2,038011006,7036,8140.463,16071,063$ 2,038010206,1796,2810.462,912$68,2492,814$ 2,039011407,0187,1320.453,21174,274$ 2,039010506,4706,5740.452,960$71,2093,066$ 2,040011707,3487,4650.443,26377,537$ 2,040010806,7746,8820.443,008$74,2163,321$ 2,041012107,6947,8140.423,31680,853$ 2,041011107,0927,2030.423,057$77,2733,580$ 2,042012408,0558,1800.413,37084,223$ 2,042011507,4257,5400.413,106$80,3793,844$ Totals:$0$2,508$0$138,135$140,643$84,223=30-year LCCTotals:$2,744$2,312$0$127,331$132,387$80,379=30-year LCCwith No ChangeImprovement Cost Energy Audit Report April 16, 2012 pg. 53 ECM #9 Calculations Horsepower Motor Loading Efficiency KW Operating Hours/yr Yearly KW Demand Yearly KW Demand Cost Yearly KWH Consumption Yearly KWH Cost Totals Existing 3 70 82.5 1.90 4380 22.79 $171.36 8,317 $1,364.02 $1,535.38 Proposed 3 70 89.5 1.75 4380 21.00 $157.96 7,667 $1,257.34 $1,415.30 Savings 1.78 $13.40 651 $106.68 $120.09 Installed Cost $1,977.36 Payback (years)16.47 Description of Improvement Motor #4 Replace 3hp air handler motor in classroom addition utility room with minimum 89.5% efficient motor. Nameplate efficiency not avaliable, original motor efficiency estimated. 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 CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$31-$ $1,535$1,566(1+i)^-nCostsCosts2,012$1,977$28-$ $1,415$1,444(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$1,977------$1,9771.00$1,977$1,9772,01303201,5771,6080.971,5621,561.62$ 2,01302901,4541,4830.971,439$3,417(1,855)$ 2,01403301,6191,6520.941,5573,119$ 2,01403001,4931,5230.941,435$4,852(1,733)$ 2,01503401,6631,6970.921,5534,671$ 2,01503101,5331,5640.921,431$6,283(1,612)$ 2,01603501,7081,7430.891,5486,220$ 2,01603201,5741,6060.891,427$7,711(1,491)$ 2,01703601,7611,7970.861,5507,770$ 2,01703301,6231,6560.861,429$9,139(1,370)$ 2,01803701,8161,8520.841,5519,321$ 2,01803401,6741,7070.841,430$10,569(1,248)$ 2,01903801,8721,9100.811,55310,873$ 2,01903501,7251,7600.811,431$12,000(1,127)$ 2,02003901,9301,9690.791,55412,428$ 2,02003601,7791,8150.791,433$13,433(1,005)$ 2,02104001,9902,0300.771,55613,983$ 2,02103701,8341,8710.771,434$14,867(884)$ 2,02204102,0512,0930.741,55715,540$ 2,02203801,8911,9290.741,435$16,302(762)$ 2,02304302,1152,1570.721,55917,099$ 2,02303901,9501,9890.721,437$17,739(640)$ 2,02404402,1812,2240.701,56018,659$ 2,02404002,0102,0500.701,438$19,177(518)$ 2,02504502,2482,2930.681,56220,221$ 2,02504202,0722,1140.681,439$20,617(396)$ 2,02604602,3182,3640.661,56321,784$ 2,02604302,1372,1790.661,441$22,057(274)$ 2,02704802,4272,4750.641,58823,372$ 2,02704402,2372,2810.641,464$23,522(149)$ 2,02804902,5412,5900.621,61424,986$ 2,02804502,3422,3880.621,488$25,009(23)$ 2,02905102,6602,7110.611,64026,626$ 2,02904702,4522,4990.611,512$26,521105$ 2,03005202,7852,8380.591,66728,293$ 2,03004802,5672,6160.591,536$28,058236$ 2,03105402,9162,9700.571,69429,987$ 2,03105002,6882,7380.571,561$29,619368$ 2,03205503,0533,1090.551,72131,708$ 2,03205102,8142,8660.551,587$31,206503$ 2,03305703,1973,2540.541,74933,457$ 2,03305302,9472,9990.541,612$32,818639$ 2,03405903,3473,4060.521,77735,235$ 2,03405403,0853,1390.521,638$34,456778$ 2,03506103,5043,5650.511,80637,041$ 2,03505603,2303,2860.511,665$36,122920$ 2,03606203,6693,7310.491,83638,877$ 2,03605803,3823,4400.491,692$37,8141,063$ 2,03706403,8413,9060.481,86540,742$ 2,03705903,5413,6000.481,720$39,5331,209$ 2,03806604,0224,0880.461,89642,638$ 2,03806103,7073,7680.461,747$41,2811,357$ 2,03906804,2114,2790.451,92644,564$ 2,03906303,8823,9450.451,776$43,0561,508$ 2,04007004,4094,4790.441,95846,522$ 2,04006504,0644,1290.441,805$44,8611,661$ 2,04107204,6164,6890.421,99048,512$ 2,04106704,2554,3220.421,834$46,6951,817$ 2,04207504,8334,9080.412,02250,534$ 2,04206904,4554,5240.411,864$48,5591,975$ Totals:$0$1,505$0$82,881$84,386$50,534=30-year LCCTotals:$1,977$1,387$0$76,399$79,763$48,559=30-year LCCwith No ChangeImprovement Cost Energy Audit Report April 16, 2012 pg. 55 ECM #10 Calculations Space Description Number of Fixtures 34 34 Lamps per Fixture 1 1 Lamp Type MH T5 Fixture Wattage 446.2 348.1 Hours on per Week 27 27 Cost of New Lamp Cost of New Fixture $573.21 Total KWH Cost $3,493.17 $2,725.17 Total Demand Cost $1,369.01 $1,068.03 Total Yearly Cost $4,862.18 $3,793.20 Yearly Savings $1,068.98 Total Retrofit Cost $19,489.14 Payback Period 18.2 years Gym Retrofit Description Replace existing metal haside lights with T5 Hi Bay lights with 54w lamps and electronic ballasts. 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 CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$97-$ $4,862$4,959(1+i)^-nCostsCosts2,012$19,489$76-$ $3,793$3,869(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$19,489------$19,4891.00$19,489$19,4892,013010004,9935,0940.974,9454,945.26$ 2,01307803,8963,9740.973,858$23,347(18,402)$ 2,014010305,1285,2310.944,9319,876$ 2,01408004,0014,0810.943,847$27,194(17,318)$ 2,015010605,2675,3730.924,91714,793$ 2,01508304,1094,1920.923,836$31,030(16,237)$ 2,016010905,4095,5180.894,90319,696$ 2,01608504,2204,3050.893,825$34,855(15,159)$ 2,017011305,5775,6890.864,90824,604$ 2,01708804,3514,4390.863,829$38,684(14,080)$ 2,018011605,7505,8660.844,91229,517$ 2,01809104,4854,5760.843,832$42,516(13,000)$ 2,019012005,9286,0470.814,91734,434$ 2,01909304,6244,7180.813,836$46,352(11,919)$ 2,020012306,1116,2350.794,92239,355$ 2,02009604,7684,8640.793,840$50,192(10,837)$ 2,021012706,3016,4280.774,92644,282$ 2,02109904,9165,0150.773,843$54,035(9,754)$ 2,022013106,4966,6270.744,93149,213$ 2,022010205,0685,1700.743,847$57,882(8,669)$ 2,023013506,6986,8320.724,93654,149$ 2,023010505,2255,3300.723,851$61,733(7,584)$ 2,024013906,9057,0440.704,94059,089$ 2,024010805,3875,4950.703,854$65,587(6,498)$ 2,025014307,1197,2620.684,94564,034$ 2,025011105,5545,6660.683,858$69,445(5,411)$ 2,026014707,3407,4870.664,95068,984$ 2,026011505,7265,8410.663,862$73,307(4,323)$ 2,027015207,6857,8370.645,03074,014$ 2,027011805,9956,1140.643,924$77,231(3,217)$ 2,028015608,0468,2020.625,11179,125$ 2,028012206,2776,3990.623,988$81,218(2,093)$ 2,029016108,4248,5850.615,19484,320$ 2,029012506,5726,6980.614,052$85,271(951)$ 2,030016608,8208,9860.595,27889,598$ 2,030012906,8817,0100.594,118$89,388210$ 2,031017109,2359,4050.575,36494,962$ 2,031013307,2057,3380.574,185$93,5731,389$ 2,032017609,6699,8450.555,451100,412$ 2,032013707,5437,6800.554,252$97,8252,587$ 2,0330181010,12310,3040.545,539105,951$ 2,033014107,8988,0390.544,321$102,1463,805$ 2,0340186010,59910,7860.525,629111,580$ 2,034014508,2698,4140.524,391$106,5385,043$ 2,0350192011,09711,2890.515,720117,301$ 2,035015008,6588,8070.514,463$111,0006,300$ 2,0360198011,61911,8170.495,813123,114$ 2,036015409,0649,2190.494,535$115,5357,578$ 2,0370204012,16512,3690.485,907129,021$ 2,037015909,4909,6490.484,609$120,1448,877$ 2,0380210012,73712,9460.466,003135,024$ 2,038016409,93710,1000.464,683$124,82710,197$ 2,0390216013,33513,5510.456,101141,125$ 2,0390169010,40410,5720.454,759$129,58711,538$ 2,0400222013,96214,1850.446,200147,325$ 2,0400174010,89211,0660.444,837$134,42312,901$ 2,0410229014,61814,8480.426,301153,625$ 2,0410179011,40411,5830.424,915$139,33914,286$ 2,0420236015,30515,5410.416,403160,028$ 2,0420184011,94012,1250.414,995$144,33415,694$ Totals:$0$4,765$0$262,464$267,230$160,028=30-year LCCTotals:$19,489$3,718$0$204,760$227,967$144,334=30-year LCC Energy Audit Report April 16, 2012 pg. 57 ECM #11 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 N/A Proposed Natural Gas 95.00%70.0 $101,798.75 Heating Data 100 Volume Served 100 Description of Retrofit Boiler Replace existing boilers with 95% AFUE boilers. This ECM is based on savings over the existing boilers already being re-fit to burn natural gas. $17,355.63 Average AFUE of All Heating Systems, proportional to volume 80.00% Heating System Summary $1.01 70 $0.00 95.00% $1.01 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 $101,798.75Estimated Cost of Heating System Replacements New Heating SystemsExisting Heating Systems 20372 17,155.37 Estimated Demand Charges (electric) Estimated Savings per Year $0.00 $20,609.81 $3,254.18 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$41220,610$ $0$21,022(1+i)^-nCostsCosts2,012$101,799$34717,356$ $0$17,703(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$101,799------$101,7991.00$101,799$101,7992,01342520,878021,3020.9720,68220,681.84$ 2,013035817,581017,9390.9717,416$119,215(98,533)$ 2,014043721,149021,5860.9420,34741,029$ 2,014036817,810018,1780.9417,135$136,350(95,320)$ 2,015045021,424021,8750.9220,01861,047$ 2,015037918,041018,4210.9216,857$153,207(92,160)$ 2,016046421,703022,1670.8919,69580,742$ 2,016039118,276018,6670.8916,585$169,792(89,050)$ 2,017047823,113023,5910.8620,350101,092$ 2,017040219,464019,8660.8617,137$186,929(85,837)$ 2,018049224,616025,1080.8421,027122,119$ 2,018041420,729021,1430.8417,707$204,636(82,517)$ 2,019050726,216026,7230.8121,728143,847$ 2,019042722,076022,5030.8118,297$222,933(79,086)$ 2,020052227,920028,4420.7922,452166,300$ 2,020044023,511023,9510.7918,907$241,840(75,541)$ 2,021053829,734030,2720.7723,201189,501$ 2,021045325,040025,4920.7719,538$261,378(71,878)$ 2,022055431,667032,2210.7423,976213,476$ 2,022046626,667027,1340.7420,190$281,568(68,092)$ 2,023057133,726034,2960.7224,776238,252$ 2,023048028,400028,8810.7220,864$302,432(64,180)$ 2,024058835,918036,5050.7025,604263,857$ 2,024049530,246030,7410.7021,561$323,994(60,137)$ 2,025060538,252038,8580.6826,460290,317$ 2,025051032,213032,7220.6822,282$346,276(55,959)$ 2,026062340,739041,3620.6627,345317,662$ 2,026052534,306034,8310.6623,028$369,304(51,642)$ 2,027064244,935045,5770.6429,254346,916$ 2,027054137,840038,3810.6424,635$393,939(47,022)$ 2,028066149,563050,2250.6231,298378,215$ 2,028055741,737042,2940.6226,356$420,295(42,081)$ 2,029068154,668055,3490.6133,487411,702$ 2,029057446,036046,6100.6128,200$448,495(36,793)$ 2,030070260,299061,0010.5935,831447,533$ 2,030059150,778051,3690.5930,174$478,669(31,136)$ 2,031072366,510067,2330.5738,342485,875$ 2,031060956,008056,6170.5732,288$510,957(25,082)$ 2,032074473,360074,1050.5541,030526,905$ 2,032062761,777062,4040.5534,552$545,508(18,603)$ 2,033076780,916081,6830.5443,909570,814$ 2,033064668,140068,7860.5436,976$582,484(11,670)$ 2,034079089,251090,0410.5246,991617,805$ 2,034066575,159075,8240.5239,572$622,056(4,251)$ 2,035081498,444099,2570.5150,293668,098$ 2,035068582,900083,5850.5142,352$664,4083,690$ 2,0360838108,5830109,4210.4953,828721,926$ 2,036070691,439092,1440.4945,329$709,73612,190$ 2,0370863119,7670120,6300.4857,614779,540$ 2,0370727100,8570101,5830.4848,517$758,25321,286$ 2,0380889132,1030132,9920.4661,668841,208$ 2,0380749111,2450111,9940.4651,931$810,18431,024$ 2,0390916145,7100146,6260.4566,009907,217$ 2,0390771122,7030123,4740.4555,587$865,77141,446$ 2,0400943160,7180161,6610.4470,658977,875$ 2,0400794135,3420136,1360.4459,502$925,27352,603$ 2,0410971177,2720178,2430.4275,6371,053,512$ 2,0410818149,2820150,1000.4263,694$988,96764,545$ 2,04201,001195,5310196,5320.4180,9681,134,481$ 2,0420843164,6580165,5000.4168,184$1,057,15177,330$ Totals:$0$20,199$2,054,685$0$2,074,884$1,134,481=30-year LCCTotals:$101,799$17,009$1,730,261$0$1,849,069$1,057,151=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.61 0.61 Air Film 0.61 0.61 Finish Material 0.5 0.5 Finish Material 0.5 0.5 R-19 fiberglass batt 0 19 R-19 fiberglass batt 0 19 8" loose fill fiberglass 17.6 17.6 8" loose fill fiberglass 17.6 17.6 Air Film 0.17 0.17 Air Film 0.17 0.17 Additional 6" loose fill fiberglass 13.2 13.2 Total R-Values 18.88 37.88 Total R-Values 32.08 51.08 Total U-Values 0.0530 0.0264 Total U-Values 0.0312 0.0196 Percentage of Framing 10.00%90.00%Percentage of Framing 10.00%90.00% Composite U-Value of Assembly 0.0291 Composite U-Value of Assembly 0.0207 Skylight U-value Skylight U-value Ceiling Square Footage 16030 Ceiling Square Footage 16030 Skylight Square Footage Skylight Square Footage Opaque Ceiling Area 16030 Opaque Ceiling Area 16030 Composite U-value for entire assembly 0.0291 Composite U-value for entire assembly 0.0207 Composite R-Value for entire assembly 34.4165 Composite R-Value for entire assembly 48.2238 Heating System Served System 1 Heating System Served System 1 Heat Loss in BTU/h 16162.05 Heat Loss in BTU/h 11534.56 Original Heating System Proposed Heating System Savings - Original Heating System Savings - Proposed Heating System Yearly Cost $1,790.40 Yearly Cost $1,277.78 $1,076.02 $512.63 $431.68 Cost of Proposed Upgrade $35,266.00 Ceiling - Original Ceiling - Proposed Assembly 2 Assembly 2 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,790$ $0$1,790(1+i)^-nCostsCosts2012$35,266$01,278$ $0$1,278(1+i)^-nCostsCosts2012$0------$01.00$0-$ 2012$35,266------$35,2661.00$35,266$35,266201301,81401,8140.971,761########2013001,29401,2940.971,257$36,523(34,762)$ 2014001,83701,8370.941,7323,493$ 2014001,31101,3110.941,236$37,759(34,266)$ 2015001,86101,8610.921,7035,196$ 2015001,32801,3280.921,216$38,974(33,778)$ 2016001,88501,8850.891,6756,871$ 2016001,34601,3460.891,195$40,170(33,299)$ 2017002,00802,0080.861,7328,603$ 2017001,43301,4330.861,236$41,406(32,803)$ 2018002,13802,1380.841,79110,394$ 2018001,52601,5260.841,278$42,684(32,290)$ 2019002,27702,2770.811,85212,246$ 2019001,62501,6250.811,322$44,005(31,760)$ 2020002,42502,4250.791,91514,160$ 2020001,73101,7310.791,366$45,372(31,212)$ 2021002,58302,5830.771,98016,140$ 2021001,84301,8430.771,413$46,785(30,645)$ 2022002,75102,7510.742,04718,187$ 2022001,96301,9630.741,461$48,246(30,059)$ 2023002,93002,9300.722,11720,303$ 2023002,09102,0910.721,511$49,756(29,453)$ 2024003,12003,1200.702,18822,492$ 2024002,22702,2270.701,562$51,318(28,826)$ 2025003,32303,3230.682,26324,755$ 2025002,37202,3720.681,615$52,933(28,178)$ 2026003,53903,5390.662,34027,094$ 2026002,52602,5260.661,670$54,603(27,508)$ 2027003,90403,9040.642,50629,600$ 2027002,78602,7860.641,788$56,391(26,791)$ 2028004,30604,3060.622,68332,283$ 2028003,07303,0730.621,915$58,306(26,023)$ 2029004,74904,7490.612,87335,156$ 2029003,38903,3890.612,051$60,356(25,200)$ 2030005,23805,2380.593,07738,233$ 2030003,73803,7380.592,196$62,552(24,319)$ 2031005,77805,7780.573,29541,528$ 2031004,12404,1240.572,352$64,904(23,376)$ 2032006,37306,3730.553,52945,057$ 2032004,54804,5480.552,518$67,422(22,365)$ 2033007,02907,0290.543,77948,835$ 2033005,01705,0170.542,697$70,119(21,284)$ 2034007,75307,7530.524,04652,882$ 2034005,53305,5330.522,888$73,007(20,125)$ 2035008,55208,5520.514,33357,215$ 2035006,10306,1030.513,093$76,099(18,884)$ 2036009,43309,4330.494,64061,855$ 2036006,73206,7320.493,312$79,411(17,556)$ 20370010,404010,4040.484,96966,825$ 2037007,42507,4250.483,546$82,957(16,133)$ 20380011,476011,4760.465,32172,146$ 2038008,19008,1900.463,798$86,755(14,609)$ 20390012,658012,6580.455,69977,844$ 2039009,03409,0340.454,067$90,822(12,978)$ 20400013,962013,9620.446,10283,947$ 2040009,96409,9640.444,355$95,177(11,230)$ 20410015,400015,4000.426,53590,482$ 20410010,991010,9910.424,664$99,841(9,359)$ 20420016,986016,9860.416,99897,480$ 20420012,123012,1230.414,994$104,835(7,356)$ Totals:$0$0$178,493$0$178,493$97,480=30-year LCCTotals:$35,266$0$127,387$0$162,653$104,835=30-year LCC Energy Audit Report April 16, 2012 pg. 61 ECM #13 Calculations Component Framed Section Insulated Section Component Framed Section Insulated Section Concrete Foundation 0.8 0.8 Concrete Foundation 0.8 0.8 EPS Insulation, 2"8 8 EPS Insulation 2"8 8 EPS Insulation, 2"8 8 Total R-Values 8.8 8.8 Total R-Values 16.8 16.8 Total U-Values 0.1136 0.1136 Total U-Values 0.0595 0.0595 Percentage of Framing 0.00%100.00%Percentage of Framing 0.00%100.00% Composite U-Value of Assembly 0.1136 Composite U-Value of Assembly 0.0595 Composite R-Value of Assembly 8.8000 Composite R-Value of Assembly 16.8000 Average Height Of Wall 4 Average Height Of Wall 4 Wall Length 949 Wall Length 949 Distance from Grade to top of wall 0.5 Distance from Grade to top of wall 0.5 Wall Square Footage - Below Grade 3321.5 Wall Square Footage - Below Grade 3321.5 Wall Square Footage - Above Grade 474.5 Wall Square Footage - Above Grade 474.5 Total Square Footage 3796 Total Square Footage 3796 Ground R-Value 7.05 Ground R-Value 7.05 Total Below Ground R-Value 15.8475 Total Below Ground R-Value 23.8475 Total Above Grade R-Value 8.8000 Total Above Grade R-Value 16.8000 Above Grade Heat Loss BTU/h 1,871.04 Above Grade Heat Loss BTU/h 980.07 Below Grade Heat Loss BTU/h 7,272.81 Below Grade Heat Loss BTU/h 4,833.04 Total Below Grade Wall Heat Loss BTU/h 9,143.85 Total Below Grade Wall Heat Loss BTU/h 5,813.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,012.94 Yearly Cost $643.97 $542.29 $368.97 $310.71 Cost of Proposed Upgrade $30,447.64 Below Grade Wall - Original Assembly 1 Below Grade Wall - Proposed Assembly 1 Energy Audit Report April 16, 2012 pg. 62 ---------------------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,013$ $0$1,013(1+i)^-nCostsCosts2012$30,448$0644$ $0$644(1+i)^-nCostsCosts2012$0------$01.00$0-$ 2012$30,448------$30,4481.00$30,448$30,448201301,02601,0260.97996996.22$ 20130065206520.97633$31,081(30,085)$ 2014001,03901,0390.949801,976$ 20140066106610.94623$31,704(29,728)$ 2015001,05301,0530.929642,940$ 20150066906690.92613$32,316(29,377)$ 2016001,06701,0670.899483,887$ 20160067806780.89602$32,919(29,032)$ 2017001,13601,1360.869804,867$ 20170072207220.86623$33,542(28,675)$ 2018001,21001,2100.841,0135,880$ 20180076907690.84644$34,186(28,306)$ 2019001,28801,2880.811,0486,928$ 20190081908190.81666$34,852(27,924)$ 2020001,37201,3720.791,0838,011$ 20200087208720.79689$35,541(27,529)$ 2021001,46101,4610.771,1209,131$ 20210092909290.77712$36,253(27,121)$ 2022001,55601,5560.741,15810,289$ 20220098909890.74736$36,989(26,700)$ 2023001,65801,6580.721,19711,487$ 2023001,05401,0540.72761$37,750(26,263)$ 2024001,76501,7650.701,23812,725$ 2024001,12201,1220.70787$38,537(25,812)$ 2025001,88001,8800.681,28014,005$ 2025001,19501,1950.68814$39,351(25,346)$ 2026002,00202,0020.661,32415,329$ 2026001,27301,2730.66842$40,193(24,864)$ 2027002,20802,2080.641,41816,747$ 2027001,40401,4040.64901$41,094(24,348)$ 2028002,43602,4360.621,51818,265$ 2028001,54901,5490.62965$42,059(23,795)$ 2029002,68702,6870.611,62619,890$ 2029001,70801,7080.611,033$43,093(23,202)$ 2030002,96402,9640.591,74121,631$ 2030001,88401,8840.591,107$44,199(22,568)$ 2031003,26903,2690.571,86423,495$ 2031002,07802,0780.571,185$45,384(21,889)$ 2032003,60603,6060.551,99625,491$ 2032002,29202,2920.551,269$46,654(21,162)$ 2033003,97703,9770.542,13827,629$ 2033002,52802,5280.541,359$48,013(20,383)$ 2034004,38704,3870.522,28929,918$ 2034002,78902,7890.521,455$49,468(19,550)$ 2035004,83804,8380.512,45232,370$ 2035003,07603,0760.511,559$51,027(18,657)$ 2036005,33705,3370.492,62534,995$ 2036003,39303,3930.491,669$52,696(17,700)$ 2037005,88605,8860.482,81137,807$ 2037003,74203,7420.481,787$54,483(16,676)$ 2038006,49306,4930.463,01140,817$ 2038004,12804,1280.461,914$56,397(15,580)$ 2039007,16107,1610.453,22444,041$ 2039004,55304,5530.452,050$58,446(14,405)$ 2040007,89907,8990.443,45247,494$ 2040005,02205,0220.442,195$60,641(13,148)$ 2041008,71308,7130.423,69751,191$ 2041005,53905,5390.422,350$62,992(11,801)$ 2042009,61009,6100.413,95955,150$ 2042006,10906,1090.412,517$65,509(10,359)$ Totals:$0$0$100,985$0$100,985$55,150=30-year LCCTotals:$30,448$0$64,200$0$94,648$65,509=30-year LCC Energy Audit Report April 16, 2012 pg. 63 Cost Data Energy Audit Report April 16, 2012 pg. 64 Energy Audit Report April 16, 2012 pg. 65