Att_4_Cost_Breakout_Spreadsheet_(CBS)_2.14.18.xlsx
XLSX spreadsheet 37 KB Posted
- Solicitation number
- N6134018R1200
About this file
This document includes a cost breakout spreadsheet and description of a federal contract opportunity for engineering support services. The cost breakout spreadsheet outlines labor categories, hours, and rates for government and contractor staff across multiple sites and years. Engineering disciplines covered include aerospace, electrical, mechanical and materials. The associated federal contract opportunity is for engineering support services at the Fleet Readiness Center Southeast located at Naval Air Station Jacksonville. Services will support aircraft and weapons systems including P-3/P-8, F/A-18, E-6, EA-6B and others. The pre-solicitation was added on February 15, 2018 with the final RFP planned for posting by February 28, 2018. The Naval Air Warfare Center Training Systems Division is the procuring agency.
Att_4_Cost_Breakout_Spreadsheet_(CBS)_2.14.18.xlsx
View the file
Other files
Show all 28
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
Cost Breakout Spreadsheet
| COST BREAKOUT SPREADSHEET | ||||||||||||||||||||||||
| Site | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | OPTION | YEARS 1-5 | YEARS 1-5, PLUS OPTION | ||||||||||||||||
| SOW LABOR CATEGORY | ||||||||||||||||||||||||
| NAS Jacksonville, FL | ||||||||||||||||||||||||
| Government Labor Category | Contractor Proposed Labor Category | Hours | Fixed Burdened Rate | Total | Hours | Fixed Burdened Rate | Total | Hours | Fixed Burdened Rate | Total | Hours | Fixed Burdened Rate | Total | Hours | Fixed Burdened Rate | Total | Hours | Fixed Burdened Rate | Total | Total Hours | Total Cost | Total Hours | Total Cost | |
| *Program Manager | $0 | $0 | $0 | $0 | $0 | $0.00 | $0 | - 0 | $0 | - 0 | $0 | |||||||||||||
| *Program Manager | - 0 | $0 | - 0 | $0 | - 0 | $0 | - 0 | $0 | - 0 | $0 | - 0 | $0.00 | $0 | - 0 | $0 | - 0 | $0 | |||||||
| Engineer (BLS SOC No. 17-2011: Aerospace Engineer) - Senior | Government | 5,040 | $0 | 6,720 | $0 | 6,720 | $0 | 6,720 | $0 | 6,720 | $0 | 3,360 | $0.00 | $0 | 31,920 | $0 | 35,280 | $0 | ||||||
| Engineer (BLS SOC No. 17-2011: Aerospace Engineer) - Senior | Contractor | 5,040 | $0 | 6,720 | $0 | 6,720 | $0 | 6,720 | $0 | 6,720 | $0 | 3,360 | $0.00 | $0 | 31,920 | $0 | 35,280 | $0 | ||||||
| Engineer (BLS SOC No. 17-2011: Aerospace Engineer) - Journeyman | Government | 5,760 | $0 | 7,680 | $0 | 7,680 | $0 | 7,680 | $0 | 7,680 | $0 | 3,840 | $0.00 | $0 | 36,480 | $0 | 40,320 | $0 | ||||||
| Engineer (BLS SOC No. 17-2011: Aerospace Engineer) - Journeyman | Contractor | 5,760 | $0 | 7,680 | $0 | 7,680 | $0 | 7,680 | $0 | 7,680 | $0 | 3,840 | $0.00 | $0 | 36,480 | $0 | 40,320 | $0 | ||||||
| Engineer (BLS SOC No. 17-2071: Electrical Engineer) - Senior | Government | 1,440 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 960 | $0.00 | $0 | 9,120 | $0 | 10,080 | $0 | ||||||
| Contractor | $0 | $0 | $0 | $0 | $0 | $0.00 | $0 | - 0 | $0 | - 0 | $0 | |||||||||||||
| Engineer (BLS SOC No. 17-2071: Electrical Engineer) - Senior | Contractor | 1,440 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 960 | $0.00 | $0 | 9,120 | $0 | 10,080 | $0 | ||||||
| Engineer, (BLS SOC No. 17-2071: Electrical Engineer) - Journeyman | Government | 7,200 | $0 | 9,600 | $0 | 9,600 | $0 | 9,600 | $0 | 9,600 | $0 | 4,800 | $0.00 | $0 | 45,600 | $0 | 50,400 | $0 | ||||||
| $0 | $0 | $0 | $0 | $0 | $0.00 | $0 | - 0 | $0 | - 0 | $0 | ||||||||||||||
| Engineer, (BLS SOC No. 17-2071: Electrical Engineer) - Journeyman | Contractor | 7,200 | $0 | 9,600 | $0 | 9,600 | $0 | 9,600 | $0 | 9,600 | $0 | 4,800 | $0.00 | $0 | 45,600 | $0 | 50,400 | $0 | ||||||
| Systems Engineer (BLS SOC No. 17-2141: Mechanical Engineer) - Senior | Government | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Systems Engineer (BLS SOC No. 17-2141: Mechanical Engineer) - Senior | Contractor | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Systems Engineer (BLS SOC No. 17-2141: Mechanical Engineer) - Journeyman | Government | 5,040 | $0 | 6,720 | $0 | 6,720 | $0 | 6,720 | $0 | 6,720 | $0 | 3,360 | $0.00 | $0 | 31,920 | $0 | 35,280 | $0 | ||||||
| Systems Engineer (BLS SOC No. 17-2141: Mechanical Engineer) - Journeyman | Contractor | 5,040 | $0 | 6,720 | $0 | 6,720 | $0 | 6,720 | $0 | 6,720 | $0 | 3,360 | $0.00 | $0 | 31,920 | $0 | 35,280 | $0 | ||||||
| Test Engineer, (BLS SOC No. 17-2141: Mechanical Engineer) - Senior | Government | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Test Engineer, (BLS SOC No. 17-2141: Mechanical Engineer) - Senior | Contractor | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Test Engineer (BLS SOC No. 17-2141: Mechanical Engineer) -Journeyman | Government | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Test Engineer (BLS SOC No. 17-2141: Mechanical Engineer) -Journeyman | Contractor | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Engineer (BLS SOC No. 17-2011: Aerospace Engineer) - Senior | Government | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| $0 | $0 | $0 | $0 | $0 | $0.00 | $0 | - 0 | $0 | - 0 | $0 | ||||||||||||||
| Engineer (BLS SOC No. 17-2011: Aerospace Engineer) - Senior | Contractor | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Engineer (BLS SOC No. 17-2011: Aerospace Engineer) - Journeyman | Government | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| $0 | $0 | $0 | $0 | $0 | $0.00 | $0 | - 0 | $0 | - 0 | $0 | ||||||||||||||
| Engineer (BLS SOC No. 17-2011: Aerospace Engineer) - Journeyman | Contractor | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Test Engineer (BLS SOC No. 17-2131: Materials Engineer)- Senior | Government | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| $0 | $0 | $0 | $0 | $0 | $0.00 | $0 | - 0 | $0 | - 0 | $0 | ||||||||||||||
| Test Engineer (BLS SOC No. 17-2131: Materials Engineer)- Senior | Contractor | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Test Engineer (BLS SOC No. 17-2131: Materials Engineer) -Journeyman | Government | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| 4,320 | $0 | $0 | $0 | $0 | $0 | $0.00 | $0 | 4,320 | $0 | 4,320 | $0 | |||||||||||||
| Test Engineer (BLS SOC No. 17-2131: Materials Engineer) -Journeyman | Contractor | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Test Engineer (BLS SOC No. 17-2131: Materials Engineer) - Junior | Government | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Test Engineer (BLS SOC No. 17-2131: Materials Engineer) - Junior | Contractor | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Engineering Technician IV – SCA 30084 | Government | 1,440 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 960 | $0.00 | $0 | 9,120 | $0 | 10,080 | $0 | ||||||
| Engineering Technician IV – SCA 30084 | Contractor | 1,440 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 960 | $0.00 | $0 | 9,120 | $0 | 10,080 | $0 | ||||||
| Engineering Technician III -SCA-30083 | Government | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Engineering Technician III -SCA-30083 | Contractor | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Drafter / CAD Operator IV - SCA30064 | Government | 1,440 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 960 | $0.00 | $0 | 9,120 | $0 | 10,080 | $0 | ||||||
| Drafter / CAD Operator IV - SCA30064 | Contractor | 1,440 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 960 | $0.00 | $0 | 9,120 | $0 | 10,080 | $0 | ||||||
| Computer Scientist, (BLS SOC No. 15-1221) - Journeyman | Government | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Computer Scientist, (BLS SOC No. 15-1221) - Journeyman | Contractor | 720 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 960 | $0 | 480 | $0.00 | $0 | 4,560 | $0 | 5,040 | $0 | ||||||
| Computer Programmer (BLS SOC No. 15-1131) | Government | 2,160 | $0 | 2,880 | $0 | 2,880 | $0 | 2,880 | $0 | 2,880 | $0 | 1,440 | $0.00 | $0 | 13,680 | $0 | 15,120 | $0 | ||||||
| Computer Programmer (BLS SOC No. 15-1131) | Contractor | 2,160 | $0 | 2,880 | $0 | 2,880 | $0 | 2,880 | $0 | 2,880 | $0 | 1,440 | $0.00 | $0 | 13,680 | $0 | 15,120 | $0 | ||||||
| TOTAL | 73,440 | $0 | 97,920 | $0 | 97,920 | $0 | 97,920 | - 0 | 97,920 | $0 | 48,960 | $0 | 465,120 | $0 | 514,080 | $0 |
| $0 | $0 | $0 | $0 | $0 | - 0 | $0.00 | $0 | $0 | - 0 | $0 | ||||||||
| TOTAL | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | $0 | - 0 | $0 | - 0 | $0 | ||
| NAS Oceana, Virginia Beach VA | ||||||||||||||||||
| Engineer (BLS SOC No. 17-2011: Aerospace Engineer) - Journeyman | Government | 1,440 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 960 | $0.00 | $0 | 9,120 | $0 | 10,080 | $0 |
| TOTAL | 1,440 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 960 | $0 | 9,120 | $0 | 10,080 | $0 | ||
| Tinker AFB, Oklahoma City OK | ||||||||||||||||||
| Engineer (BLS SOC No. 17-2071: Electrical Engineer) - Senior | Government | 1,440 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 960 | $0.00 | $0 | 9,120 | $0 | 10,080 | $0 |
| TOTAL | 1,440 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 960 | $0 | 9,120 | $0 | 10,080 | $0 | ||
| MAS Beaufort, Beaufort SC | ||||||||||||||||||
| Engineer (BLS SOC No. 17-2011: Aerospace Engineer) - Journeyman | Government | 1,440 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 960 | $0.00 | $0 | 9,120 | $0 | 10,080 | $0 |
| TOTAL | 1,440 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 960 | $0 | 9,120 | $0 | 10,080 | $0 | ||
| NAS Corpus Christi, TX | ||||||||||||||||||
| Engineer (BLS SOC No. 17-2011: Aerospace Engineer) - Journeyman | Government | 1,440 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 960 | $0.00 | $0 | 9,120 | $0 | 10,080 | $0 |
| TOTAL | 1,440 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 960 | $0 | 9,120 | $0 | 10,080 | $0 | ||
| Seattle, WA | ||||||||||||||||||
| Engineer (BLS SOC No. 17-2011: Aerospace Engineer) - Journeyman | Government | 1,440 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 960 | $0.00 | $0 | 9,120 | $0 | 10,080 | $0 |
| TOTAL | 1,440 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 960 | $0 | 9,120 | $0 | 10,080 | $0 | ||
| NAS Whiting Field, Milton FL | ||||||||||||||||||
| Engineer (BLS SOC No. 17-2011: Aerospace Engineer) - Journeyman | Government | 1,440 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 1,920 | $0 | 960 | $0.00 | $0 | 9,120 | $0 | 10,080 | $0 |
| TOTAL | 1,440 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 1,920 | - 0 | 960 | $0 | 9,120 | $0 | 10,080 | $0 |
TOTAL LABOR 82,080 $0 109,440 $0 109,440 $0 109,440 $0 109,440 $0 54,720 $0 519,840 $0 574,560 $0
Mobilization $0
| Material | $58,838 | $80,019 | $81,619 | $83,252 | $84,917 | $42,458 | $388,645 | $431,103 | |||||||
| Material Fixed Factor | $58,838 | $0 | $80,019 | $0 | $81,619 | $0 | $83,252 | $0 | $84,917 | $0 | $42,458 | 0% | $0 | $0 | $0 |
| TOTAL MATERIAL | $58,838 | $80,019 | $81,619 | $83,252 | $84,917 | $42,458 | $388,645 | $431,103 |
| Travel | $17,503 | $17,766 | $18,032 | $18,303 | $18,577 | $9,289 | $90,181 | $99,469 | |||||||
| Travel Fixed Factor | $17,503 | $0 | $17,766 | $0 | $18,032 | $0 | $18,303 | $0 | $18,577 | $0 | $9,289 | 0% | $0 | $0 | $0 |
| TOTAL TRAVEL | $17,503 | $17,766 | $18,032 | $18,303 | $18,577 | $9,289 | $90,181 | $99,469 |
FIXED FEE $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0% $0 $0 $0
TOTAL CPFF PRICE $76,341 $97,785 $99,651 $101,555 $103,494 $51,747 $478,826 $530,573
Attachment 4 1.12.18
Section B CLINs
| CLIN | CLIN Number | Total CPFF Price, minus Travel, Material, & Mobilization for Years 1-5 | % Funding Type | AMOUNT |
| Mobilization | _0001 | N/A | N/A | $0 |
| Eningeering Support Services APN or BP11 | _0002 | $0 | 40% | $0 |
| Eningeering Support Services FMS | _0003 | $0 | 3% | $0 |
| Eningeering Support Services O&M | _0004 | $0 | 46% | $0 |
| Eningeering Support Services RDT&E | _0005 | $0 | 6% | $0 |
| Eningeering Support Services WCF | _0006 | $0 | 5% | $0 |
| Material | _0007 | N/A | N/A | $388,645 |
| Travel | _0008 | N/A | N/A | $90,181 |
| Administrative & Technical Data | _0009 | N/A | N/A | NSP |
| OPTION TO EXTEND SERVICES CLINs | ||||
| CLIN | CLIN Number | Total CPFF Price, minus Travel & Material for Option | % Funding Type | AMOUNT |
| Eningeering Support Services APN or BP11 | _0010 | $0 | 52% | $0 |
| Eningeering Support Services FMS | _0011 | $0 | 3% | $0 |
| Eningeering Support Services O&M | _0012 | $0 | 34% | $0 |
| Eningeering Support Services RDT&E | _0013 | $0 | 6% | $0 |
| Eningeering Support Services WCF | _0014 | $0 | 5% | $0 |
| Material | _0015 | N/A | N/A | $42,458 |
| Travel | _0016 | N/A | N/A | $9,289 |
| Administrative & Technical Data | _0015 | N/A | N/A | NSP |
Sheet1
File details come from the government source that posted it. Updated .