Two-Stage ABC for Manufacturing
Meridian Company has determined its activity cost pools and cost
drivers to be the following:
| Cost pools | |
|---|---|
| Setup | $35,000 |
| Material handling | 12,800 |
| Machine operation | 280,000 |
| Packing | 30,000 |
| Total indirect manufacturing costs | $357,800 |
| Cost drivers | |
|---|---|
| Setups | 350 |
| Material moves | 640 |
| Machine hours | 20,000 |
| Packing orders | 1,200 |
One product made by Meridian, metal casements, used the following activities during the period to produce 500 units:
| Setups | 20 |
| Material moves | 80 |
| Machine hours | 1,900 |
| Packing orders | 150 |
(a) Calculate the cost per unit of activity for each activity cost pool.
| Setup | $Answer |
| Material handling | $Answer |
| Material operation | $Answer |
| Packing | $Answer |
(b) Calculate the manufacturing overhead cost per metal casement
manufactured during the period. Round your answer to the nearest
cent.
$Answer
Requirement (a)
|
Calculation of Activity rates |
|||||
|
Activity Cost Pool |
Activity driver |
Overhead Cost |
Expected Activity (B) |
Activity rate (A/B) |
|
|
Setup |
Number of Setup |
$ 35,000.00 |
350 |
$ 100.00 |
Per Setup |
|
Material handling |
Number of Material move |
$ 12,800.00 |
640 |
$ 20.00 |
Per Material move |
|
Machine operation |
Number of Machine hour |
$ 2,80,000.00 |
20000 |
$ 14.00 |
Per Machine hour |
|
Packing |
Number of Packing order |
$ 30,000.00 |
1,200 |
$ 25.00 |
Per Packing order |
|
Total |
$ 3,57,800.00 |
||||
|
Setup |
$ 100.00 |
Per Setup |
|
Material handling |
$ 20.00 |
Per Material move |
|
Machine operation |
$ 14.00 |
Per Machine hour |
|
Packing |
$ 25.00 |
Per Packing order |
Requirement (b)
|
Cost assigned to Metal casement |
|||
|
Activity name |
Activity Rates |
Activity |
ABC Cost |
|
(A) |
(B) |
(A x B) |
|
|
Setup |
$ 100.00 |
20 |
$ 2,000.00 |
|
Material handling |
$ 20.00 |
80 |
$ 1,600.00 |
|
Machine operation |
$ 14.00 |
1900 |
$ 26,600.00 |
|
Packing |
$ 25.00 |
150 |
$ 3,750.00 |
|
Total Overheads assigned |
$ 33,950.00 |
||
|
Production |
500 |
||
|
Overhead cost per unit |
$ 67.90 |
||
Cost per unit= $67.90
Two-Stage ABC for Manufacturing Meridian Company has determined its activity cost pools and cost drivers to...
Two-Stage ABC for Manufacturing Meridian Company has determined its activity cost pools and cost drivers to be the following: Cost pools Setup $63.000 Material handling 25,600 Machine operation 220,000 Packing 90.000 Total indirect manufacturing costs $398,600 Cost drivers Setups 350 Material moves 640 Machine hours 20,000 Packing orders 1.200 One product made by Meridian, metal casements, used the following activities during the period to produce 500 units: Setups 20 Material moves Machine hours 1,900 Packing orders 150 (a) Calculate the...
Two-Stage ABC for Manufacturing Merlot Company has determined its activity cost pools and cost drivers to be the following: Cost Pools Setup Material handling Machine operation packing Total indirect manufacturing costs $112,000 25,600 480,000 60,000 $677,600 Cost drivers Setups Material moves Machine hours Packing orders 350 640 20,000 1,200 One product made by Merlot, metal casements, used the following activities during the period to produce 500 units: Setups Material moves 80 Machine hours 1,900 Packing orders 150 20 a. Calculate...
P5-4A. Stage
Two ABC for Manufacturing Merlot Company has determined
its activity cost pools and cost drivers to be the following:
Cost
Pools
Setup……………………………………………………………………………………………………………………$59,500
Materials
handling……………………………………………………………………………………………….$16,000
Machine
operation……………………………………………………………………………………………….$300,000
Packing…………………………………………………………………………………………………………………$60,000
Total indirect
Manufacturing costs………………………………………………………………………..$435,500
Cost
drivers
Setups……………………………………………………………………………………………………………………..$350
Materials
moves………………………………………………………………………………………………………$640
Machine
hours…………………………………………………………………………………………………………$20,000
Packing
orders…………………………………………………………………………………………………………$1,000
One product made by
Merlot, metal casements, used the following activities during the
period to produce 500 unit:
Setups……………………………………………………………………………………………………………………..20
Materials
moves……………………………………………………………………………………………………….80
Machine
hours…………………………………………………………………………………………………………1,900
Packing
orders………………………………………………………………………………………………………….150
Required
Calculate the cost per unit of activity for each activity cost
pool...
Two-Stage ABC for Manufacturing Assume Sherwin-Williams Company, a large paint manufacturer, has determined the following activity cost pools and cost driver levels for the latest period: Activity Cost Pool Activity Cost Activity Cost Driver Machine setup 5900,000 2,500 setup hours Material handling 820.000 4.000 material moves Machine operation 400,000 20,000 machine hours The following data are for the production of single batches of two products, Mirlite and Subdue: Mirlite Subdue Gallons produced 60.000 25,000 Direct Isbor hours 400 250 Machine...
Two-Stage ABC for Manufacturing Assume Sherwin-Williams Company, a large paint manufacturer, has determined the following activity cost pools and cost driver levels for the latest period: Activity Cost Pool Activity Cost Activity Cost Driver Machine setup $900,000 2,500 setup hours Material handling 820,000 4,000 material moves Machine operation 400,000 20,000 machine hours The following data are for the production of single batches of two products, Mirlite and Subdue: Mirlite Subdue Gallons produced 60,000 25,000 Direct labor hours 400 250 Machine...
Two-Stage ABC for Manufacturing Assume Sherwin-Williams Company, a large paint manufacturer, has determined the following activity cost pools and cost driver levels for the latest period: Activity Cost Pool Activity Cost Activity Cost Driver Machine setup $900,000 2,500 setup hours Material handling 820,000 4,000 material moves Machine operation 400,000 20,000 machine hours The following data are for the production of single batches of two products, Mirlite and Subdue: Mirlite Subdue Gallons produced 60.000 25,000 Direct labor hours 400 250 Machine...
Two-Stage ABC for Manufacturing Assume Sherwin-Williams Company, a large paint manufacturer, has determined the following activity cost pools and cost driver levels for the latest period: Activity Cost Pool Activity Cost Activity Cost Driver Machine setup $900,000 2,500 setup hours Material handling 820,000 4,000 material moves Machine operation 400,000 20,000 machine hours The following data are for the production of single batches of two products, Mirlite and Subdue: Mirlite Subdue Gallons produced 60,000 25,000 Direct labor hours 400 250 Machine...
Two-Stage ABC for Manufacturing Detroit Foundry, a large manufacturer of heavy equipment components, has determined the following activity cost pools and cost driver levels for the year: Activity Cost Pool Activity Cost Activity Cost Driver Machine setup $600,000 12,000 setup hours Material handling 120,000 2,000 material moves Machine operation 500,000 10,000 machine hours The following data are for the production of single batches of two products, C23 Cams and U2 Shafts during the month of August: C23 Cams U2 Shafts...
Two-Stage ABC for Manufacturing Detroit Foundry, a large manufacturer of heavy equipment components, has determined the following activity cost pools and cost driver levels for the year: Activity Cost Pool Activity Cost Activity Cost Driver Machine setup $720,000 12,000 setup hours Material handling 120,000 3,000 material moves Machine operation 680,000 10,000 machine hours The following data are for the production of single batches of two products, C23 Cams and U2 Shafts during the month of August: C23 Cams U2 Shafts...
Two-Stage ABC for Manufacturing Detroit Foundry, a large manufacturer of heavy equipment components, has determined the following activity cost pools and cost driver levels for the year: Activity Cost Pool Activity Cost Activity Cost Driver Machine setup $720,000 12,000 setup hours Material handling 120,000 3,000 material moves Machine operation 680,000 10,000 machine hours The following data are for the production of single batches of two products, C23 Cams and U2 Shafts during the month of August: C23 Cams U2 Shafts...