Question

In: Accounting

The Blue division of the Leaf Company reported the following data for the current year: Sales...

The Blue division of the Leaf Company reported the following data for the current year:

Sales $2,600,000
Variable Costs $2,100,000
Controllable Fixed Costs $450,000
Average Operating Assets $5,050,000

Senior Management is unhappy with the investment centre’s return on investment. It asks the manager of the Blue division to submit plans to improve the ROI in the next year. The manager believes it is reasonable to consider each of the following independent courses of action

1. Increase sales by $270,000 with no change in the contribution margin percentage

2. Reduce variable costs by $120,000 3. Reduce average operating assets by 4.5%

3. Reduce average operating assets by 4.5%

Required :

a. Calculate the return on investment for the current year.

b. Using the ROI formula, calculate the ROI under each of the proposed courses of action (Round to one decimal)

Solutions

Expert Solution

a. Calculate the return on investment for the current year.

Net income= Sales-Variable costs-Controllable Fixed Costs

= $2600000-2100000-450000= $50000

ROI= Net income/Average operating assets

= $50000*100/5050000= 0.99% or 1%

b. Using the ROI formula, calculate the ROI under each of the proposed courses of action (Round to one decimal)

1. Increase sales by $270,000 with no change in the contribution margin percentage

Sales (2600000+270000) $2870000
Less: Variable costs (2100000*2870000/2600000) 2318077
Contribution margin 551923
Less: Fixed costs 450000
Net income $101923

ROI= Net income/Average operating assets

= $101923*100/5050000= 2.0%

2. Reduce variable costs by $120000

Sales $2600000
Less: Variable costs (2100000-120000) 1980000
Contribution margin 620000
Less: Fixed costs 450000
Net income $170000

ROI= Net income/Average operating assets

= $170000*100/5050000= 3.4%

3. Reduce average operating assets by 4.5%

New average operating assets= $5050000*95.5%= $4822750

ROI= Net income/Average operating assets

= $50000*100/4822750= 1.04%


Related Solutions

The South Division of Wiig Company reported the following data for the current year. Sales $2,950,000...
The South Division of Wiig Company reported the following data for the current year. Sales $2,950,000 Variable costs 1,947,000 Controllable fixed costs 605,000 Average operating assets 5,000,000 Top management is unhappy with the investment center’s return on investment (ROI). It asks the manager of the South Division to submit plans to improve ROI in the next year. The manager believes it is feasible to consider the following independent courses of action. 1. Increase sales by $300,000 with no change in...
The South Division of Bonita Company reported the following data for the current year. Sales $3,000,000...
The South Division of Bonita Company reported the following data for the current year. Sales $3,000,000 Variable costs 1,980,000 Controllable fixed costs 600,000 Average operating assets 5,000,000 Top management is unhappy with the investment center’s return on investment (ROI). It asks the manager of the South Division to submit plans to improve ROI in the next year. The manager believes it is feasible to consider the following independent courses of action. 1. Increase sales by $300,000 with no change in...
Exercise 10-17 (Video) The South Division of Wiig Company reported the following data for the current...
Exercise 10-17 (Video) The South Division of Wiig Company reported the following data for the current year. Sales $3,000,000 Variable costs 1,980,000 Controllable fixed costs 595,000 Average operating assets 5,000,000 Top management is unhappy with the investment center’s return on investment (ROI). It asks the manager of the South Division to submit plans to improve ROI in the next year. The manager believes it is feasible to consider the following independent courses of action. 1. Increase sales by $300,000 with...
The following data is related to sales and production for Blue sky company for last year....
The following data is related to sales and production for Blue sky company for last year. Selling price per unit $140 Variable manufacturing costs per unit $62 Variable selling and administrative expenses per unit $6 Fixed manufacturing overhead (in total) $32,000 Fixed selling and administrative expenses (in total) $6000 Units produced during the year 2000 Units sold during year 900 a) Using variable costing, what is the operating income for last year? b) Management is considering the following courses of...
Blue Elk Manufacturing reported sales of $743,000 at the end of last year; but this year,...
Blue Elk Manufacturing reported sales of $743,000 at the end of last year; but this year, sales are expected to grow by 6%. Blue Elkexpects to maintain its current profit margin of 22% and dividend payout ratio of 20%. The firm’s total assets equaled $500,000 and were operated at full capacity. Blue Elk’s balance sheet shows the following current liabilities: accounts payable of $80,000, notes payable of $35,000, and accrued liabilities of $60,000. Based on the AFN (Additional Funds Needed)...
Blue Elk Manufacturing reported sales of $720,000 at the end of last year, but this year,...
Blue Elk Manufacturing reported sales of $720,000 at the end of last year, but this year, sales are expected to grow by 7%. Blue Elk expects to maintain its current profit margin of 21% and dividend payout ratio of 30%. The following information was taken from Blue Elk’s balance sheet: Total assets: $400,000 Accounts payable: $80,000 Notes payable: $35,000 Accrued liabilities: $70,000 Based on the AFN equation, the firm’s AFN for the current year is _________. a. -86,174 b. -105,324...
Blue Elk Manufacturing reported sales of $720,000 at the end of last year, but this year,...
Blue Elk Manufacturing reported sales of $720,000 at the end of last year, but this year, sales are expected to grow by 8%. Blue Elk expects to maintain its current profit margin of 23% and dividend payout ratio of 10%. The following information was taken from Blue Elk’s balance sheet: Total assets: $400,000 Accounts payable: $80,000 Notes payable: $45,000 Accrued liabilities: $80,000 Based on the AFN equation, the firm’s AFN for the current year is _____ . A positively signed...
Lopez Company reported the following current-year data for its only product. The company uses a periodic...
Lopez Company reported the following current-year data for its only product. The company uses a periodic inventory system, and its ending inventory consists of 360 units—120 from each of the last three purchases. Jan. 1 Beginning inventory 220 units @ $2.80 = $ 616 Mar. 7 Purchase 480 units @ $3.25 = 1,560 July 28 Purchase 1,120 units @ $3.30 = 3,696 Oct. 3 Purchase 1,000 units @ $3.60 = 3,600 Dec. 19 Purchase 400 units @ $3.70 = 1,480...
The Deluxe Division, a profit center of Riley Manufacturing Company, reported the following data for the...
The Deluxe Division, a profit center of Riley Manufacturing Company, reported the following data for the first quarter of 2013:                 Sales      $9,000,000                 Variable costs    6,300,000                 Controllable direct fixed costs    1,200,000                 Noncontrollable direct fixed costs             530,000                 Indirect fixed costs          300,000 Instructions (a)          Prepare a performance report for the manager of the Deluxe Division. (b)          What is the best measure of the manager's performance? Why? (c)           How would the responsibility report differ if the division was an...
The Omaha Division, an investment center of Nebraska Manufacturing Company, reported the following data for the...
The Omaha Division, an investment center of Nebraska Manufacturing Company, reported the following data for the current year.                         Sales                                             $4,000,000                         Variable costs                                 2,400,000                         Controllable fixed costs                     300,000                         Noncontrollable fixed costs               400,000                         Average operating assets              3,600,000 Top management is unhappy with the center's return on investment (ROI). The manager of the Omaha Division believes ROI can be improved by the following independent alternatives: Increase sales by 15% with no change in the contribution margin ratio. Reduce controllable and noncontrollable fixed costs 30% each. Reduce average operating...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT