Budgeting Control Cost Volume Profit Analysis for The Best Team, Inc The Best Team Inc , sells shoes, watches, shorts and jackets The following is selected per unit information for these four products Shoes Watches Shorts Jackets Sales Price $50 $200 $25 $250 Variable costs and expenses $25 $40 $15 $75 Fixed costs and expenses amount to $800,000 per month The Best Team has total sales of $4 million per month, of which 60 percent result from the sale of shoes, 5 percent from watches, 15 percent form shorts and the rest from the sale of jackets Part 1 Compute separately the contribution margin ratio for each line of products Assuming the current sales mix, compute Average contribution margin ratio of total monthly sales Monthly operating income What is the companys operating income if monthly sales level is $2,000,000 The monthly break even sales volume (stated in dollars) The companys margin of safety if current monthly sales level is $4,000,000 If fixed costs would change to 540,000 what would happen with the break even point Explain the result If the fixed costs changed to 540,000 and sales was $4,000,000 what would happen to the operating income Explain the result If the targeted operating income was $2,500 000 what needs to be the dollars sales volume To improve the operating income what product products would you try to sell more of Explain clearly why Show also calculations to prove your reasoning, Part 2 Assume that through aggressive marketing The Best Team is able to shift its sales mix toward more sales of jackets Total sales remain $4 million per month, but now 40 percent of this revenue stems from sales of jackets, shoes 40 percent, watches 10 percent and 10 percent for shorts Fixed cost is still $800,000 per month Using the new sales mix compute Average contribution margin ratio of total monthly sales Monthly operating income The monthly break even sales volume (stated in dollars) Explain clearly why the companys financial picture changed with the new sales mix If the costs for all the products would decrease with 10 percent would the operating income then increase with 10 percent Explain Suppose that due to increased competition The Best Team needs to decrease the prices of Watches and Jackets with 30 percent The same time the fixed cost increased to $1,200,000 otherwise everything else remains the same Calculate the new break even point and operating income Comment on the new results (from question 6) compared to the base case in Part Has the risk profile of the company changed

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 02, 2024

Budgeting & Control Cost-Volume-Profit Analysis for The Best Team, Inc. The Best Team Inc., sells shoes, watches, shorts and jackets. The following is selected per-unit

Budgeting & Control

Cost-Volume-Profit Analysis for The Best Team, Inc.

The Best Team Inc., sells shoes, watches, shorts and jackets. The following is selected per-unit information for these four products:

	Shoes	Watches	Shorts	Jackets
Sales Price	$50	$200	$25	$250
Variable costs and expenses	$25	$40	$15	$75

Fixed costs and expenses amount to $800,000 per month.

The Best Team has total sales of $4 million per month, of which 60 percent result from the sale of shoes, 5 percent from watches, 15 percent form shorts and the rest from the sale of jackets.

Part 1.

Compute separately the contribution margin ratio for each line of products.

Assuming the current sales mix, compute:

Average contribution margin ratio of total monthly sales.
Monthly operating income.
What is the companys operating income if monthly sales level is $2,000,000?
The monthly break-even sales volume (stated in dollars).
The companys margin of safety if current monthly sales level is $4,000,000.
If fixed costs would change to 540,000 what would happen with the break-even point? Explain the result.
If the fixed costs changed to 540,000 and sales was $4,000,000 what would happen to the operating income? Explain the result.
If the targeted operating income was $2,500.000 what needs to be the dollars sales volume?
To improve the operating income what product /products would you try to sell more of. Explain clearly why. Show also calculations to prove your reasoning,

Part 2.

Assume that through aggressive marketing The Best Team is able to shift its sales mix toward more sales of jackets. Total sales remain $4 million per month, but now 40 percent of this revenue stems from sales of jackets, shoes 40 percent, watches 10 percent and 10 percent for shorts. Fixed cost is still $800,000 per month. Using the new sales mix compute:

Average contribution margin ratio of total monthly sales.
Monthly operating income.
The monthly break-even sales volume (stated in dollars).
Explain clearly why the companys financial picture changed with the new sales mix.
If the costs for all the products would decrease with 10 percent would the operating income then increase with 10 percent. Explain
Suppose that due to increased competition The Best Team needs to decrease the prices of Watches and Jackets with 30 percent. The same time the fixed cost increased to $1,200,000 otherwise everything else remains the same. Calculate the new break-even point and operating income.
Comment on the new results (from question 6) compared to the base case in Part Has the risk profile of the company changed?