The file's text, extracted by GovTribe without its formatting.
Years 1-5
| 692M15-21-R-00008 - Attachment B-1 |
| Aviation Weather Technical and Engineering Support | |
Offeror's Name:
| Instructions and Notes: |
| a. Fill in yellow cells only. This pricing spreadsheet has been protected so that ONLY the yellow cells can be changed. |
| b. Enter Offeror's name, proposed escalation rate, AHR rate and fully burdened labor rate in Column D (yellow cells). The spreadsheet will calculate labor rates for Years 2 through 5, and the application of AHR to travel and ODCs. |
| c. The above fully burdened labor rates will be utilized by the Prime Offeror and any of its subcontractors/team members utilized in performance this Contract. |
| d. *The Program Manager labor category will be provided by the Offeror as an indirect cost to the Contract, and therefore is not calculated in this spreadsheet. It is marked as N/A (not applicable) and grayed out in this spreadsheet. |
| e. If the Subject Matter Expert (SME) labor category is required under this Contract, that rate will be negotiated on a case-by-case basis according to the level of expertise the individual Task Order requires. It is marked with zero hours and protected in this spreadsheet. |
| Percentages |
| Escalation Rate for Years 2 through 5 | 0.00% |
| Administrative Handling Rate (AHR) | 0.00% |
Deepak: Base Year = 1Nov 2013 - 31Dec 2013
| CLIN 00001 - Year 1 | | | CLIN 00002 - Year 2 | | | CLIN 00003 - Year 3 | | | CLIN 00004 - Year 4 | | | CLIN 00005 - Year 5 | | | Labor Summary | | | |
| | 11/3/2021 - 11/2/2022 | | | 11/3/2022 - 11/2/2023 | | | 11/3/2023 - 11/2/2024 | | | 11/3/2024 - 11/2/2025 | | | 11/3/2025 - 11/2/2026 | | | Year 1-5 Totals | |
| | Est Hrs | Fully Burdened Labor Rate | Extended Price | Est Hrs | Fully Burdened Labor Rate | Extended Price | Est Hrs | Fully Burdened Labor Rate | Extended Price | Est Hrs | Fully Burdened Labor Rate | Extended Price | Est Hrs | Fully Burdened Labor Rate | Extended Price | Est Hrs | Extended Price |
| *Program Manager | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |
| Systems Engineer 1 | 5640 | $0.00 | $0.00 | 5640 | $0.00 | $0.00 | 5640 | $0.00 | $0.00 | 5640 | $0.00 | $0.00 | 5640 | $0.00 | $0.00 | 28200 | $0.00 |
| Systems Engineer 2 | 960 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 8480 | $0.00 |
| Systems Engineer 3 | 1880 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 6640 | $0.00 |
| Systems Engineer 4 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 2300 | $0.00 |
| Radar Systems Engineer 1 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 2300 | $0.00 |
| Radar Systems Engineer 2 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 2300 | $0.00 |
| Radar Systems Engineer 3 | 160 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 2000 | $0.00 |
| Software Engineer 1 | 5720 | $0.00 | $0.00 | 5720 | $0.00 | $0.00 | 5720 | $0.00 | $0.00 | 5720 | $0.00 | $0.00 | 5720 | $0.00 | $0.00 | 28600 | $0.00 |
| Software Engineer 2 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 4800 | $0.00 |
| Software Engineer 3 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 4800 | $0.00 |
| Software Engineer 4 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 2300 | $0.00 |
| Human Factors Specialist 1 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 15040 | $0.00 |
| Human Factors Specialist 2 | 3760 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 5640 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 20680 | $0.00 |
| Human Factors Specialist 3 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 9400 | $0.00 |
| Meteorologist 1 (*1 key position) | 5720 | $0.00 | $0.00 | 5720 | $0.00 | $0.00 | 5720 | $0.00 | $0.00 | 5720 | $0.00 | $0.00 | 5720 | $0.00 | $0.00 | 28600 | $0.00 |
| Meteorologist 2 | 3760 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 18800 | $0.00 |
| Meteorologist 3 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 9400 | $0.00 |
| Meteorologist 4 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 4800 | $0.00 |
| Information Technology Specialist 1 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 9400 | $0.00 |
| Information Technology Specialist 2 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 7980 | $0.00 |
| Information Technology Specialist 3 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 2300 | $0.00 |
| Subject Matter Expert (SME) | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 |
| Project Analyst | 2600 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 3760 | $0.00 | $0.00 | 17640 | $0.00 |
| Technical Professional | 460 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 1410 | $0.00 | $0.00 | 4750 | $0.00 |
| Technician | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 2800 | $0.00 |
| Air Traffic Control Specialist (ATCS) | 160 | $0.00 | $0.00 | 160 | $0.00 | $0.00 | 160 | $0.00 | $0.00 | 160 | $0.00 | $0.00 | 160 | $0.00 | $0.00 | 800 | $0.00 |
| Senior Aviation Analyst | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 2300 | $0.00 |
| Operations Research Analyst | 160 | $0.00 | $0.00 | 160 | $0.00 | $0.00 | 160 | $0.00 | $0.00 | 160 | $0.00 | $0.00 | 160 | $0.00 | $0.00 | 800 | $0.00 |
| Principal Research Scientist/Engineer | 0 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 1880 | $0.00 | $0.00 | 960 | $0.00 | $0.00 | 460 | $0.00 | $0.00 | 4260 | $0.00 |
| Task Lead | 300 | $0.00 | $0.00 | 300 | $0.00 | $0.00 | 250 | $0.00 | $0.00 | 200 | $0.00 | $0.00 | 350 | $0.00 | $0.00 | 1400 | $0.00 |
| Labor Totals | 46,780 | | $0.00 | 49,700 | | $0.00 | 52,450 | | $0.00 | 52,440 | | $0.00 | 52,500 | | $0.00 | 253,870 | $0.00 |
| Estimated Travel | | | $84,400.00 | | | $162,100.00 | | | $126,600.00 | | | $135,400.00 | | | $42,300.00 | | $550,800.00 |
| Travel AHR | | | $0.00 | | | $0.00 | | | $0.00 | | | $0.00 | | | $0.00 | | $0.00 |
| Total Travel | | | $84,400.00 | | | $162,100.00 | | | $126,600.00 | | | $135,400.00 | | | $42,300.00 | | $550,800.00 |
| Estimated ODCs | | | $5,000.00 | | | $5,000.00 | | | $6,000.00 | | | $5,000.00 | | | $3,000.00 | | $24,000.00 |
| ODC AHR | | | $0.00 | | | $0.00 | | | $0.00 | | | $0.00 | | | $0.00 | | $0.00 |
| Total ODCs | | | $5,000.00 | | | $5,000.00 | | | $6,000.00 | | | $5,000.00 | | | $3,000.00 | | $24,000.00 |
| Total Travel and ODCs | | | $89,400.00 | | | $167,100.00 | | | $132,600.00 | | | $140,400.00 | | | $45,300.00 | | $574,800.00 |
| Total Maximum Contract Ceiling | | | $89,400.00 | | | $167,100.00 | | | $132,600.00 | | | $140,400.00 | | | $45,300.00 | | $574,800.00 |
Summary
| Aviation Weather Technical and Engineering Support | | | |
| CLIN 00001 - Year 1 | | | |
| Total Labor | 46,780 | Hours | $0.00 |
| Estimated Travel w/AHR | | | $84,400.00 |
| Estimated ODCs w/AHR | | | $5,000.00 |
| Total Travel and ODCs w/AHR | | | $89,400.00 |
| Total (Year 1) | | | $89,400.00 |
| CLIN 00002 - Year 2 | | | |
| Total Labor | 49,700 | Hours | $0.00 |
| Estimated Travel w/AHR | | | $162,100.00 |
| Estimated ODCs w/AHR | | | $5,000.00 |
| Total Travel and ODCs w/AHR | | | $167,100.00 |
| Total (Year 2) | | | $167,100.00 |
| CLIN 00003 - Year 3 | | | |
| Total Labor | 52,450 | Hours | $0.00 |
| Estimated Travel w/AHR | | | $126,600.00 |
| Estimated ODCs w/AHR | | | $6,000.00 |
| Total Travel and ODCs w/AHR | | | $132,600.00 |
| Total (Year 3) | | | $132,600.00 |
| CLIN 00004 - Year 4 | | | |
| Total Labor | 52,440 | Hours | $0.00 |
| Estimated Travel w/AHR | | | $135,400.00 |
| Estimated ODCs w/AHR | | | $5,000.00 |
| Total Travel and ODCs w/AHR | | | $140,400.00 |
| Total (Year 4) | | | $140,400.00 |
| CLIN 00005 - Year 5 | | | |
| Total Labor | 52,500 | Hours | $0.00 |
| Estimated Travel wAHR | | | $42,300.00 |
| Estimated ODCs w/AHR | | | $3,000.00 |
| Total Travel and ODCs w/AHR | | | $45,300.00 |
| Total (Year 5 | | | $45,300.00 |
| Total | | | |
| Total Labor | 253,870 | Hours | $0.00 |
| Estimated Travel w/AHR | | | $550,800.00 |
| Estimated ODCs w/AHR | | | $24,000.00 |
| Total Travel and ODCs w/AHR | | | $574,800.00 |
| Total Maximum Contract Ceiling | | | $574,800.00 |