Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Reconcile Labor Utilization with Drill Through

Use the Costpoint Planning reports to reconcile data on the Labor Utilization with Drill Through report.

These reports include the following:

  • Labor Hours Analysis

  • Hours Breakdown

  • Labor Cost Analysis

  • Raw Cost Breakdown

To reconcile the Costpoint Business Intelligence Labor Utilization Report with Drill Through with Costpoint Planning:

  1. Run the Labor Utilization report in Costpoint Business Intelligence.
  2. Obtain the data for each component of the utilization calculation by running the following Costpoint Planning reports, and then compile data to compare to the Utilization %.
    This allows you to independently calculate and confirm the Utilization %.
    1. Run the Labor Hours Analysis report in Costpoint Planning (Planning > Project Budgeting > Top Level (All Projects) Reports > Labor Hours Analysis) to list the labor hours for each project.
    2. Select Latest EAC.
    3. Run the Hours Breakdown report in Costpoint Planning (Planning > Project Budgeting > Active Level Reports > Hours Breakdown) to verify the labor utilization by hours.

      Calculate the standard hours and run a SQL script to identify the standard hours by period. These are computed by multiplying the number of work days by 8 hours. Work days are defined in the Subperiod table (eSub_PD.Work_Days).

      Select Latest EAC. The labor utilization calculation for hours is:

      EAC hours/Standard hours

      The report shows monthly EAC hours by employee, but you can expand the employee to view the breakdown by project for the drill-through.

    4. Run the Labor Cost Analysis report in Costpoint Planning (Planning > Organization Budgeting > Labor Analysis Reports > Labor Cost Analysis) to list the projects that each employee charged.

      Calculate the standard hours and run a SQL script to identify the standard hours by period. These are computed by multiplying the number of work days by 8 hours. Work days are defined in the Subperiod table (eSub_PD.Work_Days).

      Select Latest EAC. The labor utilization calculation for cost by employee is:

      EAC amount/(Standard hours * hourly amount)

      The labor utilization calculation for cost by generic staff is:

      EAC amount/(Standard hours * avg hourly amount)

  3. The report displays monthly EAC cost by employee, but you can expand the employee to view the breakdown by project for the drill-through.
    1. Determine the current hourly amount for each employee.
      This information is available to those users with access rights to the Costpoint EMPL_LAB_INFO.HRLY_AMT table. You can use a SQL script to determine this information.
    2. Find the average hourly rate for generic staff.
      Attention: To do this, you must refer to the Maintain Generic Staff report at (Planning > Organization Budgeting > Controls and Utilities > Maintain Generic Staff ).
    3. Run the Raw Cost Breakdown report in Costpoint Planning (Planning > Project Budgeting > Active Level Reports > Raw Cost Breakdown) for each project that was listed in the Labor Cost Analysis report to display the unburdened labor costs.
      If an employee has charged multiple projects, you must run this report for each charge and then manually compile the total EAC labor costs.
  4. Export the data into an Excel spreadsheet to view all calculations and comparisons.