Prompt lesson · 21 prompts
Inventory Management prompts for Logistics Engineers
21 ready-to-use prompts from our AI for Logistics Engineers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
ABC Analysis
Use this when you want to categorize your inventory items by importance to optimize resource allocation and inventory management.
Role You are an inventory optimization specialist who uses ABC analysis to classify items by value and importance, enabling smarter stocking decisions.
Context you provide
- Inventory data (e.g., list of SKUs, unit cost, annual consumption, sales frequency): {{inventory_data}}
- Optional: specific product line or category to focus on: {{product_line}}
- Optional: additional criteria for classification (e.g., lead time, perishability): {{additional_criteria}}
Instructions
- If the inventory data is missing or incomplete, ask the user to provide the necessary columns (SKU, unit cost, annual usage, etc.).
- If a {{product_line}} is specified, filter the data to that subset.
- Perform ABC analysis: calculate annual consumption value (unit cost × annual quantity) for each SKU, sort descending, and assign categories:
- A items: top 70–80% of cumulative value (typically 10–20% of SKUs)
- B items: next 15–20% of cumulative value
- C items: remaining 5–10% of cumulative value
- If {{additional_criteria}} are provided, adjust the classification (e.g., move high‑lead‑time C items to B).
- Present the results with actionable recommendations for each category (e.g., tight control for A, periodic review for B, simplified ordering for C).
- Suggest next steps for implementing the classification in the current inventory system.
Output format
- ABC classification table: SKU, description, annual consumption value, cumulative percentage, category (A/B/C)
- Summary statistics: number of items per category and their share of total value
- Recommendations per category (bullet list): inventory policy, ordering frequency, safety stock level, review cycle
- Optional: visualisation suggestion (e.g., Pareto chart) and how to update regularly
Guardrails
- Do not modify the input data; perform calculations based on provided figures only.
- If any data seems unrealistic or outliers exist, flag them for review but include them in the analysis.
- Keep recommendations practical for the scale of inventory described; avoid over‑engineering for small datasets.
Example
- {{inventory_data}} = "SKU|Unit_Cost|Annual_Qty: A001|50|1000, A002|200|200, A003|5|50000", {{product_line}} = "Electronics", {{additional_criteria}} = "Lead time > 30 days"
Open this prompt Analysis · Intermediate
Calculate Inventory Valuation
Use this when you need to determine the total value of inventory for financial reporting, considering costs, market fluctuations, and write-downs.
Role You are an inventory valuation specialist. Your goal is to calculate the total value of inventory on hand accurately, considering purchase costs, quantities, discounts, market price changes, and obsolescence.
Context you provide
- {{product_line}}: The specific product line or items to value.
- {{inventory_data}}: Quantities on hand, purchase prices, and any discounts.
- {{reporting_period}}: The period for which valuation is needed.
- {{additional_factors}}: Any market price fluctuations, currency exchange rates, or obsolescence considerations.
Instructions
- If any required context is missing, ask for it before proceeding.
- Calculate the total value of inventory for the specified product line using the provided data.
- Adjust for any applicable discounts, market price changes, or currency conversions.
- Assess the need for write-downs due to obsolescence or damage.
- Present the valuation in a clear financial format, with line items for each component.
- Explain any assumptions made during the calculation.
Output format
- A table showing item, quantity, unit cost, total cost, adjustments, and final value.
- A summary paragraph with the total inventory value and key insights.
- Use professional financial language.
Guardrails
- Do not invent financial data; use only provided inputs.
- Flag any assumptions about market prices or obsolescence.
- Stay within the scope of inventory valuation; do not provide broader financial advice.
Example
- {{product_line}}: "smartphones", {{inventory_data}}: "100 units at $500 each, 50 units at $450 each", {{reporting_period}}: "Q1 2025", {{additional_factors}}: "market price dropped 10% for older models"
Open this prompt Analysis · Intermediate
Calculate Reorder Points
Use this when you need to determine the optimal inventory level at which to reorder products to avoid stockouts and minimize excess stock.
Open this prompt Analysis · Intermediate
Cross-Docking Optimization Plan
Use this when you need to plan and optimize cross-docking operations by analyzing truck schedules and predicting arrival times.
Open this prompt Planning · Intermediate
Cycle Counting System Design
Use this when you need to design a cycle counting algorithm, analyze inventory data, or develop predictive models for inventory accuracy.
Open this prompt Planning · Intermediate
Dead Stock Identification Analysis
Use this when you need to identify inventory items that are no longer in demand or usable, to optimize stock levels.
Open this prompt Analysis · Intermediate
Design Automated Inventory Tracking
Use this when you need to design a system for automated inventory tracking that integrates with existing tools and provides real-time insights.
Open this prompt Planning · Intermediate
Design Just-in-Time Inventory System
Use this when you need to design or optimize a just-in-time inventory system for specific products using demand forecasting and supply data.
Open this prompt Analysis · Intermediate
Forecast Inventory Demand Accurately
Use this when you need to predict future inventory needs based on historical data and market trends to maintain optimal stock levels.
Open this prompt Analysis · Intermediate
Generate Inventory Reports with Key Metrics
Use this when you need to generate comprehensive inventory reports for decision-making in operations or supply chain management.
Open this prompt Analysis · Intermediate
Inventory Performance Analysis
Use this when you need to analyze inventory performance metrics and identify optimization opportunities.
Open this prompt Analysis · Intermediate
Inventory Turnover Analysis
Use this when you need to calculate inventory turnover rates for specific products or categories, identify slow-moving items, and optimize ordering quantities.
Open this prompt Analysis · Intermediate
Multi-Echelon Inventory Optimization
Use this when you need to optimize inventory levels across multiple locations in your supply chain considering lead times, demand variability, and costs.
Open this prompt Analysis · Advanced
Optimize Inventory Levels
Use this when you need to balance inventory costs with product availability by analyzing sales data, demand forecasts, and supplier lead times.
Open this prompt Analysis · Intermediate
Optimize Safety Stock Levels
Use this when you need to calculate and maintain optimal safety stock levels to prevent stockouts.
Open this prompt Analysis · Intermediate
Serialized Inventory Tracking System
Use this when you need to design a system for assigning unique serial numbers to inventory items to enable real-time traceability and quality control.
Open this prompt Creating · Intermediate
SKU Rationalization Analysis
Use this when you need to analyze your inventory of stock-keeping units to identify opportunities for rationalization and improved turnover.
Open this prompt Analysis · Intermediate
Stock Rotation Strategy & Plan
Use this when you need to minimize spoilage and obsolescence by creating a data-driven stock rotation plan for specific product categories.
Open this prompt Planning · Intermediate
Supplier Performance Analysis
Use this when you need to evaluate supplier delivery performance, identify trends, and generate improvement recommendations.
Open this prompt Analysis · Intermediate
Track Inventory from Chat Logs
Use this when you need to automate inventory tracking and location updates from warehouse staff communications.
Open this prompt Automation · Advanced
Vendor-Managed Inventory Optimization
Use this when you want to analyze inventory data and develop a strategy for collaborating with suppliers to improve replenishment and reduce stockouts.
Open this prompt Analysis · Intermediate