BDM assignment #2.xlsx - Microsoft Excel 14.1 Answer Report Worksheet[BDM assignment#2]Assignment#2 Report Created 9:45:33 PM Result Solver found a

BDM assignment #2.xlsx - Microsoft Excel 14.1 Answer Report...

This preview shows page 1 - 2 out of 8 pages.

Microsoft Excel 14.1 Answer Report Worksheet: [BDM assignment #2.xlsx]Assignment #2 Report Created: 2014-10-29 9:45:33 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 7.598421 Seconds. Iterations: 18 Subproblems: 0 Solver Options Max Time 100 sec, Iterations 100, Precision 0.1, Use Automatic Scaling, Show Iteration Results Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 5%, Solve Without Integer C Objective Cell (Min) Cell Name Original Value Final Value $S$6 Totals 66250 66250 Variable Cells Cell Name Original Value Final Value Integer $C$5 Solution Chinon y1 5000 5000 Contin $D$5 Solution Chinon y2 5000 5000 Contin $E$5 Solution Chardonnay y1 5000 5000 Contin $F$5 Solution Chardonnayy2 5000 5000 Contin $G$5 Solution Cash1 6125 6125 Contin $H$5 Solution Cash2 0 0 Contin $I$5 Solution Marketing Chinon y1 1000 1000 Contin $J$5 Solution Marketing Chardonnay y1 625 625 Contin $K$5 Solution Marketing Chinon y2 63625 63625 Contin $L$5 Solution Marketing Chardonnay y2 500 500 Contin $M$5
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read all 8 pages?

  • Winter '11
  • JABER

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture