Copy of HW3-26%2c27%2c28

Copy of HW3-26%2c27%2c28 - 133.33 1.0000E+030 Sheet1 Page 2...

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

View Full Document Right Arrow Icon
Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$13 Rye= 333.33 0.00 3 1.0000E+030 5 $B$14 Bourbon= 166.67 0.00 4 1.0000E+030 10 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$8 Bourbon limit Usage 166.67 0 250 1.0000E+030 83.33 $F$10 Capacity (gals) Usage 500 3.333 500 250 100 $F$9 Blend ratio Usage 0 -0.333 0 500 250 $F$6 Demand (gals) Usage 500 0 400 100 1.0000E+030 $F$7 Blend Usage 133.33
Background image of page 1

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

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

Unformatted text preview: 133.33 1.0000E+030 Sheet1 Page 2 Homework #3-26,27,28 Whiskeys: Rye Bourbon Profit per whiskey: 3.00 4.00 Constraints Available Usage Left over Demand (gals) 1 1 400 500 100 Blend 0.6-0.4 133.33-133.33 Bourbon limit 1 250 166.67 83.33 Blend ratio 1-2 Capacity (gals) 1 1 500 500 Production: Rye= 333.33 gals. Bourbon= 166.67 gals. Profit= 1,666.67...
View Full Document

This note was uploaded on 01/31/2012 for the course BAD 305 taught by Professor Null during the Spring '12 term at GWU.

Page1 / 2

Copy of HW3-26%2c27%2c28 - 133.33 1.0000E+030 Sheet1 Page 2...

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

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