Show me how to post my homework

Question

Submitted by willietanks on Tue, 2012-04-24 17:20

due on Sat, 2012-04-28 17:19

answered 2 time(s)

Hand shake with Coloratus: Complete

willietanks is willing to pay $10.00

# Linear programming with excel and math skills number 4

I have attached here the question that I need assistance with.

Attachments:

Answer

Answer rating (rated one time)

## Complete answer

body preview (0 words)

file1.xlsx preview (661 words)

# Answer xxxxxx x

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxMicrosoft xxxxx xxxx xxxxxx xxxxxx | |||||

Worksheet: xxxxxxxxxxxxx | |||||

Report Created: 26.4.2012. xxxxxxx | |||||

xxxxxx xxxx xxxxx | |||||

xxxx | Name | Original Value | Final Value | ||

$F$18 | Flow | x | xx | ||

Adjustable Cells | |||||

xxxx | Name | xxxxxxxx xxxxx | xxxxx xxxxx | ||

$F$2 | Baltimore Flow | 0 | 0 | ||

xxxx | xxxxxxxxxx Flow | 0 | 0 | ||

xxxx | Cincinnati Flow | x | 0 | ||

xxxx | Atlanta Flow | x | 0 | ||

xxxx | Cincinnati Flow | x | 0 | ||

xxxx | Atlanta Flow | 0 | x | ||

$F$8 | Chicago xxxx | 0 | 0 | ||

xxxx | Chicago xxxx | 0 | 0 | ||

xxxxx | Memphis xxxx | x | 0 | ||

$F$11 | xxxxxxx Flow | x | 0 | ||

xxxxx | xxxxxx xxxx | 0 | x | ||

xxxxx | xxxxxxx xxxx | x | 0 | ||

$F$14 | Dallas Flow | x | 0 | ||

xxxxx | Dallas Flow | 0 | 0 | ||

xxxxx | Chicago Flow | 0 | 0 | ||

$F$17 | xxxxxxx Flow | x | 60 | ||

xxxxxxxxxxx | |||||

xxxx | xxxx | Cell Value | Formula | Status | xxxxx |

xxxx | Baltimore xxxx | 0 | $I$2=0 | Not Binding | 0 |

xxxx | xxxxxxxxxx xxxx | x | xxxxxx | xxx xxxxxxx | x |

xxxx | xxxxxxxxxx xxxx | x | $I$4=0 | xxx Binding | 0 |

xxxx | xxxxxxx xxxx | 0 | $I$5=0 | Not xxxxxxx | 0 |

xxxx | Cincinnati xxxx | x | $I$6=0 | xxx xxxxxxx | x |

xxxx | xxxxxxx Flow | 0 | xxxxxx | xxx Binding | x |

$I$8 | Chicago Flow | 0 | $I$8=0 | xxx xxxxxxx | x |

$I$9 | xxxxxxx xxxx | 0 | $I$9=0 | Not Binding | x |

$F$2 | Baltimore xxxx | x | xxxx<xxxxx | Not Binding | xx |

$F$3 | xxxxxxxxxx xxxx | x | $F$3<=$E$3 | Not xxxxxxx | xx |

$F$4 | Cincinnati xxxx | x | xxxx<=$E$4 | Not Binding | 35 |

$F$5 | xxxxxxx Flow | x | $F$5<=$E$5 | Not xxxxxxx | 10 |

$F$6 | Cincinnati Flow | 0 | xxxx<xxxxx | Not - - - more text follows - - - |

Try it before you buy it |

Answer

Answer rating (rated one time)

## Answer file is attached. Feel free to contact on any query

body preview (0 words)

file1.xls preview (201 words)

# Union Express

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxx | ||||||

xxxx | xxxx | xxxx | xx | Capacity in xxxx | ||

1 | xxxxxx | 2 | Baltimore | x xx | 1 | Boston |

x | Boston | x | xxxxxxxxx | x 25 | 2 | Baltimore |

1 | Boston | 4 | Cincinnati | x 35 | 3 | Pitsburgh |

2 | Baltimore | 5 | Atlanta | * 10 | x | xxxxxxxxxx |

2 | xxxxxxxxx | 4 | Cincinnati | x x | x | xxxxxxx |

x | Pitsburgh | 5 | xxxxxxx | * 15 | 6 | xxxxxxx |

x | Pitsburgh | 6 | Chicago | x xx | 7 | Memphis |

x | xxxxxxxxxx | x | xxxxxxx | * xx | 8 | xxxxxx |

4 | xxxxxxxxxx | x | Memphis | x x | ||

5 | Atlanta | x | xxxxxxx | * xx | ||

5 | xxxxxxx | 8 | Dallas | * xx | ||

6 | Chicago | 7 | Memphis | * xx | ||

6 | xxxxxxx | 8 | Dallas | x xx | ||

x | xxxxxxx | 8 | Dallas | * 30 | ||

x | Memphis | x | xxxxxxx | * xx |

# network xxxx xxxxx

xxxxxxxxxxxxxxx Data | xxxxxxx xxxxxxxx |

x

2

x

4

x

xx

25

35

5

xx

5

xx

10

xx

xx

x

2

30

5

7

xx

25

x

x

5

25

xx

15

xx

20

6

xx

x

xx

30

# xxxxx Express solution

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxx | Union Express | ||||||||

xxxxxx 0=No | Code | From | Code | To | xxxxxxxx xx xxxx | Capacity in xxxx | xxxxx | Net xxxxxxxxx xxxxxxxxxxxxxx | xxxxxx = xx Demand x x |

1 | 1 | Boston | 2 | Baltimore | * 30 | * 30 | x | xx | -1 |

x | 1 | xxxxxx | 3 | xxxxxxxxx | x xx | 0.0 | x | 0 | x |

x | 1 | xxxxxx | x | Cincinnati | x 35 | 0.0 | 3 | 0 | x |

x | x | Baltimore | x | xxxxxxx | x xx | x 10 | 4 | 0 | 0 |

0 | 2 | Baltimore | 4 | xxxxxxxxxx | x 5 | 0.0 | 5 | 0 | x |

x | 3 | xxxxxxxxx | 5 | xxxxxxx | x 15 | 0.0 | x | x | 0 |

x | 3 | xxxxxxxxx | 6 | Chicago | * xx | 0.0 | 7 | x | x |

0 | 4 | Cincinnati | x | Chicago | * - - - more text follows - - - |

Buy this answer | Try it before you buy it |