I'm looking to use excel to help me find the optimal order of products displayed on a eccommerce page.
Different revenue is generated from a click for each product dependent on the position on the page, so in the example below, Product 1 makes £33 for a click in position 1, £10 in position 2 etc. (Numbers are all made up here). The volume by position is ofcourse different (ie 40% will click P1 vs
20% click P2, however I have accounted for that in the £s to keep this simpler, so assume it is evenly spread)

Can I use excel to try every possible order to show what the optimal order is.

In this example there is on 5 products and therefore 5 positions, however in reality there may be 30-40 products

Capture.PNG

Many Thanks