Google Sheet WBS Template 42_43 - Project WBS with Budget Allocation Example.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Get Access to our Complete Collection of 43 Editable Google Sheet WBS Templates here.
2
3
4	A Work Breakdown Structure is a tool used in project management showing a breakdown of a project into smaller, more manageable components. The primary objective is shown at the top, with the smaller components broken down below. The project manager first defines the key objectives of the project, then identifies the tasks below each objective. A Work Breakdown Structure will look like a flowchart when completed, with each element of the project shown in detail in a box connected to the central project at the top. A well-structured Work Breakdown Structure helps the company with resource allocation, budgeting, scheduling, risk management, and quality control. Create your own WBS using template below.
5
6	Work Breakdown Structure
7	Task	Task Lead	Priority	Resources	Start	End	Progress	Budget	Risk	Est. Hours	Actual Hours	Notes
8	1	Name		Inadequate	1/1/2019	2/3/2019	25%	$ 600.00	HIGH RISK	32.50	17.00
9	1.1	Name	HIGH	Borderline	1/1/2019	2/3/2019	50%	$ 600.00	MEDIUM RISK	32.50	17.00
10	1.1.1		HIGH	Sufficient	1/1/2019	2/1/2019	25%	$ 100.00	HIGH RISK	15.50	10.00
11	1.1.2		MEDIUM	Borderline	1/2/2019	2/2/2019	75%	$ 200.00	MEDIUM RISK	12.00	5.00
12	1.1.3		LOW	Inadequate	1/3/2019	2/3/2019	On Hold	$ 300.00	LOW RISK	5.00	2.00
13	1.1.4
14	1.1.5
15	1.2
16	1.2.1
17	1.2.2
18	1.2.3
19	1.2.4
20	1.2.5
21	1.3
22	1.3.1
23	1.3.2
24	1.3.3
25	1.3.4
26	1.3.5
27	2	Name		Inadequate	1/1/2019	2/3/2019	25%	$ 600.00	HIGH RISK	32.50	17.00
28	2.1	Name	HIGH	Borderline	1/1/2019	2/3/2019	50%	$ 600.00	MEDIUM RISK	32.50	17.00
29	2.1.1		HIGH	Sufficient	1/1/2019	2/1/2019	25%	$ 100.00	HIGH RISK	15.50	10.00
30	2.1.2		MEDIUM	Borderline	1/2/2019	2/2/2019	75%	$ 200.00	MEDIUM RISK	12.00	5.00
31	2.1.3		LOW	Inadequate	1/3/2019	2/3/2019	On Hold	$ 300.00	LOW RISK	5.00	2.00
32	2.1.4
33	2.1.5
34	2.2
35	2.2.1
36	2.2.2
37	2.2.3
38	2.2.4
39	2.2.5
40	2.3
41	2.3.1
42	2.3.2
43	2.3.3
44	2.3.4
45	2.3.5
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