Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • You can edit manually by filling in the Safety Stock Level, Reorder Point, Preferred Stock Level for the product then click on Save button.

  • You can also import the restocking metrics for many product at once by importing CSV file.

  • The RMS system also provide the auto-calculate function. You will need to select the product, fill in its Lead Time, Safety Stock (Days), Preferred Stock (Days) then click on Auto Calculate button. The Restocking Metrics will be automatically calculated as the formula below:

    • Safety Stock Level
      Auto-Calculate Formula: Safety Stock (Level) = Safety Stock (Days) * Daily Sales Speed.

    • Reorder Point
      Auto-Calculate Formula: Reorder Point = Safety Stock (Level) + Daily Sales Speed * Lead Time.

    • Preferred Stock Level
      Auto-Calculate Formula: Preferred Stock (Level) = Preferred Stock (Days) * Daily SalesSales Speed.

Info

How does the Sales Speed caluculated?

Sales Speed = Total Shipped Product during Sales Period of Current Source/ Totals Day during Sales Period. (i.e. From 22nd December to 24th December, 20 product was sold and shipped -> Sales Speed = 20 qty / 3 days)

You can change the selected Sales Period to get the most suitable Sales Speed.

You can also print and export the list in the page to process data.