Calculation guide
Exclude spoilage and write-downs.
Issue oldest lots for FIFO; periodic weighted unit cost = total available cost / units.
Inputs
Units issued or sold
Example entry 15.
Units in lot
Example entry 10. Minimum 1e-06.
Unit cost
Example entry 5 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Units issued or sold | 15 |
Available stock lots oldest first
| Units in lot | Unit cost |
|---|---|
| 10 | 5 |
| 20 | 8 |
| Result | Value |
|---|---|
| FIFO cost of issue | 90 |
| Weighted-average cost of issue | 105 |
| FIFO closing inventory | 120 |
| Average-cost closing inventory | 105 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Units issued or sold | 15 | 17 | FIFO cost of issue | 90 | 106 |
| Units in lot (row 1) | 10 | 11 | FIFO cost of issue | 90 | 87 |
| Unit cost (row 1) | 5 | 6 | FIFO cost of issue | 90 | 100 |
