Item Daily Forecast

This screen enables you to define daily Forecasts against selected Items.  This forecast can be used in the Inventory Replenishment routine which looks at Actual -v- Forecast Demands

 

List Tab

 

This panel shows all Inventory Items and if they have a daily Forecast attached to them.

 

Display fields

 

Item Code: Display only field showing the Item Number

 

Description: Display only field showing the Description of the Item taken from the Inventory record.

 

Unit: Display only field showing the Base Unit of Measure for the Item taken from the Inventory record.

 

Status: Display only field showing the Current status of the Item taken from the Inventory record.

 

Forecasted: Display only checkbox showing if the Item has a Forecast held against it

 

Data Display Options

 

Field Position - On the List screen you can move the field position by dragging the column heading left or right to the position where you want it to appear.

 

Filtering and Sorting - If you ‘check’ the checkbox then the displayed data is available for filtering and sorting:

•

To sort the data in a selected column simply click on the column heading.  Clicking against will sort in descending order.

•

Click on the black ‘down arrow’ to the right of your selected column heading and you can either select a specific entry to display all records containing that entry, or you can select (Custom…) to enter detailed selection criteria.

 

Include Obsolete Status - By default the display will only show Items that have a status of ‘Active’.   If you wish to see all Items including those that have status ‘Obsolete’ then ‘check’ this checkbox.

 

Searching - If you enter some text into the ‘Search’ field and click on the ‘binoculars’ Icon then all records will be interrogated and those records that contain the entered text will be displayed.  To revert back to displaying all records click on the ‘Eraser’ Icon

 

Buttons

 

Close: This will close the Forecast screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

 

 

Detail Tab

 

This tab enables you to create and maintain a Forecast against an Item selected in the ‘List’ tab

 

Entry and Display fields

 

Item Code: Display only field showing the Identity of the selected Item

 

Unit: Display only field showing the base Unit of Measure for the selected Item

 

Description: Display only field showing the Description of the selected Item

 

Default Supply Method: Display only field showing the Supply Method held against the selected Item

 

Status: Display only field showing the current status of the selected Item

 

On-Hand Qty: This is a display only field showing the current stock level across all Warehouses and Locations.  For detailed on-hand information click on the adjacent button (Inventory Availability)

 

Inventory Availability: Clicking on this button will bring up a separate panel that shows details of the Inventory Availability for this Item.  This includes

•

Stock by Location segregated by Tracking Characteristic if applicable

•

Projected Availability taking into account current stock plus supply and demand

•

List of Supply and Demand orders

 

Sourced By: Display only field showing how this Item is sourced.  The display options are

Purchasing - fully purchased Item

Assembly - Assembled in-house

Supplier Assembled - Components sent to Supplier for Assembly

 

Re-Order Level: Display only field showing the Re-Order Level.  This is used in the Inventory Replenishments Routine to define the stock level at which the program generates a Planned Supply order.

 

Min Re-Order Quantity: Display only field showing the Minimum Re-Order Quantity.  This is used in the Inventory Replenishments Routine to define the minimum quantity to order when the stock is at, or below, the Re-Order Level.  The Replenishment Routine will generate a Planned Order based on the greater of the actual demand or the Re-Order Quantity.

 

Lead Time: Display only field showing the Item’s Lead time.  This will be applied to both Purchase Orders and Assembly Orders to determine when the order should be placed.   

 

Default Supplier: Display only field showing the Item’s default Supplier.  This is used by the Replenishment routine, or Source on Demand function to generate a planned Order linked to a preferred Supplier.

 

Daily Forecast Records

 

Forecasts quantities are entered relative to the requirements for each date and for each Site.    

 

 

 

Buttons

 

Close: This will close the Inventory Forecast screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

 

Save: This will save the current data without exiting the screen

 

Cancel: Any changes made to the current record or the last time the ‘Save’ Button was pressed will be lost.