Happy Thursday,

Supply Chain Technology Tip of the Day

Choosing an EDI vendor - especially one that integrates its EDI solution with your ERP system - is not simply a matter of choosing a commodity product on the basis of initial cost and perhaps feature sets, in order to meet a retailer's EDI mandate.Haitham Ghadiry

Changes in Direct Store Delivery for Walmart ASN


Walmart….I know it is almost universally recognized as a dirty word for the many challenges they create for their DSD suppliers.  However, today I would like to talk about the beneficial changes to operations that have resulted from their ASN initiative.

Let’s first look at how many “traditional” DSD vendors handled their order flow before ASN’s (I am going to state the implied assumption of pre-sold orders rather than peddle sales here, but really ASN is conceptually impossible without pre-sales).

  1. Order is received by vendor “X” hours or days in advance of required delivery (the method of entry is for another discussion at a later date) into route accounting software.
  2. Order goes through some level of processing to determine how it will be built.  Eg. Products are aggregated with common packages, or order is built specifically for customer (read my previous blog on whether to build by order or not).
  3. Pallet(s) are built by the distribution warehouse staff with paper pick tickets / load sheets.  Possibly with, but more likely without checking of pallet content.
  4. Driver shows up the following morning and verifies his load content and has to either manually pick additional product to replace short picks / miss-picks, or if they are lucky gets some help from the receiving staff.
  5. Driver delivers goods to store where additional invoice/delivery adjustments may be required due to earlier verification issues.

This process obviously has some fairly inefficient steps here, but I think it is safe to say this was generally accepted, and even still is today with many small to medium sized distributors.

The Walmart ASN initiative continues to roll out across North America.  To be compliant DSD suppliers not only have to pick at a rate of near constant perfection, but they also have to submit this information well in advance of the driver showing up at the back door with product.  Meeting these requirements means manual picking processes have to go away and any pick discrepancies must be accounted for AND communicated in advance of delivery.   This means adding a step to update pick quantities and another step to update delivery handhelds have to above process.  It doesn’t take a rocket scientist (no offence to the rocket scientists), to figure out the changes required to complete these tasks cost $$.  But let’s look at how these operational changes provide benefit beyond being able to continue to supply Walmart with product.

  1. Productivity Metrics:  by using either a handheld or mobile computer solution you should be able to track more data than just updated pick quantities.  Why not select a solution to track picking time to generate productivity numbers?  These metrics could be used for incentive picker compensation or alternative motivation plans.
  2. Driver Check Out:  with loads already reflecting the changes to pick quantities driver checkout processes should take far less time, getting them out into the trade faster.
  3. Delivery Time Reduction:  similar to point above, with accurate load/invoice information route drivers reduce time required to handle the administration side of mobile sales, and should be able to spend more time actually servicing stops.
  4. Risk of Fraud:  unfortunately fraud happens…but with accurate order/invoice numbers the need for invoice adjustment will theoretically go to zero.  While I doubt the zero adjustment goal will be present 100% of time, far fewer invoice adjustments means those that happen need better explanation and can be investigated to confirm legitimacy.
  5. Route Reconciliation:  here is yet another spot where accurate orders result in time savings.  The lack of invoice adjustments, and accurate inventory numbers save labor for route drivers and reconciliation clerks alike.
  6. Inventory Accuracy:  actual pick quantities rather than relieving inventory based on expected numbers give your operation and sales teams real on hand data to know what needs to be ordered, and what is available to sell.

As you can see there are definite benefits to implementing a process solution where actual picked quantities are efficiently tracked.  To truly reap the benefits of this process though, operations should be applying this supply chain improvement not only to their Walmart ASN accounts but to all (or at least the majority) of their accounts!

Traditional perceived challenges to dealing with Walmart aside, I think this is one area where the supplier integration changes they have created in the DSD supply chain best practices are actually forcing operations to become more efficient!  I hope that you consider some of the points above and how they could help your direct store delivery operations as well.

Comments for Changes in Direct Store Delivery for Walmart ASN

Name: Tim Moon
Time: Wednesday, May 26, 2010

This process in theory is a helpful program, however the reality from our experience with the receivers at the back door, their main concern is shrinkage, and the best way to control that from a delivery standpoint is to verify each case being brought into the store. Here at Brown, both Ty Walls (Hand Held Manager) and myself have ridden with our delivery drivers on separate occasions, and out of our 20 active Wal-Mart stores only 2 currently use the ASN while the others tear it off the pallets and manually count in each piece upon delivery. This leads us to believe that even they don’t believe in this program and they are the ones that requested it.

Name: Anna Ashmore
Time: Wednesday, May 26, 2010

Nice Reading...thanks

Name: Derek Curtis
Time: Wednesday, May 26, 2010

Thanks for the comment Tim. Unfortunately the inconsistent utilization of their own process by Walmart does definitely undermine the benefits. Although individual Walmart sites may not care to implement receiving processes in line with the overall intention of the project, in many cases compliance is still a necessary evil. Given this requirement (properly utilized or not) my intention here was to point out some peripheral benefits of implementing this solution. If you can't get the receivers to "honor" their end of the ASN agreement I hope that you at least get some of the operational benefits I listed above.

Comments for Changes in Direct Store Delivery for Walmart ASN

blog comments powered by Disqus
Supply Chain Technology Resources
Stay Smart
What to stay on top of the supply chain technology space? Our newsletter is for you.
Get Smart Now
Resource Center
Get valuable supply chain videos, whitepapers and case studies...FREE.
Watch & Learn
Adaptability Video Series
HighJump adaptability isn't just a slogan.