FIFO Calculator for Inventory
FIFO Inventory Calculator
Value cost of goods sold, ending inventory, revenue, and gross margin by consuming the oldest purchase layers first.
Inventory purchases and sale
Enter purchase batches from oldest to newest. FIFO assigns the earliest costs to sales first.
Purchase layers
Live FIFO results
All outputs update as you edit the layers or sales assumptions.
150 units are assigned to the oldest purchase costs.
Inventory value allocation
The original inventory value is split between FIFO COGS and the value still on hand.
| Category | Amount | Share |
|---|
FIFO layer consumption
Each row shows how much of a purchase batch is assigned to COGS and how much remains in ending inventory.
| Batch | Units purchased | Unit cost | Layer value | Units sold | COGS used | Units remaining | Ending value |
|---|
What does this FIFO inventory calculator estimate?
This calculator applies the first-in, first-out cost-flow assumption to a sequence of inventory purchases. It estimates the FIFO cost of goods sold (COGS), the value and quantity of ending inventory, sales revenue, gross profit, gross margin, and the average cost assigned to units sold. FIFO assumes the oldest purchase costs leave inventory first, even when the physical flow of goods is not tracked unit by unit.
The calculation is useful for planning, management reporting, and checking a layer-based inventory schedule. It is not a substitute for an accounting system, a physical inventory count, or professional advice about the method permitted for a specific tax return or financial-reporting framework.
How should each input be used?
Purchase batches
Enter batches in chronological order, with the oldest purchase first. Each batch requires a quantity and a unit cost. Quantity is the number of units acquired in that layer. Unit cost is the acquisition or production cost assigned to one unit before it is sold. Both values should be zero or positive. Higher quantities increase available inventory; higher unit costs increase the value of that layer and may raise COGS when the layer is consumed.
Use the add-batch control when inventory was purchased at more than two prices. A batch can be removed when it is not part of the scenario. Common errors include reversing the chronological order, entering a total layer cost instead of a per-unit cost, mixing currencies, or combining batches that should remain separate because their unit costs differ.
Total units sold
This required field is the quantity issued or sold during the period. The calculator starts with the oldest batch and continues into later batches until the entered quantity is covered. If units sold exceed units available, the preview caps the cost assignment at available inventory and displays a warning. That treatment prevents a negative inventory balance, but an accounting record should separately address stockouts, timing differences, returns, or missing purchase layers.
Selling price per unit
The selling price is optional for COGS and ending-inventory valuation, because those outputs depend on purchase costs rather than sales price. It is required for revenue, gross profit, and gross margin. Enter the average realized selling price per unit for a simple scenario. Discounts, returns, sales taxes, freight billed to customers, and multiple selling prices may require a more detailed revenue schedule.
How are FIFO COGS and ending inventory calculated?
Layer value = units purchased × unit cost
FIFO COGS = sum of oldest layer costs consumed
Ending inventory = total layer value − FIFO COGS
Suppose 100 units are purchased at $10 and 110 more units are purchased later at $15. Selling 150 units consumes all 100 units from the first layer and 50 units from the second layer. FIFO COGS is therefore $1,000 plus $750, or $1,750. The remaining 60 units belong to the newer $15 layer, so ending inventory is $900.
The initial inventory value should always equal FIFO COGS plus ending inventory. The layer table makes this cross-check visible. For every batch, units sold plus units remaining should equal units purchased, and COGS used plus ending value should equal the layer value.
How should the results be interpreted?
FIFO COGS is the cost attached to the units sold. A higher value reduces gross profit when revenue is unchanged. Ending inventory is the cost assigned to unsold units and remains on the balance sheet until those units are sold or otherwise written down. Initial inventory value is the value of all entered purchase layers before the modeled sale.
Revenue equals units sold multiplied by selling price. Gross profit equals revenue minus FIFO COGS; a negative value means the modeled sales price does not cover the FIFO cost assigned to the sale. Gross margin expresses gross profit as a percentage of revenue. A zero revenue produces a neutral 0% margin rather than a division error. Average FIFO cost sold is COGS divided by units sold and can help compare cost trends with pricing.
The allocation chart uses the same values as the results and table. Its COGS segment shows the share of original inventory cost transferred to expense, while the ending-inventory segment shows the share still capitalized in stock. After a reset or an all-zero scenario, the chart is replaced by a compact empty state rather than displaying a misleading ring.
Why can FIFO change margins and financial ratios?
When purchase prices rise, FIFO generally assigns older, lower costs to COGS first and leaves newer, higher costs in ending inventory. Compared with a method that uses more recent costs first, that pattern can produce lower COGS, higher gross profit, and a higher ending-inventory balance. Falling prices can reverse the direction. The effect is mechanical: it comes from the order in which cost layers are consumed.
Because inventory and COGS feed multiple statements, the choice of method can affect inventory turnover, current assets, gross margin, and other ratios. For U.S. federal tax context, review the IRS guidance on accounting periods and methods. For international financial reporting, consult IAS 2 Inventories. U.S. public-company filings and accounting disclosures can also be researched through the SEC EDGAR database.
What are the main benefits and common mistakes?
FIFO is easy to follow, often resembles the physical movement of perishable or dated products, and leaves recent costs in ending inventory. The tradeoff is that in a period of rising costs, current revenue may be matched with older costs, so reported margin may not reflect the replacement cost of inventory. Management may therefore review both accounting margin and current purchasing economics.
- Keep purchase layers in true chronological order.
- Use consistent units and currency across every batch.
- Do not enter total purchase value in the unit-cost field.
- Investigate sales quantities that exceed recorded inventory.
- Reconcile the ending quantity to a physical count and the ending value to the general ledger.
- Export the current scenario to Excel when a reviewable audit trail or layer schedule is needed.