In: Accounting
Pronghorn produces one single product, a small reading tablet,
and sells it at $100 per unit. Its current annual sales are
$200,000. Its annual fixed costs include factory rent, $38,000;
depreciation expense; equipment, $10,000; utilities, $18,000;
insurance, $8,000. Its variable costs include materials, $30 per
unit, and direct labour, $40 per unit. Pronghorn’s income tax rate
is 20%.
1.What is the contribution margin per unit?
2.What is the contribution margin ratio?
3.How many units must Pronghorn sell to break even?
4.If Pronghorn would like to earn a profit after tax of $11,000, what should the sales be? At this sales level, what is the degree of operating leverage? What is the margin of safety in unit?
5.If Pronghorn would like to earn a profit after tax that is 8% of sales, what should the sales be? How many units does Pronghorn need to increase from the current sales level?
* All working forms part of the answer
Requirement 1
| Sales price per unit | $100 | |
| Variable cost per unit: | ||
| Direct Material | $30 | |
| Direct labor | $40 | $70 |
| Contribution margin per unit | $30 |
Requirement 2
| A | Contribution margin per unit | $30 |
| B | Sales price per unit | $100 |
| C = A/B | Contribution margin ratio | 30% |
Requirement 3
| Fixed Expenses: | ||
| Factory Rent | $38,000 | |
| Depreciation expense | $10,000 | |
| Utilities | $18,000 | |
| Insurance expense | $8,000 | |
| A | Total Fixed expense | $74,000 |
| B | Contribution margin per unit | $30 |
| C = A/B | No. of units required to be sold to Break Even | 2,467 |
Requirement 4
| A | After Tax profits | $11,000 |
| B = A/80% | Hence, before tax profits = | $13,750 |
| C | Total Fixed expense | $74,000 |
| D = B+C | Total Contribution margin required | $87,750 |
| E | Contribution margin ratio | 30% |
| F = D/E | Sales should be | $292,500 |
| G = F x 30% | Contribution margin would be | $87,750 |
| H = G - C | Net Operating Income | $13,750 |
| I = G/H | Degree of Operating Leverage | 6.38 |
| J = F/$100 | Sales in Units | 2,925 |
| K | Break Even units, calculated above | 2,467 |
| L = J - K | Margin of Safety | 458 |
--Requirement 5
| Let sales be $'x' |
| Profit after tax tax required = 8% of Sales = 0.08x |
| Profit before tax = 0.08x/80% = 0.1x |
| Contribution margin = 30% of x = 0.3x |
| Fixed cost = 74000 |
| Contribution margin - Fixed Cost = Before tax profits |
| 0.3x - 74000 = 0.1x |
| 0.3x - 0.1x = 74000 |
| 0.2x = 74000 |
| x = 74000/0.2 |
| x = 370,000 |
|
Sales should be $ 370,000 = ANSWER This means 3700 units. while currently it sells 2000
units. |