Related topics
The Forecast file contains period forecast and demand statistics per item/warehouse for each forecast period. It contains the future forecast periods for one year, and historical forecast periods for one or two years, depending on how you defined the History, no of years field in the IC control file.
The future periods contain forecast information for each period. The historical forecast periods and the present forecast period contain the actual demand value for each item/warehouse and the forecast information for each period. The forecast information in this file is calculated for each item/warehouse combination when the Inventory calculations program is executed.
The purpose of this routine is to allow you to maintain the forecast information and the demand statistics for each item/warehouse combination in the system.
Options
Selection fields
- Item
- Displays the code that identifies the item.
- Description
- Displays the item description.
- Whs
- Displays the warehouse of the item.
Work with forecasts (INVD00105)
This panel displays the existing forecast information and demand statistics for the item/warehouse combination specified on the previous panel, and which displayed in the header. The periods are listed in descending period order. Both passed, current and future periods are displayed, and a cursor is positioned at the current period.
Options
| I/C calc | Only displayed in Maintenance mode. Select this option to run I/C calculations. IC calculations will be processed from the selected starting period up to the last period contained in the Forecast file. IC calculations are not allowed if the selected period is greater than the present period. |
Function keys
| Shift info | Toggle between viewing:
|
| Cust demand | View the demand per period for a customer. |
Selection fields
- Item
- Displays the code and description that identify the item.
- Warehouse
- Displays the warehouse of the item.
- Unit
- Displays the item unit, but can be changed.
- Period
- Displays the forecast period number (within the year).
- Desc
- Displays the description of the forecast period.
- Forecast
- Displays the calculated period forecast in stock units. This field can only be maintained by clicking Forecast adjustment.
- Cust. frcst
- Displays customer forecast in stock units. Customer forecast is retrieved from delivery schedules received from the customer.
- Base forecast
- Displays the base forecast in stock units.
- Demand
- Displays the demand value for this item/warehouse combination for this period. This value is retrieved from the Sales order cycle. It is the actual demand, not consumption that is updated. In the case of item substitutions, demand is updated for the original item requested. The period to which demand is posted is decided from the order line requested date.
- Adjustment
- Displays the demand adjustment.
- Mvmt
- Displays the number of order lines (from the sales order cycle) for this item/warehouse combination for this forecast period. The number reflects the requested delivery date, not actual delivery date. That is, the date when the item was demanded, not the date when it was delivered. This data is used in setting the movability code for this item/warehouse combination.
- Copied
- Indicates if the demand values for this item/warehouse combination were copied from another item/warehouse combination in the Item file.
- Lock
- Indicates if the forecast for this item/warehouse combination and period is locked.
Work with forecasts (INVD00107)
On this panel, you can maintain forecast information and demand statistics for the item/warehouse combination displayed in the header.
Function keys
| Forecast adjustment history | Access the Forecast file enquiry – Adjustment history function, which displays changes made to the Forecast and Demand adjustment fields. |
| Forecast adjustment | Only displayed in Maintenance mode. Access the Forecast adjustment function, where you can maintain the Forecast and Demand adjustment fields. |
| Promotion history | Only displayed if there are more than one sales promotion active for the same item/warehouse/period. View promotion history. |
- Item
- Displays the code and description that identify the item.
- Warehouse
- Displays the warehouse of the item.
- Forecast period
- Displays the forecast period number and description.
Forecast
- Period forecast
- Displays the calculated period forecast in stock units. This field can only be maintained by clicking Forecast adjustment.
- Lock forecast
- NO indicates that the forecast for this item/warehouse combination and period is not locked. To lock (or freeze) the forecast for this period, set this field to YES. By locking the forecast, the Inventory calculations program will not recalculate the forecast value for the period. You can lock the present period forecast and any future period forecasts for any item/warehouse combination, but you cannot lock a historical period forecast.
- Customer forecast
- Displays customer forecast in stock units. Customer forecast is retrieved from delivery schedules received from the customer. Note: This field is set to 0 (zero) if IBS Manufacturing is installed activated and the forecast is retrieved from a requirement forecast.
- Base forecast
- Displays the base forecast in stock units.
- Dependent forecast
- Only shown if IBS Manufacturing is installed and activated in the company in which you are working. Displays the calculated dependent forecast in stock units.
- Level forecast
- Displays the calculated level forecast in stock units.
- Speculation inv
- Displays the speculation inventory that is included in the forecast calculation. The speculation inventory is defined in the demand plan and this type of forecast is used for introduction of new products.
- Trend forecast
- Displays the calculated trend forecast, if you have activated the trend forecast function in the Inventory management item file for this item/warehouse combination.
- Used Demand plan qty
- Only shown if IBS Demand plan is installed and activated. Displays the used demand plan quantity.
- Additional forecast
- Only shown if IBS Demand plan is installed and activated. Displays the forecast quantity that is retrieved from a demand plan of type Additional forecast. This quantity is included in the Period forecast entry.
- Used SOP qty
- Only shown if IBS Sales and Operation plan is installed and activated. Displays the used Sales and Operation plan quantity.
- Suggested SP qty
- Only shown if IBS Supply plan is installed and activated. Displays the suggested Supply plan quantity.
- Total promotion qty
- Displays the total quantity of all sales promotions.
Demand
- Demand
- Displays the demand value for this item/warehouse combination for this period. This value is retrieved from the Sales order cycle. It is the actual demand, not consumption that is updated. In the case of item substitutions, demand is updated for the original item requested. The period to which demand is posted is decided from the order line requested date.
- Net demand
- Displays the net demand. If a manual demand adjustment has been made, this record equals:
Demand (+ or -) Demand adjustment This record cannot be negative. Net demand is used for calculating forecast for the next forecast period. You cannot change this field.
- Demand adjustment (+/-)
- Displays the demand adjustment. This field can only be maintained by clicking Forecast adjustment.
- Demand copied
- Indicates if the demand values for this item/warehouse combination were copied from another item/warehouse combination in the Item file.
- Total demand
- Displays the total demand for the item/warehouse period. The total demand also includes demand from customers that have active demand plans of type Additional. Note: This value includes demand that does not affect the forecast calculation. The demand value that is the base of the forecast calculation is retrieved from the Net demand field.
- Production demand
- Only applicable for produced items. Displays the production demand for the item. The production demand comes from the item, which is part of a manufacturing order structure and is related to the quantity required.
Work with forecasts (INVD00108)
On this panel, you can maintain further forecast information for the item/warehouse combination displayed in the header.
Function keys
| Forecast adjustment history | Access the Forecast file enquiry – Adjustment history function, which shows changes made to the Forecast and Demand adjustment fields. |
| Forecast adjustment | Only displayed in Maintenance mode. Access the Forecast adjustment function, where you can maintain the Forecast and Demand adjustment fields. |
- Item
- Displays the code and description that identify the item.
- Warehouse
- Displays the warehouse of the item.
- Forecast period
- Displays the forecast period number and description.
Promotion
- Sales promotion
- Estimated % increase
-
Note: The estimated value can be maintained on the Work with sales promotions, Forecast details panel.
- Actual % increase
- Estimated qty inc
-
Note: The estimated value can be maintained on the Work with sales promotions, Forecast details panel.
- Actual qty increase
Calculation
- Forecast method
- Displays the forecast method used for the calculation. The following methods apply:
- Exponential smoothing
- Moving average
- Forecast copy
- Season profile
- Displays the season profile from the Inventory management item file, if one has been assigned to this item/warehouse combination.
- Mean absolute dev
- Displays the calculated mean absolute deviation (MAD) for this item/warehouse combination. It is used in calculating forecast error, which in turn is used in calculating the safety stock level. The closer this value is to zero, the more accurate the forecast.
- Mean relative dev
- Displays the calculated mean relative deviation (MRD) for this item/warehouse combination. It is used in calculating forecast error, which in turn is used in calculating the safety stock level. The closer this value is to zero, the more accurate the forecast.
- Total MAD
- Displays the total calculated mean absolute deviation (MAD) for this item/warehouse combination. The total MAD is based on the comparison between the total forecast (including forecast from additional demand plans) and the total demand (including demand from additional demand plans). It is used in the Service based method to calculate SST in order to get the service level percentage to reflect the real possibility of being able to deliver, taking both the uncertainty of the forecast calculated by IBS Inventory Control and the forecast handed over from a demand plan of type Additional forecast into consideration. Note: If demand plans of type Additional forecast are not used in your system, then the total MAD is the same as the normal MAD.
- Alpha value
- Displays the alpha value for this item/warehouse combination. If manual alpha is used this value will be the same as the alpha value specified in Work with forecast control codes for all forecast periods. If automatic alpha update is used, shows the calculated alpha value.
This field is recalculated each time the Inventory calculations program is executed.
- Trend code
- Indicates if this item/warehouse combination is analysed for trend. This code is retrieved from the Inventory management item file.
- Adjust workdays
- Indicates if you chose to adjust workdays for this item/warehouse combination in the Inventory management item file.
YES means that the system adjusts the forecast according to the actual number of workdays in the period instead of using the average number of workdays per period, which was established in the IC control file. This field cannot be changed.
- No of workdays
- Displays the actual number of workdays for this period, retrieved from the active Forecast file.
- No of movements
- Displays the number of order lines (from the sales order cycle) for this item/warehouse combination for this forecast period. The number reflects the requested delivery date, not actual delivery date. That is, the date when the item was demanded, not the date when it was delivered. This data is used in setting the movability code for this item/warehouse combination.
- Production movements
- Only applicable for produced items. Displays the number of movements for an item in production demand, i.e., the total number of production orders where the item is included.
- Season index
- Only used for informational purposes. Displays the season index (per period) for the Season profile entry above.
- Markup/down (%)
- Displays how the markup or markdown has been calculated expressed in percentages.
Work with forecasts, Promotion history (INVD00111)
This panel displays all included sales promotions connected to the item/warehouse combination for the selected forecast period.
Selection fields
- Item
- Displays the code and description that identify the item.
- Warehouse
- Displays the warehouse of the item.
- Forecast period
- Displays the selected forecast period number and description.
- Promotion
- This column lists the included sales promotions.
- Estimated qty
- Displays the estimated quantity of the sales promotion.
- Actual qty
- Displays the actual quantity of the sales promotion.
- Estimated %
- Displays the estimated percentage of the sales promotion.
- Actual %
- Displays the actual percentage of the sales promotion.