Expected Quantity Process Activity Cost Activity Driver Cutting and Welding S 776,000 Welding Machining Inspecting Materials handling Setups Welding hours Machine hours No. of inspections 4,000 450,000 448,250 10,000 1,000 300,000 No. of batches 12,000 240,000 No. of setups 100 Changeover Rework S2,214.250 S 180,000 61,750 Changeover hours Rework orders Assembly 1,000 50 750 Testing Materials handling Engineering support 300,000 No. of tests 380,000 130,000 No. of parts Engineering hours 50,000 2,000 S1,051,750 Note: In the assembly process, the materials-handling activity is a function of product characteristics rather than batch activity. Other overhead activities, their costs, and drivers are listed below. Activity Cost Activity Driver Quantity 500 Purchasing Receiving Paying suppliers Providing space and utilities S135,000 274,000 225,000 Purchase requisitions Receiving orders No. of invoices 2,000 1,000 100,000 Machine hours 10,000 S734,000 Other production information concerning the two hydraulic cylinders is also provided: Cylinder A Cylinder B Units produced Welding hours 1,500 1,600 3,000 2,400 3,000 500 Machine hours 7,000 Inspections Moves 500 7,200 4,800 Batches 45 55 Changeover hours Rework orders 540 460 5 45 No. of tests 500 250 Parts 40,000 10,000 Engineering hours Requisitions Receiving orders 1,500 500 425 75 1,800 200 Invoices 650 350

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter5: Probability: An Introduction To Modeling Uncertainty
Section: Chapter Questions
Problem 33P: Suppose that Motorola uses the normal distribution to determine the probability of defects and the...
icon
Related questions
icon
Concept explainers
Topic Video
Question

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 sub-
assembly are then assembled in the Assembly Department. The activities, expected costs, and drivers associated with these two manufacturing processes are given below.

Required:
1. Using a plantwide rate based on machine hours, calculate the total overhead cost assigned
to each product and the unit overhead cost.
2. Using activity rates, calculate the total overhead cost assigned to each product and the unit
overhead cost. Comment on the accuracy of the plantwide rate.

3. Calculate the global consumption ratios.
4. Calculate the consumption ratios for welding and materials handling (Assembly) and show
that two drivers, welding hours and number of parts, can be used to achieve the same ABC
product costs calculated in Requirement 2. Explain the value of this simplification.
5. Calculate the consumption ratios for inspection and engineering, and show that the drivers
for these two activities also duplicate the ABC product costs calculated in Requirement 2.

Expected
Quantity
Process
Activity
Cost
Activity Driver
Cutting and Welding
S 776,000
Welding
Machining
Inspecting
Materials handling
Setups
Welding hours
Machine hours
No. of inspections
4,000
450,000
448,250
10,000
1,000
300,000
No. of batches
12,000
240,000
No. of setups
100
Changeover
Rework
S2,214.250
S 180,000
61,750
Changeover hours
Rework orders
Assembly
1,000
50
750
Testing
Materials handling
Engineering support
300,000
No. of tests
380,000
130,000
No. of parts
Engineering hours
50,000
2,000
S1,051,750
Note: In the assembly process, the materials-handling activity is a function of product characteristics rather than batch activity.
Other overhead activities, their costs, and drivers are listed below.
Activity
Cost
Activity Driver
Quantity
500
Purchasing
Receiving
Paying suppliers
Providing space and utilities
S135,000
274,000
225,000
Purchase requisitions
Receiving orders
No. of invoices
2,000
1,000
100,000
Machine hours
10,000
S734,000
Transcribed Image Text:Expected Quantity Process Activity Cost Activity Driver Cutting and Welding S 776,000 Welding Machining Inspecting Materials handling Setups Welding hours Machine hours No. of inspections 4,000 450,000 448,250 10,000 1,000 300,000 No. of batches 12,000 240,000 No. of setups 100 Changeover Rework S2,214.250 S 180,000 61,750 Changeover hours Rework orders Assembly 1,000 50 750 Testing Materials handling Engineering support 300,000 No. of tests 380,000 130,000 No. of parts Engineering hours 50,000 2,000 S1,051,750 Note: In the assembly process, the materials-handling activity is a function of product characteristics rather than batch activity. Other overhead activities, their costs, and drivers are listed below. Activity Cost Activity Driver Quantity 500 Purchasing Receiving Paying suppliers Providing space and utilities S135,000 274,000 225,000 Purchase requisitions Receiving orders No. of invoices 2,000 1,000 100,000 Machine hours 10,000 S734,000
Other production information concerning the two hydraulic cylinders is also provided:
Cylinder A
Cylinder B
Units produced
Welding hours
1,500
1,600
3,000
2,400
3,000
500
Machine hours
7,000
Inspections
Moves
500
7,200
4,800
Batches
45
55
Changeover hours
Rework orders
540
460
5
45
No. of tests
500
250
Parts
40,000
10,000
Engineering hours
Requisitions
Receiving orders
1,500
500
425
75
1,800
200
Invoices
650
350
Transcribed Image Text:Other production information concerning the two hydraulic cylinders is also provided: Cylinder A Cylinder B Units produced Welding hours 1,500 1,600 3,000 2,400 3,000 500 Machine hours 7,000 Inspections Moves 500 7,200 4,800 Batches 45 55 Changeover hours Rework orders 540 460 5 45 No. of tests 500 250 Parts 40,000 10,000 Engineering hours Requisitions Receiving orders 1,500 500 425 75 1,800 200 Invoices 650 350
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning