Job Screen Column Definitions

Job Screen 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.
There is a CHART column.  Clicking the chart icon will generate a chart showing the performance trend for a phase code.

On the Job Analysis Screen the following columns are imported from the accounting system.  Hours columns are show on the Job Labor Analysis screen.  All columns appear on the Job Cost Analysis screen:
  1. Company Code
  2. Phase Code (or cost code)
  3. Phase Description 
  4. Phase Cost Center
  5. Status (Active, Inactive, Complete)
  6. Cost Type
  7. JTD Hours
  8. JTD Cost
  9. JTD Qty (Job to Date Quantity)
  10. UOM (Unit of Measure)
  11. Estimated Hours (Current estimated hours)
  12. Estimated Cost (Current estimated cost)
  13. Estimated Quantity
  14. Projected Cost ERP
  15. Committed Cost
  16. TC Hours Included/Excluded (Time Card Hours can either be included or excluded  in JTD Hours based on your system setting)
  17. TC Cost Included/Excluded
The following columns are user entries: (These columns are interactive, so entering one will calculate the other two.)
When the user enters Percent Complete Labor then:
      Projected Hours at Complete = JTD Hours / Percent Complete Labor
      Projected Hours to Complete = Projected Hours at Complete - JTD Hours

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

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

The following columns are calculated:
  1. Actual/Earned = JTD Hours / Earned Hours
  2. Actual Cost/Hour = JTD Cost / JTD Hours
  3. Earned Hours = Estimated Hours x Percent Complete
  4. Earned Hours Over (Under) = JTD Hours - Earned Hours (positive is over, negative is under)
  5. Entry Date = Last date user made an entry to labor percent complete
  6. Estimated Cost/Hour = Estimated Costs / Estimated Hours
  7. Estimated Hours Remaining = Estimated Hours - JTD Hours
  8. Estimated Production = Estimated Quantity / Estimated Hours (or Estimated Hours / Estimated Quantity based on system setting)
  9. Hours Since Update = JTD Hours since user update
  10. JTD Production = JTD Quantity / JTD Hours (or JTD Hours / JTD Quantity based on system setting)
  11. Memo = entry field (posted to note field in accounting projections)
  12. Percent Complete Labor = entry (see above)
  13. Percent of Estimated Cost = JTD Cost / Estimated Cost
  14. Percent of Estimated Hours = JTD Hours / Estimated Hours
  15. Percent of Quantity = JTD Quantity / Estimated Quantity
  16. Production This Period = JTD Quantity This Period / JTD Hours This Period (or JTD Hours / JTD Quantity based on system setting)
  17. Projected Cost JSF = Max of JTD Cost, Estimated Cost (user entry field to over-ride or update)
  18. Projected Cost Over (Under) = Projected Cost - Estimated Cost
  19. Projected Hours at Complete = JTD Hours / Percent Complete (entry, see below)
  20. Projected Hours to Complete = Projected Hours - JTD Hours (entry, see below)
  21. Projected Hours Over (Under) = Projected Hours at Complete - Estimated Hours (positive is over, negative is under)



    • Related Articles

    • Screen Views

      General The application provides a way to customize the screens to suit the user. Once you have the screen adjusted to the view you wish, then you can save the view with a name. This is a very powerful capability. What is a view? A view is screen ...
    • 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 Crew Setup

      This screen will allow you to build a crew for the job. When doing time entry, you can enter one time card for the crew. First select a job by starting to type the job number or name, then select the required job. Build Crew List Click ADD EMPLOYEE ...
    • 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 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 ...