COCESS_Pricing_Model_with_Market_Basket_-_Amendment.xls

XLS spreadsheet 523 KB Posted

Attached to
Contractor Operated Civil Engineer Supply Store Federal contract opportunity
Solicitation number
FA282315R4007
Issued by
Department of the Air Force Materiel Command Test Center

View the file

Other files for this federal contract opportunity

Other files attached to Contractor Operated Civil Engineer Supply Store, newest first.
File Type Posted
FA2823-15-R-4007_Amendment_6.pdf PDF
FA2823-15-R-4007_Amendment_5.pdf PDF
FA2823-15-R-4007_Amendment_4.pdf PDF
COCESS_Q A_23_November_2015.pdf PDF
FA2823-15-R-4007_P04.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

INSTRUCTIONS - MARKET BASKET

INSTRUCTIONS: This Market Basket is to be used to calculate Material CLIN unit prices for CLINS 0002, 1002, 2002, 3002, and 4002. Current prices are given for each supply on each tab. Click on EACH tab individually for the Base and Option Years. Input the DISCOUNT RATE per CATEGORY of supply. Each CATEGORY is highlighted a different color for ease of use. See color chart below. Once a DISCOUNT RATE is placed in the cell, the worksheet will automatically calculate the DISCOUNT PRICE. The worksheet will then calculate the DISCOUNT AMOUNT by multiplying the DISCOUNT PRICE by the QUANTITY. The DISCOUNT AMOUNTS will be totaled at the bottom of each tab for a TOTAL EVALUATED AMOUNT PER TAB. This information will automatically fill the below table. The TOTAL EVALUATED AMOUNT PER TAB will be added in the below table for the Base and each Option Year to get an OVERALL EVALUATED AMOUNT. The OVERALL EVALUATED AMOUNTS in Row 18 will be transferred to the "Instructions - TEP" tab in order to calculate the OVERALL TOTAL EVALUATED PRICE.
MARKET BASKET TABS
TRA-SER Pro:Open Market:
EL = ElectricalHDW = Hardware
HV = HVACBS = Building Supplies
PB = PlumbingLG = Lawn & Garden
SUMMARY TABLE - DO NOT ENTER INFORMATION HERE. IT WILL SELF-POPULATE FROM MARKET BASKET TABS.
CLIN 0002CLIN 1002CLIN 2002CLIN 3002CLIN 4002
BASE YEAROPTION 1 YEAROPTION 2 YEAROPTION 3 YEAROPTION 4 YEAR
MATERIALTOTAL EVALUATED AMOUNT PER TABTOTAL EVALUATED AMOUNT PER TABTOTAL EVALUATED AMOUNT PER TABTOTAL EVALUATED AMOUNT PER TABTOTAL EVALUATED AMOUNT PER TAB
TRA-SER Pro $0-$500$ 671,000.76$ 671,689.04$ 671,689.04$ 671,689.04$ 671,689.04$ 3,357,756.92
TRA-SER Pro >$500$ 454,026.32$ 454,026.32$ 454,026.32$ 454,026.32$ 454,026.32$ 2,270,131.60
Open Market$ 23,790.83$ 23,790.83$ 23,790.83$ 23,790.83$ 23,790.83$ 118,954.15
OVERALL EVALUATED AMOUNT$ 1,148,817.91$ 1,149,506.19$ 1,149,506.19$ 1,149,506.19$ 1,149,506.19$ 5,746,842.67

BASE - TRA-SER Pro $0-$500

INSTRUCTIONS: Input the DISCOUNT RATE per CATEGORY of supply from your original solicitation. For price realism, place your source price and source in columns P & R. In addition, provide a hardcopy substantitaion in a binder that corresponds with the tab and line item for easy reference.
For sources, provide a short description i.e. (invoices, bills of lading, manufacturer discount agreements, subcontracts, purchase orders, etc…)
CSLNOUNADJ 1ADJ 2ADJ 3ADJ 4MANUFACTUREMANUFACTURE PART#CategoryQTYU/IUNIT PRICEDISCOUNT RATEDISCOUNT PRICEDISCOUNT AMOUNTSource Provided PriceSource Provided Discount AmountSource
AF349QSTRAPBXGALVANIZED3/8"1HOLEEGS 687855-10551 ELBX-50EL1,311EA$ 1.0550.00%$0.5250$ 688.28$0.5250$688.28
AG271LCONNECTORSADDLEGRIP03/8"ALUM/STEELARLINGTON 018997-80138 ELSG38AEL622EA$ 2.350.00%$2.3500$ 1,461.70$0.0000$0.00
AE613CWIRETHHN6STRANDBLACKCOPPER WIRE 980100-63152 ELTHHN-6-BLK-19STR-CU-IREL600FT$ 2.130.00%$2.1300$ 1,278.00$0.0000$0.00
AG510XWIRETHHN#8STRANDREDCOPPERWIRE 980100-23103 EL5597027EL500RL$ 620.000.00%$620.0000$ 310,000.00$0.0000$0.00
AF084SWIRETHHN#10COPPERREDCOPPERWIRE 980100-22521 ELTHHN-10-SOL-RED-CU-1000SEL500RL$ 340.000.00%$340.0000$ 170,000.00$0.0000$0.00
AF084WWIRETHHN#10COPPERWHITECOPPERWIRE 980100-22578 ELTHHN-10-WHT-SOL-CU-500CNEL500RL$ 340.000.00%$340.0000$ 170,000.00$0.0000$0.00
AE662OCOUPLINGEMT1/2"DIE CAST ZSET SCREWRACO 050169-02622 EL2622EL446EA$ 3.110.00%$3.1100$ 1,387.06$0.0000$0.00
AE851DSTRAPEMTSTEEL1/2"UNISTRUTB-LINE 781011-60413 ELB2208-ZN-1/2EL341EA$ 6.200.00%$6.2000$ 2,114.20$0.0000$0.00
AB293GWIRE0#6COPPERGREENCOPPERWIRE 980100-63190 ELTHHN-6-GRN-19STR-CU-1REL300FT$ 2.130.00%$2.1300$ 639.00$0.0000$0.00
AF101ASTRAPCONDUITSTEEL1/2"MINERALLACRACO 785991-50468 EL2052EL290EA$ 1.580.00%$1.5800$ 458.20$0.0000$0.00
AE871QSTRAPEMTSTEEL3/4"1HOLEEGS 687855-21902 EL1902EL257EA$ 1.280.00%$1.2800$ 328.96$0.0000$0.00
AA021RCONNECTORCOMPRESSIOALLPURPOSEVARIESCOPPER/ALUBLACKBURN 783786-10302 ELWR189EL250EA$ 1.960.00%$1.9600$ 490.00$0.0000$0.00
AA018WCONNECTORCOMPRESSIOCABLES00BLACKBURN 783786-10001 ELWR159EL250EA$ 1.960.00%$1.9600$ 490.00$0.0000$0.00
AG024UCONNECTORCOMPRESSIOCONDUIT1/2"DIE CASTRACO 050169-02802 EL2802EL232EA$ 4.680.00%$4.6800$ 1,085.76$0.0000$0.00
AE662KCONNECTORCOMPRESSIO01/2"STEELRACO 050169-02802 EL2002EL223EA$ 4.680.00%$4.6800$ 1,043.64$0.0000$0.00
AA637FCONNECTORROMEX01/2"0STEEL CITY 785991-42751 ELNC301EL211EA$ 2.400.00%$2.4000$ 506.40$0.0000$0.00
AG144ICONDUITLIQUIDTIGH1/2"PLASTIC100'CARLON 034481-23305 EL15005-100EL200FT$ 4.160.00%$4.1600$ 832.00$0.0000$0.00
AA081PCOVERJCT.BOXSTEEL4"0RACO 050169-90752 EL752EL197EA$ 8.050.00%$8.0500$ 1,585.85$0.0000$0.00
AA071FTAPEDUCT180'ALUM0BLACK SWAN 054647-10055 HV10055HV65RO$ 13.880.00%$13.8800$ 902.20$0.0000$0.00
AD444FELBOWL/RADIUSCOPPER5/8"90 DEG.NIBCO 039923-31684 HV607-LT-5/8HV62EA$ 7.080.00%$7.0800$ 438.96$0.0000$0.00
AF289VPIPECOPPER3/8" OD20 FT0CERROCOPPER 662386-10024 HVACR/OXY/MED/3/8-PER-FTHV60FT$ 1.620.00%$1.6200$ 97.20$0.0000$0.00
AA298TPIPEPVC1-1/2"20'DWVPVC FTGS 668363-20030 PB150PIP-9/FTPB480FT$ 0.890.00%$0.8900$ 427.20$0.0000$0.00
AA032MELBOWPIPEPVC3/4"90 DEG.NIBCO 039923-14064 PB406-007PB344EA$ 0.760.00%$0.7600$ 261.44$0.0000$0.00
AF423JELBOWCRIMPCOPPER1/2"90RIDGID 691514-77317 PB77317PB272EA$ 3.620.00%$3.6200$ 984.64$0.0000$0.00
AF491SPIPEPVC SCH 803/4"20 FT0NIBCO 039923-09681 PB1680180PB200FT$ 1.450.00%$1.4500$ 290.00$0.0000$0.00
AA001RADAPTERPLUMBINGPVC3/4"0NIBCO 039923-13172 PB436-007PB193EA$ 0.710.00%$0.7100$ 137.03$0.0000$0.00
AF382MTAPE03/4"X260"TEFLONWHITERETROSEAL 021449-35945 PB35945PB167EA$ 3.290.00%$3.2900$ 549.43$0.0000$0.00
AF254APIPEPVC2"20'SCHED 80PIPE FTGS&NIPLES668369-60330PB200-S80-PIP-P/FTPB120FT$ 4.700.00%$4.7000$ 564.00$0.0000$0.00
AF861AELBOWPRO PRESSCOPPER3/4"90RIDGID 691514-77322 PB77322PB115EA$ 6.100.00%$6.1000$ 701.50$0.0000$0.00
AF526QCOUPLING01/2"COPPERFITTINGRIDGID 691514-78172 PB78172PB106EA$ 7.810.00%$7.8100$ 827.86$0.0000$0.00
AG670IADAPTERCXMBRONZE1/2"0PROPRESS 691514-79215 PB79215PB101EA$ 4.260.00%$4.2600$ 430.26$0.0000$0.00
TOTAL EVALUATED PRICE$ 1,403.89$ 1,403.37$ 671,000.76$ 0.53$ 688.28

BASE - TRA-SER Pro >$500

INSTRUCTIONS: Input the DISCOUNT RATE per CATEGORY of supply from your original solicitation. For price realism, place your source price and source in columns P & R. In addition, provide hardcopy substantitaion in a binder that corresponds with the tab and line item for easy reference.
For sources, provide a short description i.e. (invoices, bills of lading, manufacturer discount agreements, subcontracts, purchase orders, etc…)
CSLNOUNADJ1ADJ2ADJ3ADJ4MANUFACTUREMANUFACTURE PART#CATEGORYQTYUIUNIT PRICEDISCOUNT RATEDISCOUNT PRICEDISCOUNT AMOUNTSource Provided PriceSource Provided Discount AmountSource
AC854VWIREACSR#2SEE BELOW0ALCAN CABLE 980120-59110 EL2 SPARROWEL15001FT$ 9.860.00%$9.86$ 147,909.86$0.0000$0.00
AE474SBULBFLUORESCENT-80120VGE 043168-26668 ELF32T8SP41EL6028EA$ 27.820.00%$27.82$ 167,698.96$0.0000$0.00
AE623ZWIRETHHN#61CONDUCTORBLACKCOPPERWIRE 980100-12204 ELTHHN-6-BLK-7STR-CU-1000REL2910FT$ 2.130.00%$2.13$ 6,198.30$0.0000$0.00
AF238SWIRETHHN350MCMCOPPERBLACKCopper Wire 980100-23430 ELTHHN-350-BLK-37STR-CU-500EL2700FT$ 26.480.00%$26.48$ 71,496.00$0.0000$0.00
AA888OWIRETHHN#2COPPERBLACKCUWIRE 980100-23301 ELTHHN-2-BLK-19STR-CU-1000REL2000FT$ 5.160.00%$5.16$ 10,320.00$0.0000$0.00
AG265WWIRETHHN#30BLACKCITY ELEC 980100-23250 ELTHHN-3-STR-BLKEL1950FT$ 4.120.00%$4.12$ 8,034.00$0.0000$0.00
AA054CSTRAPCONDUITSTEEL1/2"0Raco 050169-02082 EL2082EL1551EA$ 1.450.00%$1.45$ 2,248.95$0.0000$0.00
AG120CTHERMOSTATDIGITAL24 VAC2 C-2 HHONEYWELLHONEYWELL 085267-26199 HVTH5220D1029HV40EA$ 151.130.00%$151.13$ 6,045.20$0.0000$0.00
AE288GCONTACTORDEF.PURPOS24V2POLE0HONEYWELL 085267-78062 HVDP2030A5004HV36EA$ 34.770.00%$34.77$ 1,251.72$0.0000$0.00
AC741JFREON134A30LBDRUMREFRIGERANFORANE BS 668405-11690SUVA-134A-30 2BHV21EA$ 497.480.00%$497.48$ 10,447.08$0.0000$0.00
AA020BCOUPLINGPIPE3/4"PVC0NIBCO 049081-29624 PB1023108PB201EA$ 5.850.00%$5.85$ 1,175.85$0.0000$0.00
AA058MPIPEPVC3/4"20'04HARLOTTE 611942-03926 PB4007B-3/4X20PB143LG$ 10.800.00%$10.80$ 1,544.40$0.0000$0.00
AF539UPIPEPVC2-1/2"20'SCH80UKNOWN 668369-60350 PB250-S80-PIP-P/FTPB140LG$ 140.400.00%$140.40$ 19,656.00$0.0000$0.00
TOTAL EVALUATED PRICE$ 917.45$ - 0$ 917.45$ 454,026.32$0.00$0.00

BASE - Open Market

INSTRUCTIONS: Input the DISCOUNT RATE per CATEGORY of supply from your original solicitation. For price realism, place your source price and source in columns Q & S. In addition, provide hardcopy substantitaion in a binder that corresponds with the tab and line item for easy reference.
For sources, provide a short description i.e. (invoices, bills of lading, manufacturer discount agreements, subcontracts, purchase orders, etc…)
CSLNOUNADJ1ADJ2ADJ3ADJ4MANUFACTUREMANUFACTURE PART#SOURCECATEGORYQTYUIUNIT PRICEDISCOUNT RATEDISCOUNT PRICEDISCOUNT AMOUNTSource Provided PriceSource Provided Discount AmountSource
AF940WASPHALTCOLD PATCH60-LBPERMA-PATC0PERMA-PATCH BSPP-60-CGRAINGERBS400BG$ 34.800.00%$34.80$13,920.00$0.0000$0.00
AF899SREFLECTORROUND3"ACRYLICWHITEGRAINGER BS9DKG9GRAINGERBS58EA$ 3.790.00%$3.79$219.82$0.0000$0.00
AC717ARIBBONFLAGGINGORANGE1-3/16"FLOURESCENJOHNSON LEVEL AND TOOL HMD BS1EC17GRAINGERBS17RO$ 3.050.00%$3.05$51.85$0.0000$0.00
AG609ASIGNFIREPOLYESTER14X3-1/2"EXTINGUISHGRAINGER BS1K961GRAINGERBS9EA$ 9.520.00%$9.52$85.68$0.0000$0.00
AG651TFLAGMARKING2.5"HRED100PER.PKGPRESCO PRODUCTS CO BS3LTY1GRAINGERBS8BD$ 12.080.00%$12.08$96.64$0.0000$0.00
AG653ILINKCHAINSINGLESTEEL100TSUBAKI BS6X533GRAINGERBS6EA$ 20.670.00%$20.67$124.02$0.0000$0.00
AG653HLINKCHAINSINGLESTEEL100TSUBAKI BS6X532GRAINGERBS6EA$ 8.440.00%$8.44$50.64$0.0000$0.00
AG703GBARRECTANGLESTEEL1/8"X2"6'GRAINGER BS2HGY9GRAINGERBS5EA$ 23.440.00%$23.44$117.20$0.0000$0.00
AG585LHOLDERBITSTEEL1/4"X6"QUIKREALESIRWIN BS6CYU9GRAINGERBS5EA$ 14.850.00%$14.85$74.25$0.0000$0.00
AG677VPULLEYBLOCK3-1/2"0STEELGRAINGR APPROVED VENDOR BS4JX82GRAINGERBS4EA$ 30.050.00%$30.05$120.20$0.0000$0.00
AG408PCOVERCEILINGMETAL24"X18"FLUSHMOUNTGRAINGER BS2VE86GRAINGERBS2EA$ 82.050.00%$82.05$164.10$0.0000$0.00
AG534ZCONNECTORFLEX90DEGREE1-1/4"ALUMINUMGRAINER APPROVED VENDOR BS5UGX1GRAINGERBS2EA$ 27.800.00%$27.80$55.60$0.0000$0.00
AG147HCLIPCABLESTAINLESS1/4"WIREDAYTON BS2VKH3GRAINGERBS2PK$ 9.380.00%$9.38$18.76$0.0000$0.00
AG614PSTONEPOLISHEDSMALLPEBBECLASS 1DECORATIVEMS INTERNATIONAL BSLPEBMMIX3POL40HOME DEPOTBS100BG$ 29.970.00%$29.97$2,997.00$0.0000$0.00
AG657ALIGHTTAPELED20WATTCHANGCOLORARMACOST BSRF5050030-12CCDHOME DEPOTBS32EA$ 54.970.00%$54.97$1,759.04$0.0000$0.00
AG604TCONCRETEQUIKRETE4000 PSI80 LB0QUIKRETE BS110180LOWESBS310BG$ 4.170.00%$4.17$1,292.70$0.0000$0.00
AG650BBANDFENCEGALV-STEEL2-3/8"CHAIN LINKOLDCASTLE BS02225GRALOWESBS80EA$ 0.960.00%$0.96$76.80$0.0000$0.00
AF530BCEMENTMASONRY70LBTYPE N0QUICKCRETE10354LOWESBS71EA$ 8.090.00%$8.09$574.39$0.0000$0.00
AG119HROLLERROLLUPDOOR0STEEL0BATTALION HDW1RBH2GRAINGERHDW11PK$ 24.990.00%$24.99$274.89$0.0000$0.00
AG444FSCREWHEXHEAD#8 X 1/2 ZSTEEL1/2"GRAINGER HDW2XA37GRAINGERHDW4BX$ 5.850.00%$5.85$23.40$0.0000$0.00
AG650KBOLTCARRIAGEGALVANIZED3/8"X2"2"OLDCASTLE HDW10016GRLOWESHDW124EA$ 0.570.00%$0.57$70.68$0.0000$0.00
AG650LBOLTCARRIAGEGALVANIZED5/16"1-1/4"OLDCASTLE HDW10002GRLOWESHDW100EA$ 0.470.00%$0.47$47.00$0.0000$0.00
AG661YHOSEAIRPOLY BRAIDSNUBBER1/2"X24"LEGACYHFZ1202YW3S-GRAGRAINGERLG15EA$ 24.270.00%$24.27$364.05$0.0000$0.00
AG675WMULCHNO FLOAT2CFRED CYPRES0PREMIUM L&G85281LOWESLG364BG$ 3.330.00%$3.33$1,212.12$0.0000$0.00
TOTAL EVALUATED PRICE$437.56$437.56$23,790.83$0.00$0.00

Option 1 - TRA-SER Pro $0-$500

INSTRUCTIONS: Input the DISCOUNT RATE per CATEGORY of supply from your original solicitation. For price realism, place your source price and source in columns P & R. In addition, provide a hardcopy substantitaion in a binder that corresponds with the tab and line item for easy reference.
For sources, provide a short description i.e. (invoices, bills of lading, manufacturer discount agreements, subcontracts, purchase orders, etc…)
CSLNOUNADJ 1ADJ 2ADJ 3ADJ 4MANUFACTUREMANUFACTURE PART#CategoryQTYU/IUNIT PRICEDISCOUNT RATEDISCOUNT PRICEDISCOUNT AMOUNTSource Provided PriceSource Provided Discount AmountSource
AF349QSTRAPBXGALVANIZED3/8"1HOLEEGS 687855-10551 ELBX-50EL1,311EA$ 1.050.00%$1.0500$ 1,376.55$0.0000$0.00
AG271LCONNECTORSADDLEGRIP03/8"ALUM/STEELARLINGTON 018997-80138 ELSG38AEL622EA$ 2.350.00%$2.3500$ 1,461.70$0.0000$0.00
AE613CWIRETHHN6STRANDBLACKCOPPER WIRE 980100-63152 ELTHHN-6-BLK-19STR-CU-IREL600FT$ 2.130.00%$2.1300$ 1,278.00$0.0000$0.00
AG510XWIRETHHN#8STRANDREDCOPPERWIRE 980100-23103 EL5597027EL500RL$ 620.000.00%$620.0000$ 310,000.00$0.0000$0.00
AF084SWIRETHHN#10COPPERREDCOPPERWIRE 980100-22521 ELTHHN-10-SOL-RED-CU-1000SEL500RL$ 340.000.00%$340.0000$ 170,000.00$0.0000$0.00
AF084WWIRETHHN#10COPPERWHITECOPPERWIRE 980100-22578 ELTHHN-10-WHT-SOL-CU-500CNEL500RL$ 340.000.00%$340.0000$ 170,000.00$0.0000$0.00
AE662OCOUPLINGEMT1/2"DIE CAST ZSET SCREWRACO 050169-02622 EL2622EL446EA$ 3.110.00%$3.1100$ 1,387.06$0.0000$0.00
AE851DSTRAPEMTSTEEL1/2"UNISTRUTB-LINE 781011-60413 ELB2208-ZN-1/2EL341EA$ 6.200.00%$6.2000$ 2,114.20$0.0000$0.00
AB293GWIRE0#6COPPERGREENCOPPERWIRE 980100-63190 ELTHHN-6-GRN-19STR-CU-1REL300FT$ 2.130.00%$2.1300$ 639.00$0.0000$0.00
AF101ASTRAPCONDUITSTEEL1/2"MINERALLACRACO 785991-50468 EL2052EL290EA$ 1.580.00%$1.5800$ 458.20$0.0000$0.00
AE871QSTRAPEMTSTEEL3/4"1HOLEEGS 687855-21902 EL1902EL257EA$ 1.280.00%$1.2800$ 328.96$0.0000$0.00
AA021RCONNECTORCOMPRESSIOALLPURPOSEVARIESCOPPER/ALUBLACKBURN 783786-10302 ELWR189EL250EA$ 1.960.00%$1.9600$ 490.00$0.0000$0.00
AA018WCONNECTORCOMPRESSIOCABLES00BLACKBURN 783786-10001 ELWR159EL250EA$ 1.960.00%$1.9600$ 490.00$0.0000$0.00
AG024UCONNECTORCOMPRESSIOCONDUIT1/2"DIE CASTRACO 050169-02802 EL2802EL232EA$ 4.680.00%$4.6800$ 1,085.76$0.0000$0.00
AE662KCONNECTORCOMPRESSIO01/2"STEELRACO 050169-02802 EL2002EL223EA$ 4.680.00%$4.6800$ 1,043.64$0.0000$0.00
AA637FCONNECTORROMEX01/2"0STEEL CITY 785991-42751 ELNC301EL211EA$ 2.400.00%$2.4000$ 506.40$0.0000$0.00
AG144ICONDUITLIQUIDTIGH1/2"PLASTIC100'CARLON 034481-23305 EL15005-100EL200FT$ 4.160.00%$4.1600$ 832.00$0.0000$0.00
AA081PCOVERJCT.BOXSTEEL4"0RACO 050169-90752 EL752EL197EA$ 8.050.00%$8.0500$ 1,585.85$0.0000$0.00
AA071FTAPEDUCT180'ALUM0BLACK SWAN 054647-10055 HV10055HV65RO$ 13.880.00%$13.8800$ 902.20$0.0000$0.00
AD444FELBOWL/RADIUSCOPPER5/8"90 DEG.NIBCO 039923-31684 HV607-LT-5/8HV62EA$ 7.080.00%$7.0800$ 438.96$0.0000$0.00
AF289VPIPECOPPER3/8" OD20 FT0CERROCOPPER 662386-10024 HVACR/OXY/MED/3/8-PER-FTHV60FT$ 1.620.00%$1.6200$ 97.20$0.0000$0.00
AA298TPIPEPVC1-1/2"20'DWVPVC FTGS 668363-20030 PB150PIP-9/FTPB480FT$ 0.890.00%$0.8900$ 427.20$0.0000$0.00
AA032MELBOWPIPEPVC3/4"90 DEG.NIBCO 039923-14064 PB406-007PB344EA$ 0.760.00%$0.7600$ 261.44$0.0000$0.00
AF423JELBOWCRIMPCOPPER1/2"90RIDGID 691514-77317 PB77317PB272EA$ 3.620.00%$3.6200$ 984.64$0.0000$0.00
AF491SPIPEPVC SCH 803/4"20 FT0NIBCO 039923-09681 PB1680180PB200FT$ 1.450.00%$1.4500$ 290.00$0.0000$0.00
AA001RADAPTERPLUMBINGPVC3/4"0NIBCO 039923-13172 PB436-007PB193EA$ 0.710.00%$0.7100$ 137.03$0.0000$0.00
AF382MTAPE03/4"X260"TEFLONWHITERETROSEAL 021449-35945 PB35945PB167EA$ 3.290.00%$3.2900$ 549.43$0.0000$0.00
AF254APIPEPVC2"20'SCHED 80PIPE FTGS&NIPLES668369-60330PB200-S80-PIP-P/FTPB120FT$ 4.700.00%$4.7000$ 564.00$0.0000$0.00
AF861AELBOWPRO PRESSCOPPER3/4"90RIDGID 691514-77322 PB77322PB115EA$ 6.100.00%$6.1000$ 701.50$0.0000$0.00
AF526QCOUPLING01/2"COPPERFITTINGRIDGID 691514-78172 PB78172PB106EA$ 7.810.00%$7.8100$ 827.86$0.0000$0.00
AG670IADAPTERCXMBRONZE1/2"0PROPRESS 691514-79215 PB79215PB101EA$ 4.260.00%$4.2600$ 430.26$0.0000$0.00
TOTAL EVALUATED PRICE$ 1,403.89$ 1,403.89$ 671,689.04$ - 0$ - 0

Option 1 - TRA-SER Pro >$500

