Here's the sensitivity report for the decision variables. Which of these conclusions is correct?
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$2 Bar 12 0 1500 1560 1E+30
$C$2 Cuisine 12 0 5000 1660 1E+30
$D$2 Excursion 24.24 0 17000 1E+30 3458.333333
A) If the cost of the Bar variable is reduced by more than 0, then more of it will be used.
B) If the cost of the Bar variable is increased by more than 0, then more of it will be used.
C) If the coefficient for the Cuisine variable rises to 1660, then more of it will be used.
D) It doesn't matter how much money they make on excursions, the optimal answer will continue to be 24.24 of them.
Answer: D
You might also like to view...
Beginning WIP Inventory is 15,500 units, 75% complete for materials. During the month 90,000 units were started; 87,000 were finished; and ending WIP was 18,500 units that were 50% complete for materials
How many equivalent units should be used to allocate costs for materials (assume as usual, that the weighted average method is used, not FIFO)? A) 98,625 B) 96,250 C) 99,250 D) 100,875
Identify the nouns in the sentence. The majority of travelers on our tour were students