Northwind Traders
Memo
To: Northwind Traders
Date: 9/22/13
Re: Revenue Assessment
Thank you for the opportunity to assess your sales data in order to provide recommendations for increasing your sales. The analysis and recommendations below are based on the data you provided, which covers a period from May 2004 through June 2006. The analysis below is based on this data alone. Therefore, our recommendations should be tempered by your knowledge of business realities and your market. Please let us know if we can answer any questions concerning the analysis or the recommendations provided.
ANALYSIS 1 My Analysis of sales per Country
I have included charts that show total sales per country ranging from the years 2004-06 these charts show the following, Strong business sales, Probationary sales and Low sales. I have concluded in my analysis that there are some countries that are stronger, some that either need new guidance in sales and some that do not generate enough for the company in sales.
Salesperson
Austria
Brazil
Canada
France
Germany
Mexico
Sweden
UK
USA
Venezuela
Buchanan
15
12
11
4
7
7
19
9
Callahan
13
24
4
16
46
4
20
16
45
23
Davolio
17
21
12
23
49
16
13
22
85
19
Dodsworth
8
5
3
7
23
6
10
10
2
Fuller
17
25
14
21
37
11
13
11
23
8
King
19
19
4
12
13
11
5
12
20
9
Leverling
18
24
20
36
50
13
22
17
47
23
Peacock
21
53
9
39
73
13
6
28
68
19
Suyama
12
17
9
18
26
5
12
35
6
Grand Total
125
203
75
184
328
72
97
135
352
118
Salesperson
Belgium
Denmark
Finland
Ireland
Italy
Spain
Switzerland
Buchanan
11
4
3
5
3
Callahan
5
9
4
7
3
3
Davolio
3
13
5
3
8
7
9
Dodsworth
7
3
9
2
1
7
Fuller
7
3
17
8
15
7
King
7
9
3
6
3
8
6
Leverling
2
4
4
14
2
7
9
Peacock
15
11
7
2
12
16
9
Suyama
4
1
2
9
1
6
Grand Total
56
46
54
55
53
54
52
To: Northwind Traders
Date: 9/22/13
Re: Revenue Assessment
Thank you for the opportunity to assess your sales data in order to provide recommendations for increasing your sales. The analysis and recommendations below are based on the data you provided, which covers a period from May 2004 through June 2006. The analysis below is based on this data alone. Therefore, our recommendations should be tempered by your knowledge of business realities and your market. Please let us know if we can answer any questions concerning the analysis or the recommendations provided.
ANALYSIS 1 My Analysis of sales per Country
I have included charts that show total sales per country ranging from the years 2004-06 these charts show the following, Strong business sales, Probationary sales and Low sales. I have concluded in my analysis that there are some countries that are stronger, some that either need new guidance in sales and some that do not generate enough for the company in sales.
Salesperson
Austria
Brazil
Canada
France
Germany
Mexico
Sweden
UK
USA
Venezuela
Buchanan
15
12
11
4
7
7
19
9
Callahan
13
24
4
16
46
4
20
16
45
23
Davolio
17
21
12
23
49
16
13
22
85
19
Dodsworth
8
5
3
7
23
6
10
10
2
Fuller
17
25
14
21
37
11
13
11
23
8
King
19
19
4
12
13
11
5
12
20
9
Leverling
18
24
20
36
50
13
22
17
47
23
Peacock
21
53
9
39
73
13
6
28
68
19
Suyama
12
17
9
18
26
5
12
35
6
Grand Total
125
203
75
184
328
72
97
135
352
118
Salesperson
Belgium
Denmark
Finland
Ireland
Italy
Spain
Switzerland
Buchanan
11
4
3
5
3
Callahan
5
9
4
7
3
3
Davolio
3
13
5
3
8
7
9
Dodsworth
7
3
9
2
1
7
Fuller
7
3
17
8
15
7
King
7
9
3
6
3
8
6
Leverling
2
4
4
14
2
7
9
Peacock
15
11
7
2
12
16
9
Suyama
4
1
2
9
1
6
Grand Total
56
46
54
55
53
54
52