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

Authors Avatar

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.

3.1 Overall distribution of total sales in the UK

Figure 1.

Descriptive Statistics: Total sales

Variable      N  N*    Mean  SE Mean  StDev  Minimum      Q1  Median      Q3

Total sales  95   0  635.44     9.23  89.95   449.00  559.00  641.00  721.00

Variable     Maximum

Total sales   780.00

Figure 1 shows the overall distribution of sales in the uk. The average of total sales generated by the outlets is £635,440. The lowest total sales generated by an outlet is £449,000. up to 25% of the shops generated total sales of £559,000, whilst 50% generated total sales of up to £641,000. 25% of the outlets generated sales above £721,000 and the highest total sales generated by an outlet was £780,000.

Join now!

3.2 Proportion of total sales by region

Figure 2.

Region  Count  Percent      

East      23    24.21

North     33    34.74

South     39    41.05

N=        95

Figure 2 looks at the proportion of total sales generated by region. From the pie chart, we can see that the south region is leading with the highest total sales of  £24,599,000, which is approximately 41% of the total sales in the uk. The north ...

This is a preview of the whole essay