The Sales vs Labor Report compares sales and labor side by side. It contains sales, labor hours, and labor cost for each location and business day, with the labor cost percentage and sales per labor hour.
Column reference
| Column | Type | Description |
|---|---|---|
| tenant_id | NUMBER(38,0) | R365 internal tenant identifier |
| daily_sales_summary_id | VARCHAR | Daily sales summary record identifier. Links the sales data to the labor data. |
| location_id | VARCHAR | Location identifier |
| location_name | VARCHAR | Name of the location |
| location_number | VARCHAR | Location number |
| date | DATE | Business date |
| operational_year | NUMBER(4,0) | Fiscal year from the 4-4-5 calendar |
| operational_period | NUMBER(2,0) | Fiscal period number (1-13) from the 4-4-5 calendar |
| operational_quarter | NUMBER(9,0) | Fiscal quarter from the 4-4-5 calendar |
| net_sales | NUMBER(38,2) | Net sales amount from daily_sales_summary |
| gross_sales | NUMBER(38,2) | Gross sales amount from daily_sales_summary |
| guest_count | NUMBER(38,0) | Number of guests from daily_sales_summary |
| sales_count | NUMBER(38,0) | Number of sales tickets (check count) from daily_sales_summary |
| total_hours | NUMBER(38,10) | Total labor hours from actual punch records (sum of labor.hours) |
| regular_hours | NUMBER(38,4) | Regular labor hours from actual punch records |
| overtime_hours | NUMBER(38,4) | Overtime labor hours from actual punch records |
| double_overtime_hours | NUMBER(38,4) | Double overtime labor hours from actual punch records |
| total_labor_cost | NUMBER(38,4) | Total labor cost from actual punch records (sum of labor.total_pay) |
| dss_total_labor | NUMBER(38,4) | Total labor cost recorded on the daily sales summary form. Can differ from the total labor cost when punches are edited after the daily sales summary is approved. |
| dss_labor_percent | NUMBER(38,0) | Labor cost percentage recorded on the daily sales summary form |
| labor_cost_percentage | NUMBER(38,4) | Total labor cost divided by net sales, calculated from actual punch records. |
| sales_per_labor_hour | NUMBER(38,2) | Net sales divided by total hours, calculated from actual punch records. |