1 Activity Activity Cost Pool 2 Production $278,280.00 82,677.00 3 Setup Material handling 11,110.00 54,918.00 5 Inspection 6 Product engineering 144,361.00 Total $571,346.00 The activity bases identified for each activity are as follows: Activity Production Setup Material handling Activity Base Machine hours Number of setups Number of parts Number of inspection hours Number of engineering hours Inspection Product engineering 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 Alpha 1,057 64 84 475 113 1,374 Beta 861 109 164 317 172 935 Omega 401 208 257 225 218 488 Total 2,319 381 505 1,017 503 2,797 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 three products . 3. Why aren't the activity unit costs equal across all three products since they require the same machine time per unit? "It required, round all per-unit amounts to the nearest cont Complete the Activity Table for Alpha 1. Determine the activity rate for each activity. Enter these rates in the Activity Rate columns 2. Use the activity rates in (1) to determine the total and per-unit activity costs associated with Alpha." *if required, round all per-unit amounts to the nearest cont. Alpha Activity Activity Base Activity Activity Usage Rato Cost Production Setup Material handling Inspection S > > Product Engineering IS Total activity cost Number of units Activity cost per unit Complete the Activity Table for Beta. 1. Determine the activity rate for each activity. Enter these rates in the Activity Rate columns 2 Use the activity rates in (1) to determine the total and per-unit activity costs associated with Beta. *If required, round all per-unit amounts to the nearest cent Beta Activity Activity Base Activity Activity Usage Cost Rate Production s > Setup Material handling S S Inspection Product Engineering Total activity cost Number of units Activity cost per unit Activity Table - Omega Complete the Activity Table for Omega. 1. Determine the activity rate for each activity, Enter these rates in the Activity Rate columns 2. Use the activity rates in (1) to determine the total and per unit activity costs associated with Omega." *# required, round all per-unit amounts to the nearest cont Omega Activity Activity Base Activity Activity ). Usage X Rate Cost Production Is S Setup > IS Material handling S Inspection S >> Product Engineering 5 Total activity cost S Number of units Activity cost per unit