Up ] Current Reality Tree ] Future Reality Tree ]
Case Study: Reengineering Product Distribution

The Situation: One of the largest computer retailing franchise companies with over five hundred franchisee store locations had outgrown their product distribution systems. Things were not good. Nearly every order was late shipping and had many errors. Inbound carriers were frustrated at delays in having their freight unloaded, as the retailer’s receiving operation was constantly several days behind. Suppliers were up in arms over payment delays prompted by a beleaguered payables department unable to validate receipts to invoices. No one trusted the inventory numbers on the computer system and "search and count" the warehouses had become a daily ritual. Customer service moral was falling lower and lower as the phone calls from irate franchisees steadily rose. A hasty relationship with a contract-warehousing provider was established with hopes of rapidly expanding capacity and cutting order fulfillment costs and lead times. Inventory shrinkage was rising astronomically. Franchisees reported their shortages and kept the overages and miss-picks for free. Service grew steadily worse. Franchisees threatened to withhold fees and leave the chain. Operating expenses were out of control. At the same time the computer market was shifting and expanding, double-digit growth was the norm. An incredible opportunity to capitalize on the proliferation of PC technology was in jeopardy.

Operations management was valiantly patching systems, triple checking each shipment. Working massive overtime and staying afloat by sheer muscle and determination. They had a one-year window. Fix it or die. Fix it or watch the opportunity of a lifetime lost to the competition. The work was clearly laid out in front of them. Reengineer product distribution. Fix on time deliveries, cut lead times, eliminate errors, restore vendor relations, reduce inventories, cut operating expenses and lay the foundation to handle massive growth in throughput. Eliminate product distribution from being the constraint to the enterprise’s growth and sustainability of profits. (Refer to the Current Reality Tree for a visual picture of the franchised reseller’s situation) Click HERE to learn more on "How to Read a Logic Tree Diagram".

The Solution: Working with managers, associates, customers, and suppliers, we began by creating a list of undesirable effects (UDEs) that could be observed in the franchised reseller’s current situation. They are listed below:

The Undesirable Effects List (UDEs)

  • Inbound carriers are frustrated at delays in having freight unloaded.
  • Suppliers complain about over due payments and are getting more and more reluctant to ship additional products.
  • No one trusts the inventory numbers on the computer system.
  • Customer service moral is getting lower and lower.
  • Franchisees threaten to withhold fees and leave the chain.
  • Franchisees complain about the "high" cost of freight for their orders.
  • Operating expenses are out of control.
  • Order cycle times are too long.
  • 1st pass order fill percentages are too small.
  • Almost every shipment has multiple product errors. (1. Shortages 2.Overages 3. Wrong items)
  • Losses of inventory are growing larger and larger.

From constructing the Current Reality Tree for this situation, we identified two core problems that were causing the majority of the undesirable effects (UDEs). They were :

(1) The operational processes are fragmented and error prone and lacking support systems.

(2) Customer demand is very dynamic and difficult to predict.

Our direction of solution was determined from these two core problems as follows:

  • We needed to redesign all operational processes and support systems to be oriented toward trapping errors as close to their source as possible and to facilitate error correction at that time. And, to not make error identification and resolution punitive.
  • We needed to redesign all operational processes to be constructed of activities with built in redundant checks for upstream errors that were not previously handled.
  • We needed to add automatic data identification to reduce errors and add efficiencies.
  • We needed to redesign operational processes to support better inventory tracking and control.
  • We needed to better exploit the existing inventory to increase 1st pass order fill by improving forecasting accuracy.

The following high level injections were developed to begin our construction of a Future Reality Tree.

INJECTION: Reduce picking errors by eliminating picking lists and replacing them with either traceable bar coded picking labels or electronic picking assistants (use portable data collection devices).

INJECTION: Audit shipment consolidation and assembly with "check out stand" style shipping workstations.

INJECTION: Use bar coded "package tracking numbers" to identify and track each shipping unit. Incorporate the picking and shipping label into one label.

INJECTION: Attach "license plated" unique bar coded SKU labels to all products as they are received. License plates permit units of an identical SKU to be separately identified, eliminating concerns of miscounts based on scanning the same label multiple times by mistake.

INJECTION: Institute an electronically audited stock movement process to track and record all stocking and restocking product movements (use portable data collection devices).

INJECTION: Provide real time updates and look-ups of inventory information.

INJECTION: Forecasts based on aggregated sales of a large number of franchise locations are more accurate, therefore as we aggregate more and more locations our forecasts improve by the square root of the number of locations aggregated. If we have five hundred locations spread out across 5 regional distribution centers (100 locations per center average) and we reduce the number of centers to two. (250 locations per center) We will see a forecasting improvement of 160%. For this situation, less than two locations is not practical based on transportation times and costs. (Eventually, we eliminate the shipping to store locations and go direct to final customer, improving our forecasting by almost an additional 1600%.)

The Future Reality Tree allows us to validate the implementation of the proposed injections and the attainment of the desirable effects (DEs) which replaced our previously listed undesirable effects (UDEs).

To read more on the actual outcome of this case refer to this  ID Systems article.

Up ] Current Reality Tree ] Future Reality Tree ]

© Connected Concepts LLC.| 5579 B Chamblee Dunwoody Rd. Suite 131| Atlanta GA. 30338 | 770-481-9992