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

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture