Refer to question 45 at the end of chapter 3 and answer the following questions. a. Create
Question:
Refer to question 45 at the end of chapter 3 and answer the following questions.
a. Create a Spider Plot to summarize what happens to the optimal total profit as the total storage capacity increases from 300,000 cf to 400,000 cf in 10,000 cf increments.
b. Which of the storage capacity amounts considered in the previous question results in the highest profit (without having excessive storage capacity)?
c. How much should the company be willing to pay to increase their storage capacity to 350,000 cf?
d. Suppose the gas trading company has increased its storage capacity to 350,000 cf. Now assume a gas producer is in need of an extra 50,000 cf of storage capacity for the next 10 days and wants to buy this capacity from the gas trading firm. What is the least amount of money the gas trading company should demand to provide this capacity?
Step by Step Answer:
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics
ISBN: 1233
8th Edition
Authors: Cliff T. Ragsdale