In: Finance
TDABC
Bob Randall, cost accounting manager for Hemple Products, was asked to determine the costs of the activities performed within the company's Manufacturing Engineering Department. The department has the following activities: creating bills of materials (BOMs), studying manufacturing capabilities, improving manufacturing processes, training employees, and designing tools. The resource costs (from the general ledger) and the times to perform one unit of each activity are provided below.
Resource Costs | Activities | Unit Time | Driver | |||
Salaries | $425,000 | Creating BOMs | 0.6 hr. | No. of BOMs | ||
Equipment | 92,000 | Designing tools | 3.7 hrs. | No. of tool designs | ||
Supplies | 43,000 | Improving processes | 1.1 hrs. | Process improvement hrs. | ||
Total | $560,000 | Training employees | 2.1 hrs. | No. of training sessions | ||
Studying capabilities | 2.1 hrs. | Study hours |
Total machine and labor hours (at practical capacity):
Machine hours | 2,000 | |
Engineering hours | 18,000 | |
Total hours | 20,000 |
The activity, designing tools, uses the number of tools designed as the activity driver. Using a traditional approach, the cost of the designing tools activity was determined to be $193,000 with an expected activity output of 1,000 for the coming year. During the first week of the year, two jobs (Job 150 and Job 151) had a demand for 10 and 20 new tools, respectively.
Required:
1. Calculate the capacity cost rate for the
Manufacturing Engineering Department. Round your answer to the
nearest cent.
$ per hour
2. Using the capacity cost rate, determine the activity rates for each activity. Round your answers to the nearest cent.
Activity Rates | ||
Creating BOMs | $ | per BOM |
Designing tools | $ | per tool design |
Improving processes | $ | per process improvement hr. |
Training employees | $ | per training session |
Studying capabilities | $ | per study hour |
3. Calculate the cost of designing tools that would be assigned to each job using the TDABC-derived activity rate and then repeat using the traditional ABC rate.
Job 150 | Job 151 | |
TDABC | $ | $ |
ABC | $ | $ |
4. Now suppose that time for creating BOMs is 0.6 for a standard product but that creating a BOM for a custom product adds an additional 0.4 hour. Express the time equation for this added complexity. Round your answers to two decimal places. Place the amounts left to right, lowest to highest.
BOM time | = | + |
Calculate the activity rate for the activity of creating a BOM
for custom products. Round your answer to the nearest cent.
$ per BOM
1. Capacity cost rate for the Manufacturing Engineering Department | ||||
Total costs | 560000 | |||
Total time in hrs. | 20000 | |||
Cost/Hr.---560000/20000= | 28 | |||
Unit Time | Activity Rates | |||
Creating BOMs | 0.6 hr. | 28*0.6= | 16.8 | per BOM |
Designing tools | 3.7 hrs. | 28*3.7= | 103.6 | per tool design |
Improving processes | 1.1 hrs. | 28*1.1= | 30.8 | per process improvement hr. |
Training employees | 2.1 hrs. | 28*2.1= | 58.8 | per training session |
Studying capabilities | 2.1 hrs. | 28*2.1= | 58.8 | per study hour |
3. Cost of designing tools using the TDABC-derived activity rate and traditional ABC rate | ||||
Job 150 | Job 151 | |||
TDABC | 103.6*10= | 1036 | 103.6*20= | 2072 |
ABC at the activity rate of 193000/1000=193 | 193*10= | 1930 | 193*20= | 3860 |
4. BOM time = | (0.6+0.4)*No.of BOMs= 1* BOM | |||
Activity rate for the activity of creating a BOM for custom products. | 28*1= 28 | $ per BOM |