Ask most home bakers what their flour costs and they’ll tell you the pack price. Ask what the flour in one cake costs, and there’s a pause. That gap — between what you paid and what a recipe uses — is where profit quietly disappears. Here’s how to close it for good.
Stop thinking in packs. Think in base units.
A pack price is useless for costing until you break it down to a base unit: pesos per gram, per millilitre, or per piece. That’s the number you multiply by what a recipe actually uses.
- Flour: ₱65 for 1 kg → ₱0.065 / g
- Butter: ₱180 for 225 g → ₱0.80 / g
- Eggs: ₱225 for a tray of 30 → ₱7.50 / piece
Once every ingredient has a per-base-unit cost, any recipe costs itself: multiply, add up, done. This one shift is what separates a real costing system from a guess.
The price you paid last month isn’t today’s cost
Prices move. You bought butter at ₱170 in March and ₱190 in July — so what’s “the” cost? The honest answer is a weighted average of what’s actually in your stockroom, not just the latest receipt.
Weighted average cost = (total pesos spent on the stock you still have) ÷ (total base units you still have).
Restock at a new price, and the average shifts toward it — smoothly, the way your real costs actually behave.
Why bother? Because pricing off only your latest receipt makes your costs jump around, and pricing off your oldest one flatters your margin until reality catches up. A weighted average is the number that keeps your recipe costs steady and true.
The spreadsheet method (and where it breaks)
You can absolutely start in a spreadsheet. One sheet for ingredients — name, latest pack, per-base cost — and one sheet per recipe that references it:
| Ingredient | Pack | ₱/base |
|---|---|---|
| Cake flour | ₱65 / 1000 g | ₱0.065 / g |
| Butter | ₱180 / 225 g | ₱0.80 / g |
| Sugar | ₱78 / 1000 g | ₱0.078 / g |
This works — until it doesn’t. The moment butter’s price changes, you have to update it everywhere and re-check every recipe that uses it. With 20 ingredients and 15 recipes, that’s an evening you don’t have. And spreadsheets don’t do weighted averaging on their own, so most bakers just overwrite the old price and lose the history.
Watch the creep, or lose margin silently
The real danger isn’t a single price change — it’s the slow creep you don’t notice. Butter up ₱20, cream up ₱15, ube up ₱30, all over a few months. No single jump feels worth a reprice, but together they can erase your margin. The only defense is a record: log what you pay each time you restock, and you can actually see the trend instead of feeling vaguely poorer.
- Log every purchase: ingredient, pack size, price, date.
- Let the per-base cost re-average automatically on each restock.
- Review your steepest risers every few weeks and reprice the recipes they hit hardest.
OvenSync logs every purchase, keeps a weighted-average cost per ingredient, re-costs your recipes the instant a price changes, and flags when an ingredient is creeping up. Start free → — 30-day Baker trial, no card.
The habit that makes it stick
None of this matters if you don’t keep it current. Build one small habit: log your prices the moment you unpack the groceries, before the receipt disappears into your bag. Five minutes after each palengke run, and your recipe costs — and every price you quote — stay honest all month.