Inventory cost
Displays the total value of all products in stock based on current inventory.
Calculation Principle
Section titled “Calculation Principle”To calculate the value of products in stock, the current stock is multiplied by its price and then the values of all products are summed.
Not included in the calculation:
- products with zero stock;
- products without a price.
Calculation Example
Section titled “Calculation Example”Let’s take a current inventory with five products:
- Product A: stock — 5, price — $200
- Product B: stock — 2, price — $1500
- Product C: stock — 3, price — $800
- Product D: stock — 19, price — $100
- Product E: stock — 2, price — $5000
Calculate separately:
-
Product A:
Value — 5 × 200 = $1000
-
Product B:
Value — 2 × 1500 = $3000
-
Product C:
Value — 3 × 800 = $2400
-
Product D:
Value — 19 × 100 = $1900
-
Product E:
Value — 2 × 5000 = $10000
Total:
Total value of all products — 1000 + 3000 + 2400 + 1900 + 10000 = $18300
Summary
Section titled “Summary”Inventory cost: $18300
Product Report Key metrics on revenue and profit, recommendations for optimizing stock and improving profitability