Homework 1 Excel .xlsx - Microsoft Excel 15.30 Answer Report Worksheet[Homework 1 Problem 1]Sheet1 Report Created 12:28:36 PM Result Solver found a

Homework 1 Excel .xlsx - Microsoft Excel 15.30 Answer...

This preview shows page 1 - 4 out of 13 pages.

Microsoft Excel 15.30 Answer ReportWorksheet: [Homework 1 Problem 1 .xlsx]Sheet1Report Created: 1/27/17 12:28:36 PMResult: Solver found a solution. All constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0.099618 Seconds.Iterations: 3 Subproblems: 0Solver OptionsMax Time Unlimited, Iterations Unlimited, Precision 1E-06Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Solve WithObjective Cell (Max)CellNameOriginal ValueFinal Value$B$18minimize cost x1a0482500Variable CellsCellNameOriginal ValueFinal ValueInteger$B$16x1a00 Contin$C$16x2a00 Contin$D$16x3a0740 Contin$E$16x4a00 Contin$F$16x1b01300 Contin$G$16 x2b00 Contin$H$16x3b00 Contin$I$16x4b00 Contin$J$16x1c00 Contin$K$16x2c00 Contin$L$16x3c00 Contin$M$16 x4c0670 ContinConstraintsCellNameCell ValueFormulaStatusSlack$N$21Supplier A 740 $N$21<=$P$21 Binding0$N$22Supplier B 1300 $N$22<=$P$22 Binding0$N$23Supplier C 670 $N$23<=$P$23 Binding0
Background image
hout Integer Constraints, Assume NonNegative
Background image
Microsoft Excel 15.30 Answer ReportWorksheet: [Homework 1 Problem 1 .xlsx]Sheet1Report Created: 1/27/17 12:33:37 PMResult: Solver found a solution. All constraints and optimality conditions are satisfied.
Background image
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture