APPENDIX 8

- A. USER INSTRUCTION S FOR LIFE

- CYCLE COST AND

PAYBACK PERIOD SPREADSHEET

TABLE OF CO NTENTS

8

- A.1 DEFINITIONS

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

- A

- 1

8

- A.2 BASIC INSTRUCTIONS

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

- A

- 3

8 A

- iAPPENDIX 8

- A. USER INSTRUCTION S FOR LIFE

- CYCLE COST AND PAYBA CK

PERIOD SPREADSHEET

8

- A.1 DEFINITIONS

The interested reader can examine and reproduce detailed results of the U.S. Department

of Energy’s ( DOE’s ) life

- cycle cost ( LCC ) and payback period ( PBP ) analysi s for residential

dehumidifiers by using Microsoft Excel spreadsheet s available on DOE ’s website at http://www1.eere.energy.gov/buildings/appliance_standards/residential/dehumidifiers.html

. To fully execute the spreadsheet s requires both Microsoft Excel and Crysta l Ball software. Both applications are comme rcially available. Crystal Ball is available at www.decisioneering.com

.

The latest version of the workboo k , which is post ed on the DOE website

, was tested using Microsoft Excel 200 7

. The LCC and PBP workbook for residential dehumidifiers comprises the following workshe ets.

Summary Presents the results of an analysis in terms of a verage LCC

, LCC

s avings

, and median

, average
, and undefined PBP for all dehumidifier product classes

. A table includes, for each efficiency

level considered

, i nstalled p rice ; life time o perating c ost ; LCC ; average savings ; and the percentage of customers that w ould incur

a net cost , no impact, or net savings from each standard level

. T he

user can stipulate three parameters for a simulation run: whether the AEO energy price trend reflects an economic case that is reference, low

- growth, or high

- growth (re ference is default) ; and

the n umber of simulation runs to be performed within a range of

100 0

– 1 0,000 (10,000 is default).

LCC & Payback The LCC& Payback worksheet shows LCC and PBP calculation results for different efficiency levels for a single Residential Energy Consumption Survey (RECS) 2009 household

. During a Crystal Ball simulation, the spreadsheet records the LCC and PBP values for every sampled household.

Rebuttable Payback The Rebuttable Payback worksheet contains the installation costs, energy use calculations, and the simple PBP calculations for each efficiency level.

REC S Sample The RECS Sample worksheet contains the RECS 2009 household data for each product type . During a Crystal Ball simulation, DOE

uses these household characteristics to determine the analysis

parameters.

8

- A

- 1Weather Data The Weather Data sheet cont ains the RECS 2009 household data

matched with the National Oceanic and Atmospheric Administration’s National Climatic Data Center (NCDC) weather

stations data.

Vapor Density Table Cal culates the average vapor density for each month. It also calculates the annual operating hours by mode for the sampled

household with a portable unit dehumidifier.

Usage Contains probabili ty distribution of operating hours by mode for

whole

- home dehumidifiers. It also contains information of fan

only and standby power demand for each product type.

Base

- Case Efficiency Gives the market shares for efficiency levels in the base case.

Distribution

Equipment Prices Develops total installed cost for dehumidifiers in 20 1 2 $

. This sheet provid es baseline and incremental manufacturer costs, retail price,

sales ta x, and installation cost for both product classes and each efficiency level. Inc ludes the assumptions used about mark ups and

sales tax.

Energy Price s Contains the regional prices in 20 1 2 $ for electricity u sed in the LCC and PBP analysis.

Energy Price Tren d s Contains the electricity price trends for the reference, high, and low economic gro wth scenarios based on AEO 2013

.

Discount Rate Contains data from which an average discount rate and a

distribution o f discount rates are determined

.

Lifetime Present s the average lifetime

, in years

, for portable unit and whole

home dehumidifiers

, the Weibull parameters used for the survival

function , and a graph of the Weibull retirement function for portable unit and whole

- home dehumidifiers, respectively

.

Forecast Cells Gives details regarding base

- case efficie ncy distributions for all dehumidifier product classes. Median, minimum, maximum, and average values are given, along with 5 th , 25 th , 50 th , 75 th , and 95 th
percentile values. Included are product prices and details of the LCC and PBP (LCC savings in terms o f money, energy, and the percentages of customers that would experience a net cost, no impact, or net savings from each efficiency level).

8

- A

- 28

- A.2 BASIC INSTRUCTIONS

Basic instructions fo r operating the LCC spreadsheet are provided below.

1. After download ing the LCC file from DOE’s w eb site

, use Microsoft Excel to open it . At the bottom of the workbook , click on the tab for the sheet labeled Summary

.

2. Use Excel’s “View/Zoom” command in the top menu bar to change the size of the display so that it fit s your mo nitor.

3. U s e the graphical interface in the spreadsheet to choose parameters or enter data.

You can change the default choices f or the three inputs listed under "User Input " ( energy price tr end , start year, and number of simulation runs)

. To change a default input

, select the desired value from the drop

- down choice s by the input box.

4. After selecting the desired parameters, click the “Run” button. The spreadsheet will minimize until the simulation is complete, and will then re

- open with the updated

re sults.

8

- A

- 3