Attachment_5_Government_Labor_Hours_N0016721R0004.xlsx
XLSX spreadsheet 21 KB Posted
- Attached to
- Environmental and Ship Motion Forecasting (ESMF) system Federal contract opportunity
- Solicitation number
- N0016721R0004
View the file
Other files for this federal contract opportunity
Show all 31
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Historical Analysis FD09FD10
| FD09/FD10 Last Two Years Historical Analysis | ||||||||||||||
| TOTAL | MDF or Cost Estimating TIs | KBS Historical | Historical Code 813 MSC Support | |||||||||||
| TO | Year | POP | Invoiced HRs | labor Invoiced | TI Hours | Obligated Labor | TI Hours | Obligated Labor | TI Hours | Obligated Labor | Rates | Hours | Cost | Rate |
| FD09 | BY | 1/14/15-1/13/16 | 34,566 | $3,117,760.18 | 46,675 | $3,589,789.87 | 8,936 | $797,960.00 | 37,739 | $2,791,829.87 | $73.98 | 0 | $0.00 | |
| FD09 | OY1 | 1/14/16-1/13/17 | 52,788 | $3,801,010.28 | 57,261 | $3,981,734.70 | 15,442 | $1,165,342.00 | 41,819 | $2,816,392.70 | $67.35 | 0 | $0.00 | |
| FD09 | OY2 | 1/14/17-1/13/18 | 62,036 | $4,700,630.00 | 53,227 | $4,103,130.48 | 709 | $46,000.00 | 52,518 | $4,057,130.48 | $77.25 | 3,849 | $384,930.00 | |
| FD09 | OY3 | 12/29/17-12/28/18 | 74,092 | $5,783,632.21 | 59,577 | $4,754,451.22 | 403 | $35,000.00 | 59,174 | $4,719,451.22 | $79.76 | 23,734 | $2,142,782.00 | $90.28 |
| FD09 | OY4 | 12/28/18-12/28/19 | TBD | TBD | 69,996 | $5,266,097.00 | 677 | $59,000.00 | 69,319 | $5,207,097.00 | $75.12 | 27,419 | $2,171,237.00 | $79.19 |
| FD10 | BY | $2,590,719.48 | |||||||
| FD10 | OY1 | $320,958.00 | |||||||
| FD10 | OY2 | 5/14/17-5/13/18 | 42,906 | $3,681,705.95 | 24,663 | $2,198,517.00 | 18,244 | $1,483,188.95 | $81.30 |
| FD10 | OY3 | 5/14/18-5/13/19 | 44,970 | $3,737,442.40 | 26,014 | $2,230,404.40 | 18,956 | $1,507,038.00 | $79.50 |
| FD09/FD10 KBS | 2017/2018 | 77,418 | $6,202,640.17 | $80.12 | |||||
| FD09/FD10 KBS | 2018/2019 | 88,275 | $6,714,135.00 | $76.06 | |||||
| Code 813 Future Requirements | |||||||||
| Employment Cost Index (ECI) Dec 2018 = 2.5% | ECI/year | Historical Hrs + Historical Travel + $2M/Yr | |||||||
| 2020 Annual KBS Labor Requirements (from HISTORICAL) | 2.5% | Hours | Cost | ODC | Total | ODC % | |||
| LOE Requirements = 2019 Hrs (88,275) x 2018 Rate x ECI | 88,275 | $7,249,319.50 | $82.12 | 27,419 | $2,251,703.10 | ERROR:#REF! | ERROR:#REF! | ||
| Plus-Up: Code 813 (Pete Connor) MSC N74/SRD work increase (email 3/27) - 2020 | ERROR:#REF! | ERROR:#REF! | $82.12 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||
| 2020 Annual KBS Requirements (BY) (Initial) | ERROR:#REF! | ERROR:#REF! | $82.12 | ||||||
| 2020 Annual KBS Requirements (BY) (Rounded) | 111,000 | $9,115,541.94 | $82.12 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
2021 Annual KBS Requirements (OY1) 111,000 $9,343,430.49 $84.18 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
2022 Annual KBS Requirements (OY2) 111,000 $9,577,016.25 $86.28 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
2023 Annual KBS Requirements (OY3) 111,000 $9,577,016.25 $88.44 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
2024 Annual KBS Requirements (OY4) 111,000 $9,577,016.25 $90.65 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
| KBS 5 Year Task Order LABOR Requirements | 555,000 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||
| ODC % | |||||||
| KBS 5 Year Task Order ODC Requirements | ERROR:#REF! | 5% | ERROR:#REF! | ERROR:#REF! |
TOTAL KBS Requirements ERROR:#REF! ERROR:#REF!
Sheet1 A. Government's Level of Effort Requirements
| Labor Categories | Labor Mix | Total | Base Year Hours | OY1 Hours | OY2 Hours | OY3 Hours | OY4 Hours |
| Contractor Site, Key Personnel | |||||||
| Program Manager (Lead POC) | Senior | 5,000.0 | 1,000.0 | 1,000.0 | 1,000.0 | 1,000.0 | 1,000.0 |
| Principal Engineer (Lead TPOC) | Senior | 2,500.0 | 500.0 | 500.0 | 500.0 | 500.0 | 500.0 |
| Senior Scientist | Senior | 2,500.0 | 500.0 | 500.0 | 500.0 | 500.0 | 500.0 |
| Principal Scientist | Senior | 5,000.0 | 1,000.0 | 1,000.0 | 1,000.0 | 1,000.0 | 1,000.0 |
| Contractor Site, Non-Key Personnel | |||||||
| Engineer (Software) - Senior | Senior | 7,750.0 | 1,550.0 | 1,550.0 | 1,550.0 | 1,550.0 | 1,550.0 |
| Engineer (Mechanical) - Senior | Senior | 3,750.0 | 750.0 | 750.0 | 750.0 | 750.0 | 750.0 |
| Engineer (Mechanical) - Journeyman | Mid-Level | 7,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 |
| Engineer (Software) - Junior | Junior | 7,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 | 1,500.0 |
| Task Order Administrator (Schedule and Financials) | Mid-Level | 3,500.0 | 700.0 | 700.0 | 700.0 | 700.0 | 700.0 |
| Contractor Site Hours | 45,000.0 | 9,000.0 | 9,000.0 | 9,000.0 | 9,000.0 | 9,000.0 |
B. Labor Mix Allocation Across Experience Levels
Requirement Senior Mid-Level Junior Total
| Hours | 26,500.0 | 11,000.0 | 7,500.0 | 45,000.0 |
| Percentage of Personnel as Compared to Total Number of Labor Resources | 59% | 24% | 17% | 100% |
| Professional Experience in their Specific Task Area(s) | 10 years or more | Greater than 3 and less than 10 years | 3 years of less |
C. Allocations of Total Direct Labor Hours Per Geographic Location
Requirement Government Facilities Contractor Facilities
Percentage of Personnel as Compared to Total Number of Labor Resources 0% 100%
File details come from the government source that posted it. Updated .