Light-emitting diode (LED) light bulbs have become required in recent years, but do they make financial sense? Suppose a typical 60-watt incandescent light bulb costs $.45 and lasts for 1,000 hours. A 7-watt LED, which provides the same light, costs $2.25 and lasts for 40,000 hours. A kilowatt-hour of electricity costs $.121, which is about the national average. A kilowatt-hour is 1,000 watts for 1 hour. However, electricity costs actually vary quite a bit depending on location and user type (you can get information on your rates from your local power company). An industrial user in West Virginia might pay $.04 per kilowatt-hour whereas a residential user in Hawaii might pay $.25. You require a 10 percent return and use a light fixture 500 hours per year. What is the break-even cost per kilowatt-hour? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 6 decimal places, e.g., 32.161616.) Break-even cost

Light-emitting diode (LED) light bulbs have become required in recent years, but do they make financial sense? Suppose a typical 60-watt incandescent light bulb costs $.45 and lasts for 1,000 hours. A 7-watt LED, which provides the same light, costs $2.25 and lasts for 40,000 hours. A kilowatt-hour of electricity costs $.121, which is about the national average. A kilowatt-hour is 1,000 watts for 1 hour. However, electricity costs actually vary quite a bit depending on location and user type (you can get information on your rates from your local power company). An industrial user in West Virginia might pay $.04 per kilowatt-hour whereas a residential user in Hawaii might pay $.25. You require a 10 percent return and use a light fixture 500 hours per year. What is the break-even cost per kilowatt-hour? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 6 decimal places, e.g., 32.161616.) Break-even cost

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A health insurance policy pays 70 percent of physical therapy costs after a $200 deductible. In contrast, an HMO charges $13 per visit for physical therapy. How much would a person save with the HMO if he or she had 10 physical therapy sessions costing $45 each?
Multiple Choice As the discount rate increases, the present value of a positive cash flow to be received at a particular time in the future: gets closer to zero gets larger without limit stays unchanged gets smaller without limit
If you purchase 3 gallons of milk for $10.17, how much would 1-quart cost? How much would 1 fluid ounce cost? How much would 1 cup cost?
You are considering buying a 30-HP electric motor which has an efficiency rating of 89%. The motor costs $10,000 and will be used for 10 years. The expected salvage value at that time is $1,000. The cost to run the electric motor is $0.09 per kWh for 2,000 hours a year. (1HP=0.7457kW.)(1 HP=0.7457 kW.) What is the total annual equivalent cost of owning and operating the motor for 10 years at an interest rate of 12% per year? Answer must be shown in Excel!
RoboGarden sells a robot lawn aerator. At the current price, RoboGarden's contribution margin is $128.26 per unit. Because of a shortage of silicon chips, RoboGarden expects variable cost to increase by $9.32. In response, RoboGarden is thinking about raising its selling price by $28.44. Calculate the percent profit breakeven metric for this situation. Report the correct sign for the result. Report your answer as a percent. Report -25.5%, for example, as "-25.5". Rounding: tenth of a percent.
Assume “Jane” saves $10,000 per year for 10 years starting at age 25. At age 35 she no longer is able to save but leaves her accumulated savings invested until age 65 when she retires. Assume “John” does not begin saving until age 35, but then saves $10,000 per year until age 65 when he also retires. Assume John and Jane invest their entire wealth in the same mutual fund. Who accumulates a larger retirement nest egg? 1. Answer this question by building an Excel spreadsheet that allows you to show the difference in wealth at age 65 assuming an annual rate of return of 8%. Make sure your model allows you to change the assumed rate of return and automatically recalculate the difference in wealth at age 65. 2. At what assumed rate of return are John and Jane’s wealth at age 65 equal? Use “Goal Seek” in order to find this rate of return. 3. Create a graph to clearly show how final wealth for John and Jane depends on the rate of return. Start at 0% and increase the rate of return in…
A producer of pocket calculators estimates that the calculators fail at a rate of oneevery five years. The calculators are sold for $25 each with a one-year freereplacement warranty but can be purchased from an unregistered mail-ordersource for $18.50 without the warranty. Is it worth purchasing the calculator withthe warranty?
An online news platform is hosting sports news on a local webserver. Assuming the webserver is valued at $10,000. This webserver crashed 7 times in one year and in every crash, it resulted in a 3% loss. Calculate the expected losses using single loss expectancy (SLE) and annualize Loss expectancy (ALE)
Your answer is partially correct. An independent contractor for a transportation company needs to determine whether she should upgrade the vehicle she currently owns or trade her vehicle in to lease a new vehicle. If she keeps her vehicle, she will need to invest in immediate upgrades that cost $5,200 and it will cost $1,300 per year to operate at the end of year that follows. She will keep the vehicle for 5 years; at the end of this period, the upgraded vehicle will have a salvage value of $3,800. Alternatively, she could trade in her vehicle to lease a new vehicle. She estimates that her current vehicle has a trade-in value of $9,800 and that there will be $4,100 due at lease signing. She further estimates that it will cost $2,900 per year to lease and operate the vehicle. The independent contractor's MARR is 11%. Compute the EUAC of both the upgrade and lease alternatives using the insider perspective. Click here to access the TVM Factor Table Calculator. 1943.56 EUAC(keep): $…
Which of the following is NOT an example of an automatic stabilizer? Personal Income Tax Food Stamps Stimulus Package Unemployment Insurance
A firm sells two products. Product R sells for $20; its variable cost is $6. Product S sells for $50; its variable cost is $30. Product R accounts for 60 percent of the firm’s sales, while S accounts for 40 percent. The firm’s fixed costs are $4 million annually. Calculate the firm’s break-even point
“As soon as the customer places an Order, it is received by the Sales department and a Sales Order is created. The Sales Order is sent to the Finance Department to check if the customer has any outstanding balance for more than 60 days. The AR Clerk at the Finance Department checks and sends the results back to the Sales Department. If there is an outstanding balance for more than 60 days, the Sales Department puts the Order on hold and notifies the customer. Otherwise, the Order Entry Clerk creates an Order Confirmation and sends it to the customer. Simultaneously a Picking List is generated and sent to the Order Fulfilment Department who picks up the next set of process steps. The Order Fulfilment Department receives the Picking List and determines which Warehouse is closest to the Customer location. The Picking List is sent to that Warehouse location. There, the items from the Picking List are picked. An Invoice is generated and printed. The items are packed along with the printed…