PASS Cost Template.xlsx

XLSX spreadsheet 43 KB Posted Sep 5, 2024

Attached to: Program And Staff Services (PASS) Draft RFP Federal contract opportunity
Solicitation number: W911SR-24-R-0001
Issued by: Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

Written by GovTribe AI · Sep 5, 2024

This document appears to be a cost template for an Indefinite Delivery/Indefinite Quantity (IDIQ) federal contract opportunity with the Army Contracting Command Aberdeen Proving Ground. The contract will provide a wide range of professional services to support the DEVCOM CBC mission areas, including human capital, intelligence, security, strategic planning, business development, operations, project management, acquisition development, financial management, safety, and risk management. The solicitation is a draft Request for Proposal (RFP) with a number of defined labor categories, associated minimum qualifications, and estimated pricing. The contract has a 5-year period of performance, with an initial base period and four 1-year option periods. The draft RFP provides details on the required labor categories, billing rates, and estimated hours and costs for the base and option years.

View the file

Other files for this federal contract opportunity

Other files attached to Program And Staff Services (PASS) Draft RFP, newest first.
File	Type	Posted
PASS Question Spreadsheet_Government Responses.xlsx	XLSX spreadsheet	Nov 22, 2024
PASS Draft PWS Base IDIQ Updated.pdf	PDF	Sep 9, 2024
W911SR-24-R-0001 PASS Draft Solicitation Updated.pdf	PDF	Sep 9, 2024
PASS Draft PWS Task Order One Updated.pdf	PDF	Sep 9, 2024
W911SR-24-R-0001 PASS Draft Solicitation.docx	DOCX document	Sep 5, 2024
PASS Draft PWS Task Order One.docx	DOCX document	Sep 5, 2024
PASS Draft PWS Base IDIQ.docx	DOCX document	Sep 5, 2024
PASS Question Spreadsheet.xlsx	XLSX spreadsheet	Sep 5, 2024

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.

IDIQ LCAT Definitions

Labor Category	Labor Category Description	Minimum Education and Experience
Contract Program Manager	11-3012 Administrative Services Managers. Plan, direct, or coordinate one or more administrative services of an organization.	Bachelor's Degree with 10 years experience.
Contract Site Supervisor	43-1011. First-Line Supervisors of Office and Administrative Support Workers. Directly supervise and coordinate the activities of clerical and administrative support workers.	Bachelor's Degree with 5 years experience.
Contract Adminstrative Specialist	43-6011 Executive Secretaries and Executive Administrative Assistants. Provide high-level administrative support by conducting research, preparing statistical reports, and handling information requests, as well as performing routine administrative functions such as preparing correspondence, receiving visitors, arranging conference calls, and scheduling meetings. May also train and supervise lower-level clerical staff.	High School Diploma with 1-3 years experience.
Contract Accounting Technician	43-3031 Bookkeeping, Accounting, and Auditing Clerks. Compute, classify, and record numerical data to keep financial records complete. Perform any combination of routine calculating, posting, and verifying duties to obtain primary financial data for use in maintaining accounting records. May also check the accuracy of figures, calculations, and postings pertaining to business transactions recorded by other workers.	High School Diploma with 1-3 years experience.
Senior Communication Specialist	27-3031. Public Relations Specialists. Promote or create an intended public image for individuals, groups, or organizations. May write or select material for release to various communications media. May specialize in using social media.	Bachelor's Degree with at least 7 years experience.
Communication Specialist	27-3031. Public Relations Specialists. Promote or create an intended public image for individuals, groups, or organizations. May write or select material for release to various communications media. May specialize in using social media.	Bachelor's Degree with at least 5 years experience.
Photographer/Videographer	27-4021 Photographers. Photograph people, landscapes, merchandise, or other subjects. May use lighting equipment to enhance a subject's appearance. May use editing software to produce finished images and prints. Includes commercial and industrial photographers, scientific photographers, and photojournalists. 27-4032 Film and Video Editors. Edit moving images on film, video, or other media. May work with a producer or director to organize images for final production. May edit or synchronize soundtracks with images. 27-4031 Camera Operators, Television, Video, and Film. Operate television, video, or film camera to record images or scenes for television, video, or film productions.	Associate's Degree with at least 3 years experience.
Graphic Designer	27-1024. Graphic Designers. Design or create graphics to meet specific commercial or promotional needs, such as packaging, displays, or logos. May use a variety of mediums to achieve artistic or decorative effects.	Bachelor's Degree with at least 5 years experience.
Congressional Affairs Advisor	11-2032. Public Relations Managers. Plan, direct, or coordinate activities designed to create or maintain a favorable public image or raise issue awareness for their organization or client.	Bachelor's Degree with at least 5 years experience.
Senior Technology Transfer Specialist	13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.	Bachelor's Degree with at least 10 years experience.
Junior Technology Transfer Specialist	13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.	Bachelor's Degree with at least 3 years experience.
Senior Business Development Analyst	13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.	Bachelor's Degree with at least 7 years experience.
Acquisition Specialist - Midlevel	13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.	Bachelor's Degree with at least 5 years experience.
Acquisition specialist - Senior Level	13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.	Bachelor's Degree with at least 7 years experience.
Cost Analyst - Junior Level	13-1051. Cost Estimators. Prepare cost estimates for product manufacturing, construction projects, or services to aid management in bidding on or determining price of product or service. May specialize according to particular service performed or type of product manufactured.	Bachelor's Degree.
Cost Analyst - Senior Level	13-1051. Cost Estimators. Prepare cost estimates for product manufacturing, construction projects, or services to aid management in bidding on or determining price of product or service. May specialize according to particular service performed or type of product manufactured.	Bachelor's Degree with at least 7 years experience.
Decision Analysis Analyst - Junior Level	13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.	Bachelor's Degree.
Decision Analysis Analyst- Senior Level	13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.	Bachelor's Degree with at least 7 years experience.
Financial Analyst - Junior Level	13-2051. Financial and Investment Analysts. Conduct quantitative analyses of information involving investment programs or financial data of public or private institutions, including valuation of businesses.	Bachelor's Degree with at least 3 years experience.
Financial Analyst - Senior Level	13-2051. Financial and Investment Analysts. Conduct quantitative analyses of information involving investment programs or financial data of public or private institutions, including valuation of businesses.	Bachelor's Degree with at least 7 years experience.
GFEBS Senior Consultant	13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.	Bachelor's Degree with at least 10 years experience.
Program Analyst - Junior Level	13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.	Bachelor's Degree with at least 3 years experience.
Program Analyst - Senior Level	13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.	Bachelor's Degree with at least 7 years experience.
Emergency Coordinator (Emergency Management)	11-9161 Emergency Management Directors. Plan and direct disaster response or crisis management activities, provide disaster preparedness training, and prepare emergency plans and procedures for natural (e.g., hurricanes, floods, earthquakes), wartime, or technological (e.g., nuclear power plant emergencies or hazardous materials spills) disasters or hostage situations.	Bachelor's Degree with at least 5 years experience.
Risk Communications Specialist (Safety and Risk Management Support)	13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.	Bachelor's Degree with at least 5 years experience.
Administrative Specialist (Safety and Risk Management Support)	43-6011 Executive Secretaries and Executive Administrative Assistants. Provide high-level administrative support by conducting research, preparing statistical reports, and handling information requests, as well as performing routine administrative functions such as preparing correspondence, receiving visitors, arranging conference calls, and scheduling meetings. May also train and supervise lower-level clerical staff.	High School Diploma with 1-3 years experience.
SOP Coordinator (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)	17-2111. Health and Safety Engineers, Except Mining Safety Engineers and Inspectors. Promote worksite or product safety by applying knowledge of industrial processes, mechanics, chemistry, psychology, and industrial health and safety laws. Includes industrial product safety engineers.	High School Diploma with 1-3 years experience.
Radiation Specialist (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)	17-2111. Health and Safety Engineers, Except Mining Safety Engineers and Inspectors. Promote worksite or product safety by applying knowledge of industrial processes, mechanics, chemistry, psychology, and industrial health and safety laws. Includes industrial product safety engineers.	Bachelor's Degree with at least 7 years experience.
Engineering Controls Certification Specialist (Hazardous Work Protection)	17-2111. Health and Safety Engineers, Except Mining Safety Engineers and Inspectors. Promote worksite or product safety by applying knowledge of industrial processes, mechanics, chemistry, psychology, and industrial health and safety laws. Includes industrial product safety engineers.	High school diploma with at least 5 years experience.
Safety Specialist (Hazardous Work Protection)	17-2111. Health and Safety Engineers, Except Mining Safety Engineers and Inspectors. Promote worksite or product safety by applying knowledge of industrial processes, mechanics, chemistry, psychology, and industrial health and safety laws. Includes industrial product safety engineers.	Bachelor's Degree with at least 2 years experience.
Senior Operations Analyst	13-1199. Business Operations Specialists, All Other. All business operations specialists not listed separately.	Bachelor's Degree with at least 7 years experience.
Operations Specialist	13-1199. Business Operations Specialists, All Other. All business operations specialists not listed separately.	Bachelor's Degree with at least 5 years experience.
Security Specialist	13-1199. Business Operations Specialists, All Other. All business operations specialists not listed separately.	Bachelor's Degree with at least 3 years experience.
Technical Writer	27-3042. Technical Writers. Write technical materials, such as equipment manuals, appendices, or operating and maintenance instructions. May assist in layout work.	Associate's Degree with at least 3 years experience.
Travel and Timekeeping Clerk	43-3031. Bookkeeping, Accounting, and Auditing Clerks. Compute, classify, and record numerical data to keep financial records complete. Perform any combination of routine calculating, posting, and verifying duties to obtain primary financial data for use in maintaining accounting records. May also check the accuracy of figures, calculations, and postings pertaining to business transactions recorded by other workers.	High School Diploma with 1-3 years experience.

Prop. Y1 Labor

Company Name

CAGE

LCAT_Title

Direct Rate

Fringe Rate

Fringe

Overhead Rate

Overhead

Subcontractor Rate

Subcontractor Handling Rate

Subcontractor Handling

G&A Rate

G&A

FCCOM if Applicable

Proposed_Cost_per_Hour

Evaluation_Weight

Contract Program Manager

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Contract Site Supervisor

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Contract Adminstrative Specialist

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

4.3%

Contract Accounting Technician

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Senior Communication Specialist

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Communication Specialist

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Photographer/Videographer

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Graphic Designer

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Congressional Affairs Advisor

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Senior Technology Transfer Specialist

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Junior Technology Transfer Specialist

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Senior Business Development Analyst

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Acquisition Specialist - Midlevel

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

4.4%

Acquisition specialist - Senior Level

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

4.4%

Cost Analyst - Junior Level

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

4.4%

Cost Analyst - Senior Level

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

4.4%

Decision Analysis Analyst - Junior Level

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Decision Analysis Analyst- Senior Level

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Financial Analyst - Junior Level

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Financial Analyst - Senior Level

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

GFEBS Senior Consultant

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Program Analyst - Junior Level

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

4.4%

Program Analyst - Senior Level

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

6.6%

Emergency Coordinator (Emergency Management)

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Risk Communications Specialist (Safety and Risk Management Support)

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Administrative Specialist (Safety and Risk Management Support)

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

SOP Coordinator (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Radiation Specialist (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

0.5%

Engineering Controls Certification Specialist (Hazardous Work Protection)

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

4.3%

Emplosives Safety Specialist (Hazardous Work Protection)

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Senior Operations Analyst

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Operations Specialist

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

4.4%

Security Specialist

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Technical Writer

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

4.4%

Travel and Timekeeping Clerk

<Rate>

<Rate>

<Rate>

<Rate>

$0.00

2.2%

Prop. Non-Labor

	Rate	Total
$1 of Direct Materials		$1.00
Material Handling	<Rate>	<Formula>
Subtotal, Materials		$1.00
G&A on Materials	<Rate>	<Formula>
FCCOM on Materials	<Rate>	<Formula>
Prop_Mat_Mult		$1.00

$1 of Travel		$1.00
G&A on Travel	<Rate>	<Formula>
FCCOM on Travel	<Rate>	<Formula>
Prop_Travel_Mult		$1.00

$1 of ODCs		$1.00
G&A on ODCs	<Rate>	<Formula>
FCCOM on ODCs	<Rate>	<Formula>
Prop_ODC_Mult		$1.00
***Add/Remove Rows as needed for accurate multiplier calculations

IDIQ Eval Price

Proposed Fixed Fee (% of Estimated Labor Cost):					←Must be 10% or less.
Escalation				5.0%	←Do not change. Will be 5% for all Offerors.
	Labor (CPFF)					Materials (Cost)			Travel (Cost)			ODCs (Cost)			Total
	Weighted Avg. Total Cost per Hour	Evaluation Hours	Proposed Evaluation Labor Cost	Proposed Evaluation Fixed Fee	Proposed Evaluation CPFF	Plug Number	Material Multiplier	Evaluation Price	Plug Number	Travel Multiplier	Evaluation Price	Plug Number	ODC Multiplier	Evaluation Price	Evaluation Price
Year 1	$0.00	75,000	$0	$0	$0	$15,000	1.000	$15,000	$100,000	1.000	$100,000	$15,000	1.000	$15,000	$130,000
Year 2	$0.00	75,000	$0	$0	$0	$15,750	1.000	$15,750	$105,000	1.000	$105,000	$15,750	1.000	$15,750	$136,500
Year 3	$0.00	75,000	$0	$0	$0	$16,538	1.000	$16,538	$110,250	1.000	$110,250	$16,538	1.000	$16,538	$143,325
Year 4	$0.00	75,000	$0	$0	$0	$17,364	1.000	$17,364	$115,763	1.000	$115,763	$17,364	1.000	$17,364	$150,491
Year 5 (6 months)	$0.00	37,500	$0	$0	$0	$9,116	1.000	$9,116	$60,775	1.000	$60,775	$9,116	1.000	$9,116	$79,008
Proposed Evaluation Price					$0			$73,768			$491,788			$73,768	$639,324

Task Order Hours Labor Category Title Base Period of Performance Misc. Contract Management and Administration Misc. Employee Training & Ancillary Compliance (e.g. obtain CAC) 3.4 Technology Transfer 3.5 Decision & Cost Analysis Financial Management Services 3.6 GFEBS Financial Management Services 3.7 Safety and Risk Management Services Each Option Year Misc. Contract Management and Administration Misc. Employee Training & Ancillary Compliance (e.g. obtain CAC) 3.4 Technology Transfer 3.5 Decision & Cost Analysis Financial Management Services 3.6 GFEBS Financial Management Services 3.7 Safety and Risk Management Services

Task Order Cost

	Labor Category
(Add Rows and extend formulas as Needed)	Base Period			Option Year 1			Option Year 2			Option Year 3			Option Year 4				Total
		Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
	Estimated Labor Cost			$0			$0			$0			$0			$0
	Fixed Fee (Equals IDIQ Fee Percentage)		0.0%	$0		0.0%	$0		0.0%	$0		0.0%	$0		0.0%	$0
	Labor, CPFF			$0			$0			$0			$0			$0

	Gov't Plug	Multiplier		Gov't Plug	Multiplier		Gov't Plug	Multiplier		Gov't Plug	Multiplier		Gov't Plug	Multiplier
Materials	$0	1.000	$0	$0	1.000	$0	$0	1.000	$0	$0	1.000	$0	$0	1.000	$0
Travel	$25,000	1.000	$25,000	$26,250	1.000	$26,250	$27,563	1.000	$27,563	$28,941	1.000	$28,941	$30,388	1.000	$30,388	$138,141
ODCs	$3,000	1.000	$3,000	$3,150	1.000	$3,150	$3,308	1.000	$3,308	$3,473	1.000	$3,473	$3,647	1.000	$3,647	$16,577
Materials, Travel & ODCs, Cost (no-fee)			$28,000			$29,400			$30,870			$32,414			$34,034	$154,718

Task Order Total $28,000 $29,400 $30,870 $32,414 $34,034 $154,718

Task Order Labor Info Proposed Labor Categories for Task Order Employee Makup If "Current Workforce", add years with company;

if "Subcontracts", briefly describe B2B historical relationship with subcontractor (only once for each subcontractor)

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
**Prefills based on "Task Order Hours" tab. Feel free to copy above and paste as values instead so updates to "Task Order Hours" don't inadvertantly change this sheet.

lists

Employee_Makeup

Current Workforce

Subcontracts

New Hires

Approx. 50/50 mix of Current Workforce and Subcontracts

Approx. 50/50 mix of Current Workforce and New Hires

Approx. 50/50 mix of Subcontracts and New Hires

File details come from the government source that posted it. Updated Sep 5, 2024.