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

Microsoft Excel 16.0 Answer Report
Worksheet: [Biopharma Handin Case 4 attempt.xlsx]BipharmaNewNew
Report Created: 17-Apr-20 17:44:01
Result: Solver found a solution.  All Constraints and optimality conditions are satisfied.
Solver Engine
 | Engine: [NAME]
 | Solution Time: 0.188 Seconds.
 | Iterations: 41 Subproblems: 2
Solver Options
 | [NAME],  Iterations Unlimited, Precision 0.000001
 | Max Subproblems Unlimited, [NAME], [NAME] 1%, Assume NonNegative
Objective Cell (Min)
 | Cell | Name | Original Value | Final Value
 | $J$47 | Germany Total Cost | 1225533000 | 1225533000
Variable Cells
 | Cell | Name | Original Value | Final Value | [NAME]
 | $B$37 | Brazil Plant Open / Close | 0 | 0 | Binary
 | $C$37 | Brazil HighCal Open / Close | 0 | 0 | Binary
 | $D$37 | Brazil Relax Open / Close | 0 | 0 | Binary
 | $B$38 | Germany Plant Open / Close | 0 | 0 | Binary
 | $C$38 | Germany HighCal Open / Close | 0 | 0 | Binary
 | $[NAME] | Germany Relax Open / Close | 0 | 0 | Binary
 | $B$39 | India Plant Open / Close | 1 | 1 | Binary
 | $C$39 | India HighCal Open / Close | 1 | 1 | Binary
 | $[NAME] | India Relax Open / Close | 1 | 1 | Binary
 | $[NAME] | Japan Plant Open / Close | 0 | 0 | Binary
 | $C$40 | Japan HighCal Open / Close | 0 | 0 | Binary
 | $[NAME] | Japan Relax Open / Close | 0 | 0 | Binary
 | $B$41 | Mexico Plant Open / Close | 1 | 1 | Binary
 | $C$41 | Mexico HighCal Open / Close | 1 | 1 | Binary
 | $D$41 | Mexico Relax Open / Close | 0 | 0 | Binary
 | $B$42 | U.S Plant Open / Close | 0 | 0 | Binary
 | $C$42 | U.S HighCal Open / Close | 0 | 0 | Binary
 | $D$42 | U.S Relax Open / Close | 0 | 0 | Binary
 | $K$33 | Brazil Latin America | 0 | 0 | [NAME]
 | $L$33 | Brazil Europe | 0 | 0 | [NAME]
 | $M$33 | Brazil Asia | 0 | 0 | [NAME]
 | $N$33 | Brazil Japan | 0 | 0 | [NAME]
 | $O$33 | Brazil Mexico | 0 | 0 | [NAME]
 | $[NAME] | Brazil U.S | 0 | 0 | [NAME]
 | $K$34 | Germany Latin America | 0 | 0 | [NAME]
 | $L$34 | Germany Europe | 0 | 0 | [NAME]
 | $M$34 | Germany Asia | 0 | 0 | [NAME]
 | $N$34 | Germany Japan | 0 | 0 | [NAME]
 | $O$34 | Germany Mexico | 0 | 0 | [NAME]
 | $P$34 | Germany U.S | 0 | 0 | [NAME]
 | $K$35 | India Latin America | 7000000 | 7000000 | [NAME]
 | $L$35 | India Europe | 12000000 | 12000000 | [NAME]
 | $M$35 | India Asia | 3000000 | 3000000 | [NAME]
 | $N$35 | India Japan | 8000000 | 8000000 | [NAME]
 | $[NAME] | India Mexico | 3000000 | 3000000 | [NAME]
 | $P$35 | India U.S | 17000000 | 17000000 | [NAME]
 | $K$36 | Japan Latin America | 0 | 0 | [NAME]
 | $L$36 | Japan Europe | 0 | 0 | [NAME]
 | $M$36 | Japan Asia | 0 | 0 | [NAME]
 | $N$36 | Japan Japan | 0 | 0 | [NAME]
 | $O$36 | Japan Mexico | 0 | 0 | [NAME]
 | $P$36 | Japan U.S | 0 | 0 | [NAME]
 | $K$37 | Mexico Latin America | 0 | 0 | [NAME]
 | $L$37 | Mexico Europe | 0 | 0 | [NAME]
 | $M$37 | Mexico Asia | 0 | 0 | [NAME]
 | $N$37 | Mexico Japan | 0 | 0 | [NAME]
 | $O$37 | Mexico Mexico | 0 | 0 | [NAME]
 | $P$37 | Mexico U.S | 0 | 0 | [NAME]
 | $K$38 | U.S Latin America | 0 | 0 | [NAME]
 | $L$38 | U.S Europe | 0 | 0 | [NAME]
 | $M$38 | U.S Asia | 0 | 0 | [NAME]
 | $N$38 | U.S Japan | 0 | 0 | [NAME]
 | $O$38 | U.S Mexico | 0 | 0 | [NAME]
 | $P$38 | U.S U.S | 0 | 0 | [NAME]
 | $K$21 | Brazil Latin America | 0 | 0 | [NAME]
 | $[NAME] | Brazil Europe | 0 | 0 | [NAME]
 | $M$21 | Brazil Asia | 0 | 0 | [NAME]
 | $N$21 | Brazil Japan | 0 | 0 | [NAME]
 | $[NAME] | Brazil Mexico | 0 | 0 | [NAME]
 | $P$21 | Brazil U.S | 0 | 0 | [NAME]
 | $[NAME] | Germany Latin America | 0 | 0 | [NAME]
 | $L$22 | Germany Europe | 0 | 0 | [NAME]
 | $M$22 | Germany Asia | 0 | 0 | [NAME]
 | $[NAME] | Germany Japan | 0 | 0 | [NAME]
 | $O$22 | Germany Mexico | 0 | 0 | [NAME]
 | $P$22 | Germany U.S | 0 | 0 | [NAME]
 | $K$23 | India Latin America | 6000000 | 6000000 | [NAME]
 | $L$23 | India Europe | 0 | 0 | [NAME]
 | $M$23 | India Asia | 5000000 | 5000000 | [NAME]
 | $[NAME] | India Japan | 7000000 | 7000000 | [NAME]
 | $O$23 | India Mexico | 0 | 0 | [NAME]
 | $P$23 | India U.S | 0 | 0 | [NAME]
 | $[NAME] | Japan Latin America | 0 | 0 | [NAME]
 | $[NAME] | Japan Europe | 0 | 0 | [NAME]
 | $[NAME] | Japan Asia | 0 | 0 | [NAME]
 | $N$24 | Japan Japan | 0 | 0 | [NAME]
 | $O$24 | Japan Mexico | 0 | 0 | [NAME]
 | $P$24 | Japan U.S | 0 | 0 | [NAME]
 | $K$25 | Mexico Latin America | 999999.9999999963 | 999999.9999999963 | [NAME]
 | $[NAME] | Mexico Europe | 15000000 | 15000000 | [NAME]
 | $M$25 | Mexico Asia | 0 | 0 | [NAME]
 | $N$25 | Mexico Japan | 0 | 0 | [NAME]
 | $O$25 | Mexico Mexico | 3000000 | 3000000 | [NAME]
 | $P$25 | Mexico U.S | 18000000 | 18000000 | [NAME]
 | $K$26 | U.S Latin America | 0 | 0 | [NAME]
 | $L$26 | U.S Europe | 0 | 0 | [NAME]
 | $M$26 | U.S Asia | 0 | 0 | [NAME]
 | $N$26 | U.S Japan | 0 | 0 | [NAME]
 | $O$26 | U.S Mexico | 0 | 0 | [NAME]
 | $[NAME] | U.S U.S | 0 | 0 | [NAME]
