Question

In: Accounting

Optimus Company manufactures a variety of tools and industrial equipment. The company operates through three divisions....

Optimus Company manufactures a variety of tools and industrial equipment. The company operates through three divisions. Each division is an investment center. Operating data for the Home Division for the year ended December 31, 2020, and relevant budget data are as follows.

Actual

Comparison with Budget

Sales $1,401,000 $101,000 favorable
Variable cost of goods sold 680,000 55,000 unfavorable
Variable selling and administrative expenses 125,000 26,000 unfavorable
Controllable fixed cost of goods sold 169,000 On target
Controllable fixed selling and administrative expenses 79,000 On target


Average operating assets for the year for the Home Division were $2,000,000 which was also the budgeted amounts

Compute the expected ROI in 2020 for the Home Division, assuming the following independent changes to actual data. (Round ROI to 2 decimal places, e.g. 1.57%.)

The expected ROI

(1) Variable cost of goods sold is decreased by 5%. %
(2) Average operating assets are decreased by 20.0%. %
(3) Sales are increased by $199,000, and this increase is expected to increase contribution margin by $84,000. %

Solutions

Expert Solution

Answer:

Return on Investment (ROI)
Action 1 19.10%
Action 2 21.75%
Action 3 21.60%

Calculations:

Return on Investment (ROI) = Net Income / Operating Assets * 100

Present Proposed
Total $ Action 1 Action 2 Action 3
Sales $ 1,401,000 $ 1,401,000 $ 1,401,000 $ 1,600,000
Less: Variable Cost $    805,000 $    771,000 $    805,000 $    920,000
Contribution $    596,000 $    630,000 $    596,000 $    680,000
Less: fixed Cost $    248,000 $    248,000 $    248,000 $    248,000
Net Income (A) $    348,000 $    382,000 $    348,000 $    432,000
Operating assets (B) $ 2,000,000 $ 2,000,000 $ 1,600,000 $ 2,000,000
ROI (A/B) 17.40% 19.10% 21.75% 21.60%

In case of any doubt or clarification, feel free to come back via comments.


Related Solutions

                Problem 22-5A (Part Level Submission) Optimus Company manufactures a variety of tools and industrial equipment....
                Problem 22-5A (Part Level Submission) Optimus Company manufactures a variety of tools and industrial equipment. The company operates through three divisions. Each division is an investment center. Operating data for the Home Division for the year ended December 31, 2017, and relevant budget data are as follows.                                                                                                                                                                                              Actual                   Comparison with Budget Sales                                                                                     $1,400,000                           $101,000              favorable Variable cost of goods sold                                                           675,000                 55,000         unfavorable Variable selling and administrative expenses                       126,000                 25,000  ...
Problem 22-5A (Part Level Submission) Optimus Company manufactures a variety of tools and industrial equipment. The...
Problem 22-5A (Part Level Submission) Optimus Company manufactures a variety of tools and industrial equipment. The company operates through three divisions. Each division is an investment center. Operating data for the Home Division for the year ended December 31, 2017, and relevant budget data are as follows. Actual Comparison with Budget Sales $1,399,000 $100,000 favorable Variable cost of goods sold 675,000 54,000 unfavorable Variable selling and administrative expenses 124,000 24,000 unfavorable Controllable fixed cost of goods sold 170,000 On target...
Problem 22-5A (Part Level Submission) Optimus Company manufactures a variety of tools and industrial equipment. The...
Problem 22-5A (Part Level Submission) Optimus Company manufactures a variety of tools and industrial equipment. The company operates through three divisions. Each division is an investment center. Operating data for the Home Division for the year ended December 31, 2017, and relevant budget data are as follows. Actual Comparison with Budget Sales $1,401,000 $101,000 favorable Variable cost of goods sold 675,000 55,000 unfavorable Variable selling and administrative expenses 124,000 25,000 unfavorable Controllable fixed cost of goods sold 170,000 On target...
Mac Manufacturing Company manufactures a variety of garden and lawn equipment. The company operates through three...
Mac Manufacturing Company manufactures a variety of garden and lawn equipment. The company operates through three divisions. Each division is an investment center. Operating data for the Weedeater Division for the year ended December 31, 2016, and relevant budget data are as follows. Actual Comparison with Budget Sales $2,900,000 $120,000 unfavorable Variable cost of goods sold 1,400,000 90,000 unfavorable Variable selling and administrative expenses 290,000 60,000 favorable Controllable fixed cost of goods sold 270,000 On target Controllable fixed selling and...
Marx Manufacturing Company manufactures a variety of garden and lawn equipment. The company operates through three...
Marx Manufacturing Company manufactures a variety of garden and lawn equipment. The company operates through three divisions. Each division is an investment center. Operating data for the Weedeater Division for the year ended December 31, 2016, and relevant budget data are as follows. Actual Comparison with Budget Sales $2,900,000 $120,000 unfavorable Variable cost of goods sold 1,400,000 90,000 unfavorable Variable selling and administrative expenses 290,000 60,000 favorable Controllable fixed cost of goods sold 270,000 On target Controllable fixed selling and...
Type or paste question here Problem 22-5A (Part Level Submission) Optimus Company manufactures a variety of...
Type or paste question here Problem 22-5A (Part Level Submission) Optimus Company manufactures a variety of tools and industrial equipment. The company operates through three divisions. Each division is an investment center. Operating data for the Home Division for the year ended December 31, 2017, and relevant budget data are as follows. Actual Comparison with Budget Sales $1,399,000 $101,000 favorable Variable cost of goods sold 676,000 56,000 unfavorable Variable selling and administrative expenses 124,000 25,000 unfavorable Controllable fixed cost of...
Heather Smith Cosmetics (HSC) manufactures a variety of products and is organized into three divisions (investment...
Heather Smith Cosmetics (HSC) manufactures a variety of products and is organized into three divisions (investment centers): soap products, skin lotions, and hair products. Information about the most recent year’s operations follows. The information includes the value of intangible assets, including research and development, patents, and other innovations that are not included on HSC’s balance sheet. Were these intangibles to be included in the financial statements (as they are for EVA®), the increase in the balance sheet and the increase...
Heather Smith Cosmetics (HSC) manufactures a variety of products and is organized into three divisions (investment...
Heather Smith Cosmetics (HSC) manufactures a variety of products and is organized into three divisions (investment centers): soap products, skin lotions, and hair products. Information about the most recent year’s operations follows. The information includes the value of intangible assets, including research and development, patents, and other innovations that are not included on HSC’s balance sheet. Were these intangibles to be included in the financial statements (as they are for EVA), the increase in the balance sheet and the increase...
19-3 Heather Smith Cosmetics (HSC) manufactures a variety of products and is organized into three divisions...
19-3 Heather Smith Cosmetics (HSC) manufactures a variety of products and is organized into three divisions (investment centers): soap products, skin lotions, and hair products. Information about the most recent year’s operations follows. The information includes the value of intangible assets, including research and development, patents, and other innovations that are not included on HSC’s balance sheet. Were these intangibles to be included in the financial statements (as they are for EVA®), the increase in the balance sheet and the...
Selco, a U.S. Company, imports and exports tools, shop equipment, and industrial construction supplies. The company...
Selco, a U.S. Company, imports and exports tools, shop equipment, and industrial construction supplies. The company uses a periodic inventory system. During April the company entered into the following transactions. All rate quotations are direct exchange rates. April  3 Purchased power tools from a wholesaler in Japan, on account, at an invoice cost of 1,600,000 yen. On this date the exchange rate for the yen was $.0072.  5 Sold hand tools on credit that were manufactured in the U.S. to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT