SUPPLY CHAIN ANALYTICS

AtliQ Supply Chain Analysis

Analysed delivery service levels including On-Time, In-Full and OTIF to help identify supply chain service issues.

ExcelTableauOTIFSupply Chain

Project overview

This Codebasics resume project challenge explored supply chain service levels after key customers did not renew annual contracts. The analysis focused on delivery performance so the team could identify where service issues might need attention.

Key supply chain metrics

LIFR %
Line Fill Rate: order lines shipped in full quantity divided by total order lines.
VOFR %
Volume Fill Rate: total quantity shipped divided by total quantity ordered.
OT %
On-Time Delivery: orders delivered on time divided by total orders.
IF %
In-Full Delivery: orders delivered in full quantity divided by total orders.
OTIF %
On-Time In-Full: orders delivered both on time and in full divided by total orders.

Project screenshots

Open interactive Tableau dashboard ↗