Attachment__3_-_NCSA_Task_Order_0001_Price_Proposal_Matrix_0001.xlsx

XLSX spreadsheet 50 KB Posted Sep 14, 2016

Attached to: Award Notice - Non-Commercial Sustaining Announcements (NCSA) Single Award Indefinite Delivery/Indefinite Quantity Contract (IDIQ)
Solicitation number: W9133L-16-R-0011
Issued by: Department of the Army National Guard

About this file

From the source

Amended Price Proposal Matrix

View the file

Other files

File	Type	Posted
Amendment_2_-_NCSA_Industry_Questions_and__Government_Responses.xlsx	XLSX spreadsheet	Sep 16, 2016
Attachment__2_-_NCSA_Task_Order_0001_PWS_0002.docx	DOCX document	Sep 16, 2016
Amendment_1_-_NCSA_Industry_Questions_and__Government_Responses.xlsx	XLSX spreadsheet	Sep 14, 2016
W9133L-16-R-0011_0001.docx	DOCX document	Sep 14, 2016
Attachment__5_-_NCSA_Task_Order_0001_Award_Fee_Plan_0001.docx	DOCX document	Sep 14, 2016
Attachment__2_-_NCSA_Task_Order_0001_PWS_0001.docx	DOCX document	Sep 14, 2016
Attachment__4-_NCSA_Task_Order_0001_AQLs_0001.xlsx	XLSX spreadsheet	Sep 14, 2016
Attachment__1_-_Base_IDIQ_Price_Proposal_Worksheet.xlsx	XLSX spreadsheet	Aug 26, 2016
Attachment__7_-_Past_Perf_Questionnaire.docx	DOCX document	Aug 26, 2016
Attachment__3_-_NCSA_Task_Order_0001_Price_Proposal_Matrix.xlsx	XLSX spreadsheet	Aug 26, 2016
Attachment__6-_NCSA_Award_Fee_Flow_Chart.pptx	PPTX presentation	Aug 26, 2016
Attachment__4-_NCSA_Task_Order_00001_TV_Top_100_DMAs_AQLs.xlsx	XLSX spreadsheet	Aug 26, 2016
Attachment__2_-_NCSA_Task_Order_0001_PWS.docx	DOCX document	Aug 26, 2016
Attachment__5_-_NCSA_Task_Order_0001_Award_Fee_Plan.docx	DOCX document	Aug 26, 2016
W9133L-16-R-0011.docx	DOCX document	Aug 26, 2016
Attachment_5_-_Past_Perf_Questionnaire.docx	DOCX document	Apr 25, 2016
Attachment_6_-_NCSA_Sample_Task_Order_Award_Fee_Plan.docx	DOCX document	Apr 25, 2016
Attachment_7_-_Draft_NCSA_Award_Fee_Flow_Chart.pptx	PPTX presentation	Apr 25, 2016
Draft_RFP_FFPAF_NCSA_Overview_Memo.docx	DOCX document	Apr 25, 2016
Attachment_3_-_NCSA__Sample_Task_Order_0001_Price_Proposal_Matrices_.xlsx	XLSX spreadsheet	Apr 25, 2016
Attachment_2_-_NCSA_Sample_Task_Order_PWS.docx	DOCX document	Apr 25, 2016
Attachment_1_-_Base_IDIQ_Price_Proposal_Worksheet.XLSX	XLSX spreadsheet	Apr 25, 2016
Attachment_4_-_NCSA_Sample_Task_Order_TV_ _Radio_DMA_AQLs.xlsx	XLSX spreadsheet	Apr 25, 2016
W9133L-16-R-0011.docx	DOCX document	Apr 25, 2016

Show all 24

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 Proposal Matrix

SECTION A

SECTION B

SECTION C

SECTION D

FFP CLIN Number

CLIN DESCRIPTION

PROPOSED SBA FEES

OFFEROR'S PROPOSED LABOR MIX

OFFEROR'S PROPOSED HOURS

OFFEROR'S PROPOSED HOURLY RATE

TOTAL LABOR COST

CLIN TOTAL (Columns C + G)

Award Fee CLIN Number

Award Fee DMAs

AWARD FEE RATING & QUALITY LEVEL

AWARD FEE PERCENTAGE for TV Plays

AWARD FEE AMOUNT for TV Plays (Columns H x M)

AWARD FEE PERCENTAGE for PT and LE Day Part TV

AWARD FEE AMOUNT for PT and LE Day Part TV (Columns H x O)

Alabama

0001

NCSA TV & Radio Services

0002

Birmingham (Ann and Tusc) Rank #42

Excellent

2.50%

Very Good

1.25%

Good

0.75%

Mobile-Pensacola (Ft. Walton) Rank #60

Excellent

2.50%

Very Good

1.25%

Good

0.75%

Alaska

0003

NCSA TV & Radio Services

		$	$
Arizona
0004	NCSA TV & Radio Services			0005	Phoenix (Prescott) Rank #14	Excellent	3.50%	3.50%
						Very Good	1.75%	1.75%
						Good	0.87%	0.87%
					Tucson (Sierra Vista) Rank #70	Excellent	1.50%
						Very Good	0.75%
		$	$			Good	0.37%
Arkansas
0006	NCSA TV & Radio Services			0007	Little Rock-Pine Bluff Rank #56	Excellent	3.00%
						Very Good	1.50%
						Good	0.75%
					Ft. Smith-Fay-Spring-Rogers Rank #99	Excellent	2.00%
						Very Good	1.00%
		$	$			Good	0.50%
California
0008	NCSA TV & Radio Services			0009	Los Angeles Rank #2	Excellent	1.00%	2.00%
						Very Good	0.50%	1.00%
						Good	0.25%	0.50%
					San Fran/OAK/San Jose Rank #6	Excellent	1.00%	1.00%
						Very Good	0.50%	0.50%
						Good	0.25%	0.25%
					Sacramento-Stockton-Modesto Rank #20	Excellent	1.00%	1.00%
						Very Good	0.50%	0.50%
						Good	0.25%	0.25%
					San Diego Rank #28	Excellent	1.00%	1.00%
						Very Good	0.50%	0.50%
						Good	0.25%	0.25%
					Fresno-Visalia Rank #55	Excellent	1.00%
						Very Good	0.50%
		$	$			Good	0.25%
Colorado
0010	NCSA TV & Radio Services			0011	Denver Rank #17	Excellent	3.00%	3.00%
						Very Good	1.50%	1.50%
						Good	0.75%	0.75%
					Colorado Springs-Pueblo Rank #89	Excellent	2.00%
						Very Good	1.00%
		$	$			Good	0.50%
Connecticut
0012	NCSA TV & Radio Services			0013	Hartford-New Haven Rank #30	Excellent	3.00%	2.50%
						Very Good	1.50%	1.25%
						Good	0.75%	0.75%

		$	$
DC, Delaware & Maryland
0014				0015	Washington, DC (Hagerstown) Rank #8	Excellent	2.50%	5.00%
						Very Good	1.25%	2.50%
						Good	0.75%	1.25%
					Baltimore Rank #26	Excellent	2.50%
						Very Good	1.25%
		$	$			Good	0.75%
Florida
0016	NCSA TV & Radio Services			0017	Tampa-St. Pete (Sarasota) Rank #11	Excellent	0.83%	1.00%
						Very Good	0.42%	0.75%
						Good	0.20%	0.37%
					Miami-Ft. Lauderdale Rank #16	Excellent	0.83%	1.00%
						Very Good	0.42%	0.75%
						Good	0.20%	0.37%
					Orlando-Daytona Beach-Melbourne Rank #18	Excellent	0.83%	1.00%
						Very Good	0.42%	0.75%
						Good	0.20%	0.37%
					West Palm Beach-Ft. Pierce Rank #38	Excellent	0.83%	1.00%
						Very Good	0.42%	0.75%
						Good	0.20%	0.37%
					Jacksonville Rank #50	Excellent	0.83%	1.00%
						Very Good	0.42%	0.75%
						Good	0.20%	0.37%
					Ft. Myers-Naples Rank #62	Excellent	0.83%
						Very Good	0.42%
		$	$			Good	0.20%
Georgia
0018	NCSA TV & Radio Services			0019	Atlanta Rank #10	Excellent	1.25%	3.00%
						Very Good	0.63%	1.50%
						Good	0.31%	0.75%
					Huntsville-Decatur (Flor) Rank #79	Excellent	1.25%
						Very Good	0.63%
						Good	0.31%
					Savannah Rank #92	Excellent	1.25%
						Very Good	0.63%
		$	$			Good	0.31%
Hawaii
0020	NCSA TV & Radio Services			0021	Honolulu Rank #71	Excellent	5.00%
						Very Good	2.50%
						Good	1.25%

		$	$
Idaho
0022	NCSA TV & Radio Services

		$	$
Illinois
0023	NCSA TV & Radio Services			0024	Chicago Rank #3	Excellent	2.50%	3.00%
						Very Good	1.25%	1.50%
						Good	0.75%	0.75%
					Champaign & Springfield-Decatur Rank #83	Excellent	1.25%
						Very Good	0.62%
		$	$			Good	0.31%
Indiana
0025	NCSA TV & Radio Services			0026	Indianapolis Rank #26	Excellent	2.50%	2.50%
						Very Good	1.25%	1.25%
						Good	0.75%	0.75%
					South Bend-Elkhart Rank #95	Excellent	2.50%
						Very Good	1.25%
		$	$			Good	0.75%
Iowa
0027	NCSA TV & Radio Services			0028	Des Moines-Ames Rank #72	Excellent	2.50%	2.50%
						Very Good	1.25%	1.25%
						Good	0.75%	0.75%
					Cedar Rapids-wtrlo-IWC&Dub Rank #90	Excellent	2.50%	2.50%
						Very Good	1.25%	1.25%
		$	$			Good	0.75%	0.75%
Kansas
0029	NCSA TV & Radio Services			0092	Wichita-Hutchinson Plus Rank #66	Excellent	2.50%
						Very Good	1.25%
						Good	0.75%

		$	$
Kentucky
0030	NCSA TV & Radio Services			0031	Louisville Rank #48	Excellent	1.67%	1.67%
						Very Good	0.83%	0.83%
						Good	0.42%	0.42%
					Lexington Rank #64	Excellent	1.67%	1.67%
						Very Good	0.83%
						Good	0.42%
					Paducah-Cape Girard-Harsbg Rank #81	Excellent	1.67%
						Very Good	0.83%
		$	$			Good	0.42%
Louisiana
0032	NCSA TV & Radio Services			0033	New Orleans Rank #51	Excellent	1.67%
						Very Good	0.83%
						Good	0.42%
					Shreveport Rank #82	Excellent	1.67%
						Very Good	0.83%
						Good	0.42%
					Baton Rouge Rank #94	Excellent	1.67%
						Very Good	0.83%
		$	$			Good	0.42%
Maine
0034	NCSA TV & Radio Services			0035	Portland-Auburn Rank #80	Excellent	5.00%
						Very Good	2.50%
						Good	1.25%

		$	$
Massachusetts
0036	NCSA TV & Radio Services			0037	Boston (Manchester) Rank #9	Excellent	5.00%	5.00%
						Very Good	2.50%	2.50%
						Good	1.25%	1.25%

		$	$
Michigan
0038	NCSA TV & Radio Services			0039	Detroit Rank #13	Excellent	1.67%	1.67%
						Very Good	0.83%	0.83%
						Good	0.42%	0.42%
					Grand Rapids-Kalamazoo-B.Crk Rank #39	Excellent	1.67%
						Very Good	0.83%
						Good	0.42%
					Flint-Saginaw-Bay City Rank #67	Excellent	1.67%
						Very Good	0.83%
		$	$			Good	0.42%
Minnesota
0040	NCSA TV & Radio Services			0041	Minneapolis-St. Paul Rank #15	Excellent	5.00%	5.00%
						Very Good	2.50%	2.50%
						Good	1.25%	1.25%

		$	$
Mississippi
0042	NCSA TV & Radio Services			0043	Jackson Rank #93	Excellent	5.00%
						Very Good	2.50%
						Good	1.25%

		$	$
Missouri
0044	NCSA TV & Radio Services			0045	St. Louis Rank #21	Excellent	1.67%	1.67%
						Very Good	0.83%	0.83%
						Good	0.42%	0.42%
					Kansas City Rank #31	Excellent	1.67%
						Very Good	0.83%
						Good	0.42%
					Springfield Rank #74	Excellent	1.67%
						Very Good	0.83%
		$	$			Good	0.42%
Montana
0046	NCSA TV & Radio Services

		$	$
Nebraska
0047	NCSA TV & Radio Services			0048	Omaha Rank #75	Excellent	3.00%
						Very Good	1.50%
						Good	0.75%

		$	$
Nevada
0049	NCSA TV & Radio Services			0050	Las Vegas Rank #40	Excellent	5.00%	3.00%
						Very Good	2.50%	1.50%
						Good	1.25%	0.75%

		$	$
New Hampshire
0051	NCSA TV & Radio Services

		$	$
New Jersey
0052	NCSA TV & Radio Services

		$	$
New Mexico
0053	NCSA TV & Radio Services			0054	Albuquerque-Santa Fe Rank #47	Excellent	3.00%	3.00%
						Very Good	1.50%	1.50%
						Good	0.75%	0.75%

		$	$
New York
0055	NCSA TV & Radio Services			0056	New York City Rank #1	Excellent	2.50%	5.00%
						Very Good	1.25%	2.50%
						Good	0.75%	1.25%
					Buffalo Rank #52	Excellent	0.62%
						Very Good	0.31%
						Good	0.15%
					Albany-Schenectady-Troy Rank #58	Excellent	0.62%
						Very Good	0.31%
						Good	0.15%
					Rochester Rank #78	Excellent	0.62%
						Very Good	0.31%
						Good	0.15%
					Syracuse Rank #84	Excellent	0.62%
						Very Good	0.31%
		$	$			Good	0.15%
North Carolina
0057	NCSA TV & Radio Services			0058	Raleigh-Durham (Fayetteville) Rank #24	Excellent	1.00%	1.00%
						Very Good	0.50%	0.50%
						Good	0.25%	0.25%
					Charlotte Rank #25	Excellent	1.00%	1.00%
						Very Good	0.50%	0.50%
						Good	0.25%	0.25%
					Greenville-Spart-Asheville-And Rank #37	Excellent	1.00%
						Very Good	0.50%
						Good	0.25%
					Greensboro-H. Point-W Salem Rank #46	Excellent	1.00%
						Very Good	0.50%
						Good	0.25%
					Greenville-N.Bern-Washington Rank #100	Excellent	1.00%
						Very Good	0.50%
		$	$			Good	0.25%
North Dakota
0059	NCSA TV & Radio Services

		$	$
Ohio
0060	NCSA TV & Radio Services			0061	Cleveland-Akron (Canton) Rank #19	Excellent	1.00%	1.00%
						Very Good	0.50%	0.50%
						Good	0.25%	0.25%
					Columbus Rank #32	Excellent	1.00%	1.00%
						Very Good	0.50%	0.50%
						Good	0.25%	0.25%
					Cincinnati Rank #35	Excellent	1.00%	1.00%
						Very Good	0.50%	0.50%
						Good	0.25%	0.25%
					Dayton Rank #63	Excellent	1.00%
						Very Good	0.50%
						Good	0.25%
					Toledo Rank #76	Excellent	1.00%
						Very Good	0.50%
		$	$			Good	0.25%
Oklahoma
0062	NCSA TV & Radio Services			0063	Oklahoma City Rank #41	Excellent	2.50%	2.50%
						Very Good	1.25%	1.25%
						Good	0.75%	0.62%
					Tulsa Rank #59	Excellent	2.50%
						Very Good	1.25%
		$	$			Good	0.75%
Oregon
0064	NCSA TV & Radio Services			0065	Portland Rank #22	Excellent	5.00%	3.00%
						Very Good	2.50%	1.50%
						Good	1.25%	0.75%

		$	$
Pennsylvania
0066	NCSA TV & Radio Services			0067	Philadelphia Rank #4	Excellent	1.25%	2.50%
						Very Good	0.63%	1.25%
						Good	0.31%	0.62%
					Pittsburgh Rank #23	Excellent	1.25%	1.25%
						Very Good	0.63%	0.63%
						Good	0.31%	0.31%
					Harrisburg-Lancaster-Leb-York Rank #43	Excellent	1.25%	1.25%
						Very Good	0.63%	0.63%
						Good	0.31%	0.31%
					Wilkes Barre-Scranton-Hztn Rank #54	Excellent	1.25%
						Very Good	0.63%
		$	$			Good	0.31%
Rhode Island
0068	NCSA TV & Radio Services			0069	Providence-New Bedford Rank #53	Excellent	5.00%
						Very Good	2.50%
						Good	1.25%

		$	$
South Carolina
0070	NCSA TV & Radio Services			0071	Columbia Rank #77	Excellent	2.50%
						Very Good	1.25%
						Good	0.75%
					Charleston Rank #98	Excellent	2.50%
						Very Good	1.25%
		$	$			Good	0.75%
South Dakota
0072	NCSA TV & Radio Services

		$	$
