Fig8-10 v2 soln

Fig8-10 v2 soln - Not Binding 23.3 $E$10 Youngstown to Tower 39.800 $E$10<=$F$10 Not Binding 0.2 Location Analysis Page 2 Coordinates X Y

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

View Full Document Right Arrow Icon
Microsoft Excel 11.0 Answer Report Worksheet: [Fig8-10.xls]Location Analysis Report Created: 10/15/2008 8:24:02 PM Target Cell (Min) Cell Name Original Value Final Value $E$11 Total to Tower 86.328 81.761 Adjustable Cells Cell Name Original Value Final Value $C$6 Tower X 21.50 12.20 $D$6 Tower Y 23.00 21.00 Constraints Cell Name Cell Value Formula Status Slack $E$7 Cleveland to Tower 25.057 $E$7<=$F$7 Not Binding 14.94 $E$8 Akron to Tower 0.200 $E$8<=$F$8 Not Binding 39.8 $E$9 Canton to Tower 16.704 $E$9<=$F$9
Background image of page 1

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

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

Unformatted text preview: Not Binding 23.3 $E$10 Youngstown to Tower 39.800 $E$10<=$F$10 Not Binding 0.2 Location Analysis Page 2 Coordinates X Y Distance Maximum Tower 12.20 21.00 to Tower Allowed Cleveland 5 45 25.057 40 Akron 12 21 0.200 40 Canton 17 5 16.704 40 Youngstown 52 21 39.800 40 Total 81.761 Rappaport Communications Minimize: E11 By changing: C6:D6 Subject to: E7:E10<=F7:F10 A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17...
View Full Document

This note was uploaded on 04/19/2011 for the course CBA 0060 taught by Professor Barrymitnick during the Spring '09 term at Pittsburgh.

Page1 / 2

Fig8-10 v2 soln - Not Binding 23.3 $E$10 Youngstown to Tower 39.800 $E$10<=$F$10 Not Binding 0.2 Location Analysis Page 2 Coordinates X Y

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