Week 5 Cost Volume Profit Analysis

 
Purpose of Assignment 
The Case Study focuses on CVP (Cost-Volume-Profit), break-even, and margin of safety analyses which allows students to experience working through a business scenario and applying these tools in managerial decision making. 
Resources

Generally Accepted Accounting Principles (GAAP), U.S. Securities and Exchange Commission (SEC) 

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 of shoes. Management is impressed with Mary’s ideas but concerned about the effects these changes will have on the break-even point and the margin of safety.
Assignment Steps
Complete the following: 

Compute the current break-even point in units, and compare it to the break-even point in units if Mary’s ideas are used.
Compute the margin of safety ratio for current operations and after Mary’s changes are introduced (Round to nearest full percent).
Prepare a CVP (Cost-Volume-Profit) income statement for current operations and after Mary’s changes are introduced.

Prepare a maximum 500-word informal memo to management addressing Mary’s suggested changes. 

Explain whether Mary’s changes should be adopted. Why or why not? Analyze the above information (three bullet points above) and use this information to support your suggestion.

USE the memo template provided in week 1.
Show your work in Excel. 
Complete calculations/computations using Excel. 

** GRADING RUBRIC ATTACHED***
**MEMO TEMPLATE ATTACHED**
 
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"