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...
Which of the following would be considered a part of a consulting services (non-assurance) engagement?I.Expressing a conclusion about the reliability of an entity's financial statements.II.Reviewing and commenting on a client-prepared business plan.
A. I only. B. II only. C. Both I and II. D. Neither I nor II.
If the probability of F is greater than the significance level ?, ________ and ________ should be used
A) H0 is rejected; t based on "equal variances not assumed" B) H0 is not rejected; t based on "equal variances assumed" C) H0 is rejected; t based on "equal variances assumed" D) H0 is not rejected; t based on "equal variances not assumed"
When is tax allocation necessary?
a. When a revenue or expense reaches the financial statements before it appears on the tax return b. When a revenue or expense reaches the tax return before it appears on the financial statements c. When the tax basis and book basis of assets and liabilities differ d. All of the above
Describe the background and the significance of QWL.
What will be an ideal response?