BIT Problem Number 24

BIT Problem Number 24 - MicrosoftExcel12.0AnswerReport

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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 Objective Allowable Allowable Cell Name Value Cost
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/01/2011 for the course BIT 2406 at Virginia Tech.

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 Right Arrow Icon
Ask a homework question - tutors are online