|
|
|
Forecasting and Replenishment |
|
| " This module will explain what is involved with Forecasting for Replenishment of goods within FDM4. This procedure will allow the user to maintain the Item usage and forecasting information that will be the basis of replenishing stock. " |
|
- Optimization of re-ordering product quantities by vendor's best price packaging.
- The system retains actual and adjusted history to project the forecast for replenishment.
- The system automatically adjusts history based on the origin of the order as opposed to the shipping warehouse to reflect the product demand from the appropriate location.
- Customer orders and vendor Purchase Orders can be flagged to be excluded from affecting forecasting.
- Vendor lead time is included in product projections
- The system uses the following replenishment types: min/max, line point, seasonal.
- Product replenishment can be driven by vendor purchase order, warehouse transfer, kit configuration and work orders.
- The user can view the Average Sales Percentages calculated by the system for any highlighted product
- This will break each product out as a percentage of the total sales for the selected category.
- At the sub category level, the percentages displayed are applicable to the sales figures for the selected category level within the product.
- The user can change the display to the information applicable to another location of inventory, where multiple locations are used. Each location used within the system will have it's own forecasting values and percentages if the location stocks the product.
- The user can maintain the forecasting values for products, categories and sub-categories.
- The percentages displayed are the system calculated average sales percentages for the active products by the category and sub-category for that product. These percentages are recalculated on a monthly basis and represent the percentage of sales over the last year.
- The system allows the user to enter a high low variance by product to alert the user of an abnormal sales level that would adversely affect the purchase forecast quantity.
- Replenishment can build EDI Purchase Orders
- Purchase Order, Warehouse transfer, Kit Configuration and work order.
- A Forecast curve can be calculated based on the products sales history. If no history is available a default sales curve will be used.
- A default sales curve can be set on new products based on a similar type product's history. This field will allow the user to manipulate the average usage percentages for each month manually, overriding the existing sales curve for that product.
- The number of weeks supply can be set by the buyer per product and the system will calculate the suggested quantities to be purchased to maintain the weeks supply.
- Exception report - this report will allow the buyer to go into the system and print off a listing of all of the items where their average sales percentages fall outside the variance range determined on the report selection criteria.
- The user can further drill down the percentage of sales from the category to the sub category level. The user can view the percentage of sales for each of the sub categories applicable to the category within the product.
|
|
|
|
|
|
