Consumption Rate - Average Stock Rate by Supplier

This report returns a list of sold stock over the selected time frame, current stock, daily consumption rate and days of stock left based on average consumption rate over the selected period of time.

Avgstockrate supplier 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.
  • Supplier: The Linnworks supplier you wish to display data for.

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

  • Composite parent items are not included in this report.
  • Only processed orders are included.
  • Items that do not have selected supplier assigned will not be included.
  • Only stock items that were linked with the Supplier set as the Default Supplier at the time of processing will be 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.
  • SupplierCode: This is the supplier's SKU for the Linnworks Item, which may differ from the Linnworks SKU.
  • 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 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.
  • Minimum Level: The minimum level set in Linnworks for the Stock Item.

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

  • ItemNumber
  • ItemTitle
  • CurrentStock
  • Available
  • OnOrder