INSTRUCTIONS: Input the DISCOUNT RATE per CATEGORY of supply from your original solicitation. For price realism, place your source price and source in columns P & R. In addition, provide hardcopy substantitaion in a binder that corresponds with the tab and line item for easy reference.
For sources, provide a short description i.e. (invoices, bills of lading, manufacturer discount agreements, subcontracts, purchase orders, etc…)
CSLNOUNADJ1ADJ2ADJ3ADJ4MANUFACTUREMANUFACTURE PART#CATEGORYQTYUIUNIT PRICEDISCOUNT RATEDISCOUNT PRICEDISCOUNT AMOUNTSource Provided PriceSource Provided Discount AmountSource
AC854VWIREACSR#2SEE BELOW0ALCAN CABLE 980120-59110 EL2 SPARROWEL15001FT$ 9.860.00%$9.86$ 147,909.86$0.0000$0.00
AE474SBULBFLUORESCENT-80120VGE 043168-26668 ELF32T8SP41EL6028EA$ 27.820.00%$27.82$ 167,698.96$0.0000$0.00
AE623ZWIRETHHN#61CONDUCTORBLACKCOPPERWIRE 980100-12204 ELTHHN-6-BLK-7STR-CU-1000REL2910FT$ 2.130.00%$2.13$ 6,198.30$0.0000$0.00
AF238SWIRETHHN350MCMCOPPERBLACKCopper Wire 980100-23430 ELTHHN-350-BLK-37STR-CU-500EL2700FT$ 26.480.00%$26.48$ 71,496.00$0.0000$0.00
AA888OWIRETHHN#2COPPERBLACKCUWIRE 980100-23301 ELTHHN-2-BLK-19STR-CU-1000REL2000FT$ 5.160.00%$5.16$ 10,320.00$0.0000$0.00
AG265WWIRETHHN#30BLACKCITY ELEC 980100-23250 ELTHHN-3-STR-BLKEL1950FT$ 4.120.00%$4.12$ 8,034.00$0.0000$0.00
AA054CSTRAPCONDUITSTEEL1/2"0Raco 050169-02082 EL2082EL1551EA$ 1.450.00%$1.45$ 2,248.95$0.0000$0.00
AG120CTHERMOSTATDIGITAL24 VAC2 C-2 HHONEYWELLHONEYWELL 085267-26199 HVTH5220D1029HV40EA$ 151.130.00%$151.13$ 6,045.20$0.0000$0.00
AE288GCONTACTORDEF.PURPOS24V2POLE0HONEYWELL 085267-78062 HVDP2030A5004HV36EA$ 34.770.00%$34.77$ 1,251.72$0.0000$0.00
AC741JFREON134A30LBDRUMREFRIGERANFORANE BS 668405-11690SUVA-134A-30 2BHV21EA$ 497.480.00%$497.48$ 10,447.08$0.0000$0.00
AA020BCOUPLINGPIPE3/4"PVC0NIBCO 049081-29624 PB1023108PB201EA$ 5.850.00%$5.85$ 1,175.85$0.0000$0.00
AA058MPIPEPVC3/4"20'04HARLOTTE 611942-03926 PB4007B-3/4X20PB143LG$ 10.800.00%$10.80$ 1,544.40$0.0000$0.00
AF539UPIPEPVC2-1/2"20'SCH80UKNOWN 668369-60350 PB250-S80-PIP-P/FTPB140LG$ 140.400.00%$140.40$ 19,656.00$0.0000$0.00
TOTAL EVALUATED PRICE$ 917.45$ - 0$ 917.45$ 454,026.32$0.00$0.00

Option 1 - Open Market

INSTRUCTIONS: Input the DISCOUNT RATE per CATEGORY of supply from your original solicitation. For price realism, place your source price and source in columns Q & S. In addition, provide hardcopy substantitaion in a binder that corresponds with the tab and line item for easy reference.
For sources, provide a short description i.e. (invoices, bills of lading, manufacturer discount agreements, subcontracts, purchase orders, etc…)
CSLNOUNADJ1ADJ2ADJ3ADJ4MANUFACTUREMANUFACTURE PART#SOURCECATEGORYQTYUIUNIT PRICEDISCOUNT RATEDISCOUNT PRICEDISCOUNT AMOUNTSource Provided PriceSource Provided Discount AmountSource
AF940WASPHALTCOLD PATCH60-LBPERMA-PATC0PERMA-PATCH BSPP-60-CGRAINGERBS400BG$ 34.800.00%$34.80$13,920.00$0.0000$0.00
AF899SREFLECTORROUND3"ACRYLICWHITEGRAINGER BS9DKG9GRAINGERBS58EA$ 3.790.00%$3.79$219.82$0.0000$0.00
AC717ARIBBONFLAGGINGORANGE1-3/16"FLOURESCENJOHNSON LEVEL AND TOOL HMD BS1EC17GRAINGERBS17RO$ 3.050.00%$3.05$51.85$0.0000$0.00
AG609ASIGNFIREPOLYESTER14X3-1/2"EXTINGUISHGRAINGER BS1K961GRAINGERBS9EA$ 9.520.00%$9.52$85.68$0.0000$0.00
AG651TFLAGMARKING2.5"HRED100PER.PKGPRESCO PRODUCTS CO BS3LTY1GRAINGERBS8BD$ 12.080.00%$12.08$96.64$0.0000$0.00
AG653ILINKCHAINSINGLESTEEL100TSUBAKI BS6X533GRAINGERBS6EA$ 20.670.00%$20.67$124.02$0.0000$0.00
AG653HLINKCHAINSINGLESTEEL100TSUBAKI BS6X532GRAINGERBS6EA$ 8.440.00%$8.44$50.64$0.0000$0.00
AG703GBARRECTANGLESTEEL1/8"X2"6'GRAINGER BS2HGY9GRAINGERBS5EA$ 23.440.00%$23.44$117.20$0.0000$0.00
AG585LHOLDERBITSTEEL1/4"X6"QUIKREALESIRWIN BS6CYU9GRAINGERBS5EA$ 14.850.00%$14.85$74.25$0.0000$0.00
AG677VPULLEYBLOCK3-1/2"0STEELGRAINGR APPROVED VENDOR BS4JX82GRAINGERBS4EA$ 30.050.00%$30.05$120.20$0.0000$0.00
AG408PCOVERCEILINGMETAL24"X18"FLUSHMOUNTGRAINGER BS2VE86GRAINGERBS2EA$ 82.050.00%$82.05$164.10$0.0000$0.00
AG534ZCONNECTORFLEX90DEGREE1-1/4"ALUMINUMGRAINER APPROVED VENDOR BS5UGX1GRAINGERBS2EA$ 27.800.00%$27.80$55.60$0.0000$0.00
AG147HCLIPCABLESTAINLESS1/4"WIREDAYTON BS2VKH3GRAINGERBS2PK$ 9.380.00%$9.38$18.76$0.0000$0.00
AG614PSTONEPOLISHEDSMALLPEBBECLASS 1DECORATIVEMS INTERNATIONAL BSLPEBMMIX3POL40HOME DEPOTBS100BG$ 29.970.00%$29.97$2,997.00$0.0000$0.00
AG657ALIGHTTAPELED20WATTCHANGCOLORARMACOST BSRF5050030-12CCDHOME DEPOTBS32EA$ 54.970.00%$54.97$1,759.04$0.0000$0.00
AG604TCONCRETEQUIKRETE4000 PSI80 LB0QUIKRETE BS110180LOWESBS310BG$ 4.170.00%$4.17$1,292.70$0.0000$0.00
AG650BBANDFENCEGALV-STEEL2-3/8"CHAIN LINKOLDCASTLE BS02225GRALOWESBS80EA$ 0.960.00%$0.96$76.80$0.0000$0.00
AF530BCEMENTMASONRY70LBTYPE N0QUICKCRETE10354LOWESBS71EA$ 8.090.00%$8.09$574.39$0.0000$0.00
AG119HROLLERROLLUPDOOR0STEEL0BATTALION HDW1RBH2GRAINGERHDW11PK$ 24.990.00%$24.99$274.89$0.0000$0.00
AG444FSCREWHEXHEAD#8 X 1/2 ZSTEEL1/2"GRAINGER HDW2XA37GRAINGERHDW4BX$ 5.850.00%$5.85$23.40$0.0000$0.00
AG650KBOLTCARRIAGEGALVANIZED3/8"X2"2"OLDCASTLE HDW10016GRLOWESHDW124EA$ 0.570.00%$0.57$70.68$0.0000$0.00
AG650LBOLTCARRIAGEGALVANIZED5/16"1-1/4"OLDCASTLE HDW10002GRLOWESHDW100EA$ 0.470.00%$0.47$47.00$0.0000$0.00
AG661YHOSEAIRPOLY BRAIDSNUBBER1/2"X24"LEGACYHFZ1202YW3S-GRAGRAINGERLG15EA$ 24.270.00%$24.27$364.05$0.0000$0.00
AG675WMULCHNO FLOAT2CFRED CYPRES0PREMIUM L&G85281LOWESLG364BG$ 3.330.00%$3.33$1,212.12$0.0000$0.00
TOTAL EVALUATED PRICE$437.56$437.56$23,790.83$0.00$0.00

Option 2 - TRA-SER Pro $0-$500

