NO PLAGERIASM, MUST BE ORIGINAL WORK
MUST USE AT LEAST 2 IN TEXT CITATIONS WITH ALL REFERNCES LISTED IN APA FORMAT
THIS IS A 2 PART ASSIGHNMENT
1ST PART IS A WORD DOCUMENT OF NO LESS THAN 700 WORDS
2ND PART IS AN EXCEL DOCUMENT THAT SHOWS ALL CALCULATIONS WITH FORMULAS INSERTED INTO COLUMNS (ANSWERS ALONE IS NOT ENOUGH, WORK MUST BE SHOWN)
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 Excel®.
Format your assignment consistent with APA guidelines.
Hi there! Click one of our representatives below and we will get back to you as soon as possible.