The Tiger Catering Company is trying to determine the most economical combination of sandwiches to make for

Question:

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?
The Tiger Catering Company is trying to determine the most

(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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Decision Modeling With Spreadsheets

ISBN: 718

3rd Edition

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

Question Posted: