Inside the file
- 01Start Here & Setup Guide
- 02Restaurant Profitability Dashboard
- 03Supplier Database
- 04Ingredient Master Database
- 05Ingredient Cost Calculator
- 06Pack Size & Unit Conversion
- 07Yield & Trim Loss Calculator
- 08Usable Ingredient Cost Calculator
- 09Supplier Price History
- 10Ingredient Price Change Tracking
- 11Prep Recipe / Sub-Recipe Costing
- 12Recipe Builder
- 13Batch Cost Calculator
- 14Cost Per Portion Calculator
- 15Menu Item Database
- 16Menu Pricing Calculator
- 17Food Cost Percentage Calculator
- 18Gross Profit Calculator
- 19Gross Margin Calculator
- 20Target Food Cost Calculator
- 21Suggested Selling Price Calculator
- 22Packaging Cost Tracking
- 23Labor Cost Allowance
- 24Waste Cost Allowance
- 25Tax / VAT Inputs
- 26Price Gap Alerts
- 27Menu Item Profitability Overview
- 28Sales Mix Tracker
- 29Menu Engineering Analysis
- 30Star / Plowhorse / Puzzle / Dog Classification
- 31Waste & Spoilage Tracker
- 32Inventory Count Sheet
- 33Inventory Value Calculator
- 34Reorder Planning
- 35Purchase History
- 36Actual Food Cost Tracking
- 37Theoretical Food Cost Tracking
- 38Food Cost Variance Analysis
- 39Production Planning
- 40Break-Even Analysis
- 41Menu Price Simulator
- 42Printable Recipe Cost Card
- 43Allergen Notes
- 44Storage Location Tracking
- 45Demo Excel Workbook
- 46Blank Excel Workbook
- 4711-Page Quick Start Guide
- 489-Page Kitchen & Cost Control Forms Pack
- 49Single-Business Use License
Stop guessing what your dishes actually cost.
Ingredient prices change. Portions vary. Waste happens. Supplier costs increase. Packaging adds up. And if your recipes are not priced correctly, even a busy restaurant can lose money.
Restaurant Food Cost & Menu Pricing OS is a complete restaurant costing and profitability spreadsheet designed to help food businesses understand the true cost of every recipe and make smarter pricing decisions.
Instead of managing ingredients, recipes, food costs, supplier pricing, inventory, waste and menu profitability across separate spreadsheets, you get one connected system built around the real food-costing workflow:
Supplier → Ingredient → Yield → Prep Recipe → Menu Recipe → Portion Cost → Menu Price → Food Cost % → Profit
Build a Complete Ingredient Cost Database
Store the ingredients your business uses and track important costing information such as supplier, pack size, purchase cost, unit conversion, usable yield, waste percentage and true usable cost.
When ingredient prices change, update the cost in one place and use the workbook to understand how those changes affect your recipes and menu profitability.
Calculate True Ingredient Cost
Purchase price alone does not always represent the true usable cost of food.
The system allows you to account for:
- Pack size
- Purchase unit
- Recipe unit
- Unit conversion
- Yield percentage
- Trim loss
- Preparation loss
- Waste allowance
- Usable quantity
- Cost per usable unit
This is especially useful for ingredients such as meat, fish, produce and other items where the quantity purchased may be different from the quantity ultimately served.
Build Prep Recipes & Sub-Recipes
Many menu items rely on sauces, doughs, dressings, marinades, stocks, fillings and other components that are prepared in batches.
Create prep recipes and calculate:
- Batch ingredient cost
- Batch yield
- Cost per batch
- Cost per gram, milliliter or portion
- Cost contribution to finished menu recipes
This helps prevent ingredients buried inside sub-recipes from being ignored when costing a dish.
Calculate Recipe Cost Automatically
Build recipes using your ingredient database and calculate the cost of every ingredient used.
The workbook helps you see:
- Total recipe cost
- Batch cost
- Number of portions
- Cost per portion
- Packaging cost
- Labor allowance
- Waste allowance
- Total menu item cost
Know Your Food Cost Percentage
For every menu item, compare its cost against its selling price.
Monitor:
- Cost per serving
- Selling price
- Food cost %
- Gross profit
- Gross margin %
- Target food cost %
- Suggested selling price
- Pricing gap
This makes it easier to spot dishes that look profitable but are actually consuming too much of their selling price in food costs.
Calculate a Suggested Menu Price
Enter your target food-cost percentage and let the workbook help estimate an appropriate selling price.
For example, if a dish costs $4.50 to produce and your target food cost is 30%, the system can help determine the price required to support that target.
You remain in control of your final pricing, but you gain a clearer financial starting point.
See the Impact of Ingredient Price Changes
One of the biggest problems in restaurant costing is that supplier prices constantly change.
A dish that was profitable several months ago may no longer have the same margin today.
Restaurant Food Cost & Menu Pricing OS helps you track supplier and ingredient pricing so you can identify menu items whose cost or margin needs attention.
Track Supplier Prices
Maintain a supplier database and purchase history containing information such as:
- Supplier
- Ingredient
- Pack size
- Purchase price
- Purchase date
- Unit cost
- Notes
This helps you understand how ingredient costs move over time.
Track Waste & Spoilage
Food thrown away is money lost.
Use the Waste Tracker to record:
- Date
- Ingredient
- Quantity wasted
- Reason
- Cost of waste
- Department or station
- Notes
Monitor waste patterns and identify areas where tighter portioning, purchasing or prep controls could reduce costs.
Inventory Tracking
Keep a structured record of your ingredient inventory.
Track:
- Ingredient
- Storage location
- Quantity on hand
- Unit
- Unit cost
- Inventory value
- Reorder level
- Reorder quantity
Use inventory information alongside purchasing and usage data to better understand your food-cost performance.
Reorder Planning
The included reorder planning tools help identify ingredients that may need to be replenished based on current stock and reorder levels.
This can help reduce emergency purchases and improve purchasing organization.
Actual vs Theoretical Food Cost
Recipe costing tells you what food should cost.
Purchases and inventory tell you what food actually cost.
The workbook includes tools for comparing theoretical food cost with actual food cost so you can investigate differences caused by factors such as:
- Waste
- Over-portioning
- Spoilage
- Incorrect recipes
- Price changes
- Inventory errors
- Unrecorded consumption
Menu Engineering
Not every popular dish is profitable, and not every profitable dish sells well.
Use menu engineering to compare item popularity with profitability and help classify menu items into categories such as:
Stars — popular and profitable
Plowhorses — popular but lower-profit
Puzzles — profitable but less popular
Dogs — lower popularity and lower profitability
This can help you decide which dishes deserve promotion, repricing, redesign or reconsideration.
Track Sales Mix
Record menu-item sales volumes and revenue to understand which dishes are actually driving your business.
Compare:
- Units sold
- Selling price
- Revenue
- Food cost
- Gross profit
- Contribution margin
- Sales mix %
This helps you move beyond recipe costing into actual menu performance.
Price Simulator
Test potential pricing changes before updating your menu.
See how a new selling price affects:
- Food cost %
- Gross profit
- Gross margin
- Profit per serving
- Estimated menu profitability
This can be particularly useful when supplier prices rise or when reviewing menu prices periodically.
Break-Even Analysis
Use the included break-even tools to estimate how much sales volume or revenue may be required to cover relevant business costs based on the assumptions you enter.
Production Planning
Estimate how much food needs to be prepared based on expected sales quantities.
This can help kitchens organize production while reducing unnecessary overproduction and waste.
Menu Item Profitability Overview
View important pricing and profitability metrics together, including:
- Menu price
- Portion cost
- Food cost %
- Gross profit
- Gross margin
- Units sold
- Total contribution
- Pricing alerts
Quickly identify menu items that may need attention.
Restaurant Profitability Dashboard
Get a high-level overview of the financial performance of your menu.
Monitor key indicators such as:
- Number of menu items
- Average food cost %
- Total sales
- Estimated food cost
- Gross profit
- Waste cost
- Inventory value
- Highest-margin items
- Lowest-margin items
- Menu pricing alerts
Printable Recipe Cost Card
Create a clean recipe cost card showing ingredients, quantities, unit costs and recipe totals.
This can be useful for costing reviews, kitchen documentation and internal recipe management.
Allergen & Storage Notes
Ingredient and recipe records include space for operational notes such as allergens and storage information.
These fields are organizational tools only and are not a substitute for professional allergen-management, food-safety or regulatory systems.
Demo + Blank Workbooks Included
You receive two versions:
Blank Workbook
The main product. Ready for your restaurant, café, bakery or food business.
Demo Workbook
Contains fictional ingredients, suppliers, recipes, menu items, purchasing information and sales data so you can understand how the system works before entering your own information.
No Monthly Subscription
Restaurant Food Cost & Menu Pricing OS is a downloadable Excel product.
Pay once and use your copy without adding another required monthly software subscription to your business.
Good for
Restaurant Food Cost & Menu Pricing OS is ideal for restaurants, cafés, bakeries, coffee shops, caterers, food trucks, ghost kitchens, cloud kitchens, meal-prep businesses, dessert businesses, takeaway restaurants, small hospitality businesses, chefs, kitchen managers and food entrepreneurs who want a structured way to calculate recipe costs, control food-cost percentages, set profitable menu prices, monitor ingredient price changes, track waste and understand which dishes contribute the most profit. It is particularly useful for food businesses that currently rely on basic spreadsheets, handwritten recipes or rough pricing estimates and want a more complete one-time-purchase system for managing food costs and menu profitability.
Leave it
Restaurant Food Cost & Menu Pricing OS is not designed to replace a full restaurant POS system, accounting software, inventory automation platform, payroll system, supplier ordering platform, food-safety management system or enterprise restaurant-management platform. It does not automatically connect to POS transactions, supplier APIs, bank accounts or accounting platforms, and it should not be used as the sole source for legally required nutrition, allergen, food-safety or regulatory information. Large restaurant groups requiring real-time multi-location inventory, employee permissions, automated purchasing, POS integrations or centralized enterprise reporting may be better served by dedicated restaurant-management software.
Before you pay
What is Restaurant Food Cost & Menu Pricing OS?
It is a complete Excel-based food costing, recipe costing and menu pricing system that helps food businesses track ingredient costs, calculate recipe and portion costs, determine food-cost percentages, price menu items, monitor waste and inventory, and analyze menu profitability.
Is this just a food cost calculator?
No.
The product includes food-cost calculations, but it also covers ingredients, suppliers, yield, recipe costing, prep recipes, menu pricing, sales mix, menu engineering, inventory, waste, purchasing, actual vs theoretical food cost, production planning and profitability analysis.
What do I receive after purchase?
Your download includes:
Blank Excel Workbook
Demo Excel Workbook
Quick Start Guide PDF
Printable Kitchen & Cost Control Forms Pack
License and supporting documentation
Which workbook should I use?
Use the Blank Workbook for your own business.
Use the Demo Workbook to explore the system using fictional example data before entering your real ingredients and recipes.
Is this a subscription?
No.
It is a one-time-purchase digital product with no mandatory monthly subscription fee.
What software do I need?
The product is supplied as Microsoft Excel .xlsx workbooks.
For the most reliable experience, use a modern desktop version of Microsoft Excel.
Can I use this for a restaurant?
Yes.
The system is designed specifically for restaurant and food-business costing workflows.
Can cafés use it?
Yes.
It can be used for coffee, drinks, pastries, sandwiches and other café menu items.
Can bakeries use it?
Yes.
Bakeries can use the ingredient, recipe, batch-yield and portion-costing features for breads, cakes, pastries, fillings and other products.
Can caterers use it?
Yes.
Catering businesses can use the system to cost recipes, batches and portions and evaluate selling prices.
Can food trucks use it?
Yes.
Food trucks can use the same costing and menu-pricing tools to monitor ingredient and menu profitability.
Does it calculate food cost percentage?
Yes.
The workbook calculates food-cost percentage using your menu price and calculated menu-item cost.
Does it calculate recipe cost?
Yes.
Recipes can be built using ingredients and quantities, allowing the workbook to calculate ingredient totals, recipe cost and portion cost.
Does it calculate cost per serving?
Yes.
Enter the recipe yield or number of portions and the workbook can calculate cost per portion.
Can it calculate suggested menu prices?
Yes.
You can enter a target food-cost percentage and use the workbook to estimate a selling price aligned with that target.
What is yield costing?
Yield costing accounts for the fact that the amount of an ingredient you can actually use may be lower than the amount purchased.
For example, trimming meat or peeling vegetables can reduce usable quantity and increase the real cost of the usable ingredient.
Can I account for ingredient waste?
Yes.
The system includes yield/waste calculations at the ingredient level as well as a dedicated Waste & Spoilage Tracker.
Can I create prep recipes or sub-recipes?
Yes.
Prep components such as sauces, doughs, marinades, fillings, dressings or stocks can be costed separately and incorporated into finished menu recipes.
Can I track suppliers?
Yes.
The Supplier Database helps you organize supplier information and associate ingredient purchasing information with suppliers.
Can I track ingredient price changes?
Yes.
Purchase and supplier pricing information can be recorded so you can monitor cost changes and understand their impact on recipes.
Does changing an ingredient price affect recipes?
The workbook is designed so ingredient costing information flows into recipe and menu-item calculations. When relevant source costs change, dependent costing calculations update accordingly.
Can I track packaging costs?
Yes.
Menu-item costing can include packaging and other allowances rather than considering ingredients alone.
Can I include labor in menu-item cost?
Yes.
The system includes a labor-cost allowance so you can incorporate labor into your internal pricing analysis where appropriate.
Does it track food waste?
Yes.
Record wasted items, quantities, reasons and estimated waste costs.
Does it include inventory?
Yes.
An inventory sheet helps track quantities on hand, values, storage locations and reorder information.
Does it automatically deduct inventory when I make a sale?
No.
This is a spreadsheet-based management system and does not automatically connect to a POS system or deduct live inventory after every transaction.
What is actual vs theoretical food cost?
Theoretical food cost represents what food should cost based on recipes and expected sales.
Actual food cost reflects inventory and purchasing activity.
Comparing the two can help identify potential waste, over-portioning, pricing changes or inventory discrepancies.
Does it include menu engineering?
Yes.
The system includes menu-engineering analysis using item popularity and profitability.
What are Stars, Plowhorses, Puzzles and Dogs?
They are common menu-engineering categories used to compare menu-item popularity and profitability.
The workbook helps organize menu items according to those types of performance characteristics.
Can I track menu-item sales?
Yes.
The sales mix section allows you to record units sold and evaluate revenue and contribution by menu item.
Can I test new prices before changing my menu?
Yes.
The Price Simulator allows you to evaluate how potential selling-price changes affect food-cost percentage, margin and profit.
Does it calculate break-even?
The workbook includes break-even analysis based on the assumptions and figures you enter.
Does it handle tax or VAT?
The workbook includes tax/VAT inputs for pricing analysis, but tax treatment varies by jurisdiction.
Always confirm the appropriate tax treatment with a qualified local professional.
Does it calculate nutrition information?
No.
This product is not a nutritional-analysis system.
Does it guarantee allergen compliance?
No.
Allergen fields are provided for organizational purposes only. Food-allergen regulations and cross-contamination risks require appropriate professional procedures and local compliance.
Is this food-safety software?
No.
It does not replace HACCP systems, food-safety procedures, regulatory records or professional food-safety guidance.
Can I customize it?
Yes.
You can customize your suppliers, ingredients, categories, recipes, prices, assumptions and other editable business information.
Keep an untouched backup before making structural changes to workbook formulas or layouts.
Is sample data included?
Yes.
The Demo Workbook contains fictional suppliers, ingredients, recipes, menu items, purchases and sales information so you can learn how the product works.
Can I resell or redistribute the product?
No.
Your purchase provides usage rights according to the included license. The workbook, formulas, templates, PDFs and supporting files may not be resold, redistributed or offered as your own product.
