Horngren's Cost Accounting, Student Value Edition (16th Edition)
16th Edition
ISBN: 9780134476032
Author: Srikant M. Datar, Madhav V. Rajan
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 5, Problem 5.37P
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?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Customer profitability, customer-cost hierarchy. Enviro-Tech has only two retail and two wholesale customers. Information
relating to each customer for 2017 follows (in thousands):
Wholesale Customers
Retail Customers
North America
South America
Wholesaler
Wholesaler
Green Energy
Global Power
Revenues at list prices
Discounts from list prices
Cost of goods sold
Delivery costs
Order processing costs
$375,000
25,800
$590,000
$175,000
$130,000
47,200
8,400
590
285,000
510,000
144,000
95,000
2,230
2,180
4,550
6,710
2,145
3,820
5,980
1,130
Cost of sales visit
6,300
2,620
2,620
1,575
Enviro-Tech's annual distribution-channel costs are $33 million for wholesale customers and $12 million for retail
customers. The company's annual corporate-sustaining costs, such as salary for top management and general-
administration costs are $48 million. There is no cause-and-effect or benefits-received relationship between any cost-
allocation base and corporate-sustaining costs. That is, Enviro-Tech could…
How might Enviro-Tech use the new cost information from its activity-based costing system to better manage its business?
Recalculate the customer-level operating income using the number of written orders but at their actual $8 cost per order instead of $15 (except for DC, whose actual cost is $15 per order). How will KC Corporation evaluate customer-level operating cost performance this period?
Chapter 5 Solutions
Horngren's Cost Accounting, Student Value Edition (16th Edition)
Ch. 5 - What is broad averaging, and what consequences can...Ch. 5 - Why should managers worry about product...Ch. 5 - What is costing system refinement? Describe three...Ch. 5 - What is an activity-based approach to designing a...Ch. 5 - Describe four levels of a cost hierarchy.Ch. 5 - Why is it important to classify costs into a cost...Ch. 5 - What are the key reasons for product cost...Ch. 5 - Prob. 5.8QCh. 5 - Department indirect-cost rates are never...Ch. 5 - Prob. 5.10Q
Ch. 5 - Prob. 5.11QCh. 5 - Prob. 5.12QCh. 5 - Activity-based costing is the wave of the present...Ch. 5 - Increasing the number of indirect-cost pools is...Ch. 5 - The controller of a retail company has just had a...Ch. 5 - Conroe Company is reviewing the data provided by...Ch. 5 - Prob. 5.17MCQCh. 5 - Cost hierarchy. Roberta, Inc., manufactures...Ch. 5 - ABC, cost hierarchy, service. (CMA, adapted)...Ch. 5 - Alternative allocation bases for a professional...Ch. 5 - Plant-wide, department, and ABC Indirect cost...Ch. 5 - Plant-wide, department, and activity-cost rates....Ch. 5 - ABC, process costing. Sander Company produces...Ch. 5 - Department costing, service company. DLN is an...Ch. 5 - Activity-based costing, service company....Ch. 5 - Activity-based costing, manufacturing. Decorative...Ch. 5 - ABC, retail product-line profitability. Fitzgerald...Ch. 5 - Prob. 5.28ECh. 5 - Activity-based costing. The job-costing system at...Ch. 5 - ABC, product costing at banks,...Ch. 5 - Problems 5-31 Job costing with single direct-cost...Ch. 5 - Job costing with multiple direct-cost categories,...Ch. 5 - Job costing with multiple direct-cost categories,...Ch. 5 - First-stage allocation, time-driven activity-based...Ch. 5 - First-stage allocation, time-driven activity-based...Ch. 5 - Department and activity-cost rates, service...Ch. 5 - Activity-based costing, merchandising. Pharmahelp,...Ch. 5 - Choosing cost drivers, activity-based costing,...Ch. 5 - ABC, health care. Crosstown Health Center runs two...Ch. 5 - Unused capacity, activity-based costing,...Ch. 5 - Unused capacity, activity-based costing,...Ch. 5 - ABC, implementation, ethics. (CMA, adapted) Plum...Ch. 5 - Activity-based costing, activity-based management,...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- 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
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial 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
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Inspection and Quality control in Manufacturing. What is quality inspection?; Author: Educationleaves;https://www.youtube.com/watch?v=Ey4MqC7Kp7g;License: Standard youtube license