Spreadsheet: 673126d1587194274-excel-solver-simplex-lp-constraints-are-not-respected-biopharma-handin-case-4th_opensolver
Sheet: BipharmaNewNew

 |  |  | HighCal |  | Relax |  |  |  | High Cal Production, Transport & Import cost
Market | Plant | Capacity | sales | Production 2013 | sales | Production 2013 |  |  | From/To | Latin America | Europe | Asia | Japan | Mexico | U.S
Latin America | Brazil | 18000000 | 7000000 | 11000000 | 7000000 | 7000000 |  |  | Brazil
Europe | Germany | 45000000 | 15000000 | 15000000 | 12000000 | 0 |  |  | Germany
Asia | India | 18000000 | 5000000 | 10000000 | 3000000 | 8000000 |  |  | India
Japan | Japan | 10000000 | 7000000 | 2000000 | 8000000 | 0 |  |  | Japan
Mexico | Mexico | 30000000 | 3000000 | 12000000 | 3000000 | 18000000 |  |  | Mexico
U.S | U.S | 22000000 | 18000000 | 5000000 | 17000000 | 17000000 |  |  | U.S
 |  |  |  |  |  |  |  |  | Relax Production, Transport & Import cost
 |  |  |  |  |  |  |  |  | From/To | Latin America | Europe | Asia | Japan | Mexico | U.S
 |  |  |  |  |  |  |  |  | Brazil
Variable and fixed costs |  |  |  |  |  |  |  |  | Germany
Plant | Plant Fixed Cost | [NAME] | Relax Fix | HighCal Raw mat | HighCal Production Cost | Relax Raw Mat Cost | Relax Production Cost |  | India
Brazil | 20000000 | 5000000 | 5000000 | 3.6 | 5.1 | 4.6 | 6.6 |  | Japan
Germany | 45000000 | 13000000 | 13000000 | 3.9 | 6 | 5 | 7 |  | Mexico
India | 14000000 | 3000000 | 3000000 | 3.6 | 4.5 | 4.5 | 6 |  | U.S
Japan | 13000000 | 4000000 | 4000000 | 3.9 | 6 | 5.1 | 7
Mexico | 30000000 | 6000000 | 6000000 | 3.6 | 5 | 4.6 | 6.5 |  | Volume [NAME]
U.S | 23000000 | 5000000 | 5000000 | 3.6 | 5 | 4.5 | 6.5 |  | From/To | Latin America | Europe | Asia | Japan | Mexico | U.S | Total Production | HighCal MAX
 |  |  |  |  |  |  |  |  | Brazil | 0 | 0 | 0 | 0 | 0 | 0
Transportation Costs per kg. |  |  |  |  |  |  |  |  | Germany | 0 | 0 | 0 | 0 | 0 | 0
From/To | Latin America | Europe | Asia | Japan | Mexico | U.S |  |  | India | 0 | 0 | 3000000 | 0 | 0 | 0
Brazil | 0.2 | 0.45 | 0.5 | 0.5 | 0.4 | 0.45 |  |  | Japan | 0 | 0 | 0 | 0 | 0 | 0
Germany | 0.45 | 0.2 | 0.35 | 0.4 | 0.3 | 0.3 |  |  | Mexico | 7000000 | 13000000 | 0 | 7000000 | 3000000 | 0
India | 0.5 | 0.35 | 0.2 | 0.3 | 0.5 | 0.45 |  |  | U.S | 0 | 2000000 | 2000000 | 0 | 0 | 18000000
Japan | 0.5 | 0.4 | 0.3 | 0.1 | 0.45 | 0.45 |  |  | Supplied
Mexico | 0.4 | 0.3 | 0.5 | 0.45 | 0.2 | 0.25 |  |  |  | = | = | = | = | = | =
U.S | 0.45 | 0.3 | 0.45 | 0.45 | 0.25 | 0.2 |  |  | Sales | 7000000 | 15000000 | 5000000 | 7000000 | 3000000 | 18000000
Import Tax percentage |  |  |  |  |  |  |  |  | Volume [NAME]
 | Latin America | Europe | Asia | Japan | Mexico | U.S |  |  | From/To | Latin America | Europe | Asia | Japan | Mexico | U.S | Total Production | Relax MAX
 | 0.3 | 0.03 | 0.27 | 0.06 | 0.35 | 0.04 |  |  | Brazil | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | Germany | 0 | 12000000 | 0 | 6000000 | 0 | 17000000
 | Open/idle - Binary values |  |  | Fixed Cost |  |  |  |  | India | 7000000 | 0 | 3000000 | 2000000 | 3000000 | 0
Plant | Plant Open / Close | HighCal Open / Close | Relax Open / Close | Plant Fixed Cost | Highcal Fixed Cost | Relax Fixed Cost |  |  | Japan | 0 | 0 | 0 | 0 | 0 | 0
Brazil | 0 | 0 | 0 |  |  |  |  |  | Mexico | 0 | 0 | 0 | 0 | 0 | 0
Germany | 1 | 0 | 1 |  |  |  |  |  | U.S | 0 | 0 | 0 | 0 | 0 | 0
India | 1 | 1 | 1 |  |  |  |  |  | Supplied
Japan | 0 | 0 | 0 |  |  |  |  |  |  | = | = | = | = | = | =
Mexico | 1 | 1 | 0 |  |  |  |  |  | Sales | 7000000 | 12000000 | 3000000 | 8000000 | 3000000 | 17000000
U.S | 1 | 1 | 0
 | Capacity Constraints |  |  |  |  |  |  |  | Fixed Costs | Other Cost
Plant | Plant [NAME] |  | Totalproduction
Brazil |  |  |  |  |  |  |  |  | Total Cost
Germany |  |  |  |  |  |  |  | Objective Function:
India |  | [NAME]
Japan
Mexico
U.S |  |  |  |  |  |  |  |  | The results should be:
 |  |  |  |  |  |  |  |  | Fixed costs | Other Cost
 |  |  |  |  |  |  |  |  | 177000000 | 1177096000
 |  |  |  |  |  |  |  |  | Total Cost