...
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.