Scribd
Upload
1K views10 pages

Excel GANTT Chart

This document contains a Gantt chart and budget plan for a 48-week project. The Gantt chart outlines the work breakdown structure (WBS), tasks, owners, start and end dates, duration, resources needed, and timeline. The budget plan assigns labor rates and costs to each task based on the information in the Gantt chart. It provides weekly estimates for labor costs, expenses, and total budget based on the project schedule.

Uploaded by

alan toomey
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
1K views10 pages

Excel GANTT Chart

This document contains a Gantt chart and budget plan for a 48-week project. The Gantt chart outlines the work breakdown structure (WBS), tasks, owners, start and end dates, duration, resources needed, and timeline. The budget plan assigns labor rates and costs to each task based on the information in the Gantt chart. It provides weekly estimates for labor costs, expenses, and total budget based on the project schedule.

Uploaded by

alan toomey
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
  • Project Schedule - Gantt Chart: Displays the project schedule using a Gantt chart to manage tasks over a 48-week window.
  • Project Budget Spend Plan: Outlines the project budget spend plan with a detailed table and graph comparing planned versus actual spending across project weeks.
  • Planned Project Staffing Profile: Presents planned staffing versus actual labor hours using tables and graphs to track resource allocation.

Project Schedule - Gantt Chart (48-Week Window)

Version 4.0
WBS

Tasks

Month-1

Yellow cells = cells for data entry.


Owner

1
1.1
1.1.1
1.1.2
1.1.3
1.1.4
1.1.5
1.1.6
1.1.7
1.2
1.2.1

Plan Start

Plan Finish

Project Name
Project planning & prep
3-May-05
1-Aug-05
Supervison & coord
Sue
3-May-05
1-Aug-05
Develop plan
Sue
4-May-05
28-May-05
Develop budget
Bill
24-May-05
3-Jun-05
Schedule kickoff mtg.
Nan
17-May-05 17-May-05
Conduct kickoff mtg.
Jim
7-Jun-05
7-Jun-05
Monthly Meetings
(special - inserted "1" each)
Quarterly Mtgs.
(special - inserted "1" each)
Requirements Management
Conduct requirements analysis
24-May-05
13-Jul-05
Develop interview forms Bob
24-May-05 28-May-05
Conduct interviews
Sue
28-May-05
25-Jun-05
Write prelim. requirements Nan
14-Jun-05
2-Jul-05
Conduct walk-thru
Sue
6-Jul-05
7-Jul-05
Update requirements doc. Nan
8-Jul-05
13-Jul-05
1.2.2 Establish requirements baseline
15-Jul-05
3-Aug-05
Publish draft req. doc.
Nan
15-Jul-05
15-Jul-05
Conduct req. review mtg. Sue
19-Jul-05
20-Jul-05
Incorporate comments
Nan
26-Jul-05
30-Jul-05
Send document for signatures
Sue
2-Aug-05
3-Aug-05
Establish formal baseline Rog
3-Aug-05
3-Aug-05
Next Major WBS Element
16-Mar-05 29-Mar-05
Task
16-Mar-05 17-Mar-05
Task
17-Mar-05 20-Mar-05
Task
18-Mar-05 23-Mar-05
Task
19-Mar-05 26-Mar-05
Task
20-Mar-05 29-Mar-05
Next Major WBS Element
Task
Task
Task
Task
Task
Next Major WBS Element
Task
Task
Task
Task
Task
Next Major WBS Element
Task
Task
Task
Task
Task

148111116.xls.ms_office

Days

FTEs

Hrs.

5/3

5/10

5/17

5/24

Month-2
5/31

6/7

1886
65
19
9
1
1
6
2

0.40
0.30
0.20
0.20
8.00
4.00
4.00

208
46
14
2
64
192
64

5
21
15
2
4

2.00
4.00
1.00
8.00
2.00

80
672
120
128
64

1
2
5
2
1

1.00
8.00
2.00
1.00
0.10

8
128
80
16
1

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
0
0
0
0

0
0
0
0
0
Note: Calendar week dates begin on Mondays.

5/28/2013

6/14

6/21

Month-3
6/28

7/5

7/12

7/19

7/26

Month-4
8/2

8/9

8/16

8/23

8/30

Project Schedule - Gantt Chart (48-Week Window)

h-4

Month-5
8/30

9/6

9/13

9/20

Month-6
9/27

10/4 10/11 10/18 10/25 11/1

148111116.xls.ms_office

Month-7

Month-8

11/8 11/15 11/22 11/29 12/6 12/13 12/20 12/27

5/28/2013

Month-9
1/3

1/10

1/17

Month-10
1/24

1/31

2/7

2/14

2/21

Month-11
2/28

3/7

3/14

3/21

3/28

Project Budget Spend Plan

WBS
1
1.1
1.1.1
1.1.2
1.1.3
1.1.4
1.1.5
1.1.6

Tasks

Owner

Project Name
Project planning & prep
0 Supervison & coord
0 Develop plan
0 Develop budget
0 Schedule kickoff mtg.
0 Conduct kickoff mtg.
0 Monthly Meetings
0
1.2 Requirements Management
1.2.1 Conduct requirements analysis
0 Develop interview forms
0 Conduct interviews
0 Write prelim. requirements
0 Conduct walk-thru
0 Update requirements doc.
1.2.2 Establish requirements baseline
0 Publish draft req. doc.
0 Conduct req. review mtg.
0 Incorporate comments
0 Send document for signatures
0 Establish formal baseline
Next Major WBS Element
0 Task
0 Task
0 Task
0
0 Task
Task
Task
Task
Task
Next Major WBS Element
Task
Task
Task
Task
Task
Next Major WBS Element
Task
Task
Task
Task
Task

Labor Rate Days

FTEs

Hrs.

0
0.4
0.3
0.2
0.2
8
4
4
0
0
2
4
1
8
2
0
1
8
2
1
0.1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

1886
0
208
46
14
2
64
192
64
0
0
80
672
120
128
64
0
8
128
80
16
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

ONLY INPUT

Sue
Sue
Bill
Nan
Jim

$35.00
$35.00
$35.00
$35.00
$35.00
$30.00

0
65
19
9
1
1
6
2
0
0
5
21
15
2
4
0
1
2
5
2
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

5/3 5/10 5/17 5/24 5/31 6/7 6/14 6/21 6/28 7/5 7/12 7/19 7/26

8/2

8/9

8/16

8/23

8/30

9/6

9/13

Do not input data into these cells -- these feed from the Gantt chart
560 560 560 560 560 560 560 560 560 560
560
420 420
0
0
0
0
0
0
0
0
0
0
280 224
0
0
0
0
0
0
0
0
56
0
0
0
0
0
0
0
0
0
0
0
0
0 2,240 0
0
0
0
0
0
0
0
0
0
0
960
0
0
0
960
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
0
0
0
0
0 2,400 0
0
0
0
0
0
0
0
0
0
960 4,800 4,800 4,800 4,800 0
0
0
0
0
0
0
0
0 1,200 1,200 1,200 0
0
0
0
0
0
0
0
0
0
0 3,840 0
0
0
0
0
0
0
0
0
0
960 960
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
240
0
0
0
0
0
0
0
0
0
0
0 3,840
0
0
0
0
0
0
0
0
0
0
0
2,400
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
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
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
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
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
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
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
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
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
0
0
0
480
24
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
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
0
0

0
0
0
0
0
960
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
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
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
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
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
0
0
0
0
0
0
0

0
0
0
0
0
960
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
0
0
0
0
0

Weekly Labor Cost

896 980 #### #### #### #### #### #### #### #### #### #### 2,960

504

960

960

Weekly Expense Estimate:

100 100 100 100 100 100 100 100 100 100 100 100

100

100

100

100

100

100

100

Weekly Budget Estimate:

996 #### #### #### #### #### #### #### #### #### #### #### 3,060

604

100

1,060

100

100

100

1,060

5/3 5/10 5/17 5/24 5/31 6/7 6/14 6/21 6/28 7/5 7/12 7/19 7/26

8/2

8/9

8/16

8/23

8/30

9/6

9/13

$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00
$30.00

Repeated for ease of graphic->

560
336
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
0
0
0
0
0
0
0
0
0

560
420
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
0
0
0
0
0
0
0
0
0

100

Budget Spend Plan - Generated from Gantt Chart #### 2,176 3,312 8,032 #### #### #### #### #### #### #### #### 53,396 54,000 54,100 55,160 55,260 55,360 55,460 56,520
Cumulative Actuals - Manual Entry

#### #### #### #### #### #### #### #### #### #### #### ####

Project Budget Spend Plan vs. Actuals


148111116.xls.ms_office

5/28/2013 - 12:06 AM

Project Budget Spend Plan

Project Budget Spend Plan vs. Actuals


70,000

Cumulative Project Budget/Spending $

60,000

50,000

40,000

30,000
Budget Spend Plan - Generated from Gantt Chart

20,000

Cumulative Actuals - Manual Entry

10,000

Project Weeks

148111116.xls.ms_office

5/28/2013 - 12:06 AM

Project Budget Spend Plan

9/13

9/20

9/27

10/4 10/11 10/18 10/25 11/1

11/8 11/15 11/22 11/29 12/6 12/13 12/20 12/27

0
0
0
0
0
960
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
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
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
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
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
0
0
0
0
0
0
0

0
0
0
0
0
960
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
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
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
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
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
0
0
0
0
0
0
0

0
0
0
0
0
960
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
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
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
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
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
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
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
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
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
0
0
0
0
0
0
0
0
0

960

960

960

100

100

100

100

101

102

103

104

105

106

107

108

109

1,060

100

100

100

1,061

102

103

104

1,065

106

107

108

109

9/13

9/20

9/27

10/4 10/11 10/18 10/25 11/1

1/10

1/17

1/24

1/31

2/7

2/14

2/21

2/28

3/7

3/14

3/21

3/28

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

$7,488
$1,642
$518
$58
$2,304
$5,952
$64
$0
$0
$2,480
$20,832
$3,720
$3,968
$1,984
$0
$248
$3,968
$2,480
$496
$25
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$56,340

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

$5,125

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

$61,465

1/3

1/10

1/17

1/24

1/31

2/7

2/14

2/21

2/28

3/7

3/14

3/21

3/28 #######

11/8 11/15 11/22 11/29 12/6 12/13 12/20 12/27

56,520 56,620 56,720 56,820 57,881 57,983 58,086 58,190 59,255 59,361 59,468 59,576 59,685 59,795 59,906 60,018 60,131 60,245 60,360 60,476 60,593 60,711 60,830 60,950 61,071 61,193 61,316 61,440 61,565

148111116.xls.ms_office

Task
Totals

1/3

5/28/2013 - 12:06 AM

Project Budget Spend Plan

148111116.xls.ms_office

5/28/2013 - 12:06 AM

Planned Project Staffing Profile vs. Actual Labor Hours

WBS

Tasks

Owner

Days

1 Project Name
1.1 Project planning & prep
1.1.1
Supervison & coord Sue
1.1.2
Develop plan
Sue
1.1.3
Develop budget
Bill
1.1.4
Schedule kickoff mtg.Nan
1.1.5
Conduct kickoff mtg.Jim

0
65
19
9
1
1
6
2
0
0
5
21
15
2
4
0
1
2
5
2
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

FTEs

Hrs.

0
0.4
0.3
0.2
0.2
8
4
4
0
0
2
4
1
8
2
0
1
8
2
1
0.1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

1886
0
208
46
14
2
64
192
64
0
0
80
672
120
128
64
0
8
128
80
16
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

8/2

8/9

8/16

8/23

8/30

9/6

9/13

9/20

Do not input data into these cells -- these feed from the Gantt chart
16
0
0
0
0
0
0
0
0
0
160
40
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

16
0
0
0
0
0
0
0
0
0
0
40
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

16
0
0
0
0
0
0
0
0
0
0
0
128
32
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

16
0
0
0
0
32
0
0
0
0
0
0
0
32
0
8
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

16
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
128
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

16
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
80
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
0
0
0
0
0
0
0
0
0
0
0
16
1
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
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
0
0

0
0
0
0
0
32
32
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
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
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
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
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
0
0
0
0
0
0

0
0
0
0
0
32
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
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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

148 182 240 248 216

56

176

88

144

96

17

64

32

5/3 5/10 5/17 5/24 5/31 6/7 6/14 6/21 6/28 7/5 7/12 7/19 7/26

8/2

8/9

8/16

8/23

8/30

9/6

9/13

9/20

Labor Hours per Week

26

28

30 148 182 240 248 216 56 176 88 144

17

64

32

Actual Staff Hours

47

109

94

Conduct requirements analysis


Develop interview forms
Conduct interviews
Write prelim. requirements
Conduct walk-thru
Update requirements doc.
Establish requirements baseline
Publish draft req. doc.
1.2.2
Conduct req. review mtg.
Incorporate comments
Send document for signatures
Establish formal baseline
Next Major WBS Element
Task
Task
Task
Task
Task
Next Major WBS Element
Task
Task
Task
Task
Task
Next Major WBS Element
Task
Task
Task
Task
Task
Next Major WBS Element
Task
Task
Task
Task
Task
1.2
1.2.1

Weekly Labor Hours

148111116.xls.ms_office

5/3 5/10 5/17 5/24 5/31 6/7 6/14 6/21 6/28 7/5 7/12 7/19 7/26

16
10
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
0
0
0
0
0
0
0
0
0

16
12
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
0
0
0
0
0
0
0
0
0

16
12
0
2
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
0
0
0
0
0
0
0

26

28

30

16
12
8
0
0
0
0
0
0
80
32
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

31

16
0
6
0
0
0
0
0
0
0
160
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

31

16
0
0
0
64
0
0
0
0
0
160
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

31

16
0
0
0
0
32
0
0
0
0
160
40
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

31

5/28/2013 - 12:06 AM

31

31

31

31

31

96

148111116.xls.ms_office

Weeks

5/28/2013 - 12:06 AM
3/21/2006

3/7/2006

2/21/2006

2/7/2006

1/24/2006

200

1/10/2006

12/27/2005

12/13/2005

11/29/2005

11/15/2005

11/1/2005

10/18/2005

10/4/2005

9/20/2005

9/6/2005

8/23/2005

8/9/2005

7/26/2005

7/12/2005

6/28/2005

6/14/2005

5/31/2005

5/17/2005

5/3/2005

Labor Hours (all skills)

Planned Project Staffing Profile vs. Actual Labor Hours

300

Weekly Staffing Plan - Labor Hours vs. Actuals

250

Labor Hours per Week

Actual Staff Hours

150

100

50

Planned Project Staffing Profile vs. Actual Labor Hours

9/20

9/27

10/4 10/11 10/18 10/25 11/1

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
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
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
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
0
0

0
0
0
0
0
32
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
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
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
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
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
0
0
0
0
0
0
0

0
0
0
0
0
32
32
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
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
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
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
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
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
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
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
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
0
0
0
0
0
0
0
0

32

64

9/20

9/27

10/4 10/11 10/18 10/25 11/1

32

148111116.xls.ms_office

11/8 11/15 11/22 11/29 12/6 12/13 12/20 12/27

1/3

1/10

1/17

1/24

1/31

2/7

2/14

2/21

2/28

3/7

3/14

3/21

3/28

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

1/3

1/10

1/17

1/24

1/31

2/7

2/14

2/21

2/28

3/7

3/14

3/21

3/28

11/8 11/15 11/22 11/29 12/6 12/13 12/20 12/27

64

5/28/2013 - 12:06 AM

Planned Project Staffing Profile vs. Actual Labor Hours

148111116.xls.ms_office

5/28/2013 - 12:06 AM

You might also like