This lesson looks at how changes in costs and price affect the break-even point. Using Excel to teach through practical activity, by the end of the lesson, students will be able to understand the affect of changes on the break-even point.
Excel Worksheet (with teacher solution)
Student worksheet
Example evidence of tasks in Microsoft Word.
Visual representation, calculations and formula:
Break-even Point:
a) What happens if the variable costs increase/decrease?
b) what happens if the fixed costs increase/decrease?
c) What happens if the selling price increases/decreases?
Excel Worksheet (with teacher solution)
Student worksheet
Example evidence of tasks in Microsoft Word.
Visual representation, calculations and formula:
Break-even Point:
a) What happens if the variable costs increase/decrease?
b) what happens if the fixed costs increase/decrease?
c) What happens if the selling price increases/decreases?
Get this resource as part of a bundle and save up to 54%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£2.00