TACCOM_II_DISCOUNT_AND_SERVICES_PRICING.XLSX

XLSX spreadsheet 476 KB Posted Jul 8, 2017

Attached to: TACCOM II Federal contract opportunity
Solicitation number: 2017036109
Issued by: Department of Homeland Security Customs and Border Protection

About this file

Written by GovTribe AI · Dec 29, 2023

This document contains pricing templates and instructions for a federal contract opportunity for tactical communications services and equipment. Vendors are required to complete pricing templates for portable radios, accessories, and labor categories. Quantity discounts for portable radios must be provided in tiered pricing from 0-100 units, 101-1000 units, 1001-5000 units, and over 5000 units. Discounts for accessories must be provided in tiers of 0-10 units, 11-100 units, 101-500 units, and over 500 units. Labor rates for over 100 categories must be proposed at ceiling rates, with escalation of 1.7% annually. Some categories are subject to service contract labor standards. Templates include columns for labor sources, descriptions, qualifications, rates, and multi-year pricing. Vendors must also submit detailed equipment listings and pricing documentation.

From the source

Pricing Template

View the file

Other files for this federal contract opportunity

Other files attached to TACCOM II, newest first.
File	Type	Posted
TACCOM_II_SUBCATEGORY_EQUIPMENT_PRICING_TEMPLATE.xlsx	XLSX spreadsheet	Mar 15, 2018
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.docx	DOCX document	Mar 15, 2018
WD_No._2015-5637_SCA_WD_for_San_Francisco_Revision_8_011618.pdf	PDF	Mar 15, 2018
CO-COR_Certification_Form_-_Federal.docx	DOCX document	Mar 15, 2018
TACCOM_II_RFP_A0010_Final.docx	DOCX document	Mar 15, 2018
TACCOM_II_TC2_Proposal_Workbook_A0010.Final.xlsx	XLSX spreadsheet	Mar 15, 2018
Offeror_Notice_Webinar_Questions_and_Extension_3.9.18.docx	DOCX document	Mar 9, 2018
Webinar_Q&A_Final.xlsx	XLSX spreadsheet	Mar 9, 2018
TACCOM_II_A0009_SF30.pdf	PDF	Feb 28, 2018
TACCOM_II_RFP_A0009_FINAL.docx	DOCX document	Feb 28, 2018
CO-COR_Certification_Form_-_State_or_Local.docx	DOCX document	Feb 28, 2018
TACCOM_II_SERVICES_PRICING_TEMPLATE.xlsx	XLSX spreadsheet	Feb 28, 2018
TACCOM_II_SUBCATEGORY_EQUIPMENT_PRICING_TEMPLATE.xlsx	XLSX spreadsheet	Feb 28, 2018
INDIVIDUAL_SMALL_BUSINESS_SUBCONTRACTING_PLAN_TEMPLATE.docx	DOCX document	Feb 28, 2018
TACCOM_II_SELF_SCORING_WORKSHEET.xlsx	XLSX spreadsheet	Dec 29, 2017
TACCOM_II_SF30_A0008.pdf	PDF	Dec 29, 2017
TACCOM_II_SF30_A0007.pdf	PDF	Dec 15, 2017
TACCOM_II_RFP_A0007.docx	DOCX document	Dec 15, 2017
TACCOM_II_SF30_A0005.pdf	PDF	Dec 5, 2017
TACCOM_II_SUBCATEGORY_EQUIPMENT_PRICING_TEMPLATE.xlsx	XLSX spreadsheet	Dec 5, 2017
TACCOM_II_LCAT_MAP_TEMPLATE.xlsx	XLSX spreadsheet	Dec 1, 2017
TACCOM_II_SF30_A0004.pdf	PDF	Dec 1, 2017
TACCOM_II_LCAT_MAP_TEMPLATE.xlsx	XLSX spreadsheet	Nov 21, 2017
TACCOM_II_SUBCATEGORY_EQUIPMENT_PRICING_TEMPLATE.xlsx	XLSX spreadsheet	Nov 21, 2017
COMMON_REQUIREMENTS_LIST.xlsx	XLSX spreadsheet	Nov 21, 2017
RFP_TACCOM_II_QUESTIONS_ANSWERS_A0003.xlsx	XLSX spreadsheet	Nov 21, 2017
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.docx	DOCX document	Nov 21, 2017
TACCOM_II_LABOR_CATEGORIES.xlsx	XLSX spreadsheet	Nov 21, 2017
TACCOM_II_LCAT_MAP_TEMPLATE_v2.xlsx	XLSX spreadsheet	Sep 7, 2017
TACCOM_II_RELEVANT_EXPERIENCE_FORM.docx	DOCX document	Sep 6, 2017
RFP_TACCOM_II_QUESTIONS_TEMPLATE.xlsx	XLSX spreadsheet	Sep 5, 2017
TACCOM_II_SUBCATEGORY_EQUIPMENT_PRICING_TEMPLATE.xlsx	XLSX spreadsheet	Sep 5, 2017
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.docx	DOCX document	Sep 5, 2017
COMMON_REQUIREMENTS_LIST.xlsx	XLSX spreadsheet	Sep 5, 2017
Special_Notice_07282017_(002).docx	DOCX document	Jul 28, 2017
TacCom_II_Scoring_Spreadsheet_v6.xlsx	XLSX spreadsheet	Jul 8, 2017
TACCOM_RFP_Second_Draft_FINAL.docx	DOCX document	Jul 8, 2017
TACCOM_II_FBO_SPECIAL_NOTICE.DOCX	DOCX document	Jul 8, 2017
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.DOCX	DOCX document	Jul 8, 2017
DHS_TacCom_II_Requirements_v12.xlsx	XLSX spreadsheet	Jul 8, 2017
TacCom_II_Pre-Solicitation_Conference_Slides_05052017.pptx	PPTX presentation	May 8, 2017
TACCOM_II_PRE-SOLICITATION_CONFERENCE_FBO_NOTICE_ADDITIONAL_INFORMATION_05032017.docx	DOCX document	May 3, 2017
TACCOM_II_PRE-SOLICITATION_CONFERENCE_FBO_NOTICE.docx	DOCX document	Apr 27, 2017
TACCOM_II_SECTIONS_LM.docx	DOCX document	Apr 21, 2017
TACCOM_II_FBO_SPECIAL_NOTICE.docx	DOCX document	Apr 21, 2017
TACCOM_II_SECTION_C.docx	DOCX document	Apr 21, 2017
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.docx	DOCX document	Apr 21, 2017
TACCOM_II_RELEVANT_EXPERIENCE_FORM.docx	DOCX document	Apr 21, 2017
TACCOM_II_QUESTIONS_COMMENTS_TEMPLATE.xlsx	XLSX spreadsheet	Apr 21, 2017
TACCOM_II_SAMPLE_ORDERS.xlsx	XLSX spreadsheet	Apr 21, 2017

Show all 50

TACCOM II has more files on GovTribe.

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.

Subscriber

SUBSCRIBER REQUIREMENTS

MOBILE RADIOS

Standard Configurations

Options

Dual Control Head Operation package

Siren / PA system interface package

External Emergency button package

External Data Support package

Extended length remote cable ( Limo )

Option for Motorcycle weather resistant installation package

Hands-free microphone kit

PORTABLE RADIO SPECIFICATIONS

Standard Configurations

VHF Portable Radios

700/800 Portable Radios

Portable Radio Accessories

Clamshell battery pack

Standard Capacity battery pack

High Capacity battery pack

Standard Capacity battery pack Intrinsically Safe

High Capacity battery pack Intrinsically Safe

Manufacture shall provide in addition to NiCad, optional chemistry batteries such as ( NiMH ) Nickel-Metal-Hydride and (Li-Ion) Lithium-Ion. The manufacture shall ensure proper operation of the radio as well as the accessories and chargers with these batteries.

Single Unit Charger

Multi Unit Charger

Multi Unit Charger with Display of battery capacity

Single Unit Charger with battery exercise capability

Multi Unit Charger with battery exercise capability

Multi Unit Charger with display and battery exercise capability

DC car charger

Disposable battery pack

Enhanced Speaker Microphone

