Product Velocity Report

The Product Velocity Report is designed to track and analyze the movement of inventory items through sales, purchase orders, and manual adjustments.

 

It helps businesses understand how quickly products are moving, identify trends, and make informed decisions regarding inventory management.

Data Selection:

Report View:

Components of the Report

  1. Graphical Representation:
    • The graph displays daily inventory changes for the product over the selected date range (May 1st, 2024 to May 11th, 2024).
  2. Key Metrics:
    • First Purchase Order: Date of the first purchase order for the product within the system, which is March 30th, 2024.
    • First Sale: Date of the first recorded sale, which is January 17th, 2024.
    • Total Ordered Quantity (current range): Total quantity of the product ordered within the selected date range, which is 48.
    • Total Quantity Sold (current range): Total quantity sold within the date range, totaling 12.
  3. Detailed Data Tables:
    • Sales Records: Lists individual sales transactions, including order ID, date, quantity, and status (2 is order completed)
    • Purchase Order Details: Shows purchase orders placed, including PO number, date, quantity, and status.
    • Manual Adjustments: (Not shown in the image but typically part of such reports) Would detail any manual changes made to the inventory, including the date, new quantity, and old quantity.