What-if Analysis in Excel to Anaplan.

Hi, I happened to see a video on Youtube (https://www.youtube.com/watch?v=N924D6tGOG8) where a person introduces the Excel function "What-if analysis - data table" I want to replicate this function in Anaplan where I have similiar variables (values are dependent on both columns and rows). Are there any best practices on these kind of functions? Regards B

Accepted answers

All comments

ArunManickam

@bbolton , Our optimizer can give us only the optimum result, but not all possible results which the Excel "What if" does. Essentially "What if" is a loop of different values for some variables and a resultant is calculated. We can do this in Anaplan, but it will be through model building, you can have the end-users to change the range of values for the variables.

Thanks

Arun

anirudh

Agree with @ArunManickam

Optimizer does not fit this use case. The best way to replicate this what-if analysis is through boolean overrides.

Basically, supply a boolean for each of the drivers, like products sold. If the boolean is checked, then the profit calculation considers a separate line item which is a user input for number of products sold...

AnyaS

hi there. I am happy to share a little sample I did - feel free to email ASkvortsova@allitix.com

Quick Links

Can you help?

Unanswered questions

Reverse BOM recommendation based on Attributes
Hi, Consider this scenario for a Diamond Industry supply chain Demand for Diamond from customer comes with various attributes [cut, carat, clarity, etc etc] Prospect has made over the years diamonds with various attributes. This historical data is available [both BOM and Recipe]. There is a unique Stage 1 BOM and Stage 1…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…