Question: 2. [25 marks] The Excel output and sensitivity report from a linear programming problem are shown below. Northorn MInndiainrle (a) (4 marks) What is the

 2. [25 marks] The Excel output and sensitivity report from a

2. [25 marks] The Excel output and sensitivity report from a linear programming problem are shown below. Northorn MInndiainrle (a) (4 marks) What is the optimal manufacturing plan and corresponding profit represented by the objective function? (b) (3 marks) Identify the binding and non-binding constraint(s) Consider each of the following changes separately. Calculate the impact on the total profit or the optimal manufacturing plan, being as specific as possible. (c) (3 marks) The amount of cutting time increases by 200 minutes. (d) ( 3 points) the selling price for doors increases to $332 (e) (3 points) The amount of assembly time increases to 1900 minutes. (f) (3 marks) the selling price of tables increases to $375 (g) The amount of assembly time falls by 10 minutes, while the amount of finishing time increases by 10 minutes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!