Line Operator Resume

Description

Line Operator Resume document sample

Document Sample
scope of work template
							                                                                                                                                                             LBOS Personnel Costs Worksheet


                                                          winCOMPARE2 automatically calculates these columns.

     A                   B                  C       D      E        F             G           H        I         J         K            L                M                N                 O               P             Q              R           S                  T             U         V                    W                   X

                                                                                                               Total                                                                                      Fringe                                 Other Pay
                                                                                             Paid               Paid     Basic                                                                          Benefits                      Other Pay  and Other                                      Is
                                                                             Productive     Hours              Hours     Hourly                                                                          (Col N x                     Medicare Pay Medicare      Total Personnel             Position
                                                           Position          Hours per       per    Number       for      Pay                          1st PP           Other         Basic Pay (Col    32.85% or                      (Col P x   (Col P x        Costs (Col N +    Exp or   on DOL        Position Title on
  OSC             Position Title          Grade Series EPA  Type                FTE          FTE     of FTE   Position    Rate     Salary/Wages     Prorated FTE     Entitlements       L + Col M)        7.65%)       Other Pay        0.0145)   1.0145)         Col O+ Col R)      Mix      Listing        DOL Listing             Remarks
          1001-Supervisory
          Communications-Computer
  SC1     Specialist                      GS13     301     No       FT          1776        2087     1.0000   2087.00     $39.12       $81,638.00            1.000            $0.00        $81,638.00     $26,818.08          $0.00       $0.00          $0.00        $108,456.08     No        No
          1002-Visual Information
  SC1     Specialist                      GS11     1084    No       FT          1776        2087     1.0000   2087.00     $27.45       $57,280.00            0.634            $0.00        $57,280.00     $18,816.48          $0.00       $0.00          $0.00         $76,096.48     No        No
          1003-Visual Information
  SC1     Specialist                      GS09     1084    No       FT          1776        2087     1.0000   2087.00     $22.68       $47,340.00            0.601            $0.00        $47,340.00     $15,551.19          $0.00       $0.00          $0.00         $62,891.19     No        No

          1004A-Telecommunications                                                                                                                                                                                                                                                                       Engineering
  SC1     Specialist/Plans Programmer     GS09     391     No       FT          1776        2087     1.0000   2087.00     $22.68       $47,340.00            0.601            $0.00        $47,340.00     $15,551.19    $6,059.50        $87.86     $6,147.36          $69,038.55     No       Yes       Technician V

          1004B-Telecommunications                                                                                                                                                                                                                                                                       Engineering
  SC1     Specialist/Plans Programmer     GS09     391     No       FT          1776        2087     1.0000   2087.00     $22.68       $47,340.00            0.510            $0.00        $47,340.00     $15,551.19    $6,059.50        $87.86     $6,147.36          $69,038.55     No       Yes       Technician V

          1004C-Telecommunications                                                                                                                                                                                                                                                                       Engineering
  SC1     Specialist/Plans Programmer     GS09     391     No       FT          1776        2087     1.0000   2087.00     $22.68       $47,340.00            0.510            $0.00        $47,340.00     $15,551.19    $6,059.50        $87.86     $6,147.36          $69,038.55     No       Yes       Technician V
          1006A-Editorial Assistant
          (Office
          Automation)/Publications
  SC1     Manager                         GS07     1087   Yes       FT          1776        2087     1.0000   2087.00     $18.54       $38,703.00            0.601            $0.00        $38,703.00     $12,713.94          $0.00       $0.00          $0.00         $51,416.94     No       Yes       Word Processor II
          1006B-Editorial Assistant
          (Office
          Automation)/Publications
  SC1     Manager                         GS07     1087   Yes       FT          1776        2087     1.0000   2087.00     $18.54       $38,703.00            0.601            $0.00        $38,703.00     $12,713.94          $0.00       $0.00          $0.00         $51,416.94     No       Yes       Word Processor II

          1007A-Computer Inventory
          Control Techician/Equipment
  SC1     Control Officer                 GS06     303    Yes       FT          1776        2087     1.0000   2087.00     $16.69       $34,829.00            0.510            $0.00        $34,829.00     $11,441.33          $0.00       $0.00          $0.00         $46,270.33     No       Yes       Supply Technician

          1007B-Computer Inventory
          Control Techician/Equipment
  SC1     Control Officer                 GS06     303    Yes       FT          1776        2087     1.0000   2087.00     $16.69       $34,829.00            0.412            $0.00        $34,829.00     $11,441.33          $0.00       $0.00          $0.00         $46,270.33     No       Yes       Supply Technician
          1008-Secretary (Office
  SC1     Automation)                     GS05     318    Yes       FT          1776        2087     1.0000   2087.00     $14.97       $31,247.00            0.510            $0.00        $31,247.00     $10,264.64          $0.00       $0.00          $0.00         $41,511.64     No       Yes       Secretary
          1009-Budget Technician
  SC1     (Office Automation)             GS05     561    Yes       FT          1776        2087     1.0000   2087.00     $14.97       $31,247.00            0.510            $0.00        $31,247.00     $10,264.64          $0.00       $0.00          $0.00         $41,511.64     No       Yes       Accounting Clerk IV
          2001-Supervisory Computer
          Assistant/Help Desk
  SC1A    Specialist                      GS09     335     No       FT          1776        2087     1.0000   2087.00     $22.68       $47,340.00            0.601            $0.00        $47,340.00     $15,551.19          $0.00       $0.00          $0.00         $62,891.19     No       Yes       Computer Operator V
          2002A-Computer
          Assistant/Help Desk                                                                                                                                                                                                                                                                            Computer Operator III
  SC1A    Specialist                      GS07     335    Yes       FT          1776        2087     1.0000   2087.00     $18.54       $38,703.00            0.601            $0.00        $38,703.00     $12,713.94          $0.00       $0.00          $0.00         $51,416.94     No       Yes       & IV
          2002B-Computer
          Assistant/Help Desk                                                                                                                                                                                                                                                                            Computer Operator III
  SC1A    Specialist                      GS07     335    Yes       FT          1776        2087     1.0000   2087.00     $18.54       $38,703.00            0.510            $0.00        $38,703.00     $12,713.94    $5,449.55        $79.02     $5,528.57          $56,945.51     No       Yes       & IV
          2002C-Computer
          Assistant/Help Desk                                                                                                                                                                                                                                                                            Computer Operator III
  SC1A    Specialist                      GS07     335    Yes       FT          1776        2087     1.0000   2087.00     $18.54       $38,703.00            0.510            $0.00        $38,703.00     $12,713.94    $5,449.55        $79.02     $5,528.57          $56,945.51     No       Yes       & IV
          2002D-Computer
          Assistant/Help Desk                                                                                                                                                                                                                                                                            Computer Operator III
  SC1A    Specialist                      GS07     335    Yes       FT          1776        2087     1.0000   2087.00     $18.54       $38,703.00            0.510            $0.00        $38,703.00     $12,713.94    $5,449.55        $79.02     $5,528.57          $56,945.51     No       Yes       & IV



          2002E-Computer
          Assistant/Help Desk                                                                                                                                                                                                                                                                            Computer Operator III
  SC1A    Specialist                      GS07     335    Yes       FT          1776        2087     1.0000   2087.00     $18.54       $38,703.00            0.510            $0.00        $38,703.00     $12,713.94    $2,031.52        $29.46     $2,060.98          $53,477.92     No       Yes       & IV
          2002F-Computer
          Assistant/Help Desk                                                                                                                                                                                                                                                                            Computer Operator III
  SC1A    Specialist                      GS07     335    Yes       FT          1776        2087     1.0000   2087.00     $18.54       $38,703.00            0.510            $0.00        $38,703.00     $12,713.94          $0.00       $0.00          $0.00         $51,416.94     No       Yes       & IV




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                                                                                                                                               08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 1 of 40
                                                                                                                                                             LBOS Personnel Costs Worksheet


     A                   B                  C       D      E        F             G           H        I         J         K            L                M                N                 O               P             Q              R           S                  T             U         V                  W                     X

                                                                                                               Total                                                                                      Fringe                                 Other Pay
                                                                                             Paid               Paid     Basic                                                                          Benefits                      Other Pay  and Other                                      Is
                                                                             Productive     Hours              Hours     Hourly                                                                          (Col N x                     Medicare Pay Medicare      Total Personnel             Position
                                                           Position          Hours per       per    Number       for      Pay                          1st PP           Other         Basic Pay (Col    32.85% or                      (Col P x   (Col P x        Costs (Col N +    Exp or   on DOL        Position Title on
  OSC             Position Title          Grade Series EPA  Type                FTE          FTE     of FTE   Position    Rate     Salary/Wages     Prorated FTE     Entitlements       L + Col M)        7.65%)       Other Pay        0.0145)   1.0145)         Col O+ Col R)      Mix      Listing        DOL Listing             Remarks
          3001-Supervisory
          Information Technology
          Specialist/Network Services
  SC1B    Branch Manager                   IT12    2210    No       FT          1776        2087     1.0000   2087.00     $33.27       $69,437.00            0.601            $0.00        $69,437.00     $22,810.05          $0.00       $0.00          $0.00         $92,247.05     No       Yes       Computer Analyst III

          3002-Information Technology
  SC1B    Specialist (Network Services)    IT11    2210    No       FT          1776        2087     1.0000   2087.00     $28.99       $60,500.00            0.510            $0.00        $60,500.00     $19,874.25    $1,452.11        $21.06     $1,473.17          $81,847.42     No       Yes       Computer Analyst II
          3003-Information Technology
          Specialist (Systems
  SC1B    Administration)                  IT11    2210    No       FT          1776        2087     1.0000   2087.00     $28.99       $60,500.00            0.510            $0.00        $60,500.00     $19,874.25      $756.35        $10.97      $767.32           $81,141.57     No       Yes       Computer Analyst II
          3004A-Information
          Technology Specialist
          (Security)/Wing Assistant
          Information Assurance
  SC1B    Manager                          IT09    2210    No       FT          1776        2087     1.0000   2087.00     $26.39       $55,086.00            0.510            $0.00        $55,086.00     $18,095.75          $0.00       $0.00          $0.00         $73,181.75     No        No
          3004B-Information
          Technology Specialist
          (Security)/Wing Assistant
          Information Assurance
  SC1B    Manager                          IT09    2210    No       FT          1776        2087     1.0000   2087.00     $26.39       $55,086.00            0.510            $0.00        $55,086.00     $18,095.75          $0.00       $0.00          $0.00         $73,181.75     No        No
          3005A-Information
          Technology Specialist
          (Network Services/Customer                                                                                                                                                                                                                                                                     Computer System
  SC1B    Support)                         IT09    2210    No       FT          1776        2087     1.0000   2087.00     $26.39       $55,086.00            0.412            $0.00        $55,086.00     $18,095.75      $688.52         $9.98      $698.50           $73,880.25     No       Yes       Analyst I
          3005B-Information
          Technology Specialist
          (Network Services/Customer                                                                                                                                                                                                                                                                     Computer System
  SC1B    Support)                         IT09    2210    No       FT          1776        2087     1.0000   2087.00     $26.39       $55,086.00            0.412            $0.00        $55,086.00     $18,095.75    $1,321.88        $19.17     $1,341.05          $74,522.80     No       Yes       Analyst I
          3005C-Information
          Technology Specialist
          (Network Services/Customer                                                                                                                                                                                                                                                                     Computer System
  SC1B    Support)                         IT09    2210    No       FT          1776        2087     1.0000   2087.00     $26.39       $55,086.00            0.412            $0.00        $55,086.00     $18,095.75      $688.52         $9.98      $698.50           $73,880.25     No       Yes       Analyst I
          3005D-Information
          Technology Specialist
          (Network Services/Customer                                                                                                                                                                                                                                                                     Computer System
  SC1B    Support)                         IT09    2210    No       FT          1776        2087     1.0000   2087.00     $26.39       $55,086.00            0.412            $0.00        $55,086.00     $18,095.75      $688.52         $9.98      $698.50           $73,880.25     No       Yes       Analyst I
          3006-Computer
  SC1B    Assistant/Web Developer         GS07     335    Yes       FT          1776        2087     1.0000   2087.00     $18.54       $38,703.00            0.412            $0.00        $38,703.00     $12,713.94          $0.00       $0.00          $0.00         $51,416.94     No       Yes       Computer Operator IV

          4001-Communications Cable
          Splicer Supervisor/Base                                                                                                                                                                                                                                                                        Cable Splicer &
          Communications Services                                                                                                                                                                                                                                                                        Telecommunications
  SC1C    Supervisor                      WS09     2504    No       FT          1776        2087     1.0000   2087.00     $24.86       $51,882.82            0.601            $0.00        $51,882.82     $17,043.51          $0.00       $0.00          $0.00         $68,926.33     No       Yes       Mechanic II
          4002A-Telecommunications                                                                                                                                                                                                                                                                       Telecommunications
  SC1C    Mechanic                        WG11     2502   Yes       FT          1776        2087     1.0000   2087.00     $20.30       $42,366.10            0.510            $0.00        $42,366.10     $13,917.26          $0.00       $0.00          $0.00         $56,283.36     No       Yes       Mechanic II
          4002B-Telecommunications                                                                                                                                                                                                                                                                       Telecommunications
  SC1C    Mechanic                        WG11     2502   Yes       FT          1776        2087     1.0000   2087.00     $20.30       $42,366.10            0.510            $0.00        $42,366.10     $13,917.26          $0.00       $0.00          $0.00         $56,283.36     No       Yes       Mechanic II
          4003-Communication Cable
          Splicer Leader/Cable and
  SC1C    Outside Plant Mechanic          WL10     2504   Yes       FT          1776        2087     1.0000   2087.00     $21.60       $45,079.20            0.510            $0.00        $45,079.20     $14,808.52          $0.00       $0.00          $0.00         $59,887.72     No       Yes       Cable Splicer
          4004A-Communications
          Cable Splicer/Cable and
  SC1C    Outside Plant Mechanic          WG10     2504   Yes       FT          1776        2087     1.0000   2087.00     $19.65       $41,009.55            0.314            $0.00        $41,009.55     $13,471.64          $0.00       $0.00          $0.00         $54,481.19     No       Yes       Cable Splicer
          4004B-Communications
          Cable Splicer/Cable and
  SC1C    Outside Plant Mechanic          WG10     2504   Yes       FT          1776        2087     1.0000   2087.00     $19.65       $41,009.55            0.314            $0.00        $41,009.55     $13,471.64          $0.00       $0.00          $0.00         $54,481.19     No       Yes       Cable Splicer
          4004C-Communications
          Cable Splicer/Cable and
  SC1C    Outside Plant Mechanic          WG10     2504   Yes       FT          1776        2087     1.0000   2087.00     $19.65       $41,009.55            0.314            $0.00        $41,009.55     $13,471.64          $0.00       $0.00          $0.00         $54,481.19     No       Yes       Cable Splicer
          4005A-Communications
  SC1C    Cable Splicer                   WG08     2504   Yes       FT          1776        2087     1.0000   2087.00     $18.30       $38,192.10            0.314            $0.00        $38,192.10     $12,546.10          $0.00       $0.00          $0.00         $50,738.20     No       Yes       Cable Splicer
          4005B-Communications
  SC1C    Cable Splicer                   WG08     2504   Yes       FT          1776        2087     1.0000   2087.00     $18.30       $38,192.10            0.314            $0.00        $38,192.10     $12,546.10          $0.00       $0.00          $0.00         $50,738.20     No       Yes       Cable Splicer




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                                                                                                                                               08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 2 of 40
                                                                                                                                                             LBOS Personnel Costs Worksheet


     A                    B                 C       D      E        F             G           H        I         J         K            L                M                N                 O                P             Q              R           S                  T             U         V                 W                        X

                                                                                                               Total                                                                                       Fringe                                 Other Pay
                                                                                             Paid               Paid     Basic                                                                           Benefits                      Other Pay  and Other                                      Is
                                                                             Productive     Hours              Hours     Hourly                                                                           (Col N x                     Medicare Pay Medicare      Total Personnel             Position
                                                            Position         Hours per       per    Number       for      Pay                          1st PP           Other         Basic Pay (Col     32.85% or                      (Col P x   (Col P x        Costs (Col N +    Exp or   on DOL        Position Title on
  OSC              Position Title          Grade Series EPA  Type               FTE          FTE     of FTE   Position    Rate     Salary/Wages     Prorated FTE     Entitlements       L + Col M)         7.65%)       Other Pay        0.0145)   1.0145)         Col O+ Col R)      Mix      Listing        DOL Listing               Remarks

            4006-Telecommunications
            Specialist/Radio/Specialized
            Communications/Frequency                                                                                                                                                                                                                                                                      Engineering
  SC1C      Manager                        GS09    391     No       FT          1776        2087     1.0000   2087.00     $22.68       $47,340.00            0.510            $0.00        $47,340.00      $15,551.19    $8,801.31       $127.62     $8,928.93          $71,820.12     No       Yes       Technician V
            4007A-Telecommunications                                                                                                                                                                                                                                                                      Telecommunications
  SC1C      Mechanic                       WG11    2502   Yes       FT          1776        2087     1.0000   2087.00     $20.30       $42,366.10            0.510            $0.00        $42,366.10      $13,917.26          $0.00       $0.00          $0.00         $56,283.36     No       Yes       Mechanic II
            4007B-Telecommunications                                                                                                                                                                                                                                                                      Telecommunications
  SC1C      Mechanics                      WG11    2502   Yes       FT          1776        2087     1.0000   2087.00     $20.30       $42,366.10            0.510            $0.00        $42,366.10      $13,917.26          $0.00       $0.00          $0.00         $56,283.36     No       Yes       Mechanic II
                                                                                                                                                                                                                                                                                                                                This position was added
            4007C-Telecommunications                                                                                                                                                                                                                                                                      Telecommunications    to accurately support OA
  SC1C      Mechanic                       WG11    2502   Yes       FT          1776        2087     1.0000   2087.00     $20.30       $42,366.10            0.510            $0.00        $42,366.10      $13,917.26          $0.00       $0.00          $0.00         $56,283.36    No        Yes       Mechanic II           data.
                                                                                                                                                                                                                                                                                                                                Number of hours
                                                                                                                                                                                                                                                                                                                                allocated for supervising
                                                                                                                                                                                                                                                                                                                                the MEO based on
                                                                                                                                                                                                                                                                                                                                Standard Indirect
                                                                                                                                                                                                                                                                                                                                Allowable Man-hour
                                                                                                                                                                                                                                                                                                                                (SIAM). 151.5 (1818/12)
                                                                                                                                                                                                                                                                                                                                is the monthly man-
                                                                                                                                                                                                                                                                                                                                hours for military. This
                                                                                                                                                                                                                                                                                                                                position is not prorate in
                                                                                                                                                                                                                                                                                                                                the 1st performance
                                                                                                                                                                                                                                                                                                                                period because the MEO
                                                                                                                                                                                                                                                                                                                                Director comes on at
  SC1       5001-MEO Oversight              O4             No       FT          1818        1818     0.0259    47.11      $75.73      $137,679.00         0.0259              $0.00         $3,567.48           $0.00          $0.00       $0.00          $0.00          $3,567.48    N/A       N/A                             Mobilization.
  Keesler   6001-KT Admin GS12             GS12            No       FT          1776        2087     1.0000   2087.00     $32.89       $68,651.00          0.601              $0.00        $68,641.43      $22,548.71          $0.00       $0.00          $0.00         $91,190.14    N/A       N/A
  Keesler   6002-KT Admin GS11             GS11            No       FT          1776        2087     1.0000   2087.00     $27.45       $57,280.00          0.000              $0.00        $57,288.15      $18,819.16          $0.00       $0.00          $0.00         $76,107.31    N/A       N/A
  Keesler   7001-GPC Oversight             GS09            No       FT          1776        2087     0.0133    27.83      $22.68       $47,340.00          0.008              $0.00          $631.11         $207.32           $0.00       $0.00          $0.00           $838.43     N/A       N/A

            TOTALS                                                                                  44.0392                         $2,243,545.37         21.194              $0.00      $2,062,723.54    $676,432.79   $50,955.88       $738.86    $51,694.74       $2,790,851.07




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                                                                                                                                                08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 3 of 40
                                                                      LBOS Other Entitlements Sub-worksheet
                                                          Basic                                                                                FWS: 3rd Shift
                                                          Hourly                                               FWS 2nd Shift                   Total: (Hourly        Other
                                  Position     Number      Pay       Paid         Annual          FWS 2nd     Total (Hourly Pay    FWS 3rd          Pay           Entitlements
OSC       Position Title    Grade   Type        of FTE     Rate      Hours     Salary/Wages       Shift Hrs    Rate*7.5%)*Hrs)     Shift Hrs   Rate*10%)*Hrs)    (Col J + Col L)
        1001-
        Supervisory
        Communications
        -Computer
SC1     Specialist          GS13       FT       1.0000    $39.12      2087          $81,638.00      0.00            $0.00            0.00          $0.00             $0.00
        1002-Visual
        Information
SC1     Specialist          GS11       FT       1.0000    $27.45      2087          $57,280.00      0.00            $0.00            0.00          $0.00             $0.00
        1003-Visual
        Information
SC1     Specialist          GS09       FT       1.0000    $22.68      2087          $47,340.00      0.00            $0.00            0.00          $0.00             $0.00
        1004A-
        Telecommunicati
        ons
        Specialist/Plans
SC1     Programmer          GS09       FT       1.0000    $22.68      2087          $47,340.00      0.00            $0.00            0.00          $0.00             $0.00
        1004B-
        Telecommunicati
        ons
        Specialist/Plans
SC1     Programmer          GS09       FT       1.0000    $22.68      2087          $47,340.00      0.00            $0.00            0.00          $0.00             $0.00
        1004C-
        Telecommunicati
        ons
        Specialist/Plans
SC1     Programmer          GS09       FT       1.0000    $22.68      2087          $47,340.00      0.00            $0.00            0.00          $0.00             $0.00

        1006A-Editorial
        Assistant (Office
        Automation)/Pub
        lications
SC1     Manager             GS07       FT       1.0000    $18.54      2087          $38,703.00      0.00            $0.00            0.00          $0.00             $0.00

        1006B-Editorial
        Assistant (Office
        Automation)/Pub
        lications
SC1     Manager             GS07       FT       1.0000    $18.54      2087          $38,703.00      0.00            $0.00            0.00          $0.00             $0.00




      For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                             08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 4 of 40
                                                                      LBOS Other Entitlements Sub-worksheet
                                                          Basic                                                                                FWS: 3rd Shift
                                                          Hourly                                               FWS 2nd Shift                   Total: (Hourly        Other
                                 Position      Number      Pay       Paid         Annual          FWS 2nd     Total (Hourly Pay    FWS 3rd          Pay           Entitlements
OSC       Position Title   Grade   Type         of FTE     Rate      Hours     Salary/Wages       Shift Hrs    Rate*7.5%)*Hrs)     Shift Hrs   Rate*10%)*Hrs)    (Col J + Col L)
        1007A-
        Computer
        Inventory
        Control
        Techician/Equip
        ment Control
SC1     Officer            GS06        FT       1.0000    $16.69      2087          $34,829.00      0.00            $0.00            0.00          $0.00             $0.00
        1007B-
        Computer
        Inventory
        Control
        Techician/Equip
        ment Control
SC1     Officer            GS06        FT       1.0000    $16.69      2087          $34,829.00      0.00            $0.00            0.00          $0.00             $0.00
        1008-Secretary
        (Office
SC1     Automation)        GS05        FT       1.0000    $14.97      2087          $31,247.00      0.00            $0.00            0.00          $0.00             $0.00
        1009-Budget
        Technician
        (Office
SC1     Automation)        GS05        FT       1.0000    $14.97      2087          $31,247.00      0.00            $0.00            0.00          $0.00             $0.00
        2001-
        Supervisory
        Computer
        Assistant/Help
SC1A    Desk Specialist    GS09        FT       1.0000    $22.68      2087          $47,340.00      0.00            $0.00            0.00          $0.00             $0.00
        2002A-
        Computer
        Assistant/Help
SC1A    Desk Specialist    GS07        FT       1.0000    $18.54      2087          $38,703.00      0.00            $0.00            0.00          $0.00             $0.00
        2002B-
        Computer
        Assistant/Help
SC1A    Desk Specialist    GS07        FT       1.0000    $18.54      2087          $38,703.00      0.00            $0.00            0.00          $0.00             $0.00
        2002C-
        Computer
        Assistant/Help
SC1A    Desk Specialist    GS07        FT       1.0000    $18.54      2087          $38,703.00      0.00            $0.00            0.00          $0.00             $0.00




      For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                             08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 5 of 40
                                                                   LBOS Other Entitlements Sub-worksheet
                                                       Basic                                                                                FWS: 3rd Shift
                                                       Hourly                                               FWS 2nd Shift                   Total: (Hourly        Other
                                Position    Number      Pay       Paid         Annual          FWS 2nd     Total (Hourly Pay    FWS 3rd          Pay           Entitlements
OSC   Position Title      Grade   Type       of FTE     Rate      Hours     Salary/Wages       Shift Hrs    Rate*7.5%)*Hrs)     Shift Hrs   Rate*10%)*Hrs)    (Col J + Col L)
     2002D-
     Computer
     Assistant/Help
SC1A Desk Specialist      GS07      FT       1.0000    $18.54      2087          $38,703.00      0.00            $0.00            0.00          $0.00             $0.00
     2002E-
     Computer
     Assistant/Help
SC1A Desk Specialist      GS07      FT       1.0000    $18.54      2087          $38,703.00      0.00            $0.00            0.00          $0.00             $0.00
     2002F-
     Computer
     Assistant/Help
SC1A Desk Specialist      GS07      FT       1.0000    $18.54      2087          $38,703.00      0.00            $0.00            0.00          $0.00             $0.00

       3001-
       Supervisory
       Information
       Technology
       Specialist/Netwo
       rk Services
SC1B   Branch Manager     IT12      FT       1.0000    $33.27      2087          $69,437.00      0.00            $0.00            0.00          $0.00             $0.00
       3002-
       Information
       Technology
       Specialist
       (Network
SC1B   Services)          IT11      FT       1.0000    $28.99      2087          $60,500.00      0.00            $0.00            0.00          $0.00             $0.00
       3003-
       Information
       Technology
       Specialist
       (Systems
SC1B   Administration)    IT11      FT       1.0000    $28.99      2087          $60,500.00      0.00            $0.00            0.00          $0.00             $0.00
       3004A-
       Information
       Technology
       Specialist
       (Security)/Wing
       Assistant
       Information
       Assurance
