Essay on Final Excel Project Bis115

757 WordsMay 28, 20134 Pages
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…show more content…
Also take careful attention to notice the difference in the two quarters from 2004 and 2006. It looks like a majority of your sales representatives are making solid revenue for the company. Graphic Recommendation My recommendation would be for starters, enroll every sales rep in a sales training class. Upon completion of I would set a goal that each sales rep must contribute at least 10% of the net income for the company. Since there are 9 sales reps this leaves some room for extra. This will not only force the sales reps to work together, and encourage friendly competition. I also recommend you elect a sales representative team leader (for example Miss Peacock who is consistently your top sales person) and empower her to encourage, coach and teacher the other sales reps in her methods and tricks. ANALYSIS 3: Total Revenues by Month in 2005 Analysis After careful consideration, I decided to look at the yearly trend of just 2005 since we have all the data from that year. If you will notice, October is by far the biggest selling month, whereas July is the lowest, but mostly the trend is pretty consistent across the year. Graphic Recommendation I recommend that we find out what about October spikes sales, and try to apply it to the rest of the year. Also, I’d consider adding special sales and discounts in March and April, the lowest sales months of the year, that should help perk up

    More about Essay on Final Excel Project Bis115

      Open Document