Average cost

[Guest]

The situatiion is the following

My data are :

line Prod Trans Qty Purchase
No Code Type Cost

1 510 Purchase 10 1.30
2 510 Sales -2
3 510 Purchase 30 1.50
5 512 purcahse 100 2.50
6 512 sales -25
512 purchase 250 3.00
513
514

I need to calculate the Average Cost for each product.

line Prod Trans Qty R Purchase Value RTot ACos
No Code Type Qty Cost

1 510 Purchase 10 10 1.30 13 13 1.3
2 510 Sales -2 8 -2.6 10.4 1.3
3 510 Purchase 30 38 1.50 45 55.4 1.45
4 510 sales -20 18 - 29 26.4 1.46
5 512 purcahse 100 2.50
6 512 sales -25



i.e line 1 average cost= Purchase Cost=1.30
line 2 average cost=Purchase Cost=1.30
line 3 average cost=Rtotal/Rqty

 

[Guest]

Loizos:

Do a search using "Average Cost", and you will find my previous response(s).
Also, I did go back and answer your follow-up questions.

Sharkbyte

 

[Joseph Meehan]

The situatiion is the following

My data are :

line Prod Trans Qty Purchase
No Code Type Cost

Please see my response to your prior question.

Note: You can add actual cost to the list of LIFO, FIFO NIFO and
Average.