Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
Company Analysis: Treforest Transport
Answered

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
  1. 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.

Licensed cars (000s)

Population (million)

GVA (£ million)

Belfast

114

0.4

10,633

  1. 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.  

  1. 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.

Car type

Sales price range in £

1. City Car

10,000 – 16,000

2. Hatchback

16,000 – 22,000

3. Saloon

30,000 – 36,000

4. Estates

28,000 – 34,000

5. SUVs

25,000 – 31,000

6. Sports

45,000 – 51,000


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)?

support
close