In Stock - Ace Min OP - Excel Worksheet

This spreadsheet tab contains a full SKU listing of Exception Report: In Stock - Ace Min OP Listing  

Each year Ace creates a list of SKUs deserving a minimum order point to ensure your store has enough inventory to complete projects and stay in stock with your most popular SKUs. For example, a caster SKU will have a minimum order point of 4 because it commonly is purchased in this quantity. The list is entirely data driven based on deep analysis of customer purchasing behavior across thousands of stores. Note: the list is the same for all stores.

Where do I find this report?

Go to your Online Report Directory. Download / Save As the email file named: " - In Stock - ", e.g. "07205 - In Stock - 1216" Navigate to the Ace Min OP tab within the workbook (1st worksheet)

Steps to process this report:

1. Open Inventory Maintenance (IMU)
2. Enter in the SKU
3. Press Display (F6) 
4. Enter the SKU's recommended Minimum Order Point (column I) into the Min Order Point field.
5.  
6. Note: you may need to increase the Order Point as well.
7. Press Change (F5)

• An error can occur if the ROP Protect flag = Y. In the codes tab, set ROP Protect = N, press Change and follow steps 4-7 again. ROP Protect can now be set back to Y if desired.

Column Definitions

H - Annual Sales Units = the number of units your store has sold the SKU over the last 12 months. I - Ace Min Order Point = Ace's calculated minimum order point. M - Store ROP Protect = indicates if the SKU has its ROP Protect flag set to Y, in which case the Eagle system will not allow you to enter the minimum order point. If this is the case then you can set ROP Protect = N and hit "change". Then enter the new minimum order point and order point, and then change the ROP Protect back to Y if desired.  O - In Stock Fusion  = "Yes" means the SKU has sufficient peer group sales to be included in your store's In Stock Fusion metric. "No" means the SKU is a very slow seller in your peer group and is not included in your In Stock Fusion metric. In other words, if "Yes" then you should really consider increasing the SKU's minimum order point because it is supported by data for your store.