Question

                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   unfavorable

Controllable fixed cost of goods sold                                        170,000                                 On target            

Controllable fixed selling and administrative expenses                    81,000                   On target            

Average operating assets for the year for the Home Division were $1,999,000 which was also the budgeted amount.

Prepare a responsibility report for the Home Division. (List variable costs before fixed costs. Round ROI to 1 decimal place, e.g. 1.5.)

OPTIMUS COMPANY

Home Division

Responsibility Report

For the Year Ended December 31, 2017

Difference

                     

                         Budget                                  Actual

Sales                    1299000                             1400000                     101000                                      

VARIABLE COSTS

COGS                        620000                         675000                          55000

Selling admin cost   101000                            126000                         25000                                              

Total variable           721000                             801000                        80000

Contribution margin 578000                           599000                         21000                                    

Controllable direct fix   170000                        170000                         

COGS                              251000                          251000                                             

Selling admin cost      81000                              81000

Control Margin            327000                              348000                         21000

ROI                       16.36%                                         17.41 %                                                         1.05%          

(c)

Compute the expected ROI in 2017 for the Home Division, assuming the following independent changes to actual data. (Round ROI to 1 decimal place, e.g. 1.5.)

The expected ROI

(1)                          Variable cost of goods sold is decreased by 7%.                 

%

(2)                          Average operating assets are decreased by 12%.               

%

(3)                          Sales are increased by $201,000, and this increase is expected to increase contribution margin by $86,000.                              

%

Homework Answers

Answer #1
ROI = Net operating income / Average assets
1) If varaiable cost of goods sold is decreased by 7%, then revised net operating income = $348,000 + $675,000*7% = $381750
ROI = $381750 / $2,000,000 = 19.7%
2) If average operating assets are decrease by 10%, then new average operating assets = $1999,000 * 88% = $1,759120
ROI = $348,000 / $1,759120 = 19.78%
3)Sales increased by $201,000 resulting in increase in contribution margin by $86,000, then
new operating income = $348,000 + $86,000 = $434000
ROI = $434,000 / $2,000,000 = 21.7%
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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. Prepare a responsibility report for an investment center, and compute ROI.    Actual    Comparison with Budget Sales    $1,400,000    $100,000 favorable The variable cost of goods sold    665,000    45,000 unfavorable Variable selling and administrative...
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, 2022, and relevant budget data are as follows. Prepare responsibility report for an investment center, and compute ROI. Actual Comparison with Budget Sales $1,400,000     $100,000 favorable Variable cost of goods sold 665,000       45,000 unfavorable Variable selling and administrative expenses 125,000       25,000 unfavorable Controllable fixed...
The Sports Equipment Division of Harrington Company is operated as a profit center. Sales for the...
The Sports Equipment Division of Harrington Company is operated as a profit center. Sales for the division were budgeted for 2020 at $902,000. The only variable costs budgeted for the division were cost of goods sold ($444,000) and selling and administrative ($63,000). Fixed costs were budgeted at $104,000 for cost of goods sold, $95,000 for selling and administrative, and $72,000 for noncontrollable fixed costs. Actual results for these items were: Sales $887,000 Cost of goods sold        Variable 409,000        Fixed 104,000...
The Sports Equipment Division of Harrington Company is operated as a profit center. Sales for the...
The Sports Equipment Division of Harrington Company is operated as a profit center. Sales for the division were budgeted for 2020 at $900,000. The only variable costs budgeted for the division were cost of goods sold ($440,000) and selling and administrative ($60,000). Fixed costs were budgeted at $100,000 for cost of goods sold, $90,000 for selling and administrative, and $70,000 for noncontrollable fixed costs. Actual results for these items were: Sales $880,000 Cost of goods sold        Variable 408,000        Fixed 105,000...
The Sports Equipment Division of Harrington Company is operated as a profit center. Sales for the...
The Sports Equipment Division of Harrington Company is operated as a profit center. Sales for the division were budgeted for 2020 at $896,000. The only variable costs budgeted for the division were cost of goods sold ($442,000) and selling and administrative ($65,000). Fixed costs were budgeted at $103,000 for cost of goods sold, $90,000 for selling and administrative, and $73,000 for noncontrollable fixed costs. Actual results for these items were: Sales $887,000 Cost of goods sold        Variable 409,000        Fixed 105,000...
Problem 22-03A (Part Level Submission) Blossom Company bottles and distributes B-Lite, a diet soft drink. The...
Problem 22-03A (Part Level Submission) Blossom Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2020, management estimates the following revenues and costs. Sales $1,950,000 Selling expenses—variable $67,000 Direct materials 550,000 Selling expenses—fixed 61,000 Direct labor 350,000 Administrative expenses—variable 28,000 Manufacturing overhead—variable 370,000 Administrative expenses—fixed 59,250 Manufacturing overhead—fixed 260,000 (a) Prepare a CVP income statement for 2020 based...
For the year ending December 31, 2020, Cobb Company accumulates the following data for the Plastics...
For the year ending December 31, 2020, Cobb Company accumulates the following data for the Plastics Division which it operates as an investment center: contribution margin—$692,320 budget, $702,576 actual; controllable fixed costs—$297,500 budget, $303,600 actual. Average operating assets for the year were $2,078,000. Prepare a responsibility report for the Plastics Division beginning with contribution margin for the year ending December 31, 2020. (Round ROI to 1 decimal place, e.g. 1.5%.) COBB COMPANY Plastics Division Responsibility Report For the Year Ended...
1. Office Stuff produced 15,000 file cabinets at a cost of $80,000. Production for the period...
1. Office Stuff produced 15,000 file cabinets at a cost of $80,000. Production for the period was estimated at 14,000 file cabinets at a cost of $75,000. On which of the following should the flexible budget be based? a. Budgeted costs of actual production b. Budgeted costs of budgeted production c. Actual costs of budgeted production d. Actual costs of actual production 2. Which of the following is false with regard to budgetary planning? a. The starting point for the...
Exercise 24-16 The Sports Equipment Division of Harrington Company is operated as a profit center. Sales...
Exercise 24-16 The Sports Equipment Division of Harrington Company is operated as a profit center. Sales for the division were budgeted for 2017 at $896,200. The only variable costs budgeted for the division were cost of goods sold ($443,790) and selling and administrative ($64,300). Fixed costs were budgeted at $100,000 for cost of goods sold, $90,810 for selling and administrative, and $69,370 for noncontrollable fixed costs. Actual results for these items were: Sales $881,500 Cost of goods sold Variable 417,170...
Torres Company accumulates the following summary data for the year ending December 31, 2020, for its...
Torres Company accumulates the following summary data for the year ending December 31, 2020, for its Water Division, which it operates as a profit center: sales—$2,043,900 budget, $2,180,900 actual; variable costs—$1,011,800 budget, $1,044,400 actual; and controllable fixed costs—$299,800 budget, $302,900 actual. Prepare a responsibility report for the Water Division for the year ending December 31, 2020. TORRES COMPANY Water Division Responsibility Report For the Year Ended December 31, 2020 Difference Budget Actual Favorable Unfavorable Neither Favorable nor Unfavorable Select an...