Discount Calculation

Good day.
I have a customer who is demanding an additional 8% discount so he can make extra margin without increasing his current selling price. I would like to calculate how much additional stock he should purchase for me to break even with this additional 8% discount. It is not as easy as working on the wholesale price less 8% and the increasing the number of units at the new discounted price to give you the same value. To set the rules please see below example.

Cost is 100.00
Markup is 50%
Wholesale is this 150.00
8% discount is -12.00
8% discount final amount is 138.00

Profit is 50.00 but after discount is 38.00.

So how would you calculate this with an easy formula to show how many unit should be purchased to get to the same unit profit?

I hope I have made it clear what I am looking for. Not the simple:

20 * 50.00 = 1000.00 in profit thus 26.5 *38.00 will give the same profit in unit of 1000.00.

I am looking for the calculation that will bring me the break even point of making the additional 8% discount worth it.

I look forward to some creative thinking.

Perhaps my business and math skills are rusty, but it's impossible to both offer an 8% discount per unit and make the same margin on a per-unit basis. It's a mathematical impossibility. You can only determine the break-even point of how many extra units you have to sell to make the same per-order margin, which is exactly the "simple" calculation you did above.

If you're talking how much extra he needs to purchase for a given order size, all you do is subtract the original order size from the new order size (in your simple calculation above) which would be 26.5 - 20 = 6.5 extra units for you to make the same profit.

I'm not quite sure what you're looking for.

units to be sold = present selling units * markup % / (markup % -(1+markup %)*discount%)

as per your example = 20*50%/(50%-(1+50%)*8%)

Thank you for all the feedback. I have worked on the attached which I think is easier from a sales perspective as it gives the increase in a percentage.

Similar to the options given.

Thanks once again



Working.xlsxWorking.xlsx