kpi-dash
Generate weekly KPI report (3PL/WMS) from shipments/events
When & Why to Use This Skill
This Claude skill automates the generation of comprehensive weekly KPI reports for 3PL (Third-Party Logistics) and WMS (Warehouse Management Systems). By analyzing shipment and event data from CSV files, it provides critical logistics insights including OTIF (On-Time In-Full) percentages, average dwell times, and demurrage/detention (DEM/DET) risk flags to streamline supply chain decision-making.
Use Cases
- Logistics Performance Monitoring: Automatically track and evaluate 3PL provider performance using standardized shipment and event logs.
- Supply Chain Risk Management: Proactively identify Demurrage and Detention (DEM/DET) risks to avoid costly penalties and improve container turnaround.
- Operational Efficiency Analysis: Calculate average dwell days and OTIF metrics to identify bottlenecks in warehouse workflows and transportation schedules.
- Automated Weekly Reporting: Replace manual spreadsheet consolidation with a script-driven workflow that generates markdown-ready KPI dashboards.
| name | kpi-dash |
|---|---|
| description | Generate weekly KPI report (3PL/WMS) from shipments/events |
Instructions:
- Run: powershell -ExecutionPolicy Bypass -File .codex/skills/kpi-dash/scripts/run.ps1
- Input: data/shipments.csv, data/events.csv
- Output: reports/weekly_kpi.md Fail-safe:
- If inputs/columns missing, output only the '以묐떒' table in reports/weekly_kpi.md and exit. Evidence Required:
- Unique shipments, OTIF%(proxy if needed), Avg dwell days, DEM/DET risk flags