ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I calculate profit as a % of Sales price (https://www.excelbanter.com/excel-discussion-misc-queries/99332-how-do-i-calculate-profit-%25-sales-price.html)

bobnewmark

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?

Marcelo

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?


GregR

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?



paul

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?





All times are GMT +1. The time now is 05:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com