Working out other people's profit margins with Excel
=Hourly rate *10% etc
So if %s are in B1, C1, & D1 and hourly rate in A2:
=A2*B1 will give 10% markup.
For 10$ an hour = 1$ fee
HTH
"Karl" wrote:
Hi,
I want to work out how much agencies are charging us for temps. I want to
create a spreadsheet into which the user can enter the hourly rate the agency
is charging.
There will be three columns, headed as follows: 10%, 12.5%, 15%.
As you'd expect, the 10% column will tell the user how much markup the
agency is making if 10% of the hourly rate is made up by their fee.
Can anyone tell me how to do this? It feels like it should be simple, but
nothing I try works.
Cheers
Karl
|