Concept explainers
Pacific Rim Industries is a diversified company whose products are marketed both domestically and internationally. The company’s major product lines are furniture, sports equipment, and household appliances. At a recent meeting of Pacific Rim’s board of directors, there was a lengthy discussion on ways to improve overall corporate profitability. The members of the board decided that they required additional financial information about individual corporate operations in order to target areas for improvement.
Danielle Murphy, the controller, has been asked to provide additional data that would assist the board in its investigation. Murphy believes that income statements, prepared along both product lines and geographic areas, would provide the directors with the required insight into corporate operations. Murphy had several discussions with the division managers for each product line and compiled the following information from these meetings.
- 1. The division managers concluded that Murphy should allocate fixed manufacturing overhead to both product lines and geographic areas on the basis of the ratio of the variable costs expended to total variable costs.
- 2. Each of the division managers agreed that a reasonable basis for the allocation of
depreciation on plant and equipment would be the ratio of units produced per product line (or per geographical area) to the total number of units produced. - 3. There was little agreement on the allocation of administrative and selling expenses, so Murphy decided to allocate only those expenses that were traceable directly to a segment. For example, manufacturing staff salaries would be allocated to product lines, and sales staff salaries would be allocated to geographic areas. Murphy used the following data for this allocation.
- 4. The division managers were able to provide reliable sales percentages for their product lines by geographical area.
Murphy prepared the following product-line income statement based on the data presented above.
Required:
- 1. Prepare a segmented income statement for Pacific Rim Industries based on the company’s geographical areas. The statement should show the operating income for each segment.
- 2. As a result of the information disclosed by both segmented income statements (by product line and by geographic area), recommend areas where Pacific Rim Industries should focus its attention in order to improve corporate profitability.
1.
Prepare a segmented income statement for Industry P based on the geographical areas of the company.
Explanation of Solution
Segment reporting: Segment reporting refers to the process of preparing accounting report by segment and for the entire organization. Several organizations prepare segmented income statements to show the income for major segments and for the enterprise as a whole.
Prepare a segmented income statement:
Figure (1)
Working notes:
(1)Calculate sales in units:
Total Units | × | % of Sales | = | Units Sold | |
Country U | |||||
Furniture | 160,000 | × | 0.4 | = | 64,000 |
Sports | 180,000 | × | 0.4 | = | 72,000 |
Appliances | 160,000 | × | 0.2 | = | 32,000 |
Country C | |||||
Furniture | 160,000 | × | 0.1 | = | 16,000 |
Sports | 180,000 | × | 0.4 | = | 72,000 |
Appliances | 160,000 | × | 0.2 | = | 32,000 |
Continent A | |||||
Furniture | 160,000 | × | 0.5 | = | 80,000 |
Sports | 180,000 | × | 0.2 | = | 36,000 |
Appliances | 160,000 | × | 0.6 | = | 96,000 |
Table (1)
(2)Calculate revenue:
Units Sold (a) |
Unit Price (b) |
Revenue | |
Country U | |||
Furniture | 64,000 | $8.00 | $ 512,000 |
Sports | 72,000 | $20 | $1,440,000 |
Appliances | 32,000 | $15 | $480,000 |
Country C | |||
Furniture | 16,000 | $8 | $128,000 |
Sports | 72,000 | $20 | $1,440,000 |
Appliances | 32,000 | $15 | $480,000 |
Continent A | |||
Furniture | 80,000 | $8 | $640,000 |
Sports | 36,000 | $20 | $720,000 |
Appliances | 96,000 | $15 | $1,440,000 |
Table (2)
(3)Calculate variable costs:
Units Sold (a) |
Variable manufacturing Cost per unit (b) |
Variable selling Cost per unit (c) |
Total variable cost | |
Country U | ||||
Furniture | 64,000 | $4 | $2 | $384,000 |
Sports | 72,000 | $10 | $3 | $864,000 |
Appliances | 32,000 | $8 | $2 | $336,000 |
Country C | ||||
Furniture | 16,000 | $4 | $2 | $96,000 |
Sports | 72,000 | $10 | $3 | $864,000 |
Appliances | 32,000 | $8 | $2 | $336,000 |
Continent A | ||||
Furniture | 80,000 | $4 | $2 | $480,000 |
Sports | 36,000 | $10 | $3 | $432,000 |
Appliances | 96,000 | $8 | $2 | $1,008,000 |
Table (3)
(4)Calculate manufacturing overhead:
Total Manufacturing Overhead (a) | Area Variable costs |
Proportion of Total (b) |
Allocated Manufacturing Cost | |
Country U | $500,000 | $1,584,000 | 33% | $165,000 |
Country C | $500,000 | $1,296,000 | 27% | $135,000 |
Continent A | $500,000 | $1,920,000 | 40% | $200,000 |
Total | $4,800,000 | $500,000 |
Table (4)
(5)Calculate depreciation expense:
Total Manufacturing Overhead (a) | Area Variable costs |
Proportion of Total (b) |
Allocated Manufacturing Cost | |
Country U | $400,000 | $168,000 | 33.60% | $134,400 |
Country C | $400,000 | $120,000 | 24.00% | $96,000 |
Continent A | $400,000 | $212,000 | 42.40% | $ 169,600 |
Total | $500,000 | $400,000 |
Table (5)
2.
Recommend areas in which Industry P must focus its attention in order to improve corporate profitability.
Explanation of Solution
Areas where the management of the company must focus its attention in order to enhance corporate profitability include the following:
The income statement by product line provides that the furniture product might not be profitable. The product line of furniture does not have a “positive contribution”. Conversely, the “fixed costs allocated” to the product line will result in a loss. The management must investigate the following factors:
- Discontinuing the manufacture of furniture and focusing on the other product lines that are profitable more.
- Cutting variable costs linked with product line of furniture.
- The probability of maximizing volume by cutting prices or increasing advertising will result in a larger total contribution margin.
- The probability of maximizing the selling price of these products.
- Calculate the amount of fixed costs assigned to furniture is separable if the product line is dropped.
Want to see more full solutions like this?
Chapter 12 Solutions
Loose-Leaf for Managerial Accounting: Creating Value in a Dynamic Business Environment
- Richmond, Inc., operates a chain of 44 department stores. Two years ago, the board of directors of Richmond approved a large-scale remodeling of its stores to attract a more upscale clientele. Before finalizing these plans, two stores were remodeled as a test. Linda Perlman, assistant controller, was asked to oversee the financial reporting for these test stores, and she and other management personnel were offered bonuses based on the sales growth and profitability of these stores. While completing the financial reports, Perlman discovered a sizable inventory of outdated goods that should have been discounted for sale or returned to the manufacturer. She discussed the Situation with her management colleagues; the consensus was to ignore reporting this inventory as obsolete because reporting it would diminish the financial results and their bonuses. Required: According to the IMA’s Statement of Ethical Professional Practice, would it be ethical for Perlman not to report the inventory…arrow_forwardWYZ Ltd. is a manufacturing company incorporated in Ghana under the Companies Act of 2019, Act 992. After successfully conducting their external and internal audits, the company formulated and implemented some of the best strategic moves in the manufacturing industry. However, several factors hampered the delivery of the desired outcomes and the company continued to struggle with their competitiveness for several years. Required: As a Strategist, recommend five (5) issues, covering; management, marketing, finance & accounting, human resource and MIS, that could be responsible for the firm’s inability to successfully implement their strategies and meet strategy expectations.arrow_forwardEthics and the ManagerRichmond, Inc., operates a chain of 44 department stores. Two years ago, the board of directors of Richmond approved a large-scale remodelling of its stores to attract a more upscale clientele.Before finalizing these plans, two stores were remodelled as a test. Linda Perlman, assistant controller, was asked to oversee the financial reporting for these test stores, and she and other management personnel were offered bonuses based on the sales growth and profitability of these stores. While completing the financial reports, Perlman discovered a sizable inventory of outdated goods that should have been discounted for sale or returned to the manufacturer. She discussed the situation with her management colleagues; the consensus was to ignore reporting this inventory as obsolete because reporting it would diminish the financial results and their bonuses.1. Managerial Accounting2. Would it be easy for Perlman to take the ethical action in this situation?arrow_forward
- The CEO of the Baker Inc, wants to implement a new accounting system, to improve work flow through the company’s sales, cash receipts, accounts payable, and cash disbursement procedures. The CEO is, however, concerned about the potential disruption that the implementation will have on operations. In an announcement letter to Baker’s employees, the CEO stated that: “I have contracted Flybynight Consulting Group to do the needs analysis, system selection, and design work. The programming and implementation will be performed in-house using existing IT department staff. The development process will be unobtrusive to user departments because Flybynight knows what needs to be done. They will work independently, in the background, and will not disrupt departmental and internal audit work flow with time consuming interviews, surveys, and questionnaires. This promises to be an efficient process that will produce a system that will be appreciated by all users.” Required: Draft a memo from George…arrow_forwardConsider the following conversation between Leonard Bryner, president and manager of a firm engaged in job manufacturing, and Chuck Davis, certified management accountant, the firms controller. Leonard: Chuck, as you know, our firm has been losing market share over the past 3 years. We have been losing more and more bids, and I dont understand why. At first, I thought that other firms were undercutting simply to gain business, but after examining some of the public financial reports, I believe that they are making a reasonable rate of return. I am beginning to believe that our costs and costing methods are at fault. Chuck: I cant agree with that. We have good control over our costs. Like most firms in our industry, we use a normal job-costing system. I really dont see any significant waste in the plant. Leonard: After talking with some other managers at a recent industrial convention, Im not so sure that waste by itself is the issue. They talked about activity-based management, activity-based costing, and continuous improvement. They mentioned the use of something called activity drivers to assign overhead. They claimed that these new procedures can help to produce more efficiency in manufacturing, better control of overhead, and more accurate product costing. A big deal was made of eliminating activities that added no value. Maybe our bids are too high because these other firms have found ways to decrease their overhead costs and to increase the accuracy of their product costing. Chuck: I doubt it. For one thing, I dont see how we can increase product-costing accuracy. So many of our costs are indirect costs. Furthermore, everyone uses some measure of production activity to assign overhead costs. I imagine that what they are calling activity drivers is just some new buzzword for measures of production volume. Fads in costing come and go. I wouldnt worry about it. Ill bet that our problems with decreasing sales are temporary. You might recall that we experienced a similar problem about 12 years agoit was 2 years before it straightened out. Required: 1. Do you agree or disagree with Chuck Davis and the advice that he gave Leonard Bryner? Explain. 2. Was there anything wrong or unethical in the behavior that Chuck Davis displayed? Explain your reasoning. 3. Do you think that Chuck was well informedthat he was aware of the accounting implications of ABC and that he knew what was meant by cost drivers? Should he have been well informed? Review (in Chapter 1) the first category of the Statement of Ethical Professional Practice for management accountants. Do any of these standards apply in Chucks case?arrow_forwardHatfield Medical Supplys stock price had been lagging its industry averages, so its board of directors brought in a new CEO, Jaiden Lee. Lee had brought in Ashley Novak, a finance MBA who had been working for a consulting company, to replace the old CFO, and Lee asked Novak to develop the financial planning section of the strategic plan. In her previous job, Novaks primary task had been to help clients develop financial forecasts, and that was one reason Lee hired her. Novak began by comparing Hatfields financial ratios to the industry averages. If any ratio was substandard, she discussed it with the responsible manager to see what could be done to improve the situation. The following data show Hatfields latest financial statements plus some ratios and other data that Novak plans to use in her analysis. Hatfield Medical Supply (Millions of Dollars, Except per Share Data) Selected Additional Data for 2019 Using Hatfields data and its industry averages, how well run would you say Hatfield appears to be in comparison with other firms in its industry? What are its primary strengths and weaknesses? Be specific in your answer and point to various ratios that support your position. Also, use the DuPont equation (see Chapter 3) as one part of your analysis.arrow_forward
- Hatfield Medical Supplys stock price had been lagging its industry averages, so its board of directors brought in a new CEO, Jaiden Lee. Lee had brought in Ashley Novak, a finance MBA who had been working for a consulting company, to replace the old CFO, and Lee asked Novak to develop the financial planning section of the strategic plan. In her previous job, Novaks primary task had been to help clients develop financial forecasts, and that was one reason Lee hired her. Novak began by comparing Hatfields financial ratios to the industry averages. If any ratio was substandard, she discussed it with the responsible manager to see what could be done to improve the situation. The following data show Hatfields latest financial statements plus some ratios and other data that Novak plans to use in her analysis. Hatfield Medical Supply (Millions of Dollars, Except Per Share Data) Selected Additional Data for 2018 Using Hatfields data and its industry averages, how well run would you say Hatfield appears to be compared to other firms in its industry? What are its primary strengths and weaknesses? Be specific in your answer, and point to various ratios that support your position. Also, use the DuPont equation (see Chapter 7) as one part of your analysis.arrow_forwardThe OakTree Group is a 75-year old company founded in Hong Kong. The Group comprises of two majorbusinesses: a publishing business known as Fairmont Publishing and an insurance business namedGeneralife. The Group is currently organized in a decentralized manner with two businesses running asinvestment centers. However, with the recent retirement of many senior staff in OakTree, the CEO is verymuch concerned regarding the performance of the company under a new generation of leadership. In fact,the CEO is considering the possibility of restructuring the Group into a centralized structure.Fairmont Publishing is organized as a divisional structure with the presence of two divisions: Printed Mediaand Online Media. The following are summary financial information for 2019 and 2020: Printed Media Online Media 2019 2020 2019 2020 sale $18900 $19320 $25200 $26880 SG&A expenses $6590 $6520 $6092 $8564 Current assets $5670 $6600 $4050…arrow_forwardThe OakTree Group is a 75-year old company founded in Hong Kong. The Group comprises of two majorbusinesses: a publishing business known as Fairmont Publishing and an insurance business namedGeneralife. The Group is currently organized in a decentralized manner with two businesses running asinvestment centers. However, with the recent retirement of many senior staff in OakTree, the CEO is verymuch concerned regarding the performance of the company under a new generation of leadership. In fact,the CEO is considering the possibility of restructuring the Group into a centralized structure.Fairmont Publishing is organized as a divisional structure with the presence of two divisions: Printed Mediaand Online Media. The following are summary financial information for 2019 and 2020: printed media Online Media 2019 2020 2019 2020 sale $18900 $19320 $25200 $26880 SG&A expenses $6590 $6520 $6092 $8564 Current assets $5670 $6600 $4050…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning