P1 (Cost Summary Spreadsheet).xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- FACSFAC Field Maintenance Support Federal contract opportunity
- Solicitation number
- N00421-20-R-0158
About this file
This document contains a Sources Sought notice and draft solicitation for field maintenance support services. The Naval Air Warfare Center Aircraft Division located in St. Inigoes, Maryland is seeking small business capabilities statements for maintenance of Area Control Services Surveillance Systems including the Fleet Area Control and Surveillance Facility Air Control Tracking System, Stand Alone Radar Console, Integrated Range Status System, and Standard Terminal Automation Replacement System located at various sites. Interested parties are requested to submit no more than a ten page response by June 4, 2020 addressing relevant technical experience, facility security clearance held or ability to obtain, and plans to meet the 50% minimum small business participation and limitation on subcontracting requirements. The work will be performed under a single award IDIQ contract with a total estimated value of $388,224 over five years.
View the file
Other files for this federal contract opportunity
Show all 25
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| Instructions for Prime Contractor: | |
| 1 | Enter Prime offeror name into cell B3. |
| 2 | Enter all prime employee names in Column C (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. |
| 3 | Enter all prime labor categories in Column B (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column C, the Offeror should insert the title of the labor category it will be utilizing. The Offeror is not required to utilize the Government's labor categories, however, each proposed labor category should appear opposite of the government labor category it is comparable to. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories. Also, labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information. |
| 4 | Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor) |
| 5 | 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. |
| 6 | All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations. |
| 7 | All dollar figures shall be carried out no further than two decimal places. |
| 8 | In column F, identify for the specific labor category individual whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time. |
| 9 | In columns G/H, the Offeror shall insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in the Government Spaces. |
| 10 | Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly. |
| 11 | For each subcontractor, enter the subcontractor name, total hours, and total amount for each period of performance. |
| 12 | Please note if more subcontractors are needed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas. |
| 13 | The prime should insert the subcontractor handling charge, if any. |
| 14 | The prime should insert the fixed fee rate applied to its cost excluding subcontractor labor. |
| 15 | The prime should insert the fixed fee rate it is applying to the subcontractor labor, if any. |
| 16 | Under Other Direct Costs, the prime contractor should separate by Travel, Material and NMCI as applicable. |
| 17 | Apply indirects to the Other Direct Costs if applicable and if in compliance with the RFP instructions. |
| 18 | On the Summary tab, break out all costs by CLIN. Ensure that the total costs of the CLINs match Section B and the total on the Cost Summary Spreadsheet |
| 19 | When submitting this file, the instructions may be deleted. |
| Instructions for Subcontractors: | |
| 1 | Enter Prime offeror name into cell A3. |
| Replace Prime Contractor with Subcontractor in A7, A8, A45, and A52. | |
| 2 | Enter all subcontractor employee names in Column A (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. |
| 3 | Enter all subcontractor labor categories in Column C (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column C, the Offeror should insert the title of the labor category it will be utilizing. The Offeror is not required to utilize the Government's labor categories, however, each proposed labor category should appear opposite of the government labor category it is comparable to. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories. Also, labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information. |
| 4 | Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor) |
| 5 | 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. |
| 6 | All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations. |
| 7 | All dollar figures shall be carried out no further than two decimal places. |
| 8 | In column D, f identify for the specific labor category individual whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time. |
| 9 | In column E, the Offeror shall insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in the Government Spaces. |
| 10 | Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly. |
| 11 | For subcontractor cost summary sheets, delete Rows 54-97. |
| 12 | When submitting this file, the instructions may be deleted. |
Cost Spreadsheet (LOE)
COST SUMMARY SPREADSHEET (LOE)
| Prime Offeror Name: | ||||||||||||||||||||||||
| Subcontractor Name (if applicable): | ||||||||||||||||||||||||
| Govt | CTR | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total | |||||||||||||||||
| Position | Cost Elements | Employee Name | Location | SCA Code | F/P | Site (G) | Site (C) | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Hours | Amount |
| Prime Contractor Labor Cost |
| 1 | Manager/Operations Manager (Program Manager)* | Patuxent River, MD | CTR | 960 | 960 | 960 | 960 | 960 | 4800 | $ - 0 | |
| 2 | Manager/Operations Manager (Project Manager)* | Patuxent River, MD | CTR | 960 | 960 | 960 | 960 | 960 | 4800 | $ - 0 | |
| 3 | Program / Project / Management Analysts (Management Analyst) | Patuxent River, MD | CTR | 960 | 960 | 960 | 960 | 960 | 4800 | $ - 0 | |
| 4 | Engineering Technician VI* | Jacksonville, FL | Govt | 1920 | 3840 | 3840 | 3840 | 3840 | 17280 | $ - 0 | |
| 5 | Engineering Technician VI* (OT) | Jacksonville, FL | Govt | 192 | 384 | 384 | 384 | 384 | 1728 | $ - 0 | |
| 6 | Engineering Technician V | Jacksonville, FL | Govt | 13440 | 15360 | 15360 | 15360 | 15360 | 74880 | $ - 0 | |
| 7 | Engineering Technician V (OT) | Jacksonville, FL | Govt | 1344 | 1536 | 1536 | 1536 | 1536 | 7488 | $ - 0 | |
| 8 | Engineering Technician VI* | Vacapes, VA | Govt | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 | $ - 0 | |
| 9 | Engineering Technician VI* (OT) | Vacapes, VA | Govt | 192 | 192 | 192 | 192 | 192 | 960 | $ - 0 | |
| 10 | Engineering Technician V | Vacapes, VA | Govt | 7680 | 7680 | 7680 | 7680 | 7680 | 38400 | $ - 0 | |
| 11 | Engineering Technician V (OT) | Vacapes, VA | Govt | 768 | 768 | 768 | 768 | 768 | 3840 | $ - 0 | |
| 12 | Engineering Technician VI* | St. Inigoes, MD | Govt | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 | $ - 0 | |
| 13 | Engineering Technician VI* (OT) | St. Inigoes, MD | Govt | 192 | 192 | 192 | 192 | 192 | 960 | $ - 0 | |
| 14 | Engineering Technician VI* | San Diego, CA | Govt | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 | $ - 0 | |
| 15 | Engineering Technician VI* (OT) | San Diego, CA | Govt | 192 | 192 | 192 | 192 | 192 | 960 | $ - 0 | |
| 16 | Engineering Technician V | San Diego, CA | Govt | 7680 | 7680 | 7680 | 7680 | 7680 | 38400 | $ - 0 | |
| 17 | Engineering Technician V (OT) | San Diego, CA | Govt | 768 | 768 | 768 | 768 | 768 | 3840 | $ - 0 | |
| 18 | Engineering Technician VI* | Pearl Harbor, HI | Govt | 1920 | 1,920 | 1920 | 1920 | 1920 | 9600 | $ - 0 | |
| 19 | Engineering Technician VI* (OT) | Pearl Harbor, HI | Govt | 192 | 192 | 192 | 192 | 192 | 960 | $ - 0 | |
| 20 | Engineering Technician V | Pearl Harbor, HI | Govt | 5760 | 7,680 | 7680 | 7680 | 7680 | 36480 | $ - 0 | |
| 21 | Engineering Technician V (OT) | Pearl Harbor, HI | Govt | 576 | 768 | 768 | 768 | 768 | 3648 | $ - 0 | |
| 22 | Engineering Technician VI* | Twentynine Palms, CA | Govt | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 | $ - 0 | |
| 23 | Engineering Technician VI* (OT) | Twentynine Palms, CA | Govt | 192 | 192 | 192 | 192 | 192 | 960 | $ - 0 | |
| 24 | Engineering Technician VI* | Camp Pendleton, CA | Govt | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 | $ - 0 | |
| 25 | Engineering Technician VI* (OT) | Camp Pendleton, CA | Govt | 192 | 192 | 192 | 192 | 192 | 960 | $ - 0 | |
| 26 | Engineering Technician VI* | Cherry Point, NC | Govt | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 | $ - 0 | |
| 27 | Engineering Technician VI* (OT) | Cherry Point, NC | Govt | 192 | 192 | 192 | 192 | 192 | 960 | $ - 0 | |
| 28 | Engineering Technician VI* | Okinawa, JP | Govt | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 | $ - 0 | |
| 29 | Engineering Technician VI* (OT) | Okinawa, JP | Govt | 192 | 192 | 192 | 192 | 192 | 960 | $ - 0 | |
| 30 | Engineering Technician VI* | Townsend, GA | Govt | 1920 | 1920 | 1920 | 1920 | 1920 | 9600 | $ - 0 | |
| 31 | Engineering Technician VI* (OT) | Townsend, GA | Govt | 192 | 192 | 192 | 192 | 192 | 960 | $ - 0 | |
| 32 | Engineering Technician VI* | Fort Bragg, NC | Govt | 3840 | 3840 | 3840 | 3840 | 3840 | 19200 | $ - 0 | |
| 33 | Engineering Technician VI* (OT) | Fort Bragg, NC | Govt | 384 | 384 | 384 | 384 | 384 | 1920 | $ - 0 | |
| 34 | Engineering Technician V | Fort Bragg, NC | Govt | 5760 | 5760 | 5760 | 5760 | 5760 | 28800 | $ - 0 | |
| 35 | Engineering Technician V (OT) | Fort Bragg, NC | Govt | 576 | 576 | 576 | 576 | 576 | 2880 | $ - 0 |
| Total Direct Labor Cost | 72,576 | $ - 0 | 78,912 | $ - 0 | 78,912 | $ - 0 | 78,912 | $ - 0 | 78,912 | $ - 0 | 388,224 | $ - 0 | |
| Prime Contractor Indirect Labor Cost | Base | Base | Base | Base | Base | ||||||||
| Overhead | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Fringe Benefits | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| G&A | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Total Indirect Labor Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Total Direct and Indirect Labor cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| COM | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Total Prime Contractor Labor Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Subcontractor Labor Cost | |||||||||||||
| Subcontractor proposed cost and fee | |||||||||||||
| 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| 2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| 3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Total proposed subcontractor labor cost and fee | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Prime contractor pass through (not including fee) | Base | Base | Base | Base | Base | ||||||||
| Handling | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| G&A | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Other (if any) | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Total pass through (not including fee) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||
| Total Subcontractor Cost including pass through | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Total Labor Cost (Prime and Subcontractor Labor) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| Fixed Fee | Base | Base | Base | Base | Base | |||||||
| Prime Contractor Fee for Prime Contractor Labor | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Prime Contractor Fee for Subcontractor Labor * | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Fee (for Prime and Subcontractor Labor) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Total Labor Cost Plus Fixed Fee (CPFF) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| Other Direct Costs | ||||||||||||
| TRAVEL | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| MATERIAL | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Any adders to ODCs such as G&A (cost only - no fee) | 0% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total ODCs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Total CPFF all CLINs (Labor and ODCs) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Grand Total of CPFF all CLINs
| Pass Through Analysis - Total for All Years | Amount | Percent |
| Subcontractor proposed cost and fee | $ - 0 | |
| Pass Through Amount (not including fee) | $ - 0 | |
| Prime Contractor Fee for Subcontractor Labor * | $ - 0 | |
| Total Pass Through Amount (including fee) | $ - 0 | ERROR:#DIV/0! |
| Fee Analysis - Total for All Years | Amount | Percent |
| Prime Contractor Labor Cost | $ - 0 | |
| Fixed Fee for Labor Performed by Prime Contractor | $ - 0 | ERROR:#DIV/0! |
Page &P &F
KTR: (name) Source Selection Information - See: FAR 2.101 and 3.104 RFP:
Summary CLIN Summary Sheet
CLINS CLIN Description Total Hours Total Cost Total Fixed Fee Total Value $
Total
File details come from the government source that posted it. Updated .