47QDCB21R0002 Att 6 sample Task Order SIP 2021-10-25.xlsx

XLSX spreadsheet 23 KB Posted Oct 26, 2021

Attached to: Market Services in Support of National Marketing and Communications Division
Solicitation number: 47QDCB21R0002
Issued by: General Services Administration Federal Acquisition Service Assisted Acquisition Services Region 5

View the file

Other files

File	Type	Posted
47QDCB21R0002 Addendum 1.pdf	PDF	Nov 15, 2021
47QDCB21R0002 Att 6 sample Task Order SIP Updated.xlsx	XLSX spreadsheet	Nov 15, 2021
47QDCB21R0002 Att 2 Slip Sheet Task Order SOW 2021-10-25.docx	DOCX document	Oct 26, 2021
47QDCB21R0002.pdf	PDF	Oct 26, 2021
47QDCB21R0002 Att 1 IDIQ SIP 2021-10-25.xlsx	XLSX spreadsheet	Oct 26, 2021
47QDCB21R0002 Att 5 sample Task Order SOW 2021-10-25.docx	DOCX document	Oct 26, 2021
47QDCB21R0002 Att 3 Slip Sheet Task Order SAMPLE 2021-10-25.pdf	PDF	Oct 26, 2021
47QDCB21R0002 Att 4 Slip Sheet SIP 2021-10-25.xlsx	XLSX spreadsheet	Oct 26, 2021

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.

Price Totals

Project: 2022 SAMPLE Task Order	Note: Blue text are calculated cells
Solicitation Number: 47QDCB21R0002 Attachment 6	Note: Quantities shall be entered by the offeror based on understanding of the statement of work
Project Number: TBD	Project Budget:

				Enter FFP
				↓↓↓↓↓↓
CLIN	Description	Quantity	Unit	Unit Price	FFP Total	Notes
					Amount

	Ad and Media Development
0001a1	Native Content on LinkedIn - initial draft	12	lot	$0.00	$0.00	1 lot per month - Supported by labor hour backup
0001a2	Native Content on LinkedIn - first revision	12	lot	$0.00	$0.00	1 lot per month - Supported by labor hour backup
0001a3	Native Content on LinkedIn - second revision	12	lot	$0.00	$0.00	1 lot per month - Supported by labor hour backup
	Sub-total				$0.00	Supported by labor hour backup
				Enter FFP
				↓↓↓↓↓↓
	Ad and Media Development	Quantity	Unit	Unit Price
0001b1	Display Ads on Select Outlets - initial draft	20	each	$0.00	$0.00
0001b2	Display Ads on Select Outlets - first revision	20	each	$0.00	$0.00
0001b3	Display Ads on Select Outlets - second revision	20	each	$0.00	$0.00
	Sub-total				$0.00	Supported by labor hour backup
				Enter FFP
				↓↓↓↓↓↓
	Ad and Media Development	Quantity	Unit	Unit Price
0001c1	5 Minute Video - initial draft	15	each	$0.00	$0.00
0001c2	5 Minute Video - first revision	15	each	$0.00	$0.00
0001c3	5 Minute Video - first revision	15	each	$0.00	$0.00
	Sub-total				$0.00	Supported by labor hour backup
				Enter FFP
				↓↓↓↓↓↓
	Ad and Media Development - Paid Search Google & Bing	Quantity	Unit	Unit Price
0001d1	Target parameters & ad language - initial draft	12	each	$0.00	$0.00
0001d2	Target parameters & ad language - first revision	12	each	$0.00	$0.00
0001d3	Target parameters & ad language - first revision	12	each	$0.00	$0.00
	Sub-total				$0.00	Supported by labor hour backup
				Enter FFP
				↓↓↓↓↓↓
	Ad and Media Development	Quantity	Unit	Unit Price
0001e1	Welcome ad - initial draft	20	each	$0.00	$0.00
0001e2	Welcome ad - first revision	20	each	$0.00	$0.00
0001e3	Welcome ad - second revision	20	each	$0.00	$0.00
	Sub-total				$0.00	Supported by labor hour backup
				Enter FFP
				↓↓↓↓↓↓
	Ad and Media Development	Quantity	Unit	Unit Price
0001f1	Graphic Media (infographics, gifs) - initial draft	15	each	$0.00	$0.00
0001f2	Graphic Media (infographics, gifs) - first revision	15	each	$0.00	$0.00
0001f3	Graphic Media (infographics, gifs) - second revision	15	each	$0.00	$0.00
	Sub-total				$0.00	Supported by labor hour backup

SUB-TOTAL LABOR COSTS - Creative Services $0.00

				Enter FFP
				↓↓↓↓↓↓
		Quantity	Unit	Unit Price
0002A	Develop Media Plan - Draft	1	each	$0.00	$0.00
0002B	Develop Media Plan - Final	1	each	$0.00	$0.00
	Sub-total				$0.00	Supported by labor hour backup

				Enter FFP
				↓↓↓↓↓↓
		Quantity	Unit	Unit Price
0003	Execute Media Plan (Purchase and Manage Media)	12	months	$0.00	$0.00	Supported by labor hour backup

				Enter FFP
				↓↓↓↓↓↓
		Quantity	Unit	Unit Price
0004	Track Metrics, Analyze and Report
	Track and Analyze	12	months	$0.00	$0.00
	Weekly Report	52	weeks	$0.00	$0.00
	Monthly Report	12	months	$0.00	$0.00
	Final Report	1	each	$0.00	$0.00
	Update Reporting Dashboard	12	months	$0.00	$0.00
	Labor Hour Sub-Total				$0.00	Supported by labor hour backup

SUB-TOTAL LABOR COSTS - Media Plan Development, Execution, Tracking $0.00

				DO NOT ENTER
				↓↓↓↓↓↓
0005	Media Purchase - Native Content on LinkedIn	1	lot	$12,000.00	$12,000.00
0006	Media Purchase - Display Ads on Select Outlets	1	lot	$400,000.00	$400,000.00
0007	Media Purchase - 5 Minute Videos on Select Outlets	1	lot	$50,000.00	$50,000.00
0008	Media Purchase - Paid Search on Google	1	lot	$85,000.00	$85,000.00
0009	Media Purchase - Paid Search on Bing	1	lot	$15,000.00	$15,000.00
0010	Media Purchase - Welcome Ads on Select Outlets	1	lot	$12,000.00	$12,000.00

SUB-TOTAL MEDIA PURCHASES - Not to Exceed $574,000.00

TOTAL - (not to exceed) $574,000.00

Labor Hour Backup

Project: 2022 SAMPLE Task Order	Note: Blue text are calculated cells
Solicitation Number: 47QDCB21R0002 Attachment 6	Note: Quantities shall be entered by the offeror offeror based on understanding of the statement of work
Project Number: TBD
Enter the labor category, quantity, and rate information for all categories that apply to this task order from the IDIQ Schedule of Items and Prices. Add rows if you are quoting more than 7 labor catagories for any objective.	LABOR COSTS IN SUPPORT OF

FIXED PRICED ITEMS

AD and MEDIA DEVELOPMENT (Creative)

Objective 1a Native Content on LinkedIn
Enter Proposed Labor Category	Enter Qty		Enter Rate
↓↓↓↓↓↓	↓↓↓↓↓↓		↓↓↓↓↓↓
Description	Quantity	Unit	IDIQ Rate	Total
				Amount
x	0	hrs	$5.00	$0.00
x	0	hrs	$1.00	$0.00
x	0	hrs	$1.00	$0.00
x	0	hrs	$1.00	$0.00
x	0	hrs	$1.00	$0.00
x	0	hrs	$1.00	$0.00
x	0	hrs	$1.00	$0.00
Labor Hour Sub-Total	0			$0.00

Objective 1b Use of Display Ads on Select Outlets
Enter Proposed Labor Category	Enter Qty		Enter Rate
↓↓↓↓↓↓	↓↓↓↓↓↓		↓↓↓↓↓↓
Description	Quantity	Unit	IDIQ Rate	Total
				Amount
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
Labor Hour Sub-Total	0			$0.00

Objective 1c Develop Short Videos & Posts
Enter Proposed Labor Category	Enter Qty		Enter Rate
↓↓↓↓↓↓	↓↓↓↓↓↓		↓↓↓↓↓↓
Description	Quantity	Unit	IDIQ Rate	Total
				Amount
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
Labor Hour Sub-Total	0			$0.00

Objective 1d Paid Search on Google and Bing
Enter Proposed Labor Category	Enter Qty		Enter Rate
↓↓↓↓↓↓	↓↓↓↓↓↓		↓↓↓↓↓↓
Description	Quantity	Unit	IDIQ Rate	Total
				Amount
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
Labor Hour Sub-Total	0			$0.00

Objective 1e Digital Ad Creation
Enter Proposed Labor Category	Enter Qty		Enter Rate
↓↓↓↓↓↓	↓↓↓↓↓↓		↓↓↓↓↓↓
Description	Quantity	Unit	IDIQ Rate	Total
				Amount
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
Labor Hour Sub-Total	0			$0.00

Objective 1f Product Specific Graphics
Enter Proposed Labor Category	Enter Qty		Enter Rate
↓↓↓↓↓↓	↓↓↓↓↓↓		↓↓↓↓↓↓
Description	Quantity	Unit	IDIQ Rate	Total
				Amount
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
Labor Hour Sub-Total	0			$0.00

SUB-TOTAL LABOR COSTS - Creative Services $0.00

Objective 2 Media Plan Development
Enter Proposed Labor Category	Enter Qty		Enter Rate
↓↓↓↓↓↓	↓↓↓↓↓↓		↓↓↓↓↓↓
Description	Quantity	Unit	IDIQ Rate	Total
				Amount
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
Labor Hour Sub-Total				$0.00

Objective 3 Media Plan Execution
Enter Proposed Labor Category	Enter Qty		Enter Rate
↓↓↓↓↓↓	↓↓↓↓↓↓		↓↓↓↓↓↓
Description	Quantity	Unit	IDIQ Rate	Total
				Amount
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
Other	0	hrs	$0.00	$0.00
Labor Hour Sub-Total				$0.00

Objective 4 Track Metrics, Analyze and Report
Enter Proposed Labor Category	Enter Qty		Enter Rate
↓↓↓↓↓↓	↓↓↓↓↓↓		↓↓↓↓↓↓
Description	Quantity	Unit	IDIQ Rate	Total
				Amount
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
x	0	hrs	$0.00	$0.00
Labor Hour Sub-Total				$0.00

SUB-TOTAL LABOR COSTS - Media Plan Development, Execution, Tracking $0.00

TOTAL LABOR COSTS $0.00

Sheet3

File details come from the government source that posted it. Updated Oct 26, 2021.