Given the information below, complete the following requirements:

A. Rank the customers by their gross margin as a percent of sales revenue.

B. Perform customer profitability analysis by generating an operating income for each customer segment through the use of activity-based costing.

C. Rank segments by their respective operating income as a percent of sales.

D. If the relative rankings of the segments using operating income as a percent of sales is different from the relative rankings using gross margin as a percent of sales, then provide two reasons why this change might have occurred.

Space is provided on the following two pages for your answer. Be sure to show your work for partial credit should you make an error.

Pharmacy

Hospital

HMO

Clinics

Revenue

$1,000,000

$1,200,000

$800,000

$600,000

CGS

$670,000

$720,000

$560,000

$390,000

Activity

Rate

Cost Driver

Order taking

$200.00

per purchase order

Information requests

$350.00

per request

Sales calls

$400.00

per sales call

Distribution

$150.00

per delivery

Expedited orders

$500.00

per expedited order

Activity Cost Driver Quantities

Activity Cost Driver

Pharmacy

Hospital

HMO

Clinics

Number of purchase orders

100

200

20

80

Number of requests

50

100

20

20

Number of sales calls

50

200

10

40

Number of deliveries

80

100

10

40

Number of expedited orders

40

150

8

60