Material_Historical_Data_-_C.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
OVERHEAD AND UNDERGROUND MATERIAL State and local contract opportunity
Solicitation number
AR #19-023-CV
Issued by
Florida

About this file

The document is a historical materials inventory spreadsheet for Kissimmee Utility Authority (KUA) in Florida, detailing stock levels of various electrical infrastructure materials across nine distinct product lots from 2016-2018. The solicitation intends to establish a contract for purchasing overhead and underground utility supplies at fixed prices, with potential additions or deletions during the contract term. The material lots include Bolts/Screws/Washers, Bracket Materials, Conduit, Overhead Cutouts/Switches, Fuse Protection, Grounding/Guying, Overhead Pole Line Equipment, Overhead Insulators, Underground Materials, and Connector/Clamp Materials.

The inventory data tracks quarterly stock quantities for each item code, revealing fluctuating inventory levels across different product categories. The contract appears designed to provide KUA flexibility in procuring electrical infrastructure components, with comprehensive coverage of materials needed for utility maintenance and construction. The spreadsheet demonstrates extensive tracking of specific component types, quantities, and seasonal variations, suggesting a detailed approach to inventory management and procurement planning. While specific pricing is not disclosed, the document indicates a structured approach to material acquisition with potential for ongoing supply relationships based on historical usage patterns.

View the file

Other files for this state and local contract opportunity

Other files attached to OVERHEAD AND UNDERGROUND MATERIAL, newest first.
File Type Posted
Completed_Anixter_Inc_AR_No_19-023-CV.pdf PDF
Completed_Gresco_AR_No_19-023-CV_002.pdf PDF
Bid_Tabulation.xlsx XLSX spreadsheet
Bid_Tabulation_AR_19-023-CV.pdf PDF
Notice_of_Intent.pdf PDF
Attachment_A_Price_List_Final_1-14-19.xlsx XLSX spreadsheet
Addendum_2.pdf PDF
Addendum_1_Due_Date_Change.pdf PDF
AR_19-023-CV_FINAL.pdf PDF

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

Acerno_Cache_XXXXX

Sheet1 Lot # 1 - Bolt, Screws, and Washers

