Analysis of goods turnover

What is it and what is it for?

The purpose of calculating the turnover is to understand how quickly the average stock in the warehouse is sold, how quickly you get the money you invested.

Turnover is the ratio of the speed of sales to the average inventory for the period.

The turnover report can be viewed in the Warehouse - Turnover Analysis.

Data in the report:

  • Goods
  • Contractor
  • Number of goods arrived
  • Stocks of goods at the beginning and end of the period
  • Sales result
  • Average stocks
  • Turnover in days and turnover
  • Goods stocks level

To calculate the turnover, you need to have THREE parameters:

1. Period. It can be a week, month, quarter, year.
2. Average stock for the period.
3. Trade turnover for the period.

Average stock for the period - the average value of the stock for the period (average annual, average monthly), is defined as:

ТЗav = ТЗ1 /2 + ТЗ2 + ТЗ3 + ТЗ4 + … ТЗn /2
                                             n – 1

ТЗ1, ТЗ2, ... ТЗn - the size of the stocks for individual dates of the analyzed period,
n is the number of dates in the period.

The turnover in days shows how many days it takes to sell the average stock.

The turnover in turnover tells how many times the goods “turned around” and sold during the period.

Stocks level is the ratio of available reserves to the expected average daily turnover in the coming period. Calculated in days of turnover.

How you can work with this report?

To create a report, go to the Warehouse - Turnover Analysis. Filter the list by the required fields and click the Show button.

Fields by which you can filter information:

  • Period
  • Goods categories
  • Suppliers (contractors)
  • Warehouses

The data in the Goods column is presented as clickable links. Click on the link in the Goods column to go to the goods card.

If necessary, the report can be exported to Excel.



Have more questions? Submit a request