• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  • Level: GCSE
  • Subject: Maths
  • Word count: 1839

Compile a report which will look at, and assess the performance of sales generated by the company DVD Sales

Extracts from this document...

Introduction

TUFAUL HAQUE                W0309417

1.0 INTRODUCTION

Nearly every movie produced today is available on DVD, and many older movies are being moved to the DVD format. Often, a movie comes out on DVD before it comes out on video tape, because the manufacturing and distribution costs for DVDs are so much lower.By bringing outstanding picture and sound to our favorite films, the DVD format is doing for movies exactly what CDs did for music.

DVD Sales is a large company selling DVD players. It has many shops throughout the United Kingdom (UK). Most of the shops are located in the regions; North, South and East of the UK. DVD Sales have concentrated advertising in 2002 for the three types of players they predominately sell (Type 1, 2 and 3).

By order of the managing directors, I have been instructed to compile a report which will look at, and assess the performance of sales generated by the company. This report is based on information from a random sample of 95 shops in the North, South and East of England.

2.0 METHODOLOGY

The information provided was analysed through the use of the Minitab 14, by creating graphs, charts and descriptive statistics. These features were used to look at and analyse the data and other factors.

3.0 STATISTICAL ANALYSIS

This report will look at, and analyse the following points:

  • The overall distribution of Total DVD sales in the UK.
  • The proportion of Totals Sales in the three regions?
  • Does the gender of the manager affect sales in the regions?
  • Which type of DVD is sold the most by female compared to male managers in the South of England.
  • The relationship between Advertising and Total sales.
  • The effect of price increases on Total Sales.
  • Another variable such as managers’ age to see if this affects sales.
...read more.

Middle

             Male    647.8    469.0  595.3   655.0  722.5    764.0

Results for Region = South

Variable     Gender   Mean  Minimum     Q1  Median     Q3  Maximum

Total sales  Female  637.6    493.0  563.0   655.0  728.0    771.0

             Male    629.3    449.0  543.0   636.5  714.3    768.0

Figure 3 looks at how the gender of the manager affects sales in each region. In the east region, male managers generated greater sales than their female counterparts with males generating average total sales of £650,500 compared to £590,000 by females. The maximum total sales generated by male managers (749,000) was also greater than that of the females (£734,000).

Male managers also had higher average total sales in the north (£647,800) although the highest total sales generated in the north region was by a female manager (£780,000), with 25% of females generating total sales above £761,000 compared to £722,000 by the males.

The average total sales for females in the south region was greater than that of the males, with females averaging total sales of £637,600, and males averaging £629,300. overall performance by females in this region was better than that of the males, with 25% of females generating sales of up to £563,000 compared to £543,000 by the males. 50% of females generated sales of up to £655,000 whilst 50% of the males managed to generate sales of up to £636,500 and 25% generated more than £714,300 compared to £728,000 by the females.

3.4 Sales of types of DVD players by gender in the south region

Figure 4.

image03.png

Descriptive Statistics: Type 1 (£000s), Type 2 (£000s), Type 3 (£000s)

Variable        Gender    Mean  

Type 1 (£000s)  Female   115.4    

                Male     110.00    

Type 2 (£000s)  Female   216.00  

                Male     215.06  

Type 3 (£000s)  Female   306.1    

                Male     304.19  

Figure 4 examines which type of DVD player is sold most by female managers compared to male managers in the south region.

...read more.

Conclusion

6.0 TASK 2

Since its launch in 1998, DVD has taken just four years to become the dominant format for video in the UK. From a small 5% share of the market for video by value in 1999, DVD captured 58% of the market in 2002. Market values reflect the fact that DVDs are more expensive than VHS videos, but also bears testimony to the fact that the video industry has been successful in managing format transition. VHS continues to pay an important complementary role to DVD, but robust marketing of the DVD by rights owners, retailers and industry associations has brought phenomenal success to the market.

Source: BVA/Rental Monitor/Mintel

 Figure 1.

image07.png

Correlations: DVD Sales (£m), Video Sales (£m)

Pearson correlation of DVD Sales (£m) and Video Sales (£m) = -0.963

P-Value = 0.008

Figure 1 shows that as DVD sales have been increasing, video sales have been decreasing. The r value is also closer to –1 which shows a negative correlation i.e. as DVD sales go up, video sales go down. This shows that as the sales of DVD’s has been increasing, this has created a decline in the sales of videos, as more and more people are buying DVD players. The decrease of DVD player prices has had a major impact on these sales, because when DVD players were first released, they were very highly priced. As the prices decreased, people started to buy more and more DVD players, this in turn has also increased the sales foe DVD’s.

ASSIGNMENT FOR EXPLORING BUSINESS DATA

4ECQ402

...read more.

This student written piece of work is one of many that can be found in our GCSE T-Total section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE T-Total essays

  1. To prove that out of town shopping is becoming increasingly popular with shoppers, and ...

    Sex: The main gender of people questioned were females making up 64% of the total. This may have been because during the day more females are shopping because they may not be working, as I predicted. 3) Area: Caldmore (12%), Palfrey (16%)

  2. Urban Settlements have much greater accessibility than rural settlements. Is this so?

    None needed, maybe a reconsideration of the places where we performed the counts. Bus Frequency I rang the bus company, and they sent me timetables. Before I could do this, I had to note which buses ran through the villages, and who to ring.

  1. I am going to investigate how changing the number of tiles at the centre ...

    Table 2 Pattern: N 1 2 3 4 5 Total Tiles: T 17 33 53 75 105 +16 +20 +24 +28 +4 +4 +4 Table two shows the pattern number and total amount of tiles in that particular pattern. There is no constant first difference until the second difference (which is constant).

  2. Maths Statistics on premiership football.

    This is why their mean score will either be over or under estimated in the table, than teams that have finished in the top ten seven seasons consecutively. For example Aston Villa had mean scores of 56.35, the score is obviously greater than Ipswich Town, who only finished once in the top ten, with a mean score of 66.

  1. For this task we were required to create a model that can be used ...

    Similar to the split rate model, a split value is needed which determines the value at which the pricing will change. Also, similar to the split rate model, the price after the split value is usually less than before it.

  2. Exploring Business Data.

    The forecast is only based on past trends. The forecast cannot be 100% accurate. Certain unexpected events would certainly affect the total number passengers using UK airports.

  1. Pay Role Model.

    The wage bill will increase dramatically. Without formula With Formula My predictions were correct because the overtime hours increase because the total wage bill increased a lot. So I was correct.

  2. ICT system analysis and modelling.

    It had customer details, financial details and hire details put in aswell. One of the formulas used is shown below; Hire Data Date Hired 13/01/2003 Insurance Costs 10 Price Per Mile �0.07 V.A.T 17.50% Rental Cost 25 Total Days Taken 14 Mileage Cost 70 Total Insurance Costs 140 Total Rental Costs 350 Sub Total 420 Total VAT 73.50 Total inc.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work