In Stock

This worksheet is Mango's comprehensive order point adjustment tool. These suggestions will modify order points on select SKUs to help keep your store in a better in stock position, increase put-away labor efficiency and reduce inventory where demand is low. It can be used for single or multi-stores in conjunction with Data Import or Compass to quickly adjust recommended order point parameters.

Order Point - this value is calculated each week (usually) automatically and is based on your monthly sales (via ROP reports set up in your Eagle scheduler). Your RSO/MPO order quantity is derived from Order Point and the SKU's QOH.

Furthermore, Order Point report (ROP) can use a SKU's Min and/or Max stock level settings to adjust its calculated Order Point:

Min Order Point = this is the lowest value Order Point can be calculated. For example, if a slow-moving SKU's order point calculates to 1, but you always want to have 4 on hand, then you can place 4 in the SKU's Min Order Point box. Then the SKU's order point will always be 4 (at a minimum).

Max Stock Level = The RSO will order up to this value when a re-order is triggered. For example, if a SKU has an order point of 5 and a Max Stock of 10, then when a reorder is triggered, the RSO will suggest ordering from the SKU's quantity-on-hand to 10. In Mango, Max Stock is used to reduce put-away frequency on good-selling, low OM SKUs.

ROP Protect (Codes tab of IMU)

If a SKU's ROP Protect flag is switched to "Y" then it is excluded from Eagle's order point calculation engine. When this happens, the SKU's order point is manually maintained via the Order Point field in the Stocking tab of Inventory Maintenance.

ROP Protect = Y should be used sparingly as the SKU's order point will no longer align with customer demand, and in some cases, will cause a SKU to run out of stock or become incompatible with a Min Order Point or Max Order Point setting.

Shelf Capacity (Location 3)

You can use Location code 3 in Inventory Maintenance to input the number of SKUs that fit on the shelf. This value is used and displayed throughout your Mango experience. Many stores are already using Loc3 for their backstock replenishment system, and SKUs with good shelf capacity data can benefit from better min/max order point suggestions.

Update 5/1/22

Most data from the In Stock tab can now be processed via the Retail Analytics Dashboard (RAD) on Acenet. Due to this enhancement, certain Min OP Types have been hidden by default using Column Y (Execute in RAD). In the table below, see the corresponding help link for instructions on how to process in RAD.

SKUs listed on this report will show a Min OP Type which helps you understand and process the suggestions:

Min OP Type
- A - In Stock: SKUs that are frequently selling to zero, not caused by warehouse outs or promo sales, and needing a higher Min OP so you don't run out. These are your Mango In-Stock suggestions found in the Retail Analytics Dashboard and help your store achieve its Productivity Level 1 - In Stock metric.
  - Steps to Process in RAD
- B - CTX: items commonly sold in multiples where your store's inventory level and order point are not sufficient to accommodate these sales.
  - Steps to Process in RAD
- C - EOQ (min/max): save labor by reducing restock put-aways. These suggestions are broken down into 3 categories.
  - 1 - Add: accept Max Stock from the back office as the suggested Max Stock can likely fit on the existing peg hook/shelf. Max Cubic Inch < 400.
    - steps to Process in RAD
    - 2 - Review: good Max Stock suggestions but the SKU size (cubic Inch) may not fit on the shelf or require remerchandising effort. These suggestions need to be printed and taken to the sales floor for further review and consideration.
    - 3 - Remove: SKUs reported in this category need to have the current Max Stock removed. The reasoning can be found in the the Action column (Z).
      - Steps to Process in RAD
  - D - MOP Reduction: Minimum order points set too high based on sales history and can be reduced.
    - Steps to Process in RAD
  - E - Ace Min OP: SKUs from Ace's current Minimum Order Point listing (project quantities). Excluding SKUs that have zero sales in your store and your store's peer group.
    - Steps to Process in RAD
  - F - ROP Protect removal, ROP=Y is:
    - Locking OP to Zero - the SKU has an Order Point protected at zero and cannot be replenished via the regular RSO/MPO process.
    - Blocking Min OP - the SKU's Min OP is greater than (or should be greater than) the SKU's protected Order Point.
    - OP Over Max Stock - the protected Order Point is greater than the SKU's Max Stock Level indicating a mismatch in shelf capacity, max stock, or order point.
    - ROP Too High - the protected order point is locked higher than customer demand.

