Activity-based costing, merchandising. Pharmahelp, Inc., a distributor of special pharmaceutical products, operates at capacity and has three main market segments:
- a. General supermarket chains
- b. Drugstore chains
- c. Mom-and-pop single-store pharmacies
Rick Flair, the new controller of Pharmahelp, reported the following data for 2017.
For many years, Pharmahelp has used gross margin percentage
[(Revenue– Cost of goods sold) ÷ Revenue] to evaluate the relative profitability of its market segments. But Flair recently attended a seminar on activity-based costing and is considering using it at Pharmahelp to analyze and allocate “other operating costs.” He meets with all the key managers and several of his operations and sales staff, and they agree that there are five key activities that drive other operating costs at Pharmahelp:
Activity Area | Cost Driver |
Order processing | Number of customer purchase orders |
Line-item processing | Number of line items ordered by customers |
Delivering to stores | Number of store deliveries |
Cartons shipped to store | Number of cartons shipped |
Stocking of customer store shelves | Hours of shelf-stocking |
Each customer order consists of one or more line items. A line item represents a single product (such as Extra-Strength Tylenol Tablets). Each product line item is delivered in one or more separate cartons. Each store delivery entails the delivery of one or more cartons of products to a customer. Pharmahelp’s staff stacks cartons directly onto display shelves in customers’ stores. Currently, there is no additional charge to the customer for shelf-stocking and not all customers use Pharmahelp for this activity. The level of each activity in the three market segments and the total cost incurred for each activity in 2017 is as follows:
- 1. Compute the 2017 gross-margin percentage for each of Pharmahelp’s three market segments.
Required
- 2. Compute the cost driver rates for each of the five activity areas.
- 3. Use the activity-based costing information to allocate the $301,080 of “other operating costs” to each of the market segments. Compute the operating income for each market segment.
- 4. Comment on the results. What new insights are available with the activity-based costing information?
Want to see the full answer?
Check out a sample textbook solutionChapter 5 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
- please another help, thanks :)arrow_forwardCalculate customer-level operating incomearrow_forwardThe Chocolate Baker specializes in chocolate baked goods. The firm has long assessed the profitability of a product line by comparing revenues to the cost of goods sold. However, Barry Love, the firm’s new accountant, wants to use an activity-based costing system that takes into consideration the cost of the delivery person. Listed below are activity and cost information relating to two of Chocolate Baker’s major products. Muffins Cheesecake Revenue $53,000 $46,000 Cost of goods sold 26,000 21,000 Delivery activity: Number of deliveries 150 85 Average length of delivery 10 minutes 15 minutes Cost per hour for delivery $20.00 $20.00 Using activity-based costing, which one of the following statements is correct? A. The cheesecakes are $75 more profitable. B. The muffins have a higher profitability as a percentage of sales and therefore are more advantageous. C. The muffins are $2,000 more…arrow_forward
- Prepare a customer-cost hierarchy reportarrow_forwardThis cost data from Hickory Furniture is for the year 2017. Using the high-low method, express the companys utility costs as an equation where X represents number of tables produced. Predict the utility costs if 800 tables are produced. Predict the utility costs if 600 tables are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between number of tables produced and utility expenses.arrow_forwardCustomer profitability, distribution. Best Drugs is a distributor of pharmaceutical products. Its ABC system has five activities:arrow_forward
- Comparison of variable costing and absorption costing. Gammaro Company uses standard costing. Tim Sweeney, the new president of Gammaro Company, is presented with the following data for 2017:arrow_forwardProduct Profitability Analysis Galaxy Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVS), the Conquistador and Hurricane, from a single manufacturing facility. The manufacturing facility operates at 100% of capacity. The following per-unit information is available for the two products: Conquistador Hurricane Sales price $4,800 $3,200 Variable cost of goods sold (3,020) (2,140) Manufacturing margin $1,780 $1,060 Variable selling expenses (964) (548) Contribution margin $816 $512 Fixed expenses (380) (200) Operating income $436 $312 In addition, the following sales unit volume information for the period is as follows: Conquistador 2,800 Hurricane 2,000 Sales unit volume a. Prepare a contribution margin by product report. Compute the contribution margin ratjo for each product as a whole percent. Galaxy Sports Inc. Contribution Margin by Productarrow_forwardCole Company sells both designer and moderately priced fashion accessories. Top management is deciding which product line to emphasize. Accountants have provided the following data: (Click the icon to view the data.) Prepare an analysis to show which product the company should emphasize. (Enter the units displayed per square foot and the contribution marain per square foot to two decimal places.) Units displayed per square foot: Designer Moderately priced Contribution margin per unit Contribution margin per square foot of display space Capacity-Square feet of display space Total contribution margin at capacity Show Transcribed Text Data table CO Average sale price Average variable costs Average contribution margin Average fixed costs (allocated) Average operating income. Designer $ $ Ĉ Product Moderately Priced Per Item Designer Moderately Priced 210 $ 100 110 15 95 $ 85 21 64 5 59 The Cole Company store in Grand Junction, Colorado, has 15,000 square feet of floor space. If Cole…arrow_forward
- Following is the revenue and cost data for Metlock Ltd. in the manufacturing of luxury shower curtains for the year ended December 31, 2022: NewsVariable manufacturing costs $34 per curtainVariable selling and administrative expenses $8 per curtain Fixed manufacturing overhead $53,900Fixed selling and administrative expenses $184,800 Units produced and sold 7, 700Selling price $84 per curtain. Prepare an income statement using absorption costing. Prepare an income statement using variable costing.arrow_forwardQue. No. 1a. When production is greater than sales which method’s net operating income will be higher, AC or VC and why? Be precise and to the point in writing the answer. Que. No. 1b. Sharp Company manufactures a product for which the following data and information related to inventory is available. The company uses variable costing for internal management reports and absorption costing for external reports to the shareholders, creditors, and the government. The company has provided the following data:Year-1Year-2Year-3Inventories:Beginning (units)200160180Ending (units)160180220Variable Costing net operating income$1,080,400$1,032,400$996,400The company’s fixed manufacturing overhead per unit was constant at $650 for all the three years.Required: 1. Determine each year’s absorption costing net operating income. Present your answer in the form of a reconciliation report. (you must show all calculations)2. In year four, the company’s variable costing net operating income was $984,400…arrow_forwardVariable versus absorption costing. The Tomlinson Company manufactures trendy, high-quality, moderately priced watches. As Tomlinson’s senior financial analyst, you are asked to recommend a method of inventory costing. The CFO will use your recommendation to prepare Tomlinson’s 2017 income statement. The following data are for the year ended December 31, 2017:arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College