Memo

|

Memo

To: Northwind Traders

From: Jessica Boone

CC: Tom Pettay

Date: 8/19/2012

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: Salesperson Sales by Country

Analysis

I thought it would be beneficial to sort out the sales that were made in each country by each of the salespeople. I figured if there were countries where there were very few sales or very high sales could affect the marketing to those countries

This is a small snapshot of the entire pivot chart this is found in the Excel document that is attached. This is a large chart so I am just providing a small portion:

Sum of Total Cost | Column Labels | | | | | | |

Row Labels | Argentina | Austria | Belgium | Brazil | Canada | Denmark | Finland |

Buchanan, Steven | | | $ 7,674.30 | $ 17,966.40 | | | $ 1,470.00 |

Callahan, Laura | $ 2,750.50 | $ 11,409.00 | | $ 12,123.85 | $ 1,349.50 | $ 1,830.60 | $ 4,169.00 |

Davolio, Nancy | $ 686.70 | $ 18,304.95 | $ 751.00 | $ 30,010.00 | $ 9,331.30 | $ 6,875.00 | $ 1,828.90 |

Dodsworth, Anne | $ 944.50 | $ 9,558.80 | $ 3,271.50 | $ 1,928.00 | $ 1,208.50 | | $ 1,871.25 |

Fuller, Andrew | $ 477.00 | $ 19,802.40 | $ 2,866.50 | $ 10,339.20 | $ 9,143.70 | $ 2,395.20 | $ 6,210.90 |

Recommendation

There were very large differences in the amount of...