Originally Posted by

**SamK** Hello,

Thank you very much for your reply and help. In my haste to get some help I forgot to mention that the items cost price varies and then we start adding on top of that vat +.75+.08 (thats where the .83 comes from) and then all the rest.

So it should be Item price+VAT, then .75 for shipping+0.08 handling, then 14.35% Commissions on the gross selling price, then 1.5% commissions on the gross selling price again, then finally another 15%vat to be taken into consideration of the gross selling price. Absolute net profit has to be a minimum of .35p.

Could I please be cheeky and ask you to post me the formula as it would appear in a single cell? Also does this take into account the output vat on the gross amount?

Once again I cannot stress enough how much this is helping me, so your help is very much appreciated.

Kind Regards,

Sam

Your post is quite hard to follow I'm afraid - did you mean that you start off with a product that costs **n** pence (inc VAT) to buy and then you have to add 0.75 shipping and 0.08 handling (these two are constants?)

From that you add the 14.5% commission and the 1.5% commission and finally the VAT at 15%. Also those three are cumulative so the 1.5% acts upon the 14.5% already added too

As this will be the total cost an extra 0.35 must be added to ensure your profit.

Is that right?

If so (and assuming n is in cell A8)

Part 1 (cost to buy): Code:

k =(A8*(1+0.15) + 0.08 + 0.75)

Purchase VAT

Shipping and Handling

Note I've used k to make it simpler in the next steps:

Part 2 (selling costs) Code:

k+0.145k + 0.015(k+0.145k) + 0.15(0.015(k+0.145k)) + 0.35

14.5% commission

1.5% commission

15% VAT on selling

0.35p profit margin

Reintroducing our expression for k:

Code:

(A8*(1+0.15) + 0.08 + 0.75)+0.145(A8*(1+0.15) + 0.08 + 0.75) + 0.015((A8*(1+0.15) + 0.08 + 0.75)+0.145(A8*(1+0.15) + 0.08 + 0.75)) + 0.15(0.015((A8*(1+0.15) + 0.08 + 0.75)+0.145(A8*(1+0.15) + 0.08 + 0.75))) + 0.35

I *think* that's right but you may want to check for yourself when subbing in your expression for k