Recommended Reorder Point Report
Recommended Reorder Point Report displays the current reorder point and safety stock and recommends new reorder points and safety stocks by computing the historical daily usage and lead time in days of the product. Reorder Point is used to know when to reorder a product. This is to ensure that the amount of stock that a product has would not go lower than the safety stock. On the other hand, Safety Stock is the minimum amount of stock that the product should always have in order to avoid stock-outs.
Recommended Reorder Point Report Overview
Report Filters
- Date From – This filter will make it so that all transactions used for the report would only start from the date selected.
- Date To – This filter will make it so that all transactions used for the report would only be up to the date selected.
- Brand – This filter will show all products of the brand selected.
- Category – This filter will show all products of the category selected.
- Product Variant– This filter will show all product variants selected.
- Include Products with no transactions within the period – This filter will make it so that products with no transactions within the period would still be displayed.
Recommended Reorder Point Report Columns
- Product – This column shows all products and their SKU.
- Maximum Daily Usage – The highest number of items sold within a single day.
- Average Daily Usage – The average number of items sold within a single day.
- Maximum Lead Time in Days – The highest number of days it takes from an order of the product being placed to the business receiving the product.
- Average Lead Time in Days – The average number of days it takes from an order of the product being placed to the business receiving the product.
- Current Safety Stock – The safety stock currently defined in the product.
- Recommended Safety Stock – The safety stock computed using historical data.
( Maximum Daily Usage * Maximum Lead Time in Days ) – ( Average Daily Usage * Average Lead Time in Days )
- Current Reorder Point – The reorder point currently defined in the product
- Recommended Reorder Point – The reorder point computed using historical data
( Average Daily Usage * Average Lead Time in Days ) + Recommended Safety Stock
Export Recommended Reorder Point Report to PDF or Excel
- In the Recommended Reorder Point Report, click Export.
- There are two Export options: Export to PDF and Export to Excel. Click your desired format.
- Upon clicking your desired format, the file will be automatically downloaded to your computer.
- You may also view the Export History.
Related Article: Inventory Turnover Ratio