Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Her ideas include the installation of a new lighting system and increased display space that will add $34,000 in fixed costs to the $270,000 currently

Her ideas include the installation of a new lighting system and increased display space that will add $34,000 in fixed costs to the $270,000 currently spent by the company. In an effort to increase sales volume the advertising manager is also proposing a 5% price decrease from the current selling price of $40 per pair of shoes. The company is currently selling 20,000 pairs of shoes and expects that these changes would bring a 20% increase in the number of shoes sold. The current variable costs for a pair of shoes are $22 and management expects this figure to remain unchanged.

Management is impressed with the advertising managers initiative and ideas but is concerned about the effects these changes will have on company profits, break-even point and margin of safety.

Requirements

Using Microsoft Excel prepare a contribution margin income statement based on the companys current operations. The income statement should be properly formatted and include sales, variable costs and contribution margin in total and also on a per unit basis. Right below the income statement calculate the following based on the current operations:

  • Break even in units sold
  • Break even in dollars
  • Margin of safety in units
  • Marginofsafetyindollars

Using Microsoft Excel prepare a contribution margin income statement based the advertising managers recommendations. The income statement should be properly formatted and include sales, variable costs and contribution margin in total and also on a per unit basis. Right below the income statement calculate the following based on the current operations:

  • Break even in units sold
  • Break even in dollars
  • Margin of safety in units
  • Marginofsafetyindollars
  • UsingMicrosoftWord,prepareaone-pagememoinwhichyouexplainwhetherornotthesechangesshouldbemade
  • Does the memo include a clear recommendation, properly supported by your analysis?
  • Does the memo exhibit a clear and coherent overall structure?
  • Does the memo employ correct grammar, sentence and paragraph structure?
  • Are there punctuation and spelling errors?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting For Dummies

Authors: Mark P Holtzman, Karen Schoenebeck

1st Edition

1118116429, 978-1118116425

More Books

Students also viewed these Accounting questions

Question

Why is a barrier islands lagoon usually a quiet environment?

Answered: 1 week ago

Question

Discuss two sources of short term funds and long term funds

Answered: 1 week ago

Question

2. Develop a good and lasting relationship

Answered: 1 week ago

Question

1. Avoid conflicts in the relationship

Answered: 1 week ago