{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

BIT Problem Number 24

# BIT Problem Number 24 - MicrosoftExcel12.0AnswerReport...

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

Microsoft Excel 12.0 Answer Report Worksheet: [BIT Problem Number 24.xlsx]Sheet1 Report Created: 9/24/2010 10:14:37 AM Target Cell (Min) Cell Name Original Value Final Value \$B\$13 Total Miles <= 0 14600 Adjustable Cells Cell Name Original Value Final Value \$B\$5 North Central 0 700 \$C\$5 North West 0 0 \$D\$5 North South 0 0 \$B\$6 South Central 0 0 \$C\$6 South West 0 0 \$D\$6 South South 0 300 \$B\$7 East Central 0 0 \$C\$7 East West 0 0 \$D\$7 East South 0 900 \$B\$8 West  Central 0 0 \$C\$8 West  West 0 600 \$D\$8 West  South 0 0 \$B\$9 Central Central 0 500 \$C\$9 Central West 0 0 \$D\$9 Central South 0 0 Constraints Cell Name Cell Value Formula Status Slack \$B\$10 Number of Students Central 1200 \$B\$10<=\$B\$12 Binding 0 \$D\$10 Number of Students South 1200 \$D\$10<=\$D\$12 Binding 0 \$C\$10 Number of Students West 600 \$C\$10<=\$C\$12 Not Binding 600 \$E\$5 North Tansported 700 \$E\$5=\$G\$5 Not Binding 0 \$E\$6 South Tansported 300 \$E\$6=\$G\$6 Not Binding 0 \$E\$7 East Tansported 900 \$E\$7=\$G\$7 Not Binding 0 \$E\$8 West  Tansported 600 \$E\$8=\$G\$8 Not Binding 0 \$E\$9 Central Tansported 500 \$E\$9=\$G\$9 Not Binding 0

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

View Full Document
Microsoft Excel 12.0 Sensitivity Report Worksheet: [BIT Problem Number 24.xlsx]Sheet1 Report Created: 9/24/2010 10:14:37 AM Adjustable Cells Final Reduced
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 6

BIT Problem Number 24 - MicrosoftExcel12.0AnswerReport...

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

View Full Document
Ask a homework question - tutors are online