Why is OTIF Important?

SHARE
Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Not complying with your purchasers’ OTIF requirements can be very costly, and result in hefty fines. For example, Walmart fines its vendors 3% of the cost of goods sold if the order fails OTIF requirements. In 2016, Target stores increased their OTIF penalties to 5% of the order cost, five times what it previously was. That kind of money adds up!

Having your product in stores according to your sales forecasts and correctly stocking your product helps maintain or even increase your sales and overall profit margins. According to recent Walmart data, poor In-Full performance accounted for $1.7 billion in lost sales during the 2019 fiscal year.


The formula for your OTIF score:

OTIF ( % ) = number of cases on time in full ÷ total number of cases ordered * 100

Note: Orders can be split and still comply. If an order has two separate delivery dates, consider each delivery separately. Check with your purchaser before breaking up orders to make sure they accept split shipments.


The Walmart OTIF Program

Walmart breaks down OTIF into separate metrics, On Time and In Full. Each metric has its own percentage goal that must be met in order to avoid fines. The metrics that apply to you differ based on whether you manage your own transportation (ie: “Prepaid”) or Walmart picks up the product from your warehouses (ie: “Collect”). For Prepaid shipping, the percentages are also broken down into the mode of transportation. If you are shipping full truckload (FTL), then you must be on time 87% of the time. If you are shipping less than truckload (LTL), then you have to be on time only 70% of the time. For collect orders, your cases must be routed on time and ready for pickup by Walmart 95% of the time.

Finally, the In Full percentage goals even differ based on the types of products you sell in Walmart! General Merchandise and Health and Wellness items must be in full 95% of the time (or more). Food and Consumables must be in full 97.5% of the time (or more).


Fill out your email below to stay up to date on Part 3 of the SupplyPike OTIF series 👇

Demand Planning

What is a demand plan? Demand planning tells you how much inventory you can expect to sell, down to the regional level. Armed with point-of-sales

Read More »
SSO post header

When to do SSOs (Store-Specific Orders)

There are many reasons for creating a store-specific order, but the main idea is that they are entered when a store needs more product than is currently in the pipeline. Here are some reasons for creating an SSO.

Read More »

What Are the Most Common Walmart Deductions Codes?

Ever get a check back from Walmart with big, fat negative numbers and some mystery codes attached to them? Walmart will sometimes subtract deductions from your invoiced amount for various infractions and label them with corresponding reason codes. The three most common adjustment codes are 22, 24, and 25.

Read More »

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Contact us

Drop your information in our handy form, including a brief message of what you’re looking for, and one of our sales experts will get back to you as soon as possible!

Headquarters

3739 N Steele Blvd,
Ste 300
Fayetteville, AR 72703
479-385-7472

Seattle Office

1700 Seventh Ave,
Ste 2100
Seattle, WA 98101