{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Copy of C6p38-b

# Copy of C6p38-b - 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: [C6p38.xlsx]Sheet1 Report Created: 10/12/2010 9:04:42 PM Target Cell (Min) Cell Name Original Value Final Value \$B\$24 total costs = \$0.00 \$15,600,000.00 Adjustable Cells Cell Name Original Value Final Value \$B\$3 ohio indiana 0 140000 \$C\$3 ohio georgia 0 0 \$B\$4 pennsylvania indiana 0 0 \$C\$4 pennsylvania georgia 0 140000 \$B\$5 new york indiana 0 70000 \$C\$5 new york georgia 0 70000 \$B\$11 indiana virginia 0 0 \$C\$11 indiana kentucky 0 210000 \$D\$11 indiana louisiana 0 0 \$B\$12 georgia virginia 0 90000 \$C\$12 georgia kentucky 0 0 \$D\$12 georgia louisiana 0 120000 Constraints Cell Name Cell Value Formula Status Slack \$D\$3 ohio shipped 140000 \$D\$3=\$F\$3 Not Binding 0 \$D\$4 pennsylvania shipped 140000 \$D\$4=\$F\$4 Not Binding 0 \$D\$5 new york shipped 140000 \$D\$5=\$F\$5 Not Binding 0 \$A\$20 transshipment constraints: 0 \$A\$20=\$C\$20 Not Binding 0 \$A\$21 transshipment constraints: 0 \$A\$21=\$C\$21 Not Binding 0 \$B\$13 shipped virginia 90000 \$B\$13>=\$B\$15 Binding 0 \$C\$13 shipped kentucky 210000 \$C\$13>=\$C\$15 Not Binding 130000 \$D\$13 shipped louisiana 120000 \$D\$13>=\$D\$15 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: [C6p38.xlsx]Sheet1 Report Created: 10/12/2010 9:04:42 PM
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 3

Copy of C6p38-b - 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