The spreadsheet is a powerful tool that has become entrenched in business processes worldwide. A working knowledge of Excel is a crucial skill for accountants.

accounting

Description

Context:

 The spreadsheet is a powerful tool that has become entrenched in business processes worldwide. A working knowledge of Excel is a crucial skill for accountants. This assessment aims to assess the student’s ability to create spreadsheets. Students will be using raw data and summarising them in a user friendly format to aid decision making.


Submission Requirement: 

Students need to submit their Excel Workbook which includes the analysis and recommendation sheet. The file should be provided in the following format:


Background 

Your case study has been inspired by the Grand Prix Formula 1 race event held annually in March in Melbourne as the first race of each F1 season. It is a three day event and thousands of local and international tourists attend the event each year. 


Victorian Government funds the event. You will conduct an analysis of hypothetical budgeted and actual data to prove your Excel skills. You will work on The 2020 Race Event budget and analyse weekly ticket sales for the 2020 Australian Grand Prix Event during the period from 5 th till 11th of August 2019. 




Related Questions in accounting category