8

- A

- i APPENDIX 8

- A. USER INSTRUCTIONS FO R THE LIFE

- CYCLE COST ANALYSIS

SPREADSHEET FOR FURNACES

TABLE OF CO NTENTS

8

- A.1 USER INSTRUCTIONS

................................ ................................ ....................... 8

- A

- 1

8

- A.2 STARTUP

................................ ................................ ................................ .............. 8

- A

- 1

8

- A.3 DESCRIPTION OF LIFE

- CYCLE COST WORKSHEET S

................................ 8

- A

- 1

8

- A.4 BASIC INSTRUCTIONS F OR OPERATING THE LIFE

- CYCLE COST

SPREADSHEETS

................................ ................................ ................................ .. 8

- A

- 38

- A

- 1 APPENDIX 8

- A. USER INSTRUCTIONS FO R THE LIFE

- CYCLE COST ANALYSIS

SPREADSHEET FOR FURNACES

8

- A.1 USER INSTRUCTIONS

The results obtained in this analysis can be examined and reproduced using the Microsoft Excel spreadsheets available on the Department of E nergy’s ( DOE's ) central air conditioner and

f urnace r ulemaking website : http://www1.eere.energy.gov/buildings/appliance_standards/residential/fb_nopr_analysis.html

. From that pa ge, follow the links to the notice of proposed rulemaking ( NOPR ) phase and then to Analytical Tools.

8

- A.2 STARTUP

DOE’s spreadsheet enable s users to perf orm l ife

- c ycle c ost (LCC) and p ayback p eriod (PBP) analyses for each product class

. One spreadsheet exists for all three furnace product

class es

.

To examine the spreadsheets, DOE assumes that the user has access to a personal computer with a hardware configuration capable of running Windows XP or later

. All LCC spreadsheets require Microsoft Excel 200 3 or later installed under the Windows operating
system. Because certain variable s inside the spreadsheets are defined as distributions

, a c opy of Crystal Ball (a commercially available add

- on program) is required to view them.

8

- A.3 DESCRIPTION OF LIFE

- CYCLE COST WORKSHEET S

For all of the furnace product classes, DOE crea ted a single spre adsheet containing a

collection of worksheets

. Each work sheet represents a conceptual component within the LCC

calculation. To facilitate navigability and identify how work sheets are related, each work sheet

contains an area on the extreme left showing variables imported to and exported from the current

work sheet. The LCC spreadsheet con tains the following worksheets:

Summary The Summary work sheet contains a user interface to manipulate energy price trend and start year inputs and to run the Crystal B all simulation. LCC and

PBP simulation results for each efficiency level are also displayed here.

LCC&PB

Calcs The LCC&PB Calcs work sheet shows LCC calculation results for different efficiency levels for a single Residential Energy Consumption Survey (RECS)

household. 1 During a Crystal Ball simulation, the spreadsheet records the

LCC and PBP values for every sampled household.

Rebuttable Payback The Rebuttable Payback workshe et c ontains the total and incremental manufacturer costs, retail prices

, the installation costs, the repair and maintenance costs, energy use calculations, and t he simple PBP calculations

for each efficiency level. DOE ’s furnace test procedure is used to calculate8

- A

- 2 parameters used in energy use calculations.

Equip Price The Equip Price work sheet calculates retail price values used as inputs in the

LCC calculations in the Summary work sheet. DOE applied baseline and incremental markups to calculate fina l retail prices. DOE calculated the markups differently for replacement units and new units.

Installation

Cost The Installation Cost worksheet provides the weighted average installation cost for each design option. These results are used to calculate the total installed prices of the design options.

Maintenance and Repair

Cost The Maintenance and Repair Cost worksheet provides the maintenance and repair cost s for each design option. These results are used to determine operating costs for the design options.

RECS Sample The RECS worksheet contains the RECS 200 5 household data for each product class. During a Crystal Ball simulation, DOE uses these household

characteristics to determine the analysis parameters

.

Base Case

AFUE The Base Case AFUE worksheet determines the annual fuel utilization efficiency (AFUE) of the base case unit s in 2016

.

AFUE (Existing) The Existing AFUE worksheet includes the furnace efficiency for all years during the period 1966

- 20 05

.

Energy Use The Energy Use worksheet calculates annual energy use by fuel type

, d epending on product class. The annual energy use calculations for each design option are inputs to the LCC&PB Calcs worksheet to calculate the

a nnual operating cost of the LCC

.

Energy Price The Energy Price worksheet shows the estimated monthly natural gas, electricity

, and oil prices.

Energy Price

Trends The Energy Price Trends worksheet shows the future price trends of the different heating fuels. DOE used energy price data and forecasts from the Energy Information Administration’s ( EIA's ) Annual Energy Outlook 2010 for the period until 2035 and extrapolated beyond 2035

. 2

Discount Rate The Discount Rate worksheet contains the distributions of discount rates for replacement and new units.

Lifetime The Lifetime worksheet contains the distribution of lifetimes for equipment of that product class.8

- A

- 3 Labor Costs The Labor Costs worksheet contains the labor cost factors by region.

Census Population

Data The Census Population Data worksheet contains the Census estimat ed housing units by State.

Models Data The Models Data worksheet includes characteristics of the furnace products used in the analysis.

Energy Use Adjustment

Factors The Energy Use Adjustment Factors worksheet contains the energy use adjustment factors by region according to heating and cooling degree day

data.

Weather Data The Weather Data worksheet contains heating degree days, cooling degree days, heating and cooling outdoor design temperature, and annual mean temperature by weather station.

Shipments The Shipments worksheet contains historical furnace shipments by State by product class.

NIA Inputs The NIA Inputs worksheet contains intermediate inputs used for other DOE analyses.

8

- A.4 BASIC INSTRUCTIONS FOR OPE RATING THE LIFE

- CYCLE

COST SPREADSHEETS

Basic instructions for operating the LCC spreadsheet are as follows:

1. Once the LCC spreadsheet has been downloaded, open the file using Excel

. Click “Enable Macro” when prompted and then clic k on the tab for the Summary worksheet.

2. Use Excel's View/Zoom commands at the top menu bar to change the size of the display to fit your monitor.

3. The user can change the parameters listed under USER OPTIONS on the Summary

worksheet

. There are three drop

- down boxes and one command button. The default
parameters are:

a. Energ y Price Trend: Defaults to “AEO 2010

- Reference Case

. ” To change the input, use the drop

- down menu and select the desired trend (Reference, Low

, or High).

b. Start Year: Defaults to “ 2016

. ” To change the value

, use the drop

- down menu and select the desired year.8

- A

- 4 c. # of Trials: Defaults to “ 10,000. ” To change the value

, use the drop

- down menu and select the desired number of trials (1,000, 2,000, 3,000

, 5,000 , or 10,000 ).

d. Subgroup: Defaults to “National.” To change the sample used for LCC and PBP calculations, use the drop

- down menu and select the desired subgroup from the available samples (National, Low

- Income, Senior

- Only

, Multi

- Family ).

4. To run the Crystal Ball simulation, click the “run” button (you must re

- run after changing

any parameters). The spreadsheet will then be minimized. You can monitor the progress of the simulation by watching the count of iterations at the left bottom corner. Wh en the simulation is finished, the wo rksheet named Summary will re appear with the results.8

- A

- 5 REFERENCES

1. U.S. Department of Energy

- Energy Information Administration, Residential Energy Consumption Survey: 2005 Public Use Data Files, 2005.

< http://www.eia.doe.gov/emeu/recs/recspubuse05/pubuse05.html >

2. Energy Information Administration, Annual Energy Outlook 2010 with Projections to

2035 , 2010. Washington, DC. Report No. DOE/EIA

- 0383(2010).

< http://www.eia.doe.gov/oiaf/aeo/ >