R365 Intelligence: Labor Dashboard Master

03 Jul 2024
4 Minutes to read

Print
Share
Dark
Light
PDF

R365 Intelligence: Labor Dashboard Master

Updated on 03 Jul 2024
4 Minutes to read

Print
Share
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

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

	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. 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.

Was this article helpful?

What's Next

R365 Intelligence: Intraday Dashboard Master

Table of contents

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