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
Refer to documentation Implementation
Screen management
Entry screen
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.
Block number 1
| Code (field COD) |
|
It identifies the current statistical code. A set of totals based on one to eight crossed criteria is linked to each statistical code. |
| Company (field CPY) |
|
Define the code for the company. It can be mandatory according to the level of definition of the statistics parameterization. |
| Site (field FCY) |
|
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 :
The number of criteria displayed depends on the level reached via the level change buttons. |
| 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 |
Specific Buttons
|
Criteria
Allows you to change the entry criteria via a dedicated screen which appears. Selection
|
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.
Block number 1
| Initialization type (field TYPINI) |
|
Used to define the initialization type of the provision :
|
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) |
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.
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) |