CA Activity 2 - Model/Recommendations

BA2 analyse data though the use of your product research and provide suitable recommendations based on your findings


The model (spreadsheet) and recommendations section of the CA run together and rely on each other.


For the model you must have:

• Completed Expenditure/Income/Summary sheets
• Used vlookup or other advanced functions to link your sheets together
• Incorporate methods to make your model easier for the user to use (spinners)
• Created charts to represent each of your venues at each of your ticket prices
• Ensure that % of activities is consistent throughout
• You should have 9 charts for this section
• Created a tenth chart comparing overall profit/loss for each venue/ticket price

For your recommendations you should have:

• The logo and strapline
• Screenshots of your tables/charts to support your findings
• Answered the 3 'What if?' questions (possibly as 3 slides at the end of the presentation
• If my audience is only prepared to pay a certain ticket price, what must I sacrifice from my festival?
• If I limit the audience size, how will this affect my income?
• If my ticket price becomes too high should I use a different venue?

NOTES:

• Use speaker notes to expand/comment on what you have found. DO NOT use a lot of text on your slides
• Your audience for the model and recommendations is the people helping you organise the festival NOT the general public. You should still include you logo/colour scheme throughout.

CLASS WORK DEADLINE FOR MODEL/RECOMMENDATIONS 12/09/14