while(motivation <= 0)

Back to the blog...
Finding the maximum bid for achiving a specific discount over retail

So this weekend, I set about solving a problem that was bothering me. When purchasing a pewpew at auction, what should the maximum bid be, assuming we want a specified percentage discount off the retail new price for a given item?

Building on an existing formula I had worked out to calculate the savings percent over retail, I started working backwards.

Assumptions

Variables

a table of variables
With the variables defined, now we can work backwards and then solve for the bid. excel sheet formulas
Last but not least, while solving for B, I tried a number of AI assistants. The winner ended up being ChatGPT, which was able to isolate B on the left side of the equation.
max bid formula