P6- Select information to support a business decision-making process Report 1

Report 1

Introduction

In this report I am going to explain my findings and data I got from the car insurance spreadsheet which was about the different car models that sold in 2012 and 2013. The type of data in the spreadsheet is mostly figures which shows overall profits from the make of the car and there is also data the market share of the car and whether it has had an impact/ change on the market. The data is presented is separated in two different tables one of which showing the month for the sales and this is the one I am going to be using mostly. Hopefully if I extract good information I will be able to make graphs and recommendations from these graphs which the managers can use for further profit for the business.

Data

With all the data I collected from the spreadsheet I had to make sure a couple of things which was the information’s validity, accuracy, relevance and currency. Not knowing these things could result into me getting the wrong information and redundant data.

Validity – First I had to verify the information for its validity and making sure it was the correct for my purpose. I already knew the source where the data has come from SMMT because there was a logo on the spreadsheet so to validate this I visited there webpage which shown information about motor vehicles and how this organisation provides data about this.

Accuracy – The information seems to be accurate as there is no odd patterns or spikes in the data, for example some of the registration numbers between both of the years seem to be similar so the information must be accurate.

Relevance – All the data in spreadsheet was relevant to what I needed for because I was asked to analyse data for the business linked with Motor vehicles and the spreadsheet shown different car models along with the number of registrations and market shares, this is just what I needed to get important information from th

Currency- The information has not been updated because it is from the past, the data shows information from 2013 and 2012 which I can still analyse and get important facts but it is not the latest information to something like this current year 2015. Also even though it has 4 months’ worth of information it doesn’t show every month which means it was not regularly updated.

Investigation

Through the investigation process I decided to work out different values from the data to give the company an estimate of figures such as what car was the most popular sale for both years, which was the worst selling car for both years and the total sales for both years. I think all of this is important information that the business can use.

From this first spreadsheet I decided first see which is the bestselling car for this company  so I complied this chart which is showing the best Selling Cars for 2012 and 2013 and further indicating at how much registrations the top cars get. As you can see each bar represents both of the years 2012 and 2013 and from this chart it looks like 2013 was the better year as there more registrations of the highest selling Car. This leads onto the highest selling car which I found out to be Ford for both years and all the months this data was recorded at.

This is the second chart I complied but this time showing the worst selling cars for 2012 and 2013. As you can see on the side the legend shows both years however there are not many bars this is because these cars got 0 registrations however in April of 2013 you can see that the Saab got 2 registrations. 2013 was not the same year as 2012 because there were different cars for example the Saab that was very common for not selling in 2013 didn’t even appear once in 2012.

This is the final chart I created from the data I was given and I decided to do a more broad overview seeing the total number of car sales for both years 2012 and 2013. From this graph you can see that overall there were more sales in 2013 than 2012 and this is for every month not just 1 but the different was not that big like there was not big jumps between the bars. Obviously if there were more registrations (Sales) it was probably because the population was rising slowly this means more people will need to buy a car.

Recommendations/Conclusion

Based on the three charts/ graphs I managed to create from the data I have some recommendations that might be useful for the business.

From the first chart which is the best selling cars for both years I would advise for the business to stock and order more of these as more people seem to be buying and registering more of the vehicles on the road. From the data I pointed out that Ford was the bestselling vehicle so anything within that range will sell well. Even though I only have data from the past from what I can predict is that this will continue to grow and increase the number of Ford sales thus leading to more profit for the business.

Another recommendation I would make from the second chart which shows the worst selling/ registering cars for both years is for the business not to stock these cars which are Saab, Dacia and Proton. It probably costs the business a lot of money for them to import and stock those cars so it they didn’t order them in the first place they would avoid this hassle and maybe not waste as much money.

In conclusion the amount of car sales and registrations are going up as you can see by the chart, even though the difference is very minor as long as the business continues to carry on stocking the top few cars and not stocking the very few selling cars they can make a lot of money. However one thing to note is the business will have to carry on monitoring data like this because one year might not be the same as the others and things can change very quickly like the bestselling car, you have witnessed this with the worst selling car.