Display Financial Analysis Graph (For Home Page) (tppss0800m000)

Use this session to create a graph of the progression of costs and revenues during the project execution time. By analysis of the costs and revenues within a specific period, you can make a planning of the required or remaining amounts in the future.

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.

Field Information

Project

The code of the project.

Project

The description or name of the code.

Budget Cost Analysis Version

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

Cost Analysis Version

The description or name of the code.

Time Unit to be Shown

Select the time unit that must be displayed.

Note: You must set this field to Day. However, you can specify the From and To dates that can be weekly, monthly, or daily. LN displays the data based on these dates and checks for the specified date in the Reference Date field.
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:

For example:

  • Start activity = 2010/11/27
  • End activity = 2011/02/25
  • Actual specified on = 2010/12/08
  • Forecast specified for = 2011/02/02
  • Reference date = 2011/02/03

The total number of days from the start to end activity date is 91 days.

  • Budget = USD 125
  • Forecast = USD 150
  • Actual = USD 100

The explains a line going upto 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: actual + 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.
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 material costs are displayed.

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.

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 equipment costs are displayed.

Subcontracting Costs

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

Subcontracting Costs

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

Sundry Cost

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

Sundry Cost

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

Surcharges

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

Surcharges

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

Planned Revenues

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

Note: Planned revenues are obtained from advances and installments. Advance amounts are displayed at the start date of the activity.
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.
Related topics