ACCT6001: Analyzing Formula 1 Grand Prix Data - Case Study Report

This case study analyzes the financial data of a Formula 1 Grand Prix event, focusing on ticket sales and revenue generation. The student utilizes Excel to analyze various aspects, including different ticket types, sales per country, and overall budget. The analysis includes the creation of several worksheets to organize and summarize the data, such as an individual registration worksheet, total sales per ticket type, and total sales per country. The findings reveal that the 'PIT EXIT - TRACKSIDE INTERNATIONAL, 3-Day Pass' generates the most revenue, and the UK contributes the highest sales among countries. Based on the analysis, the student recommends increased advertising to attract a wider audience. The case study concludes with a bibliography citing relevant sources.

Running head: ACCOUNTING INFORMATION SYSTEM
Accounting Information System
Name of the Student:
Name of the University:
Author’s Note:

1ACCOUNTING INFORMATION SYSTEM
Table of Contents
1. Individual Registration Worksheet:.......................................................................................2
2. Total Sales per Ticket Type Worksheet:................................................................................2
3. Total Sales per Ticket Type per Country Worksheet:............................................................3
4. The Race Event Budget Worksheet:......................................................................................4
5. Budget Summary Report Worksheet:....................................................................................4
6. Analysis and Recommendations Worksheet:.........................................................................5
Bibliography:..............................................................................................................................6

2ACCOUNTING INFORMATION SYSTEM
1. Individual Registration Worksheet:
2. Total Sales per Ticket Type Worksheet:

3ACCOUNTING INFORMATION SYSTEM
3. Total Sales per Ticket Type per Country Worksheet:
CORPORATE PLATFORM TURN 15, 3-Day Pass
CHICANE PAVILION LOWER, Friday
PIT EXIT - TRACKSIDE INTERNATIONAL, 3Day Pass
THE LOUNGE, 3Day Pass
THE LOUNGE, Saturday, Sunday
FANGIO LOUNGE, 3Day pass
$-
$2,000
$4,000
$6,000
$8,000
$10,000
$12,000
$14,000
$16,000
Sales per Ticket Type per Country
UK
USA
China
Russia
Australia

4ACCOUNTING INFORMATION SYSTEM
4. The Race Event Budget Worksheet:
5. Budget Summary Report Worksheet:

5ACCOUNTING INFORMATION SYSTEM
6. Analysis and Recommendations Worksheet:
It can be observed from the above analysis that the ticket type PIT EXIT -
TRACKSIDE INTERNATIONAL, 3-Day Pass is generating more revenue than the other
ticket types. In terms of country wise sales, the highest revenue is generated from the UK for
a total amount of $17,165. The comparative analysis of total sales country wise can be shown
in the following chart.
Australia Russia China USA UK
$-
$2,000.00
$4,000.00
$6,000.00
$8,000.00
$10,000.00
$12,000.00
$14,000.00
$16,000.00
$18,000.00
Sales per Country
Total
It can be recommended that, they need to spend more on advertising and build such
advertising strategies which will attract more and more domestic as well as overseas
audiences.

6ACCOUNTING INFORMATION SYSTEM
Bibliography:
Collier, P. M. (2015). Accounting for managers: Interpreting accounting information for
decision making. John Wiley & Sons.
Tickets Search | Formula 1® Australian Grand Prix. (2019). Grandprix.com.au. Retrieved 7
August 2019, from https://www.grandprix.com.au/tickets/search