Original Value Cell SFS4 Name Max Profit Final Value 790 Original Value Variable Cells Cell Name $B$2 Values T $C$2 Values H $D$2 Values C $E$2 Values S Final Value 400 200 1000 400 Cell Value 400 Slack 200 Constraints Cell Name $F$10 Min. supply (S) $F$11 Proportion (C) $F$12 Prep. Time (min.) SF$13 Vending space $F$7 Min. supply (U) $F$8 Min. supply (H) $F$9 Min. supply (C) 960 2000 400 200 1000 Formula $F$10>=$H$10 $F$11>=$H$11 $F$12=$H$7 $F$8>=$H$8 $F$9>=$H$9 Status Not Binding Binding Binding Binding Not Binding Binding Not Binding 800 Variable Cells Cell $B$2 $C$2 $D$2 $E$2 Name Values T Values H Values C Values S Final Reduced Value Cost 400 200 1000 400 Objective Allowable Allowable Coefficient Increase Decrease 0.42 0.0400 0.0200 0.44 0.0067 1E+30 0.35 0.0913 0.5353 0.46 0.0913 0.0100 Constraints Allowable Decrease 1E+30 800 Final Shadow Value Price 400 0 0 -0.0913 960 0.2667 2000 0.2677 400 200 -0.0067 10000 Cell Name $F$10 Min. supply (S) $F$11 Proportion (C) SFS12 Prep. Time (min.) $F$13 Vending space $F$7 Min. supply (T) $F$8 Min. supply (H) $F$9 Min. supply (C) Constraint Allowable R.H. Side Increase 200 200 375 960 30 2000 68.1818 200 200 200 300 200 800 30 58.2524 1E+30 200 1E-30 > Moving to another question will save this response. Question 18 of 24 Question 18 3 points MS3053 LP Sensitivity Analysis_ExcelOutput.pdf Refer to above Excel output, Janet, one of the four workers who work 3.5 hours each evening, wishes to reduce her time to 3 hours. What effect will this change have on the optimal solution and the total daily profit, if any? This change is not allowed. Thus, the optimal solution and the total daily profit will change. The model has to be rerun This change is allowed. The optimal solution will remain the same but the optimal daily profit will decrease by $8.001 This change is not allowed. Thus, the optimal solution will remain the same. The model has to be rerun to find out the new optimal daily profit. This change is allowed. The optimal solution will remain the same but the optimal daily profit will increase by $8.001. This change is allowed. The optimal solution and the total daily profit will not change Question 18 of 24 Moving to another question will save this response. > A Moving to another question will save this response. Question 14 Question 14 of 24 3 points M53053 LP Sensitivity Analysis_ExcelOutput.pdf Refer to above Excel output, ALS Is now worried about losing half an hour of preparation time. Joe, the person who currently works only two hours each evening, Is aware of this and offered to do an extra hour if Janet reduces her time to 3 hours. How will this impact the optimal solution and the total daily profit, if any? This change is not allowed. Thus, the optimal solution and the total daily profit will change. The model has to be rerun. This change is allowed. The optimal solution will remain the same but the optimal daily profit will decrease by $8.001. This change is allowed. The optimal solution will remain the same but the optimal dally profit will increase by $8.001. This change is not allowed. Thus, the optimal solution will remain the same. The model has to be rerun to find out the new optimal daily profit This change is allowed. The optimal solution and the total daily profit will not change. - Moving to another question will save this response. Question 14 of MacBook Air Original Value Cell SFS4 Name Max Profit Final Value 790 Original Value Variable Cells Cell Name $B$2 Values T $C$2 Values H $D$2 Values C $E$2 Values S Final Value 400 200 1000 400 Cell Value 400 Slack 200 Constraints Cell Name $F$10 Min. supply (S) $F$11 Proportion (C) $F$12 Prep. Time (min.) SF$13 Vending space $F$7 Min. supply (U) $F$8 Min. supply (H) $F$9 Min. supply (C) 960 2000 400 200 1000 Formula $F$10>=$H$10 $F$11>=$H$11 $F$12=$H$7 $F$8>=$H$8 $F$9>=$H$9 Status Not Binding Binding Binding Binding Not Binding Binding Not Binding 800 Variable Cells Cell $B$2 $C$2 $D$2 $E$2 Name Values T Values H Values C Values S Final Reduced Value Cost 400 200 1000 400 Objective Allowable Allowable Coefficient Increase Decrease 0.42 0.0400 0.0200 0.44 0.0067 1E+30 0.35 0.0913 0.5353 0.46 0.0913 0.0100 Constraints Allowable Decrease 1E+30 800 Final Shadow Value Price 400 0 0 -0.0913 960 0.2667 2000 0.2677 400 200 -0.0067 10000 Cell Name $F$10 Min. supply (S) $F$11 Proportion (C) SFS12 Prep. Time (min.) $F$13 Vending space $F$7 Min. supply (T) $F$8 Min. supply (H) $F$9 Min. supply (C) Constraint Allowable R.H. Side Increase 200 200 375 960 30 2000 68.1818 200 200 200 300 200 800 30 58.2524 1E+30 200 1E-30 > Moving to another question will save this response. Question 18 of 24 Question 18 3 points MS3053 LP Sensitivity Analysis_ExcelOutput.pdf Refer to above Excel output, Janet, one of the four workers who work 3.5 hours each evening, wishes to reduce her time to 3 hours. What effect will this change have on the optimal solution and the total daily profit, if any? This change is not allowed. Thus, the optimal solution and the total daily profit will change. The model has to be rerun This change is allowed. The optimal solution will remain the same but the optimal daily profit will decrease by $8.001 This change is not allowed. Thus, the optimal solution will remain the same. The model has to be rerun to find out the new optimal daily profit. This change is allowed. The optimal solution will remain the same but the optimal daily profit will increase by $8.001. This change is allowed. The optimal solution and the total daily profit will not change Question 18 of 24 Moving to another question will save this response. > A Moving to another question will save this response. Question 14 Question 14 of 24 3 points M53053 LP Sensitivity Analysis_ExcelOutput.pdf Refer to above Excel output, ALS Is now worried about losing half an hour of preparation time. Joe, the person who currently works only two hours each evening, Is aware of this and offered to do an extra hour if Janet reduces her time to 3 hours. How will this impact the optimal solution and the total daily profit, if any? This change is not allowed. Thus, the optimal solution and the total daily profit will change. The model has to be rerun. This change is allowed. The optimal solution will remain the same but the optimal daily profit will decrease by $8.001. This change is allowed. The optimal solution will remain the same but the optimal dally profit will increase by $8.001. This change is not allowed. Thus, the optimal solution will remain the same. The model has to be rerun to find out the new optimal daily profit This change is allowed. The optimal solution and the total daily profit will not change. - Moving to another question will save this response. Question 14 of MacBook Air