In: Accounting
Kitchen Supply, Inc. (KSI), manufactures three types of flatware: institutional, standard, and silver. It applies all indirect costs according to a predetermined rate based on direct labor-hours. A consultant recently suggested that the company switch to an activity-based costing system and prepared the following cost estimates for year 2 for the recommended cost drivers.
Activity | Recommended Cost Driver |
Estimated Cost |
Estimated Cost Driver Activity |
||||
Processing orders | Number of orders | $ | 41,125 | 175 | orders | ||
Setting up production | Number of production runs | 170,000 | 100 | runs | |||
Handling materials | Pounds of materials used | 250,000 | 100,000 | pounds | |||
Machine depreciation and maintenance | Machine-hours | 231,000 | 11,000 | hours | |||
Performing quality control | Number of inspections | 68,500 | 50 | inspections | |||
Packing | Number of units | 96,000 | 480,000 | units | |||
Total estimated cost | $ | 856,625 | |||||
In addition, management estimated 7,700 direct labor-hours for year 2.
Assume that the following cost driver volumes occurred in January, year 2:
Institutional | Standard | Silver | |||||||
Number of units produced | 63,000 | 27,000 | 8,000 | ||||||
Direct materials costs | $ | 37,000 | $ | 23,000 | $ | 13,000 | |||
Direct labor-hours | 480 | 450 | 640 | ||||||
Number of orders | 10 | 10 | 6 | ||||||
Number of production runs | 2 | 4 | 6 | ||||||
Pounds of material | 14,000 | 6,000 | 3,400 | ||||||
Machine-hours | 610 | 160 | 100 | ||||||
Number of inspections | 3 | 3 | 3 | ||||||
Units shipped | 63,000 | 27,000 | 8,000 | ||||||
Actual labor costs were $14 per hour.
Required:
a.
(1) Compute a predetermined overhead rate for year 2 for each cost driver using the estimated costs and estimated cost driver units prepared by the consultant. (Round your answers to 2 decimal places.)
|
(2) Compute a predetermined rate for year 2 using direct labor-hours as the allocation base.
b. Compute the production costs for each product for January using direct labor-hours as the allocation base and the predetermined rate computed in requirement a(2).(Do not round intermediate calculations.)
|
c. Compute the production costs for each product for January using the cost drivers recommended by the consultant and the predetermined rates computed in requirement a. (Note: Do not assume that total overhead applied to products in January will be the same for activity-based costing as it was for the labor-hour-based allocation.) (Do not round intermediate calculations.)
|
Thank you for your time and help!
a) | Estimated | Driver | rate | |||||
1) | cost (a) | (b) | c=a/b | |||||
processing orders | 41,125 | 175 | 235 | per order | ||||
Setting up production | 170,000 | 100 | 1700 | per run | ||||
handling materials | 250,000 | 100,000 | 2.5 | per pound | ||||
using machines | 231,000 | 11,000 | 21 | per mh | ||||
performing quality control | 68,500 | 50 | 1370 | per inspection | ||||
packing | 96,000 | 480,000 | 0.2 | per unit | ||||
856,625 | ||||||||
Estimated activity | 856,625 | |||||||
estimated allocation base | 7,700 | |||||||
predetermined rate for direct labor | 111.25 | |||||||
production cost using direct labor hours | ||||||||
institutional | standard | Silver | total | |||||
b) | Account | |||||||
Direct materials | 37000 | 23000 | 13000 | 73000 | ||||
direct labor | 6720 | 6300 | 8960 | 21980 | ||||
indirect costs | 53400 | 50063 | 71200 | 174663 | ||||
total cost | 97120 | 79363 | 93160 | 269643 | ||||
direct labor = DLH*$14 per hour | ||||||||
indirect cost = dLH*$111.25 | ||||||||
c) | institutional | standard | Silver | total | ||||
Account | ||||||||
Direct materials | 37000 | 23000 | 13000 | 73000 | ||||
direct labor | 6750 | 6300 | 8960 | 22010 | ||||
Indirect costs | ||||||||
processing orders | 2350 | 2350 | 1410 | 6110 | ||||
Setting up production | 3400 | 6,800 | 10200 | 20400 | ||||
handling materials | 35000 | 15000 | 8500 | 58500 | ||||
using machines | 12810 | 3360 | 2100 | 18270 | ||||
performing quality control | 4110 | 4,110 | 4110 | 12330 | ||||
packing | 12600 | 5400 | 1600 | 19600 | ||||
total cost | 114020 | 66320 | 49880 | 230220 | ||||