Refer to Problem 6-8. Disposing of incandescent light bulbs is just like getting rid of and recycling glassware in general. However, this is not the case for CFLs. Disposing of CFLs is complicated by the fact that each lamp contains a small amount of mercury, which is a very environmentally dangerous substance. Write a brief report of your findings for your boss for each of the following scenarios (11.3):
a. Develop an Excel spreadsheet to investigate the sensitivity of choice of lighting systems when the CFL disposal cost varies from $1.00 to $5.00 per lamp.
b. Use your spreadsheet to explore the sensitivity of bulb or lamp choice as the cost of electricity varies from $0.04 per kWh to $0.16 per kWh.
c. Use your spreadsheet to quantify the sensitivity of bulb or lamp choice when CFLs last 5, 6, 7, 8, 9, and 10 times as long as incandescent bulbs.