The Excel scenario manager allows you to store multiple scenarios and switch them on and off when required. It is ideal when you have entirely different cases (e.g. optimistic, realistic and pessimistic) that involve changing a number of variables.
So in the mini model below, we have a purchase of equipment but we can’t agree on the key inputs. We can run multiple scenarios based on our assumptions or the offers made by various suppliers.
To see the full course contents click here.