What a Menu Engineering Worksheet Actually Measures
A menu engineering worksheet maps every menu item across two dimensions: contribution margin (how many dollars of profit the item generates per cover) and popularity (how often it's ordered as a percentage of total covers). The resulting four-quadrant grid classifies each item as a Star (high margin, high popularity), Plow Horse (low margin, high popularity), Puzzle (high margin, low popularity), or Dog (low margin, low popularity).
The core formula is straightforward:
- Item Contribution Margin = Menu Price − Food Cost
- Menu Mix % = Item Units Sold ÷ Total Items Sold
- Category Average CM = Total Category Contribution Margin ÷ Total Items Sold
An item is "high margin" if its CM exceeds the category average; "high popularity" if its menu mix % exceeds 70% of the category average (the standard threshold popularized by Kasavana & Smith).
The Fields You Need in Your Worksheet
A complete worksheet includes: item name, category, menu price, recipe cost, contribution margin, units sold in the period, menu mix %, quadrant classification, and recommended action (promote, reprice, reposition, or remove).
Worked example: Your ribeye sells for $48. Recipe cost is $19.20, so CM = $28.80. It represents 18% of entrée covers versus a category average of 12%. It is a Star — protect its visibility and resist discounting it.
Your pasta primavera has a CM of $9.40 and commands 22% of covers. That's a Plow Horse — wildly popular but margin-thin. Even a $1.50 price increase or a recipe tweak could recover meaningful profit.
Why This Matters to Your Bottom Line
Restaurants that systematically engineer their menus report measurable food-cost improvement. Moving even two Plow Horses toward Star territory — through repricing or portion adjustment — can shift overall food cost by one to two percentage points, which at $1M in sales equals real money.
How Hubstaurant Replaces the Spreadsheet
Hubstaurant reads your purchase invoices automatically, tracks live ingredient prices, and connects that cost data directly to your POS sales mix. It calculates contribution margin and menu mix for every item in real time — no manual entry, no monthly spreadsheet ritual.
The food-cost analytics dashboard surfaces quadrant classifications automatically and flags items whose costs have drifted since you last set the recipe. When vendor prices change on an invoice, Hubstaurant recalculates affected item margins on the spot.
Standalone inventory apps like MarketMan do solid invoice parsing, and dedicated menu engineering tools like Menutail offer deep analysis — but they require exporting data between systems and reconciling numbers manually. Hubstaurant keeps purchasing, food cost, and POS analytics in one place, so your menu engineering view is always current without the copy-paste.
Start Engineering Your Menu Today
If you're running menu decisions off gut feel or a quarterly spreadsheet, you're leaving margin on the table every service. Start a free Hubstaurant trial and let the system show you exactly which items are working for your bottom line — and which ones are quietly costing you.