Inventory: Understanding Average Cost
Jump to navigation
Jump to search
Inventory Simple Case - Avg Cost IS impacted by Sequence!!!
| TxType | EFFCTV QTY | ACCUMQTY | COST | TOTCOST | ACCUMBAL | AVGCOST |
|---|---|---|---|---|---|---|
| B | 100 | 100 | 15 | 1500 | 1500 | 15 |
| S | -50 | 50 | 15 | -750 | 750 | 15 |
| I | 10 | 60 | 20 | 200 | 950 | 15.83333333 |
| TxType | EFFCTV QTY | ACCUMQTY | COST | TOTCOST | ACCUMBAL | AVGCOST |
|---|---|---|---|---|---|---|
| B | 100 | 100 | 15 | 1500 | 1500 | 15 |
| I | 10 | 110 | 20 | 200 | 1700 | 15.45454545 |
| S | -50 | 60 | 15.45454545 | -772.7272727 | 927.2727273 | 15.45454545 |
