Breeden Security Inc. A Case Solution

2. What’s our break-even volume assuming our mix stays the same—two RC 1s for each RC 2?

Break-even point is the point where there are zero profit or sales equal’s costs. In this case, we assume the same thing as above, that is, the manufacturing costs per unit are $ 16 for RC 1 and $ 19 for RC 2. Also assuming that RC 2’s are half that of RC 1, that is RC2= ½ RC1. The selling and admin expenses amount to $ 480,000 for the year. This gives us the break-even sales of 80,000 units of RC 1 and 40,000 units of RC 2 per year or 6667 units of RC1 and 3333 units of RC2 per month.

Calculation 

20 RC1 + 23RC2 = (40,000 x 12) + 16RC1 +19RC2

Substituting RC2 with RC1/2,

31.5RC1 = 480,000 + 25.5RC1

RC1= 80,000 units per annum

RC2= 40,000 units per annum.

3. What’s our manufacturing cost per unit if we produce only 8,000 RC1 units and 4,000 RC2 units per month?

For 10,000 units of RC 1, the parts cost $ 5.5 per unit, and direct labor costs $ 3.5 per unit. For the 5,000 units of RC 2, the parts cost $ 6.4 per unit, and direct labor costs $ 4.2 per unit. According to the budget, only parts, direct labor and supplies are variable costs and vary per unit. Supplies are a portion of manufacturing over head and can be divided among RC 1 and RC 2 based on their unit ratios. For 10,000 units assuming that 62.5% of the total supplies are attributed for RC 1, $ 13,125 comes as the amount of supplies for RC 1. The rest of $7,875 can be attributed to RC 2. This brings per unit cost of supplies to $ 1.3125 per unit for RC 1 and $ 1.575 per unit for RC 2. The rest of the over head expenses amounting to $ 91,000 are fixed.

Assuming that the fixed expenses of $ 91,000 in manufacturing over head are distributed in the same ratio as supplies, $ 56,875 is allocated to the production of RC 1. The difference amounting to $ 34,125 is attributed to the manufacturing over heads of RC 2. Dividing 10,000 units by the allocated fixed costs, we get a per unit cost of $ 5.6875 for RC 1 which brings the total of manufacturing over head cost per unit of RC 1 to $ 7 per unit. For RC 2 when the initial 5000 units are divided by the fixed manufacturing over heads, we get per unit cost to $ 6.825. The total per unit cost of manufacturing over heads is $ 8.4 per unit of RC 2. This suggests that even after reallocating the total manufacturing costs per unit, we still get the same manufacturing cost per unit for both products that is $ 16 per unit for RC 1 and $ 19 per unit for RC 2. Also, since the product mix does not change and still remains 2 RC 1’s for each RC 2, the proportion of expenses allocated to each product would not change. The only figure that would change be the total costs and revenues which will subsequently change the monthly profits.

4. What’s our profit if each month we only sell 8,000 RC1s and 4,000 RC2s, but we produce 10,000 RC1s and 5,000 RC2s, assuming the unsold units go into finished goods inventory?

If the production remains the same, the total expenses would remain the same for both products, that is, $ 160,000 per month for RC 1 and $ 95,000 per month for RC 2. Selling and administrative expenses stay the same at $ 40,000. The only figure that would take a hit would be the sales revenue.

RC 1 is sold at $ 20 per unit while RC 2 is sold at $ 23 per unit. If the company sells 8000 units of RC 1 per month and 4,000 units of RC 2. The sales revenue for RC 1 would be $ 160,000 and that of RC 2 would be $92,000. The total combined sales revenue is $ 252,000. Deducting the total expenses of $ 295,000(160,000+95,000+40,000), we get a net loss per month of 43,000.