Attachment_P6_-_CLIN_Breakout_Spreadsheet.xls

XLS spreadsheet 250 KB Posted

Attached to
7. 1. 5 NAVAIR Navy ERP Business Office Support Services
Solicitation number
N00421-14-R-0081
Issued by

About this file

Attachment P6 - CLIN Breakout Spreadsheet

View the file

Other files

File Type Posted
SOLICITATION_QUESTIONS_AND_ANSWERS.doc DOC document
N00421-14-R-0081_RFP_-_Amendment_3.doc DOC document
SOLICITATION_QUESTIONS_AND_ANSWERS.doc DOC document
N00421-14-R-0081_RFP_-_Amendment_2.doc DOC document
SOLICITATION_QUESTIONS_AND_ANSWERS.doc DOC document
N00421-14-R-0081_RFP_-_Amendment_1.doc DOC document
N00421-14-R-0081_RFP.doc DOC document
Attachment_6_-_Data_Item_Transmittal_Acceptance_Rejection_Form.doc DOC document
Attachment_E_-_Trip_Report.xls XLS spreadsheet
Attachment_P2_-_Workforce_Hour_Matrix.xls XLS spreadsheet
Attachment_D_-_Quarterly_Production_Interface_Schedule_Contact_List.xlsx XLSX spreadsheet
Attachment_G_-_Contractor_Support_Services_Work_Schedule.xlsx XLSX spreadsheet
Attachment_P4_-_Past_Performance_Matrix.doc DOC document
Attachment_5_-_Surveillance_Activity_Evaluation_Form.doc DOC document
Attachment_F_-_NBO_Non-Disclosure_Statement.doc DOC document
Attachment_C_-_Monthly_Progress_Status_Report.docx DOCX document
Attachment_P1_-_Workforce_Qualifications_Spreadsheet.xls XLS spreadsheet
Attachment_P3_-_CPARS_Update_Questionnaire.doc DOC document
Attachment_1_-_DD_Form_254_Contract_Security_Classification_Specification.pdf PDF
Attachment_B_-_Incurred_Cost_and_Progress_Reporting_for_Services.xlsx XLSX spreadsheet
Exhibit_A_-_Contract_Data_Requirements_List_(CDRLs_A001_-_A007).pdf PDF
N00421-14-R-0081_RFP.doc DOC document
Attachment_A_-_Cost_Report_(Labor _Travel _Material).xls XLS spreadsheet
Attachment_2_-_Minimum_Personnel_Requirements_and_Labor_Category_Qualifications.doc DOC document
Attachment_P7_-_Fully_Burdened_Labor_Rates.xls XLS spreadsheet
Attachment_P5_-_Past_Performance_Questionnaire.doc DOC document
Show all 26

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

Instructions

