In: Accounting
know headquarters wants us to add that new product line,” said Dell Havasi, manager of Billings Company’s Office Products Division. “But I want to see the numbers before I make any move. Our division’s return on investment (ROI) has led the company for three years, and I don’t want any letdown.” |
Billings Company is a decentralized wholesaler with five autonomous divisions. The divisions are evaluated on the basis of ROI, with year-end bonuses given to the divisional managers who have the highest ROIs. Operating results for the company’s Office Products Division for the most recent year are given below: |
Sales | $ | 22,000,000 |
Variable expenses | 13,500,000 | |
Contribution margin | 8,500,000 | |
Fixed expenses | 6,000,000 | |
Net operating income | $ | 2,500,000 |
Divisional operating assets | $ | 4,443,500 |
The company had an overall return on investment (ROI) of 16.00% last year (considering all divisions). The Office Products Division has an opportunity to add a new product line that would require an additional investment in operating assets of $2,289,300. The cost and revenue characteristics of the new product line per year would be: |
Sales | $ 9,155,000 |
Variable expenses | 65% of sales |
Fixed expenses | $ 2,543,950 |
Required: | |
1. |
Compute the Office Products Division’s ROI for the most recent year; also compute the ROI as it would appear if the new product line is added. (Do not round intermediate calculations. Round your Turnover answers to 2 decimal places. Round your Margin and ROI percentage answers to 2 decimal places (i.e., 0.1234 should be entered as 12.34).) |
2. |
If you were in Dell Havasi’s position, would you accept or reject the new product line? |
||||
|
3. |
Why do you suppose headquarters is anxious for the Office Products Division to add the new product line? |
||||
|
4. |
Suppose that the company’s minimum required rate of return on operating assets is 13.00% and that performance is evaluated using residual income. |
a. |
Compute the Office Products Division’s residual income for the most recent year; also compute the residual income as it would appear if the new product line is added. (Enter your Minimum Required Rate as a whole percentage (i.e., 0.12 should be entered as 12).) |
b. |
Under these circumstances, if you were in Dell Havasi’s position, would you accept or reject the new product line? |
||||
|
income on new line | ||||||||
contribution (11,140,000*35%)= | 3,204,250 | |||||||
less Fixed expense | -2,543,950 | |||||||
Net operating income | 660300 | |||||||
1,2&3) | present | new line | total | |||||
Sales | 22,000,000 | 9,155,000 | 31,155,000 | |||||
Net operating income | 2,500,000 | 660,300 | 3,160,300 | |||||
operating assets | 4,443,500 | 2,289,300 | 6,732,800 | |||||
margin | 11.36% | 7.21% | 10.14% | |||||
turnover | 4.95 | 4.00 | 4.63 | |||||
ROI | 56.26% | 28.84% | 46.94% | |||||
where margin = net operating income/sales | ||||||||
turnover = sale/average operating assets | ||||||||
ROI = margin *turnover | ||||||||
4) | Reject | |||||||
5) | Addint the new product line would improve overall ROI | |||||||
6) | Residual income = net operating income -(average assets *min rate or return) | |||||||
present | new line | total | ||||||
operating assets | 4,443,500 | 2,289,300 | 6,732,800 | |||||
minimum required return | 13% | 13% | 13% | |||||
min net opeerating income | 577655 | 297609 | 875264 | |||||
actual net operating income | 2,500,000 | 660,300 | 3,160,300 | |||||
min net operating income | 577655 | 297609 | 875264 | |||||
residual income | 1,922,345 | 362,691 | 2,285,036 | |||||
b) | Accept | |||||||