PR 23-3B Divisional income statements and rate of return on investment analysis OBJ. 4 The Whole Earth Food Company is a diversified food company with three operating di visions organized as investment centers, Condensed data taken from the records of the three divisions for the year ended June 30, 2014, are as follows: Cereal Snack Cake Retail Division Division Bakeries Division Sales $12,000,000 $6,600,000 $5,740,000 Cost of goods sold 8,000,000 4,600,000 4,000,000 Operating expenses 3,280,000 1,340,000 1,051,200 Invested assets 6,000,000 4,400,000 4,100,000 The management of The Whole Earth Food Company is evaluating each division as a basis for planning a future expansion of operations. Instructions 1. Prepare condensed divisional income statements for the three divisions, assuming that there were no service department charges. 2. Using the DuPont formula for rate of return on investment, compute the profit margin, investment turnover, and rate of return on investment for each division. 3. If available funds permit the expansion of operations of only one division, which of the divisions would you recommend for expansion, based on parts (1) and (2)? Explain. H34 M N O H B D F E 8 wctions gors are entered in the cold with gray backgrounds 10 with non-gray backgrounds are protected and cannot be edited 11 torsk (*) will appear to the right of an incorrect entry in the income statement and above or below 12 nts in the equations. The essay answer will not be graded. 13 14 THE WHOLE EARTH FOOD COMPANY 15 Divisional Income Statements 16 For the Year Ended June 30, 2014 Snack Retail 17 18 Cereal Cake Bakeries Division 19 Division Division 20 Fee revenge $ 12,000,000 5 5,740,000 $ 5,600,000 21 Cost of goods sold 8.000.000 4.600.000 4.000.000 22 Gross profit 23 Operating expenses 3.280,000 1,340,000 1,051,200 Income from operations 24 $ 720,000 $ $ 660,000 888.800 25 26 27 28 Rate of Retum (ROI) on Investment Profit Margin x Investment Tumover 29 30 Income from Operations Sales Rate of Retum (ROI) on Investment 31 Sales Invested Assets 32 33 Cereal Division 34 ROI X 35 36 37 Snack Cake Division: 38 ROI 39 40 41 Retail Bakeries Division: 42 ROI x 43 44 45 x [Kay essay answer here) 46 47 48 49 50 51 Pr. 2(8)3-3B Ready