Step-by-Step guide for setup the Replenishment calculation by Average Usage
1 - Setup time horizons for historical data to calculate the Average Sales
1.1 - Enter "Replen. Sales Profiles" in to search then select the related link
1.2 - In the "Replen. Sales Profiles List", click New button to setup for the Average Usage Calculation
1.3 - In General tab, fill in the Code and Description for the "Replen. Sales Profile
1.4 - In Line Tab, you can enter one or more lines with weights. The weights field use for identify what period is more important.
For example, enter a higher value in the weight field for the more recent period if you want the period closest to today's periods to have more importance than a period one month ago.
Fields | |
---|---|
Date Formula for Start Date | The starting Date for the period that you want the system to calculate the quantity sold |
Date Formula for End Date | The date formula for the end data of the period |
Weight | If no weight is entered, all periods have same importance |
Weight Percentage | Calculated automatically |