Question

In: Accounting

Total Unit Sales $ 992,000 $ 49.60 Variable expenses 595,200 29.76 Contribution margin 396,800 19.84 Fixed...

Total Unit
Sales $ 992,000 $ 49.60
Variable expenses 595,200 29.76
Contribution margin 396,800 19.84
Fixed expenses 316,800 15.84
Net operating income 80,000 4.00
Income taxes @ 40% 32,000 1.60
Net income $ 48,000 $ 2.40

The company had average operating assets of $506,000 during the year.

1. Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms of margin and turnover.

For each of the following questions, indicate whether the margin and turnover will increase, decrease, or remain unchanged as a result of the events described, and then compute the new ROI figure. Consider each question separately, starting in each case from the data used to compute the original ROI in (1) above.

2. Using Lean Production, the company is able to reduce the average level of inventory by $98,000. (The released funds are used to pay off short-term creditors.)

3. The company achieves a cost savings of $10,000 per year by using less costly materials.

4. The company issues bonds and uses the proceeds to purchase machinery and equipment that increases average operating assets by $127,000. Interest on the bonds is $16,000 per year. Sales remain unchanged. The new, more efficient equipment reduces production costs by $6,000 per year.

5. As a result of a more intense effort by sales people, sales are increased by 20%; operating assets remain unchanged.

6. At the beginning of the year, obsolete inventory carried on the books at a cost of $17,000 is scrapped and written off as a loss.

7. At the beginning of the year, the company uses $176,000 of cash (received on accounts receivable) to repurchase and retire some of its common stock.

Solutions

Expert Solution

1) Margin= Net operating income/Sales

= $80000*100/992000= 8.06%

Turnover= Sales/Average operating assets

= $992000/506000= 1.96 times

ROI= Margin*Turnover

= 8.06%*1.96= 15.80%

2) If the company reduces the average level of inventory by $98000, the average operating assets of the company will also reduced by $98000. So, the new average operating assets

= $506000-98000= $408000

Margin= Net operating income/Sales

= $80000*100/992000= 8.06%

Turnover= Sales/Average operating assets

= $992000/408000= 2.43 times

ROI= Margin*Turnover

=8.06%*2.43= 19.59%

Margin 8.06 % Unchanged
Turnover 2.43 times Increase
ROI 19.59 % Increase

3) If the company achieves a cost saving of $10000 per year, the net operating income of the company will also increases by $10000

New net operating income= $80000+10000= $90000

Margin= Net operating income/Sales

= $90000*100/992000= 9.07%

Turnover= Sales/Average operating assets

= $992000/506000= 1.96 times

ROI= Margin*Turnover

= 9.07%*1.96= 17.78%

Margin 9.07 % Increase
Turnover 1.96 times Unchanged
ROI 17.78 % Increase

4) If the company issue bonds and uses the proceeds to purchase the machinery and equipment for $127000, the average operating assets of the company will increases by $127000. And as the production costs will reduces by $6000 per year the net operating income will increases by $6000 per year. So, the new average operating assets and net operating income will be

New average operating assets= $506000+127000= $633000

New net operating income= $80000+6000= $86000

Margin= Net operating income/Sales

= $86000*100/992000= 8.67%

Turnover= Sales/Average operating assets

= $992000/633000= 1.57 times

ROI= Margin*Turnover

= 8.67%*1.57= 13.61%

Margin 8.67 % Increase
Turnover 1.57 times Decrease
ROI 13.61 % Decrease

5)

Sales (992000*1.20) $1190400
Variable expenses 714240
Contribution margin 476160
Fixed expenses 316800
Net operating income $159360

Variable expenses= $(595200/992000)*1190400= $714240

Margin= Net operating income/Sales

= $159360*100/1190400= 13.39%

Turnover= Sales/Average operating assets

= $1190400/506000= 2.35 times

ROI= Margin*Turnover

= 13.39%*2.35= 31.47%

Margin 13.39 % Increase
Turnover 2.35 times Increase
ROI 31.47 % Increase

6) If the obsolete inventory $17000 is scrapped the net operating income and average operating assets will also reduce by $17000

New net operating income= $80000-17000= $63000

New average operating assets= $506000-17000= $489000

Margin= Net operating income/Sales

= $63000*100/992000= 6.35%

Turnover= Sales/Average operating assets

= $992000/489000= 2.03 times

ROI= Margin*Turnover

= 6.35%*2.03= 12.89%

Margin 6.35 % Decrease
Turnover 2.03 times Increase
ROI 12.89 % Decrease

7) If the company uses cash $176000 to repurchase and retire its common stock, the average operating assets will decrease by $176000

New average operating assets= $506000-176000= $330000

Margin= Net operating income/Sales

= $80000*100/992000= 8.06%

Turnover= Sales/Average operating assets

= $992000/330000= 3.01 times

ROI= Margin*Turnover

= 8.06%*3.01= 24.26%

Margin 8.06 % Unchanged
Turnover 3.01 times Increase
ROI 24.26 % Increase

Related Solutions

1). Contribution Margin is: a). Sales - Total Variable expenses b). Sales - Total variable expenses...
1). Contribution Margin is: a). Sales - Total Variable expenses b). Sales - Total variable expenses - Total fixed expenses c). Sales revenue per unit x Sales quantity d). Variable expense per unit x Sales quantity 2). When preparing segmented income statements fixed expense are separated into the following categories: a). Traceable and common b).Fixed and Variable c).Direct and indirect d).Product and period 3).A Co. reported: Sales $125000; Contribution margin $62000; Total fixed expenses $42000; Common fixed expenses $15000. How...
Total Per Unit Sales $ 318,000 $ 20 Variable expenses 222,600 14 Contribution margin 95,400 $...
Total Per Unit Sales $ 318,000 $ 20 Variable expenses 222,600 14 Contribution margin 95,400 $ 6 Fixed expenses 72,600 Net operating income $ 22,800 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin at the break-even point? 3-a. How many units would have to be sold each month to attain a target profit of $39,600? 3-b. Verify your answer by preparing a...
Sales (13,000 units × $20 per unit) $ 260,000 Variable expenses 156,000 Contribution margin 104,000 Fixed...
Sales (13,000 units × $20 per unit) $ 260,000 Variable expenses 156,000 Contribution margin 104,000 Fixed expenses 116,000 Net operating loss $ (12,000 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes that a $6,500 increase in the monthly advertising budget, combined with an intensified effort by the sales staff, will result in an $80,000 increase in monthly sales. If the president is right, what will be...
Sales (13,000 units × $20 per unit) $ 260,000 Variable expenses 130,000 Contribution margin 130,000 Fixed...
Sales (13,000 units × $20 per unit) $ 260,000 Variable expenses 130,000 Contribution margin 130,000 Fixed expenses 145,000 Net operating loss $ (15,000) 1 Refer to the original data. By automating, the company could reduce variable expenses $3 per unit . However, fixed expenses would increase by $52,000 each month. a. Compute the new CM ratio and the new break-even point in both unit sales and dollar sales. (Use the CM ratio to calculate your break-even point in dollars. Round...
Sales (12,800 units × $30 per unit) $ 384,000 Variable expenses 192,000 Contribution margin 192,000 Fixed...
Sales (12,800 units × $30 per unit) $ 384,000 Variable expenses 192,000 Contribution margin 192,000 Fixed expenses 214,500 Net operating loss $ (22,500 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes that a $6,600 increase in the monthly advertising budget, combined with an intensified effort by the sales staff, will increase unit sales and the total sales by $89,000 per month. If the president is right,...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the following independent situations, calculate the amount(s) required. Required: 1. At the break-even point, Jefferson Company sells 85,000 units and has fixed cost of $348,600. The variable cost per unit is $0.35. What price does Jefferson charge per unit? Note: Round to the nearest cent. $ 2. Sooner Industries charges a price of $127 and has fixed cost of $360,500. Next year, Sooner expects to...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the following independent situations, calculate the amount(s) required. Required: 1. At the break-even point, Jefferson Company sells 95,000 units and has fixed cost of $349,700. The variable cost per unit is $0.15. What price does Jefferson charge per unit? Note: Round to the nearest cent. $ 2. Sooner Industries charges a price of $129 and has fixed cost of $421,000. Next year, Sooner expects to...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the following independent situations, calculate the amount(s) required. Required: 1. At the break-even point, Jefferson Company sells 85,000 units and has fixed cost of $351,900. The variable cost per unit is $0.30. What price does Jefferson charge per unit? Note: Round to the nearest cent. $ 2. Sooner Industries charges a price of $136 and has fixed cost of $391,500. Next year, Sooner expects to...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the following independent situations, calculate the amount(s) required. Required: 1. At the break-even point, Jefferson Company sells 85,000 units and has fixed cost of $346,500. The variable cost per unit is $0.10. What price does Jefferson charge per unit? Note: Round to the nearest cent. $ 2. Sooner Industries charges a price of $98 and has fixed cost of $476,500. Next year, Sooner expects to...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the...
Price, Variable Cost per Unit, Contribution Margin, Contribution Margin Ratio, Fixed Expense For each of the following independent situations, calculate the amount(s) required. Required: 1. At the break-even point, Jefferson Company sells 115,000 units and has fixed cost of $346,800. The variable cost per unit is $0.10. What price does Jefferson charge per unit? Note: Round to the nearest cent. $ 2. Sooner Industries charges a price of $116 and has fixed cost of $395,500. Next year, Sooner expects to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT