But anyway I don't get. How average price can be LOWER than the minimal price between 4 companies.
that's exactly what I meant
In your case average must be (32500 * qty1 + 28000 * qty2 + 41000 * qty3 + 29840 * qty4) / (qty1 + qty2 + qty3 + qty4)
thx, i didn't know this formula, but in my case, as you can see in report, quality is 1.0, so I calculated it rightly. average price must be exactly 32 835$.
why 24 220$ ??
don't see connection on how you loosing millions because of ''wrong'' average price of product
look.. if average price is 32000+ i can sell my current volumes for average price or higher = more profit
now i'm obliged to sell my good for low price to keep volumes, if I will sell it for 32 000 , it rather more than "average" price, I'll loose consumers
Don't forget about local suppliers, they are taking into account too.
local supplies must adapt to players, but not other way |