ATTACHMENT_5_Pricing_Spreadsheet_16-R-0030_Ft_Hood_20_May_2016.xls

XLS spreadsheet 46 KB Posted May 27, 2016

Attached to: Training Aids, Devices, Simulators and Simulations (TADSS)
Solicitation number: W91151-16-R-0030
Issued by: Department of the Army Materiel Command Mission and Installation Contracting Command Fort Hood

About this file

From the source

Attachment 5 Pricing Spreadsheet

View the file

Other files

File	Type	Posted
Revised_Attachment_5_Pricing_Spreadhsheet_16-R-0030 _Ft_Hood _TADSS _3_Jun_16.xls	XLS spreadsheet	Jun 6, 2016
Conform_Copy _16-R-0030 _Ft._Hood _TADSS _6_Jun_16.docx	DOCX document	Jun 6, 2016
Amendment_0004 _16-R-0030 _Ft._Hood _TADSS _6_Jun_16.docx	DOCX document	Jun 6, 2016
Conform_Copy-16-R-0030_Ft._Hood _TADSS_2_Jun_16.docx	DOCX document	Jun 2, 2016
Amendment_0003-16-R-0030_TADSS_Support_Services _2_Jun_16.docx	DOCX document	Jun 2, 2016
Amendment_0002-16-R-0030_TADSS_Support_Services _27_May_16.docx	DOCX document	May 31, 2016
TE_A_GOVERNMENT_FURNISHED_FACILITY.PDF	PDF	May 27, 2016
TE_C_SAMPLE_LIST_OF_SPARE_PARTS.xls	XLS spreadsheet	May 27, 2016
TE_E_DD_Form_254.doc	DOC document	May 27, 2016
TE_J_Baseline_Data_Table.xls	XLS spreadsheet	May 27, 2016
TE_F_-_WD_-2015-2523_Revision_3_dated_29Dec2015.doc	DOC document	May 27, 2016
TE_D_SAMPLE_LIST_OF_MILES_EQUIPMENT.xls	XLS spreadsheet	May 27, 2016
TE_H_Deliverable.doc	DOC document	May 27, 2016
TE_G_PRS.doc	DOC document	May 27, 2016
TE_B_EQUIPMENT_UNDER_WARRANTY.pdf	PDF	May 27, 2016
TE_K_BASELINE_STAFFING.DOC	DOC document	May 27, 2016
Conform_Copy-16-R-0030_Ft._Hood_TADSS_27_May_16.docx	DOCX document	May 27, 2016
TE_D_SAMPLE_LIST_OF_MILES_EQUIPMENT.xls	XLS spreadsheet	May 9, 2016
TE_K_BASELINE_STAFFING.DOC	DOC document	May 9, 2016
TE_E_DD_Form_254.doc	DOC document	May 9, 2016
TE_C_SAMPLE_LIST_OF_SPARE_PARTS.xls	XLS spreadsheet	May 9, 2016
ATTACHMENT_5_Pricing_Spreadsheet_16-R-0030_Ft_Hood_22_Feb_16.xls	XLS spreadsheet	May 9, 2016
Attachment_2_Contract_Sheets_16-R-0030_Ft_Hood_22_Feb_16.docx	DOCX document	May 9, 2016
Attachment_3_Past_Performance_Questionnaire_16-R-0030_Ft_Hood_22_Feb_16.docx	DOCX document	May 9, 2016
TE_B_EQUIPMENT_UNDER_WARRANTY.pdf	PDF	May 9, 2016
TE_H_Deliverable.doc	DOC document	May 9, 2016
TE_J_Baseline_Data_Table.xls	XLS spreadsheet	May 9, 2016
Attachment_4__Sample_Questionnaire_Cover_Letter_16-R-0030_Ft_Hood_22_Feb_16.docx	DOCX document	May 9, 2016
TE_A_GOVERNMENT_FURNISHED_FACILITY.PDF	PDF	May 9, 2016
Attachment_1_Consent_Form__16-R-0030_Ft_Hood_22_Feb_16.docx	DOCX document	May 9, 2016
Amendment_0001__-_16-R-0030_TADSS_Support_Services_2_May_2016.docx	DOCX document	May 6, 2016
Conform_Copy_-_16-R-0030_Ft_Hood_TADSS_2_May_16.doc	DOC document	May 6, 2016
Conform_Copy_-_16-R-0030_Ft_Hood_TADSS_2_May_16.doc	DOC document	May 3, 2016
Amendment_0001__-_16-R-0030_TADSS_Support_Services_2_May_2016.docx	DOCX document	May 3, 2016

