Activity Area 1. Order processing Cost Driver Rate in 2017 $42 per order $5 per line item 2. Line-item ordering 3. Store deliveries $47 per store delivery $4 per carton $13 per stocking-hour 4. Carton deliveries 5. Shelf-stocking Rick Flair, the controller of Best Drugs, wants to use this ABC system to examine individual customer profit- ability 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: San Diego Pharmacy Ann Arbor Pharmacy Total orders 13 Average line items per order 11 19 Total store deliveries Average cartons shipped per store delivery Average hours of shelf-stocking per store delivery Average revenue per delivery Average cost of goods sold per delivery 21 18 0.5 0.75 $1,900 $2,600 $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. 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 rec- ommendations that you think Best Drugs should consider in light of this new customer-profitability information. Required

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter12: Fainancial Statement Analysis
Section: Chapter Questions
Problem 84PSA
icon
Related questions
Question

Customer profitability, distribution. Best Drugs is a distributor of pharmaceutical products. Its ABC system has five activities:

Activity Area
1. Order processing
Cost Driver Rate in 2017
$42 per order
$5 per line item
2. Line-item ordering
3. Store deliveries
$47 per store delivery
$4 per carton
$13 per stocking-hour
4. Carton deliveries
5. Shelf-stocking
Rick Flair, the controller of Best Drugs, wants to use this ABC system to examine individual customer profit-
ability 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:
San Diego Pharmacy
Ann Arbor Pharmacy
Total orders
13
Average line items per order
11
19
Total store deliveries
Average cartons shipped per store delivery
Average hours of shelf-stocking per store delivery
Average revenue per delivery
Average cost of goods sold per delivery
21
18
0.5
0.75
$1,900
$2,600
$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.
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 rec-
ommendations that you think Best Drugs should consider in light of this new customer-profitability
information.
Required
Transcribed Image Text:Activity Area 1. Order processing Cost Driver Rate in 2017 $42 per order $5 per line item 2. Line-item ordering 3. Store deliveries $47 per store delivery $4 per carton $13 per stocking-hour 4. Carton deliveries 5. Shelf-stocking Rick Flair, the controller of Best Drugs, wants to use this ABC system to examine individual customer profit- ability 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: San Diego Pharmacy Ann Arbor Pharmacy Total orders 13 Average line items per order 11 19 Total store deliveries Average cartons shipped per store delivery Average hours of shelf-stocking per store delivery Average revenue per delivery Average cost of goods sold per delivery 21 18 0.5 0.75 $1,900 $2,600 $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. 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 rec- ommendations that you think Best Drugs should consider in light of this new customer-profitability information. Required
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Industry Specific Activities
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning