Weighted average calculation of product purchase value

[Syndicate_Admin]

Good morning friends, I was currently asked to create inventory kardex for the company, it should be noted that it is a single product.
From it I have records of entry, exit, purchase costs, accumulated inventory after each movement.

The value that says tickets is the multiplication of the quantity purchased by the purchase value.
.- Now I would need to calculate the balance of the inventory initially would be 5819.35 but when they begin to register movements must be calculated, serious = previous inventory balance + purchases - production - salesbox (I leave print of an excel that was created to have a guide)

- Now I need to calculate the weighted average that would be Inventory balance / quantity in inventory (in excel it is called balance)

- Finally I would need to calculate the value of the outputs of products, whether to production or cash sales. multiplying the output quantity by the last weighted average value.

I hope to explain myself well. Thanks in advance

[MMPagola]

Hello, I need to do the same. Have you been able to achieve it yet? Thank you