Question

In: Accounting

Activity-Based Costing, Reducing the Number of Drivers and Equal Accuracy Reducir, Inc., produces two different types...

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

Solutions

Expert Solution


Related Solutions

Activity-based costing, manufacturing. Decorative Doors, Inc., produces two types of doors, interior and exterior. The company’s...
Activity-based costing, manufacturing. Decorative Doors, Inc., produces two types of doors, interior and exterior. The company’s simple costing system has two direct-cost categories (materials and labor) and one indirect-cost pool. The simple costing system allocates indirect costs on the basis of machine-hours. Recently, the owners of Decorative Doors have been concerned about a decline in the market share for their interior doors, usually their biggest seller. Information related to Decorative Doors production for the most recent year follows: Table shows...
Problem 5-15B Using activity-based costing to improve allocation accuracy Casey’s Commemoratives makes and sells two types...
Problem 5-15B Using activity-based costing to improve allocation accuracy Casey’s Commemoratives makes and sells two types of decorative plates. One plate displays a hand-painted image of Princess Kate; the other plate displays a machine-pressed image of Marilyn Monroe. The Kate plates require 25,000 hours of direct labor to make; the Monroe plates require only 5,000 hours of direct labor. Overhead costs are composed of (1) $105,000 machine-related activity costs, including indirect labor, utilities, and depreciation; and (2) $75,000 labor-related activity...
Assume activity-based costing is suitable for your business. Select TWO possible activity cost drivers in your...
Assume activity-based costing is suitable for your business. Select TWO possible activity cost drivers in your business and describe in detail what the activities in the cost driver are.
Activity based costing Apply the Concepts Scenario IV: Goodmark Company produces two types of birthday cards:...
Activity based costing Apply the Concepts Scenario IV: Goodmark Company produces two types of birthday cards: scented and regular. Expected product data for the coming year are given below. Overhead costs are identified by activity. Scented Cards Regular Cards Total Units produced 20,000 200,000 - Prime costs $160,000 $1,500,000 $1,660,000 Direct labor hours 20,000 160,000 180,000 Number of setups 60 40 100 Machine hours 10,000 80,000 90,000 Inspection hours 2,000 16,000 18,000 Number of moves 180 120 300 Overhead costs:...
Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell...
Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 4,000 direct labor hours. The total indirect labor is budgeted to be $524,800. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time supporting actual production. The following information about cell phones and tablet PCs...
Digital Storage Concept Inc. is considering a change to activity-based product costing. The company produces two...
Digital Storage Concept Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 3,750 direct labor hours. The total indirect labor is budgeted to be $375,000. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time supporting actual production. The following information about cell phones and...
Exercise C: Activity-Based Costing Erte, Inc. has the following predicted indirect costs and cost drivers for...
Exercise C: Activity-Based Costing Erte, Inc. has the following predicted indirect costs and cost drivers for 2017 for the given activity cost pools: Manufacture Department Finishing Department Cost Driver Maintenance $30,000 $15,000 Machine hours Materials handling $40,000 $25,000 Material moves Machine setups $80,000 $5,000 Machine setups Inspections $0 $20,000 Inspection hours Total 150,000 $65,000 The following activity predictions were also made for the year: Manufacture Department Finishing Department Machine hours 15,000 8,000 Materials moves 5,000 3,500 Machine setups 900 150...
ACCT4210–Cost and Managerial Accounting Problem 4: Activity-based costing Rome, Inc., produces two products, Product A and...
ACCT4210–Cost and Managerial Accounting Problem 4: Activity-based costing Rome, Inc., produces two products, Product A and Product B. If currently allocates overhead costs using direct-labor hours, but the controller has recommended an activity-based costing (ABC) system using the following data: Activity Level Activity Cost-Driver Base Cost Product A Product B Production setup Number of setups $ 90,000 11 19 Materials handling & requisition Number of parts per unit $ 15,000 6 18 Packaging & shipping Number of units shipped $...
Exercise 9-25 Activity-Based versus Traditional Costing (L.O. 4, 5, 6) Rodent Corporation produces two types of...
Exercise 9-25 Activity-Based versus Traditional Costing (L.O. 4, 5, 6) Rodent Corporation produces two types of computer mice, wired and wireless. The wired mice are designed as low-cost, reliable input devices. The company only recently began producing the higher-quality wireless model. Since the introduction of the new product, profits have been steadily declining. Management believes that the accounting system is not accurately allocating costs to products, particularly because sales of the new product have been increasing.      Management has asked you...
Activity-based costing problem Factory A produces golf carts. One of its plants in Texas produces two...
Activity-based costing problem Factory A produces golf carts. One of its plants in Texas produces two versions of carts: a basic model and a deluxe model. The deluxe model has a sturdier frame, a higher horsepower engine, bigger tires, and softer seats. At the beginning of the year, the following data were prepared by the controller’s office for this Texas plant:                                                                                          Basic                         Deluxe Expected Quantity to Produce                         20,000 carts                 10,000 carts Selling Price                                                                $ 1,800                       $ 3,600...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT