EXCEL Gantt v4

Document Sample
EXCEL Gantt v4 Powered By Docstoc
					Project Schedule - Gantt Chart (48-Week Window)
Version 4.0 WBS 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 Tasks Owner Yellow cells = cells for data entry. Plan Start Plan Finish Days FTEs Hrs. 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/3

Month-1
5/10 5/17 5/24 5/31 6/7

Month-2
6/14 6/21 6/28 7/5

Month-3
7/12 7/19 7/26 8/2 8/9

Month-4
8/16 8/23 8/30 9/6

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

5 21 15 2 4 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

2.00 4.00 1.00 8.00 2.00 1.00 8.00 2.00 1.00 0.10

80 672 120 128 64 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 Note: Calendar week dates begin on Mondays.

76387cad-b0fc-4cb0-8e95-68f0e83018c5.xls

8/12/2008

Project Schedule - Gantt Chart (48-Week Window) Month-5
9/6 9/13 9/20 9/27

Month-6
10/4 10/11 10/18 10/25 11/1

Month-7

Month-8
1/3

Month-9
1/10 1/17 1/24 1/31

Month-10
2/7 2/14 2/21 2/28 3/7

Month-11
3/14 3/21 3/28

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

76387cad-b0fc-4cb0-8e95-68f0e83018c5.xls

8/12/2008

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

Labor Rate Days
ONLY INPUT

FTEs 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

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

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

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

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

Sue Sue Bill Nan Jim

$35.00 $35.00 $35.00 $35.00 $35.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 $30.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

Weekly Labor Cost Weekly Expense Estimate: Weekly Budget Estimate: Repeated for ease of graphic->

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

504 100 604 8/2

0 100 100 8/9

960 100 1,060 8/16

0 100 100 8/23

0 100 100 8/30

0 100 100 9/6

960 100 1,060 9/13

0 100 100 9/20

996 #### #### #### #### #### #### #### #### #### #### #### 3,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

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
76387cad-b0fc-4cb0-8e95-68f0e83018c5.xls 8/12/2008 - 7:23 PM

Project Budget Spend Plan

Project Budget Spend Plan vs. Actuals
70,000

60,000

Cumulative Project Budget/Spending $

50,000

40,000

30,000

20,000

Budget Spend Plan - Generated from Gantt Chart Cumulative Actuals - Manual Entry

10,000

0

Project Weeks

76387cad-b0fc-4cb0-8e95-68f0e83018c5.xls

8/12/2008 - 7:23 PM

Project Budget Spend Plan
Task Totals

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

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

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

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 $5,125 $61,465

0 100 100 9/20

0 100 100 9/27

0 100 100

960 101 1,061

0 102 102

0 103 103

0 104 104

960 105 1,065

0 106 106

0 107 107

0 108 108

0 109 109

0 110 110

0 111 111

0 112 112

0 113 113 1/3

0 114 114 1/10

0 115 115 1/17

0 116 116 1/24

0 117 117 1/31

0 118 118 2/7

0 119 119 2/14

0 120 120 2/21

0 121 121 2/28

0 122 122 3/7

0 123 123 3/14

0 124 124 3/21

0 125 125

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

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

76387cad-b0fc-4cb0-8e95-68f0e83018c5.xls

8/12/2008 - 7:23 PM

Project Budget Spend Plan

76387cad-b0fc-4cb0-8e95-68f0e83018c5.xls

8/12/2008 - 7:23 PM

Planned Project Staffing Profile vs. Actual Labor Hours

WBS

Tasks

Owner

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

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

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

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

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 Labor Hours per Week Actual Staff Hours

8/2

8/9

8/16

8/23

8/30

9/6

9/13

9/20

9/27

26
47

28
109

30 148 182 240 248 216 56 176 88 144
94 31 31 31 31 31 31 31 31 31

96

17

0

64

0

0

0

32

0

0

76387cad-b0fc-4cb0-8e95-68f0e83018c5.xls

8/12/2008 - 7:23 PM

Labor Hours (all skills)
300

100

150

200

250

50

0
5/3/2005 5/17/2005 5/31/2005 6/14/2005 6/28/2005 7/12/2005 7/26/2005
8/9/2005

76387cad-b0fc-4cb0-8e95-68f0e83018c5.xls
8/23/2005 9/6/2005 9/20/2005 10/4/2005 10/18/2005 11/1/2005 11/15/2005 11/29/2005
12/13/2005

Planned Project Staffing Profile vs. Actual Labor Hours

Weekly Staffing Plan - Labor Hours vs. Actuals

8/12/2008 - 7:23 PM

Weeks
12/27/2005 1/10/2006 1/24/2006 2/7/2006 2/21/2006 3/7/2006 3/21/2006

Actual Staff Hours

Labor Hours per Week

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

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

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

76387cad-b0fc-4cb0-8e95-68f0e83018c5.xls

8/12/2008 - 7:23 PM


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:2033
posted:1/22/2008
language:English
pages:9