Question

In: Accounting

Exercise 5 Magnolia Company is considering the production and sale of a new product with the...

Exercise 5

Magnolia Company is considering the production and sale of a new product with the following sales and cost data: unit sales price, $350; unit variable costs, $180; total fixed costs, $399,500; and projected sales, $910,000. Round your answers to the nearest whole unit or dollar.

(a) Calculate break-even in units.

(b) Calculate break-even in dollars (use four decimal places when calculating the contribution margin ratio).

(c) Calculate number of units that would need to be sold to generate an after-tax profit of $420,000 assuming a 30% tax rate.

(d) Calculate dollar sales that would be needed to generate the same profit as above.

(e) Calculate the margin of safety stated as a percentage using the $910,000 projected sales level.

Be sure to label each calculation and show all calculations.

Solutions

Expert Solution

a) Calculation of break even point in units:
Contribution per unit= Selling price- variable cost per unit
                                         = 350-180=$170
Break even sale in units= Fixed cost/ contribution per unit
                                              = 399500/170=2350 units
Break even point in unit sales= 2350 units
b) Calculation of break even point in dollars:
Contribution Margin ratio= Contribution per unit/ Selling price*100= 170/350*100= 48.5714%
Contribution margin ratio= 48.5714%
Break even point in dollar sales= Fixed cost/ CM ratio
                                                               =399500/0.485714= $822500
Break even point in dollar sales=$822500
c) Calculation of number of units:
Profit= 420000*0.7= $294000
Number of units= (Fixed cost+ profit)/ contribution per unit
                                            =(294000+399500)/170=4079.41 units
Number of units= 4079 units
d) Calculation of dollar sales:
Dollar sales= units* selling price= 4079*350= $1427650
Dollar sales= $1427650
e) Calculation of margin of safety as a percentage of sales
Margin of safety= total sales- break even sales= 910000-822500= $87500
Margin of safety as a percentage of sales= 87500/910000*100=9.62%
Margin of safety as a percentage of sales=9.62%

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Exercise 5 Magnolia Company is considering the production and sale of a new product with the...
Exercise 5 Magnolia Company is considering the production and sale of a new product with the following sales and cost data: unit sales price, $350; unit variable costs, $180; total fixed costs, $399,500; and projected sales, $910,000. Round your answers to the nearest whole unit or dollar. (a) Calculate break-even in units. (b) Calculate break-even in dollars (use four decimal places when calculating the contribution margin ratio). (c) Calculate number of units that would need to be sold to generate...
A firm is considering a project that involves the production and sale of a new product...
A firm is considering a project that involves the production and sale of a new product over the next five years. This product's sales are expected to be 200000 units a year at a selling price of $80 per unit. The fixed operating expenses ( excluding depreciation ) are expected to increase by $8 million a year and variable operating expenses to decrease by $2 million a year. In addition, the product will require additional equipment to be purchased today...
A company is considering a 5-year project to expand production with the purchase of a new...
A company is considering a 5-year project to expand production with the purchase of a new automated machine using the latest technology. The new machine would cost $200,000 FOB St. Louis, with a shipping cost of $8,000 to the plant location. Installation expenses of $15,000 would also be required. This new machine would be classified as 7-year property for MACRS depreciation purposes. The project engineers anticipate that this equipment could be sold for salvage for $44,000 at the end of...
Suppose that a company is considering an investment in a new product with a 5-year horizon...
Suppose that a company is considering an investment in a new product with a 5-year horizon (product will be sold for 5 years). The upfront investment is $1 million and it is assumed to depreciate on a straight-line basis for 5 years, with no residual value. Fixed costs are assumed to be $50,000 per year. The company estimates the variable cost per unit (v) to be $5 and expects to sell each unit for $15. There are no taxes and...
Reid Company is considering the production of a new product. The expected variable cost is $23...
Reid Company is considering the production of a new product. The expected variable cost is $23 per unit. Annual fixed costs are expected to be $966,000. The anticipated sales price is $92 each. Required Determine the break-even point in units and dollars using each of the following: Use the equation method. Use the contribution margin per unit approach. Use the contribution margin ratio approach. (Do not round intermediate calculations. Round "Contribution margin ratio" to 1 decimal place. (i.e., 0.234 should...
Reid Company is considering the production of a new product. The expected variable cost is $27...
Reid Company is considering the production of a new product. The expected variable cost is $27 per unit. Annual fixed costs are expected to be $810,000. The anticipated sales price is $72 each. Determine the break-even point in units and dollars using each of the following: a. Use the equation method. b. Use the contribution margin per unit approach. c. Use the contribution margin ratio approach. (Do not round intermediate calculations. Round "Contribution margin ratio" to 1 decimal place. (i.e.,...
ABC plc has a new product ready for production and sale. Fixed costs of production (excluding...
ABC plc has a new product ready for production and sale. Fixed costs of production (excluding depreciation) are expected to be £200,000 a year. This figure is made up of £160,000 additional fixed costs and £40,000 fixed costs relating to the existing business which will be apportioned to the new product. The company estimates that the product will sell 150,000 units a year over the next five years. The sale price will be £5 per unit and variable costs are...
A company is considering a 5-year project to open a new product line. A new machine...
A company is considering a 5-year project to open a new product line. A new machine with an installed cost of $90,000 would be required to manufacture their new product, which is estimated to produce sales of $80,000 in new revenues each year. The cost of goods sold to produce these sales (not including depreciation) is estimated at 55% of sales, and the tax rate at this firm is 40%. If straight-line depreciation is used to calculate annual depreciation, what...
A company is considering a 5-year project that opens a new product line and requires an...
A company is considering a 5-year project that opens a new product line and requires an initial outlay of $81,000. The assumed selling price is $96 per unit, and the variable cost is $62 per unit. Fixed costs not including depreciation are $22,000 per year. Assume depreciation is calculated using stright-line down to zero salvage value. If the required rate of return is 13% per year, what is the financial break-even point? (Answer to the nearest whole unit.) Detailed explanation...
X Company is planning to stop the production and sale of Product Q, which lost $12,000...
X Company is planning to stop the production and sale of Product Q, which lost $12,000 last year. If Product Q is dropped, two things will happen in each of the next four years: 1) last year's loss will be avoided, and 2) sales of Product R will be increased, contributing $12,000 to annual profits. In addition, if Product Q is dropped, the company will be able to sell some equipment immediately for $17,000. Assuming a discount rate of 4%,...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT