It will help a lot if you guys can give a hand with this! From part A to E en excel! thanks in advance!

Hope this gives a better view!

please use Excel!

1. The total estimated manufacturing overhead was $260,000. Under traditional costing (which assigns overhead on the basis of direct labor hours), what amount of manufacturing overhead costs are assigned to:

1. One mobile safe?

2. One walk-in safe?

2. The total estimated manufacturing overhead of $260,000 was comprised of $160,000 for material handling costs and $100,000 for purchasing activity costs. Under activity-based costing (ABC):

3. What amount of material handling costs are assigned to:

1. One mobile safe?

2. One walk-in safe?

4. What amount of purchasing activity costs are assigned to:

1. One mobile safe?

2. One walk-in safe?

5. Compare the amount of overhead allocated to one mobile safe and to one walk-in safe under the traditional costing approach versus under ABC.

thank you!!

Exercise:

Perdon Corporation manufactures safeslarge mobile safes and large walk-in stationary bank safes. As part of its annual budgeting process, Perdon is analyzing the profitability of its two products. Part of this analysis involves estimating the amount of overhead to be allocated to each product line. The information shown below relates to overhead.

Mobile Walk-In

Safes Safes

Units planned for production 200 50

Material moves per product line 300 200

Purchase orders per product line 450 350

Direct labor hours per product line 800 1,700

1. The total estimated manufacturing overhead was $260,000. Under traditional costing (which assigns overhead on the basis of direct labor hours), what amount of manufacturing overhead costs are assigned to:

1. One mobile safe?

2. One walk-in safe?

2. The total estimated manufacturing overhead of $260,000 was comprised of $160,000 for material handling costs and $100,000 for purchasing activity costs. Under activity-based costing (ABC):

3. What amount of material handling costs are assigned to:

1. One mobile safe?

2. One walk-in safe?

4. What amount of purchasing activity costs are assigned to:

1. One mobile safe?

2. One walk-in safe?

5. Compare the amount of overhead allocated to one mobile safe and to one walk-in safe under the traditional costing approach versus under ABC.

Perdon Corporation manufactures safes-large mobile safes and large walkin stationary bank safes. As part of its annual budgeting process, Perdon is analyzing the profitability of its two products. Part of this andiysis involves estimating the amount of overtead to be alocated to each product line. The information shown bebw relates to overhead. a. The tolal estimated manulacturing overhead was $260,000. Under traditional costing (which assigns overhead on the basis of drect labor hours), what amount of mandacturing overhead costs are assigned to. 1. One mobile safe? 2. One walk-in sale? b. The total estimated manulacturing overthead of $260.000 was comprised of $160.000 for matenal handing costs and $100, 000 for purchasing activity costs. Under activity.based costirg (ABC) c. What amount of material handing costs are assigned to: 1. One moble safe? 2 One walk-in safe? d. What amount of purchasing activity costs are assigned to 1. One motde sale? 2 One walk-in safe? e. Compare the amount of overhead allocated to one mobile safe and to one walk-in safe under the traditional costing approach versus under ABC. Perdon Corporation manufactures safes-large mobile safes and large walk-in stationary bank safes. As part of its annual budgeting process, Perdon is analyzing the profitability of its two products. Part of this analysis involves estimating the amount of overhead to be allocated to each product line. The information shown below relates to overhead