| # Display Financial Analysis (Graph) (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. Related topics To register cost forecast Budgeted Costs If this check box is selected, the budgeted costs of the activity budget are displayed. Incl. 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 retrieved from advances, installments, progress payments and fixed fees. Incl. 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 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: The graph displays 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: 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. |