2. Determine the total and per-unit activity cost for all three products. Round all total costs to whole number and round all per unit amounts to the nearest cent. Formula: Activity-Base Usage x Activity rate from Req. (1) = Activity cost; #NAME? Sum all activity costs per product to determine the total activity costs and Divide the total activity overhead by budgeted units to compute the activity costs per unit for each product. Products Production Setup Materials handlin Engineering Inspection Total costs Unit cost Standard Premium Super Total 0 0 0 0 0 0 0Problem 1 Complete the Cells in BLUE Min Xi Manufacturing Company produce three model of an electronic device (Standard, Premium and Super) 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: Activities Activity Cost Pool Activity Base Machining $350,000 Machine Hours (MH) Setup $120,000 Number of Setups Materials handling $20,000 Number of Material order (MO ngineering $154,000 Number of Eng. Hours (EH) spection $108,000 Number of Insp. Hours (IH) $752,000 The activity-base usage quantities and units produced for the three products were determined from corporate records and are as follows Number of MH Number of Setups Number of MO Number of EH Number of IH Number of Units Produced Standard 2,500 250 350 250 280 2.500 Premium 1,700 180 250 230 170 1,700 Super 800 170 400 220 150 800 Total 6,00 6001 1,000 700 600 Each product requires 60 minutes per unit of machine time equired: Determine the activity rate for each activity. Round all per unit amounts to the nearest cent. Formula: Activity rate = Activity cost pool = Number of activity base ctivities Activity Cost Pool Number of Activity Base Activity rate Machining $350,000 $ 5,000 Machine Hours 70 Setup $120.000 $ 600 Number of Setups 200 Materials handling $20.000 $ 1,000 Number of MC 20 Engineering $154,000 $ 700 Number of EH 220 ispection $108,000 $ 600 Number of IH 180 2. Determine the total and per-unit activity cost for all three products. =sum Round all total costs to whole number and round all per unit amounts to the nearest cent. Formula: Activity-Base Usage x Activity rate from Req. (1) = Activity cost, #NAME? Sum all activity costs per product to determine the total activity costs and Divide the total activity overhead by budgeted units to compute the activity costs per unit for each product. Products Production Setup Materials handlin Engineering Inspection Total costs Unit cost tandard Premium super Total 0 0 0