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

    • Job Labor Analysis Screen

      The job labor analysis screen is the main screen for updating your job forecast. 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 instance if you are ...
    • 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 Schedule

      The Job Schedule Screen is designed to give you an approximate forecast of the labor requirements over the duration of the job. This screen is organized by "Work Group".  The Work Group is defined in the Master Phase Code setup.  See that article for ...
    • Job Configuration

      The purpose of this screen is to allow users to: Assign a master phase code structure to a job.  This parses the phase code with readable descriptions. Add additional users to the job.  The system automatically gives permission to the PM, Super and ...