In: Finance
Warrington LTD makes and sells one product. Unit costs for direct materials and direct labor are $24 and $36. In March, 20K units were produced, and total overhead was $214K. In April, 26K units were produced, and total overhead was $259K. The selling price of the unit is $100.
1. Compute the total fixed overhead of the company
2. Compute the contribution margin ratio
3. Compute the company's break-even point in sales dollars
4. Compute the number of units must be sold to have net income of $122K
1. | ||
Total overhead cost | Units | |
High level of activity | 259000 | 26000 |
(-) Low level of activity | 214000 | 20000 |
Difference | 45000 | 6000 |
Variable overhead per unit = Difference in total overhead cost / Difference in units = 45000 / 6000 | 7.5 | per unit |
Now let us calculate total fixed overhead from the data of high level of activity. | ||
Total overhead cost = Total fixed overhead + ( Units * Variable overhead per unit ) | ||
259000 = Total fixed overhead + ( 26000 * 7.5 ) | ||
259000 = Total fixed overhead + 195000 | ||
Total fixed overhead cost = 259000 - 195000 | 64000 |
2. | |
Direct materials per unit | 26 |
Direct labor per unit | 36 |
Variable overhead per unit | 7.5 |
Total variable cost per unit | 69.5 |
Contribution margin per unit = Selling price per unit - Total variable cost per unit = 100 - 69.5 | 30.5 |
Contribution margin ratio = Contribution margin per unit / Selling price per unit = 30.5 / 100 | 30.50% |
3. | ||
Break-even point in sales dollars = Fixed costs / Contribution margin ratio = 64000 / 30.5% | 209836 | |
4. | ||
Number of units to be sold = ( Fixed costs + Net income ) / Contribution margin per unit = ( 64000 + 122000 ) / 30.5 | 6098 | units |