Show me how to post my homework

Question

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

due on Sat, 2012-04-28 16: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 (585 words)

# xxxxxx xxxxxx x

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxx xxxx xxxxxx Report | |||||

xxxxxxxxxx [Book1]Sheet1 | |||||

xxxxxx Created: xxxxxxxxxx 0:11:05 | |||||

Target xxxx xxxxx | |||||

Cell | Name | Original xxxxx | xxxxx Value | ||

xxxxx | xxxx | x | 60 | ||

Adjustable xxxxx | |||||

xxxx | xxxx | xxxxxxxx Value | Final Value | ||

xxxx | xxxxxxxxx xxxx | 0 | x | ||

$F$3 | Pittsburgh Flow | 0 | 0 | ||

$F$4 | Cincinnati Flow | 0 | x | ||

xxxx | xxxxxxx xxxx | x | 0 | ||

xxxx | Cincinnati Flow | 0 | x | ||

xxxx | xxxxxxx xxxx | 0 | x | ||

$F$8 | xxxxxxx xxxx | x | 0 | ||

$F$9 | Chicago xxxx | x | 0 | ||

$F$10 | xxxxxxx xxxx | x | 0 | ||

xxxxx | Memphis xxxx | 0 | 0 | ||

$F$12 | Dallas Flow | x | 0 | ||

xxxxx | Memphis Flow | 0 | x | ||

xxxxx | xxxxxx xxxx | 0 | 0 | ||

$F$15 | xxxxxx xxxx | x | x | ||

xxxxx | Chicago xxxx | 0 | x | ||

$F$17 | xxxxxxx xxxx | x | 60 | ||

xxxxxxxxxxx | |||||

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

xxxx | Baltimore Flow | x | $I$2=0 | xxx Binding | 0 |

$I$3 | Pittsburgh xxxx | 0 | $I$3=0 | Not xxxxxxx | 0 |

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

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

xxxx | Cincinnati Flow | 0 | xxxxxx | Not xxxxxxx | x |

$I$7 | Atlanta Flow | x | $I$7=0 | xxx xxxxxxx | 0 |

xxxx | xxxxxxx xxxx | 0 | xxxxxx | xxx |

- - - 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 (122 words)

# xxxxx Express

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxx | ||||||

xxxx | xxxx | xxxx | To | Capacity xx xxxx | ||

x | xxxxxx | x | xxxxxxxxx | x 30 | x | Boston |

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

x | Boston | x | Cincinnati | x 35 | x | xxxxxxxxx |

2 | xxxxxxxxx | x | Atlanta | * xx | x | Cincinnati |

x | Baltimore | 4 | xxxxxxxxxx | * x | x | Atlanta |

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

x | xxxxxxxxx | 6 | Chicago | * xx | x | Memphis |

4 | xxxxxxxxxx | 6 | Chicago | x xx | x | Dallas |

x | xxxxxxxxxx | x | xxxxxxx | * 5 | ||

x | Atlanta | 7 | xxxxxxx | x 25 | ||

5 | Atlanta | 8 | Dallas | x 10 | ||

6 | Chicago | x | xxxxxxx | x xx | ||

6 | Chicago | x | xxxxxx | x xx | ||

7 | xxxxxxx | x | xxxxxx | * 30 | ||

7 | xxxxxxx | x | xxxxxxx | * xx |

# xxxxxxx xxxx xxxxx

xxxxxxxProblem Data | Optimal xxxxxxxx |

x

2

6

4

3

30

xx

35

5

xx

5

15

10

15

xx

x

x

30

5

x

xx

25

x

7

x

25

30

xx

15

xx

x

xx

x

xx

30

# xxxxx xxxxxxx xxxxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Express | xxxxx xxxxxxx | ||||||||

1=Yes, xxxx | xxxx | From | Code | xx | xxxxxxxx in xxxx | xxxxxxxx in tons | Nodes | Net xxxxxxxxx Inflow-outflow | Supply x -1 Demand x x |

1 | 1 | xxxxxx | 2 | xxxxxxxxx | * 30 | x 30 | 1 | xx | xx |

x | x | Boston | 3 | Pitsburgh | x xx | xxx | x | 0 | 0 |

0 | x | Boston | 4 | xxxxxxxxxx | x xx | 0.0 | x | x | x |

x | x | Baltimore | 5 | Atlanta | x xx | x 10 | x | 0 | x |

x | 2 | Baltimore | x | Cincinnati | * 5 | 0.0 | x | 0 | 0 |

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

0 | 3 | xxxxxxxxx | x | xxxxxxx | x 20 | 0.0 | 7 | x | 0 |

x | 4 | Cincinnati | x | Chicago | * 15 | xxx | x | x | 1 |

x | 4 | xxxxxxxxxx | 7 | xxxxxxx | * 5 | xxx | |||

1 | 5 | xxxxxxx | x | Memphis | * 25 | x 25 | |||

0 | x | Atlanta | 8 | Dallas | * xx | 0.0 | |||

x | x | xxxxxxx | x | Memphis | * xx | x 20 | |||

x | 6 | xxxxxxx | 8 | Dallas | * xx | 0.0 | |||

x | 7 | xxxxxxx | 6 | Chicago | x xx | * xx | |||

1 | x | xxxxxxx | x | Dallas | x 30 | * 30 | |||

Maximum capacity xx tons from Boston xx Dallas | x xxx |

Buy this answer | Try it before you buy it |