The file's text, extracted by GovTribe without its formatting.
Cost_Price Summary
| SOLICITATION NO. N39040-17-R-0018 - ATTACHMENT 5 |
| COST SUMMARY FORMAT |
| Prime Offeror Name: | | | | | | | | | | | | | | | | | | | | |
| Subcontractor Name (if applicable): | | | | | | | | | | | | | | | | | | | | |
| DCAA Point of Contact Information: | | | Key | | | | | | | | | | | | | | | | | |
| | | Personnel | Total for All Years | | Base Period | | | Option Year 1 | | | Option Year 2 | | | Option Year 3 | | | Option Year 4 | | |
| Cost Elements | Labor Category | CLIN | Y / N | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount |
| Prime Contractor Labor Cost | | | | | | | | | | | | | | | | | | | | |
| Prime Contractor Direct Labor | | | | | | | | | | | | | | | | | | | | |
| Marine Electrician |
| Marine Electrician OT |
| Marine Electrician Supervisor |
| Firewatch |
| Firewatch OT |
| Firewatch Supervisor |
| Marine Pipefitter |
| Marine Pipefitter OT |
| Marine Pipefitter Supervisor |
| Marine Electrician Worker |
| Marine Electrician Worker OT |
| Marine Electrician Worker Supervisor |
| Industrial Fire Watch/Laborer |
| Industrial Fire Watch/Laborer OT |
| Industrial Fire Watch/Laborer Supervisor |
| Marine Pipefitter |
| Marine Pipefitter OT |
| Marine Pipefitter Supervisor |
| Outside Marine Machinist |
| Outside Marine Machinist OT |
| Outside Marine Machinist Supervisor |
| Marine Painter |
| Marine Painter OT |
| Marine Painter Supervisor |
| Weighthandler |
| Weighthandler OT |
| Weighthandler Supervisor |
| Marine Shipfitter |
| Marine Shipfitter OT |
| Marine Shipfitter Supervisor |
| Shipwright |
| Shipwright OT |
| Shipwright Supervisor |
| Welder |
| Welder OT |
| Welder Supervisor |
| Marine Insulator |
| Marine Insulator OT |
| Marine Insulator Supervisor |
| Abrasive Blaster |
| Abrasive Blaster OT |
| Abrasive Blaster Supervisor |
| Deck Tile Setter |
| Deck Tile Setter OT |
| Deck Tile Setter Supervisor |
| Sound Tile Setter |
| Sound Tile Setter OT |
| Sound Tile Setter Supervisor |
| Sheet Metal |
| Sheet Metal OT |
| Sheet Metal Supervisor |
| Management Rate (Identify Job Title) |
| Management Rate (Identify Job Title) |
| Management Rate (Identify Job Title) |
| Management Rate (Identify Job Title) |
| Management Rate (Identify Job Title) |
| Total Direct Labor Cost |
| Prime Contractor Indirect Labor Cost |
| Overhead |
| Fringe Benefits |
| G&A |
| Total Indirect Labor Cost |
| Total Direct and Indirect Labor cost |
| COM |
| Total Prime Contractor Labor Cost |
| Subcontractor Labor Cost |
| Subcontractor proposed cost and fee |
| Subcontractor 1 |
| Subcontractor 2 |
| Etc. |
| Subcontractor 1 Total Cost |
| Subcontractor 1 Total Fee |
| Subcontractor 1 TOTAL |
| Suncontractor 2 Total Cost |
| Subcontractor 2 Total Fee |
| Subcontractor 2 TOTAL |
| Total proposed subcontractor labor cost and fee |
| 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 Fee (for Prime and Subcontractor Labor) |
| Total Labor Cost Plus Fixed Fee (CPFF) |
| Total Labor Cost Plus Fees |
Total CPFF all CLINs (Labor and ODCs)
| Pass Through Analysis - Total for All Years | Amount | Percent |
| Subcontractor proposed cost and fee | | |
| Pass Through Amount (not including fee) | | |
| Prime Contractor Fee for Subcontractor Labor * | | |
| Total Pass Through Amount (including fee) | | ERROR:#DIV/0! |
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. |
| Marine Electrician | | | |
| Firewatch | | | |
| Marine Pipefitter | | | |
| Marine Painter | | | |
| Outside Marine Machinist | | | |
| Marine Painter | | | |
| Rigger | | | |
| Shipwright | | | |
| Welder | | | |
| 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 | | | |
Additional brief narrative in accordance with Section L, Supporting Cost Data.
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 |
| Training | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 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. |