View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default I need a percentage Formula

Hi

It depends whether you are are saying you want 15% 15% markup on cost.

Total cost = (Cost + Shipping) * (1+commison%)
Commission of 15% =
Total Cost *(1+15%)
therefore True Cost = Total cost * (1 + 15%)
= Total Cost *1.15
with your example
True cost = (10+5)*(1+15%) = 17.25

With a Markup of 15%
Sale Price = 17.25 * (1+markup%) = 17.25 * (1+15%) = 17.25 * 1.15 = 19.84

--

Regards
Roger Govier

"Gmata" wrote in message
...
Ok so basicly i want to know at how much do i need to sell a product to
have
a 15% profit.

the problem is i get charged a 15% commision for selling my products on
Amazon with the Shipping included.

So if a product cost me $10 + $5 for shipping = $15 and i get charged 15%
of
that, $ 2.25.

So how much do i need to sell my product to make 15% profit. i need a
formula.

Thanks

Gmata