Show me the steps to solve

Question $1(22$ marks$)$

Beluga caviar is one of the expensive foods that can be purchased from the market and sold to

restaurants and supermarkets. The CityTasty seafood distributor plans to buy Beluga caviar

and sell it later at an appropriate price. Sealed caviar can last up to $6$ weeks when stored

properly. The company has a large frozen storage facility which can store up to $20000$ kg of

caviar each week. Currently, it has $4500$ kg of fresh Beluga caviar in storage. On Friday every

week, CityTasty can buy Beluga caviar from the market and sell some or all its inventory at

market price in that week. Unsold caviar could be stored at a cost of $$600$ per kg per week. The

estimates of market prices of Beluga caviar for the next four weeks are $$21000,$ $$20790,$

$$22245$ and $$21133$ per kg $.$ As demand is anticipated to increase in the forthcoming festival

period, CityTasty would like to keep $5000$ kg of Beluga caviar in storage at the end of week $4.$

In order to determine the optimal strategy of buying, selling and storage for each of the next

four weeks to maximize the total profit, CityTasty has formulated the problem by a linear

program.

Let B$\_($t$)=$ amount $($kg$)$ of Beluga caviar to be bought in week t$($t$=1,2,3,4)$

S$\_($t$)=$ amount $($kg$)$ of Beluga caviar to be sold in week t$($t$=1,2,3,4)$

I$\_($t$)=$ remaining inventory $($kg$)$ of Beluga caviar to be stored in week t$($t$=1,2,3,4)$

Linear programming formulation:

Max.Z$=21000($S$\_(1)-$B$\_(1))+20790($S$\_(2)-$B$\_(2))+22245($S$\_(3)-$B$\_(3))+21133($S$\_(4)-$B$\_(4))-600($I$\_(1)+$I$\_(2)+$I$\_(3)+$I$\_(4))$

subject to:

q$,\{($:$[-$B$\_(1)+$S$\_(1)+$I$\_(1),=4500)$:$\}$

B$\_(2)-$S$\_(2)+$I$\_(1)-$I$\_(2)=0$

B$\_(3)-$S$\_(3)+$I$\_(2)-$I$\_(3)=0$

B$\_(4)-$S$\_(4)+$I$\_(3)-$I$\_(4)=0$

I

I

I

I

All variables $>=0]$ Question $1($continued$)$

When the linear program was solved using Solver, the following sensitivity report was obtained.

Constraints

Use the linear program and the sensitivity report to answer the following parts $($a$)$ to $($f$).$ Each

part is independent.

$($a$)$ What is the optimal buying$-$selling$-$storing plan for the next four weeks?

$(4$ marks$)$

$($b$)$ What is the expected maximum profit for the next four weeks?

$(3$ marks$)$

$($c$)$ For each of the week$($s$)$ in which the storage facility is fully utilized, determine the impact

on the maximum profit by acquiring more storage capacity. Up to what storage limit would

this impact be valid? Alternatively, explain why it could not be determined from the

sensitivity report, assuming all other factors remain unchanged.

$(4$ marks$)$

$($d$)$ Is there any alternative optimal plan? Explain.

$(2$ marks$)$ $$600$ per kg per week