Attachment 1-Cost Summary Template.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
US Navy Submarine EDG Global Repair Services
Solicitation number
N6449820R4043
Issued by

View the file

Other files

File Type Posted
Attachment 5- DD Form 254.pdf PDF
CDRL A002 Travel Report.pdf PDF
CDRL A006 QMS Manual.pdf PDF
N64498-20-R-4043.pdf PDF
CDRL A001 Contract Status Report.pdf PDF
Attachment 2-Direct Labor Rate Substantiation.xls XLS spreadsheet
Attachment 4-Pre Award Survey of Prospective Contractor Accounting System Checklist.pdf PDF
Attachment 8- Commercial Provisions and Clauses.docx DOCX document
CDRL A004 Project Planning Chart.pdf PDF
Attachment 3- Section B.xlsx XLSX spreadsheet
Attachment 6-GFI NAVSEA 4340_02.pdf PDF
Attachment 7- Appendices A through F.docx DOCX document
CDRL A003 Contractor Personnel Roster.pdf PDF
CDRL A005 Technical Report.pdf PDF
Show all 14

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

T&M

SOLICITATION NO. N64498-20-R-4043 - ATTACHMENT 1
COST SUMMARY FORMAT- For T&M CLINS
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
Total for All YearsBase PeriodYear 1Year 2Year 3Year 4
Cost ElementsLabor CategoryHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
Employee Name 1
Employee Name 2
Etc.
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.
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 Time and Material (T&M)

Other Direct Costs
Other Direct Costs (ODCs)*$1,503,553.90
Any adders to ODCs such as G&A (This will become (subject to evaluation) the "Fixed Fee" for the whole contract)
Total ODCs
Total T&M all CLINs (Labor and ODCs)
*This is the NTE amount listed in CLIN 0003
Pass Through Analysis - Total for All YearsAmountPercent
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!
Fee Analysis - Total for All YearsAmountPercent
Prime Contractor Labor Cost
Fixed Fee for Labor Performed by Prime ContractorERROR:#DIV/0!

** When analyzing pass through costs, the Government will consider prime offeror fee on subcontractor price as an element of pass through. In Section B, however, prime offeror fee on subcontractor price is a fee element rather than a cost element. Prime offeror fee on subcontractor price should be included in the fee column (rather than the cost column) of Section B.

eCRAFT Fully Burdened Rates The contractor shall provide the Fully Burdened Bid Rates for all proposed personnel. The sum of the total dollars must reconcile to the 'Total Labor Time and Material (T&M)' for "All Years" as proposed in the Cost Summary Worksheet tab.

Column Descriptions are provided below: (All data provided below must be consistent with data contained in the Cost Summary Worksheet tab)
ECRAFT Labor Category Code: List eCRAFT labor category code, if known
Labor Category Description: List eCRAFT Labor Category Description
Employee Name: List employee name or "TBD" if unknown
Company: Prime Company Name or Subcontractor Company Name
Location and Pay Type: A location and pay type must be indicated for each labor category. For Straight time hours, location is indicated as either Contractor site (KR-SITE) or Government site (GOVT-SITE). For Overtime Hours, location is indicated as either Contrator Site (K-OT) or Government site (G-OT).
Hours: List the total hours for each labor category for the life of the contract
Average Fully Burdened Labor Rate: Defined as direct labor PLUS all applicable indirects PLUS fee encompassing the entire period of performance of the contract
Dollars: Hours TIMES Fully Burdened Labor Rate
Average Rate for All Years
eCRAFT Labor Category CodeeCRAFT Labor Category DescriptionEmployee NameCompanyLocation and Pay TypeHoursAverage Fully Burdened Labor RateDollars
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Total Labor Cost Plus Fixed Fee (CPFF)0$ - 0

File details come from the government source that posted it. Updated .