Get documents about "EXCEL Gantt v4
Document Sample
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
Related docs
