1-BPM003459_Catalog_Import_File V2.xlsx

XLSX spreadsheet 28 KB Posted Aug 5, 2021

Attached to: Master Agreement AZ|CTR056620
Contract number: CTR056620
Issued by: Arizona

About this file

Written by GovTribe AI · Oct 3, 2025

This document appears to be a comprehensive catalog import file for a state and local contract, specifically focused on technology and traffic management equipment. The file contains detailed pricing information for products from manufacturers Econolite and WTI, with a primary focus on traffic monitoring and surveillance systems. The contract seems to be applicable to jurisdictions within Arizona, as evidenced by the extensive tax code listings for various cities and counties in the state.

The catalog includes pricing for multiple product lines, such as Econolite's Autoscope Vision camera systems (ranging from 1-6 camera configurations), radar sensors, communication panels, and conductor cables. Pricing is consistent across different system configurations, with items like a 6-camera system priced at $30,804.00 and a single camera at $4,475.00. WTI products include CCTV cameras, wall mounts, and POE injectors. The contract appears to be valid from July 1, 2021, with all listed items showing a 0.00% discount. The document provides a detailed breakdown of unit prices, units of measure, and an extensive tax code reference specific to different Arizona localities, suggesting a comprehensive state and local government procurement vehicle for traffic and surveillance equipment.

View the file

Other files

File	Type	Posted
1-Financial Envelope-Proposal # 1-prop_answer.xls	XLS spreadsheet	Aug 5, 2021
1-Participation Israel Boycott.pdf	PDF	Aug 5, 2021
APPROVED_Econolite_06.27.21-06.27.22.pdf	PDF	Aug 5, 2021
CTR056620_Contract_Amendment_Summary_No._1.pdf	PDF	Aug 5, 2021
1-Cutsheets and submittals.pdf	PDF	Aug 5, 2021
1-Lobbying Certificate.pdf	PDF	Aug 5, 2021
1-Non Collision Affidavit.pdf	PDF	Aug 5, 2021
1-Proposal # 1-prop_items.xls	XLS spreadsheet	Aug 5, 2021
ACCEPTED_ANY_ALL_GL_AL_WC_06.27.23-06.27.24.pdf	PDF	Aug 5, 2021
ACCEPTED_ANY_ALL_GL_AL_WC_06.27.24-06.27.25__1_.pdf	PDF	Aug 5, 2021
CTR056620_Contract_Amendment_Summary_6.pdf	PDF	Aug 5, 2021
CTR056620_Contract_Amendment_Summary_Two__2_.pdf	PDF	Aug 5, 2021
1-Buy America Certificate.pdf	PDF	Aug 5, 2021
1-Confidentiality & Trade Secrets.pdf	PDF	Aug 5, 2021
1-Price Increase percentages & w-9_1.pdf	PDF	Aug 5, 2021
APPROVED_CRT056620_GL_AL_WC_06.27.22-06.27.23.pdf	PDF	Aug 5, 2021
CTR056620_Contract_Amendment_Summary_7.pdf	PDF	Aug 5, 2021
CTR056620_Contract_Amendment_Summary_Five__5_.pdf	PDF	Aug 5, 2021
Contract_Extension_-_Joan_Concurrence_-_Roadway_Electrical__State___Federal_.pdf	PDF	Aug 5, 2021
1-Offer and Aceptance.pdf	PDF	Aug 5, 2021
1-Price Increase percentages & w-9.pdf	PDF	Aug 5, 2021
CTR056620_Contract_Amendment_Summary_Four__4_.pdf	PDF	Aug 5, 2021
CTR056620_Contract_Amendment_Summary_Three__3_.pdf	PDF	Aug 5, 2021
CTR056620_Contract_Documents_-_Econolite.pdf	PDF	Aug 5, 2021

Show all 24

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Catalog Template

Manufacturer

Product Short Description

Product Manufacturer

Link to Manufacturer Catalog

Product Category

Percent Discount

Summary

Key Words

Detailed Description

Image File Name

Product File Name

Link to Item Catalog

Validity Start Date

Validity End Date

Item Comments

Retail price (tax excl.)

Tax Code

Item Qty Negotiated A

Item Price A (tax excl.)

Item Qty Negotiated B

Item Price B (tax excl.)

Item Qty Negotiated C

Item Price C (tax excl.)

