Attachment 2 - TEDSS Pricing Spreadsheet.xls

XLS spreadsheet 70 KB Posted Jan 14, 2011

Attached to: Technical Engineering Development and Support Services (TEDSS) for the United States Coast Guard's Command and Control Engineering Center
Solicitation number: HSCG44-10-R-TEDSSA
Issued by: Department of Homeland Security US Coast Guard

About this file

From the source

Attachment 2 - TEDSSA Pricing Spreadsheet

View the file

Other files

File	Type	Posted
Attachment 6b - Continuation Page - DD FORM 254 SECTION 13 .doc	DOC document	Feb 17, 2011
Attachment 8b - Supplemental clarification of answers to questions under RFP HSCG44-10-R-TEDSSA.doc	DOC document	Feb 17, 2011
Attachment 3-TEDDS_RateSchedule.doc	DOC document	Feb 14, 2011
Attach9-C3CECOrg(FINAL).rtf	RTF text file	Feb 14, 2011
FINAL REVISED TEDDS RFP(1).doc	DOC document	Feb 14, 2011
Attachment 1 - FINALTEDDS PWS.docx	DOCX document	Feb 14, 2011
Attachment 6-DD254(2).pdf	PDF	Feb 14, 2011
Attach 2-TEDSS-Pricing Spreadsheet.xls	XLS spreadsheet	Feb 14, 2011
Attachment 8 - TEDSS List of Questions and Answers.doc	DOC document	Feb 14, 2011
TEDSS20-pdf.pdf	PDF	Feb 10, 2011
FINAL TEDDS_RFP(1).doc	DOC document	Jan 14, 2011
Attachment 6 - DD254 TEDSS signed.pdf	PDF	Jan 14, 2011
Attachment 4 - WageDet-05-2543.doc	DOC document	Jan 14, 2011
Attachment 7 - Statement of Equivalent Rates for Federal Hires.doc	DOC document	Jan 14, 2011
Attachment 5 - TEDSS-Past Performance Questionnaire.doc	DOC document	Jan 14, 2011
Attachment 3 - TEDDS CLIN Structure - Labor Category Descriptions.doc	DOC document	Jan 14, 2011
Attachment 1 - TEDDS_PWS_10DEC10.docx	DOCX document	Jan 14, 2011
P00011 Solicitation.doc	DOC document	Nov 29, 2010
P00010 Solicitation.doc	DOC document	Oct 28, 2010
P00009 Solicitation.doc	DOC document	Oct 5, 2010
P00008 Solicitation.doc	DOC document	Sep 10, 2010
P00007 Solicitation.doc	DOC document	Sep 9, 2010
Contractor Clarifications to Government Responses.doc	DOC document	Sep 8, 2010
Attachment E Sept Revised.pdf	PDF	Sep 8, 2010
Attachment B Revised.pdf	PDF	Sep 8, 2010
Attachment C NEW DOL WD.pdf	PDF	Sep 8, 2010
P00006 Solicitation.doc	DOC document	Sep 8, 2010
TEDSS RFP P00006.pdf	PDF	Sep 8, 2010
P00005 Solicitation.doc	DOC document	Sep 2, 2010
P00004 Solicitation.doc	DOC document	Aug 27, 2010
Contractor Questions and Govt Response.doc	DOC document	Aug 20, 2010
TEDSS RFP Aug 2010.doc	DOC document	Aug 20, 2010
P00003 Solicitation.doc	DOC document	Aug 20, 2010
C3CEN Standard Orientation Brief July2010 TEDSS.pdf	PDF	Aug 20, 2010
TEDSS Preproposal Conference Attendees List.doc	DOC document	Aug 5, 2010
TEDSS Preproposal Conference Power Point RFP.ppt	PPT presentation	Aug 5, 2010
P00002 Solicitation.doc	DOC document	Aug 5, 2010
P00001 Solicitation.doc	DOC document	Jul 8, 2010
Attachment A.xls	XLS spreadsheet	Jun 25, 2010
Solicitation Page 1 of 62.pdf	PDF	Jun 25, 2010
Attachment D.doc	DOC document	Jun 25, 2010
Solicitation Pages 2 - 62.pdf	PDF	Jun 25, 2010
Attachment B.pdf	PDF	Jun 25, 2010
Attachment E.pdf	PDF	Jun 25, 2010
Attachment C DOL Wage Determination Virginia.txt	TXT text file	Jun 25, 2010

Show all 45

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.

CY 1

