In: Accounting
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 |