FLUORESCENT LAMP BALLAST ANALYSIS

PUBLIC WORKSHOP

AT DOE, WASHINGTON DC MARCH 17, 1995

ISAAC TURIEL

LAWRENCE BERKELEY LABORATORY

Lamp Ballasts Workshop March 17, 1995 Comment 08
BF, and Watts Inputs

* Ballast Prices

Explanation of 10 and Percentile s

Lamp Ballasts Workshop March 17, 1995 Comment 08
INPUTS FOR BALLAST LCC ANALYSIS

For Each mp/Ballast Combination and Technology

put Watts, Ballast Factor, and BEF

Lghting Operating Hours

Lamp and Ballast Service Lives

Electricity Prices

Prices of Ballasts and Lamps

Fixture Effect Correction to put Watts

• Discount Rates

Labor Times to Replace Lamp and Ballasts

Lamp Ballasts Workshop March 17, 1995 Comment 08
Methodel_- __ ;1, s

Average s Chosen for Energy Efficient Magnetic and

Cathode Cutout Ballasts

for 104 50 Percentile and Maximum

Efficiency Cases for Ele&onic Ballasts

s Selected for each Technologies

Input Watts Calculated

* Input Watts Normalized to Light Output (95% BF)

* Data Obtained from NEMA, S eattle Database, Product

Literature

Lamp Ballasts Workshop March 17, 1995 Comment 08
Equal Light Output Normalization

example With Magnetic Ballast for Energy Saver Lamp,,

No NEMA ata Provided for ES Lamps

Used NYSEO Database and Product Literature

General Procedure

Choose Average BEFs for Magnetic Ballasts

Choose BF and Calculate Watts Input

Normalize Watts to a 95% BF

For a 2F40 T12/ES Ballast

Case (1) Start at BF = 95%

Case (2) Start at BF = 88%

(1) 'Average BEF = 1.24 at BF = 95 W = 95/1.24 = 76.6

W

(2) Average BEF = 1.24 at BF = 88 W = 88/1.24 = 71.0

W

alized Input Watts = (95188)* 71 = 76.6 Watts

Lamp Ballasts Workshop March 17, 1995 Comment 08
I

ce Data Obtained from Survey

Data Sources: Ballast facts ers,

Manufacturers,. and i g a e nerL, Companies

.e

Markups Provided used to End-User

Prices

Final Prices Calculated by Weighting Two Sets of Ballast

Prices

End-User Price (1) ® 1.20*LMC Price

End-User Price (2) ® . 81 *Fixture OEM Price

Weighted Average End-User. Price

for Electronics .5 * (1) .5 * (2)

for Magnetics .2 *(1) + . *(2)

Data Arriving Late Sh Above Values May Need to be

Changed to 44%/56% Electronics 37%/63% Magnetics

for Respectively

Lamp Ballasts Workshop March 17, 1995 Comment 08
BALLAST SENSITIVITIES FOR LCC AND PAYBACK PERIOD

Electricity Price

Operating Hours

Ballast Prices

APPROACH

One parameter at a time

Lamp Ballasts Workshop March 17, 1995 Comment 08
uct Class

1-F40 T12

Ti

(F34 T12)

2-F40 T12

2-F40 T 1 S

4 T12)

3-F40 T12

3-F40 T1 S

(F34 T12)

Payback ary

sign BEF yrbac ' @ % d

E.E Magnetic 1.86

Cathode Cutout 1.94 9.9

Electronic RS 10% 2.32 5.4

Electronic RS 50% 2.41 4.7

Max. Efficiency 2.48 4.3

E.E Magnetic 1.89 NA

Cathode tout 2.26 2.5

Electronic RS 10% 2.57 4.1

Electronic RS 50% 2.76 3.5

Max. Efficient 3.10 2.8

E.E Magnetic 1.07 NA

Cathode tout 1.15 3.3

Electronic RS 10% 1.18 6.5

Electronic RS 50% 1.19 5.7

Max. Efficiency 1.23 4.6

E.E Magnetic 1.24 NA

Cathode Cutout 1.33 3.9

Electronic RS 10% 1.34 9.4

Electronic RS 50% 1.41 5.6

Max. Efficiency 1.43 5.1

E.E Magnetic 0.71 NA

Cathode Cutout 0.77 3.5

Electronic 10% 0.78 1.1

Electronic RS 50% 0.79 0.9

Max. Efficiency 0.87 0.4

E.E Magnetic 0.83 NA

Cathode Cutout 0.89 4.3

Electronic RS 10% 0.92 0.9

Electronic 50% 0.93 0.8

Max. Ecien 1.02 0.4

