For the project management hours performed that week, the project controls manager claims quantities directly at the budget level (instead of in the field).
The project controls manager also gets an updated Excel file from the superintendent for materials and indirects claimed that week (since the aren’t tracked in their timesheet system).
The project controls manager imports them into the Cost Breakdown Structure.
Learn how to work within the InEight Control application to update quantities, hours, and costs.
In order to view earned value metrics, you’ll need up-to-date values reflected in your current budget, current estimate, and project forecast. To keep these values current, quantities, man-hours, and costs can be brought into InEight Control through several different methods. You may find that you alternate between some of these methods based on your specific needs. Review the workflow below to see how these values can be brought into Control.
Not all quantities are required to be claimed within InEight Plan, which is mostly reserved for progressing direct labor or subcontracts. For cost items that don’t need to be broken down into components or tracked on daily plans, you can claim directly in InEight Control, viewing progress side by side with your budget.
Ideas on Site
Actual quantities completed are required for all terminal cost items in order to drive earned value and accurately calculate automated forecast methods. Your project team should have a plan for how and when quantities will be claimed for cost items not being progressed through InEight Plan and Progress.
To enable claiming in Plan and Progress, deselect Hide in Plan, Progress, and Design for the cost item in InEight Control.
Follow the steps below to claim quantities manually.
From the Control CBS, click the context menu on the cost item and select Actuals details.
A slide-out panel will open to Claim Actuals > Quantities. Enter the amount in the Claimed quantity field.
Click Apply.
To learn more about claiming quantities in Control, watch this video:
Another option is to set up a claiming template at the beginning of the job that you can claim against through the Claim multiple CBS quantities feature. This template should include all terminal cost items that need to be claimed directly in Control on a weekly or monthly basis.
The steps below walk through how to set up and use a template for claiming multiple quantities.
From within InEight Control, select Actions > Claim multiple CBS quantities.
On the resulting window, you can select the cost items to add to your template from the CBS.
Select Save as template to open the Save template window.
From here you can name the template, then click Save.
Once the template is created, you can select Load template to load it into the main window for claiming.
Use the Claimed quantity column to update claimed quantities.
Click Claim when finished.
The Actual qty (to date) for the cost items claimed will update accordingly.
If necessary, you can either copy or directly enter your claimed quantities into Excel and then import them from Excel into InEight Control.
Follow the steps below to import via Excel.
|
|
|
|
| Populate data in Excel | Import to InEight Control | Map to Control fields | Run Import |
|
|
|
|
|
|
|
|
When the import is completed successfully, claimed quantities will appear in the Actual qty (to date) field.
Access the following link to learn more:
You will likely track hours and associate costs separately from quantities, so they can be sent through payroll processing.
Once you have current actuals processed through your payroll/ERP system, if your company doesn’t have a direct integration from ERP to Control, you can update Control via Excel import.
You can also manually enter hours and costs into Control if needed (e.g., for one-off adjustments).
If your organization is not using a direct integration with your ERP, you can export costs and hours from your ERP to Excel. Assuming the exported data is in the proper format, you can then import the actual costs and hours into InEight Control via Excel import.
For import, you will typically use the following columns in the Excel template:
| COLUMNS TYPICALLY USED FOR IMPORT |
|
WBS Phase Code Actual Man-Hours Actual Cost Posting Date* Cost Category* |
| *required field |
See the workflow below for importing actuals using Excel:
|
|
|
|
| Populate data in Excel | Import to InEight Control | Map to Control fields | Run Import |
|
|
|
|
|
|
|
|
|
Below is an example of an Excel file formatted and ready to import actual values:
Once the import is completed successfully, the updated costs and man-hours will appear in the Actual cost (to date) and Actual MHrs/unit (to date) fields in Control.
Access the following link to learn more:
Follow the steps below to claim hours and costs manually.
From the Control CBS, click the context menu on the cost item and select Actuals details.
A slide-out panel will open. Select the appropriate tab from the left.
Enter the actuals values.
Click Apply.
To learn more about claiming hours and costs in Control, watch this video:
Additional Information
9977 N 90th Street, Suite 250 Scottsdale, AZ 85258 | 1-800-637-7496
© 2024 InEight, Inc. All Rights Reserved | Privacy Statement | Terms of Service | Cookie Policy | Do not sell/share my information
