Know Your Costs. Protect Your Margins. Make Better Menu Decisions.

Dynamic Excel System for Ingredient Costing, Portion Economics, Price Inflation, Menu Profitability & Menu Engineering.

Take control of restaurant recipe costs, ingredient price changes, portion economics, and menu profitability with a dynamic, multi-sheet Excel costing system. Calculate ingredient costs, track supplier price history, analyze food-cost percentages and contribution margins, evaluate menu performance, and model pricing scenarios using your own restaurant data.

Includes an 18-worksheet Excel workbook, a practical user guide, and setup documentation. No macros required for core calculations.

Understand Your Food Costs. Analyze Your Margins. Manage Your Menu with Confidence.

A restaurant menu can generate impressive sales while individual dishes deliver less contribution than expected. Supplier price increases, inconsistent portion sizes, preparation losses, outdated menu prices, and incomplete recipe costing can all make it difficult to understand the economics behind each dish.

Restaurant Recipe Costing, Plate Margin & Menu Engineering Matrix provides a structured Excel-based system for connecting ingredient purchase costs to recipe economics, menu pricing, sales performance, and cost-control decisions.

Instead of maintaining disconnected spreadsheets for ingredient prices, recipe cards, menu prices, and sales figures, you can use one interconnected workbook to organize your information and evaluate how changes affect your modeled costs and margins.

Enter your own supplier prices, package sizes, ingredient yields, recipes, portion counts, menu prices, and sales records. The workbook then uses linked formulas to help you understand what each portion costs, how much food cost consumes the selling price, and how individual dishes perform against your selected menu-engineering thresholds.

What Can You Analyze?

Ingredient Costing and Edible Yield

Normalize purchase prices into consistent grams, milliliters, or individual units. Distinguish as-purchased (AP) costs from edible-product (EP) costs, and account for verified preparation yields where appropriate.

The conversion framework documents supported units and identifies situations where an ingredient-specific density or other verified conversion is required.

Recipe and Subrecipe Costing

Build ingredient-level recipes and cost prepared components such as sauces, dressings, marinades, stocks, fillings, and other batch-prepared items.

Calculate modeled batch costs and costs per sellable portion using linked ingredient and subrecipe records. Missing inputs can be flagged rather than silently treated as zero-cost ingredients.

Plate Economics and Menu Pricing

Evaluate the relationship between ingredient cost, selling price, and food contribution margin.

Calculate:

• Ingredient cost per portion.

• Food-cost percentage.

• Food contribution margin per portion.

• Contribution after specified additional variable costs.

• Suggested price at a user-defined food-cost target.

• Suggested price at a user-defined contribution-margin target.

• Proposed price changes and their modeled financial effects.

Ingredient Price History and Inflation Alerts

Maintain dated purchase-price records instead of simply overwriting previous prices.

Compare normalized ingredient costs, identify price changes against a selected baseline, flag increases above your configured threshold, and assess how ingredient inflation affects recipe and portion costs.

Four-Quadrant Menu Engineering

Analyze menu-item popularity alongside contribution margin to classify eligible items as:

• Stars: High popularity, high contribution margin.

• Plowhorses: High popularity, relatively low contribution margin.

• Puzzles: Low popularity, high contribution margin.

• Dogs: Low popularity, low contribution margin.

The workbook uses configurable thresholds and flags missing critical inputs instead of automatically assigning a performance category.

These classifications are intended to support investigation and management decisions—not automatically dictate price increases, promotions, or menu removals.

Inventory and Purchasing Controls

Record on-hand inventory, quantities on order, par levels, reorder thresholds, and package sizes.

Calculate indicative reorder quantities and estimated purchasing costs using your entered information. These results support planning but do not replace physical stock verification or supplier confirmation.

Actual vs. Theoretical Food Cost

Compare recorded inventory-based food cost against recipe-based theoretical consumption.

Review dollar and percentage variances, food-cost ratios, and missing reconciliation information. Use the results to investigate possible causes such as portion deviations, incomplete records, inventory-count differences, or purchasing-period errors.

