In uDesigner, data elements can be added that allow you to enter and view cost data on 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, the Activity Latest Progress As Of data element can be added to allow you to track the date of the last change to an activity.
Note: Unifier refreshes the cost data when you choose File > Refresh in a Schedule Sheet and refresh immediately or set up a refresh frequency. See Refreshing Schedule Sheet data for details.
In the activity setup performed by the Administrator, one of more CBS Codes can be associated with an activity. The value carried by the Total Cost data element on add to a Schedule Activity Attribute form gets passed onto these CBS codes as the result of calculations such as data roll up 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 an Schedule Activity Attribute form, the system will scan through all of the activities and associated CBS codes.
- The system will accumulate all of 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.
The following 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.00 | |
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.