MRP/ERP Inventory Optimization Advisor
Optimize inventory levels and reduce carrying costs with AI-powered MRP/ERP analysis
What You Can Do
You analyze your historical sales data, demand patterns, and inventory metrics to identify optimal stock levels, reorder points, and safety stock quantities. The skill integrates with your ERP system's data to reduce excess inventory, prevent stockouts, and provide cost-benefit analysis for inventory decisions. You get actionable recommendations on ABC analysis, seasonal adjustments, and inventory turnover optimization.
Features
Analyze historical sales trends and seasonal patterns to predict future demand with quantified confidence intervals
Compute optimal safety stock levels based on demand variability, lead time uncertainty, and your target service level
Determine ideal reorder quantities and points that balance carrying costs against shortage risks
Classify inventory by value contribution to prioritize management effort on high-impact items
Break down holding costs, ordering costs, and shortage costs to identify savings opportunities
Works with data exports from SAP, Oracle, NetSuite, Dynamics 365, and other major ERP systems
Identify items at risk of stockouts based on lead time, variability, and current inventory positions
Automatically detect and quantify seasonal demand patterns to adjust inventory planning accordingly
Example Output
Demand Forecast with Confidence Intervals
Item: SKU-4521 (Industrial Bearings)
- Current monthly avg: 145 units
- Forecast (next 6 months): 168, 172, 201, 215, 198, 156 units
- 95% confidence interval: ±28 units
- Seasonal index (Q4): 1.38x baseline
Reorder Point Recommendation
Reorder Point: 320 units
- Lead time: 14 days average (±3 days)
- Daily demand: 6.8 units average (±1.2 units)
- Safety stock (95% SL): 45 units
- Economic Order Qty: 480 units
- Estimated annual carrying cost: $3,240
ABC Classification Results
Class A (80% of value, 18% of items): 24 SKUs
- Recommend: Weekly reviews, tight safety stock (80% SL)
Class B (15% of value, 32% of items): 112 SKUs
- Recommend: Bi-weekly reviews, standard safety stock (90% SL)
Class C (5% of value, 50% of items): 156 SKUs
- Recommend: Monthly reviews, lower safety stock (70% SL)
What's Included
- Demand Forecasting Templates: Pre-built calculation models for trend analysis, seasonality adjustment, and forecasting accuracy metrics
- Inventory Optimization Calculations: Ready-to-use formulas for safety stock, reorder points, economic order quantities, and cost-benefit analysis
- ERP Integration Guidelines: Step-by-step instructions for exporting data from SAP, Oracle, NetSuite, and other ERP systems for analysis
- ABC Analysis Worksheets: Structured framework to classify inventory by value and establish differentiated management policies
- Cost Analysis Framework: Detailed breakdowns of carrying costs, ordering costs, and shortage costs with sensitivity analysis
- Performance Dashboard Template: KPI tracking spreadsheet with inventory turnover, fill rates, carrying cost trends, and improvement metrics
Who It's For
- Supply Chain Managers
- Inventory Planners and Analysts
- Operations Managers
- Procurement Specialists
- ERP Business Analysts
Best For
- Optimizing inventory levels to reduce working capital
- Demand forecasting and production planning
- Cost reduction initiatives in supply chain
- Improving inventory turnover and fill rates
- ERP data analysis and system optimization
You might also like
You can map your entire supply chain network, identify bottlenecks and inefficiencies, and model optimization scenarios. This skill helps you visualize supplier relationships, distribution channels, and logistics flows to find cost savings and reduce delivery times. You'll get actionable recommendations backed by network analysis and scenario modeling.
You can analyze historical demand patterns, generate statistical forecasts with explicit assumptions, and create best/base/worst-case scenarios for supply chain planning. The skill evaluates demand seasonality, trends, and volatility to produce actionable forecasts with confidence intervals. Your results include documented methodology, key assumptions, and specific recommendations for inventory and production planning.
You'll create comprehensive, data-driven vendor negotiation briefs that synthesize vendor background, pricing history, market position, and negotiation leverage into a concise, actionable brief. The skill analyzes your vendor context and generates talking points, risk assessments, and strategic recommendations tailored to your negotiation objectives.
Analyze supplier capabilities and proposals using structured evaluation frameworks that score vendors across cost, quality, delivery, and risk dimensions. Claude builds comprehensive negotiation strategies with quantified leverage points, walkaway prices, and contract optimization recommendations. You'll reduce material costs by 10-20% while minimizing supply chain risks through data-driven decision-making.
This skill quickly analyzes inventory discrepancies from cycle counts, pinpoints the likely root causes, and recommends specific corrective actions to improve accuracy. You can upload count data, review detailed variance breakdowns by location or SKU, and get actionable insights to close gaps in your inventory management.
This skill analyzes complex supply chain networks to identify optimization opportunities across cost, service levels, and environmental impact. You can model network changes, evaluate supplier alternatives, and forecast the impact of disruptions before implementation. It provides data-driven recommendations for network redesign, inventory rebalancing, carrier selection, and sustainability improvements.
This skill transforms how you review and negotiate contracts by automatically identifying risks, spotting unfavorable clauses, and generating data-backed negotiation strategies. You get detailed risk scoring, compliance checks, and financial impact analysis—turning hours of manual review into minutes of actionable insights. It helps you close contracts faster while protecting your organization from costly mistakes.
You can analyze shipping expenses across multiple carriers, identify cost-saving opportunities, and evaluate carrier performance metrics to reduce logistics expenses. The skill compares rates, delivery times, reliability scores, and service quality to help you negotiate better contracts and make data-driven carrier selection decisions.