Attachment D_IDIQ Pricing Worksheet.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
CTP Public Education Campaign Federal contract opportunity
Solicitation number
RFP_FDA-SOL-1230974
Issued by
Department of Health and Human Services Food and Drug Administration Office of Acquisition and Grant Services

About this file

Written by GovTribe AI ·

This document contains a pricing worksheet template and details of a federal contract opportunity. The pricing worksheet is for an indefinite delivery, indefinite quantity contract with a ceiling of $900 million over five one-year ordering periods to provide technical services supporting public education campaigns for the FDA Center for Tobacco Products. Services include formative research, planning, developing, producing, and delivering consumer communication programs and paid media campaigns through multiple channels. The goal is to educate the public, especially youth, about the dangers of tobacco product use and reduce tobacco-related disease and death. Target audiences include both national groups and niche segments defined by geographic, demographic, psychographic, socioeconomic and cultural factors.

View the file

Other files for this federal contract opportunity

Other files attached to CTP Public Education Campaign, newest first.
File Type Posted
Amend2_Attachment G_Question Submittal Form.xlsx XLSX spreadsheet
Amend1_RFP_FDA-SOL-1230974.pdf PDF
Attachment J_HHS Small Business Subcontracting Plan Template.doc DOC document
Attachment A_Campaign Backgrounds 10.6.20.pdf PDF
Attachment E_Standard Form LLL Disclosure of Lobbying Activities.pdf PDF
Attachment H_Relevant Experience Form.docx DOCX document
Attachment C_ Wage Determinations.pdf PDF
Attachment I_PPQ.docx DOCX document
Attachment F_Labor Category Descriptions.docx DOCX document
RFP_FDA-SOL-1230974.docx DOCX document
Attachment G_Question Submittal Form.xlsx XLSX spreadsheet
Attachment B_FAR Deviation 18-01 (Whistleblower Protection-Commercial).pdf PDF
Show all 12

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.

PRICING

Attachment D: Pricing Worksheet;

Solicitation No. FDA-RFP-

Offeror Name:
The Offeror shall perform the work described in the Statement of Work to support the U.S. Food and Drug Administration. The resultant award shall be a five (5)-year, Indefinite Delivery-Indefinite Quantity (IDIQ) contract with a ceiling of $900,000,000 and five (5) 12-month ordering periods.Offeror DUNS:Material Handling Fee (%)
Instructions: Offers are to complete only the yellow highlighted portions of the spreadsheet. No other cells shall be altered in any way, or offers may be deemed non-responsive.Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 5
Ordering Period 1(12 months)(12 months)(12 months)(12 months)
(12 months)Escalation Rate (%):Escalation Rate (%):Escalation Rate (%):Escalation Rate (%):
Labor Categories
SCLS applicable? (Yes/No)Fully-Burdened Labor Rate (Incl. Fee)Estimated Labor HoursFull-Time Equivalents (FTEs)Total CostFully-Burdened Labor Rate (Incl. Fee)Estimated Labor HoursFull-Time Equivalents (FTEs)Total CostFully-Burdened Labor Rate (Incl. Fee)Estimated Labor HoursFull-Time Equivalents (FTEs)Total CostFully-Burdened Labor Rate (Incl. Fee)Estimated Labor HoursFull-Time Equivalents (FTEs)Total CostFully-Burdened Labor Rate (Incl. Fee)Estimated Labor HoursFull-Time Equivalents (FTEs)Total Cost
Account DirectorNo$ - 011000$ - 0$ - 011000$ - 0$ - 011000$ - 0$ - 011000$ - 0$ - 011000$ - 0
Account ManagerNo$ - 04400$ - 0$ - 04400$ - 0$ - 04400$ - 0$ - 04400$ - 0$ - 04400$ - 0
AnalystNo$ - 06500$ - 0$ - 06500$ - 0$ - 06500$ - 0$ - 06500$ - 0$ - 06500$ - 0
Art BuyerNo$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0
Art Director/DesignerNo$ - 05000$ - 0$ - 05000$ - 0$ - 05000$ - 0$ - 05000$ - 0$ - 05000$ - 0
Assistant Account ExecutiveNo$ - 05004$ - 0$ - 05004$ - 0$ - 05004$ - 0$ - 05004$ - 0$ - 05004$ - 0
Assistant ProducerNo$ - 04000$ - 0$ - 04000$ - 0$ - 04000$ - 0$ - 04000$ - 0$ - 04000$ - 0
Associate Creative DirectorNo$ - 04500$ - 0$ - 04500$ - 0$ - 04500$ - 0$ - 04500$ - 0$ - 04500$ - 0
Broadcast Traffic SupervisorNo$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0
Contract ManagerNo$ - 01250$ - 0$ - 01250$ - 0$ - 01250$ - 0$ - 01250$ - 0$ - 01250$ - 0
CopywriterYes - 30463$ - 09000$ - 0$ - 09000$ - 0$ - 09000$ - 0$ - 09000$ - 0$ - 09000$ - 0
Creative DirectorNo$ - 03500$ - 0$ - 03500$ - 0$ - 03500$ - 0$ - 03500$ - 0$ - 03500$ - 0
Digital Account ProfessionalNo$ - 03000$ - 0$ - 03000$ - 0$ - 03000$ - 0$ - 03000$ - 0$ - 03000$ - 0
Digital Project ManagerNo$ - 04000$ - 0$ - 04000$ - 0$ - 04000$ - 0$ - 04000$ - 0$ - 04000$ - 0
Digital StrategistNo$ - 08000$ - 0$ - 08000$ - 0$ - 08000$ - 0$ - 08000$ - 0$ - 08000$ - 0
Director, AnalyticsNo$ - 02500$ - 0$ - 02500$ - 0$ - 02500$ - 0$ - 02500$ - 0$ - 02500$ - 0
Director, Broadcast ProductionNo$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0
Director, Experience ArchitectureNo$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0
EVP Chief Analytics OfficerNo$ - 0150$ - 0$ - 0150$ - 0$ - 0150$ - 0$ - 0150$ - 0$ - 0150$ - 0
Executive VP/General ManagerNo$ - 0800$ - 0$ - 0800$ - 0$ - 0800$ - 0$ - 0800$ - 0$ - 0800$ - 0
Graphic DesignerYes - 15080$ - 08000$ - 0$ - 08000$ - 0$ - 08000$ - 0$ - 08000$ - 0$ - 08000$ - 0
Interactive and Social Media DirectorNo$ - 02500$ - 0$ - 02500$ - 0$ - 02500$ - 0$ - 02500$ - 0$ - 02500$ - 0
Junior Media PlannerNo$ - 012000$ - 0$ - 012000$ - 0$ - 012000$ - 0$ - 012000$ - 0$ - 012000$ - 0
Media PlannerNo$ - 014000$ - 0$ - 014000$ - 0$ - 014000$ - 0$ - 014000$ - 0$ - 014000$ - 0
Media Planning, Buying & Measurement DirectorNo$ - 03000$ - 0$ - 03000$ - 0$ - 03000$ - 0$ - 03000$ - 0$ - 03000$ - 0
Media StrategistNo$ - 07000$ - 0$ - 07000$ - 0$ - 07000$ - 0$ - 07000$ - 0$ - 07000$ - 0
Media SupervisorNo$ - 09050$ - 0$ - 09050$ - 0$ - 09050$ - 0$ - 09050$ - 0$ - 09050$ - 0
Partnerships StrategistNo$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0
Print Production ManagerNo$ - 0200$ - 0$ - 0200$ - 0$ - 0200$ - 0$ - 0200$ - 0$ - 0200$ - 0
ProducerNo$ - 04000$ - 0$ - 04000$ - 0$ - 04000$ - 0$ - 04000$ - 0$ - 04000$ - 0
ProofreaderNo$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0
Public Relations StrategistNo$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0
Quality Assurance SpecialistNo$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0
Research DirectorNo$ - 03500$ - 0$ - 03500$ - 0$ - 03500$ - 0$ - 03500$ - 0$ - 03500$ - 0
Research ManagerNo$ - 012000$ - 0$ - 012000$ - 0$ - 012000$ - 0$ - 012000$ - 0$ - 012000$ - 0
Senior Account ManagerNo$ - 014000$ - 0$ - 014000$ - 0$ - 014000$ - 0$ - 014000$ - 0$ - 014000$ - 0
Senior Art Director/Senior DesignerNo$ - 012000$ - 0$ - 012000$ - 0$ - 012000$ - 0$ - 012000$ - 0$ - 012000$ - 0
Senior Broadcast ProducerNo$ - 01500$ - 0$ - 01500$ - 0$ - 01500$ - 0$ - 01500$ - 0$ - 01500$ - 0
Senior Talent ManagerNo$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0$ - 0500$ - 0
Senior Vice PresidentNo$ - 01500$ - 0$ - 01500$ - 0$ - 01500$ - 0$ - 01500$ - 0$ - 01500$ - 0
Strategy and Planning DirectorNo$ - 03500$ - 0$ - 03500$ - 0$ - 03500$ - 0$ - 03500$ - 0$ - 03500$ - 0
Traffic Manager/Production ManagerNo$ - 0400$ - 0$ - 0400$ - 0$ - 0400$ - 0$ - 0400$ - 0$ - 0400$ - 0
VideographerYes - 13074$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0$ - 01000$ - 0
Web DeveloperNo$ - 03000$ - 0$ - 03000$ - 0$ - 03000$ - 0$ - 03000$ - 0$ - 03000$ - 0
191,254- 0$ - 0191,254- 0$ - 0191,254- 0$ - 0191,254- 0$ - 0191,254- 0$ - 0
SUB TOTALSOrdering Period 1$ - 0Ordering Period 2$ - 0Ordering Period 3$ - 0Ordering Period 4$ - 0Ordering Period 5$ - 0
GRAND TOTAL$ - 0

NOTES and ASSUMPTIONS Offerors shall use this space to include any assumptions being made that affect pricing, as well as any relevant notes:

File details come from the government source that posted it. Updated .