Consumption Rate - Avg Stock Normal Distribution - No Spikes

This report returns a list of sold stock over the selected time frame, current stock, daily consumption rate. The report works out the average based on the number of sales and gets rid of spikes which are over 300% of average consumption rate.

Avgstock nospikes v2

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 from the selected location.
  • CurrentStock: Current stock level in the selected location.
  • Available: Available stock level in the selected location.
  • DailyConsumptionRate: Number of units that have been sold daily in the 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.

Grouping - Items that match across the following criteria will be grouped on a single row in the report.

  • ItemNumber
  • ItemTitle
  • CurrentStock
  • Available
  • OnOrder
  • AvailableStockDaysLeft