Problem
Preamble
Tupps Motors, which was established in year 2000, sells 5 brands of new passenger vehicles Holden, Toyota, Ford and Mitsubishi and Nissan which were the market leaders in 2000. As years passed the General Manager of Tupps Motors, Brian Tupps, noticed that brands such as Holden, Ford and Nissan are not selling as much as they used to. In 2018, Brian Tupps discusses his observation with his recent Business graduate son, Ben Tupps, and they both decided to collect Australia-wide sales data of the top 10 brands of passenger vehicles in 2018 to see how the market share of the different brands has changed. In 2020, the pandemic struck, and business was not in a good shape, but Brian managed to keep the business and his employees functioning with pandemic subsidies provided by the Federal government. With the closure of the production of Holden in Australia in 2021, Brian wanted Ben to analyse the Australia-wide post-pandemic sales data for 2022 and provide him with advice on the market share of the 10 brands of passenger vehicles.
Data
Data on the number of passenger vehicles sales for the top 10 brands of passenger vehicles in 2018, 2020 and 2022 are provided in the file Sales-1.xlsx. [Note that to make comparisons easier Ben collected data for the same top 10 brands of passenger vehicles. As Holden sales ceased in 2021, Ben has excluded Holden from the Top 10 passenger vehicles for this analysis.]
Analysis
I. Identify the type of data that Ben has collected for the various brands of passenger vehicles.
II. Comment on the movement in the TOTAL sales of the top 10 passenger vehicles in 2018, 2020 and 2022.
III. Use an appropriate chart to display the market share of the top 10 brands of passenger vehicles in 2018. Comment on the market leaders.
IV. In 2018, considering the market shares displayed in the chart in part (III), what would be Ben's advice to Brian about the top 5 brands of passenger vehicles based on the 2018 market share.
V. Would it be appropriate to make decisions based on the 2020 sales data?
VI. Use an appropriate chart to display the market share of the top 10 brands of passenger vehicles in 2022. Has the market share of the brands changed between 2018 and 2022. Comment on the top 5 brands that Ben should Brian to consider for his business. Would the advice be different between the two years and why?
VII. Using an appropriate chart, present the sales of the top 10 passenger vehicles sales in in Australia in 2018 and 2022. From what you observe from the chart, present a comparison of changes in sales by brand between 2018 and 2022.