Scenario Summary

Hi Emma,

Thank you for the forum question.

If you have calculate average increase and want to predict future years it is not really a job for the scenario manage.

The advantage of the scenario manager is in a model with several variables.

Example:

We know that the cost for each different cancer treatments. We have predicted the increase in cancer patients for future years. We know the current capacity to treat cancer patients.

Then we could use the scenario manager to build different scenarios.

What will the cost be with the estimated increase and the current variety of cancer treatments and do we have enough capacity?


What will the cost be if the increase is higher than estimated and the future variety of cancer treatments are different than current and do we have enough capacity?

If the only variable is the percentage then you have no need of the scenario manager.

If You have calculated let us say the average increase to 5%. I would type 5% in a cell. Then I would use a cell reference to the cell with the 5% to add 5% to my 2022 numbers to get expected 2023 numbers and again add 5% to my 2023 numbers to get 2024. You can always chance the percentage in the cell to another percentage.




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector