preview

Essay on Final Excel Project Bis115

Decent Essays

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

Get Access