Docstoc

Selection of Contractor

Document Sample
Selection of Contractor Powered By Docstoc
					                                        Labor Rates
                                      Civil Service Labor Rates
        Grade         Annual Salary   Fringe Benefits     Overhead       Burdened Cost   Hourly Cost
                                          32.85%           12.00%
        GS   15            125,078           41,088.12       19,939.93      186,106.06            89.17
        GS   14            106,331           34,929.73       16,951.29      158,212.02            75.81
        GS   13             89,985           29,560.07       14,345.41      133,890.48            64.15
        GS   12             75,671           24,857.92       12,063.47      112,592.39            53.95
        GS   11             63,135           20,739.85       10,064.98       93,939.83            45.01
        GS   10             57,463           18,876.60        9,160.75       85,500.35            40.97
        GS   09             52,180           17,141.13        8,318.54       77,639.67            37.20
        GS   08             47,245           15,519.98        7,531.80       70,296.78            33.68
        GS   07             42,659           14,013.48        6,800.70       63,473.18            30.41
        GS   06             38,388           12,610.46        6,119.81       57,118.27            27.37
        GS   05             34,437           11,312.55        5,489.95       51,239.50            24.55
        GS   04             30,779           10,110.90        4,906.79       45,796.69            21.94
        GS   03             27,419            9,007.14        4,371.14       40,797.28            19.55
        GS   02             24,325            7,990.76        3,877.89       36,193.65            17.34
        GS   01             22,345            7,340.33        3,562.24       33,247.57            15.93




                                       Contractor Labor Rates
       Contractor     Annual Salary     Overhead           G&A           Burdened Cost   Hourly Cost
     Labor Category                       65.00%           40.00%
Contractor Rate A          165,000         107,250.00        66,000.00      338,250.00          162.07
Contractor Rate B          155,000         100,750.00        62,000.00      317,750.00          152.25
Contractor Rate C          145,000          94,250.00        58,000.00      297,250.00          142.43
Contractor Rate D          135,000          87,750.00        54,000.00      276,750.00          132.61
Contractor Rate E          125,000          81,250.00        50,000.00      256,250.00          122.78
Contractor Rate F          115,000          74,750.00        46,000.00      235,750.00          112.96
Contractor Rate G          105,000          68,250.00        42,000.00      215,250.00          103.14
Contractor Rate H           95,000          61,750.00        38,000.00      194,750.00           93.32
Contractor Rate I           85,000          55,250.00        34,000.00      174,250.00           83.49
Contractor Rate J           75,000          48,750.00        30,000.00      153,750.00           73.67
Contractor Rate K           65,000          42,250.00        26,000.00      133,250.00           63.85
Contractor Rate L           55,000          35,750.00        22,000.00      112,750.00           54.02
Contractor Rate M           45,000          29,250.00        18,000.00       92,250.00           44.20
Contractor Rate N           35,000          22,750.00        14,000.00       71,750.00           34.38
Contractor Rate O           25,000          16,250.00        10,000.00       51,250.00           24.56
                                                                                                           Labor Estimates


                                                                                                                     Government Labor Costs
         Rate
                      Jan-03                Feb-03          Mar-03                Apr-03             May-03             Jun-03                 Jul-03           Aug-03             Sep-03             Oct-03             Nov-03                Dec-03                 Totals
                    Hours    $           Hours    $      Hours         $       Hours      $       Hours      $       Hours      $       Hours        $       Hours      $       Hours      $       Hours      $       Hours         $       Hours    $           Hours        $
        GS 15           14  1,248            16  1,427       18        1,605       18     1,605       18     1,605       18     1,605       18       1,605       18     1,605       18     1,605       18     1,605       18        1,605       16  1,427            208     18,548
        GS 14           68  5,155            72  5,458       80        6,065       80     6,065       80     6,065       80     6,065       80       6,065       80     6,065       80     6,065       80     6,065       80        6,065       72  5,458            932     70,653
        GS 13          136  8,725           154  9,880      160       10,265      172    11,035      240    15,397      240    15,397      240      15,397      240    15,397      240    15,397      172    11,035      160       10,265      154  9,880          2,308    148,069
        GS 12                   0                    0                     0                  0                  0                  0                    0                  0                  0                  0                     0               0              0          0
        GS 11          272 12,243           320 14,404      364       16,384      420    18,905      600    27,007      720    32,409      720      32,409      720    32,409      600    27,007      420    18,905      364       16,384      320 14,404          5,840    262,869
        GS 10                   0                    0                     0                  0                  0                  0                    0                  0                  0                  0                     0               0              0          0
        GS 09                   0                    0                     0                  0                  0                  0                    0                  0                  0                  0                     0               0              0          0
        GS 08                   0                    0                     0                  0                  0                  0                    0                  0                  0                  0                     0               0              0          0
        GS 07           68 2,068             72 2,190           80     2,433      120     3,650      160     4,866      172     5,231      172       5,231      172     5,231      160     4,866      120     3,650          80     2,433       72 2,190           1,448     44,039
        GS 06                   0                    0                     0                  0                  0                  0                    0                  0                  0                  0                     0               0              0          0
        GS 05                   0                    0                     0                  0                  0                  0                    0                  0                  0                  0                     0               0              0          0
        GS 04                   0                    0                     0                  0                  0                  0                    0                  0                  0                  0                     0               0              0          0
        GS 03                   0                    0                     0                  0                  0                  0                    0                  0                  0                  0                     0               0              0          0
        GS 02                   0                    0                     0                  0                  0                  0                    0                  0                  0                  0                     0               0              0          0
        GS 01                   0                    0                     0                  0                  0                  0                    0                  0                  0                  0                     0               0              0          0
        Totals         558 29,440           634 33,358      702       36,752      810    41,259    1,098    54,940    1,230    60,707    1,230      60,707    1,230    60,707    1,098    54,940      810    41,259      702       36,752      634 33,358         10,736    544,179



                                                                                                                      Contractor Labor Costs
         Rate
                      Jan-03                Feb-03          Mar-03                Apr-03             May-03             Jun-03                 Jul-03           Aug-03             Sep-03             Oct-03             Nov-03                Dec-03                  Totals
                     Hrs          $       Hrs      $      Hrs          $        Hrs       $        Hrs       $        Hrs       $        Hrs         $        Hrs       $        Hrs       $        Hrs       $        Hrs          $        Hrs          $      Hours         $
