Durham Fox
El Dude Brother.
I need to create a formula in excel that will calculate how much I need to increase a customers discount by to negate an increase in RRP.
Scenario:
Dave is a customer and gets varying discounts on different product areas (with multiple products, all priced individually) he buys from me:
Daves Discounts
All dry goods 45%
All fresh goods 35%
Homeware 65%
Frozen Foods 55%
I've decided to increase the base cost of all of my stock by different amounts in the above areas.
RRP Increases
All dry goods 5%
All fresh goods 3%
Homeware 6%
Frozen Foods 5%
Dave is such a good customer I don't want to pass on the increase in prices to him so have agreed to increase his discounts to negate the change.
How do I work that out in excel?
Example - a item in dry goods has an RRP of £1 and Dave would normally buy this at 55p (ie 45% discount). I'm increasing the RRP to £1.05. What should his discount be now to ensure he still pays 55p? and more importantly, how do I calculate that so I can apply it to each product area?
Scenario:
Dave is a customer and gets varying discounts on different product areas (with multiple products, all priced individually) he buys from me:
Daves Discounts
All dry goods 45%
All fresh goods 35%
Homeware 65%
Frozen Foods 55%
I've decided to increase the base cost of all of my stock by different amounts in the above areas.
RRP Increases
All dry goods 5%
All fresh goods 3%
Homeware 6%
Frozen Foods 5%
Dave is such a good customer I don't want to pass on the increase in prices to him so have agreed to increase his discounts to negate the change.
How do I work that out in excel?
Example - a item in dry goods has an RRP of £1 and Dave would normally buy this at 55p (ie 45% discount). I'm increasing the RRP to £1.05. What should his discount be now to ensure he still pays 55p? and more importantly, how do I calculate that so I can apply it to each product area?
Last edited: