Supply Chain Strategist

Build a data-driven supply chain analysis and optimization system via OpenClaw Ultra. From inventory management to demand forecasting to supplier evaluation to risk monitoring, manage your entire supply chain operations from a single chat interface.

Core System Overview

INFO

This is a closed-loop supply chain management workflow. OpenClaw Ultra analyzes your inventory data, forecasts demand, optimizes stock levels, evaluates suppliers, monitors risks, and generates actionable reports — so you can make data-driven supply chain decisions.

System Layer	Core Function	Final Output
Data Collection Layer	Import ERP/Excel/CSV data, clean and normalize	Structured supply chain dataset
Demand Forecasting Layer	Historical trend analysis, seasonality detection, prediction modeling	Demand forecast by SKU and period
Inventory Optimization Layer	ABC classification, safety stock calculation, reorder point setting	Optimized inventory parameters
Supplier Evaluation Layer	Performance scoring, lead time analysis, quality tracking	Supplier scorecards and rankings
Risk Monitoring Layer	Stockout alerts, lead time variance, supply disruption detection	Risk alerts and mitigation plans
Reporting Layer	Dashboard generation, KPI tracking, executive summaries	Weekly/monthly supply chain reports

Prerequisites

Item	Requirement
OpenClaw Ultra	Installed and running
Inventory Data	CSV/Excel export with SKU, quantity, location, dates
Sales Data (Recommended)	Historical sales records for demand forecasting
Supplier Data (Optional)	Supplier list with lead times, pricing, performance history
Business Parameters	Target service level, acceptable stockout risk, budget constraints

Step 0 — Initialize Your Supply Chain System

Set up OpenClaw Ultra as your dedicated supply chain analyst.

Operation Steps

1. Open OpenClaw Ultra new chat session
2. Prepare your data files (CSV/Excel)
3. Paste the initialization prompt

Ready-to-Use Prompt

Act as my supply chain strategist and analyst.

My business:
- Industry: [retail / manufacturing / e-commerce / wholesale]
- Product type: [perishable / non-perishable / seasonal / standard]
- SKU count: [approximate number]
- Locations: [warehouses, stores, regions]

My goals:
- Reduce stockouts to under [X]%
- Optimize inventory holding costs
- Improve supplier reliability
- Build supply chain resilience

Data I can provide:
- Inventory snapshots (CSV/Excel)
- Sales history (CSV/Excel)
- Supplier information (if available)

Build a complete supply chain management system covering:
- data import and analysis
- demand forecasting
- inventory optimization
- supplier evaluation
- risk monitoring
- automated reporting

Step 1 — Import & Analyze Supply Chain Data

Load your data and establish baseline metrics.

1.1 Data Import

Prompt

Import and analyze my supply chain data:

Inventory file: [paste data or upload CSV]
Columns: SKU, Product Name, Quantity, Location, Last Updated

Sales history: [paste data or upload CSV]
Columns: Date, SKU, Quantity Sold, Revenue

Tasks:
1. Clean the data (remove duplicates, fix formatting)
2. Validate data quality (missing fields, outliers)
3. Generate summary statistics
4. Identify data gaps that need attention

1.2 Baseline Metrics

Prompt

Calculate baseline supply chain metrics from my data:

Inventory metrics:
- Total SKUs: [X]
- Total inventory value: [X]
- Average days of supply: [X]
- SKUs below minimum stock: [list]
- Overstocked SKUs: [list]

Sales metrics:
- Total revenue (last 12 months): [X]
- Top 10 SKUs by revenue
- Bottom 10 SKUs by revenue
- Seasonal patterns detected

Output: baseline dashboard with key findings.

Step 1 Output

Clean dataset with baseline metrics and initial insights.

Step 2 — Demand Forecasting

Predict future demand to inform inventory decisions.

2.1 Historical Trend Analysis

Prompt

Analyze demand patterns in my sales data:

For each top SKU (top 20 by revenue):
- Monthly sales trend (last 12 months)
- Seasonality detection (peak months, low months)
- Growth rate (month-over-month, year-over-year)
- Demand variability (coefficient of variation)

Identify:
- SKUs with stable demand (predictable)
- SKUs with volatile demand (need safety stock)
- SKUs with declining trend (potential discontinuation)
- SKUs with growth trend (need stock increase)

2.2 Demand Forecast Generation

Prompt

Generate demand forecasts for the next [3/6/12] months:

For each SKU, forecast:
- Expected monthly demand
- Confidence interval (low / expected / high)
- Recommended order quantity
- Forecast method used (moving average, seasonal, trend)

Output format:
| SKU | Product | Month 1 | Month 2 | Month 3 | Method | Confidence |

Prioritize accuracy for top revenue SKUs.

Step 2 Output

SKU-level demand forecasts with confidence intervals.

Step 3 — Optimize Inventory Parameters

Set optimal stock levels based on demand and service targets.

3.1 ABC Classification

Prompt

Perform ABC classification on my inventory:

Classification criteria:
- A items: Top 80% of revenue (tight control, frequent review)
- B items: Next 15% of revenue (moderate control)
- C items: Bottom 5% of revenue (minimal control)

For each class, output:
- SKU count and percentage
- Total inventory value and percentage
- Recommended review frequency
- Recommended service level target

