Keep Drop Customers Decisions

Example 1 Customers
Philips Accountancy
Phillips Accountancy provides bookkeeping, tax, and audit services to its clients. Management believes Phillips Accountancy has several unprofitable customers and would like to perform differential analysis to find out how profits would change if Phillips dropped these customers. Alternative 1 includes the annual revenues, costs, and resulting profit if the company keeps all existing customers. Alternative 2 includes the annual revenues, costs, and resulting profit if the company drops what it believes are unprofitable customers. How should management decide whether to keep all existing customers or drop certain customers?
Answer: Table PA-1 Differential Analysis for Phillips Accountancy presents the format used by management to perform differential analysis. In this case, differential analysis is used to evaluate whether Phillips Accounting should keep all customers or drop unprofitable customers. The information in Table PA-1 Differential Analysis for Phillips Accountancy confirms that Phillips Accountancy would be better off dropping the unprofitable customers (Alternative 2), because company profits would increase by $20,000. The general rule is to select the alternative with the highest differential profit.
Phillips Accountancy Differential Customer Analysis Table PA-1 | ||||
Alternative 1 Keep All Customers | Drop Unprofitable Customers | Differential Amount | Alternative 1 is | |
Sales revenue | 700,0000 | 600,0000 | 100,000 | Higher |
Variable costs | 525,0000 | 450,0000 | 750,000 | Higher |
Contribution margin | 175,0000 | 150,0000 | 250,000 | Higher |
Fixed costs | 45,0000 | 18,0000 | 270,000 | Higher |
Profit | 130,0000 | 132,0000 | (20,000) | Lower |
Notice that in Table PA-1 Differential Analysis for Phillips Accountancy the columns labeled Alternative 1 and Alternative 2 show revenues, costs, and profit for each alternative. The third column, labeled Differential Amount, presents the differential revenues and costs and resulting differential profit. Positive amounts appearing in this column indicate Alternative 1 is higher than Alternative 2.
Negative amounts appearing in the Differential Amount column indicate Alternative 1 is lower than Alternative 2. The fourth column shows whether Alternative 1 is higher or lower than Alternative 2 for each line item.
For example, the differential amount of $1,000,000 for revenue indicates Alternative 1 produces $1,000,000 more in revenue than Alternative 2. The differential amount of $750,000 for variable costs indicates variable costs are $750,000 higher for Alternative 1 than for Alternative 2. Move to the bottom of Table PA-1 Differential Analysis for Phillips Accountancy. Notice that the differential amount for profit is a negative ($20,000). This indicates that Alternative 1 results in profits that are $20,000 lower than Alternative 2. Thus Alternative 2 (dropping unprofitable customers) is the desirable course of action.
Notice that the columns labeled Alternative 1 and Alternative 2 show information in summary form (i.e., no detail is provided for revenues, variable costs, or fixed costs). Some managers may want only this type of summary information, whereas others may prefer more detailed information. It is important to be flexible with the format, to best meet the needs of managers.
Much like product line decisions, managers often use profitability as a determining factor to decide whether to keep or drop customers. This is an issue for all types of organizations, including manufacturers, retailers, and service companies. How does the differential analysis format differ for customer decisions compared to product line decisions? Answer: Instead of tracing revenues, variable costs, and fixed costs directly to product lines, we track this information by customer. Fixed costs that cannot be traced directly to customers are allocated to customers. Let’s look at an example for a company called Colony Landscape Maintenance to identify the similarities and differences between the two formats.
Example 2 Customers
Colony Landscapes
Question: Colony Landscape Maintenance provides services to three large customers:Brumfield, Hodges, and Orth. The segmented income statement in Table CL-1 Income Statement for Colony Landscape Maintenance provides annual revenue and cost information by customer.
However, instead of tracking information by a product line, here we track information by customer.
Colony assigns the allocated fixed costs of $20,000 to Brumfield based on sales revenue, and those costs will continue regardless of Colony’s decision. Thus allocated fixed costs are not differential costs.
Table CL-1 Income Statement for Colony Landscape Maintenance
Examine the Income Statement for Colony Landscape Maintenance carefully and notice that the Brumfield account shows a loss for the year of $15,000. Should Colony Landscape Maintenance drop the Brumfield account? Answer: To answer this question we must take a closer look at the information in Table CL-1 Income Statement for Colony Landscape Maintenance. The variable costs and direct fixed costs are related directly to each customer, and thus are eliminated if Colony eliminates the Brumfield account. That is, all variable costs and direct fixed costs are differential costs for the two alternatives facing Colony.
Income Statement for Colony Landscape Maintenance Table CL-1 | ||||
Customers | Brumfield | Hodges | Orth | Total |
Sales revenue | 200,000 | 500,000 | 300,000 | 1,000,000 |
Variable costs | 170,000 | 380,000 | 200,000 | 750,000 |
Contribution margin | 30,000 | 120,000 | 100,000 | 250,000 |
Direct Fixed costs | 25,000 | 40,000 | 30,000 | 95,000 |
Allocated Fixed Costs | 20,000 | 50,000 | 30,000 | 100,000 |
Profit | (15,000) | 30,000 | 40,000 | 55,000 |
Management of Colony Landscape Maintenance would like to know if dropping the Brumfield account would increase overall company profit. The differential analysis presented in Table CL-2 Customer Differential Analysis for Colony Landscape Maintenance provides the answer. Panel A shows the income statement for Alternative 1: keeping all three customers. Panel B shows the income statement for Alternative 2: dropping the Brumfield account. And panel C presents the differential analysis for both alternatives. The differential analysis presented in Table CL-2 shows that overall profit will decrease by $5,000 if Colony drops the Brumfield account.
Income Statement for Colony Landscape Maintenance Panel A | ||||
Alternative 1 Keep All Customers | Brumfield | Hodges | Orth | Total |
Sales revenue | 200,000 | 500,000 | 300,000 | 1,000,000 |
Variable costs | 170,000 | 380,000 | 200,000 | 750,000 |
Contribution margin | 30,000 | 120,000 | 100,000 | 250,000 |
Direct Fixed costs | 25,000 | 40,000 | 30,000 | 95,000 |
Contribution to Fixed Costs and Profit | 5,000 | 80,000 | 70,000 | 155,000 |
Allocated Fixed Costs | 20,000 | 50,000 | 30,000 | 100,000 |
Profit | (15,000) | 30,000 | 40,000 | 55,000 |
Income Statement for Colony Landscape Maintenance Panel B | ||||
Alternative 2 Drop Brumfield | Brumfield | Hodges | Orth | Total |
Sales revenue | 0 | 500,000 | 300,000 | 800,000 |
Variable costs | 0 | 380,000 | 200,000 | 580,000 |
Contribution margin | 0 | 120,000 | 100,000 | 220,000 |
Direct Fixed costs | 0 | 40,000 | 30,000 | 70,000 |
Contribution to Fixed Costs and Profit | 0 | 80,000 | 70,000 | 150,000 |
Allocated Fixed Costs | 0 | 62,500 | 32,500 | 100,000 |
Profit | 0 | 17,500 | 37,500 | 50,000 |
Customer Differential Analysis for Colony Landscape Maintenance Table CL-2 | ||||
Alternative 1 Keep All Customers | Drop Brumfield | Differential Amount | Alternative 1 is | |
Sales revenue | 100,0000 | 800,000 | 200,000 | Higher |
Variable costs | 750,000 | 580,000 | 170,000 | Higher |
Contribution margin | 250,000 | 220,000 | 30,000 | Higher |
Direct fixed costs | 95,000 | 70,000 | 25,000 | Higher |
Contribution to Fixed Costs and Profit | 155,000 | 150,000 | 5,000 | Higher |
Allocated fixed Costs | 100,000 | 100,000 | 0 | |
Profit | 55,000 | 50,000 | 5,000 | Higher |
A more concise explanation in Table CL-3 Summary of Differential Analysis for Colony Landscape Maintenance, which presents the Differential Amount column shown in Table CL-2 Customer Differential Analysis for Colony Landscape Maintenance along with a brief description of each item.
Summary of Differential Analysis for Colony Landscape Maintenance Table CL-3 | |
Dropping Brumfield Account | |
Sales revenue lost | (200,000) |
Variable costs eliminated | 170,000 |
Contribution margin eliminated | (30,000) |
Direct fixed costs eliminated | 25,000 |
Loss from dropping customer | (5,000) |
Note: Amounts shown in parentheses indicate a negative impact on profit, and amounts without parentheses indicate a positive impact on profit.
Example 3 Customers
Tatum & Associates
The following annual income statement is for Tatum & Associates, a firm that provides legal services to its customers.
Tatum & Associates Income Statement Table TA-1 | ||||
Customers | New Haven Company | Penryn | Elko Corporation | Total |
Sales revenue | 1,200,000 | 750,000 | 1,050,000 | 3,000,000 |
Variable costs | 700,000 | 300,000 | 800,000 | 1,800,000 |
Contribution margin | 500,000 | 450,000 | 250,000 | 1,200,000 |
Direct Fixed costs | 200,000 | 180,000 | 255,000 | 635,000 |
Allocated Fixed Costs | 120,000 | 75,000 | 105,000 | 300,000 |
Profit | 180,000 | 195,000 | (110,000) | 265,000 |
Tatum & Associates is concerned about the losses associated with the Elko Corporation account and is considering dropping this customer. Allocated fixed costs are assigned to customers based on percentage of sales. If a customer is dropped, total allocated fixed costs are assigned to the remaining customers. All variable costs and direct fixed costs are differential costs.
The differential analysis presented in Table TA-2 Customer Tatum & Associates provides the answer. Panel A shows the income statement for Alternative 1: keeping all three customers. Panel B shows the income statement for Alternative 2: dropping the Brumfield account. And panel C presents the differential analysis for both alternatives. The differential analysis presented in Table CL-2 shows that overall profit will decrease by $5,000 if Colony drops the Brumfield account.
Tatum & Associates Income Statement Panel A | ||||
Keep All Customers | New Haven Company | Penryn | Elko Corporation | Total |
Sales revenue | 1,200,000 | 750,000 | 1,050,000 | 3,000,000 |
Variable costs | 700,000 | 300,000 | 800,000 | 1,800,000 |
Contribution margin | 500,000 | 450,000 | 250,000 | 1,200,000 |
Direct Fixed costs | 200,000 | 180,000 | 255,000 | 635,000 |
Contribution to Fixed Costs and Profit | 300,000 | 270,000 | (5,000) | 565,000 |
Allocated Fixed Costs | 120,000 | 75,000 | 105,000 | 300,000 |
Profit | 180,000 | 195,000 | (110,000) | 265,000 |
Tatum & Associates Income Statement Panel B | ||||
Drop Elko | New Haven Company | Penryn | Elko Corporation | Total |
Sales revenue | 1,200000 | 750,000 | 0 | 1,950,000 |
Variable costs | 700,000 | 300,000 | 0 | 1,000,000 |
Contribution margin | 500,000 | 450,000 | 0 | 950,000 |
Direct Fixed costs | 200,000 | 180,000 | 0 | 380,000 |
Contribution to Fixed Costs and Profit | 0 | |||
Allocated Fixed Costs | 184,615 | 115,385 | 0 | 300,000 |
Profit | 115,385 | 154,615 | 0 | 270,000 |
Customer Differential Analysis for Tatum & Associates Table TA-2 | ||||
Keep All Customers | Drop Elko | Differential Amount | Alternative 1 is | |
Sales revenue | 3,000,000 | 1,950,000 | 1,050,000 | Higher |
Variable costs | 1,800,000 | 1,000,000 | 800,000 | Higher |
Contribution margin | 1,200,000 | 950,000 | 250,000 | Higher |
Direct Fixed costs | 635,000 | 380,000 | 255,000 | Higher |
Contribution to Fixed Costs and Profit | 565,000 | 570,000 | (5,000) | Lower |
Allocated Fixed Costs | 300,000 | 300,000 | 0 | |
Profit | 265,000 | 270,000 | (5,000) | Lower |
Summary of Differential Analysis for Tatum & Associates Table TA-3 | |
Sales revenue decrease | (1,050,000) |
Variable costs decrease | 800,000 |
Contribution margin decrease | (250,000) |
Direct fixed costs decrease | 255,000 |
Profit increase from dropping Elko account | 5,000 |
Note: Amounts shown in parentheses indicate a negative impact on profit, and amounts without parentheses indicate a positive impact on profit.