Please Answer all. This is one problem. I will upvote.

LP: Certain Sensitivity Analysis Questions must be answered based on the Excel Output below. The sandwich company, Alamo Lone Star (ALS) prepares sandwiches for sale in vending machines in various locations of an urban area. The four types of sandwich that are now provided are those that have been found to sell well. The following information is available on each type: Type of sandwich Decision variables Minimum number of units sold Preparation time per unit (minutes) Profit per unit ($) T 0.42 H Tuna mayonnaise Ham and cheese Cheese and salad Spicy vegetable 200 200 200 0.44 0.40 0.50 0.48 0.55 0.35 S 200 0.46 The most popular sandwich is the cheese and salad so ALS ensure that at least half of all sandwiches supplied are cheese and salad. All four types of sandwich are prepared each evening and then distributed to the vending machines the next morning. Sandwich preparation is carried out by five part-time workers. Four of these workers each work 3.5 hours each evening and one works for only two hours. ALS has 50 identical sandwich vending machines each with a capacity of 40 units. The manager of ALS needs to know how many of each type of sandwich they should produce each evening to maximize profit, subject to unit profit figures and constraints mentioned above. This problem was formulated as a linear programming model and then solved using Excel Solver. The Excel Solver output is provided below. Please note that to keep the model as simple as possible, it was assumed that ALS can sell all sandwiches they produced. APPENDIX Below is the Excel Solver output. Note that the cell entry 1E+30 means an unlimited amount. Objective Cell (Max) Cell Name Original Value Final Value $F$4 Max Profit 0 790 Variable Cells Cell Name $B$2 Values T $C$2 Values H $D$2 Values C $E$2 Values S Original Value 0 0 0 0 Final Value 400 200 1000 400 Slack 200 Constraints Cell Name $F$10 Min. supply (S) $F$11 Proportion (C) $F$12 Prep. Time (min.) $F$13 Vending space $F$7 Min. supply (T) $F$8 Min. supply (H) $F$9 Min. supply (C) Cell Value 400 0 960 2000 400 200 1000 Formula $F$10>=$H$10 $F$11>=$H$11 $F$12=$H$7 $F$8>=SH$8 $F$9>=SH$9 Status Not Binding Binding Binding Binding Not Binding Binding Not Binding 0 0 200 0 800 Variable Cells Cell $B$2 $C$2 $D$2 $E$2 Name Values T Values H Values C Values S Final Value 400 200 1000 400 Reduced Cost 0 0 0 0 Objective Allowable Coefficient Increase 0.42 0.0400 0.44 0.0067 0.35 0.0913 0.46 0.0913 Allowable Decrease 0.0200 1E+30 0.5353 0.0100 Constraints Cell Name $F$10 Min. supply (S) $F$11 Proportion (C) $F$12 Prep. Time (min.) $F$13 Vending space $F$7 Min. supply (T) $F$8 Min. supply (H) $F$9 Min. supply (C) Final Value 400 0 960 2000 400 200 1000 Shadow Price 0 -0.0913 0.2667 0.2677 0 -0.0067 0 Constraint Allowable Allowable R.H. Side Increase Decrease 200 200 1E+30 0 375 800 960 30 30 2000 68.1818 58.2524 200 200 1E+30 200 300 200 200 800 1E+30 Refer to above Excel output, Which of the following represents the constraint for the preparation time? O .40T + .50H +.48C +.555 = 14 0.42T +.44H +.35C+.465 S 16 O.40T + .50H +.48C + .55S S 16 0.42T +.44H + .35C +.465 S 960 O .40T + .50H + .48C + .555 S 960 Refer to above Excel output, ALS is now considering making simultaneous (multiple) changes. The unit price of cheese and salad sandwich were to be increased so that the new profit per unit becomes $0.38. Also, the unit price of spicy vegetable sandwich were to be increased so that the new profit per unit becomes $0.53. Which of the following correctly explain whether these multiple changes would have any effect on the daily optimal production schedule and any effect on the total daily profit? These changes are not allowed. Thus, the optimal production schedule will change. These changes must be entered into the model and the model has to be rerun. These changes are allowed. The optimal solution will not change but the optimal daily profit will be $848. These changes are not allowed. Thus, the optimal production schedule will remain the same. The model has to be rerun to find out the new optimal daily profit. These changes are allowed. The optimal daily profit will increase but the optimal daily production will change. These changes are not allowed. Thus, the optimal production schedule will change. The optimal daily profit will be $848. Refer to above Excel output, one of ALS's vending machines breaks down. ALS has been offered to rent a vending machine with a capacity of 60 units for $18 a day. Should ALS accept this offer? No. The net gain ($10.708) is lower than the cost of renting ($18). None of these answers is correct. No. The net gain ($16.062) is lower than the cost of renting ($18). Yes. The benefit ($18.25) exceeds the cost of renting ($18). Yes. The net gain will be $10.708. Refer to above Excel output, How many constraints are there with a surplus? O 3 O 5 00 04 07 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 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 decrease by $8.001. 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 and the total daily profit will not change. This change is allowed. The optimal solution will remain the same but the optimal daily profit will increase by $8.001