ATTACHMENT 2: PRICING SPREADSHEET
DESCRIPTION	EST QTY FOR CALENDAR YEAR 1		CALENDAR YEAR 1 - DATE OF AWARD -12 MONTHS THEREAFTER		DISCOUNTED FULLY BURDENED LABOR RATES
	ST HOURS	HOURS	UNIT PRICE	TOTAL PRICE	UNIT PRICE	TOTAL PRICE	TOTAL PRICE
LABOR CATEGORY
Program Manager	15,600	10000	$0.00	$0.00	$0.00	$0.00
Project Task Manager	9,360	15000	$0.00	$0.00	$0.00	$0.00
Subject Matter Expert	2,773	15000	$0.00	$0.00	$0.00	$0.00
Telecommunications Enginer	11,093		$0.00	$0.00	$0.00	$0.00
Technical Writer	33,280	15000	$0.00	$0.00	$0.00	$0.00
Integrated Systems Technician	33,280	15000	$0.00	$0.00	$0.00	$0.00
Graphics Expert	8,320	15000	$0.00	$0.00	$0.00	$0.00
Database Systems Architect	8,320	15000	$0.00	$0.00	$0.00	$0.00
Database Programmer/Analyst	8,320	10000	$0.00	$0.00	$0.00	$0.00
Programmer/Analyst	33,280	15000	$0.00	$0.00	$0.00	$0.00
Programmer	38,826	10000	$0.00	$0.00	$0.00	$0.00
Database /Administrator (DBA)	11,093	25000	$0.00	$0.00	$0.00	$0.00
Network Administrator	5,546	15000	$0.00	$0.00	$0.00	$0.00
System Administrator	5,546	15000	$0.00	$0.00	$0.00	$0.00
COMMS/Networking Engineer	11,093	15000	$0.00	$0.00	$0.00	$0.00
Training Specialist	22,187	10000	$0.00	$0.00	$0.00	$0.00
Engineering Technician I	44,373	15000	$0.00	$0.00	$0.00	$0.00
Engineering Technician II	44,373	15000	$0.00	$0.00	$0.00	$0.00
Engineering Technician III	22,187		$0.00	$0.00	$0.00	$0.00
Engineering Technician IV	11,093		$0.00	$0.00	$0.00	$0.00
Engineering Technician V	5,546		$0.00	$0.00	$0.00	$0.00
Engineering Technician VI	5,546		$0.00	$0.00	$0.00	$0.00
Drafter I	2,773		$0.00	$0.00	$0.00	$0.00
Drafter II	2,773		$0.00	$0.00	$0.00	$0.00
Drafter III	2,773		$0.00	$0.00	$0.00	$0.00
Logistics Specialist	2,773		$0.00	$0.00	$0.00	$0.00
Logistics Technician	8,320		$0.00	$0.00	$0.00	$0.00
Word Processor	16,640		$0.00	$0.00	$0.00	$0.00
Test Engineer	29,120		$0.00	$0.00	$0.00	$0.00
IT Systems Security Officer I	13,867		$0.00	$0.00	$0.00	$0.00
IT Systems Security Iffucer II	13,867		$0.00	$0.00	$0.00	$0.00
IT Systems Security Ananyst	13,867		$0.00	$0.00	$0.00	$0.00
Travel and Per Diem					$0.00
(including G&A) - NTE	$1,053,119.60		$0.00		$0.00
Other Direct Costs (ODC) NTE	$200,000.00		$0.00		$0.00
				$0.00		$0.00
TOTAL CY 1 PROPOSED PRICE

CY 2

ATTACHMENT 2: PRICING SPREADSHEET
DESCRIPTION	EST QTY FOR CALENDAR YEAR 2		CALENDAR YEAR 2 - COMPLETION OF CALENDAR YEAR 1 - 12 MONTHS THEREAFTER		DISCOUNTED FULLY BURDENED LABOR RATES
	ST HOURS	HOURS	UNIT PRICE	TOTAL PRICE	UNIT PRICE	TOTAL PRICE
