How To Calculate COGS In Retail: FIFO, LIFO, Weighted Average, And Practical Steps

Cost of Goods Sold (COGS) The direct costs assigned to products sold, commonly including manufacturing and product costs under the company's accounting policies.

Calculating COGS requires an inventory valuation method and reliable beginning/ending inventory data. Common methods are FIFO (first-in, first-out), LIFO (last-in, first-out), and weighted-average. The choice affects reported profit, tax position, and inventory carrying value. Retailers must select a method, apply it consistently, and disclose changes as required by accounting standards.

Periodic Versus Perpetual Systems

Under a periodic system, COGS is calculated at the end of the accounting period using a physical count to determine ending inventory. Under a perpetual system, inventory and COGS are updated continuously at each purchase and sale using the chosen costing method. Most modern retailers use perpetual systems linked to POS/WMS to get near-real-time COGS and inventory visibility.

FIFO (First-In, First-Out)

FIFO assumes the earliest purchased items are sold first. In rising-cost environments, FIFO results in lower COGS and higher ending inventory values, producing higher gross profit and taxable income compared to LIFO. FIFO is straightforward to implement in perpetual systems and aligns with the physical flow of many retail products with shelf lives.

LIFO (Last-In, First-Out)

LIFO assumes the most recently purchased items are sold first. LIFO typically raises COGS and lowers reported profit during inflationary periods, producing tax deferral benefits. U.S. GAAP permits LIFO, but IFRS does not; retailers that sell internationally or adopt IFRS must avoid LIFO. LIFO also requires consistent application across tax and financial reporting under the U.S. LIFO conformity rules.

Weighted Average Cost

The weighted-average method averages the cost of all units available for sale during the period. It smooths the effects of price volatility and is easy to apply in a perpetual system that recalculates the average after each purchase. Weighted average is commonly used for large volumes of indistinguishable units (for example, bulk commodities or plug-and-play SKUs).

Simple Numerical Example

Assume a retailer purchases 100 units at $10, then 100 units at $12 during the month. The retailer sells 150 units. Under FIFO, the first 150 units are 100×$10 + 50×$12 = $1,600 COGS. Under LIFO, the first 150 units are 100×$12 + 50×$10 = $1,700 COGS. Under weighted average, average unit cost = (($10×100)+($12×100))/200 = $11; COGS = 150×$11 = $1,650.

Which Method Should Retailers Choose?

Choice depends on tax strategy, inventory turnover, product characteristics, and regulatory environment. FIFO is common for perishables and fashion where older stock is sold first. LIFO can be attractive under U.S. tax law during inflation but is not allowed under IFRS and can complicate supply-chain costing. Weighted average is useful for homogeneous, high-volume goods.

Operational Steps To Calculate COGS Accurately

• Define Policy: Document the chosen costing method and treatment of direct costs (freight-in, duties, package) in the accounting manual.
• Integrate Systems: Ensure purchases, receipts, transfers, and sales post to the same SKU cost ledger in your ERP/WMS.
• Perform Regular Counts: Use cycle counts and periodic physical inventories to reconcile system balances and catch shrinkage.
• Allocate Overhead Carefully: For private-label or manufacturing, create a defensible overhead allocation method for manufacturing overhead that is capitalized into inventory.

Tax, Reporting, And Disclosure

Changing inventory methods requires disclosure and may need IRS approval for tax purposes. Public companies must disclose their inventory costing method and any changes in footnotes to financial statements. Retail managers should work with finance to evaluate the profit, tax, and operational impacts of a method change before implementing it.

Practical Tips For Retailers

• Simulate Impacts: Run parallel accounting (trial runs) to compare FIFO/LIFO/average effects on profit and tax estimates before committing to a change.
• SKU-Level Costs: Maintain per-SKU landed cost (purchase + freight-in + duties) to keep COGS accurate when sales happen.
• Monitor Price Trends: In inflationary periods, evaluate whether LIFO (U.S. retailers) is beneficial; also weigh the disclosure and complexity costs.

In short, the Cost of Goods Sold (COGS) is calculated using an inventory valuation method (FIFO, LIFO, or weighted average) together with beginning and ending inventory. The method chosen affects gross profit, inventory balances, and tax outcomes; retailers should document policy, integrate systems, and consult accounting advisors when making changes.