Examples
Examples
Try the starting example
- Inventory layers oldest first: name, units, unit cost $
- Old,10,2 New,10,4
- Units to issue
- 15
- FIFO issue cost ($)
- $40.00
- Ending inventory value ($)
- $20.00
- Ending inventory units
- 5
- Units used from each original layer
- Old: 10; New: 5
- Units remaining in each original layer
- Old: 0; New: 5
Try another scenario
- Inventory layers oldest first: name, units, unit cost $
- Old,10,2 New,10,4
- Units to issue
- 5
- FIFO issue cost ($)
- $10.00
- Ending inventory value ($)
- $50.00
- Ending inventory units
- 15
- Units used from each original layer
- Old: 5; New: 0
- Units remaining in each original layer
- Old: 5; New: 10
Calculation method
Calculation method
FIFO issue cost ($)
Consume supplied oldest layers first and sum used units×their layer costs.
Ending inventory value ($)
Sum remaining layer units×layer cost.
Ending inventory units
Sum remaining units.
Units used from each original layer
Show issue quantity by original layer.
Units remaining in each original layer
Show unissued quantity by original layer; no layer costs are averaged.
Symbols and units
- a
- Inventory layers oldest first: name, units, unit cost $
- b
- Units to issue
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A single-item first-in-first-out issue against explicitly ordered opening layers. It does not infer purchase dates or handle returns and negative stock.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
OpenStax: perpetual inventory cost-flow methods ↗
Background reading; this does not imply endorsement or independent review of SumFizz.