We’ve discussed the basics of OTIF and the fundamentals of OTIF before, but we thought we’d drill down deeper into the individual metrics. First, we’ll start by reviewing the basic goals of OTIF, and then we’ll dive into each metric and the compliance issues of each metric.
We are only covering Supplier Accountability OTIF metrics. Please note: There are some OTIF issues that are listed as Walmart Accountability, but for the sake of clarity, we will not be discussing those. For more information, check with your buyer.
Walmart’s monthly OTIF goals that suppliers are responsible for are as follows:
For more on this, check out our Why is OTIF Important? blog post.
On Time compliance issues for “Prepaid” are for times where you manage the freight. In these instances, you own the On Time accountability.
Cases on an order are designated “Prepaid Early Delivery” if the cases were delivered to the distribution center (DC) before the Must Arrive By Date (MABD) window. Early deliveries can be bad because they cause congestion in Walmart’s DCs and can actually result in the order arriving late to the store.
Cases on an order are designated “Prepaid Late Delivery” if the cases were delivered to the DC after the MABD window. Late deliveries can be bad because they can cause replenishment and stocking issues. You want to make sure that your product is always stocked and having on time deliveries will help with that.
Cases on an order are designated “Prepaid Unscheduled Appointment” when the cases arrive on a truck at the DC without a delivery appointment. Because the shipment did not have a delivery appointment, the Pro date will be considered the Arrival Compliance Date. This Pro date represents when shipping documentation is processed and may be days after the actual goods arrive. Scheduling DC appointments is something typically done by you or your carrier/3PL. Scheduled appointments are important so that the DCs know what to expect and can plan accordingly.
For more information on MABD windows, check our OTIF – How To Meet Delivery Appointments article.
Collect Ready orders are instances where Walmart or a third party is in charge of picking up the order. Some compliance issues for Collect Ready orders go into the supplier’s accountability bucket, while others are owned by Walmart. Here are the ones that are the supplier’s accountability.
The “Supplier Ship Point” bucket occurs when an order fails to be Collect Ready because the assigned carrier could not secure the load in a timely manner due to an issue caused by the supplier. This is based on a carrier EDI transmission reason code of “Held by Shipper”.
This means that the carrier was not able to secure the product upon the pickup attempt due to a supplier-caused issue. For example, the facility may have been closed, there may have been too many trucks in line to pick up shipments, or the product simply wasn’t ready. In order to avoid accountability, you are required to submit a ticket to Walmart Transportation if a carrier does not show up for a pickup appointment. Either way, this compliance issue will count against your OTIF score.
You will see a “Late Transport Notification” if the Request for Routing was not completed in a timely manner. Requests for Routing should be submitted by 4:00 PM CST the day after receiving the order.
This means that the supplier failed to submit a request for routing by 4:00 PM CST the day after the PO was submitted by Walmart. This includes weekend days, so be sure that you’re able to route all POs the day of, and the day after, any of your order review days of the week. Order Review Days are the days of the week that you’ve told Walmart you can receive POs on.
For manual orders, the expectation is to key the request 30 days prior to the MABD. If the order is received less than 30 days prior to MABD, the expectation is to key the routing request by 4:00 PM CST the day after receiving the order.
Specifically for D94 (Produce) items, System and Manual PO routing requests should be submitted at least two day prior to the ship-on day. If the order is received less than two days prior to the ship-on day, the expectation is to key the routing request on the day the order was received.
In-Full metrics measure the number of cases ordered against the number of cases delivered.
An order is considered “Not in Full” if the number of cases received was less than the number of cases ordered per PO line. System-generated orders are measured against the original order quantity. Manual orders are measured against the adjusted order quantity.
This means cases were not delivered to the destination as ordered. If a supplier cancels an entire PO or individual PO lines, the cancellation information is available to review in OTIF. Canceling a PO or PO line can be helpful as opposed to just not fulfilling an order with Walmart so that you can differentiate canceled POs on Not In Full issues from POs where you did not expect to be short.
SupplyPike offers a deep dive into your OTIF scorecard, showing you all the metrics in an easy to digest format.
Perform extensive analyses on each metric and find trends and root causes easily.
Want more? Schedule a tour today!
SupplyPike builds software to help retail suppliers fight deductions, meet compliance standards, and dig down to root cause issues in their supply chain.Visit their Website ➝