Reconcile Project Report with Labor Detail

Use the Costpoint Planning reports to reconcile data on the Project Report with Labor Detail.

These reports include the following:

  • Project Status

  • Current Forecast

  • Hours Breakdown

  • Burdened Cost Breakdown

To reconcile the Costpoint Business Intelligence Project Report with Labor Detail report with Costpoint Planning:

  1. Run the Project Report with Labor Detail in Costpoint Business Intelligence.
  2. Run the Project Status report (Planning > Project Budgeting > Supplemental Reports > Project Status) in Costpoint Planning.
  3. Select Revenue.
  4. Compare the following:

    Costpoint Business Intelligence: ITD to <prior period> Column

    Costpoint Planning Report: (Fiscal Year To Date Column + Prior Years Column – Current Period Column)

    Total Revenue

    Revenue

    Total Labor Hours

    Labor Hours

    Total Labor cost

    Labor Cost

    Total Cost

    Total Expense

    Profit/Loss

    Profit

    Costpoint Business Intelligence: Current Period Actuals Column

    Costpoint Planning Report: Current Period Column

    Total Revenue

    Revenue

    Total Labor Hours

    Labor Hours

    Total Labor cost

    Labor Cost

    Total Cost

    Total Expense

    Profit/Loss

    Profit

  5. Expand the Labor Hours section to view the actual hours by employee.
    Check the actual hours by employee.

    Costpoint Business Intelligence: ITD Actual Column

    Costpoint Planning Report: Contract to Date Column

    Actual Hours — You can expand these fields to view employee detail

    Total Labor Hours — you can expand these fields to view employee detail

  6. Run the Current Forecast report in Costpoint Planning (Planning > Project Budgeting > Active Level Reports > Current Forecast).
  7. Compare the following for the six months of forecasts between the two reports:
    Note: This report must be run for the next period.

    Costpoint Business Intelligence: Total Forecast Budget Column

    Costpoint Planning Report: Forecast Total Column

    Total Revenue

    Revenue

    Total Labor Cost

    Labor Cost

    Total Cost

    Add the following columns: Labor Cost, Non-Labor Cost, and Indirect Cost.

    Profit/Loss

    Profit

    EAC

    Bgt/EAC Total

  8. Select Latest EAC.
  9. Run the Hours Breakdown report in Costpoint Planning (Planning > Project Budgeting > Active Level Reports).
  10. Compare the following:

    Costpoint Business Intelligence: EAC Column

    Costpoint Planning Report: Total HRS BGT Column

    Total Labor Hours

    Total

    Lines by employee from the 6 monthly forecast columns and EAC column

    Lines by employee from the 6 Monthly Forecast columns and Total HRS BGT column

  11. Run the Burdened Cost Breakdown report (Planning > Project Budgeting > Active Level Reports > Burdened Cost Breakdown). Compare the following for ITD to <prior period> and Current Period Actuals amounts:

    Costpoint Business Intelligence: ITD to <prior period> Column

    Costpoint Planning Report: ITD Total – Current Period

    Total Labor Cost with Burden

    Labor

    Other Direct Cost with Burden

    Calculated by Total - Labor

    Total Costs

    Total

    Costpoint Business Intelligence: Current Period Actuals Column

    Costpoint Planning Report: Current Period

    Total Labor Cost with Burden

    Labor

    Other Direct Cost with Burden

    Calculated by Total - Labor

    Total Costs

    Total

    Costpoint Enterprise Report Current Period Actual Column

    Budgeting and Planning Report Current Period

  12. Run the Burdened Cost Breakdown report (Planning > Project Budgeting > Active Level Reports > Burdened Cost Breakdown).
  13. Select Latest EAC.
  14. Compare the following for the six months of forecasts between the two reports:

    Costpoint Business Intelligence: ETC Periods

    Costpoint Planning Report: ETC Period

    Total Labor Cost with Burden

    Labor

    Other Direct Cost with Burden

    Calculated by Total - Labor

    Total Costs

    Total

    Costpoint Business Intelligence: EAC column

    Costpoint Planning Report: Tot Burd Budget column

    Total Labor Cost with Burden

    Labor

    Other Direct Cost with Burden

    Calculated by Total – Labor

    Total Costs

    Total

    Costpoint Business Intelligence: Total Forecast Budget column

    Costpoint Planning Report: Forecast Total column

    Total Labor Cost with Burden

    Labor

    Other Direct Cost with Burden

    Calculated by Total - Labor

    Total Costs

    Total