Evaluate the economics of three light bulb options with the following characteristics: Bulb style Incandescent CFL...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Evaluate the economics of three light bulb options with the following characteristics: Bulb style Incandescent CFL LED Unit cost ($/bulb) Energy consumption (W) Life (hr) 100 23 19 0.30 1.50 6 Use the following additional data for this problem: Residential electricity cost (8/kWh) 0.12 3 345 0.06 2.50 Bulb use (hr/day) Days of use/year Discount rate Cost of changing bulb (8) 750 7,000 18,000 Calculate the total annual cost of each option, which comprises the sum of the annualized bulb cost and the annual electricity cost. To calculate the annualized cost of the bulb, first calculate the bulb lifetime in years, and then use that value as the "number of periods" argument in the PMT function. The cost of changing the bulb is labor cost incurred each time a bulb is changed. To get total bulb cost, this labor cost should be added to the bulb cost for each change. Assume all values are in real terms. Once you have the solution to the base problem, do the following breakeven and sensitivity analyses: (a) Suppose the bulb is going to a very low usage spot like a closet such that the anticipated usage is 0.5 hours/day for 100 days/year. How does that change your results? (b) What is the breakeven LED bulb price between the LED and CFL option? (c) What is the breakeven interest rate between the LED and CFL? How do you interpret this interest rate? (d) Suppose that there is a carbon tax that increases electricity price by 30%. Does that change the ranking of the alternatives in terms of total cost? Evaluate the economics of three light bulb options with the following characteristics: Bulb style Incandescent CFL LED Unit cost ($/bulb) Energy consumption (W) Life (hr) 100 23 19 0.30 1.50 6 Use the following additional data for this problem: Residential electricity cost (8/kWh) 0.12 3 345 0.06 2.50 Bulb use (hr/day) Days of use/year Discount rate Cost of changing bulb (8) 750 7,000 18,000 Calculate the total annual cost of each option, which comprises the sum of the annualized bulb cost and the annual electricity cost. To calculate the annualized cost of the bulb, first calculate the bulb lifetime in years, and then use that value as the "number of periods" argument in the PMT function. The cost of changing the bulb is labor cost incurred each time a bulb is changed. To get total bulb cost, this labor cost should be added to the bulb cost for each change. Assume all values are in real terms. Once you have the solution to the base problem, do the following breakeven and sensitivity analyses: (a) Suppose the bulb is going to a very low usage spot like a closet such that the anticipated usage is 0.5 hours/day for 100 days/year. How does that change your results? (b) What is the breakeven LED bulb price between the LED and CFL option? (c) What is the breakeven interest rate between the LED and CFL? How do you interpret this interest rate? (d) Suppose that there is a carbon tax that increases electricity price by 30%. Does that change the ranking of the alternatives in terms of total cost?
Expert Answer:
Answer rating: 100% (QA)
Here are the calculations for the economics of the three light bulb options Incandescent Bulb life 7... View the full answer
Related Book For
Engineering Economy
ISBN: 978-0132554909
15th edition
Authors: William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
What is your debt payments-to-income ratio if your debt payments total $684 and your net income is $2,000 per month?
-
Inside an infinitely long circular cylinder charged uniformly with volume density p there is a circular cylindrical cavity. The distance between the axes of the cylinder and the cavity is equal to a....
-
A geodesic dome constructed with an aluminum framework is a nearly perfect hemisphere; its diameter measures 55.0 m on a winter day at a temperature of - 15C. How much more interior space does the...
-
One interesting property of digital assets is that they can be reproduced and dis tributed via the Internet at very little cost. What are some of the implications of having a product with a marginal...
-
1. How is the number of customers who arrive on the lot on a Saturday morning distributed? 2. Suppose Ms. McNeil currently uses five salespeople on her lot on Saturday mornings. Using the probability...
-
Given Per Square Foot Total Square Footage A B A B Iding size (Sq. ft.) 80,000 ht $ 100 $ 120 $ 8,000,000 $ 90,000 10,800,000 intenance (fixed cost) (23) (30) (1,840,000) (2,700,000) Net Operating...
-
Consider the equilibrium NO 2 (g) NO(g) + 1/2O 2 (g). One mole of NO 2 (g) is placed in a vessel and allowed to come to equilibrium at a total pressure of 1 bar. An analysis of the contents of the...
-
Question 1: Solve matrix by finding the values of x and y Question 2: Find A 234 -3-3-2 32 -2 2 -1 [12 points] 3x-2y=6 2x+y=11 [12 points]
-
How does a computer system affect the concentration of assets within an organization? What implication does the effect have for internal controls?
-
Relative to a manual system, is it easier or harder to implement adequate management supervision of employees using a computer system? Explain.
-
What impact does the use of computers have on the nature and conduct of the evidence evaluation function carried out by auditors?
-
How does the continuing evolution of computer hardware and software technology affect an auditor's ability to (a) understand controls, and (b) collect evidence on the reliability of controls?
-
How does an organization compare recorded accountability with assets when computer systems are used? What controls must be exercised to ensure the veracity of this process?
-
Prepare a schedule of interest expense and bond amortization for 2025-2027. (Round answer to 2 decimal places, e.g. 38,548.25.) Cash Paid Schedule of Interest Expense and Bond Premium Amortization...
-
The process of collaborative goal setting by a manager and subordinate, the extent to which goals are accomplished is a major factor in evaluating and rewarding the subordinate's performance. It is...
-
Extended Learning Exercise There are two customers requiring three-phase electrical ser-j vice, one existing at location A and a new customer at location B. The load at location A is known to be 1110...
-
What is the minimum number of loaves that must be sold per year to justify installing Machine B instead of buying the loaves from the supplier? (a) 37,529 (b) 14,373 (c) 22,076 (d) 75,059 (e) 7,506
-
Suppose that annual income from a rental property is expected to start at $1,300 per year and decrease at a uniform amount of $50 each year after the first year for the 15-year expected life of the...
-
In the preparation of an analytic flowchart for a payroll processing application, which of the following symbols could be used to indicate the payroll data? (a) connector symbol (b) decision symbol...
-
In the preparation of an analytic flowchart, which of the following symbols should be used when flowlines are broken due to a page limitation? (a) terminal symbol (b) connector symbol (c) manual...
-
Assume trays are plug flow, and repeat Problem 16.D21 parts a and \(b\). In addition, calculate \(\mathrm{E}_{\mathrm{pt}}\) for the three mole fractions \(\mathrm{x}_{\mathrm{W}}=0.48,0.36\), and...
Study smarter with the SolutionInn App