A small furniture manufacturer produces four products. Each product must go through three stages of the manufacturing process: assembly, finishing, and inspection. The assembly time, finishing time, and inspection time for each unit of each product are provided in the table below. The unit cost, selling price, and the minimum demand for each product are also provided.
|Product 1||Product 2||Product 3||Product 4||Available Hours|
|Cost per unit||$73||$62||$54||$48|
|The minimum demands (units)||35||60||45||80|
To keep a balance, the number of product 4 units at most twice the number of product 2 units.
1) Formulate a linear programming model for this problem. Clearly define the variables, objective function, and constraints.
2) Solve the problem using Excel and answer the following questions:
a) What is the optimal solution to this LP problem?
b) Would the optimal solution change if the Selling Price of Product 4 increases by $80 and all other Products are unchanged? Explain.