111mb .' 1433 The Tiger Catering Company is trying to determine the most economical combination of sandwiches to make for a tennis club. The club has asked Tiger to provide 70 sandwiches in a variety to include tuna, tuna and cheese, ham, ham and cheese, and cheese. The club has specified a minimum of 10 each of tuna and ham and 12 each of tunalcheese and ham! cheese. Tiger makes the sandwiches using the fol- lowing resources: bread, tuna, ham, cheese, mayon- naise, mustard, lettuce, tomato, packaging material, and labor hours. The Excel layout and LP Sensitivity Report for Tiger Cateng's problem are shown in Screenshots 14-14A and 1414B, respectively. The objective function coefficients in the screenshots refer to unit cost per item. Each of the following questions is in- dependent of the others. \\ rt" DISCUSSION QUESTIONS AND PROBLEMS 495 SCREENSHOT 14-14A A B C D F G H Excel Layout for Tiger Catering Company 1 Tiger Catering Company 2 3 Tuna Tuna/Ch Ham Ham/Ch Cheese 4 Number to make 10.00 30.00 10.00 12.00 8.00 5 Cost $2.42 $2.12 $3.35 $3.02 $2.36 $176.42 6 Constraints 7 Bread (slices) No 2 2 2 140.00 = 70 18 Min Tuna 10 00 >= 10 19 Min Tuna/Ch 30.00 12 20 Min Ham 10.00 >= 10 21 Min Ham/Ch 1 12.00 12 22 LHS Sign RHSSCREENSHOT 14-14B Microsoft Excel 14.0 Sensitivity Report Solver Sensitivity Report Problems 4-33to37. Tiger Catering Company for Tiger Catering Company Variable Cells Final Reduced Objective |Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 Number to make Tuna 10.00 0.00 2.42 1E+30 0.38 SC$4 Number to make Tuna/Ch 30.00 0.00 2.12 0.24 1E+30 SD$4 Number to make Ham 10.00 0.00 3.35 1E+30 0.99 SE$4 Number to make Ham/Ch 12.00 0.00 3.02 1E+30 0.66 SF$4 Number to make Cheese 8.00 0.00 2.36 0.66 0.24 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$7 Bread (slices) 140.00 0.00 140.00 1E+30 0.00 $G$8 Tuna (oz.) 130.00 -0.08 130.00 24.00 6.00 SG$9 Ham (oz.) 76.00 0.00 100.00 1E+30 24.00 SGS10 Cheese (oz.) 74.00 0.00 80.00 1E+30 6.00 SG$11 Mayo (oz.) 54.00 0.00 72.00 1E+30 18.00 SG$12 Mustard (oz.) 4.40 0.00 8.00 1E+30 3.60 SG$13 Lettuce (oz.) 17.50 0.00 20.00 1+30 2.50 SG$14 Tomato (oz.) 35.00 0.00 40.00 1E+30 5.00 $G$15 Package (unit) 70.00 0.00 72.00 1E+30 2.00 $G$16 Labor (hrs) 5.60 0.00 8.00 1E+30 2.40 SG$17 Min total 70.00 2.36 70.00 0.00 8.00 SG$18 Min Tuna 10.00 0.38 10.00 13.50 10.00 SG$19 Min Tuna/Ch 30.00 0.00 12.00 18.00 1E+30 SG$20 Min Ham 10.00 0.99 10.00 6.00 1.50 SG$21 Min Ham/Ch 12.00 0.66 12.00 8.00 2.00Solve Problem 14-33 on page 494 of the e TextBook Tiger Catering Company. Then provide your answers to the questions below: a) The optimal cost represented by the objective function is: $ (enter numbers with 2 decimal places) b) Which constraits are binding? (refer to screenshot 14-14A on page 495, and report in terms of Excel row numbers): (Enter whole numbers with 0 decimal places, and no punctuations) (Enter row numbers in ascending order, be careful) -.0.0.0.0 0 c) Range over which the cost for cheese sandwiches could vary without changing the production plan?: (enter numbers with 2 decimal places, and no punctuations, lower number first): Between $ and $ d) Range over which the quantity of tuna could vary...? (enter numbers with 0 decimal places and no punctuations , lower number first): Between and ounces. e) Ignore f) After sandwiches are made, how many labor hours remain? (enter number with 1 decimal place, and no punctuations) hours