Here's a portion of the sensitivity analysis for the constraints. Which of these statements is best?
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$E$10 Bar/Food 0 1560 0 5 16
$E$11 Budget 150000 3.4 150000 1E+30 96200
$E$6 Excursions 24.24 0 5 19.24 1E+30
$E$7 Restaurant 12 -1660 12 16 5
A) If the budget rises to $150,001, then the optimal mix will result in an increased revenue of $3.40.
B) If the excursions rise to 6, then the optimal mix will result in increased revenue of $19.24.
C) If the restaurant constraint increased to 13, the optimal mix will result in increased revenues of $1,660.
D) If the bar/food constraint rises to 1560, then the revenue will rise by a factor of 16.
Answer: A
You might also like to view...
What is the return on equity for a firm that has a constant dividend growth rate of 7 percent and a dividend payout ratio of 60 percent?
A) 11.67 percent B) 2.80 percent C) 17.50 percent D) 4.20 percent
A company that was most concerned about the impact of price changes in raw materials would use sensitivity analysis
Indicate whether this statement is true or false.