All,

I am trying to forecast the total remaining costs of doing business from a given month. The key issue I am having is around reallocating the fixed costs in future months as I cannot seem to get around a circular reference.

Fixed costs serve as the trigger that determines if a city should remain in operation. So for this example, when the costs drop below $10k, that city is removed from the operations budget from that month on. The fixed costs need to then be redistributed among the remaining cities at levels proportionate to their share of the subscribers.

I need to be able to generate the values in column P showing the total remaining spend through a certain time period based on future changes in fixed costs.

Any help or advice would be great to avoid the circular references on this.

Thanks!

Copy of book1.xlsx