Min/Max Ordering Process
Before you begin to set up your Min/Max, there a few things to consider first, are rolling stocktakes happening? It is vital that you have accurate SOH when using the Min/Max ordering method. Run the top seller reports, to identify the rate of sale of products in key categories to begin with, and then slowly introduce all categories. For example investigate top 10-15 lines per category.
This is the best ordering process moving forward and gives you the best chance of
remaining in stock of top sellers and general items in all departments.
1. Select “Items”
2. Select “Min/Max Manager”
3. Select New and type a description
4. Click into the “Three dots” in the Order Code Box
5. Item maintenance screen opens, make your selection and click “Select Tagged”
6. When the products are on the screen Hit the “Run Formula” button
7. Based on ROS (average number of sales over a 12 week period) set up min SOH for 3 weeks and then max SOH for 5 weeks.
8. When the stock reaches the 3rd week minimum stock levels, it will reorder to 5 weeks max of stock, when Min/Max template is run.
9. This way you are doing everything possible to remain in stock of your top sellers.
10. Remaining in stock allows you to not miss out on sales and improves stock intensity per m2 and GMROF.
11. Apply
Min/Max Formula
In Min Max Manager, when you select the “Run Formula” button the screen below will open. This is where your min/max requirements will be set. When you click “Run Formula” the program will look at your selected stock and calculate the min/max quantities based on the ROS
(Rate of Sale) and the number of weeks selected.
