Water Paints Inc. has two major Divisions and has collected the following information about them. Net Sales revenue Operating income Average Total Assets Stores $3,989,000 $480,000 $1,250,000 Consumer 1,425,000 185,000 1,500,000 Required: Calculate each Division’s ROI rounding all of your answers to three decimal places. Calculate each Division’s profit margin ratio. What do your results mean? Calculate each Division’s asset turnover ratio.

Water Paints Inc. has two major Divisions and has collected the following information about them. Net Sales revenue Operating income Average Total Assets Stores $3,989,000 $480,000 $1,250,000 Consumer 1,425,000 185,000 1,500,000 Required: Calculate each Division’s ROI rounding all of your answers to three decimal places. Calculate each Division’s profit margin ratio. What do your results mean? Calculate each Division’s asset turnover ratio.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter9: Responsibility Accounting And Decentralization

Section: Chapter Questions

Problem 8PB: The following revenue data were taken from the December 31, 2017, General Electric annual report...

See similar textbooks

Similar questions

Case 1: ROI You are comparing the performance of two (2) separate divisions, segments A and B, using ROI Analysis. A B Sales P100,000.00 P500,000.00 Operating Expenses 30,000.00 300,000.00 Net Operating income 70,000.00 200,000.00 Average Operating Assets 10,000.00 40,000.00 Required: Using ROI Analysis, which segment is performing better? To answer this question, you need to: Compute the ROI of each segment and Compute the components of ROI of each segment
Arlington Clothing, Inc., shows the following information for its two divisions for year 1. Sales revenue Cost of sales Allocated corporate overhead Other general and administration Required: a. Compute divisional operating income for the two divisions. Ignore taxes. b-1. What are the gross margin and operating margin percentages for both divisions? b-2. How well have these divisions performed? Req A Complete this question by entering your answers in the tabs below. Operating income Lake Region $4,040,000 2,631,300 242,400 541,900 Req B1 stion 10- Hom... Req B2 Compute divisional operating income for the two divisions. Ignore taxes. (Enter your answers in thousa to 1 decimal place.) Coastal Region $12,950,000 6,475,000 777,000 3,743,000 Lake Region Coastal Region Reg A Req B1 > < Prev
ROI is effective because it takes into consideration the three factors under the control of an investment center manager: revenues, costs, and investments. ROI measures the income (or return) earned on each dollar of investment. APPLY THE CONCEPTS: Calculating return on investment The divisional income statements for three divisions of the McLaren Company are shown. McLaren Company Divisional Income Statements For the Year Ending December 31, 2012 Division A Division B Division C Sales Revenue $1,947,000 $1,197,000 $594,000 Operating expenses (1,148,730) (897,750) (314,820) Operating income before service department charges $798,270 $299,250 $279,180 Service department charges (467,280) (177,156) (166,320) Operating income $330,990 $122,094 $112,860 Additional financial data from the three divisions of the McLaren Company are shown. Division A Division B Division C Invested assets $1,100,000 $665,000 $450,000 Calculate the return on investment for each division. If required, round the…
Homework 1 In an effort to resolve the problem, the company wants to prepare an income statement segmented by division. Accordingly, the Accounting Department provided the following information: Sales Variable expenses as a percentage of sales. Traceable fixed expenses Required 1 Required 2A Required 28. Complete this question by entering your answers in the tabs below. Net operating income will East $ 392,000 Required: 1. Prepare a contribution format income statement segmented by divisions. 2-a. The Marketing Department believes increasing the West Division's monthly advertising by $28,000 will increase that division's sales by 16%. Assuming these estimates are accurate, how much would the company's net operating income increase (decrease) if the proposal is implemented? 2-b. Would you recommend the increased advertising? increase 52% by $ 299,000
Please send answer in chart set up Megamart, a retailer of consumer goods, provides the following information on two of its departments (each considered an investment center). Investment Center Sales Income AverageInvested Assets Electronics $ 39,840,000 $ 2,988,000 $ 16,600,000 Sporting goods 25,200,000 2,142,000 12,600,000 1. Compute return on investment for each department. Using return on investment, which department is most efficient at using assets to generate returns for the company?2. Assume a target income level of 11% of average invested assets. Compute residual income for each department. Which department generated the most residual income for the company?3. Assume the Electronics department is presented with a new investment opportunity that will yield a 15% return on investment. Should the new investment opportunity be accepted?
Please send answer in chart format Megamart, a retailer of consumer goods, provides the following information on two of its departments (each considered an investment center). Investment Center Sales Income AverageInvested Assets Electronics $ 39,840,000 $ 2,988,000 $ 16,600,000 Sporting goods 25,200,000 2,142,000 12,600,000 Compute profit margin and investment turnover for each department. Which department generates the most net income per dollar of sales? Which department is most efficient at generating sales from average invested assets?
A company's two divisions report the information below. Sales Electronics $ 81,000 Sporting Goods $40,000 Income 5,670 4,100 Average assets 40,500 25,000 Enter answers in the tabs below. Required 1 Required 2 Required 3 Calculate profit margin for each division. Division Electronics Sporting Goods Profit margin Numerator: Denominator: Profit margin Required 2 >
The following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales, Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?
The following revenue data were taken from the December 31, 2017, General Electric annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales. Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?
Customers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.
Profit Margin, Investment Turnover, and ROI Cash Company has income from operations of $19,754, invested assets of $83,000, and sales of $282,200. Use the DuPont formula to compute the return on investment. If required, round your answers to two decimal places. a. Profit margin fill in the blank 1% b. Investment turnover fill in the blank 2 c. Return on investment fill in the blank 3%
Saved Compute return on investment for each of the divisions below (each is an investment center). Which division performed the best, based on return on investment? Complete this question by entering your answers in the tabs below. Performance Based on ROI Return on Investment Compute return on investment for each of the divisions below (each is an investment center). (Round your final answers to 1 decimal place.) Average Assets Return on Investment Investment Center Net Income Cameras and camcorders 2$ 6,118,000 $ 26,600,000 Phones and communications 3,628,500 17,700,000 % Computers and accessories 2,106,000 10,800,000 K Returm on Investment Performance Based on ROI >