E.E Magnetic 0.54 NA

Cathode tout 0.58 8.3

Electronic RS 10% -0.59 1.1

Electronic 50% 0.60 1.0

Mm E cienc 0.60 1.0

E.E Magnet 0.62

iode tout 0.67

Electronic RS 10%

Electronic RS 50%

Max. Efficiency

Lamp Ballasts Workshop March 17, 1995 Comment 08
Payback Summary

Product Class Design BEF

Commercial

Payback @8%

Industrial

Payback @8%

2-F96 T12 E. E. Magnetic 0.59 NA NA

Cathode Cutout

Electronic 10% IS

N/A

0.63

NA

4.4

NA

10.8

Electronic 50% IS 0.65 2.9 7.0

Max. Efficiency 0.67 2.4 5.9

2-F96 T12/ES E. E. Magnetic 0.67 NA NA

Cathode Cutout

Electronic 10% IS

N/As

0.78

NA

2.3

NA

5.6

Electronic 50% IS 0.79 2.0 4.9

Max. Efficiency 0.84 1.6 3.8

2-F96 T12HO E. E. Magnetic 0.40 NA NA

Cathode Cutout

Electronic 10% RS

N/A

0.43

NA NA

4.8

Electronic 50%RS 0.44 3.9

Max. Efficiency 0.44 3.7

2-F96 T 12HO/ES E. E. Magnetic 0.39 NA NA

Cathode Cutout

Electronic 10% RS

N/A

0.48

NA NA

1.5

Electronic 50%RS 0.50 1.4

Max. Efficiency 0.52 1.2

Lamp Ballasts Workshop March 17, 1995 Comment 08
ay ac

ict Class Design BEF Payback @8%®

I- F32 T8 E.E. Magnetic Avg.

Cathode Cutout Avg.

2.42

NA'

NA

NA

Electronic RS 10% 2.73 9.5

Electronic RS 50% 2.90 6.6

Electronic IS 10% 2.88 10.2

Electronic IS 50% 2.97 8.8

Max. Efficiency 3.00 8.4

2..F32 T8 E.E. Magnetic Avg. 1.28 NA

Cathode Cutout Avg. 1.37 3.8

Electronic RS 10% 1.41 6.2

Electronic RS 50% 1.46 4.6

Electronic IS 10% 1.49 6.7

Electronic IS 50% 1.51 6.2

Max. Efficiency 1.54 5.6

3-F32 T8 E.E. Magnetic Avg 0.85 NA

Cathode Cutout Avg. 0.91 3.9

Electronic RS 10% 0.93

Electronic RS 50% 0.97

Electronic IS 10% 1.00 1.1

Electronic IS 50% 1.02 1.0

Max. Efficiency 1.04 0.9

4-F32 T8 E.E. Magnetic Avg. 0.64 NA

Cathode Cutout Avg. 0.69 3.9

Electronic RS 10% 0.72

Electronic RS 50% 0.74

Electronic IS 10% 0.74 1.3

Electronic IS 50% 0.77 1.1

Max. Efficiency 0.81 1.0

* Total Installed Cost is less than that of the baseline

Lamp Ballasts Workshop March 17, 1995 Comment 08
2/27/95

Payback Summary for 2-F40 T12 and 2-F40 T121ES

Product Class Design Payback @8% Electricity Price Sensitivity Operating Hrs Sensitivity Ballast Price Sensitivity

2-F40 T12 E.E Magnetic NA. Low High Low High Low

Cathode Cutout 3.3 4.49 2.35 5.40 1.69 1.05

Electronic RS 10% 6.5 8.84 4.63 10.64 3.32 2.39

Electronic RS 50% 5.7 7.79 4.08 9.37 2.93 2.11

Max. Efficiency 4.6 6.24 3.27 7.51 2.35 1.69

2-F40 T12/ES E.E Magnetic NA NA NA NA NA NA

(F34 T12) Cathode Cutout 3.9 5.34 2.80 6.43 2.01 1.25

Electronic RS 10% 9.4 12.81 6.71 15.40 4.81 3.46

Electronic RS 50% 5.6 7.66 4.01 9.22 2.88 2.07

Max. Efficiency 5.1 6.99 3.66 8.40 2.63,,., 1.89

Original Case

Hrs of operation

Elect Price

Sensitivities

4100

0.075

Low High

Elect Price 0.055 0.105

Operating Hrs 2500 8000

Cathode Cutout delta Price 2.00

Electronic-delta Price 6.00

SENS_T12.XLS

Lamp Ballasts Workshop March 17, 1995 Comment 08
2/27/95 '

