The Food Cost Worksheet provides you with the cost of food that was sold (broken down by category type) and the sales generated by the same. The costs in this report are theoretical as they are based on sales of menu items and the recipes linked to them. The sales and costs in this report can be viewed by menu items, menu product mix Sub-categories into which menu items can be grouped. or menu product group Categories into which menu product mix (and hence menu items) can be grouped., for the period selected.

Since theoretical usage estimates usage based on sales, purchases, waste, etc. this report is only as accurate as the data recorded in CLEARVIEW.

TO GENERATE A FOOD COST WORKSHEET:

  1. Open the Food Cost Worksheet page.

  2. Select the Area* and Store for which you want to generate the report from the drop-down list(s).

  3. Select the Period for which you want to generate the report from the drop-down list.

  4. Select the specifics of the period (Date*, Year*, Week Ending*, Month*, From* and/or To*) from the drop-down list(s).

  5. Select the Report Type from the drop-down list:

  6. Select the menu product Group* for which you want to generate the report.

    Not Selected will generate the report for all menu product groups Categories into which menu product mix (and hence menu items) can be grouped..

  7. Select the menu product Mix* for which you want to generate the report.

    Not Selected will generate the report for all menu product mix Sub-categories into which menu items can be grouped. in the Group selected.

  8. Click on the Go button.

The following information is displayed on the page for the Area*, Store, Period and other filters Drop-down boxes that let you select from the options available. selected:

  • Group: The menu product group Categories into which menu product mix (and hence menu items) can be grouped. for which the sales and costs are displayed; or if the Mix column is displayed, it is the menu product group under which the mix is classified.

  • Mix*: The menu product mix Sub-categories into which menu items can be grouped. for which the sales and costs are displayed; or if the Product column is displayed, it is the menu product mix under which the product is classified.

  • Product*: The menu item for which the sales and costs are displayed.

  • Sales:

    • Units: The number of units sold of the product, mix or group, as applicable.

    • Amount ($): The total amount received through the sales of the product, mix or group, as applicable.

    • Percent: The percentage of the total sales that the product, mix or group forms, as applicable.

      Percent = Sales Amount ($) x 100 / Sales Total

    • Price/Unit*: The average price of one unit of the product.

      Price/Unit = Sales Amount ($) / Sales Units

  • Theoretical Food*:

    The Cost Display on Reports control determines whether this column is displayed in the report.

    Click here to learn how to change the reporting controls in Inventory Reporting.

    • Amount ($): The total cost of the product, mix or group (based on the inventory items used in the recipes mapped to the menu items) attributed to food.

    • Percent: The percentage of the product, mix or group sales that the cost of food forms.

      Percent = Theoretical Food Amount ($) x 100 / Sales Amount ($)

    • Cost/Unit*: The average food cost for one unit of the product.

      Cost/Unit = Theoretical Food Amount ($) / Sales Units

  • Theoretical Paper*:

    The Cost Display on Reports control determines whether this column is displayed in the report.

    Click here to learn how to change the reporting controls in Inventory Reporting.

    • Amount ($): The total cost of the product, mix or group (based on the inventory items used in the recipes mapped to the menu items) attributed to paper.

    • Percent: The percentage of the product, mix or group sales that the cost of paper forms.

      Percent = Theoretical Paper Amount ($) x 100 / Sales Amount ($)

    • Cost/Unit*: The average paper cost for one unit of the product.

      Cost/Unit = Theoretical Paper Amount ($) / Sales Units

  • Theoretical Total*:

    The Cost Display on Reports control determines whether this column is displayed in the report.

    Click here to learn how to change the reporting controls in Inventory Reporting.

    • Amount ($): The total cost of the product, mix or group sold.

      Amount ($) = Theoretical Food Amount ($) + Theoretical Paper Amount ($)

    • Percent: The percentage of the sales that the cost forms.

      Percent = Theoretical Total Amount ($) x 100 / Sales Amount ($)

    • Cost/Unit*: The average total cost of one unit of the product.

      Cost/Unit = Theoretical Total Amount ($) / Sales Units

Report links:

Associated Settings

*optional section or field that may or may not be visible depending on the settings selected, whether the supplier is integrated or not, etc.