Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost.
Last year, the company sold 44,000 of these balls, with the following results:
Sales (44,000 balls) |
$ |
1,100,000 |
Variable expenses |
660,000 |
|
Contribution margin |
440,000 |
|
Fixed expenses |
317,000 |
|
Net operating income |
$ |
123,000 |
Required:
Compute (a) last year's CM ratio and the break-even point in balls, and (b) the degree of operating leverage at last year’s sales level. (Round "Unit sales to break even" to the nearest whole unit and other answers to 2 decimal places.)
|
Ratio" to 2 decimal places and "Unit sales to break even" to the nearest whole unit.)
|
|
Req 3
|
|
6. Refer to the data in (5) above.
a. If the new plant is built, how many balls will have to be sold next year to earn the same net operating income, $123,000, as last year?
Question: What is the number of balls?
b. Assume the new plant is built and that next year the company manufactures and sells 44,000 balls (the same number as sold last year). Prepare a contribution format income statement and compute the degree of operating leverage.
|
Brewer 8e Rechecks 2018-09-04
Brewer 8e Rechecks 2019-08-29
Answer | ||
1 | Contribution Margin = Sales - Variable Cost / Sales *100 | |
Particulars | Basketballs | |
Sales Qty | 44000 | |
Sales price per unit | $ 25.00 | |
Sales Value | $ 1,100,000.00 | |
Less: Variable Cost | ||
Variable cost per unit | $ 15.00 | |
Variable Cost | $ 660,000.00 | |
Contribution = Sales - Variable Cost | $ 440,000.00 | |
Contribution Margin = | 440,000/1,100,000*100 | |
Contribution Margin = | 40% | |
Contribution | $ 440,000.00 | |
Less: Fixed Cost | $ 317,000.00 | |
Net Operating Profit | $ 123,000.00 | |
Unit Sales to Break even | ||
in Units = Fixed Cost / Contribution per unit | ||
Contribution per unit= | ||
Sales price per unit | $ 25.00 | |
Variable cost per unit | $ 15.00 | |
Contribution per unit= | $ 10.00 | |
in Units = Fixed Cost / Contribution per unit | 317000/10 | |
Unit Sales to Break even = | 31,700.00 | |
Degree of operating leverage = Contribution / EBIT | ||
Contribution = | 440,000.00 | |
EBIT= | 123,000.00 | |
Degree of operating leverage = | 3.58 | |
2 | Sales Qty | 44000 |
Sales price per unit | $ 25.00 | |
Sales Value | $ 1,100,000.00 | |
Less: Variable Cost | ||
Variable cost per unit | $ 18.00 | |
Variable Cost | $ 792,000.00 | |
Contribution = Sales - Variable Cost | $ 308,000.00 | |
Contribution Margin = | 308,000/1,100,000*100 | |
Contribution Margin = | 28% | |
Contribution | $ 308,000.00 | |
Less: Fixed Cost | $ 317,000.00 | |
Net Operating Profit | $ (9,000.00) | |
Unit Sales to Break even | ||
in Units = Fixed Cost / Contribution per unit | ||
Contribution per unit= | ||
Sales price per unit | $ 25.00 | |
Variable cost per unit | $ 18.00 | |
Contribution per unit= | $ 7.00 | |
in Units = Fixed Cost / Contribution per unit | 317000/7 | |
Unit Sales to Break even = | 45,286 | |
3 | Refer to the above date 2 | |
Bolls will have to sold next year to earn the same net operating income, $123,000 as last year as follows | ||
Fixed Cost + Profit / contribution per unit | ||
ie =( 317000 + 123000) / 7 | 62,857 | |
4 | Selling price of $30 must charge next year to cover the increase labor cost | |
Workings | ||
let X = Selling price | X - 18 / X = .40 | |
X = 30 | ||
Sales Qty | 44000 | |
Sales price per unit | $ 30.00 | |
Sales Value | $ 1,320,000.00 | |
Less: Variable Cost | ||
Variable cost per unit | $ 18.00 | |
Variable Cost | $ 792,000.00 | |
Contribution = Sales - Variable Cost | $ 528,000.00 | |
Contribution Margin = | 528,000/1,320,000*100 | |
Contribution Margin = | 40% | |
5 | Sales Qty | 44000 |
Sales price per unit | $ 25.00 | |
Sales Value | $ 1,100,000.00 | |
Less: Variable Cost | ||
Variable cost per unit = 15-40% | $ 9.00 | |
Variable Cost | $ 396,000.00 | |
Contribution = Sales - Variable Cost | $ 704,000.00 | |
Contribution Margin = | 704,000/1,100,000*100 | |
Contribution Margin = | 64% | |
Contribution | $ 704,000.00 | |
Less: Fixed Cost (Increased to double) | $ 634,000.00 | |
Net Operating Profit | $ 70,000.00 | |
Unit Sales to Break even | ||
in Units = Fixed Cost / Contribution per unit | ||
Contribution per unit= | ||
Sales price per unit | $ 25.00 | |
Variable cost per unit | $ 9.00 | |
Contribution per unit= | $ 16.00 | |
in Units = Fixed Cost / Contribution per unit | 634000/10 | |
Unit Sales to Break even = | 39,625.00 | |
6.a) | Bolls will have to sold next year to earn the same net operating income, $123,000 as last year as follows | |
Fixed Cost + Profit / contribution per unit | ||
ie =( 634,000 + 123000) / 16 | 47,313 | |
6.b) | Northwood Company | |
Contribution Income Statement | ||
Particulars | Basketballs | |
Sales Qty | 44000 | |
Sales price per unit | $ 25.00 | |
Sales Value | $ 1,100,000.00 | |
Less: Variable Cost | ||
Variable cost per unit | $ 9.00 | |
Variable Cost | $ 396,000.00 | |
Contribution = Sales - Variable Cost | $ 704,000.00 | |
Less: Fixed Cost | $ 634,000.00 | |
Net Operating Profit | $ 70,000.00 | |
Degree of operating leverage = Contribution / EBIT | ||
Contribution = | 704,000.00 | |
EBIT= | 70,000.00 | |
Degree of operating leverage = | 10.06 |
Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the...
Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 44,000 of these balls, with the following results: Sales (44,000 balls) Variable expenses Contribution margin Fixed expenses Net operating income $ 1,100,000 660,000 440,000 317,000 $ 123,000 Required: 1....
Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 44,000 of these balls, with the following results: Sales (44,000 balls) Variable expenses Contribution margin Fixed expenses Net operating income $ 1,100,000 660,000 440,000 317,000 $ 123,000 Required: 1....
Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 44,000 of these balls, with the following results: Sales (44,000 balls) Variable expenses Contribution margin Fixed expenses Net operating income $ 1,100,000 660,000 440,000 317,000 $ 123,000 Required: 1....
Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 62,000 of these balls, with the following results: Sales (62,000 balls) $ 1,550,000 Variable expenses 930,000 Contribution margin 620,000 Fixed expenses 426,000 Net operating income $ 194,000 Required: 1....
Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 34,000 of these balls, with the following results: $ Sales (34,000 balls) Variable expenses Contribution margin Fixed expenses Net operating income 850,000 510,000 340,000 212,000 128,000 $ Required: 1....
Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 52,000 of these balls, with the following results: Sales (52,000 balls) Variable expenses Contribution margin Fixed expenses Net operating income $ 1,300,000 780,000 520,000 321,000 $ 199,000 Required: 1....
Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 30,000 of these balls, with the following results: $ Sales (30,000 balls) Variable expenses Contribution margin Fixed expenses Net operating income 750,000 450.000 300,000 210,000 90,000 Required: 1. Compute...
Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 44,000 of these balls, with the following results: Sales (44,000 balls) $ 1,100,000 Variable expenses 660,000 Contribution margin 440,000 Fixed expenses 317,000 Net operating income $ 123,000 Required: 1....
Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 44,000 of these balls, with the following results: Sales (44,000 balls) $ 1,100,000 Variable expenses 660,000 Contribution margin 440,000 Fixed expenses 317,000 Net operating income $ 123,000 Required: 1....
Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is dir labor cost Last year, the company sold 46,000 of these balls, with the following results: Sales (46,000 balls) Variable expenses Contribution margin Fixed expenses Net operating income $ 1,150,000 690,000 460,000 318,000 $ 142,000 Required: 1....