Create Forecast

This page allows you to create the forecast. Tell me more

Select the “Create Forecast” link under the “Demand Planning“ business component.

The “Create Forecast” page appears.

Enter the following details:

Forecast Group	The unique code identifying the forecast group Mandatory.
	Press <Enter> key.
	The system ensures that the forecast group exists in the forecast group master and the login user has at least “View” access permission to the “Maintained By” Control Unit of the Forecast Group.
	Help facility available.

Note: The forecast group should not be left blank, if the fore cast group is left blank then the system generates the forecast group using the "Numbering Type" business component.

Desc	The description of the forecast group. If forecast description is left blank, then the system defaults the forecast description as forecast group.
	Zoom facility available.
Status	Use the drop-down list box to select the status of the forecast group. You can select from “Active” or “Draft”. The system displays “Draft” by default on launch of the page.
Forecast Level	Use the drop-down list box to select the level of the forecast group. The system displays “Item” by default on launch of the page. The options available are
	Item – Indicates the forecast created at item level.
	Customer – Indicates the forecast created at customer level.
	Project – Indicates the forecast created at project level.
Customer	The name of the customer. The customer cannot be left blank, if the forecast level is set to "Customer". The customer should exist in customer master. If it does not exist, then the system displays an error message.
	Help facility available.
Project	The name of the project. The project cannot be left blank, if the forecast level is set to "Project". The project should exist in project master. If it does not exist, then the system displays an error message.
	Help facility available.
Look Back (Weeks)	The number of weeks a forecast consumption logic can look backward to consume forecast demand against actual demand.

Note: The system defaults Look Back field with the values from “Component Parameter” screen.

Look Forward (Weeks)

The number of weeks forecast consumption logic could look forward to consume forecast demand against actual demand.

Note: The system defaults Look Forward field with the values from “Component Parameter” screen.

Allow Consumption	Select the check box to indicate that actual demands can consume forecast demands. The system leaves the box “Checked” by default on launch of the page.
Matl Planner	Use the drop-down list box to select the material planners defined in the control unit. The system populates the values from the control unit master of the “Organization Model” business component. The system displays “Default Material Planner” defined for the login user by default on launch of the page.
Upload File Path	The path that identifies the location of the excel file to be uploaded. This file provides exploded view of the forecast items.

Click the “Upload” pushbutton to upload the forecast details.

The system ensures that the upload file path field should not be left blank. Uploading of the file will be done only in “Draft” status irrespective of status set in forecast group defined in the header. The file should exist in the given upload file path. The system uploads the excel information.

The system checks whether the login user has “All” access permission to the selected material planner for the item and forecast warehouse combination. If the permission is denied, then the system throws an error message. The above condition is checked by the system during batch mode execution

The system saves the forecast group details and generates forecast group from “Numbering Type” business component if the forecast group is left blank. The system generates the forecast reference using values from “Numbering Type” business component.

Enter the following in the “Forecast Details” multiline:

Plg Group	The code identifying the planning group for which the forecast is created.
	Press <Enter> key.
	The system checks whether the planning group or item is left blank. Either one can be left blank. If both the fields are left blank, then the system displays an error message. It also checks for the existence of the planning group in the planning group master. If the planning group does not exist, then the system displays an error message. The system retrieves the description for the specified planning group.
	Help facility available.
Item	The code identifying the item for which the forecast is created.
	Press <Enter> key.
	The system checks whether the item or planning group is left blank. Either one can be blank. If both the fields are left blank, then the system displays an error message. It also checks for the existence of the item in the item master. If the variant exists for the item, then it should not be left blank. The system retrieves all the item details for the selected rows in the multiline.
	Help facility available.
Var	The code or number identifying the variant of the item for which the forecast is created. If the variant is specified for the item code, then the item cannot be left blank.

The system displays the following:

Desc

The description of the planning group.

Enter the following:

Forecast Plant

Use the drop-down list box to select the valid plants where the forecast item/planning group is identified. The system populates all the storage administration Organization Units to which demand planning Organization Unit is mapped from E Model. The system displays “First Value” by default on launch of the page.

Note: The system validates the forecast plant against planning group or item code.

Forecast WH	The code or number identifying the warehouse where the forecast item/planning group is identified.
	Help facility available.

Note: The system validates the forecast warehouse against item code to check whether the item is valid in the warehouse.

Time Bucket	Use the drop-down list box to select the time bucket that represents the period of the forecast created. The system displays “Weekly” by default on launch of the page. The options available are
	Daily – indicates the daily forecast.
	Weekly – indicates the weekly forecast.
	Monthly – indicates the monthly forecast.
Anchor Date	The start date from which the forecast demands are generated. The date cannot be left blank and should be in valid Date Format.

Note: Based on the date specified in the first row the system calculates the date in the second row as sum of the date in the first row and the value specified in time bucket in the “Item Forecast” page. For example: if the Time Bucket is set to “Weekly” and the date in the first row is specified as “03/06/02” then the date in the second row should be “10/06/02”.

No of Buckets	The number of periods for which the forecast demands is generated. If planning group/item is specified, then number of bucket cannot be left blank. If this field is specified, it cannot be less than one.
Bucket Qty	The quantity that represents the forecast quantity of the item for each bucket. If planning group/item is specified, then bucket quantity cannot be left blank. If this field is specified, it cannot be less than one.
Confidence %	The percentage that represents the confidence level of the forecast. If the confidence percentage is specified, it should not be less than zero and greater than 100. The system displays “100” by default on launch of the page.

The system displays the following:

Total Qty	The total quantity of the item for which the forecast demands is generated. The quantity represents the No of Buckets multiplied by Bucket Qty.
Forecast Ref	A unique number identifying the forecast reference generated by the system. The system generates the forecast reference using “Numbering Type” business component
Item Type	The type of the item.

Enter the following:

Remarks

The remarks or comment specified by the user.

Click the “Get” pushbutton to retrieve the selected forecast details in the multiline.

Check the box in the “Select” column of the multiline to select the forecast for creating its details.

Click the “Create Forecast” pushbutton to create forecast for the selected planning group or item.

The system ensures that at least one planning group/item must have been mapped to the forecast group. The system executes in online mode. The system checks whether the status of the forecast group is set to “Active” and if all the rows are executed successfully without any errors, then the forecast details will be created in Disposition. The system creates the demand for each forecast.

To proceed, carry out the following

Select the “Edit Forecast” link at the bottom of the page to modify the forecast details.

Select the “Edit Item Forecast” link at the bottom of the page to modify the item forecast details.

Select the “Edit Consumption Demand Category” link at the bottom of the page to modify the consumption demand categories.

Select the “View Forecast Error Log” link at the bottom of the page to view the forecast error log details.

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 forecast.
Created Date	The date on which the forecast was created.

Create Forecast - An overview

The purpose of creating forecast is to plan ahead to meet the actual demands. You can create the forecast by entering the forecast group manually or the forecast is automatically generated by the system. You can define the forecast at item/customer/project level. You can make use of this screen to allow the forecast demands to be consumed by actual demands. You can upload the forecast details from excel file by specifying the appropriate path in the header.

In the multiline, you can define the forecast details for the selected planning group/item. You can create the forecast for the date, time bucket number of the bucket and quantity specified along with the percentage of confidence. You can also specify the forecast plant and warehouse where the item/planning group is valid. Upon creating the forecast details, the system automatically generates a forecast reference for each row defined in the multiline.

Pre-requisites

Optional

Planning group must be defined in the “Create Planning Group” activity of the “Item Administration” business component.

Item must be defined in the “Item Administration” business component.

Warehouse must be defined in the “Storage Administration” business component.

Material planner must be defined in the “Create Control Unit” activity under the “Organization Model” business component.