SOLUTION: OK i need to work out the price that we were beaten by to win some jobs with a particular client. I'll give 3 examples, and what I am after is a fixed formula so I can work out wh

Algebra ->  Permutations -> SOLUTION: OK i need to work out the price that we were beaten by to win some jobs with a particular client. I'll give 3 examples, and what I am after is a fixed formula so I can work out wh      Log On


   

Question 105934: OK i need to work out the price that we were beaten by to win some jobs with a particular client.
I'll give 3 examples, and what I am after is a fixed formula so I can work out what was quoted by our opposition each time.
Example#1: We won the job, quoting $1550. The variation % is 0.00%
Example#2: We have lost this job. Our quote $590. Variation 100%, therefore I calculate the winning quote to be $295.
Example#3: Our Quote: $2145. Variation: 50% Would the winning quote be $1430?
Example#4: our quote: $2435. Variation: 35.12%
Example#5: Our quote $330. Variation: 65.0%
Can someone come up with a formula that works everytime?
Thanks Kathy
Answer by scott8148(6628) About Me  (Show Source):
You can put this solution on YOUR website!
try ... (your_quote)/(100%+(variation))=(winning_quote)