Your Fill Rate Says 99%. One in Six Walmart Shipments Still Misses.

A brand can ship 99% of its units and still have one Walmart shipment in six arrive late or incomplete. Cinderhaven Provisions reads an internal fill rate of 99.2% while its receiving data shows 84.5% of its Walmart shipments arriving on time and complete. Neither number is wrong. The 14.8-point gap between them (computed on unrounded rates: 99.24 vs. 84.46) runs about $57,000 a year on a $25M brand's Walmart volume.

Cinderhaven is invented: a fictional $25M specialty food company whose shipment data is a synthetic dataset. I built its ledger so the chargebacks are computed from shipment and receiving events rather than reverse-engineered to a target, which is what lets the gap be taken apart point by point.

Two honest numbers, measuring different things

Fill rate and OTIF sound like the same idea and are not. Internal fill rate is unit-weighted and forgiving: a shipment missing one case in a hundred still reads 99%. Walmart's On-Time In-Full program fines by the case, so even the retailer's scorecard can look acceptable while individual shipments keep arriving short. A short shipment is still short. The missing cases come back as chargebacks and receiving discrepancies, and the empty shelf slot costs sales until the next order lands.

The person who sees both numbers is whoever owns the monthly fill-rate report pulled from the warehouse system, reading it beside Walmart's OTIF scorecard. One says 99. The other says the largest customer is deducting for cases that never arrived. Each report answers its own question correctly. Neither counts how many shipments arrived incomplete, which is the question the receiving dock is answering.

Nearly thirteen of the 14.8 points are in-full failures

Decompose Cinderhaven's 14.8-point gap and it separates cleanly. On-time is fine: trucks arrive in their windows, and timing accounts for barely two points of the shortfall. Nearly 13 of the 14.8 points are in-full failures.

Short-shipping drives 72% of the gap. A receiving discrepancy, where the retailer's dock scan disagrees with what the brand's records say shipped, adds another 14%, and it is pure data: the units may have arrived, but the numbers describing them did not agree, so the line scores short. Internal fill rate sees neither failure, because a line missing one case in a hundred is a success by its arithmetic. The missing case still arrives as a deduction. Appointment scheduling, carrier selection, and routing compliance all work on the two points of timing.

$23,697 is invoiced; about $33,500 is the shelf

The exposure has two parts, and only one is a hard number. The measured cost is $23,697 a year: compliance fines deducted from remittances for short shipments, late deliveries, and receiving discrepancies. Those dollars are already gone.

The second part is modeled. An empty shelf slot costs sales while the next order is in transit, which costs velocity. Estimated at $3.50 per unit of retailer shortfall, that damage runs about $33,500 a year. It is an assumption, not a figure from the platform, and it reads as a modeled estimate rather than a line on a statement. Together the two come to roughly $57,197 a year, of which $23,697 is invoiced and the rest is the shelf paying for cases that never arrived.

The modeled part is the larger one, and it never appears on a remittance. It arrives instead as velocity and delisting pressure after a bad scorecard, usually raised by the buyer at the line review.

OTIF penalties start as a measurement problem

After a bad OTIF score the instinct is to fix logistics: better carriers, tighter appointments, a routing-guide audit. In Cinderhaven's numbers that effort lands on the two points that already work. The 14.8-point gap is a short-ship and data problem, and the first step is reconciling the fill rate the brand watches against what the retailer's dock received, line by line, so the failures the internal report rounds away are visible before the chargebacks post. The same pattern sits under most OTIF fines at specialty brands, which trace to data rather than trucks. The gap calculator turns "Walmart says we're failing" into a ranked list of what failed.

Run monthly, that reconciliation is process hygiene, pointed at the nearly thirteen points the internal report cannot see. Check the short-ship lines first: in Cinderhaven's data they are 10.66 of the 14.8 points.

Send me your fill-rate report and one OTIF scorecard

Send me your internal fill-rate report and one retailer OTIF scorecard for the same period. I will show you the gap between them, split it into short-ship, timing, and receiving-discrepancy points, and put a dollar figure on each, so you can see which failures cost you fines and which cost you shelf. You'll get it back in writing.