Hello all

I'm not Math major or a Math champ but just a guy doing a retail store business. Would like to know how much the sales volume has to increase when price is reduced by a certain % keeping the same profit if my margin is 5%,10% and 15%. I got the file from a old page which had no explanation how they figures came up. If someone can explain me the concept I would like to do this in excel.

Thanks!