Admin-Cost-Model 092109.xls

XLS spreadsheet 100 KB Posted Sep 15, 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

Cost Model (For Solicitation Proposal)

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
Admin-Cost-Model 092809.xls	XLS spreadsheet	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
BASE CONTRACT CDRL DD 1423.pdf	PDF	Sep 15, 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
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
Non-Disclosure Agreement.doc	DOC document	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
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: August 17, 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-Description	Displays all the labor categories and descriptions/qualifications of each labor category.
Labor - Burdens	Displays all the labor categories. Fill in the burdens to each labor rate for all 5yrs.
Base - Costprop	Displays all the labor categories/hours. Fill in the burdened labor rates for all 5yrs applicable to the Base Effort.
TO 0001 - Costprop	Displays all the labor categories/hours. Fill in the burdened labor rates for all 5yrs applicable to Task Order 0001.

Labor-Description

Labor Descriptions (Attachment 6)
Minimum Requirements
Category	Education	Specialized Training	Skill-Set	Job Description
Secretary V	AA Degree or 6+ yrs experience.	Typing course - 55 wpm	Computer skills with Microsoft Office software. Operate office equipment such as copiers, faxes, typewriter, scanner, etc.; Must have good phone and personal skills, able to maintain a high level of accuracy and be detail oriented.	Responsible for answering phones and distributing calls in a professional manner; Responsible for performing daily office tasks such as filing, recording, maintaining records, copying, posting, and other similar duties using a computer terminal, typewriter, and other word processor; Tasking are provided and compliance required for established procedures and practices; Examines, verifies and corrects documentation such as correspondence to ensure completeness and accuracy of information and perform data entry, typing, copying, filing, and other related duties to support work flow processing and record keeping.
Secretary IV	AA Degree or 4-6 yrs experience.	Typing course - 45 wpm
Secretary III	AA Degree or 2-3 yrs experience.	Typing course - 35 wpm
Secretary II	High school degree or equivalent or 1-2 yrs experience.	Typing course - 25 wpm
Secretary I	High school degree or equivalent or 0-6 mos. experience.	Typing course - 15 wpm
General Clerk V	High school degree or equivalent or 6+ yrs experience.	Typing course - 55 wpm	Use desk-top publishing software or advanced word processing capabilities to perform basic tasks associated with activities such as laying out text, graphics, and pictures on a page; integrating text and graphics; increasing or decreasing the size of charts, graphs, or pictures; and using multiple styles and sizes of type.	Responsible for answering phones and distributing calls in a professional manner; Responsible for performing daily office tasks such as filing, recording, maintaining records, copying, posting, and other similar duties using a computer terminal, typewriter, and other word processor; Tasking are provided and compliance required for established procedures and practices; Examines, verifies and corrects documentation such as correspondence to ensure completeness and accuracy of information and perform data entry, typing, copying, filing, and other related duties to support work flow processing and record keeping.
General Clerk IV	High school degree or equivalent or 4-6 yrs experience.	Typing course - 45 wpm
General Clerk III	High school degree or equivalent or 2-3 yrs experience.	Typing course - 35 wpm
General Clerk II	High school degree or equivalent or 1-2 yrs experience.	Typing course - 25 wpm
General Clerk I	High school degree or equivalent or 0-6 mos. experience.	Typing course - 15 wpm
Desktop Publisher III/Editor	BA degree or 5+ yrs experience.	Knowledge of graphic programs	Office Suite (Word, Excel, PowerPoint) and Adobe Acrobat	Use desk-top publishing software or advanced word processing capabilities to perform basic tasks associated with activities such as laying out text, graphics, and pictures on a page; integrating text and graphics; increasing or decreasing the size of charts, graphs, or pictures; and using multiple styles and sizes of type.
Desktop Publisher II/Editor	BA degree or 3-4 yrs experience.	Knowledge of graphic programs
Events Coordinator	BA degree or 4-5 yrs experience.	Excellent communication skills (written & verbal) with the ability to communicate with all levels of staff; Proficiency in MS Word, Excel, PowerPoint & Outlook; Strong administrative background with 3+ year’s prior event planning/hospitality experience.	Experience with DoD Protocol Events Coordination.	Planning, coordinating and executing all logistics for off-site meetings and workshops; handle all aspects of visits, conferences, tours, social functions dealing with high level executives within the agency. Advise high level executives on DoD military customs, courtesies, decorum, policies, assist in managing recognition programs and special ceremonies

Scheduling rooming, travel arrangements, and catering for attendees; Organizing workshop registrations and rosters; creating calendar of events; Coordinating hotel shuttles and car service as needed; Ordering appropriate supplies and equipment for meetings and workshops;

Conducting market research to obtain the best price with all hotels for meeting space, rooms and banquets; and maintaining database of all contracts for all events.

Labor - Burdens

Labor Rate Breakout (Attachment 6)
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

B1 - Labor Categories, Labor Hour Rates, and Labor Hour Overtime Rates - Firm Fixed Priced
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

Cost Proposal Guideline "Task Order 0001" (Attachment 6)
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.