• Reg. movement means the average weekly sales in units, excluding promotion, excl. delivery, excl. HVS and only calculated as average for days with stock in the morning and the evening.
• Man. Inventory; calculation in units based on peak sales, delivery days, shelf depth for days with stock (starting point is reg. movement). If any component is missing (no sales, no delivery days, article not on the shelf) the system will take the weekly 7 days average = 7 days = reg. movement in units
• Shelf required is based on the units of man. Inventory in units
• Max. shelf, or shelf capacity, or total units is what fits into the shelf

Pre-requisites to have a proper calculation of the Manual Inventory:

• The article must be placed on the shelf, otherwise the system does not know how deep it can go on the shelf and cannot calculate shelf requirement
• Please be aware that is there are no delivery days in MMS or the article is not on the shelf, the system cannot calculate
• In MMS (NAL screen), Full facings should be set to “yes” in all circumstances
• Do not change anything in max. units height, as this will trouble the calculations and any change in one planogram will change it in all, as it is master data
• Be careful when applying Max Merch! On a shelf, the Max Merch limits the shelf capacity and is connected with the shelf. When you copy/past a shelf, you also copy the Max Merch value.

How does the calculation works:

• From MDW we get only those days, for the selected period in UDEF, where the article has stock in the morning AND in the evening.
• Days with (partly) missing stock are excluded as it would lower the average and therefore possibly not creating enough shelf required stock.
• Days in which the article is marked as promotion are excluded.

Based on the above, it might happen that in a 52 week rolling principle for one article you have 40 valid Monday and e.g. 30 valid Tuesdays.

This data capturing is done on daily base for the defined period at store individual level.

Please note: If the capturing period is too short, it might be that you get days where no data is collected!

• For those valid days, we also deduct High Volume Sales and deduct delivery sales. This means we have a weekly total and the split per day.
• After that, we use the delivery days of the particular store/ article combination (store, NOT platform) and calculate the peak sales period for that article.

Please note: The Highlighting functionality uses the man. Inventory as starting point. If you make any highlight, please ensure to select units and not facings.