Question

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 its production support activities follow.

Process Activity Overhead cost Driver Quantity
Department 1 Mixing $6,000 Machine hours 2,400
Cooking 10,800 Machine hours 2,400
Product testing 114,000 Batches 750
$130,800
Department 2 Machine calibration $325,000 Production runs 650
Labeling 18,000 Cases of output 160,000
Defects 6,000 Cases of output 160,000
$349,000
Support Recipe formulation $84,000 Focus groups 50
Heat, lights, and water 42,000 Machine hours 2,400
Materials handling 80,000 Container types 10
$206,000
Additional production information about its two product lines follows.
Extra Fine Family Style
Units produced 35,000 cases 125,000 cases
Batches 350 batches 400 batches
Machine hours 1,000 MH 1,400 MH
Focus groups 34 groups 16 groups
Container types 4 containers 6 containers
Production runs 260 runs 390 runs
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 $10 per case of Extra Fine and $9 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 $13 per case, determine the gross profit per case for each product.
3-b. What might management conclude about the Family Style Salsa product line.

Answer 1

1.$4.29 per cases

2. Extra Fine $14.29

Family Style $13.29

3a. Extra Fine $4.71

Family Style $0.29

3b. What might the management conclude about the Family Style Salsa product line is that Family Style salsa are not yielding profit which may may inturn make make the company to stop the production of the product in a situation where either the cost are not reduced or where the price.

Step-by-step explanation:

1. Computation for the overhead cost that is assigned to each case of Extra Fine Salsa and each case of Family Style Salsa using Plantwide overhead rate

Using this formula

Overhead cost=Total overhead cost/Total volume

Let plug in the formula

First step is to calculate the Total overhead cost

Total overhead cost = $130,800 + $349,000 +$206,000

Total overhead cost =$685,800

Second step is to calculate the Total volume

Total volume= 35,000 + 125,000 cases

Total volume=160,000 cases

Now let calculate the Overhead cost

Overhead cost=$685,800/160,000 cases

Overhead cost=$4.29 per cases (rounded)

Therefore since we are making use of plantwide rate which means that same overhead cost of the amount of $4.29 per cases will be assigned to each of the two case .

2. Calculation to determine the total cost per case for the two products

Extra Fine Family Style

Direct materials + Direct Labor $ 10.00 $ 9.00

Add Overhead $4.29 $4.29

Manufacturing cost per case $ 14.29 $ 13.39

Therefore the the total cost per case for the two products will be:

Extra Fine $14.29

Family Style $13.29

3-A Calculation to determine the gross profit per case for each product.

Extra Fine Family Style

Selling price per case $ 19.00 $ 13.00

Less Manufacturing cost per case $14.29 $13.29

Gross profit (loss) per case $ 4.71. $ (0.29 )

Therefore the gross profit per case for each product will be ;

Extra Fine $4.71

Family Style $0.29

3-b. Based on the above Calculation What might the management conclude about the Family Style Salsa product line is that Family Style salsa are not yielding profit which may may inturn make make the company to stop the production of the product in a situation where either the cost are not reduced or where the price.