Solve LP Application based Problem
Company A-XYZ Ltd based in Hatfield UK manufactures four products and requires anOperations Research consultant to help decide on their weekly optimal product mix. Thecompany has capacity constraints on the machines used in the factory.
The OR consultant formulated the companys product mix problem as a linear programmingproblem. The formulated linear programming problem will be presented to you in the test.
You are required to:
(i) Solve the linear programming problem using Microsoft Excel Solver.
(ii) Discuss the results.