201 W4_assignment 4 Home Insert Page Layout Formulas Data Review View Calibri (Bodyl - 11 A- A Wrap Text General Paste B IU- Merge & Center 2 Fe H16 G 1 L M N O P 1 2 D F 1 BE23 9 (LOA), AP Por its three investment centers, Gerrard Company accumulates the following data: Computereturn on investment using the ROI formule 10 11 12 Sales 3,000,000 $4.000.000 S 4.000.000 Controllable margin 1.400,000 2,000,000 3.600,000 Average operating sets 5,000,000 8.000.000 10.000.000 Compute the return on investment (ROD) for each center BE310 (LO, AP Data for the investment centers for Gerrard Company are given in BE. The contes expect the following changes in the next year) increase sales (1) decrease controllable fied costs $400,000, and (I) decrease average operating $500,000. Compute the expected return on investment (ROD) for each center Assecenter has a contribution margin percentage of Computereturn on investment under changed conditions 14 15 16 17 11 19 20 21 23 25 26 27 20 29 33 34 35 36 37 BE23-7 BE23-9,10 + 888 ** 5 2014. assignment 4 Home Insert Page Layout Formulas Data Review View Calibri Booyi 11 A-A- General B TU- Mere & Center - Conditional Format Formatting Table 015 c F 0 EX(LOAP Torres Company was the following ummary for the year ending December, on for its Water Division, which it operates a prot.000 budget, Soco cual variable costs.co budget, S50.000 actual and controllable for costs - Scoobeda, 3395.00 dal per a responsibility report for the Water Division for the yearning December Prepare a respeity report for a pronte 11 12 13 22 23 24 13 3 4 5 6 7 V 8 N 9 WE R . o