Use this report to see which items are overstocked and which items are likely to cause stockouts. Identify overstocked products to reduce inventory on hand and see how many days of sales are required to reduce overstock to optimum inventory levels.
Before you start
- Managing Cin7 Core Reports
- This is a Cin7 ForesightAI report and requires an add-on to your subscription
- ForesightAI reports require at least 6 months of sales history in Cin7 Core.
Report options
| Layout | Set to the default layout or select from a saved layout. |
|---|---|
| Save layout as | Save a layout for potential future use. |
| Reset layout | Resets layout to the default layout or selected saved layout. |
Select Apply filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing Cin7 Core Reports - Filtering Reports for more detailed information about using filters.
Export report data to Excel, PDF, or RTF.
Report fields
The following fields are available for this report. Open the Configure Layout menu to view all available fields.
Fields
| SKU | Product SKU |
|---|---|
| Product | The name of the product |
| Brand | Product brand |
| Category | Product category |
| Family | Product family name |
| Product Tags | Comma-separated product tags |
| Location | Location name |
| Unit | Product unit of measure |
| Supplier | Supplier associated with this product |
| Barcode | Product barcode |
| Demand segment | Shows if the product is a Winner, Loser, or Chaser. |
Data headers
| Optimum qty | The recommended quantity on hand of this SKU to satisfy upcoming sales demand forecast |
|---|---|
| On hand qty | Current inventory on hand |
| Inventory cost | Average cost of the product |
| Overstock qty | Quantity of overstock items |
| Overstock value | Value of overstock items |
| Days to optimum | No. of days to go from current stock level to optimum quantity of the item according to sales forecast |