Grange manufacturing company had net income of $300,000 in 2017 when the selling price per unit...

Grange manufacturing company had net income of $300,000 in 2017 when the selling price per unit was $200 and data for variable and fixed costs were as follows:

Cost Schedule:

Variable Costs:

Direct Material $28 Direct Labour $35

Variable Manufacturing Overhead $17

Total $80

Fixed Costs:

Manufacturing Overhead $225,000

Advertising 45,000

Administrative 150,000

Total $420,000

Required:
i) Compute the number of units sold in 2017, using the equation method.

ii) Calculate Grange’s break-even point in units and in dollars.

iii) Calculate the margin of safety in number of units and sales dollars.

iv) Using the sales units calculated in (i), Construct a breakeven chart for Grange Manufacturing company, clearly showing the breakeven point and the margin of safety in units and dollars and the region representing profits and losses. ( use a scale of 2cm to represent 1,000 units on the x-axis and 2cm to represent 200,000 on the y-axis)

v) The president of Grange Manufacturing is under pressure from stockholders to increase operating income by 8% in 2018. Management expects per unit data and total fixed costs to remain the same in 2018. Compute the number of units that must be sold in 2018 to reach the shareholders’ desired profit level. Is this a realistic goal?

vi) Assume that Grange Manufacturing sells the same number of units in 2018 as it did in 2017. Assuming unit variable costs and total fixed costs remain unchanged, what would the selling price have to be in order to reach the stockholders’ desired profit level?

Solutions

Expert Solution

1) Equation Method
N = Number of Units required to Break Even
Sales - Variable costs - Fixed costs = Profit
Profit at the break-even point is zero
($200 x N) - ($80 x N) - $420,000 = 0
$200N - $80N = $420,000
N = $420,000/($200 - $80)	3,500	Units
Break Even Sales	3,500	units

2)
Contribution Margin = SP - VC = $200 - $80	$120.00
Contribution Ratio = (SP - VC) /SP= $200 - $80/$200	60.00%
BEP(Units) = FC/Contribution Units = $420,000/$120	3500.00	Units
BEP (Dollars) = FC/Contribution Ratio= $420,000/60%	$700,000.00

3)
Margin of Safety (Units) = Budgeted sales - Break-even sales
Margin of Safety (Units) = 6000 - 3500	2500.00	Units
Margin of Safety (Dollars) = $1,200,000 - $700,000	$500,000.00
Budgeted Sales
Sales volume in units = (Fixed costs + Desired profit )/Contribution Margin Per Unit
Sales volume in units = ($420,000 + $300,000)/$120	6000.00	units
Sales volume in Dollars = ($420,000 + $300,000)/60%	$1,200,000.00

ekkarill92 answered 11 months ago

Next > < Previous

Related Solutions

Grange Manufacturing Company had net income of $300,000 in 2017 when the selling price per unit...

Grange Manufacturing Company had net income of $300,000 in 2017 when the selling price per unit was $200 and data for variable and fixed costs were as follows: Cost Schedule: Variable Costs: Direct Material $28 Direct Labour $35 Variable Manufacturing Overhead $17 $80 Fixed Costs: Manufacturing Overhead $225,000 Advertising 45,000 Administrative 150,000 $420,000 Required: i) Compute the number of units sold in 2017, using the equation method. ii) Using the sales units calculated in (i), prepare a contribution margin income statement for...

Grange Manufacturing Company had net income of $300,000 in 2017 when the selling price per unit...

Grange Manufacturing Company had net income of $300,000 in 2017 when the selling price per unit was $200 and data for variable and fixed costs were as follows: Cost Schedule: Variable Costs: Direct Material $28 Direct Labour $35 Variable Manufacturing Overhead $17 $80 Fixed Costs: Manufacturing Overhead $225,000 Advertising 45,000 Administrative 150,000 $420,000 i) Compute the number of units sold in 2017, using the equation method. iv) Calculate the margin of safety in number of units and sales dollars. v) Using the sales...

Crane Company had $290,600 of net income in 2019 when the selling price per unit was...

Crane Company had $290,600 of net income in 2019 when the selling price per unit was $154, the variable costs per unit were $94, and the fixed costs were $573,400. Management expects per unit data and total fixed costs to remain the same in 2020. The president of Crane Company is under pressure from stockholders to increase net income by $57,600 in 2020. A. Compute the number of units sold in 2019 B. Compute the number of units that would...

Wildhorse Company had $278,700 of net income in 2019 when the selling price per unit was...

Wildhorse Company had $278,700 of net income in 2019 when the selling price per unit was $154, the variable costs per unit were $94, and the fixed costs were $573,300. Management expects per unit data and total fixed costs to remain the same in 2020. The president of Wildhorse Company is under pressure from stockholders to increase net income by $42,600 in 2020. A.)Compute the number of units sold in 2019. B.)Compute the number of units that would have to...

Ivanhoe Company had $177,900 of net income in 2019 when the selling price per unit was...

Ivanhoe Company had $177,900 of net income in 2019 when the selling price per unit was $154, the variable costs per unit were $98, and the fixed costs were $572,500. Management expects per unit data and total fixed costs to remain the same in 2020. The president of Ivanhoe Company is under pressure from stockholders to increase net income by $93,800 in 2020. Compute the number of units sold in 2019. Compute the number of units that would have to...

Blue Spruce Company had $152,600 of net income in 2016 when the selling price per unit...

Blue Spruce Company had $152,600 of net income in 2016 when the selling price per unit was $153, the variable costs per unit were $93, and the fixed costs were $573,300. Management expects per unit data and total fixed costs to remain the same in 2017. The president of Blue Spruce Company is under pressure from stockholders to increase net income by $61,700 in 2017. Assume that Blue Spruce Company sells the same number of units in 2017 as it...

E11-14 Naylor Company had $210,000 of net income in 2016 when the selling price per unit...

E11-14 Naylor Company had $210,000 of net income in 2016 when the selling price per unit was $150, the variable costs per unit were $90, and the fixed costs were $570,000.Management expects per unit data and total fixed costs to remain the same in 2017. The president of Naylor Company is under pressure from stockholders to increase net income by $52,000 in 2017. Instructions(a) Compute the number of units sold in 2016. (b) Compute the number of units that would...

G-Force Manufacturing Company had net income of $300,000 in 2017 when the number of units produced...

G-Force Manufacturing Company had net income of $300,000 in 2017 when the number of units produced and sold was 6,000 and data for variable and fixed costs were as follows: Cost Schedule: Variable Costs: Direct Material $35 Direct Labour $30 Variable Manufacturing Overhead $15 Fixed Costs: Manufacturing Overhead $232,000 Advertising 33,000 Administrative 155,000 Required: i) Compute the selling price per unit in 2017, using the equation method. ii) Using the sales price per unit calculated in (i), prepare a contribution...

In 2017, X Company had the following selling price and per-unit variable cost information: Selling price...

In 2017, X Company had the following selling price and per-unit variable cost information: Selling price $172 Variable manufacuting costs 85 Variable selling and administrative costs 22 In 2017, total fixed costs were $643,000. In 2018, there are only two expected changes. Direct material costs are expected to decrease by $8 per unit, and fixed selling and administrative costs are expected to increase by $10,000. What must unit sales be in order for X Company to break even in 2018?

Net Income Planning Nolden Company has charged a selling price of $24 per unit, incurred variable...

Net Income Planning Nolden Company has charged a selling price of $24 per unit, incurred variable costs of $15 per unit, and total fixed costs of $108,000. What unit sales volume is necessary to earn the following related amounts of net income before income tax? a. $18,000; b. $27,000; or c. equal to 20% of sales revenue. Round UP answers to the nearest unit, when applicable. (a) Answer units (b) Answer units (c) Answer units

Subjects