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

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. 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).

      In the Report Type field, select Budget.

      In the Budget Type field, select 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.

   3. 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).

      In the Report Type field, select Budget.

      In the Budget Type field, select 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.