Payback Summary for 24?5 T12

Commercial Electric Price Sensitivity Operating Hrs Sensitivity Industrial MElectri. Price Sensitivity Operating Hrs Sensitivity

duct Class Design Payback @8% Low High Low -igh Payback @8%^ Low High Low High

T96 T12 E. E. Magnetic NA NA NA NA HNA NA NA NA NA NA

Cathode Cutout NA N/A N/A N/A N/A NA N/A N/A N/A N/A

Electronic 10% IS 4.4 6.05 3.17 5.77 3.61 10.8 18.04 8.32 14.43 8.66

Electronic 50% IS 2.9 3.93 2.06 3.75 2.34 7.0 11.72 5.41 9.38 5.63

Max. Efficient 2.4 3.28 1.72 3.12 1.95 5.9 9.76 4.50 7.81 4.68

inal Case (Commercial) Original Case (Industrial)

)f operation 6500 Hrs, of operation 4000

Price 0.075 Elect Price 0.050

itivities (Commercial)

Low High

Sensitivities (Industrial)

Low High

Price 0.055 0.105 Elect Price 0.030 0.065

ating Hrs 5000 8000 Operating Hrs 3000 5000

SENS2F96.XLS

Lamp Ballasts Workshop March 17, 1995 Comment 08
.2/27/95

Payback Summary for 2.F32 T8

Product Class

2-F32 T8

. Design

E.E. Magnetic Avg.

Cathode Cutout Avg.

Electronic RS 10%

Electronic RS 50%

Electronic IS 10%

Electronic IS 50%

Max. Efficiency _

Original Case

Hrs of operation 4100

Elect Price 0.075

Sensitivities

Payback @8%

NA

3.8

6.2

4.6

6.7

6.2

5.6

Low High

Elect Price 0.055 0.105

Operating His 2500 8000

Cathode Cutout delta Price 2.00

Electronic delta Price 6.00

Electricity Price Sensitivity

Low High

5.18 2.71

8.43 4.42

6.28 3.29

9.09 4.76

8.45 4.42

7.65 4.01

Operating Hrs Sensitivity

Low High

6.22 1.95

10.14 3.17

7.55 2.36

10.93 3.42

10.16 3.17

9.20 2.88

P.

Ballast Price Sensitivity

Low

1.33

2.93

2.18

1.88

1.75

1.58

SENS2F32.XLS

Lamp Ballasts Workshop March 17, 1995 Comment 08
FLUORESCENT BALLASTS ENGINEERING ANALYSIS

KEY VARIABLES

WATTAGE

Equal Light Output

Fixture Corrections

BALLAST PRICES

LIGHTING OPERATING HOURS (by sector)

ELECTRICITY PRICES (by sector)

., CONSTANT PARAMETERS

LAMP LABOR COST

ALLAST LABOR COST

Except 3- and 4-Lamp Ballasts

LAMP EQUIPMENT COST C pv )

Except F32 T8 Electronic Rapid Start and Instant Start Operation

Lamp Ballasts Workshop March 17, 1995 Comment 08
FLUORESCENT BALLASTS ENGINEERING ANALYSIS

FIXTURE WATTAGE CORRECTIONS

for Ballasts

LBL ANSI WATTS

derived from data sets

GENERIC ANSI WATTS

from reference sou rce

GENERIC FIXTURE WATTS

from same reference source

LBL FIXTURE WATTS

LBL ANSI WATTS x

GENERIC FIXTURE WATTS GENERIC. ANSI WATTS

Lamp Ballasts Workshop March 17, 1995 Comment 08
FLUORESCENT BALLASTS ENGINEERING ANALYSIS

TANDEM WIRING

for 3-Lamp Ballasts

3- or 41-Lamp EEM and CC Ballasts on the Market

4_ -Lamp Ballasts assumed

2 Ballasts per 4- Fixture

(Design Option Electronic Ballasts are 4-Lamp Ballasts) 1 11

3-Lamp Ballasts Assumed Tandem-Wired

(1.5 Ballasts per 3-Lamp Fixture)

(Design Option Electronic Ballasts are 3-Lamp Ballasts)

Reduces Equipment Costs

(1.5 Ballasts rather than 2 Ballasts per Fixture)

Increases Labor Costs

(over 2-Ballast Fixtures)

New Data from LRI Survey show Tandem Wiring

only 20 Percent

Assuming One 2-Lamp and One 1-Lamp Ballast per Fixture

Gives Net Cost crease to and CC Ballast Options

Lamp Ballasts Workshop March 17, 1995 Comment 08
V"t,^ IV /^

"pj

11 Lff-^tav 0 it Jam LAST

ENO E I7i / NOMIC ANALY 1

e'INPUT DATA

EFFICIENCY DATA

OUTPUT DATA

Lamp Ballasts Workshop March 17, 1995 Comment 08
BEF for ES lamps

•error EEM 1 . 2 , 1 . 10, 1 . 12

•error MAX EFF 1 .2, 1 . 10

• Fixture watts

• Adjust 1 & 2 lamp like 3 & 4 lamp

• Normalized watts

Lamp Ballasts Workshop March 17, 1995 Comment 08
• Energy Costs

• Operating Hours

Discount Rates

• Ballast Service Life

Lamp Ballasts Workshop March 17, 1995 Comment 08
• Tables 1.1-1.16(ie 1.10)

• correct BEF

• adjust operating hours

• Tables 4 . 1-4. 16(ie 4. 10)

• correct per Table 1

• sensitivity analysis

- discount rate 16%

- energy cost -10%

- consumer price dill +10%

- operating hours

Lamp Ballasts Workshop March 17, 1995 Comment 08
Table 1. 10 -- Original Data

Two F96 T12/ES Lamps

Normalized

Ballast

Efficacy

Annual

Energy

Design Design ANSI Fixture Fixture Ballast Factor Use

No. Option Watts Watts Watts Factor (BEF) (kWh/yr)

0 Energy Efficient Magnetic 141.8 141.8 141.8 0.95 0.67 922

1 Electronic, Instant Start 10% 112.0 112.0 122.3 0.87 0.78 795

2 Electronic, Instant Start 50% 111.0 111.0 119.8 0.88 0.79 779

3 Maximum Efficiency 104.0 104.0 113.6 0.87 0.84 738

Lamp Ballasts Workshop March 17, 1995 Comment 08
Table 1.10 - Revised BEF

Two F96 T12/ES Lamps

Design Design ANSI Fixture

Normalized

Fixture Ballast

No. Option Watts Watts Watts Factor

0 Energy Efficient Magnetic 1351? '1:35.1 35.9 0.95

I Electronic, Instant Start 10% 112.0 112.0 122.3 0.87

2 Electronic, Instant Start 50% 111.0 111.0 119.8 0.88

3 Maximum Efficiency 0.87

Ballast Annual

Efficacy Energy

Factor Use

BEF) (kWh/yr)

0.78

0.79

878

795

779

762

Lamp Ballasts Workshop March 17, 1995 Comment 08
Table 4.10 -- Original Data

Excel Version of Engineering/Economies Tables

LBL, 3/3/99 -

Table 4.10

200 Electricity Cost ($1994+kWh)

Annual Lighting Items

Labor Rates ($I994 per hour)

Real Discount Rates

Period (years)

ENGINEERING/ECONOMIC CALCULATIONS FOR

Fluorescent Lamp Ballasts with

Two F96 T12/ES LAMP

CJMMERCIAL SECTOR

$0.075

6500

$29.35 $42.10

4% • 8% 12%

7.38

PV Ballast PV Lamp

Equip+ Equip + Total Ballast Normalized Annual

Labor Cost Labor Cost Installed Service Fixture Energy Annual Payback Total LCC ($)

Design (PV@8%) Cost Life Watts Use Elect (58%) 4% 8% 12%

No. Design Option ($ 1994) ($1994) ($1994) (years) (kWh/yr) Cost($) (Yew)

..... --- ------------------------------- -------- -....... -------------- -- -- -------------------- --- ----- ----------- ------------------ --------------- ----------------- --------------- ------------------ --------------- -------------- --------- ------

0 Energy-Efficient Magnetic

2 Electronic, Instant Start 10%

3 Electronic, Rapid Start 50%

4 Maximum Efficiency

46.68 50.40 97.08 7.38 141.8 922

68.36 50.40 118.76 7.38 122.3 795

68.36 50. 40 118.76 7. 38 119.8 779

68.36 50. 40 118.76 7. 38 113.6 738

69.13 NA .181 421 373

5962 2.3 413 391 350

58,42 2.0 436. 385 344

55.36 1,6 416 368 330

PV I.annp

Lamp Lamp Lamp Lamp Equip r Ballast Ballast Ballast Ballast

Equip Labor Time to Relamp Service Labor Cost Consumer Labor , Tune to Equip I

Design Cost Cost Change Life Life ($1994) Price Cost Install Labor Cost

No. Design Option ($1994) ($1994) (minutes) (hours) (years) 4% 8% 12.0% ($1901) ($IaQt) (minutes) ($1994)

............. --------°-------- ------------------------------------------ ---------- ----------------------- -------------- ---- ------------------ --------------- ------------------------------ ---- ------------------ --------------- --------------- ------------- --------------- ------------------

0 Energy-Efficient Magnetic 5.87 , 5,14 10.5 8400 1.29 56.00 50.40 45.80 20.18 2650 44.5 46.68

Lamp Replacement Cost:

2 Electronic, Instant Start 10% 5.87 5. 14 10.5 8400 1.29 56.00 50.40 45.80 41.86. 2650 44.5 6836

3 Electronic, Rapid Start 50% 5.87 5.14 10.5 840 1.29 56.0 50.40 45.80 4186 26.50 44.5 6836

4 Maximum Efficiency 5.87 5. 14 10.5 . 8400 1.29 56.00 5040 45,80 4196 26.50 44.5 6836

Lamp Ballasts Workshop March 17, 1995 Comment 08
Table 4. 10 - Revlaed BEF

Excel Version of Engineering/Economics Tables

LBL, 313195

Table 4.10 ENGINEERING/ECONOMIC CALCULATIONS FOR

Fluorescent Lamp Ballasts with

Two F96 TI2/ES LAMP

COMMERCIAL SECTOR

2000 Electricity Cost ($1994rkWh)

Annual Lighting Hours

Labor Rates (51994 per hour)

Real Discount Rates

Period (years)

$0.0750

6500

$29.35

4%

7.38

$42.10

8%

PV Ballast

Equip+

2%

PV Lamp

Equip+ otal allast ormalized nnual

Labor Cost Labor Cost Installed service Fixture Energy Annual Payback Total LCC ($)

Design

No. Design Option ($1994)

(PV@8%)

($1944)

Cost

($1994)

Life

(years)

Watt Use

(kWh/yr)

Elect (c8%) 4%

Cost(S) (years)

8% 12%

0 Energy-Efficient Magnetic 46.68 50.40 97.08 7.38 135.1 878 65.86 NA 61 404 358

2 Electronic, Instant Start 10% 68.36 50.40 118.76 7.38 122.3 795 59.62 3.5 443 391 350

3 Electronic, Rapid Start 50% 68.36 50.40 118.76 7.38 119.8 779 58.42 2.9 436 385 344

4 Maximum Efficiency 68.36 50.40 118.76 7.38 ' 111.3 762 57;17 2.5 428 378: 3381

Lamp Replacement Cost: Lamp

Equip

Design Cost

No. Design Option ($1994)

Lamp

Labor

cost

($1994)

Lamp

Time to

Change

(minutes)

Relamp

Life

(hours)

Lamp

Service

Life

(years) %

PV Lamp

Equip +

Labor Cost

($ 1994)

8% 2%

Ballast

Consumer

Price

($1994)

Ballast

Labor

cost

($ 1994)

Ballast

Time to

Install

(minutes)

Ballast

Equip +

Labor Cost

($1994)

0 Energy-Efficient Magnetic 5.87 5. 14 10.5 8400 1 .29 56.00 50.40 45.80 20. 18 26.50 44.5 46.68

2 Electronic, Instant Start 10% 5.87 5. 14 10.5 8400 1.29 56.00 50.40 45.80 41.86 26.50 44.5 68.36

3 Electronic, Rapid Start 50% 5.87 5.14 10.5 8400 1.29 56.00 50.40 45.80 41.86 26.50 44.5 68.36

4 Maximum Efficiency 5.87 5. 14 10.5 8400 1 . 29 56. 00 50.40 45.80 41.86 26. 50 44.5 68.36

Lamp Ballasts Workshop March 17, 1995 Comment 08
Table 1 . 10 - Revised BEF and Annual Lighting Hours

Two F96 T12/ES Lamps

Design Design ANSI Fixture

Normalized

Fixture Ballast

Ballast Annual

Efficacy Energy

Factor Use

No. Option Watts Watts Watts Factor BE kWh/ r

0 Energy Efficient Magnetic 135.1 1:35.1 1.35.1 0.95 : 0.70 608

I Electronic, Instant Start 10% 112.0 112.0 122.3 0.87 0.78 550

2 Electronic, Instant Start 50% 111.0 111.0 119.8 0.88 0.79 539

3 Maximum Efficiency 107.4 107.4 117.3 0.87 0.81 528'

Lamp Ballasts Workshop March 17, 1995 Comment 08
Table 4.10 - Revised BEF and Annual Lighting Hours

Excel Version of Engineering/Economics Tables

LBL, 3/3/95

Table 4.10

2000 Electricity Cost (M994/kWh) 50.0750

Annual Lighting Hours

Labor Rates ($1994 per hour) $29.35

Real Discount Rates 4%

Period (years) 10.67

$42.10

8%

esign

No. esign Option

PV Ballast

Equip+

Labor Cost

($1994)

0 Energy-Efficient Magnetic 46.68

2 Electronic. Instant Start 10'4 68.36

3 Electronic, Rapid Start 50% 68.36

4 Maximum Efficiency 68.36

Lamp Replacement Cost

Na Design Option

Lamp

Equip

Cost

($1994)

ENGINEERING/ECONOMIC CALCULATIONS FOR

Fluorescent Lamp Ballasts with

Two F96 T12/ES LAktP

COMMERCIAL SECTOR

12°4

PV Lamp

Equip+

Labor Cost

(PV/ 8%)

Total

Installed

Cost

Ballast

Service

Life

Normalized

Fixture

Watts

Annual

Energy

the

Annual

Elect

Payback

(@8°/.)

Total LCC (5)

4% 8% 2%

($1994) (51994) (years) (kWWyr) Cost(S) (years)

Lamp Lamp Lamp

Labor Tune to Relamp service

Cost

($1994)

Change Life Life

(minutes) (hours) (years)

0 Energy-Efficient Magnetic 5.87 5. 14 10.5 8400

2 Electronic, Instant Start10% 5.87 5. 14 10.5 8400

3 Electronic. Rapid Staff 50% 5.81 5.14 10.5 8400

4 Maximum Efficiency 5.87 5. 14 10.3 8400

4°%

PV Lamp

Equip +

Labor Cost

($1994)

8%. 12%

Ballast

Consumer

Price

($1994)

Ballast

Labor

cost

($1994)

Ballast .

Time to

Install

(minutes)

Ballast

Equip+

Labor Cost

(51994)

20.18 26.50 44.5 46.68

41.86 26.50 44.5 68.36

41.86 26.50 44.5 68.36

41.86 26.50 44.5 68.36

Lamp Ballasts Workshop March 17, 1995 Comment 08
Table 1. 10 - New Base Assumptions

Two F96.TI2/ES Lamps

Normalized

Ballast

Efficacy

Annual

Energy

Design Design ANSI Fixture Fixture Ballast Factor Use

No. Option Watts Watts Watts Factor (BEF) (kWh/yr)

0 Energy Efficient Magnetic 135. 1 135. 1 135.1 0.95 0.70 608

1 Electronic, Instant Start 10% 112.0 112.0 122.3 0.87 0.78 550

2 Electronic, Instant Start 50% 111.0 111.0 119.8 0.88 0.79 539

3 Maximum Efficiency 107.4 107.4 117.3 0.87 0.81 528

Lamp Ballasts Workshop March 17, 1995 Comment 08
Table 4.10 --10% Reduction In Electricity Cost Assumption

Excel Version of Engineer ng/Economics Tables

LBL, 3!3/95

Table 4.10 ENGINEERING/ECONOMIC CALCULATIONS FOR

Fluorescent Lamp Ballasts with

Two F96 T12/ES LAMP

COMMERCIAL SECTOR

2000 Electricity Cost ($1994/kWh)

Annual Lighting Hours

Labor Rates ($ 1994 per has)

Real Discount Rates

Period (years)

$0.0675

4500

$29.35

4%

10.67

$42.10

8%

PV Ballasl

Equip+

2%

PV Lamp

Equip+ otal allast ormalized nnual

Labor Cost Labor Cost Installed Service Fixture Energy Annual Payback Total LCC ($)

Design

No. Design Option ($1994)

(PV@8%.)

($1994)

Cost

($1994)

Life

(years)

Watts Use

(kWh/yr)

Elect

Cost(S)

(@896)

(years)

4% 8% 12%

0 Energy-Efficient Magnetic 46.68 46.06 92.73 10.67 135. 1 608 41.04 NA 397 334 287

2 Electronic, Instant Start 10% 68.36 46.06 114.41 10.67 122.3 550 37.15 5.6 386 328 296

3 Electronic, Rapid Start 50% 68.36 46.06 114.41 10.67 119.8 539 36.40 A7 379 323 281

4 Maximum Efficiency 68.36 46.06 114.41 10.67 117.3 328 35.62 4.0 373 $19 277

Lamp Replacement Cost: Lamp

E i

Lamp

L b

Lamp

T t R l

Lamp

S i

PV Lamp

Equip+

L b C

Ballast

C

Ballast

L b

Ballast Band

i

Design

No.

qu p

Cost

Design Option ($1994)

a or

Cost

($1994)

ime o

Change

(minutes)

e amp

We

