Job Cost Analysis

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 you would like, then save that view with a name. Click here to understand views.

There are a few columns that require some explanation.  A complete list of columns and their calculations can be found here.

TC Cost Excluded/Included

This is the cost of time card entered but not posted to job cost in Spectrum ERP.  The cost is either Included  in the JTD cost or Excluded from the JTD Cost based on your system setting.  Time Card source can be either time cards entered in Spectrum, or time cards entered in JobSiteForecast, based on your system settings.

Projected Cost ERP 

This is the projected cost currently in Spectrum based on the overnight refresh.  You can refresh this data at any time by clicking on the REFRESH button.  

Projected Cost JSF

This is the projected cost currently calculated by JobSiteForecast.  If this is different from the Projected Cost ERP by +/- $10 then the column will be highlighted YELLOW (for Active or Inactive phases) or RED (for Complete phases).  

Projections

You can edit the JSF Projected Cost column and then SYNC it to Spectrum ERP.  You can only make edits to the current week.

Editing the Projected Cost JSF depends on the cost type.  It to very helpful to sort the screen by Cost Type before you start.
  1. For LABOR cost types, you must edit the Percent Complete, Hours to Complete, or Hours at Complete.  You cannot edit the cost directly.  By changing the hours projection, the system will calculate the projected cost.
  2. For LABOR cost types based on quantities (see your your system settings) you will need to update quantities in Spectrum.  The overnight refresh will get all those changes. 
  3. For NON-LABOR cost types, you can click in the Projected Cost JSF field and change the number.
After making all your changes click SAVE DETAILS.  This will save your changes to the JobSiteForecast server.

SYNC to Spectrum

If you wish to "sync" those projections to Spectrum ERP, then click the SYNC button. This will transfer all your changes to Spectrum, it waits a few seconds and then it reads back the Spectrum projection and refreshes the screen.

Data Transferred to Spectrum:
  1. Projected Cost
  2. Projected Hours at Complete

IMPORTANT: You must NOT have the Spectrum job projection window open or else Spectrum will set the entries to zero.

If the item is highlighted in RED, this means the phase code status is COMPLETE and this change will be ignored by Spectrum unless you change the status in Spectrum before finalizing the SYNC.

If the item is highlighted in YELLOW, it will be updated in Spectrum once the SYNC is complete.

If the transfer is successful, all the YELLOW/RED highlights will clear, signaling the two systems are in sync.  Note:  Spectrum can take up to 30 seconds to post the changes, so if the transfer is not successful, wait 30-60 seconds then click REFRESH to refresh everything. DO NOT click the SYNC button again.

If you want to see the posting to your job projection in Spectrum, then run Job Cost | Reports | Projected Cost History.

Master Jobs

IMPORTANT:  If this is a master job with sub-jobs, the data in JobSiteForecast is just the phase codes assigned to the Master job and does NOT include the sub-jobs.  There will be a warning message if this is a master job "Warning this job has sub-jobs <job1>, <job2>...".  Spectrum requires that job projections are done individually anyway.

If you want to compare the totals between the two system then in Spectrum go to Cost Activity and Group By Job.


    • Related Articles

    • Cost Summary

      This screen provides a cost summary of each job. This screen can be grouped by project manager, geographical area or other parameters on the job master. See the article on Screen Views. The Projected Cost ERP column is the current projection in ...
    • 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 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 ...
    • 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 ...
    • Job Trend

      This screen will provide a graph of the weekly job performance since the job inception. The chart provides the following options using the drop down to: Projected Hours Over (Under) - default Actual/Earned Production This Period Projected Cost Over ...