Module Two Homework
1) If you have not done so already, download the sales pivot file in the Module Two Resources
folder. Using the pivot table sales resource, which salesperson had the highest total sales for
the:
UK? King
USA? Peacock
Overall? Peacock - $225,763.68
How many orders were placed on 2/18/2005? 4
What were the total sales for that day? $3719.00
2) Name at least two types of sales analyses that the controller might perform for the sales team.
How would these help the sales team?
Sales by product is one type of sales analysis that the controller might perform for the sales
force. By presenting the sales team with an analytical report detailing how much of each
product is sold at what price, the sales team has access to critical data. For example, if a
product's sales have been steadily declining, the sales manager may determine it's time to
"discontinue" the product line. If, on the other hand, the sales manager notices that one
product is performing very well, he or she may decide to expand the line and use this product to
create leads.
A price analysis on each product is another sales analysis created by the controller. With a
pricing analysis, the controller must create a report that shows the costs of each product as well
as the price, which determines the profit margin. With this knowledge, the sales team will be
able to offer the best pricing possible without going below cost. enabling them to remain
competitive in their field
3) Breakeven Questions
