CA-2 TEPL.xlsx
XLSX spreadsheet 47 KB Posted
- Attached to
- Programmatic, Flight Test Engineering, and Administrative Support to Naval Test Wing Atlantic Federal contract opportunity
- Solicitation number
- N0042121R0112
About this file
This document contains a draft solicitation and related template attachments for programmatic, flight test engineering, and administrative support services for the Naval Test Wing Atlantic. The solicitation is being issued by the Naval Air Systems Command on behalf of the Naval Air Warfare Center-Aircraft Division. Key details include that the solicitation is seeking industry feedback on the draft requirements and instructions by March 31, 2021, though this is not a request for proposals. The attachments include templates for cost breakdowns, labor categories and rates, and hours by labor category. Offerors are instructed to complete the templates to demonstrate their proposed costs and pricing approach in response to the requirement.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| TEPL Questions Round 2.pdf | ||
| TEPL Draft RFP Questions and Responses.pdf | ||
| CA-1 TEPL.xlsx | XLSX spreadsheet | |
| Attachment P-2 CPAQ.pdf | ||
| Draft RFP N0042121R0112.pdf | ||
| Attachment 1 TEPL SOW.pdf | ||
| Attachment 2 NTWL SAC_TEPL.pdf | ||
| Attachment P-1 Past Peformance Information Form.pdf |
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
| Contractor: | |
| 1 | On Header Tab the attachment file name should be automatically populated. |
| 2 | On Footer Tab for the worksheet, insert the firm's name after colon. |
| 3 | Every worksheet should have items 1 and 2 completed. |
| 4 | Within the work sheet any cell colored "blue" contains a formula and should not be edited. In the 'CPFF Total Labor Hours Proposed' tab, formulas in white cells should update automatically if instructions are followed. |
| 5 | All dollar figures shall be carried out no further than two decimal places. |
| 6 | DO NOT add additional worksheets/tabs to this workbook. Any additional tabs will not be evaluated. |
| 7 | All Direct rates must be entered per year and may only link to cells to show escalation. |
| 8 | Do not change the color shading or add shading to this template. Follow the format and ensure consistency as needed. |
| 9 | In column A, starting at row 5, the Government labor category is provided. The Offeror shall begin to enter the rates proposed for each person addressing all labor categories as applicable. DO NOT DELETE UNUSED ROWS OR COLUMNS AS IT WILL IMPACT THE TOTAL COLUMNS AND ROWS. Offerors may hide unused labor categories ensuring the hours provided contain a value of "0" as applicable. If necessary, you may insert additional rows to account for multiple rates/personnel in the same category--but ensure integrity of formulas through all tabs. Labor categories with more than one person providing the service shall be listed individually for each person performing work. For example, if the offeror proposes two people to perform one Multimedia Specialist, Junior position, then the labor category Multimedia Specialist, Junior shall be listed twice along with their applicable rates, hours, and any other information. Same goes for labor categories where there are multiple full-time equivalents. |
| 10 | Labor Categories shall remain in alphabetical order and like categories remain together within each offerors section. For example if the Offeror proposes 2 software Administrative Assistant, Juniors, they should be listed in consecutive rows. The same should be followed for subcontractors proposing multiples of the same labor category. |
| 11 | In column C, the Offeror should insert a "K" if the worker will be performing at the Contractor's facility, a KA for Contractor - Alternate site if the contractor will be using an "off-site" rate for personnel that will be working at another contractor's facility, or a "G" if it will be performing the work in Government spaces. |
| 12 | In column D, the field is colored "green" indicating no input needed. |
| 13 | In column E,identify for each individual proposed whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time. |
| 14 | In column F, enter the name of the proposed individual for that position. |
| 15 | In column G: |
| 16 | (a) enter the unburdened labor rate for each individual |
| 17 | (b) In Cells G25,K25, O25,S25, W25, AA25, AE25, AI25, AM25, AQ25 insert the offerors fringe rate for full time, if it is not included in the overhead rate. If the fringe is included in the overhead rate, this cell should be left blank. |
| 18 | (c) In Cells G26,K26, O26,S26, W26, AA26, AE26, AI26, AM26, AQ26 insert the offerors fringe rate for part-time, if it is not included in the overhead rate. If the fringe is included in the overhead rate, this cell should be left blank. If no part-time employees are proposed this should also be left blank. |
| 19 | (d) In Cells G29, K29, O29,S29, W29, AA29, AE29, AI29, AM29, AQ29 the offeror should insert its overhead rate for work performed at the contractor's facility. |
| 20 | (e) In Cells G30, K30, O30,S30, W30, AA30, AE30, AI30, AM30, AQ30 the offeror should insert its overhead rate for work performed at the Client/Government's facility. |
| 21 | (f) In Cells G32, K32, O32,S32, W32, AA32, AE32, AI32, AM32, AQ32 the offeror should insert its indirect rate for the G&A rate being applied. |
| 24 | (g) In Cells G73, K73, O73,S73, W73, AA73, AE73, AI73, AM73, AQ73, the offeror should insert the fixed fee rate applied to its cost. |
| 26 | In column H, and then similarly for columns L, P, T, X AB, AF, AJ, AN, and AR: |
| 27 | (a) Enter the hours associated with individual labor category for CLIN XX00 (e.g., rows 5-22, 38-39, and so on). Also make sure you plug in the hours for columns L, P, T, X AB, AF, AJ, AN, and AR. |
| 28 | (b) In Cells H25, L25, P25, T25, X25, AB25, AF25, AJ25, AN25, and AR25, the Offerors should insert the "labor base" its fringe rate for full time is being applied to, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank. |
| 29 | (c) In Cells H26, L26, P26, T26, X26, AB26, AF26, AJ26, AN26, and AR26, the Offerors should insert the "labor base" its fringe rate for part time is being applied to, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank. |
| 30 | (d) In Cells H29, L29, P29, T29, X29, AB29, AF29, AJ29, AN29, and AR29, the Offerors should insert the "labor base" its overhead rate is being applied to for work performed at the contractor's facility. |
| 31 | (e) In Cells H30, L30, P30, T30, X30, AB30, AF30, AJ30, AN30, and AR30, the Offerors should insert the "labor base" its overhead rate is being applied to for work performed at the Client/Gov't site rate is being applied to |
| 32 | (f) In Cells H32, L32, P32, T32, X32, AB32, AF32, AJ32, AN32, and AR32, the Offerors should insert the base its G&A rate is being applied to. |
| 33 | (g) In Cells H73, L73, P73, T73, X73, AB73, AF73, AJ73, AN73, and AR73, insert the Offeors labor base its fixed fee rate is being applied to. |
| 35 | (i) In Cells G85, K85, O85,S85, W85, AA85, AE85, AI85, AM85, AQ85, the Prime shall enter its G&A rate that will be used on ODC. |
| 36 | Column "AU" automatically calculates the total hours for all the CLINS. |
| 37 | Column"AW" is a summation of the costs. |
| 38 | If there is not going to be any data entry in a row or group of rows, please just hide the rows. Do not delete. |
| 39 | When submitting this file, the instructions tab may be deleted. |
1 The CPFF Total Labor Hours Proposed Tab should calculate automatically. If adding rows, ensure the integrity of ALL formulas on ALL TABS.
| Fully Burdened CPFF Labor Rates Worksheet: | |
| 1 | In Column A, enter the Proposed Government Labor category for each proposed individual. Spell and format entries the same every time it is used on the template. |
| 2 | In Column B, For each individual Contractor employee proposed; enter a different identifying title in the form of FTE## (e.g. FTE01, FTE02, etc.) for each individual to distinguish them from one another. Rows should be added to account for multiple FTEs at one location and/or FTEs at various locations. Do not enter the individual's name into the template. |
| 3 | In Columns C-L, Enter the Annual Fully-Burdened Labor proposed for the applicable performance period (e.g. Base or Year_#) for personnel associated with the Proposed Labor Category and Individual Designator by linking back to the applicable performance period direct and indirect rates. This formula should show the Government how an Offeror develops its fully burdened rates in accordance with its disclosure statement so that the Government has a full understanding of how fully burdened rates were developed. The Government should be able to trace this formula back for each labor category for each period of performance. The first orange highlighted row is an EXAMPLE of the type of formula the Government expects to see here in accordance with an Offerors disclosure statement, and SHOULD BE DELETED prior to proposal submission. Offerors are expected to use a similar formula demonstrating how indirect rates are applied to each direct labor rate in order to formulate a fully burdened rate. Numbers should reflect U.S. Dollar format $###.## rounded to the nearest cent. Annual Fully-Burdened Labor shall include fringe, overhead, G&A, and fee on total cost, but should not include Fully-Burdened Other Direct Costs (ODCs) such as Materials, Travel, and Cost of Money costs. Annual Fully-Burdened Labor shall be the Fully-Burdened Labor Rate times the amount of hours proposed for the applicable performance period. |
Attachment CA-2 Subcontractor Cost Breakout Spreadsheet (RFP #N00421-21-R-0112)
KTR:(insert name) Source Selection Information See: FAR 2.101 3.104
Base - OY 9
| DO NOT TYPE IN ANY COLORED AREAS | Base | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 5 | Year 6 | Year 7 | Year 8 | Year 5 | Year 9 | Year 5 | ||||||||||||||||||||||||
| CPFF | CLINs | XXXX | CLINs | XXXX | CLINs | XXXX | CLINs | XXXX | CLINs | XXXX | CLINs | XXXX | CLINs | XXXX | CLINs | XXXX | CLINs | XXXX | CLINs | XXXX | |||||||||||||||||
| Services (Regular Labor) | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | subtotal | hrs | ||||||||||||||||
| Government Labor Category | Location | site | sub | f/p | Employee Name | Rate | Labor | Rate | Labor | Rate | Labor | Rate | Labor | Rate | Labor | Rate | Labor | Rate | Labor | Rate | Labor | Rate | Labor | Rate | Labor | SUM | Total | ||||||||||
| Administrative Assistant, Junior | Patucent River, MD | $ - 0 | 3456 | $ - 0 | $ - 0 | 3629 | $ - 0 | $ - 0 | 3701 | $ - 0 | $ - 0 | 3701 | $ - 0 | $ - 0 | 3701 | $ - 0 | $ - 0 | 3701 | $ - 0 | $ - 0 | 3868 | $ - 0 | $ - 0 | 4042 | $ - 0 | $ - 0 | 4224 | $ - 0 | $ - 0 | 4224 | $ - 0 | 38,247.0 | $ - 0 | ||||
| Administrative Assistant, Journeyman | Patucent River, MD | $ - 0 | 8640 | $ - 0 | $ - 0 | 9072 | $ - 0 | $ - 0 | 9253 | $ - 0 | $ - 0 | 9253 | $ - 0 | $ - 0 | 9253 | $ - 0 | $ - 0 | 9253 | $ - 0 | $ - 0 | 9670 | $ - 0 | $ - 0 | 10105 | $ - 0 | $ - 0 | 10560 | $ - 0 | $ - 0 | 10560 | $ - 0 | 95,619.0 | $ - 0 | ||||
| Administrative Assistant, Senior | Patucent River, MD | $ - 0 | 5184 | $ - 0 | $ - 0 | 5443 | $ - 0 | $ - 0 | 5552 | $ - 0 | $ - 0 | 5552 | $ - 0 | $ - 0 | 5552 | $ - 0 | $ - 0 | 5552 | $ - 0 | $ - 0 | 5802 | $ - 0 | $ - 0 | 6063 | $ - 0 | $ - 0 | 6336 | $ - 0 | $ - 0 | 6336 | $ - 0 | 57,372.0 | $ - 0 | ||||
| Engineer Scientist, Junior | Patucent River, MD | $ - 0 | 9600 | $ - 0 | $ - 0 | 10080 | $ - 0 | $ - 0 | 10282 | $ - 0 | $ - 0 | 10282 | $ - 0 | $ - 0 | 10282 | $ - 0 | $ - 0 | 10282 | $ - 0 | $ - 0 | 10744 | $ - 0 | $ - 0 | 11228 | $ - 0 | $ - 0 | 11733 | $ - 0 | $ - 0 | 11733 | $ - 0 | 106,246.0 | $ - 0 | ||||
| Engineer Scientist, Journeyman | Patucent River, MD | $ - 0 | 24000 | $ - 0 | $ - 0 | 25200 | $ - 0 | $ - 0 | 25704 | $ - 0 | $ - 0 | 25704 | $ - 0 | $ - 0 | 25704 | $ - 0 | $ - 0 | 25704 | $ - 0 | $ - 0 | 26861 | $ - 0 | $ - 0 | 28069 | $ - 0 | $ - 0 | 29333 | $ - 0 | $ - 0 | 29333 | $ - 0 | 265,612.0 | $ - 0 | ||||
| Engineer Scientist, Senior | Patucent River, MD | $ - 0 | 14400 | $ - 0 | $ - 0 | 15120 | $ - 0 | $ - 0 | 15422 | $ - 0 | $ - 0 | 15422 | $ - 0 | $ - 0 | 15422 | $ - 0 | $ - 0 | 15422 | $ - 0 | $ - 0 | 16116 | $ - 0 | $ - 0 | 16842 | $ - 0 | $ - 0 | 17600 | $ - 0 | $ - 0 | 17600 | $ - 0 | 159,366.0 | $ - 0 | ||||
| Engineering / Electronics Technician, Junior | Patucent River, MD | $ - 0 | 1920 | $ - 0 | $ - 0 | 2016 | $ - 0 | $ - 0 | 2056 | $ - 0 | $ - 0 | 2056 | $ - 0 | $ - 0 | 2056 | $ - 0 | $ - 0 | 2056 | $ - 0 | $ - 0 | 2149 | $ - 0 | $ - 0 | 2246 | $ - 0 | $ - 0 | 2347 | $ - 0 | $ - 0 | 2347 | $ - 0 | 21,249.0 | $ - 0 | ||||
| Engineering / Electronics Technician, Journeyman | Patucent River, MD | $ - 0 | 4800 | $ - 0 | $ - 0 | 5040 | $ - 0 | $ - 0 | 5141 | $ - 0 | $ - 0 | 5141 | $ - 0 | $ - 0 | 5141 | $ - 0 | $ - 0 | 5141 | $ - 0 | $ - 0 | 5372 | $ - 0 | $ - 0 | 5614 | $ - 0 | $ - 0 | 5867 | $ - 0 | $ - 0 | 5867 | $ - 0 | 53,124.0 | $ - 0 | ||||
| Engineering / Electronics Technician, Senior | Patucent River, MD | $ - 0 | 2880 | $ - 0 | $ - 0 | 3024 | $ - 0 | $ - 0 | 3084 | $ - 0 | $ - 0 | 3084 | $ - 0 | $ - 0 | 3084 | $ - 0 | $ - 0 | 3084 | $ - 0 | $ - 0 | 3223 | $ - 0 | $ - 0 | 3368 | $ - 0 | $ - 0 | 3520 | $ - 0 | $ - 0 | 3520 | $ - 0 | 31,871.0 | $ - 0 | ||||
| Multimedia Specialist, Junior | Patucent River, MD | $ - 0 | 768 | $ - 0 | $ - 0 | 806 | $ - 0 | $ - 0 | 823 | $ - 0 | $ - 0 | 823 | $ - 0 | $ - 0 | 823 | $ - 0 | $ - 0 | 823 | $ - 0 | $ - 0 | 860 | $ - 0 | $ - 0 | 898 | $ - 0 | $ - 0 | 939 | $ - 0 | $ - 0 | 939 | $ - 0 | 8,502.0 | $ - 0 | ||||
| Multimedia Specialist, Journeyman | Patucent River, MD | $ - 0 | 1920 | $ - 0 | $ - 0 | 2016 | $ - 0 | $ - 0 | 2056 | $ - 0 | $ - 0 | 2056 | $ - 0 | $ - 0 | 2056 | $ - 0 | $ - 0 | 2056 | $ - 0 | $ - 0 | 2149 | $ - 0 | $ - 0 | 2246 | $ - 0 | $ - 0 | 2347 | $ - 0 | $ - 0 | 2347 | $ - 0 | 21,249.0 | $ - 0 | ||||
| Multimedia Specialist, Senior | Patucent River, MD | $ - 0 | 1152 | $ - 0 | $ - 0 | 1210 | $ - 0 | $ - 0 | 1234 | $ - 0 | $ - 0 | 1234 | $ - 0 | $ - 0 | 1234 | $ - 0 | $ - 0 | 1234 | $ - 0 | $ - 0 | 1289 | $ - 0 | $ - 0 | 1347 | $ - 0 | $ - 0 | 1408 | $ - 0 | $ - 0 | 1408 | $ - 0 | 12,750.0 | $ - 0 | ||||
| Project or Management Analyst, Junior | Patucent River, MD | $ - 0 | 17664 | $ - 0 | $ - 0 | 18547 | $ - 0 | $ - 0 | 18918 | $ - 0 | $ - 0 | 18918 | $ - 0 | $ - 0 | 18918 | $ - 0 | $ - 0 | 18918 | $ - 0 | $ - 0 | 19769 | $ - 0 | $ - 0 | 20659 | $ - 0 | $ - 0 | 21589 | $ - 0 | $ - 0 | 21589 | $ - 0 | 195,489.0 | $ - 0 | ||||
| Project or Management Analyst, Journeyman | Patucent River, MD | $ - 0 | 44160 | $ - 0 | $ - 0 | 46368 | $ - 0 | $ - 0 | 47295 | $ - 0 | $ - 0 | 47295 | $ - 0 | $ - 0 | 47295 | $ - 0 | $ - 0 | 47295 | $ - 0 | $ - 0 | 49424 | $ - 0 | $ - 0 | 51648 | $ - 0 | $ - 0 | 53972 | $ - 0 | $ - 0 | 53972 | $ - 0 | 488,724.0 | $ - 0 | ||||
| Project or Management Analyst, Senior | Patucent River, MD | $ - 0 | 26496 | $ - 0 | $ - 0 | 27821 | $ - 0 | $ - 0 | 28377 | $ - 0 | $ - 0 | 28377 | $ - 0 | $ - 0 | 28377 | $ - 0 | $ - 0 | 28377 | $ - 0 | $ - 0 | 29654 | $ - 0 | $ - 0 | 30989 | $ - 0 | $ - 0 | 32383 | $ - 0 | $ - 0 | 32383 | $ - 0 | 293,234.0 | $ - 0 | ||||
| Technical Writer, Junior | Patucent River, MD | $ - 0 | 768 | $ - 0 | $ - 0 | 806 | $ - 0 | $ - 0 | 823 | $ - 0 | $ - 0 | 823 | $ - 0 | $ - 0 | 823 | $ - 0 | $ - 0 | 823 | $ - 0 | $ - 0 | 860 | $ - 0 | $ - 0 | 898 | $ - 0 | $ - 0 | 939 | $ - 0 | $ - 0 | 939 | $ - 0 | 8,502.0 | $ - 0 | ||||
| Technical Writer, Journeyman | Patucent River, MD | $ - 0 | 1920 | $ - 0 | $ - 0 | 2016 | $ - 0 | $ - 0 | 2056 | $ - 0 | $ - 0 | 2056 | $ - 0 | $ - 0 | 2056 | $ - 0 | $ - 0 | 2056 | $ - 0 | $ - 0 | 2149 | $ - 0 | $ - 0 | 2246 | $ - 0 | $ - 0 | 2347 | $ - 0 | $ - 0 | 2347 | $ - 0 | 21,249.0 | $ - 0 | ||||
| Technical Writer, Senior | Patucent River, MD | $ - 0 | 1152 | $ - 0 | $ - 0 | 1210 | $ - 0 | $ - 0 | 1234 | $ - 0 | $ - 0 | 1234 | $ - 0 | $ - 0 | 1234 | $ - 0 | $ - 0 | 1234 | $ - 0 | $ - 0 | 1289 | $ - 0 | $ - 0 | 1347 | $ - 0 | $ - 0 | 1408 | $ - 0 | $ - 0 | 1408 | $ - 0 | 12,750.0 | $ - 0 | ||||
| subtotal | 170880 | $ - 0 | 179424 | $ - 0 | 183011 | $ - 0 | 183011 | $ - 0 | 183011 | $ - 0 | 183011 | $ - 0 | 191248 | $ - 0 | 199855 | $ - 0 | 208852 | $ - 0 | 208852 | $ - 0 | 1,891,155.0 | $ - 0 |
| fringe fulltime | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 |
| fringe part time | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 |
| subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||
| Overhead | |||||||||||||||||||||||||||||||
| Contractor site | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 |
| Client site | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 |
| subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||
| G&A | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 |
| COM | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | 0.00% | $ - 0 | $ - 0 | $ - 0 |
| Subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||||||||||||
| Total Labor | $ - 0 |
| Fee/Profit | 0.0% | $ - 0 | $ - 0 | 0.0% | $ - 0 | $ - 0 | 0.0% | $ - 0 | $ - 0 | 0.0% | $ - 0 | $ - 0 | 0.0% | $ - 0 | $ - 0 | 0.0% | $ - 0 | $ - 0 | 0.0% | $ - 0 | $ - 0 | 0.0% | $ - 0 | $ - 0 | 0.0% | $ - 0 | $ - 0 | 0.0% | $ - 0 | $ - 0 | $ - 0 |
| Fee/Profit Pool | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Fee/Profit Pool | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| Total Labor and Cost Plus Fee/Profit | 170,880.0 | $ - 0 | 179,424.0 | $ - 0 | 183,011.0 | $ - 0 | 183,011.0 | $ - 0 | 183,011.0 | $ - 0 | 183,011.0 | $ - 0 | 191,248.0 | $ - 0 | 199,855.0 | $ - 0 | 208,852.0 | $ - 0 | 208,852.0 | $ - 0 | 1,891,155.0 | $ - 0 |
| Other Direct Costs | CLIN | XXXX-XXXX | CLIN | XXXX-XXXX | CLIN | XXXX-XXXX | CLIN | XXXX-XXXX | CLIN | XXXX-XXXX | CLIN | XXXX-XXXX | CLIN | XXXX-XXXX | CLIN | XXXX-XXXX | CLIN | XXXX-XXXX | CLIN | XXXX-XXXX | |
| Subtotal | Subtotal | Subtotal | Subtotal | Subtotal | Subtotal | Subtotal | Subtotal | Subtotal | Subtotal | Subtotal |
| ODCs | $ 560,000.00 | $ 576,800.00 | $ 588,336.00 | $ 600,102.72 | $ 618,105.80 | $ 630,467.92 | $ 643,077.28 | $ 662,369.59 | $ 675,616.99 | $ 689,129.33 | $ 6,244,005.63 | ||||||||||
| G&A on ODC | 0.00% | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | 0.00% | $ - 0 | $ - 0 |
| Total ODC | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Grand Total for Labor & ODCs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Attachment CA-2 Subcontractor Cost Breakout Spreadsheet (RFP #N00421-21-R-0112)
KTR:(insert name) Source Selection Information See: FAR 2.101 3.104
CPFF Total Labor Hours Proposed
| SUMMARY OF PRIME AND SUBCONTRACTOR LABOR HOURS AND CATEGORIES (CPFF) | ||||
| PRIME NAME | ||||
| Prime NAME Hours Proposed | Total Prime and Subcontractor Hours | Total Hours Required | Delta | |
| Administrative Assistant, Junior | 38247.00 | 38247.00 | 38247.00 | 0.00 |
| Administrative Assistant, Journeyman | 95619.00 | 95619.00 | 95619.00 | 0.00 |
| Administrative Assistant, Senior | 57372.00 | 57372.00 | 57372.00 | 0.00 |
| Engineer Scientist, Junior | 106246.00 | 106246.00 | 106246.00 | 0.00 |
| Engineer Scientist, Journeyman | 265612.00 | 265612.00 | 265612.00 | 0.00 |
| Engineer Scientist, Senior | 159366.00 | 159366.00 | 159366.00 | 0.00 |
| Engineering / Electronics Technician, Junior | 21249.00 | 21249.00 | 21249.00 | 0.00 |
| Engineering / Electronics Technician, Journeyman | 53124.00 | 53124.00 | 53124.00 | 0.00 |
| Engineering / Electronics Technician, Senior | 31871.00 | 31871.00 | 31871.00 | 0.00 |
| Multimedia Specialist, Junior | 8502.00 | 8502.00 | 8502.00 | 0.00 |
| Multimedia Specialist, Journeyman | 21249.00 | 21249.00 | 21249.00 | 0.00 |
| Multimedia Specialist, Senior | 12750.00 | 12750.00 | 12750.00 | 0.00 |
| Project or Management Analyst, Junior | 195489.00 | 195489.00 | 195489.00 | 0.00 |
| Project or Management Analyst, Journeyman | 488724.00 | 488724.00 | 488724.00 | 0.00 |
| Project or Management Analyst, Senior | 293234.00 | 293234.00 | 293234.00 | 0.00 |
| Technical Writer, Junior | 8502.00 | 8502.00 | 8502.00 | 0.00 |
| Technical Writer, Journeyman | 21249.00 | 21249.00 | 21249.00 | 0.00 |
| Technical Writer, Senior | 12750.00 | 12750.00 | 12750.00 | 0.00 |
| Total Hours (All Locations) | 1891155.00 | 1891155.00 | 1891155.00 | 0.00 |
Attachment CA-2 Subcontractor Cost Breakout Spreadsheet (RFP #N00421-21-R-0112)
KTR:(insert name) Source Selection Information See: FAR 2.101 3.104
Fully Burdened CPFF Labor Rates
| ATTACHMENT CA-1 | Individual Designator* | Proposed Fully Burdened Rates | |||||||||
| Proposed Labor Category | Base | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | |
| EXAMPLE TO BE DELETED: Administrative Assistant, Junior | FTE01 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Administrative Assistant, Junior | |||||||||||
| Administrative Assistant, Journeyman | |||||||||||
| Administrative Assistant, Senior | |||||||||||
| Engineer Scientist, Junior | |||||||||||
| Engineer Scientist, Journeyman | |||||||||||
| Engineer Scientist, Senior | |||||||||||
| Engineering / Electronics Technician, Junior | |||||||||||
| Engineering / Electronics Technician, Journeyman | |||||||||||
| Engineering / Electronics Technician, Senior | |||||||||||
| Multimedia Specialist, Junior | |||||||||||
| Multimedia Specialist, Journeyman | |||||||||||
| Multimedia Specialist, Senior | |||||||||||
| Project or Management Analyst, Junior | |||||||||||
| Project or Management Analyst, Journeyman | |||||||||||
| Project or Management Analyst, Senior | |||||||||||
| Technical Writer, Junior | |||||||||||
| Technical Writer, Journeyman | |||||||||||
| Technical Writer, Senior |
Attachment CA-2 Subcontractor Cost Breakout Spreadsheet (RFP #N00421-21-R-0112)
KTR:(insert name) Source Selection Information See: FAR 2.101 3.104
File details come from the government source that posted it. Updated .