Copy of MSChapter4_Ex4.1

Copy of MSChapter4_Ex4.1 - Usage 0.0 33.5 21.22 11.51 $G$10...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Copy of MSChapter4_Ex4.1.xlsx]Sheet1 Report Created: 2/22/2010 8:53:01 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $A$14 X1 = 22.39 0.00 140 31.74 377.86 $B$14 X2 = 16.79 0.00 205 120.23 73 $C$14 X3 = 16.79 0.00 190 1.00E+030 73 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$7 Usage 610.0 16.0 610 1.00E+030 610 $G$8 Usage -28.0 0.0 0 1.00E+030 27.98 $G$9
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
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Usage 0.0 33.5 21.22 11.51 $G$10 Usage 0.0 48.5 20.89 28.15 Sheet1 Page 2 A Product Mix Example Products: X1 X2 X3 Profit per box: 140 205 190 Resources Resources: Usage Constraints Available 10 15 8 610.0 <= 610 1-3-28.0 <=-0.6 0.4 0.4 0.0 <=-1 1 0.0 <= Production: X1 = X2 = X3 = Profit = 22.39 16.79 16.79 9765.60 maximize Z = 140 x 1 + 205 x Sheet1 Page 3 Left over 0.0 28.0 0.0 0.0 x 2 + 190 x 3...
View Full Document

Page1 / 3

Copy of MSChapter4_Ex4.1 - Usage 0.0 33.5 21.22 11.51 $G$10...

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

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