Melo manufacturing company is a diversified manufacture that manufactures three products (Alpha Beta and omega) into 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 :
*****!!!! THERE ARE THREE CHARTS THAT NEED TO BE DONE (ALPHA, BETA, OMEGA) PLEASE MAKE AND NAME EACH CHART SEPARATELY*****!!!!!!!!
ns Activity Table-Alpha Activity Table - Beta Activ ctions Manufacturing Company is a diversified manufacturer that manufactures three pro a, Beta, and Omega) in a continuous production process. Senior management has a ontroller to conduct an activity-based costing study. The controller identified the amo y overhead required by the critical activities of the organization as follows: Activity Cost Pool Activity $237,552.00 2 Production 93,660.00 3 Setup 10,500.00 4 Material handling 53,185.00 5 Inspection 156,755.00 6 Product engineering $551,652.00 7Total le - Omega Final Questiorn Activity Table Alpha Shaded cells have feedback Alpha Activity- Activity Base Activity Activity Usage Rate Cost Production Imh S setups Setup setup partss part Material handling hour insp. hours S Inspection eng. hoursS hour Product Engineering Total activity cost Number of units Activity cost per unit Points:10/28 Activity Table Omega Activity- Activity Base Activity Activity Usage Rate Cost Production 130 x_Imh Setup setups setup partsS part Material handling ipart . insp. hours Inspection hour eng. hoursS hour Product Engineering Total activity cost Number of units Activity cost per unit Instructions The activity bases identified for each activity are as follows: Activity Activity Base Production Machine hours Setup Number of setups Material handling Number of parts Inspection Number of inspection hours Product engineering Number of engineering hours The activity-base usage quantities and units produced for the three products were determined from corporate records and are as tollows Machine Number of Number of Number of Number of Hours Setups Parts Inspection Hours Engineering Hours Units Alpha 1,000 82 62 458 133 1,137 Beta733 121 147 270 187 1,057 237 271 239 474 Omega 388 215 535 2,668 500 967 Total 2,121420 Instructions The activity-base usage quantities and units produced for the three products were determined from corporate records and are as follows Machine Number of Number of Number of Number of Hours Setups Parts Inspection Hours Engineering Hours Units 82 1,137 Alpha 1,000 62 458 133 121 Beta 733 1,057 147 270 187 215 239 474 Omega388 237 271 2,668 967 535 2,121 420 500 Total Each product requires 40 minutes per unit of machine time. Required Complete the Activity Tables for Alpha, Beta and Omega. 1. Determine the activity rate for each activity. 2. Use the activity rates in (1) to determine the total and per-unit activity costs associated with all hree products across all three products since they require the same machine time per unit? Why aren't the activity unit costs equal 3. "If required, round all per-unit amounts to the nearest cent