Question: (Continuing with Pat's LP.) After running the LP in Excel, Pat gets the following Sensitivity Report Variables Cells Final Reduced Objective Allowable Allowable Cell Name

(Continuing with Pat's LP.) After running the LP
(Continuing with Pat's LP.) After running the LP
(Continuing with Pat's LP.) After running the LP in Excel, Pat gets the following Sensitivity Report Variables Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 Number of W 5 0 7 1.333 1.714 $C$4 Number of X 25 0 5 6 .667 0.800 har $D$4 Number of Y 0 -0.75 2 0 .75 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SE$8 Machine A LHS 140 0.25 140 26.667 80 SE$9 Machine BLHS 100 125 100 133.333 16 SE$10Machine C LHS 55 160 1E+30 105 estion 24 How will the optimal profit Z* change if Pat can make 20 more hours available on Machine B? tyet swered arked out of 4 Flag uestion Select one O a. No change in Z* O b. Decreases by $16.00 O C. Increases by $25.00 O d. Increases by $1.25 "$ TO Will the optimal mix of hats change if the unit profit on Whats increases from $7 to $8.50 Porod Question 25 Not yet answered Marked out of 4 p Flag question Select one: a. Yes, because the allowable decrease on W's coefficient is 1714 b. No, because the allowable increase on W's coefficient is 1.333. c. We cannot tell from the information in the Sensitivity Report d. Yes, because the allowable increase on W's coefficient is 1.333

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!