North South East West Sales $100,000 $25,000 $75,000 $76,000 CGS $50,000 $5,000 $50,674 $45,000 other expenses $25,000 $3,000 $12,894 $15,000 Average total assets $5,000,000 $50,000 $300,500 $567,850 Using the information, calculate the operating profit percentage for each of the divisions. Comment on how your analysis has changed compared to your analysis of the dollar amounts for each division. Using total assets as the investment, calcu
Q: Division Northeast Southeast West Sales $ ? $10,980,000 $ ? Net operating income $ ? $878,400…
A: Margin = Net Operating Income / Sales Turnover = Sales / Average Operating Assets Return on…
Q: Sales (75,000units) P 750,000 Variable costs 225,000 Contribution margin P 525,000 Fixed…
A: Degree of financial leverage = EBIT / EBT EBIT = EBT+ Interest
Q: Ultimo Company operates three production departments as profit centers. The following Information is…
A: Overhead are those costs that cannot be directly attributed to a unit of product.theae can be…
Q: Sales $114,000 $39,900 Operating income Total assets $71,250 Return on investment for XYZ company…
A: Return on Investment(ROI) is a performance measure that analyses the efficiency and profitability of…
Q: Return on Investment (ROI) Provide the missing data in the following table for a distributor of…
A: Division Alpha: Given Asset turnover = 5 = Sales/average opertaing assets = 5 = Sales/$800,000 = 5…
Q: 29. The Global Products Corporation has three subsidiaries. Heavy Machinery Electronics Medical…
A: Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: Accounting data is used to generate a firm's financial statements, but a firm's intrinsic value is…
A: Statement #1: J & H Corp.’s NOPAT is $3,196,800, which is less than the Industry average of…
Q: Operating segments Total revenue Profit Identifiable assets 1,000,000 200,000 4,000,000 500,000…
A: Operating segment is the component of entity, which has its own revenue, expenses, assets,…
Q: Using the data below for Ace Guitar Company: Region A Region B Sales $500,000…
A: The income statement is one of the essential parts of the financial statement used for reporting the…
Q: Cost-hierarchy income statement and allocation of corporate costs to customers. The Insurance…
A: Customer Cost Hierarchy:Customer cost hierarchy is a method that helps in the categorization of cost…
Q: Consider the following data for three divisions of a company, X, Y, and Z: Divisional: X Y Z…
A: Ratio analysis means where different ratio of various years of years companies has been compared and…
Q: Sales revenue 400,000 Total Revenue…
A: Profit margin is the measurement of company’s earning in respect to the revenues generated by it. It…
Q: The Central Division of Burlington Company reported the following operating data for the past year…
A: "Since you have posted a question with multiple sub-parts, we will solve first three sub- parts for…
Q: The following information is available for company X. 20X7 $ 20X8 Profit Sales Capital employed…
A: We have the following information: Profit for 20X7: $7,500 Profit for 20X8: $9,000 Sales for 20X7:…
Q: The Global Products Corporation has three subsidiaries. Medical Supplies Heavy Machinery…
A: Let us first compute the ROA (return on assets) for the medical supplies division. ROA = net…
Q: Sales $200,000 Interest expenses $10,000 Tax $5,000 Administration expenses $2,000 Advertisement…
A: Income statement in the business shows all incomes and all expenses in the business and at the end…
Q: Fill in the blanks: (Round "Return on sales" and "Asset turnover" answers to 2 decimal places.)…
A: 1. Return on sales = Operating income / Net Sales 2. Asset turnover = Net sales / Average total…
Q: Crane Company has four operating divisions. During the first quarter of 2022, the company reported…
A: Here in this question, we are required to calculate incremental profit/loss. This type of analysis…
Q: The following information pertains to Xavier Corp. and its divisions for the year ended 12/31/20:…
A: Sales to Unaffiliated customers = $ 4000000 Inter segment sales = $ 900000 Total revenue = 4000000 +…
Q: To qualify as reportable segment, the segment revenue should at least be what amount? A. 5,300,000…
A:
Q: Segment B $ 164,000 (128,000) (22,000) $241,000 (81,000) (28,000) $246,000 (95,000) (22,000) Sales…
A:
Q: A company’s shipping division (an investment center) has sales of $2,420,000, net income of…
A: Formula to calculate profit margin: Profit margin = Net income / Net sales Formula to calculate…
Q: 4,500,000 795,000 2,400,000 Division C Division D 6,800,000 795,000 2,700,000 Required: (a) Using…
A: Profit margin is the margin earned on sales of the business. Investment turnover shows ratio of…
Q: The following are selected data for the division for the consumer products of ABC Corp for 2019:…
A: Residual income for the division = Net income - average invested capital x Cost of capital
Q: Division P reported Income from Operations of $875,000 and Total Service Department Charges of…
A: there are three terms gross profit, income from operations and net income. lets understand these…
Q: 3. Golden Company maintains a markup of 60 percent based on cost. The company's selling and…
A: The operating profit is calculated as sales less cost of goods sold less selling and administrative…
Q: The following are selected data for the division for the consumer products of ABC Corp for 2020:…
A: Assets turnover ratio = Sales / Average Invested capital where, Average Invested capital =…
Q: Question: Vertical Analysis of the Income statement Company A Company B Net sales…
A:
Q: The following are selected data for the division for the consumer products of ABC Corp for 2020:…
A: Introduction:- The following formula used to calculate as follows:- Residual income = Net income -…
Q: Crane Company has four operating divisions. During the first quarter of 2022, the company reported…
A: Contribution margin generally represents incremental money generated for each product sold after…
Q: Data for the wholesale products division of ABC Co. are as follows: Earnings before interest and…
A: As per cost accounting and financial reporting Economic value added = NOPAT - (WACC*INVESTED…
Q: Business Division Consumer Division Sales $42,800,000 $56,000,000 Cost of goods sold 23,500,000…
A: Solution: Business division Consumer division Sales 42800000 56000000 Cost of goods sold…
Q: Zachary Transport Company divides its operations into four divisions. A recent income statement for…
A: Avoidable cost : Salaries for drivers Fuel expenses Insurance Division - level Facility -…
Q: Smith Wesson Net income $10,000 $100,000 Net sales 50,000 400,000 Calculate the profit margin ratio…
A: Lets understand the basics. Profit margin is a margin generated from the sales. It is a comparison…
Q: Assume a company with two divisions (A and B) prepared the following segmented income statement:…
A: Break even is the point at which an entity is just recovering its costs from the revenues but not…
Q: The Global Products Corporation has three subsidiaries: Medical Supplies…
A: a. Compute which division has lowest return on sales as shown below: Therefore, medical…
Q: RUSTIC RURAL Co. has the following information on its operating segments. External Inter-segment…
A: Segment reporting refers to providing the financial information of a particular division,…
Q: The following financial information is available for Beasties upper and lower divisions: Upper Lower…
A: ROI is the rate of return calculated by dividing the operating income by assts invested in business…
Q: Sales $755,000 $ 620,000 Cost of goods sold other operating expenses Interest expense $445,450…
A: The asset turnover ratio relates the worth of a company's sales or revenues to the value of its…
Q: Evergreen Corporation has two major divisions: Agricultural Products and Industrial Products. It…
A: The profit margin ratio is calculated as net operating income divided by net sales.
Q: Your Corporation has two divisions: A Division and B Division. The corporation's net operating…
A: Given: Net operating Income =$31800A Division segment margin =$111800B Division segment margin…
Q: Consider the following data for three divisions of a company, X, Y, and Z: Divisional: X Y Z…
A: The question is related to Profitability Ratio based on sales. The return on Sales is calculated…
North | South | East | West | |||
Sales | $100,000 | $25,000 | $75,000 | $76,000 | ||
CGS | $50,000 | $5,000 | $50,674 | $45,000 | ||
other expenses | $25,000 | $3,000 | $12,894 | $15,000 | ||
Average total assets | $5,000,000 | $50,000 | $300,500 | $567,850 | ||
Using the information, calculate the operating profit percentage for each of the divisions. Comment on how your analysis has changed compared to your analysis of the dollar amounts for each division.
|
||||||
Using total assets as the investment, calculate the ROI for each division. Comment on the results.
|
||||||
Assume a cost of capital of 10%. Calculate the RI for each of the divisions. Comment on the results.
|
||||||
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- The Global Products Corporation has three subsidiaries: Medical Supplies Heavy Machinery Electronics Sales.......... $20,040,000 $5,980,000 $4,730,000 Net income 1,700,000 592,000 402,000 (after taxes) Assets............8,340,000 8,760,000 3,570,000 a. Which division has the lowest return on sales? b. Which division has the highest return on assets? c. Compute the return on assets for the entire corporation. d. If the $8,760,000 investment in the heavy machinery division is sold off and redeployed in the medical supplies subsidiary at the same rate of return on assets currently achieved in the medical supplies division, what will be the new return on assets for the entire corporation?The following data are taken from the records of Dove Company, a division of Oasis Corporation for the year ended December 31, 2021 Sales 120,000,000.00Less: Variable Cost and Expenses 8,000,000.00Contribution Margin 4,000,000.00Less:: Direct Fixed Cost and Expenses 1,000,000.00Segment Income 3,000,000.00 The company used an average assets of P8,000,000.00 in 2021. The cost of capital is 12% Calculate the following:1. Return on Sales2. Asset Turnover3. ROI4. Residual IncomeCrane 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…
- he Haines Corporation shows the following financial data for 20X1 and 20X2: 20X1 20X2 Sales $ 2,950,000 $ 3,380,000 Cost of goods sold 1,630,000 2,170,000 Gross profit $ 1,320,000 $ 1,210,000 Selling & administrative expense 269,000 265,000 Operating profit $ 1,051,000 $ 945,000 Interest expense 45,400 46,600 Income before taxes $ 1,005,600 $ 898,400 Taxes (35%) 351,960 314,440 Income after taxes $ 653,640 $ 583,960 For each year, compute the following ratios and indicate how the change in each ratio will affect profitability in 20X2. Note: Input your answers as a percent rounded to 2 decimal places.Wescott Company has three divisions: A, B, and C. The company has a hurdle rate of 8 percent. Selected operating data for the three divisions are as follows: Division A Division B Division C Sales revenue $ 1,275,000 $ 996,000 $ 986,000 Cost of goods sold 788,000 731,000 716,000 Miscellaneous operating expenses 68,000 56,000 57,000 Interest and taxes 52,000 45,000 45,000 Average invested assets 8,992,000 2,118,000 3,485,000 Wescott is considering an expansion project in the upcoming year that will cost $5.4 million and return $488,000 per year. The project would be implemented by only one of the three divisions. Required: 1. Compute the ROI for each division. 2. Compute the residual income for each division. 3. Rank the divisions according to the ROI and residual income of each. 4-a. Compute the return on investment on the proposed expansion project. 4-b. Is this an acceptable project? 5. Without any additional calculations, state whether the proposed project would…Adams Company operates three segments. Income statements for the segments imply that profitability could be improved if Segment A were eliminated. ADAMS COMPANY Income Statements for Year 2 Segment A B C Sales $ 166,000 $ 250,000 $ 265,000 Cost of goods sold (126,000 ) (79,000 ) (77,000 ) Sales commissions (22,000 ) (23,000 ) (32,000 ) Contribution margin 18,000 148,000 156,000 General fixed operating expenses (allocation of president’s salary) (39,000 ) (50,000 ) (25,000 ) Advertising expense (specific to individual divisions) (5,000 ) (15,000 ) 0 Net income (loss) $ (26,000 ) $ 83,000 $ 131,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.
- Sanborn Corporation Comparative Income Statements in € For the Years Ended December 31, 20X8 and 20X7 20X8 20X7 Net Sales 3,276,800 3,146,400 Cost of goods (2,088,800) (2,008,400) Gross margin 1,188,000 1,138,000 Operating expenses Selling expenses (476,800) (518,000) General & administrative expenses (447,200) (423,200) Total operating expenses (924,000) (941,200) Income from operations 264,000 196,800 Interest expense (65,600) (39,200) Net income before taxes 198,400 157,600 Income taxes (62,400) (56,800) Net income after taxes 136,000 100,800 Earnings per share 3.40 2.52 Sanborn Corporation Comparative Balance Sheets in € December 31, 20X8 and 20X7 Assets 20X8 20X7 Liabilities & Stockholders' Equity 20X8 20X7 Fixed assets: Stockholders' equity: Property, plant and…The Global Products Corporation has three subsidiaries. Medical Supplies Heavy Machinery Electronics Sales $20,040,000 $5,980,000 $4,730,000 Net Income (after taxes) 1,700,000 592,000 402,000 Assets 8,340,000 8,760,000 3,570,000 Which division has the lowest return on sales? Which division has the highest return on assets? Compute the return on assets for the entire corporation? If the $8,760,000 investment in the heavy machinery division is sold off and redeployed in the medical supplies subsidiary at the same rate of return on assets currently achieved in the medical supplies division, what will be the new return on assets for the entire corporation?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…
- Vernon transport company divides its operations into four divisions. A recent statement for its West Division folows Vernon Transport Comapny Wesy division Income Statement for year 3 Revenue $670,000 Salaries for drivers (520,000) Fuel expenses (67,000) Insurance (87,000) Division-level facility- sustaining costs (57,000) Companywide facility-sustaining costs (147,000) Net loss $208,000 Required a) By how much would cormpanywide income increase or decrease if West Division is estimated? Should West Division be eliminated? b) assume that West Division is able to increase its revenue to $760,000 by raising its prices. Determine the amount of the increase or decrease that would occur in companywide net income if the segemnt were eliminated. Should West Division be eliminated if revenue were $760,000? c) What is the mininum amount of revenue required to Jusify continuing the operation of West Divison? Complete this question by entering your answer in the table below. Income Would…Consider the following data for three divisions of a company, X, Y, and Z: Divisional: X Y Z Sales $ 1,431,000 $ 942,000 $ 4,792,000 Operating Income 214,300 124,300 230,000 Investment in assets 557,200 596,600 2,587,500 The asset turnover (AT) for Division X is (rounded):ParsonCompany SyberCompany ConsolidatedTotals Sales $ (744,000 ) $ (654,000 ) $ (1,223,000 ) Cost of goods sold 450,000 412,000 691,000 Operating expenses 104,000 107,000 213,300 Income of Syber (102,960 ) 0 0 Separate company net income $ (292,960 ) $ (135,000 ) Consolidated net income $ (318,700 ) Net income attributable to noncontrolling interest 25,740 Net income attributable to Parson Company $ (292,960 ) Retained earnings, 1/1/21 $ (592,320 ) $ (316,000 ) $ (592,320 ) Net income (above) (292,960 ) (135,000 ) (292,960 ) Dividends declared 63,000 27,000 63,000 Retained earnings, 12/31/21 $ (822,280 ) $ (424,000 ) $ (822,280 ) Cash and receivables $ 280,000 $ 78,000 $ 333,000 Inventory 194,000 154,000 335,000 Investment in Syber Company 418,320 0 0 Land,…