WBS Sample & Template (DOWNLOAD).xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY
1	WP ID (X)	WP ID (X.X)	WP Name	Task	Responsible Party	Output	Effort	Check	7/Jan/19	14/Jan/19	21/Jan/19	28/Jan/19	4/Feb/19	11/Feb/19	18/Feb/19	25/Feb/19	4/Mar/19	11/Mar/19	18/Mar/19	25/Mar/19	1/Apr/19	8/Apr/19	15/Apr/19	22/Apr/19	29/Apr/19	6/May/19	13/May/19	20/May/19	27/May/19	3/Jun/19	10/Jun/19	17/Jun/19	24/Jun/19	1/Jul/19	8/Jul/19	15/Jul/19	22/Jul/19	29/Jul/19	5/Aug/19	12/Aug/19	19/Aug/19	26/Aug/19	2/Sep/19	9/Sep/19	16/Sep/19	23/Sep/19	30/Sep/19	7/Oct/19	14/Oct/19	21/Oct/19	28/Oct/19
2	WP ID (X)	WP ID (X.X)	WP Name	Task	Responsible Party	Output	Effort	Check	Wk1	Wk2	Wk3	Wk4	Wk5	Wk6	Wk7	Wk8	Wk9	Wk10	Wk11	Wk12	Wk13	Wk14	Wk15	Wk16	Wk17	Wk18	Wk19	Wk20	Wk21	Wk22	Wk23	Wk24	Wk25	Wk26	Wk27	Wk28	Wk29	Wk30	Wk31	Wk32	Wk33	Wk34	Wk35	Wk36	Wk37	Wk38	Wk39	Wk40	Wk41	Wk42	Wk43
3
4	1	1.1	Install test environment	Base installation (O/S, applications)	Marcia	S03 - Test environment available S05 - Production deployment available		0
5			Milestone	Production environment available			MS 1
6	1	1.2	Install acceptance environment	Install DB server	Alice	D07 - Server installation documentation S06 - Production deployment configured	1	1																							1
7
8	2	2.1	System and requirements analysis	Analyze as-is environment	Greg	D09 - Solution definition documentation	2	0
9	2	2.2	F2F preparation session (optional)	Complete detailed design	Greg	D12 - Detailed technical design	2	0
10	2	2.3	F2F validation workshop(s)	Review and validate to-be configuration	Bobby	D12 - Detailed technical design	1	0
11			Milestone	Deliver D12 technical design			MS 2
12			Milestone	Submit Dxx mapping file			MS 3
13
14	3	3.1	Data profiling	Complete data analysis	Marcia		2	1			1
15	3	3.2	Data cleansing	Identify which data needs to be cleaned	Jan		2	1					1
16			Milestone	Complete data cleansing			MS 4
17									Critical Path
18	4	4.1	Prepare for data migration	Set up environments	Bobby		2	0
19			Milestone	Complete UAT 2	Marcia		MS 5
20	4	4.2	Troubleshoot issues	Fix issues	Marcia		3	3																			1	1	1
21	4	4.3	Execute data migration	Run complete data migration on test environment	Jan		10	10																					3	5	2
22			Milestone	Complete maturity review 3			MS 6
23																																				Critical Path
24	5	5.1	Planning	Define and plan production cutover plan	Greg		1	1																											1
25	5	5.2	Acceptance	Configure production for acceptance test	Peter		3	3																											3
26	5	5.3	Data migration	Run data migration	Bobby		3	3																											1	1	1
27	5	5.4	Acceptance	Address UAT issues	Cindy		3	3																																3
28			Milestone	Complete UAT			MS 7
29																																								Critical Path
30	6	6.1	Prepare for production cutover	Final test and go-live planning	Greg		5	5																															3	2
31	6	6.2	Production cutover - pilot migration	Complete pilot migration	Greg		3	3																																		1	1	1
32			Milestone	Complete pilot migration			MS 8
33	6	6.3	Production pilot go-live	Support pilot project	Greg		1	1																																			1
34			Milestone	Complete production cutover			MS 9
35	6	6.4	Production cutover - final migration	Support production cutover	Peter		1	1																																							1
36
37	7	7.1	Post go live support	Handover to IT / support IT	Alice		1	1																																								1
38	7	7.2	Project closure	Prepare and conduct close meeting	Cindy	D24 - Project closure report	3	3																																										3
39							49		0	0	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	4	5	3	0	0	0	5	1	1	0	3	5	0	1	2	1	0	0	1	1	0	3	0
40
41
42									7/Jan/19	14/Jan/19	21/Jan/19	28/Jan/19	4/Feb/19	11/Feb/19	18/Feb/19	25/Feb/19	4/Mar/19	11/Mar/19	18/Mar/19	25/Mar/19	1/Apr/19	8/Apr/19	15/Apr/19	22/Apr/19	29/Apr/19	6/May/19	13/May/19	20/May/19	27/May/19	3/Jun/19	10/Jun/19	17/Jun/19	24/Jun/19	1/Jul/19	8/Jul/19	15/Jul/19	22/Jul/19	29/Jul/19	5/Aug/19	12/Aug/19	19/Aug/19	26/Aug/19	2/Sep/19	9/Sep/19	16/Sep/19	23/Sep/19	30/Sep/19	7/Oct/19	14/Oct/19	21/Oct/19	28/Oct/19
43									Wk2	Wk3	Wk4	Wk5	Wk6	Wk7	Wk8	Wk9	Wk10	Wk11	Wk12	Wk13	Wk14	Wk15	Wk16	Wk17	Wk18	Wk19	Wk20	Wk21	Wk22	Wk23	Wk24	Wk25	Wk26	Wk27	Wk28	Wk29	Wk30	Wk31	Wk32	Wk33	Wk34	Wk35	Wk36	Wk37	Wk38	Wk39	Wk40	Wk40	Wk40	Wk40	Wk40
44								Greg	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	3	2	0	1	2	1	0	0	0	0	0	0	0
45								Peter	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0
46								Bobby	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0
47								Marcia	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
48								Jan	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	5	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
49								Cindy	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	0	0	0	0	0	0	0	3	0
50								Alice	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0
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