Budgeting Exercise 3: Break- Even Analysis
 |
 |
This exercise comprises six (6) different event scenarios in which your task is to calculate a Break-Even Point for some type of event. The scenarios increase in degrees of difficulty and pose problems such as working out how many people are needed, or what price should be charged, or which venue will be more profitable, etc.
You are supplied with ready-to-go Excel worksheets for each scenario to make your task easier. The activity sheet provides you with instructions on how to find solutions to these scenarios and the Excel Worksheet is colour coded to assist you enter data.
This series of six(6) break-even point problems will take 15 minutes or less to complete.
Downloads for this exercise
Activity sheet for Budgeting Exercise 3 - Break-Even Point Analysis
Excel workbook for Budgeting Exercise 3 - Break-Even Point Analysis
The Excel workbook has been saved in the older 1997-2003 version of Excel (i.e. compatibility mode). If you want to save this file with your workings, then choose "Save As Type" Excel Workbook (*.xlsx).