Hi there,

I am building a model in excel to estimate the cost savings that a
company may achieve by implementing several cost savings initiatives.
The issue I have is that I have 10 different savings initiatives and
some of them reduce overlapping costs. Therefore, they are not
additive: If I choose to implement intiative 1, then I will not
achieve 100% of the value from initiative 2.

How can I set up scenarios so that if I make one initiative active,
100% of the value runs through the model, but if multiple initiatives
are active it recognizes the overlap ? Do I need to create an overlap
table / matrix that indicates how much of the value can be recognized?

Thanks!
Laura