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

• Homework Help
• 13
• 100% (1) 1 out of 1 people found this document helpful

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
hout Integer Constraints, Assume NonNegative
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.