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
EBK HORNGREN'S COST ACCOUNTING
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)
- Stable 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_forwardAnnie B's Homemade Ice Cream is an ice cream shop in Asheville, NC. The table shown below contains five measures under the column heading If and five measures under the column heading Then. If Employee turnover percentage Number of new flavors created Average revenue per order Inventory as a percent of sales Average customer order fulfillment time → → → + Then Customer perception of our customer intimacy Customer perception of our product leadership Net operating income Return on assets Percent of customers that strongly agree with the statement "I would readily recommend your company to someone else" Required: 1. For each row in the table, write an if-then hypothesis statement that connects the two measures in a manner that most likely reflects the goals of the company. If the employee turnover percentage If the number of new flavors created If the average revenue per order If the inventory as a percent of sales If the average customer order fulfillment time then the customer…arrow_forwardRetail companies with today’s online, as well as in-store sales have a lot of data to keep track of! Keeping track of sales, costs, and profits daily is essential to making the most of a business. This exercise illustrates how to use the skills presented in this Module to generate the data needed daily by a retail company. Create the following calculated columns. a) In I4, and J4, use a VLOOKUP function that will look up the Product Price and Product Cost based on the Product Sold column which lists an ID number. [Hint: The Product Table sheet lists the Price and Cost] If any error messages appear, check the Range Lookup. b) In K4, use a formula to calculate Profit. Hint: Profit =(Product Price-Product Cost)*Units Sold Format columns I, J, and K as currency with two decimal places. Make a copy of the Sales sheet and rename it Online Sales by Date. Place this sheet to the right of the Sales sheet. Answer the following question by filtering the data accordingly. a) What was the…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_forwardWorld View Outfitters operates a large outdoor clothing and equipment store with three main product lines: clothing, equipment, and shoes. World View Outfitters operates at capacity and allocates selling, general, and administration (S, G & A) costs to each product line using the cost of merchandise of each product line. The company wants to optimize the pricing and cost management of each product line and is wondering if its accounting system is providing it with the best information for making such decisions. Store manager Abe Barry gathers the following information regarding the three product lines: For2017,World View Outfitters budgets the following selling, general, and administration costs: 1. Suppose World View Outfitters uses cost of merchandise to allocate all S, G & A costs. Prepare budgeted product-line and total company income statements. 2. Identify an improved method for allocating costs to the three product lines. Explain. Use the…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_forward
- National SavingsBank (NSB) is examining the profitability of its PremierAccount, a combined savings and checking account.NSB recently conducted an activity-based costing study of its services. It assessed the following costs for six individual services. The use of these services in2017 by three customers is as follows:Assume Lindenand Gonzalez always maintain a balance above $1,000, whereas Whitner always has a balance below $1,000. Depositors receive a 2% annual interest rate on their average deposit. NSB earns an interest rate spread of 3% (the difference between the rate at which it lends money and the rate it pays depositors) by lending money for home-loan purposes at 5%. Thus, NSB would gain $60 on the interest spread if a depositor had an average Premier Account balance of $2,000 in 2017 ($2,000 x 3% = $60). The Premier Account allows depositors unlimited use of services such as deposits, withdrawals, checking accounts, and foreign currency drafts.…arrow_forwardCarmel Company has a frequent buyer program for its customers, where the customers can attain an "elite" level based on the number of orders and the total revenue of the orders. There are twoelite levels: Platinum and Titanium. The benefits of elite membership include discounts and access to special customer service representatives who can resolve problems. The company has one full time customer representative per 200 Titanium customers and one full-time customer representa tive per 2,000 Platinum customers. Customer representatives receive salaries plus bonuses of 2 percent of customer gross margin. Carmel spends 70 percent of its promotion costs on Titanium customers to encourage their loyaltyarrow_forwardSandhill 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: Retail Stores Internet Catalog Sales Sales revenue $12,000,000 $3,700,000 $6,600,000 Variable expenses 4,000,000 1,355,000 1,950,000 Direct fixed expenses 5,960,000 994,500 4,188,000 Average assets 8,000,000 3,700,000 2,000,000 Required rate of return 12% 12% 12% (a1) Calculate the margin and asset turnover for each of the three distribution channels. (Round answers to 2 decimal places, e.g. 5.12% or 5.12.) Retail Stores Internet Catalog Sales Margin enter percentages % enter percentages % enter percentages % Asset turnover enter a ratio enter a ratio enter a ratioarrow_forward
- Colby Company makes cases for cell phones of all sizes and types for sale through specialty retailers. The company makes a standard model for the most recent iPhone as well as a deluxe model. Management has designed an ABC system with the following activity cost pools and activity rates for these models: Activity Cost Pool Supporting manufacturing Order processing Customer service Management would like an analysis of the profitability of a particular customer, Cell City, which has ordered the following products over the last 12 months: Number of cases Number of orders Direct labour-hours per case Selling price per case Direct materials cost per case The company's direct labour rate is $19 per hour. Sales Costs: Activity Rates $3 per direct labour-hour $15 per order $50 per customer Direct materials Direct labour Supporting manufacturing Order processing Customer service Customer margin Standard Deluxe Model Model 120 35 23 ta ta OSOF 0.20 $ $ 5 35 10 64 $9 $ Required: Using the…arrow_forwardManagement would like an analysis of the profitability of a particular customer, Cell City, which has ordered the following products over the last 12 months: Number of cases Number of orders. Direct labour-hours per case Selling price per case. Direct materials cost per case Sales Costs: Direct materials Direct labour Supporting manufacturing Order processing Customer service The company's direct labour rate is $30 per hour. Required: Using the company's ABC system, compute the customer margin of Cell City. Customer margin Standard Model 290 5 0.25 $49 $ 26 70 Deluxe Model 105 2 $ 0.40 $ 69 $29 70 (70)arrow_forwardColby Company makes cases for cell phones of all sizes and types for sale through specialty retailers. The company makes a standard model for the most recent iPhone as well as a deluxe model. Management has designed an ABC system with the following activity cost pools and activity rates for these models: Activity Cost Pool Supporting manufacturing Order processing Customer service Management would like an analysis of the profitability of a particular customer, Cell City, which has ordered the following products over the last 12 months: Number of cases Number of orders Direct labour-hours per case Selling price per case Direct materials cost per case. Sales Costs: Activity Rates $2 per direct labour-hour $19 per order $60 per customer Direct materials Direct labour Supporting manufacturing Order processing Customer service The company's direct labour rate is $20 per hour. Required: Using the company's ABC system, compute the customer margin of Cell City. Customer margin Standard Model…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