Attachment B - Not-To-Exceed_Fully-Loaded Hourly Labor Rates_Pricing_19AQMM22R0202.xlsx

XLSX spreadsheet 43 KB Posted Jun 23, 2022

Attached to: Data Analytics - R/PPR
Solicitation number: 19AQMM22R0202
Issued by: Department of State Office of Acquisition Management

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains pricing templates and instructions for an indefinite-delivery, indefinite-quantity contract solicitation from the Department of State seeking data analytics services. Offerors are required to provide fully burdened hourly rates for various labor categories including program managers, analysts, leads, and trainers for the base year and four option years using the provided Excel templates, along with a cumulative total proposed price calculated automatically based on a sample task order labor mix and 1,920 labor hours. Services will support data collection, analysis, and evaluation efforts to enhance understanding of global audiences and adversaries' disinformation campaigns. The work will aid public diplomacy programs across the Department of State including the Bureau of Global Public Affairs and Educational and Cultural Affairs.

View the file

Other files

File	Type	Posted
19AQMM22R0202 - A0004.pdf	PDF	Jul 20, 2022
Attachment E - Evaluation Procedures_Evaluation Factors for Award_19AQMM22R0202_A0004.docx	DOCX document	Jul 20, 2022
Attachment C - Instructions to Offerors_Advisory Down-Select Process_19AQMM22R0202_A0004.docx	DOCX document	Jul 20, 2022
Attachment D - Questions and Responses_Finalized_19AQMM22R0202_A0003.xlsx	XLSX spreadsheet	Jul 12, 2022
Attachment F - Past Performance Questionnaire_19AQMM22R0202_A0003.docx	DOCX document	Jul 12, 2022
19AQMM22R0202 - A0003.pdf	PDF	Jul 12, 2022
Attachment E - Evaluation Procedures_Evaluation Factors for Award_19AQMM22R0202_A0003.docx	DOCX document	Jul 12, 2022
Attachment C - Instructions to Offerors_Advisory Down-Select Process_19AQMM22R0202_A0003.docx	DOCX document	Jul 12, 2022
19AQMM22R0202 - A0002.pdf	PDF	Jun 29, 2022
Attachment F - Past Performance Questionnaire_19AQMM22R0202.docx	DOCX document	Jun 29, 2022
Attachment G - Bidders DDForm254_Solicitation_19AQMM22R0202.pdf	PDF	Jun 29, 2022
19AQMM22R0202 - A0002.pdf	PDF	Jun 29, 2022
Attachment F - Past Performance Questionnaire_19AQMM22R0202.docx	DOCX document	Jun 27, 2022
19AQMM22R0202 - A0001.pdf	PDF	Jun 24, 2022
19AQMM22R0202.pdf	PDF	Jun 23, 2022
Attachment C - Instructions to Offerors_Advisory Down-Select Process_19AQMM22R0202.docx	DOCX document	Jun 23, 2022
Attachment C - Instructions to Offerors_Advisory Down-Select Process_19AQMM22R0202.docx	DOCX document	Jun 23, 2022
Attachment D - Questions and Responses Template_19AQMM22R0202.xlsx	XLSX spreadsheet	Jun 23, 2022
19AQMM22R0202.pdf	PDF	Jun 23, 2022
Attachment E - Evaluation Procedures_Evaluation Factors for Award_19AQMM22R0202.docx	DOCX document	Jun 23, 2022
Data Analytics Statement of Work_RPPR_FINAL.docx	DOCX document	Jun 23, 2022
Attachment A - Labor Categories_Position Decriptions_19AQMM22R0202.docx	DOCX document	Jun 23, 2022

Show all 22

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.

Instructions

Pricing Template Instructions (Labor Categories are in Attachment ???)
Not To Exceed (NTE) Labor Rates
-	Each of the labor categories provides a listing of all R/PPR Analytics labor categories to be priced
-	There is one tab for the Base Period and one tab for each of the 4 Option Periods
-	For each labor category, offerors shall enter a base rate and additional dollar amounts for Overhead, G&A, Fringe and Profit
-	The total Burdened Rate for each labor category shall be calculated automatically using Excel Formulas as the sum of the component prices entered

