Min and Max Values

The Minimum and Maximum values can be based on the setting of the number of days for which the supply should be sufficient in the store. The resulting Minimum and Maximum is then calculated from the sales data. You can also set fixed values for Minimum and Maximum. At the same time, each product which is placed in the planogram automatically takes over the Minimum and Maximum from the planogram.

All Minimums and Maximums can coexist. However, the rule is that Quant always takes into account the largest of the available Minimums and the smallest of the available Maximums. The exception is that setting the Minimum and Maximum on a product takes precedence over setting these values on a category.

Min and Max Days Reserve

Min Days Reserve specifies the minimum number of days for which the product supply in the store must be sufficient.

Max Days Reserve, on the other hand, is the maximum number of days that stores can hold stocks of products. Therefore, the product stock must not be higher than the number of days sold on average for the number of days set in the Maximum Days Reserve.

The average daily sales of the product is 5 pcs. The Min daily reserve is set to 10 and the Max daily reserve is set to 30. How will this product be ordered?

Average 
daily sales
Min Days Reserve
Max Days Reserve 
Min Value
Max Value
5 pieces
10 days
30 days
10*5=50 pieces
30*5=150 pieces

The table shows the calculated value of Minimum and Maximum. The product must have a stock of at least 50 pieces in the store so that its stock is enough for 10 days and its maximum stock will be 150 pieces (stock for 30 days). As soon as the stock of the product falls below 50 pieces, Quant will generate an order for this product in such a quantity which will replenish the stock up to 150 pieces.

What are the benefits of setting minimum and maximum values over daily reserves?

  • Automatic orders can count on the most current sales data (eg for the last month).
  • The calculated values are variable and can thus respond to changes in sales.
  • This setting allows you to react flexibly to an increase or decrease in sales (if, for example, there is a sudden increase in sales, the value of Minimum and Maximum will automatically increase without the need to change the value settings).
  • The setting of Min and Max Days Reserves can also be used in situations where, for example, you order from the supplier only once a week, and you want to be sure that there will be no outage. Setting the Min Days Reserve to 7 days will ensure that your supply never drops below a level that would not be enough for 7 days.
  • You can consider product expiration. For example, if you know that a product has a shelf life of 10 days, then you set the Max Daily Reserve to a maximum of 10 days. This way you make sure that the goods in the store will not be expired.

You can set your daily reserves in the following places:

  1. On the category for all stores. The ideal is to set daily reserves for the entire category of products so that the settings suit most products within the category. If for some specific products you subsequently find that this setting is not entirely satisfactory, you can then change it for the specific product (see point 3.).
    Days Reserve in Categories
  2. Per category for each store. If you want to set different daily reserves on a stores than those set on a category, e.g. due to different order days, select Category Store Settings.
    Days Reserve in Category Store Settings
  3. On the product for all stores. You can set daily reserves directly for the product. This setting takes priority over the per category setting.
  4. Days Reserve for a product
    On a store specific product in the Store Specific Properties tab - for example, if you want to set different minimum and maximum daily reserves for the same product at different stores.
    Settings of Days Reserve for a product

Min and Max Volume

Min and Max Volumes is a fixed value that is no longer recalculated.

If you set the Min Volume to 10 pcs and the Max Volume to 40 pcs, this means that as soon as the product stock falls below 10 pcs, such a quantity will be ordered so that the product stock is replenished to 40 pcs.

These fixed values of Minimums and Maximums are still the same and do not change depending on the marketability of the products, ie. when sales increase, they do not automatically increase and when they decrease, they do not decrease as in the case with daily reserves.

Min and Max Volumes can be used in cases where you have products that are not placed in the planograms, and at the same time these are new products in the assortment that have no historical sales.

You can set Min and Max Volume per category or for a specific product in the same way as MIN and MAX Daily Reserve.

Min and Max Volume in all stores
Min and Max Volumes 

Minimum and Maximum from a planogram 

Each product that is placed in the planogram can get the Minimum and Maximum from the planogram. These values bring valuable information about space constraints to the ordering process. Thanks to the connection of automatic orders to planograms, it cannot happen that the store orders goods which does not have a place where to be displayed because there is no space for it in the store.

Minimums and Maximums are calculated automatically for each product placed in the planogram, if you enable it in the settings of the automatic task MinMax of the order. Thanks to this, each product placed in the planogram has its Minimum and Maximum, even if you do not set any.

The minimum from the planogram is the setting of the minimum number of packages for a block. The maximum is the number of placed pieces in the planogram.

Minimum and Maximum from planogram 

Analysis Min Max Overview

In Quant, analysis is available in the Analysis / Min Max Overview menu. We recommend monitoring this analysis to find out which Minimums and Maximums are set for the selected product in the store. For example, you can see here what is the Minimum and Maximum from the planogram, what is the Minimum and Maximum amount set on the product and what is the Minimum and Maximum calculated from the daily reserve settings. You will always see the resulting Minimum and Maximum, which are taken into account when generating orders. You can easily find out why, for example, the product did not get into the order.

Min Max Overview

Analysis Store Stock

Another useful report can be the Store Stock analysis, which can be found in the Analysis / Store Stock menu. In this analysis, you can quickly find out what the stock of a given product is in the selected store. Here you can find out both the store's stock and the stock on the way.