Here are the key metrics on an inventory dashboard:
Name of the product.
Name of the supplier of the product.
The location where the inventory on hand is stored. If you store the same product at multiple locations, there might be a separate entry for each location.
The cost to your business for one unit of the product.
The number of units of a product on hand at the beginning of the selected date range. For example, if you are looking at the report for the month of August, this column displays the number of units on hand on August 1st.
The number of units of the product added to your inventory during the selected date range.
The number of units of the product sold during the selected date range.
The current number of units of the product held in inventory.
The number of units of a product not accounted for. This number is calculated by taking into account the numbers listed in the Starting Inventory, Received, Usage, and On Hand columns.
The total cost of the variance. This number is calculated using the cost of the product, not the retail price.
On Hand Value
The total cost to your business for the units of a product held in inventory at the location. This number is calculated using the cost of the product.