How Does Integrated Business Planning Support Profitability Analysis?

Chris Grundy

In my initial blog in this series related to integrated business planning (IBP) I described 02 Jul 2013 --- Businessman analyzing pie chart on digital tablet --- Image by © Hero Images/CorbisIBP as seamlessly integrating user interfaces and workflows. IBP links strategic, operational, and financial objectives and plans to improve employee alignment with the executive team’s strategy and financial performance.

In my second blog I discussed issues, needs and solutions related to strategy execution and how IBP is part of the solution.

In this blog I will discuss issues, needs, and solutions related to product, channel, and customer profitability and how IBP is part of the solution.

The expansion from product to channel and customer profitability analysis

I would like to believe that the reporting of more accurate product and standard service-line cost and profitability information using activity-based costing (ABC) principles is now common. ABC accurately traces expenses into costs with resource and activity drivers and provides cost visibility that is traditionally hidden.


Sadly, many organizations continue to use a single indirect and shared expense “pool” that allocates resource expenses into costs based on a single cost factor, which violates cost accounting’s causality principle (also see my earlier blog post on this topic). Hence, compared to ABC’s disaggregating a single cost pool into multiple ones and then tracing each pool with an activity cost driver based on a cause-and-effect relationship, the existing costs are flawed and misleading. The products and service-lines are simultaneously over- and under-costing because allocations always have a zero sum error. It’s baffling how accountants can accept this deficient costing practice when ABC is a better alternative.

But let’s put that observation aside and focus on an increasingly more relevant information need: channel and customer profitability reporting. This includes not just product-related expenses but also the “costs to serve” expenses incurred through sales and distribution channels and by customers.

Why do channel and customer costs matter?

In the past, companies focused on developing standard products and standard service lines and then incenting their sales force to push and sell them to existing customers and prospects. But many products or service lines are one-size-fits-all and have become commodity-like. For example, most banks offer similar checking and deposit services. In addition, today competitors can more quickly replicate a company’s standard products and services. Consequently, the importance of services rises, which results in a shift from product-driven differentiation toward service-driven differentiation to differentiated customer microsegments in order to gain a competitive advantage. That is, as the competitive edge from product advantages is reduced or neutralized, the customer relationship grows in importance.

To complicate matters, suppliers are aware that they have a broad range of high- and low-demand customers. For example, high-demand customers might regularly change delivery schedules, require special treatments, return goods, or frequently phone the customer service help desk. Low-demand customers do none of these things. The extra consumption of expenses from high-demand customers means they are relatively less profitable than you might assume from the sales volume of their purchases. What this means for the marketing and sales functions is that their objective is no longer solely about increasing market share and growing sales but about growing profitable sales. That requires tracing expenses below the product gross profit margin line, including channel distribution, selling, marketing, and customer service costs to serve.

The crucial challenge is to use ABC beyond calculating valid customer profitability data for decision support. The benefit comes from identifying the profit-lift potential of customers, and then realizing the potential and fulfilling it with smart decisions and actions. Marketing and sales need to view customers as an investment, such as in an individual’s personal stocks and bonds portfolio, rather than as someone or some company to spend money on.

Creating a customer profit and loss financial statement

Customer profit and loss (P&L) information quantifies what everyone already may have suspected: Customers who purchase roughly the same volume and mix at similar prices aren’t nearly the same when it comes to profit. As I just described, some customers may be more or less profitable based strictly on how demanding their behavior is on a supplier. This information also provides cost visibility and transparency when it comes to the business processes and work activities that cause the higher or lower costs – the cost drivers.

Although customer satisfaction and loyalty are important, a longer-term goal is to increase both customer and corporate profitability. There must always be a balance between managing the level of customer service to earn customer loyalty and the impact it will have on increasing owner and shareholder wealth.

There are two major “layers” of profit margin in a company’s P&L:

  1. The mix of products and service lines purchased.
  2. The non-product “costs to serve” apart from the unique mix of products and service lines purchased.

The figure below combines these two layers in a two-axis grid: (1) the composite product gross profit margin of the product mix each customer purchases (reflecting net prices to the customer), and (2) their cost to serve. Any individual customer (or grouped cluster) can be located at an intersection where the circle’s diameter size reflects each customer’s revenues. The figure debunks the myth that customers with the highest sales volume are also generating the highest profits.

Cokins Q2 2015 blog no 3 figure (2)

The objective is to drive customers with profit-increase potential to the upper-left corner of the grid through a host of actions, such as surcharge pricing, upselling, and cross-selling. For example, if a customer purchases a set of golf clubs, can they also be sold a golf shirt? And if they purchase the shirt, can they be sold a second shirt at a discounted price? The data could also help suppliers identify customers who are substantially unprofitable: those who reside deep in the bottom-right of the grid. These relationships can be terminated through actions such as increased pricing or reduced service-level tactical actions that might encourage customers to “de-select” themselves (i.e., “firing” the customer).

One critical reason for knowing where each customer is located on the profit matrix is to protect your most profitable customers from your competitors.

Integrated business planning (IBP) leverages customer profitability reporting

The message here is that management accounting must help the sales and marketing functions. A company needs to know which types of customers are attractive to retain, grow, win back, and acquire – and those who are not. To maximize shareholder wealth, a company also needs to know how much to optimally spend retaining, growing, winning back, and acquiring each type of customer. It can unnecessarily spend excessively on loyal customers and therefore destroy shareholder wealth. Or it can spend too little on marginally loyal customers and risk their defection to a competitor. Without this information, financial performance falls short of its full potential.

Integrated business planning integrates financial, strategic, and operational information. For example, individual customer profitability information may be linked to KPIs in the balanced scorecard referenced in my prior blog. The same information may be used as compensation bonuses against targets for the sales force instead of exclusively using only sales volume.

In my next blog I will discuss integrated business planning with operations for productivity improvement.

Want more future-focused business strategies? See The 5 Most Important Tools of the Make for Me Future.

Gary_CokinsGary Cokins (Cornell University BS IE/OR, 1971; Northwestern University Kellogg MBA 1974) is an internationally recognized expert, speaker, and author in enterprise and corporate performance management (EPM/CPM) systems. He is the founder of Analytics-Based Performance Management LLC . He began his career in industry with a Fortune 100 company in CFO and operations roles. Then 15 years in consulting with Deloitte, KPMG, and EDS (now part of HP). From 1997 until 2013 Gary was a Principal Consultant with SAS, a business analytics software vendor. His most recent books are Performance Management: Integrating Strategy Execution, Methodologies, Risk, and Analytics and Predictive Business Analytics.

Chris Grundy

About Chris Grundy

Chris Grundy is the Director of Product Marketing at SAP. His specialties include lead generation, product management, business analytic and marketing management.