Attachment CA-2 TEPL Subcontactor Cost Breakout.xlsx
XLSX spreadsheet 54 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 provides instructions and templates for a cost proposal submission in response to solicitation N0042121R0112 for programmatic, flight test engineering, and administrative support services to the Naval Test Wing Atlantic. The templates require offerors to provide fully burdened labor rates for all labor categories broken out by year, along with direct labor hours by CLIN. Instructions specify how to populate rates for fringe, overhead, G&A, fee, and ODCs. The templates also include a summary of proposed labor hours by category. Offerors must follow the formatting and calculation instructions precisely and include any assumptions used to develop fully burdened rates in an attached spreadsheet.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Amendment 01 to N0042121R0112.pdf | ||
| Final RFP Questions-Answers.pdf | ||
| Question 12 - NTWL TEPL Customer_Labor Cat Est.pdf | ||
| Amendment 01 to Attachment 1 TEPL SOW.pdf | ||
| Attachment 2 TEPL SAC.doc | DOC document | |
| N0042121R0112 Released.pdf | ||
| Exhibit A CDRLS_TEPL FO.pdf | ||
| Attachment 1 TEPL SOW.pdf | ||
| Attachment 3 N0042121R0112BIDDD254signed.pdf | ||
| Attachment P-1 Past Peformance Information Form.pdf | ||
| Attachment CA-1 TEPL Prime Cost Breakout.xlsx | XLSX spreadsheet | |
| Attachment P-2 CPAQ.pdf |
Show all 12
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 G26,K26, O26,S26, W26, AA26, AE26, AI26, AM26, AQ26 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 G27,K27, O27,S27, W27, AA27, AE27, AI27, AM27, AQ27 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 G30, K30, O30,S30, W30, AA30, AE30, AI30, AM30, AQ30 the offeror should insert its overhead rate for work performed at the contractor's facility. |
| 20 | (e) In Cells G31, K31, O31,S31, W31, AA31, AE31, AI31, AM31, AQ31 the offeror should insert its overhead rate for work performed at the Client/Government's facility. |
| 21 | (f) In Cells G33, K33, O33,S33, W33, AA33, AE33, AI33, AM33, AQ33 the offeror should insert its indirect rate for the G&A rate being applied. |
| 24 | (g) In Cells G38, K38, O38,S38, W38, AA38, AE38, AI38, AM38, AQ38, 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-23). Also make sure you plug in the hours for columns L, P, T, X AB, AF, AJ, AN, and AR. |
| 28 | (b) In Cells H26, L26, P26, T26, X26, AB26, AF26, AJ26, AN26, and AR26, 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 H27, L27, P27, T27, X27, AB27, AF27, AJ27, AN27, and AR27, 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 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 contractor's facility. |
| 31 | (e) In Cells H31, L31, P31, T31, X31, AB31, AF31, AJ31, AN31, and AR31, 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 H33, L33, P33, T33, X33, AB33, AF33, AJ33, AN33, and AR33, the Offerors should insert the base its G&A rate is being applied to. |
| 33 | (g) In Cells H38, L38, P38, T38, X38, AB38, AF38, AJ38, AN38, and AR38, insert the Offeors labor base its fixed fee rate is being applied to. |
| 35 | (i) In Cells G49, K49, O49,S49, W49, AA49, AE49, AI49, AM49, AQ49, 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 | Patuxent 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 | Patuxent 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 | Patuxent 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 | Patuxent 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 | Patuxent 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 | Patuxent 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 | Patuxent 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 | Patuxent 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 | Patuxent 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 | Patuxent 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 | Patuxent 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 | Patuxent 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 | ||||
| Program Analyst, Junior | Patuxent 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 | ||||
| Program Analyst, Journeyman | Patuxent 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 | ||||
| Program Analyst, Senior | Patuxent 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 | ||||
| Program Manager | Patuxent River, MD | $ - 0 | 960 | $ - 0 | $ - 0 | 1008 | $ - 0 | $ - 0 | 1028 | $ - 0 | $ - 0 | 1028 | $ - 0 | $ - 0 | 1028 | $ - 0 | $ - 0 | 1028 | $ - 0 | $ - 0 | 1074 | $ - 0 | $ - 0 | 1123 | $ - 0 | $ - 0 | 1173 | $ - 0 | $ - 0 | 1173 | $ - 0 | 10,623.0 | |||||
| Technical Writer, Junior | Patuxent 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 | Patuxent 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 | Patuxent 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 | 171840 | $ - 0 | 180432 | $ - 0 | 184039 | $ - 0 | 184039 | $ - 0 | 184039 | $ - 0 | 184039 | $ - 0 | 192322 | $ - 0 | 200978 | $ - 0 | 210025 | $ - 0 | 210025 | $ - 0 | 1,901,778.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 | 171,840.0 | $ - 0 | 180,432.0 | $ - 0 | 184,039.0 | $ - 0 | 184,039.0 | $ - 0 | 184,039.0 | $ - 0 | 184,039.0 | $ - 0 | 192,322.0 | $ - 0 | 200,978.0 | $ - 0 | 210,025.0 | $ - 0 | 210,025.0 | $ - 0 | 1,901,778.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 |
| Program Analyst, Junior | 195489.00 | 195489.00 | 195489.00 | 0.00 |
| Program Analyst, Journeyman | 488724.00 | 488724.00 | 488724.00 | 0.00 |
| Program Analyst, Senior | 293234.00 | 293234.00 | 293234.00 | 0.00 |
| Program Manager | 10623.00 | 10623.00 | 10623.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) | 1901778.00 | 1901778.00 | 1901778.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 | |||||||||||
| Program Analyst, Junior | |||||||||||
| Program Analyst, Journeyman | |||||||||||
| Program Analyst, Senior | |||||||||||
| Program Manager | |||||||||||
| 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 .