Attachment_5-_Cost_Summary_Spreadsheet.xlsx

XLSX spreadsheet 35 KB Posted

Attached to
Non-Nuclear Touch Labor Services Bridge
Solicitation number
N3904018R0007
Issued by

About this file

Cost Summary Spreadsheet

View the file

Other files

Show all 17

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-17-R-0018 - 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
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 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!

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.
Marine Electrician
Firewatch
Marine Pipefitter
Marine Painter
Outside Marine Machinist
Marine Painter
Rigger
Shipwright
Welder
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.