This was answered previously but the answer was incomplete. Requesting assistanc
ID: 2514260 • Letter: T
Question
This was answered previously but the answer was incomplete. Requesting assistance only with the 6th question
"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 ROls. Operating results for the company's Office Products Division for this year are given below: Sales Variable expenses Contribution margin Fixed expenses Net operating income Divisional average operating assets $ 22,235,800 13,981,800 8,253,200 6,100,890 2,153,200 4,625,808 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 $2,400,000. The cost and revenue characteristics of the new product line per year would be Sales Variable expenses Fixed expenses 59,600,000 65% of sales S2,582,400 Required 1. Compute the Office Products Division's ROl for this year 2. Compute the Office Products Division's ROl for the new product line by itself 3. Compute the Office Products Divislon's ROl for next year assuming that it performs the same as this year and adds the new product 4. If you were in Dell Havasi's position, would you accept or reject the new product line?Explanation / Answer
Answers
A
Net Operating Income
$ 21,53,200.00
B
Divisional Average operating assets
$ 46,25,000.00
C=A/B
ROI [Requirement 1 Answer]
46.56%
A
Sales
$ 96,00,000.00
B= A x [100% - 65%]
Contribution margin [9600000 x 35%]
$ 33,60,000.00
C
Fixed expenses
$ 25,82,400.00
D=B - C
Net Operating Income
$ 7,77,600.00
E
Operating Assets
$ 24,00,000.00
F=D/E
ROI [Requirement 2 Answer ]
32.40%
A
Combined Net Operating Income [2153200 + 777600]
$ 29,30,800.00
B
Combined Operating Assets [4625000 + 2400000]
$ 70,25,000.00
C=A/B
ROI [Requirement 3 Answer]
41.72%
I Would reject the new product line as it is clear from Requirement 3 that after the projected consideration of new product line, the overall ROI will decrease from 46.56% to 41.72%
A
Net Operating Income
$ 21,53,200.00
B
Divisional Average operating assets
$ 46,25,000.00
C=A/B
ROI [Requirement 1 Answer]
46.56%
A
Sales
$ 96,00,000.00
B= A x [100% - 65%]
Contribution margin [9600000 x 35%]
$ 33,60,000.00
C
Fixed expenses
$ 25,82,400.00
D=B - C
Net Operating Income
$ 7,77,600.00
E
Operating Assets
$ 24,00,000.00
F=D/E
ROI [Requirement 2 Answer ]
32.40%
A
Combined Net Operating Income [2153200 + 777600]
$ 29,30,800.00
B
Combined Operating Assets [4625000 + 2400000]
$ 70,25,000.00
C=A/B
ROI [Requirement 3 Answer]
41.72%
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.