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. Sales data are used effectively to calculate these values, which means that they are specific to each store based on its sales performance, and therefore do not need to be set individually for each store. 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. The resulting Minimum and Maximum are then determined based on the MinMax rules.

All Minimums and Maximums can coexist. However, the rule is that Quant always takes into account the highest of the available Minimums and the lowest 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 Min Days Reserve is set to 1 day, and the Max Days Reserve to 2 days. Let’s use an example to show how this product will be ordered. This example demonstrates how Quant calculates the Minimum and Maximum of the order based on the Min and Max Days Reserves and the forecast.

The table shows the calculated values for the Min and Max. The Min value is based on the sum of forecasted sales over a specific number of days. In this case, the number of days must correspond to the number of days in the Min Days Reserve. For the Max, the number of days included in the calculation corresponds to the Max Days Reserve. The selection of days to be summed is also important. This selection must begin with the Delivery Date (for the Maximum) and the Next Delivery Date (for the Minimum) of the order.

Graph of the order
On the Order Chart, we can see that the order was created on January 3 and the lead time is 1 day. The delivery date for this order is January 4. The delivery date for the next order is January 6. Forecasted sales of the product from the order

The store must have at least 8.95 units of the product in stock to ensure a 1-day supply. The maximum stock level should be 17.12 units (a 2-day supply). As soon as the forecasted stock of the product is expected to fall below 8.95 units, Quant will generate an order for this product in an amount sufficient to replenish the stock to 17.12 units.

What are the benefits of setting minimum and maximum values via days reserves?

• • Automatic replenishment can count with 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 Days Reserve to a maximum of 10 days. This way you make sure that the goods in the store will not be expired.
  • It takes into account the sales of individual stores, so there is no need to set individual values for each store separately.

You can set your days reserves in the following places:

1. On the category for all stores. The ideal is to set days 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

1. Per category for each store. If you want to set different days 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

1. On the product for all stores. You can set days reserves directly for the product. This setting takes priority over the per category settings.

Days Reserve for a product

1. On a store specific product in the Store Specific Properties tab - for example, if you want to set different Min and Max Days Reserves for the same product at different stores.

Days Reserve for a product for a specific store

1. On the supplier in the Suppliers section – for all products from that supplier. The Maximum Days Reserve can be set at the product, category, or supplier level. If the value is set directly on the product, it always takes precedence and is used regardless of other levels. However, the MinMax rule applies to categories. Therefore, if no value is specified on the product, the lower value between the Max Days Reserve set for the category and the supplier will be used for MAX orders.

Days Reserve for all products of the supplier

1. On the supplier for individual stores in the Supplier Store Settings section – for example, when you want to set different Min and Max Days Reserves for the same supplier at different stores.

Days Reserve for suppliers at a specific store

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 product sales, ie. when sales increase, they do not automatically increase and when they decrease, they do not decrease as in the case with days 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 Days Reserve.

Min and Max Volume in all stores

Min and Max Volumes for a specific store

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 replenishment 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 Order Types. Thanks to this, each product placed in the planogram has its Minimum and Maximum, even if you do not set any. This prevents it from being omitted from the order even though it is supposed to be displayed on the planogram.

You can read more about this in the Order Types manual.

The minimum from the planogram is the setting of the minimum number of packages for a block. The maximum is the number of placed products in the planogram or its maximum capacity, which takes into account the maximum number of products that can fit into the fixture based on its dimensions.

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 days 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

Another useful report is the Store Stock analysis, which reflects the stock of a given product at a selected store. You can learn more about this analysis in the Store Stock manual.

In Quant, you can also track how margins, sales, or other sales indicators develop over a certain period. The development of these indicators can be tracked for individual products, entire categories, or specific product groups. This analysis can also be used to display forecasts. For more information, see the Development Analysis manual.