Scottsdale Ltd. manufactures a variety of high-volume and low-volume products to customer demand. Presented is information on 2009 manufacturing overhead and activity cost drivers.
Product XI required 2,000 machine hours to fill 10 customer orders for a total of 8,000 units.
Level Total Cost Units of Cost Driver
Unit $400,000 20,000 machine hours
Batch 200,000 1,000 customer orders
Product 200,000 50 products
Product X1 required 1,000 machine hours to fill 20 customer orders for a total of 8,000 units.
(a) Assuming all manufacturing overhead is estimated and predicted on the basis of machine hours, determine the predicted total overhead costs to produce the 8,000 units of product X1.
(b) Assuming manufacturing overhead is estimated and predicted using separate rates for machine hours, customer orders, and products (a multiple-level cost hierarchy), determine the predicted total overhead costs to produce the 8,000 units of product X1.
(c) Calculate the error in predicting manufacturing overhead using machine hours versus using multiple cost drivers. Indicate whether the use of only machine hours results in overpredicting or underpredicting the costs to produce 8,000 units of product X1.
(d) Determine the error in the prediction of X1 batch-level costs resulting from the use of only machine hours. Indicate whether the use of only machine hours results in overpredicting or underpredicting the batch-level costs of product X1.
(e) Determine the error in the prediction of X1 product-level costs resulting from the use of only machine hours. Indicate whether the use of only machine hours results in overpredicting or underpredicting the product-level costs of product X1.