You must create a spreadsheet model for your allocated event. It must allow the team to ask 'what-if' questions. These will depend on what the event is but here are some examples:

• what if we use a different supplier
• what if we spend more on promotion
• what if we charge more
• what if we use a different venue

Produce your spreadsheet model. You need to think about:

• how you will show that the costs are reliable
• how you can reduce the likelihood of errors
• how you can prevent the model from being altered
• how you want the output presented
• how to make it easy for others to use

Ask other members of your team to try out your model. Make changes if necessary.

Save evidence of your spreadsheet model for your eportfolio. Make sure that the moderator can see both the values and the formulae. You must clearly show the sources you used to find cost information for your model.