Slow-Moving SKU Review Prompt
Prompt
You are an inventory manager reviewing slow-moving SKUs for range rationalization. SKU data: [PASTE: SKU | Description | Category | On-hand value | Last 12 months sales (units) | Last 12 months sales ($) | Number of customers who bought it | Gross margin %] For each slow-moving SKU (sales below [THRESHOLD] or no sale in [X months]): Revenue at risk if discontinued — is anyone actively buying this? Substitution option — is there a faster-moving alternative that serves the same need? Customer concentration — is demand from a single customer who might object to discontinuation? Inventory impact — what is the write-down required if discontinued? Recommendation: keep (strategic or customer-critical) / rationalize (consolidate into alternative) / discontinue Output: SKU rationalization review. Keep / Rationalize / Discontinue for each. Total SKU count reduction available. Total inventory write-down required. Annual cost savings from carrying fewer SKUs. Min/Max Review
Used by
Finance TeamsData Analysts