Customer profitability, distribution. Best Drugs is a distributor of pharmaceutical products. Its ABC system has five activities:
Activity Area | Cost Driver Rate in 2017 |
1. Order processing | $42 per order |
2. Line-item ordering | $5 per line item |
3. Store deliveries | $47 per store delivery |
4. Carton deliveries | $4 per carton |
5. Shelf-stocking | $13 per stocking-hour |
Rick Flair, the controller of Best Drugs, wants to use this ABC system to examine individual customer profitability within each distribution market. He focuses first on the Ma and Pa single-store distribution market. Using only two customers helps highlight the insights available with the ABC approach. Data pertaining to these two customers in August 2017 are as follows:
Ann Arbor Pharmacy | San Diego Pharmacy | |
Total orders | 13 | 7 |
Average line items per order | 11 | 19 |
Total store deliveries | 5 | 7 |
Average cartons shipped per store delivery | 21 | 18 |
Average hours of shelf-stocking per store delivery | 0.5 | 0.75 |
Average revenue per delivery | $2,600 | $1,900 |
Average cost of goods sold per delivery | $2,100 | $1,700 |
- 1. Use the ABC information to compute the operating income of each customer in August 2017. Comment on the results and what, if anything, Flair should do.
Required
- 2. Flair ranks the individual customers in the Ma and Pa single-store distribution market on the basis of monthly operating income. The cumulative operating income of the top 20% of customers is $58,120. Best Drugs reports operating losses of $23,670 for the bottom 40% of its customers. Make four recommendations that you think Best Drugs should consider in light of this new customer-profitability information.
Trending nowThis is a popular solution!
Learn your wayIncludes step-by-step video
Chapter 14 Solutions
HORNGRENS COST ACCOUNTING W/ACCESS
Additional Business Textbook Solutions
Horngren's Accounting (11th Edition)
Horngren's Financial & Managerial Accounting, The Financial Chapters (Book & Access Card)
Financial Accounting (12th Edition) (What's New in Accounting)
Intermediate Accounting (2nd Edition)
Cost Accounting (15th Edition)
- Using the preceding information, calculate the expected customer-level operating income for the six customers of KC Corporation. Use the number of written orders at $15 each to calculate expected order costs.arrow_forwardABC, retail product-line protability. Fitzgerald Supermarkets (FS) operates at capacity and decides to apply ABC analysis to three product lines: baked goods, milk and fruit juice, and frozen foods. It identies four activities and their activity cost rates as follows:arrow_forwardCal’s Sporting Goods has three product lines and has decided to apply ABC analysis to these three product lines: Running, Golfing and Kayaking. He identifies four activities and their activity cost rates as follows: Ordering $95 per purchase order Delivery and receipt of merchandise $76 per delivery Shelf stocking $19 per hour Customer support and assistance $0.15 per item sold. The revenues, cost of goods sold and activity usage are listed below: Running Golfing Kayaking Financial Data Revenues $60,000 $66,500 $50,500 Cost of goods sold $41,000 $51,000 $32,000 Store support costs (overhead) Activity Area Usage Ordering (purchase orders 44 24 14 Delivery (deliveries) 120 60 36 Shelf stocking (hours) 170 150 20 Customer support (items sold) 15,400 20,200 7,960 Under the simple costing system. Cal’s Sporting Goods…arrow_forward
- Figure Four is a distributor of pharmaceutical products. Its activity-based costing system has five activity areas: Activity Area Cost Driver and Rate Order processing $40 per order Line item ordering $3 per line item Store deliveries $50 per store delivery Carton deliveries $1 per carton Shelf-stocking $16 per stocking-hour Rick Flair, the controller of Figure Four, wants to use this activity-based costing system to examine individual customer profitability within each distribution market. Two customers are used to exemplify the insights available with the activity-based costing approach. Data pertaining to these two customers in August are as follows: Charleston Pharmacy Chapel Hill Pharmacy Total orders 12 10 Average line items per order 10 18 Total store deliveries 6 10 Average cartons shipped per store delivery 24 20 Average hours of shelf-stocking per store delivery 0 0.5 Average…arrow_forwardRecalculate 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?arrow_forwardCompany MN is a wholesale distributor. It uses an ABC system to analyze customer profitability for its small- and medium-sized retail customers. The cost pool, cost driver and other relevant information is shown below. Cost pool Costs Cost driver Small retailer Medium retailer Ordering 300,000 Number of orders 8,000 4,000 Delivery 750,000 Number of deliveries 10,800 4,200 Customer Service 1,200,000 Number of products sold 320,000 480,000 Total overhead 2,250,000 What is the average total overhead cost per product sold to small retailers? (Assuming every item sold requires certain involvement of customer service) Choose the below answer. A. $3.81 B. $1.50 C. $25.00 D. $50.00arrow_forward
- Company MN is a wholesale distributor. It uses an ABC system to analyze customer profitability for its small- and medium-sized retail customers. The cost pool, cost driver and other relevant information is shown below. Cost pool Costs Cost driver Small retailer Medium retailer Ordering 300,000 Number of orders 8,000 4,000 Delivery 750,000 Number of deliveries 10,800 4,200 Customer Service 1,200,000 Number of products sold 320,000 480,000 Total overhead 2,250,000 What is the average total overhead cost per product sold to small and medium retailers? (Assuming every item sold requires certain involvement of customer service) Choose answer as below. A. Small: $3.81; Medium: $2.15 B. Small: $3.81; Medium: $1.5 C. Small: $3.81; Medium: $0.44 D. Small: $3.81; Medium: $0.21arrow_forwardStable Paper Delivery has decided to analyze the profitability of five new customers. It buys recycled paper at $12 per case and sells to retail customers at a list price of $14.80 per case. Data pertaining to the five customers are: E (Click the icon to view the data.) Stable Paper Delivery's five activities and their cost drivers are as follows: E (Click the icon to view the activities and cost drivers.) Read the requirements. Requirement 1. Compute the customer-level operating income of each of the five retail Begin by calculating each customer's gross margin. Then calculate the operating incom minus sign for operating losses.) Requirements 1 2 1. Compute the customer-level operating income of each of the five retail customers now being examined (1, 2, 3, 4, and 5). Comment on the results. 2. What insights do managers gain by reporting both the list selling price and the actual selling price for each customer? 3. What factors should managers consider in deciding whether to drop one…arrow_forwardRecalculate the customer-level operating income if salespeople had not broken up actual orders into multiple smaller orders. Don’t forget to also adjust sales commissions.arrow_forward
- Using the chart, I need assistance in answering the following questions w/ explanations: (The cost of the bags, which must be ordered in batches of 100) a) If this was a profit-making activity, at the entry fee of $20, what would be the profit-maximizing quantity of participants/bags? (I got 300 participants/bags) b) Use the information in the table to determine the exact breakeven quantity of participants/bags for the entry fee of $20. Use the formula Qb = F/(P – AVC). (I am not sure what to do or if I did this right. I got 113.)arrow_forwardSunland Decor sells home decor items through three distribution channels-retail stores, the Internet, and catalog sales. Each distribution channel is evaluated as an investment center. Selected results from the latest year are as follows: Sales revenue Variable expenses Direct fixed expenses Average assets Required rate of return Retail Stores $9,758,800 3,935,000 4,750,332 7,870,000 12% Internet $3,570,000 1,360,000 930,155 3,570,000 12% Catalog Sales $3,870,000 1,820,000 1,829,410 1,935,000 12%arrow_forwardABC, wholesale, customer protability. Veritek Wholesalers operates at capacity and sells furniture items to four department-store chains (customers). Mr. Veritek commented, “We apply ABC to determine product-line protability. The same ideas apply to customer protability, and we should nd out our customer protability as well.” Veritek Wholesalers sends catalogs to corporate purchasing departments on a monthly basis. The customers are entitled to return unsold merchandise within a six-month period from the purchase date and receive a full purchase price refund. The following data were collected from last year’s operations:arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning