|
|
|
Item Forecast
This screen enables you to define monthly 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 monthly Forecast attached to them.
Display fields
Item Code: Display only field showing the Item Number
Site Name: Display only field showing the Site
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.
Forecast Settings
Forecasts are entered relative to the requirements within each month, thus providing seasonal variations. Within each month the Forecast can be held as a single value for the month or a daily value (based on a 5, 6, or 7 day working week).
Forecast Applies: ‘Click’ the checkbox if you are establishing a Forecast for the respective Month. This will make the following fields active against that month.
Average Forecast Quantity: The quantity entered here will apply to all occurrences of the frequency defined in the next field
Frequency: From the drop-down list select the frequency for the forecast demand entered into the previous field. The options are:
Monthly - The demand date will be the first of the Month
5-day Week- Each Mon, Tues, Wed, Thurs, and Fri in the Month
6-day Week- Each Mon, Tues, Wed, Thurs, Fri, and Sat in the Month
7-day Week- Each day in the Month
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.