Attachment III - Pricing Worksheet.xlsx

XLSX spreadsheet 121 KB Posted Jul 1, 2020

Attached to: Computerized Labeling Assessment Tool (CLAT) Services Federal contract opportunity
Solicitation number: FDA-20-SOL-1223486
Issued by: Department of Health and Human Services Food and Drug Administration

View the file

Other files for this federal contract opportunity

Other files attached to Computerized Labeling Assessment Tool (CLAT) Services, newest first.
File	Type	Posted
FDA-20-SOL-1223486 Instructions AMENDED II.pdf	PDF	Jul 23, 2020
Attachment II - CLAT TO SOW AMENDED II.pdf	PDF	Jul 21, 2020
Attachment III - Pricing Worksheet AMENDED.xlsx	XLSX spreadsheet	Jul 16, 2020
FDA-20-SOL-1223486 Instructions AMENDED.pdf	PDF	Jul 16, 2020
Contractor Question- Answers CDER CLAT RFP No. FDA-20-SOL-1223486.pdf	PDF	Jul 16, 2020
Attachment II - CLAT TO SOW AMENDED.pdf	PDF	Jul 16, 2020
Attachment IV - FAR Provision 52.212-3.docx	DOCX document	Jul 1, 2020
Attachment VII - Drug Product Labeling Submission and Review Process Use Case.docx	DOCX document	Jul 1, 2020
Attachment I - CLAT IDIQ SOW.pdf	PDF	Jul 1, 2020
Attachment V - Commitment Letter.doc	DOC document	Jul 1, 2020
Attachment II - CLAT TO SOW.pdf	PDF	Jul 1, 2020
Attachment VI - EPLC Agile.pdf	PDF	Jul 1, 2020
FDA-20-SOL-1223486 Instructions.pdf	PDF	Jul 1, 2020
Attachment VIII - CLAT Labeling Review Examples.xlsx	XLSX spreadsheet	Jul 1, 2020
Attachment IX - VPAT 2.3.docx	DOCX document	Jul 1, 2020

Show all 15

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.

Cover

U.S. Food and Drug Administration

Control Labeling Assessment Tool (CLAT) Development and Operations and Maintenance IDIQ

Vendor:

Indefinite Delivery Indefinite Quantity Pricing Sheet

Instructions

U.S. Food and Drug Administration

CLAT IDIQ

Indefinite Delivery / Indefinite Quantity General Proposal Information and Instructions

General Information & Instructions
1 -	The Offeror shall fill in the pricing tables on the following pages and include their name at the top of each page.
2 -	The Offeror shall fill in only the orange toned cells on all of the pages. Do not touch any cells on the Summary page as it does not have any fill-ins.
3 -	The Offeror shall not change, delete, or alter the Government-provided informatio in the pricing sheet and fill in only the columns specified per page.
4 -	Travel is separate from ODC's. ODC's are prefilled in order to evaluate all offerors responses equally.
5 -	The price evaluated based on the Pricing Spreadsheets is for evaluation purposes only.
6 -	The Offeror shall submit the pricing sheet in Microsoft Excel format (xls or xlsx file type) and all cells shall be unlocked
	(unprotected). The FDA shall be able to view all formulas and perform calculations within the Pricing Sheet.

Labor Rates

Vendor:

CLAT IDIQ

IDIQ Labor Rates

Labor Category	Ordering Period I (12 Months) Labor Hours (Est.)	Ordering Period I (12 Months) Loaded Labor Rate	Ordering Period I (12 Months)	Ordering Period II (12 Months) Labor Hours (Est.)	Ordering Period II (12 Months) Labor Rates	Ordering Period II (12 Months)	Ordering Period III (12 Months) Labor Hours (Est.)	Ordering Period III (12 Months) Labor Rates	Ordering Period III (12 Months)	Ordering Period IV (12 Months) Labor Hours (Est.)	Ordering Period IV (12 Months) Labor Rates	Ordering Period IV (12 Months)	Ordering Period V (12 Months) Labor Hours (Est.)	Ordering Period V (12 Months) Labor Rates	Ordering Period V (12 Months)	*6 Month Option Labor Hours (Est.)	6 Month Option Labor Hours	6 Month Option Labor Hours	TOTAL
Project Manager	1920		ERROR:#VALUE!	1920	$ - 0	$ - 0	1920	$ - 0	$ - 0	1920	$ - 0	$ - 0	1920	$ - 0	$ - 0	1920	$ - 0	$ - 0	ERROR:#VALUE!
Analyst I	1920		$ - 0	1920	$ - 0	$ - 0	1920	$ - 0	$ - 0	1920	$ - 0	$ - 0	1920	$ - 0	$ - 0	1920	$ - 0	$ - 0	$ - 0
DBA II	480		$ - 0	480	$ - 0	$ - 0	480	$ - 0	$ - 0	480	$ - 0	$ - 0	480	$ - 0	$ - 0	480	$ - 0	$ - 0	$ - 0
Software Engineer I	1920		$ - 0	1920	$ - 0	$ - 0	1920	$ - 0	$ - 0	1920	$ - 0	$ - 0	1920	$ - 0	$ - 0	1920	$ - 0	$ - 0	$ - 0
Quality Assurance Specialist	640		$ - 0	640	$ - 0	$ - 0	640	$ - 0	$ - 0	640	$ - 0	$ - 0	640	$ - 0	$ - 0	640	$ - 0	$ - 0	$ - 0
Application Engineer I	640		$ - 0	640	$ - 0	$ - 0	640	$ - 0	$ - 0	640	$ - 0	$ - 0	640	$ - 0	$ - 0	640	$ - 0	$ - 0	$ - 0
Web Software Developer	480		$ - 0	480	$ - 0	$ - 0	480	$ - 0	$ - 0	480	$ - 0	$ - 0	480	$ - 0	$ - 0	480	$ - 0	$ - 0	$ - 0
Senior Cloud Engineer	480		$ - 0	480	$ - 0	$ - 0	480	$ - 0	$ - 0	480	$ - 0	$ - 0	480	$ - 0	$ - 0	480	$ - 0	$ - 0	$ - 0
Quality Assurance Manager	240		$ - 0	240	$ - 0	$ - 0	240	$ - 0	$ - 0	240	$ - 0	$ - 0	240	$ - 0	$ - 0	240	$ - 0	$ - 0	$ - 0
Total Direct Labor Costs		$ - 0	ERROR:#VALUE!		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0	ERROR:#VALUE!

	LABOR RATE USAGE KEY
	Hours	Frequency
	1920	Frequent
	960	Likely
	640	Average
	480	Unlikely
	240	Nominal
*6-Month Oprtion period, still use the chart above, but cut the hours in half.
Offerors are to only input data into the orange tone cells. All other cells are to remain untouched, all formulas are to remain untouched.

Software

Vendor:

CLAT IDIQ

Software

The contractor shall propose a way to purchase the developed software throughout the life of the IDIQ. For the purposes of this evaluation, all quantities shall be based on a monthly cost (QTY. 12).

IDIQ - Software Purchase Increased Quantity
Item Description	Quantity	Ordering Period I Unit Price	Ordering Period I	Ordering Period II Quantity	Ordering Period II Price	Ordering Period II	Ordering Period III Quantity	Ordering Period III Price	Ordering Period II	Ordering Period IV Quantity	Ordering Period IV Price	Ordering Period IV	Ordering Period V Quantity	Ordering Period V Price	Ordering Period V	Extended 6-Month Period Quantity	Extended 6-Month Period Price	Extended 6-Month Period	TOTAL
	12.00	$ - 0	$ - 0	12.00	$ - 0	$ - 0	12.00	$ - 0	$ - 0	12.00	$ - 0	$ - 0	12.00	$ - 0	$ - 0	12.00	$ - 0	$ - 0	$ - 0
	12.00	$ - 0	$ - 0	12.00	$ - 0	$ - 0	12.00	$ - 0	$ - 0	12.00	$ - 0	$ - 0	12.00	$ - 0	$ - 0	12.00	$ - 0	$ - 0	$ - 0
