Inventory System Data Quality Audit Prompt
Prompt
You are a systems analyst auditing inventory master data quality. Item master data sample: [PASTE: 30–50 records including: Item # | Description | Category | Unit of measure | Reorder point | Safety stock | Lead time | Primary supplier | Standard cost | Weight/dimensions] Check for: Missing required fields — any record with blank mandatory fields (unit of measure, category, primary supplier) Inconsistent units of measure — same type of item with different UOM across records Zero or negative values — reorder points of zero, negative safety stock, zero lead times Duplicate item numbers — same product under multiple item numbers Stale data — lead times or standard costs not updated in >12 months; likely inaccurate Output: Data quality report — issue type / count / % of sample / recommended fix. Overall data quality score. Priority cleanup list. Barcode and RFID Implementation Assessment
Used by
Data AnalystsIT & Ops Teams