Company Analysis: Treforest Transport

You are required to use the appropriate module concepts and techniques to complete the given task and analyse the data provided on Blackboard.

Treforest Transport has a number of offices across Great Britain and Europe, selling a wide range of passenger cars. The management have consulted you to write an individual report summarising the company’s performance and recommending changes using evidence-based decision-making methods. Your report should address the following 4 issues and also present any further analysis you wish to present - focusing on your chosen degree pathway (Business, Human resource, Logistics, procurement and supply chain).

1. The company is thinking of expanding its business to Northern Ireland, but first they would like examine their current customer base and sales figure. Analyse their monthly sales and customer data, and report the results to provide the following information;

• Customers and their preferred car types
• Their travelling patterns based on average traveling distance and preferred car types

2. The company would like to see if their annual sales figure (Car Sales per year) has any relationship with the regional data – the number of licenced cars registered in the region (Licensed cars), the number of people living in the region (Population), and Gross Value Added (the value of goods and services produced in the area – GVA in £million). Using the information available, the company would like to guess what might be their car sales if they open an office in Belfast. Belfast data is below.

Please open the worksheet, GB Market, and examine the relationship between Car Sales and other three variables. Using the variable that has a strongest correlation with Car Sales, predict the future sales figure in Belfast.

3. Recently market research was undertaken in Belfast, their data analysis and key findings are summarised below.

• Majority of Hatchbacks customers are between 30 and 49 years old.
• Women preferred buying City Cars compared to Men
• Among people who earn more than £50k, the most preferred car type is Saloon.
• People who own Sports or SUVs tend to be single.

Please analyse your office data from the worksheet, Cardiff Sales, and compare your findings with the ones for Belfast.  

4. The following table shows the price range of the cars in the company. Using the average price of each car type and data from the Cardiff Salesworksheet, first find your monthly sales revenue.

The findings from the HQ based on all regional offices show that average monthly sales revenue is £5.1 million with £1.8 million standard deviation. Using this information and your monthly sales revenue you calculated above, how well do you think your branch (Cardiff office) is doing compared to other regional offices?

Based on the findings, the HQ asked you to increase the number of car sales. You are planning to organise a sales event, targeting 50 new potential customers. If you want to sell at least 10 more cars (10 or more), which car type should you aim to promote the most (= higher chance of selling the type of car)?