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
Microsoft Excel 14.4 Sensitivity Report

#### You've reached the end of your free preview.

Want to read all 6 pages?

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