TABLE OF CONTENTS
Access to Dashboards
User of group FSM BP Managers can access to the Labor dashboard group.
What is Crew Lead Summary dashboard
The dashboard includes two graphics, each of them draws a dynamic change in the difference of actual and budgeted labor hours. On the first one, we display all Build Plans. The second one presents only closed BPs. The graphics shows this dynamic of variance for the last 12 months.
Summary. Data source
Crew Lead are Employees of the corresponding Project Roles in Build Plans.
Actual hours — driven from Time Card: hours from the completed payroll allocation table (all columns are filled).
Budgeted hours — populated from the “hours” budget item of approved budgets.
Variance is the difference between actual and budget.
To calculate Monthly Average Variance, we take months that have any data for Crew Leads.
Actual hrs are taken from Time Cards by months. Budgeted hours are adjusted with % Completion Estimate for a month. If the current month's Completion Percentage is 100%, the next month's budgeted hrs are not corrected with the BP progress % and are not factor into the monthly average variance.
Work with the dashboard
- Use Crew Lead filter to display data for specific Crew Leads. By default, we show top 5 Crew Lead by actual hours for the last 12 months.
- Add Company Summary on charts. To see company summary in the table, check “Show Company Summary” and clear filter by Crew Lead, or check “Show Company Summary” and select all Crew Leads.
- Place the cursor to any chart element to display data labels.
- Zoom in/out on charts.
Not Assigned — BPs that have actual and budget hrs, but don't have a Crew Lead role.
Labor Hour Details
Labor dashboard includes in-depth information about hours worked on each Build Plan: budgeted hours, actual hours broken down by on-site hours and overtime hours, how many budgeted hours are consumed, what the estimate of hours not yet completed is, and many other key figures.
Available Build Plans
The list of Build Plans you see in the Labor dashboard depends on your relationship to a Build Plan. So:
- If you are a BP Owner, you will see all your BPs in the dashboard.
- You are a Project Owner — access to Build Plans of your Project.
- Admin can see all BPs.
- Employees with finance access can see BPs:
- where they are a member of Project Role with active checkbox “has financial access rights”
- Employee Role “All Direct Cost BPs Financials” gives access to all Direct Cost BPs.
- “Full Financial” Employee Role displays all Build Plans.
The default view of the dashboard includes all accessible active Build Plans with approved budgets.
To display other available BPs (closed over the last 3 month, without budget), you should clear the checkboxes “Active Only” and “Has Budget”.
Details: How we calculate columns
Budgeted Hours — from an approved BP budget.
Actual Hours — hours allocated to a BP, taken from the Time Card's payroll allocation table.
On-site Hours — hours allocated to a BP with cost type “On Site”.
% of On-Site Hrs — On-site hrs/ Actual hrs.
Overtime Hours (OT + DT) — hours allocated to a BP with wage types “Overtime” and “Double”.
% of Overtime Hrs = Overtime Hours (OT + DT) /Actual hrs.
% of Budget Hours Consumed — the ratio of actual hrs to budget.
% Completion Estimate — from the “Progress %” field in a Build Plan card.
Current Baseline based upon % Completion Estimate = Budgeted hrs * % Completion Estimate.
Current Variance (hrs. +- from Current Baseline) — the difference between Current Baseline based upon % Completion Estimate and Actual hrs.
Current Variance (% +- from Current Baseline) = % Completion Estimate - % of Budget Hours Consumed.
Projected Final Hours — the amount of projected final hrs adjusted by the estimated completion percentage. It is equal = Actual hrs * 100% / % Completion Estimate.
Estimated to Complete = Projected Final Hours - Actual hrs.
Projected Final Variance (Actual hrs +- from Plan) = Budget hrs - Projected Final Hours.
Projected Final Variance (% of Plan) = the ratio of Projected Final Variance hrs to Budget hrs.
Labor tab: How we calculate columns
Open Labor tab to see projected hours to complete site.
- Budgeted Hours — from the BP Budget.
- Actual Hours — from BP financial Distributions with source type "Time Keeping".
- Field Completion Estimate hours = (Budget hrs * estimated % of BP progress) / 100%
- Current Variance = Actual - Field Completion Estimate
- Projected Final Job Hours = (Actual hrs / Field Completion Estimate % ) *100
- Projected Final Job Hours % = (Actual hrs / Field Completion Estimate hrs ) *100
- Projected Final Variance = Projected Final Job Hours - Actual
Data on a graph
Actual Hours — hours allocated to a BP, taken from the Time Card's payroll allocation table.
Pie chart data
Hours — hours allocated to a BP and grouped by cost type/wage type, taken from the Time Card's payroll allocation table.
Work Orders Report
Work Orders report is a web version of Work Orders reference. You can build a report as you want: filter by necessary criterions, sort in the required order. With the dashboard you can create a new Work Order or Dispatch, check the Work Order stage, compare Work Orders by key metrics like total worked hours or last day on Site, and much more.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article