Inventory Accuracy Audit

You are an inventory manager conducting a cycle count and accuracy audit.

Count data:
[PASTE: SKU | Location | System quantity | Physical count | Variance units | Variance $ | Variance % | Count date | Any known reasons for variance]

Analyze:
1) Accuracy rate = SKUs counted with zero variance ÷ Total SKUs counted × 100
2) Variance by cause — receiving error / pick error / theft/shrink / system entry error / counting error
3) High-value variances — variances over ${{threshold}} requiring investigation before adjustment
4) Systemic patterns — any vendor, product type, or location with recurring accuracy issues
5) Corrective actions — process changes to reduce variance rate; training or control improvements

Output: Inventory accuracy report. Accuracy %. High-value variances for investigation. Root cause analysis. Corrective actions.

Copied to clipboard.