Difference between revisions of "Inventory: Understanding Average Cost"
Jump to navigation
Jump to search
(Created page with "Inventory Simple Case - Avg Cost IS impacted by Sequence!!! {| class="wikitable" ! TxType !! EFFCTV QTY !! ACCUMQTY !! COST !! TOTCOST !! ACCUMBAL !! AVGCOST |- | B || 100 ||...") |
(No difference)
|
Revision as of 18:02, 25 October 2023
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 |
