Allowable Allowable Decrease 1.714 (Continuing with Pat's LP.) After running the LP in Excel, Pat gets the following Sensitivity Report: Variables Cells Final Reduced Objective Cell Name Value Cost Coefficient $B$4 Number of W 5 0 7 SC$4 Number of X 25 0 5 SD$4 Number of Y 0 -0.75 2 Constraints Final Final Shadow Constraint Cell Name Value Price R.H. Side SE$8 Machine A LHS 140 0.25 140 SE$9 Machine B LHS 100 1. 25 1 00 SE$10 Machine C LHS 55 0 160 Increase 1.333 6.667 0.75 0.800 1E+30 Allowable Increase 26.667 1 33.333 1E+ 30 Allowable Decrease 80 1 6 1 05 How will the optimal profit Z* change if Pat can make 20 more hours available on Machine B? Select one: a. Increases by $1.25 O O O b. Decreases by $16.00 c. Increases by $25.00 d. No change in Z* Questions 21-25 refer to the following information. Pat's Hat Factory produces three types of hats (W.XY). Each hat type has a different unit profit in S) and requires a different amount of time in hours) on each of the factory's three machines (A, B, C). The hours available on the three machines are 140, 100, and 160, respectively. Pat's goal is to maximize profit from the production of hats. Her linear programming problem is: Maximize 7W + 5X + 2Y = Z subject to: 3W - 5X + 14 S 140 (Machine A) 5W + 3x + 2Y $ 100 (Machine B) 1W + 2x + 18 S 160 (Machine C W20; X20; Y20 ilearn.stsu.edu/ay1920/mod/quiz/attempt.php?attempt=901275&cmid=586799&page=5 SE$9 Machine B LHS 100 1.25 100 133.333 SE$10 Machine C LHS 55 0 160 1E+30 1 05 16 How will the optimal profit Z* change if Pat can make 20 more hours available on Machine B? Select one: a. Increases by $1.25 O b. Decreases by $16.00 O c. Increases by $25.00 O d. No change in Z* Will the optimal mix of hats change if the unit profit on Whats increases from $7 to $8.50? Select one: o a. We cannot tell from the information in the Sensitivity Report. O b. No, because the allowable increase on W's coefficient is 1.333. c. Yes, because the allowable increase on W's coefficient is 1.333. O d. Yes, because the allowable decrease on W's coefficient is 1.714