We designed a scenario planning function in our clients Anaplan for FP&A model which reduced model size by two thirds. This is how we did it...
During our early time with Anaplan we wanted to design a better way to consolidate the numerous actuals, budget and forecast data that all FP&A models generate.
Great Anaplan for FP&A model design boils down to three core models; the actuals model, consolidation model and archive model.
Great Anaplan for FP&A model design boils down to three core models; the actuals model, consolidation model and archive model.
We believe all FP&A models in Anaplan should contain scenario planning as standard. In 6 steps this is how we implemented it for our clients...
We have designed an approach to delivering scenario planning which gives our clients access to this functionality without consuming excessive resources or disrupting business as usual.
An archive is core to how scenario planning functionality should be developed in your Anaplan models...
An archive is a location within the model which is disconnected from all live processes and retains data which can be retrieved via a mapping. The retrieval can be part of a scenario planning functionality or simply used to hold historical forecasts and budget for future reference.
Scenario planning in Anaplan is often poorly conceived and badly designed with execution falling well short of expectations.
Scenario planning in Anaplan is often poorly conceived and badly designed with execution falling well short of expectations. With limited to no formal best practice in place we find that the reality almost always fails to live up to the promise.