Attachment CA-1 TEPL Prime Cost Breakout.xlsx

XLSX spreadsheet 69 KB Posted

Attached to
Programmatic, Flight Test Engineering, and Administrative Support to Naval Test Wing Atlantic Federal contract opportunity
Solicitation number
N0042121R0112
Issued by
Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

Written by GovTribe AI ·

This document provides a template for contractors to submit pricing proposals in response to solicitation number N0042121R0112 for programmatic, flight test engineering, and administrative support services to the Naval Test Wing Atlantic. The template requires contractors to provide fully burdened labor rates for all labor categories broken out by year, along with direct labor hours by category, indirect rates, fee percentages, and other direct costs. Contractors must complete spreadsheets showing direct labor rates, indirect costs, fee, and total proposed costs for prime and subcontractor labor. The solicitation seeks services for a one year base period and nine one-year options and utilizes cost-plus-fixed-fee pricing. Proposals are due by the date specified in the solicitation. The Naval Air Systems Command and Naval Air Warfare Center are the contracting agencies.

View the file

Other files for this federal contract opportunity

Other files attached to Programmatic, Flight Test Engineering, and Administrative Support to Naval Test Wing Atlantic, newest first.
File Type Posted
Final RFP Questions-Answers.pdf PDF
Question 12 - NTWL TEPL Customer_Labor Cat Est.pdf PDF
Amendment 01 to N0042121R0112.pdf PDF
Amendment 01 to Attachment 1 TEPL SOW.pdf PDF
Attachment 2 TEPL SAC.doc DOC document
N0042121R0112 Released.pdf PDF
Exhibit A CDRLS_TEPL FO.pdf PDF
Attachment 1 TEPL SOW.pdf PDF
Attachment 3 N0042121R0112BIDDD254signed.pdf PDF
Attachment P-1 Past Peformance Information Form.pdf PDF
Attachment CA-2 TEPL Subcontactor Cost Breakout.xlsx XLSX spreadsheet
Attachment P-2 CPAQ.pdf 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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions Instructions

