Planes-08.xlsx - Microsoft Excel 15.0 Answer Report Worksheet[Haley.Hamilton-Planes-08]Solver Report Created 9:42:16 AM Result Solver found a solution

# Planes-08.xlsx - Microsoft Excel 15.0 Answer Report...

• Homework Help
• 9

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

Microsoft Excel 15.0 Answer ReportWorksheet: [Haley.Hamilton-Planes-08.xlsx]SolverReport Created: 4/1/2017 9:42:16 AMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0.016 Seconds.Iterations: 2 Subproblems: 0Solver OptionsMax Time 100 sec, Iterations 100, Precision 0.000001Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 5%, Solve Without Integer ConstObjective Cell (Max)CellNameOriginal ValueFinal Value\$F\$13Units Produced Total Profit\$48,421\$48,421Variable CellsCellNameOriginal ValueFinal ValueInteger\$B\$13Units Produced Small Planes1010 Integer\$C\$13Units Produced Large Planes1212 IntegerConstraintsCellNameCell ValueFormulaStatusSlack\$D\$9Materials Used6,000 \$D\$9<=\$F\$9Binding0\$D\$10Labor Hours Used1,500 \$D\$10<=\$F\$10 Binding0\$B\$13:\$C\$13=Integer
traints, Assume NonNegative
Microsoft Excel 15.0 Sensitivity ReportWorksheet: [Haley.Hamilton-Planes-08.xlsx]SolverReport Created: 4/1/2017 9:42:16 AMVariable CellsFinalReducedObjective