{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

JB_Q3-14

# JB_Q3-14 - Microsoft Excel 9.0 Answer Report...

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

Microsoft Excel 9.0 Answer Report Worksheet: [JB_Q3-14.xls]Sheet1 Report Created: 2010/9/30 23:05:38 Target Cell (Min) Cell Name Original Value Final Value \$B\$4 Objective 0 7 Adjustable Cells Cell Name Original Value Final Value \$B\$6 y1 0 0 \$B\$7 y1' 0 3 \$B\$8 y2 0 8 \$B\$9 y2' 0 0 Constraints Cell Name Cell Value Formula Status Slack \$B\$11 Con1 11 \$B\$11=\$C\$11 Binding 0 \$B\$12 Con2 13 \$B\$12>=\$C\$12Not Binding 3 \$B\$13 Con3 3 \$B\$13<=\$C\$13Binding 0 \$B\$14 Non-neg1 0 \$B\$14>=\$C\$14Binding 0 \$B\$15 Non-neg2 3 \$B\$15>=\$C\$15Not Binding 3 \$B\$16 Non-neg3 8 \$B\$16>=\$C\$16Not Binding 8 \$B\$17 Non-neg4 0 \$B\$17>=\$C\$17Binding 0

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

View Full Document
Microsoft Excel 9.0 Sensitivity Report Worksheet: [JB_Q3-14.xls]Sheet1 Report Created: 2010/9/30 23:05:38 Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$6 y1 0 0 3 1.00E+030 0 \$B\$7 y1' 3 0 -3 5 0 \$B\$8 y2 8 0 2 1.00E+030 0 \$B\$9 y2' 0 0 -2 1.00E+030 0 Constraints Final Shadow Constraint Allowable Allowable

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.

{[ snackBarMessage ]}