Contractor Rate A       14       2,269        16 2,593       16        2,593       16     2,593       16     2,593       16     2,593       16       2,593       16     2,593       16     2,593       16     2,593       16        2,593       16       2,593       190      30,794
Contractor Rate B       34       5,177        42 6,395       42        6,395       42     6,395       42     6,395       42     6,395       42       6,395       42     6,395       42     6,395       42     6,395       42        6,395       42       6,395       496      75,517
Contractor Rate C      136      19,370      168 23,928      172       24,498      180    25,637      180    25,637      180    25,637      180      25,637      180    25,637      180    25,637      180    25,637      172       24,498      168      23,928     2,076    295,683
Contractor Rate D                    0               0                     0                  0                  0                  0                    0                  0                  0                  0                     0                    0         0           0
Contractor Rate E                    0               0                     0                  0                  0                  0                    0                  0                  0                  0                     0                    0         0           0
Contractor Rate F      544      61,451      620 70,036      680       76,814      800    90,369      960   108,443    1,020   115,220    1,020     115,220    1,020   115,220      960   108,443      800    90,369      680       76,814      620      70,036     9,724 1,098,435
Contractor Rate G                    0               0                     0                  0                  0                  0                    0                  0                  0                  0                     0                    0         0           0
Contractor Rate H                    0               0                     0                  0                  0                  0                    0                  0                  0                  0                     0                    0         0           0
Contractor Rate I                    0               0                     0                  0                  0                  0                    0                  0                  0                  0                     0                    0         0           0
Contractor Rate J                    0               0                     0                  0                  0                  0                    0                  0                  0                  0                     0                    0         0           0
Contractor Rate K          68    4,342        72 4,597          80     5,108      120     7,662      180    11,493      240    15,323      240      15,323      240    15,323      180    11,493      120     7,662          80     5,108          72    4,597     1,692    108,030
Contractor Rate L                    0               0                     0                  0                  0                  0                    0                  0                  0                  0                     0                    0         0           0
Contractor Rate M                    0               0                     0                  0                  0                  0                    0                  0                  0                  0                     0                    0         0           0
Contractor Rate N                    0               0                     0                  0                  0                  0                    0                  0                  0                  0                     0                    0         0           0
Contractor Rate O                    0               0                     0                  0                  0                  0                    0                  0                  0                  0                     0                    0         0           0
         Totals        796      92,609      918 ######      990      115,407    1,158   132,656    1,378   154,560    1,498   165,169    1,498     165,169    1,498   165,169    1,378   154,560    1,158   132,656      990      115,407      918      ######    14,178 1,608,459
                                           Material and ODC Estimates




                                                     Estimated Material and ODC
                        Jan-03   Feb-03    Mar-03    Apr-03 May-03 Jun-03 Jul-03 Aug-03           Sep-03   Oct-03 Nov-03     Dec-03
                          $        $        $         $        $         $      $     $             $       $       $          $
Hardware/Equipment                   100      250     1,000    1,500    2,000   3,000 2,000        1,000      500  2,550         100
Software                                              3,000                     1,250                       1,250
Vendor Services                     250       500     1,250    2,500    3,000   3,000 3,000        1,000      500     250
Inter-Agency Services
Supplies/Other            100       250        500    1,000    1,000    1,000    1,000    1,000    1,000      250      100        0
Cost Totals              $100      $600     $1,250   $6,250   $5,000   $6,000   $8,250   $6,000   $3,000   $2,500   $2,900     $100
                                                                                                                                                     Incurred Costs


                                                                                                                                                    Government Labor Costs Incurred
                                                   Jan-03                   Feb-03                  Mar-03                Apr-03                May-03              Jun-03              Jul-03                  Aug-03             Sep-03                Oct-03               Nov-03             Dec-03              Total
                              Hourly Rate    Hrs             $        Hrs             $       Hrs          $        Hrs             $        Hrs        $       Hrs        $        Hrs        $             Hrs       $        Hrs       $        Hrs            $        Hrs       $        Hrs       $       Hrs        $
           GS 15                89.17           16           1,427        16          1,427      24        2,140       24           2,140        24    2,140        18     1,605                        0                  0                  0                                                                   122     10,879
           GS 14                75.81           72           5,458        82          6,216      72        5,458       88           6,671      120     9,097        80     6,065                        0                  0                  0                                                                   514     38,965
           GS 13                64.15          120           7,699       160         10,265     180       11,548      180          11,548      266    17,065      240     15,397                        0                  0                  0                                                                 1,146     73,521
           GS 12                53.95                            0                        0                    0                        0                  0                   0                        0                  0                  0                                                                     0          0
           GS 11                45.01          285          12,828       344         15,484     380       17,105      440          19,805      720    32,409      760     34,209                        0                  0                  0                                                                 2,929   131,840
           GS 10                40.97                            0                        0                    0                        0                  0                   0                        0                  0                  0                                                                     0          0
           GS 09                37.20                            0                        0                    0                        0                  0                   0                        0                  0                  0                                                                     0          0
           GS 08                33.68                            0                        0                    0                        0                  0                   0                        0                  0                  0                                                                     0          0
           GS 07                30.41              72                       72                      80                144                      165                172                                                                                                                                             705          0
           GS 06                27.37                                                                                                                                                                                                                                                                               0          0
           GS 05                24.55                                                                                                                                                                                                                                                                               0          0
           GS 04                21.94                                                                                                                                                                                                                                                                               0          0
           GS 03                19.55                                                                                                                                                                                                                                                                               0          0
           GS 02                17.34                                                                                                                                                                                                                                                                               0          0
           GS 01                15.93                                                                                                                                                                                                                                                                               0          0
  Total Civil Service Labor                    493      $27,412          674     $33,392        656      $36,251      732      $40,164        1,130   $60,711     1,098   $57,276           0           $0       0         $0       0         $0          0           $0       0         $0       0             4,783 $255,206


                                                                                                                                                         Contractor Labor Costs
                                                   Jan-03                   Feb-03                  Mar-03                Apr-03                 May-03              Jun-03                Jul-03               Aug-03             Sep-03                Oct-03               Nov-03             Dec-03              Total
           Rate
                             Hourly Rate     Hrs          $           Hrs          $          Hrs          $        Hrs          $           Hrs        $        Hrs        $        Hrs            $        Hrs       $        Hrs       $        Hrs            $        Hrs       $        Hrs       $       Hrs        $
