MENU
    Menu Price Analysis
    • 31 Jul 2024
    • 2 Minutes to read
    • Dark
    • PDF

    Menu Price Analysis

    • Dark
    • PDF

    Article summary

    The Menu Price Analysis helps restaurant operators optimize their menu pricing strategies. This report provides detailed insights into the performance of individual menu items, comparing actual sales data against target margins and costs. The Menu Price Analysis shows the cost and selling price for each menu item, determines a profit from those metrics, and then calculates a variance and price needed to hit the target percentage based on the user-supplied target percentage. This provides a more realistic price for each menu item for each location selected. With this comprehensive analysis, restaurant managers can make informed decisions to maximize revenue and ensure their pricing aligns with market demands and operational goals.


    1. In the Reports section of the left navigation pane, select My Reports.
      The My Reports screen appears.

    2. At the top of the My Reports screen, select Sales.
      The screen generates a list of reports in alphabetical order.

    3. Locate the Menu Price Analysis.

    4. Select Customize to adjust the report parameters and run the report.


    Report Parameters

    Field

    Description

    1

    Filter By

    A list of all filter categories. Filter categories will vary based by report.

    2

    Filter

    A list of filter options, determined by the 'Filter By' category selected (#1).

    3

    Menu Category 1

    Filters the report to show menu items of the selected menu item categories.

    4

    Menu Category 2

    Filters the report to show menu items of the selected menu item categories.

    5

    Menu Category 3

    Filters the report to show menu items of the selected menu item categories.

    6

    Start

    First date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for which data is generated. The report then displays data for all dates within the date range, including the start and end dates.

    7

    End

    Last date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for which data is generated. The report then displays data for all dates within the date range, including the start and end dates.

    8

    View options

    This section provides options to select, save, edit, or delete a report view.

    9

    Run

    Generates the report. Click the down arrow to the right of the Run button to export, email, or print the report.


    Report Columns

    Column

    Description

    Menu Item

    The name of the menu item being analyzed in the row. Selecting the plus sign icon next to each item expands the row to show the details of the item by location.

    Cost

    Average cost of the item across all locations where it is sold, during the selected date range.

    Qty

    Quantity of each menu item sold within the selected date range. By analyzing the Qty column alongside cost and revenue metrics, managers can identify high-performing items to optimize overall menu profitability.

    Avg Price

    Average price the menu item across all locations where it is sold, during the selected date range.

    Margin

    The profit margin for each menu item, calculated as the difference between sales revenue and food cost.

    Margin = Avg Price - Cost

    Margin %

    The profit margin expressed as a percentage of sales revenue, indicating the profitability of each menu item relative to its price.

    Margin % = Profit / Avg Price

    Target %

    The target or ideal profit margin percentage set by the restaurant for each menu item. The Target % is configured on the Menu Item record.

    Var %

    The difference between the actual margin percentage and the target margin percentage. The variance helps to highlight items that are underperforming or exceeding expectations.

    Var % = Margin % - Target %

    Price Needed

    Price the menu item should be sold at to meet the Target %.


    Email, Export, or Print the Report

    This report can be emailed, exported, or printed in custom formatting directly from the reporting window. 


    Was this article helpful?