BigState - MicrosoftExcel12.0AnswerReport Worksheet:...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [BigState.xlsx]Sheet1 Report Created: 11/18/2010 2:20:21 AM Target Cell (Max) Cell Name Original Value Final Value $B$50 Net Income -24973000 28800000 Adjustable Cells Cell Name Original Value Final Value $B$4 Number of Big State residents 1 3000 $B$5 Number of X State residents 1 3400 $B$6 Number of Y State residents 1 2600 $B$7 Number of Z State residents 1 1000 Constraints Cell Name Cell Value Formula Status Slack $B$40 Total Freshmen accepted 10000 $B$40<=10000 Binding 0 $B$39 Average GPA, all freshmen 2.62 $B$39>=2.6 Not Binding 0.02 $B$50 Net Income 28800000 $B$50>=0.25*$B$43 Not Binding 50000 $B$4 Number of Big State residents 3000 $B$4>=3000 Binding 0 $B$4 Number of Big State residents 3000 $B$4<=4000 Not Binding 1000 $B$5 Number of X State residents 3400 $B$5>=1000 Not Binding 2400 $B$6 Number of Y State residents 2600 $B$6>=1000 Not Binding 1600 $B$7 Number of Z State residents 1000 $B$7>=1000 Binding 0 $B$4 Number of Big State residents
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

BigState - MicrosoftExcel12.0AnswerReport Worksheet:...

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

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