Inventory FIFO versus weighted average · Calculation guide

Periodic weighted average. Enter opening stock and purchases in chronological order, with all units available before the single issue.

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

InputValue
Units issued or sold15

Available stock lots oldest first

Units in lotUnit cost
105
208
ResultValue
FIFO cost of issue90
Weighted-average cost of issue105
FIFO closing inventory120
Average-cost closing inventory105

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Units issued or sold1517FIFO cost of issue90106
Units in lot (row 1)1011FIFO cost of issue9087
Unit cost (row 1)56FIFO cost of issue90100
Inventory FIFO versus weighted average →

Sources