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
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
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Customer profitability, distribution. Best Drugs is a distributor of pharmaceutical products. Its ABC system has five activities:
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
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.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education