Re-working original formula
((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin %
Billrate = ((PayRate*Fringe)+PayRate)/(1-Profit Margin%)


BillRate = ((12*0.24867)+12)/(1-0.30) = 21.405 %

verify with original figures
BillRate = ((12*0.24867)+12)/(1-0.2761) = 20.7 %



On Sat, 22 Jul 2006 19:27:21 +0100, bp wrote:

Hi Sandy,
Thanks for your reply
If I may go back, the formula below is actual. It works. But I must
adjust
the 20.7 until I achieve the 30% instead of the 27.61% displayed.
=((20.7-12)-(12*.24867))/20.7=27.61%

I need to try to establish a new equation to find X below
=((X-12)-(12*.24867))/X=30.00
Hope this makes sense
Can you help?
Thanks
Bill

"Sandy Mann" wrote in message
...

=((20.7-12)-(12*.24867))/20.7=27.61%

so by transposition

=((20.7-12)-(12*.24867))/30%=19.0532

therefore

=((20.7-12)-(12*.24867))/19.0532=30%


is that what you are looking for?
--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"bp" wrote in message
...
Hi All,
Running Win98SE :-( and Excel 2000.
Is it possible to get assistance with the following formula.
I am currently determining the Profit Margin Percent with the
following
((BillRate-Payrate)-(PayRate*Fringe))/BillRate=Profit Margin %
OR
=((20.7-12)-(12*.24867))/20.7=27.61%
I then have to play with the billrate to get a number close to 30%.
Is there a way to rework the formula by plugging in the 30% and
working
out
the BillRate?
Thanks
Bill









--
Steve (3)