LABOR CATEGORY
Program Manager	15,600		$0.00	$0.00	$0.00	$0.00
Project Task Manager	9,360		$0.00	$0.00	$0.00	$0.00
Subject Matter Expert	2,773		$0.00	$0.00	$0.00	$0.00
Telecommunications Enginer	11,093		$0.00	$0.00	$0.00	$0.00
Technical Writer	33,280	15000	$0.00	$0.00	$0.00	$0.00
Integrated Systems Technician	33,280	15000	$0.00	$0.00	$0.00	$0.00
Graphics Expert	8,320	15000	$0.00	$0.00	$0.00	$0.00
Database Systems Architect	8,320	15000	$0.00	$0.00	$0.00	$0.00
Database Programmer/Analyst	8,320	10000	$0.00	$0.00	$0.00	$0.00
Programmer/Analyst	33,280	15000	$0.00	$0.00	$0.00	$0.00
Programmer	38,826	10000	$0.00	$0.00	$0.00	$0.00
Database /Administrator (DBA)	11,093	25000	$0.00	$0.00	$0.00	$0.00
Network Administrator	5,546	15000	$0.00	$0.00	$0.00	$0.00
System Administrator	5,546	15000	$0.00	$0.00	$0.00	$0.00
COMMS/Networking Engineer	11,093	15000	$0.00	$0.00	$0.00	$0.00
Training Specialist	22,187	10000	$0.00	$0.00	$0.00	$0.00
Engineering Technician I	44,373	15000	$0.00	$0.00	$0.00	$0.00
Engineering Technician II	44,373	15000	$0.00	$0.00	$0.00	$0.00
Engineering Technician III	22,187		$0.00	$0.00	$0.00	$0.00
Engineering Technician IV	11,093		$0.00	$0.00	$0.00	$0.00
Engineering Technician V	5,546		$0.00	$0.00	$0.00	$0.00
Engineering Technician VI	5,546		$0.00	$0.00	$0.00	$0.00
Drafter I	2,773		$0.00	$0.00	$0.00	$0.00
Drafter II	2,773		$0.00	$0.00	$0.00	$0.00
Drafter III	2,773		$0.00	$0.00	$0.00	$0.00
Logistics Specialist	2,773		$0.00	$0.00	$0.00	$0.00
Logistics Technician	8,320		$0.00	$0.00	$0.00	$0.00
Word Processor	16,640		$0.00	$0.00	$0.00	$0.00
Test Engineer	29,120		$0.00	$0.00	$0.00	$0.00
IT Systems Security Officer I	13,867		$0.00	$0.00	$0.00	$0.00
IT Systems Security Iffucer II	13,867		$0.00	$0.00	$0.00	$0.00
IT Systems Security Ananyst	13,867		$0.00	$0.00	$0.00	$0.00
Travel and Per Diem					$0.00
(including G&A) - NTE	$1,084,713.19		$0.00		$0.00
Other Direct Costs (ODC) NTE	$206,000.00		$0.00		$0.00
				$0.00		$0.00
TOTAL CY 2 PROPOSED PRICE

CY 3

ATTACHMENT 2: PRICING SPREADSHEET
DESCRIPTION	EST QTY FOR CALENDAR YEAR 3		CALENDAR YEAR 3 - COMPLETION OF CALENDAR YEAR 2 - 12 MONTHS THEREAFTER		DISCOUNTED FULLY BURDENED LABOR RATES
	ST HOURS	HOURS	UNIT PRICE	TOTAL PRICE	UNIT PRICE	TOTAL PRICE
LABOR CATEGORY
Program Manager	15,600		$0.00	$0.00	$0.00	$0.00
Project Task Manager	9,360		$0.00	$0.00	$0.00	$0.00
Subject Matter Expert	2,773		$0.00	$0.00	$0.00	$0.00
Telecommunications Enginer	11,093		$0.00	$0.00	$0.00	$0.00
Technical Writer	33,280	15000	$0.00	$0.00	$0.00	$0.00
Integrated Systems Technician	33,280	15000	$0.00	$0.00	$0.00	$0.00
Graphics Expert	8,320	15000	$0.00	$0.00	$0.00	$0.00
Database Systems Architect	8,320	15000	$0.00	$0.00	$0.00	$0.00
Database Programmer/Analyst	8,320	10000	$0.00	$0.00	$0.00	$0.00
Programmer/Analyst	33,280	15000	$0.00	$0.00	$0.00	$0.00
Programmer	38,826	10000	$0.00	$0.00	$0.00	$0.00
Database /Administrator (DBA)	11,093	25000	$0.00	$0.00	$0.00	$0.00
Network Administrator	5,546	15000	$0.00	$0.00	$0.00	$0.00
System Administrator	5,546	15000	$0.00	$0.00	$0.00	$0.00
COMMS/Networking Engineer	11,093	15000	$0.00	$0.00	$0.00	$0.00
Training Specialist	22,187	10000	$0.00	$0.00	$0.00	$0.00
Engineering Technician I	44,373	15000	$0.00	$0.00	$0.00	$0.00
Engineering Technician II	44,373	15000	$0.00	$0.00	$0.00	$0.00
Engineering Technician III	22,187		$0.00	$0.00	$0.00	$0.00
Engineering Technician IV	11,093		$0.00	$0.00	$0.00	$0.00
Engineering Technician V	5,546		$0.00	$0.00	$0.00	$0.00
Engineering Technician VI	5,546		$0.00	$0.00	$0.00	$0.00
Drafter I	2,773		$0.00	$0.00	$0.00	$0.00
Drafter II	2,773		$0.00	$0.00	$0.00	$0.00
Drafter III	2,773		$0.00	$0.00	$0.00	$0.00
Logistics Specialist	2,773		$0.00	$0.00	$0.00	$0.00
Logistics Technician	8,320		$0.00	$0.00	$0.00	$0.00
Word Processor	16,640		$0.00	$0.00	$0.00	$0.00
Test Engineer	29,120		$0.00	$0.00	$0.00	$0.00
IT Systems Security Officer I	13,867		$0.00	$0.00	$0.00	$0.00
IT Systems Security Iffucer II	13,867		$0.00	$0.00	$0.00	$0.00
IT Systems Security Ananyst	13,867		$0.00	$0.00	$0.00	$0.00
Travel and Per Diem					$0.00
(including G&A) - NTE	$1,102,290.59		$0.00		$0.00
Other Direct Costs (ODC) NTE	$206,206.00		$0.00		$0.00
				$0.00		$0.00
