We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Northwind Traders Company

essay
The whole doc is available only for registered users

A limited time offer! Get a custom sample essay written according to your requirements urgent 3h delivery guaranteed

Order Now

Thank you for commissioning my services and the chance to analysis your company’s data. The analysis and recommendations are based on the data provided. Please let me know if you have any additional questions that I can answer concerning the analysis and/or the recommendations provided.

ANALYSIS 1 – Discount Level Analysis
Analysis

The initial step to this analysis was to determine if discounts have any effect on sales. In going so I categorized the discounts in to 5 level subtotaling all discounts under 10%. In do so, It was determined that the lowest discount level of 0%-9% products the most net sales and number of sales across all categories.

Graphic

Recommendation
We can see that the lowest discount level is the most active and productive discount in generating sales. Additionally, there is no significant impact when offering 10%-25% discount and I would recommend avoiding the larger discount levels. Instead of offering a higher discount I would recommend reducing the discount and offering a < 10% discount by volume. Try this for a couple of months to safeguard the customer relationship. ANALYSIS 2 – Net sales over time and by agent

Analysis
This analysis depicts the net sales during a year. The decline in sales in June 2006 is because it only plots the first 3 days of the month. The
company sales as a whole looks promising through 2006 projections. Graphic

Recommendation
Since the data is not available for the entire year for 2004 & 2006, I performed additional analysis looking at the data by agent. As many on the agents have declined in sales over 2005, projections are still good as a whole. With the combined analysis of #1 and #2, I would recommend a bonus incentive by category to motivate agents to sell all products. I would recommend agents getting a compounding incentive for each category over $100,000 in net sales. I would also evaluate sales strategies Steve and Anne as they have shown growth in sales since the beginning. ANALYSIS 3 – Total Sales by Country

Analysis
This analysis depicts the total sales by country.
Graphic

Recommendation
USA and Germany are the top countries where people are buying our product. Austria and Brazil are also showing a potential for growth and we can focus on increasing market share in these countries. Argentina and Norway are the countries showing little growth. In the interest to increase Net sales, I recommend increasing or decrease the discount % respectively to move closer to the average 5.6% discount and re-evaluate the impact to sales. SELF ASSESSMENT

From completing the Excel project, I learned not only how to create basic charts, pivot tables and other graphs but most importantly understand the need for data analysis, organize data, analyze the data, draw conclusions and present evidence. I did some additional analysis which are shown in the excel workbook. I would have loved to do the What if Analysis but due to the multiple courses and my work schedule I could not budget the time for the analysis.

Related Topics

We can write a custom essay

According to Your Specific Requirements

Order an essay
icon
300+
Materials Daily
icon
100,000+ Subjects
2000+ Topics
icon
Free Plagiarism
Checker
icon
All Materials
are Cataloged Well

Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email.

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
Sorry, but only registered users have full access

How about getting this access
immediately?

Your Answer Is Very Helpful For Us
Thank You A Lot!

logo

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?

Can't find What you were Looking for?

Get access to our huge, continuously updated knowledge base

The next update will be in:
14 : 59 : 59