quant quiz #2 midlik - Microsoft Excel 14.4 Answer Report Worksheet[Workbook12]Sheet1 Report Created 10:13:16 AM Result Solver found a solution All

quant quiz #2 midlik - Microsoft Excel 14.4 Answer Report...

This preview shows page 1 - 3 out of 6 pages.

Microsoft Excel 14.4 Answer Report Worksheet: [Workbook12]Sheet1 Report Created: 10/31/2014 10:13:16 AM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.657025 Seconds. Iterations: 7 Subproblems: 0 Solver Options Max Time Unlimited , Iterations Unlimited , Precision 1e-06 Max Subproblems Unlimited , Max Integer Sols Unlimited , Integer Tolerance 1%, Solve Without Integer Constraints , Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $G$14 Max Profit: Player 0 69400 Variable Cells Cell Name Original Value Final Value Integer $G$12 3M+4S+4T+3B <= 4700 Player 0 0 Contin $H$12 3M+4S+4T+3B <= 4700 Radio Tuner 0 380 Contin $I$12 3M+4S+4T+3B <= 4700 TV 0 0 Contin $J$12 3M+4S+4T+3B <= 4700 DVD Player 0 1060 Contin Constraints Cell Name Cell Value Formula Status Slack $F$17 LHS 4700 $F$17<=$H$17 Binding 0 $F$18 LHS 3940 $F$18<=$H$18 Not Binding 560 $F$19 LHS 2500 $F$19<=$H$19 Binding 0 $F$20 LHS 0 $F$20>=$H$20 Binding 0 $F$21 LHS 380 $F$21>=$H$21 Not Binding 380 $F$22 LHS 0 $F$22>=$H$22 Binding 0 $F$23 LHS 1060 $F$23>=$H$23 Not Binding 1060
Image of page 1
Microsoft Excel 14.4 Sensitivity Report
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 6 pages?

  • Fall '13
  • DVD, Blu-ray Disc, LHS

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture