GBS Test Question #4 - Microsoft Excel 14.4 Answer Report Worksheet[Workbook16]Sheet1 Report Created 10:13:28 AM Result Solver found a solution All

GBS Test Question #4 - Microsoft Excel 14.4 Answer Report...

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

Microsoft Excel 14.4 Answer Report Worksheet: [Workbook16]Sheet1 Report Created: 4/21/2015 10:13:28 AM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.524376 Seconds. Iterations: 8 Subproblems: 0 Solver Options Max Time Unlimited , Iterations Unlimited , Precision 1e-06, Use Automatic Scaling Max Subproblems Unlimited , Max Integer Sols Unlimited , Integer Tolerance 1%, Assum Objective Cell (Min) Cell Name Original Value Final Value $C$19 Objective Function (Min) M1 34.55 73,550.00 Variable Cells Cell Name Original Value Final Value Integer $C$16 M1 1.00 2000.00 Contin $D$16 M2 1.00 4000.00 Contin $E$16 M3 1.00 1400.00 Contin $F$16 XD 1.00 4000.00 Contin $G$16 XE 1.00 0.00 Contin $H$16 YA 1.00 2100.00 Contin Constraints Cell Name Cell Value Formula Status Slack $C$23 A Amount Used (LHS) 21,600.00 $C$23<=$E$23 Binding 0 $C$24 C Amount Used (LHS) 12,200.00 $C$24<=$E$24 Not Binding 2800 $C$25 B Amount Used (LHS) 18,000.00 $C$25<=$E$25 Binding 0 $C$26 D Amount Used (LHS) 6,000.00 $C$26=$E$26 Binding 0 $C$27 E Amount Used (LHS) 4,000.00 $C$27=$E$27 Binding 0 $C$28 E Amount Used (LHS) 3,500.00 $C$28=$E$28 Binding 0
Image of page 1
me NonNegative
Image of page 2
Microsoft Excel 14.4 Sensitivity Report
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 11 pages?

  • Fall '14
  • LHS, LHS)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes