N32253-15-R-0005_Attachment_5_-_Cost_Summary_Format_Workbook.xlsx

XLSX spreadsheet 42 KB Posted Mar 25, 2016

Attached to: Touch Labor Support Federal contract opportunity
Solicitation number: N32253-15-R-0005
Issued by: Department of the Navy Naval Sea Systems Command

About this file

From the source

Solicitation Attachment 5

View the file

Other files for this federal contract opportunity

Other files attached to Touch Labor Support, newest first.
File	Type	Posted
N32253-15-R-0005-0003.pdf	PDF	Apr 13, 2016
pdp32705.docx	DOCX document	Apr 8, 2016
N32252-15-R-0005-0001.docx	DOCX document	Apr 5, 2016
N32253-15-R-0005.docx	DOCX document	Mar 25, 2016
N32253-15-R-0005_Attachment_7_PAST_PERFORMANCE_INFORMATION_FORM.doc	DOC document	Mar 25, 2016
N32253-15-R-0005_Attachment_13-19_099-01_thru_07_2010_with_FOUO_pages_removed.pdf	PDF	Mar 25, 2016
N32253-15-R-0005_Attachment_4_STATUS_REPORT_REQUIREMENTS.docx	DOCX document	Mar 25, 2016
N32253-15-R-0005_Attachment_9_Environmental_Guide_for_Ktr_on_Ship_Projects.pdf	PDF	Mar 25, 2016
N32253-15-R-0005_Attachment_6_Past_Performance_Report_Form.doc	DOC document	Mar 25, 2016
N32253-15-R-0005_Attachment_2_Preaward_Survey.pdf	PDF	Mar 25, 2016
N32253-15-R-0005_Attachment_3_Trade_Estimate.docx	DOCX document	Mar 25, 2016
N32253-15-R-0005_Attachment_10_OSHCTRMOA.doc	DOC document	Mar 25, 2016
N32253-15-R-0005.docx	DOCX document	Mar 25, 2016
N32253-15-R-0005_Attachment_8_-_DCAA_Rate_Check_Form.xls	XLS spreadsheet	Mar 25, 2016
N32253-15-R-0005_Attachment_1_DD254.pdf	PDF	Mar 25, 2016
N32253-15-R-0005_Attachment_11_099-010PH_RMMCO_Check-In_v01_2014_updates.pdf	PDF	Mar 25, 2016
Touch_Labor_IDIQ.pdf	PDF	Feb 24, 2016
Touch_Labor__PERFORMANCE_WORK_STATEMENT_(DRAFT).pdf	PDF	Feb 11, 2016
Trade_Estimate.docx	DOCX document	Jan 27, 2016
Security_Addendum_(Rev_Oct_2013).pdf	PDF	Jan 27, 2016
Safety_Addendum_(Rev_Mar_2013).pdf	PDF	Jan 27, 2016
Nuclear_Addendum_(Rev_Nov_2011).pdf	PDF	Jan 27, 2016
Touch_Labor__PERFORMANCE_WORK_STATEMENT_(DRAFT)_(3).pdf	PDF	Jan 27, 2016

Show all 23

On GovTribe

Work with this file on GovTribe

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.

Cost Summary

SOLICITATION NO. ______________ - ATTACHMENT 5

COST SUMMARY FORMAT

Prime Offeror Name:

Subcontractor Name (if applicable):

Element of Cost Reference Total Amount Base Period Option Year 1 Option Year 2

Direct Labor Sched. 1

Direct Labor Overhead Sched. 2

Other Direct Costs (ODC) Sched. 3

Subtotal

G&A (Total Cost Input) Sched. 4

Total Estimated Cost

Fee @ x%

Cost of Money (if applicable) Sched. 5

Total Price

NOTE - Suggested Guidance to assist contractors in understanding Cost Type Price Proposals may be found in "INFORMATION FOR CONTRACTORS"

Located at http://www.dcaa.mil/guidance.html

Sched. 1 Direct Labor

Sample Labor Cost Summary

Prime Offeror Name

	Total for All Years		Base Period			Option Year 1
