DVD sales: Analysis of performance

Authors Avatar

Assignment for 4ECQ402-

Exploring Business Data;

        

INTRODUCTION

DVD Sales is a company selling DVD players inside the UK. It is a large company with many shops all around the country. The locations of its shops can be divided into three regions of the UK (North, South, East). The company has been selling three different types of DVD players & has been launching advertising campaigns for each of the types in the year 2002.

The aim of this part of the report (task 1) is to assess the performance of sales for the three different types of DVD players and analyse the affects of other factors that might have affected the sales. The performance of the company has been stored as a data in the PC and these data’s will be the source of information for this report. ‘Minitab’ application system will be used to generate findings and calculations.

The relevant source of information used in this report will be;

  • Regional Location of the individual outlets (North, South, East),
  • Gender of manager in individual shops,
  • The age of the manager in the individual shops,
  • Price increase of the products in individual outlets from the year 2000,
  • Average monthly advertising expenditure of individual outlet,
  • Average annual sales of individual outlet for individual products,
  • Total DVD player sales for individual outlet (Annually).

The second part of the report (task 2) involves presenting research on recent sales of DVD in the UK. Data and other relevant information for this task will be collected and presented using the EXEL program.

  1. TASK 1

  1. Distribution of the Total UK sales

One-way ANOVA: Total sales versus Region

                                   Individual 95% CIs For Mean

                                   Based on Pooled StDev

Level       N      Mean     StDev  --+---------+---------+---------+----

1          33    641.48     95.87        (------------*-----------)

2          39    630.74     91.36     (----------*-----------)

3          23    634.74     81.78   (--------------*--------------)

                                   --+---------+---------+---------+----

Pooled StDev =    90.79            600       625       650       675

(Level; 1=North, 2=South, 3=East)

The box plot & the statistics displays that the mean distributions of sales for the three regions (North-641.48, South-630.74, East-634.74) are very close to each other, but not the same. North region is doing the best in terms of sales and south is doing the worst; but there is a bigger variety (variance) in sales for shops in east than the other two regions. This indicates that in the east region some shops are doing really well while the others are have bad sales.

  1. Proportion of Total Sales in the three regions

Join now!

The total volume of sales made for each of the region has a very strong positive relationship to the number of shops there are in each region. North has 33 shops, south-39, east-23. The least number of shops are in the east UK and the most in the south UK.

  1. Gender of the managers affect on the Total sales

About a quarter of the managers of the stores are female. Their mean performance compared to that of the males is only better in the south, but they ...

This is a preview of the whole essay