Page tree
Skip to end of metadata
Go to start of metadata



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.



IMPORTANT Notes: This is a very flexible report with a number of reporting options. As a result, it can be easy to misunderstand the values presented in the Inventory Metrics portion of the report.  The time ranges in this report relate to the sales data; the inventory on hand (Units CY and PY) data is always based on the latest available time period unless the only sales time period chosen is a custom closed ended time period - in which case the on hands will reflect the values as of the end of the custom time period. The shipment data will always accumulate across the longest chosen time period in the report.


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.


Last Ship Date Added 

Another new feature added to this report is the Last Ship date. This allows you to see when the last order was sent to a location. When you add this to your report, it will appear as the last column on the right in the Inventory section of the report.

To add this metric, you will need to choose the Last Ship Date option in the Extra Output Metrics on the page where you choose the options for this report. This option is in the lower right-hand section of this page.

Also, make sure to add the Store metric to this report, so that you can see the specific last ship date for each store.

If you don't select store data, the report will show the date of the last store/item shipment.

This metric can be helpful is checking for items that are not actually present in a store. For example, if a store shows and on hand quantity, no sales, and the last PO was 2 weeks in the past, the store may actually not have the quantity shown on hand. In this case, it is probably worth doing a cycle count of the item at that location.

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