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](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/10/671c50ec09423_971671c50eb36183.jpg)
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
Get step-by-step solutions from verified subject matter experts
