Let x1,x2, and x3 represent number of units of product A,B, and C and the constraints represent the availability of materials 1,2 , and 3 . Given this LP model Maximize Z=$100x1+$602+$5032Profit Subject to 2x1+3x2+4x330x1+3x2+2x3226x1+3x2+4x330x1,x2,x30(Material1)(Material2)(Material3) The sensitivity report for this problem above is provided below as Excel Solver output. You will need this output to answer (a) through ( g) below each part of which is to be considered independently of all others. Variable Cells (a) What is the optimal profit? Show your work. (2 points) (b) Determine the range of optimality for the objective function coefficient of the decision variable x2. (2 points) (c) If the profit contribution of product A decreased to $75/ unit. Without resolving the entire problem, decide if the optimal solutions and the value of the objective function can be determined (if yes, then provide the optimal values). (4 points) (d) What will be the impact on the profit when we force the production of 2 units of Product C (i.e. x3=2 )? If you can determine what the new optimal value of the objective function is, then do so. If you cannot determine the new optimal value of the objective function, explain why. (3 points) (e) Some values in the Sensitivity report were deleted by your professor. Complete the LP table below: Write the corresponding value of each item deleted in the Sensitivity report and provide a brief justification for your answer. (8 points: 2 points each) (f) The Manager is considering increasing Material 2 and Material 3 values by 2 units EACH. Without resolving the entire problem, decide if the impact of the changes on the optimal solutions and the value of the objective function can be determined (if yes, then provide the optimal values). Show your work. (6 points) (g) If one additional unit of the third resource (ie. Material 3 constraint) could be obtained/purchased at a premium of $6, what impact would this have on profit? If you can determine what the new optimal value of the objective function is, then do so. If you cannot determine the new optimal value of the objective function, explain why. ( 3 points) Let x1,x2, and x3 represent number of units of product A,B, and C and the constraints represent the availability of materials 1,2 , and 3 . Given this LP model Maximize Z=$100x1+$602+$5032Profit Subject to 2x1+3x2+4x330x1+3x2+2x3226x1+3x2+4x330x1,x2,x30(Material1)(Material2)(Material3) The sensitivity report for this problem above is provided below as Excel Solver output. You will need this output to answer (a) through ( g) below each part of which is to be considered independently of all others. Variable Cells (a) What is the optimal profit? Show your work. (2 points) (b) Determine the range of optimality for the objective function coefficient of the decision variable x2. (2 points) (c) If the profit contribution of product A decreased to $75/ unit. Without resolving the entire problem, decide if the optimal solutions and the value of the objective function can be determined (if yes, then provide the optimal values). (4 points) (d) What will be the impact on the profit when we force the production of 2 units of Product C (i.e. x3=2 )? If you can determine what the new optimal value of the objective function is, then do so. If you cannot determine the new optimal value of the objective function, explain why. (3 points) (e) Some values in the Sensitivity report were deleted by your professor. Complete the LP table below: Write the corresponding value of each item deleted in the Sensitivity report and provide a brief justification for your answer. (8 points: 2 points each) (f) The Manager is considering increasing Material 2 and Material 3 values by 2 units EACH. Without resolving the entire problem, decide if the impact of the changes on the optimal solutions and the value of the objective function can be determined (if yes, then provide the optimal values). Show your work. (6 points) (g) If one additional unit of the third resource (ie. Material 3 constraint) could be obtained/purchased at a premium of $6, what impact would this have on profit? If you can determine what the new optimal value of the objective function is, then do so. If you cannot determine the new optimal value of the objective function, explain why. ( 3 points)