Output: ABC classification table with action recommendations.

3.2 Safety Stock Calculation

Prompt

Calculate safety stock levels for my SKUs:

Parameters:
- Target service level: [95% / 98% / 99%]
- Lead time: [X days average, Y days standard deviation]
- Demand variability: [from historical data]

For each SKU, calculate:
- Average daily demand
- Demand standard deviation
- Lead time variability
- Safety stock quantity
- Reorder point (safety stock + lead time demand)

Output: safety stock table with reorder points.

3.3 Reorder Policy Recommendations

Prompt

Recommend reorder policies for each inventory class:

A items:
- Review cycle: [continuous / weekly]
- Order policy: [EOQ / fixed interval / min-max]
- Target days of supply: [X days]

B items:
- Review cycle: [bi-weekly / monthly]
- Order policy: [suggested]
- Target days of supply: [X days]

C items:
- Review cycle: [monthly / quarterly]
- Order policy: [suggested]
- Target days of supply: [X days]

Generate a reorder policy matrix with specific parameters.

Step 3 Output

Optimized inventory parameters with ABC classification, safety stock, and reorder points.

Step 4 — Evaluate Suppliers

Score and rank suppliers based on performance data.

4.1 Supplier Scorecard

Prompt

Create supplier scorecards based on my data:

Supplier data: [paste or upload]

Evaluation criteria:
- On-time delivery rate (%)
- Quality acceptance rate (%)
- Lead time consistency (days, variance)
- Price competitiveness (vs. market)
- Communication responsiveness

For each supplier, calculate:
- Overall score (weighted average)
- Rank among all suppliers
- Strengths and weaknesses
- Recommended action (maintain / develop / phase out)

Output: supplier ranking table with scores and recommendations.

4.2 Supplier Risk Assessment

Prompt

Assess supply risk for each supplier:

Risk factors:
- Single-source dependency (are there alternatives?)
- Geographic risk (political, natural disaster, logistics)
- Financial stability indicators
- Lead time reliability
- Quality consistency

For each supplier:
- Risk level: Low / Medium / High
- Key risk factors
- Mitigation recommendations
- Alternative supplier suggestions (if high risk)

Output: supplier risk matrix with mitigation plans.

Step 4 Output

Supplier scorecards with rankings and risk assessments.

Step 5 — Monitor Risks & Alerts

Set up proactive monitoring for supply chain disruptions.

5.1 Stockout Risk Monitoring

Prompt

Set up stockout risk monitoring:

For each SKU, monitor:
- Current stock vs. safety stock level
- Days until stockout (based on current demand)
- Incoming orders (if available)
- Risk level: Safe / Watch / Critical / Stockout

Alert rules:
- Watch: stock below 1.5x safety stock
- Critical: stock below safety stock
- Stockout: zero inventory

Generate current risk report and set up recurring monitoring.

5.2 Supply Disruption Detection

Prompt

Configure supply disruption detection:

Monitor for:
- Lead times exceeding historical average by [X]%
- Supplier delivery delays beyond [X] days
- Quality rejection rates above [X]%
- Price increases above [X]%
- Single-source SKU alerts

When disruption detected:
- Alert level: [Low / Medium / High / Critical]
- Recommended response: [monitor / expedite / switch supplier / safety stock draw]
- Escalation path: [notify / recommend action / auto-respond]

Output: current disruption status and monitoring configuration.

Step 5 Output

Risk monitoring system with alert thresholds and response protocols.

Step 6 — Generate Supply Chain Reports

Create actionable reports for decision-making.

6.1 Weekly Operations Report

Prompt

Generate my weekly supply chain operations report:

Include:
- Inventory health summary (total value, turnover, stockout count)
- Top 10 SKUs needing attention (low stock, overstock, slow movers)
- Supplier performance this week (deliveries, delays, quality)
- Risk alerts triggered and resolved
- Demand forecast accuracy (predicted vs. actual)
- Recommended actions for next week

Format: executive summary + detailed tables.

6.2 Monthly Strategic Report

Prompt

Generate my monthly supply chain strategic report:

Include:
- KPI dashboard (inventory turnover, fill rate, stockout rate, carrying cost)
- ABC classification changes (items moving between classes)
- Supplier ranking updates
- Demand forecast accuracy trends
- Cost optimization opportunities identified
- Strategic recommendations for next month

Format: dashboard visualization description + narrative analysis.

Step 6 Output

Regular supply chain reports with actionable insights.

Final Closed-Loop Supply Chain Workflow

Data Imported → Baseline Established → Demand Forecasted →
Inventory Optimized → Suppliers Evaluated → Risks Monitored →
Reports Generated → Decisions Made → Data Updated → Next Cycle

Practical Usage Tips

1. Start with your top 20 SKUs by revenue — optimize the vital few before the trivial many
2. Update inventory data weekly at minimum — stale data leads to poor decisions
3. Safety stock is insurance — don't cut it to save holding costs, stockouts cost more
4. Review supplier scorecards quarterly, not just when problems occur
5. Use ABC classification to allocate your management attention, not just inventory budget
6. Track forecast accuracy over time — improve your models based on what you learn
7. Build relationships with backup suppliers before you need them