TOTAL CY 3 PROPOSED PRICE

CY 4

ATTACHMENT 2: PRICING SPREADSHEET
DESCRIPTION	EST QTY FOR CALENDAR YEAR 4		CALENDAR YEAR 4 - COMPLETION OF CALENDAR YEAR 3 - 12 MONTHS THEREAFTER		DISCOUNTED FULLY BURDENED LABOR RATES
	ST HOURS	HOURS	UNIT PRICE	TOTAL PRICE	UNIT PRICE	TOTAL PRICE
LABOR CATEGORY
Program Manager	15,600		$0.00	$0.00	$0.00	$0.00
Project Task Manager	9,360		$0.00	$0.00	$0.00	$0.00
Subject Matter Expert	2,773		$0.00	$0.00	$0.00	$0.00
Telecommunications Enginer	11,093		$0.00	$0.00	$0.00	$0.00
Technical Writer	33,280	15000	$0.00	$0.00	$0.00	$0.00
Integrated Systems Technician	33,280	15000	$0.00	$0.00	$0.00	$0.00
Graphics Expert	8,320	15000	$0.00	$0.00	$0.00	$0.00
Database Systems Architect	8,320	15000	$0.00	$0.00	$0.00	$0.00
Database Programmer/Analyst	8,320	10000	$0.00	$0.00	$0.00	$0.00
Programmer/Analyst	33,280	15000	$0.00	$0.00	$0.00	$0.00
Programmer	38,826	10000	$0.00	$0.00	$0.00	$0.00
Database /Administrator (DBA)	11,093	25000	$0.00	$0.00	$0.00	$0.00
Network Administrator	5,546	15000	$0.00	$0.00	$0.00	$0.00
System Administrator	5,546	15000	$0.00	$0.00	$0.00	$0.00
COMMS/Networking Engineer	11,093	15000	$0.00	$0.00	$0.00	$0.00
Training Specialist	22,187	10000	$0.00	$0.00	$0.00	$0.00
Engineering Technician I	44,373	15000	$0.00	$0.00	$0.00	$0.00
Engineering Technician II	44,373	15000	$0.00	$0.00	$0.00	$0.00
Engineering Technician III	22,187		$0.00	$0.00	$0.00	$0.00
Engineering Technician IV	11,093		$0.00	$0.00	$0.00	$0.00
Engineering Technician V	5,546		$0.00	$0.00	$0.00	$0.00
Engineering Technician VI	5,546		$0.00	$0.00	$0.00	$0.00
Drafter I	2,773		$0.00	$0.00	$0.00	$0.00
Drafter II	2,773		$0.00	$0.00	$0.00	$0.00
Drafter III	2,773		$0.00	$0.00	$0.00	$0.00
Logistics Specialist	2,773		$0.00	$0.00	$0.00	$0.00
Logistics Technician	8,320		$0.00	$0.00	$0.00	$0.00
Word Processor	16,640		$0.00	$0.00	$0.00	$0.00
Test Engineer	29,120		$0.00	$0.00	$0.00	$0.00
IT Systems Security Officer I	13,867		$0.00	$0.00	$0.00	$0.00
IT Systems Security Iffucer II	13,867		$0.00	$0.00	$0.00	$0.00
IT Systems Security Ananyst	13,867		$0.00	$0.00	$0.00	$0.00
Travel and Per Diem					$0.00
(including G&A) - NTE	$1,135.359.31		$0.00		$0.00
Other Direct Costs (ODC) NTE	$206,418.18		$0.00		$0.00
				$0.00		$0.00
TOTAL CY 4 PROPOSED PRICE

CY 5

ATTACHMENT 2: PRICING SPREADSHEET
DESCRIPTION	EST QTY FOR CALENDAR YEAR 5		CALENDAR YEAR 5 - COMPLETION OF CALENDAR YEAR 4 - 12 MONTHS THEREAFTER		DISCOUNTED FULLY BURDENED LABOR RATES
	ST HOURS	HOURS	UNIT PRICE	TOTAL PRICE	UNIT PRICE	TOTAL PRICE
LABOR CATEGORY
Program Manager	15,600		$0.00	$0.00	$0.00	$0.00
Project Task Manager	9,360		$0.00	$0.00	$0.00	$0.00
Subject Matter Expert	2,773		$0.00	$0.00	$0.00	$0.00
Telecommunications Enginer	11,093		$0.00	$0.00	$0.00	$0.00
Technical Writer	33,280	15000	$0.00	$0.00	$0.00	$0.00
Integrated Systems Technician	33,280	15000	$0.00	$0.00	$0.00	$0.00
Graphics Expert	8,320	15000	$0.00	$0.00	$0.00	$0.00
Database Systems Architect	8,320	15000	$0.00	$0.00	$0.00	$0.00
Database Programmer/Analyst	8,320	10000	$0.00	$0.00	$0.00	$0.00
Programmer/Analyst	33,280	15000	$0.00	$0.00	$0.00	$0.00
Programmer	38,826	10000	$0.00	$0.00	$0.00	$0.00
Database /Administrator (DBA)	11,093	25000	$0.00	$0.00	$0.00	$0.00
Network Administrator	5,546	15000	$0.00	$0.00	$0.00	$0.00
System Administrator	5,546	15000	$0.00	$0.00	$0.00	$0.00
COMMS/Networking Engineer	11,093	15000	$0.00	$0.00	$0.00	$0.00
Training Specialist	22,187	10000	$0.00	$0.00	$0.00	$0.00
Engineering Technician I	44,373	15000	$0.00	$0.00	$0.00	$0.00
Engineering Technician II	44,373	15000	$0.00	$0.00	$0.00	$0.00
Engineering Technician III	22,187		$0.00	$0.00	$0.00	$0.00
Engineering Technician IV	11,093		$0.00	$0.00	$0.00	$0.00
Engineering Technician V	5,546		$0.00	$0.00	$0.00	$0.00
Engineering Technician VI	5,546		$0.00	$0.00	$0.00	$0.00
Drafter I	2,773		$0.00	$0.00	$0.00	$0.00
Drafter II	2,773		$0.00	$0.00	$0.00	$0.00
Drafter III	2,773		$0.00	$0.00	$0.00	$0.00
Logistics Specialist	2,773		$0.00	$0.00	$0.00	$0.00
Logistics Technician	8,320		$0.00	$0.00	$0.00	$0.00
Word Processor	16,640		$0.00	$0.00	$0.00	$0.00
Test Engineer	29,120		$0.00	$0.00	$0.00	$0.00
IT Systems Security Officer I	13,867		$0.00	$0.00	$0.00	$0.00
IT Systems Security Iffucer II	13,867		$0.00	$0.00	$0.00	$0.00
IT Systems Security Ananyst	13,867		$0.00	$0.00	$0.00	$0.00
Travel and Per Diem					$0.00
(including G&A) - NTE	$1,169,420.09		$0.00		$0.00
Other Direct Costs (ODC) NTE	$206,636.73		$0.00		$0.00
				$0.00		$0.00
TOTAL CY 5 PROPOSED PRICE

TOTAL YRS

ATTACHMENT 2: PRICING SPREADSHEET
CALENDAR YEARS ONE THRU FIVE	EST LABOR HOURS		TOTAL CALENDAR YEAR (CY) ONE THRU FIVE PROPOSED PRICING:
CY 1:	497,808	$0.00	$0.00
		$0.00
CY 2:	497,808	$0.00	$0.00
		$0.00
CY 3:	497,808	$0.00	$0.00
		$0.00
CY 4:	497,808	$0.00	$0.00
CY 5:	497,808	$0.00	$0.00
SUBTOTAL (LABOR):		$0.00	$0.00
TRAVEL AND PER DIEM:	NTE		$4,409,543.47
ODC COSTS:	NTE		$1,025,260.91
TOTAL PROPOSED PRICE:			$0.00

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