Exhibit 15-2 summarizes details of the costs incurred in marketing and administration, distribution, and customer service by activity. The exhibit also identifies the cost driver (where appropriate), the total costs incurred for the activity, the total quantity of the cost driver, the cost per unit of the cost driver, and the customer cost-hierarchy category for each activity.

Marketing and Administration
Activity area: Sales orders
Cost driver: Number of sales orders
Total cost of activity: $6,750,000
Total quantity of cost driver: 6,000 sales orders
Cost per unit of cost driver: $1,125 per sales order
Cost hierarchy category: Customer batch-level costs
Customer visits
Cost driver: Number of customer visits
Total cost of activity: $4,200,000
Total quantity of cost driver: 750 customer visits
Cost per unit of cost driver: $5,600 per customer visit
Cost hierarchy category: Customer-sustaining costs
Wholesale channel marketing
Total cost of activity: $800,000
Cost hierarchy category: Distribution-channel costs
Business-sales channel marketing
Total cost of activity: $1,350,000
Cost hierarchy category: Distribution-channel costs
Provalue division administration
Total cost of activity: $1,900,000
Cost hierarchy category: Division-sustaining costs
Total marketing & administration costs of activity: $15,000,000
Distribution
Product handling
Cost driver: Number of cubic feet moved
Total cost of activity: $4,500,000
Total quantity of cost driver: 300,000 cubic feet
Cost per unit of cost driver: $15 per cubic foot
Cost hierarchy category: Customer output unit-level costs
Regular shipments
Cost driver: Number of regular shipments
Total cost of activity: $3,750,000
Total quantity of cost driver: 3,000 regular shipments
Cost per unit of cost driver: $1,250 per regular shipments
Cost hierarchy category: Customer batch-level costs
Rush shipments
Cost driver: Number of rush shipments
Total cost of activity: $750,000
Total quantity of cost driver: 150 rush shipments
Cost per unit of cost driver: $5,000 per rush shipments
Cost hierarchy category: Customer batch-level costs
Total distribution costs of activity: $9,000,000
Customer service
Cost driver: Number of units shipped
Total cost of activity: $3,600,000
Total quantity of cost driver: 150,000 units shipped
Cost per unit of cost driver: $24 per unit shipped
Cost hierarchy category: Customer output unit-level costs
For example, here is a breakdown of Provalue Division’s $15,000,000 of marketing and administration costs:
The Provalue Division managers are particularly interested in analyzing customer-level indirect costs—costs incurred in the first three categories of the customer-cost hierarchy: customer output unit–level costs, customer batch-level costs, and customer-sustaining costs. Managers believe they can work with customers to influence customer actions to reduce these costs. Information on the quantity of cost drivers used by each of four representative wholesale customers follows:

Marketing
Activity: Sales orders
Quantity of cost driver: Number of sales orders
Customer A: 1,200
Customer B: 1,000
Customer G: 600
Customer J: 300
Activity: Customer visits
Quantity of cost driver: Number of customer visits
Customer A: 150
Customer B: 100
Customer G: 50
Customer J: 25
Distribution
Activity: Product handling
Quantity of cost driver: Number of cubic feet moved
Customer A: 60,000
Customer B: 50,000
Customer G: 10,000
Customer J: 8,000
Activity: Regular shipments
Quantity of cost driver: Number of regular shipments
Customer A: 600
Customer B: 400
Customer G: 300
Customer J: 120
Activity: Rush shipments
Quantity of cost driver: Number of rush shipments
Customer A: 25
Customer B: 5
Customer G: 20
Customer J: 3
Customer service
Activity: Customer service
Quantity of cost driver: Number of units shipped
Customer A: 30,000
Customer B: 25,000
Customer G: 5,000
Customer J: 4,000
Exhibit 15-3 shows customer-level operating income for the four wholesale customers using information on customer revenues previously presented (see section Customer-Revenue Analysis) and customer-level indirect costs, obtained by multiplying the rate per unit of cost driver (from Exhibit 15-2) by the quantities of the cost driver used by each customer (in the preceding table). Exhibit 15-3 shows that the Provalue Division makes losses on Customer G (the cost of resources used exceeds revenues) while Customer J is profitable on smaller revenues. In a similar vein, the Provalue Division has higher operating income from Customer B than Customer A even though it sells fewer computers to Customer B compared to Customer A.

