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:
- Run the Project Report with Labor Detail in Costpoint Business Intelligence.
- Run the Project Status report (Planning > Project Budgeting > Supplemental Reports > Project Status) in Costpoint Planning.
- Select Revenue.
-
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
-
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
- Run the Current Forecast report in Costpoint Planning (Planning > Project Budgeting > Active Level Reports > Current Forecast).
-
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
- Select Latest EAC.
- Run the Hours Breakdown report in Costpoint Planning (Planning > Project Budgeting > Active Level Reports).
-
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
-
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
- Run the Burdened Cost Breakdown report (Planning > Project Budgeting > Active Level Reports > Burdened Cost Breakdown).
- Select Latest EAC.
-
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