Overview
This FIFO calculator is used to determine the value of a company's inventory and cost of goods sold after a sales period using the first-in-first-out method (FIFO). The FIFO method is one of several common inventory valuation methods such as the last-in-first-out (LIFO) and weighted average cost methods.
This calculator uses four inputs: number of units sold, purchase date of units, number of units purchased, and price per unit purchased. With these inputs, the FIFO calculator is able to return the cost of goods sold based on the schedule of purchased goods provided.
As shown by the name of this method, the FIFO method assumes that the first inventory items purchased are also the ones that are sold first. Many stores operate with this inventory assumption but this is most prominent with stores that sell perishable goods. A grocery store is one of the most practical examples of the FIFO method.
Using this grocery store example we can take a look at a schedule of orange purchases:
- May 8, 2019: 100 oranges purchased at $1.15/orange
- May 9, 2019: 100 oranges purchased at $1.35/orange
- May 10, 2019: 100 oranges purchased at $1.10/orange
- May 8, 2019: 100 oranges sold at $1.15/orange = $115 in COGS
- May 9, 2019: 100 oranges sold at $1.35/orange = $135 in COGS
- May 10, 2019: 30 oranges sold at $1.10/orange = $33 in COGS
Tags
Share
Reviews Add a review
No reviews yet