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 |
|
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 4 images
- eBook Question Content Area Divisional income statements and return on investment analysis The Crunchy Granola 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, 20Y7, are as follows: Line Item Description CerealDivision Snack CakeDivision RetailBakeries Division Sales $25,000,000 $8,000,000 $9,750,000 Cost of goods sold 16,670,000 5,575,000 6,795,000 Operating expenses 7,330,000 1,945,000 2,272,500 Invested assets 10,000,000 4,000,000 6,500,000 The management of The Crunchy Granola Company is evaluating each division as a basis for planning a future expansion of operations. Required: Question Content Area 1. Prepare condensed divisional income statements for the three divisions, assuming that there were no support department allocations. The Crunchy…arrow_forwardProfit Center Responsibility Reporting A-One Freight Inc. has three regional divisions organized as profit centers. The chief executive officer (CEO) evaluates divisional performance using operating income as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31, 20Y3. Revenues—Air Division $ 1,086,300 Revenues—Rail Division 1,307,900 Revenues—Truck Division 2,315,700 Operating Expenses—Air Division 688,400 Operating Expenses—Rail Division 778,400 Operating Expenses—Truck Division 1,400,400 Corporate Expenses—Shareholder Relations 165,200 Corporate Expenses—Customer Support 546,000 Corporate Expenses—Legal 262,400 General Corporate Officers’ Salaries 364,900 The company operates three service departments: Shareholder Relations, Customer Support, and Legal. The Shareholder Relations Department conducts a variety of services for shareholders of the company. The Customer Support Department…arrow_forwardNavarre Energy Research specializes in developing and commercializing new products. It is organized into two divisions, which are based on the products they produce. Canal Division is smaller, and the lives of the products it produces tend to be shorter than those produced by the larger Lake Division. Selected financial data for the past year are shown in the following table. Divisional investment is as of the beginning of the year. Navarre uses an 8 percent cost of capital and beginning-of-the-year investment when computing ROI and residual income. Ignore income taxes. Division Canal ($000) Lake ($000) Allocated corporate overhead $ 4,100 $ 9,600 Cost of goods sold 20,000 30,000 Divisional investment 60,100 400,000 R&D 12,000 32,000 Sales 50,000 100,000 Selling, general and administrative (excluding R&D) 4,500 8,000 R&D is assumed to have a three-year life in Canal Division and an eight-year life in Lake Division. All R&D expenditures are spent…arrow_forward
- Divisional income statements with support department allocations Horton Technology has two divisions. Consumer and Commercial and two corporate support departments, Tech Services and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows: ACCT 102 Chapter 24 - Homework assignment take frame Teen Services Department 2770,000 292,000 Purchasing Department Other corporate administrative expenses Total expense The other corporate administrative expenses include officers' salaries and other expenses required by the corporation. The Tech Services Department allocates costs to the divisions based on the number of computers in the department, and the Purchasing Department allocates costs to the divisions based on the number of purchase orders for each department. The services used by the two divisions are as follows: Consumer Division Commercial Division Total Tech Services $1,519,500 260 410 computers 670 457,000 Purchasing 5,100 purchase orders 1,322,900…arrow_forwardReturn on investment The operating income and the amount of invested assets in each division of Conley Industries are as follows: Operating Income Invested Assets Retail Division $72,600 $330,000 Commercial Division 117,600 490,000 Internet Division 224,100 830,000 a. Compute the return on investment for each division. (Round to the nearest whole percentage.) Division Percent Retail Division % Commercial Division % Internet Division b. Which division is the most profitable per dollar invested?arrow_forwardDivisional Income Statements and Return on Investment Analysis E.F. Lynch Company is a diversified investment company with three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y8, are as follows: Mutual FundDivision ElectronicBrokerageDivision InvestmentBankingDivision Fee revenue $1,010,000 $1,060,000 $1,030,000 Operating expenses 492,000 390,400 727,600 Invested assets 3,700,000 3,100,000 2,100,000 The management of E.F. Lynch Company is evaluating each division as a basis for planning a future expansion of operations. Required: Question Content Area 1. Prepare condensed divisional income statements for the three divisions, assuming that there were no service department cost allocations. E.F. Lynch CompanyDivisional Income StatementsFor the Year Ended June 30, 20Y8 MutualFundDivision ElectronicBrokerageDivision InvestmentBankingDivision Fee…arrow_forward
- Meiji Isetan Corporation of Japan has two regional divisions with headquarters in Osaka and Yokohama. Selected data on the two divisions follow: Division Osaka Yokohama Sales $ 9,800,000 $ 28,000,000 Net operating income $ 588,000 $ 2,240,000 Average operating assets $ 2,450,000 $ 14,000,000 Required: 1. For each division, compute the return on investment (ROI) in terms of margin and turnover. 2. Assume that the company evaluates performance using residual income and that the minimum required rate of return for any division is 14%. Compute the residual income for each division. 3. Is Yokohama’s greater amount of residual income an indication that it is better managed? Osaka Yokohama ROI % % Osaka Yokohama Residual incomearrow_forwardThe vice president of operations of Scott Hall and Associates is evaluating the performance of two divisions organized as investment centers. Invested assets and condensed income statement data for the past year for each division are as follows: Category Road Bike Division Mountain Bike Division Sales $1,750,000 $1,810,000 Cost of goods sold 1,300,000 1,440,000 Operating expenses 202,000 236,800 Invested assets 1,400,000 800,000 Prepare condensed divisional income statements for the year ended December 31, 2021, assuming that there were no service department charges. Using the DuPont formula for return on investment, determine the profit margin percentage, investment turnover, and return on investment for each division. (Round percentages and the investment turnover to two places behind the decimal.) If management’s minimum acceptable return on investment is 10%, determine the residual income for each division. In your own words…arrow_forwardEvaluating Investment Centers Terry Enterprises, Inc. has two divisions-the Foods division and the Clothes division. Historically, Terry has used the division's ROI as the performance measure for the bonus determinations. Terry Foods division has gross total assets of $1,000,000, accumulated depreciation of $350,000, current liabilities of $250,000, and sales of $2,000,000. Foods' operating income is $320,000. Terry Clothes division has gross total assets of $5,000,000, accumulated depreciation of $2,100,000, current liabilities of $1,500,000, and sales of $8,000,000. Clothes' operating income is $870,000. Use the DuPont formula to compute ROI for each division and for Terry Enterprises as a whole. Use operating income and gross total assets as the measures of income and investment. Round answers to the nearest whole percentage. ROI Foods Clothes Terry Enterprises % % %arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education