Week 10 Assignment 4

Only available on StudyMode
  • Topic: United States communities with African American majority populations, Macon, Georgia, U.S. Route 80
  • Pages : 3 (714 words )
  • Download(s) : 45
  • Published : December 9, 2012
Open Document
Text Preview
2. Solving the problem by using Solver of M S Excel, the answer report is given below:

| | | | |
Target Cell (Min)| | |
| Cell| Name| Original Value| Final Value|
| $B$22| Objective Function (Total cost) White water| 2822| 2822| | | | | |
Adjustable Cells| | |
| Cell| Name| Original Value| Final Value|
| $B$13| Kingsport White water| 35.00| 35.00|
| $C$13| Kingsport Los Canos| 0.00| 0.00|
| $D$13| Kingsport Duras| 0.00| 0.00|
| $B$14| Danville White water| 0.00| 0.00|
| $C$14| Danville Los Canos| 0.00| 0.00|
| $D$14| Danville Duras| 26.00| 26.00|
| $B$15| Macon White water| 0.00| 0.00|
| $C$15| Macon Los Canos| 0.00| 0.00|
| $D$15| Macon Duras| 42.00| 42.00|
| $B$16| Selma White water| 1.00| 1.00|
| $C$16| Selma Los Canos| 52.00| 52.00|
| $D$16| Selma Duras| 0.00| 0.00|
| $B$17| Columbus White water| 29.00| 29.00|
| $C$17| Columbus Los Canos| 0.00| 0.00|
| $D$17| Columbus Duras| 0.00| 0.00|
| $B$18| Allentown White water| 0.00| 0.00|
| $C$18| Allentown Los Canos| 28.00| 28.00|
| $D$18| Allentown Duras| 10.00| 10.00|

Constraints| | | | |
| Cell| Name| Cell Value| Formula| Status| Slack|
| $B$23| Constraint 1 White water| 35.00| $B$23=$D$23| Not Binding| 0| | $B$24| Constraint 2 White water| 26.00| $B$24=$D$24| Not Binding| 0| | $B$25| Constraint 3 White water| 42.00| $B$25=$D$25| Not Binding| 0| | $B$26| Constraint 4 White water| 53.00| $B$26=$D$26| Not Binding| 0| | $B$27| Constraint 5 White water| 29.00| $B$27=$D$27| Not Binding| 0| | $B$28| Constraint 6 White water| 38.00| $B$28=$D$28| Not Binding| 0| | $B$29| Constraint 7 White water| 65.00| $B$29=0| Binding| 0.00| | $B$14| Danville White water| 0.00| $B$14>=0| Binding| 0.00| | $C$14| Danville Los Canos| 0.00| $C$14>=0| Binding| 0.00| | $D$14|...
tracking img