Question

In: Accounting

Sales (13,000 units × $20 per unit) $ 260,000 Variable expenses 130,000 Contribution margin 130,000 Fixed...

Sales (13,000 units × $20 per unit) $ 260,000

Variable expenses 130,000

Contribution margin 130,000

Fixed expenses 145,000

Net operating loss $ (15,000)

1 Refer to the original data. By automating, the company could reduce variable expenses $3 per unit . However, fixed expenses would increase by $52,000 each month.

a. Compute the new CM ratio and the new break-even point in both unit sales and dollar sales. (Use the CM ratio to calculate your break-even point in dollars. Round your final answers to the nearest whole number.)

b Assume that the company expects to sell 20,200 units next month. Prepare two contribution format income statements, one assuming that operations are not automated and one assuming that they are.

c. would you recommend that company automates their operations ( assuming that compani expect to sell 20,200)

Solutions

Expert Solution

Answer:

OLD DATA:

Sales per Unit = Selling price / no. of unit
Sales per unit = $260,000 / 13,000
Sales per unit = $20 per unit

Variable expenses per unit = Variable expenses / no. of unit
Variable Expenses per Unit = $130,000 / 13,000
Variable Expenses per unit = $10 per unit

Contribution Margin per unit = Contribution Margin / no. of Unit
Contribution margin per unit = $130,000 / 13,000
Contribution margin per unit = $10

NEW DATA:

Selling price per unit = $20
Variable Expenses per unit = Old Variable expenses –reduced price
Variable Expenses per unit = $10 - $3
Variable Expenses per unit = $7

Fixed Expenses = Old Fixed Expenses + Increased Expenses
Fixed Expenses = $145,000 + $52,000
Fixed Expenses = $197,000

Contribution Margin = Selling Price – Variable Expenses
Contribution Margin per unit = $20 - $7
Contribution Margin per unit = $13

Answer of Part a:

CM Ratio = Contribution margin per unit / Selling price per unit *100
CM Ratio = $13 / $20 *100
CM Ratio = 65%

Break Even Point in Units = Fixed Expense / Contribution Margin per Unit
Break Even Point in Units = $197,000 / $13
Break Even point In Units = 15,154

Break Even Point in Dollars = 15,154 * $20
Break Even Point in Dollars = $303,080

Answer of Part C:

It is depend on how much company is willing to take the risk as well as future prospects for future sales. Therefore the proposed changes would increase the Company’s break even point as well as their fixed costs           . This changes also increases the CM ratio. The higher CM ratio means that once break even point is reached, profits will more rapidly increase than at present.


Related Solutions

Sales (13,000 units × $20 per unit) $ 260,000 Variable expenses 156,000 Contribution margin 104,000 Fixed...
Sales (13,000 units × $20 per unit) $ 260,000 Variable expenses 156,000 Contribution margin 104,000 Fixed expenses 116,000 Net operating loss $ (12,000 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes that a $6,500 increase in the monthly advertising budget, combined with an intensified effort by the sales staff, will result in an $80,000 increase in monthly sales. If the president is right, what will be...
Sales (12,800 units × $30 per unit) $ 384,000 Variable expenses 192,000 Contribution margin 192,000 Fixed...
Sales (12,800 units × $30 per unit) $ 384,000 Variable expenses 192,000 Contribution margin 192,000 Fixed expenses 214,500 Net operating loss $ (22,500 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes that a $6,600 increase in the monthly advertising budget, combined with an intensified effort by the sales staff, will increase unit sales and the total sales by $89,000 per month. If the president is right,...
Total Per Unit Sales $ 318,000 $ 20 Variable expenses 222,600 14 Contribution margin 95,400 $...
Total Per Unit Sales $ 318,000 $ 20 Variable expenses 222,600 14 Contribution margin 95,400 $ 6 Fixed expenses 72,600 Net operating income $ 22,800 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 to be sold each month to attain a target profit of $39,600? 3-b. Verify your answer by preparing a...
Sales (4,000 units) $200,000 Variable expenses 110,000 Contribution margin 90,000 Fixed expenses 48,000 Net operating income...
Sales (4,000 units) $200,000 Variable expenses 110,000 Contribution margin 90,000 Fixed expenses 48,000 Net operating income $42,000 A)What is the contribution margin per unit? B)What is the contribution margin ratio? C)What is the variable expense ratio? D) If sales increase to 6,050 units, what would be the estimated net operating income? E) If the selling price decreases by $4 per unit and the sales volume increases by 200 units, what would be the estimated net operating income? F) If the...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the following independent situations, calculate the amount(s) required. Required: 1. At the break-even point, Jefferson Company sells 85,000 units and has fixed cost of $348,600. The variable cost per unit is $0.35. What price does Jefferson charge per unit? Note: Round to the nearest cent. $ 2. Sooner Industries charges a price of $127 and has fixed cost of $360,500. Next year, Sooner expects to...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the following independent situations, calculate the amount(s) required. Required: 1. At the break-even point, Jefferson Company sells 95,000 units and has fixed cost of $349,700. The variable cost per unit is $0.15. What price does Jefferson charge per unit? Note: Round to the nearest cent. $ 2. Sooner Industries charges a price of $129 and has fixed cost of $421,000. Next year, Sooner expects to...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the following independent situations, calculate the amount(s) required. Required: 1. At the break-even point, Jefferson Company sells 85,000 units and has fixed cost of $351,900. The variable cost per unit is $0.30. What price does Jefferson charge per unit? Note: Round to the nearest cent. $ 2. Sooner Industries charges a price of $136 and has fixed cost of $391,500. Next year, Sooner expects to...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the following independent situations, calculate the amount(s) required. Required: 1. At the break-even point, Jefferson Company sells 85,000 units and has fixed cost of $346,500. The variable cost per unit is $0.10. What price does Jefferson charge per unit? Note: Round to the nearest cent. $ 2. Sooner Industries charges a price of $98 and has fixed cost of $476,500. Next year, Sooner expects to...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the following independent situations, calculate the amount(s) required. Required: 1. At the break-even point, Jefferson Company sells 115,000 units and has fixed cost of $346,800. The variable cost per unit is $0.10. What price does Jefferson charge per unit? Note: Round to the nearest cent. $ 2. Sooner Industries charges a price of $116 and has fixed cost of $395,500. Next year, Sooner expects to...
Total Unit Sales $ 992,000 $ 49.60 Variable expenses 595,200 29.76 Contribution margin 396,800 19.84 Fixed...
Total Unit Sales $ 992,000 $ 49.60 Variable expenses 595,200 29.76 Contribution margin 396,800 19.84 Fixed expenses 316,800 15.84 Net operating income 80,000 4.00 Income taxes @ 40% 32,000 1.60 Net income $ 48,000 $ 2.40 The company had average operating assets of $506,000 during the year. 1. Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms of margin and turnover. For each of the following questions, indicate whether the margin and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT