The Menu Price Analysis Report 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 can help provide a more realistic price for a menu item, and even that item's target percentage, for each Location selected.
Navigation
To navigate to the Menu Price Analysis Report, click 'My Reports' under 'Reports' in the left pane and then select 'Sales' in the top header of the reporting window. Once opened, a listing of reports will be shown.
Find 'Menu Price Analysis' and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be used to define your report.
Report Parameters
1) Filter By - A listing of all Location categories
2) Filter - A listing of all Locations from the selected Location category
3-5) Menu Category - A listing of all Menu Item Categories that a User can filter the items by
6) Start - The start date for the report
7) End - The end date for the report
8) Run Button - Runs the report. Users can also send, export, or print the report directly from this button by clicking the down arrow portion and selecting the desired action. Click here to learn more about this functionality
Click here to learn more about Report Views and their added functionality.
Report Columns
1) Menu Item - The name of the menu item analyzed. The plus sign
next to each item will expand to show the details of that item at the different Locations selected for this report.
2) Cost - The average cost of the item at all of the Locations that use it.
3) Qty - Number of items.
3) Avg Price - The average price this item is sold for at all Locations that use it.
4) Margin - The profit of this item based on the difference between the Avg Price and Cost.
5) Margin % - The profit divided by the Avg Price.
6) Target % - The Target Profit % set in the Menu Item record.
7) Var % - The difference between the Profit % and the Target %.
8) Price Needed - The the amount that the menu item should be priced 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. Click here to learn how to send, export, or print this report.