Docstoc

Project Schedule Gantt Templates Excel - Excel

Document Sample
Project Schedule Gantt Templates Excel - Excel Powered By Docstoc
					                                                                                  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.




          b93f618d-0895-4a29-a073-22fbf8908b78.xls                                                        7/18/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




         b93f618d-0895-4a29-a073-22fbf8908b78.xls                                           7/18/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
         b93f618d-0895-4a29-a073-22fbf8908b78.xls                                              7/18/2011 - 9:55 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




                                                                                                  Project Weeks



                                       b93f618d-0895-4a29-a073-22fbf8908b78.xls                7/18/2011 - 9:55 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




              b93f618d-0895-4a29-a073-22fbf8908b78.xls                                                  7/18/2011 - 9:55 AM
                                           Project Budget Spend Plan




b93f618d-0895-4a29-a073-22fbf8908b78.xls      7/18/2011 - 9:55 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


         b93f618d-0895-4a29-a073-22fbf8908b78.xls                                        7/18/2011 - 9:55 AM
                                                                         Labor Hours (all skills)




                                                                           100
                                                                                    150
                                                                                                                 200
                                                                                                                                              250
                                                                                                                                                    300




                                                                0
                                                                    50
                                                     5/3/2005


                                                    5/17/2005


                                                    5/31/2005


                                                    6/14/2005


                                                    6/28/2005


                                                    7/12/2005




b93f618d-0895-4a29-a073-22fbf8908b78.xls
                                                    7/26/2005


                                                     8/9/2005


                                                    8/23/2005


                                                     9/6/2005


                                                    9/20/2005


                                                    10/4/2005


                                                   10/18/2005




7/18/2011 - 9:55 AM
                                           Weeks
                                                    11/1/2005


                                                   11/15/2005


                                                   11/29/2005
                                                                                                                                                                                                           Planned Project Staffing Profile vs. Actual Labor Hours


                                                                                                                                                          Weekly Staffing Plan - Labor Hours vs. Actuals




                                                   12/13/2005


                                                   12/27/2005


                                                    1/10/2006


                                                    1/24/2006


                                                     2/7/2006
                                                                                            Actual Staff Hours




                                                    2/21/2006
                                                                                                                       Labor Hours per Week




                                                     3/7/2006


                                                    3/21/2006
                                                                 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



         b93f618d-0895-4a29-a073-22fbf8908b78.xls                                    7/18/2011 - 9:55 AM

				
DOCUMENT INFO
Description: Project Schedule Gantt Templates Excel document sample