5) RFP Schedule Calculator.xlsx

	B	C	D	E	F	G	H
1
2	Procurement Schedule
3
4							Key:
5		Project:	Insert Name Here				Only update the green cells
6		When do we expect the SOW to be completed?	Wed, 2/15/2023
7
8	1) Planning Phase (Develop SOW + RFP)		Finish Date	Duration (days)	Duration (weeks)	Duration (months)	Comments
9	1	Planning Meeting with Procurement / Supply Chain	Tue, 2/7/2023	30	4	1.0
10	2	Compile the Statement of Work (SOW)	Wed, 2/8/2023	1	0	0.0	assumes ~1mo to compile the SOW
11	3	Full SOW is ready for release	Wed, 2/15/2023	7	1	0.2	assumes ~1 week compilation before advertise
12			Total:	38	5.4	1.2
13
14	2) Selection Phase (Solicit & Evaluate Proposals)		Finish Date	Duration (days)	Duration (weeks)	Duration (months)	Comments
15	1	RFP(s) released to vendors	Wed, 2/22/2023	7	1	0.2
16	2	Pre-Proposal Information Session(s) / Site Walk	Wed, 3/1/2023	7	1	0.2	schedule for roughly 1 wk after RFP release
17	3	Vendor proposals are due	Fri, 3/24/2023	24	3	0.8	assumes ~4-5wk for proposal response
18	4	Evaluate vendor written proposals	Fri, 4/7/2023	14	2	0.5	can go as fast as evaluators are available
19	5	Lead time for Interviews and/or Product Demos	Mon, 4/17/2023	10	1	0.3	give 1-2wk notice for SL vendors to attend Int/Demos
20	6	Interviews and/or Product Demonstrations	Mon, 4/24/2023	7	1	0.2	assumes 1wk window for Int/Demos
21	7	Final Selection Results	Wed, 4/26/2023	2	0	0.1	should be quick to assemble!
22	8	Internal approvals & executive briefings	Wed, 5/10/2023	14	2	0.5	depends on internal approvals process
23			Total:	85	12.1	2.8
24
25	3) Execute Contract		Finish Date	Duration (days)	Duration (weeks)	Duration (months)	Comments
26	1	Notification & Preparation	Wed, 5/17/2023	7	1	0.2	1 wk to orient, train, and prep
27	2	Contracting Kickoff Meeting(s)	Wed, 5/24/2023	7	1	0.2	1wk window for Kickoff Meeting
28	3	Contracting Activities - detailed planning & documentation	Fri, 6/23/2023	30.5	4	1.0	highly variable…
29	4	Contracting Summary Meeting	Fri, 6/30/2023	7	1	0.2	1wk window
30	5	Contract Signature	Mon, 7/3/2023	2	0	0.1	work on contract in parallel with clarification!!!
31	6	Notice to Proceed	Wed, 7/5/2023	2	0	0.1	how quickly should vendors expect to mobilize?
32			Total:	55.5	7.9	1.8	driven by internal SME availability & # vendors
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