Analyze every item on your menu using our menu engineering worksheet, a structured template that classifies dishes based on their profitability and popularity. For each menu item, enter the number sold, the selling price, and the food cost. The worksheet calculates contribution margin per item, total profit contribution, and sales mix percentage, then plots each dish into one of four categories: stars, plowhorses, puzzles, and dogs.
Menu engineering is a methodology developed in the hospitality industry to help operators make data-driven decisions about what to keep, reprice, reposition, or remove from their menus. Stars are high-profit and high-popularity items that should be featured prominently. Plowhorses sell well but generate low margins, so they are candidates for recipe reformulation or subtle price increases. Puzzles are high-margin dishes that do not sell frequently and may benefit from better menu placement or server recommendations. Dogs are low in both profitability and popularity and are often the first candidates for removal.
To get meaningful results from the worksheet, you need sales data covering a representative period, typically four to eight weeks. You also need accurate food costs for each item, which is why recipe costing should be done before menu engineering. The worksheet allows you to compare current performance against previous periods so you can measure whether changes to pricing, descriptions, or menu placement actually improved results. Restaurant consultants, owners, and managers use this analysis during seasonal menu reviews and whenever they notice declining overall profitability across the menu.