Question

In: Accounting

Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given...

Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools:

Fabrication
Department
Finishing
Department
Cost Driver
Maintenance $ 36,000 18,000 Machine hours
Materials handling 54,000 27,000 Material moves
Machine 126,000 9,000 Machine setups
Inspections

-

45,000

Inspection hours
Total

$ 216,000

$ 99,000

The following activity predictions were also made for the year:

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 given activity does not vary between departments. Steampunk's president, Abner Punk, is trying to evaluate the company's product mix strategy regarding two of its product models, SW100 and SG150. The company has been using a company wide overhead rate based on machine hours but is considering switching to either department rates of activity-based rates. The production manager has provided the following data for the production of a batch of 100 units for each of these models:

SW100 SG150
Direct materials cost $ 12,000 $ 18,000
Direct labor cost $ 4,800 $ 3,600
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 total machine hours.

Round rate to two decimal places.

Overhead rate based on total machine hours: $Answer per machine hour

Use rounded overhead rate calculated about for calculations below. Round cost answers to the nearest whole number. Round cost per 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, assuming department overhead rates are used. Overhead is assigned based on machine 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 calculations below. 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, assuming activity-based overhead rates are used for maintenance, materials handling, 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 calculations below. 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

Solutions

Expert Solution

a. Company-wide overhead rate=Total indirect costs/Total machine hours=(216000+99000)/(5000+2500)=315000/7500=$ 42 per MH
Product Costs per Unit:
SW 100 SG 150
Direct materials cost 12000 18000
Direct labor cost 4800 3600
Manufacturing overhead 14700 16800
(Machine hours*allocation rate) (250+100)*42 (350+50)*42
Total cost per batch a 31500 38400
Number of units per batch b 100 100
Cost per unit a/b 315 384
b. Department overhead rates=Total indirect cost for the department/Total machine hours for the department
Fabrication
Department:
Department overhead rates=216000/5000=$ 43.2 per MH
Finishing
Department:
Department overhead rates=99000/2500=$ 39.6 per MH
Product Costs per Unit:
SW 100 SG 150
Direct materials cost 12000 18000
Direct labor cost 4800 3600
Manufacturing overhead
(Machine hours*allocation rate)
Fabrication
Department
10800 15120
(250*43.2) (350*43.2)
Finishing
Department
3960 1980
(100*39.6) (50*39.6)
Total cost per batch a 31560 38700
Number of units per batch b 100 100
Cost per unit a/b 315.6 387
c. Activity based overhead rates=Estimated overhead cost/Total cost driver volume
Activity Cost Total cost driver volume Activity rate
a b a/b
Maintenance 54000 7500 7.2 Per MH
(36000+18000) (5000+2500)
Materials handling 81000 2250 36 Per move
(54000+27000) (1500+750)
Machine 135000 375 360 Per setup
(126000+9000) (350+25)
Inspections 45000 500 90 per inpection hour
Product Costs per Unit:
SW 100 SG 150
Direct materials cost 12000 18000
Direct labor cost 4800 3600
Manufacturing overhead:
Maintenance activity 2520 2880
(Activity based overhead rate*cost driver usage) (250+100)*7.2 (350+50)*7.2
Materials handling activity 720 1440
(Activity based overhead rate*cost driver usage) (20*36) (40*36)
Machine setups activity 1800 3600
(Activity based overhead rate*cost driver usage) (5*360) (10*360)
Inspections a

Related Solutions

Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given...
Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools: Fabrication Department Finishing Department Cost Driver Maintenance $96 ,000 48,000 Machine hours Materials handling 144,000 72,000 Material moves Machine 336,000 24,000 Machine setups Inspections - 120,000 Inspection hours Total $ 576,000 $264 ,000 The following activity predictions were also made for the year: Fabrication Department Finishing Department Machine hours 5,000 2,500 Material moves 1,500 750 Machine setups 350 25 Inspection hours...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and 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 the year: Fabrication Department Finishing Department Machine hours 5,000 2,500 Material moves 1,500 750 Machine setups 350 25 Inspection...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools: Fabrication Department Finishing Department Cost Driver Maintenance $ 54,000 27,000 Machine hours Materials handling 81,000 40,500 Material moves Machine 189,000 13,500 Machine setups Inspections - 67,500 Inspection hours Total $ 324,000 $ 148,500 The following activity predictions were also made for the year: Fabrication Department Finishing Department Machine hours 5,000 2,500 Material moves 1,500 750 Machine setups 350 25...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools: Fabrication Department Finishing Department Cost Driver Maintenance $ 54,000 27,000 Machine hours Materials handling 81,000 40,500 Material moves Machine 189,000 13,500 Machine setups Inspections - 67,500 Inspection hours Total $ 324,000 $ 148,500 The following activity predictions were also made for the year: Fabrication Department Finishing Department Machine hours 5,000 2,500 Material moves 1,500 750 Machine setups 350 25...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools: Fabrication Department Finishing Department Cost Driver Maintenance $ 54,000 27,000 Machine hours Materials handling 81,000 40,500 Material moves Machine 189,000 13,500 Machine setups Inspections - 67,500 Inspection hours Total $ 324,000 $ 148,500 The following activity predictions were also made for the year: Fabrication Department Finishing Department Machine hours 5,000 2,500 Material moves 1,500 750 Machine setups 350 25...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and 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 the year: Fabrication Department Finishing Department Machine hours 5,000 2,500 Material moves 1,500 750 Machine setups 350 25 Inspection...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and cost drivers for 2019 for...
Activity-Based Costing Steampunk Corporation has the following predicted indirect costs and 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 the year: Fabrication Department Finishing Department Machine hours 5,000 2,500 Material moves 1,500 750 Machine setups 350 25 Inspection...
Slack Corporation has the following predicted indirect costs and cost drivers for 2019 for the given...
Slack Corporation has the following predicted indirect costs and cost drivers for 2019 for the given activity cost pools: Fabrication Department Finishing Department Cost Driver Maintenance $20,000 $10,000 Machine hours Materials handling 30,000 15,000 Material moves Machine setups 70,000 5,000 Machine setups Inspections - 25,000 Inspection hours $120,000 $55,000 The following activity predictions were also made for the year: Fabrication Department Finishing Department Machine hours 10,000 5,000 Material moves 3,000 1,500 Machine setups 700 50 Inspection hours - 1,000 It...
Question text Activity-Based Costing Slack Corporation has the following predicted indirect costs and cost drivers for...
Question text Activity-Based Costing Slack Corporation has the following predicted indirect costs and cost drivers for 2016 for the given activity cost pools: Fabrication Department Finishing Department Cost Driver Maintenance $80,000 $70,000 Machine hours Materials handling 30,000 15,000 Material moves Machine setups 70,000 5,000 Machine setups Inspections - 25,000 Inspection hours $180,000 $115,000 The following activity predictions were also made for the year: Fabrication Department Finishing Department Machine hours 10,000 5,000 Material moves 3,000 1,500 Machine setups 700 50 Inspection...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT