Get documents about "EXCEL Gantt_v4
Document Sample
Project Schedule - Gantt Chart (48-Week Window)
Version 4.0 Yellow cells = cells for data entry. Month-1 Month-2 Month-3 Month-4
WBS Tasks Owner Plan Start Plan Finish Days FTEs Hrs. 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
1 Project Name 1886
1.1 Project planning & prep 3-May-05 1-Aug-05
1.1.1 Supervison & coord Sue 3-May-05 1-Aug-05 65 0.40 208
1.1.2 Develop plan Sue 4-May-05 28-May-05 19 0.30 46
1.1.3 Develop budget Bill 24-May-05 3-Jun-05 9 0.20 14
1.1.4 Schedule kickoff mtg. Nan 17-May-05 17-May-05 1 0.20 2
1.1.5 Conduct kickoff mtg. Jim 7-Jun-05 7-Jun-05 1 8.00 64
1.1.6 Monthly Meetings (special - inserted "1" each) 6 4.00 192
1.1.7 Quarterly Mtgs. (special - inserted "1" each) 2 4.00 64
1.2 Requirements Management
1.2.1 Conduct requirements analysis 24-May-05 13-Jul-05
Develop interview forms Bob 24-May-05 28-May-05 5 2.00 80
Conduct interviews Sue 28-May-05 25-Jun-05 21 4.00 672
Write prelim. requirements Nan 14-Jun-05 2-Jul-05 15 1.00 120
Conduct walk-thru Sue 6-Jul-05 7-Jul-05 2 8.00 128
Update requirements doc. Nan 8-Jul-05 13-Jul-05 4 2.00 64
1.2.2 Establish requirements baseline 15-Jul-05 3-Aug-05
Publish draft req. doc. Nan 15-Jul-05 15-Jul-05 1 1.00 8
Conduct req. review mtg. Sue 19-Jul-05 20-Jul-05 2 8.00 128
Incorporate comments Nan 26-Jul-05 30-Jul-05 5 2.00 80
Sue
Send document for signatures 2-Aug-05 3-Aug-05 2 1.00 16
Establish formal baseline Rog 3-Aug-05 3-Aug-05 1 0.10 1
Next Major WBS Element 16-Mar-05 29-Mar-05
Task 16-Mar-05 17-Mar-05 0 0
Task 17-Mar-05 20-Mar-05 0 0
Task 18-Mar-05 23-Mar-05 0 0
Task 19-Mar-05 26-Mar-05 0 0
Task 20-Mar-05 29-Mar-05 0 0
Next Major WBS Element
Task 0 0
Task 0 0
Task 0 0
Task 0 0
Task 0 0
Next Major WBS Element
Task 0 0
Task 0 0
Task 0 0
Task 0 0
Task 0 0
Next Major WBS Element
Task 0 0
Task 0 0
Task 0 0
Task 0 0
Task 0 0
Note: Calendar week dates begin on Mondays.
9947fd2a-e695-4063-929f-b6342dd45f0b.xls 4/12/2011
Project Schedule - Gantt Chart (48-Week Window)
Month-5 Month-6 Month-7 Month-8 Month-9 Month-10 Month-11
9/6 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 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
9947fd2a-e695-4063-929f-b6342dd45f0b.xls 4/12/2011
Project Budget Spend Plan
WBS Tasks Owner Labor Rate Days FTEs Hrs. 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
1 Project Name ONLY INPUT 1886 Do not input data into these cells -- these feed from the Gantt chart
1.1 Project planning & prep 0 0 0
1.1.1 0 Supervison & coord Sue $35.00 65 0.4 208 560 560 560 560 560 560 560 560 560 560 560 560 560 0 0 0 0 0 0 0 0
1.1.2 0 Develop plan Sue $35.00 19 0.3 46 336 420 420 420 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1.1.3 0 Develop budget Bill $35.00 9 0.2 14 0 0 0 280 224 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1.1.4 0 Schedule kickoff mtg. Nan $35.00 1 0.2 2 0 0 56 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1.1.5 0 Conduct kickoff mtg. Jim $35.00 1 8 64 0 0 0 0 0 2,240 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1.1.6 0 Monthly Meetings $30.00 6 4 192 0 0 0 0 0 0 960 0 0 0 960 0 0 0 0 960 0 0 0 960 0
0 2 4 64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1.2 Requirements Management $30.00 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.2.1 Conduct requirements analysis $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 Develop interview forms $30.00 5 2 80 0 0 0 2,400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 Conduct interviews $30.00 21 4 672 0 0 0 960 4,800 4,800 4,800 4,800 0 0 0 0 0 0 0 0 0 0 0 0 0
0 Write prelim. requirements $30.00 15 1 120 0 0 0 0 0 0 1,200 1,200 1,200 0 0 0 0 0 0 0 0 0 0 0 0
0 Conduct walk-thru $30.00 2 8 128 0 0 0 0 0 0 0 0 0 3,840 0 0 0 0 0 0 0 0 0 0 0
0 Update requirements doc. $30.00 4 2 64 0 0 0 0 0 0 0 0 0 960 960 0 0 0 0 0 0 0 0 0 0
1.2.2 Establish requirements baseline $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 Publish draft req. doc. $30.00 1 1 8 0 0 0 0 0 0 0 0 0 0 240 0 0 0 0 0 0 0 0 0 0
0 Conduct req. review mtg. $30.00 2 8 128 0 0 0 0 0 0 0 0 0 0 0 3,840 0 0 0 0 0 0 0 0 0
0 Incorporate comments $30.00 5 2 80 0 0 0 0 0 0 0 0 0 0 0 0 2,400 0 0 0 0 0 0 0 0
0 Send document for signatures $30.00 2 1 16 0 0 0 0 0 0 0 0 0 0 0 0 0 480 0 0 0 0 0 0 0
0 Establish formal baseline $30.00 1 0.1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 24 0 0 0 0 0 0 0
Next Major WBS Element $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Next Major WBS Element $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Next Major WBS Element $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task $30.00 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 0 960 0 0 0 960 0
Weekly Expense Estimate: 100 100 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 100
Repeated for ease of graphic-> 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
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 56,620
Cumulative Actuals - Manual Entry #### #### #### #### #### #### #### #### #### #### #### ####
Project Budget Spend Plan vs. Actuals
9947fd2a-e695-4063-929f-b6342dd45f0b.xls 4/12/2011 - 5:06 AM
Project Budget Spend Plan
Project Budget Spend Plan vs. Actuals
70,000
60,000
Cumulative Project Budget/Spending $
50,000
40,000
30,000
Budget Spend Plan - Generated from Gantt Chart
20,000
Cumulative Actuals - Manual Entry
10,000
0
5/17/2005
5/31/2005
6/14/2005
6/28/2005
7/12/2005
7/26/2005
8/23/2005
9/20/2005
10/4/2005
11/1/2005
1/10/2006
1/24/2006
2/21/2006
3/21/2006
5/3/2005
8/9/2005
9/6/2005
2/7/2006
3/7/2006
10/18/2005
11/15/2005
11/29/2005
12/13/2005
12/27/2005
Project Weeks
9947fd2a-e695-4063-929f-b6342dd45f0b.xls 4/12/2011 - 5:06 AM
Project Budget Spend Plan
Task
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 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
Totals
0 0 0 0 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
0 0 0 0 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,642
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $518
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $58
0 0 0 0 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,304
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 $5,952
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $64
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 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,480
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $20,832
0 0 0 0 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,720
0 0 0 0 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,968
0 0 0 0 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,984
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $248
0 0 0 0 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,968
0 0 0 0 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,480
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $496
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $25
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0 0 0 0 0 0 0 0 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 960 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $56,340
100 100 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 $5,125
100 100 100 1,061 102 103 104 1,065 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 $61,465
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 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 #######
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
9947fd2a-e695-4063-929f-b6342dd45f0b.xls 4/12/2011 - 5:06 AM
Project Budget Spend Plan
9947fd2a-e695-4063-929f-b6342dd45f0b.xls 4/12/2011 - 5:06 AM
Planned Project Staffing Profile vs. Actual Labor Hours
WBS Tasks Owner Days FTEs Hrs. 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 9/27
1 Project Name 1886 Do not input data into these cells -- these feed from the Gantt chart
1.1 Project planning & prep 0 0 0
1.1.1 Supervison & coord Sue 65 0.4 208 16 16 16 16 16 16 16 16 16 16 16 16 16 0 0 0 0 0 0 0 0 0
1.1.2 Develop plan Sue 19 0.3 46 10 12 12 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1.1.3 Develop budget Bill 9 0.2 14 0 0 0 8 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1.1.4 Nan
Schedule kickoff mtg. 1 0.2 2 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1.1.5 Conduct kickoff mtg.Jim 1 8 64 0 0 0 0 0 64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6 4 192 0 0 0 0 0 0 32 0 0 0 32 0 0 0 0 32 0 0 0 32 0 0
Conduct requirements analysis 2 4 64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 32 0 0 0 0 0 0
1.2 Develop interview forms 0 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.2.1 Conduct interviews 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Write prelim. requirements 5 2 80 0 0 0 80 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Conduct walk-thru 21 4 672 0 0 0 32 160 160 160 160 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Update requirements doc. 15 1 120 0 0 0 0 0 0 40 40 40 0 0 0 0 0 0 0 0 0 0 0 0 0
Establish requirements baseline 2 8 128 0 0 0 0 0 0 0 0 0 128 0 0 0 0 0 0 0 0 0 0 0 0
Publish draft req. doc. 4 2 64 0 0 0 0 0 0 0 0 0 32 32 0 0 0 0 0 0 0 0 0 0 0
1.2.2 Conduct req. review mtg. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Incorporate comments 1 1 8 0 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0
Send document for signatures 2 8 128 0 0 0 0 0 0 0 0 0 0 0 128 0 0 0 0 0 0 0 0 0 0
Establish formal baseline 5 2 80 0 0 0 0 0 0 0 0 0 0 0 0 80 0 0 0 0 0 0 0 0 0
Next Major WBS Element 2 1 16 0 0 0 0 0 0 0 0 0 0 0 0 0 16 0 0 0 0 0 0 0 0
Task 1 0.1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Next Major WBS Element 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Next Major WBS Element 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Next Major WBS Element 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Task 0 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 Hours 26 28 30 148 182 240 248 216 56 176 88 144 96 17 0 64 0 0 0 32 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 9/20 9/27
Labor Hours per Week 26 28 30 148 182 240 248 216 56 176 88 144 96 17 0 64 0 0 0 32 0 0
Actual Staff Hours 47 109 94 31 31 31 31 31 31 31 31 31
9947fd2a-e695-4063-929f-b6342dd45f0b.xls 4/12/2011 - 5:06 AM
Planned Project Staffing Profile vs. Actual Labor Hours
Weekly Staffing Plan - Labor Hours vs. Actuals
300
250
Labor Hours per Week
Labor Hours (all skills)
200
Actual Staff Hours
150
100
50
0
Weeks
9947fd2a-e695-4063-929f-b6342dd45f0b.xls 4/12/2011 - 5:06 AM
Planned Project Staffing Profile vs. Actual Labor Hours
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 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 32 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 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 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 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 64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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 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 32 0 0 0 64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9947fd2a-e695-4063-929f-b6342dd45f0b.xls 4/12/2011 - 5:06 AM
