Overview
This report allows you to choose several time periods to view year-over-year sales along with current inventory comparisons, shipments and on order data in a single report for different levels of location detail. This report is very useful as a web query as it can provide the equivalent data of multiple reports in a single request. This report allows drill-down capability to store item-level details.
Note: The time ranges in this report relate to the sales data; the inventory data is always based on the latest available time period.
Calculating WOS
We did not include a WOS calculation to this report since most users will want to set this up for themselves based on their business need. In addition, since this report allows you to look at different time ranges within the same report, you can calculate WOS on more than 1 metric.
The best way to calculate WOS is to create the report you want and then convert it to a web query. You can then add a WOS calculation to this report and then every time you update the web query, the WOS calculation will also update.
The most common way of calculation WOS is using last week's sales divided by current inventory. We also recommend using a forward-looking calculation by using the Next 2 Weeks LY as your time frame. This way you are calculating what the WOS will look like based on future sales instead of past sales.
Default Columns In This Report
- Market
- Store #
- City
- State
- Sales Metrics Repeated Columns (for each time period chosen)
- Units CY
- Units PY
- Sales CY
- Sales PY
- Units %
- Sales %
- Inventory Metrics
- Units CY
- Units PY
- CY Cost$
- PY Cost$
- % Change
- On Order
- Shipped Units
- On Order Cost$
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.
Report Columns / Terms Glossary