Lec. 6 Problems

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

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

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

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

View Full Document
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
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

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

View Full Document
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 <= 160 <----------This Constraint is Bindin Machine II 232 <= 280 <----------This Constraint is Non-B Machine III 200 <= 200 #units of Y we produce 4 <= 16 Available hrs 160 288 200 ing Binding...
View Full Document

## This note was uploaded on 09/30/2008 for the course BUAD 311 taught by Professor Vaitsos during the Spring '07 term at USC.

### 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
Ask a homework question - tutors are online