The Product Restock Calculation Detail Screen

How To Get There

  • From the Main Menu
    • Supply Chain -> Restock Suggestions and
      • Click on The “Units Needed at Amazon” quantity

What Is It For?

  • This screen will break down all the individual calculation steps that lead to the number of units to be ordered
  • It contains details about
    • How Inventory Required Is Calculated
    • How Days Of Supply Is Calculated

Screen Print

 

Screen Content

  • How Inventory Required Is Calculated
    • The formula is Inventory Required = Days to Cover × Adjusted Velocity
    • This section shows the Days To Cover parameter, and allows you to edit the value
    • The ‘Days to Cover’ is the minimum number of days of inventory you want to hold when receiving a new order quantity
    • It also shows the current adjusted sales velocity, which is defined in the Restock Suggestions screen, under the Adjusted Sales Velocity column
    • The Units Required is calculated by multiplying Days to Cover by the Adjusted Velocity
  • How Days Of Supply Is Calculated
    • The formula is Days of Supply = Units / Adjusted Velocity
    • The Days Of Supply value represent how many days are left, at the current sales velocity, before the number of units you hold is reduced to zero
    • Calculating how many units we currently hold
      • We first determine how many units we have in Amazon FBA, per inventory status

        • In Stock
        • Inbound
          • Clicking on the Information icon will open up a popup  showing  all the inbound shipments
          • Please note that the Inbound to FBA value is taken from the Manage Your Inventory (MYI) SellerCentral report. That value may or may not match the sum of values in the shipments list.
        • Reserved for FC Transfer
        • Reserved For FC Processing
      • We next determine how many units we have in the pipeline, per inventory status

        • On Order For Amazon
          • Units for which we have active supplier PO’s, bound for Amazon
          • Clicking on the info icon will show a popup listing all the FBA POs outstanding
          • From that popup, clicking on a PO order will take you to the details of the FBA PO
        • On Order For Local Warehouse
          • Units for which we have active supplier POs, bound for a 3PL
          • Clicking on the info icon will show a popup listing all the 3PL POs outstanding
          • From that popup, clicking on a PO order will take you to the details of the 3PL PO
        • In Transit To Local Warehouse
          • Units that are currently subject to a Transfer Order and moving from one 3PL to another 3PL
        • Present in warehouses
          • Units that are currently in any 3PL warehouses already
          • Clicking on the info icon will show a popup listing all the 3PL warehouses holding inventory for that product
          • From that popup, clicking on a warehouse code will take you to the details of the warehouse
      • For each of the inventory  statuses, you can decide whether to include/exclude these in the  units to be considered in the calculation
        • Click on Yes or No based on your requirements, or
        • Click on Default if you wish that setting to always be aligned to the default option
        • The current default option is shown in parenthesis, but remember that default can be changed, upon which this option will adopt the value of the new default when changed

 

in
2 0
Malcare WordPress Security