EMS_Applied_Engineering_Support_-_Spectrum_-_Pricing_Spreadsheet_11242015.xlsx
XLSX spreadsheet 42 KB Posted
- Solicitation number
- HC1047-15-R-4012
- Issued by
-
Defense Information Systems Agency
About this file
Pricing Spreadsheet
View the file
Other files
Show all 23
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
| Offeror Name: | 0 |
| Evaluation Stage: | 0 |
| Government Excel Document Instructions for Offerors |
1. Fill in the Offeror's name in yellow box contained in the worksheet labeled "Base Period".
| 2. Fill in the appropriate stage of the evaluation in the orange box contained in the worksheet labeled "Base Period". A description of each anticipated evaluation stage is provided below. Please note that not all stages may be utilized in the evaluation process. | |
| Evaluation Stages | |
| INITIAL - | First Submission |
| INTERIM - | Submission in Response to different round of Items for Negotiations (IFNs) (i.e. Interim 1, Interim 2, Interim 3,ect…) |
| FINAL - | Submission of Final Proposal Revision (FPR) |
| 3. Fill in all cells highlighted in yellow on the following tabs within this workbook. |
| 4. Once all the information is entered in the yellow cells, the Summary worksheet will have all Evaluation Amounts totaled for validation. |
SUMMARY
| Offeror Name: | 0 |
| Evaluation Stage: | 0 |
| LCAT # | Government Labor Category | Offeror's Internal Labor Category | Contractor Site | Contractor Site | Government Site | Government Site |
| Labor Hours | Dollars | Labor Hours | Dollars | |||
| 1 | Engineer, Electronics | 0 | ||||
| 1a | Senior Level | 0 | 22,000 | $ - 0 | 11,000 | $ - 0 |
| 1b | Mid Level | 0 | 65,000 | $ - 0 | 32,500 | $ - 0 |
| 1c | Entry Level | 0 | 20,750 | $ - 0 | 9,750 | $ - 0 |
| 2 | Engineering Technician | 0 | ||||
| 2a | Senior Level | 0 | 21,000 | $ - 0 | 10,500 | $ - 0 |
| 2b | Mid Level | 0 | 20,600 | $ - 0 | 10,300 | $ - 0 |
| 2c | Entry Level | 0 | 19,900 | $ - 0 | 10,000 | $ - 0 |
| 3 | Spectrum Manager | 0 | ||||
| 3a | Senior Level | 0 | 36,600 | $ - 0 | 18,400 | $ - 0 |
| 3b | Mid Level | 0 | - 0 | $ - 0 | - 0 | $ - 0 |
| 3c | Entry Level | 0 | - 0 | $ - 0 | - 0 | $ - 0 |
| 4 | Telecommunications Specialist | 0 | ||||
| 4a | Mid Level | 0 | 21,250 | $ - 0 | 10,625 | $ - 0 |
| GRAND TOTAL LABOR | 227,100 | $ - 0 | 113,075 | $ - 0 | ||
| Travel | $ 84,073.56 | $ - 0 | ||||
| ODCs | $ 27,500.00 | $ - 0 | ||||
| GRAND TOTAL SUMMARY | 227,100 | $ 111,573.56 | 113,075 | $ - 0 |
| Hours | Dollars | |
| GRAND TOTAL | 340,175 | $ 111,573.56 |
Base Period
| Offeror Name: | |||||||||
| Evaluation Stage: | |||||||||
| LCAT # | Government Labor Category | Offeror's Internal Labor Category | Contractor Site | Contractor Site | Contractor Site | Government Site | Government Site | Government Site | |
| Loaded Labor Rate | Labor Hours | Dollars | Loaded Labor Rate | Labor Hours | Dollars | ||||
| 1 | Engineer, Electronics | ||||||||
| 1a | Senior Level | 5,500 | $ - 0 | 2,750 | $ - 0 | ||||
| 1b | Mid Level | 16,500 | $ - 0 | 8,250 | $ - 0 | ||||
| 1c | Entry Level | 4,100 | $ - 0 | 2,050 | $ - 0 |
| 2 | Engineering Technician | ||||
| 2a | Senior Level | 5,000 | $ - 0 | 2,500 | $ - 0 |
| 2b | Mid Level | 4,200 | $ - 0 | 2,100 | $ - 0 |
| 2c | Entry Level | 4,200 | $ - 0 | 2,100 | $ - 0 |
| 3 | Spectrum Manager | ||||
| 3a | Senior Level | 8,000 | $ - 0 | 4,000 | $ - 0 |
| 3b | Mid Level | - 0 | $ - 0 | - 0 | $ - 0 |
| 3c | Entry Level | - 0 | $ - 0 | - 0 | $ - 0 |
| 4 | Telecommunications Specialist | ||||
| 4a | Mid Level | 4,000 | $ - 0 | 2,000 | $ - 0 |
| TOTAL LABOR | 51,500 | $ - 0 | 25,750 | $ - 0 | |
| Travel | $ 17,850.17 | $ - 0 | |||
| ODCs | $ 5,000.00 | $ - 0 | |||
| TOTAL BASE PERIOD | 51,500 | $ 22,850.17 | 25,750 | $ - 0 |
| Hours | Dollars | |
| GRAND TOTAL BASE PERIOD | 77,250 | $ 22,850.17 |
Option Period 1
| Offeror Name: | 0 | ||||||||
| Evaluation Stage: | 0 | ||||||||
| LCAT # | Government Labor Category | Offeror's Internal Labor Category | Contractor Site | Contractor Site | Contractor Site | Government Site | Government Site | Government Site | |
| Loaded Labor Rate | Labor Hours | Dollars | Loaded Labor Rate | Labor Hours | Dollars | ||||
| 1 | Engineer, Electronics | 0 | |||||||
| 1a | Senior Level | 0 | 5,000 | $ - 0 | 2,500 | $ - 0 | |||
| 1b | Mid Level | 0 | 14,500 | $ - 0 | 7,250 | $ - 0 | |||
| 1c | Entry Level | 0 | 4,000 | $ - 0 | 2,000 | $ - 0 |
| 2 | Engineering Technician | 0 | ||||
| 2a | Senior Level | 0 | 4,500 | $ - 0 | 2,250 | $ - 0 |
| 2b | Mid Level | 0 | 4,000 | $ - 0 | 2,000 | $ - 0 |
| 2c | Entry Level | 0 | 4,000 | $ - 0 | 2,000 | $ - 0 |
| 3 | Spectrum Manager | 0 | ||||
| 3a | Senior Level | 0 | 8,000 | $ - 0 | 4,000 | $ - 0 |
| 3b | Mid Level | 0 | - 0 | $ - 0 | - 0 | $ - 0 |
| 3c | Entry Level | 0 | - 0 | $ - 0 | - 0 | $ - 0 |
| 4 | Telecommunications Specialist | 0 | ||||
| 4a | Mid Level | 0 | 4,000 | $ - 0 | 2,000 | $ - 0 |
| TOTAL LABOR | 48,000 | $ - 0 | 24,000 | $ - 0 | ||
| Travel | $ 18,357.53 | $ - 0 | ||||
| ODCs | $ 5,000.00 | $ - 0 | ||||
| TOTAL BASE PERIOD | 48,000 | $ 23,357.53 | 24,000 | $ - 0 |
| Hours | Dollars | |
| GRAND TOTAL OPTION PERIOD 1 | 72,000 | $ 23,357.53 |
Option Period 2
| Offeror Name: | 0 | ||||||||
| Evaluation Stage: | 0 | ||||||||
| LCAT # | Government Labor Category | Offeror's Internal Labor Category | Contractor Site | Contractor Site | Contractor Site | Government Site | Government Site | Government Site | |
| Loaded Labor Rate | Labor Hours | Dollars | Loaded Labor Rate | Labor Hours | Dollars | ||||
| 1 | Engineer, Electronics | 0 | |||||||
| 1a | Senior Level | 0 | 4,000 | $ - 0 | 2,000 | $ - 0 | |||
| 1b | Mid Level | 0 | 12,000 | $ - 0 | 6,000 | $ - 0 | |||
| 1c | Entry Level | 0 | 3,900 | $ - 0 | 1,950 | $ - 0 |
| 2 | Engineering Technician | 0 | ||||
| 2a | Senior Level | 0 | 4,000 | $ - 0 | 2,000 | $ - 0 |
| 2b | Mid Level | 0 | 3,800 | $ - 0 | 1,900 | $ - 0 |
| 2c | Entry Level | 0 | 3,800 | $ - 0 | 1,900 | $ - 0 |
| 3 | Spectrum Manager | 0 | ||||
| 3a | Senior Level | 0 | 7,800 | $ - 0 | 3,900 | $ - 0 |
| 3b | Mid Level | 0 | - 0 | $ - 0 | - 0 | $ - 0 |
| 3c | Entry Level | 0 | - 0 | $ - 0 | - 0 | $ - 0 |
| 4 | Telecommunications Specialist | 0 | ||||
| 4a | Mid Level | 0 | 4,000 | $ - 0 | 2,000 | $ - 0 |
| TOTAL LABOR | 43,300 | $ - 0 | 21,650 | $ - 0 | ||
| Travel | $ 16,068.70 | $ - 0 | ||||
| ODCs | $ 5,000.00 | $ - 0 | ||||
| TOTAL BASE PERIOD | 43,300 | $ 21,068.70 | 21,650 | $ - 0 |
| Hours | Dollars | |
| GRAND TOTAL OPTION PERIOD 2 | 64,950 | $ 21,068.70 |
Option Period 3
| Offeror Name: | 0 | ||||||||
| Evaluation Stage: | 0 | ||||||||
| LCAT # | Government Labor Category | Offeror's Internal Labor Category | Contractor Site | Contractor Site | Contractor Site | Government Site | Government Site | Government Site | |
| Loaded Labor Rate | Labor Hours | Dollars | Loaded Labor Rate | Labor Hours | Dollars | ||||
| 1 | Engineer, Electronics | 0 | |||||||
| 1a | Senior Level | 0 | 3,000 | $ - 0 | 1,500 | $ - 0 | |||
| 1b | Mid Level | 0 | 10,000 | $ - 0 | 5,000 | $ - 0 | |||
| 1c | Entry Level | 0 | 3,500 | $ - 0 | 1,500 | $ - 0 |
| 2 | Engineering Technician | 0 | ||||
| 2a | Senior Level | 0 | 3,000 | $ - 0 | 1,500 | $ - 0 |
| 2b | Mid Level | 0 | 3,500 | $ - 0 | 1,750 | $ - 0 |
| 2c | Entry Level | 0 | 3,400 | $ - 0 | 1,750 | $ - 0 |
| 3 | Spectrum Manager | 0 | ||||
| 3a | Senior Level | 0 | 6,800 | $ - 0 | 3,500 | $ - 0 |
| 3b | Mid Level | 0 | - 0 | $ - 0 | - 0 | $ - 0 |
| 3c | Entry Level | 0 | - 0 | $ - 0 | - 0 | $ - 0 |
| 4 | Telecommunications Specialist | 0 | ||||
| 4a | Mid Level | 0 | 4,000 | $ - 0 | 2,000 | $ - 0 |
| TOTAL LABOR | 37,200 | $ - 0 | 18,500 | $ - 0 | ||
| Travel | $ 14,054.59 | $ - 0 | ||||
| ODCs | $ 5,000.00 | $ - 0 | ||||
| TOTAL BASE PERIOD | 37,200 | $ 19,054.59 | 18,500 | $ - 0 |
| Hours | Dollars | |
| GRAND TOTAL OPTION PERIOD 3 | 55,700 | $ 19,054.59 |
Option Period 4
| Offeror Name: | 0 | ||||||||
| Evaluation Stage: | 0 | ||||||||
| LCAT # | Government Labor Category | Offeror's Internal Labor Category | Contractor Site | Contractor Site | Contractor Site | Government Site | Government Site | Government Site | |
| Loaded Labor Rate | Labor Hours | Dollars | Loaded Labor Rate | Labor Hours | Dollars | ||||
| 1 | Engineer, Electronics | 0 | |||||||
| 1a | Senior Level | 0 | 3,000 | $ - 0 | 1,500 | $ - 0 | |||
| 1b | Mid Level | 0 | 8,000 | $ - 0 | 4,000 | $ - 0 | |||
| 1c | Entry Level | 0 | 3,500 | $ - 0 | 1,500 | $ - 0 |
| 2 | Engineering Technician | 0 | ||||
| 2a | Senior Level | 0 | 3,000 | $ - 0 | 1,500 | $ - 0 |
| 2b | Mid Level | 0 | 3,400 | $ - 0 | 1,700 | $ - 0 |
| 2c | Entry Level | 0 | 3,000 | $ - 0 | 1,500 | $ - 0 |
| 3 | Spectrum Manager | 0 | ||||
| 3a | Senior Level | 0 | 4,000 | $ - 0 | 2,000 | $ - 0 |
| 3b | Mid Level | 0 | - 0 | $ - 0 | - 0 | $ - 0 |
| 3c | Entry Level | 0 | - 0 | $ - 0 | - 0 | $ - 0 |
| 4 | Telecommunications Specialist | 0 | ||||
| 4a | Mid Level | 0 | 3,500 | $ - 0 | 1,750 | $ - 0 |
| TOTAL LABOR | 31,400 | $ - 0 | 15,450 | $ - 0 | ||
| Travel | $ 11,828.38 | $ - 0 | ||||
| ODCs | $ 5,000.00 | $ - 0 | ||||
| TOTAL BASE PERIOD | 31,400 | $ 16,828.38 | 15,450 | $ - 0 |
| Hours | Dollars | |
| GRAND TOTAL OPTION PERIOD 4 | 46,850 | $ 16,828.38 |
6 Mo. Extension
| Offeror Name: | 0 | ||||||||
| Evaluation Stage: | 0 | ||||||||
| LCAT # | Government Labor Category | Offeror's Internal Labor Category | Contractor Site | Contractor Site | Contractor Site | Government Site | Government Site | Government Site | |
| Loaded Labor Rate | Labor Hours | Dollars | Loaded Labor Rate | Labor Hours | Dollars | ||||
| 1 | Engineer, Electronics | 0 | |||||||
| 1a | Senior Level | 0 | 1,500 | $ - 0 | 750 | $ - 0 | |||
| 1b | Mid Level | 0 | 4,000 | $ - 0 | 2,000 | $ - 0 | |||
| 1c | Entry Level | 0 | 1,750 | $ - 0 | 750 | $ - 0 |
| 2 | Engineering Technician | 0 | ||||
| 2a | Senior Level | 0 | 1,500 | $ - 0 | 750 | $ - 0 |
| 2b | Mid Level | 0 | 1,700 | $ - 0 | 850 | $ - 0 |
| 2c | Entry Level | 0 | 1,500 | $ - 0 | 750 | $ - 0 |
| 3 | Spectrum Manager | 0 | ||||
| 3a | Senior Level | 0 | 2,000 | $ - 0 | 1,000 | $ - 0 |
| 3b | Mid Level | 0 | - 0 | $ - 0 | - 0 | $ - 0 |
| 3c | Entry Level | 0 | - 0 | $ - 0 | - 0 | $ - 0 |
| 4 | Telecommunications Specialist | 0 | ||||
| 4a | Mid Level | 0 | 1,750 | $ - 0 | 875 | $ - 0 |
| TOTAL LABOR | 15,700 | $ - 0 | 7,725 | $ - 0 | ||
| Travel | $ 5,914.19 | $ - 0 | ||||
| ODCs | $ 2,500.00 | $ - 0 | ||||
| TOTAL BASE PERIOD | 15,700 | $ 8,414.19 | 7,725 | $ - 0 |
| Hours | Dollars | |
| GRAND TOTAL 6 MO. EXTENSION PERIOD | 23,425 | $ 8,414.19 |
File details come from the government source that posted it. Updated .