Forecast Analysis

The Forecast Analysis is an item/location specific analysis that analyzes the forecastability of a given item. As such, it is applied against items with independent demand only. If S&OP is enabled in your account, a similar analysis is done in the Forecast section of S&OP based on the forecasting structure deployed.

Even with S&OP enabled, this analysis provides valuable information to help users determine how best to plan a given item in a given location. It provides information relative to the demand history of the item and in turn based on an items classification, recommends how best to plan.

Forecast Analysis Column Definitions

  1. View: Click to view the items requirement planning details
  2. Number or Name: The item name or number depending on the value to use in system settings. Placing your cursor over the value will show the item name or number depending on the primary view option chosen.
  3. Location: If the DRP module is enabled, the location of the item. This is a physical geographic location and not an inventory location within a warehouse.
  4. BI: Business Importance of the item / location. Calculated in Classification Analysis. Top 80% revenue, margin, or cost of items are A, next 15% are B, remaining 5% C, and D's are items with no demand over 52 weeks. This also reflects if an item is assigned a User Defined Class.
  5. F: Forecastability. This metric considers the value of CoV to determine the type of forecast approach to apply to the item. This is based on item/location even if S&OP is enabled. Threshold is based on the CoV threshold system setting. One letter H or L based on the CoV threshold.
  6. Age (Wks) How old the current item is. The count of weeks to the first week where demand is created not including linked history.
  7. Wks No Demand: How many weeks an item has had no independent or dependent demand.
  8. Linked New. Does the item have historical linking. Yes or No. From item data maintenance.
  9. Forecast Acc. % ‌New. This will be a new measure based on independent demand forecast only. The calculation is: (1-(ABS(Actual Independent Demand - Forecast Independent))/Forecast Independent Demand))*100
  10. Actual Demand Actual independent demand over the measurement period.
  11. Forecast Demand Independent forecast demand over the measurement period.
  12. Demand Type: Type of demand. Types are independent demand from direct customer sales, dependent demand from either a BOM explosion or inventory transfer, or both
  13. Bucket Type: Specifies if the forecast is based on weekly (w) or monthly (m) buckets.
  14. MAPE: Mean absolute percent error
  15. RMSE: Root mean squared error
  16. Std. Dev.: The measure of the volatility of independent demand.
  17. CoV: Coefficient of Variation. This is Standard Deviation / 52 W average independent demand.
  18. ADI: Measure of spread of demand. If there is no 0 demand during the measurement period, the result equals 1 since 0 divided by 0 equals 1. The threshold between smooth and intermittent demand is 1.32.
  19. History Type: This uses the measures of ADI and CoV to state the type of demand history an item has. The results are Intermittent, Lumpy, Smooth, and Erratic.
  20. Forecast Model: The type of statistical forecast model applied when S&OP is not enabled. If S&OP is enabled, the specific forecast model is not provided since the source is a sum of context based forecasts for the given item. In this case, the model is S&OP.
  21. Approach: Recommends how best to forecast a given item item using BI and Forecastability. A items are considered H value and B and C low. See further information below.
  22. Trend Alert: Describes the rate of change of demand by comparing the percentage difference between the last 13 week average demand and the last 52 week average demand. Hyperlinked to Classification Analysis where it is calculated. If the change is less than or equal to 15% the item receives an "OK" designation. If the change is between 15% and 50% the item receives a "Concern" designation. If the change is greater than than 50% the item receives an "Alert" designation. The + or - after the designation communicates if the trend is positive or negative i.e. negative means the 13 week average is less than the 52 average.
  23. Stability Index: Compares the last 13 week independent demand against the next 13 week forecast demand.


Suggested Approach

The following defines the basis of the different approaches suggested:

  • Collaboration: High A Value and Low Forecastability
  • Statistical: High or Low Value and High Forecastability
  • Min/Max: Low Value and Low Forecastability
  • Dependent: Min/Max (components and dependent locations)
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request