Billy Adams, controller for Westcott Inc., prepared the following budget for manufacturing costs at two different levels of activity for 2012:

During 2012, Westcott employees worked a total of 80,000 direct labor hours, used 250,000 machine hours, made 32,000 moves, and performed 120 batch inspections. The following actual costs were incurred:

Westcott applies overhead using rates based on direct labor hours, machine hours, number of moves, and number of batches. The second level of activity (the far right column in the preceding table) is the practical level of activity (the available activity for resources acquired in advance of usage) and is used to compute predetermined overhead pool rates.
Required:
1. Prepare a performance report for Westcott€™s manufacturing costs in 2012.
2. Assume that one of the products produced by Westcott is budgeted to use 10,000 direct labor hours, 15,000 machine hours, and 500 moves and will be produced in 5 batches. A total of 10,000 units will be produced during the year. Calculate the budgeted unit manufacturing cost.
3. One of Westcott€™s managers said: €œBudgeting at the activity level makes a lot of sense, but this budget needs to provide more detailed information. For example, the materials handling activity requires forklifts and operators, and this information is lost with simply reporting the total cost of the activity for various levels of output. We have four forklifts; each is rented for $ 10,000 per year and can provide 10,000 moves per year. Furthermore, for our two shifts, we need up to eight operators if we run all four forklifts. Each operator is paid a salary of $ 30,000 per year. Fuel costs us about $ 0.25 per move.€™€™ Based on these comments, explain how this additional information may help Westcott to better manage its costs. Also, assuming that these are the only three items, expand the detail of the flexible budget for materials handling to reveal the cost of these three resource items for 20,000 moves and 40,000 moves, respectively.

Transcribed Image Text:

DIRECT LABOR HOURS MACHINE HOURS Level of Activity 200,000 300,000 Level of Activity 50,000 100,000 Direct materials Direct labor $300,000 600,000 Maintenance $360,000 $510,000 200,000 ,00 equipment Depreciation (plan 100,000 Subtotal 100,000 Machining 112,000 62,000 $600,000 $ Subtotal' Ta720 33727055 1.100,000 MATERIAL MOVES NUMBER OF BATCHES INSPECTED Level of Activity Level of Activity 100 20,000 40,000 200 Materials handiing $165,000 $290,000 Inspecting products 125,000 225,000 Toal Direct materials Direct labor Depreciation Maintenance $440,000 Machining Materials handling $142,000 232,500 160,000 355,000 100,000 Inspecing products 425,000