Display Financial Analysis (tppss0701m000)

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.

 

Costs
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.
Overhead
If this check box is selected, the overhead costs are displayed.
Distributed Overhead Cost
If this check box is selected, the total budgeted costs are distributed over the duration of the activity.
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.
Revenues
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.

Project
The From and To fields define a range of: projects.
Project Selection
The From and To fields define a range of: projects.
Cost Analysis Version
The cost analysis version of the activity budget from which you want to collect the costs.
Time Unit to be Shown
Select the time unit you want to show in the graph.
Note

You must set this field to Day. However, you can specify the From and To dates that can be weekly, monthly, or daily. Infor 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.