Items B and C are the only elements in the final model.

Insisting that one additional unit of B, be included in the model will reduce the profit by $2.

The final value of this problem is 9.

Item A can drop in value all the way down to 1.25 before it harms the result.

Question 1 10 pt Table 3.7: The Love Boat Captain Stubing of The Pacific Princess seeks to maximize the return for their scheduled 14 day tour of Europe and has a number of options available to him. He can ply his guests with alcohol, upsell them on fancier restaurant fare or include more expensive excursion options. These alternatives are not without tradeoffs, since different guests prefer different options, depending largely on their age and wherewithal. Among the limitations Captain Stubing must consider is the number of excursions; they must offer at least five alternatives per day for each the ten days they will reach port. In addition, the restaurant choices must exceed 12 major styles of cuisine and the bar themes down in The Grotto should rotate every other day for the 14 days. It's possible to rotate them twice a day, but any more than that and poor Isaac spends more time tearing down and setting up than he does mixing libations. Ideally, there should be at least onc different bar theme for every cuisine type. The total budget for excursions, restaurants and bar has been set by the parent company at $150,000. It costs $1,500 to stock supplies for a major cuisine category, it costs $5.000 to include each different excursion, and it costs $900 to set up with a different bar theme. Based on historical data, Captain Stubing believes that each new barsetup will generate $1,500 profit. cach new cuisine type will bring in $5.000, and each excursion type will gonerate $17.000 for the ship. Using this snippet of the sensitivity report for variable cells, which of these conclusions is best? Final Reduced Cost Name Value Objective Allowable Cocfficient Increase 5 1+30 Allowable Decrease 1.25 Cell SB$13 SC$13 SDS 9 0 B 0 -2 6 2 0 1E+30 1[+ 30 2 1 2 Question 1 10 pt Table 3.7: The Love Boat Captain Stubing of The Pacific Princess seeks to maximize the return for their scheduled 14 day tour of Europe and has a number of options available to him. He can ply his guests with alcohol, upsell them on fancier restaurant fare or include more expensive excursion options. These alternatives are not without tradeoffs, since different guests prefer different options, depending largely on their age and wherewithal. Among the limitations Captain Stubing must consider is the number of excursions; they must offer at least five alternatives per day for each the ten days they will reach port. In addition, the restaurant choices must exceed 12 major styles of cuisine and the bar themes down in The Grotto should rotate every other day for the 14 days. It's possible to rotate them twice a day, but any more than that and poor Isaac spends more time tearing down and setting up than he does mixing libations. Ideally, there should be at least onc different bar theme for every cuisine type. The total budget for excursions, restaurants and bar has been set by the parent company at $150,000. It costs $1,500 to stock supplies for a major cuisine category, it costs $5.000 to include each different excursion, and it costs $900 to set up with a different bar theme. Based on historical data, Captain Stubing believes that each new barsetup will generate $1,500 profit. cach new cuisine type will bring in $5.000, and each excursion type will gonerate $17.000 for the ship. Using this snippet of the sensitivity report for variable cells, which of these conclusions is best? Final Reduced Cost Name Value Objective Allowable Cocfficient Increase 5 1+30 Allowable Decrease 1.25 Cell SB$13 SC$13 SDS 9 0 B 0 -2 6 2 0 1E+30 1[+ 30 2 1 2