Activity Area 1. Order processing Cost Driver Rate in 2017 $42 per order $5 per line item $47 per store delivery $4 per carton $13 per stocking-hour 2. Line-item ordering 3. Store deliveries 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: Ann Arbor Pharmacy San Diego Pharmacy Total orders 13 Average line items per order 11 19 Total store deliveries 5 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 $2,600 $1,900 $2,100 S1,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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Customer protability, 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
$47 per store delivery
$4 per carton
$13 per stocking-hour
2. Line-item ordering
3. Store deliveries
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:
Ann Arbor Pharmacy
San Diego Pharmacy
Total orders
13
Average line items per order
11
19
Total store deliveries
5
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
$2,600
$1,900
$2,100
S1,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 $47 per store delivery $4 per carton $13 per stocking-hour 2. Line-item ordering 3. Store deliveries 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: Ann Arbor Pharmacy San Diego Pharmacy Total orders 13 Average line items per order 11 19 Total store deliveries 5 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 $2,600 $1,900 $2,100 S1,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 6 images

Blurred answer
Knowledge Booster
Information system controls
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education