Job Labor Analysis Column Definitions

Job Labor Analysis Column Definitions

The job screen has a number of columns.  The user can turn columns on/off to build an appropriate view for the job.  See the article on job views.

The following columns are imported from the accounting system:
  1. Phase Code (or cost code)
  2. Phase Description 
  3. Status
  4. Cost Type
  5. Estimated Qty
  6. JTD Qty (Job to Date Quantity)
  7. UOM (Unit of Measure)
  8. Estimated Hours (Current estimated hours including all approved change orders)
  9. JTD Hours (Job to Date Hours)
The following columns are user entries: (These columns are interactive, so entering one will calculated the other two.)
When the user enters Percent Complete then:
      Projected at Complete = JTD Hours / Percent Complete
      Projected to Complete = Projected at Complete - JTD Hours

When the user enters Projected at Complete then:
      Percent Complete = JTD Hours / Projected at Complete
      Projected to Complete = Projected at Complete - JTD Hours

When the user enters Projected to Complete then:
      Projected at Complete = JTD Hours + Projected to Complete
      Percent Complete = JTD Hours / Projected at Complete

The following columns are calculated:
  1. Earned Hours = Estimated Hours x Percent Complete
  2. Earned Hours Over (Under) = JTD Hours - Earned Hours (positive is over, negative is under)
  3. Percent of Estimate = JTD Hours / Estimated Hours (as a percentage)
  4. Estimated Hours Remaining = Estimated Hours - JTD Hours
  5. Actual/Earned = JTD Hours / Earned Hours
  6. Projected Over (Under) = Projected at Complete - Estimated Hours (positive is over, negative is under)
  7. Hours This Period = JTD Hours this period - JTD Hours previous period
  8. Entry Date - this is the last date a user entry was made to this phase
Also there is a CHART column.  Clicking the chart icon will generate a chart showing the performance trend for a phase code.
    • Related Articles

    • Labor Analysis Screen

      The job labor analysis screen is the main screen for updating your job forecast. Labor Analysis Grid There are many columns available on this screen, so be sure to turn columns off/on and sort/group columns to give you the best view of the job. For ...
    • Job Cost Analysis

      This screens provides detailed cost analysis on the job. Grid The listing in the grid provides all the hours projections and cost projections for each phase code. This grid has many columns so it is best to configure your screen to provide the view ...
    • Job Labor Analysis Fields Available

      To see the available job fields click on the COLUMNS button on the far right side of the summary screen. This will give you a complete list of the job fields. Summary Screen Fields Phase Code Phase Description Category Codes (these codes are segments ...
    • Labor Summary

      The labor summary screen rolls up all the jobs assigned to you, so there is one line per job.  This screen is designed to give you an overall view of the jobs. Clicking on the SELECT column (with the selection box) will take you to the job screen. ...
    • Job Time Entry

      This screen is designed for Foremen or Crew Leaders entering time for several employees. This screen will show all the entries you have made for the week. Add Time Card When you click this button you will get the dialog box below. Fill in the fields ...