d) hardly ever important
e) cultural considerations
Johnny Now, Inc. produces two different models of outhouses. Demand next period is
expected to be 12,000 and 18,000 units for Models A and B, respectively. Model A has
CPOPF planning factors of 0.75 and 0.60 for direct labor and machine time,
respectively. Model B has CPOPF planning factors of 0.50 and 0.80 for direct labor and
machine time, respectively. Historically department G uses 24% of the direct labor and
machine time for these products, while department H uses the remaining 76%. What is
the machine time requirement for department H next period?
a) 5,184 hours
b) 13,680 hours
c) 14,400 hours
d) 21,600 hours
e) 16,416 hours
In Excel, what does the formula ‘=MAX(B25:D25)’ do?
a) It returns the largest value in either cell B25 or cell D25.
b) It converts all values in the range between B25 and D25 to the highest value in that
range.