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

You've reached the end of your free preview.

Want to read all 8 pages?

• Winter '11
• JABER