Costs to only increase by occupancy and not price

[rajkenya1]

Hi

In the attached spreadsheet i have costs that are based on a % of revenue. Revenue is calculated with price which is say $100 in cell ref d4 x no of places in each year. Accordingly costs are then calculated as % of this revenue.

Now when i want to do a sensitivity, say increase price by $105 (cell ref d5) then costs should not change as costs do not necessarily increase in line with price increase.

Is there anyway i can put a formula in say cell e15 which will only increase costs with the initial entry of say $100 x 50 places.

 

[r2c2]

Hi

In the attached spreadsheet i have costs that are based on a % of revenue. Revenue is calculated with price which is say $100 in cell ref d4 x no of places in each year. Accordingly costs are then calculated as % of this revenue.

Now when i want to do a sensitivity, say increase price by $105 (cell ref d5) then costs should not change as costs do not necessarily increase in line with price increase.

Is there anyway i can put a formula in say cell e15 which will only increase costs with the initial entry of say $100 x 50 places.

You can add another row of revenue calcs in the model and use them for figuring out costs.

 

[rajkenya1]

Thanks

But it doesnt help as i wanted to formularise it without adding new rows as this is part of a wider model. The idea is to make it flexible and robust.

You can add another row of revenue calcs in the model and use them for figuring out costs.

 

[r2c2]

Why hesitate from adding rows. It is not like you are paying by row. If you don't want this extra row to show up in final output, just hide it or set up an output sheet that only refers to the rows you need.