Constraints
 | Cell | Name | Cell Value | [NAME] | Status | Slack
 | $F$46 | Brazil Totalproduction | 0 | $F$46<=$B$46 | Binding | 0
 | $F$47 | Germany Totalproduction | 0 | $F$47<=$B$47 | Binding | 0
 | $F$48 | ≥ Totalproduction | 68000000 | $F$48<=$B$48 | Binding | 0
 | $F$49 | Japan Totalproduction | 0 | $[NAME] | Binding | 0
 | $F$50 | Mexico Totalproduction | 37000000 | $F$50<=$B$50 | Binding | 0
 | $F$51 | U.S Totalproduction | 0 | $F$51<=$B$51 | Binding | 0
 | $K$27 | Supplied Latin America | 6999999.999999996 | $K$27=$K$29 | Binding | 0
 | $L$27 | Supplied Europe | 15000000 | $L$27=$L$29 | Binding | 0
 | $M$27 | Supplied Asia | 5000000 | $M$27=$M$29 | Binding | 0
 | $N$27 | Supplied Japan | 7000000 | $[NAME] | Binding | 0
 | $O$27 | [NAME] | 3000000 | $O$27=$O$29 | Binding | 0
 | $P$27 | Supplied U.S | 18000000 | $P$27=$P$29 | Binding | 0
 | $K$39 | Supplied Latin America | 7000000 | $[NAME] | Binding | 0
 | $[NAME] | Supplied Europe | 12000000 | $L$39=$L$41 | Binding | 0
 | $[NAME] | Supplied Asia | 3000000 | $M$39=$M$41 | Binding | 0
 | $[NAME] | Supplied Japan | 8000000 | $N$39=$N$41 | Binding | 0
 | $[NAME] | [NAME] | 3000000 | $O$39=$O$41 | Binding | 0
 | $[NAME] | Supplied U.S | 17000000 | $P$39=$P$41 | Binding | 0
 | $Q$21 | Brazil Total Production | 0 | $[NAME] | Binding | 0
 | $[NAME] | Germany Total Production | 0 | $Q$22<=$R$22 | Binding | 0
 | $[NAME] | India Total Production | 18000000 | $Q$23<=$R$23 | Binding | 0
 | $Q$24 | Japan Total Production | 0 | $Q$24<=$R$24 | Binding | 0
 | $Q$25 | Mexico Total Production | 37000000 | $Q$25<=$R$25 | Binding | 0
 | $Q$26 | U.S Total Production | 0 | $Q$26<=$R$26 | Binding | 0
 | $Q$33 | Brazil Total Production | 0 | $Q$33<=$R$33 | Binding | 0
 | $Q$34 | Germany Total Production | 0 | $Q$34<=$R$34 | Binding | 0
 | $Q$35 | India Total Production | 50000000 | $Q$35<=$R$35 | Binding | 0
 | $Q$36 | Japan Total Production | 0 | $Q$36<=$R$36 | Binding | 0
 | $Q$37 | Mexico Total Production | 0 | $Q$37<=$R$37 | Binding | 0
 | $Q$38 | U.S Total Production | 0 | $Q$38<=$R$38 | Binding | 0
 | $B$37:$D$42=Binary