Display Financial Analysis (Graph) (tppss0706m000)

Use this session to modify the financial analysis graph. You can make a planning of the required or remaining amounts in the future by analyzing the costs and revenues within a specific period.

Select the appropriate check boxes to display the associated options.

Note: 
  • You can only use the budgeted costs of an activity budget.
  • If you clear the Budgeted Costs check box, you cannot distribute budgeted costs over the activity.

The graph shows a cost line and a revenue line. Both lines consist partly of actual amounts and partly of planned amounts. Before the reference date the actual costs and revenues are shown. After the reference date the planned costs and revenues including the forecast are shown.

You can modify the titles of the fields in the Chart Options group box. You can reset the graph using these modified titles.

Field Information

Selection Range
Project

The From and To fields define a range of: projects.

Settings
Budget Cost Analysis Version

The cost analysis version of the activity budget from which you want to collect the costs.

Description

The description or name of the code.

Reference Date

The reference date must be between the planned start and finish date of the project. If the forecast and actual costs are given for a started activity, the following example holds:

The graph displays a line going up to 274, which is calculated in the following way:

  • On the reference date the free budget is only 30, that is, 125 divided by the days the activity runs, multiplied by the days from the reference day on left to finish the activity, so: (125/91)*22.
  • The forecast is 144, that is, 150 divided by the days of the effective forecast of the activity multiplied by the days left from the reference date on: (150/23)*22.
  • The actual costs are released at 2010/12/08.
  • The formula is: actuals + forecast + budget = 100 + 144 + 30 = 174
Note: If the forecast lies before the activity start date, the forecast starts counting on the activity start date. If you use terms of payment, the offsetting influences the release of the budget.
From

The date from when the financial analysis graph is displayed.

To

The date until when the financial analysis graph is displayed.

Costs and Revenues
Budgeted Costs

If this check box is selected, the budgeted costs of the activity budget are displayed.

Include Forecast

If this check box is selected, the forecasts are included in the budgeted costs.

Actual Costs

If this check box is selected, the actual costs are displayed.

Material Costs

If this check box is selected, the material costs are displayed.

Material Costs

If this check box is selected, the total budgeted costs are distributed over the duration of the activity.

Note: If this check box is cleared,, the total budgeted costs are allocated to the start date of the activity
Labor Costs

If this check box is selected, the labor costs are displayed.

Labor Costs

If this check box is selected, the total budgeted costs are distributed over the duration of the activity.

Note: If this check box is cleared, the total budgeted costs are allocated to the start date of the activity.
Equipment Costs

If this check box is selected, the equipment costs are displayed.

Equipment Costs

If this check box is selected, the total budgeted costs are distributed over the duration of the activity.

Note: If this check box is cleared,, the total budgeted costs are allocated to the start date of the activity.
Subcontracting Costs

If this check box is selected, the subcontracting costs are displayed.

Subcontracting Costs

If this check box is selected, the total budgeted costs are distributed over the duration of the activity.

Note: If this check box is cleared,, the total budgeted costs are allocated to the start date of the activity.
Sundry Cost

If this check box is selected, the sundry costs are displayed.

Sundry Cost

If this check box is selected, the total budgeted costs are distributed over the duration of the activity.

Note: If this check box is cleared,, the total budgeted costs are allocated to the start date of the activity.
Surcharges

If this check box is selected, the costs of surcharges are displayed.

Surcharges

If this check box is selected, the total budgeted costs are distributed over the duration of the activity.

Note: If this check box is cleared,, the total budgeted costs are allocated to the start date of the activity.
Planned Revenues

If this check box is selected, the planned revenues are displayed.

Note: Planned revenues are retrieved from advances, installments, progress payments and fixed fees.
Include Forecast

If this check box is selected, the forecasts are included in the planned revenues.

Actual Revenues

If this check box is selected, the actual revenues are displayed.

Note: Actual revenues are registered when project data is transferred in the Transfer Transactions to Invoicing (tppin4200m000) session.
Chart Options
Chart Title:

The title for the chart.

Subtitle:

The subtitle for the chart.

X-axis Title:

The title for the X axis.

Y-axis Title:

The title for the Y axis.