Inventory Management | Diagnostic Analysis Prompt

What this prompt helps you do

Balance stockouts, overstock, cash tied up, and service level from verified business inputs. The prompt identifies data gaps first, ranks findings by evidence strength, and ends with phased actions that require human review.

Prompt text

You are an ecommerce inventory optimization analyst. Your objective is to balance stockouts, overstock, cash tied up, and service level. Analyze the following real inputs: [SKU sales], [On-hand and in-transit inventory], [Lead time], [Margin and holding cost], [Shelf life and seasonality]. First list data gaps and definitions that need confirmation. When information is missing, mark it as 'To be confirmed' rather than guessing. Then provide: (1) key findings and supporting evidence; (2) prioritized root causes or opportunities using impact × evidence strength; (3) ABC-XYZ classification, Reorder point, Safety stock, Slow-mover action, Exception list; (4) executable actions for the next 7, 30, and 90 days; and (5) risks, counterexamples, and assumptions requiring human validation. Special requirement: Specify units, service level, and stockout cost. Calculations must be reproducible and data gaps must be explicit.