The city of Metropolis is considering replacing incandescent bulbs in traffic lights with light-emitting diode (LED)...

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 and upload here.

1-  Determine the payback period of converting Metropolis’s 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 LED’s 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 justification 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.

Homework Answers

Answer #1
Part 1 Investments 46.02Million
Savings Per Year 8.85Million
Calculation of payback period
Year Energy Savings Cumulative Savings
1 8.85 8.85
2 8.85 17.7
3 8.85 26.55
4 8.85 35.4
5 8.85 44.25
6 8.85 53.1
Payback = 5+(46.02-44.25)/8.85 5.2Years
Part 2 & 3 Particulars Amount
Investments 46.02
Savings each year 8.85
P.V Factor( 5%,7) 5.786
Total Savings in present value
As the amount of investment is less than the amount of savings in present value city should finance the investment in LED's
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
Active Questions
  • On the standard coordinate grid at initial moment, ship Tiger is at the position (0, 215),...
    asked 3 minutes ago
  • Please follow the instructions for credit, thank you!!! #1 Skycell, a major European cell phone manufacturer,...
    asked 10 minutes ago
  • Describe how the Standard Penetration Test (SPT) is conducted. How is the raw number of blow...
    asked 24 minutes ago
  • 1. A 28-year-old male graduate student was born with an inherited predisposition to colon cancer due...
    asked 26 minutes ago
  • Choose two of the conflict theorists: Bonger, Dahrendorf, or Vold and compare and contrast: the culture...
    asked 30 minutes ago
  • The Energy Information Administration reported that the mean retail price per gallon of regular grade gasoline...
    asked 33 minutes ago
  • What is the preferred beverage ordered at lunch independent of age bracket in a hospital cafeteria?...
    asked 37 minutes ago
  • Payroll. Canada. In your own words, explain how legislated wages in lieu of notice are treated...
    asked 38 minutes ago
  • Let A and a be the alleles at a locus l in a population evolving with...
    asked 47 minutes ago
  • A certain quantum mechanical system has the energy levels shown in the accompanying diagram. The energy...
    asked 50 minutes ago
  • How does surface energy influence protein adsorption? Think of contact angles to base your answer from.
    asked 56 minutes ago
  • Begin by briefly describing Scarr’s theory of genotype-environment correlations. Then think about ways of illustrating the...
    asked 1 hour ago