Menu Mix & Engineering Workbook

Menu Mix & Engineering Workbook

Use this workbook to identify which dishes actually drive margin, which deserve placement or promotion, and which should be redesigned or retired. The workbook is written for operators who want a practical, low-friction method to turn POS and recipe data into clear menu decisions—without guessing.

How to use this workbook

1. Gather three sources of data: recipe costs (direct ingredient costs and portion weights), recent sales by item (POS) over a representative period, and current menu prices and placement.
2. Populate the item catalog and cost section for every menu item you want to analyze. Be honest about portions—small differences can change margins.
3. Calculate contribution margin per item and popularity metrics (sales count and sales % of total items sold).
4. Plot each item on the quadrant analysis to see Stars, Plowhorses, Puzzles, and Dogs.
5. Use the placement & price simulation guidance to test low-risk changes, then follow the launch checklist and monitor results.

Workbook tabs (what to record)

• Item catalog — Item code, item name, category (appetizer/entrée/dessert/drink), current price, menu placement (front, feature, signature), and notes.
• Direct cost & portion entry — Ingredient lines per recipe: ingredient name, purchase unit cost, purchase unit weight/volume, portion weight, waste factor (if applicable), extended ingredient cost for the portion. Sum to total food cost per portion.
• Popularity tracking — Sales quantity and sales dollars for the chosen tracking period (e.g., last 30/60/90 days). Also track number of covers or transactions to normalize demand.
• Quadrant analysis — For each item calculate contribution margin and popularity percentage, then assign to: Stars, Plowhorses, Puzzles, Dogs.
• Placement & price change simulation — Simple scenarios to estimate margin impact of price or placement changes and guidance for small A/B tests.
• Launch checklist — Steps to communicate changes, train staff, monitor, and iterate.

Key calculations (simple, actionable)

Calculate these per item. Examples follow.

1. Food cost per portion = sum(ingredient portion costs) + small rounding for condiments/waste.
2. Contribution margin per portion = Menu price - Food cost per portion.
3. Contribution margin % = (Contribution margin / Menu price) × 100.
4. Popularity % = (Item sales quantity / Total item sales quantity for period) × 100.

Quadrant mapping: Stars, Plowhorses, Puzzles, Dogs

Use your menu's median or mean values to define quadrant boundaries. A simple approach:

• High popularity = popularity % > median popularity
• High margin = contribution margin % > median contribution margin %

Quadrants and what to do:

• Stars (high popularity, high margin) — Promote selectively. Protect portions and consistency. Consider premium placement and cross-sells to amplify revenue.
• Plowhorses (high popularity, low margin) — Improve margin via portion optimization, ingredient swaps, price nudges, or moving to a different size/portion. Be careful raising price; test with add-ons/up-sells first.
• Puzzles (low popularity, high margin) — Try placement, description upgrades, or front-of-house suggestions. A/B test featuring the item vs current item to check lift.
• Dogs (low popularity, low margin) — Consider reworking recipe, removing from menu, or converting to a limited-time feature to reduce waste risk.

Example row (for clarity)

Grilled Chicken Sandwich — Price: $12.00; Food cost: $3.25; Contribution margin: $8.75 (72.9%); Sales in 30 days: 150; Total item sales: 4,500 → Popularity = 3.33%.

Placement & price change simulation — practical rules

Simple simulations are often enough to decide whether to test changes. Use these conservative steps:

1. Estimate effect of a 5% price change on unit sales conservatively (assume 0–5% drop in volume for core items; more for discretionary items). If unsure, start with a $0.50 or 5% increase and monitor.
2. Simulate margin impact: New margin = (New price - Food cost) × Projected new volume.
3. For placement changes, target Puzzles with desirable margins for feature placement (test one or two at a time for a week).
4. When in doubt, prefer upsell & add-on strategies (sides, premium toppings) to change per-check revenue without risking base menu friction.

A/B testing & monitoring

• Test one variable at a time: price OR placement OR description.
• Test duration: at least 2 full weekly cycles (14 days) to smooth weekday/weekend effects.
• Measure: item quantity sold, check average, remakes/waste observations, guest feedback, and net margin change.
• Use simple significance rules: look for consistent lift for two consecutive test periods before rolling out.

Launch checklist (preparation, communication, monitoring)

1. Confirm recipes, portion weights, and plating photos for training.
2. Update POS item names and modifiers, and set test pricing in a separate POS menu if available.
3. Train staff on the reason for the change, how to describe items, and recommended up-sells.
4. Set monitoring dashboard: track item sales, waste, ticket time, and guest comments daily for the first two weeks.
5. Collect qualitative feedback from servers and cooks after each shift for the first week.
6. Decide pre-defined stop rules (e.g., >10% drop in unit sales for Stars, >20% increase in remakes, or significant negative guest feedback) and be ready to rollback quickly.

Common mistakes to avoid

• Removing a high-popularity item because it has low margin without first trying margin-improvement strategies.
• Changing multiple things at once (price + description + placement) so you can’t learn cause and effect.
• Trusting a single short period of data—use at least a few weeks and compare similar calendar periods.

Next steps and capability opportunities

This workbook is intentionally practical and ready for conversion into interactive tools:

• Make the item catalog and cost entry into an Interactive form so teams can save and revisit menus (CapabilityID 1 & 2).
• Add automated quadrant calculation, simple elasticity models, and scenario simulators that compute margin impacts immediately in the UI.
• Connect to POS and inventory systems to import sales and cost data for repeatable analysis (requires integrations beyond the workbook).
• Package as a deployable toolkit so a restaurant group can copy and tailor it per location (Adaptive Ownable Domains capability opportunity — CapabilityID 3).

Acceptable image search phrase: restaurant menu analysis spreadsheet