Retailer Sla Compliance Monitor

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

Methodology

Step 1: SLA Landscape Mapping

Document all active SLAs across retailer relationships:

Major Retailer SLA Frameworks:

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:

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:

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:

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 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:

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