QSO320-Homework_Three - Microsoft Excel 14.0 Answer Report Worksheet[Book1]Sheet1 Report Created 11:51:43 AM Result Solver found a solution All

QSO320-Homework_Three - Microsoft Excel 14.0 Answer Report...

This preview shows page 1 - 7 out of 25 pages.

Microsoft Excel 14.0 Answer ReportWorksheet: [Book1]Sheet1Report Created: 4/27/2016 11:51:43 AMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0.032 Seconds.Iterations: 15 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$B$20Objective Task 1295261Variable CellsCellNameOriginal ValueFinal ValueInteger$B$13Task 110 Contin$C$13Task 200 Contin$D$13Task 3 00 Contin$E$13Task 400 Contin$F$13Task 501 Contin$B$14Task 101 Contin$C$14Task 210 Contin$D$14Task 3 00 Contin$E$14Task 400 Contin$F$14Task 500 Contin$B$15Task 100 Contin$C$15Task 201 Contin$D$15Task 3 10 Contin$E$15Task 400 Contin$F$15Task 500 Contin$B$16Task 100 Contin$C$16Task 200 Contin$D$16Task 3 00 Contin$E$16Task 411 Contin$F$16Task 500 Contin$B$17Task 100 Contin$C$17Task 200 Contin$D$17Task 3 01 Contin$E$17Task 400 Contin$F$17Task 510 ContinConstraints
Background image
CellNameCell ValueFormulaStatusSlack$B$18Programmers Task 11 $B$18=1Binding0$C$18Programmers Task 21 $C$18=1Binding0$D$18Programmers Task 3 1 $D$18=1Binding0$E$18Programmers Task 41 $E$18=1Binding0$F$18Programmers Task 51 $F$18=1Binding0$G$13 Tasks1 $G$13=1Binding0$G$14 Tasks1 $G$14=1Binding0$G$15 Tasks1 $G$15=1Binding0$G$16 Tasks1 $G$16=1Binding0$G$17 Tasks1 $G$17=1Binding0
Background image
e
Background image
Background image
Assigning TasksInputsTask 1Task 2Task 3 Task 4Task 5Programmer 15025786460Programmer 24330705672Programmer 36028806668Programmer 45429756070Programmer 54532706275Decisions12345Tasks10000112100001301000140001015001001Programmers11111Objective261
Background image
Microsoft Excel 14.0 Answer ReportWorksheet: [QSO320-Homework_Three.xlsx]Problem 3.2cReport Created: 4/27/2016 1:52:48 PMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0.015 Seconds.Iterations: 15 Subproblems: 0Solver OptionsMax Time Unlimited, Iterations Unlimited, Precision 0.000001Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegativeObjective Cell (Min)CellNameOriginal ValueFinal Value$B$20Objective Task 10266Variable CellsCellNameOriginal ValueFinal ValueInteger$B$13Task 100 Contin$C$13Task 201 Contin$D$13Task 3 00 Contin$E$13Task 400 Contin$F$13Task 500 Contin$B$14Task 101 Contin$C$14Task 200 Contin$D$14Task 3 00 Contin$E$14Task 400 Contin$F$14Task 500 Contin$B$15Task 100 Contin$C$15Task 200 Contin$D$15Task 3 00 Contin$E$15Task 400 Contin$F$15
Background image
Image of page 7

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture