ROI, Margin, TurnoverAllard, Inc., presented two years of data for its Frozen Foods Division and its Canned Foods Division.Frozen Foods Division:Year 1Year 2Sales$33,520,000 $36,220,000Operating income1,474,880 1,593,680Average operating assets10,000,00010,000,000Canned Foods Division:Year 1Year 2Sales$11,850,000 $12,319,000Operating income628,050529,717Average operating assets5,000,0005,000,000 1. Compute the ROI and the margin and turnover ratios for each year for the Frozen Foods Division.Frozen Foods DivisionROIMarginTurnoverYear 11%%Year 2%%2. Compute the ROI and the margin and turnover ratios for each year for the Canned Foods Division..Canned Foods DivisionROITurnoverMargin%Year 1%Year 2%%3. Indicate the reason for change in ROI from Year 1 to Year 2 for the Frozen Foods Division.Indicate the reason for change in ROI from Year 1 to Year 2 for the Canned Foods Division.4. Which of the data analytic types-descriptive, diagnostic, predictive or prescriptive-is Allard using in comparing Year 1 to Year 2 for the ratios?

Note: Hi! Thank you for the question, As per the honor code, we are allowed to answer three…

ROI, Margin, Turnover Allard, Inc., presented two years of data for its Frozen Foods Division and its Canned Foods Division. Frozen Foods Division: Year 1 Year 2 Sales $33,520,000 $36,220,000 Operating income 1,474,880 1,593,680 Average operating assets 10,000,000 10,000,000 Canned Foods Division: Year 1 Year 2 Sales $11,850,000 $12,319,000 Operating income 628,050 529,717 Average operating assets 5,000,000 5,000,000

