Question

In: Accounting

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 1 year 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...
G Force Manufacturing Company had net income of $300,000 in 2017 when the number of units...
G Force Manufacturing Company had net income of $300,000 in 2017 when the number of units produced and sold was 6000 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: Compute the selling price per unit in 2017, using the equation method. Using the sales price per unit calculated...
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?
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT