FIFO inventory cost layers

Consume the oldest receipt layers in transaction order and inspect issued cost, remaining quantity and residual cost layers.

The example value has been entered. Check it immediately or change the value.

Input is processed in the browser. Refreshing returns a sample value.

Result

Instructions and example

Deduct issues from oldest receipts and sum consumed quantity×layer cost. Unit costs use exact integer hundredths with 2 decimal places.

Receive 10 at cost 2 and 5 at cost 3, then issue 12: issued cost is 26 and 3 remain with cost 9.

Up to 500 transactions, integer quantities 1–1,000,000 and costs 0–1,000,000 with 2 decimal places. A cost-flow model excluding negative stock, returns, tax, FX and write-downs.

Frequently asked questions

What happens when a FIFO issue exceeds stock?

The entire calculation is rejected at that transaction; future receipts are not borrowed.

Are FIFO receipt costs averaged?

No. Remaining quantity and unit cost stay attached to each receipt row. Use the same currency unit throughout.

Calculation criteria and reference materials

Verification of calculation criteria: · Calculation·verification principles · Report errors