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 file 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? FOUR What were the total sales for that day? TOTAL SALES for 2/18/2005 is $3,719.00
How would these help the sales team? According to Braggs (2011) the two types of sales analysis that can be done is "setting sales standards" and "sales planning and setting of quotas." When a controller decides to use either of these two options, they are able to see to take past experiences into their analysis.
By using these two different type of analysis the management team is able to see the performance of each member of the sales team, they are them able to develop standards and expectations of the team members. This also always for the sales team to have realistic goals and expectations to meet as part of their job.
3) Breakeven Questions
What are the breakeven points for Widgets A, B, and C given the following information?
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
Southern New Hampshire University
Suppose the sales manager wanted to discuss lowering the price of product C to $15.
What would you tell him? My answer would be a firm No. The manufacturing cost
would be higher than what the consumer is paying for the product. That is not a
good strategy.
Which product is the most profitable if 60 units of each were sold? B
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? The organization that I choose was Zappos. Borek (2014) state the mission statement of the organization is "To provide the best customer service possible.
This organization is one that I have frequently used myself for shoe purchases. The level of customer service that the organization provides is only matched by their reviews. One review given stated that looking for a "New Balance Shoe, one of their competitor's had the show for a lower price point. Zappos directed them to their competitor, even though they were losing the sale. That is legendary level of member service that is appreciated by people who shop with the organization.
The organization is willing to loss a sale in order for the customer to get the lowest possible price for the shoe, proves the organization has integrity and gives the customer even more reason to shop with their organization. While, the organization was discussed in a previous course, it is one