INSTRUCTIONS: Input the DISCOUNT RATE per CATEGORY of supply from your original solicitation. For price realism, place your source price and source in columns P & R. In addition, provide a hardcopy substantitaion in a binder that corresponds with the tab and line item for easy reference.
For sources, provide a short description i.e. (invoices, bills of lading, manufacturer discount agreements, subcontracts, purchase orders, etc…)
CSLNOUNADJ 1ADJ 2ADJ 3ADJ 4MANUFACTUREMANUFACTURE PART#CategoryQTYU/IUNIT PRICEDISCOUNT RATEDISCOUNT PRICEDISCOUNT AMOUNTSource Provided PriceSource Provided Discount AmountSource
AF349QSTRAPBXGALVANIZED3/8"1HOLEEGS 687855-10551 ELBX-50EL1,311EA$ 1.050.00%$1.0500$ 1,376.55$0.0000$0.00
AG271LCONNECTORSADDLEGRIP03/8"ALUM/STEELARLINGTON 018997-80138 ELSG38AEL622EA$ 2.350.00%$2.3500$ 1,461.70$0.0000$0.00
AE613CWIRETHHN6STRANDBLACKCOPPER WIRE 980100-63152 ELTHHN-6-BLK-19STR-CU-IREL600FT$ 2.130.00%$2.1300$ 1,278.00$0.0000$0.00
AG510XWIRETHHN#8STRANDREDCOPPERWIRE 980100-23103 EL5597027EL500RL$ 620.000.00%$620.0000$ 310,000.00$0.0000$0.00
AF084SWIRETHHN#10COPPERREDCOPPERWIRE 980100-22521 ELTHHN-10-SOL-RED-CU-1000SEL500RL$ 340.000.00%$340.0000$ 170,000.00$0.0000$0.00
AF084WWIRETHHN#10COPPERWHITECOPPERWIRE 980100-22578 ELTHHN-10-WHT-SOL-CU-500CNEL500RL$ 340.000.00%$340.0000$ 170,000.00$0.0000$0.00
AE662OCOUPLINGEMT1/2"DIE CAST ZSET SCREWRACO 050169-02622 EL2622EL446EA$ 3.110.00%$3.1100$ 1,387.06$0.0000$0.00
AE851DSTRAPEMTSTEEL1/2"UNISTRUTB-LINE 781011-60413 ELB2208-ZN-1/2EL341EA$ 6.200.00%$6.2000$ 2,114.20$0.0000$0.00
AB293GWIRE0#6COPPERGREENCOPPERWIRE 980100-63190 ELTHHN-6-GRN-19STR-CU-1REL300FT$ 2.130.00%$2.1300$ 639.00$0.0000$0.00
AF101ASTRAPCONDUITSTEEL1/2"MINERALLACRACO 785991-50468 EL2052EL290EA$ 1.580.00%$1.5800$ 458.20$0.0000$0.00
AE871QSTRAPEMTSTEEL3/4"1HOLEEGS 687855-21902 EL1902EL257EA$ 1.280.00%$1.2800$ 328.96$0.0000$0.00
AA021RCONNECTORCOMPRESSIOALLPURPOSEVARIESCOPPER/ALUBLACKBURN 783786-10302 ELWR189EL250EA$ 1.960.00%$1.9600$ 490.00$0.0000$0.00
AA018WCONNECTORCOMPRESSIOCABLES00BLACKBURN 783786-10001 ELWR159EL250EA$ 1.960.00%$1.9600$ 490.00$0.0000$0.00
AG024UCONNECTORCOMPRESSIOCONDUIT1/2"DIE CASTRACO 050169-02802 EL2802EL232EA$ 4.680.00%$4.6800$ 1,085.76$0.0000$0.00
AE662KCONNECTORCOMPRESSIO01/2"STEELRACO 050169-02802 EL2002EL223EA$ 4.680.00%$4.6800$ 1,043.64$0.0000$0.00
AA637FCONNECTORROMEX01/2"0STEEL CITY 785991-42751 ELNC301EL211EA$ 2.400.00%$2.4000$ 506.40$0.0000$0.00
AG144ICONDUITLIQUIDTIGH1/2"PLASTIC100'CARLON 034481-23305 EL15005-100EL200FT$ 4.160.00%$4.1600$ 832.00$0.0000$0.00
AA081PCOVERJCT.BOXSTEEL4"0RACO 050169-90752 EL752EL197EA$ 8.050.00%$8.0500$ 1,585.85$0.0000$0.00
AA071FTAPEDUCT180'ALUM0BLACK SWAN 054647-10055 HV10055HV65RO$ 13.880.00%$13.8800$ 902.20$0.0000$0.00
AD444FELBOWL/RADIUSCOPPER5/8"90 DEG.NIBCO 039923-31684 HV607-LT-5/8HV62EA$ 7.080.00%$7.0800$ 438.96$0.0000$0.00
AF289VPIPECOPPER3/8" OD20 FT0CERROCOPPER 662386-10024 HVACR/OXY/MED/3/8-PER-FTHV60FT$ 1.620.00%$1.6200$ 97.20$0.0000$0.00
AA298TPIPEPVC1-1/2"20'DWVPVC FTGS 668363-20030 PB150PIP-9/FTPB480FT$ 0.890.00%$0.8900$ 427.20$0.0000$0.00
AA032MELBOWPIPEPVC3/4"90 DEG.NIBCO 039923-14064 PB406-007PB344EA$ 0.760.00%$0.7600$ 261.44$0.0000$0.00
AF423JELBOWCRIMPCOPPER1/2"90RIDGID 691514-77317 PB77317PB272EA$ 3.620.00%$3.6200$ 984.64$0.0000$0.00
AF491SPIPEPVC SCH 803/4"20 FT0NIBCO 039923-09681 PB1680180PB200FT$ 1.450.00%$1.4500$ 290.00$0.0000$0.00
AA001RADAPTERPLUMBINGPVC3/4"0NIBCO 039923-13172 PB436-007PB193EA$ 0.710.00%$0.7100$ 137.03$0.0000$0.00
AF382MTAPE03/4"X260"TEFLONWHITERETROSEAL 021449-35945 PB35945PB167EA$ 3.290.00%$3.2900$ 549.43$0.0000$0.00
AF254APIPEPVC2"20'SCHED 80PIPE FTGS&NIPLES668369-60330PB200-S80-PIP-P/FTPB120FT$ 4.700.00%$4.7000$ 564.00$0.0000$0.00
AF861AELBOWPRO PRESSCOPPER3/4"90RIDGID 691514-77322 PB77322PB115EA$ 6.100.00%$6.1000$ 701.50$0.0000$0.00
AF526QCOUPLING01/2"COPPERFITTINGRIDGID 691514-78172 PB78172PB106EA$ 7.810.00%$7.8100$ 827.86$0.0000$0.00
AG670IADAPTERCXMBRONZE1/2"0PROPRESS 691514-79215 PB79215PB101EA$ 4.260.00%$4.2600$ 430.26$0.0000$0.00
TOTAL EVALUATED PRICE$ 1,403.89$ 1,403.89$ 671,689.04$ - 0$ - 0

Option 2 - TRA-SER Pro >$500

INSTRUCTIONS: Input the DISCOUNT RATE per CATEGORY of supply from your original solicitation. For price realism, place your source price and source in columns P & R. In addition, provide hardcopy substantitaion in a binder that corresponds with the tab and line item for easy reference.
For sources, provide a short description i.e. (invoices, bills of lading, manufacturer discount agreements, subcontracts, purchase orders, etc…)
CSLNOUNADJ1ADJ2ADJ3ADJ4MANUFACTUREMANUFACTURE PART#CATEGORYQTYUIUNIT PRICEDISCOUNT RATEDISCOUNT PRICEDISCOUNT AMOUNTSource Provided PriceSource Provided Discount AmountSource
AC854VWIREACSR#2SEE BELOW0ALCAN CABLE 980120-59110 EL2 SPARROWEL15001FT$ 9.860.00%$9.86$ 147,909.86$0.0000$0.00
AE474SBULBFLUORESCENT-80120VGE 043168-26668 ELF32T8SP41EL6028EA$ 27.820.00%$27.82$ 167,698.96$0.0000$0.00
AE623ZWIRETHHN#61CONDUCTORBLACKCOPPERWIRE 980100-12204 ELTHHN-6-BLK-7STR-CU-1000REL2910FT$ 2.130.00%$2.13$ 6,198.30$0.0000$0.00
AF238SWIRETHHN350MCMCOPPERBLACKCopper Wire 980100-23430 ELTHHN-350-BLK-37STR-CU-500EL2700FT$ 26.480.00%$26.48$ 71,496.00$0.0000$0.00
AA888OWIRETHHN#2COPPERBLACKCUWIRE 980100-23301 ELTHHN-2-BLK-19STR-CU-1000REL2000FT$ 5.160.00%$5.16$ 10,320.00$0.0000$0.00
AG265WWIRETHHN#30BLACKCITY ELEC 980100-23250 ELTHHN-3-STR-BLKEL1950FT$ 4.120.00%$4.12$ 8,034.00$0.0000$0.00
AA054CSTRAPCONDUITSTEEL1/2"0Raco 050169-02082 EL2082EL1551EA$ 1.450.00%$1.45$ 2,248.95$0.0000$0.00
AG120CTHERMOSTATDIGITAL24 VAC2 C-2 HHONEYWELLHONEYWELL 085267-26199 HVTH5220D1029HV40EA$ 151.130.00%$151.13$ 6,045.20$0.0000$0.00
AE288GCONTACTORDEF.PURPOS24V2POLE0HONEYWELL 085267-78062 HVDP2030A5004HV36EA$ 34.770.00%$34.77$ 1,251.72$0.0000$0.00
AC741JFREON134A30LBDRUMREFRIGERANFORANE BS 668405-11690SUVA-134A-30 2BHV21EA$ 497.480.00%$497.48$ 10,447.08$0.0000$0.00
AA020BCOUPLINGPIPE3/4"PVC0NIBCO 049081-29624 PB1023108PB201EA$ 5.850.00%$5.85$ 1,175.85$0.0000$0.00
AA058MPIPEPVC3/4"20'04HARLOTTE 611942-03926 PB4007B-3/4X20PB143LG$ 10.800.00%$10.80$ 1,544.40$0.0000$0.00
AF539UPIPEPVC2-1/2"20'SCH80UKNOWN 668369-60350 PB250-S80-PIP-P/FTPB140LG$ 140.400.00%$140.40$ 19,656.00$0.0000$0.00
TOTAL EVALUATED PRICE$ 917.45$ - 0$ 917.45$ 454,026.32$0.00$0.00

Option 2 - Open Market

