TACCOM_II_DISCOUNT_AND_SERVICES_PRICING.xlsx

XLSX spreadsheet 477 KB Posted

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

About this file

This file contains pricing templates and instructions for a federal indefinite delivery, indefinite quantity (IDIQ) contract opportunity for tactical communications equipment and services. The templates require offerors to provide fully burdened ceiling rates for over 100 labor categories across multiple option years, along with quantity discounts for portable radios in tiered percentages from 0-25%. The templates will be used to capture pricing for equipment under categories including radios, accessories, infrastructure components, satellite systems, test equipment, and technical manuals. Services include installation, maintenance, training, project management, warehousing, and interoperability support. The Department of Homeland Security Customs and Border Protection is listed as the agency, and pricing is to be provided at both government and contractor sites.

TACCOM II DISCOUNT AND SERVICES PRICING

View the file

Other files for this federal contract opportunity

Other files attached to TACCOM II, newest first.
File Type Posted
TACCOM_II_TC1_PROPOSAL_WORKBOOK_A0010.Final.xlsx XLSX spreadsheet
INDIVIDUAL_SMALL_BUSINESS_SUBCONTRACTING_PLAN_TEMPLATE.docx DOCX document
TACCOM_II_SERVICES_PRICING_TEMPLATE.xlsx XLSX spreadsheet
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.docx DOCX document
WD_No._2015-5637_SCA_WD_for_San_Francisco_Revision_8_011618.pdf PDF
CO-COR_Certification_Form_-_Federal.docx DOCX document
TACCOM_II_RFP_A0010_Final.docx DOCX document
TACCOM_II_TC2_Proposal_Workbook_A0010.Final.xlsx XLSX spreadsheet
TACCOM_II_FBO_COVER_LETTER_A0009.docx DOCX document
TACCOM_II_TC2_PROPOSAL_WORKBOOK.xlsx XLSX spreadsheet
WD_No._2015-5637_SCA_WD_for_San_Francisco_Revision_8_011618.pdf PDF
CO-COR_Certification_Form_-_State_or_Local.docx DOCX document
TACCOM_II_RFP_A0008.docx DOCX document
TACCOM_II_SELF_SCORING_WORKSHEET.xlsx XLSX spreadsheet
TACCOM_II_SF30_A0006.pdf PDF
TACCOM_II_RFP_A0006.docx DOCX document
RFP_TACCOM_II_QUESTIONS_ANSWERS_A0005.xlsx XLSX spreadsheet
TACCOM_II_SUBCATEGORY_EQUIPMENT_PRICING_TEMPLATE.xlsx XLSX spreadsheet
TACCOM_II_SF30_A0004.pdf PDF
TACCOM_II_SF30_A0003.pdf PDF
TACCOM_II_SELF_SCORING_WORKSHEET.xlsx XLSX spreadsheet
TACCOM_II_COVER_LETTER_A0003.docx DOCX document
TACCOM_II_RFP_A0003.docx DOCX document
TACCOM_II_SF30_A0001.pdf PDF
TACCOM_II_RELEVANT_EXPERIENCE_FORM.docx DOCX document
TACCOM_II_SF30_A0002.pdf PDF
RFP_TACCOM_II_QUESTIONS_ANSWERS_A0003.xlsx XLSX spreadsheet
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.docx DOCX document
TACCOM_II_LABOR_CATEGORIES.xlsx XLSX spreadsheet
TACCOM_II_LCAT_MAP_TEMPLATE.xlsx XLSX spreadsheet
TACCOM_II_RFP_A0002.pdf PDF
TACCOM_II_RFP_A0001.pdf PDF
TACCOM_II_LCAT_MAP_TEMPLATE_v2.xlsx XLSX spreadsheet
TACCOM_II_RELEVANT_EXPERIENCE_FORM.docx DOCX document
TACCOM_II_RFP.pdf PDF
TACCOM_II_LCAT_MAP_TEMPLATE.xlsx XLSX spreadsheet
TACCOM_II_LABOR_CATEGORIES.xlsx XLSX spreadsheet
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.docx DOCX document
TACCOM_II_LABOR_CATEGORIES.XLSX XLSX spreadsheet
SECOND_DRAFT_RFP_TACCOM_II_QUESTIONS_COMMENTS_TEMPLATE_.xlsx XLSX spreadsheet
TACCOM_II_PAST_PERFORMANCE_RATING_FORM.DOCX DOCX document
TACCOM_II_DISCOUNT_AND_SERVICES_PRICING.XLSX XLSX spreadsheet
TACCOM_II_Survey.docx DOCX document
TACCOM_II_REGISTRATION_LIST_-_FBO_NOTICE.xls XLS spreadsheet
TACCOM_II_PRE-SOLICITATION_CONFERENCE_FBO_NOTICE.docx DOCX document
TACCOM_II_SECTION_B.docx DOCX document
TACCOM_II_SELF_SCORING_WORKSHEET.xlsx XLSX spreadsheet
TACCOM_II_REQUIREMENTS.xlsx XLSX spreadsheet
TACCOM_II_RELEVANT_EXPERIENCE_FORM.docx DOCX document
TACCOM_II_QUESTIONS_COMMENTS_TEMPLATE.xlsx XLSX spreadsheet
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

