What a cost guide is, and why it beats a spreadsheet

A cost guide is one place that answers a single question for every ingredient you buy: what does this cost me right now? Not what it cost last quarter, not what the menu assumes, not roughly — the current, real number, in a unit you can actually cook from.

Most kitchens already have a version of this. It's a spreadsheet tab called prices, last touched eight months ago, with three columns that mean slightly different things depending on who filled them in. It works until the day you need to re-price a menu and realize you can't trust a single row. A proper cost guide fixes the two things that spreadsheet always gets wrong: units and freshness.

What belongs in a cost guide

For each ingredient, a good cost guide records:

• A clear item name — the name you'd recognize on an invoice (“Chicken Breast, Boneless 4oz”), not a vague one (“chicken”).
• One or more price/unit pairs. The same item is often bought and measured in different ways: a case, a pound, an each. Each way it matters to you is its own line — a price and the unit that price is for.
• The vendor each price came from, so a number is always traceable back to a real quote or invoice.
• An optional recipe label — a short alias (“tomatoes”) that lets a recipe ingredient match this item even when the invoice name is a mouthful.

That's it. No yield percentages, no recipe math, no menu prices — those live downstream. The cost guide is just the ground truth about purchase costs, kept narrow on purpose so it's easy to keep correct.

Why the unit problem matters so much

Say you pay $76 for a 40 lb case of an ingredient, and a recipe calls for 6 oz of it. To cost that line you need $76 ÷ 40 ÷ 16 = $0.11875 per oz, then × 6 = $0.71. Do that by hand across a 12-ingredient recipe and you will make an arithmetic error. Do it once in a spreadsheet and never revisit it, and the error becomes permanent — baked into a menu price you defend to a manager.

A cost guide stores the case price and the per-pound price as separate, explicit lines. When a recipe needs ounces, the conversion happens automatically from whichever line is in a compatible unit. You enter what the invoice says; the math is not your job.

Why freshness matters more than completeness

A cost guide with 60 current items beats one with 300 stale ones. Prices move — produce seasonally, proteins constantly, dry goods in quiet 4–8% steps you never notice until a distributor consolidates three increases into one invoice. If your guide reflects last year, every food cost percentage you calculate from it is fiction.

The practical rule: keep the guide small enough that updating it after a delivery takes five minutes, not an afternoon. Track the 40–80 ingredients that actually drive your food cost. Everything else can be estimated or added later when it earns its place.

What a cost guide unlocks

Once the guide is current, the things that were previously guesswork become lookups:

• Recipe costing. Every recipe reads its ingredient costs from the guide, so a single price change updates every dish that uses it. See turning a cost guide into recipe costs.
• Vendor comparison. With two vendors' prices side by side on the same item, “who's cheaper” stops being a vibe. See tracking the same item across vendors.
• Menu decisions. A 20‑cent increase on an item in nine dishes is a menu conversation; the guide is what surfaces it.

You can build all of this in the free tools without an account — your cost guide is saved in your browser, and you export a backup whenever you want a copy.