Att_P5_Cost_Summary_Sheet_20211021.xls
XLS spreadsheet 131 KB Posted
- Attached to
- Solicitation: Administrative and Operational Contractor Support Services (CSS) Support Knowledge Based Services (KBS) Federal contract opportunity
- Solicitation number
- N0001922R0036
About this file
This document contains instructions and templates for a cost proposal submission in response to a solicitation from the Naval Air Systems Command for Administrative and Operational Contractor Support Services to the F-35 Joint Program Office.
The solicitation seeks proposals for program management support services across various directorates and integrated product teams within the F-35 JPO. Offerors must submit a cost proposal using the provided templates and instructions, including a cost summary spreadsheet with fully burdened labor rates for prime contractor and subcontractor personnel broken down by labor category, individual, BLS code, and year. Templates are also provided for a composite labor rate table showing average fully burdened rates by labor category and year, and a fixed fee table. Proposals are due in the first quarter of fiscal year 2022 under solicitation number N0001922R0036.
View the file
Other files for this federal contract opportunity
Show all 38
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
| COST SUMMARY SPREADSHEET | |||
| Detailed Cost Tab | Prime Fully Burdened Labor Tab | ||
| Instructions for Prime Contractor: | Instructions for Prime Contractor: | ||
| 1 | Enter Prime offeror name into cell B3. | 1 | Enter the Offeror (Prime's name or Subcontractor's name) in Column A "Offeror Name" (starting at row 4) to distinguish between the companies. If necessary, insert additional rows--but ensure integrity of formulas. |
| 2 | Enter all Prime employee names in Column A (starting at row 9). If proposing a prospective hire, please enter "Prospective Hire". If necessary, insert additional rows--but ensure integrity of formulas. | 2 | Enter the Proposed Labor Categories in Column B for both the Prime and all subs (starting at row 4). Spell and format each entry the same way every time it is used in the spreadsheet. |
| 3 | Assign each employee/prospective hire an individual designator (each person proposed should have their own number next to it in order to identify each employee/prospective hire by a number. There should not be any duplicates, even between the Prime and Subs) in Column B (starting at row 9). If necessary, insert additional rows--but ensure integrity of formulas. | 3 | Enter in Column C (starting at row 4) for each individual employee/prospective hire proposed, the corresponding Individual Designator as found on the "Detailed Cost" tab in Column B. |
| 4 | Enter the Government's BLS Codes in Column C (starting at row 9). Offerors shall type the Government BLS Codes exactly as they are found in the RFP. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of BLS Codes used. | 4 | Enter in Columns D-H (starting at row 4) 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. In order to avoid mathematical errors, the Offeror shall use formulas and functions to the maximum extent possible (linking to Cost Summary Spreadsheet Tab). If links are utilized, supply those referenced files. Enter numbers only, in U.S. Dollar format $###.## rounded to the nearest cent. Annual Fully-Burdened Labor shall include any applicable fringe, overhead, G&A, FCCM and fee on total prime labor, but should not include Other Direct Costs (ODCs) such as Materials and Travel including any burdens applied to them. Annual Fully-Burdened Labor shall be the Fully-Burdened Labor Rate multiplied by the amount of hours proposed for the applicable performance period. |
| 5 | Enter all Government labor categories in Column D (starting at row 9) that correspond with the BLS Codes listed in Column C. Offerors shall type the Government Labor Category name exactly as it is found in the RFP. If necessary, insert additional rows--but ensure integrity of formulas. | 5 | Enter in Columns I-M the Fully-Burdened Labor Rate per hour proposed for the applicable performance period (e.g. Base or Year_#) for personnel associated with the Proposed Labor Category and Individual Designator. In order to avoid mathematical errors, the Offeror shall use formulas and functions to the maximum extent possible (linking to Cost Summary Spreadsheet Tab). If links are utilized, supply those referenced files. The numbers shall be in U.S. Dollar format $###.## rounded to the nearest cent. Fully-Burdened Labor Rates shall include any applicable fringe, overhead, G&A, FCCM, and fee on total prime labor, but should not include Other Direct Costs (ODCs) such as Materials and Travel including any burdens applied to them. |
| 6 | Enter the proposed BLS Codes in Column E (starting at row 9). Please note, in order to obtain the most accurate BLS wage data, the BLS crosswalk is available at: https://www.bls.gov/soc/2018/crosswalks.htm . The crosswalk from the 2010 Standard Occupational Classification (SOC) to the 2018 SOC matches every detailed occupation from the 2010 SOC with the corresponding new 2018 SOC code(s) and title(s). | 6 | For each subcontractor in Columns D-M, the Prime Contractor shall insert the fully burdened annual labor/rate including any applicable pass-throughs, i.e. subcontractor handling and Prime fee on sub labor, if any. |
| 7 | Enter all Prime proposed labor categories in Column F (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In Column F, the Offeror should insert the title of the labor category it will be utilizing. The proposed labor categories shall correspond with the proposed BLS codes in Column E. Unless otherwise noted in the RFP, the Offeror is not required to utilize the Government's labor categories; however, each proposed labor category should appear opposite of the government labor category it is comparable to. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories. 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. | ||
| 8 | In column G, 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. | ||
| 9 | In column H, the Offeror shall insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in the Government Spaces. | ||
| 10 | Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly. | ||
| 11 | For each subcontractor, enter the subcontractor name, total hours, and total cost for each period of performance. | ||
| 12 | Please note if more subcontractors are needed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas. | ||
| 13 | The prime should insert the subcontractor handling charge, if any. | ||
| 14 | The prime should insert the fixed fee rate applied to its cost excluding subcontractor labor. | ||
| 15 | The prime should insert the fixed fee rate it is applying to the subcontractor labor, if any. | ||
| 16 | Under Other Direct Costs, the prime contractor should separate by Travel and Material as applicable. | ||
| 17 | Apply indirects to the Other Direct Costs, if applicable, and in compliance with the RFP instructions. | ||
| 18 | On the "Detailed Cost Summary" tab, break out all costs by CLIN. Ensure that the total costs of the CLINs match Section B and the total on the "Detailed Cost" tab. | ||
| 19 | Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor) | ||
| 20 | The 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. | ||
| 21 | All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations. | ||
| 22 | All dollar figures shall be carried out no further than two decimal places. | ||
| 23 | When submitting this file, the instructions may be deleted. | ||
| Instructions for Subcontractors: | |||
| 1 | Enter Prime offeror name into cell B3. | ||
| 2 | Replace "Prime Contractor" with "Subcontractor" in A7, A8, A13, and A20. | ||
| 3 | Enter all Subcontractor employee names in Column A (starting at row 9). If proposing a prospective hire, please enter "Prospective Hire". If necessary, insert additional rows--but ensure integrity of formulas. | ||
| 4 | Assign each employee/prospective hire an individual designator (each person proposed should have their own number next to it in order to identify each employee/prospective hire by a number. There should not be any duplicates, even between the Prime and Subs) in Column B (starting at row 9). If necessary, insert additional rows--but ensure integrity of formulas. | ||
| 5 | Enter the Government's BLS Codes in Column C (starting at row 9). Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of BLS Codes used. | ||
| 6 | Enter all Government labor categories in Column D (starting at row 9) that correspond with the BLS Codes listed in Column C. Offerors shall type the Government Labor Category name exactly as it is found in the RFP. If necessary, insert additional rows--but ensure integrity of formulas. | ||
| 7 | Enter the Proposed BLS Codes in Column E (starting at row 9). Please note, in order to obtain the most accurate BLS wage data, the BLS crosswalk is available at: https://www.bls.gov/soc/2018/crosswalks.htm . The crosswalk from the 2010 Standard Occupational Classification (SOC) to the 2018 SOC matches every detailed occupation from the 2010 SOC with the corresponding new 2018 SOC code(s) and title(s). | ||
| 8 | Enter all subcontractor labor categories in Column F (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column F, the Offeror should insert the title of the labor category it will be utilizing. The proposed labor categories shall correspond with the proposed BLS codes in Column E. Unless otherwise noted in the RFP, the Offeror is not required to utilize the Government's labor categories, however, each proposed labor category should appear opposite of the government labor category it is comparable to. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories. 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. | ||
| 9 | In column G, 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. | ||
| 10 | In column H, the Offeror shall insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in the Government Spaces. | ||
| 11 | Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordinly. | ||
| 12 | For subcontractor detailed cost sheets, delete Rows 22-48. | ||
| 13 | Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor) | ||
| 14 | The 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. | ||
| 15 | All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations. | ||
| 16 | All dollar figures shall be carried out no further than two decimal places. | ||
| 17 | When submitting this file, the instructions may be deleted. |
Detailed Cost
| DETAILED COST | ||||||||||||||||||||||||
| Prime Offeror Name: | ||||||||||||||||||||||||
| Subcontractor Name (if applicable): | ||||||||||||||||||||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total for All Periods | |||||||||||||||||||
| Cost Elements | Individual Designator # | Government BLS Code | Government Labor Category | Proposed BLS Code | Proposed Labor Category | F/P | Site | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Hours | Amount |
| Prime Contractor Labor Cost | ||||||||||||||||||||||||
| Prime Contractor Direct Labor | ||||||||||||||||||||||||
| Employee Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| Employee Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| Etc. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| Total Direct Labor Cost | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| Prime Contractor Indirect Labor Cost | ||||||||||||||||||||||||
| Overhead | ||||||||||||||||||||||||
| Fringe Benefits | ||||||||||||||||||||||||
| G&A | ||||||||||||||||||||||||
| Total Indirect Labor Cost | ||||||||||||||||||||||||
| Total Direct and Indirect Labor cost | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| COM | ||||||||||||||||||||||||
| Total Prime Contractor Labor Cost | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| Subcontractor Labor Cost | ||||||||||||||||||||||||
| Subcontractor proposed cost and fee | ||||||||||||||||||||||||
| Subcontractor 1 | ||||||||||||||||||||||||
| Subcontractor 2 | ||||||||||||||||||||||||
| Etc. | ||||||||||||||||||||||||
| Total proposed subcontractor labor cost and fee | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| Prime contractor pass through (not including fee) | ||||||||||||||||||||||||
| Handling | ||||||||||||||||||||||||
| G&A | ||||||||||||||||||||||||
| Other (if any) | ||||||||||||||||||||||||
| Total pass through (not including fee) | ||||||||||||||||||||||||
| Total Subcontractor Cost including pass through | 0 | |||||||||||||||||||||||
| Total Labor Cost (Prime and Subcontractor Labor) | ||||||||||||||||||||||||
| Fixed Fee | ||||||||||||||||||||||||
| Prime Contractor Fee for Prime Contractor Labor | ||||||||||||||||||||||||
| Prime Contractor Fee for Subcontractor Labor * | ||||||||||||||||||||||||
| Total Fee (for Prime and Subcontractor Labor) | ||||||||||||||||||||||||
| Total Labor Cost Plus Fixed Fee (CPFF) | 0 | |||||||||||||||||||||||
| Other Direct Costs | ||||||||||||||||||||||||
| Other Direct Costs (ODCs) | ||||||||||||||||||||||||
| Any adders to ODCs such as G&A (cost only - no fee) | ||||||||||||||||||||||||
| Total ODCs | ||||||||||||||||||||||||
| Total CPFF all CLINs (Labor and ODCs) | 0 |
Detailed Cost Summary
| DETAILED COST SUMMARY | |||||
| CLINS | CLIN Description | Total Hours | Total Cost | Total Fixed Fee | Total Value $ |
| X001 | |||||
| X002 | |||||
| Total |
Prime Fully Burdened Labor
| Prime Fully Burdened Labor (Annual and Rate) | ||||||||||||
| Offeror Name | Proposed Labor Category | Individual Designator | Proposed Annual Fully-Burdened Labor | Proposed Fully Burdened Labor Rate | ||||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||
| *Congressional Support Analyst, Senior | ||||||||||||
| Congressional Support Analyst, Mid | ||||||||||||
| Defense Travel System Analyst, Mid | ||||||||||||
| DTS Reviewer and Travel SME, Mid | ||||||||||||
| Facility Escort, Junior | ||||||||||||
| Facility Management Support Administrator, Mid | ||||||||||||
| Financial Analyst, Senior | ||||||||||||
| *FMS Human Resource Analyst, Senior | ||||||||||||
| FMS Human Resource Analyst, Senior | ||||||||||||
| *Human Resource Analyst, Senior | ||||||||||||
| Human Resource Analyst, Senior | ||||||||||||
| Human Resource Analyst, Mid | ||||||||||||
| *ID/IQ Program Manager, Senior | ||||||||||||
| Infrastructure Services Program Integrator, Mid | ||||||||||||
| Internal Communications Analyst, Mid | ||||||||||||
| Program Administrative Support, Junior | ||||||||||||
| Program Administrative Support, Mid | ||||||||||||
| Program Manager, Senior | ||||||||||||
| Public Affairs Analyst, Senior | ||||||||||||
| Strategic Communication Analyst, Mid | ||||||||||||
| Training Program Manager (JPO), Senior | ||||||||||||
| Labor Category (* = Labor Category with Key Employee (s)) |
Composite Rate
| Worksheet and Instructions to Prime Offeror for completing Table B-1 Estimated and Negotiated Compsite Labor Rate Table. | |||||
| N00019-22-R-0036 | |||||
| ESTIMATED AND NEGOTIATED COMPOSITE LABOR RATES | |||||
| (Regardless of Clearance or Location) | |||||
| Non-Performance Based (Level of Effort) | |||||
| Labor Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| *Congressional Support Analyst, Senior | |||||
| Congressional Support Analyst, Mid | |||||
| Defense Travel System Analyst, Mid | |||||
| DTS Reviewer and Travel SME, Mid | |||||
| Facility Escort, Junior | |||||
| Facility Management Support Administrator, Mid | |||||
| Financial Analyst, Senior | |||||
| *FMS Human Resource Analyst, Senior | |||||
| FMS Human Resource Analyst, Senior | |||||
| *Human Resource Analyst, Senior | |||||
| Human Resource Analyst, Senior | |||||
| Human Resource Analyst, Mid | |||||
| *ID/IQ Program Manager, Senior | |||||
| Infrastructure Services Program Integrator, Mid | |||||
| Internal Communications Analyst, Mid | |||||
| Program Administrative Support, Junior | |||||
| Program Administrative Support, Mid | |||||
| Program Manager, Senior | |||||
| Public Affairs Analyst, Senior | |||||
| Strategic Communication Analyst, Mid | |||||
| Training Program Manager (JPO), Senior | |||||
| *Denotes Key Labor Category | |||||
| INSTRUCTIONS: | |||||
| Column Heading | Description of Data Under this Column Heading | ||||
| Government Labor Category | The Government Labor Categories correlating to Section C of the Government solicitation. | ||||
| Composite Proposed Fully Burdened Rate, Years 1 - 5 | The average Fully Burdened Labor Rate per Hour is entered in the above table as proposed for each labor category during the applicable performance year (1-5) of the ordering period. Numbers only are entered, in U.S. dollar format ($###.##) rounded to the nearest cent. Fully Burdened Labor Rates shall include direct labor cost, fringe, overhead, G&A, subcontractor pass-through rate on total cost, exclusive of fee, and should not include Fully Burdened Other Direct Costs (ODCs) such as Materials, and Travel. This would be the total labor costs (the sum of both the prime and all subcontractors) costs for that labor category divided by the total number of labor hours for that category to arrive at the average (composite) Fully Burdened Labor Rate per Hour. |
Sheet2
| Worksheet and Instructions to Prime Offeror for completing H-2 Fixed Fee Table |
| N00019-22-R-0036 |
| FIXED FEE PER HOUR |
| Fixed Fee Rate Per Hour |
| Non-Performance Based (Level of Effort) |
| INSTRUCTIONS: |
| Enter the fee per hour based on the total fee proposed for all ordering periods divided by the total number of hours for all ordering periods. |
File details come from the government source that posted it. Updated .