Attachment 6A - PRIME Pricing Model v2.0 - 6FEB2019 (17R0005).xlsx
XLSX spreadsheet 251 KB Posted
- Attached to
- N6523617R0005 SOCS SATCOM Support Federal contract opportunity
- Solicitation number
- N65236-17-R-0005
About this file
This document provides information regarding a forthcoming solicitation for Special Operations Communications Systems Satellite Communications and Network Support services. The Space and Naval Warfare Systems Center Atlantic is seeking capability statements from small businesses by November 1st, 2017 in response to a market survey and draft Performance Work Statement included as attachments. Interested small businesses are invited to submit questions by the deadline in order to inform the requirements for the upcoming solicitation for these services to be provided to the Department of the Navy Information Warfare Systems Command.
View the file
Other files for this federal contract opportunity
Show all 50
N6523617R0005 SOCS SATCOM Support has more files on GovTribe.
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
INSTRUCTIONS
GENERAL INSTRUCTIONS AND INFORMATION
PRIME CONTRACTOR PRICING MODEL
| CONTRACT VEHICLE: | N65236-17-R-0005 | ||
| PR NUMBER: | N65236-17-R-0005 | ||
| TITLE: | SOCS SATCOM | ||
| PRICIING MODEL VERSION: | 2.0 | ||
| CONTRACT SPECIALIST: | Nicole Middleton | (843) 218-6477 | nicole.middleton@navy.mil |
RESTRICTION ON DISCLOSURE AND USE OF DATA
This proposal includes data that shall not be disclosed outside the Government and shall not be duplicated, used, or disclosed--in whole or in part--for any purpose other than to evaluate this proposal. If, however, a contract is awarded to this offeror as a result of - or in connection with - the submission of this data, the Government shall have the right to duplicate, use, or disclose the data to the extent provided in the resulting contract.
This restriction does not limit the Government's right to use information contained in this proposal if it is obtained from another source without restriction. All data in this proposal are subject to this restriction.
| ASSUMPTIONS: | |
| This template assumes the following: | |
| - Allocation base for FRINGE is unburdended labor | |
| - Allocation base for OH is unburdened labor + FRINGE | |
| - Allocation base for G&A is unburdened labor + FRINGE + OH |
| DIRECTIONS | |
| 1.) | IGNORE any hidden columns or rows |
| 2.) | Populate ONLY cells highlighted yellow |
| 3.) | Populate indirect rates on CONTRACTOR DATA INPUT worksheet |
- If applicable, modify descriptions (names) for FRINGE and OH pools to match with offeror's accounting practices.
- If additional pools are needed, add row to either FRINGE or OH section of CONTRACTOR DATA INPUT worksheet.
4.) Explain basis for indirect rates in space provided on CONTRACTOR DATA INPUT worksheet (column I).
Assumptions have been made by the Government that may not match with offeror's accounting practices.
5.) If applicable, assign labor hours to subcontractors on TEAM HOURS worksheet.
If more than six (6) subcontractors are needed, follow the instruction below:
(NOTE: if subcontractor is added to base, then steps need to be repeated for all options/years)
1.) TEAM HOURS worksheet:
If adding a subcontractor, this has to be completed for base and options
- Select column Q by clicking on column header
- Right-click - select Insert (2x)
- Label column headers "RG" and "OT"
- Sum RG and OT columns at bottom of table
2.) SUMMARY worksheet:
- Add rows for each additional Subcontractor (cost and hours)
- Add rows for additional Subcontractor ODCs (if needed)
- Update the Subtotal for Subcontractor Labor costs formula
6.) Select a FRINGE and OH pool (column F & G) on RATES worksheet.
If government allocation base assumptions do NOT match with offeror's accounting practices, modify the formulas in FRINGE, OH, and G&A columns. Document any and all changes on CONTRACTOR DATA INPUT worksheet
| 7.) | Populate labor rates on RATES worksheet (column K). |
| 8.) | If offeror's labor category job titles are different from those in the solicitation, document on the OTHER LABOR DATA sheet. |
| 9.) | If labor rates are calculated by using any value other than 2,080 hours per year, document number of hours per year used to calculate the hourly rate for each labor category on OTHER LABOR DATA sheet. |
| 10.) | Complete BENEFIT SUMMARY and SALARY DATA worksheets |
| 11.) | If applicable, provide all subcontractors with copy of Subcontractor Pricing Model. |
| 12.) | Transmit entire Pricing Model in EXCEL format (complete with active formulas) along with supporting narrative to Government in accordance with solicitation instructions. |
| HELPFUL HINTS & REMINDERS | |
| 1.) | Be sure to change formulas on RATES worksheet if application base differentiates from Government assumption. |
| 2.) | Notify the contracting specialist if there are any questions or problems relating to Pricing Model. |
&"Times New Roman,Regular"&F &"Times New Roman,Regular"&A &"Times New Roman,Regular"&P of &N
By checking this box you are verifying that you have read the instructions
CONTRACTOR DATA INPUT
| SECTION 1 - Header Information |
| Contractor Name: |
| CAGE: |
| Contractor Proposal #: |
| Proposal Date: |
| Valid until: |
SECTION 2 - Loading Factors
| OPTION | ||
| 1 | OPTION | |
| 2 | OPTION | |
| 3 | OPTION |
| 0.00% | 0.00% | 0.00% | 0.00% |
| 0.00% | 0.00% | 0.00% | 0.00% |
| FRINGE | Year 1 | OPTION | |||||
| 1 | OPTION | ||||||
| 2 | OPTION | ||||||
| 3 | OPTION | ||||||
| 4 | Allocation Base | ||||||
| <FRINGE #1> | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Direct Labor | |
| <FRINGE #2> | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Direct Labor | |
| <FRINGE #3> | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Direct Labor | |
| <FRINGE #4> | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Direct Labor | |
| <FRINGE #5> | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Direct Labor |
| OVERHEAD | Year 1 | OPTION | |||||
| 1 | OPTION | ||||||
| 2 | OPTION | ||||||
| 3 | OPTION | ||||||
| 4 | Allocation Base | ||||||
| <OH #1> | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Direct Labor + Fringe | |
| <OH #2> | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Direct Labor + Fringe | |
| <OH #3> | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Direct Labor + Fringe | |
| <OH #4> | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Direct Labor + Fringe | |
| <OH #5> | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Direct Labor + Fringe |
| G&A and OTHER BURDENS | Year 1 | OPTION | |||||
| 1 | OPTION | ||||||
| 2 | OPTION | ||||||
| 3 | OPTION | ||||||
| 4 | Allocation Base | ||||||
| G&A Rate on Prime Labor | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Direct labor + Fringe + Overhead | |
| G&A on Subcontractor Labor | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Subcontractor Labor | |
| G&A on Prime ODCs | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Prime ODCs | |
| G&A on Subcontractor ODCs | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Subcontractor ODCs | |
| OTHER BURDEN on SUBCONTRACTOR LABOR (if applicable) | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Subcontractor Labor | |
| OTHER BURDEN on SUBCONTRACTOR ODCs (if applicable) | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Subcontractor ODCs |
| FEE | |
| FEE on LABOR (applied to base and options) | 0.00% |
| FEE on SUBCONTRACTOR LABOR (applied to base and options) | 0.00% |
| PROFIT | 0.00% |
CONTRACTOR CHANGES TO THE PRICING MODEL AND PROPOSAL EXPLANATIONS
SUMMARY
| Contract Number: | N65236-17-R-0005 |
| RFP Number: | N65236-17-R-0005 |
| Task Name: | SOCS SATCOM |
| Contractor Name: | |
| Contractor Proposal #: | |
| Proposal Date: | |
| Valid until: |
| LABOR | Year 1 | 0 | 0 | 0 | 0 | TOTAL | 6 month option |
| PRIME CONTRACTOR LABOR COSTS | |||||||
| PRIME LABOR HRs: | 369,860.0 | -0 | -0 | -0 | -0 | 369,860.0 | -0 |
| PRIME UNBURDENED LABOR COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| PRIME FRINGE LABOR COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| PRIME OH LABOR COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| PRIME G&A LABOR COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| SUBTOTAL PRIME LABOR: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| FEE PRIME LABOR: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| TOTAL PRIME LABOR + FEE: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBCONTRACTOR LABOR COSTS | ||||||
| SUB #1 LABOR HOURS: | - | - | - | - | - | - |
| SUB #1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #2 LABOR HOURS: | - | - | - | - | - | - |
| SUB #2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #3 LABOR HOURS: | - | - | - | - | - | - |
| SUB #3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #4 LABOR HOURS: | - | - | - | - | - | - |
| SUB #4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #5 LABOR HOURS: | - | - | - | - | - | - |
| SUB #5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #6 LABOR HOURS: | - | - | - | - | - | - |
| SUB #6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL SUBCONTRACTOR LABOR HOURS: | - | - | - | - | - | - |
| SUBTOTAL SUBCONTRACTOR LABOR COSTS: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| PRIME G&A ON SUBCONTRACTOR LABOR: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| PRIME OTHER BURDEN on SUBCONTRACTOR LABOR (if applicable): | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| PRIME FEE ON SUBCONTRACTOR LABOR: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL SUBCONTRACTOR LABOR + FEE: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL PRIME & SUBCONTRACTOR LABOR HRs: | 369,860.0 | -0 | -0 | -0 | -0 | 369,860.0 |
| TOTAL PRIME & SUBCONTRACTOR LABOR: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL PRIME & SUBCONTRACTOR FEE on LABOR: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL PRIME & SUBCONTRACTOR LABOR + FEE: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| OTHER DIRECT COSTS | 0001 | 0 | 0 | 0 | 0 | TOTAL |
| PRIME CONTRACTOR ODC COSTS | ||||||
| - MATERIAL: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| - TRAVEL: | $ 4,240,368.50 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 4,240,368.50 |
| - MISCELLANEOUS ODCs: | $ 1,276,359.09 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 1,276,359.09 |
| - Additional ODC - (if applicable): | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL PRIME ODCs: | $ 5,516,727.59 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 5,516,727.59 |
| PRIME G&A on PRIME ODCs: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL PRIME ODCs (including G&A): | $ 5,516,727.59 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 5,516,727.59 |
| SUBCONTRACTOR ODC COSTS | ||||||
| SUB #1 ADDITIONAL ODC: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #2 ADDITIONAL ODC: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #3 ADDITIONAL ODC: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #4 ADDITIONAL ODC: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #5 ADDITIONAL ODC: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #6 ADDITIONAL ODC: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL SUBCONTRACTOR ODCs: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| PRIME G&A on SUBCONTRACTOR ODCs: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| PRIME OTHER BURDEN on SUBCONTRACTOR ODCs: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL SUBCONTRACTOR ODCs (including G&A): | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL PRIME & SUBCONTRACTOR ODCs: | $ 5,516,727.59 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 5,516,727.59 | |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| TOTAL ODCs: | $ 5,516,727.59 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 5,516,727.59 | |
| TOTAL | Year 1 | ||||||
| 0001 | 0 | ||||||
| 0 | 0 | ||||||
| 0 | 0 | ||||||
| 0 | 0 | ||||||
| 0 | TOTAL | 6 month option |
| GRAND TOTAL COST (LABOR + ODCs): | $ 5,516,727.59 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 5,516,727.59 | $ - 0 |
| GRAND TOTAL FEE: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| FCCM (if applicable): | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| GRAND TOTAL: | $ 5,516,727.59 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 5,516,727.59 | $ 2,758,363.80 |
&"Times New Roman,Bold"&16&A&"Times New Roman,Regular"&10
| &"Times New Roman,Regular"&F &A | &"Times New Roman,Regular"Source Selection Information |
| See FAR 2.101 and 3.104 | &"Times New Roman,Regular"&P of &N |
SUMMARY
TEAM HOURS
| BASE | ||||||||||||||||||||
| 0001 | ||||||||||||||||||||
| TOTAL | SUB #1 | SUB #2 | SUB #3 | SUB #4 | SUB #5 | SUB #6 | PRIME | |||||||||||||
| TYPE | LABOR CATEGORY | LOCATION | SITE | RG | OT | RG | OT | RG | OT | RG | OT | RG | OT | RG | OT | RG | OT | RG | OT | |
| 1.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Camp Lejune, NC | Government | 11,520 | - | - | - | - | - | - | - | - | - | - | - | - | 11,520 | - | |
| 2.) | PROFESSIONAL | Subject Matter Expert (SME) 4 | Camp Lejune, NC | Government | 5,376 | - | - | - | - | - | - | - | - | - | - | - | - | 5,376 | - | |
| 3.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Camp Pendelton, CA | Government | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 4.) | PROFESSIONAL | Subject Matter Expert (SME) 2 | Camp Smith, HI | Government | 3,500 | - | - | - | - | - | - | - | - | - | - | - | - | 3,500 | - | |
| 5.) | PROFESSIONAL | Subject Matter Expert (SME) 4 | Camp Smith, HI | Government | 3,456 | - | - | - | - | - | - | - | - | - | - | - | - | 3,456 | - | |
| 6.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Charleston, SC | Government | 2,960 | - | - | - | - | - | - | - | - | - | - | - | - | 2,960 | - | |
| 7.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Coronado, CA | Government | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 8.) | SCLS | Computer Systems Analyst III (14103) | Coronado, CA | Government | 1,920 | 60 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | 60 |
| 9.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Eglin AFB, FL | Government | 3,840 | - | - | - | - | - | - | - | - | - | - | - | - | 3,840 | - | |
| 10.) | PROFESSIONAL | Engineer/Scientist 3 | Fayetteville, NC | Contractor | 1,964 | - | - | - | - | - | - | - | - | - | - | - | - | 1,964 | - | |
| 11.) | PROFESSIONAL | Engineer/Scientist 4 | Fayetteville, NC | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 12.) | PROFESSIONAL | Engineer/Scientist 5 | Fayetteville, NC | Contractor | 2,400 | - | - | - | - | - | - | - | - | - | - | - | - | 2,400 | - | |
| 13.) | PROFESSIONAL | Junior Logistician | Fayetteville, NC | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 14.) | PROFESSIONAL | Logistician 2 | Fayetteville, NC | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 15.) | PROFESSIONAL | Logistician 3 | Fayetteville, NC | Contractor | 6,457 | - | - | - | - | - | - | - | - | - | - | - | - | 6,457 | - | |
| 16.) | PROFESSIONAL | Logistician 4 | Fayetteville, NC | Contractor | 3,000 | - | - | - | - | - | - | - | - | - | - | - | - | 3,000 | - | |
| 17.) | PROFESSIONAL | Management Analyst 1 | Fayetteville, NC | Contractor | 10,000 | - | - | - | - | - | - | - | - | - | - | - | - | 10,000 | - | |
| 18.) | PROFESSIONAL | Management Analyst 3 | Fayetteville, NC | Contractor | 2,400 | - | - | - | - | - | - | - | - | - | - | - | - | 2,400 | - | |
| 19.) | PROFESSIONAL | Management and Program Technician 2 | Fayetteville, NC | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 20.) | PROFESSIONAL | Management and Program Technician 3 | Fayetteville, NC | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 21.) | PROFESSIONAL | Operations Specialist | Fayetteville, NC | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 22.) | PROFESSIONAL | Program Manager | Fayetteville, NC | Contractor | 2,870 | - | - | - | - | - | - | - | - | - | - | - | - | 2,870 | - | |
| 23.) | PROFESSIONAL | Project Manager | Fayetteville, NC | Contractor | 21,000 | - | - | - | - | - | - | - | - | - | - | - | - | 21,000 | - | |
| 24.) | PROFESSIONAL | Security Specialist 3 | Fayetteville, NC | Contractor | 6,227 | - | - | - | - | - | - | - | - | - | - | - | - | 6,227 | - | |
| 25.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Fayetteville, NC | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 26.) | PROFESSIONAL | Subject Matter Expert (SME) 4 | Fayetteville, NC | Contractor | 7,104 | - | - | - | - | - | - | - | - | - | - | - | - | 7,104 | - | |
| 27.) | PROFESSIONAL | Subject Matter Expert (SME) 5 | Fayetteville, NC | Contractor | 3,356 | - | - | - | - | - | - | - | - | - | - | - | - | 3,356 | - | |
| 28.) | PROFESSIONAL | Technical Writer/Editor 2 | Fayetteville, NC | Contractor | 4,200 | - | - | - | - | - | - | - | - | - | - | - | - | 4,200 | - | |
| 29.) | PROFESSIONAL | Technical Writer/Editor 3 | Fayetteville, NC | Contractor | 4,000 | - | - | - | - | - | - | - | - | - | - | - | - | 4,000 | - | |
| 30.) | PROFESSIONAL | Technical Writer/Editor 4 | Fayetteville, NC | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 31.) | PROFESSIONAL | Training Specialist 1 | Fayetteville, NC | Contractor | 4,200 | - | - | - | - | - | - | - | - | - | - | - | - | 4,200 | - | |
| 32.) | PROFESSIONAL | Training Specialist 2 | Fayetteville, NC | Contractor | 4,200 | - | - | - | - | - | - | - | - | - | - | - | - | 4,200 | - | |
| 33.) | PROFESSIONAL | Training Specialist 3 | Fayetteville, NC | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 34.) | PROFESSIONAL | Training Specialist 4 | Fayetteville, NC | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 35.) | SCLS | Administrative Assistant (01020) | Fayetteville, NC | Contractor | 1,920 | 200 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | 200 |
| 36.) | SCLS | Computer Programmer IV (14074) | Fayetteville, NC | Contractor | 1,920 | 60 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | 60 |
| 37.) | SCLS | Computer Systems Analyst III (14103) | Fayetteville, NC | Contractor | 1,920 | 60 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | 60 |
| 38.) | SCLS | Electronics Technician Maintenance I (23181) | Fayetteville, NC | Contractor | 1,920 | 60 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | 60 |
| 39.) | SCLS | Electronics Technician Maintenance III (23183) | Fayetteville, NC | Contractor | 1,920 | 60 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | 60 |
| 40.) | SCLS | Engineering Technician IV (30084) | Fayetteville, NC | Contractor | 4,000 | 200 | - | - | - | - | - | - | - | - | - | - | - | - | 4,000 | 200 |
| 41.) | SCLS | Graphic Artist (15080) | Fayetteville, NC | Contractor | 5,000 | 240 | - | - | - | - | - | - | - | - | - | - | - | - | 5,000 | 240 |
| 42.) | SCLS | Illustrator III (13043) | Fayetteville, NC | Contractor | 1,920 | 60 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | 60 |
| 43.) | SCLS | Material Expediter (21040) | Fayetteville, NC | Contractor | 6,000 | 300 | - | - | - | - | - | - | - | - | - | - | - | - | 6,000 | 300 |
| 44.) | SCLS | Supply Technician (01410) | Fayetteville, NC | Contractor | 1,920 | 60 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | 60 |
| 45.) | SCLS | Technical Instructor (15090) | Fayetteville, NC | Contractor | 1,920 | 60 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | 60 |
| 46.) | SCLS | Technical Instructor/Course Developer (15095) | Fayetteville, NC | Contractor | 10,000 | 60 | - | - | - | - | - | - | - | - | - | - | - | - | 10,000 | 60 |
| 47.) | PROFESSIONAL | Engineer/Scientist 1 | Fayetteville, NC | Government | 2,880 | - | - | - | - | - | - | - | - | - | - | - | - | 2,880 | - | |
| 48.) | PROFESSIONAL | Engineer/Scientist 2 | Fayetteville, NC | Government | 2,270 | - | - | - | - | - | - | - | - | - | - | - | - | 2,270 | - | |
| 49.) | PROFESSIONAL | Management and Program Technician 2 | Fayetteville, NC | Government | 6,000 | - | - | - | - | - | - | - | - | - | - | - | - | 6,000 | - | |
| 50.) | PROFESSIONAL | Safety Specialist 4 | Fayetteville, NC | Government | 18,000 | - | - | - | - | - | - | - | - | - | - | - | - | 18,000 | - | |
| 51.) | SCLS | Administrative Assistant (01020) | Fayetteville, NC | Government | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 52.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Fort Bragg, NC | Government | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 53.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Fort Campbell, KY | Government | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 54.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Fort Carson, CO | Government | 9,500 | - | - | - | - | - | - | - | - | - | - | - | - | 9,500 | - | |
| 55.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Fort Lewis, WA | Government | 3,840 | - | - | - | - | - | - | - | - | - | - | - | - | 3,840 | - | |
| 56.) | SCLS | Computer Systems Analyst III (14103) | Fort Lewis, WA | Government | 1,920 | 60 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | 60 |
| 57.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Homestead AFB, FL | Government | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 58.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Hurlbert Field, FL | Government | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 59.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Bagram Afghanastain | Government | 7,000 | - | - | - | - | - | - | - | - | - | - | - | - | 7,000 | - | |
| 60.) | SCLS | Computer Systems Analyst III (14103) | OCONUS - Bagram Afghanastain | Government | 3,500 | - | - | - | - | - | - | - | - | - | - | - | - | 3,500 | - | |
| 61.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Bauhmholder, Germany | Government | 3,500 | - | - | - | - | - | - | - | - | - | - | - | - | 3,500 | - | |
| 62.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Djibouti | Government | 7,000 | - | - | - | - | - | - | - | - | - | - | - | - | 7,000 | - | |
| 63.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Doha, Qatar | Government | 7,000 | - | - | - | - | - | - | - | - | - | - | - | - | 7,000 | - | |
| 64.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Iraq | Government | 3,500 | - | - | - | - | - | - | - | - | - | - | - | - | 3,500 | - | |
| 65.) | SCLS | Computer Systems Analyst III (14103) | OCONUS - Japan, Okinawa | Government | 3,500 | - | - | - | - | - | - | - | - | - | - | - | - | 3,500 | - | |
| 66.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Niger | Government | 7,000 | - | - | - | - | - | - | - | - | - | - | - | - | 7,000 | - | |
| 67.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Philippines, Manilla | Government | 3,500 | - | - | - | - | - | - | - | - | - | - | - | - | 3,500 | - | |
| 68.) | PROFESSIONAL | Subject Matter Expert (SME) 4 | OCONUS - Stuttgart Germany | Government | 5,376 | - | - | - | - | - | - | - | - | - | - | - | - | 5,376 | - | |
| 69.) | PROFESSIONAL | Subject Matter Expert (SME) 2 | San Diego, CA | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 70.) | PROFESSIONAL | Engineer/Scientist 3 | Tampa, FL | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 71.) | PROFESSIONAL | Engineer/Scientist 4 | Tampa, FL | Contractor | 2,400 | - | - | - | - | - | - | - | - | - | - | - | - | 2,400 | - | |
| 72.) | PROFESSIONAL | Engineer/Scientist 5 | Tampa, FL | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 73.) | PROFESSIONAL | Logistician 2 | Tampa, FL | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 74.) | PROFESSIONAL | Logistician 3 | Tampa, FL | Contractor | 3,936 | - | - | - | - | - | - | - | - | - | - | - | - | 3,936 | - | |
| 75.) | PROFESSIONAL | Logistician 5 | Tampa, FL | Contractor | 1,728 | - | - | - | - | - | - | - | - | - | - | - | - | 1,728 | - | |
| 76.) | PROFESSIONAL | Management Analyst 3 | Tampa, FL | Contractor | 5,760 | - | - | - | - | - | - | - | - | - | - | - | - | 5,760 | - | |
| 77.) | PROFESSIONAL | Management and Program Technician 2 | Tampa, FL | Contractor | 6,000 | - | - | - | - | - | - | - | - | - | - | - | - | 6,000 | - | |
| 78.) | PROFESSIONAL | Management and Program Technician 3 | Tampa, FL | Contractor | 4,352 | - | - | - | - | - | - | - | - | - | - | - | - | 4,352 | - | |
| 79.) | PROFESSIONAL | Operations Specialist | Tampa, FL | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 80.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Tampa, FL | Contractor | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 81.) | PROFESSIONAL | Subject Matter Expert (SME) 4 | Tampa, FL | Contractor | 6,500 | - | - | - | - | - | - | - | - | - | - | - | - | 6,500 | - | |
| 82.) | PROFESSIONAL | Subject Matter Expert (SME) 5 | Tampa, FL | Contractor | 3,348 | - | - | - | - | - | - | - | - | - | - | - | - | 3,348 | - | |
| 83.) | PROFESSIONAL | Technical Writer/Editor 1 | Tampa, FL | Contractor | 4,000 | - | - | - | - | - | - | - | - | - | - | - | - | 4,000 | - | |
| 84.) | PROFESSIONAL | Technical Writer/Editor 2 | Tampa, FL | Contractor | 4,000 | - | - | - | - | - | - | - | - | - | - | - | - | 4,000 | - | |
| 85.) | SCLS | Drafter/CAD Operator IV (30064) | Tampa, FL | Contractor | 3,200 | 200 | - | - | - | - | - | - | - | - | - | - | - | - | 3,200 | 200 |
| 86.) | SCLS | Electronics Technician Maintenance I (23181) | Tampa, FL | Contractor | 1,920 | 60 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | 60 |
| 87.) | SCLS | Material Expediter (21040) | Tampa, FL | Contractor | 1,920 | 60 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | 60 |
| 88.) | PROFESSIONAL | Engineer/Scientist 4 | Tampa, FL | Government | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 89.) | PROFESSIONAL | Management and Program Technician 3 | Tampa, FL | Government | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 90.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Tampa, FL | Government | 12,000 | - | - | - | - | - | - | - | - | - | - | - | - | 12,000 | - | |
| 91.) | PROFESSIONAL | Subject Matter Expert (SME) 4 | Tampa, FL | Government | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 92.) | PROFESSIONAL | Subject Matter Expert (SME) 5 | Tampa, FL | Government | 3,500 | - | - | - | - | - | - | - | - | - | - | - | - | 3,500 | - | |
| 93.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Va Beach, VA | Government | 1,920 | - | - | - | - | - | - | - | - | - | - | - | - | 1,920 | - | |
| 94.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 95.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 96.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 97.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 98.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 99.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 100.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 369,860 | - | - | - | - | - | - | 369,860 |
RATES
Year 1
| TYPE | LABOR CATEGORY | LOCATION | SITE | FRINGE | ||
| POOL | OH | |||||
| POOL | RG | |||||
| Hours | OT | |||||
| Hours | RATE | FRINGE | OH | G&A | RG |
BURDENED
RATE OT
BURDENED
RATE TOTAL
COST
| 1.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Camp Lejune, NC | Government | 11,520 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 2.) | PROFESSIONAL | Subject Matter Expert (SME) 4 | Camp Lejune, NC | Government | 5,376 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 3.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Camp Pendelton, CA | Government | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 4.) | PROFESSIONAL | Subject Matter Expert (SME) 2 | Camp Smith, HI | Government | 3,500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 5.) | PROFESSIONAL | Subject Matter Expert (SME) 4 | Camp Smith, HI | Government | 3,456 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 6.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Charleston, SC | Government | 2,960 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 7.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Coronado, CA | Government | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 8.) | SCLS | Computer Systems Analyst III (14103) | Coronado, CA | Government | 1,920 | 60 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 9.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Eglin AFB, FL | Government | 3,840 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 10.) | PROFESSIONAL | Engineer/Scientist 3 | Fayetteville, NC | Contractor | 1,964 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 11.) | PROFESSIONAL | Engineer/Scientist 4 | Fayetteville, NC | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 12.) | PROFESSIONAL | Engineer/Scientist 5 | Fayetteville, NC | Contractor | 2,400 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 13.) | PROFESSIONAL | Junior Logistician | Fayetteville, NC | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 14.) | PROFESSIONAL | Logistician 2 | Fayetteville, NC | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 15.) | PROFESSIONAL | Logistician 3 | Fayetteville, NC | Contractor | 6,457 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 16.) | PROFESSIONAL | Logistician 4 | Fayetteville, NC | Contractor | 3,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 17.) | PROFESSIONAL | Management Analyst 1 | Fayetteville, NC | Contractor | 10,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 18.) | PROFESSIONAL | Management Analyst 3 | Fayetteville, NC | Contractor | 2,400 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 19.) | PROFESSIONAL | Management and Program Technician 2 | Fayetteville, NC | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 20.) | PROFESSIONAL | Management and Program Technician 3 | Fayetteville, NC | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 21.) | PROFESSIONAL | Operations Specialist | Fayetteville, NC | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 22.) | PROFESSIONAL | Program Manager | Fayetteville, NC | Contractor | 2,870 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 23.) | PROFESSIONAL | Project Manager | Fayetteville, NC | Contractor | 21,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 24.) | PROFESSIONAL | Security Specialist 3 | Fayetteville, NC | Contractor | 6,227 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 25.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Fayetteville, NC | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 26.) | PROFESSIONAL | Subject Matter Expert (SME) 4 | Fayetteville, NC | Contractor | 7,104 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 27.) | PROFESSIONAL | Subject Matter Expert (SME) 5 | Fayetteville, NC | Contractor | 3,356 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 28.) | PROFESSIONAL | Technical Writer/Editor 2 | Fayetteville, NC | Contractor | 4,200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 29.) | PROFESSIONAL | Technical Writer/Editor 3 | Fayetteville, NC | Contractor | 4,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 30.) | PROFESSIONAL | Technical Writer/Editor 4 | Fayetteville, NC | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 31.) | PROFESSIONAL | Training Specialist 1 | Fayetteville, NC | Contractor | 4,200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 32.) | PROFESSIONAL | Training Specialist 2 | Fayetteville, NC | Contractor | 4,200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 33.) | PROFESSIONAL | Training Specialist 3 | Fayetteville, NC | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 34.) | PROFESSIONAL | Training Specialist 4 | Fayetteville, NC | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 35.) | SCLS | Administrative Assistant (01020) | Fayetteville, NC | Contractor | 1,920 | 200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 36.) | SCLS | Computer Programmer IV (14074) | Fayetteville, NC | Contractor | 1,920 | 60 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 37.) | SCLS | Computer Systems Analyst III (14103) | Fayetteville, NC | Contractor | 1,920 | 60 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 38.) | SCLS | Electronics Technician Maintenance I (23181) | Fayetteville, NC | Contractor | 1,920 | 60 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 39.) | SCLS | Electronics Technician Maintenance III (23183) | Fayetteville, NC | Contractor | 1,920 | 60 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 40.) | SCLS | Engineering Technician IV (30084) | Fayetteville, NC | Contractor | 4,000 | 200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 41.) | SCLS | Graphic Artist (15080) | Fayetteville, NC | Contractor | 5,000 | 240 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 42.) | SCLS | Illustrator III (13043) | Fayetteville, NC | Contractor | 1,920 | 60 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 43.) | SCLS | Material Expediter (21040) | Fayetteville, NC | Contractor | 6,000 | 300 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 44.) | SCLS | Supply Technician (01410) | Fayetteville, NC | Contractor | 1,920 | 60 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 45.) | SCLS | Technical Instructor (15090) | Fayetteville, NC | Contractor | 1,920 | 60 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 46.) | SCLS | Technical Instructor/Course Developer (15095) | Fayetteville, NC | Contractor | 10,000 | 60 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 47.) | PROFESSIONAL | Engineer/Scientist 1 | Fayetteville, NC | Government | 2,880 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 48.) | PROFESSIONAL | Engineer/Scientist 2 | Fayetteville, NC | Government | 2,270 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 49.) | PROFESSIONAL | Management and Program Technician 2 | Fayetteville, NC | Government | 6,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 50.) | PROFESSIONAL | Safety Specialist 4 | Fayetteville, NC | Government | 18,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 51.) | SCLS | Administrative Assistant (01020) | Fayetteville, NC | Government | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 52.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Fort Bragg, NC | Government | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 53.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Fort Campbell, KY | Government | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 54.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Fort Carson, CO | Government | 9,500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 55.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Fort Lewis, WA | Government | 3,840 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 56.) | SCLS | Computer Systems Analyst III (14103) | Fort Lewis, WA | Government | 1,920 | 60 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 57.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Homestead AFB, FL | Government | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 58.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Hurlbert Field, FL | Government | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 59.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Bagram Afghanastain | Government | 7,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 60.) | SCLS | Computer Systems Analyst III (14103) | OCONUS - Bagram Afghanastain | Government | 3,500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 61.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Bauhmholder, Germany | Government | 3,500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 62.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Djibouti | Government | 7,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 63.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Doha, Qatar | Government | 7,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 64.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Iraq | Government | 3,500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 65.) | SCLS | Computer Systems Analyst III (14103) | OCONUS - Japan, Okinawa | Government | 3,500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 66.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Niger | Government | 7,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 67.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | OCONUS - Philippines, Manilla | Government | 3,500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 68.) | PROFESSIONAL | Subject Matter Expert (SME) 4 | OCONUS - Stuttgart Germany | Government | 5,376 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 69.) | PROFESSIONAL | Subject Matter Expert (SME) 2 | San Diego, CA | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 70.) | PROFESSIONAL | Engineer/Scientist 3 | Tampa, FL | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 71.) | PROFESSIONAL | Engineer/Scientist 4 | Tampa, FL | Contractor | 2,400 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 72.) | PROFESSIONAL | Engineer/Scientist 5 | Tampa, FL | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 73.) | PROFESSIONAL | Logistician 2 | Tampa, FL | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 74.) | PROFESSIONAL | Logistician 3 | Tampa, FL | Contractor | 3,936 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 75.) | PROFESSIONAL | Logistician 5 | Tampa, FL | Contractor | 1,728 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 76.) | PROFESSIONAL | Management Analyst 3 | Tampa, FL | Contractor | 5,760 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 77.) | PROFESSIONAL | Management and Program Technician 2 | Tampa, FL | Contractor | 6,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 78.) | PROFESSIONAL | Management and Program Technician 3 | Tampa, FL | Contractor | 4,352 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 79.) | PROFESSIONAL | Operations Specialist | Tampa, FL | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 80.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Tampa, FL | Contractor | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 81.) | PROFESSIONAL | Subject Matter Expert (SME) 4 | Tampa, FL | Contractor | 6,500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 82.) | PROFESSIONAL | Subject Matter Expert (SME) 5 | Tampa, FL | Contractor | 3,348 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 83.) | PROFESSIONAL | Technical Writer/Editor 1 | Tampa, FL | Contractor | 4,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 84.) | PROFESSIONAL | Technical Writer/Editor 2 | Tampa, FL | Contractor | 4,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 85.) | SCLS | Drafter/CAD Operator IV (30064) | Tampa, FL | Contractor | 3,200 | 200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 86.) | SCLS | Electronics Technician Maintenance I (23181) | Tampa, FL | Contractor | 1,920 | 60 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 87.) | SCLS | Material Expediter (21040) | Tampa, FL | Contractor | 1,920 | 60 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 88.) | PROFESSIONAL | Engineer/Scientist 4 | Tampa, FL | Government | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 89.) | PROFESSIONAL | Management and Program Technician 3 | Tampa, FL | Government | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 90.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Tampa, FL | Government | 12,000 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 91.) | PROFESSIONAL | Subject Matter Expert (SME) 4 | Tampa, FL | Government | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 92.) | PROFESSIONAL | Subject Matter Expert (SME) 5 | Tampa, FL | Government | 3,500 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 93.) | PROFESSIONAL | Subject Matter Expert (SME) 3 | Va Beach, VA | Government | 1,920 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 94.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 95.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 96.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 97.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 98.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 99.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 100.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 369,860 | $ - 0 |
OTHER LABOR DATA
| Note: Complete this section ONLY if proposed rates are calculated using other than 2,080 hours per year. | ||||||
| Was Uncompensated OT used to calculate the professional labor rates? | ||||||
| UNCOMPENSATED OVERTIME CALCULATION | ||||||
| PROFESSIONAL CATEGORY | OFFEROR'S LABOR CATEGORY | Hourly Rate | Adjusted Hourly Rate | Effective Hours | ||
| 1.) | Engineer/Scientist 1 | = | ||||
| 2.) | Engineer/Scientist 2 | = | ||||
| 3.) | Engineer/Scientist 3 | = | ||||
| 4.) | Engineer/Scientist 4 | = | ||||
| 5.) | Engineer/Scientist 5 | = | ||||
| 6.) | Junior Logistician | = | ||||
| 7.) | Logistician 2 | = | ||||
| 8.) | Logistician 3 | = | ||||
| 9.) | Logistician 4 | = | ||||
| 10.) | Logistician 5 | = | ||||
| 11.) | Management Analyst 1 | = | ||||
| 12.) | Management Analyst 3 | = | ||||
| 13.) | Management and Program Technician 2 | = | ||||
| 14.) | Management and Program Technician 3 | = | ||||
| 15.) | Operations Specialist | = | ||||
| 16.) | Program Manager | = | ||||
| 17.) | Project Manager | = | ||||
| 18.) | Safety Specialist 4 | = | ||||
| 19.) | Security Specialist 3 | = | ||||
| 20.) | Subject Matter Expert (SME) 2 | = | ||||
| 21.) | Subject Matter Expert (SME) 3 | = | ||||
| 22.) | Subject Matter Expert (SME) 4 | = | ||||
| 23.) | Subject Matter Expert (SME) 5 | = | ||||
| 24.) | Technical Writer/Editor 1 | = | ||||
| 25.) | Technical Writer/Editor 2 | = | ||||
| 26.) | Technical Writer/Editor 3 | = | ||||
| 27.) | Technical Writer/Editor 4 | = | ||||
| 28.) | Training Specialist 1 | = | ||||
| 29.) | Training Specialist 2 | = | ||||
| 30.) | Training Specialist 3 | = | ||||
| 31.) | Training Specialist 4 | = | ||||
| SCLS CATEGORY | OFFEROR'S LABOR CATEGORY | |||||
| 1.) | Administrative Assistant (01020) | = | ||||
| 2.) | Computer Programmer IV (14074) | = | ||||
| 3.) | Computer Systems Analyst III (14103) | = | ||||
| 4.) | Drafter/CAD Operator IV (30064) | = | ||||
| 5.) | Electronics Technician Maintenance I (23181) | = | ||||
| 6.) | Electronics Technician Maintenance III (23183) | = | ||||
| 7.) | Engineering Technician IV (30084) | = | ||||
| 8.) | Graphic Artist (15080) | = | ||||
| 9.) | Illustrator III (13043) | = | ||||
| 10.) | Material Expediter (21040) | = | ||||
| 11.) | Supply Technician (01410) | = | ||||
| 12.) | Technical Instructor (15090) | = | ||||
| 13.) | Technical Instructor/Course Developer (15095) | = | ||||
| UNCOMPENSATED OT POLICY |
| Hourly Rate is annual salary divided by 2,080. |
| Adjusted Hourly Rate is annual salary divided by total hours recorded |
| Effective Hours are the total hours recorded, including leave. |
FORMULAS
| FRINGE FORMULA | OH FORMULA | G&A FORMULA | FRINGE FORMULA | OH FORMULA | G&A FORMULA |
| =IFERROR(K5*VLOOKUP($F5,FRINGE,2,FALSE),0) | =IFERROR(SUM(K5,L5)*VLOOKUP($G5,OH,2,FALSE),0) | =SUM(K5,L5,M5)*GA_PRIME_LABOR_1 | =IFERROR(K5*VLOOKUP($F5,FRINGE,2,FALSE),0) | =IFERROR(SUM(K5,L5)*VLOOKUP($G5,OH,2,FALSE),0) | =SUM(K5,L5,M5)*GA_PRIME_LABOR_1 |
| =IFERROR(K6*VLOOKUP($F6,FRINGE,2,FALSE),0) | =IFERROR(SUM(K6,L6)*VLOOKUP($G6,OH,2,FALSE),0) | =SUM(K6,L6,M6)*GA_PRIME_LABOR_1 | =IFERROR(K6*VLOOKUP($F6,FRINGE,2,FALSE),0) | =IFERROR(SUM(K6,L6)*VLOOKUP($G6,OH,2,FALSE),0) | =SUM(K6,L6,M6)*GA_PRIME_LABOR_1 |
| =IFERROR(K7*VLOOKUP($F7,FRINGE,2,FALSE),0) | =IFERROR(SUM(K7,L7)*VLOOKUP($G7,OH,2,FALSE),0) | =SUM(K7,L7,M7)*GA_PRIME_LABOR_1 | =IFERROR(K7*VLOOKUP($F7,FRINGE,2,FALSE),0) | =IFERROR(SUM(K7,L7)*VLOOKUP($G7,OH,2,FALSE),0) | =SUM(K7,L7,M7)*GA_PRIME_LABOR_1 |
| =IFERROR(K8*VLOOKUP($F8,FRINGE,2,FALSE),0) | =IFERROR(SUM(K8,L8)*VLOOKUP($G8,OH,2,FALSE),0) | =SUM(K8,L8,M8)*GA_PRIME_LABOR_1 | =IFERROR(K8*VLOOKUP($F8,FRINGE,2,FALSE),0) | =IFERROR(SUM(K8,L8)*VLOOKUP($G8,OH,2,FALSE),0) | =SUM(K8,L8,M8)*GA_PRIME_LABOR_1 |
| =IFERROR(K9*VLOOKUP($F9,FRINGE,2,FALSE),0) | =IFERROR(SUM(K9,L9)*VLOOKUP($G9,OH,2,FALSE),0) | =SUM(K9,L9,M9)*GA_PRIME_LABOR_1 | =IFERROR(K9*VLOOKUP($F9,FRINGE,2,FALSE),0) | =IFERROR(SUM(K9,L9)*VLOOKUP($G9,OH,2,FALSE),0) | =SUM(K9,L9,M9)*GA_PRIME_LABOR_1 |
| =IFERROR(K10*VLOOKUP($F10,FRINGE,2,FALSE),0) | =IFERROR(SUM(K10,L10)*VLOOKUP($G10,OH,2,FALSE),0) | =SUM(K10,L10,M10)*GA_PRIME_LABOR_1 | =IFERROR(K10*VLOOKUP($F10,FRINGE,2,FALSE),0) | =IFERROR(SUM(K10,L10)*VLOOKUP($G10,OH,2,FALSE),0) | =SUM(K10,L10,M10)*GA_PRIME_LABOR_1 |
| =IFERROR(K11*VLOOKUP($F11,FRINGE,2,FALSE),0) | =IFERROR(SUM(K11,L11)*VLOOKUP($G11,OH,2,FALSE),0) | =SUM(K11,L11,M11)*GA_PRIME_LABOR_1 | =IFERROR(K11*VLOOKUP($F11,FRINGE,2,FALSE),0) | =IFERROR(SUM(K11,L11)*VLOOKUP($G11,OH,2,FALSE),0) | =SUM(K11,L11,M11)*GA_PRIME_LABOR_1 |
| =IFERROR(K12*VLOOKUP($F12,FRINGE,2,FALSE),0) | =IFERROR(SUM(K12,L12)*VLOOKUP($G12,OH,2,FALSE),0) | =SUM(K12,L12,M12)*GA_PRIME_LABOR_1 | =IFERROR(K12*VLOOKUP($F12,FRINGE,2,FALSE),0) | =IFERROR(SUM(K12,L12)*VLOOKUP($G12,OH,2,FALSE),0) | =SUM(K12,L12,M12)*GA_PRIME_LABOR_1 |
| =IFERROR(K13*VLOOKUP($F13,FRINGE,2,FALSE),0) | =IFERROR(SUM(K13,L13)*VLOOKUP($G13,OH,2,FALSE),0) | =SUM(K13,L13,M13)*GA_PRIME_LABOR_1 | =IFERROR(K13*VLOOKUP($F13,FRINGE,2,FALSE),0) | =IFERROR(SUM(K13,L13)*VLOOKUP($G13,OH,2,FALSE),0) | =SUM(K13,L13,M13)*GA_PRIME_LABOR_1 |
| =IFERROR(K14*VLOOKUP($F14,FRINGE,2,FALSE),0) | =IFERROR(SUM(K14,L14)*VLOOKUP($G14,OH,2,FALSE),0) | =SUM(K14,L14,M14)*GA_PRIME_LABOR_1 | =IFERROR(K14*VLOOKUP($F14,FRINGE,2,FALSE),0) | =IFERROR(SUM(K14,L14)*VLOOKUP($G14,OH,2,FALSE),0) | =SUM(K14,L14,M14)*GA_PRIME_LABOR_1 |
| =IFERROR(K15*VLOOKUP($F15,FRINGE,2,FALSE),0) | =IFERROR(SUM(K15,L15)*VLOOKUP($G15,OH,2,FALSE),0) | =SUM(K15,L15,M15)*GA_PRIME_LABOR_1 | =IFERROR(K15*VLOOKUP($F15,FRINGE,2,FALSE),0) | =IFERROR(SUM(K15,L15)*VLOOKUP($G15,OH,2,FALSE),0) | =SUM(K15,L15,M15)*GA_PRIME_LABOR_1 |
| =IFERROR(K16*VLOOKUP($F16,FRINGE,2,FALSE),0) | =IFERROR(SUM(K16,L16)*VLOOKUP($G16,OH,2,FALSE),0) | =SUM(K16,L16,M16)*GA_PRIME_LABOR_1 | =IFERROR(K16*VLOOKUP($F16,FRINGE,2,FALSE),0) | =IFERROR(SUM(K16,L16)*VLOOKUP($G16,OH,2,FALSE),0) | =SUM(K16,L16,M16)*GA_PRIME_LABOR_1 |
| =IFERROR(K17*VLOOKUP($F17,FRINGE,2,FALSE),0) | =IFERROR(SUM(K17,L17)*VLOOKUP($G17,OH,2,FALSE),0) | =SUM(K17,L17,M17)*GA_PRIME_LABOR_1 | =IFERROR(K17*VLOOKUP($F17,FRINGE,2,FALSE),0) | =IFERROR(SUM(K17,L17)*VLOOKUP($G17,OH,2,FALSE),0) | =SUM(K17,L17,M17)*GA_PRIME_LABOR_1 |
| =IFERROR(K18*VLOOKUP($F18,FRINGE,2,FALSE),0) | =IFERROR(SUM(K18,L18)*VLOOKUP($G18,OH,2,FALSE),0) | =SUM(K18,L18,M18)*GA_PRIME_LABOR_1 | =IFERROR(K18*VLOOKUP($F18,FRINGE,2,FALSE),0) | =IFERROR(SUM(K18,L18)*VLOOKUP($G18,OH,2,FALSE),0) | =SUM(K18,L18,M18)*GA_PRIME_LABOR_1 |
| =IFERROR(K19*VLOOKUP($F19,FRINGE,2,FALSE),0) | =IFERROR(SUM(K19,L19)*VLOOKUP($G19,OH,2,FALSE),0) | =SUM(K19,L19,M19)*GA_PRIME_LABOR_1 | =IFERROR(K19*VLOOKUP($F19,FRINGE,2,FALSE),0) | =IFERROR(SUM(K19,L19)*VLOOKUP($G19,OH,2,FALSE),0) | =SUM(K19,L19,M19)*GA_PRIME_LABOR_1 |
| =IFERROR(K20*VLOOKUP($F20,FRINGE,2,FALSE),0) | =IFERROR(SUM(K20,L20)*VLOOKUP($G20,OH,2,FALSE),0) | =SUM(K20,L20,M20)*GA_PRIME_LABOR_1 | =IFERROR(K20*VLOOKUP($F20,FRINGE,2,FALSE),0) | =IFERROR(SUM(K20,L20)*VLOOKUP($G20,OH,2,FALSE),0) | =SUM(K20,L20,M20)*GA_PRIME_LABOR_1 |
| =IFERROR(K21*VLOOKUP($F21,FRINGE,2,FALSE),0) | =IFERROR(SUM(K21,L21)*VLOOKUP($G21,OH,2,FALSE),0) | =SUM(K21,L21,M21)*GA_PRIME_LABOR_1 | =IFERROR(K21*VLOOKUP($F21,FRINGE,2,FALSE),0) | =IFERROR(SUM(K21,L21)*VLOOKUP($G21,OH,2,FALSE),0) | =SUM(K21,L21,M21)*GA_PRIME_LABOR_1 |
| =IFERROR(K22*VLOOKUP($F22,FRINGE,2,FALSE),0) | =IFERROR(SUM(K22,L22)*VLOOKUP($G22,OH,2,FALSE),0) | =SUM(K22,L22,M22)*GA_PRIME_LABOR_1 | =IFERROR(K22*VLOOKUP($F22,FRINGE,2,FALSE),0) | =IFERROR(SUM(K22,L22)*VLOOKUP($G22,OH,2,FALSE),0) | =SUM(K22,L22,M22)*GA_PRIME_LABOR_1 |
| =IFERROR(K23*VLOOKUP($F23,FRINGE,2,FALSE),0) | =IFERROR(SUM(K23,L23)*VLOOKUP($G23,OH,2,FALSE),0) | =SUM(K23,L23,M23)*GA_PRIME_LABOR_1 | =IFERROR(K23*VLOOKUP($F23,FRINGE,2,FALSE),0) | =IFERROR(SUM(K23,L23)*VLOOKUP($G23,OH,2,FALSE),0) | =SUM(K23,L23,M23)*GA_PRIME_LABOR_1 |
| =IFERROR(K24*VLOOKUP($F24,FRINGE,2,FALSE),0) | =IFERROR(SUM(K24,L24)*VLOOKUP($G24,OH,2,FALSE),0) | =SUM(K24,L24,M24)*GA_PRIME_LABOR_1 | =IFERROR(K24*VLOOKUP($F24,FRINGE,2,FALSE),0) | =IFERROR(SUM(K24,L24)*VLOOKUP($G24,OH,2,FALSE),0) | =SUM(K24,L24,M24)*GA_PRIME_LABOR_1 |
| =IFERROR(K25*VLOOKUP($F25,FRINGE,2,FALSE),0) | =IFERROR(SUM(K25,L25)*VLOOKUP($G25,OH,2,FALSE),0) | =SUM(K25,L25,M25)*GA_PRIME_LABOR_1 | =IFERROR(K25*VLOOKUP($F25,FRINGE,2,FALSE),0) | =IFERROR(SUM(K25,L25)*VLOOKUP($G25,OH,2,FALSE),0) | =SUM(K25,L25,M25)*GA_PRIME_LABOR_1 |
| =IFERROR(K26*VLOOKUP($F26,FRINGE,2,FALSE),0) | =IFERROR(SUM(K26,L26)*VLOOKUP($G26,OH,2,FALSE),0) | =SUM(K26,L26,M26)*GA_PRIME_LABOR_1 | =IFERROR(K26*VLOOKUP($F26,FRINGE,2,FALSE),0) | =IFERROR(SUM(K26,L26)*VLOOKUP($G26,OH,2,FALSE),0) | =SUM(K26,L26,M26)*GA_PRIME_LABOR_1 |
| =IFERROR(K27*VLOOKUP($F27,FRINGE,2,FALSE),0) | =IFERROR(SUM(K27,L27)*VLOOKUP($G27,OH,2,FALSE),0) | =SUM(K27,L27,M27)*GA_PRIME_LABOR_1 | =IFERROR(K27*VLOOKUP($F27,FRINGE,2,FALSE),0) | =IFERROR(SUM(K27,L27)*VLOOKUP($G27,OH,2,FALSE),0) | =SUM(K27,L27,M27)*GA_PRIME_LABOR_1 |
| =IFERROR(K28*VLOOKUP($F28,FRINGE,2,FALSE),0) | =IFERROR(SUM(K28,L28)*VLOOKUP($G28,OH,2,FALSE),0) | =SUM(K28,L28,M28)*GA_PRIME_LABOR_1 | =IFERROR(K28*VLOOKUP($F28,FRINGE,2,FALSE),0) | =IFERROR(SUM(K28,L28)*VLOOKUP($G28,OH,2,FALSE),0) | =SUM(K28,L28,M28)*GA_PRIME_LABOR_1 |
| =IFERROR(K29*VLOOKUP($F29,FRINGE,2,FALSE),0) | =IFERROR(SUM(K29,L29)*VLOOKUP($G29,OH,2,FALSE),0) | =SUM(K29,L29,M29)*GA_PRIME_LABOR_1 | =IFERROR(K29*VLOOKUP($F29,FRINGE,2,FALSE),0) | =IFERROR(SUM(K29,L29)*VLOOKUP($G29,OH,2,FALSE),0) | =SUM(K29,L29,M29)*GA_PRIME_LABOR_1 |
| =IFERROR(K30*VLOOKUP($F30,FRINGE,2,FALSE),0) | =IFERROR(SUM(K30,L30)*VLOOKUP($G30,OH,2,FALSE),0) | =SUM(K30,L30,M30)*GA_PRIME_LABOR_1 | =IFERROR(K30*VLOOKUP($F30,FRINGE,2,FALSE),0) | =IFERROR(SUM(K30,L30)*VLOOKUP($G30,OH,2,FALSE),0) | =SUM(K30,L30,M30)*GA_PRIME_LABOR_1 |
| =IFERROR(K31*VLOOKUP($F31,FRINGE,2,FALSE),0) | =IFERROR(SUM(K31,L31)*VLOOKUP($G31,OH,2,FALSE),0) | =SUM(K31,L31,M31)*GA_PRIME_LABOR_1 | =IFERROR(K31*VLOOKUP($F31,FRINGE,2,FALSE),0) | =IFERROR(SUM(K31,L31)*VLOOKUP($G31,OH,2,FALSE),0) | =SUM(K31,L31,M31)*GA_PRIME_LABOR_1 |
| =IFERROR(K32*VLOOKUP($F32,FRINGE,2,FALSE),0) | =IFERROR(SUM(K32,L32)*VLOOKUP($G32,OH,2,FALSE),0) | =SUM(K32,L32,M32)*GA_PRIME_LABOR_1 | =IFERROR(K32*VLOOKUP($F32,FRINGE,2,FALSE),0) | =IFERROR(SUM(K32,L32)*VLOOKUP($G32,OH,2,FALSE),0) | =SUM(K32,L32,M32)*GA_PRIME_LABOR_1 |
| =IFERROR(K33*VLOOKUP($F33,FRINGE,2,FALSE),0) | =IFERROR(SUM(K33,L33)*VLOOKUP($G33,OH,2,FALSE),0) | =SUM(K33,L33,M33)*GA_PRIME_LABOR_1 | =IFERROR(K33*VLOOKUP($F33,FRINGE,2,FALSE),0) | =IFERROR(SUM(K33,L33)*VLOOKUP($G33,OH,2,FALSE),0) | =SUM(K33,L33,M33)*GA_PRIME_LABOR_1 |
| =IFERROR(K34*VLOOKUP($F34,FRINGE,2,FALSE),0) | =IFERROR(SUM(K34,L34)*VLOOKUP($G34,OH,2,FALSE),0) | =SUM(K34,L34,M34)*GA_PRIME_LABOR_1 | =IFERROR(K34*VLOOKUP($F34,FRINGE,2,FALSE),0) | =IFERROR(SUM(K34,L34)*VLOOKUP($G34,OH,2,FALSE),0) | =SUM(K34,L34,M34)*GA_PRIME_LABOR_1 |
| =IFERROR(K35*VLOOKUP($F35,FRINGE,2,FALSE),0) | =IFERROR(SUM(K35,L35)*VLOOKUP($G35,OH,2,FALSE),0) | =SUM(K35,L35,M35)*GA_PRIME_LABOR_1 | =IFERROR(K35*VLOOKUP($F35,FRINGE,2,FALSE),0) | =IFERROR(SUM(K35,L35)*VLOOKUP($G35,OH,2,FALSE),0) | =SUM(K35,L35,M35)*GA_PRIME_LABOR_1 |
| =IFERROR(K36*VLOOKUP($F36,FRINGE,2,FALSE),0) | =IFERROR(SUM(K36,L36)*VLOOKUP($G36,OH,2,FALSE),0) | =SUM(K36,L36,M36)*GA_PRIME_LABOR_1 | =IFERROR(K36*VLOOKUP($F36,FRINGE,2,FALSE),0) | =IFERROR(SUM(K36,L36)*VLOOKUP($G36,OH,2,FALSE),0) | =SUM(K36,L36,M36)*GA_PRIME_LABOR_1 |
| =IFERROR(K37*VLOOKUP($F37,FRINGE,2,FALSE),0) | =IFERROR(SUM(K37,L37)*VLOOKUP($G37,OH,2,FALSE),0) | =SUM(K37,L37,M37)*GA_PRIME_LABOR_1 | =IFERROR(K37*VLOOKUP($F37,FRINGE,2,FALSE),0) | =IFERROR(SUM(K37,L37)*VLOOKUP($G37,OH,2,FALSE),0) | =SUM(K37,L37,M37)*GA_PRIME_LABOR_1 |
| =IFERROR(K38*VLOOKUP($F38,FRINGE,2,FALSE),0) | =IFERROR(SUM(K38,L38)*VLOOKUP($G38,OH,2,FALSE),0) | =SUM(K38,L38,M38)*GA_PRIME_LABOR_1 | =IFERROR(K38*VLOOKUP($F38,FRINGE,2,FALSE),0) | =IFERROR(SUM(K38,L38)*VLOOKUP($G38,OH,2,FALSE),0) | =SUM(K38,L38,M38)*GA_PRIME_LABOR_1 |
| =IFERROR(K39*VLOOKUP($F39,FRINGE,2,FALSE),0) | =IFERROR(SUM(K39,L39)*VLOOKUP($G39,OH,2,FALSE),0) | =SUM(K39,L39,M39)*GA_PRIME_LABOR_1 | =IFERROR(K39*VLOOKUP($F39,FRINGE,2,FALSE),0) | =IFERROR(SUM(K39,L39)*VLOOKUP($G39,OH,2,FALSE),0) | =SUM(K39,L39,M39)*GA_PRIME_LABOR_1 |
| =IFERROR(K40*VLOOKUP($F40,FRINGE,2,FALSE),0) | =IFERROR(SUM(K40,L40)*VLOOKUP($G40,OH,2,FALSE),0) | =SUM(K40,L40,M40)*GA_PRIME_LABOR_1 | =IFERROR(K40*VLOOKUP($F40,FRINGE,2,FALSE),0) | =IFERROR(SUM(K40,L40)*VLOOKUP($G40,OH,2,FALSE),0) | =SUM(K40,L40,M40)*GA_PRIME_LABOR_1 |
| =IFERROR(K41*VLOOKUP($F41,FRINGE,2,FALSE),0) | =IFERROR(SUM(K41,L41)*VLOOKUP($G41,OH,2,FALSE),0) | =SUM(K41,L41,M41)*GA_PRIME_LABOR_1 | =IFERROR(K41*VLOOKUP($F41,FRINGE,2,FALSE),0) | =IFERROR(SUM(K41,L41)*VLOOKUP($G41,OH,2,FALSE),0) | =SUM(K41,L41,M41)*GA_PRIME_LABOR_1 |
| =IFERROR(K42*VLOOKUP($F42,FRINGE,2,FALSE),0) | =IFERROR(SUM(K42,L42)*VLOOKUP($G42,OH,2,FALSE),0) | =SUM(K42,L42,M42)*GA_PRIME_LABOR_1 | =IFERROR(K42*VLOOKUP($F42,FRINGE,2,FALSE),0) | =IFERROR(SUM(K42,L42)*VLOOKUP($G42,OH,2,FALSE),0) | =SUM(K42,L42,M42)*GA_PRIME_LABOR_1 |
| =IFERROR(K43*VLOOKUP($F43,FRINGE,2,FALSE),0) | =IFERROR(SUM(K43,L43)*VLOOKUP($G43,OH,2,FALSE),0) | =SUM(K43,L43,M43)*GA_PRIME_LABOR_1 | =IFERROR(K43*VLOOKUP($F43,FRINGE,2,FALSE),0) | =IFERROR(SUM(K43,L43)*VLOOKUP($G43,OH,2,FALSE),0) | =SUM(K43,L43,M43)*GA_PRIME_LABOR_1 |
| =IFERROR(K44*VLOOKUP($F44,FRINGE,2,FALSE),0) | =IFERROR(SUM(K44,L44)*VLOOKUP($G44,OH,2,FALSE),0) | =SUM(K44,L44,M44)*GA_PRIME_LABOR_1 | =IFERROR(K44*VLOOKUP($F44,FRINGE,2,FALSE),0) | =IFERROR(SUM(K44,L44)*VLOOKUP($G44,OH,2,FALSE),0) | =SUM(K44,L44,M44)*GA_PRIME_LABOR_1 |
| =IFERROR(K45*VLOOKUP($F45,FRINGE,2,FALSE),0) | =IFERROR(SUM(K45,L45)*VLOOKUP($G45,OH,2,FALSE),0) | =SUM(K45,L45,M45)*GA_PRIME_LABOR_1 | =IFERROR(K45*VLOOKUP($F45,FRINGE,2,FALSE),0) | =IFERROR(SUM(K45,L45)*VLOOKUP($G45,OH,2,FALSE),0) | =SUM(K45,L45,M45)*GA_PRIME_LABOR_1 |
| =IFERROR(K46*VLOOKUP($F46,FRINGE,2,FALSE),0) | =IFERROR(SUM(K46,L46)*VLOOKUP($G46,OH,2,FALSE),0) | =SUM(K46,L46,M46)*GA_PRIME_LABOR_1 | =IFERROR(K46*VLOOKUP($F46,FRINGE,2,FALSE),0) | =IFERROR(SUM(K46,L46)*VLOOKUP($G46,OH,2,FALSE),0) | =SUM(K46,L46,M46)*GA_PRIME_LABOR_1 |
| =IFERROR(K47*VLOOKUP($F47,FRINGE,2,FALSE),0) | =IFERROR(SUM(K47,L47)*VLOOKUP($G47,OH,2,FALSE),0) | =SUM(K47,L47,M47)*GA_PRIME_LABOR_1 | =IFERROR(K47*VLOOKUP($F47,FRINGE,2,FALSE),0) | =IFERROR(SUM(K47,L47)*VLOOKUP($G47,OH,2,FALSE),0) | =SUM(K47,L47,M47)*GA_PRIME_LABOR_1 |
| =IFERROR(K48*VLOOKUP($F48,FRINGE,2,FALSE),0) | =IFERROR(SUM(K48,L48)*VLOOKUP($G48,OH,2,FALSE),0) | =SUM(K48,L48,M48)*GA_PRIME_LABOR_1 | =IFERROR(K48*VLOOKUP($F48,FRINGE,2,FALSE),0) | =IFERROR(SUM(K48,L48)*VLOOKUP($G48,OH,2,FALSE),0) | =SUM(K48,L48,M48)*GA_PRIME_LABOR_1 |
| =IFERROR(K49*VLOOKUP($F49,FRINGE,2,FALSE),0) | =IFERROR(SUM(K49,L49)*VLOOKUP($G49,OH,2,FALSE),0) | =SUM(K49,L49,M49)*GA_PRIME_LABOR_1 | =IFERROR(K49*VLOOKUP($F49,FRINGE,2,FALSE),0) | =IFERROR(SUM(K49,L49)*VLOOKUP($G49,OH,2,FALSE),0) | =SUM(K49,L49,M49)*GA_PRIME_LABOR_1 |
| =IFERROR(K50*VLOOKUP($F50,FRINGE,2,FALSE),0) | =IFERROR(SUM(K50,L50)*VLOOKUP($G50,OH,2,FALSE),0) | =SUM(K50,L50,M50)*GA_PRIME_LABOR_1 | =IFERROR(K50*VLOOKUP($F50,FRINGE,2,FALSE),0) | =IFERROR(SUM(K50,L50)*VLOOKUP($G50,OH,2,FALSE),0) | =SUM(K50,L50,M50)*GA_PRIME_LABOR_1 |
| =IFERROR(K51*VLOOKUP($F51,FRINGE,2,FALSE),0) | =IFERROR(SUM(K51,L51)*VLOOKUP($G51,OH,2,FALSE),0) | =SUM(K51,L51,M51)*GA_PRIME_LABOR_1 | =IFERROR(K51*VLOOKUP($F51,FRINGE,2,FALSE),0) | =IFERROR(SUM(K51,L51)*VLOOKUP($G51,OH,2,FALSE),0) | =SUM(K51,L51,M51)*GA_PRIME_LABOR_1 |
| =IFERROR(K52*VLOOKUP($F52,FRINGE,2,FALSE),0) | =IFERROR(SUM(K52,L52)*VLOOKUP($G52,OH,2,FALSE),0) | =SUM(K52,L52,M52)*GA_PRIME_LABOR_1 | =IFERROR(K52*VLOOKUP($F52,FRINGE,2,FALSE),0) | =IFERROR(SUM(K52,L52)*VLOOKUP($G52,OH,2,FALSE),0) | =SUM(K52,L52,M52)*GA_PRIME_LABOR_1 |
| =IFERROR(K53*VLOOKUP($F53,FRINGE,2,FALSE),0) | =IFERROR(SUM(K53,L53)*VLOOKUP($G53,OH,2,FALSE),0) | =SUM(K53,L53,M53)*GA_PRIME_LABOR_1 | =IFERROR(K53*VLOOKUP($F53,FRINGE,2,FALSE),0) | =IFERROR(SUM(K53,L53)*VLOOKUP($G53,OH,2,FALSE),0) | =SUM(K53,L53,M53)*GA_PRIME_LABOR_1 |
| =IFERROR(K54*VLOOKUP($F54,FRINGE,2,FALSE),0) | =IFERROR(SUM(K54,L54)*VLOOKUP($G54,OH,2,FALSE),0) | =SUM(K54,L54,M54)*GA_PRIME_LABOR_1 | =IFERROR(K54*VLOOKUP($F54,FRINGE,2,FALSE),0) | =IFERROR(SUM(K54,L54)*VLOOKUP($G54,OH,2,FALSE),0) | =SUM(K54,L54,M54)*GA_PRIME_LABOR_1 |
| =IFERROR(K55*VLOOKUP($F55,FRINGE,2,FALSE),0) | =IFERROR(SUM(K55,L55)*VLOOKUP($G55,OH,2,FALSE),0) | =SUM(K55,L55,M55)*GA_PRIME_LABOR_1 | =IFERROR(K55*VLOOKUP($F55,FRINGE,2,FALSE),0) | =IFERROR(SUM(K55,L55)*VLOOKUP($G55,OH,2,FALSE),0) | =SUM(K55,L55,M55)*GA_PRIME_LABOR_1 |
| =IFERROR(K56*VLOOKUP($F56,FRINGE,2,FALSE),0) | =IFERROR(SUM(K56,L56)*VLOOKUP($G56,OH,2,FALSE),0) | =SUM(K56,L56,M56)*GA_PRIME_LABOR_1 | =IFERROR(K56*VLOOKUP($F56,FRINGE,2,FALSE),0) | =IFERROR(SUM(K56,L56)*VLOOKUP($G56,OH,2,FALSE),0) | =SUM(K56,L56,M56)*GA_PRIME_LABOR_1 |
| =IFERROR(K57*VLOOKUP($F57,FRINGE,2,FALSE),0) | =IFERROR(SUM(K57,L57)*VLOOKUP($G57,OH,2,FALSE),0) | =SUM(K57,L57,M57)*GA_PRIME_LABOR_1 | =IFERROR(K57*VLOOKUP($F57,FRINGE,2,FALSE),0) | =IFERROR(SUM(K57,L57)*VLOOKUP($G57,OH,2,FALSE),0) | =SUM(K57,L57,M57)*GA_PRIME_LABOR_1 |
| =IFERROR(K58*VLOOKUP($F58,FRINGE,2,FALSE),0) | =IFERROR(SUM(K58,L58)*VLOOKUP($G58,OH,2,FALSE),0) | =SUM(K58,L58,M58)*GA_PRIME_LABOR_1 | =IFERROR(K58*VLOOKUP($F58,FRINGE,2,FALSE),0) | =IFERROR(SUM(K58,L58)*VLOOKUP($G58,OH,2,FALSE),0) | =SUM(K58,L58,M58)*GA_PRIME_LABOR_1 |
| =IFERROR(K59*VLOOKUP($F59,FRINGE,2,FALSE),0) | =IFERROR(SUM(K59,L59)*VLOOKUP($G59,OH,2,FALSE),0) | =SUM(K59,L59,M59)*GA_PRIME_LABOR_1 | =IFERROR(K59*VLOOKUP($F59,FRINGE,2,FALSE),0) | =IFERROR(SUM(K59,L59)*VLOOKUP($G59,OH,2,FALSE),0) | =SUM(K59,L59,M59)*GA_PRIME_LABOR_1 |
| =IFERROR(K60*VLOOKUP($F60,FRINGE,2,FALSE),0) | =IFERROR(SUM(K60,L60)*VLOOKUP($G60,OH,2,FALSE),0) | =SUM(K60,L60,M60)*GA_PRIME_LABOR_1 | =IFERROR(K60*VLOOKUP($F60,FRINGE,2,FALSE),0) | =IFERROR(SUM(K60,L60)*VLOOKUP($G60,OH,2,FALSE),0) | =SUM(K60,L60,M60)*GA_PRIME_LABOR_1 |
| =IFERROR(K61*VLOOKUP($F61,FRINGE,2,FALSE),0) | =IFERROR(SUM(K61,L61)*VLOOKUP($G61,OH,2,FALSE),0) | =SUM(K61,L61,M61)*GA_PRIME_LABOR_1 | =IFERROR(K61*VLOOKUP($F61,FRINGE,2,FALSE),0) | =IFERROR(SUM(K61,L61)*VLOOKUP($G61,OH,2,FALSE),0) | =SUM(K61,L61,M61)*GA_PRIME_LABOR_1 |
| =IFERROR(K62*VLOOKUP($F62,FRINGE,2,FALSE),0) | =IFERROR(SUM(K62,L62)*VLOOKUP($G62,OH,2,FALSE),0) | =SUM(K62,L62,M62)*GA_PRIME_LABOR_1 | =IFERROR(K62*VLOOKUP($F62,FRINGE,2,FALSE),0) | =IFERROR(SUM(K62,L62)*VLOOKUP($G62,OH,2,FALSE),0) | =SUM(K62,L62,M62)*GA_PRIME_LABOR_1 |
| =IFERROR(K63*VLOOKUP($F63,FRINGE,2,FALSE),0) | =IFERROR(SUM(K63,L63)*VLOOKUP($G63,OH,2,FALSE),0) | =SUM(K63,L63,M63)*GA_PRIME_LABOR_1 | =IFERROR(K63*VLOOKUP($F63,FRINGE,2,FALSE),0) | =IFERROR(SUM(K63,L63)*VLOOKUP($G63,OH,2,FALSE),0) | =SUM(K63,L63,M63)*GA_PRIME_LABOR_1 |
| =IFERROR(K64*VLOOKUP($F64,FRINGE,2,FALSE),0) | =IFERROR(SUM(K64,L64)*VLOOKUP($G64,OH,2,FALSE),0) | =SUM(K64,L64,M64)*GA_PRIME_LABOR_1 | =IFERROR(K64*VLOOKUP($F64,FRINGE,2,FALSE),0) | =IFERROR(SUM(K64,L64)*VLOOKUP($G64,OH,2,FALSE),0) | =SUM(K64,L64,M64)*GA_PRIME_LABOR_1 |
| =IFERROR(K65*VLOOKUP($F65,FRINGE,2,FALSE),0) | =IFERROR(SUM(K65,L65)*VLOOKUP($G65,OH,2,FALSE),0) | =SUM(K65,L65,M65)*GA_PRIME_LABOR_1 | =IFERROR(K65*VLOOKUP($F65,FRINGE,2,FALSE),0) | =IFERROR(SUM(K65,L65)*VLOOKUP($G65,OH,2,FALSE),0) | =SUM(K65,L65,M65)*GA_PRIME_LABOR_1 |
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 .