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...
Day of week is an evaluation that is most related to these categories of business
A) fast food, utilities, long-distance telephone service B) retail shopping, movies C) ice cream, soft drinks and cold remedies D) durable goods' replacement cycles
In a just-in-time (JIT) environment, machines and workers are often rearranged into manufacturing cells
Indicate whether the statement is true or false
Forsyth Company uses estimated direct labor hours of 150,000 and estimated manufacturing overhead costs of $337,500 in establishing its 2011 predetermined manufacturing overhead rate. Results show actual manufacturing overhead of $346,500 and applied manufacturing overhead of $343,800 . The number of direct labor hours worked during the period was:
a. 154,000 b. 150,000 c. 152,800 d. 148,831 e. 146,000
The right to cure extends beyond the date that delivery is called for under the contract:
A) In all contracts covered by the UCC. B) In any situation where the seller had reasonable grounds to believe that the buyer would accept the nonconforming goods. C) In any situation where cure by the original delivery date would impose a hardship on the seller. D) Only if the contract allows. E) In any situation where it is commercially reasonable that it extend.