ESBD_File_341047_Attachment G - Fixed Pricing Matrix.xlsx

XLSX spreadsheet 53 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 a Fixed Pricing Matrix spreadsheet for a state and local 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 seeking experienced and qualified vendors to provide 9-1-1 Call Handling Equipment (CHE) that is National Emergency Number Association (NENA) i3 compliant and will integrate with the existing Motorola VESTA Router Next Generation Core Services (NGCS) solutions. The contract will enable PSA members, including Brazos County, to purchase CHE on an "as needed" basis. The pricing matrix includes tabs for Backroom, CHE Front Room, Miscellaneous, and Options, with offerors required to input pricing on a per-system or per-position basis as applicable for the initial 4-year contract period.

The pricing matrix provides instructions for offerors to propose fixed pricing, discount-off-list pricing, or both. It requires offerors to provide non-recurring costs (NRC) and monthly recurring charges (MRC) for the various CHE components, with the MRCs annualized on the Summary tab. Offerors are also instructed to provide pricing notes and any additional optional components, maintenance, spares, and other items on separate tabs. The contract will be awarded through a competitive solicitation process, though no additional details are provided on the incumbent or current environment.

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 H - Discount 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

Fixed Pricing

- Use this file for proposing fixed pricing.

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

- This file contains all information related to fixed 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_FIXED.xlsx".

- 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 and enter the NRC and MRC pricing information for Call Handling Equipment (hardware, software, etc.). 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

- This tab is for pricing 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 and enter the NRC and MRC pricing information for any other items required for completion of the project that do not fit neatly in the CHE tab. 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
	INITIAL CONTRACT PERIOD
Pricing Matrix	YEAR 1		YEAR 2		YEAR 3		YEAR 4
	NRC	MRC¹	NRC	MRC¹	NRC	MRC¹	NRC	MRC¹
CHE Backroom	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
CHE Front Room	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Miscellaneous	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Project Totals	YEAR 1	YEAR 2	YEAR 3	YEAR 4
Yearly Totals (NRC+MRC)	$0.00	$0.00	$0.00	$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
	INITIAL CONTRACT PERIOD
Pricing Matrix	YEAR 1		YEAR 2		YEAR 3		YEAR 4
	NRC	MRC¹	NRC	MRC¹	NRC	MRC¹	NRC	MRC¹
CHE Backroom	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
CHE Front Room	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Miscellaneous	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Project Totals	YEAR 1	YEAR 2	YEAR 3	YEAR 4
Yearly Totals (NRC+MRC)	$0.00	$0.00	$0.00	$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
	INITIAL CONTRACT PERIOD
Pricing Matrix	YEAR 1		YEAR 2		YEAR 3		YEAR 4
	NRC	MRC¹	NRC	MRC¹	NRC	MRC¹	NRC	MRC¹
CHE Backroom	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
CHE Front Room	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Miscellaneous	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Project Totals	YEAR 1	YEAR 2	YEAR 3	YEAR 4
Yearly Totals (NRC+MRC)	$0.00	$0.00	$0.00	$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

	INITIAL CONTRACT PERIOD
Backroom Equipment	YEAR 1		YEAR 2		YEAR 3		YEAR 4
	NRC	MRC¹	NRC	MRC¹	NRC	MRC¹	NRC	MRC¹
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Backroom Total	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
¹ 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

	INITIAL CONTRACT PERIOD
CHE Front Room	YEAR 1		YEAR 2		YEAR 3		YEAR 4
	NRC	MRC¹	NRC	MRC¹	NRC	MRC¹	NRC	MRC¹
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
CHE Front Room Total	$0.00	$0.0000	$0.00	$0.0000	$0.00	$0.0000	$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

	INITIAL CONTRACT PERIOD
Miscellaneous	YEAR 1		YEAR 2		YEAR 3		YEAR 4
	NRC	MRC¹	NRC	MRC¹	NRC	MRC¹	NRC	MRC¹
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Miscellaneous Total	$0.00	$0.0000	$0.00	$0.0000	$0.00	$0.0000	$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

Options

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

	INITIAL CONTRACT PERIOD
Options	YEAR 1		YEAR 2		YEAR 3		YEAR 4
	NRC	MRC	NRC	MRC	NRC	MRC	NRC	MRC
Hardware maintenance
Software maintenance
Spares kit
Monitoring
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input
Offeror Input

&"-,Bold"&16&F

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

Pricing Notes

Fixed 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_FIXED

and submit with your other solicitation documentation.

&"-,Bold"&16&F

Fixed Pricing Notes	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.