Week 10 Assignment 4

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