Trying to increase product cost in one column by a predetermined gp% in another column

[lmcwilliams]

I am looking for a formula to find new sale price. In one column I have my current costs. (over 1,000 rows) In another column I have the GP%'s that I want to achieve (formatted as percent).
How would this formula look in excel?

 

[Toadstool]

Hi lmcwilliams,

In its simplest form Sales Price = Cost + Desired Profit
so if your cost is $10 and your desired profit % is 20% then your desired profit is $2. This doesn't account for fixed overheads (e.g. shop rent) or variable selling costs (e.g. sales representative wages).

If you have Cost and desired GP% then the formula is Sales Price = Cost + (Cost x GP%)

lmcwilliams.xlsx
	A	B	C	D
1	Product	Cost	GP%	Sales Price
2	Widget	$ 10.00	20%	$ 12.00
3	Bodgit	$ 50.00	50%	$ 75.00
4	Fixstuf	$ 120.00	200%	$ 360.00
5	Finagletool	$ 340.00	80%	$ 612.00
Sheet1

Cell Formulas
Range	Formula
D2:D5	D2	=B2+(B2*C2)

 

[alansidman]

Here is a great little tutorial that I couldn't have explained any better.

 

[lmcwilliams]

You guys are lifesavers! Thanks so much for your help!
L.

 

[Toadstool]

You guys are lifesavers! Thanks so much for your help!
L.

You're welcome.