Attachment 5A - Prime Pricing Model - 18R0081.xlsx
XLSX spreadsheet 248 KB Posted
- Attached to
- SATCOM CB ISEA Support
- Solicitation number
- N65236-18-R-0081
About this file
This notice announces a potential solicitation for Satellite Communications In-Service Engineering Agent support services. The Department of the Navy's Space and Naval Warfare Systems Command Atlantic is seeking small businesses with relevant experience to provide In-Service Engineering Agent support for SATCOM systems across the SPAWAR enterprise in support of Program Executive Office Command, Control, Communications, Computers, and Intelligence and the Fleet Readiness Directorate. An industry day will be held on March 13, 2019 at Camp Pendleton to discuss a draft Performance Work Statement and evaluation factors. The response deadline for questions was June 1, 2018. It is anticipated that this solicitation and one issued by the Space and Naval Warfare Systems Command Pacific for similar SATCOM support services will result in two separate contract awards based on area of responsibility and performance work statement requirements.
View the file
Other files
Show all 21
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
INSTRUCTIONS
GENERAL INSTRUCTIONS AND INFORMATION
PRIME CONTRACTOR PRICING MODEL
| CONTRACT VEHICLE: | TBD | ||
| RFP NUMBER: | N65236-18-R-0081 | ||
| PR NUMBER: | TBD | ||
| TITLE: | SATCOM ISEA | ||
| PRICIING MODEL VERSION: | 1.0 | ||
| CONTRACT SPECIALIST: | Lacey C. Flint | (843) 218-6142 | lacey.flint@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 (see FAR 31.203) |
- 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.) | Select a G&A allocation base from the drop down on CONTRACTOR DATA INPUT worksheet (see FAR 31.203) |
| 5.) | Explain basis for indirect rates in space provided on CONTRACTOR DATA INPUT worksheet. (see FAR 31.203) |
Assumptions have been made by the Government that may not match with offeror's accounting practices.
6.) 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)
- Update the Subtotal for Subcontractor Labor costs formula
7.) 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
| 8.) | Populate labor rates on RATES worksheet (column K). |
| 9.) | If offeror's job titles are different from those in the solicitation, document on the UNCOMPENSATED OT worksheet. |
| 10.) | If rates are calculated using any value other than 2,080 hours per year, document number of hours per year used to calculate the hourly rate for each category on UNCOMPENSATED OT worksheet. |
| 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
CONTRACTOR DATA INPUT
| SECTION 1 - Header Information |
| Contractor Name: |
| CAGE: |
| SeaPort-e Contract #: |
| Contractor Proposal #: |
| Proposal Date: |
| Valid until: |
| SECTION 2 - Proposal Team | |
| SUBCONTRACTOR #1 : | SUB #1 |
| SUBCONTRACTOR #2 : | SUB #2 |
| SUBCONTRACTOR #3 : | SUB #3 |
| SUBCONTRACTOR #4 : | SUB #4 |
| SUBCONTRACTOR #5 : | SUB #5 |
| SUBCONTRACTOR #6 : | SUB #6 |
| SECTION 3 - Loading Factors | |||
| ESCALATION | BASE | OPTION | |
| 1 | OPTION | ||
| 2 | OPTION | ||
| 3 | OPTION |
| ESCALATION - PROFESSIONAL | N/A | 0.00% | 0.00% | 0.00% | 0.00% |
| ESCALATION - SCLS | N/A | 0.00% | 0.00% | 0.00% | 0.00% |
| FRINGE | BASE | 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 | BASE | 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 | BASE | OPTION | |
| 1 | OPTION | ||
| 2 | OPTION | ||
| 3 | OPTION | ||
| 4 | Allocation Base |
| G&A ALLOCATION METHODOLOGY (see FAR 31.203) (select from drop down) : | ||||||
| G&A on TOTAL COST (less material and subcontracts) | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Total Costs |
| Material Handling Rate on Subs | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Subcontractor Costs |
| Material Handling Rate on Material | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Material Costs |
| FEE | |
| FEE on LABOR (applied to base and options) | 0.00% |
| FEE on SUBCONTRACTOR LABOR (applied to base and options) | 0.00% |
| FEE on ODCs (applied to base and options) | 0.00% |
CONTRACTOR CHANGES TO THE PRICING MODEL AND PROPOSAL EXPLANATIONS
SUMMARY
| Contract Number: | TBD |
| RFP Number: | N65236-18-R-0081 |
| Task Name: | SATCOM ISEA |
| Contractor Name: | |
| Contractor Proposal #: | |
| Proposal Date: | |
| Valid until: |
| BASE | OPTION 1 | OPTION 2 | OPTION 3 | OPTION 4 | TOTAL | |
| LABOR | 0 - 0 | 1001 - 1001 | 0 - 0 | 0 - 0 | 0 - 0 | TOTAL |
| LABOR HOUR ALLOCATION: | ||||||
| PRIME LABOR HOURS: | - | - | - | - | - | - |
| SUB #1 LABOR HOURS: | - | - | - | - | - | - |
| SUB #2 LABOR HOURS: | - | - | - | - | - | - |
| SUB #3 LABOR HOURS: | - | - | - | - | - | - |
| SUB #4 LABOR HOURS: | - | - | - | - | - | - |
| SUB #5 LABOR HOURS: | - | - | - | - | - | - |
| SUB #6 LABOR HOURS: | - | - | - | - | - | - |
| SUBTOTAL SUBCONTRACTOR LABOR HOURS: | - | - | - | - | - | - |
| TOTAL PRIME & SUBCONTRACTOR LABOR HRs: | - | - | - | - | - | - |
| PRIME CONTRACTOR LABOR COSTS | ||||||
| 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 COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBCONTRACTOR LABOR COSTS | ||||||
| SUB #1 LABOR COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #2 LABOR COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #3 LABOR COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #4 LABOR COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #5 LABOR COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #6 LABOR COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL SUBCONTRACTOR LABOR COST : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| MATERIAL HANDLING on SUBCONTRACTOR LABOR : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| G&A on SUBCONTRACTOR M&H : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL PRIME & SUBCONTRACTOR LABOR: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| OTHER DIRECT COSTS | 0 - 0 | 1001 - 1001 | 0 - 0 | 0 - 0 | 0 - 0 | TOTAL |
| - MATERIAL : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| - TRAVEL : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| - MISCELLANEOUS ODCs : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| - ADDITIONAL ODC - (if applicable) : | $ - 0 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| MATERIAL HANDLING on MATERIALS : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| G&A on MATERIAL HANDLING : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| G&A on TRAVEL, MISC ODCs & ADDITIONAL ODCs : | $ - 0 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| TOTAL ODCs : | $ - 0 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| TOTAL | 0 - 0 | |||||||
| 0 - 0 | 1001 - 1001 | |||||||
| 1001 - 1001 | 0 - 0 | |||||||
| 0 - 0 | 0 - 0 | |||||||
| 0 - 0 | 0 - 0 | |||||||
| 0 - 0 | TOTAL | |||||||
| TOTAL COST (LABOR + ODCs) : | $ - 0 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| FEE on PRIME LABOR - 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| FEE on SUBCONTRACTOR LABOR - 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| FEE on ODCS - 0.00% | $ - 0 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
FCCM (if applicable) : $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
GRAND TOTAL : $ - 0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
| LABOR | 0001 | 1001 | 0 | 0 | 0 | TOTAL |
| LABOR HOUR ALLOCATION | ||||||
| PRIME LABOR HRs: 100.00% | 201,300 | - | - | - | - | 201,300 |
| SUB #1 LABOR HOURS: 0.00% | - | - | - | - | - | - |
| SUB #2 LABOR HOURS: 0.00% | - | - | - | - | - | - |
| SUB #3 LABOR HOURS: 0.00% | - | - | - | - | - | - |
| SUB #4 LABOR HOURS: 0.00% | - | - | - | - | - | - |
| SUB #5 LABOR HOURS: 0.00% | - | - | - | - | - | - |
| SUB #6 LABOR HOURS: 0.00% | - | - | - | - | - | - |
| SUBTOTAL SUBCONTRACTOR LABOR HOURS : | - | - | - | - | - | - |
| TOTAL PRIME & SUBCONTRACTOR LABOR HRs : | 201,300 | - | - | - | - | 201,300 |
| PRIME CONTRACTOR LABOR COSTS | ||||||
| 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 COST : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBCONTRACTOR LABOR COSTS | ||||||
| SUB #1 LABOR COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #2 LABOR COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #3 LABOR COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #4 LABOR COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #5 LABOR COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUB #6 LABOR COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL SUBCONTRACTOR LABOR COSTS : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| MATERIAL HANDLING on SUBCONTRACTOR LABOR : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| G&A on SUBCONTRACTOR M&H : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL PRIME & SUBCONTRACTOR LABOR COST : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| OTHER DIRECT COSTS | 0001 | 1001 | 0 | 0 | 0 | TOTAL |
| - MATERIAL : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| - TRAVEL : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| - MISCELLANEOUS ODCs : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| - ADDITIONAL ODC - (if applicable) : | $ - 0 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| MATERIAL HANDLING on MATERIALS : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| G&A on MATERIAL HANDLING : | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| G&A on TRAVEL, MISC ODCs & ADDITIONAL ODCs : | $ - 0 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| TOTAL ODCs : | $ - 0 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| TOTAL | ||||||
| TOTAL COST (LABOR + ODCs) : | $ - 0 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| FEE on PRIME LABOR - 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| FEE on SUBCONTRACTOR LABOR - 0.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| FEE on ODCS - 0.00% | $ - 0 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
FCCM (if applicable) : $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
GRAND TOTAL : $ - 0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
&"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 | Cybersecurity Specialist 2 | Charleston, SC | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 2.) | Professional | Program Manager | Charleston, SC | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 3.) | Professional | Project Manager | Charleston, SC | Contractor | 6,000 | - | - | - | - | - | - | - | - | - | - | - | - | 6,000 | - | |
| 4.) | Professional | Technical Writer/Editor 1 | Charleston, SC | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 5.) | SCLS | Administrative Assistant (01020) | Charleston, SC | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 6.) | SCLS | Engineering Technician IV (30084) | Charleston, SC | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 7.) | SCLS | Engineering Technician VI (30086) | Charleston, SC | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 8.) | SCLS | System Support Specialist (14170) | Charleston, SC | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 9.) | SCLS | Technical Instructor/Course Developer (15095) | Charleston, SC | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 10.) | Professional | Computer Network Architect 1 | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 11.) | Professional | Computer Network Architect 2 | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 12.) | Professional | Cybersecurity Specialist 1 | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 13.) | Professional | Engineer/Scientist 3 | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 14.) | Professional | Engineer/Scientist 4 | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 15.) | Professional | Engineer/Scientist 5 | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 16.) | Professional | Information Security Analyst | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 17.) | Professional | Logistician 2 | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 18.) | Professional | Logistician 4 | Charleston, SC | Government | 8,000 | - | - | - | - | - | - | - | - | - | - | - | - | 8,000 | - | |
| 19.) | Professional | SME - GBS | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 20.) | Professional | SME - NMT | Charleston, SC | Government | 4,000 | - | - | - | - | - | - | - | - | - | - | - | - | 4,000 | - | |
| 21.) | Professional | SME - SATCOM IA | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 22.) | Professional | Subject Matter Expert (SME) 1 | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 23.) | Professional | Subject Matter Expert (SME) 3 | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 24.) | Professional | Subject Matter Expert (SME) 4 | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 25.) | Professional | Subject Matter Expert (SME) 5 | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 26.) | Professional | Technical Writer/Editor 2 | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 27.) | SCLS | Computer Programmer II (14072) | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 28.) | SCLS | Computer Programmer III (14073) | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 29.) | SCLS | Computer Programmer IV (14074) | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 30.) | SCLS | Computer Systems Analyst II (14102) | Charleston, SC | Government | 4,000 | - | - | - | - | - | - | - | - | - | - | - | - | 4,000 | - | |
| 31.) | SCLS | Computer Systems Analyst III (14103) | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 32.) | SCLS | Drafter/CAD Operator III (30063) | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 33.) | SCLS | Electronics Technician Maintenance I (23181) | Charleston, SC | Government | 2,000 | 100 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | 100 |
| 34.) | SCLS | Electronics Technician Maintenance III (23183) | Charleston, SC | Government | 4,000 | 200 | - | - | - | - | - | - | - | - | - | - | - | - | 4,000 | 200 |
| 35.) | SCLS | Engineering Technician I (30081) | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 36.) | SCLS | Engineering Technician II (30082) | Charleston, SC | Government | 4,000 | - | - | - | - | - | - | - | - | - | - | - | - | 4,000 | - | |
| 37.) | SCLS | Engineering Technician III (30083) | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 38.) | SCLS | Engineering Technician V (30085) | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 39.) | SCLS | Personal Computer Support Technician (14160) | Charleston, SC | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 40.) | SCLS | Supply Technician (01410) | Charleston, SC | Government | 2,000 | 100 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | 100 |
| 41.) | SCLS | Warehouse Specialist (21410) | Charleston, SC | Government | 6,000 | 300 | - | - | - | - | - | - | - | - | - | - | - | - | 6,000 | 300 |
| 42.) | Professional | Program Manager | Norfolk, VA | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 43.) | Professional | Project Manager | Norfolk, VA | Contractor | 6,000 | - | - | - | - | - | - | - | - | - | - | - | - | 6,000 | - | |
| 44.) | Professional | SME - CBSP Ship | Norfolk, VA | Contractor | 8,000 | - | - | - | - | - | - | - | - | - | - | - | - | 8,000 | - | |
| 45.) | Professional | SME - CBSP Shore | Norfolk, VA | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 46.) | Professional | SME - NMT | Norfolk, VA | Contractor | 10,000 | - | - | - | - | - | - | - | - | - | - | - | - | 10,000 | - | |
| 47.) | Professional | SME - SATCOM IA | Norfolk, VA | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 48.) | Professional | SME - WSC-6 | Norfolk, VA | Contractor | 4,000 | - | - | - | - | - | - | - | - | - | - | - | - | 4,000 | - | |
| 49.) | Professional | Subject Matter Expert (SME) 1 | Norfolk, VA | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 50.) | Professional | Subject Matter Expert (SME) 3 | Norfolk, VA | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 51.) | Professional | Subject Matter Expert (SME) 4 | Norfolk, VA | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 52.) | SCLS | Administrative Assistant (01020) | Norfolk, VA | Contractor | 6,000 | - | - | - | - | - | - | - | - | - | - | - | - | 6,000 | - | |
| 53.) | SCLS | Drafter/CAD Operator IV (30064) | Norfolk, VA | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 54.) | SCLS | Electronics Technician Maintenance I (23181) | Norfolk, VA | Contractor | 2,000 | 100 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | 100 |
| 55.) | SCLS | Electronics Technician Maintenance II (23182) | Norfolk, VA | Contractor | 4,000 | 200 | - | - | - | - | - | - | - | - | - | - | - | - | 4,000 | 200 |
| 56.) | SCLS | Electronics Technician Maintenance III (23183) | Norfolk, VA | Contractor | 6,000 | 300 | - | - | - | - | - | - | - | - | - | - | - | - | 6,000 | 300 |
| 57.) | SCLS | Engineering Technician I (30081) | Norfolk, VA | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 58.) | SCLS | Engineering Technician II (30082) | Norfolk, VA | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 59.) | SCLS | Engineering Technician III (30083) | Norfolk, VA | Contractor | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 60.) | Professional | Cybersecurity Specialist 2 | Norfolk, VA | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 61.) | Professional | Engineer/Scientist 1 | Norfolk, VA | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 62.) | Professional | Engineer/Scientist 2 | Norfolk, VA | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 63.) | Professional | Logistician 2 | Norfolk, VA | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 64.) | Professional | Logistician 3 | Norfolk, VA | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 65.) | Professional | Logistician 4 | Norfolk, VA | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 66.) | Professional | SME - CBSP Ship | Norfolk, VA | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 67.) | Professional | SME - CBSP Shore | Norfolk, VA | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 68.) | Professional | SME - NMT | Norfolk, VA | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 69.) | Professional | SME - NSLC-A | Norfolk, VA | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 70.) | Professional | Subject Matter Expert (SME) 1 | Norfolk, VA | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 71.) | Professional | Subject Matter Expert (SME) 2 | Norfolk, VA | Government | 6,000 | - | - | - | - | - | - | - | - | - | - | - | - | 6,000 | - | |
| 72.) | Professional | NAVIDFOR Liaison | Suffolk, VA | Government | 2,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000 | - | |
| 73.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 74.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 75.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 76.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 77.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 78.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 79.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 80.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 81.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 82.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 83.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 84.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 85.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 86.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 87.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 88.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 89.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 90.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 91.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 92.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 93.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 94.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 95.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 96.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 97.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 98.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 99.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 100.) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | ||||||
| 201,300 | - | - | - | - | - | - | 201,300 |
RATES
BASE
| 0001 | |||||||
| TYPE | LABOR CATEGORY | LOCATION | SITE | FRINGE | |||
| POOL | OH | ||||||
| POOL | RG | ||||||
| Hours | OT | ||||||
| Hours | RATE | FRINGE | OH | G&A | RG |
BURDENED
RATE TOTAL
COST
| 1.) | Professional | Cybersecurity Specialist 2 | Charleston, SC | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 2.) | Professional | Program Manager | Charleston, SC | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 3.) | Professional | Project Manager | Charleston, SC | Contractor | 6,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 4.) | Professional | Technical Writer/Editor 1 | Charleston, SC | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 5.) | SCLS | Administrative Assistant (01020) | Charleston, SC | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 6.) | SCLS | Engineering Technician IV (30084) | Charleston, SC | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 7.) | SCLS | Engineering Technician VI (30086) | Charleston, SC | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 8.) | SCLS | System Support Specialist (14170) | Charleston, SC | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 9.) | SCLS | Technical Instructor/Course Developer (15095) | Charleston, SC | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 10.) | Professional | Computer Network Architect 1 | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 11.) | Professional | Computer Network Architect 2 | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 12.) | Professional | Cybersecurity Specialist 1 | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 13.) | Professional | Engineer/Scientist 3 | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 14.) | Professional | Engineer/Scientist 4 | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 15.) | Professional | Engineer/Scientist 5 | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 16.) | Professional | Information Security Analyst | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 17.) | Professional | Logistician 2 | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 18.) | Professional | Logistician 4 | Charleston, SC | Government | 8,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 19.) | Professional | SME - GBS | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 20.) | Professional | SME - NMT | Charleston, SC | Government | 4,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 21.) | Professional | SME - SATCOM IA | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 22.) | Professional | Subject Matter Expert (SME) 1 | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 23.) | Professional | Subject Matter Expert (SME) 3 | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 24.) | Professional | Subject Matter Expert (SME) 4 | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 25.) | Professional | Subject Matter Expert (SME) 5 | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 26.) | Professional | Technical Writer/Editor 2 | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 27.) | SCLS | Computer Programmer II (14072) | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 28.) | SCLS | Computer Programmer III (14073) | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 29.) | SCLS | Computer Programmer IV (14074) | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 30.) | SCLS | Computer Systems Analyst II (14102) | Charleston, SC | Government | 4,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 31.) | SCLS | Computer Systems Analyst III (14103) | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 32.) | SCLS | Drafter/CAD Operator III (30063) | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 33.) | SCLS | Electronics Technician Maintenance I (23181) | Charleston, SC | Government | 2,000 | 100 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 34.) | SCLS | Electronics Technician Maintenance III (23183) | Charleston, SC | Government | 4,000 | 200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 35.) | SCLS | Engineering Technician I (30081) | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 36.) | SCLS | Engineering Technician II (30082) | Charleston, SC | Government | 4,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 37.) | SCLS | Engineering Technician III (30083) | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 38.) | SCLS | Engineering Technician V (30085) | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 39.) | SCLS | Personal Computer Support Technician (14160) | Charleston, SC | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 40.) | SCLS | Supply Technician (01410) | Charleston, SC | Government | 2,000 | 100 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 41.) | SCLS | Warehouse Specialist (21410) | Charleston, SC | Government | 6,000 | 300 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 42.) | Professional | Program Manager | Norfolk, VA | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 43.) | Professional | Project Manager | Norfolk, VA | Contractor | 6,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 44.) | Professional | SME - CBSP Ship | Norfolk, VA | Contractor | 8,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 45.) | Professional | SME - CBSP Shore | Norfolk, VA | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 46.) | Professional | SME - NMT | Norfolk, VA | Contractor | 10,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 47.) | Professional | SME - SATCOM IA | Norfolk, VA | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 48.) | Professional | SME - WSC-6 | Norfolk, VA | Contractor | 4,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 49.) | Professional | Subject Matter Expert (SME) 1 | Norfolk, VA | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 50.) | Professional | Subject Matter Expert (SME) 3 | Norfolk, VA | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 51.) | Professional | Subject Matter Expert (SME) 4 | Norfolk, VA | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 52.) | SCLS | Administrative Assistant (01020) | Norfolk, VA | Contractor | 6,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 53.) | SCLS | Drafter/CAD Operator IV (30064) | Norfolk, VA | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 54.) | SCLS | Electronics Technician Maintenance I (23181) | Norfolk, VA | Contractor | 2,000 | 100 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 55.) | SCLS | Electronics Technician Maintenance II (23182) | Norfolk, VA | Contractor | 4,000 | 200 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 56.) | SCLS | Electronics Technician Maintenance III (23183) | Norfolk, VA | Contractor | 6,000 | 300 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 57.) | SCLS | Engineering Technician I (30081) | Norfolk, VA | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 58.) | SCLS | Engineering Technician II (30082) | Norfolk, VA | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 59.) | SCLS | Engineering Technician III (30083) | Norfolk, VA | Contractor | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 60.) | Professional | Cybersecurity Specialist 2 | Norfolk, VA | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 61.) | Professional | Engineer/Scientist 1 | Norfolk, VA | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 62.) | Professional | Engineer/Scientist 2 | Norfolk, VA | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 63.) | Professional | Logistician 2 | Norfolk, VA | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 64.) | Professional | Logistician 3 | Norfolk, VA | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 65.) | Professional | Logistician 4 | Norfolk, VA | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 66.) | Professional | SME - CBSP Ship | Norfolk, VA | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 67.) | Professional | SME - CBSP Shore | Norfolk, VA | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 68.) | Professional | SME - NMT | Norfolk, VA | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 69.) | Professional | SME - NSLC-A | Norfolk, VA | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 70.) | Professional | Subject Matter Expert (SME) 1 | Norfolk, VA | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 71.) | Professional | Subject Matter Expert (SME) 2 | Norfolk, VA | Government | 6,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 72.) | Professional | NAVIDFOR Liaison | Suffolk, VA | Government | 2,000 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 73.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 74.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 75.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 76.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 77.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 78.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 79.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 80.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 81.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 82.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 83.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 84.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 85.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 86.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 87.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 88.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 89.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 90.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 91.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 92.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 93.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 94.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 95.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 96.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 97.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 98.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 99.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 100.) | - | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 201,300 | $ - 0 |
UNCOMPENSATED OT
| 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 TITLE | LABOR RATE | ||
| (1) | ADJUSTED HOURLY RATE | |||
| (2) | EFFECTIVE HRs |
(3)
| 1.) | Computer Network Architect 1 | = | |
| 2.) | Computer Network Architect 2 | = | |
| 3.) | Cybersecurity Specialist 1 | = | |
| 4.) | Cybersecurity Specialist 2 | = | |
| 5.) | Engineer/Scientist 1 | = | |
| 6.) | Engineer/Scientist 2 | = | |
| 7.) | Engineer/Scientist 3 | = | |
| 8.) | Engineer/Scientist 4 | = | |
| 9.) | Engineer/Scientist 5 | = | |
| 10.) | Information Security Analyst | = | |
| 11.) | Logistician 2 | = | |
| 12.) | Logistician 3 | = | |
| 13.) | Logistician 4 | = | |
| 14.) | NAVIDFOR Liaison | = | |
| 15.) | Program Manager | = | |
| 16.) | Project Manager | = | |
| 17.) | SME - CBSP Ship | = | |
| 18.) | SME - CBSP Shore | = | |
| 19.) | SME - GBS | = | |
| 20.) | SME - NMT | = | |
| 21.) | SME - NSLC-A | = | |
| 22.) | SME - SATCOM IA | = | |
| 23.) | SME - WSC-6 | = | |
| 24.) | Subject Matter Expert (SME) 1 | = | |
| 25.) | Subject Matter Expert (SME) 2 | = | |
| 26.) | Subject Matter Expert (SME) 3 | = | |
| 27.) | Subject Matter Expert (SME) 4 | = | |
| 28.) | Subject Matter Expert (SME) 5 | = | |
| 29.) | Technical Writer/Editor 1 | = | |
| 30.) | Technical Writer/Editor 2 | = | |
| SCLS CATEGORY | OFFEROR'S LABOR CATEGORY | ||
| 1.) | Administrative Assistant (01020) | = | |
| 2.) | Computer Programmer II (14072) | = | |
| 3.) | Computer Programmer III (14073) | = | |
| 4.) | Computer Programmer IV (14074) | = | |
| 5.) | Computer Systems Analyst II (14102) | = | |
| 6.) | Computer Systems Analyst III (14103) | = | |
| 7.) | Drafter/CAD Operator III (30063) | = | |
| 8.) | Drafter/CAD Operator IV (30064) | = | |
| 9.) | Electronics Technician Maintenance I (23181) | = | |
| 10.) | Electronics Technician Maintenance II (23182) | = | |
| 11.) | Electronics Technician Maintenance III (23183) | = | |
| 12.) | Engineering Technician I (30081) | = | |
| 13.) | Engineering Technician II (30082) | = | |
| 14.) | Engineering Technician III (30083) | = | |
| 15.) | Engineering Technician IV (30084) | = | |
| 16.) | Engineering Technician V (30085) | = | |
| 17.) | Engineering Technician VI (30086) | = | |
| 18.) | Personal Computer Support Technician (14160) | = | |
| 19.) | Supply Technician (01410) | = | |
| 20.) | System Support Specialist (14170) | = | |
| 21.) | Technical Instructor/Course Developer (15095) | = | |
| 22.) | Warehouse Specialist (21410) | = | |
| UNCOMPENSATED OT POLICY |
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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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(K66*VLOOKUP($F66,FRINGE,2,FALSE),0) | =IFERROR(SUM(K66,L66)*VLOOKUP($G66,OH,2,FALSE),0) | =SUM(K66,L66,M66)*GA_1 | =IFERROR(K66*VLOOKUP($F66,FRINGE,2,FALSE),0) | =IFERROR(SUM(K66,L66)*VLOOKUP($G66,OH,2,FALSE),0) | =SUM(K66,L66,M66)*GA_PRIME_LABOR_1 |
| =IFERROR(K67*VLOOKUP($F67,FRINGE,2,FALSE),0) | =IFERROR(SUM(K67,L67)*VLOOKUP($G67,OH,2,FALSE),0) | =SUM(K67,L67,M67)*GA_1 | =IFERROR(K67*VLOOKUP($F67,FRINGE,2,FALSE),0) | =IFERROR(SUM(K67,L67)*VLOOKUP($G67,OH,2,FALSE),0) | =SUM(K67,L67,M67)*GA_PRIME_LABOR_1 |
| =IFERROR(K68*VLOOKUP($F68,FRINGE,2,FALSE),0) | =IFERROR(SUM(K68,L68)*VLOOKUP($G68,OH,2,FALSE),0) | =SUM(K68,L68,M68)*GA_1 | =IFERROR(K68*VLOOKUP($F68,FRINGE,2,FALSE),0) | =IFERROR(SUM(K68,L68)*VLOOKUP($G68,OH,2,FALSE),0) | =SUM(K68,L68,M68)*GA_PRIME_LABOR_1 |
| =IFERROR(K69*VLOOKUP($F69,FRINGE,2,FALSE),0) | =IFERROR(SUM(K69,L69)*VLOOKUP($G69,OH,2,FALSE),0) | =SUM(K69,L69,M69)*GA_1 | =IFERROR(K69*VLOOKUP($F69,FRINGE,2,FALSE),0) | =IFERROR(SUM(K69,L69)*VLOOKUP($G69,OH,2,FALSE),0) | =SUM(K69,L69,M69)*GA_PRIME_LABOR_1 |
| =IFERROR(K70*VLOOKUP($F70,FRINGE,2,FALSE),0) | =IFERROR(SUM(K70,L70)*VLOOKUP($G70,OH,2,FALSE),0) | =SUM(K70,L70,M70)*GA_1 | =IFERROR(K70*VLOOKUP($F70,FRINGE,2,FALSE),0) | =IFERROR(SUM(K70,L70)*VLOOKUP($G70,OH,2,FALSE),0) | =SUM(K70,L70,M70)*GA_PRIME_LABOR_1 |
| =IFERROR(K71*VLOOKUP($F71,FRINGE,2,FALSE),0) | =IFERROR(SUM(K71,L71)*VLOOKUP($G71,OH,2,FALSE),0) | =SUM(K71,L71,M71)*GA_1 | =IFERROR(K71*VLOOKUP($F71,FRINGE,2,FALSE),0) | =IFERROR(SUM(K71,L71)*VLOOKUP($G71,OH,2,FALSE),0) | =SUM(K71,L71,M71)*GA_PRIME_LABOR_1 |
| =IFERROR(K72*VLOOKUP($F72,FRINGE,2,FALSE),0) | =IFERROR(SUM(K72,L72)*VLOOKUP($G72,OH,2,FALSE),0) | =SUM(K72,L72,M72)*GA_1 | =IFERROR(K72*VLOOKUP($F72,FRINGE,2,FALSE),0) | =IFERROR(SUM(K72,L72)*VLOOKUP($G72,OH,2,FALSE),0) | =SUM(K72,L72,M72)*GA_PRIME_LABOR_1 |
| =IFERROR(K73*VLOOKUP($F73,FRINGE,2,FALSE),0) | =IFERROR(SUM(K73,L73)*VLOOKUP($G73,OH,2,FALSE),0) | =SUM(K73,L73,M73)*GA_1 | =IFERROR(K73*VLOOKUP($F73,FRINGE,2,FALSE),0) | =IFERROR(SUM(K73,L73)*VLOOKUP($G73,OH,2,FALSE),0) | =SUM(K73,L73,M73)*GA_PRIME_LABOR_1 |
| =IFERROR(K74*VLOOKUP($F74,FRINGE,2,FALSE),0) | =IFERROR(SUM(K74,L74)*VLOOKUP($G74,OH,2,FALSE),0) | =SUM(K74,L74,M74)*GA_1 | =IFERROR(K74*VLOOKUP($F74,FRINGE,2,FALSE),0) | =IFERROR(SUM(K74,L74)*VLOOKUP($G74,OH,2,FALSE),0) | =SUM(K74,L74,M74)*GA_PRIME_LABOR_1 |
| =IFERROR(K75*VLOOKUP($F75,FRINGE,2,FALSE),0) | =IFERROR(SUM(K75,L75)*VLOOKUP($G75,OH,2,FALSE),0) | =SUM(K75,L75,M75)*GA_1 | =IFERROR(K75*VLOOKUP($F75,FRINGE,2,FALSE),0) | =IFERROR(SUM(K75,L75)*VLOOKUP($G75,OH,2,FALSE),0) | =SUM(K75,L75,M75)*GA_PRIME_LABOR_1 |
| =IFERROR(K76*VLOOKUP($F76,FRINGE,2,FALSE),0) | =IFERROR(SUM(K76,L76)*VLOOKUP($G76,OH,2,FALSE),0) | =SUM(K76,L76,M76)*GA_1 | =IFERROR(K76*VLOOKUP($F76,FRINGE,2,FALSE),0) | =IFERROR(SUM(K76,L76)*VLOOKUP($G76,OH,2,FALSE),0) | =SUM(K76,L76,M76)*GA_PRIME_LABOR_1 |
| =IFERROR(K77*VLOOKUP($F77,FRINGE,2,FALSE),0) | =IFERROR(SUM(K77,L77)*VLOOKUP($G77,OH,2,FALSE),0) | =SUM(K77,L77,M77)*GA_1 | =IFERROR(K77*VLOOKUP($F77,FRINGE,2,FALSE),0) | =IFERROR(SUM(K77,L77)*VLOOKUP($G77,OH,2,FALSE),0) | =SUM(K77,L77,M77)*GA_PRIME_LABOR_1 |
| =IFERROR(K78*VLOOKUP($F78,FRINGE,2,FALSE),0) | =IFERROR(SUM(K78,L78)*VLOOKUP($G78,OH,2,FALSE),0) | =SUM(K78,L78,M78)*GA_1 | =IFERROR(K78*VLOOKUP($F78,FRINGE,2,FALSE),0) | =IFERROR(SUM(K78,L78)*VLOOKUP($G78,OH,2,FALSE),0) | =SUM(K78,L78,M78)*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 .