Table shows the customer profitability analysis for four wholesale-channel customers for the year 2019.
Revenue at list price
Customer A: $33,000,000
Customer B: $27,500,000
Customer G: $5,500,000
Customer J: $4,400,000
Price discount
Customer A: $3,000,000
Customer B: $1,250,000
Customer G: $750,000
Customer J: Nil
Revenues
Customer A: $30,000,000
Customer B: $26,250,000
Customer G: $4,750,000
Customer J: $4,400,000
Cost of goods sold
Customer A (product of $680 and 30,000): $20,400,000
Customer B (product of $680 and 25,000): $17,000,000
Customer G (product of $680 and 5,000): $3,400,000
Customer J (product of $680 and 4,000): $2,720,000
Gross margin
Customer A: $9,600,000
Customer B: $9,250,000
Customer G: $1,350,000
Customer J: $1,680,000
Customer-level costs
Marketing costs
Sales orders
Customer A (product of $1,125 and 1,200): $1,350,000
Customer B (product of $1,125 and 1,000): $1,125,000
Customer G (product of $1,125 and 600): $675,000
Customer J (product of $1,125 and 300): $337,500
Customer visits
Customer A (product of $5,600 and 150): $840,000
Customer B (product of $5,600 and 100): $560,000
Customer G (product of $5,600 and 50): $280,000
Customer J (product of $5,600 and 25): $140,000
Distribution costs
Product handling
Customer A (product of $15 and 60,000): $900,000
Customer B (product of $15 and 50,000): $750,000
Customer G (product of $15 and 10,000): $150,000
Customer J (product of $15 and 8,000): $120,000
Regular shipments
Customer A (product of $1,250 and 600): $750,000
Customer B (product of $1,250 and 400): $500,000
Customer G (product of $1,250 and 300): $375,000
Customer J (product of $1,250 and 120): $150,000
Rush shipments
Customer A (product of $5,000 and 25): $125,000
Customer B (product of $5,000 and 5): $25,000
Customer G (product of $5,000 and 20): $100,000
Customer J (product of $5,000 and 3): $15,000
Customer service costs
Customer service
Customer A (product of $24 and 30,000): $720,000
Customer B (product of $24 and 25,000): $600,000
Customer G (product of $24 and 5,000): $120,000
Customer J (product of $24 and 4,000): $96,000
Total customer-level costs
Customer A: $4,685,000
Customer B: $3,560,000
Customer G: $1,700,000
Customer J: $858,500
Customer-level operating income
Customer A: $4,915,000
Customer B: $5,690,000
Customer G: $(350,000) in parentheses
Customer J: $821,500
The Provalue Division’s managers can use the information in Exhibit 15-3 to work with customers to reduce the quantity of activities needed to support them. Consider, for example, Customer G and Customer J. Customer G purchases 25% more computers than Customer J (5,000 versus 4,000) but the company offers Customer G significant price discounts to achieve these sales. Compared with Customer J, Customer G places twice as many sales orders, requires twice as many customer visits, and generates two-and-a-half times as many regular shipments and almost seven times as many rush shipments. Selling smaller quantities of Provalue is profitable so long as price discounting is limited and customers do not use large amounts of division resources. For example, charging customers for marketing (sales orders and customer visits) and distribution services (regular and rush shipments) might motivate Customer G to place fewer but larger sales orders and require fewer customer visits, regular shipments, and rush shipments. A similar analysis might help managers understand the reasons for the lower profitability of Customer A relative to Customer B and actions they might take to improve Customer A’s profitability.
Owens and Minor, a distributor of medical supplies to hospitals, separately prices each of its services such as a rush delivery or special packaging. How have its customers reacted? Hospitals that value these services continue to demand and pay for them, while hospitals that do not value these services stop asking for them, saving Owens and Minor some costs. This pricing strategy influences customer behavior in a way that increases Owens and Minor’s revenues or decreases its costs.
The ABC system also highlights a second opportunity for cost reduction. Provalue Division managers can reduce the costs of activities by applying a value-engineering process to nonmanufacturing costs: (1) understand customer requirements and value-added and non-value-added costs, (2) anticipate how costs are locked in before they are incurred, and (3) use cross-functional teams to redesign products and processes to reduce costs while meeting customer needs. For example, improving the efficiency of the ordering process (through electronic ordering) reduces sales-order costs even if customers place the same number of orders.
Simplifying the design and reducing the weight of the newly designed Provalue II for 2020 reduces the cost per cubic foot of handling Provalue and total product-handling costs. By influencing customer behavior and improving marketing, distribution, and customer-service operations, managers aim to reduce the nonmanufacturing cost of Provalue II to $180 per computer and achieve the target cost of $720 for Provalue II.