(hours)

erv ce

Life

(yens) 4%

a or oat

($1994)

8% 12%

onsumer

Price

($ 1994)

a or

Cost

($1994)

Tune to

Install

(minutes)

Equ p +

Labor Cost

($1994)

0 Energy-Efficient Magnetic 5.87 5. 14 10.5 8400 1.87. 53.30 46.06 40.49 20. 18 26.50 44.5 46.68

2 Electronic, Instant Start 10% 5.87 5. 14 10.5 8300 1 .87 53.30 46.06 40.49 41.86 26.50 44.5 68.36

3 Electronic, Rapid Start 5096 5.87 5. 14 10.5 9400 1 .87 5330 46.06 40A9 41.06 26.50 44.5 68.36

4 Maximum Efficiency 5.87 5. 14 10.5 8400 1 .87 5330 46.06 40.49 41.86 26.50 44:3 68.36

Lamp Ballasts Workshop March 17, 1995 Comment 08
Table 4.10 -1ta% Discount Rate

Excel Vernon of Engineering/Economics Tables

LBL, 3/3/95

Table 4.10

2000 Electricity Cost ($1994/kWh) $0.0750

Annual Lighting Hours 4500

Labor Rates (S 1994 per hour) $2935 $42.10

Real Discount Rates 4% 8% 1636

Period (years) 10.67

ENGINEERINGIECONOMIC CALCULATIONS FOR

Fluorescent Lamp Ballasts with

Two F96 TI2/ES LAMP

COMMERCIAL SECTOR

PV Ballast

Equip +

PV Lamp

Equip + Total Ballot Normalized Annual

Labor Cost Labor Cost Installed service Fixture Energy Annual Payback Total LCC (S)

Design

No. Design Option ($1994)

(PV@8%)

($1994)

Cost

($1994)

Life

(years)

Watts the

(kWhryr)

Elect

Cost(S)

(@8%)

(years)

4% 8% 16%

0 Ettetgy-Efficient Magnetic 46.68 46.06 92.73 10.67 135.1 600 45.60 NA 436 366 273

2 Electronic, Instant Start l0% 68.36 46.06 114.41 10.67 122.3 550 41.28 5.0 421 357 273

3 Electronic, Rapid Start 50% 68.36 46.06 114.41 10.67 119.8 539 40.44 4.2 414 351 269

4 Maximum Efficiency 68.36 46.06 114.41 10.67 117.3 528 39.58 3.6 407 345 265

Lamp Replacement Cost Lamp

E ui

Lamp

Labor

Lamp

Time to Relam

Lamp

Service

PV Lamp

Equip +

Labor Cost

Ballot

Consumer

Ballast

Labor

Ballast

Time to

Ballast

E ui +

Design

No.

q p

cost

Design Option ($1994)

cost

($1994)

Change

(minutes)

p

Life

(hours)

Life

(years) 4%

(51994)

8% 1636

Price

($1994)

Cost

(51994)

Install

(minutes)

q p

Labor Cost

($1994)

0 Energy-Efficient Magnetic 5.87 5. 14 10.5 8400 1.87 5350 46.06 36. 14 20. 18 26.50 44.4 46.60

2 Electronic, Instant Stan 10% 5.87 5.14 10.5 9400 1.87 5350 46.06 36.14 41.96 26.50 44.5 68.36

3 E1ectronic, Rapid Start 50% 5.87 5.14 10.5 8400 1.87 5350 46.06 36.14 41.96 26.50 44.5 69.36

4 Maximum Efficiency 5.87 5. 14 10.5 8400 1.87 5350 46.06 36.14 41.86 26.50 44.5 69.36

Lamp Ballasts Workshop March 17, 1995 Comment 08
Table 4.10 -16% Discount Rate and 10% Reduction in Electricity Cost Assumption

Excel Version of Engineering/Economics Tables

LBL, 3/3/95

Table 4.10 ENGINEERING/ECONOMIC CALCULATIONS FOR

Fluorescent Lamp Ballasts with

Two F96 T12/ES LAMP

COMMERCIAL SECTOR

2000 Electricity Cost ($1994/kWh)

Annual Lighting Hours

Labor Rates ($1994 per hour)

Real Discount Rates

Period (years)

$0.0675

4500

$29.35

4%

10.67

$42.10

0%

PV Ballast

Equip +

L b C

L

PV Lamp

Equip+ otal allast ormalized nnual

a or ost Labor Coat Installed Service Fixture Energy Annual Payback Total LCC (S)

No. Design Option ($1994)

(PV@8%)

($1994)

Cost

($1994)

Life

(years)

Watts use