INSTRUCTIONS: Input the DISCOUNT RATE per CATEGORY of supply from your original solicitation. For price realism, place your source price and source in columns Q & S. In addition, provide hardcopy substantitaion in a binder that corresponds with the tab and line item for easy reference.
For sources, provide a short description i.e. (invoices, bills of lading, manufacturer discount agreements, subcontracts, purchase orders, etc…)
CSLNOUNADJ1ADJ2ADJ3ADJ4MANUFACTUREMANUFACTURE PART#SOURCECATEGORYQTYUIUNIT PRICEDISCOUNT RATEDISCOUNT PRICEDISCOUNT AMOUNTSource Provided PriceSource Provided Discount AmountSource
AF940WASPHALTCOLD PATCH60-LBPERMA-PATC0PERMA-PATCH BSPP-60-CGRAINGERBS400BG$ 34.800.00%$34.80$13,920.00$0.0000$0.00
AF899SREFLECTORROUND3"ACRYLICWHITEGRAINGER BS9DKG9GRAINGERBS58EA$ 3.790.00%$3.79$219.82$0.0000$0.00
AC717ARIBBONFLAGGINGORANGE1-3/16"FLOURESCENJOHNSON LEVEL AND TOOL HMD BS1EC17GRAINGERBS17RO$ 3.050.00%$3.05$51.85$0.0000$0.00
AG609ASIGNFIREPOLYESTER14X3-1/2"EXTINGUISHGRAINGER BS1K961GRAINGERBS9EA$ 9.520.00%$9.52$85.68$0.0000$0.00
AG651TFLAGMARKING2.5"HRED100PER.PKGPRESCO PRODUCTS CO BS3LTY1GRAINGERBS8BD$ 12.080.00%$12.08$96.64$0.0000$0.00
AG653ILINKCHAINSINGLESTEEL100TSUBAKI BS6X533GRAINGERBS6EA$ 20.670.00%$20.67$124.02$0.0000$0.00
AG653HLINKCHAINSINGLESTEEL100TSUBAKI BS6X532GRAINGERBS6EA$ 8.440.00%$8.44$50.64$0.0000$0.00
AG703GBARRECTANGLESTEEL1/8"X2"6'GRAINGER BS2HGY9GRAINGERBS5EA$ 23.440.00%$23.44$117.20$0.0000$0.00
AG585LHOLDERBITSTEEL1/4"X6"QUIKREALESIRWIN BS6CYU9GRAINGERBS5EA$ 14.850.00%$14.85$74.25$0.0000$0.00
AG677VPULLEYBLOCK3-1/2"0STEELGRAINGR APPROVED VENDOR BS4JX82GRAINGERBS4EA$ 30.050.00%$30.05$120.20$0.0000$0.00
AG408PCOVERCEILINGMETAL24"X18"FLUSHMOUNTGRAINGER BS2VE86GRAINGERBS2EA$ 82.050.00%$82.05$164.10$0.0000$0.00
AG534ZCONNECTORFLEX90DEGREE1-1/4"ALUMINUMGRAINER APPROVED VENDOR BS5UGX1GRAINGERBS2EA$ 27.800.00%$27.80$55.60$0.0000$0.00
AG147HCLIPCABLESTAINLESS1/4"WIREDAYTON BS2VKH3GRAINGERBS2PK$ 9.380.00%$9.38$18.76$0.0000$0.00
AG614PSTONEPOLISHEDSMALLPEBBECLASS 1DECORATIVEMS INTERNATIONAL BSLPEBMMIX3POL40HOME DEPOTBS100BG$ 29.970.00%$29.97$2,997.00$0.0000$0.00
AG657ALIGHTTAPELED20WATTCHANGCOLORARMACOST BSRF5050030-12CCDHOME DEPOTBS32EA$ 54.970.00%$54.97$1,759.04$0.0000$0.00
AG604TCONCRETEQUIKRETE4000 PSI80 LB0QUIKRETE BS110180LOWESBS310BG$ 4.170.00%$4.17$1,292.70$0.0000$0.00
AG650BBANDFENCEGALV-STEEL2-3/8"CHAIN LINKOLDCASTLE BS02225GRALOWESBS80EA$ 0.960.00%$0.96$76.80$0.0000$0.00
AF530BCEMENTMASONRY70LBTYPE N0QUICKCRETE10354LOWESBS71EA$ 8.090.00%$8.09$574.39$0.0000$0.00
AG119HROLLERROLLUPDOOR0STEEL0BATTALION HDW1RBH2GRAINGERHDW11PK$ 24.990.00%$24.99$274.89$0.0000$0.00
AG444FSCREWHEXHEAD#8 X 1/2 ZSTEEL1/2"GRAINGER HDW2XA37GRAINGERHDW4BX$ 5.850.00%$5.85$23.40$0.0000$0.00
AG650KBOLTCARRIAGEGALVANIZED3/8"X2"2"OLDCASTLE HDW10016GRLOWESHDW124EA$ 0.570.00%$0.57$70.68$0.0000$0.00
AG650LBOLTCARRIAGEGALVANIZED5/16"1-1/4"OLDCASTLE HDW10002GRLOWESHDW100EA$ 0.470.00%$0.47$47.00$0.0000$0.00
AG661YHOSEAIRPOLY BRAIDSNUBBER1/2"X24"LEGACYHFZ1202YW3S-GRAGRAINGERLG15EA$ 24.270.00%$24.27$364.05$0.0000$0.00
AG675WMULCHNO FLOAT2CFRED CYPRES0PREMIUM L&G85281LOWESLG364BG$ 3.330.00%$3.33$1,212.12$0.0000$0.00
TOTAL EVALUATED PRICE$437.56$437.56$23,790.83$0.00$0.00

Option 3 - TRA-SER Pro $0-$500

INSTRUCTIONS: Input the DISCOUNT RATE per CATEGORY of supply from your original solicitation. For price realism, place your source price and source in columns P & R. In addition, provide a hardcopy substantitaion in a binder that corresponds with the tab and line item for easy reference.
For sources, provide a short description i.e. (invoices, bills of lading, manufacturer discount agreements, subcontracts, purchase orders, etc…)
CSLNOUNADJ 1ADJ 2ADJ 3ADJ 4MANUFACTUREMANUFACTURE PART#CategoryQTYU/IUNIT PRICEDISCOUNT RATEDISCOUNT PRICEDISCOUNT AMOUNTSource Provided PriceSource Provided Discount AmountSource
AF349QSTRAPBXGALVANIZED3/8"1HOLEEGS 687855-10551 ELBX-50EL1,311EA$ 1.050.00%$1.0500$ 1,376.55$0.0000$0.00
AG271LCONNECTORSADDLEGRIP03/8"ALUM/STEELARLINGTON 018997-80138 ELSG38AEL622EA$ 2.350.00%$2.3500$ 1,461.70$0.0000$0.00
AE613CWIRETHHN6STRANDBLACKCOPPER WIRE 980100-63152 ELTHHN-6-BLK-19STR-CU-IREL600FT$ 2.130.00%$2.1300$ 1,278.00$0.0000$0.00
AG510XWIRETHHN#8STRANDREDCOPPERWIRE 980100-23103 EL5597027EL500RL$ 620.000.00%$620.0000$ 310,000.00$0.0000$0.00
AF084SWIRETHHN#10COPPERREDCOPPERWIRE 980100-22521 ELTHHN-10-SOL-RED-CU-1000SEL500RL$ 340.000.00%$340.0000$ 170,000.00$0.0000$0.00
AF084WWIRETHHN#10COPPERWHITECOPPERWIRE 980100-22578 ELTHHN-10-WHT-SOL-CU-500CNEL500RL$ 340.000.00%$340.0000$ 170,000.00$0.0000$0.00
AE662OCOUPLINGEMT1/2"DIE CAST ZSET SCREWRACO 050169-02622 EL2622EL446EA$ 3.110.00%$3.1100$ 1,387.06$0.0000$0.00
AE851DSTRAPEMTSTEEL1/2"UNISTRUTB-LINE 781011-60413 ELB2208-ZN-1/2EL341EA$ 6.200.00%$6.2000$ 2,114.20$0.0000$0.00
AB293GWIRE0#6COPPERGREENCOPPERWIRE 980100-63190 ELTHHN-6-GRN-19STR-CU-1REL300FT$ 2.130.00%$2.1300$ 639.00$0.0000$0.00
AF101ASTRAPCONDUITSTEEL1/2"MINERALLACRACO 785991-50468 EL2052EL290EA$ 1.580.00%$1.5800$ 458.20$0.0000$0.00
AE871QSTRAPEMTSTEEL3/4"1HOLEEGS 687855-21902 EL1902EL257EA$ 1.280.00%$1.2800$ 328.96$0.0000$0.00
AA021RCONNECTORCOMPRESSIOALLPURPOSEVARIESCOPPER/ALUBLACKBURN 783786-10302 ELWR189EL250EA$ 1.960.00%$1.9600$ 490.00$0.0000$0.00
AA018WCONNECTORCOMPRESSIOCABLES00BLACKBURN 783786-10001 ELWR159EL250EA$ 1.960.00%$1.9600$ 490.00$0.0000$0.00
AG024UCONNECTORCOMPRESSIOCONDUIT1/2"DIE CASTRACO 050169-02802 EL2802EL232EA$ 4.680.00%$4.6800$ 1,085.76$0.0000$0.00
AE662KCONNECTORCOMPRESSIO01/2"STEELRACO 050169-02802 EL2002EL223EA$ 4.680.00%$4.6800$ 1,043.64$0.0000$0.00
AA637FCONNECTORROMEX01/2"0STEEL CITY 785991-42751 ELNC301EL211EA$ 2.400.00%$2.4000$ 506.40$0.0000$0.00
AG144ICONDUITLIQUIDTIGH1/2"PLASTIC100'CARLON 034481-23305 EL15005-100EL200FT$ 4.160.00%$4.1600$ 832.00$0.0000$0.00
AA081PCOVERJCT.BOXSTEEL4"0RACO 050169-90752 EL752EL197EA$ 8.050.00%$8.0500$ 1,585.85$0.0000$0.00
AA071FTAPEDUCT180'ALUM0BLACK SWAN 054647-10055 HV10055HV65RO$ 13.880.00%$13.8800$ 902.20$0.0000$0.00
AD444FELBOWL/RADIUSCOPPER5/8"90 DEG.NIBCO 039923-31684 HV607-LT-5/8HV62EA$ 7.080.00%$7.0800$ 438.96$0.0000$0.00
AF289VPIPECOPPER3/8" OD20 FT0CERROCOPPER 662386-10024 HVACR/OXY/MED/3/8-PER-FTHV60FT$ 1.620.00%$1.6200$ 97.20$0.0000$0.00
AA298TPIPEPVC1-1/2"20'DWVPVC FTGS 668363-20030 PB150PIP-9/FTPB480FT$ 0.890.00%$0.8900$ 427.20$0.0000$0.00
AA032MELBOWPIPEPVC3/4"90 DEG.NIBCO 039923-14064 PB406-007PB344EA$ 0.760.00%$0.7600$ 261.44$0.0000$0.00
AF423JELBOWCRIMPCOPPER1/2"90RIDGID 691514-77317 PB77317PB272EA$ 3.620.00%$3.6200$ 984.64$0.0000$0.00
AF491SPIPEPVC SCH 803/4"20 FT0NIBCO 039923-09681 PB1680180PB200FT$ 1.450.00%$1.4500$ 290.00$0.0000$0.00
AA001RADAPTERPLUMBINGPVC3/4"0NIBCO 039923-13172 PB436-007PB193EA$ 0.710.00%$0.7100$ 137.03$0.0000$0.00
AF382MTAPE03/4"X260"TEFLONWHITERETROSEAL 021449-35945 PB35945PB167EA$ 3.290.00%$3.2900$ 549.43$0.0000$0.00
AF254APIPEPVC2"20'SCHED 80PIPE FTGS&NIPLES668369-60330PB200-S80-PIP-P/FTPB120FT$ 4.700.00%$4.7000$ 564.00$0.0000$0.00
AF861AELBOWPRO PRESSCOPPER3/4"90RIDGID 691514-77322 PB77322PB115EA$ 6.100.00%$6.1000$ 701.50$0.0000$0.00
AF526QCOUPLING01/2"COPPERFITTINGRIDGID 691514-78172 PB78172PB106EA$ 7.810.00%$7.8100$ 827.86$0.0000$0.00
AG670IADAPTERCXMBRONZE1/2"0PROPRESS 691514-79215 PB79215PB101EA$ 4.260.00%$4.2600$ 430.26$0.0000$0.00
TOTAL EVALUATED PRICE$ 1,403.89$ 1,403.89$ 671,689.04$ - 0$ - 0

Option 3 - TRA-SER Pro >$500

INSTRUCTIONS: Input the DISCOUNT RATE per CATEGORY of supply from your original solicitation. For price realism, place your source price and source in columns P & R. In addition, provide hardcopy substantitaion in a binder that corresponds with the tab and line item for easy reference.
For sources, provide a short description i.e. (invoices, bills of lading, manufacturer discount agreements, subcontracts, purchase orders, etc…)
CSLNOUNADJ1ADJ2ADJ3ADJ4MANUFACTUREMANUFACTURE PART#CATEGORYQTYUIUNIT PRICEDISCOUNT RATEDISCOUNT PRICEDISCOUNT AMOUNTSource Provided PriceSource Provided Discount AmountSource
AC854VWIREACSR#2SEE BELOW0ALCAN CABLE 980120-59110 EL2 SPARROWEL15001FT$ 9.860.00%$9.86$ 147,909.86$0.0000$0.00
AE474SBULBFLUORESCENT-80120VGE 043168-26668 ELF32T8SP41EL6028EA$ 27.820.00%$27.82$ 167,698.96$0.0000$0.00
AE623ZWIRETHHN#61CONDUCTORBLACKCOPPERWIRE 980100-12204 ELTHHN-6-BLK-7STR-CU-1000REL2910FT$ 2.130.00%$2.13$ 6,198.30$0.0000$0.00
AF238SWIRETHHN350MCMCOPPERBLACKCopper Wire 980100-23430 ELTHHN-350-BLK-37STR-CU-500EL2700FT$ 26.480.00%$26.48$ 71,496.00$0.0000$0.00
AA888OWIRETHHN#2COPPERBLACKCUWIRE 980100-23301 ELTHHN-2-BLK-19STR-CU-1000REL2000FT$ 5.160.00%$5.16$ 10,320.00$0.0000$0.00
AG265WWIRETHHN#30BLACKCITY ELEC 980100-23250 ELTHHN-3-STR-BLKEL1950FT$ 4.120.00%$4.12$ 8,034.00$0.0000$0.00
AA054CSTRAPCONDUITSTEEL1/2"0Raco 050169-02082 EL2082EL1551EA$ 1.450.00%$1.45$ 2,248.95$0.0000$0.00
AG120CTHERMOSTATDIGITAL24 VAC2 C-2 HHONEYWELLHONEYWELL 085267-26199 HVTH5220D1029HV40EA$ 151.130.00%$151.13$ 6,045.20$0.0000$0.00
AE288GCONTACTORDEF.PURPOS24V2POLE0HONEYWELL 085267-78062 HVDP2030A5004HV36EA$ 34.770.00%$34.77$ 1,251.72$0.0000$0.00
AC741JFREON134A30LBDRUMREFRIGERANFORANE BS 668405-11690SUVA-134A-30 2BHV21EA$ 497.480.00%$497.48$ 10,447.08$0.0000$0.00
AA020BCOUPLINGPIPE3/4"PVC0NIBCO 049081-29624 PB1023108PB201EA$ 5.850.00%$5.85$ 1,175.85$0.0000$0.00
AA058MPIPEPVC3/4"20'04HARLOTTE 611942-03926 PB4007B-3/4X20PB143LG$ 10.800.00%$10.80$ 1,544.40$0.0000$0.00
AF539UPIPEPVC2-1/2"20'SCH80UKNOWN 668369-60350 PB250-S80-PIP-P/FTPB140LG$ 140.400.00%$140.40$ 19,656.00$0.0000$0.00
TOTAL EVALUATED PRICE$ 917.45$ - 0$ 917.45$ 454,026.32$0.00$0.00

Option 3 - Open Market

INSTRUCTIONS: Input the DISCOUNT RATE per CATEGORY of supply from your original solicitation. For price realism, place your source price and source in columns Q & S. In addition, provide hardcopy substantitaion in a binder that corresponds with the tab and line item for easy reference.
For sources, provide a short description i.e. (invoices, bills of lading, manufacturer discount agreements, subcontracts, purchase orders, etc…)
CSLNOUNADJ1ADJ2ADJ3ADJ4MANUFACTUREMANUFACTURE PART#SOURCECATEGORYQTYUIUNIT PRICEDISCOUNT RATEDISCOUNT PRICEDISCOUNT AMOUNTSource Provided PriceSource Provided Discount AmountSource
AF940WASPHALTCOLD PATCH60-LBPERMA-PATC0PERMA-PATCH BSPP-60-CGRAINGERBS400BG$ 34.800.00%$34.80$13,920.00$0.0000$0.00
AF899SREFLECTORROUND3"ACRYLICWHITEGRAINGER BS9DKG9GRAINGERBS58EA$ 3.790.00%$3.79$219.82$0.0000$0.00
AC717ARIBBONFLAGGINGORANGE1-3/16"FLOURESCENJOHNSON LEVEL AND TOOL HMD BS1EC17GRAINGERBS17RO$ 3.050.00%$3.05$51.85$0.0000$0.00
AG609ASIGNFIREPOLYESTER14X3-1/2"EXTINGUISHGRAINGER BS1K961GRAINGERBS9EA$ 9.520.00%$9.52$85.68$0.0000$0.00
AG651TFLAGMARKING2.5"HRED100PER.PKGPRESCO PRODUCTS CO BS3LTY1GRAINGERBS8BD$ 12.080.00%$12.08$96.64$0.0000$0.00
AG653ILINKCHAINSINGLESTEEL100TSUBAKI BS6X533GRAINGERBS6EA$ 20.670.00%$20.67$124.02$0.0000$0.00
AG653HLINKCHAINSINGLESTEEL100TSUBAKI BS6X532GRAINGERBS6EA$ 8.440.00%$8.44$50.64$0.0000$0.00
AG703GBARRECTANGLESTEEL1/8"X2"6'GRAINGER BS2HGY9GRAINGERBS5EA$ 23.440.00%$23.44$117.20$0.0000$0.00
AG585LHOLDERBITSTEEL1/4"X6"QUIKREALESIRWIN BS6CYU9GRAINGERBS5EA$ 14.850.00%$14.85$74.25$0.0000$0.00
AG677VPULLEYBLOCK3-1/2"0STEELGRAINGR APPROVED VENDOR BS4JX82GRAINGERBS4EA$ 30.050.00%$30.05$120.20$0.0000$0.00
AG408PCOVERCEILINGMETAL24"X18"FLUSHMOUNTGRAINGER BS2VE86GRAINGERBS2EA$ 82.050.00%$82.05$164.10$0.0000$0.00
AG534ZCONNECTORFLEX90DEGREE1-1/4"ALUMINUMGRAINER APPROVED VENDOR BS5UGX1GRAINGERBS2EA$ 27.800.00%$27.80$55.60$0.0000$0.00
AG147HCLIPCABLESTAINLESS1/4"WIREDAYTON BS2VKH3GRAINGERBS2PK$ 9.380.00%$9.38$18.76$0.0000$0.00
AG614PSTONEPOLISHEDSMALLPEBBECLASS 1DECORATIVEMS INTERNATIONAL BSLPEBMMIX3POL40HOME DEPOTBS100BG$ 29.970.00%$29.97$2,997.00$0.0000$0.00
AG657ALIGHTTAPELED20WATTCHANGCOLORARMACOST BSRF5050030-12CCDHOME DEPOTBS32EA$ 54.970.00%$54.97$1,759.04$0.0000$0.00
AG604TCONCRETEQUIKRETE4000 PSI80 LB0QUIKRETE BS110180LOWESBS310BG$ 4.170.00%$4.17$1,292.70$0.0000$0.00
AG650BBANDFENCEGALV-STEEL2-3/8"CHAIN LINKOLDCASTLE BS02225GRALOWESBS80EA$ 0.960.00%$0.96$76.80$0.0000$0.00
AF530BCEMENTMASONRY70LBTYPE N0QUICKCRETE10354LOWESBS71EA$ 8.090.00%$8.09$574.39$0.0000$0.00
AG119HROLLERROLLUPDOOR0STEEL0BATTALION HDW1RBH2GRAINGERHDW11PK$ 24.990.00%$24.99$274.89$0.0000$0.00
AG444FSCREWHEXHEAD#8 X 1/2 ZSTEEL1/2"GRAINGER HDW2XA37GRAINGERHDW4BX$ 5.850.00%$5.85$23.40$0.0000$0.00
AG650KBOLTCARRIAGEGALVANIZED3/8"X2"2"OLDCASTLE HDW10016GRLOWESHDW124EA$ 0.570.00%$0.57$70.68$0.0000$0.00
AG650LBOLTCARRIAGEGALVANIZED5/16"1-1/4"OLDCASTLE HDW10002GRLOWESHDW100EA$ 0.470.00%$0.47$47.00$0.0000$0.00
AG661YHOSEAIRPOLY BRAIDSNUBBER1/2"X24"LEGACYHFZ1202YW3S-GRAGRAINGERLG15EA$ 24.270.00%$24.27$364.05$0.0000$0.00
AG675WMULCHNO FLOAT2CFRED CYPRES0PREMIUM L&G85281LOWESLG364BG$ 3.330.00%$3.33$1,212.12$0.0000$0.00
TOTAL EVALUATED PRICE$437.56$437.56$23,790.83$0.00$0.00

