Best method for Scenario Planning?
I am currently in the process of investigating the best methodologies for building in scenario planning into one of my models. After some internal conversations and a little community hunting, I thought it would be best to write a new post.
For context the model i am building scenarios into will require several modules to be modified to allow users the ability to flex volumes or rates but what is the best way to allow users to interact against the base plan to then see comparative analysis dashboards of base plan vs scenario? Very conscious to not add complexity, duplication or increase model size drastically.
Currently I thought I could build additional modules that will house base plan with a version list to allow multiple scenario versions to be created. Adding in additional override line items to calculate through to a new total (if Boolean ticked take scenario volume else take base plan). OR would adding a new version into the model be best using a new list built into the existing modules be a better option?
Any advice would be really appreciated