Based on the variable cells sensitivity report, what conclusion is best?
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) The value of Excursion can be infinite, since 1E+30 is 10 to the 30th power.
B) The values of Bar, Cuisine, and Excursion are all equal to zero.
C) The values of Bar and Cuisine can be negative since they have allowable decreases of 1E+30.
D) The optimal value for the objective function is $490,080
Answer: D
You might also like to view...
List the four steps, in the order of occurrence, that are used in preparing a production cost report.
What will be an ideal response?
Which one of the following is a more serious concern in terms of an adverse variance from budget?
a. a negative variance of $10,000 in budget expenditures b. a $10,000 shortfall in value earned on the project to date c. a positive variance of $10,000 in budget expenditures d. a $10,000 surplus in value earned on the project to date
Larry has $25,000 of bodily injury liability coverage under his PAP. This limit is the minimum amount required by his state to be considered financially responsible
While on a vacation, Larry visited a neighboring state which has a minimum financial responsibility limit of $50,000 for bodily injury. Which of the following statements describes the situation for Larry while he was in the neighboring state? A) Larry's policy was suspended while he was in the neighboring state. B) Larry had only $25,000 of liability coverage. C) Larry's policy automatically provided $50,000 of liability coverage. D) Larry's policy automatically provided $100,000 of liability coverage.
An income statement is a cash flow statement
Indicate whether the statement is true or false