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
Managerial Accounting: Creating Value in a Dynamic Business Environment
- Island Solutions is a technology business that retails and wholesales computer hardware along with awide variety of technology products and solution services. Recently, several competitors have enteredthe market and introduced new products that might drive some of the business’ inventory intoobsolescence. The company has always been IRFS compliant and wants to ensure that it follows theappropriate authoritative literature in determining the accounting for some significant market changes.The accountant at Island Solutions has tasked two small teams of interns to conduct several pieces of research and dry-run practices. The following data is available for the month of September for two items of inventory that mightsoon be render obsolete for Island Solutions.Inventory balances at September 1, 2023, were as follows:USB-C (TA3) Hub – 200 @ $400 ea.USB-C (TB3) Hub – 600 @ $800 ea. USB-C (TA3) HUB Date Purchases Sales Sep 5 500 @450 Sep 10 500@540 Sep 15 400 @475 Sep 20…arrow_forwardIsland Solutions is a technology business that retails and wholesales computer hardware along with awide variety of technology products and solution services. Recently, several competitors have enteredthe market and introduced new products that might drive some of the business’ inventory intoobsolescence. The company has always been IRFS compliant and wants to ensure that it follows theappropriate authoritative literature in determining the accounting for some significant market changes.The accountant at Island Solutions has tasked two small teams of interns from to conduct several pieces of research and dry-run practices. The following data is available for the month of September for two items of inventory that mightsoon be render obsolete for Island Solutions.Inventory balances at September 1, 2023, were as follows:USB-C (TA3) Hub – 200 @ $400 ea.USB-C (TB3) Hub – 600 @ $800 ea. USB-C (TA3) HUB Date Purchases Sales Sep 5 500 @450 Sep 10 500@540 Sep 15 400 @475…arrow_forwardEthics and the Manager 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: 1. According to the IMA’s Statement of Ethical Professional Practice, would it be ethical for Perlman not…arrow_forward
- Todd Johnson is the vice president of Finance for Boz Zeppelin Industries, Inc. At a recent finance meeting, Todd made the following statement: “The managers of a company should use the same information as the shareholders of the firm. When managers use the same information to guide their internal operations as shareholders use in evaluating their investments, the managers will be aligned with the stockholders’ profit objectives.” Prepare a one-half page memo to Todd discussing any concerns you might have with his statement.arrow_forwardRichmond, 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_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
- Assume that you have finished your MBA program and have applied for a position in the FinancialAccounting Department of a large multinational company. The company is struggling with itsaccounting reporting matters and several accounting reports are under regulatory scrutiny. In theinterview board, the recruitment committee members have asked you the following questions. How can you contribute the Financial Accounting Department of this company if youare recruited?arrow_forwardCamila’s Classic Clothes is a retailer that sells to professional women in the northeast. The firm leases space for stores in upscale shopping centers, and the organizational structure consists of regions, districts, and stores. Each region consists of two or more districts; each district consists of three or more stores. Each store, district, and region has been established as a profit center. At all levels, the company uses a responsibility-accounting system focusing on information and knowledge rather than blame and control. Each year, managers, in consultation with their supervisors, establish financial and nonfinancial goals, and these goals are integrated into the budget. Actual performance is measured each month. The New England Region consists of the Coastal District and the Inland District. The Coastal District includes the New Haven, Boston, and Portland stores. The Coastal District’s performance has not been up to expectations in the past. For the month of May, the district…arrow_forwardCathy’s Classic Clothes is a retailer that sells to professional women in the northeast. The firm leases space for stores in upscale shopping centers, and the organizational structure consists of regions, districts, and stores. Each region consists of two or more districts; each district consists of three or more stores. Each store, district, and region has been established as a profit center. At all levels, the company uses a responsibility-accounting system focusing on information and knowledge rather than blame and control. Each year, managers, in consultation with their supervisors, establish financial and nonfinancial goals, and these goals are integrated into the budget. Actual performance is mea-sured each month.The New England Region consists of the Coastal District and the Inland District. The Coastal District includes the New Haven, Boston, and Portland stores. The Coastal District’s performance has not been up to expectations in the…arrow_forward
- Ladbrecks was founded by members of the Ladbreck family in the 1880s. The first store opened under the name Ladbreck Dry Goods. Building on its history of excellence in customer service, the company initiated its performance-based incentive plan to support its stated firm-wide strategy of "customer emphasis" with "employee empowerment." Management expected it to result in further enhancement of customer service and, consequently, in an increase in sales generated at its stores. The plan was implemented in stores sequentially as company managers intended to examine and evaluate the plan's impact on sales and profitability. By the end of 1994, ten stores had implemented the plan. In 1995, ten more stores implemented the plan, bringing the total to 20 out of a total of 50. Management decided to call you in to provide an independent assessment. While the company thought that sales had increased with the plan's implementation, the human resource department did not know exactly…arrow_forwardTesla, the world’s largest carmaker (as determined by market capitalization), understands that their primary target market responds well to brands that focus on social responsibility. Tesla’s senior management has been meeting to devise a global marketing campaign centered on social responsibility. To this end, Tesla decided to hire a consultancy to develop a 9-month plan ending December 31, 2022. Management has asked for a presentation for an initial list of items that would be considered valid elements of a social responsibility marketing plan that would accommodate each of the markets that Tesla competes in. Questions: What type of research would the consultancy conduct to understand each of the wide variety of cultures that the brand competes in? Armed with this researched information, how might the consultancy modify its social responsibility campaigns to accommodate some of the major markets?arrow_forwardRay is a finance director in a public sector organization that has experienced difficulty attracting and retaining skilled staff. To assist in overcoming this problem, the board has engaged a consultant to recommend an improved benefits structure, to apply to all staff. The consultant has produced his report, and Ray has been asked to consider the proposed staff benefits structure, and make appropriate recommendations to the board. He study the report, conduct appropriate research, and assess the costs involved. He concludes that it will be necessary to increase staff costs, but believes these will be offset by the efficiencies brought about by recruiting and retaining high-quality staff. The report contains the following recommendations: Benefits should be related to the length of service of members of staff. After one year of continuous employment, a member of staff will qualify for private health insurance. Private health insurance should cover the member of staff and his or her…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE LAuditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub