ATTACHMENT 9 - PRICING SCHEDULE.xlsx
XLSX spreadsheet 700 KB Posted
- Solicitation number
- 75F40123R00132
About this file
This document provides a template for an Independent Government Cost Estimate (IGCE) for a Scientific Support Services Indefinite Delivery Indefinite Quantity (IDIQ) contract opportunity with the Food and Drug Administration. The template includes tables to estimate labor hours, labor rates, and costs by task area and ordering period for various FDA centers and offices requiring scientific support. It provides instructions and placeholders to populate labor categories, allocation percentages, and annual full-time equivalent hours. Totals for direct labor and other direct costs roll up across task areas and ordering periods and are intended to link to an IGCE summary table. The template aims to capture estimated costs for scientific support labor categories across multiple locations and time periods involved in the IDIQ opportunity.
View the file
Other files
Show all 27
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
T1. Cover Page
Tab 1. - FDA Scientific Support IDIQ
Section 1. General Information Section 3. Overall Cost / LOE Summary
| Agency: | FDA | Total Cost |
| Center: | FDA wide (all Centers) | |
| Office: | NA | Ordering Period 1 |
| Contract Vehicle: | IDIQ | Ordering Period 2 |
| Contract Specialist | Howard S. Yablon | Ordering Period 3 |
| Contract Name: | FDA wide Scientific Support IDIQ | Ordering Period 4 |
| Contract Type: | Firm Fixed Price & Labor Hour | |
| Date: | ||
| Section 2. Cost Estimate Documentation |
| Area 1. Estimated Period of Performance | Total Hours / LOE | 773,920 | ||
| Schedule | ||||
| Ordering Period 1 | 09/03/2023 - 09/02/2024 | Ordering Period 1 | 193,960 | |
| Ordering Period 2 | 09/03/2024 - 09/02/2025 | Ordering Period 2 | 193,960 | 0 |
| Ordering Period 3 | 09/03/2025 - 09/02/2026 | Ordering Period 3 | 193,960 | 0 |
| Ordering Period 4 | 09/03/2026 - 09/02/2027 | Ordering Period 4 | 192,040 | 0 |
| Base Year (BY) |
| Option Year 1 (OY1) |
| Option Year 2 (OY2) |
| Option Year 3 (OY3) |
| Option Year 4 (OY4) |
T2. IGCE Labor Rates Tab 2. CDER SS IDIQ Labor Rate & Catagories
Tab 2. CDER SS IDIQ Labor Categories & Rates
| Both (Government and Contractor Rates) | Base Year | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | ||
| LCAT Name | Both Site | Both Site | Both Site | Both Site | Both Site | ||
| Analyst I | $53.0 | $54.3 | $55.7 | $57.1 | $58.5 | ||
| Analyst II | $96.0 | $98.4 | $100.9 | $103.4 | $106.0 | ||
| Analyst III | $103.0 | $105.6 | $108.2 | $110.9 | $113.7 | ||
| Analyst IV | $123.5 | $126.6 | $129.8 | $133.0 | $136.3 | ||
| Analyst V | $153.0 | $156.8 | $160.7 | $164.8 | $168.9 | ||
| Application Developer/Programmer - I | $82.0 | $84.1 | $86.2 | $88.3 | $90.5 | ||
| Application Developer/Programmer - II | $96.0 | $98.4 | $100.9 | $103.4 | $106.0 | ||
| Application Developer/Programmer - III (Application Engineer III) | $110.0 | $112.8 | $115.6 | $118.5 | $121.4 | ||
| Application Developer/Programmer - IV - (Application Engineer IV) | $123.5 | $126.6 | $129.8 | $133.0 | $136.3 | ||
| Application Developer/Programmer - V (Application Engineer V) | $137.0 | $140.4 | $143.9 | $147.5 | $151.2 | ||
| Business Process Analyst I | $93.0 | $95.3 | $97.7 | $100.2 | $102.7 | ||
| Business Process Analyst II | $110.0 | $112.8 | $115.6 | $118.5 | $121.4 | ||
| Business Process Analyst III | $127.0 | $130.2 | $133.4 | $136.8 | $140.2 | ||
| Business Process Analyst IV | $144.0 | $147.6 | $151.3 | $155.1 | $158.9 | ||
| Business Process Analyst V | $161.0 | $165.0 | $169.2 | $173.4 | $177.7 | ||
| Clinical Information / Data Analyst- Senior | $134.0 | $137.4 | $140.8 | $144.3 | $147.9 | Scienctific Analyst | or Data Analyst |
| Data Analyst - I | $72.0 | $73.8 | $75.6 | $77.5 | $79.5 | ||
| Data Analyst - II | $87.5 | $89.7 | $91.9 | $94.2 | $96.6 | ||
| Data Analyst - III | $103.0 | $105.6 | $108.2 | $110.9 | $113.7 | ||
| Data Analyst - IV | $118.5 | $121.5 | $124.5 | $127.6 | $130.8 | ||
| Data Analyst -V | $134.0 | $137.4 | $140.8 | $144.3 | $147.9 | ||
| Data Architect I | $98.0 | $100.5 | $103.0 | $105.5 | $108.2 | ||
| Data Architect II | $117.5 | $120.4 | $123.4 | $126.5 | $129.7 | ||
| Data Architect III | $137.0 | $140.4 | $143.9 | $147.5 | $151.2 | ||
| Data Architect IV | $156.5 | $160.4 | $164.4 | $168.5 | $172.7 | ||
| Data Architect V | $176.0 | $180.4 | $184.9 | $189.5 | $194.3 | ||
| Data Entry Specialist I | $26.0 | $26.7 | $27.3 | $28.0 | $28.7 | ||
| Data Entry Specialist II | $36.0 | $36.9 | $37.8 | $38.8 | $39.7 | ||
| Data Entry Specialist III | $46.0 | $47.2 | $48.3 | $49.5 | $50.8 | ||
| Data Entry Specialist IV | $55.5 | $56.9 | $58.3 | $59.8 | $61.3 | ||
| Data Entry Specialist V | $65.0 | $66.6 | $68.3 | $70.0 | $71.7 | ||
| Data Manager I | $71.0 | $72.8 | $74.6 | $76.5 | $78.4 | ||
| Data Manager II | $90.0 | $92.3 | $94.6 | $96.9 | $99.3 | ||
| Data Manager III | $109.0 | $111.7 | $114.5 | $117.4 | $120.3 | ||
| Data Manager IV | $128.5 | $131.7 | $135.0 | $138.4 | $141.8 | ||
| Data Manager V | $148.0 | $151.7 | $155.5 | $159.4 | $163.4 | ||
| Data Scientist I | $95.0 | $97.4 | $99.8 | $102.3 | $104.9 | ||
| Data Scientist II | $124.0 | $127.1 | $130.3 | $133.5 | $136.9 | ||
| Data Scientist III | $153.0 | $156.8 | $160.7 | $164.8 | $168.9 | ||
| Data Scientist IV | $182.0 | $186.6 | $191.2 | $196.0 | $200.9 | ||
| Data Scientist V | $211.0 | $216.3 | $221.7 | $227.2 | $232.9 | ||
| Database Administrator I | $83.0 | $85.1 | $87.2 | $89.4 | $91.6 | ||
| Database Administrator II | $98.0 | $100.5 | $103.0 | $105.5 | $108.2 | ||
| Database Administrator III | $113.0 | $115.8 | $118.7 | $121.7 | $124.7 | ||
| Database Administrator IV | $127.5 | $130.7 | $134.0 | $137.3 | $140.7 | ||
| Database Administrator V | $142.0 | $145.6 | $149.2 | $152.9 | $156.7 | ||
| Engineer, General (Chemical, Mechanical, Electrical, Environmental, Biosystems, Food) I | $80.0 | $82.0 | $84.1 | $86.2 | $88.3 | ||
| Engineer, General (Chemical, Mechanical, Electrical, Environmental, Biosystems, Food) II | $99.5 | $102.0 | $104.5 | $107.2 | $109.8 | ||
| Engineer, General (Chemical, Mechanical, Electrical, Environmental, Biosystems, Food) III | $119.0 | $122.0 | $125.0 | $128.1 | $131.4 | ||
| Engineer, General (Chemical, Mechanical, Electrical, Environmental, Biosystems, Food) IV | $138.5 | $142.0 | $145.5 | $149.1 | $152.9 | ||
| Engineer, General (Chemical, Mechanical, Electrical, Environmental, Biosystems, Food) IV | $158.0 | $162.0 | $166.0 | $170.1 | $174.4 | ||
| Evaluation Specialist I | $65.0 | $66.6 | $68.3 | $70.0 | $71.7 | ||
| Evaluation Specialist II | $83.0 | $85.1 | $87.2 | $89.4 | $91.6 | ||
| Evaluation Specialist III | $102.0 | $104.6 | $107.2 | $109.8 | $112.6 | ||
| Evaluation Specialist IV | $121.0 | $124.0 | $127.1 | $130.3 | $133.6 | ||
| Evaluation Specialist V | $140.0 | $143.5 | $147.1 | $150.8 | $154.5 | ||
| Functional Expert Consultant I | $94.0 | $96.4 | $98.8 | $101.2 | $103.8 | ||
| Functional Expert Consultant II | $97.0 | $99.4 | $101.9 | $104.5 | $107.1 | ||
| Functional Expert Consultant III | $100.0 | $102.5 | $105.1 | $107.7 | $110.4 | ||
| Functional Expert Consultant IV | $103.0 | $105.6 | $108.2 | $110.9 | $113.7 | ||
| Functional Expert Consultant IV | $106.0 | $108.7 | $111.4 | $114.2 | $117.0 | ||
| Informatics I | $104.0 | $106.6 | $109.3 | $112.0 | $114.8 | ||
| Informatics II | $121.5 | $124.5 | $127.7 | $130.8 | $134.1 | ||
| Informatics III | $139.0 | $142.5 | $146.0 | $149.7 | $153.4 | ||
| Informatics IV | $157.0 | $160.9 | $164.9 | $169.1 | $173.3 | ||
| Informatics V | $175.0 | $179.4 | $183.9 | $188.5 | $193.2 | ||
| IT Engineer I | $122.0 | $125.1 | $128.2 | $131.4 | $134.7 | ||
| IT Engineer II | $137.0 | $140.4 | $143.9 | $147.5 | $151.2 | ||
| IT Engineer III | $152.0 | $155.8 | $159.7 | $163.7 | $167.8 | ||
| IT Engineer IV | $167.0 | $171.2 | $175.5 | $179.8 | $184.3 | ||
| IT Engineer V | $182.0 | $186.6 | $191.2 | $196.0 | $200.9 | ||
| Instructional Systems Designer I | $79.0 | $81.0 | $83.0 | $85.1 | $87.2 | ||
| Instructional Systems Designer II | $95.0 | $97.4 | $99.8 | $102.3 | $104.9 | ||
| Instructional Systems Designer III | $111.0 | $113.8 | $116.6 | $119.5 | $122.5 | ||
| Instructional Systems Designer IV | $127.0 | $130.2 | $133.4 | $136.8 | $140.2 | ||
| Instructional Systems Designer V | $143.0 | $146.6 | $150.2 | $154.0 | $157.8 | ||
| Investigator I | $95.0 | $97.4 | $99.8 | $102.3 | $104.9 | ||
| Investigator II | $123.5 | $126.6 | $129.8 | $133.0 | $136.3 | ||
| Investigator III | $152.0 | $155.8 | $159.7 | $163.7 | $167.8 | ||
| Investigator IV - Principal Investigator I | $180.0 | $184.5 | $189.1 | $193.8 | $198.7 | ||
| Investigator V - (Principal II Investigator) | $208.0 | $213.2 | $218.5 | $224.0 | $229.6 | ||
| Lab Technician I | $59.7 | $61.1 | $62.7 | $64.2 | $65.8 | ||
| Lab Technician II | $70.0 | $71.8 | $73.6 | $75.4 | $77.3 | ||
| Lab Technician III | $80.4 | $82.4 | $84.5 | $86.6 | $88.7 | ||
| Lab Technician IV | $100.7 | $103.2 | $105.8 | $108.4 | $111.2 | ||
| Lab Technician V | $121.0 | $124.0 | $127.1 | $130.3 | $133.6 | ||
| Lab Technical Support I | $43.5 | $44.6 | $45.7 | $46.8 | $48.0 | ||
| Lab Technical Support II | $45.8 | $46.9 | $48.1 | $49.3 | $50.6 | ||
| Lab Technical Support III | $48.0 | $49.2 | $50.4 | $51.7 | $53.0 | ||
| Lab Technical Support IV | $57.9 | $59.3 | $60.8 | $62.3 | $63.9 | ||
| Lab Technical Support V | $67.8 | $69.5 | $71.2 | $73.0 | $74.8 | ||
| Microbiologist I | $63.0 | $64.6 | $66.2 | $67.8 | $69.5 | ||
| Microbiologist II | $82.0 | $84.1 | $86.2 | $88.3 | $90.5 | ||
| Microbiologist III | $101.0 | $103.5 | $106.1 | $108.8 | $111.5 | ||
| Microbiologist IV | $120.0 | $123.0 | $126.1 | $129.2 | $132.5 | ||
| Microbiologist V | $139.0 | $142.5 | $146.0 | $149.7 | $153.4 | ||
| Pharmacist I | $138.5 | $142.0 | $145.6 | $149.2 | $152.9 | ||
| Pharmacist II | $148.0 | $151.7 | $155.5 | $159.4 | $163.4 | ||
| Pharmacist III | $158.0 | $162.0 | $166.0 | $170.1 | $174.4 | ||
| Pharmacist IV | $168.0 | $172.2 | $176.5 | $180.9 | $185.4 | ||
| Pharmacist V | $178.1 | $182.6 | $187.1 | $191.8 | $196.6 | ||
| Pharmacy Technician I | $32.7 | $33.5 | $34.3 | $35.2 | $36.1 | ||
| Pharmacy Technician II | $36.9 | $37.8 | $38.7 | $39.7 | $40.7 | ||
| Pharmacy Technician III | $41.1 | $42.1 | $43.1 | $44.2 | $45.3 | ||
| Pharmacy Technician IV | $45.3 | $46.4 | $47.6 | $48.8 | $50.0 | ||
| Pharmacy Technician V | $49.5 | $50.7 | $52.0 | $53.3 | $54.6 | ||
| Post-bac | $0.0 | $0.0 | $0.0 | $0.0 | |||
| Principle I | $211.0 | $216.3 | $221.7 | $227.2 | $232.9 | ||
| Principle II | $235.0 | $240.9 | $246.9 | $253.1 | $259.4 | ||
| Programmer I | $82.0 | $84.1 | $86.2 | $88.3 | $90.5 | ||
| Programmer II | $102.0 | $104.6 | $107.2 | $109.8 | $112.6 | ||
| Programmer III | $122.0 | $125.1 | $128.2 | $131.4 | $134.7 | ||
| Programmer IV | $141.0 | $144.5 | $148.1 | $151.8 | $155.6 | ||
| Programmer V | $161.0 | $165.0 | $169.2 | $173.4 | $177.7 | ||
| Program Manager I | $127.0 | $130.2 | $133.4 | $136.8 | $140.2 | ||
| Program Manager II | $170.4 | $174.6 | $179.0 | $183.4 | $188.0 | ||
| Program Manager III | $213.7 | $219.0 | $224.5 | $230.1 | $235.9 | ||
| Program Manager IV | $255.4 | $261.7 | $268.3 | $275.0 | $281.9 | ||
| Program Manager V | $297.0 | $304.4 | $312.0 | $319.8 | $327.8 | ||
| Project Coordinator I | $57.0 | $58.4 | $59.9 | $61.4 | $62.9 | ||
| Project Coordinator II | $72.0 | $73.8 | $75.6 | $77.5 | $79.5 | ||
| Project Coordinator III | $87.0 | $89.2 | $91.4 | $93.7 | $96.0 | ||
| Project Coordinator IV | $102.0 | $104.6 | $107.2 | $109.8 | $112.6 | ||
| Project Coordinator V | $117.0 | $119.9 | $122.9 | $126.0 | $129.1 | ||
| Project Manager I | $57.0 | $58.4 | $59.9 | $61.4 | $62.9 | ||
| Project Manager II | $72.0 | $73.8 | $75.6 | $77.5 | $79.5 | ||
| Project Manager III | $87.0 | $89.2 | $91.4 | $93.7 | $96.0 | ||
| Project Manager IV | $102.0 | $104.6 | $107.2 | $109.8 | $112.6 | ||
| Project Manager V | $117.0 | $119.9 | $122.9 | $126.0 | $129.1 | ||
| Lead Quality Assurance Specialist | $0.0 | $0.0 | $0.0 | $0.0 | need level | ||
| Quality Assurance Specialist I | $68.0 | $69.7 | $71.4 | $73.2 | $75.1 | ||
| Quality Assurance Specialist II | $81.5 | $83.5 | $85.6 | $87.8 | $90.0 | ||
| Quality Assurance Specialist III | $95.0 | $97.4 | $99.8 | $102.3 | $104.9 | ||
| Quality Assurance Specialist IV | $108.0 | $110.7 | $113.5 | $116.3 | $119.2 | ||
| Quality Assurance Specialist V | $121.0 | $124.0 | $127.1 | $130.3 | $133.6 | ||
| Researcher I | $84.0 | $86.1 | $88.3 | $90.5 | $92.7 | ||
| Researcher II | $106.5 | $109.2 | $111.9 | $114.7 | $117.6 | ||
| Researcher III | $129.0 | $132.2 | $135.5 | $138.9 | $142.4 | ||
| Researcher IV | $151.5 | $155.3 | $159.2 | $163.1 | $167.2 | ||
| Researcher V | $174.0 | $178.4 | $182.8 | $187.4 | $192.1 | ||
| Research Analyst I | $65.0 | $66.6 | $68.3 | $70.0 | $71.7 | ||
| Research Analyst II | $86.5 | $88.7 | $90.9 | $93.2 | $95.5 | ||
| Research Analyst III | $108.0 | $110.7 | $113.5 | $116.3 | $119.2 | ||
| Research Analyst IV | $129.5 | $132.7 | $136.1 | $139.5 | $142.9 | ||
| Research Analyst V | $151.0 | $154.8 | $158.6 | $162.6 | $166.7 | ||
| Research Assistant I | $48.0 | $49.2 | $50.4 | $51.7 | $53.0 | ||
| Research Assistant II | $60.0 | $61.5 | $63.0 | $64.6 | $66.2 | ||
| Research Assistant III | $72.0 | $73.8 | $75.6 | $77.5 | $79.5 | ||
| Research Assistant IV | $84.0 | $86.1 | $88.3 | $90.5 | $92.7 | ||
| Research Assistant V | $96.0 | $98.4 | $100.9 | $103.4 | $106.0 | ||
| Scientist I | $153.0 | $156.8 | $160.7 | $164.8 | $168.9 | ||
| Scientist II | $186.0 | $190.7 | $195.4 | $200.3 | $205.3 | ||
| Scientist III | $219.0 | $224.5 | $230.1 | $235.8 | $241.7 | ||
| Scientist IV | $257.5 | $263.9 | $270.5 | $277.3 | $284.2 | ||
| Senior Scientist – Ph.D. | $296.0 | $303.4 | $311.0 | $318.8 | $326.7 | ||
| Subject Matter Expert I | $128.0 | $131.2 | $134.5 | $137.8 | $141.3 | ||
| Subject Matter Expert II | $165.5 | $169.6 | $173.9 | $178.2 | $182.7 | ||
| Subject Matter Expert III | $203.0 | $208.1 | $213.3 | $218.6 | $224.1 | ||
| Subject Matter Expert IV | $240.5 | $246.5 | $252.7 | $259.0 | $265.5 | ||
| Subject Matter Expert V | $278.0 | $285.0 | $292.1 | $299.4 | $306.9 | ||
| Statistician I | $85.0 | $87.1 | $89.3 | $91.5 | $93.8 | ||
| Statistician II | $108.5 | $111.2 | $114.0 | $116.8 | $119.8 | ||
| Statistician III | $132.0 | $135.3 | $138.7 | $142.1 | $145.7 | ||
| Statistician IV | $155.5 | $159.4 | $163.4 | $167.5 | $171.6 | ||
| Statistician V | $179.0 | $183.5 | $188.1 | $192.8 | $197.6 | ||
| Student Intern | $0.0 | $0.0 | $0.0 | $0.0 | |||
| Technical Writer I | $64.0 | $65.6 | $67.2 | $68.9 | $70.6 | ||
| Technical Writer II | $77.5 | $79.4 | $81.4 | $83.5 | $85.5 | ||
| Technical Writer III | $91.0 | $93.3 | $95.6 | $98.0 | $100.4 | ||
| Technical Writer IV | $104.5 | $107.1 | $109.8 | $112.5 | $115.3 | ||
| Technical Writer V | $118.0 | $121.0 | $124.0 | $127.1 | $130.2 | ||
| Training Specialist I | $70.0 | $71.8 | $73.5 | $75.4 | $77.3 | ||
| Training Specialist II | $85.5 | $87.6 | $89.8 | $92.1 | $94.4 | ||
| Training Specialist III | $101.0 | $103.5 | $106.1 | $108.8 | $111.5 | ||
| Training Specialist IV | $116.0 | $118.9 | $121.9 | $124.9 | $128.0 | ||
| Training Specialist V | $131.0 | $134.3 | $137.6 | $141.1 | $144.6 |
T2. Labor Rates Tab 2. CDER SS IDIQ Labor Rate & Catagories
Tab 2. CDER SS IDIQ Labor Categories & Rates
| Government Rates - No Visa Assistance | Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | |
| LCAT Name | Gov Site | Gov Site | Gov Site | Gov Site | |
| 1 | Scientific Admin Support I | ||||
| 2 | Scientific Admin Support II | ||||
| 3 | Scientific Admin Support III | ||||
| 4 | Scientific Admin Support IV | ||||
| 5 | Scientific Admin Support V | ||||
| 6 | Analyst I | ||||
| 7 | Analyst II | ||||
| 8 | Analyst III | ||||
| 9 | Analyst IV | ||||
| 10 | Analyst V | ||||
| 11 | Application Developer/Programmer- I | ||||
| 12 | Application Developer/Programmer- II | ||||
| 13 | Application Developer/Programmer - III (Application Engineer III) | ||||
| 14 | Application Developer/Programmer - IV - (Application Engineer IV) | ||||
| 15 | Application Developer/Programmer- V (Application Engineer V) | ||||
| 16 | Bioinformatician I | ||||
| 17 | Bioinformatician II | ||||
| 18 | Bioinformatician III | ||||
| 19 | Bioinformatician IV | ||||
| 20 | Bioinformatician V | ||||
| 21 | Bioinformatics Analyst I | ||||
| 22 | Bioinformatics Analyst II | ||||
| 23 | Bioinformatics Analyst III | ||||
| 24 | Bioinformatics Analyst IV | ||||
| 25 | Bioinformatics Analyst V | ||||
| 26 | Biomedical Informatics Specialist I | ||||
| 27 | Biomedical Informatics Specialist II | ||||
| 28 | Biomedical Informatics Specialist III | ||||
| 29 | Biomedical Informatics Specialist IV | ||||
| 30 | Biomedical Informatics Specialist V | ||||
| 31 | Business Process Analyst I | ||||
| 32 | Business Process Analyst II | ||||
| 33 | Business Process Analyst III | ||||
| 34 | Business Process Analyst IV | ||||
| 35 | Business Process Analyst V | ||||
| 36 | Clinical Trial Coordinator I | ||||
| 37 | Clinical Trial CoordinatorI II | ||||
| 38 | Clinical Trial Coordinator III | ||||
| 39 | Clinical Trial Coordinator IV | ||||
| 40 | Clinical Trial Coordinator V | ||||
| 41 | Clinical Information / Data Analyst- Senior | ||||
| 42 | Data Analyst - I | ||||
| 43 | Data Analyst - II | ||||
| 44 | Data Analyst - III | ||||
| 45 | Data Analyst - IV | ||||
| 46 | Data Analyst -V | ||||
| 47 | Data Architect I | ||||
| 48 | Data Architect II | ||||
| 49 | Data Architect III | ||||
| 50 | Data Architect IV | ||||
| 51 | Data Architect V | ||||
| 52 | Data Entry Specialist I | ||||
| 53 | Data Entry Specialist II | ||||
| 54 | Data Entry Specialist III | ||||
| 55 | Data Entry Specialist IV | ||||
| 56 | Data Entry Specialist V | ||||
| 57 | Data Manager I | ||||
| 58 | Data Manager II | ||||
| 59 | Data Manager III | ||||
| 60 | Data Manager IV | ||||
| 61 | Data Manager V | ||||
| 62 | Data Scientist I | ||||
| 63 | Data Scientist II | ||||
| 64 | Data Scientist III | ||||
| 65 | Data Scientist IV | ||||
| 66 | Data Scientist V | ||||
| 67 | Database Administrator I | ||||
| 68 | Database Administrator II | ||||
| 69 | Database Administrator III | ||||
| 70 | Database Administrator IV | ||||
| 71 | Database Administrator V | ||||
| 72 | Engineer, General (Chemical, Mechanical, Electrical, Environmental, Biosystems, Food) I | ||||
| 73 | Engineer, General (Chemical, Mechanical, Electrical, Environmental, Biosystems, Food) II | ||||
| 74 | Engineer, General (Chemical, Mechanical, Electrical, Environmental, Biosystems, Food) III | ||||
| 75 | Engineer, General (Chemical, Mechanical, Electrical, Environmental, Biosystems, Food) IV | ||||
| 76 | Engineer, General (Chemical, Mechanical, Electrical, Environmental, Biosystems, Food) IV | ||||
| 77 | Evaluation Specialist I | ||||
| 78 | Evaluation Specialist II | ||||
| 79 | Evaluation Specialist III | ||||
| 80 | Evaluation Specialist IV | ||||
| 81 | Evaluation Specialist V | ||||
| 82 | Functional Expert Consultant I | ||||
| 83 | Functional Expert Consultant II | ||||
| 84 | Functional Expert Consultant III | ||||
| 85 | Functional Expert Consultant IV | ||||
| 86 | Functional Expert Consultant IV | ||||
| 87 | High Performance Health IT Computing Specialist I | ||||
| 88 | High Performance Health IT Computing Specialist II | ||||
| 89 | High Performance Health IT Computing Specialist III | ||||
| 90 | High Performance Health IT Computing Specialist IV | ||||
| 91 | High Performance Health IT Computing Specialist V | ||||
| 92 | Informatics I | ||||
| 93 | Informatics II | ||||
| 94 | Informatics III | ||||
| 95 | Informatics IV | ||||
| 96 | Informatics V | ||||
| 97 | Health IT Computational Biologist I | ||||
| 98 | Health IT Computational Biologist II | ||||
| 99 | Health IT Computational Biologist III | ||||
| 100 | Health IT Computational Biologist IV | ||||
| 101 | Health IT Computational Biologist V | ||||
| 102 | IT Engineer I | ||||
| 103 | IT Engineer II | ||||
| 104 | IT Engineer III | ||||
| 105 | IT Engineer IV | ||||
| 106 | IT Engineer V | ||||
| 107 | Instructional Systems Designer I | ||||
| 108 | Instructional Systems Designer II | ||||
| 109 | Instructional Systems Designer III | ||||
| 110 | Instructional Systems Designer IV | ||||
| 111 | Instructional Systems Designer V | ||||
| 112 | Investigator I | ||||
| 113 | Investigator II | ||||
| 114 | Investigator III | ||||
| 115 | Investigator IV - (Principal I Investigator) | ||||
| 116 | Investigator V - (Principal II Investigator) | ||||
| 117 | Lab Technician I | ||||
| 118 | Lab Technician II | ||||
| 119 | Lab Technician III | ||||
| 120 | Lab Technician IV | ||||
| 121 | Lab Technician V | ||||
| 122 | Lab Technical Support I | ||||
| 123 | Lab Technical Support II | ||||
| 124 | Lab Technical Support III | ||||
| 125 | Lab Technical Support IV | ||||
| 126 | Lab Technical Support V | ||||
| 127 | Microbiologist I | ||||
| 128 | Microbiologist II | ||||
| 129 | Microbiologist III | ||||
| 130 | Microbiologist IV | ||||
| 131 | Microbiologist V | ||||
| 132 | Pharmacist I | ||||
| 133 | Pharmacist II | ||||
| 134 | Pharmacist III | ||||
| 135 | Pharmacist IV | ||||
| 136 | Pharmacist V | ||||
| 137 | Pharmacy Technician I | ||||
| 138 | Pharmacy Technician II | ||||
| 139 | Pharmacy Technician III | ||||
| 140 | Pharmacy Technician IV | ||||
| 141 | Pharmacy Technician V | ||||
| 142 | Principle I | ||||
| 143 | Principle II | ||||
| 144 | Programmer I | ||||
| 145 | Programmer II | ||||
| 146 | Programmer III | ||||
| 147 | Programmer IV | ||||
| 148 | Programmer V | ||||
| 149 | Program Manager I | ||||
| 150 | Program Manager II | ||||
| 151 | Program Manager III | ||||
| 152 | Program Manager IV | ||||
| 153 | Program Manager V | ||||
| 154 | Project Coordinator I | ||||
| 155 | Project Coordinator II | ||||
| 156 | Project Coordinator III | ||||
| 157 | Project Coordinator IV | ||||
| 158 | Project Coordinator V | ||||
| 159 | Project Manager I | ||||
| 160 | Project Manager II | ||||
| 161 | Project Manager III | ||||
| 162 | Project Manager IV | ||||
| 163 | Project Manager V | ||||
| 164 | Protocol Data Analyst I | ||||
| 165 | Protocol Data Analyst II | ||||
| 166 | Protocol Data Analyst III | ||||
| 167 | Protocol Data Analyst IV | ||||
| 168 | Protocol Data Analyst V | ||||
| 169 | Quality Assurance Specialist I | ||||
| 170 | Quality Assurance Specialist II | ||||
| 171 | Quality Assurance Specialist III | ||||
| 172 | Quality Assurance Specialist IV | ||||
| 173 | Quality Assurance Specialist V | ||||
| 174 | Regulatory Documentation Specialist I | ||||
| 175 | Regulatory Documentation Specialist II | ||||
| 176 | Regulatory Documentation Specialist III | ||||
| 177 | Regulatory Documentation Specialist IV | ||||
| 178 | Regulatory Documentation Specialist V | ||||
| 179 | Researcher I | ||||
| 180 | Researcher II | ||||
| 181 | Researcher III | ||||
| 182 | Researcher IV | ||||
| 183 | Researcher V | ||||
| 184 | Research Analyst I | ||||
| 185 | Research Analyst II | ||||
| 186 | Research Analyst III | ||||
| 187 | Research Analyst IV | ||||
| 188 | Research Analyst V | ||||
| 189 | Research Assistant I | ||||
| 190 | Research Assistant II | ||||
| 191 | Research Assistant III | ||||
| 192 | Research Assistant IV | ||||
| 193 | Research Assistant V | ||||
| 194 | Scientist I | ||||
| 195 | Scientist II | ||||
| 196 | Scientist III | ||||
| 197 | Scientist IV | ||||
| 198 | Senior Scientist – Ph.D. | ||||
| 199 | Scientific Data Analyst I | ||||
| 200 | Scientific Data Analyst II | ||||
| 201 | Scientific Data Analyst III | ||||
| 202 | Scientific Data Analyst IV | ||||
| 203 | Scientific Data Analyst V | ||||
| 204 | Subject Matter Expert I | ||||
| 205 | Subject Matter Expert II | ||||
| 206 | Subject Matter Expert III | ||||
| 207 | Subject Matter Expert IV | ||||
| 208 | Subject Matter Expert V | ||||
| 209 | Statistician I | ||||
| 210 | Statistician II | ||||
| 211 | Statistician III | ||||
| 212 | Statistician IV | ||||
| 213 | Statistician V | ||||
| 214 | Technical Writer I | ||||
| 215 | Technical Writer II | ||||
| 216 | Technical Writer III | ||||
| 217 | Technical Writer IV | ||||
| 218 | Technical Writer V | ||||
| 219 | Training Specialist I | ||||
| 220 | Training Specialist II | ||||
| 221 | Training Specialist III | ||||
| 222 | Training Specialist IV | ||||
| 223 | Training Specialist V | ||||
| 224 | Validation Engineer I | ||||
| 225 | Validation Engineer II | ||||
| 226 | Validation Engineer III | ||||
| 227 | Validation Engineer IV | ||||
| 228 | Validation Engineer V - Manager |
Average Labor Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
T3. Ordering Period 1 FDA Scientific Support - Ordering Period 1
| 1. CDER _Office of Translational Sciences (OTS) | Labor Hours Per FTE | FTE | Total Hours | Govt. Rate: No Visa Asst. | Total Costs | Total Hours | |
| LCAT Name | |||||||
| 1 | Program Manager III | 240 | 1 | 240 | $ - 0 | $ - 0 | 240 |
| 2 | Project Manager II | 1440 | 1 | 1440 | $ - 0 | $ - 0 | 1440 |
| 3 | Analyst II | 360 | 3 | 1080 | $ - 0 | $ - 0 | 1080 |
| 4 | Analyst III | 1440 | 2 | 2880 | $ - 0 | $ - 0 | 2880 |
| 5 | Programmer III | 1920 | 3 | 5760 | $ - 0 | $ - 0 | 5760 |
| 6 | Statistician II | 540 | 2 | 1080 | $ - 0 | $ - 0 | 1080 |
| 7 | Technical Writer III | 120 | 1 | 120 | $ - 0 | $ - 0 | 120 |
| 8 | Subject Matter Expert IV | 360 | 1 | 360 | $ - 0 | $ - 0 | 360 |
| 9 | Program Manager III | 240 | 1 | 240 | $ - 0 | $ - 0 | 240 |
| 10 | Project Manager II | 1440 | 1 | 1440 | $ - 0 | $ - 0 | 1440 |
| 11 | Analyst II | 360 | 1 | 360 | $ - 0 | $ - 0 | 360 |
| 12 | Analyst III | 1440 | 1 | 1440 | $ - 0 | $ - 0 | 1440 |
| 13 | Programmer III | 1920 | 2 | 3840 | $ - 0 | $ - 0 | 3840 |
| 14 | Statistician II | 540 | 2 | 1080 | $ - 0 | $ - 0 | 1080 |
| 15 | Technical Writer II | 120 | 1 | 120 | $ - 0 | $ - 0 | 120 |
| 16 | Subject Matter Expert IV | 360 | 1 | 360 | $ - 0 | $ - 0 | 360 |
| 17 | Scientist I | 1920 | 2 | 3840 | $ - 0 | $ - 0 | 3840 |
| 18 | Scientist II | 1920 | 2 | 3840 | $ - 0 | $ - 0 | 3840 |
| 19 | Scientist III | 1920 | 7 | 13440 | $ - 0 | $ - 0 | 13440 |
| 20 | Researcher II | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 21 | Researcher III | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 22 | Research Analyst V | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 23 | Researcher V | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 24 | Lab Technical Support V | 1920 | 2 | 3840 | $ - 0 | $ - 0 | 3840 |
| 25 | Subject Matter Expert II | 832 | 1 | 832 | $ - 0 | $ - 0 | 832 |
| 26 | Clinical Information / Data Analyst- Senior | 960 | 1 | 960 | $ - 0 | $ - 0 | 960 |
| 27 | Data Entry Specialist III | 960 | 1 | 960 | $ - 0 | $ - 0 | 960 |
| 28 | Biomedical Informatics Specialist III | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 29 | Bioinformatician III | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 30 | Bioinformatician II | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 31 | Health IT Computational Biologist III | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 32 | Health IT Computational Biologist II | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 33 | High Performance Health IT Computing Specialist III | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 34 | Bioinformatics Analyst IV | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 35 | Bioinformatics Analyst III | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 36 | Bioinformatics Analyst II | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 37 | Validation Engineer IV | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 38 | Validation Engineer III | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 39 | Validation Engineer II | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 40 | Validation Engineer I | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 41 | Validation Engineer V - Manager | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 42 | Protocol Data Analyst III | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 43 | Scientific Data Analyst III | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 44 | Clinical Trial Coordinator I | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 45 | Regulatory Documentation Specialist I | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1920 |
| 62 | - 0 | 91,792 |
| 2. CDER _ Office of Pharmaceutical Quality (OPQ) | Labor Hours Per FTE | FTE | Total Hours | Both Sites -Govt/Con Rate | Total Costs | Total Hours | |
| LCAT Name | |||||||
| 1 | Informatics III | 1920 | 2 | 3840 | $ - 0 | $ - 0 | 3,840 |
| 2 | Project Coordinator III | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1,920 |
| 3 | Researcher III | 1920 | 3 | 5760 | $ - 0 | $ - 0 | 5,760 |
| 4 | Research Analyst V | 1920 | 2 | 3840 | $ - 0 | $ - 0 | 3,840 |
| 5 | Research Assistant III | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1,920 |
| Total | 9 | 17,280 | - | 17,280 |
| 3. Center of Veterinary Medicine (CVM)- Office of Research (OR) | Labor Hours Per FTE | FTE | Total Hours | Both Sites -Govt/Con Rate | Total Costs | Total Hours | |
| LCAT Name | |||||||
| 1 | IT Engineer I | 1920 |
tc={733027D0-2A54-4262-B373-43E00378D878}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| changed 2000 hours to 1920 per Aura's estimate | 1 | 1920 | $ - 0 | $ - 0 | 1,920 |
| 2 | Microbiologist III | 1920 |
tc={84FA9D7E-EE1D-4EB2-A702-8AFA6BE32405}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Changed 1000 hours per FTE to 1920 per Aura's estimate | 2 | 3840 | $ - 0 | $ - 0 | 3,840 |
| 3 | Lab Technician III | 1920 |
tc={CB58381E-FA92-4F16-8885-705B44554E7F}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Changed 1000 hours to 1920 and added FTE pr Aur's estimate | 2 | 3840 | $ - 0 | $ - 0 | 3,840 |
| 4 | Research Analyst IV | 1920 |
tc={0CA26D33-61C8-44A4-91CD-8FCC89FAC5E6}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| change 10000 hours to 1920 as per Aura's estimate | 1 | 1920 | $ - 0 | $ - 0 | 1,920 | |||
| 5 | Research Analyst V | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1,920 | |
| 6 | Total | 7 | 13440 | $ - 0 | 13,440 |
| 4. National Center for Toxicological Research (NCTR) OR | Total Labor Hours | FTE | Total Hours | Both Sites -Govt/Con Rate | Total Costs | Total Hours | ||
| LCAT Name | ` | |||||||
| IT Engineer I | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1,920 | ||
| 1 | IT Engineer II | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1,920 | |
| 2 | Lab Technician I | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1,920 | |
| 3 | Lab Technical Support I | 1400 | 1 | 1400 | $ - 0 | $ - 0 | 1,400 | |
| 4 | Lab Technical Support II | 1400 | 1 | 1400 | $ - 0 | $ - 0 | 1,400 | |
| 5 | Programmer I | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1,920 | |
| 6 | Project Manager I | 1200 | 1 | 1200 | $ - 0 | $ - 0 | 1,200 | |
| 7 | Research Analyst I | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1,920 | |
| 8 | Statistician I | 1800 | 1 | 1800 | $ - 0 | $ - 0 | 1,800 | |
| 9 | ||||||||
| 10 | Total | 9 | 15,400 | $ - 0 | 15,400 |
| 5. Office of Compliance (OC) | Total Labor Hours | FTE | Total Hours | Both Govt. Site/Con Rate | Total Costs | Total Hours | |
| LCAT Name | |||||||
| Program Manager V | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1,920 | |
| 1 | Technical Writer V | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1,920 |
| 2 | Business Process Analyst V | 1920 | 1 | 1920 | $ - 0 | $ - 0 | 1,920 |
| 3 | Total | 3 | 5,760 | $ - 0 | 5,760 |
| 6. Center of Bilological Evaluation & Research (CBER) | Total Labor Hours | FTE | Total Hours | Both Govt. Site/Con Rate | Total Costs | Total Hours |
| LCAT Name |
Total
| 7. Center for Devices & Radiological Health (CDRH) | Total Labor Hours | FTE | Total Hours | Both Sites -Govt/Con Rate | Total Costs | Total Hours |
| LCAT Name |
Total
| 8. Center for Food Safety & Applied Nutritions (CFSAN) | Total Labor Hours | FTE | Total Hours | Both Sites -Govt/Con Rate | Total Costs | Total Hours |
| LCAT Name |
Total
| 9. Center for Tobacco Products (CTP) | Total Labor Hours | FTE | Total Hours | Both Sites -Govt/Con Rate | Total Costs | Total Hours |
| LCAT Name |
| Total | ||||||
| 10. Office of Regulatory Affairs (ORA) | Total Labor Hours | FTE | Total Hours | Both Govt. Site/Con Site Rate | Total Costs | Total Hours |
| LCAT Name | ||||||
| Scientist I | 1040 | 1 | 1040 | $ - 0 | $ - 0 | 1040 |
| Subject Matter Expert V | 208 | 1 | 208 | $ - 0 | $ - 0 | 208 |
| Research Analyst I | 1040 | 1 | 1040 | $ - 0 | $ - 0 | 1040 |
| Total | 3 | $ - 0 | 2,288 |
| 11. CBER | Total Labor Hours | FTE | Total Hours | Both Govt. Site/Con Site Rate | Total Costs | Total Hours |
| LCAT Name | ||||||
| Scientific Support | 1920 | 25 | 48000 | ERROR:#DIV/0! | ERROR:#DIV/0! | 48000 |
Total 25 ERROR:#DIV/0! 48,000
TOTAL ALL CENTERS - 0 118 - 0 ERROR:#DIV/0! 193,960
| Section 2. Other Direct Charges (ODCs) | ||
| Name / Description | Total Cost Gov | ODC - Con |
| <Insert> Cloud Services - Example | ||
| <Insert> Other IT Hardware / Equipment - Example | ||
| <Insert> SW Licenses - Example | ||
| <Insert> Maintenance - Example | ||
| <Insert> Subcontractors - Example |
T4. Option Period 1
| Project Title and/or Description: Insert Task Order Name |
| Option Period 1 - 12 Months |
| Instructions |
| Section 1. Includes a listing of all the Direct Labor that is associated with the work requirements. There are five (5) Task Area placeholders tables in the template with Labor Categories (LCATs) broken out by Government and Contractor Sites. Allocations for site are to be determined in Section 4. |
| Section 1 (cont). Please only populate Column C, Overall LOE% per LCAT across each Task Area table. LCAT names and rates are linked from Tab 2. If LCATs across each row are not applicable they can be hidden, cleared, or removed. If another Task Area Table needs to be added please copy and paste one of the tables into a new row. |
| Section 2. Provides example listings of Other Direct Costs (ODCs) that may be applicable to the work requirements. Please reference and provide inputs to Columns B-E, stating a ODC description, units, costs, and any discount % that may be applicable. If a row is not applicable it can be hidden, cleared, or removed. |
| Section 3. Total LOE and Cost Summary. Provides a rollup of Section 1 and Section 2. |
| Section 4. Provides the cost factors that are associated with the work requirements. Please adjust the Government and Contractor Site Allocation % (must equal 100%) along with Annual FTE Hours (1920). Placeholder's have been provided. |
| Please insert the Task Order Name above in Row 2. |
| Please insert Task Area names (red row areas). |
| Please ensure totals for labor hours and cost link to Tab 8. IGCE Summary. |
| Section 1. Direct Labor (Broken-Down by SOW Section, Project Phase, Deliverable, or As Otherwise Best Suited for the Subject Requirement) | Section 4. Cost Factors | ||||||||||||||
| Task Area 1. Insert Name | Overall LOE % | Total Labor Hours | Govt. Site Hours | Govt. Site Rate | Govt. Site Costs | CTR. Site Hours | CTR. Site Rate | CTR. Site Costs | Total Hours | Total Costs | |||||
| LCAT Name | Site Allocation | Labor Hours | |||||||||||||
| 1 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | Govt. Site Allocation | CTR. Site Allocation | Element | Annual Hrs. | |
| 2 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | 50% | 50% | 1 FTE | 1920 | |
| 3 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | *Govt. and CTR. Site Allocations must equal 100% | ||||
| 4 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 5 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 6 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 7 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 8 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 9 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 10 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 11 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 12 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 13 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 14 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 15 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! |
Total - ERROR:#REF! - ERROR:#REF! - ERROR:#REF!
| Task Area 2. Insert Name | Overall LOE % | Total Labor Hours | Govt. Site Hours | Govt. Site Rate | Govt. Site Costs | CTR. Site Hours | CTR. Site Rate | CTR. Site Costs | Total Hours | Total Costs | |
| LCAT Name | |||||||||||
| 1 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 2 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 3 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 4 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 5 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 6 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 7 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 8 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 9 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 10 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 11 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 12 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 13 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 14 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 15 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! |
Total - ERROR:#REF! - ERROR:#REF! - ERROR:#REF!
| Task Area 3. Insert Name | Overall LOE % | Total Labor Hours | Govt. Site Hours | Govt. Site Rate | Govt. Site Costs | CTR. Site Hours | CTR. Site Rate | CTR. Site Costs | Total Hours | Total Costs | |
| LCAT Name | |||||||||||
| 1 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 2 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 3 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 4 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 5 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 6 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 7 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 8 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 9 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 10 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 11 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 12 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 13 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 14 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 15 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! |
Total - ERROR:#REF! - ERROR:#REF! - ERROR:#REF!
| Task Area 4. Insert Name | Overall LOE % | Total Labor Hours | Govt. Site Hours | Govt. Site Rate | Govt. Site Costs | CTR. Site Hours | CTR. Site Rate | CTR. Site Costs | Total Hours | Total Costs | |
| LCAT Name | |||||||||||
| 1 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 2 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 3 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 4 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 5 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 6 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 7 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 8 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 9 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 10 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 11 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 12 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 13 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 14 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 15 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! |
Total - ERROR:#REF! - ERROR:#REF! - ERROR:#REF!
| Task Area 5. Insert Name | Overall LOE % | Total Labor Hours | Govt. Site Hours | Govt. Site Rate | Govt. Site Costs | CTR. Site Hours | CTR. Site Rate | CTR. Site Costs | Total Hours | Total Costs | |
| LCAT Name | |||||||||||
| 1 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 2 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 3 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 4 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 5 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 6 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 7 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 8 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 9 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 10 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 11 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 12 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 13 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 14 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 15 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! |
Total - ERROR:#REF! - ERROR:#REF! - ERROR:#REF!
| *Insert new Task Area Table HERE (if needed)* | ||
| Total Hours/LOE | Total Cost | |
| Direct Labor Totals | - | ERROR:#REF! |
* Rollup Summary of Section 1. Direct Labor. Adjust table format/formulas to account for additional LCATs.
Direct Labor Summary % Allocation Hours Costs
| 1 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 2 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 3 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 4 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 5 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 6 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 7 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 8 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 9 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 10 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 11 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 12 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 13 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 14 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 15 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| Section 2. Other Direct Charges (ODCs) | |||||
| Name / Description | Qty | Unit Cost or Total Cost | Discount % | Total Cost | |
| 1 | <Insert> Cloud Services - Example | $ - 0 | |||
| 2 | <Insert> Other IT Hardware / Equipment - Example | $ - 0 | |||
| 3 | <Insert> SW Licenses - Example | $ - 0 | |||
| 4 | <Insert> Maintenance - Example | $ - 0 | |||
| 5 | <Insert> Subcontractors - Example | $ - 0 | |||
| 6 | <Insert> Travel - Example | $ - 0 | |||
| 7 | <Insert> Other- Example | $ - 0 | |||
| ODC Totals | $ - 0 |
| Section 3. Total LOE and Costs | Total Hours/LOE | Total Cost |
| Overall Total (Labor + ODCs) | - | ERROR:#REF! |
T5. Option Period 2
| Project Title and/or Description: Insert Task Order Name |
| Option Period 2 - 12 Months |
| Instructions |
| Section 1. Includes a listing of all the Direct Labor that is associated with the work requirements. There are five (5) Task Area placeholders tables in the template with Labor Categories (LCATs) broken out by Government and Contractor Sites. Allocations for site are to be determined in Section 4. |
| Section 1 (cont). Please only populate Column C, Overall LOE% per LCAT across each Task Area table. LCAT names and rates are linked from Tab 2. If LCATs across each row are not applicable they can be hidden, cleared, or removed. If another Task Area Table needs to be added please copy and paste one of the tables into a new row. |
| Section 2. Provides example listings of Other Direct Costs (ODCs) that may be applicable to the work requirements. Please reference and provide inputs to Columns B-E, stating a ODC description, units, costs, and any discount % that may be applicable. If a row is not applicable it can be hidden, cleared, or removed. |
| Section 3. Total LOE and Cost Summary. Provides a rollup of Section 1 and Section 2. |
| Section 4. Provides the cost factors that are associated with the work requirements. Please adjust the Government and Contractor Site Allocation % (must equal 100%) along with Annual FTE Hours (1920). Placeholder's have been provided. |
| Please insert the Task Order Name above in Row 2. |
| Please insert Task Area names (red row areas). |
| Please ensure totals for labor hours and cost link to Tab 8. IGCE Summary. |
| Section 1. Direct Labor (Broken-Down by SOW Section, Project Phase, Deliverable, or As Otherwise Best Suited for the Subject Requirement) | Section 4. Cost Factors | ||||||||||||||
| Task Area 1. Insert Name | Overall LOE % | Total Labor Hours | Govt. Site Hours | Govt. Site Rate | Govt. Site Costs | CTR. Site Hours | CTR. Site Rate | CTR. Site Costs | Total Hours | Total Costs | |||||
| LCAT Name | Site Allocation | Labor Hours | |||||||||||||
| 1 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | Govt. Site Allocation | CTR. Site Allocation | Element | Annual Hrs. | |
| 2 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | 50% | 50% | 1 FTE | 1920 | |
| 3 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | *Govt. and CTR. Site Allocations must equal 100% | ||||
| 4 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 5 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 6 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 7 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 8 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 9 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 10 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 11 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 12 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 13 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 14 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 15 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! |
Total - ERROR:#REF! - ERROR:#REF! - ERROR:#REF!
| Task Area 2. Insert Name | Overall LOE % | Total Labor Hours | Govt. Site Hours | Govt. Site Rate | Govt. Site Costs | CTR. Site Hours | CTR. Site Rate | CTR. Site Costs | Total Hours | Total Costs | |
| LCAT Name | |||||||||||
| 1 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 2 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 3 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 4 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 5 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 6 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 7 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 8 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 9 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 10 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 11 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 12 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 13 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 14 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 15 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! |
Total - ERROR:#REF! - ERROR:#REF! - ERROR:#REF!
| Task Area 3. Insert Name | Overall LOE % | Total Labor Hours | Govt. Site Hours | Govt. Site Rate | Govt. Site Costs | CTR. Site Hours | CTR. Site Rate | CTR. Site Costs | Total Hours | Total Costs | |
| LCAT Name | |||||||||||
| 1 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 2 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 3 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 4 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 5 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 6 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 7 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 8 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 9 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 10 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 11 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 12 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 13 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 14 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 15 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! |
Total - ERROR:#REF! - ERROR:#REF! - ERROR:#REF!
| Task Area 4. Insert Name | Overall LOE % | Total Labor Hours | Govt. Site Hours | Govt. Site Rate | Govt. Site Costs | CTR. Site Hours | CTR. Site Rate | CTR. Site Costs | Total Hours | Total Costs | |
| LCAT Name | |||||||||||
| 1 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 2 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 3 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 4 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 5 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 6 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 7 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 8 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 9 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 10 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 11 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 12 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 13 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 14 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 15 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! |
Total - ERROR:#REF! - ERROR:#REF! - ERROR:#REF!
| Task Area 5. Insert Name | Overall LOE % | Total Labor Hours | Govt. Site Hours | Govt. Site Rate | Govt. Site Costs | CTR. Site Hours | CTR. Site Rate | CTR. Site Costs | Total Hours | Total Costs | |
| LCAT Name | |||||||||||
| 1 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 2 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 3 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 4 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 5 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 6 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 7 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 8 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 9 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 10 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 11 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 12 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 13 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 14 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |
| 15 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! |
Total - ERROR:#REF! - ERROR:#REF! - ERROR:#REF!
| *Insert new Task Area Table HERE (if needed)* | ||
| Total Hours/LOE | Total Cost | |
| Direct Labor Totals | - | ERROR:#REF! |
* Rollup Summary of Section 1. Direct Labor. Adjust table format/formulas to account for additional LCATs.
Direct Labor Summary % Allocation Hours Costs
| 1 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 2 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 3 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 4 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 5 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 6 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 7 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 8 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 9 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 10 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 11 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 12 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 13 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 14 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| 15 | ERROR:#REF! | 0% | - | ERROR:#REF! |
| Section 2. Other Direct Charges (ODCs) | |||||
| Name / Description | Qty | Unit Cost or Total Cost | Discount % | Total Cost | |
| 1 | <Insert> Cloud Services - Example | $ - 0 | |||
| 2 | <Insert> Other IT Hardware / Equipment - Example | $ - 0 | |||
| 3 | <Insert> SW Licenses - Example | $ - 0 | |||
| 4 | <Insert> Maintenance - Example | $ - 0 | |||
| 5 | <Insert> Subcontractors - Example | $ - 0 | |||
| 6 | <Insert> Travel - Example | $ - 0 | |||
| 7 | <Insert> Other- Example | $ - 0 | |||
| ODC Totals | $ - 0 |
| Section 3. Total LOE and Costs | Total Hours/LOE | Total Cost |
| Overall Total (Labor + ODCs) | - | ERROR:#REF! |
T6. Option Period 3
| Project Title and/or Description: Insert Task Order Name |
| Option Period 3 - 12 Months |
| Instructions |
| Section 1. Includes a listing of all the Direct Labor that is associated with the work requirements. There are five (5) Task Area placeholders tables in the template with Labor Categories (LCATs) broken out by Government and Contractor Sites. Allocations for site are to be determined in Section 4. |
| Section 1 (cont). Please only populate Column C, Overall LOE% per LCAT across each Task Area table. LCAT names and rates are linked from Tab 2. If LCATs across each row are not applicable they can be hidden, cleared, or removed. If another Task Area Table needs to be added please copy and paste one of the tables into a new row. |
| Section 2. Provides example listings of Other Direct Costs (ODCs) that may be applicable to the work requirements. Please reference and provide inputs to Columns B-E, stating a ODC description, units, costs, and any discount % that may be applicable. If a row is not applicable it can be hidden, cleared, or removed. |
| Section 3. Total LOE and Cost Summary. Provides a rollup of Section 1 and Section 2. |
| Section 4. Provides the cost factors that are associated with the work requirements. Please adjust the Government and Contractor Site Allocation % (must equal 100%) along with Annual FTE Hours (1920). Placeholder's have been provided. |
| Please insert the Task Order Name above in Row 2. |
| Please insert Task Area names (red row areas). |
| Please ensure totals for labor hours and cost link to Tab 8. IGCE Summary. |
| Section 1. Direct Labor (Broken-Down by SOW Section, Project Phase, Deliverable, or As Otherwise Best Suited for the Subject Requirement) | Section 4. Cost Factors | ||||||||||||||
| Task Area 1. Insert Name | Overall LOE % | Total Labor Hours | Govt. Site Hours | Govt. Site Rate | Govt. Site Costs | CTR. Site Hours | CTR. Site Rate | CTR. Site Costs | Total Hours | Total Costs | |||||
| LCAT Name | Site Allocation | Labor Hours | |||||||||||||
| 1 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | Govt.Site Allocation | CTR. Site Allocation | Element | Annual Hrs. | |
| 2 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | 50% | 50% | 1 FTE | 1920 | |
| 3 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | *Govt. and CTR. Site Allocations must equal 100% | ||||
| 4 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | |||||
| 5 | ERROR:#REF! | - | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! | ERROR:#REF! | - | ERROR:#REF! |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .