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 tuna/cheese and ham/ cheese. Tiger makes the sandwiches using the following resources: bread, tuna, ham, cheese, mayonnaise, mustard, lettuce, tomato, packaging material, and labor hours.
The Excel layout and LP Sensitivity Report for Tiger Catering€™s problem are shown in Screenshots 4-14A and 4-14B, respectively. The objective function coefficients in the screenshots refer to unit cost per item. Each of the following questions is independent of the others.
(a) What is the optimal cost represented by the objective function and what is the optimal sandwich making plan?
(b) Which constraints are binding?

(c) What is the range over which the cost for cheese sandwiches could vary without changing the production plan?
(d) What is the range over which the quantity of tuna could vary without changing the combination of binding constraints?

(e) Does this Sensitivity Report indicate the presence of multiple optimal solutions? How do you know?

(f) After the sandwiches are made, how many labor hours remain?

Transcribed Image Text:

1 Tiger Catering Company Tuna Tuna/Ch Ham H/Ch Cheese d Number to make 10.00 30.00 10.00 12008.00 5 Cost 6 Constraints $242 $2.12 3.35$3.02 $2.36 $17642 Bread (slices) 8-Tuna (oz.) 9 22 22 1 140.00140 13D.00130 76.00: c# 100 74.0080 に 72 4.40に 8 20 0.5 05 05 05 350040 70.00 72 4 Ham (oz.) 10 Cheese (oz.) 11 Mayo (oz.] 12 Mustard (oz.) 13-Lettuce (oz.) 10.25 14 Tomato ( 05 15 Package (urit)1 16 Labor (hrs) 17 Min total 18 Min Tuna 19 Min Tuna/Ch 20 Min Ham 21 Min Ham/Ch 4 1.2 D.9 0.5 0.5 0.5 54.0 0.2 0.2 0.25 0.25 0.25 0.25 | 17.50. 0.08 0.08 008 0.08 008 5.60 70.00>= 70 10.00>= 10 30.0012 10.00 10 12.001,-- 12 LHS Sign RHS