Download White Paper: Increase Profits 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 graphs.  First is a Pareto Chart of total sales by Sales Rep.  These results were not surprising.  KT is clearly the best Sales Rep as measured by Sales $.  Everyone knew that.  On the right side of the graph is “cumulative percentage”.  KT generates 25% of Sales $.

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.

Pareto Chart – Sales $ by Sales Representative

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.

We also have the 25th and 75th percentile.  At the 25th percentile (also-known-as the 1st Quartile) 25% of the customers are less profitable and 75% are more profitable.

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.  From this data table and graph we can see that even very good Sales Reps have many unprofitable customers.  In fact, the best Sales Reps “hide” their bad customers because they have some very good customers.

The graph below is a Box-Line chart.  It shows the same data that is in the table in a different format.

  • The top line represents the most profitable customer for each Sales Rep that is not an outlier
  • The top of the box represents the 75th percentile profitable customer for each Sales Rep (25% of customers are more profitable and 75% are less profitable)
  • The thick line in the middle of the box is the median profitable customer
  • The bottom of the box represents the 25th percentile profitable customer
  • The bottom line represents the least profitable customer for each Sales Rep

Box-Line Table & Chart – Net Profit $ of Customers grouped by Sales Rep

Note: To make the chart below more useful, it does not include outliers

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

"*" indicates required fields

Ask us your Lean, Six Sigma, or Supply Chain question.

We're the experts! We'll get back within 48 hrs. with a valuable response.

This field is for validation purposes and should be left unchanged.

“We are pleased that Essex selected Supply Velocity, Inc. as our Lean Implementation Partner. At one facility, we have saved over $350,000 in work-in-process inventory, reduced throughput time from 2 weeks to minutes and increased inventory turns 3 to 8 times per year. All these results are in just 6 months. Our return of investment is very high.”
Terry Etter, Vice President of Operations , Essex Medical Systems
“We are using Supply Velocity’s Lean Six Sigma methods to analyze a variety of processes including rationalizing SKUs (stock-keeping-units). By using math to evaluate SKUs we took some of the emotion out of our decisions. We expect significant increases in sales and productivity from reducing poor performing SKUs.”
Mark Kelso, Director of Process Improvement, Save-A-Lot
“Supply Velocity has provided the technical expertise and political capital to move our project forward. They have just the right amount of push and the right amount of support. Supply Velocity has helped us make real changes to improve efficiencies in logistics without jeopardizing our performance. We’re happy and our customers are happy.”
David Walters, President, Hy-C

“Supply Velocity gave us the tools to analyze our business and processes based on the facts and numbers versus our perceptions. Our common quote was “Let the numbers lead us”. The key for our organization was how quickly we moved from classroom to actual project initiation. We were able to jump in, start using the tools and see a difference right away.

The get-into-action approach was good for our culture.”

Ned Lane, President, CeeKay Supply
“In 2015 we began working with Dr. Mitch Millstein to optimize our inventory locations supporting e-commerce and in-store inventory needs. From this work we developed a new omni-channel warehousing and inventory plan that entirely redefined our approach to warehousing, inventory management, store distribution and fulfillment. As a result of the analyses by Dr. Millstein we have begun the move to an improved omni-channel design by reassigning MSAs to new warehouses, greater leveraging of in-store inventories to satisfy e-commerce demands, and exploring acquisitions of new warehousing space in strategic locations. We have already seen an improvement of $300,000 from both more efficient shipping strategies due to better inventory management.”
Rob Bowers, Vice President of Strategy, Total Hockey
“C&R was struggling with labor productivity. The construction crews were often missing materials that they needed to do their work. This caused significant idle time. Supply Velocity, Inc. and C&R used value stream mapping and visual management tools to make dramatic improvements in operations. Most importantly, two years later C&R is sustaining and improving on the implementation. C&R’s return on investment was 11:1. C&R had a record year last year in both sales and profits and would not have been able to pull it off without the changes Supply Velocity, Inc. helped us make.”
Tom Kuthe, V.P. Construction Operations, C&R Mechanical
“In thirty years of hiring consultants, Supply Velocity, Inc. was the first to tell me what they were going to do, set a price they stuck to and substantially exceed my expectations. I have recommended them to friends and acquaintances. They were true partners in assisting with the turnaround of an acquisition we had been struggling with for two years.

Their math-based technology, solid down-to-earth facilitation skills, and positive, patient and enthusiastic attitude combined to make our implementation of Lean a very rewarding experience.

We increased our production by 50% in the first month of implementation and continue to see improvements. Improvements have not only been realized in productivity, but also in quality and morale. We have increased profitability by $2M on flat sales of $10M.

Based on Supply Velocity, Inc.’s integrity and our results, I will continue to refer them to others and utilize them in the future as we expand our company through acquisitions.”

Bill Gilbert, President, Fusion Coatings
“Our experience with Supply Velocity was one of the best values we have ever had from a consulting project. Cyril Narishkin brought a structured lean methodology, invaluable experience and engaging facilitation skills to help us streamline a very complex and disjointed sales order process. Just as importantly, our team now has the knowledge and process competencies to address other business improvement opportunities going forward.”
Mike Howard, CEO, Aspeq

“In a time of volatile supply chain disruption, Supply Velocity is helping us develop Demand and Supply Planning processes to proactively tackle these new challenges. They are genuine partners, working with our team, facilitating and teaching.”

Jane Thrasher, Vice President of Supply Chain, Horizon Hobby
“Mitch Millstein and his team helped guide our shop fabrication division in the re-layout of our custom pipe and steel fabrication facility when we moved into a new building. It is not only the results but how he helped. We were involved in every step. I personally did time studies and was able to see the non-value added steps required to manufacture in our old layout. When we created our new layout, everyone was involved, from the executive team to our direct labor force. With Mitch’s help we increased our throughput by a 3x multiple, while providing more competitive prices to our clients as a result of the efficiency improvements.

This has enabled us to not only make more money but also to expand our commercial reach and serve more, and larger customers. I would recommend Supply Velocity to any company that wants to make improvement in supply chain and operations.”

Geoff Gross, President, Gross Mechanical
“For several years we have worked with Supply Velocity to support us with their expertise on Lean Operations and Supply Chain Management. Supply Velocity has helped us implement Lean, improve our inventory systems, and educate our people. They are professionals who are always available to help us as needed.”
Lorenza Pasetti, CEO, Volpi Foods

“Your process encourages this group to work together, better communicate and have fun doing it.”

George Edinger, President, C&R Mechanical
“Closure Medical recently completed a major reorganization in order to enhance our ability to rapidly create innovative medical devices. We hired Supply Velocity to help us map out the process and service flows of the new organization that would maximize our product development process (PDP). In four weeks, Supply Velocity helped us envision a new PDP structure, develop measures and accountability for each step, and gain consensus within the organization. Supply Velocity’s focus on speed and accountability helped us complete a critical project in a timely fashion.”
Gabe Szabo, Vice President, Product Development, Closure Medical – A Division of Johnson & Johnson
“We engaged with Supply Velocity to help us embed process improvement at all levels of the business. Our team learned from Mitch to let the data drive decisions, to use Lean tools to help us see our processes critically and objectively, and to create a control plan to manage all of the tasks that were the outcome of the data study.

The project turned out to be very significant to the company and most importantly, our customers. We reduced our customer wait times by 40%, and cut in half the labor cost to fulfill customer orders.

Some results are not able to be measured. However, as a result of this project, we have started to build a Lean mindset and culture, which is part of our strategic mission to save our customers money. Supply Velocity has been a valued partner in this mission.”

Dionne Dumitru, COO, Weekends Only
“The role of the Erie Insurance Marketing Department has been evolving over the past several years – from a support role to a more critical role of driving growth in our organization. Because of our increased workload and desire to prioritize the most critical projects, we hired Supply Velocity to teach us the skills of Lean Six Sigma.

Participants included the Promotions, Market Research and Agency Licensing sections of the Marketing Department.

We learned valuable tools to help us to prioritize based on the voice of the customer.

I firmly believe these skills made a difference in how we work every day. We are moving new projects forward, eliminating or changing ineffective processes, and we are a much stronger department. We continue to use the tools to help us with our highly-complex and time-consuming projects. Supply Velocity helped us to accomplish our goals.”

Karen Rugare, Director of Marketing, Erie Insurance
“Supply Velocity’s Lean Six Sigma System has given us new tools to help improve our sales performance. We have learned new ways to analyze our business which makes problem solving more accurate and has made us better leaders.”
Rachel Andreasson, Executive Vice President – Marketing, Wallis Companies

“Supply Velocity created visibility within our Assurance Services Group… visibility of performance, Client-service, employee satisfaction and processing time. Using the Supply Velocity System, Audit Report Cycle time is down over 50%. We are using his strategies to create greater Client loyalty.”

Fred Kostecki, Partner-In-Charge, Assurance Services, Rubin Brown
“Supply Velocity has helped Clean succeed in a number of ways. First, they provided the education that kicked off our Lean Process Improvement journey. They also facilitated a number of large supply chain and process improvement projects including: 1) building quality into our direct-labor productivity incentive program, 2) designing the layout of our garment warehouse, and 3) streamlining our route service process.

We have integrated the methods that Supply Velocity taught us into our management and strategic planning. In the process our quality measurement has improved 22% from 2013 to 2015, we have reduced required annual labor by 2200 hours from the garment facility layout project and we’ve seen 50% decrease in error rate. Obviously the numbers speak for themselves, but just as important, Supply Velocity has been fun to work and have become true partners. They have “taught us how to fish” so our internal teams are able to implement change on their own, with the skills we learned from Supply Velocity. This relationship has been invaluable.”

Jeff Lazaroff, Senior Vice President, Clean Uniform
“Myerson engaged Supply Velocity, specifically Ray Davis to visit our plant in Trinidad to conduct a two day assessment of our production procedures and provide us feedback on areas for improvement and where applicable, areas for future analysis.

Put simply, we got everything we paid for and in addition to more in depth analysis, we got specific tasks that were immediately actionable. Our local management team found Ray to be engaging, highly credible and insightful based on his wide experience. In other words the cultural differences and lack of specific industry knowledge weren’t impediments to things we could implement immediately and on our own. In a nutshell it was money well spent and will pay itself back many times over.”

Lee Hartwell CPA, Plant Manager, Myerson Tooth
“In the spring of 2003, the St. Louis Area Chapter of the American Red Cross engaged Supply Velocity, Inc. to perform a study and make recommendations to streamline office processes, maximize cash flow in purchasing and warehousing and restructure and enhance our maintenance department. Supply Velocity, Inc.’s process was methodical, flexible, staff-oriented, inclusive and, above all, trackable.

In the last six months, our Chapter has realized expense savings of over $380,000 annually, and significant improvement in intra-company service levels has been attained. Supply Velocity, Inc. will return to the Chapter periodically throughout the next 18 months to audit our newly implemented processes. We have been pleased with our results and Supply Velocity, Inc.’s professionalism.”

Joe White, CEO, American Red Cross – Saint Louis Chapter
“Many thanks to all three Supply Velocity presenters. I think you guys took a very difficult time for learning and capitalized on everyone’s time and training needs. I truly hope this helps your business as this was a considerable undertaking on the part of Supply Velocity. Outstanding!!”
Mark Holdinghausen, VP of Operations, DEMA Engineering
“Supply Velocity is driving instrumental change in our inventory management processes. This is critical for us to be competitive in a supply chain environment with numerous disruptions. They are making change happen, which can be challenging in a 182 year old organization.”
Jim Carroll, Executive Vice President Operations, Schaeffer Manufacturing

“I am thrilled to provide this testimonial for Supply Velocity and their outstanding work in implementing Lean Warehouses and processes at Crescent Parts & Equipment through the COVID pandemic. With their data-first focus and Mitch’s exceptional coaching and experience, they transformed our business into a more supply chain-oriented organization, enabling us to grow while prioritizing employee safety and creating a better work environment. Supply Velocity’s expertise in Lean methodologies and their comprehensive evaluation of our customers have been instrumental in optimizing our operations and increasing customer satisfaction. We highly recommend Supply Velocity to any company seeking to implement Lean processes and enhance their supply chain efficiency.”

Josh Cole, Director of Supply Chain, Crescent Parts & Equipment
“We used Supply Velocity on our Warehouse optimization project. One of the key characteristics of Supply Velocity is that they listened to our requirements and provided a clear path for our Warehouse processes using lean tools and our future sales growth as objectives.”
Haris Tokalic, President, Grand Rock, Inc.
“Anheuser-Busch Precision Printing had been implementing Lean Operations on our own for the past two years. We needed to move faster and partnered with Supply Velocity, Inc. Through Supply Velocity, Inc.’s mathematical workflow balancing and visual management tools, dramatic improvements were achieved. The entire converting operation was rearranged based on Lean principles. The result is a 20.6% productivity improvement, enabling us to operate with 23 fewer people in production.”
Rich Lavosky, General Manager, Anheuser-Busch Precision Printing
“We used Supply Velocity to rethink our sales process. By analyzing the entire process we found wasted time in our Sales, Admin and Operations departments. Streamlining this process created extra time for each Sales Rep, allowing them to spend more time with Customers and increase the value we add. Gross profit margins are up 40%!

We are now using Supply Velocity to help us rethink our entire Strategic Plan.”

Jeff Reitz, Vice President, Central States Bus
“Isolating a problem, finding short, and long term solutions with measurable results is what was promised and results is what was delivered by Supply Velocity. Upon launch of the Lean Six Sigma Selling System, we knew more about our customers, our products, and were able to create a solid plan to increase sales of our most profitable products. Within months of implementation, our booked sales jumped 60% and our most valued customers were getting direct, active, and calculable attention.”
Mark A. Presker, General Manager, Architectural Millwork of St. Louis