Answer:
See explanation
Explanation:
We first calculate weighted avg total break even point.
The formula or this is,
Total Break even = Total fixed costs / Weighted avg contribution
Weighted avg contribution = (Contribution of A12 * Weight of A12) + (Contribution of B22 * Weight of B22) + (Contribution of C124 * Weight of C124)
Contribution/ Product =
A12 = 61 - 43 = $18
B22 = 108 - 78 = $30
C124 = 413 - 316 = $97
Thus,
Weighted avg Contribution = (18*0.56) + (30*0.27) + (97*0.17) = $34.67
Total Break even = 249624/ 34.67 = 10085 units in total
Simply multiply total break even units with each products weight to calculate qty for each product to b produced.
A12 = 10085*0.56 = 5647.6 units
B22 = 10085*0.27 = 2722.94 units
C124 = 10085*0.17 = 1714.45 units
as per the sales mix.
We can also calculate how many units of each individual product are required for break even as,
A12 = 249624/18 = 13868 units
B22 = 249624/30 = 8320.8 units
C124 = 249624/97 = 2573.44 units
Hope that helps.