Question

Erin Shelton, Inc., wants to earn a target profit of $960,000 this year. The company’s fixed...

Erin Shelton, Inc., wants to earn a target profit of $960,000 this year. The company’s fixed costs are expected to be $1,320,000 and its variable costs are expected to be 40 percent of sales. Erin Shelton, Inc., earned $860,000 in profit last year.

Required:
1.
Calculate break-even sales for Erin Shelton, Inc.


  
2. Prepare a contribution margin income statement on the basis break-even sales. (Do not leave any cells blank, enter a zero wherever required.)



3. Calculate the required sales to meet the target profit of $960,000.



4. Prepare a contribution margin income statement based on sales required to earn a target profit of $960,000.



5. When the company earns $960,000 of net income, what is its margin of safety and margin of safety as a percentage of sales? (Round your "Percentage Sales" answer to 2 decimal places. (i.e. .1234 should be entered as 12.34%.))

Homework Answers

Answer #1

1, breakeven sales($) = fixed cost/ contribution to sales ratio

$1320000/.6 = $2200000

2. contribution margin income statement

sales ($) 2200000

- variable cost(40%) 880000

contribution ($) 1320000

- fixed cost 1320000

profit 0

3.required contribution = target profit + fixed cost = $960000+ $1320000 = $2280000

requires sales = required contribution / contribution to sales ratio = $2280000/.60 = $3800000

4 contribution margin statement

sales $ 3800000

- variaable cost (40%) $1520000

contribution (60%) $2280000

- fixed cost $1320000

profit $960000

5. mos = actual sales - break even point(BEP)

BEP = FIXED COST / PV RATIO

=$ 1320000/ .6 = $2200000

MARGIN OF SAFETY = $( 3800000-2200000)

=$1600000

MOS(%)= ACTUAL SALES - BES/ACTUAL SALES *100

=$( 3800000-2200000/3800000)*100 = 42.10%


Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Erin Shelton, Inc., wants to earn a target profit of $930,000 this year. The company’s fixed...
Erin Shelton, Inc., wants to earn a target profit of $930,000 this year. The company’s fixed costs are expected to be $1,260,000 and its variable costs are expected to be 60 percent of sales. Erin Shelton, Inc., earned $830,000 in profit last year. Required: 1. Calculate break-even sales for Erin Shelton, Inc. 2. Prepare a contribution margin income statement on the basis break-even sales. (Do not leave any cells blank, enter a zero wherever required.) 3. Calculate the required sales...
Erin Shelton, Inc., wants to earn a target profit of $840,000 this year. The company’s fixed...
Erin Shelton, Inc., wants to earn a target profit of $840,000 this year. The company’s fixed costs are expected to be $1,080,000 and its variable costs are expected to be 70 percent of sales. Erin Shelton, Inc., earned $740,000 in profit last year. Required: 1. Calculate break-even sales for Erin Shelton, Inc.    2. Prepare a contribution margin income statement on the basis break-even sales. (Do not leave any cells blank, enter a zero wherever required.) 3. Calculate the required...
Erin Shelton, Inc., wants to earn a target profit of $800,000 this year. The company’s fixed...
Erin Shelton, Inc., wants to earn a target profit of $800,000 this year. The company’s fixed costs are expected to be $1,000,000 and its variable costs are expected to be 60 percent of sales. Erin Shelton, Inc., earned $700,000 in profit last year. Required: 1. Calculate break-even sales for Erin Shelton, Inc. 2. Prepare a contribution margin income statement on the basis break-even sales. (Do not leave any cells blank, enter a zero wherever required.) 3. Calculate the required sales...
Erin Shelton, Inc., wants to earn a target profit of $820,000 this year. The company’s fixed...
Erin Shelton, Inc., wants to earn a target profit of $820,000 this year. The company’s fixed costs are expected to be $1,040,000 and its variable costs are expected to be 50 percent of sales. Erin Shelton, Inc., earned $720,000 in profit last year. Required: 1. Calculate break-even sales for Erin Shelton, Inc.    2. Prepare a contribution margin income statement on the basis break-even sales. (Do not leave any cells blank, enter a zero wherever required.) 3. Calculate the required...
Erin Shelton, Inc., wants to earn a target profit of $870,000 this year. The company’s fixed...
Erin Shelton, Inc., wants to earn a target profit of $870,000 this year. The company’s fixed costs are expected to be $1,140,000 and its variable costs are expected to be 50 percent of sales. Erin Shelton, Inc., earned $770,000 in profit last year. Required: 1. Calculate break-even sales for Erin Shelton, Inc. 2. Prepare a contribution margin income statement on the basis break-even sales. 3. Calculate the required sales to meet the target profit of $870,000. 4. Prepare a contribution...
Erin Shelton, Inc., wants to earn a target profit of $840,000 this year. The company’s fixed...
Erin Shelton, Inc., wants to earn a target profit of $840,000 this year. The company’s fixed costs are expected to be $1,400,000 and its variable costs are expected to be 44 percent of sales. Erin Shelton, Inc., earned $900,000 in profit last year. Calculate break-even sales for Erin Shelton, Inc Prepare a contribution margin income statement on the basis break-even sales. (Do not leave any cells blank, enter a zero wherever required.) Calculate the required sales to meet the target...
Sandy Bank, Inc., makes one model of wooden canoe. Partial information is given below. Required: 1....
Sandy Bank, Inc., makes one model of wooden canoe. Partial information is given below. Required: 1. Complete the following table. 2. Suppose Sandy Bank sells its canoes for $550 each. Calculate the contribution margin per canoe and the contribution margin ratio. 3. This year Sandy Bank expects to sell 830 canoes. Prepare a contribution margin income statement for the company. 4. Calculate Sandy Bank’s break-even point in units and in sales dollars. 5. Suppose Sandy Bank wants to earn $81,000...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total    Per Unit   Sales $ 600,000 $ 40        Variable expenses 420,000 28        Contribution margin 180,000 $ 12        Fixed expenses 148,800   Net operating income $   31,200 Required: 1. What is the monthly break-even point in unit sales and in dollar sales?          2. Without resorting to computations, what is the total contribution margin at the break-even point?          3-a. How...
Sandy Bank, Inc., makes one model of wooden canoe. Partial information is given below. Required: 1....
Sandy Bank, Inc., makes one model of wooden canoe. Partial information is given below. Required: 1. Complete the following table. 2. Suppose Sandy Bank sells its canoes for $550 each. Calculate the contribution margin per canoe and the contribution margin ratio. 3. This year Sandy Bank expects to sell 810 canoes. Prepare a contribution margin income statement for the company. 4. Calculate Sandy Bank’s break-even point in units and in sales dollars. 5. Suppose Sandy Bank wants to earn $81,000...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total    Per Unit   Sales $ 318,000 $ 20        Variable expenses 222,600 14        Contribution margin 95,400 $ 6        Fixed expenses 76,800   Net operating income $   18,600 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin at the break-even point? 3-a. How many units would have...