Instructions
(Please note that the cells referenced below correspond to the Cost Type sheet. The Fixed Price sheet is numbered slightly differently due to the absence of the Capacity Increase CLIN. For example, cell I417 on the Cost Type sheet is cell I409 on the Fixed Price sheet.)
Government:
AOn Footer Tab for the worksheet, insert the RFP number after the colon.
BInsert the Contract Line Item Numbers (CLINs) at Cells I2, K2, M2, O2, Q2, S2, U2, W2, Y2 and AA2 for the services and at I415, i425, K415, K425, M415, M425, O415,O425, Q415, Q425, S415, S425, U415, U425, W415, W425, Y415, Y425, AA415 and AA425 for ODCs.
CInsert the CLIN description at Cells I4, K4, M4, O4, Q4, S4, U4, W4, Y4 and AA4. It can be color of money such as APN, OM&N, RDT&E, etc; or it may be specific tasks areas or locations, depending on how the Performance Based Statement of Work is written. (Once these cells are filled in, they will automatically populate cells I417, I427,K417, K427, M417, M427, O417, O427, Q417, Q427, S417, S427, U417, U427, W417, W427, Y417, Y427, AA417, and AA427 with the same information.
DIn column A starting at row 5, insert the Government Labor Categories from the Historical Information being provided in the solicitation. List each category only once regardless of the number of estimated support hours. Once A5 through A40 are filled in, they will automatically populate the corresponding cells for the subcontractors 1 through 8.
EIf Capacity Increase CLIN (CIC) is not being utilized in the solicitation, change the "10%" in cells G407, G408, G409 and G436 to "zero" and hide the rows 406-410, 435 and 436. If utilized, CIC is to be used for all Cost Type CLINs for each period.
Contractor:
1On Header Tab for each worksheet, insert the proposal number. The file name should be automatically populated.
2On Footer Tab for the worksheet, insert the firm's name after colon. Insert the RFP number after the colon, if it has not been filled-in.
3A worksheet should be prepared for each period of performance. The tab should be renamed to match the period of performance. A SUMMARY SHEET OF ALL PERIODS NEEDS TO BE COMPLETED AS A SEPARATE TAB.
4Every worksheet should have items 1 through 3 completed.
5The 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.
6Within the work sheet any cell colored "blue" contains a formula and should not be edited.
7All dollar figures shall be carried out no further than two decimal places.
8The worksheet is arranged that the workforce being proposed for an entire period of performance is shown together, even though it will separated by individual CLINS in Section B. When the numbers are carried to Section B, they will be the same as shown on the worksheet.
9In Cell B2, enter the period of performance calendar dates. (ex: 1 Jan 09 - 31 Dec 09)
10In column A, starting at row 5 to 40, the Government Labor Categories from the Historical Information should have been inserted. In column B, the Offeror can insert the title of the labor category it will be utilizing. If it is comparable to one of the Government Labor Categories, then it should appear opposite that category. However, if it is not comparable, utilize the "not comparable" row. This applies to the Prime Contractor's section and those sections for its subcontractors. If necessary, insert additional rows--but ensure integrity of formulas. The Offeror is not required to utilize the Government's labor categories. However, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories. The Offeror does not insert any subcontractor information in this section. 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.
11In column C, the Offeror should insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in Government spaces.
12In column D, for the prime contractor's own workforce, the field is colored "green" indicating no input. (This reflects that the prime contractor is proposing its own employees or contingency hires--it does not include any subcontractors.) For the subcontractors, their fields are in yellow. No input is required by the Offeror in this column. Please note if more subcontractors are needed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas.
13In column E, for both the prime contractor's own workforce and that of the individual subcontractors' workforces, 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.
14In column F, enter the name of the proposed individual for that position.
15In column G:
(a) for the prime contractor, enter the unburdened labor rate for each individual (e.g. rows 5-44)
(b) In Cell G46 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.
(c) In Cell G47 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.
(d) In Cell G50, the prime contractor should insert its overhead rate for work performed at the contractor's facility.
(e) In Cell G51, the prime contractor should insert its overhead rate for work performed at the Client/Government's facility.
(f) In Cell G53, the prime contractor should insert its G&A rate being applied.
(g) for the subcontractor enter the fully burden cost including fixed fee associated with individual labor category for CLIN XX00 (e.g., rows 59-98, 101-140, 143-182, 185-224, 227-266, 269-308, 311-350, and 353-392)
(h) In Cell G395, the prime should insert the subcontractor handling charge, if any.
(i) In Cell G398, the prime should insert the fixed fee rate applied to its cost excluding subcontractor labor.
(j) In Cell G399, the prime should insert the fixed fee rate it is applying to the subcontractor labor, if any.
16In column H, and then similarly for Columns J, L, N, P, R, T, V, X and Z:
(a) for the prime contractor and the subcontractor enter the hours associated with individual labor category for CLIN XX00 (e.g., rows 5-44, 59-98, 101-140, 143-182, 185-224, 227-266, 269-308, 311-350, and 353-392). Also make sure you plug in the hours for columns J, L, N and so on.
(b) In Cell H46, 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.
(c) In Cell H47, 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.
(d) In Cell H50, the prime contractor should insert the "labor s base" its overhead rate is being applied to for work performed at the contractor's facility.
(e) In Cell H51, the prime contractor should insert the "labor base" its overhead rate is being applied to for work performed at the Client/Government's facility.
(f) In Cell H53, the prime contractor should insert the base its G&A rate is being applied to.
(g) In Cell H398, the prime should insert the prime labor base its fixed fee rate is being applied to (excluding subcontractor labor).
(h) In Cell H399, the prime should insert the subcontractor labor base its fixed fee rate is being applied to, if any.
(i) Under Other Direct Costs, the prime contractor should insert the Travel, Material and NMCI by CLIN.
17Insert the CLIN number for the specific period of performance as identified in Section B of the Solicitation in cells I2, K2, M2, O2, Q2, S2, U2, W2, Y2 and AA2 when creating the additional sheets for the option periods.
18Column AE automatically calculated the total hours for all the CLINS.
19Column AG is a summation of the costs.
20In cells I418, K418, M418, O418, Q418, S418, U418, W418, Y418, and AA418 enter the amount for travel
21In cells I419, K419, M419, O419, Q419, S419, U419, W419, Y419, and AA419 enter the amount for material.
22In cell G421 enter the rate for material handling if it is being applied to Travel and Material. If not applying a material handling, cell should be left blank.
23In cell G422 enter the rate for G&A if it is being applied to Travel and Material. If not applying a G&A rate, cell should be left blank.
24In cells I428, K428, M428, O428 Q428, S428, U428, W428, Y428, and AA428 enter the amount for NMCI
25In cell G430 enter the rate for material handling if it is being applied to Travel and Material.
26In cell G431 enter the rate for G&A if it is being applied to NMCI.
27If 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 (which are rows 142 through 393) would be hidden.
28When submitting this file, the instructions may be deleted.

Base Period Cost Type

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:04/01/2016 - 03/31/2017CLIN0001CLINXX02CLINXX03CLINXX04CLINXX05CLINXX06CLINXX07CLINXX08CLINXX09CLINXX10CLINXX11
ServicesContractorhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotalHrs
Government Labor CategoryProposed Categorysitesubf/pEmployee NameRateLABOR(description)(description)(description)(description)(description)(description)(description)(description)(description)(description)SUMTotal
Program Manager$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert I$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert II$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert III$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert IV$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Junior)$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Senior)$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrative Assistant$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrator, Intermediate$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Program Analyst$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
X$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
subtotal0$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
fringe fulltime0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
fringe part time0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OverheadBaseBaseBaseBaseBaseBaseBaseBaseBaseBaseBase
Contractor site0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Client site0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
COM0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor$ - 0
Subcontractors
Sub: 1:
Program Manager1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert I1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert II1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert III1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert IV1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Junior)1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Senior)1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrative Assistant1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrator, Intermediate1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Program Analyst1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
X1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable1$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 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$ - 0- 0$ - 0
Sub: 2:
Program Manager2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert I2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert II2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert III2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert IV2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Junior)2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Senior)2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrative Assistant2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrator, Intermediate2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Program Analyst2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
X2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable2$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 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$ - 0- 0$ - 0
Sub: 3
Program Manager3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert I3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert II3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert III3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert IV3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Junior)3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Senior)3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrative Assistant3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrator, Intermediate3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Program Analyst3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
X3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable3$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 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$ - 0- 0$ - 0
Sub: 4:
Program Manager4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert I4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert II4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert III4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert IV4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Junior)4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Senior)4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrative Assistant4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrator, Intermediate4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Program Analyst4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
X4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable4$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 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$ - 0- 0$ - 0
Sub: 5:
Program Manager5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert I5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert II5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert III5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert IV5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Junior)5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Senior)5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrative Assistant5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrator, Intermediate5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Program Analyst5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
X5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable5$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 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$ - 0- 0$ - 0
Sub: 6:
Program Manager6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert I6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert II6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert III6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert IV6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Junior)6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Senior)6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrative Assistant6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrator, Intermediate6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Program Analyst6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
X6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable6$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 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$ - 0- 0$ - 0
Sub: 7
Program Manager7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert I7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert II7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert III7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert IV7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Junior)7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Senior)7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrative Assistant7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrator, Intermediate7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Program Analyst7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
X7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable7$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 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$ - 0- 0$ - 0
Sub: 8:
Program Manager8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert I8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert II8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert III8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Subject Matter Expert IV8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Junior)8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Financial Analyst (Senior)8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrative Assistant8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Administrator, Intermediate8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
Program Analyst8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
X8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0- 0$ - 0
not comparable8$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 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$ - 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$ - 0- 0$ - 0
subcontractor handling0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit - prime0.0%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor0.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$ - 0
Total Cost$ - 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$ - 0
Total Labor and Subcontractor Cost Plus 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
Capacity Increase for Services
CIC Cost10%$ - 0
CIC Fixed Fee Pool10%$ - 0
CIC Total Cost Plus Fixed Fee10%hours0$ - 0
Grand Total Cost$ - 0
Grand Total Fixed Fee Pool$ - 0
Grand Total Labor and Subcontractor Cost Plus Fee/Profit$ - 0
hrs
Other Direct CostsCLIN0002CLINXX02CLINXX03CLINXX04CLINXX05CLINXX06CLINXX07CLINXX08CLINXX09CLINXX10CLINXX11
SubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotal
ODC(description)(description)(description)(description)(description)(description)(description)(description)(description)(description)Total
travel$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
material$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ODC subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
material handling0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A on ODC0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total ODC$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
NMCICLIN0003CLINXXXXCLINXXXXCLINXXXXCLINXXXXCLINXXXXCLINXXXXCLINXXXXCLINXXXXCLINXXXXCLINXXXX
SubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotal
DATA(description)(description)(description)(description)(description)(description)(description)(description)(description)(description)Total
NMCI$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
NMCI subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
material handling0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A on NMCI0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total ODC:NMCI$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0
Capacity Increase for ODCs
ODC CIC Cost10%`$ - 0
Grand Total ODCs$ - 0
Grand Total Services & ODCs$ - 0

&LAttachment_P6_CLIN_Breakout_Spreadsheet&R(insert proposal number) &A &LKTR:(insert name)&CSource Selection Information See: FAR 2.101 & 3.104&RRFP:N00421-14-R-0081 &L&F &R(insert proposal number) &A &LKTR:(insert name)&CSource Selection Information See: FAR 3.104&RRFP:N00024-09-R-3185

File details come from the government source that posted it. Updated .