This report takes the guesswork out of your ordering process, providing you with data-driven reorder suggestions on products that you need to replenish.
How to use this report?
Select your store and weeks of supply that you would like product to be on the shelves. We understand that expectations vary by product type, which is why we gave you the option to filter the report by vendor, brand and category.
After applying your filters, the report will generate a minimum suggested order, which you’ll find in the far right column. This will be the number of units we suggest you order to ensure that product remains on the shelves for your designated weeks of supply.
The report will not expose products that you do not need to reorder.
*Hot Tip: Schedule this report as a recurring email so you’re always up-to-date on which products to replenish.
This report takes a 60 day historical snapshot of your product sales to (1) define the total number of units sold and (2) number of days when the product was in stock. We then take these two numbers to calculate the in stock avg. units per day (total units sold / number of days when product was in stock). We use this number to calculate the number of units we expect you to sell during the weeks of supply selected, which equals the in stock avg. units per period.
Lastly, we subtract in stock avg. units per period from your total quantity on hand to arrive at the minimum suggested order.
- in stock avg. units per day = 10
- weeks of supply = 2 (14 days)
- In stock avg. units per period = 140
- 10 units per day * 14 days = 140 avg. units per period.
- total quantity on hand = 100 units
- minimum suggested order = 40 units
- 140 avg. units per period - 100 units on hand = 40 units