Data was downloaded from one web site to receive the total number of Toyota vehicles sold within Canada during the five-year period. Due to limitations around sourcing the number of specific models, this data was created manually and calculated based on population research. The cost of repairs and MSRP per Model was also created manually, based on research of each model and their MSRP for the 5-years.
The limitations on the region included not having the data for different locations within each of the province’s Toyota dealerships. The data was obtained by calculating the aggregate of each province. The data collected could determine which province has the most car sales however it is unable to determine within each province which specific dealership sold the vehicles. To practise different techniques of analysing data, it is assumed that data for each province and territory comes in a text format of ModelYearRegin. Therefore, it was required to separate each part of the data that belonged to each category. The outcome was thirteen sheets demonstrating the number of cars sold by year and model.
Within the repair dataset assumptions were taken to categorise each repair type in a minor, major and extreme category. This decision was based on what the average person may consider to be the least up to most critical in safety or vehicle operation.
This report is taking assumptions that all new vehicles sold were at their posted MSRP price and sold within the year they were new. Profit is considered net profit after recall repair and maintenance costs. Additional costs such as the production materials, delivery and overhead were not removed from profit. Data collected for the vehicle costs in Canada were pulled from Toyota sites for each of the seven models, for the years 2016 to 2020 (inclusive) (Toyota, 2016-2020). Limitations for the MSRP included googling the posted MSRP value for each vehicle in Canada for each year.