Mango's take on processing this report

Process MIN OP changes via RAD.
Process EOQ suggestions via RAD.
(Optional or less frequently): process the Max Stock suggestions flagged for Review by using the button labeled "Print Max Stock Review"
Process ROP Protect removes.

When it comes to processing Max Stock suggestions, consider following these Action column guidelines to make the process as efficient as possible.

Processing 1 - Add

Frequency - Monthly

These are SKUs that you can easily accept the Max Stock from the back office as the Suggested Max Stock can likely fit on the existing peg hook or shelf. The max cubic inch is less than 400 or the suggested Max Stock is at/below known shelf capacity (Loc 3). If you're not familiar with Mango's Back Stock report, you can tell Mango how many of a particular SKU fits on a shelf using Location 3. If we know the shelf capacity of a SKU we will allow the Max Stock suggestion to exceed 400 and still be considered a 1 - Add.

Implementing 1 - Adds is easy with Data Import or Network Access, below you'll find a toggle panel labeled "Export Max Stock 1 - Add." Click there for more instruction on how to use the button on the worksheet to export the data and upload it into your system.

Processing 2 - Review

Frequency - Semi-annually

These SKUs are good Max Stock suggestions but because of the size of the SKU (Cubic Inch) they may not fit on the shelf and will require a remerchandising effort.

Processing 2 - Reviews requires more effort than 1 - Adds and that's why the recommended frequency is much lower but the suggestions and efficiencies gained from this category are just as important. Below you'll find a toggle panel labeled "Print Max Stock Reviews" where you'll find detailed instructions on how to process these as smoothly as possible.

Processing 3 - Remove

Frequency - Monthly

SKUs reported in this category need to have the current Max Stock removed. The reasoning can be found in the Action column (Z). Over time Max Stock levels can stale for one reason or another. It's important to stay on top of these removes to prevent out of stocks, overstock, OM changes, etc.

Removing Max Stocks are easy and can be done through Data Import or Network Access. Below is a toggle panel labeled "Export Max Stock 3 - Removes" for more detailed instructions.
Before changing Max Stock Levels, make sure you have fulfilled the prerequisites listed below, including Option ID 8859 and making sure all your scheduled ROP reports have Max Stock Level = C saved in the Options screen of ROP. Most stores have 20 (total) ROP reports in 4 queues (ROP7TH, ROP14TH, etc.) listed in SEQ.

Eagle Option ID 8859 = 2

1651 = Y
All ROP Queued Reports ROP -> Options -> Max Stock Level = C.
Highly recommend processing via RAD. Instructions here.
- File Prep (A)
  1. Enable Editing and Enable Content.
  2. If you are multi-store organization, filter the report to individual stores at a time. Data Import cannot handle multi-store data.
  3. Sort out any data you may want to exclude using the column filters.
  4. Click the button in the header called "Export MIN OP for Type A, B, D, E."
  5. The file is automatically prepped as a .txt file and needs to be saved. Save location defaults to the Desktop\MangoFiles...
  6. Close out of Excel.
  Import the Data
  1. Open Eagle Browser.
  2. Locate the folder named Data Import and click on it.
  3. Select Inventory Import Designer.
  4. Under Import File Type select Comma Delimited.
  5. In the top ribbon, select Open (F3).
  6. Select the file you saved in Step A.5 above.
  7. Double check the Import File Type is still Comma Delimited.
  8. In the top ribbon, select Map Field (F6). This is where we'll begin to tell the Eagle system what each column is from the Excel file.
  9. Find and select Store, click OK.
  10. It will ask what Position. Store (immediate update) was column 1 in our CSV file so enter 1, click OK. We'll repeat this for the remaining columns.
  11. In the top ribbon, select Map Field (F6).
  12. Find and select SKU, click OK. Position 2.
  13. Find and select Minimum Order Point, click OK. Position 3.
  14. Under Import Options, set the Flex Name to MGOMIN.
  15. Click on Store for chg and select the store you're working with.
  16. In the top ribbon, click Import.
  17. A new dialog box will appear, click Import.
  18. Once complete the box will pop up, click Cancel and close out of Data Import.
  Finalize Changes
  1. In the Launch bar of Eagle Browser, type RFL and press Enter.
  2. Print Setup -> Print To -> S (spooler).
  3. Options -> Store -> select the store you're working with.
  4. Options -> Options -> F (update inventory file).
  5. Options -> Flex Name -> MGOMIN.
  6. In the top ribbon, click Run (F4).
  7. You may see a message "No records exist for this flex name." This is okay as things can be automatically finalized for you and doesn't always require the RFL Step.
  8. You may see a message "Do you wish to exit". Click Yes.
  9. Close out of RFL. You're now finished! You can spot check IMU if you would like.
- File Prep (A)
  1. Enable Editing and Enable Content.
  2. If you are multi-store organization, filter the report to individual stores at a time. Data Import cannot handle multi-store data.
  3. Sort out any data you may want to exclude using the column filters.
  4. Click the button in the header called "Export ROP PRO = N for Type F."
  5. The file is automatically prepped as a .txt file and needs to be saved. Save location defaults to the Desktop\MangoFiles...
  6. Close out of Excel.
  Import the Data
  1. Open Eagle Browser.
  2. Locate the folder named Data Import and click on it.
  3. Select Inventory Import Designer.
  4. Under Import File Type select Comma Delimited.
  5. In the top ribbon, select Open (F3).
  6. Select the file you saved in Step A.5 above.
  7. Double check the Import File Type is still Comma Delimited.
  8. In the top ribbon, select Map Field (F6). This is where we'll begin to tell the Eagle system what each column is from the Excel file.
  9. Find and select Store (immediate update), click OK.
  10. It will ask what Position. Store (immediate update) was column 1 in our CSV file so enter 1, click OK.
  11. In the top ribbon, select Map Field (F6).
  12. Find and select SKU, click OK. Position 2.
  13. In the top ribbon, select Map Field (F6).
  14. Find and select ROP Protect, click OK. Leave Position blank and instead put the letter N into the Constant field, click OK.
  15. Under Import Options, set the Flex Name to ROPPRO.
  16. Click on Store for chg and select the store you're working with.
  17. In the top ribbon, click Import.
  18. A new dialog box will appear, click Import.
  19. Once complete the box will pop up, click Cancel and close out of Data Import.
  Finalize Changes
  1. In the Launch bar of Eagle Browser, type RFL and press Enter.
  2. Print Setup -> Print To -> S (spooler).
  3. Options -> Store -> select the store you're working with.
  4. Options -> Options -> F (update inventory file).
  5. Options -> Flex Name -> ROPPRO.
  6. In the top ribbon, click Run (F4).
  7. You may see a message "No records exist for this flex name." This is okay as things can be automatically finalized for you and doesn't always require the RFL Step.
  8. You may see a message "Do you wish to exit". Click Yes.
  9. Close out of RFL. You're now finished! You can spot check IMU if you would like.
Highly recommend processing via RAD. Instructions here.
- File Prep (A)
  Import the Data
  Finalize Changes
Highly recommend processing via RAD. Instructions here.
- Important! Option ID 1651 must be set to YES for these steps to work.
  
  File Prep (A)
  1. Enable Editing and Enable Content.
  2. If you are multi-store organization, filter the report to individual stores at a time. Data Import cannot handle multi-store data.
  3. Sort out any data you may want to exclude using the column filters.
  4. Click the button in the header called "Export Max Stock 3 - Removes."
  5. The file is automatically prepped as a .txt file and needs to be saved. Save location defaults to the Desktop\MangoFiles...
  6. Close out of Excel.
  Import the Data
  1. Open Eagle Browser.
  2. Locate the folder named Data Import and click on it.
  3. Select Inventory Import Designer.
  4. Under Import File Type select Comma Delimited.
  5. In the top ribbon, select Open (F3).
  6. Select the file you saved in Step A.5 above.
  7. Double check the Import File Type is still Comma Delimited.
  8. In the top ribbon, select Map Field (F6). This is where we'll begin to tell the Eagle system what each column is from the Excel file.
  9. Find and select SKU, click OK.
  10. It will ask what Position. SKU was column 1 in our CSV file so enter 1, click OK.
  11. In the top ribbon, select Map Field (F6).
  12. Find and select Store, click OK. Position 2.
  13. In the top ribbon, select Map Field (F6).
  14. Find and select Maximum Stock Level, click OK. Leave Position blank and instead put a question mark - ? - into the Constant field, click OK.
  15. Under Import Options, set the Flex Name to MXRMV.
  16. Click on Store for chg and select the store you're working with.
  17. In the top ribbon, click Import.
  18. A new dialog box will appear, click Import.
  19. Once complete the box will pop up, click Cancel and close out of Data Import.
  Finalize Changes
  1. In the Launch bar of Eagle Browser, type RFL and press Enter.
  2. Print Setup -> Print To -> S (spooler).
  3. Options -> Store -> select the store you're working with.
  4. Options -> Options -> F (update inventory file).
  5. Options -> Flex Name -> MXRMV.
  6. In the top ribbon, click Run (F4).
  7. You may see a message "No records exist for this flex name." This is okay as things can be automatically finalized for you and doesn't always require the RFL Step.
  8. You may see a message "Do you wish to exit". Click Yes.
  9. Close out of RFL. You're now finished! You can spot check IMU if you would like.
Processing Max Stock Reviews is a multi-step process and it's important to read through these directions before beginning.

File Prep
1. From the MEGA Report, select PL1 - In Stock and click the button Max Stock View.
2. If you a multi-store organization, filter Store (Column A) to the correct store.
3. If you only want to work certain aisles or department, this is your opportunity to filter before printing.
4. Click the button Print Max Stock Review, this will generate a PDF that can be sent to your local printer.
Sales Floor
1. Head to the floor and find your first SKU.
2. This is the order of operations and questions you'll be asking yourself:
  a. Can the suggested Max Stock fit without causing Back Stock, if YES then place a checkmark ✓ in the Shelf Capacity column. If NO, then proceed to the step below.
  
  b. If the suggested Max cannot fit, ask yourself if the area can be easily remerchandised to accommodate the max stock value. If YES, then create another facing(s) and place a checkmark ✓ in the Shelf Capacity column. If NO, then proceed to the step below.
  
  c. If the suggested Max cannot fit and cannot be remerchandised then write the number of units that can currently fill the shelf/peg in the Shelf Capacity column, close estimates are good. (Example: 6 cans per facing of spray paint, if you had 2 facings you'd write 12)
3. Repeat step 2 for the remaining SKUs in your list, once complete proceed to Computer Entry.
Computer Entry
1. Launch Eagle Browser and open Inventory Maintenance (IMU).
2. Enter the first SKU and click Display.
3. If you have a checkmark ✓ in the Shelf Capacity column then:
  1. Change the MIN OP to the Suggested MIN OP.
  2. Change the Max Stock to the Suggested Max Stock.
  3. Press Change (F5).
4. If you have a number in the Shelf Capacity column then:
  1. Click the Location hyperlink.
  2. Enter the number into Location 3.
  3. Click OK.
  4. Press Change (F5).
5. Repeat these steps for the remaining SKUs.

A - Store: Eagle store ID.

B - SKU: Item Number.

C - Min OP Type: See description above for the different types listed.

G - Current Min OP: Current store value as of the first of the month.

H - Suggested Min OP: What Mango is recommending for the new MIN OP.

I - ROP Protect: The SKUs ROP Protect flag (Codes tab of Inventory Maintenance).

J - Current Max Stock: Current store max stock value as of the first of the month.

K - Suggested Max Stock: What Mango is recommending for the new Max Stock.

L - TTM Sales Units: Last twelve months sales units.

M - Shelf Capacity (Loc3): the SKU's shelf capacity as entered in the SKU's Location code 3 in Inventory Maintenance.

N - Gap: the difference between the SKU's Min OP and Max OP.

O - Put Aways: the estimated number of times the item will be fulfilled annually given the suggested min/max settings.

P - Days Zero TTM: days the SKU was out in your store over the last year (RSC outs excluded from this number.)

Q - Times Zero TTM: Number of times the item has sold out in the last year.

R - Last Month Out: The most recent month the SKU sold to zero.

S - Max Cubic in: the total cubic inches the SKU will take up on the shelf at its Max OP quantity.

T- Inventory Dollar Change: Resulting dollar change with new Min (and/or max) OP in place.

U - Next Order Cash: How much the MIN (and/or max) OP adjustment will increase your next truck

Y - Execute in RAD: whether the Min OP Type can be processed via the Retail Analytics Dashboard.

Z - Action: recommended action to take.