Dhs Table

Increase Profit through Six Sigma Customer Analysis

Abstract

Six Sigma is a powerful tool to analyze and solve business problems.  A significant problem many companies have, even if they don't realize it, is customer profitability.  This paper will show how one company analyzed their customers using Six Sigma.  They discovered tremendous opportunities to reduce costs and increase profits while delivering great customer service.

 

Understanding Customer Profitability

The company used in this case study is a distributor of liquids used in their customers operations.  These liquids are shipped by the bottle, 5 gallon bucket, 50 gallon barrel and in bulk trailers filling up on-site bulk tanks.

 

All distributors focus on gross profit as defined by sales-price minus purchased cost of the item.

 

Distributor Gross Profit $ = Selling Price – Purchased Cost

 

This distributor transports all of its products to customers via their truck.  They charge for this service, to cover fuel and other vehicle costs.  The farther away the customer is from the warehouse, the greater the charge.

 

What is hidden from the normal financial view of customer service are the non-chargeable, variable order-processing costs.  Every order, no matter large or small, costs this company to process.  In addition, these costs are all variable.  As the number of orders increases the number of people required to do this work will also grow.  These costs include:

• Order entry / processing personnel
• Invoicing personnel
• Warehouse labor

 

While this was not an accounting project, we were trying to understand which customers were profitable and why.  We took all of these costs for a 12 month period and divided it by the total number of orders we processed.

 

Per-Order Processing Cost =

Total Variable Order Processing Labor Costs / Total # of Customer Orders

 

Per-Order Processing Costs = $105

 

The actual calculation resulted in the per-order costs equaling $105.  This means every time a customer placed an order it costs the company $105 in overhead labor to process.  This does not include the actual delivery expense, which is covered by the delivery charge.

 

Using this "Per-Order Cost" we can now calculate overall customer profitability.

 

Customer Net Profit $ = Gross Profit $ – (# of Orders x Per Order Cost)

 

For every customer we can calculate the net profit dollars they contribute.  Management accountants may find fault with our cost-allocation method.  Therefore, use whatever allocation method you want.  As we will see, the purpose of this analysis is to show that some customers are wildly profitable and others are money-losers.

 

Do Your Best Sales Reps Have Your Worst Customers

We decided to do this analysis by Sales Representative.  Any improvement ideas would have to be implemented by the Sales Force so we focused all analyses on customer profitability for each Sales Rep.

 

On the following pages are the two important sets of data.  First is total sales by Sales Rep.  These results were not surprising.  KT is clearly the best Sales Rep as measured by Sales $.  Everyone knew that.  In addition to sales is "cumulative percentage" of sales generated by that Sales Rep.  KT generates 25% of Sales $.

 

Rep: Sales $; % of Total

KT: $8,360,000; 29%

DH: $6,260,000; 22%

BC: $4,970,000; 17%

RT: $3,430,000; 12%

DM: $2,420,000; 8%

CC: $1,490,000; 5%

JB: $1,190,000; 4%

DB: $957,000; 3%

 

However, Sales $ is not what we are measuring.  Therefore, this Pareto Chart really hides the important issue, customer profitability.  By totaling Sales $ for each Sales Rep, we hide how each customer is doing.  Instead, we want to look at individual customer profitability.

 

Median – The Middle Value or 50th Percentile

To better understand customer-profitability we will use an often misunderstood statistic, the median.  If you sort customers by profitability from most profitable to least, the number right in the middle would be the median.  50% of the customers would be more profitable and 50% would be less profitable.  This is why the median is often called the 50th percentile.

 

Rep: Median Profitability per Customer

KT: -$30

DH: +$186

BC: +$119

RT: -$91

DM: +$51

CC: -$269

JB: -$237

DB: -$469

 

Rep: Max Profitability Customer

KT: $57,736

DH: $13,334

BC: $18,903

RT: $22,300

DM: $45,394

CC: $36,396

JB: $8,814

DB: $10,270

 

By analyzing the data in this way, we find shocking results.  Even KT our highest Sales $ Sales Rep has half of the customers he calls on earning less than negative $30!  DH, while lower in Sales $, has more customers in positive profit territory.

 

Of course some Sales Reps are much worse.  Half of DB's customers lose $469 each year.  From this data table and graph we can see that high and low performing Sales Reps have many unprofitable customers.  In fact, the best Sales Reps "hide" their bad customers because they have some very good customers.

 

Improvement Action Items

From this data we learned that all Sales Reps have work to do.  Everyone has unprofitable customers.

 

If you go back to the formula that we used to calculate profitability, you can understand what the Sales Reps had to do.  The driver for these problems is the number of orders.  This company's customers place orders too frequently.  Instead of ordering a bulk delivery once a month, they have customers ordering barrels two-times a week.  The Sales Reps had to go back to their customers and work together to understand the benefit to both companies of reducing order frequency.  (If it costs us $105 to process an order, it also costs the customers to process purchase orders and invoices.)

 

This change has allowed the business to grow, adding customers and volume, while reducing the number of people working in order processing.

 

(They are also working on reducing order-processing labor costs through Lean and information technology.)

About the Author

For more information on this subject goto www.supplyvelocity.com, where you can view our full white papers. Mitch Millstein, CFPIM, C.P.M., CQM, CQE President Supply Velocity, Inc. 314-406-4962 mitch@supplyvelocity.com http://supplyvelocity.com

Dhs Table Tennis - My History