For this activity it is recommended that you utilise Microsoft Excel to prepare an event budget.
Click here to download the activity sheet (PDF format)
You will need to identify and separate Fixed Costs and Variable Costs. Click here to read more.
If you have clicked on the link above you will have read that the "Break-Event Point" can be calculated using a formula. It is also possible to work out the "Break-Event Point" by plotting Fixed Costs and Variable Costs on a graph. Click here to download and example (Excel Worksheet)
The break-even point I calculated for the first part of the question is 367. What do you get?
The break-even point changes to 347 for the second part of the question. See if you agree.