Question

Please show any and all calculations. Thank you.

“I 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 this year are given below:

Sales $ 22,505,000 Variable expenses 14,105,500 Contribution margin 8,399,500 Fixed expenses 6,145,000 Net operating income $ 2,254,500 Divisional average operating assets $ 4,687,500

The company had an overall return on investment (ROI) of 17.00% this year (considering all divisions). Next year the Office Products Division has an opportunity to add a new product line that would require an additional investment that would increase average operating assets by $3,261,000. The cost and revenue characteristics of the new product line per year would be:

Sales $9,750,000 Variable expenses 65% of sales Fixed expenses $2,595,300

Required: 1. Compute the Office Products Division’s ROI for this year.

2. Compute the Office Products Division’s ROI for the new product line by itself.

3. Compute the Office Products Division’s ROI for next year assuming that it performs the same as this year and adds the new product line.

4. If you were in Dell Havasi’s position, would you accept or reject the new product line?

5. Why do you suppose headquarters is anxious for the Office Products Division to add the new product line?

6. Suppose that the company’s minimum required rate of return on operating assets is 14% and that performance is evaluated using residual income. a. Compute the Office Products Division’s residual income for this year. b. Compute the Office Products Division’s residual income for the new product line by itself. c. Compute the Office Products Division’s residual income for next year assuming that it performs the same as this year and adds the new product line. d. Using the residual income approach, if you were in Dell Havasi’s position, would you accept or reject the new product line?

Answer 1

income on new line
contribution (9,750,000*35%)=					3,412,500
less Fixed expense					-2,595,300
Net operating income					817200
1,2&3)				present	new line	total
	Sales			22,505,000	9,750,000	32,255,000
	Net operating income			2,254,500	817,200	3,071,700
	operating assets			4,687,500	3,261,000	7,948,500
	margin			10.02%	8.38%	9.52%
	turnover			4.80	2.99	4.06
	ROI			48.10%	25.06%	38.65%
	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,687,500	3,261,000	7,948,500
	minimum required return			14%	14%	14%
	min net opeerating income			656250	456540	1112790
	actual net operating income			2,254,500	817,200	3,071,700
	min net operating income			656250	456540	1112790
	residual income			1,598,250	360,660	1,958,910
b)	Accept