# ba 356 quantitive hw

I’m stuck on a Business question and need an explanation.

The problems for this week are 9.1 and 9.2. Both problems must in Excel QM and submitted through Assignment.

9.1) Given the pipeline fluid flows indicated below, determine the maximum flow from Node 1 to Node 5.

 From Node To Node Fluid Flow 1 1 2 300 2 2 1 0 3 1 3 0 4 3 1 150 5 1 4 200 6 4 1 200 7 1 5 100 8 5 1 100 9 2 4 200 10 4 2 200 11 3 4 250 12 4 3 300 13 3 5 3300 14 5 3 250 15 4 5 100 16 5 4 0

9.2) The Pointy-haired boss has five projects to assign and decides to go against all convention and assign them to individuals rather than project teams. He has the Elbonians estimate the labor cost in dollars of each possible assignment and that information is summarized in the table. Use Solver to determine which of these assignments is correct.

 Labor Costs for each possible assignment Project Dilbert Wally Alice Asok Dogbert 1 22 21 25 26 30 2 25 19 22 27 28 3 29 25 22 34 20 4 20 23 27 26 24 5 24 48 19 24 27

See rubric for problems below: