RFP Attachment 4 - Prime Pricing Model.xlsx
XLSX spreadsheet 185 KB Posted
- Solicitation number
- N65236-17-R-0002
View the file
Other files
Show all 19
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: | N65236-17-R-0002 | ||
| PR NUMBER: | N65236-17-R-0002 | ||
| TITLE: | 8(a) Incubator | ||
| PRICIING MODEL VERSION: | 1.0 | ||
| CONTRACT SPECIALIST: | Alan Bates | (843) 218-5108 | alan.bates@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.) 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
| 6.) | Populate labor rates on RATES worksheet (column K). |
| 7.) | If offeror's labor category job titles are different from those in the solicitation, document on the OTHER LABOR DATA sheet. |
| 8.) | 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. |
| 9.) | 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
| ESCALATION | BASE | OPTION | |
| 1 | OPTION | ||
| 2 | OPTION | ||
| 3 | OPTION |
| ESCALATION - PROFESSIONAL | 0.00% | 0.00% | 0.00% | 0.00% | Direct Labor |
| ESCALATION - SCLS | 0.00% | 0.00% | 0.00% | 0.00% | Direct Labor |
| 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 and OTHER BURDENS | BASE | 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 Prime ODCs | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Prime ODCs |
| FEE | |
| FEE on LABOR and ODCs | 0.00% |
CONTRACTOR CHANGES TO THE PRICING MODEL AND PROPOSAL EXPLANATIONS
SUMMARY
| Contract Number: | N65236-17-R-0002 |
| RFP Number: | N65236-17-R-0002 |
| Task Name: | 8(a) Incubator |
| Contractor Name: | |
| Contractor Proposal #: | |
| Proposal Date: | |
| Valid until: |
| LABOR | 0001 |
| PRIME CONTRACTOR LABOR COSTS | |
| PRIME LABOR HRs: | 152,121.0 |
| PRIME UNBURDENED LABOR COST | $ - 0 |
| PRIME FRINGE LABOR COST | $ - 0 |
| PRIME OH LABOR COST | $ - 0 |
| PRIME G&A LABOR COST | $ - 0 |
| SUBTOTAL PRIME LABOR: | $ - 0 |
| FEE PRIME LABOR: | $ - 0 |
| TOTAL PRIME LABOR + FEE: | $ - 0 |
| OTHER DIRECT COSTS | 0001 |
| PRIME CONTRACTOR ODC COSTS | |
| - MATERIAL: | $ 36,000.00 |
| - TRAVEL: | $ 225,000.00 |
| - MISCELLANEOUS ODCs: | $ 36,000.00 |
| - Additional ODC - (if applicable): | $ - 0 |
| SUBTOTAL PRIME ODCs: | $ 297,000.00 |
| PRIME G&A on PRIME ODCs: | $ - 0 |
| TOTAL PRIME ODCs (including G&A): | $ 297,000.00 |
| FEE on ODCs: | $ - 0 |
| TOTAL ODCs + FEE: | $ - 0 |
| TOTAL | 0001 |
| GRAND TOTAL COST (LABOR + ODCs): | $ 297,000.00 |
| GRAND TOTAL FEE: | $ - 0 |
| FCCM (if applicable): | $ - 0 |
| GRAND TOTAL: | $ 297,000.00 |
&"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
RATES
BASE
| 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 | Aeronautical Information Specialist | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 2.) | Professional | Airfield Operations Specialist | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 3.) | Professional | Engineer/Scientist 1 | Charleston, SC | Contractor | 2,162 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 4.) | Professional | Engineer/Scientist 2 | Charleston, SC | Contractor | 3,271 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 5.) | Professional | Engineer/Scientist 3 | Charleston, SC | Contractor | 3,271 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 6.) | Professional | Engineer/Scientist 4 | Charleston, SC | Contractor | 4,380 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 7.) | Professional | Engineer/Scientist 5 | Charleston, SC | Contractor | 4,380 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 8.) | Professional | Flight Procedures Specialist 1 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 9.) | Professional | Flight Procedures Specialist 2 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 10.) | Professional | Flight Procedures Specialist 3 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 11.) | Professional | Intelligence Specialist | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 12.) | Professional | Engineer/Scientist Intern | Charleston, SC | Contractor | 2,162 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 13.) | Professional | Logistician Intern | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 14.) | Professional | Management Analyst Intern | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 15.) | Professional | Logistician 1 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 16.) | Professional | Logistician 2 | Charleston, SC | Contractor | 2,162 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 17.) | Professional | Logistician 3 | Charleston, SC | Contractor | 3,271 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 18.) | Professional | Logistician 4 | Charleston, SC | Contractor | 3,271 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 19.) | Professional | Logistician 5 | Charleston, SC | Contractor | 3,271 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 20.) | Professional | Management Analyst 1 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 21.) | Professional | Management Analyst 2 | Charleston, SC | Contractor | 3,271 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 22.) | Professional | Management Analyst 3 | Charleston, SC | Contractor | 3,271 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 23.) | Professional | Management and Program Specialist 1 | Charleston, SC | Contractor | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 24.) | Professional | Management and Program Specialist 2 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 25.) | Professional | Management and Program Specialist 3 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 26.) | Professional | Management Consultant | Charleston, SC | Contractor | 2,162 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 27.) | Professional | Management Consultant (Senior) | Charleston, SC | Contractor | 3,271 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 28.) | Professional | Operations Specialist | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 29.) | Professional | Operations Specialist (Senior) | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 30.) | Professional | Program Manager | Charleston, SC | Contractor | 1,920 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 31.) | Professional | Project Manager | Charleston, SC | Contractor | 2,914 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 32.) | Professional | Safety Specialist 1 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 33.) | Professional | Safety Specialist 2 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 34.) | Professional | Safety Specialist 3 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 35.) | Professional | Safety Specialist 4 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 36.) | Professional | Security Specialist 1 | Charleston, SC | Contractor | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 37.) | Professional | Security Specialist 2 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 38.) | Professional | Security Specialist 3 | Charleston, SC | Contractor | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 39.) | Professional | Security Specialist 4 | Charleston, SC | Contractor | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 40.) | Professional | Subject Matter Expert (SME) 1 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 41.) | Professional | Subject Matter Expert (SME) 2 | Charleston, SC | Contractor | 2,162 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 42.) | Professional | Subject Matter Expert (SME) 3 | Charleston, SC | Contractor | 3,271 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 43.) | Professional | Subject Matter Expert (SME) 4 | Charleston, SC | Contractor | 3,271 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 44.) | Professional | Subject Matter Expert (SME) 5 | Charleston, SC | Contractor | 2,162 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 45.) | Professional | Technical Analyst 1 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 46.) | Professional | Technical Analyst 2 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 47.) | Professional | Technical Analyst 3 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 48.) | Professional | Technical Analyst 4 | Charleston, SC | Contractor | 2,162 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 49.) | Professional | Technical Writer/Editor 1 | Charleston, SC | Contractor | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 50.) | Professional | Technical Writer/Editor 2 | Charleston, SC | Contractor | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 51.) | Professional | Technical Writer/Editor 3 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 52.) | Professional | Technical Writer/Editor 4 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 53.) | Professional | Training Specialist 1 | Charleston, SC | Contractor | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 54.) | Professional | Training Specialist 2 | Charleston, SC | Contractor | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 55.) | Professional | Training Specialist 3 | Charleston, SC | Contractor | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 56.) | Professional | Training Specialist 4 | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 57.) | Professional | Weather Forecaster | Charleston, SC | Contractor | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 58.) | Professional | Aeronautical Information Specialist | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 59.) | Professional | Airfield Operations Specialist | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 60.) | Professional | Engineer/Scientist 1 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 61.) | Professional | Engineer/Scientist 2 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 62.) | Professional | Engineer/Scientist 3 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 63.) | Professional | Engineer/Scientist 4 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 64.) | Professional | Engineer/Scientist 5 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 65.) | Professional | Flight Procedures Specialist 1 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 66.) | Professional | Flight Procedures Specialist 2 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 67.) | Professional | Flight Procedures Specialist 3 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 68.) | Professional | Intelligence Specialist | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 69.) | Professional | Engineer/Scientist Intern | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 70.) | Professional | Logistician Intern | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 71.) | Professional | Management Analyst Intern | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 72.) | Professional | Logistician 1 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 73.) | Professional | Logistician 2 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 74.) | Professional | Logistician 3 | Charleston, SC | Government | 2,162 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 75.) | Professional | Logistician 4 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 76.) | Professional | Logistician 5 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 77.) | Professional | Management Analyst 1 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 78.) | Professional | Management Analyst 2 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 79.) | Professional | Management Analyst 3 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 80.) | Professional | Management and Program Specialist 1 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 81.) | Professional | Management and Program Specialist 2 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 82.) | Professional | Management and Program Specialist 3 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 83.) | Professional | Management Consultant | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 84.) | Professional | Management Consultant (Senior) | Charleston, SC | Government | 2,162 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 85.) | Professional | Operations Specialist | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 86.) | Professional | Operations Specialist (Senior) | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 87.) | Professional | Program Manager | Charleston, SC | Government | 1,920 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 88.) | Professional | Project Manager | Charleston, SC | Government | 2,162 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 89.) | Professional | Safety Specialist 1 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 90.) | Professional | Safety Specialist 2 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 91.) | Professional | Safety Specialist 3 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 92.) | Professional | Safety Specialist 4 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 93.) | Professional | Security Specialist 1 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 94.) | Professional | Security Specialist 2 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 95.) | Professional | Security Specialist 3 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 96.) | Professional | Security Specialist 4 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 97.) | Professional | Subject Matter Expert (SME) 1 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 98.) | Professional | Subject Matter Expert (SME) 2 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 99.) | Professional | Subject Matter Expert (SME) 3 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 100.) | Professional | Subject Matter Expert (SME) 4 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 101.) | Professional | Subject Matter Expert (SME) 5 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 102.) | Professional | Technical Analyst 1 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 103.) | Professional | Technical Analyst 2 | Charleston, SC | Government | 2,162 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 104.) | Professional | Technical Analyst 3 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 105.) | Professional | Technical Analyst 4 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 106.) | Professional | Technical Writer/Editor 1 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 107.) | Professional | Technical Writer/Editor 2 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 108.) | Professional | Technical Writer/Editor 3 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 109.) | Professional | Technical Writer/Editor 4 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 110.) | Professional | Training Specialist 1 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 111.) | Professional | Training Specialist 2 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 112.) | Professional | Training Specialist 3 | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 113.) | Professional | Training Specialist 4 | Charleston, SC | Government | 545 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 114.) | Professional | Weather Forecaster | Charleston, SC | Government | 1,090 | - | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 152,121 | $ - 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 | LABOR RATE | ||
| (1) | ADJUSTED HOURLY RATE | |||
| (2) | EFFECTIVE HRs |
(3)
| 1.) | Aeronautical Information Specialist | = |
| 2.) | Airfield Operations Specialist | = |
| 3.) | Engineer/Scientist 1 | = |
| 4.) | Engineer/Scientist 2 | = |
| 5.) | Engineer/Scientist 3 | = |
| 6.) | Engineer/Scientist 4 | = |
| 7.) | Engineer/Scientist 5 | = |
| 8.) | Flight Procedures Specialist 1 | = |
| 9.) | Flight Procedures Specialist 2 | = |
| 10.) | Flight Procedures Specialist 3 | = |
| 11.) | Intelligence Specialist | = |
| 12.) | Engineer/Scientist Intern | = |
| 13.) | Logistician Intern | = |
| 14.) | Management Analyst Intern | = |
| 15.) | Logistician 1 | = |
| 16.) | Logistician 2 | = |
| 17.) | Logistician 3 | = |
| 18.) | Logistician 4 | = |
| 19.) | Logistician 5 | = |
| 20.) | Management Analyst 1 | = |
| 21.) | Management Analyst 2 | = |
| 22.) | Management Analyst 3 | = |
| 23.) | Management and Program Specialist 1 | = |
| 24.) | Management and Program Specialist 2 | = |
| 25.) | Management and Program Specialist 3 | = |
| 26.) | Management Consultant | = |
| 27.) | Management Consultant (Senior) | = |
| 28.) | Operations Specialist | = |
| 29.) | Operations Specialist (Senior) | = |
| 30.) | Program Manager | = |
| 31.) | Project Manager | = |
| 32.) | Safety Specialist 1 | = |
| 33.) | Safety Specialist 2 | = |
| 34.) | Safety Specialist 3 | = |
| 35.) | Safety Specialist 4 | = |
| 36.) | Security Specialist 1 | = |
| 37.) | Security Specialist 2 | = |
| 38.) | Security Specialist 3 | = |
| 39.) | Security Specialist 4 | = |
| 40.) | Subject Matter Expert (SME) 1 | = |
| 41.) | Subject Matter Expert (SME) 2 | = |
| 42.) | Subject Matter Expert (SME) 3 | = |
| 43.) | Subject Matter Expert (SME) 4 | = |
| 44.) | Subject Matter Expert (SME) 5 | = |
| 45.) | Technical Analyst 1 | = |
| 46.) | Technical Analyst 2 | = |
| 47.) | Technical Analyst 3 | = |
| 48.) | Technical Analyst 4 | = |
| 49.) | Technical Writer/Editor 1 | = |
| 50.) | Technical Writer/Editor 2 | = |
| 51.) | Technical Writer/Editor 3 | = |
| 52.) | Technical Writer/Editor 4 | = |
| 53.) | Training Specialist 1 | = |
| 54.) | Training Specialist 2 | = |
| 55.) | Training Specialist 3 | = |
| 56.) | Training Specialist 4 | = |
| 57.) | Weather Forecaster | = |
| 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_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 |
| =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(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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_PRIME_LABOR_1 |
| =IFERROR(K79*VLOOKUP($F79,FRINGE,2,FALSE),0) | =IFERROR(SUM(K79,L79)*VLOOKUP($G79,OH,2,FALSE),0) | =SUM(K79,L79,M79)*GA_PRIME_LABOR_1 | =IFERROR(K79*VLOOKUP($F79,FRINGE,2,FALSE),0) | =IFERROR(SUM(K79,L79)*VLOOKUP($G79,OH,2,FALSE),0) | =SUM(K79,L79,M79)*GA_PRIME_LABOR_1 |
| =IFERROR(K80*VLOOKUP($F80,FRINGE,2,FALSE),0) | =IFERROR(SUM(K80,L80)*VLOOKUP($G80,OH,2,FALSE),0) | =SUM(K80,L80,M80)*GA_PRIME_LABOR_1 | =IFERROR(K80*VLOOKUP($F80,FRINGE,2,FALSE),0) | =IFERROR(SUM(K80,L80)*VLOOKUP($G80,OH,2,FALSE),0) | =SUM(K80,L80,M80)*GA_PRIME_LABOR_1 |
| =IFERROR(K81*VLOOKUP($F81,FRINGE,2,FALSE),0) | =IFERROR(SUM(K81,L81)*VLOOKUP($G81,OH,2,FALSE),0) | =SUM(K81,L81,M81)*GA_PRIME_LABOR_1 | =IFERROR(K81*VLOOKUP($F81,FRINGE,2,FALSE),0) | =IFERROR(SUM(K81,L81)*VLOOKUP($G81,OH,2,FALSE),0) | =SUM(K81,L81,M81)*GA_PRIME_LABOR_1 |
| =IFERROR(K82*VLOOKUP($F82,FRINGE,2,FALSE),0) | =IFERROR(SUM(K82,L82)*VLOOKUP($G82,OH,2,FALSE),0) | =SUM(K82,L82,M82)*GA_PRIME_LABOR_1 | =IFERROR(K82*VLOOKUP($F82,FRINGE,2,FALSE),0) | =IFERROR(SUM(K82,L82)*VLOOKUP($G82,OH,2,FALSE),0) | =SUM(K82,L82,M82)*GA_PRIME_LABOR_1 |
| =IFERROR(K83*VLOOKUP($F83,FRINGE,2,FALSE),0) | =IFERROR(SUM(K83,L83)*VLOOKUP($G83,OH,2,FALSE),0) | =SUM(K83,L83,M83)*GA_PRIME_LABOR_1 | =IFERROR(K83*VLOOKUP($F83,FRINGE,2,FALSE),0) | =IFERROR(SUM(K83,L83)*VLOOKUP($G83,OH,2,FALSE),0) | =SUM(K83,L83,M83)*GA_PRIME_LABOR_1 |
| =IFERROR(K84*VLOOKUP($F84,FRINGE,2,FALSE),0) | =IFERROR(SUM(K84,L84)*VLOOKUP($G84,OH,2,FALSE),0) | =SUM(K84,L84,M84)*GA_PRIME_LABOR_1 | =IFERROR(K84*VLOOKUP($F84,FRINGE,2,FALSE),0) | =IFERROR(SUM(K84,L84)*VLOOKUP($G84,OH,2,FALSE),0) | =SUM(K84,L84,M84)*GA_PRIME_LABOR_1 |
| =IFERROR(K85*VLOOKUP($F85,FRINGE,2,FALSE),0) | =IFERROR(SUM(K85,L85)*VLOOKUP($G85,OH,2,FALSE),0) | =SUM(K85,L85,M85)*GA_PRIME_LABOR_1 | =IFERROR(K85*VLOOKUP($F85,FRINGE,2,FALSE),0) | =IFERROR(SUM(K85,L85)*VLOOKUP($G85,OH,2,FALSE),0) | =SUM(K85,L85,M85)*GA_PRIME_LABOR_1 |
| =IFERROR(K86*VLOOKUP($F86,FRINGE,2,FALSE),0) | =IFERROR(SUM(K86,L86)*VLOOKUP($G86,OH,2,FALSE),0) | =SUM(K86,L86,M86)*GA_PRIME_LABOR_1 | =IFERROR(K86*VLOOKUP($F86,FRINGE,2,FALSE),0) | =IFERROR(SUM(K86,L86)*VLOOKUP($G86,OH,2,FALSE),0) | =SUM(K86,L86,M86)*GA_PRIME_LABOR_1 |
| =IFERROR(K87*VLOOKUP($F87,FRINGE,2,FALSE),0) | =IFERROR(SUM(K87,L87)*VLOOKUP($G87,OH,2,FALSE),0) | =SUM(K87,L87,M87)*GA_PRIME_LABOR_1 | =IFERROR(K87*VLOOKUP($F87,FRINGE,2,FALSE),0) | =IFERROR(SUM(K87,L87)*VLOOKUP($G87,OH,2,FALSE),0) | =SUM(K87,L87,M87)*GA_PRIME_LABOR_1 |
| =IFERROR(K88*VLOOKUP($F88,FRINGE,2,FALSE),0) | =IFERROR(SUM(K88,L88)*VLOOKUP($G88,OH,2,FALSE),0) | =SUM(K88,L88,M88)*GA_PRIME_LABOR_1 | =IFERROR(K88*VLOOKUP($F88,FRINGE,2,FALSE),0) | =IFERROR(SUM(K88,L88)*VLOOKUP($G88,OH,2,FALSE),0) | =SUM(K88,L88,M88)*GA_PRIME_LABOR_1 |
| =IFERROR(K89*VLOOKUP($F89,FRINGE,2,FALSE),0) | =IFERROR(SUM(K89,L89)*VLOOKUP($G89,OH,2,FALSE),0) | =SUM(K89,L89,M89)*GA_PRIME_LABOR_1 | =IFERROR(K89*VLOOKUP($F89,FRINGE,2,FALSE),0) | =IFERROR(SUM(K89,L89)*VLOOKUP($G89,OH,2,FALSE),0) | =SUM(K89,L89,M89)*GA_PRIME_LABOR_1 |
| =IFERROR(K90*VLOOKUP($F90,FRINGE,2,FALSE),0) | =IFERROR(SUM(K90,L90)*VLOOKUP($G90,OH,2,FALSE),0) | =SUM(K90,L90,M90)*GA_PRIME_LABOR_1 | =IFERROR(K90*VLOOKUP($F90,FRINGE,2,FALSE),0) | =IFERROR(SUM(K90,L90)*VLOOKUP($G90,OH,2,FALSE),0) | =SUM(K90,L90,M90)*GA_PRIME_LABOR_1 |
| =IFERROR(K91*VLOOKUP($F91,FRINGE,2,FALSE),0) | =IFERROR(SUM(K91,L91)*VLOOKUP($G91,OH,2,FALSE),0) | =SUM(K91,L91,M91)*GA_PRIME_LABOR_1 | =IFERROR(K91*VLOOKUP($F91,FRINGE,2,FALSE),0) | =IFERROR(SUM(K91,L91)*VLOOKUP($G91,OH,2,FALSE),0) | =SUM(K91,L91,M91)*GA_PRIME_LABOR_1 |
| =IFERROR(K92*VLOOKUP($F92,FRINGE,2,FALSE),0) | =IFERROR(SUM(K92,L92)*VLOOKUP($G92,OH,2,FALSE),0) | =SUM(K92,L92,M92)*GA_PRIME_LABOR_1 | =IFERROR(K92*VLOOKUP($F92,FRINGE,2,FALSE),0) | =IFERROR(SUM(K92,L92)*VLOOKUP($G92,OH,2,FALSE),0) | =SUM(K92,L92,M92)*GA_PRIME_LABOR_1 |
| =IFERROR(K93*VLOOKUP($F93,FRINGE,2,FALSE),0) | =IFERROR(SUM(K93,L93)*VLOOKUP($G93,OH,2,FALSE),0) | =SUM(K93,L93,M93)*GA_PRIME_LABOR_1 | =IFERROR(K93*VLOOKUP($F93,FRINGE,2,FALSE),0) | =IFERROR(SUM(K93,L93)*VLOOKUP($G93,OH,2,FALSE),0) | =SUM(K93,L93,M93)*GA_PRIME_LABOR_1 |
| =IFERROR(K94*VLOOKUP($F94,FRINGE,2,FALSE),0) | =IFERROR(SUM(K94,L94)*VLOOKUP($G94,OH,2,FALSE),0) | =SUM(K94,L94,M94)*GA_PRIME_LABOR_1 | =IFERROR(K94*VLOOKUP($F94,FRINGE,2,FALSE),0) | =IFERROR(SUM(K94,L94)*VLOOKUP($G94,OH,2,FALSE),0) | =SUM(K94,L94,M94)*GA_PRIME_LABOR_1 |
| =IFERROR(K95*VLOOKUP($F95,FRINGE,2,FALSE),0) | =IFERROR(SUM(K95,L95)*VLOOKUP($G95,OH,2,FALSE),0) | =SUM(K95,L95,M95)*GA_PRIME_LABOR_1 | =IFERROR(K95*VLOOKUP($F95,FRINGE,2,FALSE),0) | =IFERROR(SUM(K95,L95)*VLOOKUP($G95,OH,2,FALSE),0) | =SUM(K95,L95,M95)*GA_PRIME_LABOR_1 |
| =IFERROR(K96*VLOOKUP($F96,FRINGE,2,FALSE),0) | =IFERROR(SUM(K96,L96)*VLOOKUP($G96,OH,2,FALSE),0) | =SUM(K96,L96,M96)*GA_PRIME_LABOR_1 | =IFERROR(K96*VLOOKUP($F96,FRINGE,2,FALSE),0) | =IFERROR(SUM(K96,L96)*VLOOKUP($G96,OH,2,FALSE),0) | =SUM(K96,L96,M96)*GA_PRIME_LABOR_1 |
| =IFERROR(K97*VLOOKUP($F97,FRINGE,2,FALSE),0) | =IFERROR(SUM(K97,L97)*VLOOKUP($G97,OH,2,FALSE),0) | =SUM(K97,L97,M97)*GA_PRIME_LABOR_1 | =IFERROR(K97*VLOOKUP($F97,FRINGE,2,FALSE),0) | =IFERROR(SUM(K97,L97)*VLOOKUP($G97,OH,2,FALSE),0) | =SUM(K97,L97,M97)*GA_PRIME_LABOR_1 |
| =IFERROR(K98*VLOOKUP($F98,FRINGE,2,FALSE),0) | =IFERROR(SUM(K98,L98)*VLOOKUP($G98,OH,2,FALSE),0) | =SUM(K98,L98,M98)*GA_PRIME_LABOR_1 | =IFERROR(K98*VLOOKUP($F98,FRINGE,2,FALSE),0) | =IFERROR(SUM(K98,L98)*VLOOKUP($G98,OH,2,FALSE),0) | =SUM(K98,L98,M98)*GA_PRIME_LABOR_1 |
| =IFERROR(K99*VLOOKUP($F99,FRINGE,2,FALSE),0) | =IFERROR(SUM(K99,L99)*VLOOKUP($G99,OH,2,FALSE),0) | =SUM(K99,L99,M99)*GA_PRIME_LABOR_1 | =IFERROR(K99*VLOOKUP($F99,FRINGE,2,FALSE),0) | =IFERROR(SUM(K99,L99)*VLOOKUP($G99,OH,2,FALSE),0) | =SUM(K99,L99,M99)*GA_PRIME_LABOR_1 |
| =IFERROR(K100*VLOOKUP($F100,FRINGE,2,FALSE),0) | =IFERROR(SUM(K100,L100)*VLOOKUP($G100,OH,2,FALSE),0) | =SUM(K100,L100,M100)*GA_PRIME_LABOR_1 | =IFERROR(K100*VLOOKUP($F100,FRINGE,2,FALSE),0) | =IFERROR(SUM(K100,L100)*VLOOKUP($G100,OH,2,FALSE),0) | =SUM(K100,L100,M100)*GA_PRIME_LABOR_1 |
| =IFERROR(K101*VLOOKUP($F101,FRINGE,2,FALSE),0) | =IFERROR(SUM(K101,L101)*VLOOKUP($G101,OH,2,FALSE),0) | =SUM(K101,L101,M101)*GA_PRIME_LABOR_1 | =IFERROR(K101*VLOOKUP($F101,FRINGE,2,FALSE),0) | =IFERROR(SUM(K101,L101)*VLOOKUP($G101,OH,2,FALSE),0) | =SUM(K101,L101,M101)*GA_PRIME_LABOR_1 |
| =IFERROR(K102*VLOOKUP($F102,FRINGE,2,FALSE),0) | =IFERROR(SUM(K102,L102)*VLOOKUP($G102,OH,2,FALSE),0) | =SUM(K102,L102,M102)*GA_PRIME_LABOR_1 | =IFERROR(K102*VLOOKUP($F102,FRINGE,2,FALSE),0) | =IFERROR(SUM(K102,L102)*VLOOKUP($G102,OH,2,FALSE),0) | =SUM(K102,L102,M102)*GA_PRIME_LABOR_1 |
| =IFERROR(K103*VLOOKUP($F103,FRINGE,2,FALSE),0) | =IFERROR(SUM(K103,L103)*VLOOKUP($G103,OH,2,FALSE),0) | =SUM(K103,L103,M103)*GA_PRIME_LABOR_1 | =IFERROR(K103*VLOOKUP($F103,FRINGE,2,FALSE),0) | =IFERROR(SUM(K103,L103)*VLOOKUP($G103,OH,2,FALSE),0) | =SUM(K103,L103,M103)*GA_PRIME_LABOR_1 |
| =IFERROR(K104*VLOOKUP($F104,FRINGE,2,FALSE),0) | =IFERROR(SUM(K104,L104)*VLOOKUP($G104,OH,2,FALSE),0) | =SUM(K104,L104,M104)*GA_PRIME_LABOR_1 | =IFERROR(K104*VLOOKUP($F104,FRINGE,2,FALSE),0) | =IFERROR(SUM(K104,L104)*VLOOKUP($G104,OH,2,FALSE),0) | =SUM(K104,L104,M104)*GA_PRIME_LABOR_1 |
| ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K109*VLOOKUP($F109,FRINGE,2,FALSE),0) | =IFERROR(SUM(K109,L109)*VLOOKUP($G109,OH,2,FALSE),0) | =SUM(K109,L109,M109)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K110*VLOOKUP($F110,FRINGE,2,FALSE),0) | =IFERROR(SUM(K110,L110)*VLOOKUP($G110,OH,2,FALSE),0) | =SUM(K110,L110,M110)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K111*VLOOKUP($F111,FRINGE,2,FALSE),0) | =IFERROR(SUM(K111,L111)*VLOOKUP($G111,OH,2,FALSE),0) | =SUM(K111,L111,M111)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K112*VLOOKUP($F112,FRINGE,2,FALSE),0) | =IFERROR(SUM(K112,L112)*VLOOKUP($G112,OH,2,FALSE),0) | =SUM(K112,L112,M112)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K113*VLOOKUP($F113,FRINGE,2,FALSE),0) | =IFERROR(SUM(K113,L113)*VLOOKUP($G113,OH,2,FALSE),0) | =SUM(K113,L113,M113)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K114*VLOOKUP($F114,FRINGE,2,FALSE),0) | =IFERROR(SUM(K114,L114)*VLOOKUP($G114,OH,2,FALSE),0) | =SUM(K114,L114,M114)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K115*VLOOKUP($F115,FRINGE,2,FALSE),0) | =IFERROR(SUM(K115,L115)*VLOOKUP($G115,OH,2,FALSE),0) | =SUM(K115,L115,M115)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K116*VLOOKUP($F116,FRINGE,2,FALSE),0) | =IFERROR(SUM(K116,L116)*VLOOKUP($G116,OH,2,FALSE),0) | =SUM(K116,L116,M116)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K117*VLOOKUP($F117,FRINGE,2,FALSE),0) | =IFERROR(SUM(K117,L117)*VLOOKUP($G117,OH,2,FALSE),0) | =SUM(K117,L117,M117)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K118*VLOOKUP($F118,FRINGE,2,FALSE),0) | =IFERROR(SUM(K118,L118)*VLOOKUP($G118,OH,2,FALSE),0) | =SUM(K118,L118,M118)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K119*VLOOKUP($F119,FRINGE,2,FALSE),0) | =IFERROR(SUM(K119,L119)*VLOOKUP($G119,OH,2,FALSE),0) | =SUM(K119,L119,M119)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K120*VLOOKUP($F120,FRINGE,2,FALSE),0) | =IFERROR(SUM(K120,L120)*VLOOKUP($G120,OH,2,FALSE),0) | =SUM(K120,L120,M120)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K121*VLOOKUP($F121,FRINGE,2,FALSE),0) | =IFERROR(SUM(K121,L121)*VLOOKUP($G121,OH,2,FALSE),0) | =SUM(K121,L121,M121)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K122*VLOOKUP($F122,FRINGE,2,FALSE),0) | =IFERROR(SUM(K122,L122)*VLOOKUP($G122,OH,2,FALSE),0) | =SUM(K122,L122,M122)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K123*VLOOKUP($F123,FRINGE,2,FALSE),0) | =IFERROR(SUM(K123,L123)*VLOOKUP($G123,OH,2,FALSE),0) | =SUM(K123,L123,M123)*GA_PRIME_LABOR_1 |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | =IFERROR(K124*VLOOKUP($F124,FRINGE,2,FALSE),0) | =IFERROR(SUM(K124,L124)*VLOOKUP($G124,OH,2,FALSE),0) | =SUM(K124,L124,M124)*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.