Item Cost + eBay Fee % = NOT Item Sale Price, so what is?

Hewwo, working on a spreadsheet.

Item cost = actual item cost + desired profit + P&P bla bla bla. Item cost is known.

eBay fees = 8% + £0.30 for inserting the advert. Is that £0.30 added to the item cost? Or is it just subtracted from the Item cost?

What l want to achieve from the known data is the precise sale price on eBay for that item, through which l can precisely recover Item cost, and pay off the eBay fees, with zero left behind from the sale price.



I hope l am making myself clear, it might take a few re-takes for the problem to be appreciated. It sounds simple but when you think about it, you can become really frustrated.

Hiya Glenn,

It seems simple but it isn't, l'm afraid.

I'll try to rephrase the problem:


Item cost to me + Profit required + P&P = N

eBay fees = 8% + £0.30 insertion fee.

What, then, is the item's sale price?


Example of where it goes wrong for me:

I multiply N by 1.08 (108%), then add £0.30, to give eBay sale price.
If N = £10, eBay sale price thus is set at: £11.10.

BUT: Let's see what happens when the item listed at £11.10 actually sells.

£11.10 * 0.92 (100%-8% eBay fees) = £10.212.
Then subtract cost of the listing (£0,30) = £10.212 - £0.30 = £9.912 = N

Thus N becomes £9.912, when it was meant to be £10.



How do l calculate the sale price, such that when l levy the eBay fees, l am left with "Item Cost" (N) and nothing more, nothing less?



All figures quoted are imaginary.

Nice one Glenn, you killed it!

Already done thanks man.

I love this forum. Thanks all.