STORAGE COLUMN ANALYSIS

  1. Quantity purchases: Total quantity of purchases
  2. Exit quantity: Total quantity of sales
  3. Purchases: Total value of purchases before VAT
  4. Sales: Total value of sales before VAT
  5. Gross profit%: (Sale price – Purchase value) * 100 / Sale price
  6. MT market: Average market price
  7. MT selling price: Average selling price
  8. Profit margin: Sale price – Purchase value
  9. Profit margin%: (Sale price – Purchase value) * 100 / Purchase price

Average price calculation