Question

In: Accounting

Problem 5-5A a-c (Video) Mary Willis is the advertising manager for Bargain Shoe Store. She is...

Problem 5-5A a-c (Video)

Mary Willis is the advertising manager for Bargain Shoe Store. She is currently working on a major promotional campaign. Her ideas include the installation of a new lighting system and increased display space that will add $24,000 in fixed costs to the $270,000 currently spent. In addition, Mary is proposing that a 5% price decrease ($40 to $38) will produce a 20% increase in sales volume (20,000 to 24,000). Variable costs will remain at $24 per pair of shoes. Management is impressed with Mary’s ideas but concerned about the effects that these changes will have on the break-even point and the margin of safety.

Compute the current break-even point in units, and compare it to the break-even point in units if Mary’s ideas are used.

Current break-even point pairs of shoes

New break-even point pairs of shoes

Compute the margin of safety ratio for current operations and after Mary’s changes are introduced. (Round answers to 0 decimal places, e.g. 15%.)

Current margin of safety ratio %

New margin of safety ratio %

Prepare a CVP income statement for current operations and after Mary’s changes are introduced.

BARGAIN SHOE STORE
CVP Income Statement

Current

New

Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesGross ProfitNet Income/(Loss)SalesSelling ExpensesVariable Expenses

$

$

Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesGross ProfitNet Income/(Loss)SalesSelling ExpensesVariable Expenses

Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesGross ProfitNet Income/(Loss)SalesSelling ExpensesVariable Expenses

Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesGross ProfitNet Income/(Loss)SalesSelling ExpensesVariable Expenses

Administrative ExpensesContribution MarginCost of Goods SoldFixed ExpensesGross ProfitNet Income/(Loss)SalesSelling ExpensesVariable Expenses

$

$

Would you make the changes suggested?

Solutions

Expert Solution

Required information is as computed below: Calculation of Break even point and MOS
Contribution Income Statement
Current New
Units 20,000 Per Unit 24,000 Per Unit
Sales $800,000 40 $912,000 38
Variable Costs $480,000 24 $576,000 24
Contribution Margin $320,000 16 $336,000 14
Contribution Margin ratio = (Contribution Margin/Sales) 40% 37%
Fixed Costs $270,000 $294,000
Break even point (Fixed Cost/Cont Margin ratio) $675,000 $798,000
Break even point in units (Fixed Cost/Cont Margin per unit) 16,875 57,000
Margin of safety (Total sales minus break even sales) $125,000 $6 $114,000 $4.75
Margin of safety percentage (MOS/ Actual sales) 15.63% 12.50%
Contribution Income Statement
Bargain Shoe Store Current New
Units 20,000 Per Unit 24,000 Per Unit
Sales $800,000 40 $912,000 38
Variable Expenses $480,000 24 $576,000 24
Contribution Margin $320,000 16 $336,000 14
Contribution Margin ratio = (Contribution Margin/Sales) 40% 37%
Fixed Expenses $270,000 $294,000
Net Income $50,000 $42,000
No I will not make the suggested changes as these changes will not increase any profit.

Related Solutions

Mary Willis is the advertising manager for Bargain Shoe Store. She is currently working on a...
Mary Willis is the advertising manager for Bargain Shoe Store. She is currently working on a major promotional campaign. Her ideas include the installation of a new lighting system and increased display space that will add $36,000 in fixed costs to the $272,000 currently spent. In addition, Mary is proposing that a 5% price decrease ($40 to $38) will produce a 20% increase in sales volume (20,000 to 24,000). Variable costs will remain at $24 per pair of shoes. Management...
Scenario: Mary Willis is the advertising manager for Bargain Shoe Store. She is currently working on...
Scenario: Mary Willis is the advertising manager for Bargain Shoe Store. She is currently working on a major promotional campaign. Her ideas include the installation of a new lighting system and increased display space that will add $24,000 in fixed costs to the $270,000 in fixed costs currently spent. In addition, Mary is proposing a 5% price decrease ($40 to $38) will produce a 20% increase in sales volume (20,000 to 24,000). Variable costs will remain at $24 per pair...
Problem 19-4A Mary Willis is the advertising manager for Bargain Shoe Store. She is currently working...
Problem 19-4A Mary Willis is the advertising manager for Bargain Shoe Store. She is currently working on a major promotional campaign. Her ideas include the installation of a new lighting system and increased display space that will add $57,600 in fixed costs to the $396,000 currently spent. In addition, Mary is proposing that a 5% price decrease ($60 to $57) will produce a 20% increase in sales volume (20,000 to 24,000). Variable costs will remain at $36 per pair of...
Problem 18-4A Mary Willis is the advertising manager for Bargain Shoe Store. She is currently working...
Problem 18-4A Mary Willis is the advertising manager for Bargain Shoe Store. She is currently working on a major promotional campaign. Her ideas include the installation of a new lighting system and increased display space that will add $57,600 in fixed costs to the $396,000 currently spent. In addition, Mary is proposing that a 5% price decrease ($60 to $57) will produce a 20% increase in sales volume (20,000 to 24,000). Variable costs will remain at $36 per pair of...
Oriole Willis is the advertising manager for Bargain Shoe Store. She is currently working on a...
Oriole Willis is the advertising manager for Bargain Shoe Store. She is currently working on a major promotional campaign. Her ideas include the installation of a new lighting system and increased display space that will add $ 39,000 in fixed costs to the $ 423,000 currently spent. In addition, Oriole is proposing that a 5% price decrease ($ 60 to $ 57) will produce a 20% increase in sales volume ( 20,000 to 24,000). Variable costs will remain at $...
Mary Willis is the advertising manager for Culver Shoe Store. She is currently working on a...
Mary Willis is the advertising manager for Culver Shoe Store. She is currently working on a major promotional campaign. Her ideas include the installation of a new lighting system and increased display space that will add $14,000 in fixed costs to the $133,000 currently spent. In addition, Mary is proposing that a 5% price decrease ($20 to $19) will produce a 20% increase in sales volume (20,000 to 24,000). Variable costs will remain at $12 per pair of shoes. Management...
Problem 6.45A a-c Alice Oritz is the advertising manager for Value Shoe Store. She is currently...
Problem 6.45A a-c Alice Oritz is the advertising manager for Value Shoe Store. She is currently working on a major promotional campaign. Her ideas include the installation of a new lighting system and increased display space that will add $25,830 in fixed costs to the $262,605 currently spent. In addition, Alice is proposing that a 10% price decrease ($35 to $31.50) will produce a 20% increase in sales volume (20,500 to 24,600). Variable costs will remain at $14 per pair...
Charlotte Henry is the advertising manager for Bargain TV Store. She is currently working on a...
Charlotte Henry is the advertising manager for Bargain TV Store. She is currently working on a major promotional campaign. Her ideas include the installation of a new lighting system and increased display space that will add $25,000 in fixed costs to the $250,000 in fixed costs currently spent. In addition, Charlotte is proposing a 5% price decrease ($50 to $47.5) will produce a 20% increase in sales volume (50,000 to 60,000) according to market research. Variable costs will remain at...
Problem 23-5A a, c (Video) (Part Level Submission) Sunland Company manufactures a variety of tools and...
Problem 23-5A a, c (Video) (Part Level Submission) Sunland Company manufactures a variety of tools and industrial equipment. The company operates through three divisions. Each division is an investment center. Operating data for the Home Division for the year ended December 31, 2020, and relevant budget data are as follows. Actual Comparison with Budget Sales $1,401,000 $100,000 favorable Variable cost of goods sold 680,000 55,000 unfavorable Variable selling and administrative expenses 126,000 25,000 unfavorable Controllable fixed cost of goods sold...
Problem 5-02A a-c (Part Level Submission) (Video) Sunland Hardware Store completed the following merchandising transactions in...
Problem 5-02A a-c (Part Level Submission) (Video) Sunland Hardware Store completed the following merchandising transactions in the month of May. At the beginning of May, the ledger of Sunland showed Cash of $4,500 and Owner’s Capital of $4,500. May 1 Purchased merchandise on account from Braun's Wholesale Supply $3,900, terms 2/10, n/30. 2 Sold merchandise on account $2,500, terms 1/10, n/30. The cost of the merchandise sold was $1,600. 5 Received credit from Braun's Wholesale Supply for merchandise returned $400....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT