In: Accounting
Foamy Ltd. plans to produce a coffee-based drink called Alert.
It is anticipated that variable costs will amount to 40p per drink.
The company will produce Alert in a processing facility with a
capacity to produce 200,000 drinks a year. Fixed costs are
anticipated to be £100,000 per year. The company plans to supply to
retailers at a price of 95p per drink.
Required:
a. Calculate the break-even volume, at the expected price, to
retailers.
b. Calculate the break-even sales price to retailers if the factory
is used at full capacity.
Market research carried out by Foamy Ltd has demonstrated that
for sales at a price of £1.90 per drink demand from retailers would
be zero, and that demand will increase, on a straight-line basis,
by 20,000 drinks for every 10p (£0.10) fall in price.
Required:
c. Calculate the sales price at which the company’s profit will be
maximised, and the profit the company will make at that sales
price.
a. Break Even Volume = Fixed Cost/ Contribution per unit
Contribution= Sales Price - Variable Cost = 0.95-0.40 =0.55 £ per unit
Fixed Cost = 100,000 £
Break Even Volume = 100,000 /0.55 = 181818.18 units
b. calculate the break-even sales price to retailers if the factory is used at full capacity.
Step 1- Allocation of Fixed Cost to per unit
= Fixed Cost/ Number of units planning to sell
= 100,000/2,00,000 =0.5£ per unit
Step 2- Add Variable Cost Per unit to it
Which makes it 0.5+0.4 = 0.9£
Breakeven Price= £0.9 per unit
c.
Here we have maximum capacity of producing the units =200,000 units so we will have to check the profitability for each alternative as the contribution margin will change in each case as follows-
Units | Price | Variable Cost | Contibution per unit | Total Contribution Margin | Profit or Loss |
20000 | 1.9 | 0.4 | 1.5 | 30000 | -70000 |
40000 | 1.8 | 0.4 | 1.4 | 56000 | -44000 |
60000 | 1.7 | 0.4 | 1.3 | 78000 | -22000 |
80000 | 1.6 | 0.4 | 1.2 | 96000 | -4000 |
100000 | 1.5 | 0.4 | 1.1 | 110000 | 10000 |
120000 | 1.4 | 0.4 | 1 | 120000 | 20000 |
140000 | 1.3 | 0.4 | 0.9 | 126000 | 26000 |
160000 | 1.2 | 0.4 | 0.8 | 128000 | 28000 |
180000 | 1.1 | 0.4 | 0.7 | 126000 | 26000 |
200000 | 1 | 0.4 | 0.6 | 120000 | 20000 |
Therefore 160000 units to be produced and sold at £1.2 per unit.