In Stock - help

Mango Report
Help Center

Search:

Contents

IndexBookmarkPrint

MEGA Report - 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, Min OP, Max Stock, ROP Protect - what's the difference?

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 MinOP: 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. Instructions can be found here and here
Process EOQ suggestions via RAD. Instructions can be found here
(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.

How to Process Max Stock Suggestions

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.

Prerequisites

Export MIN OP for Type A, B, D, E

Highly recommend processing via RAD. Instructions here.

Data Import - MIN OP Type A, B, D, E

File Prep (A)

Enable Editing and Enable Content

If you are multi-store organization, filter the report to individual stores at a time. Data Import cannot handle multi-store data.
Sort out any data you may want to exclude using the column filters.
Click the button in the header called "Export MIN OP for Type A, B, D, E"
The file is automatically prepped and needs to be saved. Save location defaults to C:\3apps\Temp\..."
Close out of Excel

Import the Data

Open Eagle Browser
Locate the folder named Data Import and click on it
Select Inventory Import Designer
Under Import File Type select Comma Delimited
In the top ribbon, select Open (F3)
Select the file you saved in Step A.5 above
Double check the Import File Type is still Comma Delimited
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
Find and select Store, click OK
It will ask what Position. Store was column 1 in our CSV file so enter 1, click OK. We'll repeat this for the remaining columns
In the top ribbon, select Map Field (F6)
Find and select SKU, click OK. Position 2
Find and select Minimum Order Point, click OK. Position 3
Under Import Options, set the Flex Name to MGOMIN
Click on Store for chg and select the store you're working with
In the top ribbon, click Import
A new dialog box will appear, click Import
Once complete the box will pop up, click Cancel and close out of Data Import

Finalize Changes

In the Launch bar of Eagle Browser, type RFL and press Enter
Print Setup -> Print To -> S (spooler)
Options -> Store -> select the store you're working with
Options -> Options -> F (update inventory file)
Options -> Flex Name -> MGOMIN
In the top ribbon, click Run (F4)
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
You may see a message "Do you wish to exit". Click Yes
Close out of RFL. You're now finished! You can spot check IMU if you would like.

Export ROP PRO = N for Type F

Data Import - ROP PRO = N for Type F

File Prep (A)

Enable Editing and Enable Content

If you are multi-store organization, filter the report to individual stores at a time. Data Import cannot handle multi-store data.
Sort out any data you may want to exclude using the column filters.
Click the button in the header called "Export ROP PRO = N for Type F"
The file is automatically prepped and needs to be saved. Save location defaults to C:\3apps\Temp\..."
Close out of Excel

Import the Data

Open Eagle Browser
Locate the folder named Data Import and click on it
Select Inventory Import Designer
Under Import File Type select Comma Delimited
In the top ribbon, select Open (F3)
Select the file you saved in Step A.5 above
Double check the Import File Type is still Comma Delimited
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
Find and select Store, click OK
It will ask what Position. Store was column 1 in our CSV file so enter 1, click OK.
In the top ribbon, select Map Field (F6)
Find and select SKU, click OK. Position 2
In the top ribbon, select Map Field (F6)
Find and select ROP Protect, click OK. Leave Position blank and instead put the letter N into the Constant field, click OK.
Under Import Options, set the Flex Name to ROPPRO
Click on Store for chg and select the store you're working with
In the top ribbon, click Import
A new dialog box will appear, click Import
Once complete the box will pop up, click Cancel and close out of Data Import

Finalize Changes

In the Launch bar of Eagle Browser, type RFL and press Enter
Print Setup -> Print To -> S (spooler)
Options -> Store -> select the store you're working with
Options -> Options -> F (update inventory file)
Options -> Flex Name -> ROPPRO
In the top ribbon, click Run (F4)
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
You may see a message "Do you wish to exit". Click Yes
Close out of RFL. You're now finished! You can spot check IMU if you would like.

Export EOQ 1 - Adds

Highly recommend processing via RAD. Instructions here.

Data Import - EOQ Adds

File Prep (A)

Enable Editing and Enable Content

If you are multi-store organization, filter the report to individual stores at a time. Data Import cannot handle multi-store data.
Sort out any data you may want to exclude using the column filters.
Click the button in the header called "Export Adds for NA/DI"
The file is automatically prepped and needs to be saved. Save location defaults to C:\3apps\Temp\..."
Close out of Excel

Import the Data

Open Eagle Browser
Locate the folder named Data Import and click on it
Select Inventory Import Designer
Under Import File Type select Comma Delimited
In the top ribbon, select Open (F3)
Select the file you saved in Step A.5 above
Double check the Import File Type is still Comma Delimited
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
Find and select SKU, click OK
It will ask what Position. SKU was column 2 in our CSV file so enter 2, click OK. We'll repeat this for the remaining columns
In the top ribbon, select Map Field (F6)
Find and select Minimum Order Point, click OK. Position 3
Find and select Maximum Stock Level, click OK. Position 4
Under Import Options, set the Flex Name to MXSTK
Click on Store for chg and select the store you're working with
In the top ribbon, click Import
A new dialog box will appear, click Import
Once complete the box will pop up, click Cancel and close out of Data Import

Finalize Changes

In the Launch bar of Eagle Browser, type RFL and press Enter
Print Setup -> Print To -> S (spooler)
Options -> Store -> select the store you're working with
Options -> Options -> F (update inventory file)
Options -> Flex Name -> MXSTK
In the top ribbon, click Run (F4)
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
You may see a message "Do you wish to exit". Click Yes
Close out of RFL. You're now finished! You can spot check IMU if you would like.

Export EOQ 3 - Removes

Highly recommend processing via RAD. Instructions here.

Data Import - EOQ Removes

Important! Option ID 1651 must be set to YES for these steps to work.

File Prep (A)

Enable Editing and Enable Content

If you are multi-store organization, filter the report to individual stores at a time. Data Import cannot handle multi-store data.
Sort out any data you may want to exclude using the column filters.
Click the button in the header called "Export Max Stock 3 - Removes"
The file is automatically prepped and needs to be saved. Save location defaults to the desktop.
Close out of Excel

Import the Data

Open Eagle Browser
Locate the folder named Data Import and click on it
Select Inventory Import Designer
Under Import File Type select Comma Delimited
In the top ribbon, select Open (F3)
Select the file you saved in Step A.5 above
Double check the Import File Type is still Comma Delimited
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
Find and select SKU, click OK
It will ask what Position. SKU was column 1 in our CSV file so enter 1, click OK.
In the top ribbon, select Map Field (F6)
Find and select Store, click OK. Position 2
In the top ribbon, select Map Field (F6)
Find and select Maximum Stock Level, click OK. Leave Position blank and instead put a question mark - ? - into the Constant field, click OK.
Under Import Options, set the Flex Name to MXRMV
Click on Store for chg and select the store you're working with
In the top ribbon, click Import
A new dialog box will appear, click Import
Once complete the box will pop up, click Cancel and close out of Data Import

Finalize Changes

In the Launch bar of Eagle Browser, type RFL and press Enter
Print Setup -> Print To -> S (spooler)
Options -> Store -> select the store you're working with
Options -> Options -> F (update inventory file)
Options -> Flex Name -> MXRMV
In the top ribbon, click Run (F4)
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
You may see a message "Do you wish to exit". Click Yes
Close out of RFL. You're now finished! You can spot check IMU if you would like.

Print EOQ Reviews

Processing Max Stock Reviews is a multi-step process and it's important to read through these directions before beginning.

File Prep

From the MEGA Report, select PL1 - In Stock and click the button Max Stock View
If you a multi-store organization, filter Store (Column A) to the correct store
If you only want to work certain aisles or department, this is your opportunity to filter before printing.
Click the button Print Max Stock Review, this will generate a PDF that can be sent to your local printer.

Sales Floor

Head to the floor and find your first SKU
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)
Repeat step 2 for the remaining SKUs in your list, once complete proceed to Computer Entry

Computer Entry

Launch Eagle Browser and open Inventory Maintenance (IMU)
Enter the first SKU and click Display
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)
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)
Repeat these steps for the remaining SKUs

Column Definitions

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. More info here

Z - Action: recommended action to take.