Задания для самостоятельной работы
Задание 1. Построить сетевой график, найти критический путь, ранние и поздние сроки завершения работ для расчетов использовать средства Excel.
1. 2.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
1 |
|
(1, 2) |
2 |
|
(1, 3) |
3 |
|
(1, 3) |
3 |
|
(1, 4) |
5 |
|
(1, 4) |
4 |
|
(2, 5) |
4 |
|
(2, 5) |
3 |
|
(4, 5) |
2 |
|
(3, 6) |
2 |
|
(3, 6) |
1 |
|
(4, 6) |
5 |
|
(5, 8) |
3 |
|
(6, 7) |
2 |
|
(6, 7) |
2 |
|
(5, 7) |
6 |
|
(8, 9) |
4 |
|
(7, 8) |
2 |
|
(7, 10) |
5 |
|
(7, 9) |
1 |
|
(9, 10) |
3 |
|
(8, 10) |
1 |
|
|
|
|
(9, 10) |
1 |
3. 4.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
3 |
|
(1, 2) |
2 |
|
(1, 3) |
2 |
|
(1, 3) |
4 |
|
(2, 4) |
5 |
|
(2, 4) |
3 |
|
(3, 5) |
2 |
|
(4, 5) |
5 |
|
(4, 6) |
2 |
|
(3, 5) |
2 |
|
(5, 7) |
4 |
|
(4, 7) |
6 |
|
(6, 7) |
3 |
|
(5, 6) |
1 |
|
(5, 8) |
5 |
|
(6, 8) |
2 |
|
(7, 8) |
2 |
|
(7, 8) |
4 |
|
(6, 9) |
5 |
|
(8, 9) |
3 |
|
(8, 10) |
1 |
|
|
|
|
(9, 10) |
1 |
|
|
|
5. 6.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
2 |
|
(1, 2) |
2 |
|
(1, 3) |
4 |
|
(1, 3) |
3 |
|
(3, 4) |
3 |
|
(1, 4) |
4 |
|
(2, 5) |
5 |
|
(2, 5) |
3 |
|
(4, 5) |
2 |
|
(3, 5) |
2 |
|
(3, 6) |
6 |
|
(4, 6) |
5 |
|
(5, 7) |
1 |
|
(5, 7) |
2 |
|
(6, 8) |
2 |
|
(6, 7) |
6 |
|
(7, 9) |
4 |
|
(7, 8) |
1 |
|
(8, 9) |
3 |
|
(7, 9) |
2 |
|
|
|
|
(8, 9) |
1 |
7. 8.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
3 |
|
(1, 2) |
2 |
|
(1, 3) |
2 |
|
(1, 3) |
5 |
|
(2, 4) |
5 |
|
(2, 4) |
2 |
|
(4, 5) |
2 |
|
(3, 5) |
6 |
|
(5, 6) |
2 |
|
(4, 6) |
5 |
|
(3, 6) |
4 |
|
(5, 6) |
6 |
|
(4, 7) |
3 |
|
(5, 7) |
7 |
|
(6, 8) |
5 |
|
(7, 8) |
3 |
|
(7, 8) |
2 |
|
(6, 8) |
1 |
|
(6, 9) |
5 |
|
(8, 9) |
3 |
|
(8, 9) |
1 |
|
|
|
9. 10.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
3 |
|
(1, 2) |
2 |
|
(2, 3) |
2 |
|
(1, 3) |
4 |
|
(2, 4) |
5 |
|
(3, 4) |
3 |
|
(3, 5) |
2 |
|
(2, 4) |
5 |
|
(3, 6) |
2 |
|
(4, 5) |
2 |
|
(5, 7) |
4 |
|
(4, 6) |
6 |
|
(4, 7) |
3 |
|
(6, 7) |
1 |
|
(7, 8) |
5 |
|
(7, 9) |
2 |
|
(8, 9) |
2 |
|
(5, 8) |
4 |
|
(6, 9) |
5 |
|
(8, 9) |
3 |
|
(9, 10) |
1 |
|
(9, 10) |
2 |
11. 12.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
2 |
|
(1, 2) |
1 |
|
(1, 3) |
5 |
|
(1, 3) |
3 |
|
(2, 5) |
7 |
|
(2, 4) |
5 |
|
(3, 4) |
1 |
|
(3, 4) |
4 |
|
(4, 5) |
3 |
|
(4, 5) |
2 |
|
(3, 6) |
4 |
|
(4, 6) |
1 |
|
(5, 8) |
3 |
|
(5, 7) |
3 |
|
(6, 7) |
5 |
|
(6, 7) |
2 |
|
(8, 9) |
2 |
|
(7, 8) |
4 |
|
(7, 9) |
5 |
|
(7, 9) |
5 |
|
(9, 10) |
1 |
|
(8, 10) |
3 |
|
|
|
|
(9, 10) |
4 |
13. 14.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
2 |
|
(1, 2) |
3 |
|
(1, 3) |
3 |
|
(1, 3) |
4 |
|
(1, 4) |
2 |
|
(1, 4) |
5 |
|
(2, 5) |
1 |
|
(2, 5) |
2 |
|
(4, 5) |
5 |
|
(3, 6) |
7 |
|
(3, 6) |
6 |
|
(4, 6) |
1 |
|
(5, 8) |
7 |
|
(6, 7) |
3 |
|
(6, 7) |
3 |
|
(5, 7) |
5 |
|
(8, 9) |
1 |
|
(7, 8) |
3 |
|
(7, 10) |
3 |
|
(7, 9) |
2 |
|
(9, 10) |
2 |
|
(8, 10) |
4 |
|
|
|
|
(9, 10) |
5 |
15. 16.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
2 |
|
(1, 2) |
4 |
|
(1, 3) |
5 |
|
(1, 3) |
2 |
|
(2, 4) |
7 |
|
(2, 4) |
5 |
|
(3, 5) |
1 |
|
(4, 5) |
3 |
|
(4, 6) |
3 |
|
(3, 5) |
2 |
|
(5, 7) |
4 |
|
(4, 7) |
6 |
|
(6, 7) |
3 |
|
(5, 6) |
1 |
|
(5, 8) |
5 |
|
(6, 8) |
2 |
|
(7, 8) |
2 |
|
(7, 8) |
4 |
|
(6, 9) |
5 |
|
(8, 9) |
3 |
|
(8, 10) |
1 |
|
|
|
|
(9, 10) |
1 |
|
|
|
17. 18.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
4 |
|
(1, 2) |
3 |
|
(1, 3) |
2 |
|
(1, 3) |
4 |
|
(3, 4) |
5 |
|
(1, 4) |
5 |
|
(2, 5) |
3 |
|
(2, 5) |
2 |
|
(4, 5) |
2 |
|
(3, 5) |
7 |
|
(3, 6) |
6 |
|
(4, 6) |
1 |
|
(5, 7) |
1 |
|
(5, 7) |
3 |
|
(6, 8) |
2 |
|
(6, 7) |
5 |
|
(7, 9) |
4 |
|
(7, 8) |
3 |
|
(8, 9) |
3 |
|
(7, 9) |
2 |
|
|
|
|
(8, 9) |
4 |
19. 20.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
2 |
|
(1, 2) |
3 |
|
(1, 3) |
5 |
|
(1, 3) |
2 |
|
(2, 4) |
7 |
|
(2, 4) |
5 |
|
(4, 5) |
1 |
|
(3, 5) |
1 |
|
(5, 6) |
3 |
|
(4, 6) |
4 |
|
(3, 6) |
4 |
|
(5, 6) |
3 |
|
(4, 7) |
3 |
|
(5, 7) |
7 |
|
(6, 8) |
5 |
|
(7, 8) |
2 |
|
(7, 8) |
2 |
|
(6, 8) |
1 |
|
(6, 9) |
5 |
|
(8, 9) |
3 |
|
(8, 9) |
1 |
|
|
|
21. 22.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
2 |
|
(1, 2) |
4 |
|
(2, 3) |
5 |
|
(1, 3) |
2 |
|
(2, 4) |
7 |
|
(3, 4) |
5 |
|
(3, 5) |
1 |
|
(2, 4) |
3 |
|
(3, 6) |
3 |
|
(4, 5) |
2 |
|
(5, 7) |
4 |
|
(4, 6) |
6 |
|
(4, 7) |
3 |
|
(6, 7) |
1 |
|
(7, 8) |
5 |
|
(7, 9) |
2 |
|
(8, 9) |
2 |
|
(5, 8) |
4 |
|
(6, 9) |
5 |
|
(8, 9) |
3 |
|
(9, 10) |
1 |
|
(9, 10) |
2 |
23. 24.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
4 |
|
(1, 2) |
3 |
|
(1, 3) |
1 |
|
(1, 3) |
2 |
|
(2, 5) |
2 |
|
(2, 4) |
5 |
|
(3, 4) |
4 |
|
(3, 4) |
6 |
|
(4, 5) |
3 |
|
(4, 5) |
4 |
|
(3, 6) |
4 |
|
(4, 6) |
3 |
|
(5, 8) |
3 |
|
(5, 7) |
7 |
|
(6, 7) |
5 |
|
(6, 7) |
2 |
|
(8, 9) |
2 |
|
(7, 8) |
1 |
|
(7, 9) |
5 |
|
(7, 9) |
3 |
|
(9, 10) |
1 |
|
(8, 10) |
2 |
|
|
|
|
(9, 10) |
1 |
25. 26.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
3 |
|
(1, 2) |
2 |
|
(1, 3) |
2 |
|
(1, 3) |
3 |
|
(1, 4) |
5 |
|
(1, 4) |
4 |
|
(2, 5) |
6 |
|
(2, 5) |
7 |
|
(4, 5) |
4 |
|
(3, 6) |
1 |
|
(3, 6) |
3 |
|
(4, 6) |
3 |
|
(5, 8) |
7 |
|
(6, 7) |
5 |
|
(6, 7) |
2 |
|
(5, 7) |
3 |
|
(8, 9) |
1 |
|
(7, 8) |
2 |
|
(7, 10) |
3 |
|
(7, 9) |
1 |
|
(9, 10) |
2 |
|
(8, 10) |
1 |
|
|
|
|
(9, 10) |
1 |
27. 28.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
4 |
|
(1, 2) |
4 |
|
(1, 3) |
1 |
|
(1, 3) |
3 |
|
(2, 4) |
2 |
|
(2, 4) |
2 |
|
(3, 5) |
4 |
|
(4, 5) |
5 |
|
(4, 6) |
3 |
|
(3, 5) |
2 |
|
(5, 7) |
4 |
|
(4, 7) |
6 |
|
(6, 7) |
3 |
|
(5, 6) |
1 |
|
(5, 8) |
5 |
|
(6, 8) |
2 |
|
(7, 8) |
2 |
|
(7, 8) |
4 |
|
(6, 9) |
5 |
|
(8, 9) |
3 |
|
(8, 10) |
1 |
|
|
|
|
(9, 10) |
1 |
|
|
|
29. 30.
|
(i, j) |
tij |
|
(i, j) |
tij |
|
(1, 2) |
2 |
|
(1, 2) |
4 |
|
(1, 3) |
4 |
|
(1, 3) |
3 |
|
(3, 4) |
6 |
|
(1, 4) |
5 |
|
(2, 5) |
2 |
|
(2, 5) |
2 |
|
(4, 5) |
5 |
|
(3, 5) |
1 |
|
(3, 6) |
4 |
|
(4, 6) |
5 |
|
(5, 7) |
3 |
|
(5, 7) |
2 |
|
(6, 8) |
2 |
|
(6, 7) |
6 |
|
(7, 9) |
4 |
|
(7, 8) |
1 |
|
(8, 9) |
3 |
|
(7, 9) |
2 |
|
|
|
|
(8, 9) |
1 |