

Jami Gong is how to calculate using fifo a Chartered Professional Account and Financial System Consultant. She holds a Masters Degree in Professional Accounting from the University of New South Wales. Her areas of expertise include accounting system and enterprise resource planning implementations, as well as accounting business process improvement and workflow design. Jami has collaborated with clients large and small in the technology, financial, and post-secondary fields.
Keep up with Michelle’s CPA career — and ultramarathoning endeavors — on LinkedIn. Let’s say on January 1st of the new year, Lee wants to calculate the cost of goods sold in the previous year. So, as you organize your vanity drawers or the space under your sink, be sure to put the older products you have front and center—to ensure you use them first—and send any newer products to the back. For example, when you’re unpacking your latest grocery store haul—be intentional and put that new box of crackers or pasta behind the one you bought on your last trip.
Notice how DIO would increase because of higher inventory and lower COGS, which is precisely what happens when we use the FIFO method during an inflationary period. Using FIFO, the COGS would be $1,100 ($5 per unit for the original 100 units, plus 50 additional units bought for $12) and ending inventory value would be $240 (20 units x $24). Ecommerce merchants can now leverage ShipBob’s WMS (the same one that powers ShipBob’s global fulfillment network) to streamline in-house inventory management and fulfillment. With this level of visibility, you can optimize inventory levels to keep carrying costs at a minimum while avoiding stockouts. If you have items stored in different bins — one with no lot date and one with a lot date — we will always ship the one updated with a lot date first. When you send us a lot item, it will not be sold with other non-lot items, or other lots of the same SKU.
Besides calculating COGS, you can use the FIFO accounting method to calculate the value of your remaining (unsold) inventory, also known as inventory valuation. In that case, you’ll multiply what you have left by the most recent price you paid your suppliers. While FIFO refers to first in, first out, LIFO stands for last in, first out. This method is FIFO flipped around, assuming that the last inventory purchased is the first to be sold.
So, which inventory figure fixed assets a company starts with when valuing its inventory really does matter. And companies are required by law to state which accounting method they used in their published financials. Under the LIFO method, assuming a period of rising prices, the most expensive items are sold.
Inventory value is then calculated by adding together the unique prices of every inventory unit. FIFO, on the other hand, is the most common inventory valuation method in most countries, accepted by International Financial Reporting Standards Foundation (IRFS) regulations. Under FIFO, the brand assumes the 100 mugs sold come from the original batch. Because the brand is using the COGS of $5, rather than $8, they are able to represent higher profits on their balance sheet. A higher inventory valuation can improve a brand’s balance sheets and minimize its inventory write-offs, so using FIFO can really benefit a business financially.