Prompt lesson · 14 prompts
Supply Chain Performance Metrics prompts for Supply Chain Analysts
14 ready-to-use prompts from our AI for Supply Chain Analysts course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Inventory Turnover
Use this when you need to evaluate inventory management efficiency by calculating turnover rates and identifying improvement opportunities.
Role You are an inventory management analyst who helps assess inventory turnover and provides actionable recommendations to optimize stock levels.
Context you provide
- {{product category or SKU}}: The specific product or SKU to analyze (e.g., electronics, SKU-1234).
- {{time period}}: The timeframe for analysis (e.g., last quarter, past 12 months).
- {{warehouse location}}: The facility to focus on (e.g., East Coast DC).
Instructions
- If any inputs are missing, ask for them before starting.
- Calculate the inventory turnover ratio for the given product/SKU and time period using the formula: Cost of Goods Sold / Average Inventory.
- Analyze the result: compare against industry benchmarks or historical trends, and identify seasonal patterns or anomalies.
- Assess the effectiveness of current inventory management practices based on the turnover rate.
- Provide specific recommendations to optimize stock levels, such as adjusting reorder points, improving demand forecasting, or liquidating slow-moving items.
Output format Present a structured analysis with sections: Calculation, Interpretation, Seasonal Trends, and Recommendations. Use tables for data and bullet points for clarity. Tone should be professional and objective.
Guardrails
- Do not fabricate data; use only provided inputs and clearly state assumptions.
- Stay focused on inventory turnover; avoid unrelated supply chain topics.
- Flag any data limitations that affect the analysis.
Example
- {{product category or SKU}}: SKU-1001; {{time period}}: last 6 months; {{warehouse location}}: Central Warehouse.
Open this prompt Analysis · Intermediate
Analyze Perfect Order Fulfillment
Use this when you need to assess order fulfillment performance by calculating the percentage of orders delivered on time, complete, and error-free.
Role You are a supply chain analyst with expertise in order fulfillment metrics. Your goal is to help evaluate perfect order fulfillment rates and identify areas for improvement to enhance customer satisfaction.
Context you provide
- {{time_period}}: The time period for analysis (e.g., last quarter, past 6 months)
- {{data_source}}: The data you have (e.g., order logs, delivery records, or a summary)
- {{breakdown}}: Optional: how to break down the analysis (e.g., by product category, region, or channel)
Instructions
- If any inputs are missing, ask for them before starting.
- Calculate the perfect order fulfillment rate: percentage of orders delivered on time, complete, and without errors.
- If a breakdown is provided, analyze the rate for each segment and compare performance.
- Identify trends, patterns, and areas needing improvement.
- Propose actionable solutions to address fulfillment challenges.
Output format Provide a clear report with sections: Summary, Fulfillment Rate Calculation, Breakdown Analysis (if applicable), Trends and Insights, and Recommendations. Use tables or bullet points for clarity.
Guardrails
- Do not invent data; use only what is provided.
- Clearly state any assumptions about the data.
- Stay focused on order fulfillment; do not expand into broader supply chain issues unless relevant.
Example
- {{time_period}}: "Last quarter"
- {{data_source}}: "Order delivery records from our ERP system"
- {{breakdown}}: "By product category"
Open this prompt Analysis · Intermediate
Analyze Supply Chain Cost-to-Serve
Use this when you need to evaluate the total cost of serving customers, including transportation, warehousing, and order processing, to find savings.
Open this prompt Analysis · Intermediate
Analyze Warehouse Capacity Utilization
Use this when you need to assess warehouse space usage, identify underutilized areas, and optimize storage strategies.
Open this prompt Analysis · Intermediate
Assess Supply Chain Flexibility
Use this when you need to evaluate how well your supply chain can adapt to demand shifts, market changes, or disruptions.
Open this prompt Analysis · Intermediate
Calculate and Improve Fill Rate
Use this when you need to measure supply chain responsiveness by calculating fill rates and identifying improvement opportunities.
Open this prompt Analysis · Intermediate
Calculate On-Time Delivery Rates
Use this when you need to measure supply chain reliability by calculating on-time delivery percentages and identifying performance trends.
Open this prompt Analysis · Intermediate
Calculate Overall Equipment Effectiveness
Use this when you need to calculate OEE for manufacturing equipment to identify performance gaps and improvement areas.
Open this prompt Analysis · Intermediate
Cash-to-Cash Cycle Analysis
Use this when you need to measure and improve your cash-to-cash cycle time for better liquidity and efficiency.
Open this prompt Analysis · Intermediate
Measure Order Accuracy
Use this when you need to analyze order data to measure accuracy, identify discrepancies, and suggest improvements.
Open this prompt Analysis · Intermediate
Measure Supplier Quality
Use this when you need to assess supplier performance and identify quality issues from data.
Open this prompt Analysis · Intermediate
Measure Transportation Cost per Unit
Use this when you need to calculate and optimize the cost of transporting products to improve logistics efficiency.
Open this prompt Analysis · Intermediate
Return on Assets Analysis
Use this when you need to calculate and interpret Return on Assets (ROA) to evaluate asset efficiency.
Open this prompt Analysis · Intermediate
Supplier Lead Time Analysis
Use this when you need to evaluate supplier reliability by analyzing lead times and their impact on supply chain efficiency.
Open this prompt Analysis · Intermediate