This article reviews the labor dashboard master.
Upon opening the Labor Dashboard Master, users may be prompted to select a date parameter. The default setting is set to the date that is 3 months back from the current date. Once loaded, the dashboard master will feature the data within the date window.
This dashboard cannot be edited. However, should any changes need to be made, users can duplicate this dashboard master and edit the copy.
The labor dashboard master uses the Labor Dataset to create the following visualizations:
- Total Actual Hours
- Actual Shift Count
- Total Actual Wages
- Labor %
- Actual vs. Scheduled Hours
- Actual vs. Scheduled Wages
- Actual vs. Scheduled Shifts
- Labor Summary
- Labor Efficiency Analysis
- Void Analysis
Total Actual Hours
Field | Description | |
Total Actual Hours | The total number of hours worked within the selected date parameter. | |
Scheduled Hours | The total number of hours that were scheduled within the selected date parameter. | |
Variance | The variance percent. This variance is based on the comparison between the hours scheduled and the hours worked. |
This visualization was created using the following metrics:
- Total Actual Hours
- Total Scheduled Hours
Actual Shift Count
Field | Description | |
Actual Shift Count | The number of shifts worked within the selected date parameter. | |
Scheduled Shift Count | The number of shifts scheduled within the selected date parameter. | |
Variance | The variance percent. This variance is based on the comparison between scheduled shift count and actual shift count. |
This visualization was created using the following metrics:
- Actual Shift Count
- Scheduled Shift Count
Total Actual Wages
Field | Description | |
Total Actual Wages | The total dollar amount of all wages paid to employees within the selected date parameter. | |
Scheduled Wages | The total dollar amount of all wages scheduled to be paid to employees based on the scheduled hours within the selected date parameter. | |
Variance | The variance percent. This variance is based on the comparison between scheduled wages and actual wages. |
This visualization was created using the following metrics:
- Total Actual Wages
- Total Scheduled Wages
Labor %
The labor percent shows the percent of labor used within the selected date parameter. This is calculated by taking the Total Actual Wages metric and dividing it by the Gross Sales metric.
This visualization was created using the following metric:
- Labor %
Actual vs. Scheduled Hours
Field | Description | |
Date | The x or horizontal axis shows individual dates in d/m/yyyy format. The dates here are determined by the date parameters set on the dashboard. | |
Hours | The y or vertical axis shows the number of hours. | |
Total Actual Hours | The left bar shows the total actual hours. These are the total number of hours worked by employees on the designated day. | |
Total Scheduled Hours | The right bar shows the total scheduled hours. These are the total number of hours scheduled on the designated day. |
This visualization was created using the following attributes and metrics:
- Attributes
- Date
- Metrics
- Total Actual Hours
- Total Scheduled Hours
Actual vs. Scheduled Wages
Field | Description | |
Date | The horizontal axis shows individual dates in d/m/yyyy format. The dates here are determined by the date parameters set on the dashboard. | |
Wages | The vertical axis shows the dollar amount of wages. | |
Total Actual Wages | The left bar shows the total actual wages. This is the total dollar amount of all wages paid to employees based on the total hours worked. | |
Total Scheduled Wages | The right bar shows the total scheduled wages. This is the total dollar amount of all wages scheduled to be paid to employees based on the total scheduled hours. |
This visualization was created using the following attributes and metrics:
- Attributes
- Date
- Metrics
- Total Actual Wages
- Total Scheduled Wages
Actual vs. Scheduled Shifts
Field | Description | |
Date | The horizontal axis shows individual dates in d/m/yyyy format. The dates here are determined by the date parameters set on the dashboard. | |
Shifts | The vertical axis shows the number of shifts. | |
Total Actual Shifts | The left bar shows the total actual shifts worked. This is the total number of shifts worked by employees on the designated day. | |
Total Scheduled Shifts | The right bar shows the total scheduled shifts. This is the total number of shifts that were scheduled on the designated day. |
This visualization was created using the following attributes and metrics:
- Attributes
- Date
- Metrics
- Actual Shift Count
- Scheduled Shift Count
Labor Summary
Field | Description | |
Attribute Selector | This selector allows users to sort the visualizations below either by Location or by Employee Name. When Location is selected, the data shown will be per location, and when set to Employee Name, the data shown will be per each employee. Important Note: This selector also applies to the Labor Efficiency Analysis and Void Analysis visualizations. | |
Location / Employee Name | When the selector is set to Location, this will list the Location names. When set to Employee Name, this will list the names of the Employees. | |
DT Actual Hours | The actual number of double time hours worked. | |
OT Actual Hours | The actual number of over time hours worked. | |
Regular Actual Hours | The actual number of regular hours worked. | |
Regular Scheduled Hours | The number of regular hours scheduled. | |
Scheduled Shift Count | The number of scheduled shifts. | |
Total Actual Hours | The total actual hours worked. This includes DT, OT, and regular hours. | |
Total Scheduled Hours | The total scheduled hours. |
This visualization was created using the following attributes and metrics:
- Attributes
- Location
- Employee Name
- Metrics
- DT Actual Hours
- OT Actual Hours
- Regular Actual Hours
- Regular Scheduled Hours
- Total Actual Hours
- Total Scheduled Hours
Labor Efficiency Analysis
Field | Description | |
GPLH | The vertical axis represents the guests per labor hour. This is calculated by taking the Guest Count metric and dividing it by the Total Actual Hours metric. | |
SPLH | The horizontal axis represents the sales per labor hour. This is calculated by taking the Gross Sales metric and dividing it by the Total Actual Hours metric. | |
Graph Point | The circles on the graph represent individual data points. Hovering over a circle will show the detailed data with the location, GPLH value, and SPLH value. |
This visualization was created using the following attributes and metrics:
- Attributes
- Employee Name
- Metric
- GPLH
- SPLH
Void Analysis
Field | Description | |
Void Amount | The vertical axis represents the dollar void amount. This is the dollar amount of all voided transactions. | |
Gross Sales | The horizontal axis represents the dollar amount of gross sales. This is the total sales amount without adjustments or deductions. | |
Graph Point | The circles on the graph represent individual data points. Hovering over a circle will show the detailed data with the location, gross sales, void amount, and void %. |
This visualization was created using the following attributes and metrics:
- Attributes
- Employee Name
- Metrics
- Void Amount
- Gross Sales
- Void %
- This is calculated by taking the Void Amount Metric and dividing it by the Gross Sales metric.