Required Information Problem 17-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 Overhead cost $ 7,000 16,200 114,500 $ 137,700 $ 350,000 18,500 9,500 Department 2 Machine calibration Labeling Defects Production runs Cases of output Cases of output 700 140,000 140,000 $ 378,000 Support Recipe formulation Heat, lights, and water Materials handling $ 89,000 58,000 85,000 $ 232,000 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 Problem 17-5A Parts 1, 2 & 3 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 case for the two products if the direct materials and direct labor Problem 17-5A Parts 1, 2 & 3 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 case for the two products if the direct materials and direct labor cost is $11 per case of Extra Fine and $7 per case of Family Style. 3.a. If the market price of Extra Fine Salsa is $19 per case and the market price of Family Style Salsa is $12 per case, determine the gross profit per case for each product. 3.b. What might management conclude about the Family Style Salsa product line? Complete this question by entering your answers in the tabs below. Req 1 Reg 2 Reg 3A Req 3B 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. (Round your intermediate calculations and final answers to 2 decimal places.) Plantwide overhead rate per case Batches Machine hours Focus groups Container types Production runs 400 batches 1,250 MH 32 groups 5 containers 310 runs 100 batches 1,650 MH 18 groups 5 containers 390 runs Problem 17-5A Parts 1, 2 & 3 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 case for the two products if the direct materials and direct labor cost is $11 per case of Extra Fine and $7 per case of Family Style. 3.a. If the market price of Extra Fine Salsa is $19 per case and the market price of Family Style Salsa is $12 per case, determine the gross profit per case for each product. 3.b. What might management conclude about the Family Style Salsa product line? Complete this question by entering your answers in the tabs below. Reg Reg 2 3A Req 3B Using the plantwide overhead rate, determine the total cost per case for the two products if the direct materials and direct labor cost is $11 per case of Extra Fine and $7 per case of Family Style. (Round your intermediate calculations and final answers to 2 decimal places.) Total cost per unit unit Extra Fine Family Style unit Batches Machine hours Focus groups Container types Production runs 400 batches 1,250 MH 32 groups 5 containers 310 runs 100 batches 1,650 MH 18 groups 5 containers 390 runs Problem 17-5A Parts 1, 2 & 3 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 case for the two products if the direct materials and direct labor cost is $11 per case of Extra Fine and $7 per case of Family Style. 3.a. If the market price of Extra Fine Salsa is $19 per case and the market price of Family Style Salsa is $12 per case, determine the gross profit per case for each product. 3.b. What might management conclude about the Family Style Salsa product line? Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 34 Req 3B If the market price of Extra Fine Salsa is $19 per case and the market price of Family Style Salsa is $12 per case, determine the gross profit per case for each product. (Round your intermediate calculations and final answers to 2 decimal places.) Extra Fine Family Style Units produced Batches Machine hours Focus groups Container types Production runs 40,00 cases 400 batches 1,250 MH 32 groups 5 containers 310 runs 100,00 cases 100 batches 1,650 MH 18 groups 5 containers 390 runs Problem 17-5A Parts 1, 2 & 3 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 case for the two products if the direct materials and direct labor cost is $11 per case of Extra Fine and $7 per case of Family Style. 3.a. If the market price of Extra Fine Salsa is $19 per case and the market price of Family Style Salsa is $12 per case, determine the gross profit per case for each product. 3.b. What might management conclude about the Family Style Salsa product line? Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 3A Req 3B What might management conclude about the Family Style Salsa product line? Conclude about the Family Style Salsa product line