(kWh/yr)

Elect

Cost(S)

(@8%)

(years)

4% 8%

0 Energy-Efficient Magnetic 46.68 46.06 92.73 10.67 135.1 600 47.04 NA 397 334 2s0

2 Electronic, Instant Start 10% 66.36 46.06 114.41 10.67 1223 550 37.15 5.6 386 328 jft

3 Electronic, Rapid Start 50% 68.36 46.06 114.41 10.67 119.8 539 36.40 4.7 379 323 L49

4 Maximum Efficiency 68.36 46.06 114.41 10.67 117.3 528 35.62 4.0 373 318 24S

Lamp Replacement Cost: Lamp Lamp Lamp L-P

PV Lamp

Equip + Ballast Ballast Ballast Ballast

Design

No.

Equip

Cost

Design Option ($1994)

Labor

cost

($1994)

Time to

Change

(minutes)

Relamp

Life

(boors)

Service

Life

(years) 4%

Labor Cost

($1994)

8% Lint

Conur!mer

Price

($1994)

Labor

Cost

($1994)

Time to

Install

(minutes)

Equip +

Labor Cost

($1994)

0 Energy-Efficient Magnetic 5.87 5.14 10.5 8400 1 .67 53.30 46.06 20.18 26.50 44.5 46.68

2 Electronic, instant Start 10% 5.87 5.14 10.5 8400 1.87 53.30 46.06 j¢!4 41.86 26.50 44.5 68.36

3 Electronic. Rapid Start 50% 5.8,7 5.14 10.5 8400 1.87 5330 46.06 Lq 41.86 26.50 44.5 68.36

4 Maximum Efficiency - 5.87 5.14 10.5 8400 1.87 5330 46.06 ^LL4 41.86 26.50 44.5 60.36

Lamp Ballasts Workshop March 17, 1995 Comment 08
Table 4.10 - 16% Discount Rate, 10% Reduction In Electricity Cost Assumption, and 10% Increase In Assumed Difference of Ballast Consumer Price for Baseline and Design Option Ballasts

Excel Version of Engineering/Economics Tables

LBL, 373/95

Table 4.10

2000 Electricity Cost (119941kWh) 80.0675

Annual Lighting Hours 4500

Labor Rates (S 1994 per hour) $29.35 142.10.

Real Discount Rates 4% 8%

Period (years) 10.67

ENGINEERING/ECONOMIC CALCULATIONS FOR

Fluorescent Lamp Ballasts with

Two F96 T12/ES LAMP

COMMERCIAL SECTOR

esign

No. esign Option

PV Ballast

Equip +

Labor Cost

(11994)

PV Lamp

Equip +

Labor Cost

(PV@8%)

($1994)

Total

Installed

Cost

(11994)

Ballast

Service

Life

(years)

Normalized

Fixture

Watts

Annual

Energy

Use

(kWWyr)

Annual

Elect

Cost($)

0 Energy-Et6cientMagnetic 46.68 46.06 92.73 10.67 135.1 608 41.04

2 Electronic, Instant Start 10% 3053 46.06 11658 10.67 122.3 550 37.15

3 Electronic, Rapid Start 50% 7x:33. 46.06 11658 10.67 119.8 539 36.40

4 Maximum Efficiency 7G 46.06 116,18 10.67 117.3 528 35.62

Payback

(@8%)

(years)

NA

6.1

Lamp Replacement Cost Lamp

E i

Lamp

L b

Lamp Lamp

PV Lamp

Equip +

Design

No.

qu p

Cost

Design Option ($1994)

a or

cost

(11994)

Tune to

Change

(minutes)

Relunp

Life

(hours)

service

Life

(years)

Labor Cost

($1994)

8%

0 Energy-Efficient Magnetic 3.87 5.14 10's 8400 1.87 53.30 46.06 j¢ ji

2 Electronic, Instant Start 10% 3.87 5.14 10.5 8400 1.87 53.30 46.06 j¢(q

3 Electronic, Rapid Start 50% 5.87 3.14 10.5 8400 1,7 53.30 46.06 L jq

4 Maximum Efficiency 5.87 5.14 10.5 8400 1.87 53.30 46.06

Taal LCC (S)

4% 8% 1691

397 334

3811 331

.935

s30

Ballast Ballast Ballast Ballast

Consumer Labor Tune to Equip +

Price Cost Install Labor Cost

($1994) (11994) (minutes) (11994)

20.18 26.50 44.5 46.68

403 26.50 44.5 70.53

26.50 44.5 70.53

26.30 44.5 70-53

Lamp Ballasts Workshop March 17, 1995 Comment 08