Daily Operations (Quick Service Restaurant, Inclusive Tax)
Summary report that shows sales and operating metrics.
Description
The Daily Operations report is a summary report that consists of KPI tiles, a multi-KPI tile, pie charts, bar charts, and tables that show sales and operating metrics. This report is for quick service restaurants with inclusive taxes.
Permissions: Sales and Operations and Labor.
Report Tags
Simphony, RES 3700, e7, Inclusive Tax, and Quick Service.
Sales and Margin
Visualization: KPI tile.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-74 Sales and Margin
Metric | Data Format | Description |
---|---|---|
Sales Net VAT |
Currency |
Sales net VAT amount. |
Margin Percent |
Percent |
Margin percent. |
Costs
Visualization: Multi-KPI tile.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-75 Costs
Metric | Data Format | Description |
---|---|---|
Cost of Goods Sold % |
Percent |
Prep cost total divided by sale net VAT total. |
Labor Cost % |
Percent |
Regular and overtime pay divided by net sales total. |
Check Count
Visualization: KPI tile.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-76 Check Count
Metric | Data Format | Description |
---|---|---|
Amount |
Integer |
Number of checks. |
Sales Metrics
Visualization: Grid.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Click Run Financial ControlReport to drill down.
Table 2-77 Sales Metrics
Metric | Data Format | Description |
---|---|---|
Gross Sales Before Discount |
Currency |
Gross sales before discount. |
Total Discounts |
Currency |
Total monetary amount of discounts. Drills down to Discounts. |
Gross Sales After Discount |
Currency |
Gross sales after discount. |
Tax Collected |
Currency |
Monetary amount of tax collected. Drills down to Taxes. |
Sales Net VAT |
Currency |
Sales net VAT minus tax collected. Drills down to Sales Mix. |
Service Charges |
Currency |
Service charges. Drills down to Service Charges. |
Non-Revenue Totals |
Currency |
Sum of non-revenue service charges and non-revenue menu items. Drills down to Non-Revenue. Not supported for RES 3700. |
Service
Visualization: Grid.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Click Run Service Performance Report to drill down.
Table 2-78 Service
Metric | First Column Data Format | Second Column Data Format | Description |
---|---|---|---|
Checks |
Integer |
Currency |
Number of checks and average spend per check. Drills down to Checks |
Sales Net VAT per Labor Hour |
N/A |
Currency |
Sales net VAT per labor hour. |
Drive Thru |
Integer |
Time |
Number of parked cars and average amount of time. |
Operating Costs
Visualization: Grid.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-79 Operating Costs
Metric | Data Format | Description |
---|---|---|
Cost of Goods Sold |
Currency |
Cost of goods sold. Drills down to Cost of Goods Sold. |
Cost of Goods Sold Percent |
Percent |
Prep cost total divided by net sales. |
Labor Cost |
Currency |
Regular pay plus overtime pay. Drills down to Labor Summary. |
Labor Cost Percent |
Percent |
Total labor cost divided by net sales. |
Operating Margin |
Currency |
Monetary amount of operating margin. |
Adjustments
Visualization: Grid.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-80 Adjustments
Metric | Count Data Format | Amount Data Format | Description |
---|---|---|---|
Returns |
Integer |
Currency |
Returns count and amount.
|
Voids |
Integer |
Currency |
Voids count and amount.
|
Manager Voids |
Integer |
Currency |
Manager voids count and amount.
|
Error Corrects |
Integer |
Currency |
Error corrects count and amount.
|
Cancels |
Integer |
Currency |
Cancels count and amount.
|
Cash Collected
Visualization: Grid.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Confirm that the Cash and Tips Paid tender media master items are configured correctly. See the Configure Tender Media Master Items for Daily Operations Report section of the Oracle MICROS Reporting and Analytics User Guide.
Table 2-81 Cash Collected
Metric | Data Format | Description |
---|---|---|
Cash In |
Currency |
Sum of all tenders of master type Payment and subtype Cash. |
Paid In |
Currency |
Sum of all tenders of master type Loan. |
Paid Out |
Currency |
Sum of all tenders of master type Pickup. |
Cash Due |
Currency |
Cash in plus paid in minus paid out. |
Deposits
Visualization: Grid.
Permission: Sales and Operations.
Data Retention Category: Transaction and KDS Details. See Data Retention Limits for more details.
Confirm that the Cash, Tips Paid, and Deposit tender media master items are configured correctly. See the Configure Tender Media Master Items for Daily Operations Report section of the Oracle MICROS Reporting and Analytics User Guide
Table 2-82 Deposits
Metric | Data Format | Description |
---|---|---|
Cash Due |
Currency |
Cash total (all tender totals of subtype Cash) plus paid in total minus paid out total. |
Deposits |
Currency |
Sum of all tenders of master type Pickup and subtype Bank deposit or all Cash Management transactions of type Deposit. If deposits are used in cash management, do not also assign tenders to the tender master subtype Bank deposit otherwise those transactions will be counted twice. |
Over/Short |
Currency |
Deposits minus cash due. |
Total Hours by Job Code
Visualization: Bar chart.
Permission: Labor.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-83 Total Hours by Job Code
Metric | Data Format | Description |
---|---|---|
Total Hours |
Time duration |
Regular hours plus overtime hours on the Y axis. |
Job Codes |
String |
Job codes on the X axis. |
Hours and Pay by Job Code
Visualization: Table.
Permission: Labor.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Click Run Labor Topic Report to drill down.
Table 2-84 Hours and Pay by Job Code
Metric | Data Format | Description |
---|---|---|
Total Row |
Variable |
The top row of the table shows totals for each metric. |
Job Code Name |
String |
Job code name. |
Regular Hours |
Integer |
Regular hours. |
Overtime Hours |
Integer |
Overtime hours. |
Total Hours |
Integer |
Regular hours plus overtime hours. |
Regular Pay |
Currency |
Regular pay. |
Overtime Pay |
Currency |
Overtime pay. |
Total Pay |
Currency |
Regular pay plus overtime pay. |
Labor Cost Percent |
Percent |
(Regular pay plus overtime pay) divided by sales net VAT. |
Sales Net VAT by Revenue Center
Visualization: Pie chart.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-85 Sales Net VAT by Revenue Center
Metric | Data Format | Description |
---|---|---|
Revenue Center |
Percent |
Revenue center sales net VAT as a percent of all revenue centers in the pie chart. |
Sales and Operations by Revenue Center
Visualization: Table.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-86 Sales and Operations by Revenue Center
Metric | Data Format | Description |
---|---|---|
Total Row |
Variable |
The top row of the table shows totals for each metric. |
Revenue Center Name |
String |
Revenue center name. |
Sales Net VAT |
Integer |
Sales net VAT. |
Percent of Total Sales Net VAT |
Percent |
Revenue center sales net VAT as a percent of total net sales. |
Checks |
Integer |
Number of checks. |
Percent of Total Checks |
Percent |
Revenue center checks as a percent of total checks. |
Average Spend per Check |
Currency |
Average spend per check at revenue center. |
Average Drive Thru Time |
Time |
Average time in drive thru. |
Average Parked Cars Count |
Integer |
Average number of parked cars. |
Sales Net VAT by Order Type
Visualization: Pie chart.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-87 Sales Net VAT by Order Type
Metric | Data Format | Description |
---|---|---|
Order Type |
Percent |
Order type net sales as a percent of all order types in the pie chart. |
Sales and Operations by Order Type
Visualization: Table.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-88 Sales and Operations by Order Type
Metric | Data Format | Description |
---|---|---|
Total Row |
Variable |
The top row of the table shows totals for each metric. |
Order Type Name |
String |
Order type name. |
Sales Net VAT |
Currency |
Sales net VAT. |
Percent of Total Sales Net VAT |
Percent |
Order type as a percent of total sales net VAT. |
Checks |
Integer |
Number of checks. |
Percent of Total Checks |
Percent |
Order type checks as a percent of total checks. |
Average Spend per Check |
Currency |
Average spend per check. |
Average Drive Thru Time |
Time |
Average time in drive thru. |
Average Parked Cars Count |
Integer |
Average number of parked cars. |
Sale Net VAT by Order Channel
Visualization: Pie chart.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-89 Sale Net VAT by Order Channel
Metric | Data Format | Description |
---|---|---|
Order Channel |
Percent |
Order channel sales net VAT. |
Sales and Operations by Order Channel
Visualization: Table.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-90 Sales and Operations by Order Channel
Metric | Data Format | Description |
---|---|---|
Total Row |
Variable |
The top row of the table shows totals for each metric. |
Order Channel Name |
String |
Order channel name. |
Sales Net VAT |
Currency |
Sales net VAT. |
Percent of Total Sales Net VAT |
Percent |
Order channel sales as a percent of total sales net VAT. |
Checks |
Integer |
Number of checks. |
Percent of Total Checks |
Percent |
Order channel checks as a percent of total checks. |
Average Spend per Check |
Currency |
Average spend per check. |
Sales Net VAT by Day Part
Visualization: Pie chart.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-91 Sales Net VAT by Day Part
Metric | Data Format | Description |
---|---|---|
Day Part |
Percent |
Day part sales net VAT as a percent of all day parts in the pie chart. |
Sales and Operations by Day Part
Visualization: Table.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-92 Sales and Operations by Day Part
Metric | Data Format | Description |
---|---|---|
Total Row |
Variable |
The top row of the table shows totals for each metric. |
Day Part Name |
String |
Day part name or quarter hour. |
Sales Net VAT |
Currency |
Sales Net VAT. |
Percent of Total Sales Net VAT |
Percent |
Day part sales net VAT as a percent of total sale net VAT. |
Checks Begun Count |
Integer |
Number of checks. Top level drills down to Checks report. Day part drills down to All Checks Fixed Period. |
Percent of Total Checks |
Percent |
Day part checks as a percent of total checks. |
Average Spend per Check |
Currency |
Average spend per check. |
Average Drive Thru Time |
Time |
Average time in drive thru. |
Average Parked Cars Count |
Integer |
Average number of parked cars. |
Sales Net VAT by Major Group
Visualization: Bar chart.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-93 Sales Net VAT by Major Group
Metric | Data Format | Description |
---|---|---|
Sales Net VAT |
Currency |
Sales net VAT on the Y axis. |
Major Groups |
String |
Major groups on the X axis. |
Sales and Operations by Major Group
Visualization: Table.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-94 Sales and Operations by Major Group
Metric | Data Format | Description |
---|---|---|
Total Row |
Variable |
The top row of the table shows totals for each metric. |
Name |
String |
Name of major group, family group, or menu item. |
Quantity Sold |
Integer |
Quantity sold. |
Gross Sales Before Discounts |
Currency |
Gross sales before discounts. |
Discounts |
Currency |
Monetary amount of item discounts. |
Gross Sales After Discounts |
Currency |
Gross sales minus item discounts. |
Sales Net VAT |
Currency |
Sales net VAT. |
Percent of Total Sales Net VAT |
Percent |
Group or item sales net VAT as a percent of total sales net VAT. |
Payment Total by Tender Type
Visualization: Bar chart.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Table 2-95 Payment Total by Tender Type
Metric | Data Format | Description |
---|---|---|
Payment Total |
Currency |
Monetary payment total on the Y axis. |
Tender Type |
String |
Tender type on the X axis. |
Payments by Tender Type
Visualization: Table.
Permission: Sales and Operations.
Data Retention Category: Daily and Fixed Period Totals. See Data Retention Limits for more details.
Click Run Tender Media Topic Report to drill down.
Table 2-96 Payments by Tender Type
Metric | Data Format | Description |
---|---|---|
Total Row |
Variable |
The top row of the table shows totals for each metric. |
Tender Type |
String |
Tender type. |
Amount |
Currency |
Monetary payment total. |
Percent of Total Amount |
Percent |
Tender type as a percent of total payments. |
Count |
Integer |
Number of payments for tender type. |
Average Amount |
Integer |
Average total per payment type. |
Report Notes
Checks and deposits do not get filtered by day part.
Parent topic: Summary Reports