The Retail Product Expense-Expected vs. Actual graph gives you the amount spent to procure retail products by audit date for the current center.
Important: If you want to view the graph for more than five audits, use the Expenditure report.
You can compare the actual expense incurred with the projected expense calculated by Zenoti.
When you navigate to the Inventory dashboard, you can see this graph for the most recent five audits done in the last six months for retail and consumables.
You can see the following details on the graph:
Projected Expense: The average cost over a period of time auto-calculated by Zenoti to purchase this product.
Projected Expense = Cost of (Outflow Sold quantity - Inflow POS Return + Outflow PO quantity + Outflow PO Return quantity + Outflow Consumed quantity)
Actual Expense: The average cost incurred to purchase this product.
Actual Expense = Cost of (Opening Qty + Inflow PO quantity + Inflow Transfer quantity – Outflow PO Return quantity + Inflow PO Return + Inflow Converted quantity - Outflow Converted quantity + (Inflow Bundle quantity + Inflow Unbundled quantity) – (Outflow Bundle quantity + Outflow Unbundled quantity) - Outflow - PO quantity - Outflow Transfer quantity - Outflow InTransit quantity – Closing Qty)
Stock Value: The value of the stock after the audit was reconciled at the current center.
Stock Value = Sum of Audited quantity x Sale price for the center
Click the color codes for various items, below the graph to remove or add the corresponding details to the graph.
For example, if you click the blue color code for Projected Expense, Zenoti does not consider projected expenses for the specified date range in the graphical report. However, when you click it again, the projected expenses are considered in the graphical report.