Chapter 4 Activity-Based Costing and Analysis 163 Style for home use, Salsa and drivers associ Problem 4-5A Pricing analysis with ABC and a plantwide overhead rate A1 A2 P1 P3 Salsa Company produces its condiments in for home use, Salsa is prepared in department and packa wwo types: Extra Fine for restaurant customers and Family associated with these two manufacturing processes and its production Suport activities follow "Packaged in department 2 The activities overhead costs Process Activity Overhead Cost Driver Quantity Department Moving $4,500 Cooking Machine hours 1,500 Product testing 11.250 G Machine hours 1,500 112.500 / Batches 600 $128,250 Department 2 Machine calibration $250,000 Production runs 400 Labeling 12,000 Cases of output 120.000 Defects 6,000 Cases of output 120000 $268,000 Support Recipe formulation $ 90,000 Focus groups Heat, lights, and water 27,000 Machine hours 1.500 Materials handling 65,000 Container types $182,000 Additional production information about its two product lines follows. Units produced ......... Batches. Machine hours.......... Focus groups .......... Container types ......... Production runs......... 20.000 es 200 batches 500 MH 30 groups 5 containers 200 runs Paraly Style cases 400 butches 1.000 MH 15 groups 3 containers 200 runs Check 2) Cost per case: Extra Fine, $10.82: Family Style, $9.82 Required 1. Using a plantwide overhead rate based on cases, compute the overhead cost that is assigned to each case of Extra Fine Salsa and each case of Family Style Salsa. 2. Using the plantwide overhead rate, determine the total cost per unit for the two products if the direct materials and direct labor cost is $6 per case of Extra Fine and $5 per case of Family Style. 3. If the market price of Extra Fine Salsa is $18 per case and the market price of Family Style Salsa is $9 per case, determine the gross profit per case for each product. What might management conclude about each product line? 4. Using ABC, compute the total cost per case for each product type if the direct labor and direct materials cost is $6 per case of Extra Fine and $5 per case of Family Style. 5. If the market price is $18 per case of Extra Fine and $9 per case of Family Style, determine the gross profit per case for each product. How should management interpret the market prices given your computations? 6. Would your pricing analysis be improved if the company used departmental rates based on machine hours in department 1 and number of cases in department 2, instead of ABC? Explain. (4) Cost per case: E Fine, $20.02: Family Style, $7.9