Break Even Simulator - Spreadsheet

Here’s a free graphical, interactive Excel file designed to teach AS students how the key concepts of contribution and break even interact.

A useful activity for a lesson in the ICT suite, a consolidation lesson and an excellent resource for visual learners. Depending on the difficulty of the questions set by the teacher, this activity coudl be used before or at the end of the substantive teaching. Teachers can produce their own questions to best maximise the resource for their learners.

Note: Macro’s in Excel will need to be enabled in order to reset the data to default (in options).

Download breakeven spreadsheet

Pandanomics - Can Edinburgh Zoo Get a Return on its Cuddly Investment? [7 Dec 2011]
Sing Along Revision - The Break Even Song [4 Dec 2011]
Cut price cup cake deal goes wrong…... [22 Nov 2011]
Revision Quiz - Breakeven Basics [15 Oct 2011]
Revision exercise - Chantelle’s Jigsaws [1 Oct 2011]
The breakeven simulator [1 Oct 2011]
Messy Contributions…. recipe for success? [29 Sep 2011]
Skype CEO on Aims, Growth, Risks and Motivation [4 Sep 2011]
Spotify - Five Years to Break-even [28 Aug 2011]
Where there’s muck there’s brass [6 Jul 2011]
Cash flow crisis at Saab: what went wrong? [23 Jun 2011]
Retrenchment in action - Comet turns off the retail lights [12 May 2011]
Dark days for the UK nightclub market [21 Jun 2010]
Revision Quiz - Using Breakeven Analysis in Decision-making [5 Apr 2010]
Revision Presentation - Cost Basics [30 Dec 2009]
Bottom Line - Keeping Overheads Low [28 Dec 2009]
More trouble in the skies [27 Aug 2009]
From crisps to vodka - what else can you make from potatoes? [31 May 2009]
Why businesses fail - an interview with Pepita Diamand [24 May 2009]
Ansoff helps with the school lunches [11 May 2009]
Celebrity chef had the recipe wrong after all [5 Apr 2009]
Q&A - What are fixed costs? [1 Mar 2009]
Breakeven exercise - cosmetic surgery while you wait [23 Sep 2008]
Cutting capacity to weather the housing slump [25 Aug 2008]
Not enough customers to break the daily grind at Beanscene [14 Aug 2008]
Pontins gains from the credit crunch as tourists stay home [21 Jul 2008]
A good example of a small business that just couldn’t break-even [14 Jul 2008]
The business of farm-produced ice cream [1 Apr 2008]
Local councils may takeover struggling post offices [8 Mar 2008]
Times up for Asda’s 4 year George Trial [5 Mar 2008]
Pest controller sees profits tumble [28 Feb 2008]

BUSINESS TEACHER RESOURCE NEWSLETTER
Get first news of business teaching resources, ideas and other materials from tutor2u. Over 9,400 business teachers from the UK and around the world receive our regular teacher email newsletters. Sign up for free here!