Baljit provided the following information for the year ended 30 April 2013. $ Inventory 1 May 2012 14841 Inventory 30 April 2013 21159 Cost of goods sold 90 000 Administration expenses 4890 Selling expenses 7485 Capital employed 1 May 2012 101 250 Mark up 25% REQUIRED
- (a)(i)Calculate for the year ended 30 April 2013: Sales[2]
- (a)(ii)Calculate for the year ended 30 April 2013: Purchases[2]
- (a)(iii)Calculate for the year ended 30 April 2013: Profit for the year[2]
- (b)Calculate the following ratios. Comparative figures for the previous year are shown in the last column. Ratio | Workings | 30 April 2013 | 30 April 2012 ---|---|---|--- Gross profit margin (gross profit to sales) | | | 25% Net profit margin (net profit to sales) | | | 11% Rate of inventory turnover | | | 8 times / 45.6 days Return on capital employed (ROCE) | | | 12%[8]
- (c)Give two comments on the performance of Baljit’s business over the two years.[6]
- (d)Suggest three actions Baljit may take to improve her rate of inventory turnover.[6]
Mark scheme
Marking points from the official mark scheme (May/June 2013). The mark or mark type is shown in brackets.
- [2] Sales (Cost of sales $90 000 + 25%) = $112 500
- [2] Purchases $96318
- [1] Gross profit $22500
- [1] Administration expenses ($4890)
- [1] Selling expenses ($7485)
- [2] Profit for the year $10125 (2)/(1) of
- [1] Gross profit margin: $22500 (1) of ×100 / $112500 (1) of
- [1] Gross profit margin: 20%
- [1] Net profit margin: $10125 (1) of ×100 / $112500 (1) of
- [1] Net profit margin: 9%
- [1] Rate of inventory turnover: Cost of goods sold / Average inventory = $90000 (1) / $18000 (1)
- [1] Rate of inventory turnover: 5 times
- [1] Rate of inventory turnover: Average inventory ×365 / Cost of goods sold = $18000 (1) × 365 / $90000 (1)
- [1] Rate of inventory turnover: 73 days
- [1] Return on capital employed (ROCE): Net profit x 100 / Capital = $10125 (1) of ×100 / $101250 (1)
- [1] Return on capital employed (ROCE): 10%
- [1] Overall profitability was lower in 2013
- [1] Overall all the profitability ratios have fallen
- [2] Gross profit and net profit (margin) have both fallen
- [1] The gross profit margin has fallen in 2013
- [1] from 25% to 20%/or by 5%
- [1] because selling price has been decreased
- [1] or cost of sales has increased
- [max 3]
- [1] The net profit margin has fallen in 2013
- [1] from 11% to 9%/or by 2%
- [1] because the gross profit is lower
- [1] expenses are higher
- [max 3]
- [1] The return on capital employed has fallen in 2013
- [1] from 12% to 10%/or by 2%
- [1] because net profit is lower
- [1] capital employed is higher/taken a long term loan
- [max 3]
- [1] The rate of inventory turnover has decreased in 2013
- [1] from 8 times to 5 times/or by 3 times
- [1] or from 45.6 days to 73 days/or by 27.4 days
- [1] because they are selling the inventory more slowly
- [1] closing inventory has increased
- [max 3]
- [max 6]
- [2] Reduce inventory levels by reducing purchases
- [2] Give discounts to get rid of surplus stock
- [2] Promote sales by offering cash/trade discounts
- [2] Sales promotions/advertising to increase sales
- [2] Reduce selling price to sell more
- [2] Reduce mark up on cost of sales
- [2] Use a just-in-time stock control system
- [2] Find cheaper suppliers/buy in bulk to reduce the cost of sales
- [max 6]
Write your answer and get it marked
On Oracle Prep you can write or photograph your own answer and have it marked by AI against this mark scheme, with feedback on what you missed.
Sign up free →