Attachment_21_2_Nov_2018.xlsx
XLSX spreadsheet 40 KB Posted
- Solicitation number
- N6134019R0025
About this file
Attachment_21_2_Nov_2018.xlsx
View the file
Other files
| File | Type | Posted |
|---|---|---|
| N6134019R0025_Amendment_2____2nov2018.pdf | ||
| N6134019R0025_Amendment_0002.zipx | ZIPX file | |
| RFP_Questions_and_answers_23_Oct_2018.xls | XLS spreadsheet | |
| N6134019R0025_Amendment_0001.pdf | ||
| N61340-19-R-0025_Amendment_0001.zipx | ZIPX file | |
| N61340-19-R-0025_Attachment_17-22_and_Exhibit_B.zipx | ZIPX file | |
| Attachment_16_Note.docx | DOCX document | |
| N6134019R0025_9OCT2018.pdf | ||
| N61340-19-R-0025_Attachments_1-15.zipx | ZIPX file |
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
(A) Instructions Contractor Instructions
2Nov2018 Amendment 0002
| 1 | Do not type in colored/shaded cells. Any colored or shaded cell should not be edited nor its formula. |
| 2 | On Footer Tab of every worksheet, insert the firm's name after colon. Insert the RFP number after the colon, if it has not been filled-in. |
| 3 | The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER. |
| 4 | The worksheet is arranged that the workforce being proposed for an entire period of performance is shown together, even though it will separated by individual CLINS in Section B. When the numbers are carried to Section B, they will be the same as shown on the worksheet. |
| 5 | TABS: D,E,F,G,H, and I Columns B have been populated with the Government recommended Labor Categories. In columns C and D, the Offeror will insert the title of the labor category and DOL ID number it will be utilizing. |
| 6 | TAB J: Column A have been populated with the Government recommended Labor Categories. In columns B and C, the Offeror will insert the title of the labor category and DOL ID number it will be utilizing. |
| 7 | The Offeror is not required to utilize the Government's labor categories. However, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories. |
| 8 | TABS: D,E,F,G,H, and I Columns E Unburdened Direct Labor rate shall be a weighted average of all personnel for the associated labor category and site |
| 9 | TAB: J Columns D,E,F, G and H Unburdened Direct Labor rate shall be a weighted average of all personnel for the associated labor category and site |
| 10 | TABS: D,E,F,G,H, and I Columns H Unit Price shall include service support amounts (service support amounts are not separate prices but are included within the unit pricing to include indirect costs). |
| 11 | TABS: D,E,F,G,H, and I Columns F Row 6 and 7 will be the only cells the Offeror can input an hour amount. The 2 cells when added will equal the amount of above highlighted cell F5. |
| 12 |
(B) Total CLIN Summary
| Do not type in colored/shaded cells. Any colored or shaded cell should not be edited nor its formula. | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | 6-month Option to Extend | Total | ||
| 1 | San Diego Mobilization SWOS | $ - 0 | $ - 0 | ||||||
| X100 | San Diego Contractor Instructor-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X110 | San Diego High Risk Instructor- SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X120 | San Diego Diesel Engine Inspector-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 2 | Norfolk Mobilization | $ - 0 | $ - 0 | ||||||
| X200 | Norfolk Contractor Instructor-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X210 | Norfolk Diesel Engine Inspector-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 3 | Great Lake Mobilization | $ - 0 | $ - 0 | ||||||
| X300 | Great Lakes Contractor Instructor-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X310 | Great Lakes NDT Instructor-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X320 | Great Lakes Testing Officer-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X330 | Great Lakes Testing Clerk-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X340 | Great Lakes Computer Programmer-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X350 | Great Lakes Database Manager-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X360 | Great Lakes Diesel Engine Inspector-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X370 | Great Lakes MGTI Instructor-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4 | Pearl Harbor Mobilization | $ - 0 | $ - 0 | ||||||
| X400 | Pearl Harbor High Risk Instructor-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X420 | Pearl Harbor Emergency Medical Technician-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 5 | Newport Mobilization | $ - 0 | $ - 0 | ||||||
| X500 | Newport Contractor Instructor-SWOS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 6 | San Diego Mobilization PMS 339 | $ - 0 | $ - 0 | ||||||
| X700 | San Diego Contractor Instructor- PMS 339 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X600 | SWOS Travel | $ 16,027.00 | $ 16,507.00 | $ 17,003.00 | $ 17,513.00 | $ 18,038.00 | $ 9,019.00 | $ 94,107.00 | |
| $ 16,027.00 | $ 16,507.00 | $ 17,003.00 | $ 17,513.00 | $ 18,038.00 | $ 9,019.00 | $ 94,107.00 | Grand Total |
| Dollar Amount of Grand Total to be spent for SDVOSB concerns |
| Percentage Amount of Grand Total to spent for SDVOSB concerns |
(C) Mobilization
| Do not type in colored/shaded cells. Any colored or shaded cell should not be edited nor its formula. | ||
| Mobilization CLINS | ||
| CLIN | Description | TOTAL PRICE |
| 00001 | San Diego SWOS | |
| 00002 | Norfolk SWOS | |
| 00003 | Great Lakes SWOS | |
| 00004 | Pearl Harbor SWOS | |
| 00005 | Newport SWOS | |
| 00006 | San Diego PMS 339 | |
| Total | $ - 0 |
(D) Base Year
| Do not type in colored/shaded cells. Any colored or shaded cell should not be edited nor its formula. | ||||||||
| CLIN | Description | Proposed DOL ID Number | Proposed Labor Category | Unburdened Direct Labor Rate | (QTY)Training Hours Per Year | Unit | UNIT PRICE | TOTAL PRICE |
| 1100/1110 | 36461 | |||||||
| 1100 | San Diego Contractor Instructor-SWOS | Hour | $ - 0 | |||||
| 1110 | San Diego High Risk Instructor- SWOS | Hour | $ - 0 | |||||
| 1120 | San Diego Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 1200 | Norfolk Contractor Instructor-SWOS | 18688 | Hour | $ - 0 | ||||
| 1210 | Norfolk Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 1300 | Great Lakes Contractor Instructor-SWOS | 17184 | Hour | $ - 0 | ||||
| 1310 | Great Lakes NDT Instructor-SWOS | 1920 | Hour | $ - 0 | ||||
| 1320 | Great Lakes Testing Officer-SWOS | 11520 | Hour | $ - 0 | ||||
| 1330 | Great Lakes Testing Clerk-SWOS | 11520 | Hour | $ - 0 | ||||
| 1340 | Great Lakes Computer Programmer-SWOS | 1920 | Hour | $ - 0 | ||||
| 1350 | Great Lakes Database Manager-SWOS | 1920 | Hour | $ - 0 | ||||
| 1360 | Great Lakes Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 1400 | Pearl Harbor High Risk Instructor-SWOS | 6953 | Hour | $ - 0 | ||||
| 1420 | Pearl Harbor Emergency Medical Technician-SWOS | 1920 | Hour | $ - 0 | ||||
| 1500 | Newport Contractor Instructor-SWOS | 1970 | Hour | $ - 0 | ||||
| 1700 | San Diego Contractor Instructor- PMS 339 | 5674 | Hour | $ - 0 | ||||
| 1600 | SWOS Travel | $ 16,027.00 | ||||||
| Total | $ 16,027.00 |
(E) Period 2
| Do not type in colored/shaded cells. Any colored or shaded cell should not be edited nor its formula. | ||||||||
| CLIN | Description | Proposed DOL ID Number | Proposed Labor Category | Unburdened Direct Labor Rate | (QTY)Training Hours Per Year | Unit | UNIT PRICE | TOTAL PRICE |
| 2100/2110 | 36461 | |||||||
| 2100 | San Diego Contractor Instructor-SWOS | Hour | $ - 0 | |||||
| 2110 | San Diego High Risk Instructor- SWOS | Hour | $ - 0 | |||||
| 2120 | San Diego Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 2200 | Norfolk Contractor Instructor-SWOS | 18688 | Hour | $ - 0 | ||||
| 2210 | Norfolk Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 2300 | Great Lakes Contractor Instructor-SWOS | 17184 | Hour | $ - 0 | ||||
| 2310 | Great Lakes NDT Instructor-SWOS | 1920 | Hour | $ - 0 | ||||
| 2320 | Great Lakes Testing Officer-SWOS | 11520 | Hour | $ - 0 | ||||
| 2330 | Great Lakes Testing Clerk-SWOS | 11520 | Hour | $ - 0 | ||||
| 2340 | Great Lakes Computer Programmer-SWOS | 1920 | Hour | $ - 0 | ||||
| 2350 | Great Lakes Database Manager-SWOS | 1920 | Hour | $ - 0 | ||||
| 2360 | Great Lakes Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 2370 | Great Lakes MGTI Instructor-SWOS | 1920 | Hour | $ - 0 | ||||
| 2400 | Pearl Harbor High Risk Instructor-SWOS | 6953 | Hour | $ - 0 | ||||
| 2420 | Pearl Harbor Emergency Medical Technician-SWOS | 1920 | Hour | $ - 0 | ||||
| 2500 | Newport Contractor Instructor-SWOS | 1970 | Hour | $ - 0 | ||||
| 2700 | San Diego Contractor Instructor- PMS 339 | 5674 | Hour | $ - 0 | ||||
| 2600 | SWOS Travel | $ 16,507.00 | ||||||
| Total | $ 16,507.00 |
(F) Period 3
| Do not type in colored/shaded cells. Any colored or shaded cell should not be edited nor its formula. | ||||||||
| CLIN | Description | Proposed DOL ID Number | Proposed Labor Category | Unburdened Direct Labor Rate | (QTY)Training Hours Per Year | Unit | UNIT PRICE | TOTAL PRICE |
| 3100/3110 | 36461 | |||||||
| 3100 | San Diego Contractor Instructor-SWOS | Hour | $ - 0 | |||||
| 3110 | San Diego High Risk Instructor- SWOS | Hour | $ - 0 | |||||
| 3120 | San Diego Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 3200 | Norfolk Contractor Instructor-SWOS | 18688 | Hour | $ - 0 | ||||
| 3210 | Norfolk Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 3300 | Great Lakes Contractor Instructor-SWOS | 17184 | Hour | $ - 0 | ||||
| 3310 | Great Lakes NDT Instructor-SWOS | 1920 | Hour | $ - 0 | ||||
| 3320 | Great Lakes Testing Officer-SWOS | 11520 | Hour | $ - 0 | ||||
| 3330 | Great Lakes Testing Clerk-SWOS | 11520 | Hour | $ - 0 | ||||
| 3340 | Great Lakes Computer Programmer-SWOS | 1920 | Hour | $ - 0 | ||||
| 3350 | Great Lakes Database Manager-SWOS | 1920 | Hour | $ - 0 | ||||
| 3360 | Great Lakes Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 3370 | Great Lakes MGTI Instructor-SWOS | 1920 | Hour | $ - 0 | ||||
| 3400 | Pearl Harbor High Risk Instructor-SWOS | 6953 | Hour | $ - 0 | ||||
| 3420 | Pearl Harbor Emergency Medical Technician-SWOS | 1920 | Hour | $ - 0 | ||||
| 3500 | Newport Contractor Instructor-SWOS | 1970 | Hour | $ - 0 | ||||
| 3700 | San Diego Contractor Instructor- PMS 339 | 5674 | Hour | $ - 0 | ||||
| 3600 | SWOS Travel | $ 17,003.00 | ||||||
| Total | $ 17,003.00 |
(G) Period 4
| Do not type in colored/shaded cells. Any colored or shaded cell should not be edited nor its formula. | ||||||||
| CLIN | Description | Proposed DOL ID Number | Proposed Labor Category | Unburdened Direct Labor Rate | (QTY)Training Hours Per Year | Unit | UNIT PRICE | TOTAL PRICE |
| 4100/4110 | 36461 | |||||||
| 4100 | San Diego Contractor Instructor-SWOS | Hour | $ - 0 | |||||
| 4110 | San Diego High Risk Instructor- SWOS | Hour | $ - 0 | |||||
| 4120 | San Diego Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 4200 | Norfolk Contractor Instructor-SWOS | 18688 | Hour | $ - 0 | ||||
| 4210 | Norfolk Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 4300 | Great Lakes Contractor Instructor-SWOS | 17184 | Hour | $ - 0 | ||||
| 4310 | Great Lakes NDT Instructor-SWOS | 1920 | Hour | $ - 0 | ||||
| 4320 | Great Lakes Testing Officer-SWOS | 11520 | Hour | $ - 0 | ||||
| 4330 | Great Lakes Testing Clerk-SWOS | 11520 | Hour | $ - 0 | ||||
| 4340 | Great Lakes Computer Programmer-SWOS | 1920 | Hour | $ - 0 | ||||
| 4350 | Great Lakes Database Manager-SWOS | 1920 | Hour | $ - 0 | ||||
| 4360 | Great Lakes Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 4370 | Great Lakes MGTI Instructor-SWOS | 1920 | Hour | $ - 0 | ||||
| 4400 | Pearl Harbor High Risk Instructor-SWOS | 6953 | Hour | $ - 0 | ||||
| 4420 | Pearl Harbor Emergency Medical Technician-SWOS | 1920 | Hour | $ - 0 | ||||
| 4500 | Newport Contractor Instructor-SWOS | 1970 | Hour | $ - 0 | ||||
| 4700 | San Diego Contractor Instructor- PMS 339 | 5674 | Hour | $ - 0 | ||||
| 4600 | SWOS Travel | $ 17,513.00 | ||||||
| Total | $ 17,513.00 |
(H) Period 5
| Do not type in colored/shaded cells. Any colored or shaded cell should not be edited nor its formula. | ||||||||
| CLIN | Description | Proposed DOL ID Number | Proposed Labor Category | Unburdened Direct Labor Rate | (QTY)Training Hours Per Year | Unit | UNIT PRICE | TOTAL PRICE |
| 5100/5110 | 36461 | |||||||
| 5100 | San Diego Contractor Instructor-SWOS | Hour | $ - 0 | |||||
| 5110 | San Diego High Risk Instructor- SWOS | Hour | $ - 0 | |||||
| 5120 | San Diego Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 5200 | Norfolk Contractor Instructor-SWOS | 18688 | Hour | $ - 0 | ||||
| 5210 | Norfolk Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 5300 | Great Lakes Contractor Instructor-SWOS | 17184 | Hour | $ - 0 | ||||
| 5310 | Great Lakes NDT Instructor-SWOS | 1920 | Hour | $ - 0 | ||||
| 5320 | Great Lakes Testing Officer-SWOS | 11520 | Hour | $ - 0 | ||||
| 5330 | Great Lakes Testing Clerk-SWOS | 11520 | Hour | $ - 0 | ||||
| 5340 | Great Lakes Computer Programmer-SWOS | 1920 | Hour | $ - 0 | ||||
| 5350 | Great Lakes Database Manager-SWOS | 1920 | Hour | $ - 0 | ||||
| 5360 | Great Lakes Diesel Engine Inspector-SWOS | 1920 | Hour | $ - 0 | ||||
| 5370 | Great Lakes MGTI Instructor-SWOS | 1920 | Hour | $ - 0 | ||||
| 5400 | Pearl Harbor High Risk Instructor-SWOS | 6953 | Hour | $ - 0 | ||||
| 5420 | Pearl Harbor Emergency Medical Technician-SWOS | 1920 | Hour | $ - 0 | ||||
| 5500 | Newport Contractor Instructor-SWOS | 1970 | Hour | $ - 0 | ||||
| 5700 | San Diego Contractor Instructor- PMS 339 | 5674 | Hour | $ - 0 | ||||
| 5600 | SWOS Travel | $ 18,038.00 | ||||||
| Total | $ 18,038.00 |
(I) 6 month option to extend
| Do not type in colored/shaded cells. Any colored or shaded cell should not be edited nor its formula. | Do not add escalation in the 6 month option to extend period | |||||||
| CLIN | Description | Proposed DOL ID Number | Proposed Labor Category | Unburdened Direct Labor Rate | (QTY)Training Hours Per Year | Unit | UNIT PRICE | TOTAL PRICE |
| 6100/6110 | 18230.5 | |||||||
| 6100 | San Diego Contractor Instructor-SWOS | Hour | $ - 0 | |||||
| 6110 | San Diego High Risk Instructor- SWOS | Hour | $ - 0 | |||||
| 6120 | San Diego Diesel Engine Inspector-SWOS | 960 | Hour | $ - 0 | ||||
| 6200 | Norfolk Contractor Instructor-SWOS | 9344 | Hour | $ - 0 | ||||
| 6210 | Norfolk Diesel Engine Inspector-SWOS | 960 | Hour | $ - 0 | ||||
| 6300 | Great Lakes Contractor Instructor-SWOS | 8592 | Hour | $ - 0 | ||||
| 6310 | Great Lakes NDT Instructor-SWOS | 960 | Hour | $ - 0 | ||||
| 6320 | Great Lakes Testing Officer-SWOS | 5760 | Hour | $ - 0 | ||||
| 6330 | Great Lakes Testing Clerk-SWOS | 5760 | Hour | $ - 0 | ||||
| 6340 | Great Lakes Computer Programmer-SWOS | 960 | Hour | $ - 0 | ||||
| 6350 | Great Lakes Database Manager-SWOS | 960 | Hour | $ - 0 | ||||
| 6360 | Great Lakes Diesel Engine Inspector-SWOS | 960 | Hour | $ - 0 | ||||
| 6370 | Great Lakes MGTI Instructor-SWOS | 960 | Hour | $ - 0 | ||||
| 6400 | Pearl Harbor High Risk Instructor-SWOS | 3476.5 | Hour | $ - 0 | ||||
| 6420 | Pearl Harbor Emergency Medical Technician-SWOS | 960 | Hour | $ - 0 | ||||
| 6500 | Newport Contractor Instructor-SWOS | 985 | Hour | $ - 0 | ||||
| 6700 | San Diego Contractor Instructor- PMS 339 | 2837 | Hour | $ - 0 | ||||
| 6600 | SWOS Travel | $ 9,019.00 | ||||||
| Total | $ 9,019.00 |
(J) Escalation Summary
| Do not type in colored/shaded cells. Any colored or shaded cell should not be edited nor its formula. | |||||||
| Description | Proposed DOL ID Number | Proposed Labor Category | Unburdened Direct Labor Rate Base Year | Unburdened Direct Labor Rate Year 2 | Unburdened Direct Labor Rate Year 3 | Unburdened Direct Labor Rate Year 4 | Unburdened Direct Labor Rate Year 5 |
| San Diego Contractor Instructor-SWOS | |||||||
| San Diego High Risk Instructor- SWOS | |||||||
| San Diego Diesel Engine Inspector-SWOS | |||||||
| Norfolk Contractor Instructor-SWOS | |||||||
| Norfolk Diesel Engine Inspector-SWOS | |||||||
| Great Lakes Contractor Instructor-SWOS | |||||||
| Great Lakes NDT Instructor-SWOS | |||||||
| Great Lakes Testing Officer-SWOS | |||||||
| Great Lakes Testing Clerk-SWOS | |||||||
| Great Lakes Computer Programmer-SWOS | |||||||
| Great Lakes Database Manager-SWOS | |||||||
| Great Lakes Diesel Engine Inspector-SWOS | |||||||
| Great Lakes MGTI Instructor-SWOS | |||||||
| Pearl Harbor High Risk Instructor-SWOS | |||||||
| Pearl Harbor Emergency Medical Technician-SWOS | |||||||
| Newport Contractor Instructor-SWOS | |||||||
| San Diego Contractor Instructor- PMS 339 |
File details come from the government source that posted it.