Year-Over-Year Inventory Productivity By Item (68)
- Amy Midkiff (Unlicensed)
- Daniel Fitzpatrick (Unlicensed)
Overview
This report provides sales and inventory data, weeks of supply metrics and average inventory on a year-on-year comparative basis. It is helpful in allowing you to understand how your item inventory is performing compared to the prior year.
Note that the inventory figures in this report are averages, not current data. This is done to allow for calculating annual turns and GMROI (gross margin return on investment).
Click-Through Interactivity
Notice in the above screenshot there are several columns where the text is blue. One of the big benefits of web reporting is the ability to embed a number of rich interaction links with more detailed results from inside a report. Usually a left-most column that is clickable (blue text) indicates a drill-down capability which will open a new report for the specific item or category with a greater level of data detail. Hovering your mouse over the link should provide you with a hint of what the link can do as well. Links in other columns often will provide you with pop-up graphs to enhance your understanding of the data in that row/column as well.
Default Columns In This Report
- Item #
- Description
- Retailer Category
- # Stores
- Units CY
- Sales CY
- Inventory CY
- Cost Inventory $ CY
- WOS CY
- Ann. Turns CY
- Units PY
- Sales PY
- Inventory PY
- Cost Inventory $ PY
- WOS PY
- Ann. Turns PY
- Units %
- Sales %
- Inventory %
- WOS %
- Turns %
- CY Margin$
- PY Margin$
- CY GMROI
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.