SC1B   Manager            IT09      FT       1.0000    $26.39      2087          $55,086.00      0.00            $0.00            0.00          $0.00             $0.00

   For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                             08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 6 of 40
                                                                  LBOS Other Entitlements Sub-worksheet
                                                      Basic                                                                                FWS: 3rd Shift
                                                      Hourly                                               FWS 2nd Shift                   Total: (Hourly        Other
                             Position      Number      Pay       Paid         Annual          FWS 2nd     Total (Hourly Pay    FWS 3rd          Pay           Entitlements
OSC      Position TitleGrade   Type         of FTE     Rate      Hours     Salary/Wages       Shift Hrs    Rate*7.5%)*Hrs)     Shift Hrs   Rate*10%)*Hrs)    (Col J + Col L)
       3004B-
       Information
       Technology
       Specialist
       (Security)/Wing
       Assistant
       Information
       Assurance
SC1B   Manager          IT09       FT       1.0000    $26.39      2087          $55,086.00      0.00            $0.00            0.00          $0.00             $0.00
       3005A-
       Information
       Technology
       Specialist
       (Network
       Services/Custom
SC1B   er Support)      IT09       FT       1.0000    $26.39      2087          $55,086.00      0.00            $0.00            0.00          $0.00             $0.00
       3005B-
       Information
       Technology
       Specialist
       (Network
       Services/Custom
SC1B   er Support)      IT09       FT       1.0000    $26.39      2087          $55,086.00      0.00            $0.00            0.00          $0.00             $0.00
       3005C-
       Information
       Technology
       Specialist
       (Network
       Services/Custom
SC1B   er Support)      IT09       FT       1.0000    $26.39      2087          $55,086.00      0.00            $0.00            0.00          $0.00             $0.00
       3005D-
       Information
       Technology
       Specialist
       (Network
       Services/Custom
SC1B   er Support)      IT09       FT       1.0000    $26.39      2087          $55,086.00      0.00            $0.00            0.00          $0.00             $0.00
       3006-Computer
       Assistant/Web
SC1B   Developer        GS07       FT       1.0000    $18.54      2087          $38,703.00      0.00            $0.00            0.00          $0.00             $0.00


  For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                             08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 7 of 40
                                                                  LBOS Other Entitlements Sub-worksheet
                                                      Basic                                                                                FWS: 3rd Shift
                                                      Hourly                                               FWS 2nd Shift                   Total: (Hourly        Other
                               Position    Number      Pay       Paid         Annual          FWS 2nd     Total (Hourly Pay    FWS 3rd          Pay           Entitlements
OSC     Position Title   Grade   Type       of FTE     Rate      Hours     Salary/Wages       Shift Hrs    Rate*7.5%)*Hrs)     Shift Hrs   Rate*10%)*Hrs)    (Col J + Col L)

       4001-
       Communications
       Cable Splicer
       Supervisor/Base
       Communications
       Services
SC1C   Supervisor        WS09      FT       1.0000    $24.86      2087          $51,882.82      0.00            $0.00            0.00          $0.00             $0.00
       4002A-
       Telecommunicati
SC1C   ons Mechanic      WG11      FT       1.0000    $20.30      2087          $42,366.10      0.00            $0.00            0.00          $0.00             $0.00
       4002B-
       Telecommunicati
SC1C   ons Mechanic      WG11      FT       1.0000    $20.30      2087          $42,366.10      0.00            $0.00            0.00          $0.00             $0.00
       4003-
       Communication
       Cable Splicer
       Leader/Cable
       and Outside
SC1C   Plant Mechanic    WL10      FT       1.0000    $21.60      2087          $45,079.20      0.00            $0.00            0.00          $0.00             $0.00
       4004A-
       Communications
       Cable
       Splicer/Cable
       and Outside
SC1C   Plant Mechanic    WG10      FT       1.0000    $19.65      2087          $41,009.55      0.00            $0.00            0.00          $0.00             $0.00
       4004B-
       Communications
       Cable
       Splicer/Cable
       and Outside
SC1C   Plant Mechanic    WG10      FT       1.0000    $19.65      2087          $41,009.55      0.00            $0.00            0.00          $0.00             $0.00
       4004C-
       Communications
       Cable
       Splicer/Cable
       and Outside
SC1C   Plant Mechanic    WG10      FT       1.0000    $19.65      2087          $41,009.55      0.00            $0.00            0.00          $0.00             $0.00
       4005A-
       Communications
SC1C   Cable Splicer     WG08      FT       1.0000    $18.30      2087          $38,192.10      0.00            $0.00            0.00          $0.00             $0.00

  For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                             08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 8 of 40
                                                                   LBOS Other Entitlements Sub-worksheet
                                                       Basic                                                                                FWS: 3rd Shift
                                                       Hourly                                               FWS 2nd Shift                   Total: (Hourly        Other
                              Position      Number      Pay       Paid         Annual          FWS 2nd     Total (Hourly Pay    FWS 3rd          Pay           Entitlements
OSC   Position Title    Grade   Type         of FTE     Rate      Hours     Salary/Wages       Shift Hrs    Rate*7.5%)*Hrs)     Shift Hrs   Rate*10%)*Hrs)    (Col J + Col L)
     4005B-
     Communications
SC1C Cable Splicer     WG08         FT       1.0000    $18.30      2087          $38,192.10      0.00            $0.00            0.00          $0.00             $0.00
     4006-
     Telecommunicati
     ons
     Specialist/Radio/
     Specialized
     Communications
     /Frequency
SC1C Manager           GS09         FT       1.0000    $22.68      2087          $47,340.00      0.00            $0.00            0.00          $0.00             $0.00
     4007A-
     Telecommunicati
SC1C ons Mechanic      WG11         FT       1.0000    $20.30      2087          $42,366.10      0.00            $0.00            0.00          $0.00             $0.00

     4007B-
     Telecommunicati
SC1C ons Mechanics      WG11        FT       1.0000    $20.30      2087          $42,366.10      0.00            $0.00            0.00          $0.00             $0.00
     4007C-
     Telecommunicati
SC1C ons Mechanic       WG11        FT       1.0000    $20.30      2087          $42,366.10      0.00            $0.00            0.00          $0.00             $0.00
     5001-MEO
     Oversight            O4                 0.0259    $75.73      1818        $137,679.00       0.00            $0.00            0.00          $0.00             $0.00
     6001-KT Admin
     GS12               GS12                 1.0000    $32.89      2087          $68,651.00      0.00            $0.00            0.00          $0.00             $0.00
     6002-KT Admin
     GS11               GS11                 1.0000    $27.45      2087          $57,280.00      0.00            $0.00            0.00          $0.00             $0.00
     7001-GPC
     Oversight          GS09                 0.0133    $22.68      2087          $47,340.00      0.00            $0.00            0.00          $0.00             $0.00


      TOTALS                                44.0392                           $2,243,545.37      0.00            $0.00            0.00          $0.00             $0.00




   For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                             08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 9 of 40
                                                                              LBOS Other Pay Sub-Worksheet (Night Differential only)


                                                                                                            GS 2nd Shift
                                                          Basic                                             Total (Hourly            GS: 3rd Shift       Other Pay (Night
                                    Position Number       Hourly      Paid                       GS 2nd         Pay       GS: 3rd Total: (Hourly Pay     Differential only)
OSC      Position Title    Grade     Type     of FTE     Pay Rate     Hours      Salary/Wages    Shift Hrs Rate*10%)*Hrs) Shift Hrs Rate*10%)*Hrs)        (Col I + Col K)            Remarks
      1001-Supervisory
      Communications-
      Computer
SC1   Specialist            GS13       FT       1.0000    $39.12       2087       $81,638.00       0.00          $0.00          0.00     $0.00                 $0.00
      1002-Visual
      Information
SC1   Specialist            GS11       FT       1.0000    $27.45       2087       $57,280.00       0.00          $0.00          0.00     $0.00                 $0.00
      1003-Visual
      Information
SC1   Specialist            GS09       FT       1.0000    $22.68       2087       $47,340.00       0.00          $0.00          0.00     $0.00                 $0.00

      1004A-
      Telecommunication
      s Specialist/Plans
SC1   Programmer            GS09       FT       1.0000    $22.68       2087       $47,340.00       0.00          $0.00          0.00     $0.00                 $0.00

      1004B-
      Telecommunication
      s Specialist/Plans
SC1   Programmer            GS09       FT       1.0000    $22.68       2087       $47,340.00       0.00          $0.00          0.00     $0.00                 $0.00

      1004C-
      Telecommunication
      s Specialist/Plans
SC1   Programmer            GS09       FT       1.0000    $22.68       2087       $47,340.00       0.00          $0.00          0.00     $0.00                 $0.00
      1006A-Editorial
      Assistant (Office
      Automation)/Public
SC1   ations Manager        GS07       FT       1.0000    $18.54       2087       $38,703.00       0.00          $0.00          0.00     $0.00                 $0.00
      1006B-Editorial
      Assistant (Office
      Automation)/Public
SC1   ations Manager        GS07       FT       1.0000    $18.54       2087       $38,703.00       0.00          $0.00          0.00     $0.00                 $0.00
      1007A-Computer
      Inventory Control
      Techician/Equipme
SC1   nt Control Officer    GS06       FT       1.0000    $16.69       2087       $34,829.00       0.00          $0.00          0.00     $0.00                 $0.00

For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                              08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 10 of 40
                                                                              LBOS Other Pay Sub-Worksheet (Night Differential only)


                                                                                                            GS 2nd Shift
                                                          Basic                                             Total (Hourly            GS: 3rd Shift       Other Pay (Night
                                    Position Number       Hourly      Paid                       GS 2nd         Pay       GS: 3rd Total: (Hourly Pay     Differential only)
OSC      Position Title    Grade     Type     of FTE     Pay Rate     Hours      Salary/Wages    Shift Hrs Rate*10%)*Hrs) Shift Hrs Rate*10%)*Hrs)        (Col I + Col K)                 Remarks
      1007B-Computer
      Inventory Control
      Techician/Equipme
SC1   nt Control Officer    GS06       FT       1.0000    $16.69       2087       $34,829.00       0.00          $0.00          0.00     $0.00                 $0.00

     1008-Secretary
SC1  (Office Automation)    GS05       FT       1.0000    $14.97       2087       $31,247.00       0.00          $0.00          0.00     $0.00                 $0.00
     1009-Budget
     Technician (Office
SC1 Automation)             GS05       FT       1.0000    $14.97       2087       $31,247.00       0.00          $0.00          0.00     $0.00                 $0.00
     2001-Supervisory
     Computer
     Assistant/Help
SC1A Desk Specialist        GS09       FT       1.0000    $22.68       2087       $47,340.00       0.00          $0.00          0.00     $0.00                 $0.00
     2002A-Computer
     Assistant/Help
SC1A Desk Specialist        GS07       FT       1.0000    $18.54       2087       $38,703.00       0.00          $0.00          0.00     $0.00                 $0.00
                                                                                                                                                                              Shift differential was calculated
                                                                                                                                                                              as: 365.25 days/year x 12
     2002B-Computer                                                                                                                                                           hours = 4,383 hours/4 =
     Assistant/Help                                                                                                                                                           1095.75 hours per
SC1A Desk Specialist        GS07       FT       1.0000    $18.54       2087       $38,703.00      1095.75      $2,031.52        0.00     $0.00               $2,031.52        year/employee
                                                                                                                                                                              Shift differential was calculated
                                                                                                                                                                              as: 365.25 days/year x 12
     2002C-Computer                                                                                                                                                           hours = 4,383 hours/4 =
     Assistant/Help                                                                                                                                                           1095.75 hours per
SC1A Desk Specialist        GS07       FT       1.0000    $18.54       2087       $38,703.00      1095.75      $2,031.52        0.00     $0.00               $2,031.52        year/employee
                                                                                                                                                                              Shift differential was calculated
                                                                                                                                                                              as: 365.25 days/year x 12
     2002D-Computer                                                                                                                                                           hours = 4,383 hours/4 =
     Assistant/Help                                                                                                                                                           1095.75 hours per
SC1A Desk Specialist        GS07       FT       1.0000    $18.54       2087       $38,703.00      1095.75      $2,031.52        0.00     $0.00               $2,031.52        year/employee
                                                                                                                                                                              Shift differential was calculated
                                                                                                                                                                              as: 365.25 days/year x 12
     2002E-Computer                                                                                                                                                           hours = 4,383 hours/4 =
     Assistant/Help                                                                                                                                                           1095.75 hours per
SC1A Desk Specialist        GS07       FT       1.0000    $18.54       2087       $38,703.00      1095.75      $2,031.52        0.00     $0.00               $2,031.52        year/employee

For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                              08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 11 of 40
                                                                              LBOS Other Pay Sub-Worksheet (Night Differential only)


                                                                                                            GS 2nd Shift
                                                          Basic                                             Total (Hourly            GS: 3rd Shift       Other Pay (Night
                                    Position Number       Hourly      Paid                       GS 2nd         Pay       GS: 3rd Total: (Hourly Pay     Differential only)
OSC     Position Title     Grade     Type     of FTE     Pay Rate     Hours      Salary/Wages    Shift Hrs Rate*10%)*Hrs) Shift Hrs Rate*10%)*Hrs)        (Col I + Col K)                 Remarks
     2002F-Computer
     Assistant/Help
SC1A Desk Specialist        GS07       FT       1.0000    $18.54       2087       $38,703.00       0.00          $0.00          0.00     $0.00                 $0.00
     3001-Supervisory
     Information
     Technology
     Specialist/Network
     Services Branch
