Southern New Hampshire University
Module Two Homework
Answer the following ques ons in a Word document.
1) If you have not done so already, download the sales pivot le in the Module Two Resources folder. Using the pivot table sales resource, which sales person had the highest total sales for the: UK? King USA? Peacock Overall? Peacock How many orders were placed on 2/18/2005? 4 What were the total sales for that day? $3719.10
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?
To help the sales team, I would analysis their individual performance so they could be er
understand areas of improvement to keep up with sales standards. Secondly, I would analysis sales by territory to make sure it is even worth sending sales teams and resources to territories that are not making enough of a purchase.
3) Breakeven Ques ons
What are the breakeven points for Widgets A, B, and C given the following informa on?
Fixed costs for A = 500, B = 500, C = 500
Pricing for A = $20, B= $30, C = $40
Variable costs for A =$10, B= $5, C= $20
Breakeven A = 50
Breakeven B = 20
Breakeven C = 25
Suppose the sales manager wanted to discuss lowering the price of product C to $15. What
would you tell him? I would sit the sales manager down and explain to him about variable cost
and show him that if we lower it to $15 it would cost more to make than we are receiving. Which product is the most protable if 60 units of each were sold? Widget B
Southern New Hampshire University
4) Think of any large company. Look up their mission statement. What is their mission statement? Do you think this company lives up to their mission statement? Why or why not?
Walmart is a large company with the mission statement "to save people money so they can live be er". While they do save people money on many items, there are some instances where the products are so cheaply made that it causes the consumers to waste money by spending at Walmart and then going somewhere else to buy be er quality. I feel they try to live up to their mission
statement but end up falling short with quality and service.
5) If you had as much money as Bill Gates and decided to create any company you wanted, what would your business be? What would your mission statement be? How did you come up with this statement? What aspects of your business did you think about to determine your
statement?
I would create a chain of resort style shoo ng ranges. The mission statement would be "Pung fun and safety together for your family". The statement represents what the resort shoo ng range can do. The business itself would involve a nice spa resort with di erent a