What is yield loss and why does it matter for COGS?

Yield loss is the reduction in quantity or weight of raw materials during processing, such as moisture loss, trimming, or spoilage. If you start with 1,000 lbs of ingredients and yield 850 lbs of finished product, your true cost per unit is based on 1,000 lbs of input, not 850. Ignoring yield loss systematically understates COGS and overstates margins.

How do I calculate COGS for a food brand with multiple co-packers?

For each co-packer, you need to capture their per-unit conversion cost (toll fee), any yield loss they introduce, and any packaging materials they source on your behalf. True COGS per SKU = raw material cost (adjusted for yield) + co-packer conversion fee + packaging + inbound freight + allocated overhead. The challenge is that co-packers rarely give you lot-level yield data automatically, you have to build that into your production reporting workflow.

What is the difference between standard cost and actual cost for CPG brands?

Standard cost is a predetermined estimate of what a unit should cost based on expected ingredient prices and yields. Actual cost is what you really paid, adjusted for real yield and real purchase prices. The gap between them is called a cost variance. Most early-stage food brands run on standard costs in spreadsheets and only discover variances at month-end, which is too late to act on them.

How often should a CPG brand update its COGS calculations?

Ideally, COGS should update continuously as purchase orders are received and production batches are completed. At minimum, recalculate COGS whenever a supplier price changes, a new production run completes, or a new lot of ingredients is received. Waiting until month-end means you are making pricing and purchasing decisions on stale data.

What hidden costs do food brands most often miss in COGS?

The most commonly missed costs are: yield loss (especially moisture loss in baking and trimming in produce), inbound freight and broker fees on ingredients, co-packer setup and changeover fees, rework and repack labor, and quality testing costs. Organic brands also frequently miss the cost of maintaining mass balance documentation, which has real labor overhead.

How to Get Off Spreadsheets: The CPG Operations Guide

The Spreadsheet Breaking Point

There is no shame in running a $2M food brand on Google Sheets. Spreadsheets are flexible, free, and everyone knows how to use them. But there is a specific revenue threshold—usually between $3M and $5M—where spreadsheets stop being a tool and start becoming a liability.

You hit the breaking point when:

Your operations manager spends three days at month-end reconciling inventory.
A retailer asks for a mock recall, and it takes you 8 hours to trace a lot code across three different tabs.
You run out of a critical packaging component because the "Projected Depletion" formula in cell G42 was accidentally overwritten.
Your true landed COGS are a mystery until the accountant closes the books 20 days after the month ends.

Phase 1: Data Clean-Up (Before You Buy Software)

The biggest mistake brands make is buying an ERP or operations platform and trying to dump messy spreadsheet data directly into it. Software does not fix bad data; it just makes bad data process faster.

Before you migrate, you must standardize three things:

1. SKU Naming Conventions

"Glass Bottle 12oz" is not a SKU. PKG-BTL-GLS-12OZ-V1 is a SKU. Every ingredient, packaging component, and finished good needs a unique, standardized identifier that makes sense to a computer.

2. Unit of Measure (UOM) Conversions

You buy flour in 50lb bags. You formulate recipes in grams. You store it on pallets. Map out the exact conversion rates for every item in your inventory. Software requires explicit mathematical relationships between purchasing UOM, stocking UOM, and consumption UOM.

3. Master Bill of Materials (BOM)

Ensure your BOMs reflect reality, not just the theoretical recipe. If a batch always requires 2% more salt than the recipe states due to machine calibration, the BOM needs to reflect that 2% overage.

Phase 2: Choosing the Right System

You do not need a $100,000 enterprise ERP like NetSuite. But you also cannot survive on a basic e-commerce inventory app that doesn't understand batch manufacturing or lot expiry.

Look for a system built specifically for food and beverage operations. It must natively handle:

Bi-directional lot traceability (FSMA 204 compliance)
Expiration date tracking and FEFO (First Expired, First Out) allocation
Yield variance tracking for co-packer production runs
Landed COGS calculations including freight and tolling

Platforms like Guidance are designed specifically to bridge the gap between spreadsheets and enterprise ERPs for scaling CPG brands.