Final Excel Project Bis115
CanDo Consulting Don’t let your Profits Walk out the Door…
Memo
To: Northwind Traders
From: Tina Thompson
CC: Professor Michael Jones
Date: 6/5/2013
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: Total Sales by Country
Analysis
As an American based country one expects the highest income to be within a company’s home country. Well, in the case of Northwind Traders, that is the case. The USA has the highest gross net sales, to be followed closely by Germany and then Austria and Brazil. Sales are above 100,000 over the past two years. If you notice, all of the top selling companies are offered a discount whereas the lower selling countries are offered now discount at all.
Graphic
Recommendation
Based on my analysis I think it would be wise to entice lower income countries to buy more products by offering a discount if they reach a certain amount of product ordered. I also recommend sending surveys to the largest purchasing companies to see what products they would like to see discounts offered on if larger volumes are purchased. Also taking special care to cater to the products higher volume countries are requiring.
ANALYSIS 2 : Net Income by Sales Rep
Analysis I was given two full years of sales data, and took a look at the net revenue of each of your sales representatives. At first glance it looks like 2005 might have been a more profitable year, but bear in mind that 2005 is the only year we all four quarters accounted for. Keeping
Memo
To: Northwind Traders
From: Tina Thompson
CC: Professor Michael Jones
Date: 6/5/2013
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: Total Sales by Country
Analysis
As an American based country one expects the highest income to be within a company’s home country. Well, in the case of Northwind Traders, that is the case. The USA has the highest gross net sales, to be followed closely by Germany and then Austria and Brazil. Sales are above 100,000 over the past two years. If you notice, all of the top selling companies are offered a discount whereas the lower selling countries are offered now discount at all.
Graphic
Recommendation
Based on my analysis I think it would be wise to entice lower income countries to buy more products by offering a discount if they reach a certain amount of product ordered. I also recommend sending surveys to the largest purchasing companies to see what products they would like to see discounts offered on if larger volumes are purchased. Also taking special care to cater to the products higher volume countries are requiring.
ANALYSIS 2 : Net Income by Sales Rep
Analysis I was given two full years of sales data, and took a look at the net revenue of each of your sales representatives. At first glance it looks like 2005 might have been a more profitable year, but bear in mind that 2005 is the only year we all four quarters accounted for. Keeping