Attachment J-S-1 - Price-Cost Template.xlsx
XLSX spreadsheet 23 KB Posted
- Solicitation number
- N6339420R0008
About this file
This document contains a price-cost template and supporting cost data for a solicitation seeking engineering services, installations, materials procurement, and other direct costs to support sustainment of TI16 equipment. Naval Surface Warfare Center Port Hueneme Division is soliciting proposals for limited manufacturing, assembly, testing, engineering services, procurement, installation of ordnance alteration kits, and related products. Offerors are to provide labor rates and supporting indirect cost data using the template included, with any differences from actual or recommended rates explained. Questions regarding the solicitation are due within 15 days of issuance.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| N6339420R0008_TI16_QandA_5.xlsx | XLSX spreadsheet | |
| N6339420R0008_Amendment 0005 (Modification Copy).pdf | ||
| N6339420R0008_Amendment 0004 (Conformed Copy).pdf | ||
| N6339420R0008_TI16_QandA_4.xlsx | XLSX spreadsheet | |
| N6339420R0008_Amendment 0004 (Modification Copy).pdf | ||
| Attachment J-S-1 - Price-Cost Template_Revision 2.xlsx | XLSX spreadsheet | |
| N6339420R0008_TI16_QandA_3.xlsx | XLSX spreadsheet | |
| N6339420R0008_Amendment 0003 (Modification Copy).pdf | ||
| N6339420R0008-0002 (Conformed Copy).pdf | ||
| N6339420R0008_TI16_QandA_2.xlsx | XLSX spreadsheet | |
| Attachment J-S-1 - Price-Cost Template_Revision 1.xlsx | XLSX spreadsheet | |
| N6339420R0008-0002 (Modification Copy).pdf | ||
| N6339420R0008_Amendment 0001.pdf | ||
| N6339420R0008_TI16_QandA_1.xlsx | XLSX spreadsheet | |
| N6339420R0008.pdf | ||
| Attachment J-2 - DD254.pdf | ||
| Attachment J-1 - CDRLS.pdf | ||
| Attachment J-S-2 - Pre-Award Survey.docx | DOCX document | |
| Attachment J-4 - Service Contract Act (SCA) Wage Determination.pdf |
Show all 19
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
CPFF Cost Summary
| Prime Offeror Name: | ||||||||||||||||||||
| Subcontractor Name (if applicable): | ||||||||||||||||||||
| DCAA Point of Contact Information: | ||||||||||||||||||||
| Total for All Years | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||||||||
| Cost Elements | Labor Category | BLS Code | BLS Percentile | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount |
| CLIN 0001: Engineering Services (CPFF) | ||||||||||||||||||||
| Prime Contractor Labor Cost | ||||||||||||||||||||
| Employee Name 1 | MANAGER, PROGRAM/PROJECT III (eCraft MANP3) | Engineering Manager 11-9041 | 50th percentile | 2880 | 960 | 480 | 480 | 480 | 480 | |||||||||||
| Employee Name 2 | ANALYST, MANAGEMENT II (eCraft ANM2) | Management Analyst 13-1110 | 25th percentile | 2880 | 960 | 480 | 480 | 480 | 480 | |||||||||||
| Employee Name 3 | ANALYST, MANAGEMENT II (eCraft ANM2) | Management Analyst 13-1111 | 25th percentile | 2240 | 960 | 320 | 320 | 320 | 320 | |||||||||||
| Employee Name 4 | LOGISTICIAN III (eCraft LGT3) | Logisticians 13-1080 | 50th percentile | 7200 | 1440 | 1440 | 1440 | 1440 | 1440 | |||||||||||
| Employee Name 5 | ENGINEER, DESIGN IV (eCraft ED4) | Computer Hardware Engineer 17-2061 | 75th percentile | 17280 | 1920 | 3840 | 3840 | 3840 | 3840 | |||||||||||
| Employee Name 6 | ENGINEER, SYSTEMS III (eCraft ESY3) | Electrical Engineer 17-2070 | 50th percentile | 19200 | 3840 | 3840 | 3840 | 3840 | 3840 | |||||||||||
| Employee Name 7 | ENGINEER, ELECTRICAL/ELECTRONICS IV (eCraft EE4) | Electrical Engineer 17-2071 | 75th percentile | 19200 | 3840 | 3840 | 3840 | 3840 | 3840 | |||||||||||
| Employee Name 8 | ENGINEERING TECHNICIAN V (eCraft 30085) | Engineering Technician 17-3020 | 90th percentile | 26880 | 3840 | 5760 | 5760 | 5760 | 5760 | |||||||||||
| Employee Name 9 | ENGINEER, COMPUTER III (eCraft EC3) | SW Developer 15-1133 | 50th percentile | 16320 | 960 | 3840 | 3840 | 3840 | 3840 | |||||||||||
| Employee Name 10 | ENGINEER IV (eCraft E4) | Electrical Engineer 17-2071 | 75th percentile | 8640 | 960 | 1920 | 1920 | 1920 | 1920 | |||||||||||
| Employee Name 11 | ENGINEER, MECHANICAL III (eCraft EM3) | Mechanical Engineer 17-2141 | 50th percentile | 8160 | 480 | 1920 | 1920 | 1920 | 1920 | |||||||||||
| Employee Name 12 | ENGINEERING TECHNICIAN V (eCraft 30085) | Aerospace Engineering and Operations Technician 17-3021 | 90th percentile | 8160 | 480 | 1920 | 1920 | 1920 | 1920 | |||||||||||
| Employee Name 13 | ENGINEERING TECHNICIAN V (eCraft 30085) | Electrical and Electronics Engineering Technicians 17-3023 | 90th percentile | 8640 | 960 | 1920 | 1920 | 1920 | 1920 | |||||||||||
| Employee Name 14 | MATERIAL COORDINATOR (eCraft 21030) | Electrical, Electronics, and Electromechanical Assemblers 51-2020 | 25th percentile | 8640 | 960 | 1920 | 1920 | 1920 | 1920 | |||||||||||
| Employee Name 15 | ENGINEERING TECHNICIAN IV (eCraft 30084) | Mechanical Engineering Technicians 17-3027 | 75th percentile | 9600 | 1920 | 1920 | 1920 | 1920 | 1920 | |||||||||||
| Total Direct Labor Cost | 165,920 | 24,480 | 35,360 | 35,360 | 35,360 | 35,360 | ||||||||||||||
| Prime Contractor Indirect Cost Applied to Labor | ||||||||||||||||||||
| Overhead | ||||||||||||||||||||
| Fringe Benefits | ||||||||||||||||||||
| G&A | ||||||||||||||||||||
| Total Indirect Cost on Labor | ||||||||||||||||||||
| Total Direct and Indirect Cost | ||||||||||||||||||||
| FCCOM | ||||||||||||||||||||
| Total Prime Contractor Labor Cost | ||||||||||||||||||||
| Subcontractor Labor Cost | ||||||||||||||||||||
| Subcontractor 1 | ||||||||||||||||||||
| Subcontractor 2 | ||||||||||||||||||||
| Etc. | ||||||||||||||||||||
| Total Subcontract Costs | ||||||||||||||||||||
| 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 | ||||||||||||||||||||
| Total Labor Cost (Prime and Subcontractor Labor) | ||||||||||||||||||||
| Fixed Fee | ||||||||||||||||||||
| Prime Contractor Fee for Prime Contractor Labor | ||||||||||||||||||||
| Prime Contractor Fee for Subcontractor Labor * | ||||||||||||||||||||
| Total Fixed Fee (for Prime and Subcontractor Labor) | ||||||||||||||||||||
| Total Labor Cost Plus Fixed Fee | ||||||||||||||||||||
| CLIN 0002: Installations (FFP) | $2,789,054.00 | |||||||||||||||||||
| Apply applicable burdens and profit | ||||||||||||||||||||
| Total Installation Costs | ||||||||||||||||||||
| CLIN 0003: Materials (FFP) | $137,953,212.00 | |||||||||||||||||||
| Apply applicable burdens and profit | ||||||||||||||||||||
| Total Material Costs | ||||||||||||||||||||
| CLIN 0004: Other Direct Costs (Cost Only) | $449,324.00 | |||||||||||||||||||
| Apply applicable burdens (cost only - no fee) | ||||||||||||||||||||
| Total ODCs | ||||||||||||||||||||
| CLIN 0005: Materials in support of Engineering Services (Cost Only) | $10,532,839.00 | |||||||||||||||||||
| Apply applicable burdens (cost only - no fee) | ||||||||||||||||||||
| Total Materials in support of Engineering Services | ||||||||||||||||||||
| Total CPFF, FFP, and COST of all CLINs (Labor and ODCs) |
Supporting Cost Data Summary
SUPPORTING COST DATA
| Direct Labor: | Actual Current Labor Rate | Proposed Base Period Labor Rate | Reason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCAA recommended rates, if known. |
| Employee Name | $ | $ | |
| Employee Name | $ | $ | |
| Employee Name | $ | $ |
| Indirect Rates: | Current Rate | Proposed Base Rate | Subject to FPRA? (Yes/No) Reason for difference between current rates and proposed rates. Reason for difference between proposed rates and DCAA recommended rates, if known. |
| Fringe | |||
| Overhead | |||
| G&A | |||
| Other |
Indirect Rate Support Sample Indirect Rate Supporting Documentation
| Budget | Actual Expenses | |||
| Overhead Expense | 2011 | 2010 | 2009 | 2008 |
| Payroll Taxes | $ 110,000 | $ 93,000 | $ 90,000 | $ 85,000 |
| Vacation | $ 50,000 | $ 46,000 | $ 43,000 | $ 42,000 |
| Holiday | $ 40,000 | $ 40,000 | $ 39,000 | $ 38,500 |
| Sick Leave | $ 10,000 | $ 9,000 | $ 8,000 | $ 7,000 |
| Pensions | $ 200,000 | $ 175,000 | $ 165,000 | $ 155,000 |
| Office Equipment | $ 5,000 | $ 6,000 | $ 65,000 | $ 3,000 |
| Depreciation | $ 4,000 | $ 1,000 | $ 4,000 | $ 2,000 |
| Travel | $ 40,000 | $ 35,000 | $ 33,000 | $ 33,000 |
| Reproduction | $ 10,000 | $ 9,800 | $ 9,700 | $ 9,600 |
| Rent | $ 130,000 | $ 82,000 | $ 75,000 | $ 68,000 |
| Advertising | $ 55,000 | $ 44,000 | $ 50,000 | $ 42,000 |
| Insurance | $ 48,000 | $ 46,000 | $ 44,000 | $ 42,000 |
| Telephone | $ 12,000 | $ 12,000 | $ 11,500 | $ 10,000 |
| Total Pool | $ 714,000 | $ 598,800 | $ 637,200 | $ 537,100 |
| Less Unallowable Costs | ||||
| Entertainment | $ 6,000 | $ 4,000 | $ 1,000 | $ 3,000 |
| Net Allowable Costs | $ 708,000 | $ 594,800 | $ 636,200 | $ 534,100 |
| Allocation Base | ||||
| Direct Labor | $ 1,895,500 | $ 1,756,200 | $ 1,650,000 | $ 1,530,000 |
Overhead Rate 37.35% 33.87% 38.56% 34.91%
| *Contributing Government Contracts | Expiration Date | Value of Contracts |
| N000XX-XX-X-00XX | 6/1/11 | |
| N000XX-XX-X-00XX | 9/1/12 | |
| N000XX-XX-X-00XX | 8/1/10 |
| * When developing your percentage, these are the contracts contributing |
| to development of the percentage. |
File details come from the government source that posted it. Updated .