FIFO Ending Inventory And COGS Calculator

Cost actual FIFO issues across all oldest-first layers and reconcile remaining cost inventory; unlike existing oldest-layer quantity tracker, this allocates multiple cost layers and rejects stockout. One issue after these receipts, not a chronological perpetual ledger.

Description

FIFO issue costing consumes oldest receipts first and preserves later-layer inventory.

FIFO issue costing consumes oldest receipts first and preserves later-layer inventory. This tool applies one issue after the supplied layers.^[1]

The returned values include Issued cost minor, Ending inventory minor, Remaining layer units. The How section below explains the calculation, input rules and interpretation.

When to use FIFO Ending Inventory And COGS Calculator

Use FIFO Ending Inventory And COGS Calculator when you need to evaluate the supplied records under the calculation and evidence rules below. No stockout, chronological purchase/issue ledger or moving-average substitution is supported.

Gather the source balances and explicit accounting policy. Monetary inputs use integer minor units in one currency; for a currency with 100 minor units per major unit, 12345 represents 123.45. One basis point is 0.01 percentage points; 10000 basis points is 100%. Dates and posting signs follow the individual rules below.

How to use FIFO Ending Inventory And COGS Calculator and understand its results

Gather the source balances and explicit accounting policy. Monetary inputs use integer minor units in one currency; for a currency with 100 minor units per major unit, 12345 represents 123.45. One basis point is 0.01 percentage points; 10000 basis points is 100%. Dates and posting signs follow the individual rules below.
Enter oldestFirstLayerUnits, layerUnitCostsMinor, unitsIssued using the field table and calculation rules, then run the tool.
Read issuedCostMinor, endingInventoryMinor, remainingLayerUnits. The explanation below defines the units, signs, ordering and any flags or placeholder values.
If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.

Input field	Meaning	Value type; see rules below	Requirement
oldestFirstLayerUnits	Oldest first layer units	list of number	Required
layerUnitCostsMinor	Layer unit costs minor	list of number	Required
unitsIssued	Units issued	number	Required

Enter aligned nonempty integer layer units 0–1000000 and nonnegative safe-integer unit costs in oldest-first order, plus integer issue units between zero and total stock. Return checked issue cost, ending inventory value and units remaining per layer.

take_i=min(layerUnits_i,issueUnitsRemaining); issuedCost=sum(take_i×unitCost_i)

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output field	Meaning	Value type
issuedCostMinor	Issued cost minor	number
endingInventoryMinor	Ending inventory minor	number
remainingLayerUnits	Remaining layer units	list of number

json

{
  "input": {
    "oldestFirstLayerUnits": [
      5,
      5
    ],
    "layerUnitCostsMinor": [
      10,
      20
    ],
    "unitsIssued": 7
  },
  "output": {
    "issuedCostMinor": 90,
    "endingInventoryMinor": 60,
    "remainingLayerUnits": [
      0,
      3
    ]
  }
}

Limitations and assumptions

No stockout, chronological purchase/issue ledger or moving-average substitution is supported.

Numeric inputs, where present, must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Numeric lists are limited to 10,000 entries and string lists to 128 entries of at most 128 characters. Follow any smaller limits above. Missing fields without a declared default, extra fields, wrong value types and violations of the calculation rules are input errors.

Alternative or Complementary methods

Use Moving Average Cost After Purchase Update Calculator: Perpetual moving-average inventory updates average cost after each purchase and allocates that pooled cost to issues. Event order affects issue costs. For a complementary task, use NRV Lower Of Cost NRV Inventory Test Tool: Net realizable value subtracts completion and selling costs from expected selling price. Inventory carrying value uses lower cost or NRV with a zero floor.

References

FIFO Ending Inventory And COGS Calculator — tool.io

Similar or alternative tools

Moving Average Cost After Purchase Update Calculator
Perpetual moving-average inventory updates average cost after each purchase and allocates that pooled cost to issues. Event order affects issue costs.
NRV Lower Of Cost NRV Inventory Test Tool
Net realizable value subtracts completion and selling costs from expected selling price. Inventory carrying value uses lower cost or NRV with a zero floor.