SC1B Manager                IT12       FT       1.0000    $33.27       2087       $69,437.00       0.00          $0.00          0.00     $0.00                 $0.00

     3002-Information                                                                                                                                                         Shift differential was calculated
     Technology                                                                                                                                                               as: 52.18 weeks/year x 30
     Specialist (Network                                                                                                                                                      hours = 1,565.4 hours/6 =
SC1B Services)              IT11       FT       1.0000    $28.99       2087       $60,500.00      260.90        $756.35         0.00     $0.00                $756.35         260.90 per employee.
     3003-Information
     Technology                                                                                                                                                               Shift differential was calculated
     Specialist                                                                                                                                                               as: 52.18 weeks/year x 30
     (Systems                                                                                                                                                                 hours = 1,565.4 hours/6 =
SC1B Administration)        IT11       FT       1.0000    $28.99       2087       $60,500.00      260.90        $756.35         0.00     $0.00                $756.35         260.90 per employee.

     3004A-Information
     Technology
     Specialist
     (Security)/Wing
     Assistant
     Information
SC1B Assurance Manager      IT09       FT       1.0000    $26.39       2087       $55,086.00       0.00          $0.00          0.00     $0.00                 $0.00

     3004B-Information
     Technology
     Specialist
     (Security)/Wing
     Assistant
     Information
SC1B Assurance Manager      IT09       FT       1.0000    $26.39       2087       $55,086.00       0.00          $0.00          0.00     $0.00                 $0.00




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                              08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 12 of 40
                                                                              LBOS Other Pay Sub-Worksheet (Night Differential only)


                                                                                                            GS 2nd Shift
                                                          Basic                                             Total (Hourly            GS: 3rd Shift       Other Pay (Night
                                    Position Number       Hourly      Paid                       GS 2nd         Pay       GS: 3rd Total: (Hourly Pay     Differential only)
OSC     Position Title     Grade     Type     of FTE     Pay Rate     Hours      Salary/Wages    Shift Hrs Rate*10%)*Hrs) Shift Hrs Rate*10%)*Hrs)        (Col I + Col K)                 Remarks

     3005A-Information
     Technology                                                                                                                                                               Shift differential was calculated
     Specialist (Network                                                                                                                                                      as: 52.18 weeks/year x 30
     Services/Customer                                                                                                                                                        hours = 1,565.4 hours/6 =
SC1B Support)               IT09       FT       1.0000    $26.39       2087       $55,086.00      260.90        $688.52         0.00     $0.00                $688.52         260.90 per employee.

     3005B-Information
     Technology                                                                                                                                                               Shift differential was calculated
     Specialist (Network                                                                                                                                                      as: 52.18 weeks/year x 30
     Services/Customer                                                                                                                                                        hours = 1,565.4 hours/6 =
SC1B Support)               IT09       FT       1.0000    $26.39       2087       $55,086.00      260.90        $688.52         0.00     $0.00                $688.52         260.90 per employee.

     3005C-Information
     Technology                                                                                                                                                               Shift differential was calculated
     Specialist (Network                                                                                                                                                      as: 52.18 weeks/year x 30
     Services/Customer                                                                                                                                                        hours = 1,565.4 hours/6 =
SC1B Support)               IT09       FT       1.0000    $26.39       2087       $55,086.00      260.90        $688.52         0.00     $0.00                $688.52         260.90 per employee.

     3005D-Information
     Technology                                                                                                                                                               Shift differential was calculated
     Specialist (Network                                                                                                                                                      as: 52.18 weeks/year x 30
     Services/Customer                                                                                                                                                        hours = 1,565.4 hours/6 =
SC1B Support)               IT09       FT       1.0000    $26.39       2087       $55,086.00      260.90        $688.52         0.00     $0.00                $688.52         260.90 per employee.
     3006-Computer
     Assistant/Web
SC1B Developer              GS07       FT       1.0000    $18.54       2087       $38,703.00       0.00          $0.00          0.00     $0.00                 $0.00

     4001-
     Communications
     Cable Splicer
     Supervisor/Base
     Communications
SC1C Services Supervisor WS09          FT       1.0000    $24.86       2087       $51,882.82       0.00          $0.00          0.00     $0.00                 $0.00
     4002A-
     Telecommunication
SC1C s Mechanic          WG11          FT       1.0000    $20.30       2087       $42,366.10       0.00          $0.00          0.00     $0.00                 $0.00

For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                              08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 13 of 40
                                                                              LBOS Other Pay Sub-Worksheet (Night Differential only)


                                                                                                            GS 2nd Shift
                                                          Basic                                             Total (Hourly            GS: 3rd Shift       Other Pay (Night
                                    Position Number       Hourly      Paid                       GS 2nd         Pay       GS: 3rd Total: (Hourly Pay     Differential only)
OSC       Position Title   Grade     Type     of FTE     Pay Rate     Hours      Salary/Wages    Shift Hrs Rate*10%)*Hrs) Shift Hrs Rate*10%)*Hrs)        (Col I + Col K)            Remarks
       4002B-
       Telecommunication
SC1C   s Mechanic          WG11        FT       1.0000    $20.30       2087       $42,366.10       0.00          $0.00          0.00     $0.00                 $0.00
       4003-
       Communication
       Cable Splicer
       Leader/Cable and
       Outside Plant
SC1C   Mechanic             WL10       FT       1.0000    $21.60       2087       $45,079.20       0.00          $0.00          0.00     $0.00                 $0.00
       4004A-
       Communications
       Cable
       Splicer/Cable and
       Outside Plant
SC1C   Mechanic            WG10        FT       1.0000    $19.65       2087       $41,009.55       0.00          $0.00          0.00     $0.00                 $0.00
       4004B-
       Communications
       Cable
       Splicer/Cable and
       Outside Plant
SC1C   Mechanic            WG10        FT       1.0000    $19.65       2087       $41,009.55       0.00          $0.00          0.00     $0.00                 $0.00
       4004C-
       Communications
       Cable
       Splicer/Cable and
       Outside Plant
SC1C   Mechanic            WG10        FT       1.0000    $19.65       2087       $41,009.55       0.00          $0.00          0.00     $0.00                 $0.00
       4005A-
       Communications
SC1C   Cable Splicer       WG08        FT       1.0000    $18.30       2087       $38,192.10       0.00          $0.00          0.00     $0.00                 $0.00
       4005B-
       Communications
SC1C   Cable Splicer       WG08        FT       1.0000    $18.30       2087       $38,192.10       0.00          $0.00          0.00     $0.00                 $0.00




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                              08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 14 of 40
                                                                              LBOS Other Pay Sub-Worksheet (Night Differential only)


                                                                                                            GS 2nd Shift
                                                          Basic                                             Total (Hourly            GS: 3rd Shift       Other Pay (Night
                                     Position Number      Hourly      Paid                       GS 2nd         Pay       GS: 3rd Total: (Hourly Pay     Differential only)
OSC       Position Title     Grade    Type     of FTE    Pay Rate     Hours      Salary/Wages    Shift Hrs Rate*10%)*Hrs) Shift Hrs Rate*10%)*Hrs)        (Col I + Col K)            Remarks
       4006-
       Telecommunication
       s
       Specialist/Radio/Sp
       ecialized
       Communications/Fr
SC1C   equency Manager       GS09      FT       1.0000    $22.68       2087       $47,340.00       0.00          $0.00          0.00     $0.00                 $0.00
       4007A-
       Telecommunication
SC1C   s Mechanic            WG11      FT       1.0000    $20.30       2087       $42,366.10       0.00          $0.00          0.00     $0.00                 $0.00
       4007B-
       Telecommunication
SC1C   s Mechanics           WG11      FT       1.0000    $20.30       2087       $42,366.10       0.00          $0.00          0.00     $0.00                 $0.00
       4007C-
       Telecommunication
SC1C   s Mechanic            WG11      FT       1.0000    $20.30       2087       $42,366.10       0.00          $0.00          0.00     $0.00                 $0.00
       5001-MEO
       Oversight              O4       FT       0.0259    $75.73       1818       $137,679.00      0.00          $0.00          0.00     $0.00                 $0.00
       6001-KT Admin
       GS12                  GS12      FT       1.0000    $32.89       2087       $68,651.00       0.00          $0.00          0.00     $0.00                 $0.00
       6002-KT Admin
       GS11                  GS11      FT       1.0000    $27.45       2087       $57,280.00       0.00          $0.00          0.00     $0.00                 $0.00
       7001-GPC
       Oversight             GS09      FT       0.0133    $22.68       2087       $47,340.00       0.00          $0.00          0.00     $0.00                 $0.00

       TOTALS                                  44.0392                           $2,243,545.37   5,948.40     $12,392.86        0.00     $0.00              $12,392.86




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                              08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 15 of 40
                                                                                                      LBOS Other Pay All Sub-Worksheet (Including Night Differential)

                                                                                                                                               Total Sunday
                                                                                                                                               Premium Pay
                                  Basic                     OT                 OT Total Cost             Total Holiday Shift                   (Basic Hourly                    Other Pay (Col H +    Medicare      Other Pay &
                                  Hourly  Number           Hourly               (OT Hourly    Holiday    Cost (Basic Hourly        Sunday       Rate x .25 x       Night        Col J + Col L + Col   (Col O x    Medicare (Col O +
OSC      Position Title    Grade Pay Rate of FTE          Pay Rate    OT Hours rate x Hours) Shift Hours   Rate x Hours)            Hours         Hours)        Differential        M + Col N)         1.45%)          Col P)                        Remarks
      1001-Supervisory
      Communications-
      Computer
SC1   Specialist           GS13     $39.12      1.0000     $39.12          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
      1002-Visual
      Information
SC1   Specialist           GS11     $27.45      1.0000     $33.06          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
      1003-Visual
      Information
SC1   Specialist           GS09     $22.68      1.0000     $33.06          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00

                                                                                                                                                                                                                                     Overtime hours broken out between
                                                                                                                                                                                                                                     PD# 1004 A/B/C equals 15.274 monthly
      1004A-                                                                                                                                                                                                                         hours per position.  OA directed OT is
      Telecommunication                                                                                                                                                                                                              based on 0.3096 FTE of OT monthly or
      s Specialist/Plans                                                                                                                                                                                                             45.821 monthly hours *12 months =
SC1   Programmer         GS09       $22.68      1.0000     $33.06        183.288        $6,059.50     0.00                 $0.00        0.00            $0.00           $0.00             $6,059.50      $87.86            $6,147.36 183.288 hours per year per position.

                                                                                                                                                                                                                                     Overtime hours broken out between
                                                                                                                                                                                                                                     PD# 1004 A/B/C equals 15.274 monthly
      1004B-                                                                                                                                                                                                                         hours per position.  OA directed OT is
      Telecommunication                                                                                                                                                                                                              based on 0.3096 FTE of OT monthly or
      s Specialist/Plans                                                                                                                                                                                                             45.821 monthly hours *12 months =
SC1   Programmer         GS09       $22.68      1.0000     $33.06        183.288        $6,059.50     0.00                 $0.00        0.00            $0.00           $0.00             $6,059.50      $87.86            $6,147.36 183.288 hours per year per position.

                                                                                                                                                                                                                                     Overtime hours broken out between
                                                                                                                                                                                                                                     PD# 1004 A/B/C equals 15.274 monthly
      1004C-                                                                                                                                                                                                                         hours per position.  OA directed OT is
      Telecommunication                                                                                                                                                                                                              based on 0.3096 FTE of OT monthly or
      s Specialist/Plans                                                                                                                                                                                                             45.821 monthly hours *12 months =
SC1   Programmer           GS09     $22.68      1.0000     $33.06        183.288        $6,059.50     0.00                 $0.00        0.00            $0.00           $0.00             $6,059.50      $87.86            $6,147.36 183.288 hours per year per position.
      1006A-Editorial
      Assistant (Office
      Automation)/Public                                                                                                                                                                                                             Currently this workcenter has two
SC1   ations Manager       GS07     $18.54      1.0000     $27.81          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00 positions and no historical OT.
      1006B-Editorial
      Assistant (Office
      Automation)/Public                                                                                                                                                                                                             Currently this workcenter has two
SC1   ations Manager       GS07     $18.54      1.0000     $27.81          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00 positions and no historical OT.
      1007A-Computer
      Inventory Control
      Techician/Equipme
SC1   nt Control Officer   GS06     $16.69      1.0000     $25.04          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
      1007B-Computer
      Inventory Control
      Techician/Equipme
SC1   nt Control Officer   GS06     $16.69      1.0000     $25.04          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00




  For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                                                           08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 16 of 40
                                                                                                       LBOS Other Pay All Sub-Worksheet (Including Night Differential)

                                                                                                                                                Total Sunday
                                                                                                                                                Premium Pay
                                  Basic                      OT                 OT Total Cost             Total Holiday Shift                   (Basic Hourly                    Other Pay (Col H +    Medicare      Other Pay &
                                  Hourly  Number            Hourly               (OT Hourly    Holiday    Cost (Basic Hourly        Sunday       Rate x .25 x       Night        Col J + Col L + Col   (Col O x    Medicare (Col O +
OSC     Position Title     Grade Pay Rate of FTE           Pay Rate    OT Hours rate x Hours) Shift Hours   Rate x Hours)            Hours         Hours)        Differential        M + Col N)         1.45%)          Col P)                       Remarks

     1008-Secretary
SC1  (Office Automation)    GS05     $14.97      1.0000     $22.46          0.000              $0.00    0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
     1009-Budget
     Technician (Office
SC1 Automation)             GS05     $14.97      1.0000     $22.46          0.000              $0.00    0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
     2001-Supervisory
     Computer
     Assistant/Help
SC1A Desk Specialist        GS09     $22.68      1.0000     $33.06          0.000              $0.00    0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
     2002A-Computer
     Assistant/Help
