Project Management with the Critical Path Method

	A	B	C	D	E	F	G	I	J
1	Project Management with the Critical Path Method
2
3	Instructions: The objective is to minimize the duration of a project of multiple tasks and sequence constraints. The calculation also finds the latest start of tasks subject to the minimum duration. Tasks on the critical path have no slack. This spreadsheet uses the OpenSolver Add-on. The Green cells denote user input, yellow are decision variable determined by the solver, and the red cell is the problem objective.
4
5	Project Duration		64
6	Sum of Slacks		229
7	Objective		6171	<< a weighted difference between project duration and sum of slacks
8
9				Earliest		Latest
10	Task Description	Task Code	Dur	Start	Finish	Start	Finish	Slack	Critical Path?
11	Installing the Construction Site	T01	2	0	2	0	2	0	Critical Path
12	Terracing	T02	16	2	18	2	18	0	Critical Path
13	Constructing Foundations	T03	9	18	27	18	27	0	Critical Path
14	Access Roads	T04	8	18	26	29	37	11
15	Basement	T05	10	27	37	27	37	0	Critical Path
16	Main Floor	T06	6	37	43	37	43	0	Critical Path
17	Chaning Rooms	T07	2	26	28	61	63	35
18	Electrifying Terraces	T08	2	43	45	59	61	16
19	Roof	T09	9	43	52	43	52	0	Critical Path
20	Stadium Lighting	T10	5	26	31	59	64	33
21	Installing Terraces	T11	3	43	46	58	61	15
22	Sealing Roof	T12	2	52	54	52	54	0	Critical Path
23	Finish Changing Rooms	T13	1	28	29	63	64	35
24	Constructing Ticket Office	T14	7	18	25	53	60	35
25	Secondary Access Roads	T15	4	26	30	60	64	34
26	Signalling	T16	3	46	49	61	64	15
27	Lawn and Accessories	T17	9	54	63	54	63	0	Critical Path
28	Handing Over	T18	1	63	64	63	64	0	Critical Path
29	Finish	Finish	0	64	64	64	64	0	Critical Path
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100