Text version

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

OfferorXYZ Corporation
Type of RadioMakeModelContract/ScheduleCurrent 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

OfferorMaterial CategoryType of RadioDiscount Tier Quantity (Min)1Discount Tier Quantity (Max)1% Discount2
Portable Radios700/800 Portable Radio0100
Portable Radios700/800 Portable Radio1011000
Portable Radios700/800 Portable Radio10015000
Portable Radios700/800 Portable Radio5001>5001
Portable RadiosStandard Configuration0100
Portable RadiosStandard Configuration1011000
Portable RadiosStandard Configuration10015000
Portable RadiosStandard Configuration5001>5001
Portable RadiosUHF Portable0100
Portable RadiosUHF Portable1011000
Portable RadiosUHF Portable10015000
Portable RadiosUHF Portable5001>5001
Portable RadiosVHF Portable0100
Portable RadiosVHF Portable1011000
Portable RadiosVHF Portable10015000
Portable RadiosVHF Portable5001>5001
Portable Radios700/800 Portable Radio Accessories010
Portable Radios700/800 Portable Radio Accessories11100
Portable Radios700/800 Portable Radio Accessories101500
Portable Radios700/800 Portable Radio Accessories501>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 the source of their proposed ceiling rates (ie, GSA schedule, commercial catalog if applicable), and identify their corresponding labor category title in Column D. Minimum qualifications are to be shown in Column E.

