The owner of a company that supplies home heating oil would like to determine whether to offer
Question:
The owner of a company that supplies home heating oil would like to determine whether to offer a solar heating installation service to its customers. The owner of the company has determined that a startup cost of $150,000 would be necessary, but a profit of $2,000 can be made on each solar heating system installed. The owner estimates the probability of various demand levels as follows:
Number of Units................ Installed Probability
50 ...........................................0.40
100..........................................0.30
200..........................................0.30
a. Construct a payoff table, indicating the events and alternative courses of action.
b. Construct a decision tree.
c. Construct an opportunity loss table.
d. Compute the expected monetary value (EMV) for offering this solar heating system installation service.
e. Compute the expected opportunity loss (EOL) for offering this solar heating system installation service.
f. Explain the meaning of the expected value of perfect information (EVPI) in this problem.
g. Compute the return-to-risk ratio (RTRR) for offering this solar heating system installation service.
h. Based on the results of (d), (e), and (g), should the company offer this solar heating system installation service? Why?
i. How would your answers to (a) through (h) be affected if the startup cost were $200,000?
Step by Step Answer:
Statistics For Managers Using Microsoft Excel
ISBN: 9780134173054
8th Edition
Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat