Admin-Cost-Model 092809.xls

XLS spreadsheet 86 KB Posted Sep 30, 2009

Attached to: Professional and Administrative Support Services Federal contract opportunity
Solicitation number: HDTRA1-09-R-0015
Issued by: Defense Threat Reduction Agency

About this file

From the source

Revised Attachment 6

View the file

Other files for this federal contract opportunity

Other files attached to Professional and Administrative Support Services, newest first.
File	Type	Posted
HDTRA1-09-R-0015-0003.pdf	PDF	Sep 30, 2009
HDTRA1-09-R-0015 Q A.doc	DOC document	Sep 30, 2009
HDTRA1-09-R-0015 Q A.doc	DOC document	Sep 21, 2009
HDTRA1-09-R-0015-0001.doc	DOC document	Sep 16, 2009
FLORIDA DOL WAGE DETERMINATION.pdf	PDF	Sep 15, 2009
NEW MEXICO DOL WAGE DETERMINATION.pdf	PDF	Sep 15, 2009
Attachment L-2 PPPQ.doc	DOC document	Sep 15, 2009
Non-Disclosure Agreement.doc	DOC document	Sep 15, 2009
Admin-Cost-Model 092109.xls	XLS spreadsheet	Sep 15, 2009
I50152.pdf	PDF	Sep 15, 2009
TASK ORDER 0001 CDRL DD 1423.pdf	PDF	Sep 15, 2009
DD-254 FOR HDTRA1-09-R-0015.pdf	PDF	Sep 15, 2009
NCR DOL WAGE DETERMINATION.pdf	PDF	Sep 15, 2009
ADMIN SOW BASE SOW Sep1409.doc	DOC document	Sep 15, 2009
HDTRA1-09-R-0015.docx	DOCX document	Sep 15, 2009
Admin Support	—	Sep 15, 2009
Attachment L-1 PPPI.doc	DOC document	Sep 15, 2009
BASE CONTRACT CDRL DD 1423.pdf	PDF	Sep 15, 2009
Presolicitation Q A.doc	DOC document	Aug 5, 2009

Show all 19

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.

Attachment 6 - Cost Model

Attachment 6
	Date: September 28, 2009
This page is the table of contents for the worksheets contained in this spreadsheet/file.
This spreadsheet serves as the model for the cost proposal for the Base Effort and Task Order 0001.
This tool is to be used to enter your cost data.
All cells calculating data shall display the formula and shall not be a number entered manually or pasted.
This attachment will be referred to in the future to match new Task Orders against the rates proposed herein.
Worksheet Title	Description
Labor - Burdens J-1	Displays all the labor categories. Fill in the burdens to each labor rate for all 5yrs.
Base - Costprop J-2	Displays all the labor categories/hours. Fill in the burdened labor rates for all 5yrs applicable to the Base Effort.
TO 0001 - Costprop J-3	Displays all the labor categories/hours. Fill in the burdened labor rates for all 5yrs applicable to Task Order 0001.

Labor - Burdens J-1

Labor Rate Breakout (Attachment 6, J-1)
Breakout shows how the Labor Burdens equal the Burdened Rate
Important Note: Please fill out (6) copies of the spreadsheet below with the following Titles:
Classification	Location
Secret	Ft. Belvoir, VA
Secret	Eglin AFB, FL
Secret	Albuquerque NM
Top Secret	Ft. Belvoir, VA
Top Secret	Eglin AFB, FL
Top Secret	Albuquerque NM
* Note that the out-years need to be escalated to ensure that DOL minimum wage & minimum Health/Welfare amounts are met
Base Year
	Burdened	Un-Burdened	Fringe			Health &
Category	Labor Rate	Labor Rate	Benefits	Overhead	G&A	Welfare	Fee
Secretary V	$22.85	$10.00	$3.00	$3.00	$2.00	$3.35	$1.50
Secretary IV
Secretary III
Secretary II
Secretary I
General Clerk V
General Clerk IV
General Clerk III
General Clerk II
General Clerk I
Desktop Publisher III/Editor
Desktop Publisher II/Editor
Events Coordinator
Option Year 1
	Burdened	Un-Burdened	Fringe			Health &
Category	Labor Rate	Labor Rate	Benefits	Overhead	G&A	Welfare	Fee
Secretary V	$23.54	$10.30	$3.09	$3.09	$2.06	$3.45	$1.55
Secretary IV
Secretary III
Secretary II
Secretary I
General Clerk V
General Clerk IV
General Clerk III
General Clerk II
General Clerk I
Desktop Publisher III/Editor
Desktop Publisher II/Editor
Events Coordinator
Option Year 2
	Burdened	Un-Burdened	Fringe			Health &
Category	Labor Rate	Labor Rate	Benefits	Overhead	G&A	Welfare	Fee
Secretary V	$24.24	$10.61	$3.18	$3.18	$2.12	$3.55	$1.59
Secretary IV
Secretary III
Secretary II
Secretary I
General Clerk V
General Clerk IV
General Clerk III
General Clerk II
General Clerk I
Desktop Publisher III/Editor
Desktop Publisher II/Editor
Events Coordinator
Option Year 3
	Burdened	Un-Burdened	Fringe			Health &
Category	Labor Rate	Labor Rate	Benefits	Overhead	G&A	Welfare	Fee
Secretary V	$24.97	$10.93	$3.28	$3.28	$2.19	$3.66	$1.64
Secretary IV
Secretary III
Secretary II
Secretary I
General Clerk V
General Clerk IV
General Clerk III
General Clerk II
General Clerk I
Desktop Publisher III/Editor
Desktop Publisher II/Editor
Events Coordinator
Option Year 4
	Burdened	Un-Burdened	Fringe			Health &
Category	Labor Rate	Labor Rate	Benefits	Overhead	G&A	Welfare	Fee
Secretary V	$25.72	$11.26	$3.38	$3.38	$2.25	$3.77	$1.69
Secretary IV
Secretary III
Secretary II
Secretary I
General Clerk V
General Clerk IV
General Clerk III
General Clerk II
General Clerk I
Desktop Publisher III/Editor
Desktop Publisher II/Editor
Events Coordinator
Summary (Average Rates)
	Burdened	Un-Burdened	Fringe			Health &
Category	Labor Rate	Labor Rate	Benefits	Overhead	G&A	Welfare	Fee
Secretary V	$24.26	$10.62	$3.19	$3.19	$2.12	$3.56	$1.59
Secretary IV
Secretary III
Secretary II
Secretary I
General Clerk V
General Clerk IV
General Clerk III
General Clerk II
General Clerk I
Desktop Publisher III/Editor
Desktop Publisher II/Editor
Events Coordinator
General Clerk II
General Clerk I
Desktop Publisher III
Desktop Publisher II
Events Coordinator

B1 Labor Rates J-2

B1 - Labor Categories, Labor Hour Rates, and Labor Hour Overtime Rates - Firm Fixed Priced, J-2
Price reasonableness will be determined by analyzing one hour of labor per category and travel for the period below.
All labor categories require a Secret clearance except those marked TS - Top Secret Clearance
Year 1	Fort Belvoir, VA		Eglin AFB, FL		Albuquerque, NM
Labor Categories	Hourly Rate	Overtime Rate	Hourly Rate	Overtime Rate	Hourly Rate	Overtime Rate
Secretary V		$0.00		$0.00		$0.00	$0.00
Secretary IV		$0.00		$0.00		$0.00	$0.00
Secretary III		$0.00		$0.00		$0.00	$0.00
Secretary III		$0.00		$0.00		$0.00	$0.00
Secretary I		$0.00		$0.00		$0.00	$0.00
Clerk IV		$0.00		$0.00		$0.00	$0.00
Clerk V		$0.00		$0.00		$0.00	$0.00
Clerk III		$0.00		$0.00		$0.00	$0.00
Clerk II		$0.00		$0.00		$0.00	$0.00
Clerk I		$0.00		$0.00		$0.00	$0.00
Events Coordinator		$0.00		$0.00		$0.00	$0.00
Desktop Publisher III/Editor		$0.00		$0.00		$0.00	$0.00
Desktop Publisher II/Editor		$0.00		$0.00		$0.00	$0.00
Secretary V - TS		$0.00		$0.00		$0.00	$0.00
Secretary IV - TS		$0.00		$0.00		$0.00	$0.00
Clerk IV - TS		$0.00		$0.00		$0.00	$0.00
Clerk III - TS		$0.00		$0.00		$0.00	$0.00
Subtotal							$0.00
Escalation - insert % in Column B
Year 2	Fort Belvoir, VA		Eglin AFB, FL		Albuquerque, NM
Labor Categories	Hourly Rate	Overtime Rate	Hourly Rate	Overtime Rate	Hourly Rate	Overtime Rate
Secretary V	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary IV	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary I	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk IV	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk V	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk II	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk I	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Events Coordinator	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Desktop Publisher III/Editor	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Desktop Publisher II/Editor	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary V - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary IV - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk IV - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk III - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Subtotal							$0.00
Escalation - insert % in Column B
Year 3	Fort Belvoir, VA		Eglin AFB, FL		Albuquerque, NM
Labor Categories	Hourly Rate	Overtime Rate	Hourly Rate	Overtime Rate	Hourly Rate	Overtime Rate
Secretary V	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary IV	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary I	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk IV	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk V	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk II	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk I	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Events Coordinator	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Desktop Publisher III/Editor	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Desktop Publisher II/Editor	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary V - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary IV - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk IV - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk III - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Subtotal							$0.00
Escalation - insert % in Column B
Year 4	Fort Belvoir, VA		Eglin AFB, FL		Albuquerque, NM
Labor Categories	Hourly Rate	Overtime Rate	Hourly Rate	Overtime Rate	Hourly Rate	Overtime Rate
Secretary V	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary IV	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary I	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk IV	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk V	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk II	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk I	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Events Coordinator	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Desktop Publisher III/Editor	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Desktop Publisher II/Editor	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary V - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary IV - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk IV - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk III - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Subtotal							$0.00
Escalation - insert % in Column B
Year 5	Fort Belvoir, VA		Eglin AFB, FL		Albuquerque, NM
Labor Categories	Hourly Rate	Overtime Rate	Hourly Rate	Overtime Rate	Hourly Rate	Overtime Rate
Secretary V	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary IV	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary I	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk IV	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk V	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk III	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk II	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk I	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Events Coordinator	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Desktop Publisher III/Editor	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Desktop Publisher II/Editor	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary V - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Secretary IV - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk IV - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Clerk III - TS	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Subtotal							$0.00
						Year 1	$0.00
						Year 2	$0.00
						Year 3	$0.00
						Year 4	$0.00
						Year 5	$0.00
						Total	$0.00
						Travel	$100,000.00
						Grand Total	$100,000.00

TO 0001 - Costprop J-3

Cost Proposal Guideline "Task Order 0001" (Attachment 6, J-3)
Breakout by Year for Labor Categories/Hours
Important Note: Please enter rates into the spreadsheet below that correspond to rates
in the basic contract for the following classification/location:
Classification	Location
Secret	Ft. Belvoir, VA
Base Year
				Burdened
Category	# FTEs	Man-year	Total Man-hrs	Labor Rate	Total
Secretary V	2	1920	3840
General Clerk IV	2	1920	3840
Desktop Publisher III	1	1920	1920
	5		9,600
Option Year 1
				Burdened
Category	# FTEs	Man-year	Total Man-hrs	Labor Rate	Total
Secretary V	2	1920	3840
General Clerk IV	2	1920	3840
Desktop Publisher III	1	1920	1920
	5		9,600
Option Year 2
				Burdened
Category	# FTEs	Man-year	Total Man-hrs	Labor Rate	Total
Secretary V	2	1920	3840
General Clerk IV	2	1920	3840
Desktop Publisher III	1	1920	1920
	5		9,600
Option Year 3
				Burdened
Category	# FTEs	Man-year	Total Man-hrs	Labor Rate	Total
Secretary V	2	1920	3840
General Clerk IV	2	1920	3840
Desktop Publisher III	1	1920	1920
	5		9,600
Option Year 4
				Burdened
Category	# FTEs	Man-year	Total Man-hrs	Labor Rate	Total
Secretary V	2	1920	3840
General Clerk IV	2	1920	3840
Desktop Publisher III	1	1920	1920
	5		9,600
Summary (Base + Options)
				Burdened
Category	# FTEs	Man-year	Man-hrs	Labor Rate	Total
Secretary V	10	1920	19200
General Clerk IV	10	1920	19200
Desktop Publisher III	5	1920	9600
	25		48,000
Total Cost for 5 Years

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