The Velocity Report is useful when your inventory includes products you regularly replenish and avoiding stockouts or overstock is an important factor in maintaining the health of your business.
Assigning a Lead Time
Add replenishable MSKUs to the Velocity Report and begin tracking their Replenish By dates by assigning a lead time.
Your Lead Time is the number of days you’ll need to source and ship new quantities, while also allowing for transit time, and the time it takes for Amazon to process your inbound shipment.
To enter the Lead Time, go to your Inventory tab and select either FBA or Merchant fulfilled inventory from the menu.
You have the option to display your Inventory in different Views, which you can access by clicking the three dots on the upper right of the page.
To view Lead Times, make sure to select a custom view that has Lead Times as a visible column. (By default, the view will be set to Standard View.)
To create a Custom View, select Manage Custom Views:
You will then be taken to the Manage Custom Views screen:
Here, you can give your custom view a title and choose which columns to display. Be sure to set one of the columns to display Lead Time!
Click Save Changes:
Then select your new custom view from the three-dot drop-down menu:
Once you are in your custom view, find the MSKU in your inventory. The Replenish Lead Time field is editable, so that you may enter the desired number of Lead Time days. Once you enter it, it will automatically save your Lead Time for that MSKU.
Note: The Velocity Report is designed to track items you regularly replenish. It is not recommended to use this report to track all of your inventory. Tracking all of your inventory if you have a large amount of MSKUs can cause performance issues.
Viewing the Velocity Report
Select Velocity Report from the Reports tab menu.
Your Velocity Report syncs with Amazon every 6 hours daily. MSKUs with newly assigned lead times or changes to lead times are added to the report the next time this occurs.
The following columns make up the report:
Inventory Item – This displays the item’s title and ASIN. Clicking on the ASIN will take you to that product’s detail page on Amazon.com.
MSKU – This displays the item’s MSKU. Clicking on the MSKU will take you to the item in the Inventory page Management view.
On Hand – This is the ‘On-Hand’ quantity of the item at time of last update.
Inbound – This is the Inbound quantity of the item at time of last update.
Supplier – This column will show up to 3 suppliers. If there are more than three, there will be a link to the Sub MSKU page for that MSKU. On Export, it will separate suppliers by slashes (SupplierA / SupplierB / Supplier C)
Average Daily Sales – This column displays the Average Daily Sales data for the last 30 days and the last 7 days, for each item that you are tracking.
Lead Time – This displays the lead time entered at time of last update.
Days Remaining w/ Safety Stock – This is how many days of safety stock are remaining before you need to replenish. The calculation for the days remaining is Days Until Reorder Date = (Current Inventory Qty – Reorder Point) / Avg Daily Sales
- Safety Stock – The safety net amount of stock in case you do start selling more than usual. The calculation for this is Safety Stock = (Max Daily Sales – Avg Daily Sales) x Lead Time
- Reorder Point (this is in-stock quantity, not a date) = Lead Time Usage (Avg. Daily Sales * Leadtime) + Safety Stock.
- Max Daily Sales – the maximum number of sales you’ve had in a day for an MSKU based on the past 30 days.
- Average Daily Sales – the average daily sales based on the past 30 days.
Replenish By – This is the date in which you need to order or source additional quantities to avoid a stock out.
Note: All columns are sortable with the expectations of Supplier, Average Daily Sales, and Lead Time.
View Days Remaining Without Safety Stock
There may be some items you have that are slower-moving, seasonal, or may have an occasional velocity spike that would overestimate your time to replenish. You have the option to switch the report to view Days Remaining W/o Safety Stock. This changes the Reorder Point calculation to Average Daily Sales * Leadtime.
To change the view, the selection box is in the upper right corner of your screen, to the left of the search field:
Click in the box and select either W/Safety Stock or W/O Safety Stock
Your last view chosen will be saved as the default for the next time you open the report. Exporting will export the columns you have in your current view.
Average Daily Sales Graph
If you click on any of the graph icons, an Average Daily Sales graph will appear at the bottom of the screen. The Last 30 Days graph will display each day for the past 30 days, and the Last 7 Days graph will display each day for the past 7 days.
You can move your cursor over each graph point to see the number of daily sales for the items you are tracking.
You can also view the information for every item you are tracking combined, or individually for each MSKU. To view by MSKU, click on the graph icon next to each MSKUs Average Daily Sales graph.
Note: You can filter the report using the search at the top. It will begin to filter with each keystroke. If the results of are greater than 200, the Average Daily Sales graph will not display results. Refine your search criteria to narrow the results. You can also search by scanning in a UPC.
0 comments
Article is closed for comments.