|
|
|
|
|
This page allows you to modify the forecast details for each forecast reference and position number of the item/planning group of the forecast group. In the multiline, you can change the total quantity and confidence percentage of the forecast reference along with the date on which the forecasts were generated. The system recalculates the available and balance quantity to be forecasted based on the above modifications.
Select the “Edit Item Forecast” link under the “Demand Planning“ business component.
The “Edit Item Forecast” page appears.
Modify the following details, if required:
|
Forecast Group |
The unique number identifying the forecast group of an item. Mandatory. |
Note: If the forecast group is specified and exists in the forecast group master, then the system retrieves all the forecast group details.
|
Customer Code |
The name of the customer. If customer is specified, then the system retrieves only forecast group attached to the specified customer. |
|
Help facility available. |
|
|
Project |
The name of the project for which the item forecast has to be modified. If project is specified, then the system retrieves only forecast group attached to the specified project. |
|
Help facility available. |
|
|
Plg. Group |
The code identifying the planning group for which the item forecast has to be modified. If the planning group is specified, then the item should be left blank. |
|
Help facility available. |
|
|
Item Code |
The code identifying the item for which the item forecast has to be modified. If the item is specified, then the planning group should be left blank. |
|
Help facility available. |
|
|
Plant |
Use the drop-down list box to select the valid plants where the items/planning groups are identified. If plant is selected, then the system restricts the forecast groups to the selected plant. The system retrieves all the “Storage Administration” Organization Unit to which demand planning Organization Unit is mapped from CIM Model. The system displays “First Value” by default on launch of the page. |
|
Warehouse Code |
The code or number identifying the warehouse where the forecast item/planning group is identified. |
|
Help facility available. |
|
|
Sort Order |
Use the drop-down list box to select the order of sorting the forecast details. You can select from “Item”, “Customer”, “Project” or “Date”. The system displays “Item” by default on launch of the page. The system retrieves the forecast group in ascending order for all the options selected in the sort order. |
Click the “Search” pushbutton to retrieve the search details in the multiline.
The system retrieves the forecast groups that are in “Active” or “Draft” status in the multiline for either the item and warehouse/planning group combination.
Modify the following in the “Item Forecast Details” multiline, if required:
|
Date |
The start date from which the forecast demands are generated. The date cannot be left blank and should be in valid Date Format. The system checks whether any new date is added and the forecast ref/group is in “Draft” status. If the date already exists for the forecast reference then the system displays an error message, else if date does not exist then the system modifies the forecast item details. |
|
Total Qty. |
The total quantity of the item for which the forecast demands is generated Mandatory. The quantity represents the No of Buckets multiplied by Bucket Qty. The system checks whether any new quantity is added and forecast ref/group is in “Active” status. If the quantity already exists for the forecast reference then the system displays an error message, else if the quantity does not exist then the system modifies the forecast item details. |
The system displays the following:
|
Available Qty . |
The available quantity of the forecast. The quantity represents the total quantity multiplied by percentage of confidence. If the total quantity and confidence percentage is changed, then the available quantity is updated with new total quantity multiplied by percentage of confidence. |
|
Balance Qty. |
The quantity of the production forecast for the period that is not consumed by actual demands. If the total quantity or confidence percentage is changed and the status of the forecast ref/group is in “Draft”, then the system sets the balance quantity to the available quantity. If the total quantity or confidence % is changed and status of the forecast group/ref is “Active”, then the balance quantity is updated with the new balance quantity. |
|
Plg. Group |
The code identifying the planning group of the forecast group. |
|
Item Type |
The type of the item of the forecast group. |
|
Item Code |
The code identifying the item of the forecast group. |
|
Variant Code |
The code or number identifying the variant of the item of the forecast group. |
|
Description |
The description in combination of item/item variant. |
Modify the following, if required:
|
Confidence % |
The percentage that represents the confidence level of the forecast. |
The system displays the following:
|
Forecast Plant |
The plant where the forecast item/planning group is identified. |
|
Customer |
The name of the customer for which the item forecast is modified. |
|
Project |
The name of the project for which the item forecast is modified. |
|
Forecast Warehouse |
The code or number identifying the warehouse where the forecast item/planning group is identified. |
|
Forecast Ref. |
The number identifying the forecast reference for which the item forecast is modified. |
|
Forecast Group |
The code identifying the forecast group for which item forecast is modified. |
Check the box in the “Select” column of the multiline to select the item forecast for modifying its details.
Click the “Edit Item Forecast” pushbutton to modify the item forecast for the selected forecast group.
The system ensures that the login user has “All” access permission to the “Maintained By” Control Unit of the forecast group. The system executes each row and continues until the last row in the multiline and generated errors (if any) are logged to the Forecast Error Log screen.
4 If the total qty or confidence % is changed and the status of the forecast ref/group is set to “Draft”, then the forecast balance qty will be the available qty which is represented as the below formula
1. New Total Qty * New Confidence %.
4 If the total qty or confidence % is changed and the status of the forecast ref/group is set to “Active”, and if New Total Qty * New Confidence % < Old Total Qty * Old Confidence %, then if Balance Qty >= (Old Total Qty * Old Confidence % - New Total Qty * New Confidence %) then
1. The forecast Balance Qty is set to New Balance Qty by using the formula New balance qty = (New Total Qty - Old Total Qty)*Confidence % + Old Balance Qty.
2. The demand will be modified in disposition to New Balance Qty.
4 if Balance Qty < (Old Total Qty * Old Confidence % - New Total Qty * New Confidence %) and the status of the forecast ref is set to “Active”, then
1. The forecast Balance Qty is set to (New Total Qty * Confidence %).
2. The demand will be modified in disposition to New Balance Qty.
The system updates the item forecast details.
To proceed, carry out the following
Select the “Track Forecast Consumption” link at the bottom of the page to track the forecast consumption details.
The system displays the following:
|
Created By |
The login ID of the user who created the item forecast. |
|
Created Date |
The date on which the item forecast was created. |
|
Edited By |
The login ID of the user who modified the item forecast. |
|
Edited Date |
The date on which the item forecast was modified. |
