Inventory Method Calculator

Publish date: 2024-05-08
Image to Crop Given the inputs you entered, calculate the First In, First Out (FIFO) accounting items
TimePurchase or SaleUnitsCostTotal = Cost x Units
1P6015$900.00
2P14015.50$2,170.00
3S19019$3,610.00
4P7016$1,120.00
5S3019.50$585.00

Calculate Unit Items:

Units available for sale = 60 + 140 + 70 = 270
Units sold = 190 + 30 = 220
Units in Ending Inventory = 270 - 220 = 50

Calculate Ending Inventory (last Cost Entry):

Ending Inventory = 50 units x $16.00 cost = $800.00


How does the Inventory Method Calculator work?

Free Inventory Method Calculator - Takes accounting entries using the FIFO (first in first out) and LIFO (last in first out) inventory methods.
This calculator has 1 input.

What 3 formulas are used for the Inventory Method Calculator?

Units in Ending Inventory = Units available for sale - Units Sold
Ending Inventory (LIFO) = Units in Ending Inventory * Last Cost Entry
Ending Inventory (FIFO) = Units in Ending Inventory * First Cost Entry

For more math formulas, check out our Formula Dossier

What 4 concepts are covered in the Inventory Method Calculator?

FIFOFirst In, First Out is an accounting method in which assets purchased or acquired first are disposed of firstLIFOLast In, Last Out is an accounting method in which assets purchased or acquired lasst are disposed of firstcostan amount that has to be paid or spent to buy or obtain somethinginventorya complete list of items such as property, goods in stock, or the contents of a building

Tags:

Add This Calculator To Your Website

ncG1vNJzZmivp6x7rq3ToZqepJWXv6rA2GeaqKVfnru3sc2tpquxj6KytbTOnWWpoKB0uqLA0aKvanWAWn%2BEgo9eaXxpZVp9hXGPeodeanNmgXFxkXxobmZlZXJxkIRpeIxdYnh%2BenyEa3pqcVVlkWZ8oIlca3tnZXJzj5BvXGl8VWWOlHGRfGppXWJ4fnp6lGlcaXxVZY5nvMt2fYJ%2Bfw%3D%3D