Supply Chain Supervisor

Managing inventory and logistics across multiple suppliers often feels like firefighting without a map. This skill provides a structured framework to audit supply chain data, identify critical shortages, and build an evidence-backed action plan for procurement and operations teams.

What it does

• Inventory auditing identifies stockout risks, excess inventory, and aging stock by comparing on-hand levels against demand and safety stock.
• Exception prioritization categorizes supply risks from P1 (Critical) to P4 (Monitor) based on the severity of production or customer impact.
• Metric calculation derives days of cover, inventory position, and projected shortages using user-provided demand and lead time data.
• Supplier risk tracking flags overdue purchase orders and identifies at-risk shipments based on logistics and carrier data.
• Action registration generates a prioritized task list including owner roles, triggers, and closure criteria for every identified exception.

How it works

1. Define the picture by summarizing the planning horizon, locations, and data timestamp to ensure the analysis context is correct.
2. Input data including SKU lists, stock levels, open purchase orders, and demand forecasts.
3. Execute analysis to calculate coverage and detect exceptions across inventory, procurement, and logistics.
4. Review the Brief which provides a structured report with an executive status, priority tables, and specific owner-based actions.

Frameworks & tools

This skill is designed for supply chain professionals using CSV/Excel exports from ERP or WMS systems, planning tools, or manual inventory logs. It utilizes standard supply chain math including Days of Cover and Inventory Position formulas.

Why this beats prompting it yourself

Generic prompts often hallucinate stock levels or fail to distinguish between confirmed orders and forecasts. This skill enforces strict data validation and uses a standardized priority matrix to ensure recommendations are based on evidence rather than statistical guesswork.

Use cases

• Auditing weekly inventory reports to flag imminent stockouts before production stops.
• Reviewing supplier performance to identify which overdue POs require immediate escalation.
• Comparing demand forecasts against safety stock to identify excess capital tied up in slow-moving SKUs.
• Building contingency plans for logistics disruptions by comparing baseline and downside scenarios.

Known limitations

This skill does not connect directly to live ERP APIs or place orders automatically. It relies entirely on the accuracy and freshness of the data provided in the chat context.