Due by 5pm MST 3/11/17. 100% Plagiarism Free. A++ Work. I will need all aspects of the assignment (excel spreadsheet and MS Word Informal Memo)
Resources: Generally Accepted Accounting Principles (GAAP), U.S. Securities and Exchange Commission (SEC)
Tutorial help on Excel® and Word functions can be found on the Microsoft® Office website. There are also additional tutorials via the web offering support for Office products.
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.
Complete the following:
Prepare a maximum 700-word informal memo to management addressing Mary’s suggested changes.
Show your work in Microsoft® Word or Excel®.
Complete calculations/computations using Microsoft® Word or Excel®.
Format your assignment consistent with APA guidelines.
Click the Assignment Files tab to submit your assignment.