Question

In: Accounting

Selected operating data for two divisions of Outback Brewing, Ltd., of Australia are given below: Division...

Selected operating data for two divisions of Outback Brewing, Ltd., of Australia are given below:

Division
Queensland New South Wales
Sales $ 864,000 $ 2,016,000
Average operating assets $ 540,000 $ 630,000
Net operating income $ 60,480 $ 80,640
Property, plant, and equipment (net) $ 247,000 $ 197,000

Required:

1. Compute the rate of return for each division using the return on investment (ROI) formula stated in terms of margin and turnover.

2. Which divisional manager seems to be doing the better job?

Solutions

Expert Solution

Return on investment AKA ROI) is a measurement of performance which shows the returns on the average operating assets.
Formula to Calculate ROI = Margin X TurnOver   ( Note Margin in % and Turn Over in Ratio )
Where Margin = Net operating income / Sales   & TurnOver = Sales / Average operating assets
Below is the Calculation
Queensland New South Wales
A   Sales 8,64,000 20,16,000
B   Average operating assets 5,40,000 6,30,000
C   Net operating income 60,480 80,640
D   Property, plant, and equipment (net) 2,47,000 1,97,000
M Margin % (C/A) 7.00% 4.00%
T Turnover (A/B) 1.6 3.2
ROI (MXT) Return on investment 11.20% 12.80%
1)
Margin Turnover ROI
Queensland 7.00% 1.6 11.20%
New South Wales 4.00% 3.2 12.80%
2) Divisional manager of New South Wales is doing the better job as the ROI is greater for New South Wales

Related Solutions

Selected operating data for two divisions of Outback Brewing, Ltd., of Australia are given below: Division...
Selected operating data for two divisions of Outback Brewing, Ltd., of Australia are given below: Division Queensland New South Wales Sales $ 2,176,000 $ 3,445,000 Average operating assets $ 640,000 $ 650,000 Net operating income $ 250,240 $ 275,600 Property, plant, and equipment (net) $ 264,000 $ 214,000 Required: 1. Compute the rate of return for each division using the return on investment (ROI) formula stated in terms of margin and turnover. 2. Which divisional manager seems to be doing...
Selected sales and operating data for three divisions of different structural engineering firms are given as...
Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C Sales $ 12,000,000 $ 14,000,000 $ 25,000,000 Average operating assets $ 3,000,000 $ 7,000,000 $ 5,000,000 Net operating income $ 600,000 $ 560,000 $ 800,000 Minimum required rate of return 14 % 10 % 16 % Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover....
Selected sales and operating data for three divisions of different structural engineering firms are given as...
Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C Sales $ 12,600,000 $ 35,750,000 $ 20,600,000 Average operating assets $ 3,150,000 $ 7,150,000 $ 5,150,000 Net operating income $ 516,600 $ 572,000 $ 597,400 Minimum required rate of return 9.00 % 9.50 % 11.60 % Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover....
Selected sales and operating data for three divisions of different structural engineering firms are given as...
Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C Sales $ 5,100,000 $ 9,100,000 $ 8,200,000 Average operating assets $ 1,020,000 $ 2,275,000 $ 1,640,000 Net operating income $ 214,200 $ 746,200 $ 118,900 Minimum required rate of return 17.00 % 32.80 % 14.00 % Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover....
Selected sales and operating data for three divisions of different structural engineering firms are given as...
Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C Sales $ 12,280,000 $ 35,350,000 $ 20,280,000 Average operating assets $ 3,070,000 $ 7,070,000 $ 5,070,000 Net operating income $ 601,720 $ 600,950 $ 567,840 Minimum required rate of return 10.00 % 10.50 % 11.20 % Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover....
Selected sales and operating data for three divisions of different structural engineering firms are given as...
Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C Sales $ 12,360,000 $ 28,360,000 $ 25,450,000 Average operating assets $ 3,090,000 $ 7,090,000 $ 5,090,000 Net operating income $ 494,400 $ 453,760 $ 636,250 Minimum required rate of return 7.00 % 7.50 % 12.50 % Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover....
Selected sales and operating data for three divisions of different structural engineering firms are given as...
Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C Sales $ 12,120,000 $ 28,120,000 $ 20,120,000 Average operating assets $ 3,030,000 $ 7,030,000 $ 5,030,000 Net operating income $ 496,920 $ 449,920 $ 503,000 Minimum required rate of return 7.00 % 7.50 % 10.00 % Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover....
Selected sales and operating data for three divisions of different structural engineering firms are given as...
Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C Sales $ 16,000,000 $ 36,000,000 $ 20,800,000 Average operating assets $ 3,200,000 $ 7,200,000 $ 5,200,000 Net operating income $ 752,000 $ 576,000 $ 540,800 Minimum required rate of return 9.00 % 9.50 % 10.40 % Required: 1. Compute the margin, turnover, and return on investment (ROI) for each division. 2. Compute the residual income (loss) for...
Selected sales and operating data for three divisions of different structural engineering firms are given as...
Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C   Sales $ 5,600,000 $ 9,600,000 $ 8,700,000   Average operating assets $ 1,120,000 $ 3,200,000 $ 1,740,000   Net operating income $ 263,200 $ 835,200 $ 169,650   Minimum required rate of return 16.00 % 26.10 % 13.00 % Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and turnover....
Selected sales and operating data for three divisions of different structural engineering firms are given as...
Selected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C Sales $ 6,900,000 $ 10,900,000 $ 10,000,000 Average operating assets $ 1,725,000 $ 5,450,000 $ 2,500,000 Net operating income $ 414,000 $ 1,090,000 $ 325,000 Minimum required rate of return 19.00 % 20.00 % 16.00 %      Required: 1. Compute the return on investment (ROI) for each division using the formula stated in terms of margin and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT