Restaurant Menu Engineering Spreadsheet - Stars, Plowhorses, Puzzles and Dogs with Price Optimization Calculator

Know exactly which dishes are making you money and which ones are dragging down your margins. Built by a 38-year hospitality operator who has engineered menus across fine dining, hotel food and beverage, and high-volume casino restaurant operations.

This 7-sheet system runs the full menu engineering matrix, classifies every item as a star, plowhorse, puzzle, or dog, and includes a price optimization calculator to model price changes before you reprint a single menu. Works for any full-service restaurant, hotel dining outlet, or multi-concept operation.

What is included:

Guide: step-by-step instructions for setting up and running your menu analysis Dashboard: one-screen summary of your menu health with category breakdowns and key metrics Menu Data: enter your menu items with sales volume, food cost, and menu price Analysis: automated menu engineering matrix classifying every item by profitability and popularity Price Calculator: model the revenue and margin impact of price changes before committing Benchmarks: industry benchmark comparisons for food cost percentage, contribution margin, and menu mix Sheet1: working scratch area for custom calculations

7 sheets. Instant download. Excel and Google Sheets compatible. Sample data and setup guide included. Own it forever. No subscription.