Tennessee
0073	NCSA TV & Radio Services			0074	Nashville Rank #29	Excellent	1.00%	1.25%
						Very Good	0.50%	0.50%
						Good	0.25%	0.25%
					Memphis Rank #49	Excellent	1.00%	1.00%
						Very Good	0.50%	0.50%
						Good	0.25%	0.25%
					Knoxville Rank #61	Excellent	1.00%
						Very Good	0.50%
						Good	0.25%
					Chattanooga Rank #87	Excellent	1.00%
						Very Good	0.50%
						Good	0.25%
					Tri-Cities (TN-VA) Rank #96	Excellent	1.00%
						Very Good	0.50%
		$	$			Good	0.25%
Texas
0075	NCSA TV & Radio Services			0076	Dallas-Ft. worth Rank #5	Excellent	0.71%	2.00%
						Very Good	0.36%	1.00%
						Good	0.17%	0.50%
					Houston Rank #10	Excellent	0.71%	2.00%
						Very Good	0.36%	1.00%
						Good	0.17%	0.50%
					San Antonio Rank #36	Excellent	0.71%	0.50%
						Very Good	0.36%	0.25%
						Good	0.17%	0.13%
					Austin Rank #45	Excellent	0.71%	0.50%
						Very Good	0.36%	0.25%
						Good	0.17%	0.13%
					Harlingen-Wslco-Brnsvl-McA Rank #86	Excellent	0.71%
						Very Good	0.36%
						Good	0.17%
					Waco-Temple-Bryan Rank #88	Excellent	0.71%
						Very Good	0.36%
						Good	0.17%
					El Paso (Las Cruces) Rank #91	Excellent	0.71%
						Very Good	0.36%
		$	$			Good	0.17%
Utah
0077	NCSA TV & Radio Services			0078	Salt Lake City Rank #33	Excellent	5.00%	3.00%
						Very Good	2.50%	1.50%
						Good	1.25%	0.75%

		$	$
Vermont
0079	NCSA TV & Radio Services			0080	Burlington-Plattsburg Rank #97	Excellent	5.00%
						Very Good	2.50%
						Good	1.25%

		$	$
Virginia
0081	NCSA TV & Radio Services			0082	Norfolk-Portsmth-Newpt Nws Rank #44	Excellent	1.67%	1.67%
						Very Good	0.83%	0.83%
						Good	0.42%	0.42%
					Richmond-Petersburg Rank #57	Excellent	1.67%
						Very Good	0.83%
						Good	0.42%
					Roanoke-Lynchburg Rank #68	Excellent	1.67%
						Very Good	0.83%
		$	$			Good	0.42%
Washington
0083	NCSA TV & Radio Services			0084	Seattle-Tacoma Rank #14	Excellent	2.50%	2.50%
						Very Good	1.25%	1.25%
						Good	0.75%	0.75%
					Spokane Rank #73	Excellent	2.50%
						Very Good	1.25%
		$	$			Good	0.75%
West Virginia
0085	NCSA TV & Radio Services			0086	Charleston-Huntington Rank #65	Excellent	5.00%
						Very Good	2.50%
						Good	1.25%

		$	$
Wisconsin
0087	NCSA TV & Radio Services			0088	Milwaukee Rank #34	Excellent	1.67%	1.67%
						Very Good	0.83%	0.83%
						Good	0.42%	0.42%
					Green Bay Rank #69	Excellent	1.67%
						Very Good	0.83%
						Good	0.42%
					Madison Rank #85	Excellent	1.67%
						Very Good	0.83%
		$	$			Good	0.42%
Wyoming
0089	NCSA TV & Radio Services

		$	$
Puerto Rico
0090	NCSA TV & Radio Services

Sheet1

Proposal guidelines

18 million cap on the contract with 3 million of that set aside for possible bonuses

Must meet minimum plays statewide and have airing in each DMA to qualify for a incentives

First bonus is for total plays above Satisfactory within the State and based off historical data from Nielsen reports. The maximum bonus for this shall not exceed more then 5% (semi-annually) 10% (annually)of the total base payment to the SBA

Second Bonus targets the top 100 DMAs in the country in only the Prime Time and Late Evening slots in those DMAs. The maximum bonus for this shall not exceed more then 5% (semi-annually) 10% (annually)of the total base payment to the SBA

File details come from the government source that posted it. Updated Nov 14, 2017.