Show all 34

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.

FFP ODCs

SOLICITATION NO.:
TOTAL AVAILABLE HOURS:			0				TOTAL PRODUCTIVE HOURS:				0
	FT/	NO.	AVAIL	NET PROD	HR SALARY	DIRECT	HOLIDAY &	H&W	FICA	FUTA	SUTA	WORK COMP	WORK COMP	WORK COMP	TOTAL FRINGE	SUBTOTAL	G&A	TOTAL	PROFIT	GRAND
LABOR CATEGORY	PT	EMP.	HOURS	HOURS	RATE	LABOR	VACATION	$ 4.27	7.65%	0.60%		CODE	RATE	AMOUNT	BURDEN	COST		COST		TOTAL
EXEMPT:			2080	1920						$ 7,000	$ 9,000		PER $100
Position #1	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #2	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Position #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
NON-EXEMPT
Skill Category #1	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Skill Category #2	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Skill Category #3	FT	- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL NON-EXEMPT		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
CONTRACTOR MANPOWER REPORT
Skill Category #4		- 0	- 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL LABOR		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
OVERTIME
REGULAR (excl premium)
Skill Category A	FT		- 0			$ - 0			$ - 0					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Skill Category B	FT		- 0			$ - 0			$ - 0					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL REGULAR						$ - 0			$ - 0					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
PREMIUM
Skill Category A	FT		- 0	- 0	$ - 0	$ - 0			$ - 0						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Skill Category B	FT		- 0	- 0	$ - 0	$ - 0			$ - 0						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL PREMIUM						$ - 0			$ - 0						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL OVERTIME COST			- 0			$ - 0			$ - 0					$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL ALL LABOR		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
OTHER DIRECT COST (ODC):
Supplies																	$ - 0	$ - 0	$ - 0	$ - 0
Parts/Materials																	$ - 0	$ - 0	$ - 0	$ - 0
Equipment																	$ - 0	$ - 0	$ - 0	$ - 0
Travel																	$ - 0	$ - 0	$ - 0	$ - 0
Training																	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL OTHER DIRECT COST																$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
GRAND TOTAL		- 0	- 0	- 0		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fill in yellow boxes.
Revised 21 July 2015

INSTRUCTIONS

(1) Offeror needs to replace Skill Category #1, #2 and so forth with the skill category being proposed in column A.

(2) Offeror needs to indicate FT for full time employee, FTE for full time equivalent or PT for part time employee in column B

(3) Available hours are all hours including holidays and vacation.

(4) Net productive hours are the available hours less any holiday or vacation allowed by the offeror.

(5) SUTA rate shown in column K on this spreadsheet is for sample spreadsheet estimating purposes only. It is each individual offeror's responsibility to apply its own percentage rate for SUTA.

(6) SUTA and Workers' Compensation (WC) certificates need to be provided to support the SUTA & WC rates proposed on this spreadsheet. Also if General Liability is proposed separate from G&A we need the General Liability certificate for this proposed rate.

(7) If an offeror has an overhead rate it may insert the necessary columns to calculate the overhead. However, a narrative must be provided to support the proposed overhead rate.

(8) G&A rate shown in column Q on this spreadsheet is for estimating purposes only. It is each individual offeror's responsibility to apply its own percentage rate for G&A.

(9) Profit rate shown in column S on this spreadsheet is for estimating purposes only. It is each individual offeror's responsibility to apply its own percentage rate for profit.

(10) Although formulas are provided in the spreadsheet cells it is the responsibility of the offeror to make sure all formulas are correct.

(11) Spreadsheets must be completed for each option year.

(12) A pricing narrative should accompany the spreadsheets.

(13) Any labor costs provided by a sub-contractor need to be proposed in detail on the spreadsheet just as the prime contractor would. This means that the sub-contractor needs to fill in columns A through T.

Revised May 15, 2008

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