FIFO Calculator for Inventory

Your details

Number of units in your first (oldest) purchase.
Cost per unit for your first purchase batch.
USD
Number of units in your second purchase (leave at 0 if unused).
Cost per unit for your second purchase batch.
USD
Number of units in your third purchase (leave at 0 if unused).
Cost per unit for your third purchase batch.
USD
Number of units in your fourth purchase (leave at 0 if unused).
Cost per unit for your fourth purchase batch.
USD
Number of units in your fifth purchase (leave at 0 if unused).
Cost per unit for your fifth purchase batch.
USD
Total units sold during the period.
Average selling price per unit. Used to calculate revenue and gross profit. Leave at 0 to skip.
USD
Cost of Goods Sold (COGS)
1,240USD

Total cost of inventory consumed under FIFO

Ending Inventory Value720USD
Ending Inventory Units60
Total Units Purchased180
Total Purchase Cost1,960USD
Revenue2,160USD
Gross Profit920USD
Gross Margin42.6%
Avg Cost Per Unit Sold10.3333USD
COGS1,240
Ending Inventory720

FIFO COGS: $1240.00

  • Your FIFO COGS is $1240.00, representing 63.3% of your total purchase cost.
  • Ending inventory is 60 units valued at $720.00.
  • Your gross margin is 42.6%, which is strong for most product categories.
  • You sold 66.7% of your total purchased inventory this period.

Next stepCompare your gross margin to industry benchmarks. Retail typically targets 30-50%; wholesale 15-30%.

 = Powered by OnlyCalculators