Using a product profitability report to guide strategic decisions
The controller of Boom Box Sounds Inc. prepared the following product profitability report for management, using activity-based costing methods for allocating both the factory overhead and the marketing expenses. As such, the controller has confidence in the accuracy of this report. In addition, the controller interviewed the vice president of marketing, who indicated that the floor loudspeakers were an older product that was highly recognized in the marketplace. The ribbon loudspeakers were a new product that was recently launched. The ribbon loudspeakers are a new technology that have no competition in the marketplace, and it is hoped that they will become an important future addition to the company’s product portfolio. Initial indications are that the product is well received by customers. The controller believes that the
Floor Loudspeakers | Bookshelf Loudspeakers | Ribbon Loudspeakers | Totals | |
Sales | $ 1,500,000 | $ 1,200,000 | $900,000 | $3,600,000 |
Less cost of goods sold | 1,050,000 | 720,000 | 810,000 | 2,580,000 |
Gross profit | $ 450,000 | $ 480,000 | $ 90,000 | $ 1,020,000 |
Less marketing expenses | 600,000 | 120,000 | 72,000 | 792,000 |
Income from operations | $ (150,000) | $360,000 | $ 18,000 | $ 228,000 |
- 1. Calculate the gross profit and income from operations to sales ratios for each product.
- 2. Write a memo using the product profitability report and the calculations in (I) to make recommendations to management with respect to strategies for the three products.
Want to see the full answer?
Check out a sample textbook solutionChapter 26 Solutions
Bundle: Financial & Managerial Accounting, 13th + Working Papers, Volume 1, Chapters 1-15 For Warren/reeve/duchac’s Corporate Financial Accounting, ... 13th + Cengagenow™v2, 2 Terms Access Code
- Randy Harris, controller, has been given the charge to implement an advanced cost management system. As part of this process, he needs to identify activity drivers for the activities of the firm. During the past four months, Randy has spent considerable effort identifying activities, their associated costs, and possible drivers for the activities costs. Initially, Randy made his selections based on his own judgment using his experience and input from employees who perform the activities. Later, he used regression analysis to confirm his judgment. Randy prefers to use one driver per activity, provided that an R2 of at least 80 percent can be produced. Otherwise, multiple drivers will be used, based on evidence provided by multiple regression analysis. For example, the activity of inspecting finished goods produced an R2 of less than 80 percent for any single activity driver. Randy believes, however, that a satisfactory cost formula can be developed using two activity drivers: the number of batches and the number of inspection hours. Data collected for a 14-month period are as follows: Required: 1. Calculate the cost formula for inspection costs using the two drivers, inspection hours and number of batches. Are both activity drivers useful? What does the R2 indicate about the formula? 2. Using the formula developed in Requirement 1, calculate the inspection cost when 300 inspection hours are used and 30 batches are produced. Prepare a 90 percent confidence interval for this prediction.arrow_forwardConstruct and interpret a product profitability report, allocating selling and administrative expenses Naper Inc. manufactures power equipment. Naper has two primary productsgenerators and air compressors. The following report was prepared by the controller for Napers senior marketing management for the year ended December 31: The marketing management team was concerned that the selling and administrative expenses were not traced to the products. Marketing management believed that some products consumed larger amounts of selling and administrative expense than did other products. To verify this, the controller was asked to prepare a complete product profitability report, using activity-based costing. The controller determined that selling and administrative expenses consisted of two activities: sales order processing and post-sale customer service. The controller was able to determine the activity base and activity rate for each activity, as follows: The controller determined the following activity-base usage information about each product: Determine the activity cost of each product for sales order processing and post-sale customer service activities. Use the information in (A) to prepare a complete product profitability report dated for the year ended December 31. Compute the gross profit to sales and the operating income to sales percentages for each product. (Round to two decimal places.) Interpret the product profitability report. How should management respond to the report?arrow_forwardTom Young, vice president of Dunn Company (a producer of plastic products), has been supervising the implementation of an activity-based cost management system. One of Toms objectives is to improve process efficiency by improving the activities that define the processes. To illustrate the potential of the new system to the president, Tom has decided to focus on two processes: production and customer service. Within each process, one activity will be selected for improvement: molding for production and sustaining engineering for customer service. (Sustaining engineers are responsible for redesigning products based on customer needs and feedback.) Value-added standards are identified for each activity. For molding, the value-added standard calls for nine pounds per mold. (Although the products differ in shape and function, their size, as measured by weight, is uniform.) The value-added standard is based on the elimination of all waste due to defective molds (materials is by far the major cost for the molding activity). The standard price for molding is 15 per pound. For sustaining engineering, the standard is 60 percent of current practical activity capacity. This standard is based on the fact that about 40 percent of the complaints have to do with design features that could have been avoided or anticipated by the company. Current practical capacity (the first year) is defined by the following requirements: 18,000 engineering hours for each product group that has been on the market or in development for five years or less, and 7,200 hours per product group of more than five years. Four product groups have less than five years experience, and 10 product groups have more. There are 72 engineers, each paid a salary of 70,000. Each engineer can provide 2,000 hours of service per year. There are no other significant costs for the engineering activity. For the first year, actual pounds used for molding were 25 percent above the level called for by the value-added standard; engineering usage was 138,000 hours. There were 240,000 units of output produced. Tom and the operational managers have selected some improvement measures that promise to reduce non-value-added activity usage by 30 percent in the second year. Selected actual results achieved for the second year are as follows: The actual prices paid per pound and per engineering hour are identical to the standard or budgeted prices. Required: 1. For the first year, calculate the non-value-added usage and costs for molding and sustaining engineering. Also, calculate the cost of unused capacity for the engineering activity. 2. Using the targeted reduction, establish kaizen standards for molding and engineering (for the second year). 3. Using the kaizen standards prepared in Requirement 2, compute the second-year usage variances, expressed in both physical and financial measures, for molding and engineering. (For engineering, explain why it is necessary to compare actual resource usage with the kaizen standard.) Comment on the companys ability to achieve its targeted reductions. In particular, discuss what measures the company must take to capture any realized reductions in resource usage.arrow_forward
- Pareto chart and cost of quality report for a manufacturing company The president of Mission Inc. has been concerned about the growth in costs over the last several years. The president asked the controller to perform an activity analysis to gain a better insight into these costs. The activity analysis revealed the following: The production process is complicated by quality problems, requiring the production manager to expedite production and dispose of scrap. Instructions 1. Prepare a Pareto chart of the company activities. 2. Classify the activities into prevention, appraisal, internal failure, external failure, and not costs of quality (producing product). Classify the activities into value-added and non-value-added activities. 3. Use the activity cost information to determine the percentages of total costs that are prevention, appraisal, internal failure, external failure, and not costs of quality. 4. Determine the percentages of total costs that are value-added and non-value-added. 5. Interpret the information.arrow_forwardThe following situations describe decision scenarios that could use managerial accounting information:1. The manager of High Times Restaurant wants to determine the price to charge for various lunch plates.2. By evaluating the cost of leftover materials, the plant manager of a precision tool facility wants to determine how effectively the plant is being run.3. The division controller of West Coast Supplies needs to determine the cost of products left in inventory.4. The manager of the Maintenance Department of a large manufacturing company wants to plan next year’s anticipated expenditures.For each situation, discuss how managerial accounting information could be used.arrow_forwardConsumer Focus is a marketing research firm that organizes focus groups for consumerproduct companies. A Consumer Focus Staff member attends each session to ensure that all the logistical aspects run smoothly”In light to the above statement, classify each of the following cost items as:a. Direct or Indirect (D or I) costs with respect to each individual focus group.b. Variable or Fixed (V or F) costs with respect to how the total costs of Consumer Focus change as the number of focus groups conducted changes. (If in doubt, select on the basis of whether the total costs will change substantially if there is a large change in the number of groups conducted.)You will have two answers (D or I; V or F) for each of the following items followed by a short interpretation note. Use the sample answer table and continue from Cost Item BCost ItemA. Payment to individual in each focus group to provide comments on new products.B. Annual subscription of Consumer Focus to Consumer Reports magazine.C.…arrow_forward
- The activity-based costing (ABC) system has been used by manufacturing companies for a long period of time. Recently, the ABC system has been used by banks, insurance companies, not-for-profit organizations, government agencies, and service companies. Assume that you were hired as a cost accountant to develop a plan to implement the ABC system for one of these service organizations. Create an ABC system development plan, including detailed steps needed to effectively implement the system. Then present the plan in the discussion. Response should include: A brief background on the organization's main activities. Whether there will be any limitation on implementing the ABC system in the organization selected.arrow_forwardThe manager of the manufacturing unit of a company is responsibie for the costs of the manufacturing unit. The president is in the process of deciring whether to evaluate the manager at the manufacturing unit by the average cost per unit or the vartable cast per unit Quality and umely delivery would be used in coruncion with the cust meesure lo rewerd the maneger Required: a. What problems are associated with using the average cost per unit as a pertormance measure b. What problems are associated with using the variable cost per unt as a performance measure?arrow_forwardWhat are the Costs per unit of Alfa and Beta under traditional and ABC costing systems? What would be the prices of Alpha and Beta traditional and ABC costing systems? Compare the costs and prices calculated in the two systems. Please write down the calculation process!thanks!!!arrow_forward
- Company XYZ Manufacturer Limited is involved in the production of antiseptic products. Recently Company has started manufacturing of Sanitizers due to overwhelming demand of this product in the market. As company has already expertise in production of disinfectants therefore this new product will increase the product line of business. You are required to describe whether this company is involved in Job order costing or Process costing method to calculate product cost also differentiate between these two types. Company’s CEO has directed the financial manger to calculate the total cost of production for sanitizers during the year 2020. For this purpose the accountants have recorded and prepared the following cost data related to production of five thousand sanitizers for year 2020 in company’s accounting record under the title of Job “A111” Indirect Material Rs. 38,000 Other Costs incurred: Rs. Indirect Labor 78,000 Purchases of Raw Material (Both Direct and Indirect)…arrow_forward. The firm You are employed by Maddie's Corp. an Accounting Firm based in Houston has recently been asked by a client, a medium-sized manufacturing company in California to provide advice and recommendations to improve the company's existing costing system. The CEO of the manufacturing company is keen to implement standard costing. Requirement: Draft a report for your client that: a. b. Outlines the purposes of standard costing Explains the operating mechanisms of the standard costing system The company is also looking to expand and wishes to understand the scope, structure and purpose of transfer pricing. Requirement: Draft a report for your client that: C. Explains how transfer pricing worksarrow_forwardPlain Limited produces two standard products, White and Grey. You have recently been appointed as a management accountant along with a new marketing manager, who has several ideas about how to grow the company, including introducing new products with different designs. The company currently absorbs overheads on the basis of units produced, but they have read about a method based on activities undertaken, Activity Based Costing. They have asked you to help them to investigate this method and it’s implication for their business should they decide to implement it in the next accounting year. The current expected output for the existing products during the next year is White 15,000 and Grey 12,000 The company has also provided the following information about the current overhead costs of the business; Overhead activity. Annual costs Cost driver. Amount of activity White…arrow_forward
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning