Subjects accounting

Break Even Margin

Step-by-step solutions with LaTeX - clean, fast, and student-friendly.

Search Solutions

Break Even Margin


1. **Problem Statement:** We are given an income statement for Safari Manufacturing Ltd. for the year ended 30 September 2024 and expected changes for the next year. We need to: i) Compute the break-even point (sales value) for the current year. ii) Compute the margin of safety (sales value) for the current year. iii) Determine the sales value required to achieve a profit of 3,000,000 next year after changes. iv) Prepare a summary operating statement showing the calculation for the profit target. 2. **Calculate Contribution Margin and Break-even Point for Current Year:** - Sales = 45,000,000 - Direct material = 9,500,000 - Direct labour = 8,100,000 - Variable production overheads = 6,300,000 - Variable selling & distribution = 3,600,000 - Fixed production overheads = 10,200,000 - Fixed selling & distribution = 2,400,000 - Fixed administration expenses = 2,900,000 - Net profit = 2,000,000 Variable costs = Direct material + Direct labour + Variable production overheads + Variable selling & distribution = 9,500,000 + 8,100,000 + 6,300,000 + 3,600,000 = 27,500,000 Contribution = Sales - Variable costs = 45,000,000 - 27,500,000 = 17,500,000 Contribution margin ratio = Contribution / Sales = 17,500,000 / 45,000,000 = 0.3889 Total fixed costs = Fixed production overheads + Fixed selling & distribution + Fixed administration expenses = 10,200,000 + 2,400,000 + 2,900,000 = 15,500,000 Break-even sales value = Fixed costs / Contribution margin ratio $$\text{Break-even sales} = \frac{15,500,000}{0.3889} = 39,826,530$$ 3. **Calculate Margin of Safety for Current Year:** Margin of safety = Actual sales - Break-even sales = 45,000,000 - 39,826,530 = 5,173,470 4. **Calculate Sales Value Required for Profit of 3,000,000 Next Year:** Adjust sales price and costs for next year: - New selling price = 45,000,000 * 1.05 = 47,250,000 - New material cost = 9,500,000 * 1.04 = 9,880,000 - New labour cost = 8,100,000 * 1.03 = 8,343,000 - New variable production overheads = 6,300,000 * 1.02 = 6,426,000 - New variable selling costs = 3,600,000 * 0.98 = 3,528,000 - Fixed production overheads = 10,200,000 * 1.05 = 10,710,000 - Fixed selling & distribution = 2,400,000 (unchanged) - Fixed administration expenses = 2,900,000 (unchanged) New variable costs = 9,880,000 + 8,343,000 + 6,426,000 + 3,528,000 = 28,177,000 Contribution margin ratio next year = (New sales - New variable costs) / New sales = (47,250,000 - 28,177,000) / 47,250,000 = 19,073,000 / 47,250,000 = 0.4037 Total fixed costs next year = 10,710,000 + 2,400,000 + 2,900,000 = 16,010,000 Required sales to achieve profit 3,000,000: $$\text{Required sales} = \frac{\text{Fixed costs} + \text{Target profit}}{\text{Contribution margin ratio}} = \frac{16,010,000 + 3,000,000}{0.4037} = \frac{19,010,000}{0.4037} = 47,086,000$$ 5. **Summary Operating Statement for Next Year at Target Sales:** - Sales = 47,086,000 - Variable costs = 47,086,000 * (1 - 0.4037) = 47,086,000 * 0.5963 = 28,076,000 - Contribution = 47,086,000 - 28,076,000 = 19,010,000 - Fixed costs = 16,010,000 - Profit = Contribution - Fixed costs = 19,010,000 - 16,010,000 = 3,000,000 **Final answers:** - Break-even sales value (current year) = 39,826,530 - Margin of safety (current year) = 5,173,470 - Required sales for 3,000,000 profit next year = 47,086,000