A variance identifies an area for investigation; it does not, by itself, prove why the difference occurred.

Built for Practical Restaurant Operations

This is more than a static recipe-costing template. The workbook connects ingredient, recipe, pricing, sales, inventory, and reporting information in one structured system.

Its calculations are formula-driven, assumptions remain editable, and important costing conventions are documented so operators can review how their results are produced.

What You Receive

Your purchase includes:

1. The Excel Workbook (.xlsx) — 18 interconnected worksheets for costing, menu pricing, sales analysis, price history, inventory controls, reporting, and QA.

2. The User Guide (.docx) — Instructions for configuring and operating the workbook, with worked illustrative guidance.

3. The README (.md) — Product overview, setup sequence, calculation conventions, limitations, troubleshooting, and buyer-license information.

The workbook includes a clearly identified illustrative demonstration case. Replace its example records with verified information from your own restaurant before relying on its outputs for operational decisions.

Who Is This For?

• Restaurant owners and operators.

• Executive chefs and head chefs.

• Kitchen and food-cost managers.

• Restaurant consultants.

• Hospitality business managers.

• Multi-unit restaurant operators.

• Culinary entrepreneurs preparing to standardize recipes and portion costing.

Whether you operate an independent restaurant, manage a professional kitchen, or advise hospitality businesses, this system provides a structured starting point for understanding recipe economics and menu performance.

Make Decisions from Your Own Data

Use the workbook to identify where ingredient costs have changed, evaluate the financial effect of different selling prices, compare modeled contribution margins, and investigate menu items that deserve closer attention.

The objective is not to promise guaranteed savings or higher profits. It is to give you a transparent, repeatable framework for organizing cost information and making better-informed decisions.

Know Your Costs. Protect Your Margins. Make Better Menu Decisions.

KEY FEATURES

• 18 interconnected Excel worksheets.

• Ingredient master database with consistent IDs.

• Purchase-price history and normalized unit-cost comparisons.

• AP and EP costing with edible-yield adjustments.

• Documented mass, volume, and count conversions.

• Ingredient-level recipe and subrecipe costing.

• Batch costs and cost per sellable portion.

• Menu pricing and target-price calculations.

• Food-cost percentage and contribution-margin analysis.

• Sales mix and menu-item contribution calculations.

• Four-quadrant menu-engineering classification.

• Ingredient inflation and recipe-cost review flags.

• Price sensitivity and editable planning scenarios.

• Inventory, par-level, and reorder calculations.

• Actual-versus-theoretical food-cost reconciliation.

• Formula dictionary, source register, dashboard, and QA checks.

• Input validation and visual exception indicators.

• Excel-compatible core calculations without VBA or macros.

• Companion user guide and README.

WHAT'S INCLUDED

Main Excel workbook:
Restaurant-Recipe-Costing-Plate-Margin-and-Menu-Engineering-Matrix.xlsx

User guide:
Restaurant-Recipe-Costing-and-Menu-Engineering-User-Guide.docx

README:
Restaurant-Recipe-Costing-and-Menu-Engineering-README.md

Delivery format: Downloadable digital files packaged in a ZIP archive.

Access: Digital download after purchase, according to the storefront's delivery settings.

Physical product: None.

IDEAL CUSTOMER

This product is especially suitable for restaurant operators who want to move beyond manually calculating recipe costs or maintaining disconnected spreadsheets.

It is best suited to users who can access or obtain their own ingredient purchase prices, recipe quantities, portion yields, selling prices, and sales records.

Basic spreadsheet familiarity is helpful. Users should understand that the quality of the results depends on the accuracy and consistency of their input data.

TECHNICAL REQUIREMENTS

• Microsoft Excel with support for standard spreadsheet formulas is recommended.

• The core model does not require VBA or macros.

• A desktop spreadsheet application is recommended for full workbook navigation, formula inspection, conditional formatting, and chart interaction.

• Other spreadsheet applications may render some features differently.

• Internet access is required only for external activities such as accessing the download or obtaining supplier information; the core costing calculations are designed to run locally in the spreadsheet.

• The workbook does not automatically connect to supplier databases, accounting software, inventory systems, or point-of-sale platforms.

IMPORTANT PRODUCT NOTES

Demonstration data: The workbook contains clearly labeled illustrative data. Sample prices, yields, recipes, sales volumes, and financial results are not presented as verified restaurant records or industry benchmarks.

Data entry: Users must supply and verify their actual purchase prices, unit conversions, edible yields, recipe quantities, portion counts, menu prices, sales records, and inventory counts.

Financial scope: Ingredient cost and food contribution margin are not the same as total restaurant profit. Labor, occupancy, overhead, financing, taxes, and other expenses may materially affect overall profitability.

Menu engineering: The four-quadrant classification supports analysis but does not replace commercial judgment or customer research.

Price sensitivity: A modeled selling-price change does not establish how actual customer demand or unit sales will respond.

Accounting conventions: Tax treatment, discounts, inventory adjustments, and other costing assumptions must be configured to suit the restaurant's documented procedures.

BUYER LICENSE

Purchasers may use the workbook for their own restaurant operations, hospitality consulting, and internal professional business activities. They may enter their own records and modify the working model for legitimate internal use.

The original workbook and substantial portions of its original content may not be resold, redistributed as a competing spreadsheet product, publicly uploaded as a substitute for purchasing it, or rebranded to claim authorship of the original published materials without separate authorization.

This license description is provided in plain language and is not a guarantee of legal enforceability in every jurisdiction.

PUBLISHER AND COPYRIGHT

Copyright © 2026 Mohammed A. Omer. Published by Sarchawa (sarchawa.com). All rights reserved.

Sarchawa is the publishing website and digital resource platform operated by Mohammed A. Omer.

Product: Restaurant Recipe Costing, Plate Margin & Menu Engineering Matrix
Owner & Writer: Mohammed A. Omer
Publisher: Sarchawa
Website: https://sarchawa.com
Edition: First Edition, 2026

FREQUENTLY ASKED QUESTIONS

Q: Is this an Excel workbook or a PDF guide?

The principal product is an editable, formula-driven Excel workbook. A DOCX user guide and Markdown README are included as companion files.

Q: Does it calculate recipe costs automatically?

It calculates costs using the ingredient prices, conversions, yields, recipe quantities, and other inputs entered into the workbook. Missing or unverified information may prevent reliable costing.

Q: Can it handle ingredient price increases?

Yes. It maintains dated purchase-price records and compares normalized unit costs against selected baselines. Linked recipe and portion calculations can reflect approved current-cost changes.

Q: Does it classify menu items automatically?

It calculates sales mix, contribution margins, and menu-engineering classifications using the selected analysis period and configured thresholds. Items with missing critical information should be reviewed rather than treated as fully classified.

Q: Can it recommend menu prices?

It calculates proposed prices using a target food-cost percentage or target contribution margin. These are pricing calculations, not guarantees that customers will accept the proposed prices.

Q: Does it connect directly to my POS or supplier system?

No. The workbook is designed around entered or imported records. Automated external system integration is not included.

Q: Are the example prices and restaurant results real?

No. Demonstration figures are illustrative and must be replaced with the purchaser's verified data.

Q: Does it require macros?

No. The core calculations are designed to work without VBA or macros.

Q: Will it guarantee lower food costs or higher profits?

No. It supports cost visibility and analysis, but outcomes depend on data quality, restaurant operations, customer demand, purchasing decisions, and other business conditions.

TAKE ACTION!

Bring Your Restaurant's Numbers into Focus

Understand your ingredient costs, calculate the economics of every portion, monitor price changes, and evaluate menu performance through one connected Excel system.

Download the Restaurant Recipe Costing, Plate Margin & Menu Engineering Matrix and build a clearer picture of your restaurant's food-cost and menu-pricing decisions.

Know Your Costs. Protect Your Margins. Make Better Menu Decisions.