Attach P4 - Cost Summary Spreadsheet.xls
XLS spreadsheet 93 KB Posted
- Solicitation number
- N0042120R0153
About this file
This document package includes a cost proposal template and instructions for a federal contract opportunity with the Naval Air Systems Command.
The cost proposal template provides instructions for offerors to complete cost spreadsheets detailing proposed labor categories, BLS codes, fully burdened labor rates, and other direct costs for the prime contractor and any subcontractors. It requires the contractor to break out costs by CLIN and year. The detailed cost tab separates costs for prime contractor labor, subcontractor labor, fixed fee, and other direct costs. The prime fully burdened labor tab lists proposed annual labor and hourly rates by individual, labor category, and performance period.
The related federal contract opportunity is solicitation number N0042120R0153 to provide liaison services between the Navy ERP Program Management Office, Naval Supply Systems Command Business Support Center, and NAVAIR Navy Enterprise Resource Planning Business Office. Services will include business solutions management, reporting and analysis, user management, and operational support. A large portion of effort will support Navy ERP modernization and migration to SAP S/4HANA. The requirement serves as a vehicle for NAVAIR Navy ERP expertise and issue resolution. The Naval Air Systems Command is the contracting agency.
View the file
Other files
Show all 15
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
| 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 2019 BLS Occupational Employment Statistics are available at: https://www.bls.gov/oes/current/oes_stru.htm. | 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 2019 BLS Occupational Employment Statistics are available at: https://www.bls.gov/oes/current/oes_stru.htm. | ||
| 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. |
&RN0042120R0153
Attachment P4
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 |
&RN0042120R0153
Attachment P4
Detailed Cost Summary
| DETAILED COST SUMMARY | |||||
| CLINS | CLIN Description | Total Hours | Total Cost | Total Fixed Fee | Total Value $ |
| X001 | |||||
| X002 | |||||
| Total |
&RN0042120R0153
Attachment P4
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 |
&RN0042120R0153
Attachment P4
File details come from the government source that posted it. Updated .