SC1A Desk Specialist        GS07     $18.54      1.0000     $27.81          0.000              $0.00    0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00

                                                                                                                                                                                                                                      The Help Desk operates 24X7;
                                                                                                                                                                                                                                      therefore, one worker will be scheduled
                                                                                                                                                                                                                                      for a 8-hour shift. There are ten paid
                                                                                                                                                                                                                                      holidays. Holiday premium: 8 hours x 10
     2002B-Computer                                                                                                                                                                                                                   holidays = 80 hours per year/per shift.
     Assistant/Help                                                                                                                                                                                                                   Sunday premium: 52.18 sundays x 8
SC1A Desk Specialist        GS07     $18.54      1.0000     $27.81          0.000              $0.00   80.00           $1,483.20      417.44         $1,934.83     $2,031.52               $5,449.55      $79.02            $5,528.57 hours = 417.44 hours per worker.

                                                                                                                                                                                                                                      The Help Desk operates 24X7;
                                                                                                                                                                                                                                      therefore, one worker will be scheduled
                                                                                                                                                                                                                                      for a 8-hour shift. There are ten paid
                                                                                                                                                                                                                                      holidays. Holiday premium: 8 hours x 10
     2002C-Computer                                                                                                                                                                                                                   holidays = 80 hours per year/per shift.
     Assistant/Help                                                                                                                                                                                                                   Sunday premium: 52.18 sundays x 8
SC1A Desk Specialist        GS07     $18.54      1.0000     $27.81          0.000              $0.00   80.00           $1,483.20      417.44         $1,934.83     $2,031.52               $5,449.55      $79.02            $5,528.57 hours = 417.44 hours per worker.

                                                                                                                                                                                                                                      The Help Desk operates 24X7;
                                                                                                                                                                                                                                      therefore, one worker will be scheduled
                                                                                                                                                                                                                                      for a 8-hour shift. There are ten paid
                                                                                                                                                                                                                                      holidays. Holiday premium: 8 hours x 10
     2002D-Computer                                                                                                                                                                                                                   holidays = 80 hours per year/per shift.
     Assistant/Help                                                                                                                                                                                                                   Sunday premium: 52.18 sundays x 8
SC1A Desk Specialist        GS07     $18.54      1.0000     $27.81          0.000              $0.00   80.00           $1,483.20      417.44         $1,934.83     $2,031.52               $5,449.55      $79.02            $5,528.57 hours = 417.44 hours per worker.




     2002E-Computer
     Assistant/Help
SC1A Desk Specialist        GS07     $18.54      1.0000     $27.81          0.000              $0.00    0.00                $0.00        0.00            $0.00     $2,031.52               $2,031.52      $29.46            $2,060.98
     2002F-Computer
     Assistant/Help
SC1A Desk Specialist        GS07     $18.54      1.0000     $27.81          0.000              $0.00    0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00


   For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                                                           08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 17 of 40
                                                                                                       LBOS Other Pay All Sub-Worksheet (Including Night Differential)

                                                                                                                                                Total Sunday
                                                                                                                                                Premium Pay
                                  Basic                      OT                 OT Total Cost             Total Holiday Shift                   (Basic Hourly                    Other Pay (Col H +    Medicare      Other Pay &
                                  Hourly  Number            Hourly               (OT Hourly    Holiday    Cost (Basic Hourly        Sunday       Rate x .25 x       Night        Col J + Col L + Col   (Col O x    Medicare (Col O +
OSC     Position Title     Grade Pay Rate of FTE           Pay Rate    OT Hours rate x Hours) Shift Hours   Rate x Hours)            Hours         Hours)        Differential        M + Col N)         1.45%)          Col P)                        Remarks
     3001-Supervisory
     Information
     Technology                                                                                                                                                                                                                       Overtime hours from PRD were used to
     Specialist/Network                                                                                                                                                                                                               staff this section. No additional OT is
     Services Branch                                                                                                                                                                                                                  expected because 1 FTE was moved to
SC1B Manager                IT12     $33.27      1.0000     $33.06          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00 swings.

     3002-Information
     Technology                                                                                                                                                                                                                       Routine server maint 3rd Sunday each
     Specialist                                                                                                                                                                                                                       month; Sunday premium was computed
SC1B (Network Services)     IT11     $28.99      1.0000     $33.06          0.000              $0.00   0.00                 $0.00       96.00          $695.76       $756.35               $1,452.11      $21.06            $1,473.17 as follows: 12 months x 8 hours = 96
     3003-Information
     Technology                                                                                                                                                                                                                      Overtime hours from PRD were used to
     Specialist                                                                                                                                                                                                                      staff this section. No additional OT is
     (Systems                                                                                                                                                                                                                        expected because 1 FTE was moved to
SC1B Administration)        IT11     $28.99      1.0000     $33.06          0.000              $0.00   0.00                 $0.00        0.00            $0.00       $756.35                 $756.35      $10.97             $767.32 swings.

     3004A-Information
     Technology
     Specialist
     (Security)/Wing
     Assistant                                                                                                                                                                                                                        Overtime hours from PRD was used to
     Information                                                                                                                                                                                                                      staff this section. No additional OT is
     Assurance                                                                                                                                                                                                                        expected because 1 FTE was moved to
SC1B Manager                IT09     $26.39      1.0000     $33.06          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00 swings.

     3004B-Information
     Technology
     Specialist
     (Security)/Wing
     Assistant                                                                                                                                                                                                                        Overtime hours from PRD were used to
     Information                                                                                                                                                                                                                      staff this section. No additional OT is
     Assurance                                                                                                                                                                                                                        expected because 1 FTE was moved to
SC1B Manager                IT09     $26.39      1.0000     $33.06          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00 swings.

     3005A-Information                                                                                                                                                                                                               Working 1500 to 0000 5 days per week
     Technology                                                                                                                                                                                                                      (CWS). This position was moved to
     Specialist                                                                                                                                                                                                                      swing shift to cover any work due to day
     (Network                                                                                                                                                                                                                        hot issues that require after hour support
     Services/Customer                                                                                                                                                                                                               or overtime. Overtime hours from PRD
SC1B Support)               IT09     $26.39      1.0000     $33.06          0.000              $0.00   0.00                 $0.00        0.00            $0.00       $688.52                 $688.52       $9.98             $698.50 were used to staff this section.

     3005B-Information
     Technology
     Specialist
     (Network                                                                                                                                                                                                                         Routine server maint 3rd Sunday each
     Services/Customer                                                                                                                                                                                                                month; Sunday premium was computed
SC1B Support)               IT09     $26.39      1.0000     $33.06          0.000              $0.00   0.00                 $0.00       96.00          $633.36       $688.52               $1,321.88      $19.17            $1,341.05 as follows: 12 months x 8 hours = 96



   For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                                                           08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 18 of 40
                                                                                                       LBOS Other Pay All Sub-Worksheet (Including Night Differential)

                                                                                                                                                Total Sunday
                                                                                                                                                Premium Pay
                                  Basic                      OT                 OT Total Cost             Total Holiday Shift                   (Basic Hourly                    Other Pay (Col H +    Medicare      Other Pay &
                                  Hourly  Number            Hourly               (OT Hourly    Holiday    Cost (Basic Hourly        Sunday       Rate x .25 x       Night        Col J + Col L + Col   (Col O x    Medicare (Col O +
OSC      Position Title    Grade Pay Rate of FTE           Pay Rate    OT Hours rate x Hours) Shift Hours   Rate x Hours)            Hours         Hours)        Differential        M + Col N)         1.45%)          Col P)                      Remarks

     3005C-Information
     Technology
     Specialist
     (Network
     Services/Customer
SC1B Support)               IT09     $26.39      1.0000     $33.06          0.000              $0.00   0.00                 $0.00        0.00            $0.00       $688.52                 $688.52       $9.98             $698.50

       3005D-Information
       Technology
       Specialist
       (Network
       Services/Customer
SC1B    Support)            IT09     $26.39      1.0000     $33.06          0.000              $0.00   0.00                 $0.00        0.00            $0.00       $688.52                 $688.52       $9.98             $698.50
       3006-Computer
       Assistant/Web
SC1B   Developer            GS07     $18.54      1.0000     $27.81          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
       4001-
       Communications
       Cable Splicer
       Supervisor/Base
       Communications
       Services
SC1C   Supervisor          WS09      $24.86      1.0000     $37.29          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
       4002A-
       Telecommunication
SC1C   s Mechanic          WG11      $20.30      1.0000     $30.45          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
       4002B-
       Telecommunication
SC1C   s Mechanic          WG11      $20.30      1.0000     $30.45          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
       4003-
       Communication
       Cable Splicer
       Leader/Cable and
       Outside Plant
SC1C   Mechanic            WL10      $21.60      1.0000     $32.40          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
       4004A-
       Communications
       Cable
       Splicer/Cable and
       Outside Plant
SC1C   Mechanic            WG10      $19.65      1.0000     $29.48          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
       4004B-
       Communications
       Cable
       Splicer/Cable and
       Outside Plant
SC1C   Mechanic            WG10      $19.65      1.0000     $29.48          0.000              $0.00   0.00                 $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00



   For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                                                           08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 19 of 40
                                                                                                        LBOS Other Pay All Sub-Worksheet (Including Night Differential)

                                                                                                                                                 Total Sunday
                                                                                                                                                 Premium Pay
                                    Basic                    OT                 OT Total Cost             Total Holiday Shift                    (Basic Hourly                    Other Pay (Col H +    Medicare      Other Pay &
                                    Hourly  Number          Hourly               (OT Hourly    Holiday    Cost (Basic Hourly         Sunday       Rate x .25 x       Night        Col J + Col L + Col   (Col O x    Medicare (Col O +
OSC    Position Title        Grade Pay Rate of FTE         Pay Rate    OT Hours rate x Hours) Shift Hours   Rate x Hours)             Hours         Hours)        Differential        M + Col N)         1.45%)          Col P)                        Remarks
     4004C-
     Communications
     Cable
     Splicer/Cable and
     Outside Plant
SC1C Mechanic                WG10    $19.65      1.0000     $29.48          0.000              $0.00     0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
     4005A-
     Communications
SC1C Cable Splicer           WG08    $18.30      1.0000     $27.45          0.000              $0.00     0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
     4005B-
     Communications
SC1C Cable Splicer           WG08    $18.30      1.0000     $27.45          0.000              $0.00     0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00

       4006-
       Telecommunication
       s                                                                                                                                                                                                                               Currently this workcenter is staffed with
       Specialist/Radio/Sp                                                                                                                                                                                                             1 employee. OA directed OT is based on
       ecialized                                                                                                                                                                                                                       0.1499 FTE of OT monthly or 22.1852
       Communications/F                                                                                                                                                                                                                hours *12 months = 266.2224 hours per
SC1C   requency Manager      GS09    $22.68      1.0000     $33.06        266.222        $8,801.31       0.00                $0.00        0.00            $0.00           $0.00             $8,801.31     $127.62            $8,928.93 year.
       4007A-
       Telecommunication
SC1C   s Mechanic            WG11    $20.30      1.0000     $30.45          0.000              $0.00     0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
       4007B-
       Telecommunication
SC1C   s Mechanics           WG11    $20.30      1.0000     $30.45          0.000              $0.00     0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
       4007C-
       Telecommunication
SC1C   s Mechanic            WG11    $20.30      1.0000     $30.45          0.000              $0.00     0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00
       5001-MEO
       Oversight              O4     $75.73      0.0259      $0.00          0.000              $0.00     0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00 MEO Oversight
       6001-KT Admin
       GS12                  GS12    $32.89      1.0000     $33.06          0.000              $0.00     0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00 KT Admin is not part of MEO
       6002-KT Admin
       GS11                  GS11    $27.45      1.0000     $33.06          0.000              $0.00     0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00 KT Admin is not part of MEO
       7001-GPC
       Oversight             GS09    $22.68      0.0133     $33.06          0.000              $0.00     0.00                $0.00        0.00            $0.00           $0.00                 $0.00       $0.00                $0.00 KT Admin is not part of MEO

       TOTALS                                    44.0392                  816.086       $26,979.81     240.00           $4,449.60     1,444.32        $7,133.61    $12,392.86              $50,955.88     $738.86           $51,694.74




   For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                                                            08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 20 of 40
                                                                                    Pay Tables

                                            Basic Hourly Hourly Overtime
      Grade          Step        Salary      Pay Rate       Pay Rate
      EL05            5        $35,376.00      16.95          25.43
      EL07            5        $43,814.00      20.99          31.49                              EL Table Date    1-May-2005
      EL09            5        $53,588.00      25.68          33.06                              EN Table Date    1-May-2005
      EL11            5        $58,811.00      28.18          33.06                              GS Table Date    9-Jan-2005
      EL12            5        $66,870.00      32.04          33.06                              IT Table Date    1-May-2005
      EN05            5        $35,376.00      16.95          25.43                              WG Table Date   23-Jan-2005
      EN07            5        $43,814.00      20.99          31.49
      EN09            5        $53,588.00      25.68          33.06
      EN11            5        $57,303.00      27.46          33.06
      EN12            5        $63,256.00      30.31          33.06
      GS01            5        $20,273.00       9.71          14.57
      GS02            5        $22,070.00      10.57          15.86
      GS03            5        $24,877.00      11.92          17.88
      GS04            5        $27,926.00      13.38          20.07
      GS05            5        $31,247.00      14.97          22.46
      GS06            5        $34,829.00      16.69          25.04
      GS07            5        $38,703.00      18.54          27.81
      GS08            5        $42,860.00      20.54          30.81
      GS09            5        $47,340.00      22.68          33.06
      GS10            5        $52,136.00      24.98          33.06
      GS11            5        $57,280.00      27.45          33.06
      GS12            5        $68,651.00      32.89          33.06
      GS13            5        $81,638.00      39.12          39.12
      GS14            5        $96,474.00      46.23          46.23
      GS15            5       $113,482.00      54.38          54.38
      IT05            5        $38,597.00      18.49          27.74
      IT07            5        $46,075.00      22.08          32.03
      IT09            5        $55,086.00      26.39          33.06
      IT11            5        $60,500.00      28.99          33.06
      IT12            5        $69,437.00      33.27          33.06
      IT13            5          $0.00          0.00           0.00
      WG01            4        $27,485.79      13.17          19.76
      WG02            4        $29,113.65      13.95          20.93
      WG03            4        $30,699.77      14.71          22.07
      WG04            4        $32,098.06      15.38          23.07
      WG05            4        $33,746.79      16.17          24.26
      WG06            4        $35,165.95      16.85          25.28
      WG07            4        $36,668.59      17.57          26.36
      WG08            4        $38,192.10      18.30          27.45
      WG09            4        $39,611.26      18.98          28.47
      WG10            4        $41,009.55      19.65          29.48
      WG11            4        $42,366.10      20.30          30.45
      WG12            4        $43,597.43      20.89          31.34
      WG13            4        $44,766.15      21.45          32.18
      WG14            4        $45,955.74      22.02          33.03

For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                            08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 21 of 40
                                                                                    Pay Tables

                                            Basic Hourly Hourly Overtime
      Grade          Step        Salary      Pay Rate       Pay Rate
      WG15            4        $47,082.72      22.56          33.84
      WL01            4        $30,303.24      14.52          21.78
      WL02            4        $32,056.32      15.36          23.04
      WL03            4        $33,746.79      16.17          24.26
      WL04            4        $35,416.39      16.97          25.46
      WL05            4        $37,106.86      17.78          26.67
      WL06            4        $38,672.11      18.53          27.80
      WL07            4        $40,320.84      19.32          28.98
      WL08            4        $41,990.44      20.12          30.18
      WL09            4        $43,534.82      20.86          31.29
      WL10            4        $45,079.20      21.60          32.40
      WL11            4        $46,602.71      22.33          33.50
      WL12            4        $48,001.00      23.00          34.50
      WL13            4        $49,253.20      23.60          35.40
      WL14            4        $50,568.01      24.23          36.35
      WL15            4        $51,799.34      24.82          37.23
      WS01            4        $40,049.53      19.19          28.79
      WS02            4        $41,635.65      19.95          29.93
      WS03            4        $43,159.16      20.68          31.02
      WS04            4        $44,557.45      21.35          32.03
      WS05            4        $46,039.22      22.06          33.09
      WS06            4        $47,541.86      22.78          34.17
      WS07            4        $49,023.63      23.49          35.24
      WS08            4        $50,526.27      24.21          36.32
      WS09            4        $51,882.82      24.86          37.29
      WS10            4        $53,301.98      25.54          38.31
      WS11            4        $55,180.28      26.44          39.66
      WS12            4        $57,559.46      27.58          41.37
      WS13            4        $60,460.39      28.97          43.46
      WS14            4        $63,862.20      30.60          45.90
      WS15            4        $67,890.11      32.53          48.80
      WS16            4        $72,251.94      34.62          51.93
      WS17            4        $77,448.57      37.11          55.67
      WS18            4        $83,166.95      39.85          59.78
      WS19            4        $87,779.22      42.06          63.09




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision        08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 22 of 40
                                                                                                                              LBOS Personnel Costs Backup

                                                                          # of
                                                                       Employees                                     Midnight
                                                                       Receiving                    Evening Shift      Shift          Sunday                    Holiday
                                                            Number      Premium         Day Shift    Differential   Differential   Premium Pay Overtime (OT)   Premium     Bonus    Hazardous     Total #
               OSC          Position Title        Grade     of FTEs        Pay         Hours/Week    Hours/Week     Hours/Week      Hours/Week    Hours        Pay Hours   Amount    Duty Pay   Hours/Week   Justification for Decision:
                       1001-Supervisory
                       Communications-
            SC1        Computer Specialist        GS-13         1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       1002-Visual
            SC1        Information Specialist     GS-11         1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       1003-Visual
            SC1        Information Specialist     GS-09         1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                                                                                                                                                                                                             Overtime hours broken out between PD# 1004 A/B/C
                       1004A-                                                                                                                                                                                equals 15.274 monthly hours per position. OA
                       Telecommunications                                                                                                                                                                    directed OT is based on 0.3096 FTE of OT monthly or
                       Specialist/Plans                                                                                                                                                                      45.821 monthly hours *12 months = 183.288 hours
            SC1        Programmer                 GS-09         1            0              40           N/A            N/A             N/A          183.288     N/A         0         N/A          40       per year per position.
                                                                                                                                                                                                             Overtime hours broken out between PD# 1004 A/B/C
                       1004B-                                                                                                                                                                                equals 15.274 monthly hours per position. OA
                       Telecommunications                                                                                                                                                                    directed OT is based on 0.3096 FTE of OT monthly or
                       Specialist/Plans                                                                                                                                                                      45.821 monthly hours *12 months = 183.288 hours
            SC1        Programmer                 GS-09         1            0              40           N/A            N/A             N/A          183.288     N/A         0         N/A          40       per year per position.
                                                                                                                                                                                                             Overtime hours broken out between PD# 1004 A/B/C
                       1004C-                                                                                                                                                                                equals 15.274 monthly hours per position. OA
                       Telecommunications                                                                                                                                                                    directed OT is based on 0.3096 FTE of OT monthly or
                       Specialist/Plans                                                                                                                                                                      45.821 monthly hours *12 months = 183.288 hours
            SC1        Programmer                 GS-09         1            0              40           N/A            N/A             N/A          183.288     N/A         0         N/A          40       per year per position.
                       1006A-Editorial
                       Assistant (Office
                       Automation)                                                                                                                                                                           Currently this workcenter has two positions and no
            SC1        Publications Manager       GS-07         1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40       historical OT.
                       1006B-Editorial
                       Assistant (Office
                       Automation)                                                                                                                                                                           Currently this workcenter has two positions and no
            SC1        Publications Manager       GS-07         1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40       historical OT.
                       1007A-Computer
                       Inventory Control
                       Technician/Equipment
            SC1        Control Officer            GS-06         1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       1007B-Computer
                       Inventory Control
                       Technician/Equipment
            SC1        Control Officer            GS-06         1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       1008-Secretary (Office
            SC1        Automation)                GS-05         1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       1009-Budget
                       Technician (Office
            SC1        Automation)                GS-05         1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       2001-Supervisory
                       Computer
                       Assistant/Help Desk
            SC1A       Specialist                 GS-09         1            0              40                                                        0.000      N/A         0         N/A          40
                       2002A-Computer
                       Assistant/Help Desk
            SC1A       Specialist                 GS-07         1            0              40                                                        0.000      N/A         0         N/A          40       Refer to PRD 7.1.4.4; 7.4.10; Day Shift
                       2002B-Computer
                       Assistant/Help Desk
            SC1A       Specialist                 GS-07         1            0              40                                                        0.000      N/A         0         N/A          40       Refe to PRD 7.1.4.4; 7.4.10; Day Shift

For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                                                           08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 23 of 40
                                                                                                                            LBOS Personnel Costs Backup

                                                                          # of
                                                                       Employees                                     Midnight
                                                                       Receiving                    Evening Shift      Shift          Sunday                    Holiday
                                                            Number      Premium         Day Shift    Differential   Differential   Premium Pay Overtime (OT)   Premium     Bonus    Hazardous     Total #
               OSC          Position Title        Grade     of FTEs        Pay         Hours/Week    Hours/Week     Hours/Week      Hours/Week    Hours        Pay Hours   Amount    Duty Pay   Hours/Week   Justification for Decision:
                       2002C-Computer
                       Assistant/Help Desk
            SC1A       Specialist                 GS-07         1            1              40                                         10           0.000        N/A         0         N/A          40
                       2002D-Computer
                       Assistant/Help Desk
            SC1A       Specialist                 GS-07         1            1              40                                                      0.000        N/A         0         N/A          40
                       2002E2003A-
                       Computer
                       Assistant/Help Desk
            SC1A       Specialist                 GS-07         1            1                           40                            10           0.000        N/A         0         N/A          40       Rotating evening & midnight shift
                       2002F2003B-
                       Computer
                       Assistant/Help Desk
            SC1A       Specialist                 GS-07         1            1                           40                                         0.000        N/A         0         N/A          40       Rotating evening & midnight shift
                       3001-Supervisory
                       Information
                       Technology
                       Specialist/Network                                                                                                                                                                    OT hours from PRD was used to staff this section. No
                       Services Branch                                                                                                                                                                       additional OT expected because 1 FTE was moved to
            SC1B       Manager                     IT12         1            0                                                                      0.000        N/A         0          0           40       swings.

                       3002-Information                                                                                                                                                                      OT hours from PRD was used to staff this section. No
                       Technology Specialist                                                                                                                                                                 additional OT expected because 1 FTE was moved to
            SC1B       (Network Services)          IT11         1            0                                                                      0.000        N/A         0          0           40       swings.
                       3003-Information
                       Technology Specialist                                                                                                                                                                 OT hours from PRD was used to staff this section. No
                       (Systems                                                                                                                                                                              additional OT expected because 1 FTE was moved to
            SC1B       Administration)             IT11         1            0                                                                      0.000        N/A         0          0           40       swings.

                       3004A-Information
                       Technology Specialist
                       (Security)/Wing                                                                                                                                                                       OT hours from PRD was used to staff this section. No
                       Assistant Information                                                                                                                                                                 additional OT expected because 1 FTE was moved to
            SC1B       Assurance Manager           IT09         1            0                                                                      0.000        N/A         0          0           40       swings.

                       3004B-Information
                       Technology Specialist
                       (Security)/Wing                                                                                                                                                                       OT hours from PRD was used to staff this section. No
                       Assistant Information                                                                                                                                                                 additional OT expected because 1 FTE was moved to
            SC1B       Assurance Manager           IT09         1            0                                                                      0.000        N/A         0          0           40       swings.
                       3005A-Information
                       Technology (Network                                                                                                                                                                   OT hours from PRD was used to staff this section. No
                       Services/Customer                                                                                                                                                                     additional OT expected because 1 FTE was moved to
            SC1B       Support)                    IT09         1            0                                                                      0.000        N/A         0                      40       swings.
                       3005B-Information                                                                                                                                                                     This positon was moved to swingshift to cover any
                       Technology (Network                                                          1800 to 0000,                                                                                            work due to day hot issues that require after hour
                       Services/Customer                                                              5 days per                                                                                             support or overtime. overtime hours from PRD was
            SC1B       Support)                    IT09         1            0                       week (CWS)                                     0.000        N/A         0                      40       used to staff this section.
                       3005C-Information
                       Technology (Network                                                                                                                                                                   OT hours from PRD was used to staff this section. No
                       Services/Customer                                                                                                                                                                     additional OT expected because 1 FTE was moved to
            SC1B       Support)                    IT09         1            0                                                                      0.000        N/A         0          0           40       swings.