1 wire surveillance kit receive only with options for volume control, extra loud for high noise, cable in black or beige

2 wire surveillance kit with microphone and PTT, with receive options for volume control, extra loud for high noise, cable in black or beige

3 wire surveillance kit with microphone, separate PTT, receive options for volume control, extra loud for high noise, cable in black or beige

Replacement components for all surveillance kits

Ear Microphone system for use with Fire Fighting and or HAZMAT operations

Headset with noise canceling boom microphone for industrial environments

Headset with noise canceling boom microphone for high noise environments

Heavy Duty Headset with noise canceling boom microphone for high noise environments

Tactical head sets and throat mics

Nylon Carry Case

Leather Carry Case

Chest Pack Radio Holder

Vehicular Adapter for charging battery as well as connection to external antenna, speaker, and microphone.

1. Option of RF Power amplifier.

2. Option of amplified speaker

3. Kit for covert install of PTT and microphone

4. Option for high gain antenna

All batteries supplied shall provide a minimum of 8 hours operation with duty cycle of 10% off, 10% transmitting and 80% receiving radio traffic and shall be resistant to memory effects.

DC Car Charger

Tactical head sets and throat microphones

Bulk Packaging for Shipping

SOFTWARE

All operating, programming and diagnostic software shall be available supporting all operating modes

All applicable software licenses shall be furnished allowing unlimited use within the agency

Media - CD ROM

Operating System - current MS Windows version, DOS is not acceptable

Updates shall be provided for the first five years after delivery at no additional cost

All required passwords shall be provided

Cloning capability shall be supported as required by the specific system or equipment type

TECHNICAL SERVICE MANUALS

Shall be packaged with the associated equipment and include the following options:

1. Printed copy of operators manual with each unit.

2. Installation Manual, to include cabling diagrams and initial testing

3. Service Manual to include alignment instructions complete with schematic diagrams , descriptions of circuit operation, block diagrams, parts list, maintenance and troubleshooting procedures, technical specifications and any specific configuration information.

TRAINING

Complete technical diagnostic and maintenance training courses shall be offered

Installation and Programming Training

TONE/DIGITAL/IP REMOTE CONTROL CONSOLES

Option for analog style either 2-wire or 4-wire, standard telephone style

Option for simultaneous attachment of at least 3 desk sets to a control station

Option for full feature desk set

shielding against high ambient RF fields

Speaker, speaker volume control & PTT active indicator

Desk stand microphone and telephone style handset with positive PTT

Channel selection and station activation shall take < 300 milliseconds

Headset and Standard Surveillance Kit Interface

Dispatcher style headset with interface

CONTROL STATIONS / Desk Set Control Points

120 VAC, 60 Hz, Optional - 12, 24 & 48 VDC, 240 VAC, 50 Hz

Radio operation Identical to Mobile Radio

Option for Local Control Operation to include Desk Mic, speaker and full function display control identical to a mobile radio

Option for Remote Control Operation only

Option for single channel tone remote operation

Option for rack mount operation

Option for digital desk set that provides full feature remote control ( programmable features identical to mobile)

Option for multiple desk set controllers to run one control station.

Option for extended remote via I.P. or Modem Lines

Encryption Key Loaders / and Accessories

Key loader to load and provision DES/ DES-XL/DES-OFB keys in a subscriber radio

Key loader to load and provision AES keys in a subscriber radio

Cables and adapters to connect KVL to required subscriber radios

Cables and adapters to connect to required infrastructure devices

Spare Battery

Battery Charger

Data port for direct serial connection

Modem port for dialing to the Motorola KMF

Instructions Portable Radios

Instructions for completing the tabs titled “Detail Portable Radio Table” and “Portable Radio Tiered Pricing”

The tabs titled “Detail Portable Radio Table” and “Portable Radio Tiered Pricing” are intended to capture quantity discounts, offered by vendor, for Portable Radios and Accessories offered for sale under the Technical Category 1- Equipment. Offerors proposing quantity discounts are obligated to provide those discounts when delivering items under TacCom II. The tiers shown in the “Portable Radio Tiered Pricing” tab are set by the Government. Historical data indicates that the government has received discounts on purchases of portable radios and radio accessories as follows:

Instructions for completing Portable Radio Tiered Pricing.

Enter the Offeror's name in the column with the heading “Offeror” (Column A) for each line on the table. The data in the column titled “Material Category” (Column B) should read “Portable Radios”.

-Select the appropriate value from the drop down button in the column titled “Type of Radio” (Column C).

Enter the percent discount in the column titled “% Discount” (Column F). The first four quantity tiers (Column D and E) are set by the government. The tiers for portable radio accessories are (0-10, 11-100, 101-500 and >500. The fixed quantity tiers for all other portable radio categories are (0-100, 101-1000, 1001-5000, > 5000). Offeror must provide their discount for the fixed quantity tiers. Vendor has the option to offer discounts for additional tiers above the government stipulated tiers. Add rows to the spreadsheet for additional tiers.

The tab titled “Detail Portable Radio Table” is illustrative and optional. Offeror must supply the level of detail in the attachment, however, vendor may provide their own form. Offeror must provide a detailed listing of the make and model of each item available within the “Type of Radio” category (Column A). The type of radio category must be one of the following:

· 700/800 Portable Radio

· 700/800 Portable Radio Accessories

· Standard Configuration

· UHF Portable

· VHF Portable

In the column titled “Contract/Schedule” (Column D) Offeror must identify the source material where the discount comes from. For example, if your item comes from a GSA catalog with a unit price, identify the GSA catalog. Description of the base from which the discount is offered should be sufficiently detailed to be traceable to the source documentation. Offeror should expand column as needed. Enter the current price of the items in the column titled “Current Price” (Column E).

Detail Portable Radio Table

Offeror	XYZ Corporation
Type of Radio	Make	Model	Contract/Schedule	Current Price
700/800 Portable Radio
700/800 Portable Radio
700/800 Portable Radio Accessories
700/800 Portable Radio Accessories
Standard Configuration
Standard Configuration
UHF Portable
UHF Portable
VHF Portable
VHF Portable

Portable Radio Tiered Pricing

Offeror	Material Category	Type of Radio	Discount Tier Quantity (Min)1	Discount Tier Quantity (Max)1	% Discount2
	Portable Radios	700/800 Portable Radio	0	100
	Portable Radios	700/800 Portable Radio	101	1000
	Portable Radios	700/800 Portable Radio	1001	5000
	Portable Radios	700/800 Portable Radio	5001	>5001
	Portable Radios	Standard Configuration	0	100
	Portable Radios	Standard Configuration	101	1000
	Portable Radios	Standard Configuration	1001	5000
	Portable Radios	Standard Configuration	5001	>5001
	Portable Radios	UHF Portable	0	100
	Portable Radios	UHF Portable	101	1000
	Portable Radios	UHF Portable	1001	5000
	Portable Radios	UHF Portable	5001	>5001
	Portable Radios	VHF Portable	0	100
	Portable Radios	VHF Portable	101	1000
	Portable Radios	VHF Portable	1001	5000
	Portable Radios	VHF Portable	5001	>5001
	Portable Radios	700/800 Portable Radio Accessories	0	10
	Portable Radios	700/800 Portable Radio Accessories	11	100
	Portable Radios	700/800 Portable Radio Accessories	101	500
	Portable Radios	700/800 Portable Radio Accessories	501	>501
Notes:	1. Discount Tiers are set by the government. Do not change. Add volume tiers as desired above the top volume tiers set by the government.
	2. Enter discount percent from the current unit price.

Instructions for Services

The following instructions apply for completion of this attachment. Offerors are reminded that they must complete both pricing tabs: Government Site Rates and Contractor Site Rates. All percentages and rates shall be rounded to two decimal places.

1. Enter the Offeror Name in Row 3 and the DUNS Number in Row 4.

2. In Column C, Offerors must indicate if the proposed ceiling rates are from their GSA schedule or commercial catalog, and identify their corresponding labor category title in Column D. Minimum qualifications are to be shown in Column E.

3. In Column F, Offerors shall enter fully burdened rates for all applicable labor categories. Discounts from GSA and Commercial Catalogs are encouraged, column G. The fully-burdened, discounted ceiling rate as of 9/26/2017 will populate in column H and shall include all direct labor and indirect costs applicable to that labor category (such as fringe benefits, overhead, and G&A), and profit.

For each applicable labor category, Offerors shall propose a ceiling rate for the period 9/26/2017 to 9/27/2018. This attachment will then automatically apply an annual escalation factor of 1.7% beginning 9/26/2018. The applied factor is determined by the Bureau of Labor Statistics (BLS) Employment Cost Index (ECI) and is based on average annual BLS ECI increases for the previous three years from the date period of performance begins. The applied escalation factor will be revisited prior to the exercise of each option period. The established ceiling rates in the awarded contract will only be adjusted upwards to reflect changes in escalation that are greater than the currently applied escalation factor. Conversely, if updates to the BLS ECI escalation are equal to or even fall below the currently applied escalation factor, the ceiling rates will remain unchanged.

The Government has identified and marked certain labor categories in this attachment as categories covered by the Service Contract Act (SCA). Categories subject to SCA are identified with an " * " and are not escalated.The Government has incorporated the San Francisco, CA wage determination for purposes of pricing the SCA positions under this IDIQ contract, since it is one of the highest cost areas where work may be performed. The actual geographic locations of performance will be determined at the task order level and the applicable prevailing wage determination will be incorporated into the task order solicitation at that time. Offerors are strongly encouraged to consider the impact of the known geographic location in their task order pricing as compared to the San Francisco, CA prevailing wage determination that was used for the purposes of pricing your IDIQ ceiling rates.

&"-,Bold"&20Instructions for Pricing Services

Government Site Rates Government Site Rates

Offeror Name:
DUNS Number:
Enter Data in Yellow Highlighted Cells
Government Labor Category Title	Level	Specify Source (i.e. GSA, commercial catalog)	Contractor Labor Category Title/Description	Minimum Qualifications and Experience	GSA/Catalog Rate	Discount	Proposed Ceiling Rate 9/26/2017	OPTION YEAR 1 9/26/18-9/27/19	OPTION YEAR 2 9/26/19-9/27/20	OPTION YEAR 3 9/26/20-9/27/21	OPTION YEAR 4 9/26/21-9/27/22
RF Engineer	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
RF Engineer	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Business Analyst/Project Support/ Project Control Specialist	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Business Analyst/Project Support/ Project Control Specialist	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Business Analyst/Project Support/ Project Control Specialist	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Business Manager/Project Support Staff	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Business Manager/Project Support Staff	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Business Manager/Project Support Staff	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Certified Project Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Certified Project Manager	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Computer-Aided Dispatcher/Law Enforcement Communications Support Specialist	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Computer-Aided Dispatcher/Law Enforcement Communications Support Specialist	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Computer-Aided Dispatcher/Law Enforcement Communications Support Specialist	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Construction Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Construction Manager	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Draftsman	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Draftsman	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Draftsman	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Electrician *	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Electrician *	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Electrician *	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Environmental Specialist	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Environmental Specialist	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Environmental Specialist	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
IT Systems Engineer	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
IT Systems Engineer	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
IT Systems Engineer	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
IT Systems Integrator	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
IT Systems Integrator	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
IT Systems Integrator	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
LMR Technicians	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
LMR Technicians	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
LMR Technicians	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Logistics Analyst	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Logistics Analyst	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Logistics Analyst/Project Control Specialist	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Logistics Analyst/Project Control Specialist	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Logistics Analyst/Project Control Specialist	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Professional Engineer	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Professional Engineer	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Program Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Program Manager	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Project Engineer/Tower Engineer	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Project Engineer/Tower Engineer	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Purchaser / Procurement Specialist	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Purchaser / Procurement Specialist	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Scheduler	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Scheduler	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Spectrum Manager	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Spectrum Manager	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Spectrum Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Spectrum Manager	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Subject Matter Expert (SME)	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Subject Matter Expert (SME)	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Supervisor (On-Site)	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Supervisor (On-Site)	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Supervisor (On-Site)	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Supervisor (On-Site)	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Fleet Manager	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Fleet Manager	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Fleet Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Interoperable Systems	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Interoperable Systems	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Interoperable Systems	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Interoperable Systems	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Rapid Deployment Assets Manager	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Rapid Deployment Assets Manager	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist /Technicians	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist /Technicians	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist /Technicians	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist /Technicians	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Technician	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Technician	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Technician	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Technician/Business Analyst	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Technician/Business Analyst	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Climber / Tower Worker	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Climber / Tower Worker	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Inspector	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Inspector	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Inspector	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Inspector	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Rigger	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Rigger	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Rigger	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Rigger	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Trainer	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Trainer	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Training Specialist	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Training Specialist	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Training Specialist	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Transportation Staff - Helicopter Pilot *	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Transportation Staff - Helicopter Pilot *	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Transportation Staff - Truck Driver *	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Transportation Staff - Truck Driver *	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse / Logistics Manager	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse / Logistics Manager	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse / Logistics Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse / Logistics Manager	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse Manager	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse Staff *	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse Staff *	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00

Contractor Site Rates

Contractor Site Rates
Offeror Name:
DUNS Number:
Enter Data in Yellow Highlighted Cells
Labor Category	Level	Specify Source (i.e. GSA, commercial catalog)	Contractor Labor Category Title/Description	Minimum Qualifications/Experience	GSA/Catalog Rate	Discount	Proposed Ceiling Rate 9/26/2017	OPTION YEAR 1 9/26/18-9/27/19	OPTION YEAR 2 9/26/19-9/27/20	OPTION YEAR 3 9/26/20-9/27/21	OPTION YEAR 4 9/26/21-9/27/22
RF Engineer	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
RF Engineer	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Business Analyst/Project Support/ Project Control Specialist	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Business Analyst/Project Support/ Project Control Specialist	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Business Analyst/Project Support/ Project Control Specialist	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Business Manager/Project Support Staff	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Business Manager/Project Support Staff	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Business Manager/Project Support Staff	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Certified Project Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Certified Project Manager	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Computer-Aided Dispatcher/Law Enforcement Communications Support Specialist	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Computer-Aided Dispatcher/Law Enforcement Communications Support Specialist	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Computer-Aided Dispatcher/Law Enforcement Communications Support Specialist	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Construction Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Construction Manager	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Draftsman	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Draftsman	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Draftsman	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Electrician *	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Electrician *	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Electrician *	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Environmental Specialist	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Environmental Specialist	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Environmental Specialist	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
IT Systems Engineer	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
IT Systems Engineer	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
IT Systems Engineer	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
IT Systems Integrator	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
IT Systems Integrator	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
IT Systems Integrator	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
LMR Technicians	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
LMR Technicians	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
LMR Technicians	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Logistics Analyst	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Logistics Analyst	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Logistics Analyst/Project Control Specialist	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Logistics Analyst/Project Control Specialist	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Logistics Analyst/Project Control Specialist	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Professional Engineer	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Professional Engineer	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Program Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Program Manager	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Project Engineer/Tower Engineer	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Project Engineer/Tower Engineer	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Purchaser / Procurement Specialist	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Purchaser / Procurement Specialist	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Scheduler	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Scheduler	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Spectrum Manager	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Spectrum Manager	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Spectrum Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Spectrum Manager	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Subject Matter Expert (SME)	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Subject Matter Expert (SME)	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Supervisor (On-Site)	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Supervisor (On-Site)	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Supervisor (On-Site)	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Supervisor (On-Site)	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Fleet Manager	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Fleet Manager	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Fleet Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Interoperable Systems	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Interoperable Systems	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Interoperable Systems	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Interoperable Systems	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Rapid Deployment Assets Manager	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist - Rapid Deployment Assets Manager	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist /Technicians	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist /Technicians	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist /Technicians	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Systems Technologist /Technicians	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Technician	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Technician	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Technician	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Technician/Business Analyst	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Technician/Business Analyst	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Climber / Tower Worker	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Climber / Tower Worker	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Inspector	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Inspector	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Inspector	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Inspector	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Rigger	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Rigger	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Rigger	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Tower Rigger	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Trainer	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Trainer	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Training Specialist	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Training Specialist	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Training Specialist	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Transportation Staff - Helicopter Pilot *	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Transportation Staff - Helicopter Pilot *	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Transportation Staff - Truck Driver *	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Transportation Staff - Truck Driver *	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse / Logistics Manager	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse / Logistics Manager	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse / Logistics Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse / Logistics Manager	IV				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse Manager	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse Manager	III				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse Staff *	I				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00
Warehouse Staff *	II				$0.00	0%	$0.00	$0.00	$0.00	$0.00	$0.00

vlookup

Technical Category	Category	Category II	Standardized Category	Dropdown Category	Dropdown for Portable Radio Sheet
Equipment	Communications Infrastructure	Comparator	Infrastructure	Communications Infrastructure	700/800 Portable Radio
Equipment	Communications Infrastructure	Digital Interface Unit	Infrastructure	Software	700/800 Portable Radio Accessories
Equipment	Communications Infrastructure	Dispatch Console	Infrastructure	Encryption Key Loaders/and Accessories	Standard Configuration
Equipment	Communications Infrastructure	Key Management Facility	Infrastructure	Mobile Radios	UHF Portable
Equipment	Communications Infrastructure	Key Variable Loader	Infrastructure	UHF-AM	VHF Portable
Equipment	Communications Infrastructure	Logging Recorders	Infrastructure	UHF-AM/MAD
Equipment	Communications Infrastructure	Receivers	Infrastructure	VHF-AM
Equipment	Communications Infrastructure	Repeaters/Base Station	Infrastructure	VHF – Digital
Equipment	Communications Infrastructure	Routers	Infrastructure	Technical Service Manuals
Equipment	Communications Infrastructure	Servers	Infrastructure	High Frequency (HF) Radio
Equipment	Communications Infrastructure	Switch	Infrastructure	HF Radio
Equipment	Communications Infrastructure	Workstations	Infrastructure	Low Band Mobile Radio
Equipment	Communications Infrastructure	Control Stations/Desk Set Control Points	Infrastructure	Low Band Portable Radio
Equipment	Communications Infrastructure	Tone/Digital/IP Remote Control Consoles	Infrastructure	USCG – specific
Equipment	Communications Infrastructure	Transportable Repeater	Infrastructure	Maritime
Equipment	Communications Infrastructure	Tools	Infrastructure	Boat Crew Communications System
Equipment	Communications Infrastructure	Additional: Microwave Wave	Infrastructure	Military Satellite Communications
Equipment	Communications Infrastructure	Civil Infrastructure	Infrastructure	Test Equipment
Equipment	Software		Infrastructure	Control Stations / Desk Set Control Points
Equipment	Encryption Key Loaders/and Accessories		Radios and accessories	Encryption Key Loaders / and Accessories
Equipment	Mobile Radios		Radios and accessories	Interoperability
Equipment	Portable Radios	700/800 Portable Radios	Radios and accessories	Boat Crew Communications System (BCCS)
Equipment	Portable Radios	700/800 Portable Radio Accessories	Radios and accessories	Satellite
Equipment	Portable Radios	Standard Configuration	Radios and accessories	Transportable Repeater Non-Commercial Power
Equipment	Portable Radios	UHF Portable	Radios and accessories	Transportable Repeater, Commercial Power
Equipment	Portable Radios	VHF Portable	Radios and accessories	UHF-AM / MAD
Equipment	UHF-AM	Transceiver	Radios and accessories	VHF-Digital Selective Requirements
Equipment	UHF-AM/MAD		Radios and accessories	General
Equipment	VHF-AM		Radios and accessories	Training
Equipment	VHF – Digital		Radios and accessories
Equipment	Technical Service Manuals		Radios and accessories
Equipment	High Frequency (HF) Radio		High Frequency
Equipment	HF Radio		High Frequency
Equipment	Low Band Mobile Radio		High Frequency
Equipment	Low Band Portable Radio		High Frequency
Equipment	USCG – specific		High Frequency
Equipment	Maritime		Maritime
Equipment	Boat Crew Communications System		Maritime
Equipment	Military Satellite Communications		Satellite
Equipment	Test Equipment		Test Equipment
Services	O&M Purchasing Support		O&M
Services	O&M Repair and Maintenance Services		O&M
Services	Preventive Maintenance		O&M
Services	Command & Control / Dispatch Center Maintenance		O&M
Services	Subscriber Programming / Blitz Support		Radio
Services	Subscriber Repair		Radio
Services	Subscriber Installation		Radio
Services	Tactical Communications Fleet / Rapid Deployment Equipment Support		Radio
Services	RF Network Management		RF
Services	Spectrum Support		RF
Services	Site Surveys		Site
Services	Environmental Analysis		Site
Services	Structural Analysis and Remediation		Site
Services	Site Lease Acquisition		Site
Services	Site Construction and System Implementation		Site
Services	Tower Site / Infrastructure Maintenance Support		Site
Services	Telco Circuit / Pots Lines Support		Site
Services	Tower Lease Support		Site
Services	Tower Operations and Maintenance Support		Site
Services	Interoperable Systems / Interoperability Support		System
Services	Circuit Acquisition		System
Services	System Staging		System
Services	Integration		System
Services	Re System Design		System
Services	ROIP System Design		System
Services	Project Closeout Activities		Project Management/Support
Services	Project Management		Project Management/Support
Services	General Requirements		Project Management/Support
Services	End User Training		Project Management/Support
Services	Logistics /Warehouse Support		Project Management/Support
Services	Command & Control / Dispatch Support		Project Management/Support
Services	User Requirements Gathering		Project Management/Support
Services	System Monitoring		Project Management/Support
Services	Labor and Services		Project Management/Support
Services	Logistics/ Warehouse/ Transportation Support		Project Management/Support
Equipment	Control Stations / Desk Set Control Points		Infrastructure
Equipment	Encryption Key Loaders / and Accessories		Infrastructure
Equipment	Interoperability		Radios and accessories
Equipment	Boat Crew Communications System (BCCS)		Maritime
Equipment	Satellite		Satellite
Equipment	Transportable Repeater Non-Commercial Power		Infrastructure
Equipment	Transportable Repeater, Commercial Power		Infrastructure
Equipment	UHF-AM / MAD		Radios and accessories
Equipment	VHF-Digital Selective Requirements		Radios and accessories
Equipment	General		General
Equipment	Training		General

Sheet1

Category	Discount Tier Quantity (Min)	Discount Tier Quantity (Max)	% Discount
Portable Radios	0	100	25%
Portable Radios	101	1000	35%
Portable Radios	1001	5000	55%
Portable Radios	5001	>5001	59%
Portable Radio Accessories	0	10	25%
Portable Radio Accessories	11	100	35%
Portable Radio Accessories	101	500	55%
Portable Radio Accessories	501	>501	59%

Level Definitions

	Education & Experience Levels			Equivalent Education and Experience
Level	Education	and/ or	Experience	Acquired Degree	Minimum Experience	Added, changed, or deleted	Comments
I	High School diploma or GED Certification	and	1 year	Less than high School/GED	2 years
II	Associate’s Degree or higher	and	2 year	High School/GED	4 years
III	Bachelor's Degree or higher	and	5 year	High School/GED	9 years
				Associate	7 years
				Master	3 years
				Doctorate	1 year
IV	Master's Degree or higher	and	6 year	High School/GED	12 years
				Associate	10 years
				Master	8 years
				Doctorate	4 years

image1.tmp image2.tmp image3.tmp

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