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...
Which statement below regarding the AIS is false?
A) The AIS must be able to provide managers with detailed and operational information about the organization's performance. B) Both traditional financial measures and operational data are required for proper and complete evaluation of performance. C) The AIS was often just one of the information systems used by an organization to collect and process financial and nonfinancial data. D) Traditionally, most AIS have been designed so that both financial and operational data are stored in a manner that facilitates their integration in reports.
Which of the following is another term for the invoice approval form?
a. a receiving report b. an invoice c. a voucher d. a remittance advice