Problem 04-5A Pricing analysis with ABC and a plantwide overhead rate LO A1, A2, P1, P3 [The following information applies to the questions displayed below.) Sara's Salsa Company produces its condiments in two types: Extra Fine for restaurant customers and Family Style for home use. Salsa is prepared in department 1 and packaged in department 2. The activities, overhead costs, and drivers associated with these two manufacturing processes and the company's production support activities follow. Process Department 1 Activity Mixing Cooking Product testing Driver Machine hours Machine hours Batches Quantity 2,900 2,900 500 Department 2 Machine calibration Labeling Defects Overhead cost $ 7,000 16,200 114,500 $ 137,700 $ 350,000 18,500 9,500 $ 378,000 $ 89,000 58,000 85,000 $ 232,000 Production runs Cases of output Cases of output 700 140,000 140,000 Support Recipe formulation Heat, lights, and water Materials handling Focus groups Machine hours Container types 50 2,900 10 Additional production information about its two product lines follows. Units produced Batches Machine hours Focus groups Container types Production runs Extra Fine 40,000 cases 400 batches 1,250 MH 32 groups 5 containers 310 runs Family Style 100,000 cases 100 batches 1,650 MH 18 groups 5 containers 390 runs 4. Using ABC, compute the total cost per case for each product type if the direct labor and direct materials cost is $11 per case of Extra Fine and $7 per case of Family Style. (Round your intermediate calculations to 2 decimal places. Round "Activity Rate" and "Overhead cost per unit" answers to 2 decimal places.) Answer is not complete. Extra fine Family Style Activity Drivers Activity Activity Drivers Activity Rate Activity Drivers Overhead Cost $ 23,200 Overhead assigned Overhead assigned $ 1,650 2,900 machine hours $ 1,250 1.650 Mixing & Cooking Product testing Machine calibration Labeling & Defects Recipe formulation Heat, light and water Material handling 1.00 per machine hours 1.00 X per batch 1.00 x per run 1.00 x per case 400 310 40,000 32 114,500 500 batches 350,000 700 runs 28,000 140,000 cases 89.000 50 groups 58,000 2.900 machine hours 85.000 10 container types 100 390 100,000 310 40,000 32 100 390 100,000 18 1.00 X per group 18 1.00 per machine hour 16 X 16 12 X 12 1.00 X per type x 1 x 1 $ 102,171 Total overhead costs assigned Total units produced Overhead cost per unit 1 Total overhead costs assigned 40,000 Total units produced 1.00 Overhead cost per unit 100,000 $ $ 1.00 X Extra fine Family Style $ 11.00 $ 7 Direct materials and direct labor Overhead Total cost/case 1.00 12.00 1.00 8.00 $ $
