pls help me for this assessment
2.1 Analyse performance data from all areas of the business
In this task, you will use the ‘PoS Data from Stores’ time series data.
R 1. calculate the performance of all stores in terms of total revenue
R 2. prepare a table that summarises the performance of each store by year [2010-2015] inclusive:
·      must be in a cross-tabular format
·      consolidate the quarterly figures by year
·      show the grand totals of each store by year ([2010-2015] inclusive)
·      show the grand totals of all stores by year ([2010-2015] inclusive)
·      list the stores from the highest performing to the lowest
R 3. plot the performance trends:
·      chart ‘Top 11 – highest revenue generating’ stores by year
·      chart ‘Bottom 11 – lowest revenue generating’ stores by year
·      your visualisations must conform to the Reporting Standards
R 4. analyse these performance trends:
·      identify the three stores that generate the highest revenue
·      identify the three stores that generate the lowest revenue
·      identify the three stores with the highest overall jump
·      identify the three stores with the highest overall slump
·      compare the performance of the best and worst performing stores
R 5. write a summary based on your analyses:
·      draw insight on the success of marketing activities
·      suggest three strategies that A & A Coffee should consider to improve overall performance
·      explain how each activity would be helpful to generate more leads
R 6. word count is approximately 400 words in total.



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *