| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working out other people's profit margins with Excel
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Working out other people's profit margins with Excel
Wouldn't that get me 10% of the total fee. So if the fee is $20, the sheet
would show 10% as $2. But what I want to know is: if the total fee is $20, and I know their markup is 10% - how much is their markup in dollars? "Toppers" wrote: =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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Working out other people's profit margins with Excel
=Fee-ROUND(Fee/(1+x%),2)
Where x% is the markup For 20$ this gives fee of $18.18 and markup of $1.82 Is this what you want? "Karl" wrote: Wouldn't that get me 10% of the total fee. So if the fee is $20, the sheet would show 10% as $2. But what I want to know is: if the total fee is $20, and I know their markup is 10% - how much is their markup in dollars? "Toppers" wrote: =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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Working out other people's profit margins with Excel
perfect, thank you.
"Toppers" wrote: =Fee-ROUND(Fee/(1+x%),2) Where x% is the markup For 20$ this gives fee of $18.18 and markup of $1.82 Is this what you want? "Karl" wrote: Wouldn't that get me 10% of the total fee. So if the fee is $20, the sheet would show 10% as $2. But what I want to know is: if the total fee is $20, and I know their markup is 10% - how much is their markup in dollars? "Toppers" wrote: =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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fomula for working out profit | Excel Discussion (Misc queries) | |||
| I need an Excel template that will calculate Retail Gross Profit | Excel Worksheet Functions | |||
| How do I work out people's exact ages from their Dates of Birth? | Excel Discussion (Misc queries) | |||
| How do I prepare a cost-volume-profit (CVP) graph using EXCEL? | Charts and Charting in Excel | |||
| Adding My Profit Margins to Supplyer's Pricelist.xls | New Users to Excel | |||
Linear Mode
