Hi All, This is my first post and looking to get this set up for a report I'm loking to complete for tuesday to my boss.

I'm struggling to work out a formula that will calculate the New WSP of a product through calculating it at a set % of 50% in terms of gross percentage margin. For example the existing of a product ;WSP is £6.03, the retail selling price is £1.08 and the cost £4.33, which provides a cash profit % of circa 72%. What I want to be able to do is calculate a new wsp by Applying the 50% margin rate. I.e. the product above GP% would drop by 22%!!!


Any Ideas?