Contractor:
1On Header Tab the attachment file name should be automatically populated.
2On Footer Tab for the worksheet, insert the firm's name after colon.
3Every worksheet should have items 1 and 2 completed.
4Within 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.
5All dollar figures shall be carried out no further than two decimal places.
6DO NOT add additional worksheets/tabs to this workbook. Any additional tabs will not be evaluated.
7All Direct rates must be entered per year and may only link to cells to show escalation.
8Do not change the color shading or add shading to this template. Follow the format and ensure consistency as needed.
9In column A, starting at row 5, the Government labor category is provided. The Prime shall begin to enter the rates proposed for each person addressing all labor categories. For each proposed subcontractor, the Prime shall fill in the subs proposed Government labor category under each proposed subcontractor's section, along with the rates proposed by the subcontractor. Replace "Sub 1", "Sub 2", and so on with the actual Subcontractor's name In COLUMN A ONLY. DO NOT DELETE UNUSED ROWS OR COLUMNS AS IT WILL IMPACT THE TOTAL COLUMNS AND ROWS. 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.
10Labor Categories shall remain in alphabetical order and like categories remain together within each offerors section. For example if the Prime 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.
11In 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.
12In column D, for the prime contractor's own workforce, the field is colored "green" indicating no input needed. (This reflects that the prime contractor is proposing its own employees, contingency hires-, or prospective hires - it does not include any subcontractors.) For the subcontractors, their fields are in yellow. Please note if more subcontractors are needed, the contractor may add additional Sections and rows to accommodate them, but ensure integrity of the formulas. Subcontractor positions should be listed within the individual subcontractor section ONLY. The top portion of the worksheets are for the Prime's workforce. Do not add subcontractor rows in the Prime section. The prime will complete the subcontractors fully burdened rates and hours, as necessary, within the subcontractors individual section with the subcontractors fully burdened rate less Prime pass through.
13In column E, for both the prime contractor's own workforce and that of the individual subcontractors' workforce, 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.
14In column F, enter the name of the proposed individual for that position.
15In column G:
16(a) for the prime contractor, enter the unburdened labor rate for each individual
17(b) In Cells G26,K26, O26,S26, W26, AA26, AE26, AI26, AM26, AQ26 the prime contractor should insert its fringe rate for full time, if it is not included in its 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 the prime contractor should insert its fringe rate for part-time, if it is not included in its 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 prime contractor 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 prime contractor 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 prime contractor should insert its indirect rate for the G&A rate being applied.
22(g) For all subcontractors, begining with G39,K39, O39,S39, W39, AA39, AE39, AI39, AM39, AQ39 the Prime shall enter the fully burdened labor rate, including the subcontractors fixed fee, associated with the individual proposed, per labor category, per labor CLIN
23(h) In Cells G71,K71, O71,S71, W71, AA71, AE71, AI71, AM71, AQ71, the prime should insert it's subcontractor handling charge, if any.
24(i) In Cells G74, K74, O74,S74, W74, AA74, AE74, AI74, AM74, AQ74, the Prime should insert the fixed fee rate applied to its cost excluding subcontractor labor.
25(j) In Cells G75, K75, O75,S75, W75, AA75, AE75, AI75, AM75, AQ75, the prime should insert the fixed fee rate it is applying to the subcontractor labor, if any.
26In column H, and then similarly for columns L, P, T, X AB, AF, AJ, AN, and AR:
27(a) for the prime contractor and the subcontractor enter the hours associated with individual labor category for CLIN XX00 (e.g., rows 5-23, 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 H26, L26, P26, T26, X26, AB26, AF26, AJ26, AN26, and AR26, the prime contractor 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 Prime contractor 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 Prime contractor 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 Prime contractor 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 Prime contractor should insert the base its G&A rate is being applied to.
33(g) In Cells H74, L74, P74, T74, X74, AB74, AF74, AJ74, AN74, and AR74, the Prime should insert the prime labor base its fixed fee rate is being applied to (excluding subcontractor labor).
34(h) In Cells H75, L75, P75, T75, X75, AB75, AF75, AJ75, AN75, and AR75, the Prime should insert the subcontractor labor base its fixed fee rate is being applied to, if any.
35(i) In Cells G86, K86, O86,S86, W86, AA86, AE86, AI86, AM86, AQ86, the Prime shall enter its G&A rate that will be used on ODC.
36Column "AU" automatically calculates the total hours for all the CLINS.
37Column"AW" is a summation of the costs.
38If there is not going to be any data entry in a row or group of rows, please just hide the rows. Do not delete. For example, if the Prime is only utilizing two subcontractors, then the rows concerning sub 3 through 8 would be hidden.
39When submitting this file, the instructions tab may be deleted.

1 The CPFF Total Labor Hours Proposed Tab should calculate automatically. If adding subcontractors or rows, ensure the integrity of ALL formulas on ALL TABS.

Fully Burdened CPFF Labor Rates Worksheet:
1In 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.
2In 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.
3In 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 a Prime 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-1 Prime 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 AREASBaseYear 1Year 2Year 3Year 4Year 5Year 5Year 6Year 7Year 8Year 5Year 9Year 5
CPFFCLINsXXXXCLINsXXXXCLINsXXXXCLINsXXXXCLINsXXXXCLINsXXXXCLINsXXXXCLINsXXXXCLINsXXXXCLINsXXXX
Services (Regular Labor)hrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrs
Government Labor CategoryLocationsitesubf/pEmployee NameRateLaborRateLaborRateLaborRateLaborRateLaborRateLaborRateLaborRateLaborRateLaborRateLaborSUMTotal
Administrative Assistant, JuniorPatuxent River, MD$ - 03456$ - 0$ - 03629$ - 0$ - 03701$ - 0$ - 03701$ - 0$ - 03701$ - 0$ - 03701$ - 0$ - 03868$ - 0$ - 04042$ - 0$ - 04224$ - 0$ - 04224$ - 038,247$ - 0
Administrative Assistant, JourneymanPatuxent River, MD$ - 08640$ - 0$ - 09072$ - 0$ - 09253$ - 0$ - 09253$ - 0$ - 09253$ - 0$ - 09253$ - 0$ - 09670$ - 0$ - 010105$ - 0$ - 010560$ - 0$ - 010560$ - 095,619$ - 0
Administrative Assistant, SeniorPatuxent River, MD$ - 05184$ - 0$ - 05443$ - 0$ - 05552$ - 0$ - 05552$ - 0$ - 05552$ - 0$ - 05552$ - 0$ - 05802$ - 0$ - 06063$ - 0$ - 06336$ - 0$ - 06336$ - 057,372$ - 0
Engineer Scientist, JuniorPatuxent River, MD$ - 09600$ - 0$ - 010080$ - 0$ - 010282$ - 0$ - 010282$ - 0$ - 010282$ - 0$ - 010282$ - 0$ - 010744$ - 0$ - 011228$ - 0$ - 011733$ - 0$ - 011733$ - 0106,246$ - 0
Engineer Scientist, JourneymanPatuxent River, MD$ - 024000$ - 0$ - 025200$ - 0$ - 025704$ - 0$ - 025704$ - 0$ - 025704$ - 0$ - 025704$ - 0$ - 026861$ - 0$ - 028069$ - 0$ - 029333$ - 0$ - 029333$ - 0265,612$ - 0
Engineer Scientist, SeniorPatuxent River, MD$ - 014400$ - 0$ - 015120$ - 0$ - 015422$ - 0$ - 015422$ - 0$ - 015422$ - 0$ - 015422$ - 0$ - 016116$ - 0$ - 016842$ - 0$ - 017600$ - 0$ - 017600$ - 0159,366$ - 0
Engineering / Electronics Technician, JuniorPatuxent River, MD$ - 01920$ - 0$ - 02016$ - 0$ - 02056$ - 0$ - 02056$ - 0$ - 02056$ - 0$ - 02056$ - 0$ - 02149$ - 0$ - 02246$ - 0$ - 02347$ - 0$ - 02347$ - 021,249$ - 0
Engineering / Electronics Technician, JourneymanPatuxent River, MD$ - 04800$ - 0$ - 05040$ - 0$ - 05141$ - 0$ - 05141$ - 0$ - 05141$ - 0$ - 05141$ - 0$ - 05372$ - 0$ - 05614$ - 0$ - 05867$ - 0$ - 05867$ - 053,124$ - 0
Engineering / Electronics Technician, SeniorPatuxent River, MD$ - 02880$ - 0$ - 03024$ - 0$ - 03084$ - 0$ - 03084$ - 0$ - 03084$ - 0$ - 03084$ - 0$ - 03223$ - 0$ - 03368$ - 0$ - 03520$ - 0$ - 03520$ - 031,871$ - 0
Multimedia Specialist, JuniorPatuxent River, MD$ - 0768$ - 0$ - 0806$ - 0$ - 0823$ - 0$ - 0823$ - 0$ - 0823$ - 0$ - 0823$ - 0$ - 0860$ - 0$ - 0898$ - 0$ - 0939$ - 0$ - 0939$ - 08,502$ - 0
Multimedia Specialist, JourneymanPatuxent River, MD$ - 01920$ - 0$ - 02016$ - 0$ - 02056$ - 0$ - 02056$ - 0$ - 02056$ - 0$ - 02056$ - 0$ - 02149$ - 0$ - 02246$ - 0$ - 02347$ - 0$ - 02347$ - 021,249$ - 0
Multimedia Specialist, SeniorPatuxent River, MD$ - 01152$ - 0$ - 01210$ - 0$ - 01234$ - 0$ - 01234$ - 0$ - 01234$ - 0$ - 01234$ - 0$ - 01289$ - 0$ - 01347$ - 0$ - 01408$ - 0$ - 01408$ - 012,750$ - 0
Program Analyst, JuniorPatuxent River, MD$ - 017664$ - 0$ - 018547$ - 0$ - 018918$ - 0$ - 018918$ - 0$ - 018918$ - 0$ - 018918$ - 0$ - 019769$ - 0$ - 020659$ - 0$ - 021589$ - 0$ - 021589$ - 0195,489$ - 0
Program Analyst, JourneymanPatuxent River, MD$ - 044160$ - 0$ - 046368$ - 0$ - 047295$ - 0$ - 047295$ - 0$ - 047295$ - 0$ - 047295$ - 0$ - 049424$ - 0$ - 051648$ - 0$ - 053972$ - 0$ - 053972$ - 0488,724$ - 0
Program Analyst, SeniorPatuxent River, MD$ - 026496$ - 0$ - 027821$ - 0$ - 028377$ - 0$ - 028377$ - 0$ - 028377$ - 0$ - 028377$ - 0$ - 029654$ - 0$ - 030989$ - 0$ - 032383$ - 0$ - 032383$ - 0293,234$ - 0
Program ManagerPatuxent River, MD$ - 0960$ - 0$ - 01008$ - 0$ - 01028$ - 0$ - 01028$ - 0$ - 01028$ - 0$ - 01028$ - 0$ - 01074$ - 0$ - 01123$ - 0$ - 01173$ - 0$ - 01173$ - 010,623
Technical Writer, JuniorPatuxent River, MD$ - 0768$ - 0$ - 0806$ - 0$ - 0823$ - 0$ - 0823$ - 0$ - 0823$ - 0$ - 0823$ - 0$ - 0860$ - 0$ - 0898$ - 0$ - 0939$ - 0$ - 0939$ - 08,502$ - 0
Technical Writer, JourneymanPatuxent River, MD$ - 01920$ - 0$ - 02016$ - 0$ - 02056$ - 0$ - 02056$ - 0$ - 02056$ - 0$ - 02056$ - 0$ - 02149$ - 0$ - 02246$ - 0$ - 02347$ - 0$ - 02347$ - 021,249$ - 0
Technical Writer, SeniorPatuxent River, MD$ - 01152$ - 0$ - 01210$ - 0$ - 01234$ - 0$ - 01234$ - 0$ - 01234$ - 0$ - 01234$ - 0$ - 01289$ - 0$ - 01347$ - 0$ - 01408$ - 0$ - 01408$ - 012,750$ - 0
subtotal171840$ - 0180432$ - 0184039$ - 0184039$ - 0184039$ - 0184039$ - 0192322$ - 0200978$ - 0210025$ - 0210025$ - 01,901,778$ - 0
fringe fulltime0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
fringe part time0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead
Contractor site0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
Client site0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
COM0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
Subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor$ - 0
Subcontractors
Sub: 1:
1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
sub total on Sub 1- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
Sub: 2:
2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
sub total on Sub 2- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
Sub: 3
3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
sub total on Sub 3- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
Sub: 4:
4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
sub total on Sub 4- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
Sub: 5:
5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
sub total on Sub 5- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
Sub: 6:$ - 0
6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
sub total on Sub 6- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
Sub: 7
7$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
7$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
sub total on Sub 7- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
Sub: 8:
8$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
8$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0- 0$ - 0
sub total on Sub 8- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
Total of all Subcontractors- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0$ - 0
subcontractor handling0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit - prime0.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$ - 0$ - 0
prime's fee/profit on subcontractor costs0.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$ - 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 Subcontractor Cost Plus Fee/Profit171,840.0$ - 0180,432.0$ - 0184,039.0$ - 0184,039.0$ - 0184,039.0$ - 0184,039.0$ - 0192,322.0$ - 0200,978.0$ - 0210,025.0$ - 0210,025.0$ - 01,901,778.0$ - 0
Other Direct CostsCLINXXXX-XXXXCLINXXXX-XXXXCLINXXXX-XXXXCLINXXXX-XXXXCLINXXXX-XXXXCLINXXXX-XXXXCLINXXXX-XXXXCLINXXXX-XXXXCLINXXXX-XXXXCLINXXXX-XXXX
SubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotal
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 ODC0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.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-1 Prime 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 NAME1.002.003.004.005.006.007.008.00
Prime NAME Hours ProposedSubcontractor #1 NAME Hours ProposedSubcontractor #2 NAME Hours ProposedSubcontractor #3 NAME Hours ProposedSubcontractor #4 NAME Hours ProposedSubcontractor #5 NAME Hours ProposedSubcontractor #6 NAME Hours ProposedSubcontractor #7 NAME Hours ProposedSubcontractor #8 NAME Hours ProposedTotal Prime and Subcontractor HoursTotal Hours RequiredDelta
Administrative Assistant, Junior38247.000.000.000.000.000.000.000.000.0038247.0038247.000.00
Administrative Assistant, Journeyman95619.000.000.000.000.000.000.000.000.0095619.0095619.000.00
Administrative Assistant, Senior57372.000.000.000.000.000.000.000.000.0057372.0057372.000.00
Engineer Scientist, Junior106246.000.000.000.000.000.000.000.000.00106246.00106246.000.00
Engineer Scientist, Journeyman265612.000.000.000.000.000.000.000.000.00265612.00265612.000.00
Engineer Scientist, Senior159366.000.000.000.000.000.000.000.000.00159366.00159366.000.00
Engineering / Electronics Technician, Junior21249.000.000.000.000.000.000.000.000.0021249.0021249.000.00
Engineering / Electronics Technician, Journeyman53124.000.000.000.000.000.000.000.000.0053124.0053124.000.00
Engineering / Electronics Technician, Senior31871.000.000.000.000.000.000.000.000.0031871.0031871.000.00
Multimedia Specialist, Junior8502.000.000.000.000.000.000.000.000.008502.008502.000.00
Multimedia Specialist, Journeyman21249.000.000.000.000.000.000.000.000.0021249.0021249.000.00
Multimedia Specialist, Senior12750.000.000.000.000.000.000.000.000.0012750.0012750.000.00
Program Analyst, Junior195489.000.000.000.000.000.000.000.000.00195489.00195489.000.00
Program Analyst, Journeyman488724.000.000.000.000.000.000.000.000.00488724.00488724.000.00
Program Analyst, Senior293234.000.000.000.000.000.000.000.000.00293234.00293234.000.00
Program Manager10623.000.000.000.000.000.000.000.000.0010623.0010623.000.00
Technical Writer, Junior8502.000.000.000.000.000.000.000.000.008502.008502.000.00
Technical Writer, Journeyman21249.000.000.000.000.000.000.000.000.0021249.0021249.000.00
Technical Writer, Senior12750.000.000.000.000.000.000.000.000.0012750.0012750.000.00
Total Hours (All Locations)1901778.000.000.000.000.000.000.000.000.001901778.001901778.000.00

Attachment CA-1 Prime 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-1Individual Designator*Proposed Fully Burdened Rates
Proposed Labor CategoryBaseYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9
EXAMPLE TO BE DELETED: Administrative Assistant, JuniorFTE01$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-1 Prime 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 .