EXCEL Gantt v4

Project Schedule -Gantt Chart (48-Week Window) Version 4.0 Yellow cells = cells for data entry. WBS Tasks Owner Plan Start Plan Finish Days FTEs Hrs. 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 Send document for signatures Sue 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. Month-1 Month-2 Month-3 Month-4 6/28 7/5 7/12 7/19 7/26 8/2 8/9 8/16 5/31 6/7 6/14 6/21 5/3 5/10 5/17 5/24 8/23 8/30 $ASQEXCEL+Gantt_v4.xls 1/30/2008Project Schedule -Gantt Chart (48-Week Window) Month-10 Month-6 Month-7 Month-8 Month-9 Month-5 Month-11 9/6 9/13 3/21 1/10 1/17 1/24 1/31 11/15 11/22 11/29 12/13 12/6 12/20 12/27 3/28 3/7 3/14 2/7 2/14 2/21 2/28 1/3 9/20 9/27 10/4 10/11 10/18 10/25 11/1 11/8 $ASQEXCEL+Gantt_v4.xls 1/30/2008Project Budget Spend Plan WBS Tasks Owner Labor Rate Days FTEs Hrs. 1 Project Name ONLY INPUT 1886 1.1 Project planning & prep 0 0 0 1.1.1 0 Supervison & coord Sue $35.00 65 0.4 208 1.1.2 0 Develop plan Sue $35.00 19 0.3 46 1.1.3 0 Develop budget Bill $35.00 9 0.2 14 1.1.4 0 Schedule kickoff mtg. Nan $35.00 1 0.2 2 1.1.5 0 Conduct kickoff mtg. Jim $35.00 1 8 64 1.1.6 0 Monthly Meetings $30.00 6 4 192 0 2 4 64 1.2 Requirements Management $30.00 0 0 0 1.2.1 Conduct requirements analysis $30.00 0 0 0 0 Develop interview forms $30.00 5 2 80 0 Conduct interviews $30.00 21 4 672 0 Write prelim. requirements $30.00 15 1 120 0 Conduct walk-thru $30.00 2 8 128 0 Update requirements doc. $30.00 4 2 64 1.2.2 Establish requirements baseline $30.00 0 0 0 0 Publish draft req. doc. $30.00 1 1 8 0 Conduct req. review mtg. $30.00 2 8 128 0 Incorporate comments $30.00 5 2 80 0 Send document for signatures $30.00 2 1 16 0 Establish formal baseline $30.00 1 0.1 1 Next Major WBS Element $30.00 0 0 0 0 Task $30.00 0 0 0 0 Task $30.00 0 0 0 0 Task $30.00 0 0 0 0 $30.00 0 0 0 0 Task $30.00 0 0 0 Task $30.00 0 0 0 Task $30.00 0 0 0 Task $30.00 0 0 0 Task $30.00 0 0 0 Next Major WBS Element $30.00 0 0 0 Task $30.00 0 0 0 Task $30.00 0 0 0 Task $30.00 0 0 0 Task $30.00 0 0 0 Task $30.00 0 0 0 Next Major WBS Element $30.00 0 0 0 Task $30.00 0 0 0 Task $30.00 0 0 0 Task $30.00 0 0 0 Task $30.00 0 0 0 Task $30.00 0 0 0 Weekly Labor Cost Weekly Expense Estimate: Weekly Budget Estimate: Repeated for ease of graphic-> Budget Spend Plan -Generated from Gantt Chart Cumulative Actuals -Manual Entry 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 896 980 #### #### #### #### #### #### #### #### #### #### 2,960 504 0 960 0 0 0 960 0 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 996 #### #### #### #### #### #### #### #### #### #### #### 3,060 604 100 1,060 100 100 100 1,060 100 #### 2,176 3,312 8,032 ##### ##### ##### ##### ##### ##### ##### ##### 53,396 54,000 54,100 55,160 55,260 55,360 55,460 56,520 56,620 #### #### #### #### #### #### #### #### #### #### #### #### Do not input data into these cells --these feed from the Gantt chart 560 560 560 560 560 560 560 560 560 560 560 560 560 0 0 0 0 0 0 0 0 336 420 420 420 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 280 224 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 56 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 960 0 0 0 960 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 0 0 0 0 0 0 0 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 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 0 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 0 0 0 0 0 0 0 0 0 0 3,840 0 0 0 0 0 0 0 0 0 0 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 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 0 0 0 0 0 0 0 0 0 0 3,840 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 0 0 0 0 0 0 0 0 0 0 0 480 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Project Budget Spend Plan vs. Actuals $ASQEXCEL+Gantt_v4.xls 1/30/2008 -11:58 AMProject Budget Spend Plan Project Budget Spend Plan vs. Actuals 0 10,000 20,000 30,000 40,000 50,000 60,000 70,000 5/3/2005 5/17/2005 5/31/2005 6/14/2005 6/28/2005 7/12/2005 7/26/2005 8/9/2005 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 12/27/2005 1/10/2006 1/24/2006 2/7/2006 2/21/2006 3/7/2006 3/21/2006 Project Weeks Cumulative Project Budget/Spending $ Budget Spend Plan -Generated from Gantt Chart Cumulative Actuals -Manual Entry $ASQEXCEL+Gantt_v4.xls 1/30/2008 -11:58 AMProject Budget Spend Plan Task Totals $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 ####### 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 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 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 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 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 $ASQEXCEL+Gantt_v4.xls 1/30/2008 -11:58 AMProject Budget Spend Plan $ASQEXCEL+Gantt_v4.xls 1/30/2008 -11:58 AMPlanned Project Staffing Profile vs. Actual Labor Hours WBS Tasks Owner Days FTEs Hrs. 1 Project Name 1886 1.1 Project planning & prep 0 0 0 1.1.1 Supervison & coord Sue 65 0.4 208 1.1.2 Develop plan Sue 19 0.3 46 1.1.3 Develop budget Bill 9 0.2 14 1.1.4 Schedule kickoff mtg.Nan 1 0.2 2 1.1.5 Conduct kickoff mtg.Jim 1 8 64 6 4 192 Conduct requirements analysis 2 4 64 1.2 Develop interview forms 0 0 0 1.2.1 Conduct interviews 0 0 0 Write prelim. requirements 5 2 80 Conduct walk-thru 21 4 672 Update requirements doc. 15 1 120 Establish requirements baseline 2 8 128 Publish draft req. doc. 4 2 64 1.2.2 Conduct req. review mtg. 0 0 0 Incorporate comments 1 1 8 Send document for signatures 2 8 128 Establish formal baseline 5 2 80 Next Major WBS Element 2 1 16 Task 1 0.1 1 Task 0 0 0 Task 0 0 0 Task 0 0 0 Task 0 0 0 Next Major WBS Element 0 0 0 Task 0 0 0 Task 0 0 0 Task 0 0 0 Task 0 0 0 Task 0 0 0 Next Major WBS Element 0 0 0 Task 0 0 0 Task 0 0 0 Task 0 0 0 Task 0 0 0 Task 0 0 0 Next Major WBS Element 0 0 0 Task 0 0 0 Task 0 0 0 Task 0 0 0 Task 0 0 0 Task 0 0 0 Weekly Labor Hours Labor Hours per Week Actual Staff Hours 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 Do not input data into these cells --these feed from the Gantt chart 16 16 16 16 16 16 16 16 16 16 16 16 16 0 0 0 0 0 0 0 0 10 12 12 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 64 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 32 0 0 0 32 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 80 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 32 160 160 160 160 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40 40 40 0 0 0 0 0 0 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 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 8 0 0 0 0 0 0 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 80 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 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 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 26 28 30 148 182 240 248 216 56 176 88 144 96 17 0 64 0 0 0 32 0 47 109 94 31 31 31 31 31 31 31 31 31 $ASQEXCEL+Gantt_v4.xls 1/30/2008 -11:58 AMPlanned Project Staffing Profile vs. Actual Labor Hours Weekly Staffing Plan -Labor Hours vs. Actuals 0 50 100 150 200 250 300 5/3/2005 5/17/2005 5/31/2005 6/14/2005 6/28/2005 7/12/2005 7/26/2005 8/9/2005 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 12/27/2005 1/10/2006 1/24/2006 2/7/2006 2/21/2006 3/7/2006 3/21/2006 Weeks Labor Hours (all skills) Labor Hours per Week Actual Staff Hours $ASQEXCEL+Gantt_v4.xls 1/30/2008 -11:58 AMPlanned 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 $ASQEXCEL+Gantt_v4.xls 1/30/2008 -11:58 AM