| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate profit as a % of Sales price
I have all my costs (item, freight, storage, handeling, overhead) I want to
calculate profit as a % of the sales price. e.g. all my costs add up to $8.00 and I wan to make a 10% profit, what is my sales price? What formula do I use to calculate this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I calculate profit as a % of Sales price
hi,
=totalcost/0.9 or 8/.9 = 8.88 hth regards from Brazil Marcelo "bobnewmark" escreveu: I have all my costs (item, freight, storage, handeling, overhead) I want to calculate profit as a % of the sales price. e.g. all my costs add up to $8.00 and I wan to make a 10% profit, what is my sales price? What formula do I use to calculate this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I calculate profit as a % of Sales price
or
=8*1.10 Marcelo wrote: hi, =totalcost/0.9 or 8/.9 = 8.88 hth regards from Brazil Marcelo "bobnewmark" escreveu: I have all my costs (item, freight, storage, handeling, overhead) I want to calculate profit as a % of the sales price. e.g. all my costs add up to $8.00 and I wan to make a 10% profit, what is my sales price? What formula do I use to calculate this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I calculate profit as a % of Sales price
this is where we have the discussion regarding MARGIN and MARKUP
They are not the same. 8/.9 is a 10%margin ( ten percent discount arrives back at the cost) 8*1.1 is a 10% markup...not the same as above -- paul remove nospam for email addy! "GregR" wrote: or =8*1.10 Marcelo wrote: hi, =totalcost/0.9 or 8/.9 = 8.88 hth regards from Brazil Marcelo "bobnewmark" escreveu: I have all my costs (item, freight, storage, handeling, overhead) I want to calculate profit as a % of the sales price. e.g. all my costs add up to $8.00 and I wan to make a 10% profit, what is my sales price? What formula do I use to calculate this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Total Sales from a Database | Excel Worksheet Functions | |||
| Re-arrangement | Excel Discussion (Misc queries) | |||
| MSNStockQuote Function Parameters | Excel Worksheet Functions | |||
| calculate predicted sales value | Excel Worksheet Functions | |||
| how do we calculate T-bill Price in 365 days year. | Excel Worksheet Functions | |||
Linear Mode
