Lec. 6 Problems

Lec. 6 Problems - Allowable Allowable Cell Name Value Cost...

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

View Full Document Right Arrow Icon
Decision Variables X Y Available hrs #units of X we produce 66.67 Machine I 1 1 200 #units of Y we produce 133.33 Machine II 4 1 400 Objective Function Unit Profit Maximize profit 1333.33 X 10 Y 5 Constraints Machine I 200 <= 200 Machine II 400 <= 400
Background image of page 1

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

View Full DocumentRight Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [Lec. 6 Problems.xlsx]Sheet2 Report Created: 9/11/2008 11:32:39 AM Target Cell (Max) Cell Name Original Value Final Value $B$9 Maximize profit 792 792 Adjustable Cells Cell Name Original Value Final Value $B$4 #units of X we produce 0 0 $B$5 #units of Y we produce 4 4 $B$6 #units of Z we produce 48 48 Constraints Cell Name Cell Value Formula Status Slack $B$14 Machine I 160 $B$14<=$D$14 Binding 0 $B$15 Machine II 232 $B$15<=$D$15 Not Binding 48 $B$16 Machine III 200 $B$16<=$D$16 Binding 0 $B$17 #units of Y we produce 4 $B$17<=$D$17 Not Binding 12 $B$4 #units of X we produce 0 $B$4>=0 Binding 0 $B$5 #units of Y we produce 4 $B$5>=0 Not Binding 4 $B$6 #units of Z we produce 48 $B$6>=0 Not Binding 48
Background image of page 2
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Lec. 6 Problems.xlsx]Sheet2 Report Created: 9/11/2008 11:33:07 AM Adjustable Cells Final Reduced Objective
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 #units of X we produce-10.2 12 10.2 1.00E+030 $B$5 #units of Y we produce 4 18 2 7.29 $B$6 #units of Z we produce 48 15 21 1.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$14 Machine I 160 4.2 160 15 10 $B$15 Machine II 232 280 1.00E+030 48 $B$16 Machine III 200 0.6 200 13.33 34.29 $B$17 #units of Y we produce 4 16 1.00E+030 12 Question 6 Decision Variables X Y Z #units of X we produce Machine I 5 4 3 #units of Y we produce 4 Machine II 4 10 4 #units of Z we produce 48 Machine III 2 2 4 Objective Function Unit Profit Maximize profit 792 X 12 Y 18 Z 15 Constraints Next Month Machine I 160 &lt;= 160 &lt;----------This Constraint is Bindin Machine II 232 &lt;= 280 &lt;----------This Constraint is Non-B Machine III 200 &lt;= 200 #units of Y we produce 4 &lt;= 16 Available hrs 160 288 200 ing Binding...
View Full Document

Page1 / 5

Lec. 6 Problems - Allowable Allowable Cell Name Value Cost...

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

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