Spreadsheet: 544570d1508946967-product-order-optimisation-test-data_solver_model_2
Sheet: Sheet1_solver_setup

out
Click Volume | 1000
Click Share | 0.3548378527106776 | 0.1523786030095448 | 0.1165221351448794 | 0.09807776238638304 | 0.07228220649348184 | 0.05565950018026906 | 0.04468395984743543 | 0.04434619252737243 | 0.03253951687887816 | 0.0286722708210782
Position | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Product 1 | 0.3282941266046283 | 0.09792389780758952 | 0.06483348677771936 | 0.05378324086673049 | 0.03763947970155039 | 0.03036300845007509 | 0.02137119708174898 | 0.03450876306238158 | 0.01733371640252636 | 0.01532648469577928
Product 2 | 0.08700738061810606 | 0.06463510544631154 | 0.03627873859242786 | 0.0395753668591419 | 0.02900432654585517 | 0.02189797914469669 | 0.01549266128712024 | 0.01648782617151959 | 0.009759292748204381 | 0.005805225716246459
Product 3 | 0.2843654950093158 | 0.08471985026224621 | 0.102075555872776 | 0.06154839294974783 | 0.04715752206855917 | 0.02852091795769125 | 0.03254373777410162 | 0.04086927563746933 | 0.03686533024040269 | 0.03209850255541037 |  |  |  |  |  | 1
Product 4 | 0.2842553353173245 | 0.1199836665968859 | 0.08815741288790484 | 0.0704125815922389 | 0.055276759977794 | 0.04274665323827942 | 0.03470316148036767 | 0.0345332065133095 | 0.01845165693603265 | 0.0168710934980634
Product 5 | 0.606829296271252 | 0.3162520097348221 | 0.2232098742281882 | 0.1894391873452315 | 0.08301711483834276 | 0.09531200736933504 | 0.03693204321518898 | 0.006517822835243997 | 0.007553676304066644 | 0.01660484128845366
Product 6 | 0.2589003865309124 | 0.1176125790366832 | 0.07200545567018327 | 0.05138356005361941 | 0.06001848640730691 | 0.04431453129861346 | 0.02845937588790138 | 0.02989183564229071 | 0.02678991453555069 | 0.02278300915641998
Product 7 | 0.1489057450711082 | 0.1022096101762042 | 0.04644842408926559 | 0.03453670168187895 | 0.02496563951007856 | 0.01856999922183582 | 0.01617262818676799 | 0.01400709814072935 | 0.012442206945224 | 0.01058768477565872
Product 8 | 0.1673338400461997 | 0.07725202756386063 | 0.05882698682049252 | 0.05993433813244309 | 0.03634295499316902 | 0.03561249549612755 | 0.02116678568184961 | 0.02005746679375989 | 0.01567050015634361 | 0.01358079750915243
Product 9 | 0.1134664237761594 | 0.02502892406056801 | 0.01929057412593202 | 0.05653964387842805 | 0.03596307778690108 | 0.009978418328676731 | 0.00743460909915914 | 0.007590741930556055 | 0.006337081894725034 | 0.01051170093766665
Product 10 | 0.245863495611291 | 0.09290595373462901 | 0.08067755988402986 | 0.08054153880710392 | 0.04664782925384512 | 0.03590075473368393 | 0.04410152072406733 | 0.05671192271827587 | 0.0344666570481923 | 0.03033275574768161
Binary Grid |  |  |  |  |  |  |  |  |  |  | Sum Activity |  | Costr 3
Product 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  | =< | 1
Product 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |  |  | 1
Product 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
Product 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
Product 5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
Product 6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  |  | 1
Product 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  | 1
Product 8 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  | 1
Product 9 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
Product 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  | 1
 | =< | =< | =< | =< | =< | =< | =< | =< | =< | =<
[NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Object func
Desired Solution would be a table as below which shows what order is optimal and a calculation of what the total income would be
Position | Product
1 | 5
2 | 5
3 | 5
4 | 5
5 | 6
6 | 4
7 | 5
8 | 7
9 | 1
10 | 2
Total Income | 0.71