Item Costing Report

The Item Costing Report displays profit based on selected items. Item Cost is derived from the "Item Cost" field in Item Maintenance. If this field contains a value of zero, the report will attempt to determine the item's cost based on the cost of it's ingredients.

ClosedHow to Generate the Enterprise Item Costing Report
  1. Open the Back Office.
  2. Click the Reports icon.
  3. Select Item Costing.
  4. When the Item Costing Report window appears, configure the report settings:
    • Select a Start Date, Start Time, End Date, and End Time for the report.
    • Select a Scalable Items option:
      • Show Quantity Sold displays the items sold by the number of items sold.
      • Show Weight Sold displays the items sold by weight.
    • Don't Include Items With a Zero Price excludes items that customers are not charged for.
    • Select the Departments and Items to include in the report or click the Select/De-Select All buttons to select or de-select all Departments or Items.
  5. Click OK to generate the report.
    The Item Costing Report configurations window
ClosedItem Costing Report Values Defined

Item Costing Summary

Displays items sold by weight or quantity sold, the sales price,

Item Number: The Item Name as configured in Item Maintenance; sorted by Group and Department as configured in Department Maintenance.

Description: The Description as configured in Item Maintenance.

Qty Sold: The amount of the item sold, by weight or quantity, based on the Scalable Items option selected when configuring the report.

Cost: The Item Cost per item as configured in Item Maintenance. This is the cost to produce the item.

Tot Cost: The total dollar amount of the specified item sold. Total Cost = Cost * Qty Sold

Retail: The item's Default Price as configured in Item Maintenance.

Tot Retl: The total dollar amount of the specified item sold. This total is based on the sale price of the item and will calculate any price level changes, coupons, or discounts that were applied to the item.

% Cost: The percentage of cost that is represented by the total retail amount sold. Percent Cost = Total Cost/Total Retail

% Dpt Tot: The percentage of the department sales the specified item represents

% Tot Sls: The percentage of all sales for all departments that the specified item represents

Dept Totals: The total quantity or weight sold, cost, retail, percentage of cost, and percentage of total sales from the specified department.

Group Totals: The total quantity or weight sold, cost, retail, percentage of cost, and percentage of total sales from the specified group.

ClosedNotes

Users can configure Auto Report Settings by clicking File > Auto Report in the report preview window. For more information, see Auto Reports.

Open topic with navigation