Skip to content
retailer-sla-compliance-monitor logo

Retailer SLA Compliance Monitor

retailer-sla-compliance-monitor

Track and report on SLA adherence across CPG-retailer relationships including fill rates, on-time delivery, labeling compliance, and chargeback metrics. Use when monitoring operational SLAs, preparing compliance reports, analyzing chargeback trends, disputing penalties, or conducting supplier sco...

writer/skills0installs8stars

SKILL.md

Full skill instructions

Retailer SLA Compliance Monitor

Overview

Systematically track, analyze, and report on Service Level Agreement compliance across CPG-retailer relationships. This skill monitors operational KPIs (fill rate, OTIF, labeling, EDI accuracy), identifies compliance trends and root causes, quantifies financial impact of non-compliance (chargebacks and penalties), and produces actionable improvement plans aligned with retailer scorecard frameworks.

When to Use

  • Monthly/​quarterly SLA compliance reporting
  • Retailer supplier scorecard preparation
  • Chargeback dispute analysis and remediation
  • OTIF (On-Time In-Full) performance deep-dives
  • Labeling and packaging compliance audits
  • Pre-line-review compliance status preparation
  • Corrective action plan development after compliance failures
  • Benchmarking SLA performance across retailers

Required Inputs

InputDescriptionFormat
SLA requirementsContractual KPIs and thresholds by retailerSLA terms document
Performance dataActual performance metrics (fill rate, OTIF, etc.)Operational data
Chargeback historyDeduction detail by type, amount, dateChargeback log
Order/​shipment dataPO detail, shipment dates, quantities, ASN accuracyTransaction data
Retailer scorecardsPublished supplier performance reportsScorecard documents
Root cause dataKnown causes of compliance failuresIncident log or notes
Improvement actionsActive corrective actions and their statusAction tracker

Methodology

Step 1: SLA Landscape Mapping

Document all active SLAs across retailer relationships:

Major Retailer SLA Frameworks:

RetailerKey ProgramCritical KPIsPenalty Structure
WalmartOTIF ScorecardOn-Time ≥87%, In-Full ≥95%3% of COGS fine per infraction
TargetVendor ComplianceShip window accuracy, PO fill rate$ per occurrence by violation type
KrogerSupplier PerformanceFill rate ≥98%, ASN accuracy ≥95%Deductions per case short
AmazonVendor Central MetricsPO fill rate, ASN accuracy, prep complianceChargebacks + potential suppression
CostcoSupplier RequirementsOn-time delivery, quality standardsNon-compliance fees + potential delisting

SLA KPI Universe:

Delivery Performance:
├── On-Time Delivery Rate (% of POs delivered within window)
├── In-Full Rate (% of PO units delivered complete)
├── OTIF Combined (On-Time AND In-Full — most stringent)
├── Must Arrive By Date (MABD) compliance
└── Appointment scheduling compliance

Order Accuracy:
├── PO Fill Rate (units shipped / units ordered)
├── ASN (Advance Ship Notice) accuracy and timeliness
├── Invoice accuracy (match to PO and ASN)
├── EDI compliance (transaction set accuracy)
└── Labeling/​barcode accuracy

Quality & Compliance:
├── Product quality incidents (damage, defect rate)
├── Packaging compliance (case pack, pallet configuration)
├── Labeling compliance (GS1, retailer-specific requirements)
├── Recall response time
└── Documentation completeness (COA, SDS as required)

Step 2: Performance Measurement and Trending

Calculate current compliance metrics against each SLA:

OTIF Calculation (Walmart methodology):

On-Time Rate:
  = Orders delivered within the delivery window / Total orders
  Window: Typically ±1 day of requested delivery date
  Threshold: ≥87% (as of current program)

In-Full Rate:
  = Cases delivered complete / Cases ordered
  Threshold: ≥95% (measured at case level)

OTIF Combined:
  = Orders that are BOTH on-time AND in-full / Total orders
  This is multiplicative — must meet BOTH criteria for each order

Trend Analysis:

  • Calculate rolling 4-week and 13-week performance averages
  • Identify trends: improving, stable, or deteriorating
  • Flag any metric that has declined for 3+ consecutive periods
  • Compare against prior year same period (seasonality adjustment)

Performance vs. Threshold Heat Map:

KPIThreshold4-Week Avg13-Week AvgYoY TrendStatus
On-Time≥87%XX.X%XX.X%+/​-Xpp🟢/🟡/🔴
In-Full≥95%XX.X%XX.X%+/​-Xpp🟢/🟡/🔴
ASN Accuracy≥95%XX.X%XX.X%+/​-Xpp🟢/🟡/🔴

Status: 🟢 = ≥threshold; 🟡 = within 2pp of threshold; 🔴 = >2pp below threshold

Step 3: Chargeback Analysis and Financial Impact

Quantify the financial impact of SLA non-compliance:

Chargeback Taxonomy:

CategoryCommon TypesTypical Cost
DeliveryLate/​early shipment, missed appointment$200-$500 per occurrence
QuantityShort ship, over ship, unauthorized substitution% of shorted value
DocumentationMissing/​inaccurate ASN, BOL, packing slip$100-$300 per occurrence
LabelingWrong UPC, missing GS1-128, pallet label errors$100-$500 per occurrence
PackagingWrong case pack, pallet configuration, damage$200-$1,000+ per occurrence
ComplianceOTIF fines (Walmart: 3% of COGS)Variable by program

Financial Summary:

Total Chargebacks (period):         $XXX,XXX
  Delivery-related:                 $XX,XXX  (XX%)
  Quantity-related:                 $XX,XXX  (XX%)
  Documentation-related:            $XX,XXX  (XX%)
  Labeling-related:                 $XX,XXX  (XX%)
  Packaging-related:                $XX,XXX  (XX%)
  Compliance fines:                 $XX,XXX  (XX%)

Chargebacks as % of Net Revenue:    X.X%
  Benchmark: <0.5% is healthy; >1.0% requires immediate action

Successfully disputed:              $XX,XXX  (XX% of total)
Dispute success rate:               XX%
Open disputes:                      $XX,XXX

Step 4: Root Cause Analysis

Apply the Five Whys and Pareto analysis to compliance failures:

Pareto Analysis: Rank failure modes by frequency and financial impact. Focus corrective actions on the top 3-5 root causes that account for 80% of chargebacks.

Root Cause Categories:

CategoryExamplesResolution Owner
Demand planningPoor forecast accuracy → shortsDemand Planning
Supply reliabilitySupplier delays → late shipmentsProcurement
Warehouse operationsPick errors, wrong labels, late dispatchLogistics/​3PL
TransportationCarrier delays, missed appointmentsLogistics
System/​EDIASN errors, PO processing failuresIT/​Operations
QualityProduct defects, packaging failuresQuality Assurance
CapacityInsufficient production to fill ordersManufacturing

Root Cause Deep-Dive Template:

Failure: [Specific failure description]
Impact: $XX,XXX in chargebacks; XX POs affected
Root Cause (5 Whys):
  Why 1: [Surface symptom]
  Why 2: [Contributing factor]
  Why 3: [Process failure]
  Why 4: [System/​structural cause]
  Why 5: [Root cause]
Corrective Action: [Specific fix addressing root cause]
Preventive Action: [System/​process change to prevent recurrence]
Owner: [Name/​function]
Due Date: [Date]
Expected Impact: [Estimated chargeback reduction]

Step 5: Dispute Management

Identify chargebacks eligible for dispute:

Dispute Eligibility Criteria:

Dispute BasisEvidence RequiredSuccess Probability
POD (Proof of Delivery) contradictsSigned BOL, carrier trackingHigh (70-90%)
ASN was sent on time (system proof)EDI transmission log with timestampHigh (70-85%)
Quantity discrepancy (retailer counting error)BOL, packing slip, warehouse scan logsMedium (50-70%)
Duplicate chargebackPrior deduction for same eventHigh (80-95%)
Program interpretation disagreementContract language, program guide citationLow-Medium (30-50%)
Force majeure eventWeather, carrier force majeure declarationLow (20-40%)

Dispute ROI Analysis:

Chargebacks eligible for dispute:     $XX,XXX
Expected success rate:                XX%
Expected recovery:                    $XX,XXX
Cost to dispute (labor + admin):      $X,XXX
Dispute ROI:                          X.Xx
Prioritize disputes with ROI > 3.0x

Step 6: Corrective Action Plan

Develop a structured improvement plan:

Corrective Action Plan (CAP)
Target: Improve [KPI] from [current] to [target] within [timeline]

Initiative 1: [Name]
  Action: [Specific operational change]
  Owner: [Name/​function]
  Timeline: [Start-End]
  Investment: $X
  Expected Impact: +Xpp on [KPI], -$XK in chargebacks
  Milestone 1: [Date — what should be true]
  Milestone 2: [Date — what should be true]

Initiative 2: [Name]
  [Same structure]

Monitoring:
  Weekly: [Leading indicators to track]
  Monthly: [SLA performance review]
  Quarterly: [Retailer scorecard review]

Output Specification

# SLA Compliance Report — [Retailer] [Period]

## Executive Summary
**Overall Compliance Status**: 🟢 Compliant / 🟡 At Risk / 🔴 Non-Compliant
**Financial Impact**: $XK in chargebacks (X.X% of revenue)
**Top Issue**: [Most impactful compliance failure]
**Trend**: Improving / Stable / Deteriorating

## Performance Dashboard

| KPI | Threshold | Current | Prior Period | Trend | Status |
|-----|-----------|---------|-------------|-------|--------|
| OTIF | ≥XX% | XX.X% | XX.X% | ↑/→/↓ | 🟢/🟡/🔴 |
| Fill Rate | ≥XX% | XX.X% | XX.X% | ↑/→/↓ | 🟢/🟡/🔴 |
| ASN Accuracy | ≥XX% | XX.X% | XX.X% | ↑/→/↓ | 🟢/🟡/🔴 |

## Chargeback Summary
| Category | Amount | % of Total | Trend | Top Root Cause |
|----------|--------|-----------|-------|---------------|
| Delivery | $XK | XX% | ↑/→/↓ | [Cause] |
| Quantity | $XK | XX% | ↑/→/↓ | [Cause] |

## Root Cause Analysis
[Pareto chart of top failure modes with 5-Why deep-dive on #1 issue]

## Dispute Status
- Open: $XK across X disputes
- Recovered YTD: $XK (XX% success rate)
- Pending: $XK

## Corrective Action Plan
[Active initiatives with status, owner, timeline, expected impact]

## Cross-Retailer Benchmark
[Performance comparison across retailers to identify systemic vs retailer-specific issues]

Analysis Framework

SLA Compliance Maturity Model:

LevelDescriptionCharacteristics
1 - ReactiveFire-fighting compliance failuresNo trend monitoring, high chargebacks
2 - MeasuredTracking KPIs but not acting proactivelyDashboards exist, but root cause analysis is ad hoc
3 - ManagedRoot cause analysis drives improvementCorrective actions active, chargeback declining
4 - OptimizedPredictive monitoring prevents failuresLeading indicators trigger preemptive action
5 - Best-in-ClassCompliance is a competitive advantageStrategic supplier status, preferred partner programs

Example

Input: "Walmart OTIF last 4 weeks: 82%, 84%, 81%, 83%. Threshold is 87%. Total OTIF fines YTD: $420K. Main issue is late deliveries from our West Coast DC."

Analysis excerpt:

"Status: 🔴 NON-COMPLIANT. Rolling 4-week OTIF average of 82.5% is 450bps below the 87% threshold, generating an estimated $35K/​week in OTIF fines (3% of COGS on non-compliant POs). YTD fines of $420K represent 1.8% of Walmart net revenue — well above the 0.5% healthy benchmark. Root cause: Pareto analysis shows 68% of late deliveries originate from the West Coast DC, with carrier appointment scheduling as the #1 failure mode. Five-Why analysis traces this to a manual appointment booking process that doesn't account for Walmart's 30-minute delivery windows. Corrective Action Plan: (1) Immediate: Pre-book carrier appointments 72 hours in advance (vs current 24 hours), target: +3pp OTIF within 4 weeks. (2) Short-term: Implement automated appointment scheduling integration with Walmart's Luminate platform, target: +5pp within 8 weeks. (3) Medium-term: Evaluate adding a Southwest regional DC to reduce transit distance and variability. Expected full recovery to 87%+ within 12 weeks, preventing ~$180K in additional fines."

Guidelines

  • Always lead with financial impact — compliance metrics alone don't drive urgency
  • Track at the most granular level possible (DC, carrier, SKU) to identify true root causes
  • Benchmark performance across retailers to distinguish systemic vs retailer-specific issues
  • Dispute eligible chargebacks aggressively — recovered deductions improve the bottom line
  • Chargebacks as % of net revenue is the KPI that gets executive attention
  • Corrective actions must have owners, dates, and measurable outcomes
  • SLA requirements change — re-map the landscape annually

Validation Checklist

  • All active SLAs mapped with thresholds by retailer
  • Performance metrics calculated with rolling averages (4-week, 13-week)
  • Heat map shows status vs threshold for every KPI
  • Chargebacks classified by taxonomy and quantified
  • Chargebacks as % of net revenue calculated and benchmarked
  • Root cause analysis applied with Pareto and Five Whys
  • Dispute-eligible chargebacks identified with expected recovery
  • Corrective action plan includes specific initiatives with owners and timelines
  • Cross-retailer benchmark identifies systemic issues
  • Trend analysis covers at least 13 weeks of historical data

More skills from writer

Identifies, quantifies, and forecasts seasonal demand patterns for CPG and retail products to optimize inventory, promotions, and assortment timing. Use when the user wants to understand seasonal trends, build seasonal demand forecasts, plan seasonal inventory, or optimize the timing of product l...

8 0
View

Validate informed consent documentation for completeness, regulatory compliance, and clinical appropriateness by assessing required elements against CMS Conditions of Participation, Joint Commission standards, and state-specific consent laws. Use when auditing consent records, preparing for accre...

8 0
View

Conduct M&A financial due diligence analysis for bank acquisitions including accretion/dilution modeling, fair value marks, cost synergy validation, and pro-forma capital impact. Use when evaluating bank acquisition targets, preparing deal committee materials, analyzing merger economics, or asses...

8 0
View

Interpret and explain fraud detection signals, model outputs, and suspicious patterns across payment, identity, and account fraud typologies. Use when analyzing fraud alerts, explaining model scores, investigating fraud rings, or documenting fraud case findings for consumer and commercial banking.

8 0
View

Analyze policy exceptions for risk patterns, concentration risks, and control gaps in financial institutions. Use when reviewing policy exception requests, analyzing exception trends, assessing exception backlogs, or evaluating whether exceptions indicate systemic control weaknesses under COSO, O...

8 0
View

Explain portfolio drift from target allocations in client-friendly language with actionable rebalancing guidance. Use when preparing client review presentations, explaining allocation changes caused by market movements, justifying rebalancing trades, or helping clients understand why their portfo...

8 0
View

Decompose and explain healthcare cost growth into contributing factors including utilization changes, unit price shifts, case mix evolution, and population changes. Use when analyzing PMPM cost trends, explaining cost variance to leadership, preparing actuarial summaries, or identifying cost redu...

8 0
View

Analyze operational risk events and produce structured loss event narratives, root cause analyses, and OpRisk reports. Use when documenting operational loss events, conducting RCSA analysis, preparing OpRisk committee reports, or supporting Basel III operational risk capital calculations under th...

8 0
View

Predict provider capacity shortages and surpluses using demand modeling, wRVU productivity analysis, panel-size optimization, and workforce pipeline analytics to inform strategic recruitment and scheduling decisions.

8 0
View

Assess internal control testing effectiveness for financial institutions using COSO 2013 framework and SOX 302/404 requirements. Use when evaluating control test results, assessing control design and operating effectiveness, analyzing control deficiencies, or preparing management's assessment of ...

8 0
View

Diagnose supply delays by decomposing lead time into constituent stages, identifying variance sources, quantifying downstream impact on inventory and service levels, and recommending corrective actions.

8 0
View

Attribute AUM growth to its component drivers — market performance, net new assets, client acquisition, attrition, and fee impact. Use when analyzing practice growth, preparing management reporting, evaluating advisor productivity, forecasting AUM trajectory, benchmarking organic growth rates, or...

8 0
View

Popular AI tools

Kaiber logo
Video

Kaiber

Generate, edit, and beat-sync AI video with leading models in one workspace.

Paid
View
Vimcal logo
Productivity

Vimcal

The world's fastest calendar for remote work

Free
View

Transform Your Design with AI Designer by ImgCreator.ai

Freemium
View
Akool AI logo
Content & writing

Akool AI

Revolutionizing Video Production with AI-Powered Creativity

Paid
View

Extend an image past the frame and let AI fill the new aspect ratio.

Freemium
View
StarByFace logo
Security

StarByFace

Discover your celebrity doppelgänger with StarByFace!

Free
View
C

ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.

Freemium
View
Opus Clip logo
Coding & apps

Opus Clip

Opus.ai: Revolutionize Your Web Experience

Free
View