Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 41
Default I need a percentage Formula

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,090
Default I need a percentage Formula

Say your cost is X. That includes all of your costs. To make a 15% profit
you need to sell it for 1.15 times X.
This means:
Your Selling price=1.15*((Product cost + Shipping)*1.15)
HTH Otto
"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



  #3   Report Post  
Posted to microsoft.public.excel.misc
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


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default I need a percentage Formula

It costs you $10 + $5 +$2.25 = $17.25 to sell your stuff on Amazon. To make
a 15% profit, you simply multiply your cost by 100% (your cost) + 15% (your
profit)or 115% or 1.15. Therefore your selling price has to be $17.25 * 1.15
= $19.84. $19.84 - $17.25 = $2.59 which is ($2.59 / $17.25) * 100 = 15%
(your profit).

Tyro

"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



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default I need a percentage Formula

But wouldn't Amazon's commission be based on the selling price?
--
David Biddulph

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
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






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default I need a percentage Formula

Hi David
You are probably right.
If that is the case, then it all depends whether the OP is wanting a 15%
return on turnover (sale price) or 15% markup on Cost.

If they want 15% on turnover (the same as Amazon) then sale price would be
Total Cost/(1-(15% + 15%))= Cost/(1-30%) = Cost/0.7 or 15/0.7 = 21.43
Amazon would receive 21.43 *15% = 3.21
Net proceeds to the OP would be 18.22 which after deducting the original 15
would leave them with 3.22

If they want a 15% markup on Total cost including Amazon's 15% of Sale price
then Sale Price would need to be
Total Cost * (1+15%)/(1-15%) = Total Cost*1.15/0.85 = 15*1.15/0.85 = 20.31
Amazon would receive 20.31 *15% = 3.05
Net proceeds to the OP would be 17.26 which after deducting the original 15
would leave them with 2.26 or 15% of 15.


--

Regards
Roger Govier

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
But wouldn't Amazon's commission be based on the selling price?
--
David Biddulph

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Percentage formula help LB Excel Worksheet Functions 2 November 16th 06 05:08 PM
Percentage Formula Kittykat8181 Excel Discussion (Misc queries) 2 November 28th 05 07:11 PM
Formula for percentage Tugger Excel Discussion (Misc queries) 2 May 26th 05 01:53 PM
percentage formula Tracy Excel Discussion (Misc queries) 1 April 5th 05 12:40 AM
Percentage formula st Excel Worksheet Functions 1 December 30th 04 06:13 PM


All times are GMT +1. The time now is 10:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"