Total Evaluated Price
-	NOTE: The labor mix and FTE counts for this sample task are for evaluation purposes only and do not represent any current or future planned task orders.
-	The total evaluated price will be calculated automatically by applying the Offerors proposed labor rates from the labor category tabs to the sample LOE of 1,920 hours.
Protected Workbook
-	Offerors shall provide their proposed pricing using this pricing template - not alternative formats will be accepted
-	The tables in this pricing workbook have been protected to prevent editing or changing the structure and format of the pricing tables
-	Offerors shall enter their pricing information where requested and shall not modify or edit the format or structure of the pricing workbook
-	Offerors submitting modified files with different formats/structures will have their pricing proposal deemed non-responsive and will be removed from further consideration for award
Cumulative Totals
-	Offerors shall provide their cumulative proposed pricing on the last sheet labeled "Cumulative".
-	It will be the Offerors responsibility to verify the correctness of the amounts or will be subject to having their pricing proposal deemed non-responsive and will be removed from further consideration for award.

&1#&"Times New Roman"&10&K000000SBU - CONTRACTING AND ACQUISITIONS

Cumulative

Data Analytics Sample Task Order
FOR EVALUATION PURPOSES ONLY
* The labor mix and hourly rates for this sample task are for evaluation purposes only and do not represent any current or future planned task orders. In the table below, mutiply the loaded/burdened hourly rate x 1,920 hours to establish the rates for each labor category for the Base Year plus each Option Year FAILURE TO DO SO will consider the proposal to be non-responsive and NO FURTHER evauations will be made.
Labor Category	Total Evaluated Price*
	Base	OY 1	OY 2	OY 3	OY 4	TOTAL
Program Manager
Program Analysts
Chief Analyst
Level IV Analyst
Level III Analyst
Level II Analyst
Level I Analyst
Area Leads
Consultation Lead - Level I
Consultation Lead - Level II
Measurement Lead - Level I
Measurement Lead - Level II
Marketing and Strategic Planning Lead - Level I
Marketing and Strategic Planning Lead - Level II
Data and Social Science Lead - Level I
Data and Social Science Lead - Level II
Innovation Lead
Trainers
Trainers

Total Evaluated Price*
	Total Proposed Price	$0

&1#&"Times New Roman"&10&K000000SBU - CONTRACTING AND ACQUISITIONS

BASE

Attachment B_Not-To-Exceed, Fully-Loaded Hourly Labor Rates.Pricing.19AQMM22R0202
Data Analytics	Note: Offeror shall fill in the Base Rate, Overhead, G&A, Fringe, and Profit amounts comprising the fully Burdened Rate using EXCEL Formulas to arrive at the Burdened Rate.
Breakdown of NTE Hourly Rates by Labor Category

BASE YEAR HOURLY RATES

Labor Category	Base Rate	Overhead	G&A	Fringe	Profit	Burdened Rate
1.1 Program Analysts
Chief Analyst
Level IV Analyst
Level III Analyst
Level II Analyst
Level I Analyst
1.2 Area Leads
Consultation Lead - Level I
Consultation Lead - Level II
Measurement Lead - Level I
Measurement Lead - Level II
Marketing & Strategic Planning Lead - Level I
Marketing & Strategic Planning Lead - Level II
Data and Social Science Lead - Level I
Data and Social Science Lead - Level II
Innovation Lead
1.3 Trainers
Trainers

&1#&"Times New Roman"&10&K000000SBU - CONTRACTING AND ACQUISITIONS

OY 1

Attachment B_Not-To-Exceed, Fully-Loaded Hourly Labor Rates.Pricing.19AQMM22R0202
Data Analytics	Note: Offeror shall fill in the Base Rate, Overhead, G&A, Fringe, and Profit amounts comprising the fully Burdened Rate using EXCEL Formulas to arrive at the Burdened Rate.
Breakdown of NTE Hourly Rates by Labor Category

OPTION YEAR HOURLY RATES

