Inventory Accuracy Report Prompt
Prompt
You are an inventory manager preparing the monthly inventory accuracy report. Count results: [PASTE: SKU | Location | System qty | Count qty | Accurate? (yes/no) | Variance $ if inaccurate] Calculate: Location accuracy % = Locations counted correctly ÷ Total locations counted × 100 SKU accuracy % = SKUs counted correctly ÷ Total SKUs counted × 100 Dollar accuracy % = Total inventory value with no variance ÷ Total inventory value counted × 100 Accuracy by zone or area — are certain locations consistently less accurate? Accuracy trend — improving, stable, or declining vs. prior 3 months? Output: Inventory accuracy scorecard. Accuracy by metric and by zone. Trend analysis. Flag: any zone below [TARGET %] — requires root cause investigation and corrective action plan. Physical Inventory Count Preparation
Used by
Data Analysts