Item Inventory Stocking Level Summary Report (8)
- Amy Midkiff (Unlicensed)
- Daniel Fitzpatrick (Unlicensed)
Overview
This report allows you to monitor inventory levels on individual items based on a number of metrics. Unlike standard OOS reports, which show only zero on hands, this report allows you to customize the danger metrics. In this report you can customize the WOS threshold on both an upper and lower basis, based on a WOS calculation over any number of weeks. In addition to a standard "backward-looking" calculation, you also get a symmetric forward-looking WOS calculation, allowing you to evaluate coming needs as well.
Inventory Alerts:
B-OVERSTOCK shows items overstock for both forward-looking and trailing sales trends
P-OVERSTOCK shows items overstocked based on past sales trends
F-OVERSTOCK shows items overstocked based on forward-looking sales (same future periods for prior year)
Default Columns In This Report
- Store #
- Market/Patch
- Mkt Name
- Item #
- Description
- Retailer Category
- Inventory Alert
- On Hand
- FWOS
- TWOS
Column Definitions
Many of the column names are common between reports. We also use abbreviations to save space. To learn about the meaning of a specific column click on the link below for the glossary of column terms.