Stock201620172018
Code1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr
ANCHOREDHE38SS350250300100200300600350300200200150
BOLTHHDSS1224800000000000
BOLTHXHD12019200124800042000
BOLTHHS1213425610650049700000
BOLTSTU343431308117518936219313513516119312570
BOLTMACH3412030700001000
BOLTCARGA385033110550520630024
BOLTMACH581216710214326133212021610814164116156
BOLTMACH5814819013713732118915018889192112138
BOLTMACH58162110167363371583131035100
BOLTDAGA5818660047022314520
BOLTDAGA5820690511255154100
BOLTDAGA583026252122708027606
BOLTDAGA5836833563041225492160
BOLTDAGA34364100631001053000
BOLTOEYE58121031470163895991163441600
BOLTSSFT1225411400515562703845960818672904600175
BOLTSTUD58121803550404447231214230
BOLTSPOOL12X85344079101915261360
BOLTSPOOL14X0011114847084820
NUTHEXHEADSB1278670040261268680013009026001098600200
NUTHXHDGAL120000000750000
NUTOVALEYE58472157793035812432350
SCREWLAG140410851757532508050701353560
SCREWLAG14250020025001000100300025000
SCREWSET38150008000000000
WASHCOILSP58149150800450750124002500538200100
WASHERSS58LC07200100106019442670200
WASHERROUND5837400502355200195000
WASHSQUCUR348907487024149717480
WASHGALCUR3342021940035260054546250165450100135
WASHERSSFL121228124880011851260180022001750123024201400200
WASHERSSLC12801801206100010000
WASHFLASQU221702962302262940070697380170
WASHERBELLV12772300700400900400130090079710036000
Lot # 2 - Bracket Materials
Stock201620172018
Code1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr
BRACKARRECUT9132010232725201920137
BRACKINTARRE030000000000
BRACKCABLEST000000000000
BRACKCIRCUIT000007000000
BRACKETFIB1200000000000
BRACKFIBER14138182961884812371717231626912348
BRACKLFIBE15181214515721184667144916
BRACKTFIBE1641482643343842760534911
BRACKLIMTENS000000000000
BRACKTMAST24000900310000
BRACKETPOL2410340000516700
BRACKETSPOOL14011224319035311
BRACKETTRAN3002110120211
BRACKETTRAN2212301110000
BRACKETVERTI09062724180333300
BRACKETVERIP000200000000
Lot # 3 - Conduit
Stock201620172018
Code1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr
CLAMPMORBOLT61062004125930
CLAMPMORBOLT8000000000000
CONDUIPVC210573562554049498424572213
CONDUIPVC3100046020911000
CONDUIPVC410648234826102496201
CONDUIPVC610210042073107192150
CONDUGALV2104159144108124941
CONDUGALV4108430126370110
CONDUGALV6102000542541040
COUPFEMAPVC46000032176500
COUPLINGPVC6604044253517710340
COUPLINGTRAN213470000000000
COUPLINGTRAN4000000000000
COUPLINGTRAN6000000000000
COUPFESLIP61202090040000
COUPFESLIP8000000008000
COUPELCOPVC2000000000470
COUPELOCPVC40190000000000
COUPELCOPVC6000000000000
ELBPVCCON290543817340000
ELBOWGPVC390000104042826216
ELBOWGPVC4901231511112541200
ELBOWGPVC690000000012000
ELBOWGPVC8900000000003400
ELBOWGALV290102111340000600
ELBOWGALV490220011000421
ELBOWGALV490ST7900001100110
ELBOWGALV690500030101153010
PVCBELL2INCH00000000416360
PVCBELL4INCH000000000000
PVCBELL6INCH00000202300000
PVCBELL8INCH000000005454610
STRAPCON2I2H32182112837414858163060
STRAPCON4I2H2701122152272657001900057000
TAPEPULLING22,6003,1005,7006,20013,3005,7003,1982,102
Lot # 4 - Overhead Cutout and Switches
Stock201620172018
Code1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr
ARRESSUR10OH6898431051149810410912314214240
ARRESDIST10KV330210033130
ARRESURRISER26325534567370465775556
CAPARRESTORP6001200000006
CUTOUTCOVERG0003110000610
DOORCUTOT300401212331685102
FUSETUBE100A4452996586881265790687014
FUSETUBE200A003531512534203
FUSECUTOTOVD364390716888846663607015
SWITC900SODR0164172730283353761
SWITCH900AMP300940033030
Lot # 5 - Fuse Protection
Stock201620172018
Code1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr
FUSEXTENDER0000363214723
FUSEPNX25AMP444131313401217103
FUSETYPENX506152891213232024151819
FUSETYPENX6538126512911238912
FUSETYPENX800382064014055
FUSENX100AMP03111201033330
FUSEUNIT25KR003003204570
FUSEUNIT50KR318430005250
FUSEUNIT80KR000403537430
FUSEUNIT100K20010120111210
FUSEUNIT125A008000332510
FUSEUNIT150A000730332300
FUSEUNIT175A000700002000
FUSEUNIT200A003400881130
FUSELINKK3A00000005000250
FUSELINKK6AM25258010304050301025600
FUSELINKK8AM252550003500100400
FUSELINKK10A000000000000
FUSELINKK15A10000005000000
FUSELINKK20A200000000100100
FUSELINKK25A2500000000255025
FUSELINKK30A25000000000250
FUSELINKK40A2500005300002515
FUSELINKK65A1501500530040807010
FUSELINKK80A150000000100150
FUSELINK100A405040302080907520403030
FUSELINK140A40020040403525504510
FUSEDIST150A000000000000
FUSEDIST200A600000003000
FUSEUNITSME20000000020000
FUSEUNITSML20004060000210
Lot # 6 - Grounding and Guying
Stock201620172018
Code1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr
ANCHORSC109629362622784523286216291
ANCHOREDHD38000000000000
ANCHOREDHD38SS350250300100200300600350300200200150
ANCHOREXTEN71300000000000
ANCHORSCRE72090025300010
ANCHORSH123016099600100240
ANCHORSQGALV600000000000
ARMRODBRN33630002361421000
CLIPBONDIN3460072838887020000
COUPGROUDROD5503502503753398547388001408750685155
CONDUIGALV25000411112101
DEDENDGUY710000000000000
FITGUYPOLE2PE000411011101
FITTIGUYCAP2001412011201
GUARDGUYPLAS9636388716469308322033491
HOOKGUY00000192649417928227990531
PERFORMGUY388899941051731486995223551111
PLATEGUYHOOK000000000000
RODGROUND58851040344135791089583013101346850753323
RODTHRD5811664212546660601266114618
WIRECUSTHD10000000000000
WIREGUYGA387200020001000150035001000150020003000150020000
Lot # 7 - Overhead Pole Line
Stock201620172018
Code1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr
ARMRODBL1020000210002000
ARMRODBRN33630002661421000
ARMFODBLCK40000000210000
ARMRODPUR4772703496123452300
ARMWDCROSS962131017015000
ARMGACROSS60001000000000
BRACECRARM280171247021000
BANDISS34044200202051040
CUTOUTCOVERG0003110000610
CLEVISTHIMBL000000000000
DDIECOMCOVER66315449353295213523325275400187104
DEADEND40477184014218170348778143
DEADENDAL62049263056761330228719683
DEDENCU2AUTO000000000000
DEDEN04AUTO04154174317162400
DEDENDJIFFY601544110206151902
DEADENDACU10002200000000
DEADENCLEV40046103000000
DEDENSLSP4776016183981211020
LINKEXTENSIO130960033030
LINKTRUNIONS330930033050
PLATIE40154023196841476457702536533
SIDETIEPREA22426333456192131660310
SIDETIEPRE10607600000300
SIDETIEAL336291898182493245600156
SIDETIEPRE40004120000982056018
SIDETIEB1030000000000000
TOPTIEBL10301200166000030
SPOOLTIEAL021320152922191017950120
SPOOLTIE1020110600002100
SPOOLTIEA3361570176720818323731
SPOOLTIEAL406103385019815191310
SLEEVEALSPL270219637070975446801030
SLEEVEALSPL6006825025256565000
SLEEVEGALV386108360131811152360
WIREHOLDERMT04418341423003
WIREHOLDER4I026643600000
Lot # 8 - Overhead Insulators
Stock201620172018
Code1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr
INSUGUYSTR361318425163732371
INSUGUYSTR7812831182464268150
INSUGUYSTR96189115433317123820190
INSULOUT75KV048154842546606667624
INSUPOCLATOP661311149281761860
INS25KVTIETP84147119179316137129902692268239
INSPINTYP15KV400000000000
INS35KVDEDEN73696442997984612255649
INSU35KVTIET231459296261102612264543
INSU25KVPOST003300102220
INS35KVSLACK10618723521710234216
INSUSECSPOOL23213232844521428334144
DEADENDAL62044262639701125168719683
DEADEND404771540807549318778143
DEDENAL303367270413058000
CLAMPDEADEND32341921472671874056
Lot # 9 - Underground Materials
Stock201620172018
Code1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr
ARRESPAR15KV11142183611254760262918
ARRESTELBO10192654285544515847425835
ADAPTRALUGSE310354366159235216309482520273407252
BUSHINGINSER8588622901761511632303312759
BUSHINGFEEDT0140824341170
BUSHINGPARKS22753180285115330
COMPOUNDELE4253422223169815887517727
CONPEDTY8POS12320153011629541421533871120
CONNECTPEDT4030000000000
CONNPLUG600A000024912303900
CONNTRAN8500330274206181263256302460565270435297
CONVERJUNBOX000000000000
COVERSECBAR8BLK3476426191042
DUMMYCAPR200401241346523729326635923722214859
ELBOWLBR2002562176242252474145131619
ELBOWLB20010336664403288473645544750845464816277
ELBOWLB20040003601215729469680
ELBOWNL60010000063000000
ELBOWNL60040002431201230000
ELBNLB60045045390384242481654450
ELBNLB600750000012511600601312218
ELBOWREPLACE030000000000
JUNLODBREAK41034602781994610087685728
PLUGREDUCTIP2136123283585205889306
SOAPWIREPULL4614152412172612500
TERMKT5007506180917153033854287
TERMINATION24028305335886748423330494
Lot # 10 - Connector and Clamp Materials
Stock201620172018
Code1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr1st Qtr2nd Qtr3rd Qtr4th Qtr
CLAMPHOTLI20766086231115126791993917616768
CLAMPHOTL6CU0436240912041976
CLAMPCASEGRD200200271200225315492316852450200250
CLAMPANGL125002200003800
CLAMPANGL1063303360315100
CLAMPANGL842040010203100
CLAMPSLSPAN20314753188151216
CLAMPCONGRD253442241195534274051675
CLAMRUBBLKET10242212820819157220
CONHYLUG50024150151512930361215
CONNECTOCU042252002755352191245143202613522750
CONNECTOCU02450700600600500105013007001450900600300
CONNECTOCU40005025650255000250
CONNONESHOT4000000000000
CONTRALUG250234244543639402160273111
CONNECGELTAP25030825317930426521052853853011846
CONNEC4POSWT3039060120433
CONPEDTY8POS12320233311629541421533871120
CONNTRAN250014401208001604
CONTRANL47508884441919032240
DEDENCU2AUTO000000000000
DEDEND04AUTO04152774247162400
DEDENDJIFFY601530110166151902
KNOCON477477185322188015282726173812
LOCKJUNIORBRASS12401891270016401360194015721802194826601442360
LOCKSENIORBRASS01001112181926533300
LUG1HOLE4CU12001006001320000
LUG2HOLE4CU00041600014000
LUGGRND2HOLE1500270007400
LUGCOMRESSI6000010060010
LUGCOM477AAC15241245525540657483615
LUG477AAC4H066015624209120
LUGTER500MCM6216927301801830339
LUGCOM750795000003180312230
LUGCOMALCU40000000000000
SADDLEALSTRU743366133137124821269317416239
SLEEVECUCOM475571001000100100100000100
SQUEEZEONCO12752502251752252503254003352508866
SQUEEZEONCO21751751251501842162201852331673544
SQUEEZEONCO3N/AN/AN/AN/AN/AN/AN/AN/A1251003226
SQUEEZEONCO412522532515025020035010020725211971
SQUEEZEONCN5373850505050100075252412
SQUEEZEONCN7N/AN/AN/AN/AN/AN/AN/AN/A250583
SQUEEZEONCN6250175502525880100254629
SQUEEZEON7151807504450200062010
SQUEEZEON77540051400100560
WEDGECLMSM2610802225310325220600502411
WEDGEMEDIU22050150150100542321000501231
WEDGECLG2040064133675705035025017

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