Food Cost Calculator PRO: dish costing, food cost and prices (Excel + HTML)

Food Cost Calculator PRO: dish costing, food cost and prices (Excel + HTML)

19% FOOD COST INSTEAD OF 35% — AND THE MENU MAKES MONEY

Dish costing, food cost and pricing for cafes, restaurants and canteens. The database holds 34 dishes with recipe cards and 55 ingredients at Russian purchase prices (September 2026). Change a supplier price and the cost, food cost, margin and recommended price recalculate across the whole file. Two files — one model: an Excel workbook with live formulas and an offline HTML calculator.

WHAT´S INSIDE:
• foodcalc-pro.xlsx, 5 sheets: «Сырьё» (price list) → «Техкарты» (recipe cards, prices pulled by VLOOKUP) → «Калькуляция» (cost, food cost, margin, markup, dish class) → «Наценка» (price at 25/30/35% food cost) → «Сводка» (the menu´s key numbers)
• foodcalc-pro.html: the same calculation offline in a browser — edit prices and recipes right in the table, expand recipe cards with a click, CSV export, dark theme, state saved automatically
• Recommended price = cost × 100 / target food cost — fit your concept (25% premium, 30% standard, 35% discounting)
• Menu engineering matrix: Star / Cash Cow / Puzzle / Dog — what to grow, what to drop

WHAT IT COMPUTES:
• Dish cost from the recipe card: the database yields 13 610 ₽ revenue at 2 601.61 ₽ cost — average menu food cost 19.12%
• Food cost per dish: from 2.28% (tea) to 27.82% (borscht) — shows instantly where you give food away
• Total menu margin 11 008.39 ₽; the median margin per dish is the classification threshold

FOR WHOM:
• Chef and sous-chef: a price justified by the recipe card, not “like the place next door”
• Owner and manager: where the menu loses money, which dishes drag it down
• Changing concept or supplier: what happens to food cost at new prices — in a minute

VERIFIED BEFORE SALE:
• 331 SELFTESTS: 23 database checks + 99 Excel-formula checks by a real formula engine + 209 checks of the JS logic taken out of the finished HTML file
• EXCEL↔HTML PARITY TO THE KOPECK: cost, food cost, margin, markup, recommended price and dish class — the same number everywhere
• Rounding to the kopec, halves up — identical in Excel, Python and JS
• Every number on the screenshots comes from the same database you receive — nothing is drawn in

SEE ALSO:
• Cafe & restaurant financial model — revenue, food cost, break-even: plati.market/itm/6095539
• Break-even point for small business — Excel calculator: plati.market/itm/6174550

Guarantee: replacement or refund. Files are delivered automatically right after payment.