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

• what if we use a different supplier
• what if we spend more on promotion
• what if we have too many or too few customers

Produce your spreadsheet model. You need to think about:

• 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

Test your model using test data and a calculator.

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

Save evidence of your spreadsheet model for your eportfolio. Make sure that the moderator can see both the values and the formulae.

Make sure you save details about the costs you have used in your model. You will need to include this information in your presentation to the team.