Solve LP Application based Problem
Flat 50% Off Order New Solution
Company A-XYZ Ltd based in Hatfield UK manufactures four products and requires an Operations Research consultant to help decide on their weekly optimal product mix. The company has capacity constraints on the machines used in the factory.
The OR consultant formulated the company’s product mix problem as a linear programming problem. 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.
