Attachment 5- Production Support Direct Rate Spreadsheet.xlsx

XLSX spreadsheet 32 KB Posted

Attached to
Touch Labor Production Support for Portsmouth Naval Shipyard
Solicitation number
N3904023R0008
Issued by

About this file

This document contains a cost summary template and supporting cost data for solicitation number N3904023R0008 for touch labor production support services at Portsmouth Naval Shipyard. The template requires offerors to provide pricing details for direct labor categories including shipfitters, welders, electricians, and other trades along with associated indirect rates for fringe benefits, overhead, and G&A. Offerors must also provide pricing for any proposed subcontractors. Supporting documentation is requested to justify direct labor rates and indirect rates. The Navy seeks these touch labor services through January 2028 with option periods to extend the contract through January 2032. Offerors must submit pricing using this template by the solicitation response date to be considered for award.

View the file

Other files

File Type Posted
Amendment0003_Discussion_Letter_Memo.docx DOCX document
Enclosure 3_Amendment_23R0008_U0003.pdf PDF
Attachment 24 - Final Questions Answer N39040-23-R-0008.docx DOCX document
Attachment 22 - Entry Regulations.pdf PDF
Amended Solicitation 2 N3904023R0008.pdf PDF
Final Solicitation N3904023R0008 Complete.pdf PDF
Attachment 23 - Amendment 2 - Questions Answer N39040-23-R-0008.docx DOCX document
Final Released Amended Solicitation 1 N3904023R0008.pdf PDF
Attachment 21 - N39040-23-R-0008 Answers to Industry Questions.docx DOCX document
Attachment 15 - Wage Determination.pdf PDF
Attachment 2 - DD254.doc DOC document
Attachment 13 - Contractor Employee Injury Report.pdf PDF
Attachment 16 - Wage Determination - San Diego.pdf PDF
Attachment 11 - Quality Assurance Surveillance Plan.pdf PDF
Attachment 7 - Past Performance Report Form.doc DOC document
Attachment 9 - Contractor Weekly Reporting Hours.xlsx XLSX spreadsheet
REVISED - CDRL A001 - CDRL A004.pdf PDF
Attachment 17 - Wage Determination - Groton.pdf PDF
Attachment 4 - List of Identity Proofing Documents.pdf PDF
Attachment 8 - Contracted Employee Timesheet.docx DOCX document
Attachment 12 - QASP Matrix.xlsx XLSX spreadsheet
Attachment 1 - Status Reporting Requirements.pdf PDF
Attachment 14 - DON Testing Designated Positions.pdf PDF
Attachment 6 - Past Performance Information Form.doc DOC document
REVISED CDRL A009 - CDRL A011.pdf PDF
Attachment 10 - Onboarding and Offboarding.xlsx XLSX spreadsheet
REVISED CDRL A005 - CDRL A008.pdf PDF
Attachment 3 - SECNAV 5512-1.pdf PDF
Final Solicitation N3904023R0008.pdf PDF
Show all 29

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

Cost_Price Summary

SOLICITATION NO. N39040-23-R-0008 - ATTACHMENT 5
COST SUMMARY FORMAT
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:Key
PersonnelTotal for All YearsBase PeriodOption Year 1Option Year 2Option Year 3Option Year 4
Cost ElementsLabor CategoryCLINY / NHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
Shipfitter
Shipfitter OT
Shipfitter Supervisor
Welder
Welder OT
Welder Supervisor
Fire Watch
Fire Watch OT
Fire Watch Supervisor
Outside Machinist
Outside Machinist OT
Outside Machinist Supervisor
Electrician
Electrician OT
Electrician Supervisor
Marine Pipefitter
Marine Pipefitter OT
Marine Pipefitter Supervisor
Shipwright
Shipwright OT
Shipwright Supervisor
Fabric Worker
Fabric Worker OT
Fabric Worker Supervisor
Painter
Painter OT
Painter Supervisor
Weight Handler
Weight Handler OT
Weight Handler Supervisor
Marine Insulator
Marine Insulator OT
Marine Insulator Supervisor
Avrasive Blaster
Abrasive Blaster OT
Abrasive Blaster Supervisor
Deck Tile
Deck Tile OT
Deck Tile Supervisor
Sound Tile
Sound Tile OT
Sound Tile 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
AmountPercent
Total CPFF all CLINs (Labor and ODCs)
Pass Through Analysis - Total for All Years
Subcontractor proposed cost and feeERROR:#DIV/0!
Pass Through Amount (not including fee)
Prime Contractor Fee for Subcontractor Labor *
Total Pass Through Amount (including fee)

Supporting Cost Data Summary

SUPPORTING COST DATA

Direct Labor:Actual Current Labor RateProposed Base Period Labor RateReason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCAA recommended rates, if known.
Shipfitter
Welder
Fire Watch
Outside Machinist
Electrician
Pipefitter
Shipwright
Fabric Worker
Painter
Weight Handler
Marine Insulator
Abrasive Blaster
Deck Tile
Sound Tile
Sheet Metal
Indirect Rates:Current RateProposed Base RateSubject 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

BudgetActual Expenses
Overhead Expense2011201020092008
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 ContractsExpiration DateValue of Contracts
N000XX-XX-X-00XX6/1/11
N000XX-XX-X-00XX9/1/12
N000XX-XX-X-00XX8/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 .