Pixels and Clicks · OTIF Deduction Root–Cause Report SAMPLE — ILLUSTRATIVE DATA

SAMPLE — ILLUSTRATIVE DATA

PIXELS AND CLICKS

OTIF Deduction Root–Cause Report

A fixed-scope trace of 90 days of Walmart scorecard and remittance data to root cause — carrier, ASN/EDI, or demand planning — with a recoverable-margin estimate and a two-page mitigation checklist.

Prepared For

A $40M Snacks Brand [illustrative]

Engagement ID

PC-OTIF-0417

Retailer

Walmart · Retail Link

Date

July 2026

Scope

90-day scorecard & remittance trace, read-only data access

Scan Fee

$2,500

01 — The Verdict

Everything a CFO forwards

Estimated Annual Exposure

$146,800

Disputable (file now)$38,400 · 26%

Preventable (fix root cause)$108,400 · 74%

Top root causeASN/EDI transmission lag (58% of preventable total)

Scan fee $2,500 · Identified $146,800 · Multiple 58.7x — guarantee cleared

The gap between this brand's 88.4% OTIF and Walmart's 98% threshold traces to three causes. The largest, ASN/EDI transmission lag, is a fixable systems issue — not a forecasting or carrier problem, as scorecard reviews had assumed.

02 — Exposure Detail

90-day deduction ledger by code family

Code	Description	Occ.	$ Total	Disputable	Root Cause
OTIF-04	Late shipment window miss	61	$62,100	✗	ASN/EDI lag
OTIF-11	Carrier appointment miss	22	$24,900	✓	Carrier pickup timing
OTIF-07	Short-ship vs. PO qty	18	$19,600	✗	Demand planning
OTIF-02	ASN not transmitted <24hr	34	$28,300	✓	ASN/EDI lag
OTIF-19	Case-pack mismatch	9	$11,900	✓	Warehouse

03 — Root-Cause Taxonomy

ASN/EDI transmission lag — the largest single cause

Ship-confirmWMS marks order shipped
T+0h

ERP batch jobNightly batch, not real-time
T+0–18h

ASN transmittedEDI 856 sent to Retail Link
T+18h

Retailer windowWalmart requires <4h post-ship
Missed

The ERP's nightly batch job is the break point: ASNs queue for up to 18 hours before transmission, well past Walmart's 4-hour requirement. This is a scheduling-job fix, not a staffing or carrier issue.

04 — Disputable vs. Preventable

What to file, what to fix

File These Disputes	$	Deadline
OTIF-11 · Carrier appointment miss	$24,900	30 days
OTIF-02 · ASN <24hr (partial)	$13,500	30 days
OTIF-19 · Case-pack mismatch	$11,900	45 days

Prevent These	Fix Owner	Effort
ERP ASN batch job → real-time trigger	IT / ERP Admin	M
Demand-plan buffer on top 20 SKUs	Demand Planning	S
Carrier pickup SLA renegotiation	Logistics	L

05 — Mitigation Checklist

The two-page checklist your team can act on

Move ERP ASN batch job from nightly to hourly (or event-triggered)Owner: IT / ERP Admin · System: ERP · Impact: closes ~58% of preventable exposure
File disputes on all OTIF-11 and OTIF-19 codes from the last 30–45 daysOwner: Deductions Analyst · System: Retail Link · Impact: $36,800 recoverable
Add 3-day safety buffer to top 20 SKU forecasts feeding Walmart DCsOwner: Demand Planning · System: Forecasting tool · Impact: closes remaining short-ship risk
Renegotiate carrier pickup SLA to a fixed 2-hour windowOwner: Logistics · System: TMS · Impact: reduces appointment misses ~70%
Re-run this scan in 90 days to confirm the ASN fix closed the gapOwner: Founder walkthrough call · Impact: validates fix, informs next scorecard cycle

06 — What We'd Do Next

If you want us to build the fix

100% of this $2,500 scan fee credits toward an implementation engagement within 60 days. The ERP batch-job fix above is a 1–2 week build inside your existing stack — no new platform required.

Retailer program terms verified as of July 2026 against published Walmart OTIF compliance documentation.

[ founder photo ]

Bhaskar Sarma

Founder, Pixels and Clicks · linkedin.com/company/pixels-and-clicks

Thanks for reading this far — that's rarer than you'd think. Happy to walk through any of this on a call before you decide anything.

▶ 6-min video walkthrough of this report → [short link + QR — HUMAN to add]