Your case study has been inspired by the Grand Prix Formula 1 race event held annually in March
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 5th till 11th of August 2019.
Detailed instructions:
Create an Excel Workbook with 6 Worksheets (tabs):
Individual Registration
Total Sales per Ticket Type
Total Sales per Ticket Type per Country
The Race Event Budget
Budget Summary Report
Analysis and Recommendations
Hint
Accounting and Finance A budget analysis is mainly focused on a critical evaluation of the budgetary allocations that are made at the beginning of a financial year. It also seeks to track the expenditure that is undertaken based on those allocations so as to determine how the policies translate into the desired outcomes. ...
A budget analysis is mainly focused on a critical evaluation of the budgetary allocations that are made at the beginning of a financial year. It also seeks to track the expenditure that is undertaken based on those allocations so as to determine how the policies translate into the desired outcomes.