For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                                                           08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 24 of 40
                                                                                                                              LBOS Personnel Costs Backup

                                                                          # of
                                                                       Employees                                     Midnight
                                                                       Receiving                    Evening Shift      Shift          Sunday                    Holiday
                                                            Number      Premium         Day Shift    Differential   Differential   Premium Pay Overtime (OT)   Premium     Bonus    Hazardous     Total #
               OSC          Position Title        Grade     of FTEs        Pay         Hours/Week    Hours/Week     Hours/Week      Hours/Week    Hours        Pay Hours   Amount    Duty Pay   Hours/Week   Justification for Decision:
                       3005D-Information
                       Technology (Network                                                                                                                                                                   OT hours from PRD was used to staff this section. No
                       Services/Customer                                                                                                                                                                     additional OT expected because 1 FTE was moved to
            SC1B       Support)                    IT09         1            0                                                                        0.000      N/A         0          0           40       swings.
                       3006-Computer                                                                                                                                                                         OT hours from PRD was used to staff this section. No
                       Assistant/Web                                                                                                                                                                         additional OT expected because 1 FTE was moved to
            SC1B       Developer                   GS07         1            0                                                                        0.000      N/A         0          0           40       swings.

                       4001-Communications
                       Cable Splicer
                       Supervisor/Base
                       Communications
            SC1C       Services Supervisor        WS-09         1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       4002A-
                       Telecommunication
                       Mechanic (Circuit
            SC1C       Actions)                   WG-11         1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       4002B-
                       Telecommunication
                       Mechanic (Circuit
            SC1C       Actions)                   WG-11         1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40


                       4003-Communications
                       Cable Splicer
                       Leader/Cable and
            SC1C       Outside Plant Mechanic      WL10         1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       4004A-
                       Communications
                       Cable Splicer/Cable
                       and Outside Plant
            SC1C       Mechanic                   WG10          1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       4004B-
                       Communications
                       Cable Splicer/Cable
                       and Outside Plant
            SC1C       Mechanic                   WG10          1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       4004C-
                       Communications
                       Cable Splicer/Cable
                       and Outside Plant
            SC1C       Mechanic                   WG10          1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       4005A-
                       Communications
            SC1C       Cable Splicer              WG08          1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       4005B-
                       Communications
            SC1C       Cable Splicer              WG08          1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                                                           08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 25 of 40
                                                                                                                              LBOS Personnel Costs Backup

                                                                          # of
                                                                       Employees                                     Midnight
                                                                       Receiving                    Evening Shift      Shift          Sunday                    Holiday
                                                            Number      Premium         Day Shift    Differential   Differential   Premium Pay Overtime (OT)   Premium     Bonus    Hazardous     Total #
               OSC           Position Title       Grade     of FTEs        Pay         Hours/Week    Hours/Week     Hours/Week      Hours/Week    Hours        Pay Hours   Amount    Duty Pay   Hours/Week   Justification for Decision:
                       4006-
                       Telecommunications
                       Specialist/Radio/Specia                                                                                                                                                               Currently this workcenter is staffed with 1 employee.
                       lized                                                                                                                                                                                 OA directed OT is based on 0.1499 FTE of OT
                       Communications/Frequ                                                                                                                                                                  monthly or 22.1852 hours *12 months = 266.2224
            SC1C       ency Manager                GS09         1            0              40           N/A            N/A             N/A         266.2224     N/A         0         N/A          40       hours per year.
                       4007A-
                       Telecommunicaitons
            SC1C       Mechanic                   WG11          1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       4007B-
                       Telecommunicaitons
            SC1C       Mechanic                   WG11          1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40
                       4007C-
                       Telecommunicaitons
            SC1C       Mechanic                   WG11          1            0              40           N/A            N/A             N/A           0.000      N/A         0         N/A          40

                       Totals                                  42                                                                                    816.086




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                                                           08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 26 of 40
                                                                                                                    LBOS Transition Plan                                                                                    4/21/20112:53 PM
                                                                                                  Reflecting Partial FTEs for the First Performance Period
                                                                                                                                                                                                              # Days on
                                                                                                                                                                                                              Board for
                               Date of                                                                                            Start                                                                      Mobilization                    Breakout
                             Incremental                   GS/FW-Series-                                                         Date (T- Clearance                              Certifications     Days         and           1st PP           of
                             Assumption       New OSC          Grade             Classifciation/Duty Title          Number       Date = 1) Required Training Required            Required          from T     Transition        FTEs         multiples
                                                                                    1001-Supervisory
                                                                                Communications-Computer                                                  Information Awareness
                                 T+30            SC1         GS-0301-13                 Specialist                      1           -61          S       Network Licensing       None                -61          153           1.000
                                                                                                                                                         Information Awareness
                                 T Day           SC1         GS-1084-11      1002-Visual Information Specialist         1           -5           S       Network Licensing       None                 -5           97           0.634
                                                                               1004A-Telecommunications                                                  Information Awareness
                                 T+30            SC1         GS-0391-09        Specialist/Plans Programmer              1            1           S       Network Licensing       None                 1            92           0.601
                                                                                                                                                         Information Awareness
                                 T Day           SC1         GS-1084-09      1003-Visual Information Specialist         1            1           S       Network Licensing       None                 1            92           0.601

                                                                                                                                                         FOIA
                                                                             1006A-Editorial Assistant (Office                                           Information Awareness
                                 T Day           SC1         GS-1087-07      Automation)/Publications Manager           1            1         None      Network Licensing       None                 1            92           0.601


                                                                             1006B-Editorial Assistant (Office                                           Information Awareness
                                 T Day           SC1         GS-1087-07      Automation)/Publications Manager           1            1         None      Network Licensing       None                 1            92           0.601
                                                                                   1008-Secretary (Office                                                Information Awareness
                                 T+30            SC1         GS-0318-05                 Automation)                     1           15         None      Network Licensing       None                 15           78           0.510
                                                                              1009-Budget Technician (Office                                             Information Awareness
                                 T+30            SC1         GS-0561-05                 Automation)                     1           15           S       Network Licensing       None                 15           78           0.510
                                                                               1004B,C-Telecommunications                                                Information Awareness
                                 T+30            SC1         GS-0391-09         Specialist/Plans Programmer             2           15           S       Network Licensing       None                 15           78           1.020          0.510
                                                                                 1007A-Computer Inventory                                                ADPE
                                                                               Control Technician/Equipment                                              Information Awareness
                                 T+30            SC1         GS-0303-06                Control Officer                  1           15           S       Network Licensing       None                 15           78           0.510
                                                                                 1007B-Computer Inventory                                                ADPE
                                                                               Control Technician/Equipment                                              Information Awareness
                                 T+30            SC1         GS-0303-06                Control Officer                  1           30           S       Network Licensing       None                30           63           0.412
SC1 Subtotal                                     SC1                                          12                                                                                         Percent of workcenter personnel during transition       0.583
                                                                                                                                                         DMS/Messaging(Formal
                                                                                                                                                         Training)
                                                                                2001-Supervisory Computer                                                Information Awareness
                                 T+30           SC1A         GS-0335-09        Assistant/Help Desk Specialist           1            1          TS       Network Licensing       None                 1            92           0.601
                                                                                                                                                         DMS/Messaging
                                                                              2002A-Computer Assistant/Help                                              Information Awareness
                                 T+30           SC1A         GS-0335-07              Desk Specialist                    1            1          TS       Network Licensing       None                 1            92           0.601
                                                                                                                                                         DMS/Messaging
                                                                                 2002B,C,D,E,F-Computer                                                  Information Awareness
                                 T+30           SC1A         GS-0335-07        Assistant/Help Desk Specialist           5           15          TS       Network Licensing       None                 15           78           2.549          0.51

SC1 A Subtotal                                  SC1A                                         7                                                                                           Percent of workcenter personnel during transition       0.536
                                                                               3001-Supervisory Information
                                                                              Technology Specialist/Network                                              Information Awareness
                                 T+45           SC1B         GS-2210-12          Services Branch Manager                1            1           S       Network Licensing       None                 1            92           0.601
                                                                               3003-Information Technology
                                                                                   Specialist (Systems                                                   Information Awareness
                                 T+45           SC1B         GS-2210-11               Administration)                   1           15           S       Network Licensing       None                 15           78           0.510
                                                                               3002-Information Technology                                               Information Awareness
                                 T+45           SC1B         GS-2210-11        Specialist (Network Services)            1           15           S       Network Licensing       None                 15           78           0.510
                                                                                                                                                         COMSEC
                                                                             3004A,B-Information Technology                                              COMPUSEC
                                                                                Specialist (Security)/Wing                                               EMSEC
                                                                             Assistant Information Assurance                                             Information Awareness
                                 T+45           SC1B         GS-2210-09                   Manager                       2           15          TS       Network Licensing       None                 15           78           1.020          0.51




      For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                          08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 27 of 40
                                                                                                                    LBOS Transition Plan                                                                                    4/21/20112:53 PM
                                                                                                  Reflecting Partial FTEs for the First Performance Period
                                                                                                                                                                                                              # Days on
                                                                                                                                                                                                              Board for
                               Date of                                                                                            Start                                                                      Mobilization                    Breakout
                             Incremental                   GS/FW-Series-                                                         Date (T- Clearance                              Certifications     Days         and           1st PP           of
                             Assumption       New OSC          Grade            Classifciation/Duty Title           Number       Date = 1) Required Training Required            Required          from T     Transition        FTEs         multiples
                                                                             3005A,B-Information Technology
                                                                                   Specialist (Network                                                   Information Awareness
                                 T+45           SC1B         GS-2210-09        Services/Customer Support)               2           30           S       Network Licensing       None                 30           63           0.824          0.412
                                                                             3005C,D-Information Technology
                                                                                   Specialist (Network                                                   Information Awareness
                                 T+45           SC1B         GS-2210-09        Services/Customer Support)               2           30           S       Network Licensing       None                 30           63           0.824          0.412
                                                                              3006-Computer Assistant/Web                                                Information Awareness
                                 T+45           SC1B         GS-0335-07                 Developer                       1           30           S       Network Licensing       None                30           63           0.412
SC1 B Subtotal                                  SC1B                                        10                                                                                           Percent of workcenter personnel during transition       0.470
                                                                                                                                                         CPR
                                                                               4001-Communications Cable                                                 Information Awareness
                                 T+30           SC1C         WS-2504-09              Splicer Supervisor                 1            1           S       Network Licensing       None                 1            92           0.601
                                                                                 4006-Telecommunications
                                                                               Specialist/Radio/Specialized
                                                                               Communications/Frequency                                                  Information Awareness
                                 T+30           SC1C         GS-0391-09                   Manager                       1           15           S       Network Licensing       None                 15           78            0.51
                                                                               4003-Communication Cable
                                                                             Splicer Leader/Cable and Outside                                            Information Awareness
                                 T+45           SC1C         WL-2504-10                Plant Mechanic                   1           15           S       Network Licensing       None                 15           78            0.51
                                                                                                                                                         COMSEC/EMSEC
                                                                                                                                                         CPR
                                                                               4002A,B-Telecommunications                                                Information Awareness
                                 T+30           SC1C        WG-2502-11                  Mechanic                        2           15          TS       Network Licensing       None                 15           78            1.02          0.51




      For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                          08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 28 of 40
                                                                                                                        LBOS Transition Plan                                                                                        4/21/20112:53 PM
                                                                                                      Reflecting Partial FTEs for the First Performance Period
                                                                                                                                                                                                                      # Days on
                                                                                                                                                                                                                      Board for
                                   Date of                                                                                            Start                                                                          Mobilization                    Breakout
                                 Incremental                   GS/FW-Series-                                                         Date (T- Clearance                                 Certifications      Days         and           1st PP           of
                                 Assumption       New OSC          Grade            Classifciation/Duty Title           Number       Date = 1) Required Training Required               Required           from T     Transition        FTEs         multiples
                                                                                 4007A,B,C Telecommunications                                           Information Awareness
                                     T+45           SC1C        WG-2502-11                  Mechanic                        3           15        S     Network Licensing               Nortel                15           78           1.529          0.51
                                                                                   4004A,B,C-Communications
                                                                                 Cable Splicer/Cable and Outside                                             Information Awareness
                                     T+45           SC1C        WG-2504-10               Plant Mechanic                     3           45           S       Network Licensing          None                  45           48           0.941          0.314
                                                                                 4005A,B-Communications Cable                                                Information Awareness
                                     T+45           SC1C        WG-2504-08                    Splicer                       2           45           S       Network Licensing          None                 45           48           0.627           0.314
SC1 C Subtotal                                      SC1C                                        13                                                                                               Percent of workcenter personnel during transition        0.441




                                                                                                      Total Number:        42                                                                                                               21.19


                                                                                                                                                             Percentage of Total FTEs          0.505

SC1                                                 SC1              O4                5001-MEO Oversight                0.0259        T-61                                                                  61           153              0.0259
Keesler                                            Keesler          GS12               6001-KT Admin GS12                   1         T-Date                                                                  0            92               0.601
Keesler                                            Keesler          GS11               6002-KT Admin GS11                   0         2nd PP                                                                  0            93                   0
Keesler                                            Keesler          GS09               7001-GPC Oversight             0.01333333      T-Date                                                                  0            92               0.008
                                                                                                                      43.0392333

Column P gives the individual 1st PP pro-rated FTEs for lines with more than one position. This may not match Column O due to rounding. For instance, a line may have 2 FTEs,
each with a pro-ration of .398. However, the total pro-ration for the 2 FTEs is .795 as opposed to .796 (.398 * 2), due to rounding.

  NOTE: WinCompare will reflect some GS positions as Information Technology (IT) positions. Although still technically classified under the GS               Color Legend:
  system, this is a new special pay rate for technology related positions incurring a different rate of pay than a normal GS classification. These
  positions are numbered 3001 through3005D.                                                                                                                  Line 1 - Personnel Costs
                                                                                                                                                             Line 3 - Training Costs
                                                                                                                                                             Line 5 - Security
                                                                                                                                                             Clearances




          For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                              08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 29 of 40
                                                                                                                  LBOS Transition Plan                                                                          4/21/20112:53 PM
                                                                                                Reflecting Partial FTEs for the First Performance Period
                                                                                                                                                                                                  # Days on
                                                                                                                                                                                                  Board for
                             Date of                                                                                            Start                                                            Mobilization                Breakout
                           Incremental                   GS/FW-Series-                                                         Date (T- Clearance                     Certifications     Days        and          1st PP        of
                           Assumption       New OSC          Grade             Classifciation/Duty Title          Number       Date = 1) Required Training Required   Required          from T    Transition       FTEs      multiples

