CEE111 - Design Exs #1 - Simplified (With Answers)

CEE111 - Design Exs #1 - Simplified (With Answers) -...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel 14.0 Answer Report Worksheet: [Book3]Aluminum Report Created: 1/22/2012 1:34:12 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Solver Options Objective Cell (Min) Cell Name Original Value Final Value $E$4 Minimize 176.470875 176.470875 Variable Cells Cell Name Original Value Final Value Integer $C$3 Area Bar A 0.5 0.5 Contin $D$3 Area Bar B 5.30225 5.30225 Contin Constraints Cell Name Cell Value Formula Status Slack $E$8 Cost 176.470875 $E$8<=$G$8 Not Binding 823.529125 $E$9:$E$13 >= $G$9:$G$13
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Microsoft Excel 14.0 Sensitivity Report Worksheet: [Book3]Aluminum Report Created: 1/22/2012 1:34:12 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$3 Area Bar A 0.5 0 18.9 1.0000E+030 18.9 $D$3 Area Bar B 5.30225 0 31.5 1.0000E+030 31.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$8 Cost 176.470875 0 1000 1.0000E+030 823.529125 $E$9:$E$13 >= $G$9:$G$13
Background image of page 2
Microsoft Excel 14.0 Limits Report Worksheet: [Book3]Aluminum Report Created: 1/22/2012 1:34:12 PM Objective Cell Name Value $E$4 Minimize 176.470875 Variable Lower Objective Upper
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 12

CEE111 - Design Exs #1 - Simplified (With Answers) -...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online