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
COST ACCT
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)
- 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_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_forwardPaint Company has two customers Commercial and Consumer with data as follows: Commercial Consumer Selling Price per unit $15 $15 Units Sold 5,000 8,000 Manufacturing Cost per unit $8.25 $8.25 Number of Purchase Orders 76 212 Number of Deliveries 104 287 Number of Expedited deliveries 357 589 Customer Visits 58 75 Paint Company’s management accountant has gathered the following ABC rate information: ABC Cost Rate Purchase Orders $ 72 per purchase order Deliveries $ 43 per delivery Expedited Deliveries $ 18 per expedited delivery Customer Visits $ 56 per customer visit Using the information in the tables above and allocating indirect support costs using ABC to customers, what is the Operating Income for the Commercial customer?arrow_forward
- Sandhill 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_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_forwardDavis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. The following data were collected from last year’s operations (revenues and costs in thousands of dollars). Store Revenues Costs 101 $4,220 $4,394 102 2,347 3,134 103 5,918 5,361 104 4,222 4,298 105 3,094 4,036 106 4,263 3,739 107 7,014 5,209 108 1,959 2,974 109 6,016 5,168 110 3,588 3,319 111 4,126 4,479 112 4,990 3,440 113 3,672 2,916 114 5,297 4,895 115 2,724 3,166 Required a. Use the high-low method to estimate the fixed and variable portions of store costs based on revenues. b. Managers estimate that one of the proposed stores will have revenues of $3.7 million. What are the estimated monthly overhead costs, assuming no…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_forwardDavis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. The following data were collected from last year’s operations (revenues and costs in thousands of dollars). Store Revenues Costs 101 $4,240 $4,424 102 2,367 3,174 103 5,948 5,391 104 4,262 4,348 105 3,124 4,096 106 4,303 3,809 107 7,034 5,239 108 1,989 3,074 109 6,116 5,248 110 3,648 3,379 111 4,166 4,529 112 5,040 3,480 113 3,692 2,976 114 5,377 4,935 115 2,824 3,196 Required a. Use the high-low method to estimate the fixed and variable portions of store costs based on revenues. b. Managers estimate that one of the proposed stores will have revenues of $3.9 million. What are the estimated monthly overhead costs, assuming no…arrow_forwardSouth Coast Appliance Store is a small company that has hired you to perform some management advisory services. The following information pertains to 2017 operations. Sales (5,500 microwave ovens) $5,500,000 Cost of goods sold 962,500 Store manager's salary per year 150,000 Operating costs per year 220,000 Advertising and promotion per year 18,960 Commissions (3.2% of sales) 176,000 What was the variable cost per unit sold for 2017?arrow_forward
- Stage 2 ABC for a Wholesale CompanyInformation is presented for the activity costs of Brighton Wholesale Company: Activity Cost per Unit of Activity Driver Customer relations $82.00 per customer per month Selling 0.09 per sales dollar Accounting 7.00 per order Warehousing 0.60 per unit shipped Packing 0.35 per unit shipped Shipping 0.40 per pound shipped The following information pertains to Brighton Wholesale Company's activities in Colorado for the month of June 2017: Number of orders 320 Sales revenue $218,000 Cost of goods sold $98,100 Number of customers 40 Units shipped 5,400 Pounds shipped 81,000 RequiredDetermine the profitability of sales in Colorado for June 2017.Do not use a negative sign with your answers. Profitability of Sales in Colorado March 2017 Sales revenue Answer Less: Cost of goods sold Answer Customer relations Answer Selling expenses Answer Accounting Answer Warehousing Answer…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_forwardThe management accountant for Giada's Book Store has prepared the following income statement for the most current year: Cookbook Travel Book Classics Total Sales $60,000 $100,000 $40,000 $200,000 Cost of goods sold 36,000 65,000 20,000 121,000 Contribution margin 24,000 35,000 20,000 79,000 Order and delivery process 18,000 21,000 8,000 47,000 Rent (per sq. foot used) 2,000 1,000 3,000 6,000 Allocated corporate costs 7,000 7,000 7,000 21,000 Corporate profit $ (3,000) $ 6,000 $ 2,000 $ 5,000 If the cookbook product line had been discontinued prior to this year, the company would have reported ________. Select one: a. greater corporate profits…arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College