inventory-management
Analyze stock levels, calculate reorder points, classify SKUs, map warehouse layouts, and reconcile physical counts. Operates in two modes: standalone (CSV/JSON data dumps) or connected (live ERP via `mcp-server-odoo` or `erpnext-mcp`).
Inputs
- stock_data — Stock snapshot data (CSV/JSON dump or MCP query result). Schema must include standard_price (unit cost) for value calculations; expiration_date is optional for expiry-based flags.
- demand_history — Demand history for turnover/days-of-stock calculation. Schema: product_id, default_code, period_start, period_end, qty_consumed. If absent, turnover ratio and days-of-stock are reported as 'N/A — demand data required'.
- client_id — Client identifier for output routing
- demand_history — Historical demand data (min 3 months recommended)
- lead_times — Supplier lead times per SKU (defaults to 7 days if absent)
- service_level — Target service level 0-1 (default 0.95)
- sku_data — SKU-level sales/consumption data with value and volume
- location_data — Warehouse locations with zone, aisle, rack, bin identifiers
- stock_data — Current stock by location (for heatmap overlay)
- physical_count — Physical count results (SKU, location, counted qty)
- system_stock — System stock snapshot at time of count
How you ask
- Run an inventory health check for Acme Corp using their latest stock export
- Calculate reorder points and safety stock for all SKUs at 95% service level
- Classify our client's SKUs using ABC/XYZ analysis on their annual sales data
- Map the warehouse layout for Bobbolt's main distribution center
- We just finished a physical count — reconcile it against the system stock
Outputs
- Prioritized SKU matrix with class assignments and action flags
- Reorder point and safety stock recommendations per SKU
- Stock health report with KPIs, flags, and recommendations
- Variance report with discrepancy flags and root-cause suggestions
- Visual warehouse layout with zones and stock distribution
Levelbeginner
Inputconversation
Outputdocument
Setup[none]
Roles[Operations Manager]