Item Qty Negotiated D

Item Price D (tax excl.)

Item Qty Negotiated E

Item Price E (tax excl.)

Unit of Measure (UOM)

Other Units

Packaging

Delivery Delay

Delivery Mode

Incoterm

Incoterm Location

Item Tag

Econolite

Autoscope Vision 6-Camera system No Cable

TBD

0.00%

7/1/21

$30,804.00

Econolite

Autoscope Vision 5-Camera system No Cable

TBD

0.00%

7/1/21

$26,141.00

Econolite

Autoscope Vision 4-Camera systemNo Cable

TBD

0.00%

7/1/21

$21,478.00

Econolite

Autoscope Vision 3-Camera system No Cable

TBD

0.00%

7/1/21

$16,815.00

Econolite

Autoscope Vision 2-Camera system No Cable

TBD

0.00%

7/1/21

$12,152.00

Econolite

Autoscope Vision 1-Camera system No Cable

TBD

0.00%

7/1/21

$7,489.00

Econolite

Autoscope Vision Single Camera

AVISION

0.00%

7/1/21

$4,475.00

Econolite

Autoscope Vision Std. Mounting Bracket

AMBKTM11S

0.00%

7/1/21

$49.00

Econolite

Autoscope Vision Extender Mtg Bracket

AMBKTM16S

0.00%

7/1/21

$230.00

Econolite

Autoscope Vision Comm Panel

AVCM

0.00%

7/1/21

$2,800.00

Econolite

Autoscope SDLC Cable

171-1804-501

0.00%

7/1/21

$69.00

Econolite

Autoscope Total Vu

201-1005-201 or TOTALVUHD

0.00%

7/1/21

$1,000.00

Econolite

EVO Radar sensor Kit

143-1001-503

0.00%

7/1/21

$8,500.00

Econolite

EVO Radar Cabinet Hub same price for wall or rack mount

Reference wall or shelf

0.00%

7/1/21

$4,200.00

Econolite

EVO Radar TS2 SDLC Cable Male to SDLC Hub 25 pin to 15 pin

151-0967

0.00%

7/1/21

$149.00

Econolite

EVO Radar Conductor Cable 500' Spool

EVOCBL-05

0.00%

7/1/21

$400.00

Econolite

Autoscope Vision Conductor Cable 500' Spool

1175-010

0.00%

7/1/21

$395.00

Econolite

Autoscope Vision Conductor Cable 1,000' Spool

1175-011

0.00%

7/1/21

$620.00

Econolite

Autoscope Vision Conductor Cable 5,000' Spool

16/3-5000

0.00%

7/1/21

$3,100.00

WTI

Viper Sidwinder CCTV Camera

VS720-H.264-HD30L-POE-R

0.00%

7/1/21

$3,559.00

WTI

Viper Sidwinder CCTV Camera

VS720-H.264-HD30L-AC-BR

0.00%

7/1/21

$3,893.00

WTI

Wall mount w vertical adapter

SWWM1 wVPA

0.00%

7/1/21

$166.00

WTI

POE Injector

WTI-POE-I

0.00%

7/1/21

$331.00

Various

Cat 6 Cable 150' Spool

TBD

0.00%

7/1/21

$199.00

Field Descriptions

Ivalua Field	Ivalua Field Description	Required
Product Short Description	Product Label	Y
Product Manufacturer	Product Manufacturer	Y
Link to Manufacturer Catalog	URL to Manufacturer Catalog	Y
Product Code	Manufacturer Ref.
Commodity Code	Commodity Code for Product - Commodity level does not matter
Summary	Summary
Key Words	Keywords
Detailed Description	Product Description
Image File Name	Product Image
Percent Discount	Percent Discount	Y
Item Short Description	Item Label	Y
Vendor Item Ref No.	Supplier Reference	Y
Link to Item Catalog	Supplier Reference URL
Validity Start Date	Contract Validated Date From
Validity End Date	Contract Validated Date To
Item Comments	Item Comment
Retail price (tax excl.)	Item Public Price	Y
Currency	Currency (USD)	Y
Tax Code	Tax (%)
Item Qty Negotiated A	Item Quantity A Negotiated
Item Price A (tax excl.)	Negotiated Price for Quantity A
Item Qty Negotiated B	Item Quantity B Negotiated
Item Price B (tax excl.)	Negotiated Price for Quantity B
Item Qty Negotiated C	Item Quantity C Negotiated
Item Price C (tax excl.)	Negotiated Price for Quantity C
Item Qty Negotiated D	Item Quantity D Negotiated
Item Price D (tax excl.)	Negotiated price for Quantity D
Item Qty Negotiated E	Item Quantity E Negotiated
Item Price E (tax excl.)	Negotiated price for Quantity E
Unit of Measure (UOM)	Unit of Measure	Y
Other Units	Additional Unit of Measure
Packaging	To be left blank
Delivery Delay	To be left blank
Delivery Mode	To be left blank
Incoterm	To be left blank
Incoterm Location	To be left blank

Units of Measure

Code (To be entered in catalog import)	Label
SQFT	Square Foot
MM	Millimeter
FT	Feet
CUFT	Cubic Feet
CM	Centimeter
10	Per 10
15MIN	15 Minutes
1GALPOT	1 Gallon Pot
24BX	24 Inch Box
35INPOT	3-1/2 Inch Pot
36INBX	36 Inch Box
3GALPOT	3 Gallon Pot
4INPOT	4 Inch Pot
5GALPOT	5 Gallon Pot
6PK	6 Pack
ACRE	Acre
AMP	Ampule
ASSM	Assessment
BAG	Bag
BAIL	Bail
BALE	Bale
BALL	Ball
BALR	Baler
BAND	Band
BANL	Bi-Annual
BAR	Bar
BBL	Barrel
BCH	Bunch
BDFT	Board foot
BDL	Bundle
BE	Bundle
BED	Bed
BG	Bag
BIMO	Bimonthly
BIWKLY	Bi-Weekly
BKT	Bucket
BL	Bale
BOLT	Bolt
BOOK	Book
BOX	Box
BPI	Base Point Incentive
BTL	Bottle
BU	Bushel
BULK	Bulk
BX	Box
CAN	Can
CARD	Card
CARE	Cost/Care
CASE	CASE
CASK	Cask
CBDF	Hundred Board Feet
CBY	Carboy
CC	Cubic centimeter
CFT	Hundred feet
CLGCDT	College Credit
CLML	Column Line
Clnt	Client
CLTN	Collection
CN	CN
CNGM	Centigram
COIL	Coil
CONE	Cone
Consult	Consultation
CORD	Cord
Cost	Cost
CRLD	Carload
CRT	Crate
CRTG	Cartridge
CS	Case
CT	Carton
CTN	Carton
CTR	Container
CUIN	Cubic inch
CUP	Cup
CWT	Hundred weight
CYL	Cylinder
DCGM	Decigram
DCMT	Decimeter
DEWR	Dewar vessel (flask)
DISK	Disk
DM	Drum
DOSE	Dose
DR	Dram
DZ	Dozen
DZN	Dozen
EA	Each
EACH	Each
ENVP	ENVP
ES	ES
EVENT	Event
EXAM	Exam
FEE	Fee
FIBER	Fiber
FIELD	Per Field
FILE	File
FLAT	Flat
FLOZ	Fluid ounce
GALL	Gallon
GL	Gallon
GLL	Gallon
GM	Gram
GRAIN	Grain
GROSS	Gross
GRTON	Gross Ton (2240 lbs)
HANK	Hank
HFGL	Half Gallon
HFHR	Half Hour
HFPT	Half Pint
HKUP	Hookup
Hlf Dy	Half Day
HR	Hour
HSPP	Hospital Pack
IMAGE	Per Image
IN	Inch
INJT	Injection
JAR	Jar
JOB	Job
JUG	Jug
KIT	Kit
KM	Kilometer
KT	Kit
KW	Kilowatt
LCT	Locate
Lease	Lease
LF	Lineal Foot
LFT	Linear foot
LGSN	Legislative Session
LGTH	Length
LI	Liter
LINE	Line
LOAD	Load
LOAF	Loaf
LOP	Line of Print
LOT	Lot
LTR	Liter
LUG	Lug
LUMPSUM	Lump Sum
MC	Master Carton
MCUFT	Thousand Cubic Feet
MDABM	Media Buy Markup (Percent of Net Price)
MG	Milligram
MILE	Mile
ML	Milliliter
MLST	Milestone
MN	Minute (Labor)
MNT	Minute
MO	Month
MORTN	Monthly Retainer
MSHT	M Sheets
MSQIN	Thousand Square Inches
Mtng	Meeting
NOSH	No-Show
OZ	Ounce
PACK	Pack
PAD	Pad
PAIL	Pail
PAIR	Pair
PAN	Pan
PC	Piece
PCALL	Per Call
PCNT	Percent
PCTG	Percentage
PD	Per Diem
PDLV	Per Delivery
PEPM	Per Employee Per Month
PERSON	Person
PF	Pallet
PG	Page
PHMS	PHMS
PK	Pack
PKG	Package
PKT	Packet
PL	Pallet
POHS	Percent of Hired Salary
PPGE	Per Page
PPM	Person Per Month
PR	Pair
PRSN	PRSN
PT	Pint
PTGH	Photograph
Pull	Pull
PYWT	Penny Weight
QRT	Quart
QTR	Quarter
RL	Reel
RO	Roll
ROLL	Roll
ROUND	Round
RPT	Report
SACK	Sack
SEM	Per Semester
Semi-Ann	Semi-Annual
SET	Set
SF	Square Foot
SH	Sheet
SHT	Sheet
SK	Sack
SKEIN	Skein
SKID	Skid
SL	Sleeve
SP	Special Order Item
SPL	Spool
SPSN	Special Session
SQ	Square
SQIN	Square Inch
SQMI	Square Mile
ST	Set
STDT	Student
SUM	Sum
SYSTM	System
TANK	Tank
TB	Tub
TBLS	Tablespoon
TEAS	Teaspoon
TEST	Test
TKLD	Truckload
TL	Truckload
TO	Tote
TON	Ton
TOTAL	Total Cost
TRANS	Transaction
TRAY	Tray
TRIP	Trip
TU	Tube
Tub	Tub
TUBE	Tube
UNDS	Unit Dose
UNIT	Unit
VIAL	Vial
Vst	Visit
WATT	WATT
WKRT	Weekly Retainer
WORD	Word
MNT	Minute
SQFT	Square foot
SQYD	Square yard
QR	Quire
RM	Ream
GAL	Gallon
QT	Quart
LB	Pound
YR	Year
CM	Centimeter
MTR	Meter
FT	Foot
DAY	Day
KG	Kilogram
YD	Yard
C	Hundred
D	Five hundred
DOZ	Dozen
GR	Gross
M	Thousand
WK	Week
CUFT	Cubic foot
CUYD	Cubic yard
MM	Millimeter
BD	Bundle

