The URL can be used to link to this page

Home My WebLink AboutCIRI-IYS-CAEC Wasilla Police Station 2012-EEFINAL ENERGY AUDIT Wasilla Police Department 1800 E. Park Highway Wasilla, AK 99654 ATTN: Archie Giddings 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 19 Benchmark Information 27 Supporting Documentation 33 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 lia bility 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 Wasilla Police Station as part of a contract for: Alaska Housing Finance Corporation City of Wasilla Contact: Rebekah Luhrs Contact: Archie Giddings 4300 Boniface Parkway 290 E. Herning Avenue Anchorage, AK 99510 Wasilla, AK 99654 Email: rluhrs@ahfc.us Email: agiddings@ci.wasilla.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 $33,882.50 Natural Gas $14,019.50 Total $47,902.00 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 10,376 square foot police station. 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 Squad Room - Replace existing recessed incandescent lamps with 18w compact fluorescent lamps. $196 $173 $2,775 $2,971 14.2 2 1417% 2 Dispatch, Dispatch Office - Replace existing lamps in T8 fixtures with 25w lamps.$1,251 $346 $5,533 $6,784 4.4 3 442% 3 Stairwells 1 & 2 - Replace existing lamps in T8 fixtures with 25w lamps.$278 $76 $1,223 $1,501 4.4 3 440% 4 Replace current Grundfos 50-160 circulation pumps with equivalent permanent magnet, variable speed pumps. $5,407 $597 $8,957 $14,364 1.7 6 166% 5 Replace three existing heating systems with three 95% AFUE boilers. This estimate assumes existing heating systems will be replaced over the next 20 years and has annualized that cost. $61,009 $4,770 $95,403 $156,412 1.6 9 156% 6 Upstairs Restrooms - Replace existing lamps in T8 fixtures with 25w lamps.$209 $10 $167 $376 0.8 9 80% 7 Front Hallway, Administration, Upstairs Hallway - Replace existing T12 U-Bend fixtures with T8 U-Bend fixtures w/ 25w lamps and electronic ballasts. $4,061 $145 $2,321 $6,382 0.6 14 57% Total, Cost Effective Measures $72,412 $6,118 $116,379 $188,791 1.6 -161% 8 Entry, Breakroom - Replace existing 4' 3 lamp T12 fixtures with 3 lamp T8 fixtures with 25w lamps and electronic ballasts. $708 ($5)($84)$624 -0.1 19 -12% 9 Gun Room, Server Room, Training Room, IT Office, IT Room, Break Room, Investigation - Replace existing 4' 4 lamp T12 fixtures with 4 lamp T8 fixtures with 25w lamps and electronic ballasts. $14,415 ($120)($1,927)$12,488 -0.1 19 -13% 10 Remove electric domestic hot water tanks and replace with indirect fired boiler mate.$4,562 ($90)($1,354)$3,208 -0.3 21 -30% 11 Youth Court, Interview Room, Administration, Sergeant's Office, Lieutenant's Office, Chief's Office, Front Hallway, Copy Area, Evidence Room, Squad Area, Armory, Upstairs Hallway, Breakroom - Replace existing T12 U-Bend fixtures with T8 U-Bend fixtures with 25w lamps and electronic ballasts. $25,844 ($769)($12,306)$13,538 -0.5 29 -48% 12 Over Dispatch Desks - Replace existing 4' 1 lamp T12 fixtures with 1 lamp T8 fixtures with 25w lamps and electronic ballasts. $675 ($20)($325)$350 -0.5 29 -48% 13 Add 2 inches insulation to exterior of foundation wall.$14,664 ($651)($13,024)$1,640 -0.9 >30 -89% 14 1st Floor Men's/Women's Bath, Evidence Rooms 1 & 2 - Replace existing 4' 4 lamp T12 fixtures with 4 lamp T8 fixtures with 25w lamps and electronic ballasts. $2,621 ($151)($2,417)$204 -0.9 >30 -92% 15 Boiler Room - Replace existing 4' 4 lamp T12 fixtures with 4 lamp T8 fixtures with 25w lamps and electronic ballasts. $1,085 ($67)($1,072)$13 -1.0 >30 -99% Total, All Measures $136,986 $4,244 $83,870 $220,856 0.6 -61% 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 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 Return on Investment (ROI) listed for each ECM is the net savings of the energy conservation measure divided by the installed cost listed. 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 Wasilla Police Department is a 2 story structure that formerly housed a bank. The building is typically staffed by 20 persons during regular business hours and 10 persons on a 24 hour basis. This building is currently served by 2 natural gas fired boilers in series for heat, and one natural gas boiler for snowmelt. Heat is supplied to the building through radiators. Domestic hot water is supplied by 2 stand-alone water heaters. Outside air and air conditioning are controlled through a digital control system and supplied through a packaged air handling system. The building is ventilated and air conditioned by two separate units; one dedicated to the IT room and one serving the remainder of the building. The majority of lighting in the building is fluorescent and high pressure sodium. The building has a significant amount of office equipment that contributes to the electrical cost. 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 Squad Room - Replace existing recessed incandescent lamps with 18w compact fluorescent lamps. $196 $173 $2,775 $2,971 14.2 2 1417% 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 Dispatch, Dispatch Office - Replace existing lamps in T8 fixtures with 25w lamps.$1,251 $346 $5,533 $6,784 4.4 3 442% 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 Stairwells 1 & 2 - Replace existing lamps in T8 fixtures with 25w lamps.$278 $76 $1,223 $1,501 4.4 3 440% Energy Audit Report April 16, 2012 pg. 14 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 4 Replace current Grundfos 50-160 circulation pumps with equivalent permanent magnet, variable speed pumps. $5,407 $597 $8,957 $14,364 1.7 6 166% Energy Audit Report April 16, 2012 pg. 15 This ECM assumes a life expectancy of 20 years for this measure. Boilers should be equipped with outdoor resets to adjust boiler water temperature to outdoor temperature and load. ECM #Improvement Description Installed Cost Annualized NPV Savings NPV Savings Over Improvement Life Breakeven Cost SIR Simple Payback (Years) ROI 5 Replace three existing heating systems with three 95% AFUE boilers. This estimate assumes existing heating systems will be replaced over the next 20 years and has annualized that cost. $61,009 $4,770 $95,403 $156,412 1.6 9 156% Energy Audit Report April 16, 2012 pg. 16 This ECM assumes a life expectancy of 16 years for this measure. ECM #Improvement Description Installed Cost Annualized NPV Savings NPV Savings Over Improvement Life Breakeven Cost SIR Simple Payback (Years) ROI 6 Upstairs Restrooms - Replace existing lamps in T8 fixtures with 25w lamps.$209 $10 $167 $376 0.8 9 80% Energy Audit Report April 16, 2012 pg. 17 This ECM assumes a life expectancy of 16 years for this measure. ECM #Improvement Description Installed Cost Annualized NPV Savings NPV Savings Over Improvement Life Breakeven Cost SIR Simple Payback (Years) ROI 7 Front Hallway, Administration, Upstairs Hallway - Replace existing T12 U-Bend fixtures with T8 U-Bend fixtures w/ 25w lamps and electronic ballasts. $4,061 $145 $2,321 $6,382 0.6 14 57% Energy Audit Report April 16, 2012 pg. 18 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 8 Entry, Breakroom - Replace existing 4' 3 lamp T12 fixtures with 3 lamp T8 fixtures with 25w lamps and electronic ballasts. $708 ($5)($84)$624 -0.1 19 -12% Energy Audit Report April 16, 2012 pg. 19 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 9 Gun Room, Server Room, Training Room, IT Office, IT Room, Break Room, Investigation - Replace existing 4' 4 lamp T12 fixtures with 4 lamp T8 fixtures with 25w lamps and electronic ballasts. $14,415 ($120)($1,927)$12,488 -0.1 19 -13% Energy Audit Report April 16, 2012 pg. 20 This ECM assumes a life expectancy of 15 years for this measure. This measure also assumes that it is done in conjunction with existing boiler. If this ECM is done in conjunction with the proposed boiler noted in ECM # 5 savings will be increased. ECM #Improvement Description Installed Cost Annualized NPV Savings NPV Savings Over Improvement Life Breakeven Cost SIR Simple Payback (Years) ROI 10 Remove electric domestic hot water tanks and replace with indirect fired boiler mate.$4,562 ($90)($1,354)$3,208 -0.3 21 -30% Energy Audit Report April 16, 2012 pg. 21 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 11 Youth Court, Interview Room, Administration, Sergeant's Office, Lieutenant's Office, Chief's Office, Front Hallway, Copy Area, Evidence Room, Squad Area, Armory, Upstairs Hallway, Breakroom - Replace existing T12 U-Bend fixtures with T8 U-Bend fixtures with 25w lamps and electronic ballasts. $25,844 ($769)($12,306)$13,538 -0.5 29 -48% Energy Audit Report April 16, 2012 pg. 22 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 12 Over Dispatch Desks - Replace existing 4' 1 lamp T12 fixtures with 1 lamp T8 fixtures with 25w lamps and electronic ballasts. $675 ($20)($325)$350 -0.5 29 -48% 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.$14,664 ($651)($13,024)$1,640 -0.9 >30 -89% Energy Audit Report April 16, 2012 pg. 24 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 14 1st Floor Men's/Women's Bath, Evidence Rooms 1 & 2 - Replace existing 4' 4 lamp T12 fixtures with 4 lamp T8 fixtures with 25w lamps and electronic ballasts. $2,621 ($151)($2,417)$204 -0.9 >30 -92% Energy Audit Report April 16, 2012 pg. 25 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 15 Boiler Room - Replace existing 4' 4 lamp T12 fixtures with 4 lamp T8 fixtures with 25w lamps and electronic ballasts. $1,085 ($67)($1,072)$13 -1.0 >30 -99% Energy Audit Report April 16, 2012 pg. 26 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. Air Conditioners – Refrigerant levels should be checked on a yearly basis. The Filters and coils should be cleaned/replaced periodically to ensure proper airflow. Dirty filter/coils decrease heat transfer ability and efficiency of the system. Energy Audit Report April 16, 2012 pg. 27 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 more than twice 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. Energy Audit Report April 16, 2012 pg. 28 Electrical usage in terms of BTU per square foot is more than double the national benchmark for similar buildings. This indicates potential for electrical savings and also reflects the continuous usage of the building and the higher than national average kilowatt hour costs. Energy Audit Report April 16, 2012 pg. 29 The natural gas consumption of this building is nearly triple the national average. This is in part due to Alaska’s harsh climate but also shows a potential for energy savings. Energy Audit Report April 16, 2012 pg. 30 The total energy use profile shows the majority of BTUs consumed by the building are from natural gas which is used exclusively for heating. Electrical usage is second. Energy Audit Report April 16, 2012 pg. 31 The energy cost total shows electricity being the majority fuel cost. Electricity is much more expensive per BTU than natural gas. This emphasizes the need to reduce electrical consumption. Energy Audit Report April 16, 2012 pg. 32 Natural gas consumption tracks closely with Heating Degree Days, which are a measure of the heating load imposed by the climate. Energy Audit Report April 16, 2012 pg. 33 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 PFG-7 HWB 390,000 BTU/h 80%N/A In series 20 0 Boiler 2 Utility Room Heating Weil McLain PFG-7 HWB 390,000 BTU/h 80%N/A In series 20 0 Snowmelt Boiler Utility Room Snowmelt Weil McLain PFG-5-PI HWB 204,000 BTU/h 80%N/A Not used in summer 20 0 DHW 1 Utility Room Domestic Hot Water American E61-120- 0153V WH 12 Gal N/A N/A Electric, 1st Floor 15 2 DWH 2 2nd Floor Utility Room Domestic Hot Water Bradford White MIII50T6 DS19 WH 50 Gal N/A N/A Electric, 2nd Floor 15 7 Air Conditioner 1 Rooftop Cooling/Ventilation AAON RN-040-B- 0-BA04- 000 35 Tons 12.2 SEER 27 HP Total Serves entire building 15 7 Air Conditioner 2 Rooftop Cooling/Ventilation Trane YSC060E1 RHA19D0 00000002 00 B 5 Tons 13 SEER Dedicated to IT Room 15 13 Fan Coil Utility Room Heating Dunham Bush H250C Fan Coil N/A N/A .10 HP Never On 20 0 Energy Audit Report April 16, 2012 pg. 34 Benchmark Data Building Designation:Electric Meter #Square footage of conditioned area:10376Gas Meter #Number of billing periods24Year:MonthDays in Billing PeriodElectric KWHElectric Demand KWElectric Cost $/KWHElectric CostDemand CostElectric MMBtu Load Factor% of bill from demandGas Usage ThermsGas Cost $Gas Unit Cost $/ThermGas MMBtuJan-093127,880$0.14$3,797.0095.15#DIV/0!0.0%2,174 $2,280.00$1.05217.40Feb-092823,920$0.14$3,260.0081.64#DIV/0!0.0%2,197 $2,061.00$0.94219.70Mar-092822,840$0.14$3,113.0077.95#DIV/0!0.0%1,985 $1,641.00$0.83198.50Apr-093524,760$0.12$3,063.0084.51#DIV/0!0.0%1,578 $1,600.00$1.01157.80May-092823,280$0.12$2,881.0079.45#DIV/0!0.0%1,522 $858.00$0.56152.20Jun-093224,840$0.12$3,073.0084.78#DIV/0!0.0%858 $389.00$0.4585.80Jul-093124,280$0.12$2,827.0082.87#DIV/0!0.0%365 $176.00$0.4836.50Aug-092922,760$0.12$2,651.0077.68#DIV/0!0.0%159 $473.00$2.9715.90Sep-093223,640$0.12$2,753.0080.68#DIV/0!0.0%443 $703.00$1.5944.30Oct-093021,720$0.11$2,407.0074.13#DIV/0!0.0%669 $1,208.00$1.8166.90Nov-092827,720$0.11$3,069.0094.61#DIV/0!0.0%1,158 $1,797.00$1.55115.80Dec-093525,480$0.11$2,822.0086.96#DIV/0!0.0%1,728 $1,548.00$0.90172.80Jan-102827,840$0.10$2,809.0095.02#DIV/0!0.0%1,771 $1,872.00$1.06177.10Feb-102824,480$0.10$2,471.0083.55#DIV/0!0.0%2,151 $1,246.00$0.58215.10Mar-103530,040$0.10$3,030.00102.53#DIV/0!0.0%1,439 $1,255.00$0.87143.90Apr-102826,480$0.09$2,447.0090.38#DIV/0!0.0%1,433 $925.00$0.65143.30May-102823,080$0.09$2,134.0078.77#DIV/0!0.0%1,053 $440.00$0.42105.30Jun-103529,240$0.09$2,701.0099.80#DIV/0!0.0%493 $281.00$0.5749.30Jul-102827,200$0.09$2,521.0092.83#DIV/0!0.0%309 $292.00$0.9430.90Aug-102829,560$0.09$2,738.00100.89#DIV/0!0.0%322 $379.00$1.1832.20Sep-103528,000$0.09$2,594.0095.56#DIV/0!0.0%337 $648.00$1.9233.70Oct-102827,800$0.10$2,686.0094.88#DIV/0!0.0%673 $872.00$1.3067.30Nov-102831,600$0.10$3,051.00107.85#DIV/0!0.0%952 $1,845.00$1.9495.20Dec-103029,680$0.10$2,867.00101.30#DIV/0!0.0%2,167 $3,250.00$1.50216.70#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00#DIV/0!0.00#DIV/0!#DIV/0!#DIV/0!0.00Montly Average30.2526171.670.00#DIV/0!$2,823.54$0.0089.32#DIV/0!#DIV/0!1164.00$1,168.29#DIV/0!116.40Total726628,120N/AN/A$67,765.00$0.002,143.77N/AN/A27,936.00$28,039.00N/A2793.60Monthly BenchmarkOccupancyPublic Order and Safety ......37.76310640.4664% DifferenceSize10,001 to 100,000 Square Feet236.54%287.65%Energy Use Index Form 1Natural Gas ElectricityWasilla Police Station Energy Audit Report April 16, 2012 pg. 35 HDDCCDProductionBtu/Sq. FtCost $/Sq Ft1650030,123$0.591400029,042$0.511324026,643$0.46840023,353$0.45479422,326$0.363381116,440$0.331863611,504$0.2932659,019$0.30507012,045$0.33782013,592$0.351422020,278$0.471497025,035$0.421512026,226$0.451071028,783$0.361145023,750$0.41800022,521$0.325021217,740$0.25358214,369$0.29310511,925$0.27312312,827$0.30519012,458$0.31856015,630$0.341226019,569$0.471757030,647$0.590$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.00586.643.250.0019,827$0.3821119.0078.000.00475,846$9.236,792291.93%EUI Energy Audit Report April 16, 2012 pg. 36 Climate & Fuel Assumptions Client Name:Wasilla Police Station Address: Square Footage 10376 Days Occupied per Year State HDD CDD Avg. Temp 365 Alaska 10,254 1 36.8 Fuels Natural Gas $1.00 $ Per CCF $0.97 Per Therm Oil $ Per Gallon $0.00 Per Therm Electricity $0.11 $ per KWH $3.22 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 $0.00 Kw/Month City Wasilla 3 S Energy Audit Report April 16, 2012 pg. 37 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. 38 ECM #1 Calculations Space Description Number of Fixtures 10 10 Lamps per Fixture 1 1 Lamp Type Halogen PAR 30 CFL Fixture Wattage 75 18 Hours on per Week 56 56 Cost of New Lamp $19.58 Cost of New Fixture Total KWH Cost $240.24 $57.66 Total Demand Cost $0.00 $0.00 Total Yearly Cost $240.24 $57.66 Yearly Savings $182.58 Total Retrofit Cost $195.80 Payback Period 1.1 years Retrofit Description Replace existing recessed incandescent lamps in the squad room with 18w compact fluorescent lamps. Squad Room Energy Audit Report April 16, 2012 pg. 39 ---------------------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-$ $240$245(1+i)^-nCostsCosts2,012$196$1-$ $58$59(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$196------$1961.00$196$1962,0130502472520.97244244.35$ 2,01301059600.9759$254(10)$ 2,0140502532580.94244488$ 2,01401061620.9458$313175$ 2,0150502602650.92243731$ 2,01501062640.9258$371360$ 2,0160502672730.89242973$ 2,01601064650.8958$429544$ 2,0170602762810.862421,216$ 2,01701066670.8658$488728$ 2,0180602842900.842431,458$ 2,01801068700.8458$546913$ 2,0190602932990.812431,701$ 2,01901070720.8158$6041,097$ 2,0200603023080.792431,945$ 2,02001072740.7958$6621,282$ 2,0210603113180.772432,188$ 2,02102075760.7758$7211,467$ 2,0220603213270.742442,432$ 2,02202077790.7458$7791,652$ 2,0230703313380.722442,675$ 2,02302079810.7259$8381,838$ 2,0240703413480.702442,920$ 2,02402082840.7059$8972,023$ 2,0250703523590.682443,164$ 2,02502084860.6859$9552,209$ 2,0260703633700.662453,408$ 2,02602087890.6659$1,0142,395$ 2,0270703803870.642493,657$ 2,02702091930.6460$1,0732,584$ 2,0280803984050.622533,910$ 2,02802095970.6261$1,1342,775$ 2,0290804164240.612574,166$ 2,0290201001020.6162$1,1962,971$ 2,0300804364440.592614,427$ 2,0300201051070.5963$1,2583,169$ 2,0310804564650.572654,692$ 2,0310201101120.5764$1,3223,370$ 2,0320904784860.552694,961$ 2,0320201151170.5565$1,3873,575$ 2,0330905005090.542745,235$ 2,0330201201220.5466$1,4523,783$ 2,0340905245330.522785,513$ 2,0340201261280.5267$1,5193,994$ 2,0350905485580.512835,796$ 2,0350201321340.5168$1,5874,209$ 2,03601005745840.492876,083$ 2,0360201381400.4969$1,6564,427$ 2,03701006016110.482926,375$ 2,0370201441470.4870$1,7264,649$ 2,03801006296400.462976,672$ 2,0380201511540.4671$1,7974,875$ 2,03901106596700.453016,973$ 2,0390301581610.4572$1,8695,104$ 2,04001106907010.443067,279$ 2,0400301661680.4474$1,9435,336$ 2,04101107227340.423117,591$ 2,0410301731760.4275$2,0185,573$ 2,04201207567680.413167,907$ 2,0420301811840.4176$2,0935,813$ Totals:$0$235$0$12,968$13,204$7,907=30-year LCCTotals:$196$57$0$3,112$3,365$2,093=30-year LCC Energy Audit Report April 16, 2012 pg. 40 ECM #2 Calculations Space Description Number of Fixtures 18 18 Lamps per Fixture 4 4 Lamp Type 4' T8 4' T8 Fixture Wattage 115.1 91 Hours on per Week 168 168 Cost of New Lamp $17.38 Cost of New Fixture Total KWH Cost $1,990.92 $1,574.05 Total Demand Cost $0.00 $0.00 Total Yearly Cost $1,990.92 $1,574.05 Yearly Savings $416.86 Total Retrofit Cost $1,251.36 Payback Period 3.0 years Retrofit Description Replace existing lamps in T8 fixtures with 25w lamps. Dispatch, Dispatch Office Energy Audit Report April 16, 2012 pg. 41 ---------------------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$40-$ $1,991$2,031(1+i)^-nCostsCosts2,012$1,251$31-$ $1,574$1,606(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$1,251------$1,2511.00$1,251$1,2512,01304102,0452,0860.972,0252,024.94$ 2,01303201,6171,6490.971,601$2,852(827)$ 2,01404202,1002,1420.942,0194,044$ 2,01403301,6601,6940.941,596$4,449(405)$ 2,01504402,1572,2000.922,0136,057$ 2,01503401,7051,7390.921,592$6,04117$ 2,01604502,2152,2600.892,0088,065$ 2,01603501,7511,7860.891,587$7,628437$ 2,01704602,2832,3300.862,01010,075$ 2,01703601,8051,8420.861,589$9,217858$ 2,01804802,3542,4020.842,01112,086$ 2,01803801,8611,8990.841,590$10,8071,279$ 2,01904902,4272,4760.812,01314,100$ 2,01903901,9191,9580.811,592$12,3991,701$ 2,02005002,5022,5530.792,01516,115$ 2,02004001,9782,0180.791,593$13,9922,123$ 2,02105202,5802,6320.772,01718,132$ 2,02104102,0402,0810.771,595$15,5872,545$ 2,02205402,6602,7140.742,01920,151$ 2,02204202,1032,1450.741,596$17,1832,968$ 2,02305502,7422,7980.722,02122,172$ 2,02304402,1682,2120.721,598$18,7813,391$ 2,02405702,8282,8840.702,02324,195$ 2,02404502,2352,2800.701,599$20,3803,815$ 2,02505802,9152,9740.682,02526,220$ 2,02504602,3052,3510.681,601$21,9814,239$ 2,02606003,0063,0660.662,02728,247$ 2,02604802,3762,4240.661,602$23,5844,663$ 2,02706203,1473,2090.642,06030,307$ 2,02704902,4882,5370.641,628$25,2125,094$ 2,02806403,2953,3590.622,09332,400$ 2,02805102,6052,6550.621,655$26,8675,533$ 2,02906603,4503,5150.612,12734,526$ 2,02905202,7272,7790.611,682$28,5485,978$ 2,03006803,6123,6790.592,16136,688$ 2,03005402,8552,9090.591,709$30,2576,430$ 2,03107003,7813,8510.572,19638,884$ 2,03105502,9903,0450.571,736$31,9946,890$ 2,03207203,9594,0310.552,23241,116$ 2,03205703,1303,1870.551,765$33,7587,358$ 2,03307404,1454,2190.542,26843,384$ 2,03305903,2773,3360.541,793$35,5517,833$ 2,03407604,3404,4160.522,30545,689$ 2,03406003,4313,4920.521,822$37,3748,315$ 2,03507904,5444,6230.512,34248,031$ 2,03506203,5933,6550.511,852$39,2268,806$ 2,03608104,7584,8390.492,38050,411$ 2,03606403,7613,8250.491,882$41,1079,304$ 2,03708304,9815,0650.482,41952,830$ 2,03706603,9384,0040.481,912$43,0209,810$ 2,03808605,2155,3010.462,45855,288$ 2,03806804,1234,1910.461,943$44,96310,325$ 2,03908805,4605,5490.452,49857,786$ 2,03907004,3174,3870.451,975$46,93810,848$ 2,04009105,7175,8080.442,53960,325$ 2,04007204,5204,5920.442,007$48,94511,380$ 2,04109405,9866,0800.422,58062,905$ 2,04107404,7324,8070.422,040$50,98511,920$ 2,04209706,2676,3640.412,62265,527$ 2,04207604,9555,0310.412,073$53,05812,469$ Totals:$0$1,951$0$107,471$109,423$65,527=30-year LCCTotals:$1,251$1,543$0$84,969$87,763$53,058=30-year LCC Energy Audit Report April 16, 2012 pg. 42 ECM #3 Calculations Space Description Number of Fixtures 8 8 Lamps per Fixture 2 2 Lamp Type 4' T8 4' T8 Fixture Wattage 57.5 45.5 Hours on per Week 168 168 Cost of New Lamp $17.38 Cost of New Fixture Total KWH Cost $442.04 $349.79 Total Demand Cost $0.00 $0.00 Total Yearly Cost $442.04 $349.79 Yearly Savings $92.25 Total Retrofit Cost $278.08 Payback Period 3.0 years Stairwells 1 and 2 Retrofit Description Replace existing lamps in T8 fixtures with 25w lamps. Energy Audit Report April 16, 2012 pg. 43 ---------------------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-$ $442$451(1+i)^-nCostsCosts2,012$278$7-$ $350$357(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$278------$2781.00$278$2782,0130904544630.97450449.59$ 2,0130703593660.97356$634(184)$ 2,0140904664760.94448898$ 2,0140703693760.94355$989(91)$ 2,01501004794880.924471,345$ 2,0150803793870.92354$1,3423$ 2,01601004925020.894461,791$ 2,0160803893970.89353$1,69596$ 2,01701005075170.864462,237$ 2,0170804014090.86353$2,048189$ 2,01801105235330.844472,683$ 2,0180804144220.84353$2,402282$ 2,01901105395500.814473,131$ 2,0190904264350.81354$2,755375$ 2,02001105565670.794473,578$ 2,0200904404490.79354$3,109469$ 2,02101205735840.774484,026$ 2,0210904534620.77354$3,464562$ 2,02201205916020.744484,474$ 2,0220904674770.74355$3,818656$ 2,02301206096210.724494,923$ 2,02301004824920.72355$4,174749$ 2,02401306286400.704495,372$ 2,02401004975070.70355$4,529843$ 2,02501306476600.684505,822$ 2,02501005125220.68356$4,885937$ 2,02601306676810.664506,272$ 2,02601105285390.66356$5,2411,031$ 2,02701406997120.644576,729$ 2,02701105535640.64362$5,6031,126$ 2,02801407327460.624657,194$ 2,02801105795900.62368$5,9701,223$ 2,02901507667810.614727,666$ 2,02901206066180.61374$6,3441,322$ 2,03001508028170.594808,146$ 2,03001206356460.59380$6,7241,422$ 2,03101608408550.574888,633$ 2,03101206646770.57386$7,1101,524$ 2,03201608798950.554969,129$ 2,03201306967080.55392$7,5021,627$ 2,03301609209370.545049,633$ 2,03301307287410.54398$7,9001,732$ 2,03401709649810.5251210,144$ 2,03401307637760.52405$8,3051,839$ 2,03501701,0091,0260.5152010,664$ 2,03501407988120.51412$8,7171,948$ 2,03601801,0561,0740.4952811,193$ 2,03601408368500.49418$9,1352,058$ 2,03701901,1061,1240.4853711,730$ 2,03701508758900.48425$9,5602,170$ 2,03801901,1581,1770.4654612,276$ 2,03801509169310.46432$9,9922,284$ 2,03902001,2121,2320.4555512,830$ 2,03901609599750.45439$10,4312,400$ 2,04002001,2691,2900.4456413,394$ 2,04001601,0041,0200.44446$10,8772,517$ 2,04102101,3291,3500.4257313,967$ 2,04101601,0521,0680.42453$11,3302,637$ 2,04202101,3911,4130.4158214,549$ 2,04201701,1011,1180.41461$11,7912,758$ Totals:$0$433$0$23,862$24,295$14,549=30-year LCCTotals:$278$343$0$18,882$19,503$11,791=30-year LCC Energy Audit Report April 16, 2012 pg. 44 ECM #4 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 85 80 2.38 8760 28.53 $0.00 20,830 $2,291.32 $2,291.32 Proposed 3 50 80 1.40 8760 16.79 $0.00 12,253 $1,347.84 $1,347.84 Savings 11.75 $0.00 8,577 $943.48 $943.48 Installed Cost $5,405.27 Payback (years)5.73 Description of Improvement Replace current Grundfos 50-160 circulation pumps with equivalent permanent magnet, variable speed pumps. Energy Audit Report April 16, 2012 pg. 45 ---------------------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$46-$ $2,291$2,337(1+i)^-nCostsCosts2,012$5,405$27-$ $1,348$1,375(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$5,405------$5,4051.00$5,405$5,4052,01304702,3532,4000.972,3302,330.47$ 2,01302801,3841,4120.971,371$6,776(4,446)$ 2,01404902,4172,4650.942,3244,654$ 2,01402901,4221,4500.941,367$8,143(3,489)$ 2,01505002,4822,5320.922,3176,971$ 2,01502901,4601,4890.921,363$9,506(2,535)$ 2,01605202,5492,6010.892,3119,282$ 2,01603001,4991,5300.891,359$10,865(1,583)$ 2,01705302,6282,6810.862,31311,595$ 2,01703101,5461,5770.861,360$12,226(631)$ 2,01805502,7092,7640.842,31513,910$ 2,01803201,5941,6260.841,362$13,587322$ 2,01905602,7932,8500.812,31716,227$ 2,01903301,6431,6760.811,363$14,9511,276$ 2,02005802,8802,9380.792,31918,546$ 2,02003401,6941,7280.791,364$16,3152,231$ 2,02106002,9693,0290.772,32220,868$ 2,02103501,7471,7820.771,366$17,6813,187$ 2,02206203,0613,1230.742,32423,192$ 2,02203601,8011,8370.741,367$19,0474,144$ 2,02306303,1563,2200.722,32625,518$ 2,02303701,8571,8940.721,368$20,4165,102$ 2,02406503,2543,3190.702,32827,846$ 2,02403801,9141,9530.701,370$21,7856,061$ 2,02506703,3553,4220.682,33030,176$ 2,02504001,9742,0130.681,371$23,1567,020$ 2,02606903,4593,5280.662,33332,509$ 2,02604102,0352,0750.661,372$24,5287,981$ 2,02707103,6223,6930.642,37034,879$ 2,02704202,1302,1720.641,394$25,9238,957$ 2,02807403,7923,8650.622,40937,288$ 2,02804302,2302,2740.621,417$27,3399,949$ 2,02907603,9704,0460.612,44839,736$ 2,02904502,3352,3800.611,440$28,77910,957$ 2,03007804,1574,2350.592,48742,223$ 2,03004602,4452,4910.591,463$30,24311,981$ 2,03108004,3524,4320.572,52844,751$ 2,03104702,5602,6070.571,487$31,72913,022$ 2,03208304,5574,6390.552,56947,320$ 2,03204902,6802,7290.551,511$33,24014,079$ 2,03308504,7714,8560.542,61049,930$ 2,03305002,8062,8560.541,535$34,77615,154$ 2,03408804,9955,0830.522,65352,583$ 2,03405202,9382,9900.521,560$36,33616,246$ 2,03509005,2305,3200.512,69655,278$ 2,03505303,0763,1290.511,586$37,92217,356$ 2,03609305,4755,5690.492,73958,018$ 2,03605503,2213,2760.491,611$39,53318,484$ 2,03709605,7335,8290.482,78460,802$ 2,03705603,3723,4290.481,638$41,17119,631$ 2,03809906,0026,1010.462,82963,631$ 2,03805803,5313,5890.461,664$42,83520,796$ 2,039010206,2846,3860.452,87566,506$ 2,03906003,6973,7570.451,691$44,52621,979$ 2,040010506,5806,6850.442,92269,427$ 2,04006203,8703,9320.441,719$46,24523,182$ 2,041010806,8896,9970.422,96972,396$ 2,04106404,0524,1160.421,747$47,99124,405$ 2,042011107,2137,3240.413,01775,414$ 2,04206504,2434,3080.411,775$49,76625,647$ Totals:$0$2,246$0$123,687$125,933$75,414=30-year LCCTotals:$5,405$1,321$0$72,757$79,483$49,766=30-year LCC Energy Audit Report April 16, 2012 pg. 46 ECM #5 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%65.0 $61,009.43 Heating Data 100 Volume Served 100 Description of Retrofit Boiler Replace all heating systems with 95% AFUE boiler. This estimate assumes existing heating systems will be replaced over the next 20 years and has annualized that cost. $61,009.43Estimated Cost of Heating System Replacements New Heating SystemsExisting Heating Systems 13968 9,991.06 Estimated Demand Charges (electric) Estimated Savings per Year $0.00 $13,587.55 $3,868.62 $0.97 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 $9,718.93 Average AFUE of All Heating Systems, proportional to volume 80.00% Heating System Summary $0.97 65 $0.00 95.00% Energy Audit Report April 16, 2012 pg. 47 ---------------------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$3,05013,588$ $0$16,638(1+i)^-nCostsCosts2,012$61,009$979,719$ $0$9,816(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$61,009------$61,0091.00$61,009$61,0092,0133,14213,764016,9060.9716,41316,413.29$ 2,01301009,84509,9450.979,656$70,665(54,252)$ 2,01403,23613,943017,1790.9416,19332,606$ 2,01401039,973010,0760.949,498$80,163(47,557)$ 2,01503,33314,124017,4570.9215,97648,582$ 2,015010610,103010,2090.929,343$89,506(40,924)$ 2,01603,43314,308017,7410.8915,76264,344$ 2,016010910,234010,3440.899,190$98,696(34,352)$ 2,01703,53615,238018,7740.8616,19480,539$ 2,017011310,899011,0120.869,499$108,195(27,657)$ 2,01803,64216,228019,8700.8416,64197,180$ 2,018011611,608011,7240.849,819$118,014(20,834)$ 2,01903,75117,283021,0340.8117,103114,283$ 2,019012012,362012,4820.8110,149$128,163(13,880)$ 2,02003,86418,407022,2700.7917,580131,863$ 2,020012313,166013,2890.7910,491$138,653(6,790)$ 2,02103,98019,603023,5830.7718,074149,937$ 2,021012714,022014,1490.7710,844$149,497440$ 2,02204,09920,877024,9760.7418,585168,522$ 2,022013114,933015,0640.7411,209$160,7067,816$ 2,02304,22222,234026,4560.7219,113187,635$ 2,023013515,904016,0380.7211,587$172,29315,342$ 2,02404,34923,680028,0280.7019,658207,293$ 2,024013916,938017,0760.7011,977$184,27023,024$ 2,02504,47925,219029,6980.6820,223227,516$ 2,025014318,039018,1810.6812,381$196,65030,866$ 2,02604,61326,858031,4710.6620,806248,322$ 2,026014719,211019,3580.6612,798$209,44838,874$ 2,02704,75229,624034,3760.6422,065270,387$ 2,027015121,190021,3410.6413,698$223,14647,241$ 2,02804,89432,676037,5700.6223,412293,800$ 2,028015623,372023,5280.6214,662$237,80855,991$ 2,02905,04136,041041,0830.6124,856318,655$ 2,029016125,780025,9400.6115,694$253,50365,153$ 2,03005,19239,754044,9460.5926,401345,056$ 2,030016528,435028,6010.5916,800$270,30374,754$ 2,03105,34843,848049,1960.5728,056373,113$ 2,031017031,364031,5340.5717,984$288,28684,826$ 2,03205,50948,365053,8730.5529,828402,941$ 2,032017634,594034,7700.5519,251$307,53795,403$ 2,03305,67453,346059,0200.5431,726434,667$ 2,033018138,158038,3380.5420,609$328,146106,521$ 2,03405,84458,841064,6850.5233,759468,426$ 2,034018642,088042,2740.5222,063$350,209118,217$ 2,03506,01964,901070,9210.5135,935504,361$ 2,035019246,423046,6150.5123,619$373,828130,533$ 2,03606,20071,586077,7860.4938,266542,626$ 2,036019851,204051,4020.4925,286$399,114143,512$ 2,03706,38678,960085,3460.4840,762583,388$ 2,037020356,478056,6820.4827,072$426,186157,202$ 2,03806,57887,093093,6700.4643,434626,822$ 2,038021062,296062,5050.4628,983$455,169171,653$ 2,03906,77596,0630102,8380.4546,297673,119$ 2,039021668,712068,9280.4531,031$486,200186,919$ 2,04006,978105,9580112,9360.4449,362722,481$ 2,040022275,790076,0120.4433,223$519,423203,057$ 2,04107,188116,8710124,0590.4252,644775,124$ 2,041022983,596083,8250.4235,571$554,994220,131$ 2,04207,403128,9090136,3120.4156,159831,283$ 2,042023692,206092,4420.4138,085$593,079238,204$ Totals:$0$149,458$1,354,604$0$1,504,062$831,283=30-year LCCTotals:$61,009$4,763$968,924$0$1,034,696$593,079=30-year LCC Energy Audit Report April 16, 2012 pg. 48 ECM #6 Calculations Space Description Number of Fixtures 6 6 Lamps per Fixture 2 2 Lamp Type 4' T8 4' T8 Fixture Wattage 57.5 45.5 Hours on per Week 56 56 Cost of New Lamp $17.38 Cost of New Fixture Total KWH Cost $110.51 $87.45 Total Demand Cost $0.00 $0.00 Total Yearly Cost $110.51 $87.45 Yearly Savings $23.06 Total Retrofit Cost $208.56 Payback Period 9.0 years Upstairs Restrooms Retrofit Description Replace existing lamps in T8 fixtures with 25w lamps. Energy Audit Report April 16, 2012 pg. 49 ---------------------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$2-$ $111$113(1+i)^-nCostsCosts2,012$209$2-$ $87$89(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$209------$2091.00$209$2092,0130201131160.97112112.40$ 2,01302090920.9789$298(185)$ 2,0140201171190.94112224$ 2,01402092940.9489$386(162)$ 2,0150201201220.92112336$ 2,01502095970.9288$475(138)$ 2,0160201231250.89111448$ 2,01602097990.8988$563(115)$ 2,0170301271290.86112559$ 2,0170201001020.8688$651(92)$ 2,0180301311330.84112671$ 2,0180201031050.8488$739(69)$ 2,0190301351370.81112783$ 2,0190201071090.8188$828(45)$ 2,0200301391420.79112894$ 2,0200201101120.7989$916(22)$ 2,0210301431460.771121,006$ 2,0210201131160.7789$1,0051$ 2,0220301481510.741121,119$ 2,0220201171190.7489$1,09425$ 2,0230301521550.721121,231$ 2,0230201201230.7289$1,18248$ 2,0240301571600.701121,343$ 2,0240201241270.7089$1,27172$ 2,0250301621650.681121,455$ 2,0250301281310.6889$1,36095$ 2,0260301671700.661131,568$ 2,0260301321350.6689$1,449119$ 2,0270301751780.641141,682$ 2,0270301381410.6490$1,540143$ 2,0280401831860.621161,798$ 2,0280301451480.6292$1,632167$ 2,0290401911950.611181,916$ 2,0290301521540.6193$1,725191$ 2,0300402002040.591202,036$ 2,0300301591620.5995$1,820216$ 2,0310402102140.571222,158$ 2,0310301661690.5796$1,916242$ 2,0320402202240.551242,282$ 2,0320301741770.5598$2,014268$ 2,0330402302340.541262,408$ 2,0330301821850.54100$2,114294$ 2,0340402412450.521282,536$ 2,0340301911940.52101$2,215321$ 2,0350402522570.511302,666$ 2,0350302002030.51103$2,318348$ 2,0360402642690.491322,798$ 2,0360402092130.49105$2,423375$ 2,0370502762810.481342,932$ 2,0370402192220.48106$2,529403$ 2,0380502892940.461363,069$ 2,0380402292330.46108$2,637432$ 2,0390503033080.451393,208$ 2,0390402402440.45110$2,747461$ 2,0400503173220.441413,348$ 2,0400402512550.44112$2,858490$ 2,0410503323370.421433,492$ 2,0410402632670.42113$2,972520$ 2,0420503483530.411463,637$ 2,0420402752800.41115$3,087551$ Totals:$0$108$0$5,965$6,074$3,637=30-year LCCTotals:$209$86$0$4,720$5,015$3,087=30-year LCC Energy Audit Report April 16, 2012 pg. 50 ECM #7 Calculations Space Description Number of Fixtures 11 11 Lamps per Fixture 2 2 Lamp Type T12 U-Bend T8 U-Bend Fixture Wattage 82.6 45.5 Hours on per Week 168 168 Cost of New Lamp Cost of New Fixture $369.20 Total KWH Cost $873.13 $480.96 Total Demand Cost $0.00 $0.00 Total Yearly Cost $873.13 $480.96 Yearly Savings $392.17 Total Retrofit Cost $4,061.20 Payback Period 10.4 years Front Hallway, Administration, Upstairs Hallway 24/7 Replace existing T12 U-Bend fixtures with T8 U-Bend fixtures w/ 25w lamps and electronic ballasts. Retrofit Description Energy Audit Report April 16, 2012 pg. 51 ---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$17-$ $873$891(1+i)^-nCostsCosts2,012$4,061$10-$ $481$491(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$4,061------$4,0611.00$4,061$4,0612,01301808979150.97888888.05$ 2,01301004945040.97489$4,550(3,662)$ 2,01401909219390.948861,774$ 2,01401005075170.94488$5,038(3,265)$ 2,01501909469650.928832,657$ 2,01501105215310.92486$5,525(2,868)$ 2,01602009719910.898803,537$ 2,01601105355460.89485$6,010(2,473)$ 2,01702001,0011,0220.868814,418$ 2,01701105525630.86485$6,495(2,077)$ 2,01802101,0321,0530.848825,300$ 2,01801105695800.84486$6,981(1,680)$ 2,01902101,0641,0860.818836,183$ 2,01901205865980.81486$7,467(1,284)$ 2,02002201,0971,1200.798847,067$ 2,02001206056170.79487$7,954(887)$ 2,02102301,1311,1540.778857,952$ 2,02101306236360.77487$8,441(490)$ 2,02202301,1671,1900.748868,837$ 2,02201306436560.74488$8,929(92)$ 2,02302401,2031,2270.728869,724$ 2,02301306636760.72488$9,418306$ 2,02402501,2401,2650.7088710,611$ 2,02401406836970.70489$9,906705$ 2,02502601,2781,3040.6888811,499$ 2,02501407047180.68489$10,3951,104$ 2,02602601,3181,3450.6688912,388$ 2,02601507267410.66490$10,8851,503$ 2,02702701,3801,4070.6490313,291$ 2,02701507607750.64498$11,3831,909$ 2,02802801,4451,4730.6291814,209$ 2,02801507968110.62506$11,8882,321$ 2,02902901,5131,5420.6193315,142$ 2,02901608338490.61514$12,4022,740$ 2,03003001,5841,6140.5994816,090$ 2,03001608728890.59522$12,9243,165$ 2,03103101,6581,6890.5796317,053$ 2,03101709149300.57531$13,4553,598$ 2,03203201,7361,7680.5597918,032$ 2,03201709569740.55539$13,9944,038$ 2,03303201,8181,8500.5499519,026$ 2,03301801,0011,0190.54548$14,5424,485$ 2,03403301,9031,9370.521,01120,037$ 2,03401801,0481,0670.52557$15,0994,939$ 2,03503401,9932,0270.511,02721,064$ 2,03501901,0981,1170.51566$15,6645,400$ 2,03603502,0862,1220.491,04422,108$ 2,03602001,1491,1690.49575$16,2395,869$ 2,03703702,1852,2210.481,06123,169$ 2,03702001,2031,2230.48584$16,8246,345$ 2,03803802,2872,3250.461,07824,247$ 2,03802101,2601,2810.46594$17,4186,829$ 2,03903902,3952,4340.451,09625,343$ 2,03902101,3191,3400.45603$18,0217,321$ 2,04004002,5072,5470.441,11326,456$ 2,04002201,3811,4030.44613$18,6347,822$ 2,04104102,6252,6660.421,13127,587$ 2,04102301,4461,4690.42623$19,2588,330$ 2,04204202,7482,7910.411,15028,737$ 2,04202301,5141,5370.41633$19,8918,846$ Totals:$0$856$0$47,132$47,988$28,737=30-year LCCTotals:$4,061$471$0$25,963$30,495$19,891=30-year LCC Energy Audit Report April 16, 2012 pg. 52 ECM #8 Calculations Space Description Number of Fixtures 2 2 Lamps per Fixture 3 3 Lamp Type 4' T12 4' T8 Fixture Wattage 126.9 67 Hours on per Week 56 56 Cost of New Lamp Cost of New Fixture $354.02 Total KWH Cost $81.30 $42.92 Total Demand Cost $0.00 $0.00 Total Yearly Cost $81.30 $42.92 Yearly Savings $38.37 Total Retrofit Cost $708.04 Payback Period 18.5 years Retrofit Description Replace existing 4' 3 lamp T12 fixtures with 3 lamp T8 fixtures with 25w lamps and electronic ballasts. Entry, Breakroom Energy Audit Report April 16, 2012 pg. 53 ---------------------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$2-$ $81$83(1+i)^-nCostsCosts2,012$708$1-$ $43$44(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$708------$7081.00$708$7082,01302083850.978382.69$ 2,01301044450.9744$752(669)$ 2,01402086870.9482165$ 2,01401045460.9444$795(630)$ 2,01502088900.9282247$ 2,01501046470.9243$839(591)$ 2,01602090920.8982329$ 2,01601048490.8943$882(553)$ 2,01702093950.8682411$ 2,01701049500.8643$925(514)$ 2,01802096980.8482494$ 2,01801051520.8443$969(475)$ 2,019020991010.8182576$ 2,01901052530.8143$1,012(436)$ 2,0200201021040.7982658$ 2,02001054550.7943$1,055(397)$ 2,0210201051070.7782740$ 2,02101056570.7743$1,099(359)$ 2,0220201091110.7482823$ 2,02201057590.7444$1,142(320)$ 2,0230201121140.7283905$ 2,02301059600.7244$1,186(281)$ 2,0240201151180.7083988$ 2,02401061620.7044$1,230(242)$ 2,0250201191210.68831,071$ 2,02501063640.6844$1,273(203)$ 2,0260201231250.66831,153$ 2,02601065660.6644$1,317(164)$ 2,0270301281310.64841,238$ 2,02701068690.6444$1,361(124)$ 2,0280301351370.62851,323$ 2,02801071720.6245$1,407(84)$ 2,0290301411440.61871,410$ 2,02901074760.6146$1,452(43)$ 2,0300301471500.59881,498$ 2,03001078790.5947$1,499(1)$ 2,0310301541570.57901,588$ 2,03102082830.5747$1,54641$ 2,0320301621650.55911,679$ 2,03202085870.5548$1,59484$ 2,0330301691720.54931,772$ 2,03302089910.5449$1,643128$ 2,0340301771800.52941,866$ 2,03402094950.5250$1,693173$ 2,0350301861890.51961,961$ 2,035020981000.5150$1,744218$ 2,0360301941980.49972,058$ 2,0360201031040.4951$1,795264$ 2,0370302032070.48992,157$ 2,0370201071090.4852$1,847310$ 2,0380402132160.461002,258$ 2,0380201121140.4653$1,900358$ 2,0390402232270.451022,360$ 2,0390201181200.4554$1,954406$ 2,0400402332370.441042,463$ 2,0400201231250.4455$2,009455$ 2,0410402442480.421052,569$ 2,0410201291310.4256$2,064504$ 2,0420402562600.411072,676$ 2,0420201351370.4157$2,121555$ Totals:$0$80$0$4,388$4,468$2,676=30-year LCCTotals:$708$42$0$2,317$3,067$2,121=30-year LCC Energy Audit Report April 16, 2012 pg. 54 ECM #9 Calculations Space Description Number of Fixtures 33 33 Lamps per Fixture 4 4 Lamp Type 4' T12 4' T8 Fixture Wattage 161.1 88.5 Hours on per Week 56 56 Cost of New Lamp Cost of New Fixture $436.83 Total KWH Cost $1,702.92 $935.49 Total Demand Cost $0.00 $0.00 Total Yearly Cost $1,702.92 $935.49 Yearly Savings $767.42 Total Retrofit Cost $14,415.39 Payback Period 18.8 years Retrofit Description Replace existing 4' 4 lamp T12 fixtures with 4 lamp T8 fixtures with 25w lamps and electronic ballasts. Gun Room, Server Room, Training Room, IT Office, IT Room, Break Room, Investigation Energy Audit Report April 16, 2012 pg. 55 ---------------------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$34-$ $1,703$1,737(1+i)^-nCostsCosts2,012$14,415$19-$ $935$954(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$14,415------$14,4151.00$14,415$14,4152,01303501,7491,7840.971,7321,732.02$ 2,01301909619800.97951$15,367(13,635)$ 2,01403601,7961,8320.941,7273,459$ 2,01402009871,0070.94949$16,316(12,857)$ 2,01503701,8451,8820.921,7225,181$ 2,01502001,0131,0340.92946$17,262(12,080)$ 2,01603801,8941,9330.891,7176,898$ 2,01602101,0411,0620.89943$18,205(11,307)$ 2,01703901,9531,9930.861,7198,617$ 2,01702201,0731,0950.86944$19,149(10,532)$ 2,01804102,0142,0540.841,72010,338$ 2,01802201,1061,1290.84945$20,094(9,757)$ 2,01904202,0762,1180.811,72212,060$ 2,01902301,1411,1640.81946$21,040(8,981)$ 2,02004302,1402,1840.791,72413,784$ 2,02002401,1761,2000.79947$21,987(8,204)$ 2,02104402,2072,2510.771,72515,509$ 2,02102401,2121,2370.77948$22,935(7,426)$ 2,02204602,2752,3210.741,72717,236$ 2,02202501,2501,2750.74949$23,884(6,648)$ 2,02304702,3462,3930.721,72918,965$ 2,02302601,2891,3150.72950$24,834(5,869)$ 2,02404902,4182,4670.701,73020,695$ 2,02402701,3291,3550.70951$25,784(5,089)$ 2,02505002,4932,5430.681,73222,427$ 2,02502701,3701,3970.68951$26,736(4,309)$ 2,02605202,5712,6220.661,73424,161$ 2,02602801,4121,4410.66952$27,688(3,527)$ 2,02705302,6922,7450.641,76225,922$ 2,02702901,4791,5080.64968$28,656(2,733)$ 2,02805502,8182,8730.621,79027,713$ 2,02803001,5481,5780.62983$29,639(1,927)$ 2,02905602,9513,0070.611,81929,532$ 2,02903101,6211,6520.61999$30,639(1,107)$ 2,03005803,0893,1470.591,84931,381$ 2,03003201,6971,7290.591,016$31,654(274)$ 2,03106003,2343,2940.571,87933,259$ 2,03103301,7771,8100.571,032$32,686573$ 2,03206203,3863,4480.551,90935,168$ 2,03203401,8601,8940.551,049$33,7351,433$ 2,03306303,5463,6090.541,94037,108$ 2,03303501,9481,9830.541,066$34,8012,307$ 2,03406503,7123,7770.521,97139,080$ 2,03403602,0392,0750.521,083$35,8843,196$ 2,03506703,8873,9540.512,00341,083$ 2,03503702,1352,1720.511,101$36,9844,099$ 2,03606904,0694,1390.492,03643,119$ 2,03603802,2362,2740.491,118$38,1035,016$ 2,03707104,2614,3320.482,06945,188$ 2,03703902,3412,3800.481,137$39,2395,949$ 2,03807304,4614,5340.462,10347,290$ 2,03804002,4512,4910.461,155$40,3946,896$ 2,03907604,6714,7460.452,13749,427$ 2,03904202,5662,6070.451,174$41,5687,859$ 2,04007804,8904,9680.442,17151,599$ 2,04004302,6862,7290.441,193$42,7618,838$ 2,04108005,1205,2000.422,20753,805$ 2,04104402,8132,8570.421,212$43,9739,832$ 2,04208305,3615,4430.412,24356,048$ 2,04204502,9452,9900.411,232$45,20510,843$ Totals:$0$1,669$0$91,925$93,594$56,048=30-year LCCTotals:$14,415$917$0$50,499$65,831$45,205=30-year LCC Energy Audit Report April 16, 2012 pg. 56 ECM #10 Calculations Incoming Water Temperature 40 System 1 - Location Served: Fuel Type AFUE Thermostat Setpoint Full Load KW (Electric Only) Mo/Yr Operation (Electric Only)Cost Existing Electricity 99.00%120.0 N/A Proposed Natural Gas 80.00%120.0 $4,561.79 Domestic Water Heating Data Gallons Hot Water/yr 21,352 21,352 Description of Retrofit Remove electric domestic hot water tanks and replace with indirect fired boiler mate. Existing Proposed $0.00 $0.00 143.73 177.86 Average Cost Per Therm of Heating Fuels; proportional Average Thermostat Setpoint; proportional Estimated Cost over 1 year $463.23 Estimated Cost of Replacements $4,561.79 120 Estimated Demand Charges (electric) 99.00%80.00% $3.22 $0.97 120 Domestic Water Heating System Summary Average AFUE of Domestic Hot Water Systems; proportional $173.02 Therms required for Domestic Hot Water over 1 year Energy Audit Report April 16, 2012 pg. 57 ---------------------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$0463$ $0$463(1+i)^-nCostsCosts2,012$4,562$46173$ $0$219(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$4,562------$4,5621.00$4,562$4,5622,013046904690.97456455.58$ 2,01304717502220.97216$4,778(4,322)$ 2,0140047504750.94448904$ 2,01404817802260.97219$4,997(4,093)$ 2,0150048204820.924411,344$ 2,01505018002300.97223$5,220(3,876)$ 2,0160048804880.894331,778$ 2,01605118202340.97227$5,447(3,669)$ 2,0170051905190.864482,226$ 2,01705319402470.97240$5,686(3,461)$ 2,0180055305530.844632,689$ 2,01805420702610.97254$5,940(3,251)$ 2,0190058905890.814793,168$ 2,01905622002760.97268$6,208(3,040)$ 2,0200062806280.794953,664$ 2,02005823402920.97284$6,492(2,828)$ 2,0210066806680.775124,176$ 2,02106025003090.97300$6,792(2,616)$ 2,0220071207120.745304,705$ 2,02206126603270.97318$7,109(2,404)$ 2,0230075807580.725485,253$ 2,02306328303460.97336$7,446(2,193)$ 2,0240080708070.705665,819$ 2,02406530203670.97356$7,802(1,982)$ 2,0250086008600.685856,405$ 2,02506732103880.97377$8,178(1,774)$ 2,0260091609160.666057,010$ 2,02606934204110.97399$8,577(1,567)$ 2,027001,01001,0100.646487,658$ 2,02707137704480.97435$9,013(1,354)$ 2,028001,11401,1140.626948,353$ 2,02807341604890.97475$9,488(1,135)$ 2,029001,22901,2290.617439,096$ 2,02907545905340.97519$10,006(910)$ 2,030001,35501,3550.597969,892$ 2,03007850605840.97567$10,573(681)$ 2,031001,49501,4950.5785310,745$ 2,03108055806380.97620$11,193(448)$ 2,032001,64901,6490.5591311,657$ 2,03208261606980.97678$11,871(213)$ 2,033001,81901,8190.5497812,635$ 2,03308567907640.97742$12,61322$ 2,034002,00602,0060.521,04713,682$ 2,03408774908370.97812$13,425257$ 2,035002,21302,2130.511,12114,803$ 2,03509082609160.97890$14,315488$ 2,036002,44102,4410.491,20116,004$ 2,03609391201,0040.97975$15,290714$ 2,037002,69202,6920.481,28617,289$ 2,0370961,00501,1010.971,069$16,359931$ 2,038002,96902,9690.461,37718,666$ 2,0380981,10901,2070.971,172$17,5311,135$ 2,039003,27503,2750.451,47420,141$ 2,03901011,22301,3250.971,286$18,8171,324$ 2,040003,61203,6120.441,57921,719$ 2,04001041,34901,4540.971,411$20,2281,491$ 2,041003,98403,9840.421,69123,410$ 2,04101081,48801,5960.971,549$21,7771,633$ 2,042004,39504,3950.411,81125,221$ 2,04201111,64101,7520.971,701$23,4791,742$ Totals:$0$0$46,181$0$46,181$25,221=30-year LCCTotals:$4,562$2,235$17,249$0$24,046$23,479=30-year LCC Energy Audit Report April 16, 2012 pg. 58 ECM #11 Calculations Space Description Number of Fixtures 70 70 Lamps per Fixture 2 2 Lamp Type T12 U-Bend T8 U-Bend 25 Fixture Wattage 82.6 45.5 Hours on per Week 56 56 Cost of New Lamp Cost of New Fixture $369.20 Total KWH Cost $1,852.09 $1,020.22 Total Demand Cost $0.00 $0.00 Total Yearly Cost $1,852.09 $1,020.22 Yearly Savings $831.87 Total Retrofit Cost $25,844.00 Payback Period 31.1 years Replace existing T12 U-Bend fixtures with T8 U-Bend fixtures with 25w lamps and electronic ballasts. Retrofit Description Youth Court, Interview Room, Administration, Sergeant's Office, Lieutenant's Office, Chief's Office, Front Hallway, Copy Area, Evidence Room, Squad Area, Armory, Upstairs Hallway, Breakroom Energy Audit Report April 16, 2012 pg. 59 ---------------------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$37-$ $1,852$1,889(1+i)^-nCostsCosts2,012$25,844$20-$ $1,020$1,041(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$25,844------$25,8441.00$25,844$25,8442,01303801,9021,9400.971,8841,883.74$ 2,01302101,0481,0690.971,038$26,882(24,998)$ 2,01403901,9531,9930.941,8783,762$ 2,01402201,0761,0980.941,035$27,916(24,154)$ 2,01504002,0062,0470.921,8735,635$ 2,01502201,1051,1270.921,032$28,948(23,313)$ 2,01604202,0602,1020.891,8687,503$ 2,01602301,1351,1580.891,029$29,977(22,474)$ 2,01704302,1242,1670.861,8699,372$ 2,01702401,1701,1940.861,030$31,007(21,634)$ 2,01804402,1902,2340.841,87111,243$ 2,01802401,2061,2310.841,031$32,037(20,794)$ 2,01904602,2582,3040.811,87313,116$ 2,01902501,2441,2690.811,032$33,069(19,953)$ 2,02004702,3282,3750.791,87514,991$ 2,02002601,2821,3080.791,033$34,102(19,111)$ 2,02104802,4002,4480.771,87716,868$ 2,02102701,3221,3490.771,034$35,136(18,268)$ 2,02205002,4752,5240.741,87818,746$ 2,02202701,3631,3910.741,035$36,170(17,424)$ 2,02305102,5512,6030.721,88020,626$ 2,02302801,4051,4340.721,036$37,206(16,580)$ 2,02405302,6302,6830.701,88222,508$ 2,02402901,4491,4780.701,037$38,243(15,734)$ 2,02505402,7122,7660.681,88424,392$ 2,02503001,4941,5240.681,038$39,280(14,888)$ 2,02605602,7962,8520.661,88526,277$ 2,02603101,5401,5710.661,039$40,319(14,042)$ 2,02705802,9272,9850.641,91628,193$ 2,02703201,6131,6440.641,055$41,374(13,181)$ 2,02805903,0653,1240.621,94730,140$ 2,02803301,6881,7210.621,073$42,447(12,306)$ 2,02906103,2093,2700.611,97932,119$ 2,02903401,7681,8010.611,090$43,537(11,418)$ 2,03006303,3603,4230.592,01134,129$ 2,03003501,8511,8850.591,108$44,644(10,515)$ 2,03106503,5183,5830.572,04336,173$ 2,03103601,9381,9740.571,125$45,770(9,597)$ 2,03206703,6833,7500.552,07638,249$ 2,03203702,0292,0660.551,144$46,913(8,664)$ 2,03306903,8563,9250.542,11040,359$ 2,03303802,1242,1620.541,162$48,076(7,717)$ 2,03407104,0374,1080.522,14442,503$ 2,03403902,2242,2630.521,181$49,257(6,754)$ 2,03507304,2274,3000.512,17944,682$ 2,03504002,3292,3690.511,200$50,457(5,775)$ 2,03607504,4264,5010.492,21446,896$ 2,03604102,4382,4790.491,220$51,677(4,780)$ 2,03707804,6344,7110.482,25049,146$ 2,03704302,5532,5950.481,240$52,916(3,770)$ 2,03808004,8524,9320.462,28751,433$ 2,03804402,6732,7170.461,260$54,176(2,743)$ 2,03908205,0805,1620.452,32453,757$ 2,03904502,7982,8430.451,280$55,456(1,699)$ 2,04008505,3185,4030.442,36256,119$ 2,04004702,9302,9760.441,301$56,757(638)$ 2,04108705,5685,6560.422,40058,518$ 2,04104803,0673,1150.421,322$58,079440$ 2,04209005,8305,9200.412,43960,957$ 2,04205003,2123,2610.411,344$59,4221,535$ Totals:$0$1,815$0$99,977$101,792$60,957=30-year LCCTotals:$25,844$1,000$0$55,072$81,916$59,422=30-year LCC Energy Audit Report April 16, 2012 pg. 60 ECM #12 Calculations Space Description Number of Fixtures 3 3 Lamps per Fixture 1 1 Lamp Type 4' T12 4' T8 Fixture Wattage 46.4 24 Hours on per Week 56 56 Cost of New Lamp Cost of New Fixture $225.08 Total KWH Cost $44.59 $23.06 Total Demand Cost $0.00 $0.00 Total Yearly Cost $44.59 $23.06 Yearly Savings $21.53 Total Retrofit Cost $675.24 Payback Period 31.4 years Over Dispatch Desks Retrofit Description Replace existing 4' 1 lamp T12 fixtures with 1 lamp T8 fixtures with 25w lamps and electronic ballasts. Energy Audit Report April 16, 2012 pg. 61 ---------------------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$1-$ $45$45(1+i)^-nCostsCosts2,012$675$0-$ $23$24(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$675------$6751.00$675$6752,01301046470.974545.35$ 2,01300024240.9723$699(653)$ 2,01401047480.944591$ 2,01400024250.9423$722(632)$ 2,01501048490.9245136$ 2,01501025250.9223$745(610)$ 2,01601050510.8945181$ 2,01601026260.8923$769(588)$ 2,01701051520.8645226$ 2,01701026270.8623$792(566)$ 2,01801053540.8445271$ 2,01801027280.8423$815(545)$ 2,01901054550.8145316$ 2,01901028290.8123$839(523)$ 2,02001056570.7945361$ 2,02001029300.7923$862(501)$ 2,02101058590.7745406$ 2,02101030300.7723$885(479)$ 2,02201060610.7445451$ 2,02201031310.7423$909(457)$ 2,02301061630.7245497$ 2,02301032320.7223$932(436)$ 2,02401063650.7045542$ 2,02401033330.7023$956(414)$ 2,02501065670.6845587$ 2,02501034340.6823$979(392)$ 2,02601067690.6645633$ 2,02601035360.6623$1,002(370)$ 2,02701070720.6446679$ 2,02701036370.6424$1,026(348)$ 2,02801074750.6247726$ 2,02801038390.6224$1,051(325)$ 2,02901077790.6148773$ 2,02901040410.6125$1,075(302)$ 2,03002081820.5948822$ 2,03001042430.5925$1,100(279)$ 2,03102085860.5749871$ 2,03101044450.5725$1,126(255)$ 2,03202089900.5550921$ 2,03201046470.5526$1,152(231)$ 2,03302093940.5451972$ 2,03301048490.5426$1,178(206)$ 2,03402097990.52521,023$ 2,03401050510.5227$1,205(181)$ 2,0350201021040.51521,076$ 2,03501053540.5127$1,232(156)$ 2,0360201071080.49531,129$ 2,03601055560.4928$1,259(130)$ 2,0370201121130.48541,183$ 2,03701058590.4828$1,287(104)$ 2,0380201171190.46551,238$ 2,03801060610.4628$1,316(77)$ 2,0390201221240.45561,294$ 2,03901063640.4529$1,345(50)$ 2,0400201281300.44571,351$ 2,04001066670.4429$1,374(23)$ 2,0410201341360.42581,409$ 2,04101069700.4230$1,4045$ 2,0420201401430.41591,468$ 2,04201073740.4130$1,43433$ Totals:$0$44$0$2,407$2,451$1,468=30-year LCCTotals:$675$23$0$1,245$1,943$1,434=30-year LCC Energy Audit Report April 16, 2012 pg. 62 ECM #13 Calculations Component Framed Section Insulated Section Component Framed Section Insulated Section Poured Concrete 0.8 0.8 Poured Concrete 0.8 0.8 XPS Insulation, 2"10 10 XPS Insulation 2"10 10 EPS Insulation, 2"8 8 Total R-Values 10.8 10.8 Total R-Values 18.8 18.8 Total U-Values 0.0926 0.0926 Total U-Values 0.0532 0.0532 Percentage of Framing 0.00%100.00%Percentage of Framing 0.00%100.00% Composite U-Value of Assembly 0.0926 Composite U-Value of Assembly 0.0532 Composite R-Value of Assembly 10.8000 Composite R-Value of Assembly 18.8000 Average Height Of Wall 2.5 Average Height Of Wall 2.5 Wall Length 304 Wall Length 304 Distance from Grade to top of wall 0.5 Distance from Grade to top of wall 0.5 Wall Square Footage - Below Grade 608 Wall Square Footage - Below Grade 608 Wall Square Footage - Above Grade 152 Wall Square Footage - Above Grade 152 Total Square Footage 760 Total Square Footage 760 Ground R-Value 5.38 Ground R-Value 5.38 Total Below Ground R-Value 16.1799 Total Below Ground R-Value 24.1799 Total Above Grade R-Value 10.8000 Total Above Grade R-Value 18.8000 Above Grade Heat Loss BTU/h 467.26 Above Grade Heat Loss BTU/h 268.43 Below Grade Heat Loss BTU/h 1,247.57 Below Grade Heat Loss BTU/h 834.81 Total Below Grade Wall Heat Loss BTU/h 1,714.83 Total Below Grade Wall Heat Loss BTU/h 1,103.24 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 $182.66 Yearly Cost $117.51 $98.96 $65.15 $46.60 Cost of Proposed Upgrade $14,663.87 Below Grade Wall - Original Assembly 1 Below Grade Wall - Proposed Assembly 1 Energy Audit Report April 16, 2012 pg. 63 ---------------------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$0183$ $0$183(1+i)^-nCostsCosts2012$14,664$0118$ $0$118(1+i)^-nCostsCosts2012$0------$01.00$0-$ 2012$14,664------$14,6641.00$14,664$14,6642013018501850.97180179.65$ 20130011901190.97116$14,779(14,600)$ 20140018701870.94177356$ 20140012101210.94114$14,893(14,537)$ 20150019001900.92174530$ 20150012201220.92112$15,005(14,475)$ 20160019201920.89171701$ 20160012401240.89110$15,115(14,414)$ 20170020502050.86177878$ 20170013201320.86114$15,229(14,351)$ 20180021802180.841831,060$ 20180014001400.84118$15,346(14,286)$ 20190023202320.811891,249$ 20190014901490.81122$15,468(14,218)$ 20200024702470.791951,445$ 20200015901590.79126$15,593(14,149)$ 20210026402640.772021,647$ 20210017001700.77130$15,723(14,077)$ 20220028102810.742091,855$ 20220018101810.74134$15,858(14,002)$ 20230029902990.722162,071$ 20230019201920.72139$15,996(13,925)$ 20240031803180.702232,295$ 20240020502050.70144$16,140(13,845)$ 20250033903390.682312,526$ 20250021802180.68149$16,289(13,763)$ 20260036103610.662392,764$ 20260023202320.66154$16,442(13,678)$ 20270039803980.642563,020$ 20270025602560.64164$16,607(13,587)$ 20280043904390.622743,294$ 20280028302830.62176$16,783(13,489)$ 20290048504850.612933,587$ 20290031203120.61189$16,971(13,385)$ 20300053405340.593143,901$ 20300034403440.59202$17,173(13,273)$ 20310058905890.573364,237$ 20310037903790.57216$17,390(13,153)$ 20320065006500.553604,597$ 20320041804180.55232$17,621(13,024)$ 20330071707170.543854,982$ 20330046104610.54248$17,869(12,887)$ 20340079107910.524135,395$ 20340050905090.52266$18,135(12,740)$ 20350087208720.514425,837$ 20350056105610.51284$18,419(12,582)$ 20360096209620.494736,311$ 20360061906190.49305$18,724(12,413)$ 2037001,06101,0610.485076,818$ 20370068306830.48326$19,050(12,232)$ 2038001,17101,1710.465437,360$ 20380075307530.46349$19,399(12,039)$ 2039001,29101,2910.455817,942$ 20390083108310.45374$19,773(11,831)$ 2040001,42401,4240.446238,564$ 20400091609160.44401$20,174(11,609)$ 2041001,57101,5710.426679,231$ 2041001,01101,0110.42429$20,603(11,372)$ 2042001,73301,7330.417149,945$ 2042001,11501,1150.41459$21,062(11,117)$ Totals:$0$0$18,210$0$18,210$9,945=30-year LCCTotals:$14,664$0$11,715$0$26,379$21,062=30-year LCC Energy Audit Report April 16, 2012 pg. 64 ECM #14 Calculations Space Description Number of Fixtures 6 6 Lamps per Fixture 4 4 Lamp Type 4' T12 4' T8 Fixture Wattage 161.6 88.5 Hours on per Week 5 5 Cost of New Lamp Cost of New Fixture $436.83 Total KWH Cost $27.73 $15.19 Total Demand Cost $0.00 $0.00 Total Yearly Cost $27.73 $15.19 Yearly Savings $12.54 Total Retrofit Cost $2,620.98 Payback Period 208.9 years 1st Floor Men's/Women's Bath, Evidence Rooms 1 & 2 Retrofit Description Replace existing 4' 4 lamp T12 fixtures with 4 lamp T8 fixtures with 25w lamps and electronic ballasts. Energy Audit Report April 16, 2012 pg. 65 ---------------------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$1-$ $28$28(1+i)^-nCostsCosts2,012$2,621$0-$ $15$15(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$2,621------$2,6211.00$2,621$2,6212,01301028290.972828.20$ 2,01300016160.9715$2,636(2,608)$ 2,01401029300.942856$ 2,01400016160.9415$2,652(2,595)$ 2,01501030310.922884$ 2,01500016170.9215$2,667(2,583)$ 2,01601031310.8928112$ 2,01600017170.8915$2,683(2,570)$ 2,01701032320.8628140$ 2,01700017180.8615$2,698(2,558)$ 2,01801033330.8428168$ 2,01800018180.8415$2,713(2,545)$ 2,01901034340.8128196$ 2,01900019190.8115$2,729(2,532)$ 2,02001035360.7928224$ 2,02000019190.7915$2,744(2,519)$ 2,02101036370.7728253$ 2,02100020200.7715$2,759(2,507)$ 2,02201037380.7428281$ 2,02200020210.7415$2,775(2,494)$ 2,02301038390.7228309$ 2,02300021210.7215$2,790(2,481)$ 2,02401039400.7028337$ 2,02400022220.7015$2,806(2,469)$ 2,02501041410.6828365$ 2,02500022230.6815$2,821(2,456)$ 2,02601042430.6628393$ 2,02600023230.6615$2,836(2,443)$ 2,02701044450.6429422$ 2,02700024240.6416$2,852(2,430)$ 2,02801046470.6229451$ 2,02800025260.6216$2,868(2,417)$ 2,02901048490.6130481$ 2,02901026270.6116$2,884(2,403)$ 2,03001050510.5930511$ 2,03001028280.5916$2,901(2,390)$ 2,03101053540.5731542$ 2,03101029290.5717$2,918(2,376)$ 2,03201055560.5531573$ 2,03201030310.5517$2,935(2,362)$ 2,03301058590.5432604$ 2,03301032320.5417$2,952(2,348)$ 2,03401060620.5232636$ 2,03401033340.5218$2,969(2,333)$ 2,03501063640.5133669$ 2,03501035350.5118$2,987(2,318)$ 2,03601066670.4933702$ 2,03601036370.4918$3,006(2,303)$ 2,03701069710.4834736$ 2,03701038390.4818$3,024(2,288)$ 2,03801073740.4634770$ 2,03801040400.4619$3,043(2,273)$ 2,03901076770.4535805$ 2,03901042420.4519$3,062(2,257)$ 2,04001080810.4435840$ 2,04001044440.4419$3,081(2,241)$ 2,04101083850.4236876$ 2,04101046460.4220$3,101(2,225)$ 2,04201087890.4137913$ 2,04201048490.4120$3,121(2,208)$ Totals:$0$27$0$1,497$1,524$913=30-year LCCTotals:$2,621$15$0$820$3,456$3,121=30-year LCC Energy Audit Report April 16, 2012 pg. 66 ECM #15 Calculations Space Description Number of Fixtures 4 4 Lamps per Fixture 2 2 Lamp Type 4 foot T-12 4 foot T-8 Fixture Wattage 80.6 45.5 Hours on per Week 1 1 Cost of New Lamp Cost of New Fixture $271.22 Total KWH Cost $1.84 $1.04 Total Demand Cost $0.00 $0.00 Total Yearly Cost $1.84 $1.04 Yearly Savings $0.80 Total Retrofit Cost $1,084.88 Payback Period 1350.9 years Replace existing 4' 4 lamp T12 fixtures with 4 lamp T8 fixtures with 25w lamps and electronic ballasts. Boiler Room Retrofit Description Energy Audit Report April 16, 2012 pg. 67 ---------------------A N N U A L R E A L C A S H F L O W S C U R R E N T----------------------------------------------------------------------------------A N N U A L R E A L C A S H F L O W S P R O P O S E D----------------------------- (Begin)First &AnnualAnnualAnnualTotalPresentPresentPresent(Begin)First &AnnualAnnualAnnualTotalPresentPresentPresentPresent Value of YearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofYearReplace.Maint.Nat.GasElectricAnnualWorthWorth ofWorth ofCumulative CostsCostsCostsCostsCostsFactorAnnualCumulativeCostsCostsCostsCostsCostsFactorAnnualCumulativeSavings2,012$0-$ $2$2(1+i)^-nCostsCosts2,012$1,085$0-$ $1$1(1+i)^-nCostsCosts2,012$0------$01.00$0-$ 2,012$1,085------$1,0851.00$1,085$1,0852,013000220.9721.88$ 2,013000110.971$1,086(1,084)$ 2,014000220.9424$ 2,014000110.941$1,087(1,083)$ 2,015000220.9226$ 2,015000110.921$1,088(1,082)$ 2,016000220.8927$ 2,016000110.891$1,089(1,082)$ 2,017000220.8629$ 2,017000110.861$1,090(1,081)$ 2,018000220.84211$ 2,018000110.841$1,091(1,080)$ 2,019000220.81213$ 2,019000110.811$1,092(1,079)$ 2,020000220.79215$ 2,020000110.791$1,093(1,078)$ 2,021000220.77217$ 2,021000110.771$1,094(1,078)$ 2,022000230.74219$ 2,022000110.741$1,095(1,077)$ 2,023000330.72221$ 2,023000110.721$1,096(1,076)$ 2,024000330.70222$ 2,024000120.701$1,098(1,075)$ 2,025000330.68224$ 2,025000220.681$1,099(1,074)$ 2,026000330.66226$ 2,026000220.661$1,100(1,073)$ 2,027000330.64228$ 2,027000220.641$1,101(1,073)$ 2,028000330.62230$ 2,028000220.621$1,102(1,072)$ 2,029000330.61232$ 2,029000220.611$1,103(1,071)$ 2,030000330.59234$ 2,030000220.591$1,104(1,070)$ 2,031000440.57236$ 2,031000220.571$1,105(1,069)$ 2,032000440.55238$ 2,032000220.551$1,106(1,068)$ 2,033000440.54240$ 2,033000220.541$1,108(1,067)$ 2,034000440.52242$ 2,034000220.521$1,109(1,066)$ 2,035000440.51244$ 2,035000220.511$1,110(1,066)$ 2,036000440.49247$ 2,036000230.491$1,111(1,065)$ 2,037000550.48249$ 2,037000330.481$1,113(1,064)$ 2,038000550.46251$ 2,038000330.461$1,114(1,063)$ 2,039000550.45254$ 2,039000330.451$1,115(1,062)$ 2,040000550.44256$ 2,040000330.441$1,116(1,061)$ 2,041000660.42258$ 2,041000330.421$1,118(1,060)$ 2,042000660.41261$ 2,042000330.411$1,119(1,058)$ Totals:$0$2$0$100$101$61=30-year LCCTotals:$1,085$1$0$56$1,142$1,119=30-year LCC Energy Audit Report April 16, 2012 pg. 68 Cost Data Energy Audit Report April 16, 2012 pg. 69 Energy Audit Report April 16, 2012 pg. 70