Usage > Statistics > Forecasts 

This function is used to enter provisional values for statistical totals created by the statistics setup function which defines for each statistical code:

  • a set of analysis criteria (from 1 to 8), to which the company (and the site, if needed) can be added
  • 1 to 10 cumulated values that will be stored in the statistics totals table, with a frequency to be set Each value can be associated to provisional values (or "statistical budgets") or not.

Entering these data can be done:

  • from the general level (we can see the different values of the first criterion for which cumulated records exist)
  • for some finer values, for some values with specific criteria (then we go down to the level of detail desired)

When the statistics is defined at a global level, entering forecasts can only be done at this level. When the statistics is defined at the company level, the forecast must be entered company by company.  On the other hand, if the statistics is defined at the site level, the provisional values entered can be entered at the company or site level; but once a forecast is entered at the company level, it is impossible to enter forecasts in sites connected to the company (except if you delete the forecasts of the company before). Conversely, entering a forecast at the level of a site prevents you from entering a forecast at the level of the company it is linked to.

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Entry screen

    Presentation

    When entering statistical forecasts, a screen displays the main criteria and the columns with forecasts previously entered and allows you to enter or modify forecasts. These values are displayed when all the criteria have been entered, or when clicking the button  . It is possible to modify the criterion values at any time, in order to re-launch the modification.

    Close

     

    Fields

    The following fields are present on this tab :

    Block number 1

    It identifies the current statistical code. A set of totals based on one to eight crossed criteria is linked to each statistical code.

    Define the code for the company. It can be mandatory according to the level of definition of the statistics parameterization.

    Define the site code. It is mandatory if the company code is not assigned. In this case, it makes it possible to initialize the company code.

    • Start date (field DATDEB)

    Start date of the statistical process : this date must fall in the first period as a function of the periodicity defined.

    • End date (field DATFIN)

    End date for the statistical process : this date must fall in the last period as a function of the periodicity defined.

    • Criteria (field LIBEL)

    Used to display the current value of successive criteria, whilst moving between levels in provisions entry. The display is made in the form :

    CRITERION LEVEL 1 / CRITERION LEVEL 2 / CRITERION LEVEL 3...

    The number of criteria displayed depends on the level reached via the level change buttons.

    Grid

    • field NUMLIG

     

    • field LIBCLE

    Used to enter the criterion for which provisions will be entered.

    • Det (field FLG)

    This column is display only and contains an asterisk if the provision amount for the line derives from an aggregated of provision amounts entered at lower levels. If this is the case, it is impossible to directly modify the level of the provisions : it is necessary to descend to the lower levels using the button.

    Once a lower level of detail has been reached, it is possible to modify or delete the corresponding line and ascend to the level above.

    • Description (field INTCLE)

    Title associated with the previous code.

    • field AMT1

    Define the amount for the provision that is to be assigned for the given criterion and the statistical value.

    • field AMT2

     

    • field AMT3

     

    • field AMT4

     

    • field AMT5

     

    • field AMT6

     

    • field AMT7

     

    • field AMT8

     

    • field AMT9

     

    • field AMT10

     

    Close

     

    Specific Buttons

    The following fields are included on the window opened through this button :

    Selection

    Define the code for the company. It can be mandatory according to the level of definition of the statistics parameterization.

    Define the site code. It is mandatory if the company code is not assigned. In this case, it makes it possible to initialize the company code.

    • Start date (field DATDEB)

    Start date of the statistical process : this date must fall in the first period as a function of the periodicity defined.

    • End date (field DATFIN)

    End date for the statistical process : this date must fall in the last period as a function of the periodicity defined.

    Close

    Allows you to change the entry criteria via a dedicated screen which appears.

    The following fields are included on the window opened through this button :

    Block number 1

    • Initialization type (field TYPINI)

    Used to define the initialization type of the provision :

    • in the case of the real, the global provisional amounts will be calculated from the calculated statistics (for a period that is then entered). They are then distributed over the calculation period.
    • In the case of the provisional, a provision made on an earlier period to be entered is distributed.

    Block number 2

    • Level (field NIVEAU)

    Define the reference level for the statistics that will serve in the initialization of the current provision. This is used to define the statistics at a reasonable aggregation level without descending to greater detail.

    Thus, for example, if there is a statistic based on 5 criteria and the calculation is made at level 3, for each interaction of the first 3 criteria, carryout the total of the corresponding statistic and then calculate a provision at level 3 detail.

    • Start date (field DATDEBI)

    Used to indicate the statistical reference dates that will serve in the initialization of the provision.

    • End date (field DATFINI)

     

    Grid Variables

    • Variable (field VARNAM)

    Define the code for the variable for which the provisions are calculated.

    • Description (field AMTDES)

    Title associated with the previous code.

    • Increase (%) (field AUGMENT)

    These two fields are used to indicate the increase percentage that will be applied to the calculation basis as well as the rounded amount used.

    For example this amount can be 1, 10, 100, even 20 or 50.

    • Rounding (field ARROND)

     

    Close

    This button allows you to calculate a statistical forecast from an original amount that may be an actual amount established on any period, or a forecast on another period than the calculation period, by applying potential increase percentages. A window opens to set the parameters of the initialization.

    The following fields are included on the window opened through this button :

    Grid Variables

    • Variable (field VARNAM)

    Define the code for the variable for which the provisions are calculated.

    • Description (field AMTDES)

    Title associated with the previous code.

    • Increase (%) (field AUGMENT)

    These two fields are used to indicate the increase percentage that will be applied to the calculation basis as well as the rounded amount used.

    For example this amount can be 1, 10, 100, even 20 or 50.

    • Rounding (field ARROND)

     

    Close

    This button allows you to increase all or part of the amounts of a forecast by applying an increase percentage. A window opens to set the parameters of the increase.

    Allows you, when on a detail line, to go back to the level immediately above.

    Allows you , when on a line, to go down to the detail of the line in order to define the values of forecasts at a finer level.

    Error messages

    In addition to the generic error messages, the following messages can appear during the entry :

    No forecast on this code

    A statistical code on which no value has been set as being likely to be entered as forecast has been entered.

    Forecasts have already been entered at the level of the site

    Forecasts are being entered at the company level, whereas forecasts have already been entered at the site level.

    Forecasts have already been entered at the company level

    Forecasts are being entered at the level of a site, whereas forecasts have already been entered at the level of the company.

    Tables used

    SEEREFERTTO Refer to documentation Implementation

    Notes

    The forecasts can be entered in the form of integers only.

    Entering forecasts is done from date and to date, and is automatically adjusted according to the frequency of the statistics. If it is a monthly statistics, and if the dates entered are from 01/10/06 to 04/25/06, these dates are automatically re-displayed with the values 01/01/06 and 04/30/06.

    When the interval of entry covers several dates, the system automatically distributes the VALUE amount on the N periods by rounding the amounts distributed using the following rule:

    amount of the period P = rounded ( P * VALUE / N) - rounded ((p-1) *VALUE /N)

    For example, an amount is split on 3 periods:

    • An amount of 10 will be divided into 3,4,3
    • An amount of 11 will be divided into 4,3,4
    • An amount of 12 will be divided into 4,4,4

    If you wish to distribute the amounts in a different way , you must enter data at the finer level (by giving as entry period a unitary period taking into account the periodicity of the statistics).