Activity-Based Costing, Reducing the Number of Drivers and Equal
Accuracy
Reducir, Inc., produces two different types of hydraulic
cylinders. Reducir produces a major subassembly for the cylinders
in the Cutting and Welding Department. Other parts and the
subassembly are then assembled in the Assembly Department. The
activities, expected costs, and drivers associated with these two
manufacturing processes are given below.
Process |
Activity |
Cost |
Activity Driver |
Expected Quantity |
Cutting and Welding |
Welding |
$ 776,000 |
Welding hours |
4,000 |
|
Machining |
450,000 |
Machine hours |
10,000 |
|
Inspecting |
448,250 |
No. of inspections |
1,000 |
|
Materials handling |
300,000 |
No. of batches |
12,000 |
|
Setups |
240,000 |
No. of setups |
100 |
|
|
$2,214,250 |
|
|
Assembly |
Changeover |
$ 180,000 |
Changeover hours |
1,000 |
|
Rework |
61,750 |
Rework orders |
50 |
|
Testing |
300,000 |
No. of tests |
750 |
|
Materials handling |
380,000 |
No. of parts |
50,000 |
|
Engineering support |
130,000 |
Engineering hours |
2,000 |
|
|
$1,051,750 |
|
|
Other overhead activities, their costs, and drivers are listed
below.
Activity |
Cost |
Activity Driver |
Quantity |
Purchasing |
$ 135,000 |
Purchase requisitions |
500 |
Receiving |
274,000 |
Receiving orders |
2,000 |
Paying suppliers |
225,000 |
No. of invoices |
1,000 |
Providing space and utilities |
100,000 |
Machine hours |
10,000 |
Total |
$ 734,000 |
|
|
Other production information concerning the two hydraulic
cylinders is also provided:
|
|
|
Cylinder A |
|
Cylinder B |
|
|
Units produced |
1,500 |
|
3,000 |
Welding hours |
1,600 |
|
2,400 |
Machine hours |
3,000 |
|
7,000 |
Inspections |
500 |
|
500 |
Moves |
7,200 |
|
4,800 |
|
Batches |
45 |
|
55 |
|
Changeover hours |
540 |
|
460 |
|
Rework orders |
5 |
|
45 |
|
No. of tests |
500 |
|
250 |
|
Parts |
40,000 |
|
10,000 |
|
Engineering hours |
1,500 |
|
500 |
|
Requisitions |
425 |
|
75 |
|
Receiving orders |
1,800 |
|
200 |
|
Invoices |
650 |
|
350 |
|
Required:
1. Using a plantwide rate based on machine
hours, calculate the total overhead cost assigned to each product
and the unit overhead cost. If required, round your unit overhead
cost answers to the nearest cent.
|
Total Overhead Cost |
Unit Overhead Cost |
Cylinder A |
$ |
$ |
Cylinder B |
$ |
$ |
2. Using activity rates, calculate the total
overhead cost assigned to each product and the unit overhead cost.
If required, round interim calculations to the nearest cent, and
final answers to the nearest dollar.
|
Total Overhead Cost |
Unit Overhead Cost |
Cylinder A |
$ |
$ |
Cylinder B |
$ |
$ |
3. Calculate the global consumption ratios.
Round your answers to two decimal places.
|
Global Consumption Ratios |
Cylinder A |
|
Cylinder B |
|
4. Calculate the consumption ratios for welding
and materials handling (Assembly). Round your answers to two
decimal places.
|
Cylinder A |
Cylinder B |
Welding |
|
|
Materials handling |
|
|
5. Calculate the consumption ratios for
inspection and engineering. Round your answers to two decimal
places.
|
Cylinder A |
Cylinder B |
Inspection |
|
|
Engineering |
|
|