Minimum Pricing Formula - Please Help if you can with Excel
I am trying to put together a one-cell excel formula so that I can calculate a minimum selling price for a given item after all expenses, commissions, and taxes(vat) are paid.
My costs are:
Item purchase price excluding VAT@15%
0.83p per item
14.35% comissions of the gross selling price
1.5% comissions of the gross selling price
15% vat of the gross selling price
My formula needs to factor in a minimum of .35 pence NET profit after all is paid.
Can anyone help? Any help on this would be very much appreciated! :)