Transcribed Image Text
In: AccountingA certain dealer owns a warehouse that can store a maximum of600 units of a...A certain dealer owns a warehouse that can store a maximum of600 units of a given commodity. He has on hand 100 units of thecommodity and knows the buying and selling price for the next 5time periods. They are:PERIODBUYING PRICESELLING PRICE1151621717321204191951620He is permitted to sell up to theamount that he has in his warehouse at the beginning of eachperiod. If he buys in a given period, delivery will be made so thatit is in storage at the beginning of the next period. Let(Xi, Yi) denote the amount he buys and sellsin time-period i respectively. What is the optimal buyingsellingstrategy.Formulate the linear programming problem.  Develop a spreadsheet and solve the problem.