Knowing how much product to send to Amazon is something every seller needs to know. If you don’t send enough, then you run out of stock. If you send too many, then you pay storage fees. The client was using some reports that Amazon has for this purpose, but they wanted to take into account many more variables than the standard on-hand inventory, in-transit, sellable, and sales over the last 30 days. They wanted to take into account lead-time from the supplier, ordered inventory that was on its way from the supplier, time it took Amazon to check in their products when using UPS or LTL, and other variables that Amazon doesn’t account for.
A velocity report tool was created for my website SellersToolbox which the client now has perpetual access. It allows for variations between suppliers of any length, variations in Amazon check-in times, sales history from 1 week to 1 year, purchase timeframe from 1 week to 1 year, and supplier filtering. It shows profitability and margin values based on cost, the number of days before the product will run out, the number of units and dollar amount that is an overage for slow-moving products, and more. They can now deal with foreign suppliers where it takes 2-3 months for products to arrive, as well as from a supplier that can deliver within 2-3 days. All of the data is downloadable to a spreadsheet for easier handling.