Question Details

(Solved) Great Western Outfitters Complete Problems 1-6 1. The boot department of the Great Western Outfitters store is preparing to set sales goals for the...


Great Western Outfitters
Complete Problems 1–6

The boot department of the Great Western Outfitters store is preparing to set sales goals for the upcoming year. Sally Brown, the department manager, is trying to determine what brands of boots to retain as part of the sales inventory. In particular, she is wondering about the value of continuing to sell Durango Boots. Going through past records, she retrieves the following information about the sales of Durango boots and asks you to help her with some calculations:



Total Sales (1,000 pairs of boots)

$500,000

Variable Costs

$300,000

Fixed Costs

$150,000

Tax Rate

25%



Based on this information: Compute the Contribution Margin (CM), unit CM, and CM ratio.

Answer: The Company has sales of $500,000 and variable costs of $300,000. The contribution margin for this example would be the difference of $500,000 and $300,000, which is $200,000. The $200,000 is the amount left over to pay fixed costs. A 'per product' margin can be found by dividing $200,000 by the number of units sold.

If the average CM ratio for other brands is 35%, should Brown keep stocking Durango Boots? Why or Why not? Provide a rationale that demonstrates your understanding of how the technique is applied in practice.




Sally Brown discovers that the owner of Great Western Outfitters is a big fan of Durango Boots and wants to continue selling them. As Sally prepares to order the boots for next year, she needs to determine how many pairs of boots (a pair of boots is one unit) she needs to sell to break even.



Based on the Table from Problem 1: Help Sally compute the break-even point in units and in dollars.



What if any factors might she consider which have the potential to change her analysis and/or the assumptions underlying her analysis?



Sally feels strongly that if they are going to carry Durango Boots that they need to do more than just break even.



Based on the Table from Problem 1: How many pairs of boots (units) would the boot department need to sell to obtain a profit of $100,000?

How many pairs of boots (units) would the company have to sell to obtain an after tax income of $120,000?

What assumptions were essential to the accuracy of her results and to the analysis and conclusions drawn? Discuss what role HR data might play in arriving at these calculations. How do HR data impact decisions on sales volume and operational results?

Sally Brown is flipping through a popular magazine and sees a photo spread of Garth Brooks, the country singing legend. Prominently on display is his collection of Durango Boots. Because of this, Sally is certain that the store can expect to sell 250 extra pairs of boots.



Based on the Table from Problem 1: How much will income increase if the sales go up by 250 units? (You can ignore taxes for this problem.)

How much will income increase if the store expects sales to go up by $25,000? (ignoring taxes).

The top three selling brands of boots at the Great Western Outfitters store are Double-H boots, Durango boots, and Stetson boots.



For the last quarter, sales were as follows:

Double-H Boots

Durango Boots

Stetson Boots

Sales

$400,000

$500,000

$875,000

Variable Costs

$250,000

$300,000

$625,000



Total fixed costs were $507,000.



Using these figures: Determine the sales mix, CM by product and in total, the CM ratio by product and in total, and the net income (ignore taxes).

Calculate the break-even point in dollars in total and by product.

Prepare a chart, such as example 12 on page 67, to help you with your answer. Use three decimal places for the percentages. For example, .275 would be 27.5%


Sally Brown is concerned about the sales numbers for Double-H Boots.



Based on the Table from Problem 5: What is the margin of safety if the company projects sales at $400,000 and the break-even point is $250,000?

As the HR Manager for several stores, variable and fixed costs include HR components. As an HR professional, having reviewed the analysis, what feedback do you have about the information from an HR perspective? How might this information be valuable to your role in hiring, rewarding and developing sales associates?

Great Western Outfitters
Complete Problems 1–6
1.
The boot department of the Great Western Outfitters store is preparing to set sales goals
for the upcoming year. Sally Brown, the department manager, is trying to determine what brands
of boots to retain as part of the sales inventory. In particular, she is wondering about the value of
continuing to sell Durango Boots. Going through past records, she retrieves the following
information about the sales of Durango boots and asks you to help her with some calculations: Total Sales (1,000 pairs of boots) $500,000
Variable Costs $300,000 Fixed Costs $150,000 Tax Rate 25% Based on this information: Compute the Contribution Margin (CM), unit CM, and CM ratio.
Answer: The Company has sales of $500,000 and variable costs of $300,000. The contribution margin for this example would be the difference of $500,000 and $300,000, which is $200,000. The $200,000 is the amount left over to pay fixed costs. A 'per product' margin can be found by dividing $200,000 by the number of units sold.
If the average CM ratio for other brands is 35%, should Brown keep stocking Durango
Boots? Why or Why not? Provide a rationale that demonstrates your understanding of
how the technique is applied in practice. o Sally Brown discovers that the owner of Great Western Outfitters is a big fan of
Durango Boots and wants to continue selling them. As Sally prepares to order the boots for next
year, she needs to determine how many pairs of boots (a pair of boots is one unit) she needs to
sell to break even.
Based on the Table from Problem 1: Help Sally compute the break-even point in units and
in dollars.
What if any factors might she consider which have the potential to change her analysis
and/or the assumptions underlying her analysis? o Sally feels strongly that if they are going to carry Durango Boots that they need to
do more than just break even. Based on the Table from Problem 1: How many pairs of boots (units) would the boot
department need to sell to obtain a profit of $100,000?
How many pairs of boots (units) would the company have to sell to obtain an after tax
income of $120,000?
What assumptions were essential to the accuracy of her results and to the analysis and
conclusions drawn? Discuss what role HR data might play in arriving at these
calculations. How do HR data impact decisions on sales volume and operational results? Sally Brown is flipping through a popular magazine and sees a photo spread of
Garth Brooks, the country singing legend. Prominently on display is his collection of Durango
Boots. Because of this, Sally is certain that the store can expect to sell 250 extra pairs of boots.
Based on the Table from Problem 1: How much will income increase if the sales go up by
250 units? (You can ignore taxes for this problem.)
How much will income increase if the store expects sales to go up by $25,000? (ignoring
taxes).
The top three selling brands of boots at the Great Western Outfitters store are Double-H boots,
Durango boots, and Stetson boots.
For the last quarter, sales were as follows:
Double-H Boots Durango Boots Stetson Boots
Sales $400,000 $500,000 $875,000 Variable Costs $250,000 $300,000 $625,000 Total fixed costs were $507,000.
Using these figures: Determine the sales mix, CM by product and in total, the CM ratio by
product and in total, and the net income (ignore taxes). Calculate the break-even point in dollars in total and by product. Prepare a chart, such as example 12 on page 67, to help you with your answer. Use three
decimal places for the percentages. For example, .275 would be 27.5% Sally Brown is concerned about the sales numbers for Double-H Boots.
Based on the Table from Problem 5: What is the margin of safety if the company projects
sales at $400,000 and the break-even point is $250,000?
As the HR Manager for several stores, variable and fixed costs include HR components. As an
HR professional, having reviewed the analysis, what feedback do you have about the
information from an HR perspective? How might this information be valuable to your role in
hiring, rewarding and developing sales associates?

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $15

Solution~000200147382.zip (25.37 KB)

Buy this answer for only: $18

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now