Filter Demand Forecast Parts
Explanation
Use the filter function to filter out the parts that you can want to work with, you can also use the sort
function to sort the list according to the wanted criteria's (typical according to some forecast error
measurement or all parts in a product family...) you can filter/sort by all fields in the Detail View.
Other important none Detail View filtering criteria's available are
:
- Percent Adjusted/Budget, sums the Adjusted Forecast and budget numbers for all periods in the forecast range.
Then we divide ( sum Adjusted Forecast / Sum Budget ) * 100 this is the value shown in the part selector. If
Percent Adjusted/Budget is 100 it means that the Sum of the Adjusted Forecast and Budget in the Forecast Range is
exactly the same, when the Percent Adjusted/Budget is > 100 it means that the sum of the Adjusted Forecast is
bigger than the sum of the budget values. Thus a Percent Adjusted/Budget number bigger than 100 indicates that
the sum of the Budget numbers in the forecast horizon is bigger than the sum of the Adjusted Forecast
numbers.
- Percent Adjusted/Target Sales Plan, sums the adjusted forecast and Target Sakes Plan numbers for all periods
in the forecast range. ( Then we divide sum Adjusted Forecast / Sum Target Sales Plan ) * 100 this is the value
shown in the part selector.
- Percent Used, needs the Aggregate Daily job to be scheduled to run
once every day to work. Takes the current periods Adjusted Demand and divides it on the current periods Adjusted
Forecast and multiplies it with 100 this is the value shown in the part selector. The part with a high value has
consumed more (likely to be sold out?) of the forecast until now in the current period than a part with a low
value (likely to have surplus?). This number is also displayed in the accuracy tab in Detail view.
- Percent Adjusted/Events, sums the Adjusted Forecast and absolute Event numbers for all periods in the
forecast range. Then we divide (sum Adjusted Forecast / Sum Abs Events) * 100 this is the value shown in the part
selector. The bigger the percentage number the larger is the sum of the Events compared to the sum of the
Adjusted forecast for the part.
- Percent Historical Forecast/Events, sums the Historical Forecast and Historical Event numbers in the set
Forecast Error Period range (see Enter General Server Data).
Then we divide (sum Historical Forecast / sum Events) this is the number shown in the part selector.
- The Outliner factor used to sort the parts according to Outliers, the part with the most recent and biggest
outliner first, and so on. An outliner is a part that has a demand period outside of 2 standard deviations.
- Future Eco Footprint measurements like GWP100, ODP100, EP, AP, POCP, HTP, WASTE, HAZARDOUSWASTE,
RENEWABLEENERGY, NONRENEWABLEENERGY, you have to select which 3 of them to use in the Demand Plan Server see
Define Advanced Server Settings for details.
To work at group level you start creating a filter that includes all the items that you want to group and then
push the Group button in the top row.
Prerequisites
- The Demand Plan Server needs to be running.
System Effects
The Forecast Part List will be filled with items matching your query setting