# Week 10 Assignment 4

Topics: United States communities with African American majority populations, Macon, Georgia, U.S. Route 80 Pages: 3 (714 words) Published: December 9, 2012
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| | | | | |
| 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|...