Decision Science

# Decision Science - Microsoft Excel 12.0 Answer Report...

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

Microsoft Excel 12.0 Answer Report Worksheet: [Final Exam #9.xlsx]Sheet1 Report Created: 7/23/2009 12:14:10 PM Target Cell (Max) Cell Name Original Value Final Value \$D\$9 Obj. Function MAX 0 51406.25 Adjustable Cells Cell Name Original Value Final Value \$B\$7 DV Values C1 0 15.63 \$C\$7 DV Values S1 0 659.38 Constraints Cell Name Cell Value Formula Status Slack \$D\$12 Land LHS 675 \$D\$12<=\$F\$12 Binding 0 \$D\$13 Seed LHS 15000 \$D\$13<=\$F\$13 Binding 0 \$D\$14 Chemicals LHS 9901.56 \$D\$14<=\$F\$14 Not Binding 2098.44 \$D\$15 Fertilizer LHS 5438.28 \$D\$15<=\$F\$15 Not Binding 61.72 \$D\$16 Trucking LHS 1775 \$D\$16<=\$F\$16 Not Binding 1225 \$D\$17 Insurance LHS 3008.13 \$D\$17>=\$F\$17 Not Binding 8.13

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

View Full Document
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Final Exam #9.xlsx]Sheet1 Report Created: 7/23/2009 12:14:10 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$7 DV Values C1 15.63 0 125 20.34 50 \$C\$7 DV Values S1
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 11/22/2010 for the course BUSI 508 taught by Professor Thomas during the Summer '10 term at Columbia College.

### Page1 / 4

Decision Science - Microsoft Excel 12.0 Answer Report...

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

View Full Document
Ask a homework question - tutors are online