Cost Elements	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount
Prime Contractor Labor Cost
Prime Contractor Direct Labor (Note 2)
Welder
Pipefitter
Outside Machinist
Electrician (Note 3)
Shipfitter
Painter (Note 3)
Weight Handler
Firewatch
Shipwrights
Direct Supervision
Direct QA
Other

Total Prime Contractor Direct Labor Cost

Direct Labor Overhead (Sched. 2)

Total Prime Contractor Direct Labor and Direct Labor Overhead

Sample Explanatory Notes

(1) All hours proposed are based on historical amounts on similar work performed under contract ABCXYZ…

(2) The company direct labor rates are based on actual average rates as of 31 December 2015 and escalated __ percent each year per Global Insight

(3) The Painter and Electrician rates are based on Professional Services Agreement and in accordance with FAR 31.205-33

and FAR 52.215-22 and 225.215-23 Limitations on Pass-Through Charges.

Service Agreements are included with proposal.

NOTE - Suggested Guidance to assist contractors in understanding Cost Type Price Proposals may be found in "INFORMATION FOR CONTRACTORS"

Located at http://www.dcaa.mil/guidance.html

Sched. 2 Dir Labor OH support

Sample Indirect Rate Supporting Documentation

Prime Offeror Name

	Projected	Budget	Actual Expenses (Note 1)
Sample Overhead Expenses (Note 2)	2017	2016	2015	2014	2013
Payroll Taxes
Overhead Wages
Vacation
Holiday
Sick Leave
Pensions and Severance
Office Equipment
Depreciation
Travel
Relocation
Rent
Advertising
Insurance
Telephone
Total Pool

Less Unallowable Costs
Entertainment	(Note 5)
Net Allowable Costs

Allocation Base
Direct Labor and R&D/B&P Labor	(Note 3)

Overhead Rate (Note 4)

*Sample Contributing Govt Contracts	Expiration Date	Value of Contracts	Type of Contract
N000XX-XX-X-00XX	6/1/16		FFP
N000XX-XX-X-00XX	9/1/17		CPFF
N000XX-XX-X-00XX	8/1/16		Commercial

* When developing your percentage, these are the contracts contributing

to majority of development of the percentage.

Sample Explanatory Notes

(1) Provided prior three years' actual overhead expense and allocation base in the same format as the budget

for 2016. For the year 2015, actuals to date are provided and annualized (All values are not shown in this

example for brevity of presentation).

(2) The budgeted overhead expenses are based on the company's operating budget for 2016. The operating

budget supporting data is available upon request.

(3) Includes IR&D and B&P Labor of $__. IR&D B&P labor is included in the overhead base in order to allocate a

proportionate share of overhead to the labor, as required by FAR 31.205-18

(4) The same rate is estimated for fiscal years 2017 and 2018. We anticipate minimal inflation and a stable

business base as illustrated in our long-term strategic plan. The data and analysis is supporting this assertion is

available upon request.

(5) Entertainment Costs not allowable per FAR 31.205-14.

NOTE - Suggested Guidance to assist contractors in understanding Cost Type Price Proposals may be found in "INFORMATION FOR CONTRACTORS"

Located at http://www.dcaa.mil/guidance.html

Sched.3 Other Direct Costs ODC

Sample ODC Supporting Documentation
Prime Offeror Name
Other Direct Costs
Item Description	Amount
Travel		(Note 1)

Total Travel

Miscellaneous

description

Total Miscellaneous

Total ODC

G&A on ODC (Sched. 4)

Sample Explanatory Notes

(1) Airfare amounts are supported by recent quotes from industry providers; selection was based on lowest estimate and/or best value.

Travel costs that are not reasonable or allowable per FAR 31.205-46 have been removed from estimated amount.

NOTE - Suggested Guidance to assist contractors in understanding Cost Type Price Proposals may be found in "INFORMATION FOR CONTRACTORS"

Located at http://www.dcaa.mil/guidance.html

Sched. 4 G&A support

Sample Indirect Rate Supporting Documentation

Prime Offeror Name

	Projected	Budget		Net Allowable	Actual Expenses (Note 1)
2016 Projected G&A Sample Expenses (Note 2)	2017	2016	Less Unallowables	Expenses	2015	2014	2013
Payroll Taxes
Officers Salaries
Admin Salaries
Interest
Vacation
Holiday
Sick Leave
Contributions
Pensions
Office Equipment
Depreciation
Travel
Miscellaneous
Legal Fees
Accounting Fees
Computer
Rent
Advertising
Telephone
Insurance
Total Pool

IRD/B&P Labor
IRD/B&P Overhead xx.x%	(Note 3)
IRD/B&P Travel
Total IRD/B&P

Grand Total

ALLOCATION BASE
Direct Labor
Dir Labor Overhead
Less IRD/B&P Overhead @ xx.x%	Note (4)
Other Direct Costs (ODC)
Total Cost Input Base

G&A RATE (Note 5)

Sample Contributing Govt Contracts	Expiration Date	Value of Contracts	Type of Contract
N000XX-XX-X-00XX	6/1/16		FFP
N000XX-XX-X-00XX	9/1/17		CPFF
N000XX-XX-X-00XX	8/1/16		Commercial (IRD B&P)

Sample Explanatory Notes

(1) Provide the prior three years' actual G&A expenses and the allocation base I the same format sa the 2010

budget. For the year 2015, actuals are provided to date and annualized (All values are not shown in this

example for brevity of presentation).

(2) The projected G&A expenses are based on the company's operating budget for 2016. The operating

budget supporting data is available upon request.

(3) The $__ adjustment reflects the difference between the total overhead rate of __% is added to the G&A Pool and

deducted from the G&A Base.

(4) Overhead on IRD/B&P labor at the total overhead rate of _% is added to the G&A Pool and deducted

from the G&A Base.

(5) The same rate is estimated for fiscal years 2017 and 2018. We anticipate minimal inflation and a stable

business base as illustrated in our long-term strategic plan. The data and analysis is supporting this assertion is

available upon request. The total cost input base consists of contract direct costs plus total overhead costs

(including unallowable costs) less overhead on IRD/B&P transferred to the G&A Pool. The base does not include

IRD/B&P direct labor or other IRD/B&P direct costs, which are usually recovered through the G&A Pool.

NOTE - Suggested Guidance to assist contractors in understanding Cost Type Price Proposals may be found in "INFORMATION FOR CONTRACTORS"

Located at http://www.dcaa.mil/guidance.html

Sched. 5 Cost of Money

Sample Cost of Money Supporting Documentation

Prime Offeror Name

Computing COM Rate:
	Treasury Rate (Note 1)	Mos.	COM Rate
Jan - Jun 15
Jul - Dec 15
Jan - Mar 16

Months percentage added for demonstration purposes - adjust as needed

NBV BASES

		1. Applicable	2. Accumulation	3. Allocation of	4. Total Net	5. COM for Cost	6. Allocation	7. Facilities
Company 1		Cost of Money	& Distribution of	Undistributed	Book Value	Accounting	Base For	Capital COM
Cost Accounting Period 20xx		Rate	NBV			Period	Period	Factors
	Recorded	0.00%		(Basis Of Allocation)	(Column 2+3)	(Column 1*4)	In units	(Column 5/6)
Business	Leased Property						of measure
Unit	Corporate/Group						(Note 2)
Facilities	Total
Capital	Undistributed
	Distributed

Overhead	Unused
Pools	Unused
	Unused
	Cost of Money G&A
	Cost of Money Overhead
	Unused
	LESS: COM on IR&D/B&P Labor:
	Unused
	Unused
	Unused
	Cost of Money G&A
	Cost of Money Overhead
	Unused
	Subtotal
G&A	G & A
Expense Pools	ADD: COM on IR&D/B&P Labor
	Subtotal:
TOTAL

Sample Note 1: The interest rates to be used are those determined by the Secretary of the Treasury under Public Law 92-41, 85 Status 97.
	The rate is published semiannually in the Federal Register.
Sample Note 2: Allocation Bases
Overhead COM: Straight time direct labor dollars of all contracts and projects including labor costs of IR&D/B&P projects.
G&A COM: Total cost input (excluding G&A, B&P, and Cost of Money)

NOTE - Suggested Guidance to assist contractors in understanding Cost Type Price Proposals may be found in "INFORMATION FOR CONTRACTORS"

Located at http://www.dcaa.mil/guidance.html

File details come from the government source that posted it. Updated Nov 14, 2017.