In: Accounting
Mastery Problem: Activity-Based Costing
WoolCorp
WoolCorp buys sheep’s wool from farmers. The company began operations in January of this year, and is making decisions on product offerings, pricing, and vendors. The company is also examining its method of assigning overhead to products. You’ve just been hired as a production manager at WoolCorp.
Currently WoolCorp makes two products: (1) raw, clean wool to be used as stuffing or insulation and (2) wool yarn for use in the textile industry.
The company would like you to evaluate its costing methods for its raw wool and wool yarn.
Single Plantwide Rate
WoolCorp is currently using the single plantwide factory overhead rate method, which uses a predetermined overhead rate based on an estimated allocation base such as direct labor hours or machine hours. The rate is computed as follows:
Single Plantwide Factory Overhead Rate = (Total Budgeted Factory Overhead) ÷ (Total Budgeted Plantwide Allocation Base)
WoolCorp has been using combing machine hours as its allocation base.
The company would like to consider activity-based costing. In order to understand their current system better, you evaluate WoolCorp’s current method of costing for raw wool and wool yarn. The production staff has compiled the following information for you on the production of 550 pounds of either raw wool or wool yarn:
Factory Overhead Type |
Budgeted Factory Overhead |
Sorting | $25,600 |
Cleaning | 38,400 |
Combing | 1,300 |
Raw Wool | Wool Yarn | |
Hours of combing machine use required | 70 | 30 |
In the following table, use combing machine hours as the allocation base for assigning overhead costs to each product. When required, round your answers to the nearest dollar.
Single Plantwide Factory Overhead Rate: $ per combing hour
Raw Wool | Wool Yarn | |
Allocated factory overhead cost | $ | $ |
Feedback
Review the single plantwide factory overhead rate method, and allocate the costs using a single plantwide factory overhead rate and the combing hours used by each product.
Activity-Based Costing
In order to compare WoolCorp’s current method with activity-based costing, you interview the production staff and compile the following information, which relates to the costs for raw wool and wool yarn.
Type of Cost | Activity Base | Total Cost |
Sorting | Hours of sorting | $25,600 |
Cleaning | Units of cleaning machine power | 38,400 |
Combing | Hours of combing machine use | 1,300 |
Raw Wool | Wool Yarn | |
Hours of sorting required | 800 | 3,200 |
Units of cleaning machine power required | 1,920 | 4,480 |
Hours of combing machine use required | 70 | 30 |
In the following table, compute and enter the activity rate for each of the three activities. If required, round your answers to the nearest cent.
Activity | Activity Rate | |
Sorting | $ | per sorting hour |
Cleaning | $ | per unit of cleaning machine power |
Combing | $ | per hour of combing machine use |
In the following table, allocate the costs of sorting, cleaning, and combing based on the rates of activity consumed by each product’s process. When required, round your answers to the nearest dollar.
Raw Wool | Wool Yarn | |
Sorting cost | $ | $ |
Cleaning cost | ||
Combing cost | ||
Total cost | $ | $ |
Part 1 | |||||
Plantwide Factory OH rate =Estimated Factory overhead / Estimated Machine hours | |||||
Plantwide Factory OH rate =$65,300 / 100 hours =$653.00 per machine hours | |||||
Raw Wool | Wool Yarn | ||||
Machine hours used | 70 | 30 | |||
Plantwide Factory OH rate | $ 653.00 | $ 653.00 | |||
Allocated Factory Overhead costs | $ 45,710.00 | $ 19,590.00 | |||
Part 2 | |||||
Computation of Activity Based usage | |||||
Raw Wool | Wool Yarn | Total | |||
Sorting | 800 | 3200 | 4000 | sorting hours | |
Cleaning | 1920 | 4480 | 6400 | cleaning machine power | |
Combing | 70 | 30 | 100 | machine hours | |
Computation of ABC rate | |||||
Activity | OH Costs(Col 1) | No. of activity base(Col 2) | Activity Rate(Col 1 / Col 2) | ||
Sorting | $ 25,600 | 4,000 | $ 6.40 | per sorting hours | |
Cleaning | $ 38,400 | 6,400 | $ 6.00 | per cleaning machine power | |
Combing | $ 1,300 | 100 | $ 13.00 | per machine hours | |
Allocation of Overhead Costs | |||||
Raw Wool | Wool Yarn | ||||
Activity Based usage | Activity Based usage*ABC rate | Activity Based usage | Activity Based usage*ABC rate | ||
Sorting | 800 | $ 5,120.00 | 3200 | $ 20,480.00 | |
Cleaning | 1920 | $ 11,520.00 | 4480 | $ 26,880.00 | |
Combing | 70 | $ 910.00 | 30 | $ 390.00 | |
Total Overhead Cost allocated | $ 17,550.00 | $ 47,750.00 | |||