Memo
To: Northwind Traders
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 Performance Data
Analysis
Analysis of salesperson performance data over a 2 year period shows that your bottom 5 sales producers are in order from most sales to least sales:

1. King 2. Callahan 3. Dodsworth 4. Suyama 5. Buchanan

Although King’s sales before discount were the highest of the bottom 5, his sales after discount were slightly lower, while Callahan’s sales stayed about the same before and after discounted sales. Dodsworth again didn’t have much variation between his before and after discount sales. Suyama had higher sales after discounts than before, while Buchanan had lower sales after discounts than before.

The top 4 sales performers are in order from most sales to least sales:

1. Peacock 2. Leverling 3. Davolio 4. Fuller

Peacock and Fuller’s sales were approximately the same before and after discounts, while Leverling and Davolio’s sales were actually higher after discounts.

Graphic Recommendation
After analyzing the data provided I would recommend that a bottom sales baseline of $50,000 per year be implemented encouraging salespersons to rise to the occasion in order to keep their positions. I would also recommend that any salesperson whose annual sales after discounts are actually higher than before