Question: Q2 (5 marks) Use mixed integer linear programming to solve the problem regarding the monthly demancBuppose that holding cost is applied to the ending inventory.

Q2 (5 marks) Use mixed integer linear programming to solve the problem regarding the monthly demancBuppose that holding cost is applied to the ending inventory. - Develop the mathematical model in the W'ord document. - Solve the problem in Excel . Develop a plan in the W'ord document and explain when and how many products should be ordered in order to minimise the total cost. - Recalculate the optimal value of objective function (total cost with the new assumption that the holding cost is applied to the average inventory (not ending inventory)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
