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...

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
Background image
Background image
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
Background image
Background image
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.
Background image
Image of page 6

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture