Question
The city of Metropolis is considering replacing incandescent bulbs in traffic lights with light-emitting diode (LED) lights because they use significantly less energy and last
The city of Metropolis is considering replacing incandescent bulbs in traffic lights with light-emitting diode (LED) lights because they use significantly less energy and last much longer without abrupt failure. Currently Metropolis has 80,000 incandescent bulbs in traffic lights at approximately 12,000 intersections. It is estimated that replacing all the incandescent bulbs with LED will cost $46.02 million. However, the investment is also estimated to save the city $8.85 million per year in energy costs. Answer the following questions on a Word Doc or Excel Spreadsheet :
1- Determine the payback period of converting Metropoliss traffic lights to LEDs.
2- If the average life of an incandescent traffic light is one year and the average life of an LED traffic light is seven years, should the city finance the investment in LEDs at an interest rate of 5% per year? Support your answer by showing calculations or copying and pasting your spreadsheet.
3- Assume the project manager for the city of Metropolis asked you to provide justific2- ation for the project. Write a brief email to the project manager describing why or why not Metropolis should invest in LED lights using the support figures you calculated for #2.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started