Answered step by step
Verified Expert Solution
Question
1 Approved Answer
#44 A natural gas trading company wants to develop an optimal trading plan for next 10 days. The following table summarizes the estimated prices per
#44
A natural gas trading company wants to develop an optimal trading plan for next 10 days. The following table summarizes the estimated prices per thousand cubic feet (cf) at which the company can buy and sell natural gas during this time. The company may buy gas at the "Ask" price and sell gas at the "Bid" price. The company currently has 150,000 cf of gas in storage and has a maximum storage capacity of 300,000 cf. To maintain the required pressure in the gas transmission pipeline system, the company can inject no more than 200,000 cf into the storage facility each day and can extract no more than 180,000 cf per day. Assume extractions occur in the morning and injections occur in the evening. The owner of the storage facility charges a storage fee of 5% of the market (bid) value of the average daily gas inventory. (The average daily inventory is computed as the average of each day's beginning and ending inventory.) Create a spreadsheet model for this problem and solve it. What is the optimal solution? Assuming price forecasts for natural gas change on a daily basis, how would you suggest the company in this problem actually use your model? A natural gas trading company wants to develop an optimal trading plan for next 10 days. The following table summarizes the estimated prices per thousand cubic feet (cf) at which the company can buy and sell natural gas during this time. The company may buy gas at the "Ask" price and sell gas at the "Bid" price. The company currently has 150,000 cf of gas in storage and has a maximum storage capacity of 300,000 cf. To maintain the required pressure in the gas transmission pipeline system, the company can inject no more than 200,000 cf into the storage facility each day and can extract no more than 180,000 cf per day. Assume extractions occur in the morning and injections occur in the evening. The owner of the storage facility charges a storage fee of 5% of the market (bid) value of the average daily gas inventory. (The average daily inventory is computed as the average of each day's beginning and ending inventory.) Create a spreadsheet model for this problem and solve it. What is the optimal solution? Assuming price forecasts for natural gas change on a daily basis, how would you suggest the company in this problem actually use your modelStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started