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. 
ResourcesGenerally 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**
Approximate price: $22
We value our customers and so we ensure that what we do is 100% original..

With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.