Operations

“Where do delivery and returns cost us money?”

Find where delivery and returns cost money.

Supplier OTIF, lead-time and return-reason analysis can be scoped from purchasing, receipt and returns records. One customer result: orders from three webshops routed automatically to five stores and two supplier warehouses.

Talk to us

The problem

  • Returns processing costs are invisible to sales.
  • Delivery unreliability damages customer trust.
  • Inventory gets tied up in the returns flow.

Who this is for

  • Supply Chain Director
  • COO

Questions you can answer

  • What is our supplier OTIF?
  • What is the not-as-described return share?
  • How accurate is our lead-time?

Answers

What is our supplier OTIF?

built per customer
Sources needed
  • ERP orders
  • WMS receipts
Calculation
On-time and in-full deliveries ÷ Total deliveries
What you see
Supplier performance dashboard

What is the not-as-described return share?

built per customer
Sources needed
  • WMS returns
  • Ticketing
Calculation
Returns flagged not-as-described ÷ Total returns
What you see
Return reason analysis

How accurate is our lead-time?

built per customer
Sources needed
  • ERP orders
  • WMS receipts
Calculation
Actual lead time vs Planned lead time
What you see
Lead-time accuracy dashboard

How do we map returns processing back to products?

built per customer
Sources needed
  • WMS
  • Carrier tracking
Calculation
Return logistics matching
What you see
Product returns flow

How Dataloader solves it

  1. Connect logistics WMS, carrier and returns data are connected as part of the project.
  2. Track returns We map returns processing back to products.
  3. Monitor suppliers OTIF and lead-time accuracy can be built per customer from purchase-order and receipt data.

Logistics and Returns

What you see

Supply chain reliability metrics.

Illustrative
  • vs Target
Supply chain reliability metrics. Illustrative example. Figures are not customer data.
Supplier/CarrierOTIFReturn RateCost
Supplier A
Carrier B
Illustrative | WMS updated 07:00 Illustrative example. Figures are not customer data.

KPI definitions

Supplier OTIF

Formula
On-time in-full deliveries ÷ Total deliveries
Inputs
  • ERP orders
  • WMS receipts
Missing data
Requires ERP orders and WMS receipts.

Lead-time accuracy

Formula
Actual lead time vs Planned lead time
Inputs
  • ERP orders
  • WMS receipts
  • Supplier data
Missing data
Requires ERP orders, WMS receipts and supplier data.

Return rate

Formula
Returned items ÷ Sold items
Inputs
  • WMS returns
  • ERP sales
Missing data
Requires WMS returns and ERP sales data.

Not-as-described return share

Formula
Returns flagged not-as-described ÷ Total returns
Inputs
  • WMS returns
  • Customer service tickets
Missing data
Requires WMS returns and customer service tickets.

Business case

Returns cost reduction

  • Total return volume
  • Processing cost per return
  • Calculation: Savings = Avoided returns × Processing cost.

Industries where this matters

Frequently asked questions

Do you connect to carrier APIs?

Carrier data is connected as part of the project where an API or export is available; WMS and returns data are needed for the full flow.

Find where delivery and returns cost money.