Enter Item		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0	$ - 0
Enter Item		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0		$ - 0	$ - 0	$ - 0
IDIQ Total Material Costs			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0

*Offerors are to only input data into the orange tone cells. All other cells are to remain untouched, all formulas are to remain untouched.

Also, Offeror's are to include any other potential items that would need to included for the cloud computing platform.

Task Order

Vendor:

CLAT IDIQ

Task Order #1 Proposal

The Contractor will develop a plan that will address all of the Task Order's deliverables: Task 1, Prototype for CLAT, Task 2 Projwct Management, and Task 3 Secuity Delierables

Task Order Labor Rates
Task Area	Labor Category	Task Order Base (12 Months) Labor Hours (Est.)	Task Order (12 Months) Loaded Labor Rate	Task Order (12 Months)	6 Month Option Labor Hours	Grand TOTAL
Task 1 Prototype for CLAT
			$ - 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	$ - 0	$ - 0	$ - 0
Task 2 Project Management
			$ - 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	$ - 0	$ - 0	$ - 0
Security Deliverables
			$ - 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	$ - 0	$ - 0	$ - 0
Transition Out Activities (Option)
			$ - 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	$ - 0	$ - 0	$ - 0
	Total Direct Labor Costs			$ - 0	$ - 0	$ - 0

Task Order -Software
Item Description	Quantity	Unit Price	Task Order Total	6 Month Option Labor Hours	Grand TOTAL
Monthly Software Subscription	12.00	$ - 0	$ - 0	$ - 0	$ - 0
Monthly Software Licenses	12.00	$ - 0	$ - 0	$ - 0	$ - 0
Enter Item		$ - 0	$ - 0	$ - 0	$ - 0
Enter Item		$ - 0	$ - 0	$ - 0	$ - 0
Task Order Total Material Costs			$ - 0	$ - 0	$ - 0

Task Order ODC's
Item	QTY.	Cost per Titem	Task Order Total	6 Month Option	Grand TOTAL
Potential ODC's (fixed)	1.00	$ 10,000.00	$ 10,000.00	$ 5,000.00	$ 15,000.00
			$ - 0	$ - 0	$ - 0
			$ - 0	$ - 0	$ - 0
Task Order Total Travel Costs			$ 10,000.00	$ 5,000.00	$ 15,000.00

Summary

U.S. Food and Drug Administration

CLAT IDIQ

IDIQ pricing summary

Instruction(s) for the Indefinite Delivery/ Indefinite Quantity Pricing Summary Sheet (tab)

1 - All cells are automatically populated, do not enter any pricing data into these cells.

Description	Ordering Period I	Ordering Period II	Ordering Period III	Ordering Period IV	Ordering Period V	Extended 6-Month Period	Grand Total
Labor	ERROR:#VALUE!	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#VALUE!
CLAT Software	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
IDIQ Total	ERROR:#VALUE!	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	ERROR:#VALUE!
Task Order (TO)	$ - 0					$ - 0	$ - 0
TO Software	$ - 0					$ - 0	$ - 0
TO ODC's	$ 10,000.00					$ 5,000.00	$ 15,000.00
Task Order Total	$ 10,000.00					$ 5,000.00	$ 15,000.00
IDIQ + Task Order Total	ERROR:#VALUE!	$ - 0	$ - 0	$ - 0	$ - 0	$ 5,000.00	ERROR:#VALUE!

* Total Value will be inflated, however ocerall IDIQ ceiling is $5M

Notes and Assumptions

Vendor:

U.S. Food and Drug Administration

CLAT IDIQ

Indefinite Delivery/ Indefinite Quantity Notes & Assumptions Sheet

Instruction(s) for completing the BPA Notes & Assumptions Sheet (tab)

1 - The Contractor shall clearly list all pricing notes and assumptions used in the development of its price quotation.

2 - Assumptions conflicting with the solicitation may be deem Unsatisfactory and may not be considered for award.

Assumption(s)

1 -

2 -

3 -

4 -

5 -

6 -

7 -image1.png image2.jpeg

File details come from the government source that posted it. Updated Jul 1, 2020.