Question: need help thanks 3. Trading decision: (20 marks) A small firm buys and sells wheat. They own a warehouse with a capacity of 10,000 bushels,

need help thanks
3. Trading decision: (20 marks) A small firm buys and sells wheat. They own a warehouse with a capacity of 10,000 bushels, and as of late August, there will be 2000 bushels in the warehouse. Wheat is delivered to the warehouse during the first week of the month, and it is sold and shipped around the middle of the month. All transactions are on a cash basis because the season is short, and the firm expects to have $20,000 in its accounts at the end of August. This amount is available for making September purchases. Assume inventory costs are zero. The latest predictions of market prices are shown in the table below: Sept. 2019 Oct. 2019 Nov. 2019 Buy $5.45 $5.75 $6.00 Sell $6.05 $6.25 $6.30 a) (5 marks) Formulate a network LP (please show your network) for the above problem. Note: Buying takes place at the beginning of the months. So, we cannot buy more than what the cash at the beginning of the month allows b) (5 marks) Implement your above model in excel. c) (5 marks) Use Solver to determine the best buy and sell schedule that would yield the maximum profit for the firm. Write down the optimal schedule and also the optimal total profit. d) (5 marks) Identify some key insights from the sensitivity reportStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