ROI, Margin, Turnover Allard, Inc., presented two years of data for its Frozen Foods Division and its Canned Foods Division. Frozen Foods Division: Year 1 Year 2 Sales $33,520,000 $36,220,000 Operating income 1,474,880 1,593,680 Average operating assets 10,000,000 10,000,000 Canned Foods Division: Year 1 Year 2 Sales $11,850,000 $12,319,000 Operating income 628,050 529,717 Average operating assets 5,000,000 5,000,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Residual Income and Investment Decisions Allard, Inc., presented two years of data for its Frozen Foods Division and its Canned Foods Division. Frozen Foods Division: Year 1 Year 2 Sales $35,300,000 $37,800,000 Operating income 1,440,000 1,590,000 Average operating assets 4,890,000 4,890,000 Canned Division: Year 1 Year 2 Sales $11,900,000 $12,600,000 Operating income 640,000 510,000 Average operating assets 5,800,000 5,800,000 At the end of Year 2, the manager of the Canned Division is concerned about the division's performance. As a result, he is considering the opportunity to invest in two independent projects. The first is juice boxes for elementary school children. The second is fruit and veggie pouches for kids on the go. Without the investments, the division expects that Year 2 data will remain unchanged. The expected operating incomes and the outlay required for each investment are as follows: Juice Box Fruit Pouch Operating…
Crane Company has four operating divisions. During the first quarter of 2022, the company reported aggregate income from operations of $ 210,600 and the following divisional results. Division I II III IV Sales $ 245,000 $ 197,000 $ 504,000 $ 450,000 Cost of goods sold 200,000 192,000 301,000 249,000 Selling and administrative expenses 72,400 63,000 58,000 50,000 Income (loss) from operations $ ( 27,400) $ ( 58,000) $ 145,000 $ 151,000 Analysis reveals the following percentages of variable costs in each division. I II III IV Cost of goods sold 73 % 91 % 82 % 75 % Selling and administrative expenses 39 59 50 61 Discontinuance of any division would save 50% of the fixed costs and expenses for that division.Top management is very concerned about the unprofitable divisions (I and II). Consensus is that one or both of the…
Required information Skip to question [The following information applies to the questions displayed below.] King Mattresses sells both mattress sets and bed frames. Last quarter, total sales were $70,000 for mattress sets and $45,000 for bed frames. Return on investment (ROI) was 15% for both divisions, while asset turnover (AT) was 3 for mattress sets and 3 for bed frames. Compute King Mattresses’s total return on sales (ROS) for the quarter.
Buckley Company operates three segments. Income statements for the segments imply that profitability could be improved if Segment A were eliminated. BUCKLEY COMPANY Income Statements for Year 2 Segment A B C Sales $ 330,000 $ 480,000 $ 500,000 Cost of goods sold (242,000 ) (184,000 ) (190,000 ) Sales commissions (30,000 ) (44,000 ) (44,000 ) Contribution margin 58,000 252,000 266,000 General fixed operating expenses (allocation of president’s salary) (92,000 ) (92,000 ) (92,000 ) Advertising expense (specific to individual divisions) (6,000 ) (20,000 ) 0 Net income (loss) $ (40,000 ) $ 140,000 $ 174,000 Required Prepare a schedule of relevant sales and costs for Segment A. Prepare comparative income statements for the company as a whole under two alternatives: (1) the retention of Segment A and (2) the elimination of Segment A. Options for required A table are: Advertising…
Operating income for profit center The centralized Data Analytics Department of Drewlink Company has expenses of $340,000. The department has provided a total of 8,000 hours of service for the period. The Retail Division has used 2,000 hours of data analytics service during the period, and the Commercial Division has used 6,000 hours of data analytics service. Additional data for the two divisions is following below: Retail Division Commercial Division Sales Cost of goods sold $2,550,000 1,450,000 $1,700,000 -750,000 230,000 170,000 Selling expenses Determine the divisional operating income for the Retail Division and the Commercial Division. Do not round interim calculations. Drewlink Company Divisional Operating income Line Item Description Retail Division Commercial Division Sales Cost of goods sold Support department allocations X Operating income Feedback
Profit Margin, Investment Turnover, and return on investment The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows (assuming no service department charges): Sales $816,000 Cost of goods sold 367,200 Gross profit $448,800 Administrative expenses 285,600 Income from operations $163,200 The manager of the Consumer Products Division is considering ways to increase the return on investment. a. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment of the Consumer Products Division, assuming that $1,360,000 of assets have been invested in the Consumer Products Division. Round the investment turnover to one decimal place. Profit margin 2 x % Investment turnover Rate of return on investment % b. If expenses could be reduced by $40,800 without decreasing sales, what would be the impact on the profit margin, investment turnover, and return on investment for the Consumer…
Terra Company has two divisions, the Retail Division and the Wholesale Division. The following information was gathered for the two divisions for the current year: Operating income Operating assets Retail Division $ 7,200,000 $37,200,000 Wholesale Division $ 3,700,000 $17,200,000 Assuming that these are the only divisions of Terra Company, what is the ROI for the company as a whole?
Long Beach Pharmaceutical Company has two divisions, which reported the following results for the most recent year. Income Average invested capital ROI Division I $ 900,000 $6,000,000 Division II $ 200,000 $1,000,000 15% 20% Which was the more successful division during the year? Think carefully about this, and Required: explain your answer.
Residual Income and Investment Decisions Allard, Inc., presented two years of data for its Frozen Foods Division and its Canned Foods Division. Frozen Foods Division: Year 1 Year 2 Sales $6,000,000 $6,200,000 Operating income 420,000 434,000 Average operating assets 4,000,000 4,000,000 Canned Foods Division: Year 1 Year 2 Sales $2,400,000 $2,600,000 Operating income 120,000 117,000 Average operating assets 1,000,000 1,000,000 Required: 1. Compute the ROI and the margin and turnover ratios for each year for the frozen foods division. (Round your answer to four significant digits). 2. Compute the ROI and the margin and turnover ratios for each year for the canned foods division. (Round your answer to four significant digits). 3. Explain the change in ROI from year one and year two for each division. 4. Which of the data analytic types-descriptive, diagnostic, predictive or prescriptive-is Allard using and comparing year one to year two for the ratios?…
Profit Margin, Investment Turnover, and return on investment The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows (assuming no service department charge Sales $936,000 Cost of goods sold 421,200