ESBD_File_341047_Attachment H - Discount Pricing Matrix.xlsx

XLSX spreadsheet 54 KB Posted Oct 30, 2023

Attached to: Call Handling Equipment for 9-1-1 Services
Solicitation number: 23-204
Issued by: Brazos County, Texas

About this file

Written by GovTribe AI · Apr 3, 2024

This document is the Discount Pricing Matrix for a state and local government contract opportunity issued by the Purchasing Solutions Alliance (PSA), a non-profit cooperative purchasing program of the Brazos Valley Council of Governments (BVCOG) in Texas. The solicitation is for 9-1-1 Call Handling Equipment (CHE) that will integrate with the existing Motorola VESTA Router Next Generation Core Services (NGCS) solutions. The contract will enable multiple agencies to purchase CHE on an "as needed" basis from a competitively awarded contract. The solicitation defines requirements for National Emergency Number Association (NENA) i3 CHE. The contract will cover multiple jurisdictions, including Brazos County.

The pricing matrix allows vendors to propose discount-off-list pricing for CHE backroom equipment, CHE front room equipment, and miscellaneous items. Vendors must provide published list prices, discount percentages, and resulting PSA prices. The matrix also includes sections for optional items such as maintenance, spares, and monitoring. Pricing is requested on a per-system, per-position, or per-item basis as applicable. The contract term and any renewal options are not specified in the provided documents.

View the file

Other files

File	Type	Posted
ESBD_File_341047_Attachment B - Industry Standards.pdf	PDF	Oct 30, 2023
ESBD_File_341047_Attachment E - Conflict_of_Interest_Questionnaire.pdf	PDF	Oct 30, 2023
ESBD_File_341047_Attachment F - Sample Contract 23-204.pdf	PDF	Oct 30, 2023
ESBD_File_341047_Attachment G - Fixed Pricing Matrix.xlsx	XLSX spreadsheet	Oct 30, 2023
ESBD_File_341047_RFP 23-204 Published 10-30-2023.pdf	PDF	Oct 30, 2023
ESBD_File_341047_Attachment A - Technical Requirements.pdf	PDF	Oct 30, 2023
ESBD_File_341047_Attachment C - Offeror_Acknowledgement_&_Certification.pdf	PDF	Oct 30, 2023
ESBD_File_341047_Attachment D - Proposer Certifications 23-204.pdf	PDF	Oct 30, 2023

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.

Instructions

INSTRUCTIONS TO OFFERORS - READ THIS TAB FIRST

Discount Pricing

- Use this file for proposing pricing that is based on a discount percentage off published list pricing.

- For each line item, enter the currently published list price, the percent discount, and the resulting PSA price.

- Offeror has the option of proposing fixed pricing, discount-off-list pricing, or both.

- This file contains all information related to discount-off-list pricing only.

General

- All cells are locked except those allowing input (shaded orange).

- Tabs will contain cells for Non-Recurring Costs (NRC) and Monthly Recurring Charges (MRC). The NRC columns may also be used for Annual Recurring Costs (ARC).

- Follow the instructions for each Tab.

- Save as an Excel file and give it a unique name, using the following format: "Vendor Name_PSA_PRICING MATRIX_DISCOUNT.xlsx".

- If submitting a paper response, print the workbook (not just the worksheets) to verify content of each tab.

Summary Tab

- For reference purposes only, population numbers for TriCOG are shown on this tab. These numbers are only used in the locked formulas in the Summary tab.

- As the name implies, this tab contains the totals from the Backroom, CHEFront, and Miscellaneous tabs.

- Enter the Offeror name in the designated cell. This information automatically populates the other tabs.

- All other cells are locked.

Backroom Tab

NOTE: Pricing to be on a per-system basis.

- Change the free form "Offeror Input" labels as needed for each device.

- Enter the NRC and MRC pricing information for Call Handling Equipment (hardware, software, etc.). Include the published list price, the percent discount, and the resulting PSA price for each item.

- The MRCs will be annualized on the Summary tab.

- This tab is for pricing out the core devices of the CHE system that reside in a data center or equipment room: servers, switches, routers, firewalls, etc., and the associated software.

- Add rows as needed to include more devices.

CHEFront Tab

NOTE: Pricing shall be on a per-position basis

- Change the free form "Offeror Input" labels as needed for each item.

- Enter the NRC and MRC pricing information for Call Handling Equipment (hardware, software, etc.). Include the published list price, the percent discount, and the resulting PSA price for each item.

- The MRCs will be annualized on the Summary tab.

- This tab is for pricing out the core devices of the CHE system that reside on the PSAP/ECC floor: workstations, etc., and the associated software.

- Be sure to include pricing for all items listed as required in the RFP. Add rows as needed.

Miscellaneous Tab

NOTE: Pricing shall be on a per-position basis

- Change the free form "Offeror Input" labels as needed for each item.

- Enter the NRC and MRC pricing information for Call Handling Equipment (hardware, software, etc.). Include the published list price, the percent discount, and the resulting PSA price for each item.

- The MRCs will be annualized on the Summary tab.

- Show pricing for complete years as though all PSAPs would cut on the same date.

- Be sure to include pricing for all items listed as required in the RFP. Add rows as needed.

Options Tab

- This tab includes lines for Offeror to list additional optional components it may offer as well as maintenance, spares, and other items. Note that some expected line items have already been titled.

- Options pricing is not rolled up into the Summary tab.

- Add rows as needed.

Pricing Notes Tab

- The space may be used to provide explanatory notes regarding the pricing presented in this workbook.

- Due to the limitations on the number of characters allowed in a cell, you may add additional rows to the table.

- Alternately, include this information as a separate document with supplemental information on the pricing, please name that file as follows: Vendor Name_PSA_PRICING NOTES_DISCOUNT

&"-,Bold"&16&F

&A &F &D

Summary

Offeror Name: <Insert Name>

BVCOG
Positions	16
Number of Systems	1

Pricing Matrix	CURRENT PRICING
	NRC	MRC¹
CHE Backroom	0.00	0.00
CHE Front Room	0.00	0.00
Miscellaneous	0.00	0.00
	$0.00	$0.00

Project Totals	BVCOG CURRENT ANNUAL PRICE
Yearly Totals (NRC+MRC)	$0.00

¹ Monthly recurring charges from other tabs have been annualized on this Summary tab.
Four-decimal-place numbers have been rounded to two decimal places for readability.
CTCOG
Positions	57
Number of Systems	2

Pricing Matrix	CURRENT PRICING
	NRC	MRC¹
CHE Backroom	0.00	0.00
CHE Front Room	0.00	0.00
Miscellaneous	0.00	0.00
	$0.00	$0.00

Project Totals	CTCOG CURRENT ANNUAL PRICE
Yearly Totals (NRC+MRC)	$0.00

¹ Monthly recurring charges from other tabs have been annualized on this Summary tab.
Four-decimal-place numbers have been rounded to two decimal places for readability.
HOTCOG
Positions	17
Number of Systems	1

Pricing Matrix	CURRENT PRICING
	NRC	MRC¹
CHE Backroom	0.00	0.00
CHE Front Room	0.00	0.00
Miscellaneous	0.00	0.00
	$0.00	$0.00

Project Totals	HOTCOG CURRENT ANNUAL PRICE
Yearly Totals (NRC+MRC)	$0.00

¹ Monthly recurring charges from other tabs have been annualized on this Summary tab.

Four-decimal-place numbers have been rounded to two decimal places for readability.

&"-,Bold"&16&F

&A	RFP 23-204 Call Handling Equipment for 9-1-1 Services
&F	&D

Backroom

Offeror Name:	<Insert Name>
NOTE: Pricing shall be on a per-host-pair basis

Location of Published List Pricing:

Backroom Equipment	NRC - CURRENT PRICING			MRC1 - CURRENT PRICING
	NRC LIST PRICE	PSA DISCOUNT	NRC PSA PRICE	MRC LIST PRICE	MRC PSA DISCOUNT	MRC PSA PRICE
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input						$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Backroom Total			$ - 0			$ - 0
¹ Enter monthly recurring charges (MRC) on a per-network-segment basis (annualized MRC appears on Summary tab)
Note: NRC = Non-Recurring Costs, MRC = Monthly Recurring Charges.

&"-,Bold"&16&F

&A	RFP 23-204 Call Handling Equipment for 9-1-1 Services
&F	&D

CHEFront

Offeror Name:	<Insert Name>
NOTE: Pricing shall be on a per-position basis

Location of Published List Pricing:

CHE Front Room	NRC - CURRENT PRICING			MRC1 - CURRENT PRICING
	NRC LIST PRICE	PSA DISCOUNT	NRC PSA PRICE	MRC LIST PRICE	MRC PSA DISCOUNT	MRC PSA PRICE
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
CHE Front Room Total			$0.00			$0.0000
¹ Enter monthly recurring charges (annualized MRC will appear on Summary tab)
Note: NRC = Non-Recurring Costs, MRC = Monthly Recurring Charges.

&"-,Bold"&16&F

&A	RFP 23-204 Call Handling Equipment for 9-1-1 Services
&F	&D

Miscellaneous

Offeror Name:	<Insert Name>
NOTE: MRC Pricing shall be on a per-position basis

Location of Published List Pricing:

Miscellaneous	NRC - CURRENT PRICING			MRC1 - CURRENT PRICING
	NRC LIST PRICE	PSA DISCOUNT	NRC PSA PRICE	MRC LIST PRICE	MRC PSA DISCOUNT	MRC PSA PRICE
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Miscellaneous Total			$ - 0			$ - 0
¹ Enter monthly recurring charges (annualized MRC will appear on Summary tab)
Note: NRC = Non-Recurring Costs, MRC = Monthly Recurring Charges.

&"-,Bold"&16&F

&A	RFP 23-204 Call Handling Equipment for 9-1-1 Services
&F	&D

Options

Offeror Name:	<Insert Name>
Options pricing is not rolled up into the Summary tab.

Location of Published List Pricing:

Options	NRC - CURRENT PRICING			MRC1 - CURRENT PRICING
	NRC LIST PRICE	PSA DISCOUNT	NRC PSA PRICE	MRC LIST PRICE	MRC PSA DISCOUNT	MRC PSA PRICE
Hardware maintenance			$ - 0			$ - 0
Software maintenance			$ - 0			$ - 0
Spares kit			$ - 0			$ - 0
Monitoring			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0
Offeror Input			$ - 0			$ - 0

&"-,Bold"&16&F

&A	RFP 23-204 Call Handling Equipment for 9-1-1 Services
&F	&D

Pricing Notes

Discount Pricing Notes Per the instructions, the following space may be used for providing explanatory notes regarding the pricing presented in this workbook. Due to the limitations on the number of characters allowed in a cell, you may add additional rows to the table.

However, if Respondent prefers to attach a separate document with supplemental information on the pricing, please name that file as follows:

Vendor Name_PSA_PRICING NOTES_DISCOUNT

and submit with your other solicitation documentation.

&"-,Bold"&16&F

&A	RFP 23-204 Call Handling Equipment for 9-1-1 Services
&F	&D

File details come from the government source that posted it. Updated Apr 2, 2024.