Stock > Reorders > Demand forecasts 

This function is used to enter and view the demand forecasts for a product at a given site.

This function generates orders of the type SOS in the WIP.

These forecasts can be manually entered period by period or automatically based on the distribution information which can include the seasonality curve linked to the product or by duplicating the forecasts for another product.

 

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    This function is composed of a left list with all the products in the database and a screen presenting the forecasts for the selected product.

    Entry screen

    Presentation

    The selections :

    The site: mandatory field, the user's default site is proposed by default.

    The product: mandatory field.

    Date range: the start date is initialized by the horizon end date for the request or by the current date if there is not one.

     

    The request horizon, the seasonality curve, the economic lot and the technical lot are loaded after selecting the product.

    Forecast display

    On display, the forecast grid is used to view the sales forecasts already existing for each month (a grid line by month).

    The quantities are detailed by week for each month.

    The last 2 columns in the grid specify the start and end date for the month.

    For each forecast line, at the end of the line entry the totals by month are displayed and at the end of the general entry the percentage information is displayed.

    These forecasts can be modified directly in the grid, deleted or modified.

    If the firm and/or planned orders have been requested (boxes ticked), they are inserted in the forecast sequencing.

     

    At the level of each line, using a contextual button, it is possible to:

    view the calendar for the month

    view the orders in progress linked to the line

    group the next line or lines.

    Forecast creation

    Manual creation of forecasts

    If the forecasts exist already, it is sufficient to modify, delete or add lines.

    If no forecast exists, it is possible to enter them directly period by period in the grid.

     

    Creation of the forecast based on the seasonality information

    The button opens a window used to give the information necessary for the calculation. That is to say:

    the date range (the calculation period is pre-loaded with the horizon entered in the main window)

    the quantity to be distributed initialized by the total amount for each line.

    and the distribution method for this quantity in the horizon (week by week, all on week 1 of the month, all on week 2 of the month, all on week 3 of the month or all on the last week).

    It is possible to associate a seasonality curve to these data. By default the system proposes the curve associated with the product in the product-site record, but this field can be modified.

    If a seasonality curve is entered, the quantity to be distributed is adjusted over time by the season.

    Once the calculation criteria are entered, the use of the OK button replenishes the grid with the newly loaded forecasts.

    It is possible to add the forecasts or to modify the forecasts created in this way directly in the grid.

    The demand forecasts created in this way are taken into account by the MRP calculation process for the replenishment of the product concerned, taking into account, depending on the setup, the demand horizon planned for the product.

     

    Forecast creation by duplication

    The "Forecast duplication" left list is used to duplicate the forecasts for another product for the period included between a date range.

    For that purpose, it is necessary to select from the "Demand forecasts" left list the product that will have its forecasts modified. Then, the forecasts that are to be duplicated are selected from the "Forecast duplication" left list. Finally it is saved in order to take into account the modification.

    Close

     

    Fields

    The following fields are present on this tab :

    Block number 1

    Use this field to define the storage and/or production site.

    The site defined on the user record is displayed by default but can be amended.

     A storage site has the Stock check box in the Details section selected.

    Reference of the product for which the transaction needs to be carried out. It must be defined for the selected site.

    • Start date (field STRDAT)

    Start date used to select the records to be processed.


    • End date (field ENDDAT)

    End date used in the selection of the records to be processed.

    Block number 2

    • Demand horizon (field FOHENDDAT)

     

    • EOQ (field REOMINQTY)

     

     

     

    • Technical lot (field MFGLOTQTY)

     

     

    Grid

    • Year (field YEA)

     

    • Months (field MON)

    Calculation month

    • Date (field YEAMONTXT)

     

    • Order status (field TYPDES)

     

    • Monthly total (field TOTQTY)

     

    • % of total (field TOTPRC)

     

    • Qty week 1 (field WEEQTY1)

    Compose or validate the forecast quantity for the week





    • Qty week 2 (field WEEQTY2)

     

    • Qty week 3 (field WEEQTY3)

     

    • Qty week 4 (field WEEQTY4)

     

    • Qty week 5 (field WEEQTY5)

     

    • Beginning of month (field DAYSTR)

     

    • End of month (field DAYEND)

     

    Close

     

    Specific buttons

    This button is used to load the forecasts already existing for the selected product and the date range required. If the end date is not entered, all the forecasts after the start date are loaded.

    This button opens a window grouping the different selection criteria:

    the product: to display the forecasts for another product at the same site

    the date range: to display the forecasts for the product on a different date range

    the display of the customer orders: firm and/or planned, if the boxes are ticked, these orders are inserted into the forecast sequencing

    the log: if the box is ticked, during the forecast validation, there will be a log of the demand forecasts entered, calculated and not modified.

     

    This button is used to group several forecasts within a period.

    It is first necessary to indicate the start and end months for the grouping. For the end month, it is possible to tick the 'end of grid' box that will load the end month with the date of the last forecast.

    Then, it is necessary to select the grouping and rounding methods that will be used.

    This button opens a window that gives the information required for the calculation. That is to say:

    the date range (the calculation period is pre-loaded with the horizon entered in the main window)

    the quantity to be distributed initialized by the total amount for each line.

    and the distribution method for this quantity in the horizon (week by week, all on week 1 of the month, all on week 2 of the month, all on week 3 of the month or all on the last week).

    This button is used to access the stock inquiry.

    This button is used to access the WIP inquiry.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation