Attachment J-S-1 - Price-Cost Template_Revised as of Amendment 0016.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- Common Display System (CDS) Sustainment, Installation, Procurement, and Engineering Services - N6339420R0013
- Solicitation number
- N6339420R0013
View the file
Other files
Show all 48
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 | Base Year | Year 1 | Year 2 | Year 3 | Year 4 | |||||||||||||||
| 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 through 0005: Engineering Services (CPFF) | ||||||||||||||||||||
| Prime Contractor Labor Cost | ||||||||||||||||||||
| Employee Name 1 | MANAGER, PROGRAM/PROJECT III (eCraft MANP3) | Engineering Manager 11-9041 | 50th percentile | 3184 | 1000 | 544 | 552 | 552 | 536 | |||||||||||
| Employee Name 2 | ANALYST, MANAGEMENT II (eCraft ANM2) | Management Analyst 13-1111 | 10th percentile | 6032 | 2040 | 992 | 1016 | 1016 | 968 | |||||||||||
| Employee Name 3 | LOGISTICIAN III (eCraft LGT3) | Logisticians 13-1081 | 50th percentile | 2380 | 460 | 480 | 480 | 480 | 480 | |||||||||||
| Employee Name 4 | ENGINEER, DESIGN IV (eCraft ED4) | Computer Hardware Engineer 17-2061 | 75th percentile | 8640 | 960 | 1920 | 1920 | 1920 | 1920 | |||||||||||
| Employee Name 5 | ENGINEER, SYSTEMS III (eCraft ESY3) | Computer Hardware Engineer 17-2061 | 50th percentile | 9600 | 1920 | 1920 | 1920 | 1920 | 1920 | |||||||||||
| Employee Name 6 | ENGINEER, ELECTRICAL/ELECTRONICS IV (eCraft EE4) | Electrical Engineer 17-2071 | 75th percentile | 9600 | 1920 | 1920 | 1920 | 1920 | 1920 | |||||||||||
| Employee Name 7 | ENGINEERING TECHNICIAN IV (eCraft 30084) | Mechanical Engineering Technicians 17-3027 | 75th percentile | 4800 | 960 | 960 | 960 | 960 | 960 | |||||||||||
| ENGINEERING TECHNICIAN V (eCraft 30085) | Software Developers and Software Quality Assurance Analysts and Testers 15-1256 | 90th percentile | 50880 | 4560 | 11520 | 11760 | 11760 | 11280 | ||||||||||||
| Employee Name 8 | ENGINEER, COMPUTER III (eCraft EC3) | Electrical and Electronic Engineering Technologists and Technicians 17-3023 | 50th percentile | 8160 | 480 | 1920 | 1920 | 1920 | 1920 | |||||||||||
| Employee Name 9 | ENGINEER IV (eCraft E4) | Electrical Engineer 17-2071 | 75th percentile | 4320 | 480 | 960 | 960 | 960 | 960 | |||||||||||
| Employee Name 10 | ENGINEER, MECHANICAL III (eCraft EM3) | Mechanical Engineer 17-2141 | 50th percentile | 12720 | 1080 | 2880 | 3000 | 3000 | 2760 | |||||||||||
| Employee Name 11 | MATERIAL COORDINATOR (eCraft 21030) | Electrical, Electronics, and Electromechanical Assemblers 51-2028 | 75th percentile | 8640 | 960 | 1920 | 1920 | 1920 | 1920 | |||||||||||
| Total Direct Labor Cost | 128,956 | 16,820 | 27,936 | 28,328 | 28,328 | 27,544 | ||||||||||||||
| 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 | ||||||||||||||||||||
| CLINs 0006 through 0155: Materials (FFP) | ||||||||||||||||||||
| Total Material Costs | ||||||||||||||||||||
| CLINs 0026 through 0030: Other Direct Costs (Cost Only) | $390,689.00 | |||||||||||||||||||
| Apply applicable burdens (cost only - no fee) | ||||||||||||||||||||
| Total ODCs | ||||||||||||||||||||
| CLIN 9998: Provisioned Items Order (Cost Only) | $21,018,273.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 .