Eastern Mountain Sport’s Sales Analysis

Running Head: EASTERN MOUNTAIN SPORT’S SALES ANALYSIS
1
Eastern Mountain Sport’s Sales Analysis
Student’s Name:
University :

Running Head: EASTERN MOUNTAIN SPORT’S SALES ANALYSIS
2
Eastern Mountain Sports’ wear company was started in the year
1967 to provide sport lovers with different sporting products. The company
has been able to be on the top game due to its innovative strategies that
has allowed its steady growth over the years. However, several sporting
companies have emerged and threatening to take the Mountains market
share (Feldmann, 2009). This report analyses the Eastern Mountain sales
over three years in different regions. The following three insights will be
used to analyze EMS sales data.
i) Sales by keeping units of stocks.
ii) Cross tabulations
iii) Brand development index
Insight 1: Sales by keeping units of stocks.
In this insight, we capture each product, their sizes and variations sold in
different countries over stipulated time. The variables that are required for
this insight are: Order Quantity, Product Name, State(country) and Time
(Credit Card Expiry Date).
The table below contains sum od products sold in each country irrespective
of product name.
Country
Sum of
OrderQuantity
AU 2332
CA 5309
DE 1873

Running Head: EASTERN MOUNTAIN SPORT’S SALES ANALYSIS
3
FR 3363
GB 2767
US 13455
Grand Total 29099
We will draw a bar graph of the above sales to give us an actual sales in
these regions.
AU CA DE FR GB US
0
2000
4000
6000
8000
10000
12000
14000
16000
Quantity of sales in different countires
Total
Country
Sum of products
Table 1.
From the table, it is clear that U.S.A is the leading market for EMS
products followed by Canada with 5309 trucks of products while
Denmark become lasts with 1873 trucks only.
In the year 2005, EMS products were only ferried to two countries:
AU and CA.
Row Labels
Sum of
OrderQuantity
AU 2332
CA 4093
Grand Total 6425

Running Head: EASTERN MOUNTAIN SPORT’S SALES ANALYSIS
4
AU CA
0
500
1000
1500
2000
2500
3000
3500
4000
4500
Quantity of trucks by trucks
Total
In the 2005, Canada lead in the number of products with 4093 trucks
followed by Australia with2332 trucks.
In 2006 and 2007 and 2008, the quantity ferried to different markets
are as below.
CA DE FR GB
0
500
1000
1500
2000
2500
3000
3500
4000
Products distributed in the year 2006
Total