Forecasting with Accuracy in Today’s World

Forecasting in Today’s World

Frequent volatility in marketplace in the post pandemic era caused by multiple events leading from war in Ukraine to inflation and high interest rates globally have had resultant impacts on businesses around the world. The short lead times these fluctuations have offered to businesses to adjust their business plans have made it even more challenging for them to calibrate changes in planning, forecasting and resultant business actions.

Enter Anaplan: A platform that allows flexible and nimble forecasting, moving away from rigid structures enforced by transaction processing systems

• Enables truly connected planning, with the ability to start from one business area: say Sales Planning adding others: Demand Planning, Capacity Planning: FP&A Revenue &; OpEx Planning, etc.
• Allows customizable multi-dimensional hierarchies.
• Low/Simple Coding
• Intuitive interactive Dashboards – forecasts on the fly
• Stakeholder collaboration
• Real-time integration with ERPs

Defined Models in Anaplan maintain data in prescribed modules enabling generation of forecasts in Time Series or PlanIQ, a Machine Learning (ML) based platform to generate forecasts. These can be generated across Supply Chain, Human Resources & Finance at the lowest level of measure required.

PlanIQ offers multiple forecast outputs using algorithms leveraging ML. It is a native platform within Anaplan offering that combines the unique flexibility and in-memory capabilities of Anaplan with the advanced forecasting analytics to deliver high forecasts with minimal setup and process time.

Known PlanIQ solutions where it has works well are:
1. Supply Chain: Demand Sensing, Demand planning, Demand Management
2. Finance: CapEx planning, OpEx planning
3. Workforce: Workforce planning, Attrition planning

To take the case of Demand Planning, following would be the derivation of Demand Plan, for a Manufacturing Company

Data Organization

Sales History for the past x years
Data Normalized – outliers removed, trade promotions, extra-ordinary events, and occurrences
Statistical normalization: UCL, LCL, USL, LSL, Standard Deviation, etc. applied
Run Time Series algorithms…Anaplan provides downloadable models in AppHub and 17 results derived
Run PlanIQ ML forecasting (explained below)
System suggested Best Fit Forecast based on MAPE% closest to 0
Over-ride of best-fit by Planners, if needed
Unconstrained Demand Plan derived

Anaplan processes:

– Sales History and periodic updates are interfaced from ERP/Transaction Processing systems into Anaplan at defined frequency into the Data Hub Model
– Downloadable Models are available in AppHub – a repository of pre-built customized apps that have Time Series Statistical Forecasting Apps
– AppHub Models downloaded need to be modified and within those data is appropriately transformed and loaded from the Data Hub. This data is normalized to remove outliers, statistical normalization applied and trends, seasonality applied.
– To apply Statistical Normalization and Trends & Seasonality statistical formulae can be built into Anaplan with excel-like functions available.
– Run Time-Series measures to derive results from algorithms reflected below (in blue)
– Run PlanIQ ML to derive results as shown below (in green)

The Statistical measures and their application are explained below. Data below is illustrative:

Algorithm MAPE%

(Mean Absolute Percentage Error)


(Root Mean Square Error)



Amazon Auto ML Forecast 2% 482 415 30%
Anaplan Auto ML Forecast 12% 468 390 50%
Prophet Forecast 14.3% 640 350 40%
ARIMA Forecast 8.3% 680 450 40%
DeepAR+ Forecast 14.5% 900 750 20%
CNN-QR Forecast 3.8% 750 650 25%
Linear Regression 22.6% 340 300 7%
Logarithmic Regression 24% 330 250 6.5%
Exponential Regression 24.8% 340 300 6%
Power Regression 8% 200 280 4%
Moving Average 5% 220 120 4.2%
Double Moving Average 8% 300 150 5%
Simple Exponential Smoothing 5.5% 150 130 5%
Double Exponential Smoothing 7% 160 120 5.5%
Triple Exponential Smoothing 8% 200 150 6%
Additive Decomposition 40% 1,000 1100 30%
Multiplicative Decomposition 5% 130 100 4%
Multi Decomp Logarithmic 6% 142 120 4.5%
Multi Decomp Exponential 5% 130 130 5%
Multi Decomp Power 6% 140 140 5%
Winter’s Additive 6.5% 170 160 5.2%
Winter’s Multiplicative 7% 200 140 6%
Prior Year% 14% 300 280 8%


• The Algorithm with MAPE (Mean Absolute Percentage Error%) closest to Zero is considered as the industry measure for the Best Fit Forecast. MAPE is a statistical metric where the where the value corresponds to the average amount of errors that predictions have. Therefore, a lower MAPE is better, where the lower the value the more accurate the prediction is.
• RMSE or Root Mean Squared Error Root error helps understand how accurate predictions are and, what is the amount of deviation from the actual values.
• MAD or Mean Absolute Deviation represents the deviation of actual independent values from their aggregate average value.
• BIAS% is the variance between actual outcomes and previous forecasts.

Best Fit forecast measure and forecast values available on a Dashboard enable Planners and Business Leaders to determine the Demand Planning Forecast to be carried forward. They can also over-ride the System suggested Best Fit considering:

• Other measures such as BIAS% which becomes crucial given the deviation of past outcomes from forecasts for a certain algorithm.
• RMSE for deviation of predictions from actual values
• Actual pulse on the business and markets

Forecasting accuracy being an evolving process, data organization, the underlying parameters to drive outputs would play a key role. This would get refined as the business iteratively executes this as there is no getting it first time right theory.
ML Based forecasting using PlanIQ provides opportunities to improve the forecasting accuracy.
In this instance for Demand Planning
• Reduce cycle time for scientific forecasting integrated with transaction systems.
• Improve forecasting accuracies leading to informed downstream decisions i.e.,
• Streamline Production Planning, Inventory Optimization – avoid overstocking and unavailability of raw materials and inputs.
• Plan for temp workers
• Arrange for Working Capital as per seasonality.
• Fulfilling Market Demands while reducing risk of overstocking of finished goods, stock obsolescence or buy finished goods to sell at lower margins.
All these lead to adding improved Profitability and better Cash Flow Management.

Anaplan with PlanIQ offers a very flexible forecasting options across Business Areas for improved business performance.

Author Details

Suryakiron Venkata Emani

Connected Planning EPM & ERP expertise coupled with Finance Background

Leave a Comment

Your email address will not be published.