tp.xlsx - Microsoft Excel 16.0 Answer Report Worksheet[Book1]Sheet1 Report Created 4:01:39 PM Result Solver found a solution All Constraints and

tp.xlsx - Microsoft Excel 16.0 Answer Report...

• 27

This preview shows page 1 - 6 out of 27 pages.

Microsoft Excel 16.0 Answer ReportWorksheet: [Book1]Sheet1Report Created: 2/20/2019 4:01:39 PMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0.031 Seconds.Iterations: 13 Subproblems: 0Solver OptionsMax Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic ScalingMax Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegativeObjective Cell (Min)CellNameOriginal ValueFinal Value\$J\$6Cost06780000Variable CellsCellNameOriginal ValueFinal ValueInteger\$C\$8Taiwan Seoul03500 Contin\$D\$8Taiwan Beijing00 Contin\$E\$8Taiwan Manila01000 Contin\$F\$8Taiwan Jakarta00 Contin\$G\$8Taiwan Dhaka00 Contin\$C\$9Ahmedabad Seoul00 Contin\$D\$9Ahmedabad Beijing00 Contin\$E\$9Ahmedabad Manila00 Contin\$F\$9Ahmedabad Jakarta01000 Contin\$G\$9Ahmedabad Dhaka02000 Contin\$C\$10Vietnam Seoul00 Contin\$D\$10Vietnam Beijing02000 Contin\$E\$10Vietnam Manila02000 Contin\$F\$10Vietnam Jakarta01500 Contin\$G\$10Vietnam Dhaka00 ContinConstraintsCellNameCell ValueFormulaStatusSlack\$C\$11rq Seoul3500 \$C\$11=\$C\$12Binding0\$D\$11rq Beijing2000 \$D\$11=\$D\$12Binding0\$E\$11rq Manila3000 \$E\$11=\$E\$12Binding0\$F\$11rq Jakarta2500 \$F\$11=\$F\$12Binding0\$G\$11rq Dhaka2000 \$G\$11=\$G\$12 Binding0\$H\$8Taiwan sq4500 \$H\$8<=\$I\$8Binding0\$H\$9Ahmedabad sq3000 \$H\$9<=\$I\$9Binding0\$H\$10Vietnam sq5500 \$H\$10<=\$I\$10Not Binding500
Microsoft Excel 16.0 Answer ReportWorksheet: [Book1]Sheet1Report Created: 2/20/2019 4:03:47 PMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0.031 Seconds.Iterations: 13 Subproblems: 0Solver OptionsMax Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic ScalingMax Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegativeObjective Cell (Min)CellNameOriginal ValueFinal Value\$J\$6Cost07375000Variable CellsCellNameOriginal ValueFinal ValueInteger\$C\$8Taiwan Seoul03500 Contin\$D\$8Taiwan Beijing00 Contin\$E\$8Taiwan Manila02000 Contin\$F\$8Taiwan Jakarta00 Contin\$G\$8Taiwan Dhaka00 Contin\$C\$9Ahmedabad Seoul00 Contin\$D\$9Ahmedabad Beijing00 Contin\$E\$9Ahmedabad Manila00 Contin\$F\$9Ahmedabad Jakarta0500 Contin\$G\$9Ahmedabad Dhaka02500 Contin\$C\$10Vietnam Seoul00 Contin\$D\$10Vietnam Beijing02700 Contin\$E\$10Vietnam Manila01000 Contin\$F\$10Vietnam Jakarta02000 Contin\$G\$10Vietnam Dhaka00 ContinConstraintsCellNameCell ValueFormulaStatusSlack\$C\$11rq Seoul3500 \$C\$11=\$C\$12Binding0\$D\$11rq Beijing2700 \$D\$11=\$D\$12Binding0\$E\$11rq Manila3000 \$E\$11=\$E\$12Binding0\$F\$11rq Jakarta2500 \$F\$11=\$F\$12Binding0\$G\$11rq Dhaka2500 \$G\$11=\$G\$12 Binding0\$H\$8Taiwan sq5500 \$H\$8<=\$I\$8Binding0\$H\$9Ahmedabad sq3000 \$H\$9<=\$I\$9Binding0\$H\$10Vietnam sq5700 \$H\$10<=\$I\$10Not Binding300
Microsoft Excel 16.0 Answer ReportWorksheet: [Book1]Sheet1Report Created: 2/20/2019 4:04:35 PMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.