Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
16th Edition
ISBN: 9780134475585
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
ROI performance measures based on historical cost and current cost. Nature’s Juice Corporation operates three divisions that process and bottle natural fruit juices. The historical-cost accounting system reports the following information for 2017:
Performance Auto Company operates a new car division (that sells high performance sports cars) and a performance parts division (that sells performance-improvement parts for family cars). Some division financial measures for 2017 are as follows:
E (Click the icon to view the data.)
Read the requirements.
Data table
rounded to one decimal place in the format X.X%.)
Requirements
New Car
Performance
1. Calculate return on investment (ROI) for each division using operating income
as a measure of income and total assets as a measure of investment.
Division
Parts Division
2. Calculate residual income (RI) for each division using operating income as a
Total assets
2$
35,000,000 $
32,312,500
measure of income and total assets minus current liabilities as a measure of
investment.
Current liabilities
2$
6,500,000 $
৪,000,000
3. William Abraham, the New Car Division manager, argues that the performance
parts division has "loaded up on a lot of short-term debt" to boost its RI.
Operating income
$4…
The following is a financial information from MayPagAsaPa Company:
Additional information:The company purchase office supplies from big manufacturers and distributes among different segments. Cost of goods sold and shipping expenses are both variable.
1.Prepare a new contribution format segmented income statement.
2.Analyze your requirement #1. What points that might help to improve the company’s performance would you bring to management’s attention?
3.Compare your output with Requirement 1 with the information above. List the items you think that is an error/disadvantage/weakness of the given data.
Chapter 5 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (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
- This 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_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 a strategy of product differentiation, Arseniq Company makes a high-end Appliance, XT15. Arseniq presents the following data for the years 2014 and 2015: 2014 59.000 $600 154,000 2015 Units of XT15 produced and aold Selling price Direct materials (square feet) Direct matenals costs per square foot Manufacturing capacity in units of XT15 Total convermon costs 61,500 $650 157,200 $68 63,500 $7.429,500 $60 63,500 $6,985,000 Conversion costs perunit of capaaty Selling and oustomer-ervice capacity (customers) Total selling and customer-ervice conts Selling and customer-service capacity cost per customer $110 $117 190 $2.907,000 $15,300 190 $3,030,500 $15,950 Arseniq produces no defective units but it wants to reduce direct materials usage per unit of XT15. Manufacturing conversion costs in each year depend on production capacity defined in terms of XT15 units that can be produced. Selling and customer-service costs depend on the number of customers that the customer and service…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_forwardSpectrum Corp. makes two products: C and D. The following data have been summarized: (Click the icon to view the data.) Spectrum Corp. desires a 25% target gross profit after covering all product costs. Considering the total product costs assigned to the Products C and D, what would Spectrum have to charge the customer to achieve that gross profit? Round to two decimal places. Begin by selecting the formula to compute the amount that the company should charge for each product. Required sales price per unit Data table Direct materials cost per unit Direct labor cost per unit Indirect manufacturing cost per unit Total costs assigned Print $ $ Product C 600.00 $ 300.00 270.00 1,170.00 S Done - X Product D 2,400.00 200.00 604.00 3,204.00arrow_forward
- Slarlet Beauty manufactures and sells a face cream lo small specialy stores in the greater Los Angeles area. It presents the monthly operating income stalement shown here to George Diaz, a polenial investor in the business. Help Mr. Diaz understand Starlet Beauty's cost structure. E(Click the icon to view the operating income stalement.) Read the equirements. Data Table Requirement 1. Recast the income statement to emphasize contribution margin. Starlet Cosmetics Operating Income Statement, June 2017 Starlet Beauty Operating Income Statement, June 2017 10,000 Units sold Revenues 200,000 Cost of goods sold Variable manufacturing costs 80,000 32,900 Fixed manufacturing costs 112,900 Total Gross margin 87,100 Operating costs Variable marketing costs 48,000 17.500 Fixed marketing and administrative costs 65,500 Total operating costs 21,600 Operating income Print Done Choose from any list or enter any number in the input fields and then click Check Answer.arrow_forwardCalabria Healthcare supplies prescription drugs to pharmacies. As the management accountant,you are required to analyze the financial statements for this quarter. You already have analyzedthe company’s two divisions, Name Brand and Generic, and your supervisor wants an analysis ofthe comparable profitability of the SBUs. The contribution margins are $500,000 and $200,000,respectively; the controllable fixed costs are $200,000 and $50,000; and the noncontrollable fixedcosts are $50,000 and $100,000. Assume there are no nontraceable fixed costs.What are the total contributions by profit center (CPC) for the Name Brand and Genericdivisions, respectively?a. Name Brand: $300,000; Generic: $150,000b. Name Brand: $250,000; Generic: $50,000c. Name Brand: $200,000; Generic: $50,000d. Name Brand: $500,000; Generic: 200,000arrow_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 White, the firms new accountant, wants to use an activity-based costing system that takes into consideration the cost of the delivery person. Following are activity and cost information relating to two of Chocolate Bakers major products: Using activity-based costing, which of the following statements is correct? a. The muffins are 2,000 more profitable. b. The cheesecakes are 75 more profitable. c. The muffins are 1,925 more profitable. d. The muffins have a higher profitability as a percentage of sales and, therefore, are more advantageous.arrow_forward
- Evaluating selling and administrative cost allocations Gordon Gecco Furniture Company has two major product lines with the following characteristics: Commercial office furniture: Few large orders, little advertising support, shipments in full truckloads, and low handling complexity Home office furniture: Many small orders, large advertising support, shipments in partial truckloads, and high handling complexity The company produced the following profitability report for management: The selling and administrative expenses are allocated to the products on the basis of relative sales dollars. Evaluate the accuracy of this report and recommend an alternative approach.arrow_forwardNation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The firm's controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of an equation, in the form of Y= a + bx, for maintenance costs. Data regarding the maintenance hours and costs for last year are as follows: Month January February March April May June July August September October November December Total Average Hours of Maintenance Service 560 480 280 470 350 460 320 430 490 380 350 340 4,910 409 Maintenance cost Maintenance Costs $ 5,110 4,240 2,730 4,300 3,030 4, 120 3,000 3,590 4,000 3,220 3,170 3,070 $ 43,580 $ 3,632 PR 6-38 (Algo) Part 3 Compute the predicted maintenance cost... 3. Compute the predicted maintenance cost at 670 hours of activity. Answer is complete but not entirely correct. $ 49,192 Xarrow_forwardNation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The firm's controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of an equation, in the form of Y= a + bX, for maintenance costs. Data regarding the maintenance hours and costs for last year are as follows: Month January February March April May June July August September October November December Total Average Hours of Maintenance Service Variable maintenance cost 560 480 280 470 350 460 320 430 490 380 350 340 4,910 409 $ Maintenance Costs $ 5,110 4,240 2,730 4,300 3,030 4, 120 PR 6-38 (Algo) Part 2 What is the variable component of the maintenance cost? 2. Using your answer to requirement 1, what is the variable component of the maintenance cost? Note: Round your answer to 2 decimal places. 3,000 3,590…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