3. In Column E, Offerors shall enter fully burdened rates for all applicable labor categories. If using GSA and Commercial Catalog prices, discounts are encouraged, column F. Your hourly price, less any discounts, will be used to determine fair and reasonablenes and establish ceiling prices for the IDIQ. Further evaluation of these ceiling prices will be made on the order level. The fully-burdened, discounted base year ceiling rate will populate in column G 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 base period. This attachment will then automatically apply an annual escalation factor of 1.7%. 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. 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 TitleLevelSpecify Source (i.e. GSA, commercial catalog if applicable)Contractor Labor Category TitleRate (GSA/Commercial Catalog, if applicable) prior to discountDiscountProposed Ceiling Rate BASE YEAROPTION YEAR 1OPTION YEAR 2OPTION YEAR 3OPTION YEAR 4
RF EngineerIII$0.000%$0.00$0.00$0.00$0.00$0.00
RF EngineerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Business Analyst/Project Support/ Project Control SpecialistII$0.000%$0.00$0.00$0.00$0.00$0.00
Business Analyst/Project Support/ Project Control SpecialistIII$0.000%$0.00$0.00$0.00$0.00$0.00
Business Analyst/Project Support/ Project Control SpecialistIV$0.000%$0.00$0.00$0.00$0.00$0.00
Business Manager/Project Support StaffII$0.000%$0.00$0.00$0.00$0.00$0.00
Business Manager/Project Support StaffIII$0.000%$0.00$0.00$0.00$0.00$0.00
Business Manager/Project Support StaffIV$0.000%$0.00$0.00$0.00$0.00$0.00
Certified Project ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Certified Project ManagerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Computer-Aided Dispatcher/Law Enforcement Communications Support SpecialistI$0.000%$0.00$0.00$0.00$0.00$0.00
Computer-Aided Dispatcher/Law Enforcement Communications Support SpecialistII$0.000%$0.00$0.00$0.00$0.00$0.00
Computer-Aided Dispatcher/Law Enforcement Communications Support SpecialistIII$0.000%$0.00$0.00$0.00$0.00$0.00
Construction ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Construction ManagerIV$0.000%$0.00$0.00$0.00$0.00$0.00
DraftsmanII$0.000%$0.00$0.00$0.00$0.00$0.00
DraftsmanIII$0.000%$0.00$0.00$0.00$0.00$0.00
DraftsmanIV$0.000%$0.00$0.00$0.00$0.00$0.00
Electrician *I$0.000%$0.00$0.00$0.00$0.00$0.00
Electrician *II$0.000%$0.00$0.00$0.00$0.00$0.00
Electrician *III$0.000%$0.00$0.00$0.00$0.00$0.00
Environmental SpecialistII$0.000%$0.00$0.00$0.00$0.00$0.00
Environmental SpecialistIII$0.000%$0.00$0.00$0.00$0.00$0.00
Environmental SpecialistIV$0.000%$0.00$0.00$0.00$0.00$0.00
IT Systems EngineerII$0.000%$0.00$0.00$0.00$0.00$0.00
IT Systems EngineerIII$0.000%$0.00$0.00$0.00$0.00$0.00
IT Systems EngineerIV$0.000%$0.00$0.00$0.00$0.00$0.00
IT Systems IntegratorII$0.000%$0.00$0.00$0.00$0.00$0.00
IT Systems IntegratorIII$0.000%$0.00$0.00$0.00$0.00$0.00
IT Systems IntegratorIV$0.000%$0.00$0.00$0.00$0.00$0.00
LMR TechniciansII$0.000%$0.00$0.00$0.00$0.00$0.00
LMR TechniciansIII$0.000%$0.00$0.00$0.00$0.00$0.00
LMR TechniciansIV$0.000%$0.00$0.00$0.00$0.00$0.00
Logistics AnalystI$0.000%$0.00$0.00$0.00$0.00$0.00
Logistics AnalystII$0.000%$0.00$0.00$0.00$0.00$0.00
Logistics Analyst/Project Control SpecialistII$0.000%$0.00$0.00$0.00$0.00$0.00
Logistics Analyst/Project Control SpecialistIII$0.000%$0.00$0.00$0.00$0.00$0.00
Logistics Analyst/Project Control SpecialistIV$0.000%$0.00$0.00$0.00$0.00$0.00
Professional EngineerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Professional EngineerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Program ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Program ManagerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Project Engineer/Tower EngineerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Project Engineer/Tower EngineerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Purchaser / Procurement SpecialistII$0.000%$0.00$0.00$0.00$0.00$0.00
Purchaser / Procurement SpecialistIII$0.000%$0.00$0.00$0.00$0.00$0.00
SchedulerIII$0.000%$0.00$0.00$0.00$0.00$0.00
SchedulerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Spectrum ManagerI$0.000%$0.00$0.00$0.00$0.00$0.00
Spectrum ManagerII$0.000%$0.00$0.00$0.00$0.00$0.00
Spectrum ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Spectrum ManagerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Subject Matter Expert (SME)III$0.000%$0.00$0.00$0.00$0.00$0.00
Subject Matter Expert (SME)IV$0.000%$0.00$0.00$0.00$0.00$0.00
Supervisor (On-Site)I$0.000%$0.00$0.00$0.00$0.00$0.00
Supervisor (On-Site)II$0.000%$0.00$0.00$0.00$0.00$0.00
Supervisor (On-Site)III$0.000%$0.00$0.00$0.00$0.00$0.00
Supervisor (On-Site)IV$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Fleet ManagerI$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Fleet ManagerII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Fleet ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Interoperable SystemsI$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Interoperable SystemsII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Interoperable SystemsIII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Interoperable SystemsIV$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Rapid Deployment Assets ManagerI$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Rapid Deployment Assets ManagerII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist /TechniciansI$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist /TechniciansII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist /TechniciansIII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist /TechniciansIV$0.000%$0.00$0.00$0.00$0.00$0.00
TechnicianI$0.000%$0.00$0.00$0.00$0.00$0.00
TechnicianII$0.000%$0.00$0.00$0.00$0.00$0.00
TechnicianIII$0.000%$0.00$0.00$0.00$0.00$0.00
Technician/Business AnalystII$0.000%$0.00$0.00$0.00$0.00$0.00
Technician/Business AnalystIII$0.000%$0.00$0.00$0.00$0.00$0.00
Tower Climber / Tower WorkerI$0.000%$0.00$0.00$0.00$0.00$0.00
Tower Climber / Tower WorkerII$0.000%$0.00$0.00$0.00$0.00$0.00
Tower InspectorI$0.000%$0.00$0.00$0.00$0.00$0.00
Tower InspectorII$0.000%$0.00$0.00$0.00$0.00$0.00
Tower InspectorIII$0.000%$0.00$0.00$0.00$0.00$0.00
Tower InspectorIV$0.000%$0.00$0.00$0.00$0.00$0.00
Tower RiggerI$0.000%$0.00$0.00$0.00$0.00$0.00
Tower RiggerII$0.000%$0.00$0.00$0.00$0.00$0.00
Tower RiggerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Tower RiggerIV$0.000%$0.00$0.00$0.00$0.00$0.00
TrainerIII$0.000%$0.00$0.00$0.00$0.00$0.00
TrainerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Training SpecialistII$0.000%$0.00$0.00$0.00$0.00$0.00
Training SpecialistIII$0.000%$0.00$0.00$0.00$0.00$0.00
Training SpecialistIV$0.000%$0.00$0.00$0.00$0.00$0.00
Transportation Staff - Helicopter Pilot *I$0.000%$0.00$0.00$0.00$0.00$0.00
Transportation Staff - Helicopter Pilot *II$0.000%$0.00$0.00$0.00$0.00$0.00
Transportation Staff - Truck Driver *I$0.000%$0.00$0.00$0.00$0.00$0.00
Transportation Staff - Truck Driver *II$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse / Logistics ManagerI$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse / Logistics ManagerII$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse / Logistics ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse / Logistics ManagerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse ManagerII$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse Staff *I$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse Staff *II$0.000%$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 CategoryLevelSpecify Source (i.e. GSA, commercial catalog if applicable)Contractor Labor Category TitleRate (GSA/Commercial Catalog, if applicable) prior to discountDiscountProposed Ceiling Rate BASE YEAROPTION YEAR 1OPTION YEAR 2OPTION YEAR 3OPTION YEAR 4
RF EngineerIII$0.000%$0.00$0.00$0.00$0.00$0.00
RF EngineerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Business Analyst/Project Support/ Project Control SpecialistII$0.000%$0.00$0.00$0.00$0.00$0.00
Business Analyst/Project Support/ Project Control SpecialistIII$0.000%$0.00$0.00$0.00$0.00$0.00
Business Analyst/Project Support/ Project Control SpecialistIV$0.000%$0.00$0.00$0.00$0.00$0.00
Business Manager/Project Support StaffII$0.000%$0.00$0.00$0.00$0.00$0.00
Business Manager/Project Support StaffIII$0.000%$0.00$0.00$0.00$0.00$0.00
Business Manager/Project Support StaffIV$0.000%$0.00$0.00$0.00$0.00$0.00
Certified Project ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Certified Project ManagerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Computer-Aided Dispatcher/Law Enforcement Communications Support SpecialistI$0.000%$0.00$0.00$0.00$0.00$0.00
Computer-Aided Dispatcher/Law Enforcement Communications Support SpecialistII$0.000%$0.00$0.00$0.00$0.00$0.00
Computer-Aided Dispatcher/Law Enforcement Communications Support SpecialistIII$0.000%$0.00$0.00$0.00$0.00$0.00
Construction ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Construction ManagerIV$0.000%$0.00$0.00$0.00$0.00$0.00
DraftsmanII$0.000%$0.00$0.00$0.00$0.00$0.00
DraftsmanIII$0.000%$0.00$0.00$0.00$0.00$0.00
DraftsmanIV$0.000%$0.00$0.00$0.00$0.00$0.00
Electrician *I$0.000%$0.00$0.00$0.00$0.00$0.00
Electrician *II$0.000%$0.00$0.00$0.00$0.00$0.00
Electrician *III$0.000%$0.00$0.00$0.00$0.00$0.00
Environmental SpecialistII$0.000%$0.00$0.00$0.00$0.00$0.00
Environmental SpecialistIII$0.000%$0.00$0.00$0.00$0.00$0.00
Environmental SpecialistIV$0.000%$0.00$0.00$0.00$0.00$0.00
IT Systems EngineerII$0.000%$0.00$0.00$0.00$0.00$0.00
IT Systems EngineerIII$0.000%$0.00$0.00$0.00$0.00$0.00
IT Systems EngineerIV$0.000%$0.00$0.00$0.00$0.00$0.00
IT Systems IntegratorII$0.000%$0.00$0.00$0.00$0.00$0.00
IT Systems IntegratorIII$0.000%$0.00$0.00$0.00$0.00$0.00
IT Systems IntegratorIV$0.000%$0.00$0.00$0.00$0.00$0.00
LMR TechniciansII$0.000%$0.00$0.00$0.00$0.00$0.00
LMR TechniciansIII$0.000%$0.00$0.00$0.00$0.00$0.00
LMR TechniciansIV$0.000%$0.00$0.00$0.00$0.00$0.00
Logistics AnalystI$0.000%$0.00$0.00$0.00$0.00$0.00
Logistics AnalystII$0.000%$0.00$0.00$0.00$0.00$0.00
Logistics Analyst/Project Control SpecialistII$0.000%$0.00$0.00$0.00$0.00$0.00
Logistics Analyst/Project Control SpecialistIII$0.000%$0.00$0.00$0.00$0.00$0.00
Logistics Analyst/Project Control SpecialistIV$0.000%$0.00$0.00$0.00$0.00$0.00
Professional EngineerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Professional EngineerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Program ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Program ManagerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Project Engineer/Tower EngineerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Project Engineer/Tower EngineerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Purchaser / Procurement SpecialistII$0.000%$0.00$0.00$0.00$0.00$0.00
Purchaser / Procurement SpecialistIII$0.000%$0.00$0.00$0.00$0.00$0.00
SchedulerIII$0.000%$0.00$0.00$0.00$0.00$0.00
SchedulerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Spectrum ManagerI$0.000%$0.00$0.00$0.00$0.00$0.00
Spectrum ManagerII$0.000%$0.00$0.00$0.00$0.00$0.00
Spectrum ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Spectrum ManagerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Subject Matter Expert (SME)III$0.000%$0.00$0.00$0.00$0.00$0.00
Subject Matter Expert (SME)IV$0.000%$0.00$0.00$0.00$0.00$0.00
Supervisor (On-Site)I$0.000%$0.00$0.00$0.00$0.00$0.00
Supervisor (On-Site)II$0.000%$0.00$0.00$0.00$0.00$0.00
Supervisor (On-Site)III$0.000%$0.00$0.00$0.00$0.00$0.00
Supervisor (On-Site)IV$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Fleet ManagerI$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Fleet ManagerII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Fleet ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Interoperable SystemsI$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Interoperable SystemsII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Interoperable SystemsIII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Interoperable SystemsIV$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Rapid Deployment Assets ManagerI$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist - Rapid Deployment Assets ManagerII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist /TechniciansI$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist /TechniciansII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist /TechniciansIII$0.000%$0.00$0.00$0.00$0.00$0.00
Systems Technologist /TechniciansIV$0.000%$0.00$0.00$0.00$0.00$0.00
TechnicianI$0.000%$0.00$0.00$0.00$0.00$0.00
TechnicianII$0.000%$0.00$0.00$0.00$0.00$0.00
TechnicianIII$0.000%$0.00$0.00$0.00$0.00$0.00
Technician/Business AnalystII$0.000%$0.00$0.00$0.00$0.00$0.00
Technician/Business AnalystIII$0.000%$0.00$0.00$0.00$0.00$0.00
Tower Climber / Tower WorkerI$0.000%$0.00$0.00$0.00$0.00$0.00
Tower Climber / Tower WorkerII$0.000%$0.00$0.00$0.00$0.00$0.00
Tower InspectorI$0.000%$0.00$0.00$0.00$0.00$0.00
Tower InspectorII$0.000%$0.00$0.00$0.00$0.00$0.00
Tower InspectorIII$0.000%$0.00$0.00$0.00$0.00$0.00
Tower InspectorIV$0.000%$0.00$0.00$0.00$0.00$0.00
Tower RiggerI$0.000%$0.00$0.00$0.00$0.00$0.00
Tower RiggerII$0.000%$0.00$0.00$0.00$0.00$0.00
Tower RiggerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Tower RiggerIV$0.000%$0.00$0.00$0.00$0.00$0.00
TrainerIII$0.000%$0.00$0.00$0.00$0.00$0.00
TrainerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Training SpecialistII$0.000%$0.00$0.00$0.00$0.00$0.00
Training SpecialistIII$0.000%$0.00$0.00$0.00$0.00$0.00
Training SpecialistIV$0.000%$0.00$0.00$0.00$0.00$0.00
Transportation Staff - Helicopter Pilot *I$0.000%$0.00$0.00$0.00$0.00$0.00
Transportation Staff - Helicopter Pilot *II$0.000%$0.00$0.00$0.00$0.00$0.00
Transportation Staff - Truck Driver *I$0.000%$0.00$0.00$0.00$0.00$0.00
Transportation Staff - Truck Driver *II$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse / Logistics ManagerI$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse / Logistics ManagerII$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse / Logistics ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse / Logistics ManagerIV$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse ManagerII$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse ManagerIII$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse Staff *I$0.000%$0.00$0.00$0.00$0.00$0.00
Warehouse Staff *II$0.000%$0.00$0.00$0.00$0.00$0.00

vlookup

Technical CategoryCategoryCategory IIStandardized CategoryDropdown CategoryDropdown for Portable Radio Sheet
EquipmentCommunications InfrastructureComparatorInfrastructureCommunications Infrastructure700/800 Portable Radio
EquipmentCommunications InfrastructureDigital Interface UnitInfrastructureSoftware700/800 Portable Radio Accessories
EquipmentCommunications InfrastructureDispatch ConsoleInfrastructureEncryption Key Loaders/and AccessoriesStandard Configuration
EquipmentCommunications InfrastructureKey Management FacilityInfrastructureMobile RadiosUHF Portable
EquipmentCommunications InfrastructureKey Variable LoaderInfrastructureUHF-AMVHF Portable
EquipmentCommunications InfrastructureLogging RecordersInfrastructureUHF-AM/MAD
EquipmentCommunications InfrastructureReceiversInfrastructureVHF-AM
EquipmentCommunications InfrastructureRepeaters/Base StationInfrastructureVHF – Digital
EquipmentCommunications InfrastructureRoutersInfrastructureTechnical Service Manuals
EquipmentCommunications InfrastructureServersInfrastructureHigh Frequency (HF) Radio
EquipmentCommunications InfrastructureSwitchInfrastructureHF Radio
EquipmentCommunications InfrastructureWorkstationsInfrastructureLow Band Mobile Radio
EquipmentCommunications InfrastructureControl Stations/Desk Set Control PointsInfrastructureLow Band Portable Radio
EquipmentCommunications InfrastructureTone/Digital/IP Remote Control ConsolesInfrastructureUSCG – specific
EquipmentCommunications InfrastructureTransportable RepeaterInfrastructureMaritime
EquipmentCommunications InfrastructureToolsInfrastructureBoat Crew Communications System
EquipmentCommunications InfrastructureAdditional: Microwave WaveInfrastructureMilitary Satellite Communications
EquipmentCommunications InfrastructureCivil InfrastructureInfrastructureTest Equipment
EquipmentSoftwareInfrastructureControl Stations / Desk Set Control Points
EquipmentEncryption Key Loaders/and AccessoriesRadios and accessoriesEncryption Key Loaders / and Accessories
EquipmentMobile RadiosRadios and accessoriesInteroperability
EquipmentPortable Radios700/800 Portable RadiosRadios and accessoriesBoat Crew Communications System (BCCS)
EquipmentPortable Radios700/800 Portable Radio AccessoriesRadios and accessoriesSatellite
EquipmentPortable RadiosStandard ConfigurationRadios and accessoriesTransportable Repeater Non-Commercial Power
EquipmentPortable RadiosUHF PortableRadios and accessoriesTransportable Repeater, Commercial Power
EquipmentPortable RadiosVHF PortableRadios and accessoriesUHF-AM / MAD
EquipmentUHF-AMTransceiverRadios and accessoriesVHF-Digital Selective Requirements
EquipmentUHF-AM/MADRadios and accessoriesGeneral
EquipmentVHF-AMRadios and accessoriesTraining
EquipmentVHF – DigitalRadios and accessories
EquipmentTechnical Service ManualsRadios and accessories
EquipmentHigh Frequency (HF) RadioHigh Frequency
EquipmentHF RadioHigh Frequency
EquipmentLow Band Mobile RadioHigh Frequency
EquipmentLow Band Portable RadioHigh Frequency
EquipmentUSCG – specificHigh Frequency
EquipmentMaritimeMaritime
EquipmentBoat Crew Communications SystemMaritime
EquipmentMilitary Satellite CommunicationsSatellite
EquipmentTest EquipmentTest Equipment
ServicesO&M Purchasing SupportO&M
ServicesO&M Repair and Maintenance ServicesO&M
ServicesPreventive MaintenanceO&M
ServicesCommand & Control / Dispatch Center MaintenanceO&M
ServicesSubscriber Programming / Blitz SupportRadio
ServicesSubscriber RepairRadio
ServicesSubscriber InstallationRadio
ServicesTactical Communications Fleet / Rapid Deployment Equipment SupportRadio
ServicesRF Network ManagementRF
ServicesSpectrum SupportRF
ServicesSite SurveysSite
ServicesEnvironmental AnalysisSite
ServicesStructural Analysis and RemediationSite
ServicesSite Lease AcquisitionSite
ServicesSite Construction and System ImplementationSite
ServicesTower Site / Infrastructure Maintenance SupportSite
ServicesTelco Circuit / Pots Lines SupportSite
ServicesTower Lease SupportSite
ServicesTower Operations and Maintenance SupportSite
ServicesInteroperable Systems / Interoperability SupportSystem
ServicesCircuit AcquisitionSystem
ServicesSystem StagingSystem
ServicesIntegrationSystem
ServicesRe System DesignSystem
ServicesROIP System DesignSystem
ServicesProject Closeout ActivitiesProject Management/Support
ServicesProject ManagementProject Management/Support
ServicesGeneral RequirementsProject Management/Support
ServicesEnd User TrainingProject Management/Support
ServicesLogistics /Warehouse SupportProject Management/Support
ServicesCommand & Control / Dispatch SupportProject Management/Support
ServicesUser Requirements GatheringProject Management/Support
ServicesSystem MonitoringProject Management/Support
ServicesLabor and ServicesProject Management/Support
ServicesLogistics/ Warehouse/ Transportation SupportProject Management/Support
EquipmentControl Stations / Desk Set Control PointsInfrastructure
EquipmentEncryption Key Loaders / and AccessoriesInfrastructure
EquipmentInteroperabilityRadios and accessories
EquipmentBoat Crew Communications System (BCCS)Maritime
EquipmentSatelliteSatellite
EquipmentTransportable Repeater Non-Commercial PowerInfrastructure
EquipmentTransportable Repeater, Commercial PowerInfrastructure
EquipmentUHF-AM / MADRadios and accessories
EquipmentVHF-Digital Selective RequirementsRadios and accessories
EquipmentGeneralGeneral
EquipmentTrainingGeneral

Sheet1

CategoryDiscount Tier Quantity (Min)Discount Tier Quantity (Max)% Discount
Portable Radios010025%
Portable Radios101100035%
Portable Radios1001500055%
Portable Radios5001>500159%
Portable Radio Accessories01025%
Portable Radio Accessories1110035%
Portable Radio Accessories10150055%
Portable Radio Accessories501>50159%

Level Definitions

Education & Experience LevelsEquivalent Education and Experience
LevelEducationand/ orExperienceAcquired DegreeMinimum ExperienceAdded, changed, or deletedComments
IHigh School diploma or GED Certificationand1 yearLess than high School/GED2 years
IIAssociate’s Degree or higherand2 yearHigh School/GED4 years
IIIBachelor's Degree or higherand5 yearHigh School/GED9 years
Associate7 years
Master3 years
Doctorate1 year
IVMaster's Degree or higherand6 yearHigh School/GED12 years
Associate10 years
Master8 years
Doctorate4 years

image1.tmp image2.tmp image3.tmp

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