Consumption Rate - Average Stock Rate

This report returns a list of current stock for the selected SKU/Location with statistics on sales, based on the supplied date range. This report also gives an estimate of the number of days of stock remaining, based on sales statistics.

Avgstockrate v3

Selection criteria

Linnworks will select the items to be included in the report based on the following criteria

Parameters - The following parameters can be used to configure this report.

  • Date range: select the date range for the report.
    • Start date: From the start of the day for the specified date.
    • End date: To the end of the day for the specified date.
  • Product: Linnworks stock item Number or Title. If no SKU/Title is specified, all items will be displayed.
  • Category: Linnworks stock item category.
  • Location: Linnworks location whose sales and stock data will be displayed.

Rules - internal logic applied to extract only those records that fulfil the specified criteria.

  • Composite parent items are not included in this report.
  • Only orders processed from the selected location are included.

Reported values

The following values are returned by the report.

Values - Column names and description.

  • ItemNumber: The Linnworks Stock Item Number.
  • ItemTitle: The Linnworks Stock Item Title.
  • SoldQty: The number of units sold and despatched from the selected location.
  • CurrentStock: Current stock level in the selected location.
  • Available: Available stock level in a selected location (Current Stock - Open Orders in selected Location).
  • DailyConsumptionRate: Number of units that have been sold daily in a selected time span from the selected location.
  • OnOrder: Quantity in purchase orders
  • AvailableStockDaysLeft: Estimated number of days current available stock will last for, based on consumption rate.
  • StandardDeviation: Standard Deviation for sold quantity.
  • Location: Linnworks location.