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:
Criteria
Excellent
Average
Poor
Points
8-10 points
6-7 points
1-5 points
Submission fully addresses questions listed in the problem. Answer is consistent and supported by Excel QM spreadsheets/results.
Response fully answers all parts listed in the question. Answer is consistent and supported by Excel QM spreadsheets as a separate document. All calculations are shown.
Response partially answers all parts listed in the question. Answer is consistent and supported by Excel QM spreadsheets as a separate document. Most calculations are shown.
Response partially answers few parts listed in the question. Answer is not consistent with supporting Excel QM spreadsheets. Most or all calculations not provided.
There must be a written response to each part of the question. This can be inside the corresponding Excel QM spreadsheet.
Each part of each question is fully answered and explained. All Excel QM or additional calculations are shown if they required.
Most questions are fully answered and explained. All Excel QM or additional calculations are shown if they required.
Few question are answered and explained. Few to no Excel QM or additional calculations are shown if they required.
Academic Integrity and Syntax:
Academic Integrity
Spelling and grammar
Work is original.
Adheres to all spelling and grammar rules
Work is original
Few grammar and spelling errors
All or portions of the work are not original
Follows few or does not follow grammar and spelling rules
Timely submission
Entire assignment successfully submitted through Turn-it-in on or before due date.
Most of the assignment submitted, on or before due date.
Part or entire assignment submitted within 3 days after the due date.
