Free Menu Engineering Spreadsheet Template

Menu engineering helps chefs kitchen managers and operators quickly see which dishes make money, which ones just take up space on the line, and where to focus limited time and ingredients for the biggest impact on profit and guest satisfaction. You don’t need to spend money on a program to use a menu matrix. There is a free tamplate you can download on this page and just plug in your data.

What the template actually does

You’ll see in the video tutorial that the menu engineering template organizes each menu item by how often it sells (popularity) and how much profit it brings in per plate (profitability), then plots every item in a simple matrix. By comparing items to find your stars, dogs, plowhorses and puzzles within the same category (for example, all dinner mains), you get a realistic picture of what is truly working on your own menu, not against industry averages or theory.

 

Managing your kitchen using sales data

This template turns your existing sales and cost data into clear, actionable visuals you can use to make informed management decisions. It shows you where to raise prices, where to tighten recipes or portions, and which items can be removed without hurting guests or the bottom line.

Concrete benefits in the kitchen

  • Protect margins by shifting focus toward items that are both popular and profitable, instead of pushing “chef favourites” that quietly lose money. 
  • Streamline prep and inventory by identifying low-selling, low-margin dishes that create waste, clutter your walk‑in, and slow the line down. 
  • Improve guest experience by doubling down on “star” items that guests already love, then featuring them more prominently on the menu, in staff training, and in promos. 

How to use the menu matrix template in your food operation

The ultimate goal is straightforward: optimize your menu to boost profits while keeping your guests satisfied and returning.
 
Inputting Initial Data
 
The first step in leveraging the menu matrix is inputting the data. To do this, you’ll need:
•Costs: Detail the ingredient cost for each item on your menu. Remember, every penny counts, so be as precise as possible.
•Prices: Input the selling prices of your dishes as they appear on the menu.
•Sales Volume: Record the number of each menu item sold over a selected time period. You could compare by the week, month, or any period that reflects typical business levels.
Once your initial data is in place, the FoodCostChef Menu Matrix Spreadsheet Template works its magic, sorting each menu item into one of four distinct groups based on profitability and popularity. Here’s a deeper look into what these categories mean and some strategic considerations for each:

•Stars: Yes, they are called stars for a reason. They make you the company money and they’re popular with your guests. They are the backbone of your menu, bringing in steady revenue and customer satisfaction. Since they are already performing well, major changes are optional. However, continuous monitoring for consistency in quality and cost is crucial to maintain their star status.

•Plowhorses: These are your crowd-pleasers with lower profit margins. They are often considered comfort dishes or staples that your regulars expect. While it’s tempting to maintain the status quo due to their popularity, there’s a strategic opportunity to tweak ingredient sourcing or preparation methods to enhance profitability without compromising taste or quality.

•Puzzles: High profitability but low popularity defines these enigmatic items. They can potentially be significant profit drivers if they can gain traction with your clientele. Consider altering their placement on the menu, enhancing their descriptions, or incorporating them into specials to increase their visibility and appeal.

•Dogs: Items in this category are neither profitable nor popular and are prime candidates for removal. However, before deciding to 86 these dishes, evaluate if they serve a specific purpose, like catering to niche dietary preferences or using up inventory that could otherwise go to waste. Removing them can streamline your operations and reduce costs if they don’t serve a strategic purpose.
This analytical approach allows you to strategically fine-tune your menu based on solid data, aligning offerings more closely with your business objectives and customer preferences.
menu engineering graph
Your menu items will end up somewhere in this menu matrix graph.

Decision-Making Based on the Menu Matrix

Once you categorize all of the menu items you can refine your menu:
 

•Menu Item Tweaks: Adjust recipes or presentation for Plowhorses to increase margins or revamp Puzzles to boost their appeal.

•Price Adjustments: Consider subtle price increases for Plowhorses without compromising their popularity or test price reductions for Puzzles to make them more attractive.

•Promotional Strategies: Use your marketing channels to highlight Stars and try to convert Puzzles into Stars with targeted promotions.
 
This structured approach streamlines your menu and aligns it more closely with your business goals, ensuring that every dish not only tastes good but also contributes positively to your bottom line. With these strategies, your menu becomes a powerful tool for achieving financial success and customer satisfaction.
Menu Engineeering using Microsoft Excel

Advanced Strategies in Menu Engineering

Accurate menu costing is the cornerstone of effective menu engineering. Here’s how to ensure precision:

•Regular Updates: Ingredient prices fluctuate due to seasonality and market changes. To maintain accurate margins, regularly update your costing to reflect these changes.

•Comprehensive Food Costing: Include all components of a dish in your cost analysis—consider seasonings, garnishes, and cooking oil, which are often overlooked but can significantly impact the cost.

•Waste Management: Track and minimize waste by adjusting portion sizes or reevaluating the usability of your kitchen’s by-products in other dishes.

•POS adjustments: The price of a menu item is always theoretical. Your POS report will always have adjustments for promotions, discounts, refunds, etc. You’ll want to take the total sales dollars and divide that amount by units sold to get your actual selling price of a menu item.
 

Testing and Revising the Menu

 

Continuous improvement through testing and revising is crucial:

•Split Testing: Try different versions of a dish (e.g., ingredient tweaks, presentation changes) in a controlled environment to see which performs better regarding customer satisfaction and profitability.

•Seasonal Adjustments: Align your menu with seasonal availability of ingredients not only to lower costs but also to keep the menu exciting and relevant.

•Customer Feedback: Utilize customer feedback to decide which dishes to modify, keep, or remove. Management can gather this through direct interaction, server feedback, comment cards, or online reviews.

Leveraging Psychological Tricks
Psychology plays a significant role in menu design. Here are some tricks to guide customer choices:
 

•Menu Descriptions: Use enticing and emotive language to describe dishes. For example, instead of “chocolate pudding,” use “velvety chocolate pudding with a hint of Madagascar vanilla.”

•Item Placement: Place high-margin items in prime spots based on eye-scanning patterns, such as the top right corner of the menu or the first and last items in a list.

•Colour and Typography: Utilize colours and fonts that match your brand and appeal to emotions, encouraging diners to order more. For instance, red and yellow stimulate appetite and attention.

Utilizing Technology

Embrace technology to streamline the menu engineering process:

•POS Integration: Use POS data to track sales and popularity in real time, allowing for quicker adjustments.

•Digital Menus: Digital menus on tablets allow for dynamic changes and can include high-resolution images to entice customers.

•Data Analytics Tools: Employ advanced analytics to dissect sales data, predict trends, and make data-driven decisions about your menu.
 
Maintaining your menu management can take time and effort. The key to making it manageable is to set up systems that involve your entire team. The more staff you get on board with this, the more important they will feel about their contributions and how important this is for the entire operation.

More Food Costing Tips:

Get A Quote
Get A Quote
Scroll to Top