Fully Allocated Customer Profitability

Learning Objective 5 Discuss decisions faced when collecting and allocating indirect costs to customers

In this section, we focus on the first purpose of cost allocation (see Exhibit 14-1): to provide information for economic decisions, such as pricing, by measuring the full costs of delivering products to different customers based on an ABC system.

We continue with the Astel Computers example introduced earlier in this chapter and focus on the fully allocated customer-profitability calculations for the 10 wholesale customers in the Provalue Division. The Provalue Division also uses a direct sales channel to sell Provalue computers directly to business customers. Recall that Astel has another division, the Deskpoint Division, which sells high-end computers. We illustrate how costs incurred in different parts of a company can be assigned, and then reassigned, to calculate customer profitability.

We summarize the cost categories as follows:

1. CORPORATE ADVERTISING COSTS—advertising and promotion costs to promote the Astel brand, $1,050,000.

2. CORPORATE ADMINISTRATION COSTS—executive salaries, rent, and general administration costs, $4,400,000.

Exhibit 15-9 presents an overview diagram of the allocation of corporate, division, and ­distribution-channel indirect costs to wholesale customers of the Provalue Division. Note that the Deskpoint Division has its own indirect-cost pools used to allocate costs to its customers. These cost pools and cost-allocation bases parallel the indirect-cost pools and allocation bases for the Provalue Division.

Exhibit15-9 Overview Diagram for Allocating Corporate, Division, and Channel Indirect Costs to Wholesale Customers of Provalue Division

Flow diagram shows the allocation of corporate, division, and channel indirect costs to wholesale customers of Provalue Division.

Implementing Corporate and Division Cost Allocations

Exhibit 15-10 allocates all overhead costs to customers based on the overview diagram in Exhibit 15-9. We describe some of the allocation choices based on the criteria for allocating costs explained in Exhibit 15-8.

  1. Start at the top of Exhibit 15-9 with the allocation of corporate advertising and corporate administration costs based on the demands that the Provalue Division and Deskpoint Division customers place on corporate resources. The first two columns in Exhibit 15-10 present the allocation of corporate advertising and corporate administration costs to the Provalue division.
    1. Astel allocates a total of $1,050,000 of corporate advertising costs to the two divisions on the basis of the revenues of each division (benefits received). It is plausible to assume that customers with higher revenues benefited more from corporate advertising costs than customers with lower revenues (see Exhibit 15-7 for information on revenues of each division):

Provalue Division:$1,050,000×$150,000,000$150,000,000+$200,000,000=$450,000Deskpoint Division:$1,050,000 × $200,000,000$150,000,000+$200,000,000=$600,000

b. Using the benefits-received criterion, Astel allocates corporate administration costs of $4,400,000 to each division on the basis of division administration costs because corporate administration’s main role is to support division administration. Exhibit 15-6 shows division administration costs for Provalue Division of $1,900,000. Division administration costs for Deskpoint Division are $2,100,000. The allocations are as follows:

Provalue Division:$4,400,000  × $1,900,000$1,900,000+$2,100,000=$2,090,000Deskpoint Division:$4,400,000 × $2,100,000$1,900,000+$2,100,000=$2,310,000

  1. Next, drop down one level in Exhibit 15-9 and focus on the allocation of costs from the division cost pools to the distribution-channel cost pools for the Provalue Division. The three columns labeled “Provalue Division Cost Pools” in Exhibit 15-10 show the allocations of the Provalue Division costs to the wholesale channel and the business-sales channel.
    1. Using the benefits-received criterion, the corporate advertising cost of $450,000 that had been allocated to the Provalue Division is now reallocated to the wholesale and business-sales channels’ revenue-based cost pools on the basis of the revenues of each channel (see Exhibit 15-6).

Wholesale Channel:$450,000×$97,550,000$97,550,000+$52,450,000=$292,650Business-Sales Channel:$450,000×$52,450,000$52,450,000+$97,550,000=$157,350

b. The R&D costs and design costs are aggregated into one homogeneous cost pool and allocated to channels on the basis of a study analyzing the demand for R&D and design resources by the wholesale and business-sales channels. A significant amount of the R&D and design costs arises as a result of modifications to the Provalue computer demanded by the more sophisticated business customers. Using the results of the study and the fairness criterion, the Provalue Division allocates half of the R&D and design costs to the business-sales channel (and half to the wholesale channel) even though the business-sales channel accounts for only about one-third of the total sales of the Provalue Division. Exhibit 15-10 shows that the Provalue Division allocates $2,700,000 ($5,400,000÷2) each to the wholesale and business-sales channels’ revenue-based cost pools.

c. Each division adds the allocated corporate administration costs to the division administration cost pool. The costs in this cost pool are facility-sustaining costs and do not have a cause-and-effect relationship with any of the activities in the distribution channels. Astel, however, allocates all costs to products so that managers are aware of all costs when making pricing and other decisions. The Provalue Division allocates the total costs of $3,990,000 in the Provalue Division Administration cost pool ($2,090,000 of Corporate Administration Costs allocated to the Provalue Division+$1,900,000 of Provalue Division Administration Costs) to the wholesale channel and business-sales channel based on operating incomes of the wholesale and business-sales channels, representing the ability of each channel to bear division administration costs (including allocated corporate administration costs). The lower the operating income of a channel, the lower the division costs allocated to it. As described earlier in the chapter, the rationale for the ability-to-bear criterion is that the Provalue Division will work hard to reduce the support it provides to channels with lower incomes. From Exhibit 15-10, the operating income of the wholesale channel after subtracting all costs that have been allocated to it thus far is $11,234,850 ($15,027,500 (Cell R7)−$292,650 (Cell G15)−$2,700,000 (Cell G16)−$800,000 (Cell G17) while the operating income of the business-sales channel is $5,215,150 (calculations not shown).

Wholesale Channel:$3,990,000×$11,234,850$11,234,850+$5,215,150=$2,725,049Business-Sales Channel:$3,990,000×$5,215,150$11,234,850+$5,215,150=$1,264,951

  1. Finally, focus on the bottom rows in Exhibit 15-9 and the allocation of costs from the wholesale distribution-channel cost pools of the Provalue Division to individual wholesale-channel customers. The four columns labeled “Provalue Division Distribution Channel Cost Pools” in Exhibit 15-10 show costs accumulated in the wholesale channel and the business-sales channel. Exhibit 15-10 only presents the allocation of wholesale-channel costs to wholesale customers.
    1. The wholesale-channel revenue-based cost pool is allocated to individual wholesale customers on the basis of revenues because revenues are a good measure of how individual customers benefit from these costs. The costs in this cost pool total $3,792,650 and are composed of three costs: (1) $292,650 of corporate advertising costs allocated to the wholesale channel revenue-based cost pool in Step 2a, (2) $2,700,000 of R&D and design costs allocated to the wholesale channel revenue-based cost pool in Step 2b, and (3) $800,000 of costs of the wholesale-distribution channel itself (Exhibit 15-6). In Exhibit 15-10, the costs allocated to Customer A and Customer B, for example, are shown below:

Exhibit15-10 Profitability of Wholesale Customers of Provalue Division After Fully Allocating Corporate, Division, and Channel Indirect Costs (in thousands, rounded)

Spreadsheet screenshot shows profitability of wholesale customers of Provalue Division after fully allocating corporate, division, and channel indirect costs (in thousands, rounded).

The spreadsheet shows costs for Astel Corporation cost pools, Provalue Division costs pools, Provalue Division distribution channel cost pools, and wholesale channel customers.

(A) Astel Corporation cost pools

1. Costs allocated based on division revenues

Astel corporate advertising costs: $(1,050) in parentheses

Allocate corporate advertising costs to divisions based on division revenues: 1,050

2. Costs allocated based on division administration costs 

Astel corporate administration costs: $(4,400) in parentheses

Allocate corporate administration costs to divisions based on division administration costs: 4,400

(B) Provalue division cost pools

1. Costs allocated based on channel revenues

Allocate corporate advertising costs to divisions based on division revenues: $(450) in parentheses (calculated by taking the product of $1,050 and $150,000 and dividing the result by the sum of $150,000 and $200,000 which equals $450)

Allocate corporate advertising costs from Provalue Division to channels based on channel revenues: 450

2. R&D and design cost allocation pool

R&D costs: $(2,400)

Design costs: (3,000)

Allocate R&D and Design costs to channels based on fairness: 5,400

3. Costs allocated based on channel operating incomes

Allocate corporate administration costs to divisions based on division administration costs: $(2,090) in parentheses (calculated by taking the product of $4,400 and $1,900 and dividing the result by the sum of $1,900 and $2,090 which equals $2090)

Division administration costs: (1,900)

Allocate division administration costs from Provalue Division to channels based on channel operating incomes: 3,990

(C) Provalue division distribution channel cost pools

1. Wholesale channel costs allocated based on customer revenues:

Allocate corporate advertising costs from Provalue Division to channels based on channel revenues: $(293) in parentheses (calculated by dividing the product of 450 and $97,550 by $150,000)

Allocate R&D and Design costs to channels based on fairness: (2,700) in parentheses (calculated by dividing $5,400 by 2)

Distribution channel costs: (800) in parentheses

Allocate wholesale channel costs to customers based on customer revenues: 3,793

2. Wholesale channel costs allocated based on customer operating incomes:

Allocate division administration costs from Provalue Division to channels based on channel operating incomes: $(2,725)

Allocate wholesale channel costs to customers based on customer operating income, if positive (ability to bear): 2,725

3. Business- sales channel costs allocated based on customer revenues:

Allocate corporate advertising costs from Provalue Division to channels based on channel revenues: 157 in parentheses (calculated by dividing the sum of $450 and $52,450 by $150,000)

Allocate R&D and Design costs to channels based on fairness: (2,700) in parentheses (calculated by dividing $5,400 by 2)

Distribution channel costs: (1,350) in parentheses

4. Business- sales channel costs allocated based on customer operating incomes:

Allocate division administration costs from Provalue Division to channels based on channel operating incomes: $(1,265)

(D) Wholesale Channel Customers

Customer A

1. Revenues (Exhibit 15-4): $30,000

2. Customer-level costs (Exhibit 15-4): (25,085) in parentheses

3. Customer-level operating income: 4,915

4. Allocate wholesale channel costs to customers based on customer revenues: (1,166) in parentheses

5. Operating income before allocation of wholesale channel administration costs: 3,749

6. Allocate wholesale channel costs to customers based on customer operating income, if positive (ability to bear): (774) in parentheses

7. Fully allocated customer profitability: $2,975

Customer B

1. Revenues (Exhibit 15-4): $26,250

2. Customer-level costs (Exhibit 15-4): (20,560) in parentheses

3. Customer-level operating income: 5,690

4. Allocate wholesale channel costs to customers based on customer revenues: (1,021) in parentheses

5. Operating income before allocation of wholesale channel administration costs: 4,669

6. Allocate wholesale channel costs to customers based on customer operating income, if positive (ability to bear): (964) in parentheses 

7. Fully allocated customer profitability: $3,705

Customer C

1. Revenues (Exhibit 15-4): $13,000

2. Customer-level costs (Exhibit 15-4): (10,345)

3. Customer-level operating income: 2,655

4. Allocate wholesale channel costs to customers based on customer revenues: 2,150 in parentheses

5. Operating income before allocation of wholesale channel administration costs: 2,150

6. Allocate wholesale channel costs to customers based on customer operating income, if positive (ability to bear): (444) in parentheses

7. Fully allocated customer profitability: $1,706

Customer D:

1. Revenues (Exhibit 15-4): $7,250

2. Customer-level costs (Exhibit 15-4): (5,805) in parentheses

3. Customer-level operating income: 1,445

4. Allocate wholesale channel costs to customers based on customer revenues: (282) in parentheses

5. Operating income before allocation of wholesale channel administration costs: 1,163

6. Allocate wholesale channel costs to customers based on customer operating income, if positive (ability to bear): (240) in parentheses

7. Fully allocated customer profitability: $923

Customer E:

1. Revenues (Exhibit 15-4): $1,800

2. Customer-level costs (Exhibit 15-4): (1,700) in parentheses

3. Customer-level operating income: 100

4. Allocate wholesale channel costs to customers based on customer revenues: (70) in parentheses

5. Operating income before allocation of wholesale channel administration costs: 30

6. Allocate wholesale channel costs to customers based on customer operating income, if positive (ability to bear): (6) in parentheses

7. Fully allocated customer profitability: $24

Customer F:

1. Revenues (Exhibit 15-4): $5,100

2. Customer-level costs (Exhibit 15-4): (4,114) in parentheses

3. Customer-level operating income: 986

4. Allocate wholesale channel costs to customers based on customer revenues: (198) in parentheses

5. Operating income before allocation of wholesale channel administration costs: 788

6. Allocate wholesale channel costs to customers based on customer operating income, if positive (ability to bear): (163) in parentheses

7. Fully allocated customer profitability: $625

Customer G:

1. Revenues (Exhibit 15-4): $4,750

2. Customer-level costs (Exhibit 15-4): (5,100) in parentheses

3. Customer-level operating income: (350) in parentheses

4. Allocate wholesale channel costs to customers based on customer revenues: (185) in parentheses

5. Operating income before allocation of wholesale channel administration costs: (535) in parentheses

6. Allocate wholesale channel costs to customers based on customer operating income, if positive (ability to bear): nil

7. Fully allocated customer profitability: $(535) in parentheses

Customer H:

1. Revenues (Exhibit 15-4): $2,400

2. Customer-level costs (Exhibit 15-4): (2,935) in parentheses

3. Customer-level operating income: (535) in parentheses 

4. Allocate wholesale channel costs to customers based on customer revenues: (93) in parentheses

5. Operating income before allocation of wholesale channel administration costs: (628) in parentheses

6. Allocate wholesale channel costs to customers based on customer operating income, if positive (ability to bear): nil

7. Fully allocated customer profitability: $ (628) in parentheses

Customer I:

1. Revenues (Exhibit 15-4): $2,600

2. Customer-level costs (Exhibit 15-4): (3,300) in parentheses

3. Customer-level operating income: (700) in parentheses

4. Allocate wholesale channel costs to customers based on customer revenues: (101) in parentheses

5. Operating income before allocation of wholesale channel administration costs: (801) in parentheses

6. Allocate wholesale channel costs to customers based on customer operating income, if positive (ability to bear): nil

7. Fully allocated customer profitability: $ (801) in parentheses

Customer J:

1. Revenues (Exhibit 15-4): $4,400

2. Customer-level costs (Exhibit 15-4): (3,578) in parentheses

3. Customer-level operating income: 822

4. Allocate wholesale channel costs to customers based on customer revenues: (172) in parentheses

5. Operating income before allocation of wholesale channel administration costs: 650

6. Allocate wholesale channel costs to customers based on customer operating income, if positive (ability to bear): (134) in parentheses

7. Fully allocated customer profitability: $ 516

(E) Total

1. Revenues (Exhibit 15-4): $4,400

2. Customer-level costs (Exhibit 15-4): (82,522) in parentheses 

3. Customer-level operating income: 15,028

4. Allocate wholesale channel costs to customers based on customer revenues: (3,793) in parentheses

5. Operating income before allocation of wholesale channel administration costs: 11,235

6. Allocate wholesale channel costs to customers based on customer operating income, if positive (ability to bear): (2,725) in parentheses

7. Fully allocated customer profitability: $ 8,510

Customer A:$3,792,650×$30,000,000$97,550,000=$1,166,371Customer  B:$3,792,650×$26,250,000$97,550,000=$1,020,574

b. The second wholesale-channel cost pool is composed of $2,725,049 of the division-­administrative costs allocated to the wholesale channel operating-income-based cost pool in Step 2c. These costs are allocated to individual wholesale customers in Exhibit 15-10, row 21, on the basis of operating incomes (if positive) (see Exhibit 15-10, row 20) because operating incomes represent the ability of customers to bear these costs. In Exhibit 15-10, the sum of all the positive amounts in row 20 equals $13,195,922. The costs allocated to Customer A and Customer B, for example, are as follows:

Customer A:$2,725,049×$3,748,629$13,195,922=$774,117Customer  B:$2,725,049×$4,669,426$13,195,922=$964,269