Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This article provides details of the Menu Cost & Profit Report.

Overview

The Menu Cost & Profit Report helps users understand their menu item’s profitability. Clients with hierarchy data will have the capability to view modifiers added or removed to menu items. This data can be used to see potential modifiers added or removed to menu items, such as combo, number of units sold per item, plate cost %, and other cost-related data.

Info

Decision Logic currently supports the Qu Point of Sale system.

Users will need View permissions for the Menu Cost & Profit page within Purchasing in Profile Maintenance.

Run Report

Begin by navigating to:

Reports > Purchasing > Menu Cost & Profit

  1. Select the Company, Region, Area, or Store.

  2. Click View X Store.

    1-2. Scope Selector.pngImage Added
  3. Select a Date or Date Range.

    1. By default, Enforce Weeks will be toggled on to select a date range.

    2. Un-toggle Enforce Weeks to select a single date.

    3. The green dot under a date represents the beginning of an Inventory Week Start.

    4. The orange triangle represents the Period Start.

  4. Select a Sales View option from the dropdown.

  5. Click Apply.

    Image Removed3-5 Parameters menu cost.pngImage Added

Below is an example report.

1-5 2024.pngImage Removed

Example menu cost.pngImage Added

The report is broken down by Menu Category followed by Menu Item. Users can sort a column by selecting the arrow next to a column. Available columns are:

  • Description - how the POS describes the item.

  • Sold - how many unit items were sold.

  • Average Price - obtained from the POS.

  • Average Revenue - average revenue of the item which includes upsells.

  • Average Base Cost - average cost for the menu item only. Excludes additions or removals.

  • Sales - total revenue excluding taxes.

  • Average Cost - average cost for the menu item which takes in account upsells and removals.

  • Profit - total revenue minus total cost.

  • Base Plate Cost % - average base cost / average price.

  • Total Plate Cost % - average cost / average revenue.

Clicking View provides a slide out with more details which includes modifications to the menu item.

Print or Export Report

Begin by navigating to:

Reports > Purchasing > Menu Cost & Profit

  1. Select the Company, Region, Area, or Store.

  2. Click View X Store.

    1-2. Scope Selector.pngImage Added
  3. Select a Date or Date Range.

    1. By default, Enforce Weeks will be toggled on to select a date range.

    2. Un-toggle Enforce Weeks to select a single date.

    3. The green dot under a date represents the beginning of an Inventory Week Start.

    4. The orange triangle represents the Period Start.

  4. Select a Sales View option from the dropdown.

  5. Click Apply.

    Image Removed3-5 Parameters menu cost.pngImage Added
  6. Click Print or Export.

    Print and Export.pngImage RemovedExport_print.pngImage Added

2023 2024 Knowledge Management Systems, LLC. Decision Logic. All Rights Reserved.

Table of Contents

Table of Contents
minLevel1
maxLevel6
outlinefalse
typelist
printablefalse
Info

For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.

Info

Unable to access this feature in the Decision Logic platform?

  • Contact your Decision Logic Administrator to make Scope and Security adjustments to your user profile or add new features.

  • Some features are client-specific.