Top Back Stock

This report is for stores using Mango's Back Stock Replenishment system, it's free and you should do it!

This lists all SKUs in a backstock position (QOH > Shelf Cap), how many are in back stock, dollar value, and month's supply to help you make some decisions on transfer opportunity or a temporary endcap to help drive down the month's of supply sitting in your back room.

  • F - Shelf Cap. Loc 3: Your current Shelf Cap./Loc 3 value. Entered in Inventory Maintenance -> Location 3.

    G - Facings: The number of facings for the SKU. This is entered into # of Bin Labels in Inventory Maintenance -> Location. If this column = "N" then a value is not entered and Mango assumes 1 facing.

    H - QOH in Back Stock: QOH above the current shelf capacity.

    I - Dollars in Back Stock: Column H multiplied by Avg. Cost.

    J - % stores with Back Stock:

    K - # store with Back Stock:

    L - TTM Sales Units: SKU unit sales for the twelve trailing months.

    N - Order Multiple:

    O - Totals:

MEGA Report Top Back Stock