Entering and Viewing Cost Data
You can add data elements that allow users to enter and view cost data on their schedule sheets. These data elements are Activity Cost 1 (and Activity Total Cost 1 Per CBS) and Activity Cost 2 (and Activity Total Cost 2 Per CBS). The Cost and Per CBS data elements have a predefined association between them. Also, you can add a data element (Activity Latest Progress As Of) that allows users to view the date of the last activity data change.
In Unifier activity setup, users can associate one or more CBS Codes to an activity. The value carried by Total Cost data element on activity form gets passed onto these CBS codes as the result of calculations such as data rollup to a Cost Sheet, or earned value calculations. The logic used by the Activity Cost 1 and Activity Cost 2 and the associated Activity Total Cost 1 Per CBS and Activity Total Cost 2 Per CBS data elements is based on the association of an activity to a CBS code.
The values for Activity Total Cost 1 Per CBS and Activity Total Cost 2 Per CBS data elements are calculated by the system based on the corresponding Activity Cost 1 or Activity Cost 2 data element values.
These are the steps the system follows to calculate values for Activity Total Cost 1 Per CBS and Activity Total Cost 2 Per CBS data elements:
- If the combination of Cost and Per CBS data elements are used on a Schedule Activity Attribute form, the system will scan through all the activities and associated CBS codes.
- The system will accumulate all the values in the Activity Cost 1 or Activity Cost 2 data elements for all activities per CBS code associated with each activity.
- Use the total value calculated in step 2 per CBS code as the value for each Activity Total Cost 1 Per CBS and Activity Total Cost 2 Per CBS data element specified for each activity.
- Each activity gets a total value calculated in step 2 based on the CBS code associated with it.
This example explains these calculations. For this example, the data elements Activity Cost 1 and Activity Total Cost 1 Per CBS have been added to the attribute form:
Activity Name | Activity Cost 1 | Activity Total Cost 1 Per CBS |
|---|---|---|
Control Account 1 | $28,000.00 |
|
Control Activity 1.1 | $19,000 |
|
Control Point 1.1.1 | $10,000.00 | $28,000.00 |
CBS - 1 | $10,000.00 |
|
Control Point 1.1.2 | $9,000.00 | $28,000.00 |
CBS - 1 | $9,000.00 |
|
Control Activity 1.2 | $9,000.00 | |
Control Point 1.2.1 | $5,000.00 | $28,000.00 |
CBS - 1 | $5,000.00 |
|
Control Point 1.2.2 | $4,000.00 | $28,000.00 |
CBS - 1 | $4,000.00 |
|
Control Account 2 | $20,000.00 |
|
Control Activity 2.1 | $20,000.00 |
|
Control Point 2.1.1 | $8,000.00 | $20,000.00 |
CBS - 2 | $8,000.00 |
|
Control Point 2.1.2 | $12,000.00 | $20,000.00 |
CBS - 2 | $12,000.00 |
|
In the above example, Control Point 1.1.1 has a value $28000.00, which was arrived at by adding the value of CBS - 1 across all activities.
Last Published Monday, June 3, 2024