Transition        92                           153
               # Days                                                                                           Assumption
  Date        on Board                        NEW                                 Function From PRD                Date         Months
  T-61           153                          1.000                                 BNCC Circ Act                   30          2.037
  T-60           152                          0.993                                 BNCC Systems                    45          1.544
  T-45           137                          0.895                                   BNCC Infra                    45          1.544
  T-30           122                          0.797                                    Message                      30          2.037
  T-15           107                          0.699                                 Info Assurance                  45          1.544
  T-14           106                          0.693                                      LMR                        30          2.037
  T-10           102                          0.667                                  Tele Systems                   45          1.544
   T-7            99                          0.647                                      Cable                      45          1.544
   T-5            97                          0.634                                      Plans                      30          2.037
   T-2            94                          0.614                                      Visual                      0          3.022
    T             92                          0.601                                    Publishing                    0          3.022
  T+5             88                          0.575                         Total Months of MEO Operation                       21.912
  T+15            78                          0.510
                                                                               Average Months of MEO
  T+25            68                          0.444                                  Operation                                   1.992
  T+28            65                          0.425
  T+30            63                          0.412                               Percentage of Period                           0.398
                                                                           This is the average percentage of
                                                                             the Mob and Trans Period that
                                                                            the MEO will be responsible for
                                                                           operations, and thus, responsible
                                                                             for buying Materials and Office
  T+35            58                          0.379                                     Supplies
  T+45            48                          0.314
  T+50            43                          0.281
  T+60            33                          0.216
  T+61            32                          0.209
  T+65            28                          0.183
  T+70            23                          0.150
  T+80            13                          0.085
  T+92             1                          0.007




    For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                                                                                 08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 30 of 40
                                                     STANDARD INDIRECT MANHOUR CALCULATION
                                                           Workcenter Used in Calculation: LBOS
                                                                                           Based on AFMS 00AA, Feb 02
                                                                    Workload Information
                            1. Answer Y for Yes or N for No for each variable task in the "SIAM Fixed" Tab on this Spreadsheet.
                            2. Answer the Questions below.
                               Is this an Aircraft MX workcenter? (Answer "Yes" or "No")       No           Requires No Input
                              # of civilians in the workcenter                                  1                             1.5356
                              # of vehicles assigned to the workcenter                          0                                   0
                              # of pieces of machinery maintained by the workcenter             0                                   0
                              # pieces of test equipment maintained (Non-ACMX
                            functions or overhead workcenter)                                   0                                   0
                            Average number of travel documents prepared by the
                            workcenter                                                          0                                   0
                            Average number of personal computers assigned to the
                            workcenter                                                          0                                   0
                            # Web Sites Maintained by the Workcenter                            0                                   0
                                         Total Personnel Generated and Variable Manhours                                      1.5356
                                                           Fixed Manhours                                                        2.39
                                     Total Personnel Generated and Variable + Fixed Manhours                                  3.9256
                                                             Partial FTEs                                                     0.0259




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                     08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 31 of 40
                                                                         Variable


Task Number           Task Title        b = man-hours              X                Y=bX             Notes

                                                                                            X = Average number of
                                                                                            pieces of machinery
                                                                                            maintained. Does not
                                                                                            apply to ACMX functions
I9.1            Maintains Machinery              0.4843                      0       0      or overhead workcenters.

                                                                                            X = Average number of
                                                                                            pieces of test equipment
                                                                                            maintained. Does not
                Maintains Test                                                              apply to ACMX functions
I9.2            Equipment                         0.407                      0       0      or overhead workcenters.

                                                                                            X = Average number of
                                                                                            assigned vehicles
                                                                                            maintained. Does not
                Maintains Assigned                                                          apply to ACMX functions
I9.5            Vehicle                           2.513                      0       0      or overhead workcenters.


                                                                                            X = Average number of
                                                                                            pieces of machinery
                                                                                            maintained. Only applies
                                                                                            to ACMX functions and
                                                                                            does not apply to
I10.1           Maintains Machinery                0.81                      0       0      overhead workcenters.

                                                                                            X = Average number of
                                                                                            pieces of machinery
                                                                                            maintained. Only applies
                                                                                            to ACMX functions and
                Maintains Test                                                              does not apply to
I10.2           Equipment                        0.7089                      0       0      overhead workcenters.




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision            08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 32 of 40
                                                                         Variable


Task Number           Task Title        b = man-hours              X                Y=bX                Notes

                                                                                               X = Average number of
                                                                                               pieces of machinery
                                                                                               maintained. Only applies
                Maintains                                                                      to ACMX functions and
                Consolidated Tool                                                              does not apply to
I10.3           Kits (AC MX only)            3.506                           0                 overhead workcenters.

                                                                                               X = Average number of
                                                                                               assigned vehicles
                                                                                               maintained. Only applies
                                                                                               to ACMX functions and
                Maintains Assigned                                                             does not apply overhead
I10.5           Vehicles                          4.484                      0       0         workcenters.
                                                                                               X= Average number of
                Completes Travel                                                               travel documents
I4.11.          Document                             4.62                    0       0         completed monthly
                                                                                               X= Average number of
                Approves Travel                                                                travel documents
I4.12.          Document                        0.02406                      0       0         completed monthly
                                                                                               X= Average number of
                Maintains                                                                      personal computers
                Microcomputer                                                                  assigned to the
I5.22.          System                            2.261                      0       0         workcenter.
                                                                                               X= Average number of
                                                                                               personal computers
                Perform Work Group                                                             assigned to the
I5.23.          Management                       0.4043                      0       0         workcenter.
                                                                                               X= Average number of
I5.24.          Maintains Web Site                1.829                      0       0         Web Sites maintained.




                                                                                           0




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision               08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 33 of 40
                                                                       SIAM Personnel Generated


 Task Number               Task Title                  b = man-hours   X = No of Civilians    Y=bX
I1.1         Hires Civilian Employee                            0.2856        1.00            0.2856

I1.2            Types Civilian Personnel Document                 0.027           1.00         0.027
I1.3            Indoctrinates Civilian Employee                  0.0535           1.00        0.0535

I1.4            Prepares Civilian Performance Plan               0.1291           1.00        0.1291
                Prepares Civilian Performance
I1.5            Appraisal.                                       0.1558           1.00        0.1558
I1.6            Types Civilian Appraisal                         0.0704           1.00        0.0704
                Approves Civilian Performance
I1.7            Appraisal                                        0.0339           1.00        0.0339
                Prepares for Performance
I1.8            Feedback Session                                 0.0613           1.00        0.0613
                Conducts Performance Feedback
I1.9.           Session                                          0.0688           1.00        0.0688
                Attends Performance Feedback
I1.10           Session                                          0.0688           1.00

I1.11           Prepares Cvilian Award Nomination                0.1227           1.00        0.1227
I1.12           Types Civilian Award Nomination                  0.0484           1.00        0.0484
I1.13           Counsels Civilian Employee                       0.0563           1.00        0.0563
                Maintains Time and Attendance
I1.14           Form                                             0.2736           1.00        0.2736
I4.1            Schedules Personnel                              0.1038           1.00             0

I4.2            Prepares Alternate Work Schedule                 0.0279           1.00            0
I4.5            Oversees Work in Progress                        1.2881           1.00            0
I4.7            Informs Workcenter Personnel                     0.0934           1.00            0
I4.8            Informs Individual                               0.0806           1.00            0
I4.21           Prepares IDEA                                    0.0107           1.00
i4.22           Reviews IDEA                                     0.0028           1.00
I4.23           Evaluates IDEA                                   0.0049           1.00
I5.10           Maintains Personnel Locator File                 0.0082           1.00
                Conducts or Attends Flight/Section
I6.10           Meeting                                          0.4793           1.00
                Develops Training and Certification
I7.1            Plan                                             0.0162           1.00        0.0162
                Evaluates Individual Training and
I7.2            Certification Requirement                        0.0233           1.00        0.0233
                Controls Career Development
I7.3            Course (CDC) Package                             0.0272           1.00        0.0272


For Official Use Only: Procurement Sensitive until the tentative cost comparison decision              08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 34of 40
                                                                       SIAM Personnel Generated


 Task Number             Task Title                    b = man-hours   X = No of Civilians    Y=bX
I7.4         Counsels Trainee                                   0.0224        1.00            0.0224

I7.6            Conducts Training and Certification              0.0601           1.00        0.0601

I7.7            Receives Training and Certification              0.0601           0.00
                Maintains Individual Tool Kits
                (Does not apply to Overhead
I9.4            Workcenters)                                     0.3733           1.00
                Maitains Individual Tool Kits (Does
                not Apply to Overhead
I10.4           Workcenters)                                     0.8946           1.00
I11.1           Prepares Work Area                                  1.75          1.00
I11.2           Puts Work Away                                    2.075           1.00



                                                                                              1.5356




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision              08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 35of 40
                                                                              SIAM FIXED


                                                                                 MEO Customized SIAM
                                                                                   allowed Averaged
                                                 SIAM Allowed Average           Manhours (Answer "Y" for
 Task Number               Task Title                Monthly Hours                 Yes and "N" for No)
                  Develops Policy Letter,
                  Procedure, or Operating
I4.3              Instruction                             4.2972                            N
                  Develops Performance
I4.4              Standard or Checklist                   0.9451                            N
                  Coordinates on Work
                  Center or Personnel
I4.6              Status                                    2.39                            Y
                  Prepares
                  Correspondence
                  Associated with Indirect
I4.9              Work                                     5.109                            N
                  Types Correspondence
                  Associated with Indirect
I4.10             Work                                     3.289                            N
                  Reviews Incoming
I4.13             Distribution                              11.6                            N
                  Reviews Outgoing
I4.14             Distribution                             9.409                            N

I4.15             Develops Budget Estimate                0.3074                            N
                  Assists in Mishap or
I4.16             Incident Investigation                  0.2473                            N
I4.17             Inspects Office Facility                 4.021                            N
                  Inspects
                  Warehouse/Maintenance
I4.18             Facility                                 5.217                            N
                  Receives and Assists
I4.19             Visiting Official                         1.25                            N
                  Reviews Report and
I4.20             Statistical Data                          1.9                             N

                  Processes Unclassified
I5.1              Incoming Distribution                    10.62                            N
                  Processes Unclassified
I5.2              Outgoing Distribution                    8.203                            N




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                  08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 36 of 40
                                                                              SIAM FIXED


                                                                                 MEO Customized SIAM
                                                                                   allowed Averaged
                                                 SIAM Allowed Average           Manhours (Answer "Y" for
 Task Number               Task Title                Monthly Hours                 Yes and "N" for No)
                  Establishes New
                  Unclassified
I5.3              Correspondence File                     0.1286                            N
                  Updates Unclassified
I5.4              Correspondence File                     0.2369                            N
                  Files Unclassified
I5.5              Correspondence                           6.003                            N
                  Reviews Unclassified
                  Correspondence File for
I5.6              Disposal                                0.2586                            N
                  Disposes of Unclassified
I5.7              Documentation                            0.178                            N
I5.8              Maintains Suspence File                   5.23                            N
                  Maintains Log and
I5.9              Register                                 5.554                            N
                  Controls Classified
I5.11             Material                                  1.82                            N
                  Inventories TOP SECRET
I5.12             Material                                 1.284                            N
                  Safeguards Classified
I5.13             Material                                 3.273                            N
                  Destroys Classified
I5.14             Material                                0.2676                            N
                  Maintains Unclassified
I5.15             Publication File                         1.371                            N
                  Operates Classified and
                  Unclassified Office
I5.16             Equipment                                11.68                            N
                  Maintains Stock of Non-
I5.17             Electronic Forms                        0.5853                            N
I5.18             Maintains Bulletin Board                0.5029                            N
                  Maintains Appointment
I5.19             Record                                    3.24                            N
I5.20             Acknowledges Visitor                     6.667                            N
                  Maintains Office
I5.21             Equipment                                1.343                            N




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                  08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 37 of 40
                                                                              SIAM FIXED


                                                                                 MEO Customized SIAM
                                                                                   allowed Averaged
                                                 SIAM Allowed Average           Manhours (Answer "Y" for
 Task Number              Task Title                 Monthly Hours                 Yes and "N" for No)

                  Prepares for Wing/Center
I6.1              Staff Meeting                            2.437                            N

                  Conducts or Attends
I6.2              Wing/Center Staff Meeting                4.358                            N
                  Prepares for
                  Group/Directorate Staff
I6.3              Meeting                                   2.77                            N
                  Conducts or Attends
                  Group/Direcorate Staff
I6.4              Meeting                                  4.064                            N

                  Prepares for
I6.5              Squadron/Division Meeting                2.144                            N

                  Conduct or Attends
I6.6              Squadron/Division Meeting                 5.14                            N
                  Prepares for Branch
I6.7              Meeting                                  2.312                            N
                  Conducts or Attends
I6.8              Branch Meeting                           4.142                            N
                  Prepares for
I6.9              Flight/Section Meeting                   1.861                            N
                  Develops Training and
I7.5              Certification Material                  0.5432                            N
                  Processes Equipment
I8.1              Request                                 1.4594                            N
I8.2              Conducts Inventory                      0.2928                            N
                  Maintains Custodian
I8.3              Document                                0.6177                            N
                  Obtains Expendable
I8.4              Supplies                                1.8384                            N
                  Maintains Financial
                  Reports for Expendable
I8.5.             Supplies                                 1.211                            N




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                  08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 38 of 40
                                                                              SIAM FIXED


                                                                                 MEO Customized SIAM
                                                                                   allowed Averaged
                                                 SIAM Allowed Average           Manhours (Answer "Y" for
 Task Number               Task Title                Monthly Hours                 Yes and "N" for No)
                  Maintains Consolidated
                  Tool Kit (does not apply to
I9.3              AC MX)                                  0.6754                            N




                                                 Total MEO Customized
                                                   Allowed Manhours                                  2.39




For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                   08a293fa-1b7f-495f-ba50-79c0c79526c0.xls 39 of 40
                                                                            LBOS_GPC_Workload

                                                            Full
             Card                     Fractional  # of Card Performance 1sT PP
             Holder FTEs Per 200 Card FTE Per      Holders Fractional   Fractional Monthly
Function     Range       Holders      Card Holder in MEO FTEs           FTEs       Hours                        Remarks
                                                                                                                1 primary & 1 alternate. In
                                                                                                                order to mainain better
LBOS                                                                                                            oversight of expenditures
GPC                                                                                                             the number of card holders
Oversight        300              2               0.00666667          2        0.013333333      0.008 1.973333 will be controlled.
                                                                                                          23.68 Annual hours


             This calculation is based on AFMS, 12A OPERATIONAL
             CONTRACTING, Dated 7 Dec 2001, Table 3




   For Official Use Only: Procurement Sensitive until the tentative cost comparison decision                40 of 40 08a293fa-1b7f-495f-ba50-79c0c79526c0.xls

						
Related docs
Other docs by cuh14130