Divisional Income Statements and Rate of Return on Investment Analysis Sunshine
ID: 2568464 • Letter: D
Question
Divisional Income Statements and Rate of Return on Investment Analysis
Sunshine Food Company is a diversified food company that specializes in all natural foods. The company has three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 2016, are as follows:
The management of Sunshine Food Company is evaluating each division as a basis for planning a future expansion of operations.
Required:
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. Round your answers to one decimal place.
3. When faced with limited funds for expansion, management should consider an expansion of the Division first.
Cereal
Division
Snack Cake
Division Retail
Bakeries
Division Sales $5,060,000 $5,400,000 $4,740,000 Cost of goods sold 3,090,000 3,350,000 2,800,000 Operating expenses 958,000 1,078,000 612,800 Invested assets 4,600,000 6,000,000 7,900,000
Explanation / Answer
Dear Student Thank you for using Chegg Please find below the answer and please give thumbs up Statementshowing Computations Paticulars Cereal Division Snack Cake Division Retail Bakeries Division Sales 5,060,000.00 5,400,000.00 4,740,000.00 Cost of goods sold 3,090,000.00 3,350,000.00 2,800,000.00 Gross profit 1,970,000.00 2,050,000.00 1,940,000.00 Operating expenses 958,000.00 1,078,000.00 612,800.00 Income from operations 1,012,000.00 972,000.00 1,327,200.00 2) Invested Assets 4,600,000.00 6,000,000.00 7,900,000.00 Profit Margin = Income/ Sales 20.00% 18.00% 28.00% Investment turnover = Sales/ Invested Assets 1.10 0.90 0.60 ROI = Income/ Invested assets 22.00% 16.20% 16.80% 3) When faced with limited funds for expansion, management should consider an expansion of the cereal Division first.