2. (50pts) McDonald-Pelz wants to determine its oil trading strategy for the next two weeks (10...

Transcribed Image Text:

2. (50pts) McDonald-Pelz wants to determine its oil trading strategy for the next two weeks (10 business days). The following table summarizes the estimated purchase prices (the Ask price, per thousand barrels) and sales prices (the Bid price, per thousand barrels) during each of the next 10 business days. DAY 1 2 3 4 5 6 7 8 9 10 ASK $3,220 $4,100 $6,130 $4,190 $4,050 $5,120 $5,280 $4.230 $3,150 $4,180 BID $3,060 $4,010 $6,030 $4,060 $4,010 $5,020 $5,100 $4,080 $3,010 $4,010 McDonald-Pelz currently has 150,000 barrels of oil in storage. The storage facility it rents has a maximum storage capacity of 500,000 barrels. Due to safety regulations, a maximum of 180,000 barrels can be taken out of the storage facility per day. At the same time, a maximum of than 200,000 barrels can be added to the storage each day. The storage facility's owner charges a fee equal to 5% of the bid value of the average daily oil inventory. a) Create a spreadsheet model that can be used to determine an optimal trading strategy and solve it. b) What is the optimal solution? 2. (50pts) McDonald-Pelz wants to determine its oil trading strategy for the next two weeks (10 business days). The following table summarizes the estimated purchase prices (the Ask price, per thousand barrels) and sales prices (the Bid price, per thousand barrels) during each of the next 10 business days. DAY 1 2 3 4 5 6 7 8 9 10 ASK $3,220 $4,100 $6,130 $4,190 $4,050 $5,120 $5,280 $4.230 $3,150 $4,180 BID $3,060 $4,010 $6,030 $4,060 $4,010 $5,020 $5,100 $4,080 $3,010 $4,010 McDonald-Pelz currently has 150,000 barrels of oil in storage. The storage facility it rents has a maximum storage capacity of 500,000 barrels. Due to safety regulations, a maximum of 180,000 barrels can be taken out of the storage facility per day. At the same time, a maximum of than 200,000 barrels can be added to the storage each day. The storage facility's owner charges a fee equal to 5% of the bid value of the average daily oil inventory. a) Create a spreadsheet model that can be used to determine an optimal trading strategy and solve it. b) What is the optimal solution?

Answer rating: 100% (QA)

To create a spreadsheet model to determine the optimal trading strategy for McDonaldPelz we can foll... View the full answer