Question: Suppose you are given the following linear programming model to maximize profit from a production plan, where x1 denotes the quantity of product 1 to

 Suppose you are given the following linear programming model to maximize
profit from a production plan, where x1 denotes the quantity of product

Suppose you are given the following linear programming model to maximize profit from a production plan, where x1 denotes the quantity of product 1 to make, etc. Max23x1+18x2+15x3 (profit) Subject to (Machine)(Labor)(Materials)(Product2max)(Non-negativity)5x1+4x2+3x3160minutes4x1+10x2+4x3200hours2x1+2x2+4x3200poundsx216unitsx10,x20,x30 a. Solve this LP by Excel Solver. Attach your Excel worksheet as an Excel file (not just a screenshot) including the sensitivity report of the LP. b. Using the sensitivity report, answer the following questions. Note: You are not allowed to re-solve the LP for these questions; please explain how you use the report in your answer. i. Are any constraints binding? If so, which ones? ii. If the profit on product 3 were changed to $22 a unit, what would the values of the decision variables be? What would the overall total profit be at the new optimal production plan? iii. If the profit on product 1 were changed to $22 a unit, what would the values of the decision variables be? What would the overall total profit be at the new optimal production plan? iv. If the manager decided that as many as 20 units of product 2 could be produced (instead of 16 ), how much additional profit would be generated by the new optimal production plan? v. If 10 hours less of labor time were available, what would the overall total profit be at the new optimal production plan

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!