Inventory Valuation for CPG: FIFO, LIFO, and Weighted Average
How much is the inventory sitting in your 3PL worth? The answer depends entirely on your inventory valuation method. The accounting method you choose to value your inventory directly impacts your Cost of Goods Sold (COGS), your gross margin, and ultimately, your corporate tax liability.
For food brands dealing with volatile commodity prices and perishable goods, choosing the right valuation method is a critical financial decision.
1. First-In, First-Out (FIFO)
FIFO assumes that the first items placed in inventory are the first ones sold. In the food industry, this perfectly matches the physical flow of goods, you always ship the oldest product first to avoid spoilage (FEFO).
Financial Impact: In an inflationary environment (where ingredient prices are rising), FIFO results in the lowest COGS because you are matching your oldest, cheapest inventory against your current sales. Lower COGS means higher gross margins and higher net income, which looks great to investors but results in higher tax liabilities.
2. Last-In, First-Out (LIFO)
LIFO assumes that the most recently purchased items are the first ones sold. While this makes zero sense for the physical movement of perishable food, the IRS allows it for accounting purposes.
Financial Impact: When prices are rising, LIFO matches your newest, most expensive inventory against current sales. This results in higher COGS, lower net income, and consequently, a lower tax bill. However, LIFO is complex to manage and is prohibited by International Financial Reporting Standards (IFRS), making it a poor choice if you plan to expand globally or sell to an international conglomerate.
3. Standard Costing
Standard costing assigns a predetermined, estimated cost to your inventory based on historical data and expected future costs. If you estimate organic flour will cost $1.00/lb this year, you value all flour inventory at $1.00/lb, regardless of what you actually paid.
Financial Impact: Standard costing makes budgeting easy, but it requires you to calculate "variances" at the end of the month (the difference between the standard cost and the actual cost). In volatile food commodity markets, these variances can become massive, hiding your true margins until the end-of-month reconciliation.
4. Moving Average (Weighted Average) Cost
Moving Average recalculates the cost of your inventory every time a new purchase order is received. If you have 1,000 units valued at $10, and you buy 1,000 more units at $12, your new moving average cost for all 2,000 units is $11.
Financial Impact: Moving average smooths out price volatility. It prevents a single expensive purchase order from violently swinging your COGS in one month. It provides a highly accurate, real-time view of your margins.
Why Modern Brands Choose Moving Average
For scaling CPG brands, Moving Average (often combined with FIFO tracking for physical lot expiry) is generally the most accurate method. It requires sophisticated operations software to recalculate costs dynamically with every receipt and production run, but it provides the most realistic picture of your profitability in a volatile market.
Frequently Asked Questions
Can I change my inventory valuation method?
Yes, but changing your valuation method (e.g., from LIFO to FIFO) requires filing Form 3115 with the IRS to request a change in accounting method. It is not a decision to be made lightly and requires CPA guidance.
Does QuickBooks support Moving Average costing?
QuickBooks Desktop supports Average Costing. QuickBooks Online Advanced supports FIFO. Managing true moving average costs with landed freight allocations typically requires a dedicated inventory operations platform integrated with your accounting software.
What is the difference between FIFO and FEFO?
FIFO (First-In, First-Out) is an accounting and inventory method based on the date of receipt. FEFO (First-Expired, First-Out) is a physical inventory routing method based on the expiration date of the lot. Food brands must physically ship FEFO to prevent spoilage.
Help shape the commercial release.
A working prototype validated Guidance's core operating model. The commercial rebuild is translating that proof into production-ready workflows with CPG design partners.
Apply as Design Partner →Related Reading
Cycle Counts, Reconciliation, and Adjustment Workflow
Set a repeatable cycle count cadence and tie it to SKU value and velocity. Use ABC classification: A items (top 70% of inventory value) count weekly or biweekly, B items monthly, C items quarterly. When physical count differs from book inventory calculate the adjustment as Adjustment = Physical Quantity - Book Quantity. Convert to dollars at your current unit cost to determine the balance sheet impact. Establish a materiality threshold, for example 0.5% of total inventory value, above which counts trigger root cause analysis and corrective actions.
Operationalize the adjustment with a documented journal entry workflow: post the inventory variance journal, tag it to a cause code (shrinkage, miscount, pricing error), and link supporting 3PL paperwork or count sheets. If a count reveals recurring issues, update safety stock, lead time, or ASN procedures. Track count variance by SKU over time and set KPI targets, for example reduce A-item variance to under 0.25% month over month.
Accounting for Spoilage, Shrinkage, and Customer Returns
Build explicit processes for perishable spoilage and inventory shrinkage. Rather than ad hoc write-offs, maintain an inventory reserve account. Calculate a monthly reserve using Reserve = Opening Inventory Value * Expected Spoilage Rate. For example, on $200,000 opening inventory and a 1% expected spoilage rate book a reserve of $2,000. Monthly adjusting entries are Dr. Spoilage Expense and Cr. Inventory Reserve. When actual spoilage occurs reverse the reserve against inventory so the net expense reflects the estimate variance.
Customer returns need a clear disposition policy. If returns are restockable, capture return cost at the original unit cost and reinstate inventory using a restock journal. If returns are unsellable mark them to spoilage and dispose with supporting photos and disposal logs. Track return rates by SKU and set trigger points, for example investigate SKUs with return rates above 5% or when return costs exceed 0.5% of monthly revenue.
3PL and Co-Packer Inventory Ownership, Reporting, and Landed Cost
Clarify legal ownership and invoicing timing with each 3PL and co-packer. Ownership often transfers on shipment, receipt at 3PL, or on completion of co-pack runs. Define this in contracts and align ERP posting rules so inventory appears on your balance sheet at the agreed point. Require daily or weekly inventory reports from 3PLs with SKU-level on-hand, receipts, and shipments. Reconcile 3PL reports to your ERP using a three-way match: ERP book, 3PL count, and ASN or invoice.
Include co-pack fees, packaging, inbound freight, and duties in your landed cost calculation. Use the formula Landed Cost per Unit = (Raw Materials + Co-pack Fee + Packaging + Freight + Duties) / Units Produced. Example: raw materials $2,500, co-pack fee $1,200, packaging $300, freight $200 for a 1,000 unit run gives landed cost = (2,500+1,200+300+200)/1,000 = $4.20 per unit. Store landed cost by lot when possible so COGS reflects true economics of each production run.
Using Inventory Valuation to Set Prices and Evaluate Promotions
Translate your unit cost into actionable pricing using Gross Margin Percent = (Selling Price - Unit COGS) / Selling Price. If your COGS per unit is $3.50 and your target gross margin is 40% the minimum selling price to hit target is Price = COGS / (1 - Target Margin) = 3.50 / 0.6 = $5.83. When planning promotions, reverse engineer the required baseline price to support a discount. For a 20% off promotion to still meet the target margin you need baseline = 5.83 / 0.8 = $7.29.
Use your valuation method to model promo scenarios across inventory lots. If a discount will liquidate older, higher-cost lots, calculate blended COGS post-promo = (Sum of Lot Cost Values + Lot Quantities Sold at Discount) / Total Units Sold. Run sensitivity analysis with 3 cases: best-case (current low-cost lots sold), mid-case (blended lots), worst-case (old high-cost lots sold). Make promo decisions that protect margins and avoid creating forced write-offs or negative gross margins.