Labor Category	Base Rate	Overhead	G&A	Fringe	Profit	Burdened Rate
1.1 Program Analysts
Chief Analyst
Level IV Analyst
Level III Analyst
Level II Analyst
Level I Analyst
1.2 Area Leads
Consultation Lead - Level I
Consultation Lead - Level II
Measurement Lead - Level I
Measurement Lead - Level II
Marketing & Strategic Planning Lead - Level I
Marketing & Strategic Planning Lead - Level II
Data and Social Science Lead - Level I
Data and Social Science Lead - Level II
Innovation Lead
1.3 Trainers
Trainers

&1#&"Times New Roman"&10&K000000SBU - CONTRACTING AND ACQUISITIONS

OY 2

Attachment B_Not-To-Exceed, Fully-Loaded Hourly Labor Rates.Pricing.19AQMM22R0202
Data Analytics	Note: Offeror shall fill in the Base Rate, Overhead, G&A, Fringe, and Profit amounts comprising the fully Burdened Rate using EXCEL Formulas to arrive at the Burdened Rate.
Breakdown of NTE Hourly Rates by Labor Category

OPTION YEAR 2 HOURLY RATES

Labor Category	Base Rate	Overhead	G&A	Fringe	Profit	Burdened Rate
1.1 Program Analysts
Chief Analyst
Level IV Analyst
Level III Analyst
Level II Analyst
Level I Analyst
1.2 Area Leads
Consultation Lead - Level I
Consultation Lead - Level II
Measurement Lead - Level I
Measurement Lead - Level II
Marketing & Strategic Planning Lead - Level I
Marketing & Strategic Planning Lead - Level II
Data and Social Science Lead - Level I
Data and Social Science Lead - Level II
Innovation Lead
1.3 Trainers
Trainers

&1#&"Times New Roman"&10&K000000SBU - CONTRACTING AND ACQUISITIONS

Oy 3

Attachment B_Not-To-Exceed, Fully-Loaded Hourly Labor Rates.Pricing.19AQMM22R0202
Data Analytics	Note: Offeror shall fill in the Base Rate, Overhead, G&A, Fringe, and Profit amounts comprising the fully Burdened Rate using EXCEL Formulas to arrive at the Burdened Rate.
Breakdown of NTE Hourly Rates by Labor Category

OPTION YEAR 3 HOURLY RATES

Labor Category	Base Rate	Overhead	G&A	Fringe	Profit	Burdened Rate
1.1 Program Analysts
Chief Analyst
Level IV Analyst
Level III Analyst
Level II Analyst
Level I Analyst
1.2 Area Leads
Consultation Lead - Level I
Consultation Lead - Level II
Measurement Lead - Level I
Measurement Lead - Level II
Marketing & Strategic Planning Lead - Level I
Marketing & Strategic Planning Lead - Level II
Data and Social Science Lead - Level I
Data and Social Science Lead - Level II
Innovation Lead
1.3 Trainers
Trainers

&1#&"Times New Roman"&10&K000000SBU - CONTRACTING AND ACQUISITIONS

OY 4

Attachment B_Not-To-Exceed, Fully-Loaded Hourly Labor Rates.Pricing.19AQMM22R0202
Data Analytics	Note: Offeror shall fill in the Base Rate, Overhead, G&A, Fringe, and Profit amounts comprising the fully Burdened Rate using EXCEL Formulas to arrive at the Burdened Rate.
Breakdown of NTE Hourly Rates by Labor Category

OPTION YEAR 4 HOURLY RATES

Labor Category	Base Rate	Overhead	G&A	Fringe	Profit	Burdened Rate
1.1 Program Analysts
Chief Analyst
Level IV Analyst
Level III Analyst
Level II Analyst
Level I Analyst
1.2 Area Leads
Consultation Lead - Level I
Consultation Lead - Level II
Measurement Lead - Level I
Measurement Lead - Level II
Marketing & Strategic Planning Lead - Level I
Marketing & Strategic Planning Lead - Level II
Data and Social Science Lead - Level I
Data and Social Science Lead - Level II
Innovation Lead
1.3 Trainers
Trainers

&1#&"Times New Roman"&10&K000000SBU - CONTRACTING AND ACQUISITIONS

File details come from the government source that posted it. Updated Jun 23, 2022.