Spreadsheet: 768502d1645002550-excel-opensolver-non-linearity-issue-opensolver-constraints-issue-
Sheet: Model 2 (w regions)

 |  |  |  |  | Price matrix |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Selection (variables) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | objective (min)
 |  |  |  |  | Supplier 1 | Supplier 1 | Supplier 1 | Supplier 2 | Supplier 2 | Supplier 2 | Supplier 3 | Supplier 3 | Supplier 3 | Supplier 3 | Supplier 3 | Supplier 4 | Supplier 4 | Supplier 4 | Supplier 5 |  | Supplier 1 | Supplier 1 | Supplier 1 | Supplier 2 | Supplier 2 | Supplier 2 | Supplier 3 | Supplier 3 | Supplier 3 | Supplier 3 | Supplier 3 | Supplier 4 | Supplier 4 | Supplier 4 | Supplier 5 |  |  |  | Model scenario
Client | Macro region | Region | Vol per year |  | Samara | Kashira | [NAME] | Samara | Kashira | [NAME] | Samara | Kashira | [NAME] | Lebedyan | Domodedovo | Kashira | Lebedyan | Domodedovo | [NAME] |  | Samara | Kashira | [NAME] | Samara | Kashira | [NAME] | Samara | Kashira | [NAME] | Lebedyan | Domodedovo | Kashira | Lebedyan | Domodedovo | [NAME] | # of choices |  |  | Total | Supplier | Volume |  |  |  | Demand | Supply
Client 1 | Moscow | Moscow region | 30713 |  | 350 | 350 | 350 | 220 | 220 | 220 | 999999 | 999999 | 999999 | 999999 | 999999 | 160 | 160 | 160 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  |  |  |  |  |  |  |  |  | 1200*800 | 1200*800
Client 2 | Moscow | Moscow region | 26512 |  | 210 | 210 | 210 | 220 | 220 | 220 | 999999 | 999999 | 999999 | 999999 | 999999 | 160 | 160 | 160 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  |  |  |  |  |  |  |  | Samara | 10000
Client 3 | Moscow | Moscow region | 17663 |  | 210 | 210 | 210 | 220 | 220 | 220 | 999999 | 999999 | 999999 | 999999 | 999999 | 190 | 190 | 190 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  |  |  |  |  |  |  | Kashira | 40000 |  | volume restriction (not more than a plant demands)
Client 4 | [NAME] | Nizhegorod region | 27489 |  | 350 | 350 | 350 | 377.2 | 377.2 | 377.2 | 999999 | 250 | 999999 | 250 | 250 | 999999 | 999999 | 999999 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | [NAME] | 35000
Client 5 | [NAME] | Nizhegorod region | 2367 |  | 350 | 350 | 350 | 999999 | 999999 | 999999 | 250 | 250 | 250 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | Lebedyan | 75000
Client 6 | [NAME] | Orenburg region | 2913 |  | 350 | 350 | 350 | 240 | 240 | 240 | 250 | 250 | 250 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | Domodedovo | 120000
Client 7 | [NAME] | Orenburg region | 1508 |  | 350 | 350 | 350 | 240 | 240 | 240 | 250 | 250 | 250 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Client 8 | [NAME] | Orenburg region | 13480 |  | 350 | 350 | 350 | 377.2 | 377.2 | 377.2 | 250 | 250 | 250 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Client 9 | Ural | Perm region | 17699 |  | 350 | 350 | 350 | 377.2 | 377.2 | 377.2 | 250 | 250 | 250 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Client 10 | [NAME] | MaryEl region | 3164 |  | 350 | 350 | 350 | 999999 | 999999 | 999999 | 999999 | 250 | 999999 | 250 | 250 | 999999 | 999999 | 999999 | 150 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  | Total |  | Share
Client 11 | [NAME] | Tatarstan | 27241 |  | 300 | 300 | 300 | 350 | 350 | 350 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | Supplier 1
Client 12 | [NAME] | Tatarstan | 1535 |  | 350 | 350 | 350 | 999999 | 999999 | 999999 | 250 | 250 | 250 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | Supplier 2
Client 13 | [NAME] | Chuvash republic | 983 |  | 350 | 350 | 350 | 999999 | 999999 | 999999 | 250 | 250 | 250 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | Supplier 3 |  |  | share (not yet active)
Client 14 | [NAME] | Chuvash republic | 827 |  | 350 | 350 | 350 | 999999 | 999999 | 999999 | 250 | 250 | 250 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | Supplier 4
Client 15 | [NAME] | Chuvash republic | 82 |  | 350 | 350 | 350 | 999999 | 999999 | 999999 | 250 | 250 | 250 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | Supplier 5
Client 16 | [NAME] | Chuvash republic | 30 |  | 350 | 350 | 350 | 999999 | 999999 | 999999 | 250 | 250 | 250 | 999999 | 999999 | 999999 | 999999 | 999999 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Client 17 | Moscow | Yaroslavl region | 44285 |  | 350 | 350 | 350 | 377.2 | 377.2 | 377.2 | 999999 | 999999 | 999999 | 999999 | 999999 | 160 | 160 | 160 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
Client 18 | Moscow | Yaroslavl region | 14239 |  | 350 | 350 | 350 | 377.2 | 377.2 | 377.2 | 999999 | 999999 | 999999 | 999999 | 999999 | 160 | 160 | 160 | 999999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | not more than 1 supplier per region
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Region | Supplier 1 | Supplier 2 | Supplier 3 | Supplier 4 | Supplier 5 | # of suppl
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Moscow region
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nizhegorod region
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Orenburg region
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Perm region
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MaryEl region
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tatarstan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chuvash republic
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yaroslavl region