William ran the model in Excel and received both an answer and sensitivity report. Which of these statements about this portion of the sensitivity report is best?
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$14 Rotgut 12.5 0 0 0 0
$C$14 White Lightning 12.5 0 0 0 0
$D$16 Hours d1+ 0 1 1 1E+30 1
$E$16 Hours d1- 9.5 0 0 1 0
$D$17 Profit d2+ 0 0 0 1E+30 0
$E$17 Profit d2- 0 0 0 1E+30 0
$D$18 Corn d3+ 2.5 0 0 0 0
$E$18 Corn d3- 0 0 0 1E+30 0
$D$19 Sugar d4+ 7.5 0 0 0 0
$E$19 Sugar d4- 0 0 0 1E+30
A) William needs only 62.5 hours to produce.
B) William needs to acquire 2.5 additional bushels of corn.
C) William needs 7.5 pounds more sugar.
D) William needs 1 more hour to produce.
Answer: A
You might also like to view...
Brandywine Corporation reported the following information for 2011 and 2012: Interest payable, December 31, 2011 $ 13,500 Interest payable, December 31, 2012 20,500 Interest expense--2012 32,000 How much cash was paid for interest during 2012?
A) $25,000 B) $39,000 C) $52,500 D) $45,500
Which of the following causes sampling error?
a. Taking a random sample from a population instead of studying the entire population. b. Making a mistake in the process of collecting the data. c. Nonresponse bias. d. All of these choices are true.