Attachment_B_Pricing_Scenario_Spreadsheet.xlsx

XLSX spreadsheet 15 KB Posted Oct 16, 2019

Attached to: Accelerating Change and Transformation in Organizations and Networks (ACTION) IV IDIQ
Solicitation number: AHRQ-20-10005
Issued by: Department of Health and Human Services Agency for Healthcare Research and Quality Headquarters

About this file

From the source

Attachment B Pricing Scenario Spreadsheet

View the file

Other files

File	Type	Posted
Attachment_A_Technical_Proposal_Template_Amendment_01.docx	DOCX document	Nov 7, 2019
RFP_AHRQ-20-10005_Amendment_01.pdf	PDF	Nov 7, 2019
Responses_to_Offeror_Questions_AHRQ-20-10005.pdf	PDF	Nov 7, 2019
Attachment_B_Pricing_Scenario_Spreadsheet_Amendment_01.xlsx	XLSX spreadsheet	Nov 7, 2019
Attachment_C_Small_Business_Subcontracting_Plan.docx	DOCX document	Oct 16, 2019
RFP_AHRQ-20-10005_ACTION_4.pdf	PDF	Oct 16, 2019
Attachment_D_AHRQ_Information_Security_and_Privacy_Requirements.docx	DOCX document	Oct 16, 2019
Attachment_A_Technical_Proposal_Template.docx	DOCX document	Oct 16, 2019
DRAFT_SOW_AHRQ-20-10005.pdf	PDF	Oct 2, 2019

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.

Tab 1 - Section B

Section B
Ordering Period - Year 1
Labor Class	Fully Burdened Hourly Rate
Class I – Senior
Class II – Associate
Class III – Intermediate
Class IV – Junior
Class V – Other Technical
Class VI - Clerical
Ordering Period - Year 2
Labor Class	Fully Burdened Hourly Rate
Class I – Senior
Class II – Associate
Class III – Intermediate
Class IV – Junior
Class V – Other Technical
Class VI - Clerical
Ordering Period - Year 3
Labor Class	Fully Burdened Hourly Rate
Class I – Senior
Class II – Associate
Class III – Intermediate
Class IV – Junior
Class V – Other Technical
Class VI - Clerical
Ordering Period - Year 4
Labor Class	Fully Burdened Hourly Rate
Class I – Senior
Class II – Associate
Class III – Intermediate
Class IV – Junior
Class V – Other Technical
Class VI - Clerical
Ordering Period - Year 5
Labor Class	Fully Burdened Hourly Rate
Class I – Senior
Class II – Associate
Class III – Intermediate
Class IV – Junior
Class V – Other Technical
Class VI - Clerical

Tab 2 - Pricing Scenario Pricing Scenario - Ordering Period Year 1 Rates

Labor Categories	Hours	Fully Burdened Hourly Rates	Total Cost
Class I - Senior	250		$ - 0
Class II - Associate	1700		$ - 0
Class III - Intermediate	1500		$ - 0
Class IV- Junior	750		$ - 0
Class V - Other Technical	1000		$ - 0
Class VI - Clerical	300		$ - 0
Total - Loaded Labor Cost			$ - 0

Tab 3 - Calculations

Ordering Period Year 1
Labor Class	Unloaded Rate	% Fringe	Subtotal	% Overhead	Subtotal	% G&A	Total before fee	% Fee	Fully Burdened Hourly Rate
Class I – Senior
Class II – Associate
Class III – Intermediate
Class IV – Junior
Class V – Other Technical
Class VI - Clerical

Ordering Period Year 2
Labor Class	Unloaded Rate	% Fringe	Subtotal	% Overhead	Subtotal	% G&A	Total before fee	% Fee	Fully Burdened Hourly Rate
Class I – Senior
Class II – Associate
Class III – Intermediate
Class IV – Junior
Class V – Other Technical
Class VI - Clerical
Ordering Period Year 3
Labor Class	Unloaded Rate	% Fringe	Subtotal	% Overhead	Subtotal	% G&A	Total before fee	% Fee	Fully Burdened Hourly Rate
Class I – Senior
Class II – Associate
Class III – Intermediate
Class IV – Junior
Class V – Other Technical
Class VI - Clerical
Ordering Period Year 4
Labor Class	Unloaded Rate	% Fringe	Subtotal	% Overhead	Subtotal	% G&A	Total before fee	% Fee	Fully Burdened Hourly Rate
Class I – Senior
Class II – Associate
Class III – Intermediate
Class IV – Junior
Class V – Other Technical
Class VI - Clerical
Ordering Period Year 5
Labor Class	Unloaded Rate	% Fringe	Subtotal	% Overhead	Subtotal	% G&A	Total before fee	% Fee	Fully Burdened Hourly Rate
Class I – Senior
Class II – Associate
Class III – Intermediate
Class IV – Junior
Class V – Other Technical
Class VI - Clerical

File details come from the government source that posted it.