Customer-Level Costs

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.

Exhibit 15-2

Marketing, Administration, Distribution, and Customer Service Activities, Costs, and Cost Driver Information for Provalue Division in 2019

Table shows the cost driver, total cost of activity, total quantity of cost driver, cost per unit of cost driver, and cost hierarchy category for various activity areas.

Marketing and Administration

  1. 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

  2. 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

  3. Wholesale channel marketing

    • Total cost of activity: $800,000

    • Cost hierarchy category: Distribution-channel costs

  4. Business-sales channel marketing

    • Total cost of activity: $1,350,000

    • Cost hierarchy category: Distribution-channel costs

  5. Provalue division administration

    • Total cost of activity: $1,900,000

    • Cost hierarchy category: Division-sustaining costs

  6. Total marketing & administration costs of activity: $15,000,000

Distribution

  1. 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

  2. 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

  3. 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

  4. 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:

Spreadsheet screenshot shows the quantity of cost driver of various activities for the customers A, B, G, and J.

Marketing

  1. 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

  2. Activity: Customer visits

    • Quantity of cost driver: Number of customer visits

    • Customer A: 150

    • Customer B: 100

    • Customer G: 50

    • Customer J: 25

Distribution

  1. 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

  2. Activity: Regular shipments

    • Quantity of cost driver: Number of regular shipments

    • Customer A: 600

    • Customer B: 400

    • Customer G: 300

    • Customer J: 120

  3. 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

  1. 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.

Exhibit 15-3

Customer-Profitability Analysis for Provalue Division’s Four Wholesale-Channel Customers for 2019

Spreadsheet screenshot shows the quantity of cost driver of various activities for the customers A, B, G, and J.

Table shows the customer profitability analysis for four wholesale-channel customers for the year 2019.

  1. Revenue at list price

    • Customer A: $33,000,000

    • Customer B: $27,500,000

    • Customer G: $5,500,000

    • Customer J: $4,400,000

  2. Price discount

    • Customer A: $3,000,000

    • Customer B: $1,250,000

    • Customer G: $750,000

    • Customer J: Nil

  3. Revenues

    • Customer A: $30,000,000

    • Customer B: $26,250,000

    • Customer G: $4,750,000

    • Customer J: $4,400,000

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

  12. Total customer-level costs

    • Customer A: $4,685,000

    • Customer B: $3,560,000

    • Customer G: $1,700,000

    • Customer J: $858,500

  13. 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.

Watch Try It Video

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.