Profit Target Margin

[JimFreestyle]

Hi all,

I am trying to add to my existing costing model which is very basic and made by myself.

I sell online and I sell many products (over 300) and I would like to work out the selling price based on a percentage target but I cannot find any formulas online.

So basically I would like to type in "15%" and this will add the correct selling price to all of my products based on the the fee's I have to pay for selling online dependant on the marketplace.

I have all of my fees worked out already on a sheet I just can't figure a way of creating a formula to add the selling price in for me based on the fees.

Below is my current costing model, I would just love to have a cell which I can put "15%" in and it populates the "sell price" column with the correct sell price!

Any help greatly appeciated.

 

[6StringJazzer]

Which figure is your total cost? In this example Cost + Profit does not equal Sell Price so I can't figure out what your calculations are.

The formula for sell price is:

Price = Cost / (1 - Margin)

where Cost is marginal unit cost (that is, not including fixed costs) and Margin is a percent.

You have not given enough information to write an actual Excel formula for this that will work in your sheet because row and column headings are not shown, and calculations are not shown.

 

[JimFreestyle]

Which figure is your total cost? In this example Cost + Profit does not equal Sell Price so I can't figure out what your calculations are.

The formula for sell price is:

Price = Cost / (1 - Margin)

where Cost is marginal unit cost (that is, not including fixed costs) and Margin is a percent.

You have not given enough information to write an actual Excel formula for this that will work in your sheet because row and column headings are not shown, and calculations are not shown.

Thanks for the reply.

Total cost would be the cells, cost price, post and total ebay fees.

Thanks

 

[JimFreestyle]

Which figure is your total cost? In this example Cost + Profit does not equal Sell Price so I can't figure out what your calculations are.

The formula for sell price is:

Price = Cost / (1 - Margin)

where Cost is marginal unit cost (that is, not including fixed costs) and Margin is a percent.

You have not given enough information to write an actual Excel formula for this that will work in your sheet because row and column headings are not shown, and calculations are not shown.

Just to add to my last message my costing model works as it should for now but I am wanting to mass update all of prices to produce a certain percentage profit to save myself hours of going through each line.

 

[ExceLoki]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	sku	description	qty	each new	vat	each w/vat	location	weight	stock	pack size	sell price	cost	ebay fee	fvf	post	ebay fee2	ebay fee vat	total ebay fees	total fees	profit	total weight	desired profit margin
2	1166	white hit and miss vents 9x9" 10 each		2	20%	2.4	a01-02	268		1	5.32	2.4	0.71	0.3	0.9	1.01	0.2	1.22	2.12	0.80	268	15%
Sheet1

Cell Formulas
Range	Formula
K2	K2	=([cost]+[total fees])/(1-[desired profit margin])
S2	S2	=[@[total ebay fees]]+[@post]
T2	T2	=[@[sell price]]-([@cost]+[@[total fees]])