What will it cost? How are you going to pay for it? Do you want to make a profit?
You must produce a spreadsheet model to find answers to 'what if' questions. You need to calculate costs, decide how much to charge, how many items you need to sell, etc.
Your model will be used by the team to help decide which enterprise idea to adopt. It is vital that it produces accurate information and is easy to use.
Produce your spreadsheet model. You need to think about:
Test your model to make sure that it is accurate and that it is possible to find answers to the 'what if' questions you need to ask.
Pass the spreadsheet to your team and ask them for comments. Make changes where necessary. You will need to offer other team members constructive feedback in return.
Save evidence of your spreadsheet model in both value and formulae views. Make sure that it is in an acceptable file format. Do NOT include the spreadsheet itself.
Update your project diary, including notes about comments you received on your model and feedback you offered to other team members.
Print this page