Cash Flow Analysis enables you to gain an idea of the financial health and liquidity of your business, by showing what is actually available to use to meet your business needs.
You can use the CBS-type Cash Flow curve to get the Units, or Cost Data, from the Activity Sheet as per CBS code either at the Activity level, at the Resource level.
You can use the Baseline Cash Flow curve to get the Planned, Remaining, and At Completion units. In this case, the total for each CBS Code and Cost comes from the Cost Sheet column, the Planned, or the At Completion costs (from the Activity Sheet).
Similarly, the Forecast Cash Flow curve brings the Planned, Remaining, and At Completion units, or the costs per CBS Code (from the Activity Sheet).
You can use the Spends-type Cash Flow curve to get the Actual Costs from the Activity Sheet, in addition to getting the costs from the Cost Sheet column, or from the P6 Summary Sheets.
You can perform Cash Flow analysis based on the budgets, forecast projections, and actuals received by using the Planned, Remaining Cost, and Actual Costs received from the Activity Sheet. In summary, for:
Cash Flow curves: CBS Detail, Baseline, and Forecast (Activity level)
Ability to define Baseline and Forecast Cash Flow curves with the Activity Sheet (Activity level) selected as a source for distribution or cost. In this scenario:
The period distribution for each CBS Code will be received at Activity level, from the selected Activity Sheet. The value is the sum of all the planned units for each CBS code by day which it will be used to distribute the costs. The schedule will be disabled once you select Activity Sheet as the distribution source.
The cost distribution for each period can either be calculated based on the units and total cost received from cost sheet column, or based on the cost spread received from Activity Sheet (Activity level).
You can get data either from the current project or the baseline.
Cash Flow curves: CBS Detail, Baseline, and Forecast (Resource level)
Ability to define Baseline and Forecast Cash Flow curves with the Activity Sheet (Resource level) selected as a source for distribution or cost. In this scenario:
The period distribution for each CBS Code will be received at Resource level, from the selected Activity Sheet. The value is the sum of all the planned units for each CBS code by day which it will be used to distribute the costs. The schedule will be disabled once you select Activity Sheet as the distribution source.
The cost distribution for each period can either be calculated based on the units and total cost received from cost sheet column, or based on the cost spread received from Activity Sheet (Resource level).
You can get data either from the current project or the baseline.
Cash Flow curves: CBS Detail, Spends (Activity level)
You can define Spends Cash Flow curves when the Activity Sheet (Activity level) is selected as a source for cost. The value is the sum of all the actual costs for each CBS code per day across the activities.
Cash Flow curves: CBS Detail, Spends (Resource level)
You can define Spends Cash Flow curves when the Activity Sheet (Resource level) is selected as a source for cost. The value is the sum of all the actual costs for each CBS code per day across the activities.
Similar to the P6 Summary Sheet, you can use the Activity Sheet as a source in Cash Flow.
The following table explains the details:
Type | CBS |
|---|---|
Baseline (Distribution) | Activity Sheet (Activity Level) Sum all the planned units for each CBS code by day which will be used to distribute the costs. You can select either the current project or the baseline. (Schedule disabled) Activity Sheet (Resource Level) Sum all the planned units for each CBS code by day which will be used to distribute the costs. You can select either the current project or the baseline. (Schedule disabled) |
Baseline (Cost) | Cost Sheet Column Activity Sheet (Activity Level) Sum all the planned costs for each CBS code by day. You can select if this is from the current project or the baseline. Activity Sheet (Resource Level) Sum all the planned costs for each CBS code by day. You can select if the from the current project or the baseline. |
Baseline (Schedule) | Schedule is derived from the unit distribution. |
Spends (Cost) | Activity Sheet (Activity Level) Sum all the actual costs for each CBS code by day. Activity Sheet (Resource Level) Sum all the actual costs for each CBS code by day. |
Forecast (Distribution) | Activity Sheet (Activity Level) Sum all the remaining or at completion units for each CBS code by day which will be used to distribute the costs. (Schedule disabled) Activity Sheet (Resource Level) Sum all the remaining or at completion units for each CBS code by day which will be used to distribute the costs. (Schedule disabled) |
Forecast (Cost) | Cost Sheet Column Activity Sheet (Activity Level) Sum all the planned costs for each CBS code by day. Activity Sheet (Resource Level) Sum all the remaining or at completion costs for each CBS code by day. |
Forecast (Schedule) | Schedule is derived from the unit distribution. |