Activity-Based Costing
Steampunk Corporation has the following predicted indirect costsand cost drivers for 2019 for the given activity cost pools:
| Fabrication Department | Finishing Department | Cost Driver |
---|
Maintenance | $ 60,000 | 30,000 | Machine hours |
Materials handling | 90,000 | 45,000 | Material moves |
Machine | 210,000 | 15,000 | Machine setups |
Inspections | - | 75,000 | Inspection hours |
Total | $ 360,000 | $165,000 | |
The following activity predictions were also made for theyear:
| Fabrication Department | Finishing Department |
---|
Machine hours | 5,000 | 2,500 |
Material moves | 1,500 | 750 |
Machine setups | 350 | 25 |
Inspection hours | - | 500 |
It is assumed that the cost per unit of activity for a givenactivity does not vary between departments. Steampunk's president,Abner Punk, is trying to evaluate the company's product mixstrategy regarding two of its product models, SW100 and SG150. Thecompany has been using a company wide overhead rate based onmachine hours but is considering switching to either departmentrates of activity-based rates. The production manager has providedthe following data for the production of a batch of 100 units foreach of these models:
| SW100 | SG150 |
---|
Direct materials cost | $ 20,000 | $ 30,000 |
Direct labor cost | $ 8,000 | $ 6,000 |
Machine hours (Fabrication) | 250 | 350 |
Machine hours (Finishing) | 100 | 50 |
Materials moves | 20 | 40 |
Machine setups | 5 | 10 |
Inspection hours | 15 | 30 |
a. Determine the cost of one unit each of SW100 and SG150,assuming a company-wide overhead rate is used based on totalmachine hours.
Round rate to two decimal places.
Overhead rate based on total machine hours: $Answer per machinehour
Use rounded overhead rate calculated about for calculationsbelow. Round cost answers to the nearest whole number. Round costper unit to two decimal places.
Product Costs per Unit | SW100 | SG150 |
---|
Direct materials | Answer | Answer |
Direct labor | Answer | Answer |
Manufacturing overhead | Answer | Answer |
Total cost per batch | Answer | Answer |
Number of units per batch | Answer | Answer |
Cost per unit | Answer | Answer |
b. Determine the cost of one unit of SW100 and SG150, assumingdepartment overhead rates are used. Overhead is assigned based onmachine hours in both departments.
Round to two decimal places, if applicable.
Overhead rate based on machine hours for Fabrication Dept.:$Answer per machine hour.
Overhead rate based on machine hours for Finishing Dept.:$Answer per machine hour.
Use rounded overhead rate calculated above for calculationsbelow. Round cost answers to the nearest whole number, when needed.Round cost per unit to two decimal places, if needed.
Product Costs per Unit | SW100 | SG150 |
---|
Direct materials | Answer | Answer |
Direct labor | Answer | Answer |
Manufacturing overhead: |
Fabrication Dept. | Answer | Answer |
Finishing Dept. | Answer | Answer |
Total cost per batch | Answer | Answer |
Number of units per batch | Answer | Answer |
Cost per unit | Answer | Answer |
c. Determine the cost of one unit of SW100 and SG150, assumingactivity-based overhead rates are used for maintenance, materialshandling, machine setup, and inspection activities.
Round rate to two decimal places, if applicable.
Activity-based overhead rates: |
Maintenance | Answer |
Materials handling | Answer |
Machine setup | Answer |
Inspection activities | Answer |
Use rounded overhead rate calculated above for calculationsbelow. Round cost answers to the nearest whole number, when needed.Round cost per unit to two decimal places, if needed.
Product Costs per Unit | SW100 | SG150 |
---|
Direct materials | Answer | Answer |
Direct labor | Answer | Answer |
Manufacturing overhead: |
Maintenance activity | Answer | Answer |
Materials handling activity | Answer | Answer |
Machine setups activity | Answer | Answer |
Inspections activity | Answer | Answer |
Total cost per batch | Answer | Answer |
Number of units per batch | Answer | Answer |
Cost per unit | Answer | Answer |