We could present our findings as they are. The general conclusion would be that we could make a modest profit if we book the Cabbage Farmers, and it doesn't make a lot of difference which venue we go to. However, we have set up a mathematical model for seeing the effect of changes, which we can use to change different criteria and see what results occur. Suppose we thought we could get away with charging £15 for the tickets. What effect would that have on the conclusions? Could we afford the fabled Raging Parrots now? Also, we could go back and recalculate the advertising costs and expected ticket sales by increasing our advertising spend per person. The best way to do this would be to use a spreadsheet. Set out the information in a table format. Enter formulae to do the calculations. Draw your charts from the outcomes. Then change the input criteria (like ticket price or advertising spend) and draw more charts. In this way you can build up a varied proposal for your company. It can show the outcome in a number of key cases. You can show how we could make a profit with different bands. You can extend and improve the work by improving the assumptions. For example, our advertising graph doesn't take account of the popularity of the bands. We would expect the Raging Parrots to sell more tickets than the Cabbage Farmers at whatever price! Try to include modifications that take account of issues such as this. That is the end of this module on organising a gig.
You have covered the following curriculum objectives: - Plan an activity by breaking it down into a series of tasks (all Level 3)
- Carry out multi-stage calculations
- Work out proportional change
- Rearrange and use formulae, equations and expressions
- Use checking procedures to identify errors in methods and results
| 