Option 4 - TRA-SER Pro $0-$500

INSTRUCTIONS: Input the DISCOUNT RATE per CATEGORY of supply from your original solicitation. For price realism, place your source price and source in columns P & R. In addition, provide a hardcopy substantitaion in a binder that corresponds with the tab and line item for easy reference.
For sources, provide a short description i.e. (invoices, bills of lading, manufacturer discount agreements, subcontracts, purchase orders, etc…)
CSLNOUNADJ 1ADJ 2ADJ 3ADJ 4MANUFACTUREMANUFACTURE PART#CategoryQTYU/IUNIT PRICEDISCOUNT RATEDISCOUNT PRICEDISCOUNT AMOUNTSource Provided PriceSource Provided Discount AmountSource
AF349QSTRAPBXGALVANIZED3/8"1HOLEEGS 687855-10551 ELBX-50EL1,311EA$ 1.0550.00%$0.5250$ 688.28$0.5250$688.28
AG271LCONNECTORSADDLEGRIP03/8"ALUM/STEELARLINGTON 018997-80138 ELSG38AEL622EA$ 2.350.00%$2.3500$ 1,461.70$0.0000$0.00
AE613CWIRETHHN6STRANDBLACKCOPPER WIRE 980100-63152 ELTHHN-6-BLK-19STR-CU-IREL600FT$ 2.130.00%$2.1300$ 1,278.00$0.0000$0.00
AG510XWIRETHHN#8STRANDREDCOPPERWIRE 980100-23103 EL5597027EL500RL$ 620.000.00%$620.0000$ 310,000.00$0.0000$0.00
AF084SWIRETHHN#10COPPERREDCOPPERWIRE 980100-22521 ELTHHN-10-SOL-RED-CU-1000SEL500RL$ 340.000.00%$340.0000$ 170,000.00$0.0000$0.00
AF084WWIRETHHN#10COPPERWHITECOPPERWIRE 980100-22578 ELTHHN-10-WHT-SOL-CU-500CNEL500RL$ 340.000.00%$340.0000$ 170,000.00$0.0000$0.00
AE662OCOUPLINGEMT1/2"DIE CAST ZSET SCREWRACO 050169-02622 EL2622EL446EA$ 3.110.00%$3.1100$ 1,387.06$0.0000$0.00
AE851DSTRAPEMTSTEEL1/2"UNISTRUTB-LINE 781011-60413 ELB2208-ZN-1/2EL341EA$ 6.200.00%$6.2000$ 2,114.20$0.0000$0.00
AB293GWIRE0#6COPPERGREENCOPPERWIRE 980100-63190 ELTHHN-6-GRN-19STR-CU-1REL300FT$ 2.130.00%$2.1300$ 639.00$0.0000$0.00
AF101ASTRAPCONDUITSTEEL1/2"MINERALLACRACO 785991-50468 EL2052EL290EA$ 1.580.00%$1.5800$ 458.20$0.0000$0.00
AE871QSTRAPEMTSTEEL3/4"1HOLEEGS 687855-21902 EL1902EL257EA$ 1.280.00%$1.2800$ 328.96$0.0000$0.00
AA021RCONNECTORCOMPRESSIOALLPURPOSEVARIESCOPPER/ALUBLACKBURN 783786-10302 ELWR189EL250EA$ 1.960.00%$1.9600$ 490.00$0.0000$0.00
AA018WCONNECTORCOMPRESSIOCABLES00BLACKBURN 783786-10001 ELWR159EL250EA$ 1.960.00%$1.9600$ 490.00$0.0000$0.00
AG024UCONNECTORCOMPRESSIOCONDUIT1/2"DIE CASTRACO 050169-02802 EL2802EL232EA$ 4.680.00%$4.6800$ 1,085.76$0.0000$0.00
AE662KCONNECTORCOMPRESSIO01/2"STEELRACO 050169-02802 EL2002EL223EA$ 4.680.00%$4.6800$ 1,043.64$0.0000$0.00
AA637FCONNECTORROMEX01/2"0STEEL CITY 785991-42751 ELNC301EL211EA$ 2.400.00%$2.4000$ 506.40$0.0000$0.00
AG144ICONDUITLIQUIDTIGH1/2"PLASTIC100'CARLON 034481-23305 EL15005-100EL200FT$ 4.160.00%$4.1600$ 832.00$0.0000$0.00
AA081PCOVERJCT.BOXSTEEL4"0RACO 050169-90752 EL752EL197EA$ 8.050.00%$8.0500$ 1,585.85$0.0000$0.00
AA071FTAPEDUCT180'ALUM0BLACK SWAN 054647-10055 HV10055HV65RO$ 13.880.00%$13.8800$ 902.20$0.0000$0.00
AD444FELBOWL/RADIUSCOPPER5/8"90 DEG.NIBCO 039923-31684 HV607-LT-5/8HV62EA$ 7.080.00%$7.0800$ 438.96$0.0000$0.00
AF289VPIPECOPPER3/8" OD20 FT0CERROCOPPER 662386-10024 HVACR/OXY/MED/3/8-PER-FTHV60FT$ 1.620.00%$1.6200$ 97.20$0.0000$0.00
AA298TPIPEPVC1-1/2"20'DWVPVC FTGS 668363-20030 PB150PIP-9/FTPB480FT$ 0.890.00%$0.8900$ 427.20$0.0000$0.00
AA032MELBOWPIPEPVC3/4"90 DEG.NIBCO 039923-14064 PB406-007PB344EA$ 0.760.00%$0.7600$ 261.44$0.0000$0.00
AF423JELBOWCRIMPCOPPER1/2"90RIDGID 691514-77317 PB77317PB272EA$ 3.620.00%$3.6200$ 984.64$0.0000$0.00
AF491SPIPEPVC SCH 803/4"20 FT0NIBCO 039923-09681 PB1680180PB200FT$ 1.450.00%$1.4500$ 290.00$0.0000$0.00
AA001RADAPTERPLUMBINGPVC3/4"0NIBCO 039923-13172 PB436-007PB193EA$ 0.710.00%$0.7100$ 137.03$0.0000$0.00
AF382MTAPE03/4"X260"TEFLONWHITERETROSEAL 021449-35945 PB35945PB167EA$ 3.290.00%$3.2900$ 549.43$0.0000$0.00
AF254APIPEPVC2"20'SCHED 80PIPE FTGS&NIPLES668369-60330PB200-S80-PIP-P/FTPB120FT$ 4.700.00%$4.7000$ 564.00$0.0000$0.00
AF861AELBOWPRO PRESSCOPPER3/4"90RIDGID 691514-77322 PB77322PB115EA$ 6.100.00%$6.1000$ 701.50$0.0000$0.00

This is the start of the file's text. The full file is on GovTribe.

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