...
Sold Qty = The total qty shipped from the selected sources during the selected sales period.
Total Revenue = Total Revenue = Total revenue earned from product shipped of the selected sources during the selected period [(Row Total of the ordered product - Tax Amount) / Ordered Qty * Shipped Qty].
Total Cost = Total cost of all shipped qty - Total cost. (The cost is recorded in the shipment -> Total cost = MAC at the time of the shipment * total shipped qty) (Refers to US01.5).
Average Cost = Total Cost / Sold Qty
Gross Profit = Total Revenue - Total Cost
Margin (%) = Gross Profit / Total Revenue (How profitable the warehouse is from the sale of products)
Turnover Rate =
Turnover Rate = Sold Qty x 2 / (Opening Qty + Ending Qty)
Opening Qty = the latest qty of the product before the day of the selected beginning date. (The new qty of this product in the last inventory movement before the beginning date) Ex: If user selects the start date as 3/7 -> The system will find the last inventory movement before the date (from 2/7 to before - If there is no movement on 2/7 then the system will continue to find the movement in the previous day until there is a movement). If there is no inventory movement from 2/7 to before -> Opening Qty = 0.
Ending Qty = the latest qty of the product before 24h of the selected ending date. (The new qty of this product in the last inventory movement before 24h of the ending date) Ex: If user selects the end date as 5/7 -> The system will find the last inventory movement before 12.am- 24:00 of the selected date (from 5/7 to before - If there is no movement on 5/7 then the system will continue to find the movement in the previous day until there is a movement). If there is no inventory movement from 5/7 to before -> Ending Qty = 0.
Note that, to get the newest data for your report, please refresh the statistics to the newest date by clicking on the “here” text.
...
How does Inventory Profit & Revenue report support you in your sales strategy
...