Novo Forecast Pro

Novo Forecast Pro is the solution for forecasting based on Excel from Novo BI company.

2019: Features

(data are relevant for March, 2019)

Features

• Data preparation
  • Search and marking of emissions in data array.
  • Creation of the diagram for the analysis of quality of data.
  • Automatic data preparation: smoothing of emissions, recovery of zero.

• Automatic forecast calculation
  • Analysis of characteristics of each time series.
  • Testing and selection of a forecasting model for each time series.
  • Forecast calculation on data array and an output to the sheet.

• Planning
  • Creation of the sheet of accounting of factors of influence on the forecast.
  • Automatic adjustment of the forecast factors.
  • Graphical analysis of rejections of the plan from the forecast.

• Analysis of results of the forecast
  • Output of step-by-step forecast calculation to the sheet.
  • Automatic creation of charts and analytical panels.
  • Calculation of accuracy and forecast errors.

• ABC-XYZ analysis
  • Setup of borders of groups for ABC and XYZ.
  • The XYZ analysis, with breakdown on groups XX, X, Y, Z, ZZ.
  • ABC analysis, with a possibility of segmentation on the AA, A, B, C, D, E groups.
  • The choice of logic of ABC analysis for time series - on the amount, average, a median.

Additional functions

• Data preparation for loading in base.
• Calculation of seasonality, trend, credible interval.
• Calculation of the amount of the forecast.
• ABC analysis of input data and result.
• XYZ analysis of input data and result.
• Forecast calculation on groups of ABC analysis.