Contractor Rate A                 162.07        24        3,890           32       5,186         18        2,917       16        2,593           16     2,593        16     2,593                       0                  0                  0                       0                  0                  0     122     19,773
Contractor Rate B                 152.25        48        7,308           44       6,699         44        6,699       48        7,308           42     6,395        42     6,395                       0                  0                  0                       0                  0                  0     268     40,804
Contractor Rate C                 142.43       144       20,510          172      24,498        180       25,637      196       27,916          180   25,637        180    25,637                       0                  0                  0                       0                  0                  0   1,052   149,836
Contractor Rate D                 132.61                      0                        0                       0                     0                      0                   0                       0                  0                  0                       0                  0                  0       0          0
Contractor Rate E                 122.78                      0                        0                       0                     0                      0                   0                       0                  0                  0                       0                  0                  0       0          0
Contractor Rate F                 112.96       600       73,670          660      81,037        680       83,493      820      100,683          960 117,873        1024   125,731                       0                  0                  0                       0                  0                  0   4,744   582,487
Contractor Rate G                 103.14                      0                        0                       0                     0                      0                   0                       0                  0                  0                       0                  0                  0       0          0
Contractor Rate H                  93.32                      0                        0                       0                     0                      0                   0                       0                  0                  0                       0                  0                  0       0          0
Contractor Rate I                  83.49           72     6,011             80     6,679            80     6,679      120       10,019          182   15,196        248    20,706                       0                  0                  0                       0                  0                  0     782     65,292
Contractor Rate J                  73.67                      0                        0                       0                     0                      0                   0                       0                  0                  0                       0                  0                  0       0          0
Contractor Rate K                  63.85                      0                        0                       0                     0                      0                   0                       0                  0                  0                       0                  0                  0       0          0
Contractor Rate L                  54.02                      0                        0                       0                     0                      0                   0                       0                  0                  0                       0                  0                  0       0          0
Contractor Rate M                  44.20                      0                        0                       0                     0                      0                   0                       0                  0                  0                       0                  0                  0       0          0
Contractor Rate N                  34.38                      0                        0                       0                     0                      0                   0                       0                  0                  0                       0                  0                  0       0          0
Contractor Rate O                  24.56                      0                        0                       0                     0                      0                   0                       0                  0                  0                       0                  0                  0       0          0
         Total Contractor Labor                888      111,390          988     124,100      1,002      125,426     1,200     148,519        1,380 167,693       1,510   181,062           0           0        0         0        0         0           0           0        0         0        0         0   6,968 $792,899

                                                                        Material and Other Direct Costs
                                Jan-03      Feb-03      Mar-03       Apr-03    May-03     Jun-03    Jul-03         Aug-03     Sep-03        Oct-03    Nov-03    Dec-03    Totals
                                  $           $           $            $          $         $          $             $          $             $         $         $         $
Hardware/Equipment                              100         250        1,000       1,500    2,000                                                                           4,850
Software                                                               3,000                                                                                                3,000
Vendor Services                                250            500      1,250       2,500    3,000                                                                           7,500
Inter-Agency Services                                                                                                                                                            0
Supplies/Other                       100       250            500      1,000          1,000   1,000                                                                         3,850
                                                                                                                                                                                 0
           Totals                    100       600           1250      6250           5000     6000           0           0            0         0         0         0      19200
                                  Completion Percentages




                                                Actual Percentage of Work Complete as of Reporting Date
                      WBS
WBS 1.0             Weighting Jan-03 Feb-03 Mar-03   Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03
          WBS 1.1        0.50   5.0% 10.0%   15.0%     20.0% 30.0% 40.0%
          WBS 1.2        0.25   8.0% 12.0%   20.0%     27.0% 37.0% 48.0%
          WBS 1.3        0.15   8.0% 12.0%   20.0%     27.0% 37.0% 48.0%
          WBS 1.4        0.10   5.0% 10.0%   15.0%     25.0% 35.0% 45.0%
           TOTAL         1.00   6.2% 10.8%   17.0%     23.3% 33.3% 43.7% 0.0%            0.0%    0.0%   0.0% 0.0% 0.0%

                                                        Projected Completion Percentage by Month
                              Jan-03 Feb-03   Mar-03   Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03
                                5.6% 12.0%     19.0%    27.2% 37.0% 47.6% 58.2% 68.8% 78.5% 86.5% 93.6% 100.0%
                                                                EVMS Calculations


          Jan-03       Feb-03       Mar-03       Apr-03       May-03       Jun-03       Jul-03      Aug-03      Sep-03      Oct-03      Nov-03      Dec-03
            $            $            $            $            $            $            $           $           $           $           $           $
BCWS        122,148      263,656      417,065      597,229      811,730    1,043,605    1,277,731   1,509,606   1,722,107   1,898,522   2,053,581   2,194,588
ACWP        138,901      296,993      459,920      654,854      888,258    1,132,596    1,132,596   1,132,596   1,132,596   1,132,596   1,132,596   1,132,596
BCWP        136,064      237,015      373,080      511,339      730,798      959,035

BAC       2,194,588    2,194,588    2,194,588    2,194,588    2,194,588    2,194,588    2,194,588   2,194,588   2,194,588   2,194,588   2,194,588   2,194,588

CV            -2,837      -59,978      -86,840    -143,515     -157,461     -173,561
CV %         -2.09%      -25.31%      -23.28%      -28.07%      -21.55%      -18.10%
CPI            0.980        0.798        0.811        0.781        0.823        0.847

SV           13,916       -26,640      -43,985      -85,890     -80,932      -84,570
SV %        11.39%       -10.10%      -10.55%      -14.38%       -9.97%       -8.10%
SPI           1.114         0.899        0.895        0.856        0.900        0.919

EAC 1     2,240,346    2,749,940    2,705,414    2,810,533    2,667,443    2,591,754
EAC2      2,025,419    3,025,646    2,970,149    3,172,625    2,864,478    2,720,426

VAC 1       -45,758     -555,352     -510,826     -615,945     -472,855     -397,166
VAC 1 %      -2.09%      -25.31%      -23.28%      -28.07%      -21.55%      -18.10%

VAC 2       169,169     -831,058     -775,561     -978,037     -669,890     -525,838
VAC 2 %      7.71%       -37.87%      -35.34%      -44.57%      -30.52%      -23.96%

ETC       1,886,517    2,728,653    2,510,228    2,517,771    1,976,220    1,587,830

ECD       19-Nov-03     5-Feb-04     7-Feb-04    21-Feb-04     5-Feb-04    29-Jan-04
                                                      EVMS Chart


           Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03                  Jul-03    Aug-03      Sep-03     Oct-03   Nov-03     Dec-03
BCWS        122,148   263,656   417,065   597,229   811,730 ####### 1,277,731   1,509,606   1,722,107 1,898,522 2,053,581 2,194,588
ACWP        138,901   296,993   459,920   654,854   888,258 #######
BCWP        136,064   237,015   373,080   511,339   730,798 959,035




       2,500,000
                                                                                               2,194,588


       2,000,000




       1,500,000
                                                                                                                   BCWS

                                                     1,132,596                                                     ACWP
                                                                                                                   BCWP
       1,000,000
                                                              959,035



        500,000




              0
                   Jan-03 Feb-03 Mar-03 Apr-03 May-03 Jun-03 Jul-03 Aug-03 Sep-03 Oct-03 Nov-03 Dec-03

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:8/10/2011
language:English
pages:7
Description: Selection of Contractor document sample