Tax

Code (To be entered in catalog import)	Tax	Label
0	0.00	Additional Charges
5	5.00	5 %
8.2	8.20	8.2 %
918	9.18	Prescott Valley - 9.18 %
AJ	9.10	Apache Junction - 9.1 %
AP	8.60	Apple - 8.6 %
AV	8.80	Avondale - 8.8 %
AZ	5.60	AZ State (Use) Tax - 5.6 %
BC	6.35	Black Canyon City - 6.35 %
BE	10.10	Benson - 10.1 %
BK	9.30	Buckeye - 9.3 %
BX	0.05	BLBOX Special Tax - Phoenix - 0.05 %
CA	10.00	Camp Verde - 10 %
CB	6.10	6.1 Cochise/Navajo/Chambers - 6.1 %
CC	6.90	Coconino County - 6.9 %
CE	6.90	Cochise County - 6.9 %
CF	9.30	Carefree - 9.3 %
CG	8.70	Casa Grande - 8.7 %
CH	7.80	Chandler - 7.8 %
CI	9.30	Circle City - 9.3 %
CL	9.70	Coolidge - 9.7 %
CN	5.02	Camp Navajo - 5.02 %
CO	5.40	Construction Tax - 5.4 %
CP	6.60	Claypool - 6.6 %
CT	6.73	Coconino County Island Tax - 6.73 %
CV	10.35	Chino Valley - 10.35 %
CW	9.35	Cottonwood - 9.35 %
DE	7.60	Dell - 7.6 %
DG	8.90	Douglas - 8.9 %
DU	8.60	Duncan - 8.6 %
EG	9.10	Eagar - 9.1 %
EL	9.70	Eloy - 9.7 %
EM	9.30	El Mirage - 9.3 %
FC	5.82	Flagstaff Contracting Tax - 5.82 %
FD	1.00	City of Phoenix Food Tax - 1 %
FG	8.95	Flagstaff - 8.95 %
FH	8.90	Fountain Hills - 8.9 %
FL	8.70	Florence - 8.7 %
FR	10.90	Fredonia - 10.9 %
FS	7.60	Fisher Scientific - 7.6 %
FT	12.10	Flagstaff Area Tire - 12.1 %
GB	9.30	Gila Bend - 9.3 %
GI	7.80	Gilbert - 7.8 %
GL	9.20	Glendale - 9.2 %
GO	8.60	Globe - 8.6 %
GU	10.30	Guadalupe - 10.3 %
GY	8.80	Goodyear- 8.8 %
HB	9.10	Holbrook - 9.1 %
HC	7.60	Huachuca City - 7.6 %
HP	8.60	Hewlett Packard - 8.6 %
HV	5.27	HVAC - 5.27 %
HY	9.60	Hayden - 9.6 %
JR	9.85	Jerome - 9.85 %
KG	8.35	Kingman - 8.35 %
KN	9.70	Kearny - 9.7 %
LA	5.27	AZ Labor Tax - 5.27 %
LH	7.85	Lake Havasu City - 7.85 %
Life Technologies	7.60	Life Technologies - 7.6 %
LP	9.10	Litchfield Park - 9.1 %
LU	10.71	San Luis - 10.71 %
MA	8.70	Mammath - 8.7 %
MC	6.30	Maricopa County - 6.3 %
MI	9.10	Miami - 9.1 %
MN	8.60	Marana - 8.6 %
MS	8.05	Mesa - 8.05 %
NC	6.10	Navajo County - 6.1 %
NO	8.60	Nogales - 8.6 %
NT	0.00	Non-Taxable - 0 %
OV	8.60	Oro Valley - 8.6 %
PC	6.70	Pinal County - 6.7 %
PE	8.10	Peoria - 8.1 %
PG	9.90	Page - 9.9 %
PK	9.60	Parker - 9.6 %
PM	8.60	Pima - 8.6 %
PO	8.10	Peoria - 8.1 %
PR	8.35	Prescott - 8.35 %
PS	8.72	Payson - 8.72 %
PT	8.60	Pinetop-Lakeside - 8.6 %
PU	6.35	Prescott Unincorporated - 6.35 %
PV	8.68	Prescott Valley - 8.68 %
PX	8.30	Phoenix - 8.3 %
QZ	10.10	Quartzsite - 10.1 %
SA	8.10	Sahuarita - 8.1 %
SC	7.95	Scottsdale - 7.95 %
SCT	5.40	Special Contracting Tax - 5.4 %
SE	9.73	Sedona - 9.73 %
SF	9.10	Safford - 9.1 %
SG	9.10	Springerville - 9.1 %
SH	7.21	Silverbell Heliport - 7.21 %
SI	7.60	Sitmatic - 7.6 %
SL	8.10	Showlow - 8.1 %
SM	6.35	Seligman - 6.35 %
SR	10.70	Superior - 10.7 %
ST	10.60	South Tuscon - 10.6 %
SU	8.50	Surprise - 8.5 %
SV	7.85	Sierra Vista - 7.85 %
SVT	5.60	Special Vendor Tax - 5.6 %
SW	6.30	Sun City West - 6.3 %
TA	8.10	Tayor - 8.1 %
TB	9.60	Tombstone - 9.6 %
TE	0.00	Tax Exempt - 0 %
TH	9.10	Thatcher - 9.1 %
TM	8.10	Tempe - 8.1 %
TO	8.80	Tolleson - 8.8 %
TU	8.10	Tucson - 8.1 %
VO	9.64	AzTEDP Voucher - 9.64 %
WE	9.21	Wellton - 9.21 %
WH	11.10	Winslow (hotels) - 11.1 %
WI	9.10	Winslow - 9.1 %
WK	8.50	Wickenburg - 8.5 %
WM	10.40	Williams - 10.4 %
WN	10.10	Winkelman - 10.1 %
WS	8.60	Wisca - 8.6 %
WX	9.10	Wilcox - 9.1 %
YC	6.35	Yavapai County - 6.35 %
YG	9.30	Youngtown - 9.3 %
YM	8.41	Yuma - 8.41 %

File details come from the government source that posted it. Updated Oct 3, 2025.