Mango Report
Help Center
Search:
Contents
:
IndexBookmarkPrint

Home > Retail Analytics Dashboard > EOQ (Min/Max)

RAD - EOQ (Min/Max)

 

Economic Order Quantity (EOQ) is a popular way to increase labor efficiency and in-stock by ordering more units, less frequently.

  • Uses your Eagle Minimum Order Point and Max Stock fields to decrease Ace delivery put-away trips by ordering more quantity, but less often.
  • Targets 300-800 SKUs (depending on store size).
  • Max quantities are unlikely to cause back stock. 
  • Target SKUs: order multiple=1, low cost, low cube, non-seasonal, non-promo, regular selling SKUs.
  • Examples: watch/calculator batteries, drill bits, PVC fittings, super glue, etc.

     One-Time Prerequisite Setup

​

Steps to execute EOQ (Max Stock) Adds & Adjusts:

  1. Log into Acenet and select Analytics Dashboard from the top menu.
  2. Under the Optimal Shelf Quantity section, find and click the Current % hyperlink for EOQ (Max Stock) Acceptance. 
  3. A new popup will appear, click the acceptance hyperlink for EOQ Adds and Adjusts
  4. A grid will load and populate SKUs which are suggested EOQs for your store. 
  5. A lot of intelligence has gone into the suggested Min OP and Max Stock but if you'd to analyze further consider columns like: Last 12 Months Units, Shelf Capacity, and Expected Annual Put Away. 
  6. You can accept these Min/Max recommendation by clicking the button in the Change Min/Max Order Point column.
  7. Once you have selected the SKUs you'd like to accept, click Submit in the upper right hand corner.
  8. Within 30 minutes, the Max Stock and Minimum Order Point will bet set to the suggested levels.

Steps to execute EOQ (Max Stock) Removes:

  1. Log into Acenet and select Analytics Dashboard.
  2. Under the Optimal Shelf Quantity section, find and click the Current % hyperlink for EOQ (Max Stock) Acceptance. 
  3. A new popup will appear, click the acceptance hyperlink for EOQ Removes.
  4. A grid will load and populate SKUs that currently have an EOQ in your system that should be removed. The reason for the suggested removal can be found in the Action column.
  5. You can accept these EOQ Removals by clicking the button in the Remove Max Stock column.
  6. Once you have selected the SKUs you'd like to accept, click the Submit in the upper right hand corner.
  7. Within 30 minutes, the Max Stock will be cleared from the SKUs.