Question

Instructions Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and OmeRequired Complete the Activity Tables for Alpha Bots and more 1. Determine the city rate for each activity 2. Use me activityProduction $ Setup $ Meral $ $ s handling Inspection Product Engineering Total activity cost Number of units Activity cost pe

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Alpha
Base Activity Activity
Activity usage * rate = cost
Production 1,440 mh 80 /mh = 115200
Setup 75 setups 100 /setups = 7500
Material handling 65 parts 30 /parts = 1950
Inspection 400 insp.hours 50 /insp.hrs = 20000
product engineering 125 eng. Hours 280 /eng.hrs = 35000
Total activity cost 179650
number of units 1,800
Activity cost per unit 99.81
where activity rate =activity cost pool/total base usage
Beta
Base Activity Activity
Activity usage * rate = cost
Production 1,080 mh 80 /mh = 86400
Setup 165 setups 100 /setups = 16500
Material handling 80 parts 30 /parts = 2400
Inspection 300 insp.hours 50 /insp.hrs = 15000
product engineering 175 eng. Hours 280 /eng.hrs = 49000
Total activity cost 169300
number of units 1,350
Activity cost per unit 125.41
Omega
Base Activity Activity
Activity usage * rate = cost
Production 720 mh 80 /mh = 57600
Setup 310 setups 100 /setups = 31000
Material handling 180 parts 30 /parts = 5400
Inspection 500 insp.hours 50 /insp.hrs = 25000
product engineering 140 eng. Hours 280 /eng.hrs = 39200
Total activity cost 158200
number of units 900
Activity cost per unit 175.78
3) The difference is because the products consume many activities in ratios different
from the volume
Add a comment
Know the answer?
Add Answer to:
Instructions Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega)...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Instructions Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega)...

    Instructions Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows: 1 Activity Activity Cost Pool 2 Production $242,089.00 3 Setup 88,425.00 4. Material handling 9,253.00 5 Inspection 49,623.00 6 Product engineering 167,990.00 7 Total $557,380.00 Production Machine hours Setup...

  • Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in...

    Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows: 1 Activity Activity Cost Pool 2 Production $251,598.00 3 Setup 92,035.00 4 Material handling 10,736.00 5 Inspection 49,833.00 6 Product engineering 136,230.00 7 Total $540,432.00 The activity bases identified for...

  • Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in...

    Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows: 1 Activity Activity Cost Pool 2 Production $238,830.00 3 Setup 96,585.00 4 Material handling 9,660.00 5 Inspection 52,364.00 6 Product engineering 171,622.00 7 Total $569,061.00 The activity bases identified for...

  • Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in...

    Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows: 1 Activity Activity Cost Pool 2 Production $238,830.00 3 Setup 96,585.00 4 Material handling 9,660.00 5 Inspection 52,364.00 6 Product engineering 171,622.00 7 Total $569,061.00 The activity bases identified for...

  • Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in...

    Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows: 1 Activity Activity Cost Pool 2 Production $251,598.00 3 Setup 92,035.00 4 Material handling 10,736.00 5 Inspection 49,833.00 6 Product engineering 136,230.00 7 Total $540,432.00 The activity bases identified for...

  • Activity-Based Product Costing Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta,...

    Activity-Based Product Costing Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows: Activity Activity Cost Pool Production $259,200 Setup 55,000 Materials handling 9,750 Inspection 60,000 Product engineering 123,200 Total $507,150 The activity bases identified for each activity are as...

  • Hello, Please help me answer, activity table Alpha, i first pasted the instructions and numbers needed...

    Hello, Please help me answer, activity table Alpha, i first pasted the instructions and numbers needed and then pasted the actual Alpha table, thank you in advance Mello Manufacturing Company is a diversified manufacturer that manufactures three products (Alpha, Beta, and Omega) in a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows: 1 Activity Activity...

  • PR 18-4A Activity-based product costing Obj. 4 2. Alpha total activity Mello Manufacturing Company is a...

    PR 18-4A Activity-based product costing Obj. 4 2. Alpha total activity Mello Manufacturing Company is a diversified manufacturer that manufactures three products cost, $160,450 (Alpha, Beta, and Omega) in a continuous production process. Senior n a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows: EXCEL TEMPLATE Activity Production Setup Material handling Inspection Product engineering Total...

  • Garfield Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the...

    Garfield Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated budgeted activity costs and activity bases are as follows: Budgeted Activity Cost Activity Activity Base Casting $142,926 Machine hours Assembly 57,741 Direct labor hours Inspecting 19,912 Number of inspections Setup 24,300 Number of setups dling Materials handling 32,452 Number of loads Corporate records were obtained to estimate the amount of activity to be used by the two products....

  • Activity-Based Product Costing Sweet Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar)...

    Activity-Based Product Costing Sweet Sugar Company manufactures three products (white sugar, brown sugar, and powdered sugar) in a continuous production process. Senior management has asked the controller to conduct an activity-based costing study. The controller identified the amount of factory overhead required by the critical activities of the organization as follows: Activity Budgeted Activity Cost Production $471,200 Setup 310,800 Inspection 81,000 Shipping 156,000 Customer service 65,500 Total $1,084,500 The activity bases identified for each activity are as follows: Activity Activity...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT