Need help trying to calculate a net retail sales price for product

[mjg060468]

I am trying to work out what I need to sell a product for to return me a commission which equates to 50% of the net premium paid by a customer

Cost price of product = £57 ex VAT
Current Sales Price inc VAT £200
Current sales price ex VAT £166.67
Current Profit = £109.67 which equates to 66% of retail premium

I need to work out what I need to sell the product for to return me a commission of 50%

I am sure I am being really thick but it has got me stumped

Image of my spreadsheet below
excel.png

[Logit]

.
Wouldn't you add C4 & F4 ( 90.33 ) then add 50% to the sum ? 45.17 + 90.33 = 135.50

[Logit]

.


Markup Percentage = (Selling Price - Cost) / Cost X 100

[shg]

	A	B	C
1	VAT Rate	16.67%	B1: =20% / (1+ 20%)
2	GM Target	50%	B2: Input
3	Cost	$ 100.00	B3: Input
4	Price	$ 300.00	B4: =B3 / (1 - B1 - B2)
5	Check:
6	VAT	$ 50.00	B6: =B4 * B1
7	Dealer Gross	$ 250.00	B7: =B4 - B6
8	Dealer Net	$ 150.00	B8: =B7 - B3
9	Dealer GM	50%	B9: =B8 / B4