Embedded Files
The goal of this project was to provide business leaders with relevant labor information using tables and interactive visualizations.
Challenge: Design a dynamic labor analysis tool to replace a legacy static report. Business leaders are accustomed to seeing a data table with summary level information for each property and division. This view needs to be maintained but with added visualizations and drill-down capabilities.
Solution: A labor report that emails a summary level report each week but is accessible on-demand with information updated daily. The on-demand version will include drill-down functionality as well as additional visualizations.
User options include fiscal year, week ending, time period, lessee sales (net or gross), properties, and labor types.
All options are universal to the workbook and can be changed on any relevant page.
Executive Summary:
Initial page of the analysis
Tabular representation of labor hours, expenses, and labor margin
Includes gradient coloring to quickly identify outliers
Emailed each week to leaders at all properties
Labor Variance:
Useful for division leaders to understand variances by labor type
Drill down available to see variances for each business unit
Labor by Business Unit:
Tabular representation of labor hours and expenses as related to budget and prior year
Includes gradient coloring to quickly identify outliers
Labor Variance by Business Unit:
Graph of labor variances for hours and expenses sorted by variance percent from largest to smallest
Allows division leaders to quickly find the business units that are performing well and those that are struggling
Labor with Attendance by Business Unit:
Labor hours and expense per guest
Variance compared to prior year
Selected business units are graphed on right for easy comparison
Rate & Volume Variance to Budget:
Labor expense divided into rate and volume components
Variance compared to budget with gradient coloring
Visualization of expense variance and overtime hours by division
Weekly Report:
Selections from the list of divisions are graphed on the right to show labor expense and average pay rate graphically depicted by week
Division leaders are able to see if overtime costs are significantly affecting average rates during times of peak labor usage
Weekly Labor Expense with Attendance:
Selections from the list of divisions are graphed on the right to show labor expense broken out by regular and overtime graphically depicted by week and juxtaposed with attendance by week
Provides insights into whether labor usage is following attendance trends
Weekly Labor by Business Unit:
Labor expense by week overlaid with overtime labor with selections from the table shown in the graph
Used to show relationship of seasonality and labor peaks with overtime usage
Values and data labels hidden or blurred for shareability
Google Sites
Report abuse