Question

In: Accounting

Midlands Inc. had a bad year in 2016. For the first time in its history, it...

Midlands Inc. had a bad year in 2016. For the first time in its history, it operated at a loss. The company’s income statement showed the following results from selling 79,000 units of product: net sales $1,975,000; total costs and expenses $1,805,000; and net loss $170,000. Costs and expenses consisted of the following.

Total

Variable

Fixed

Cost of goods sold $1,148,000 $645,000 $503,000
Selling expenses 510,000 90,000 420,000
Administrative expenses 147,000 55,000 92,000
$1,805,000 $790,000 $1,015,000

Management is considering the following independent alternatives for 2017.
1. Increase unit selling price 30% with no change in costs and expenses.
2. Change the compensation of salespersons from fixed annual salaries totaling $205,000 to total salaries of $36,000 plus a 5% commission on net sales.
3. Purchase new high-tech factory machinery that will change the proportion between variable and fixed cost of goods sold to 50:50. COMPUTE THE BREAK-EVEN POINT IN DOLLARS UNDER EACH OF THE ALTERNATIVE COURSES OF ACTION FOR 2017. I don't care about showing work at this point, just give answers ASAP please.

Solutions

Expert Solution

Solution 1:

Current selling price = $1,975,000 / 79000 = $25 per unit

Current variable cost per unit = $790,000 / 79000 = $10 per unit

Existing contribution margin per unit = $25 - $10 = $15 per unit

Existing fixed cost = $1,015,000

If selling price will be increase by 30% then revised selling price = $25*130% = $32.50

Revised contribution per unit = $32.50 - $10 = $22.50

New contribution margin ratio = $22.50 / $32.50 = 69.23%

Breakeven point in dollar = $1,015,000 / 69.23% = $1,466,127

Solution 2:

Due to change in compensation of sales person from fixed annual salaries totalling $205,000 to total salaries of $36,000 plus a 5% commission on net sales, fixed cost will decrease by $169,000 ( $205,000 - $36,000) and variable cost will increase by $1.25 ($25*5%) per unit

New variable cost per unit = $10 + $1.25 = $11.25

New Fixed cost = $1,015,000 - $169,000 = $846,000

New Contribution margin per unit = $25 - $11.25 = $13.75

New contribution margin ratio = $13.75 / $25 = 55%

Breakeven point in sales dollar = $846,000 / 55% = $1,538,182

Solution 3:

New variable cost of good sold due to high tech machinery = $1,148,000*50% = $574,000

New fixed cost of goods sold = $1,148,000*50% = $574,000

New total variable cost = $574,000 + $90,000 + $55,000 = $719,000

New Total fixed cost = $574,000 + $420,000 + $92,000 = $1,086,000

New contribution = $1,975,000 - $719,000 = $1,256,000

New contribution margin ratio = $1,256,000 / $1,975,000 = 63.59493%

Breakeven sales in dollar = Fixed cost / contribution margin ratio = $1,086,000 / 63.59493% = $1,707,683


Related Solutions

Midlands Inc. had a bad year in 2016. For the first time in its history, it...
Midlands Inc. had a bad year in 2016. For the first time in its history, it operated at a loss. The company’s income statement showed the following results from selling  79,000 units of product: net sales $ 1,975,000; total costs and expenses $ 1,805,000; and net loss $ -170,000. Costs and expenses consisted of the following. Total Variable Fixed Cost of goods sold $ 1,148,000 $ 645,000 $ 503,000 Selling expenses 510,000 90,000 420,000 Administrative expenses 147,000 55,000 92,000 $ 1,805,000...
Midlands Inc. had a bad year in 2016. For the first time in its history, it...
Midlands Inc. had a bad year in 2016. For the first time in its history, it operated at a loss. The company’s income statement showed the following results from selling 77,000 units of product: net sales $2,310,000; total costs and expenses $2,180,000; and net loss $-130,000. Costs and expenses consisted of the following. Total Variable Fixed Cost of goods sold $1,505,000 $1,003,000 $502,000 Selling expenses 522,000 92,000 430,000 Administrative expenses 153,000 60,000 93,000 $2,180,000 $1,155,000 $1,025,000 Management is considering the...
Midlands Inc. had a bad year in 2019. For the first time in its history, it...
Midlands Inc. had a bad year in 2019. For the first time in its history, it operated at a loss. The company’s income statement showed the following results from selling 79,000 units of product: net sales $1,580,000; total costs and expenses $1,637,040; and net loss $57,040. Costs and expenses consisted of the following. Total Variable Fixed Cost of goods sold 972000 486000 486000 Selling expenses 517040 90000 427040 Admin expenses 148000 56000 92000 Total 1637040 632000 1005040 Management is considering...
Midlands Inc. had a bad year in 2019. For the first time in its history, it...
Midlands Inc. had a bad year in 2019. For the first time in its history, it operated at a loss. The company’s income statement showed the following results from selling 79,000 units of product: net sales $1,580,000; total costs and expenses $1,829,800; and net loss $249,800. Costs and expenses consisted of the following. Total Variable Fixed Cost of goods sold $1,163,400 $637,000 $526,400 Selling expenses 516,400 93,000 423,400 Administrative expenses 150,000 60,000 90,000 $1,829,800 $790,000 $1,039,800 Management is considering the...
Midlands Inc. had a bad year in 2019. For the first time in its history, it...
Midlands Inc. had a bad year in 2019. For the first time in its history, it operated at a loss. The company’s income statement showed the following results from selling 77,000 units of product: net sales $1,540,000; total costs and expenses $1,964,000; and net loss $424,000. Costs and expenses consisted of the following. Total Variable Fixed Cost of goods sold $1,299,600 $773,000 $526,600 Selling expenses 513,400 93,000 420,400 Administrative expenses 151,000 58,000 93,000 $1,964,000 $924,000 $1,040,000 Management is considering the...
Midlands Inc. had a bad year in 2019. For the first time in its history, it...
Midlands Inc. had a bad year in 2019. For the first time in its history, it operated at a loss. The company’s income statement showed the following results from selling 78,000 units of product: net sales $1,560,000; total costs and expenses $1,789,800; and net loss $229,800. Costs and expenses consisted of the following. Total Variable Fixed Cost of goods sold $1,129,600 $635,000 $494,600 Selling expenses 513,200 90,000 423,200 Administrative expenses 147,000 55,000 92,000 $1,789,800 $780,000 $1,009,800 Management is considering the...
Midlands Inc. had a bad year in 2019. For the first time in its history, it...
Midlands Inc. had a bad year in 2019. For the first time in its history, it operated at a loss. The company’s income statement showed the following results from selling 78,000 units of product: net sales $1,560,000; total costs and expenses $1,976,000; and net loss $416,000. Costs and expenses consisted of the following. Total Variable Fixed Cost of goods sold $1,320,400 $785,000 $535,400 Selling expenses 504,600 91,000 413,600 Administrative expenses 151,000 60,000 91,000 $1,976,000 $936,000 $1,040,000 Management is considering the...
Midlands Inc. had a bad year in 2019. For the first time in its history, it...
Midlands Inc. had a bad year in 2019. For the first time in its history, it operated at a loss. The company’s income statement showed the following results from selling 79,000 units of product: net sales $1,580,000; total costs and expenses $1,637,040; and net loss $57,040. Costs and expenses consisted of the following. Total Variable Fixed Cost of goods sold $972,000 $486,000 $486,000 Selling expenses 517,040 90,000 427,040 Administrative expenses 148,000 56,000 92,000 $1,637,040 $632,000 $1,005,040 Management is considering the...
Midlands Inc. had a bad year in 2019. For the first time in its history, it...
Midlands Inc. had a bad year in 2019. For the first time in its history, it operated at a loss. The company’s income statement showed the following results from selling 75,000 units of product: net sales $1,500,000; total costs and expenses $1,750,200; and net loss $250,200. Costs and expenses consisted of the following. Total Variable Fixed Cost of goods sold $1,080,000 $600,000 $480,000 Selling expenses 520,200 95,000 425,200 Administrative expenses 150,000 55,000 95,000 $1,750,200 $750,000 $1,000,200 Management is considering the...
Midlands Inc. had a bad year in 2019. For the first time in its history, it...
Midlands Inc. had a bad year in 2019. For the first time in its history, it operated at a loss. The company’s income statement showed the following results from selling 76,000 units of product: net sales $1,520,000; total costs and expenses $1,780,000; and net loss $260,000. Costs and expenses consisted of the following. Total Variable Fixed Cost of goods sold $1,115,600 $611,000 $504,600 Selling expenses 515,400 93,000 422,400 Administrative expenses 149,000 56,000 93,000 $1,780,000 $760,000 $1,020,000 Management is considering the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT