Loading...
5404 Pricing Matrix - City of Denton - Q12015 AMM Index Values Average of the National mills Carbon Grade Plate (Cut to Length and Coiled) for the last month of the quarter Base Line February 2014 = LME Index Values 2012 Monthly Average Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD Avg Average of the Zinc pricing from the London Metals Exchange for the last month of the quarter Base Line February 2014 = EIA Index Values Website Average of the Gulf Coast Diesel prices from the EIA.gov for the last month of the quarter Base Line February 2014 = 0.8984 0.9336 0.9229 0.9057 0.8754 0.8418 0.8397 0.8227 0.9081 0.8672 0.8638 0.9242 0.883625 http://www.eia.gov/dnav/pet/pet_pri_gnd_dcus_r30_m.htm 2013 Monthly Average Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD Avg 790 0.9222 0.9658 0.8781 0.8405 0.8296 0.8343 0.8327 0.8594 0.8384 0.854 0.8476 0.8778 0.865 0.9232 3.806 2014 Monthly Average Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD Avg 0.9246 0.9232 0.9137 0.9211 0.9345 0.9629 1.0483 1.0565 1.0416 1.0309 1.0249 0.9852 0.980616666666667 Cost Model Review Process: Owner and Seller agree to review the Unit Price of the Materials on a quarterly basis on or about the dates scheduled below ("Quarterly Review Date"). Any Increase or decrease in the Unit Price, as agreed to by the parties, shall become effective on the fifteenth (15th) day following the applicable quarterly Review Date. Any adjustments shall be made via revisions to the BPO and shall be reflected on future PO's. Process for Price Adjustments: 1. In the event the date of delivery of an order occurs after a Quarterly Review Date, Seller agrees to hold the Unit Price firm and fixed at the Unit Price Listed at the time the order was placed. 2. Seller shall prepare and submit a quarterly summary of price increases or decreases to the Owner by the Seventh (7th) day of the quarter following the above Quarterly Review Dates. 3. Owner shall review, verify, and clarify any requests to increase or decrease the Unit Price in writing to the Seller within seven (7) business days of receiving the Seller's request. 4. Price adjustments that follow the processes as described herein do not require an amendment to the Contract. The adjustments and approvals shall be documented under separate cover. Actual adjustments to the Unit Price will be updated on the BPO, and such revised pricing will be reflected on future PO's. - January 1st - April 1st - July 1st - October 1st Q4 2014 Q1 2015 Q2 2015 Q3 2015 Q4 2015 Q1 2016 Q2 2016 Q3 2016 Q4 2016 Q1 2017 Q2 2017 Q3 2017 Q4 2017 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 2014 2014 2015 2015 2015 2015 2016 2016 2016 2016 2017 2017 2017 2017 Index Value Index Value Index Value Index Value Index Value Index Value Index Value Index Value Index Value Index Value Index Value Index Value Index Value Date Base (February 2014) Q4 2014 Index Value Q1 2015 Index Value Q2 2015 Index Value Q3 2015 Index Value Q4 2015 Index Value Q1 2016 Index Value Q2 2016 Index Value Q3 2016 Index Value Q4 2016 Index Value Q1 2017 Index Value Q2 2017 Index Value Q3 2017 Index Value Q4 2017 Index Value S1 S2 Z1 Z2 D1 D2 S% Z% D% P Formula S1 Baseline Steel 790 = = = = = = = = = = = S2 Current Steel 868.75 765 765 765 765 765 765 765 765 765 765 765 765 RED = Forecasted Values Baseline AMM Steel Index Value Future AMM Steel Index Value Baseline LME Zinc Index Value Future LME Zinc Index Value Baseline Diesel EIA Gulf Coast Index Value Future Diesel EIA Gulf Coast Index Value 50% material Content 2% Zinc Content 1% Freight Content (5 denotes MPG avarage) Price Change Multiplier Formula(P) = 1+((S2-S1)/S1)*Material Content)+((Z2-Z1)/Z1*Zinc Content)+ (((D2-D1)/D1/5*freight content) % Steel Change 9.96835443037975E-02 -3.16455696202532E-02 -3.16455696202532E-02 -3.16455696202532E-02 -3.16455696202532E-02 -3.16455696202532E-02 -3.16455696202532E-02 -3.16455696202532E-02 -3.16455696202532E-02 -3.16455696202532E-02 -3.16455696202532E-02 -3.16455696202532E-02 -3.16455696202532E-02 S% Steel Content 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Z1 Baseline Zinc 0.9232 Z2 Current Zinc 1.0416 0.9852 0.9852 0.9852 0.9852 0.9852 0.9852 0.9852 0.9852 0.9852 0.9852 0.9852 0.9852 % Zinc Change 0.128249566724437 6.71577123050259E-02 6.71577123050259E-02 6.71577123050259E-02 6.71577123050259E-02 6.71577123050259E-02 6.71577123050259E-02 6.71577123050259E-02 6.71577123050259E-02 6.71577123050259E-02 6.71577123050259E-02 6.71577123050259E-02 6.71577123050259E-02 Z% Zinc Content 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 D1 Baseline Diesel 3.806 D2 Current Diesel 3.704 3.312 3.312 3.312 3.312 3.312 3.312 3.312 3.312 3.312 3.312 3.312 3.312 % Diesel Change -2.67997898055701E-02 -0.129795060430899 -0.129795060430899 -0.129795060430899 -0.129795060430899 -0.129795060430899 -0.129795060430899 -0.129795060430899 -0.129795060430899 -0.129795060430899 -0.129795060430899 -0.129795060430899 -0.129795060430899 D% Diesel Content 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 P Custom Galv Steel Pole Price Change Multiplier 1.05235316390678 0.985260779315112 0.985260779315112 0.985260779315112 0.985260779315112 0.985260779315112 0.985260779315112 0.985260779315112 0.985260779315112 0.985260779315112 0.985260779315112 0.985260779315112 0.985260779315112 P Custom Anchor Bolt Price Change Multiplier 1.04978817257229 0.983917625069012 0.983917625069012 0.983917625069012 0.983917625069012 0.983917625069012 0.983917625069012 0.983917625069012 0.983917625069012 0.983917625069012 0.983917625069012 0.983917625069012 0.983917625069012 Galvanized Steel Pole Price Change Multiplier: Anchor Bolt Price Change Multiplier: Pricing Sheet 5404-TM Steel Poles (Revised 7/25/2014) Contract # 5404 Contract Date: June 3, 2014 Contract Term: 3 years ITEM # SINGLE CIRCUIT WITHOUT UNDERBUILD 101 102 122 123 124 SINGLE CIRCUIT WITH UNDERBUILD 1 2 3 4 109 110 111 119 120 121 5 6 7 104 117 118 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 DOUBLE CIRCUIT WITHOUT UNDERBUILD 29 30 31 32 33 108 34 35 35-REV 36 37 38 39 40 41 103 42 43 44 45 46 47 48 49 50 51 52 53 54 55 55-REV 55-REV2 56 56-REV 56-REV2 57 57-REV 57-REV2 58 58-REV 58-REV2 59 59-REV 59-REV2 114 112 60 61 62 63 64 65 66 67 68 105 106 107 113 DOUBLE CIRCUIT WITH UNDERBUILD 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 86-REV 86-REV2 87 87-REV 87-REV2 88 88-REV 88-REV2 116 89 90 91 DISTRIBUTION DOUBLE CIRCUIT 92 93 94 PRICE ADJUSTMENTS POLE MODIFICATION OPTION Adder price per pound of steel for modifications = DELIVERY OPTION Adder price per pound per structure for pole location drop delivery = Current Quarter: Foundation Type Foundation Foundation Foundation Foundation Foundation Embedded Embedded Embedded Embedded Embedded Embedded Foundation Foundation Foundation Foundation Embedded Embedded Embedded Embedded Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Embedded Embedded Embedded Embedded Embedded Embedded Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Embedded Embedded Embedded Embedded Embedded Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Foundation Embedded Embedded Height 65 80 75' 80' 85' 100 105 110 115 105 110 95 85 90 95 105 110 115 120 95 100 95 100 105 95 100 105 90 95 100 90 95 100 90 95 100 90 95 100 90 95 100 105 110 115 120 125 130 90 95 95 100 105 90 95 100 105 110 85 90 95 100 105 80 95 100 105 80 95 100 105 80 80 80 90 90 90 95 95 95 100 100 100 105 105 105 85 95 90 95 100 75 80 85 90 95 100 85 90 95 105 105 110 115 120 125 95 100 105 100 105 110 100 105 110 100 105 110 100 100 100 105 105 105 110 110 110 95 100 105 110 40 55 50 Galvanized Steel Transmission Poles Contract Amount: $15,590,000.00 PoleName (ref Exhibit 4) TUS-5AA TUS-2A TUS-5AR TUS-5AR TUS-5AR TPS-138U TPS-138U TPS-138U TPS-138U TPS-138U-XS TPS-138U-XS TPS-138U-XT TPS-138XU TPS-138XU TPS-138XU TUS-2AU TUS-2AU TUS-2AU TUS-2AU TUS-2AXU TUS-2AXU TUS-3AU TUS-3AU TUS-3AU TUS-4AU TUS-4AU TUS-4AU TUS-5AAU TUS-5AAU TUS-5AAU TUS-5AAU-2 TUS-5AAU-2 TUS-5AAU-2 TUS-5AU TUS-5AU TUS-5AU 1.5 TUS-5AU 1.5 TUS-5AU 1.5 TUS-5AU TUS-SWT-1U TUS-SWT-1U TUS-SWT-1U TPS-138DC TPS-138DC TPS-138DC TPS-138DC TPS-138DC TPS-138DC TPS-138DCX TPS-138DCX TPS-138DCX TPS-138DCX TPS-138DCX TUS-2DC TUS-2DC TUS-2DC TUS-2DC TUS-2DC TUS-7GA TUS-7GA TUS-7GA TUS-7GA TUS-7GA TUS-7GA-2 TUS-7GA-2 TUS-7GA-2 TUS-7GA-2 TUS-7GA-3 TUS-7GA-3 TUS-7GA-3 TUS-7GA-3 TUS-7G TUS-7G TUS-7G TUS-7G TUS-7G TUS-7G TUS-7G TUS-7G TUS-7G TUS-7G TUS-7G TUS-7G TUS-7G TUS-7G-M1 TUS-7G TUS-7G2 TUS-7G2 TUS-7GX TUS-7GX TUS-7GX TUS-7A TUS-7A TUS-7A TUS-7A TUS-7A TUS-7A TUS-7GAX TUS-7GAX TUS-7GAX TUS-7GAX TPS-138DCU TPS-138DCU TPS-138DCU TPS-138DCU TPS-138DCU TUS-2DCU TUS-2DCU TUS-2DCU TUS-7GAU TUS-7GAU TUS-7GAU TUS-7GAU-2 TUS-7GAU-2 TUS-7GAU-2 TUS-7GAU-3 TUS-7GAU-3 TUS-7GAU-3 TUS-7GU TUS-7GU TUS-7GU TUS-7GU TUS-7GU TUS-7GU TUS-7GU TUS-7GU TUS-7GU TUS-7GU-2 TUS-7GXU TUS-7GXU TUS-7GXU DC8S DC8S-M3 DC19-UG Q1 2015 0.985260779315112 0.983917625069012 Embedded Depth 13'-0" 13'-6" 14'-0" 14'-6" 13' 6" 14' 16'-6" 17'-0" 17'-6" 18'-0" 16'-6" 17'-0" 17'-6" 18'-0" 18'-6" 19' 16'-6" 17'-0" 17'-6" 18'-0" 18'-6" 8.5 8 Anchor Bolt Cage Length 20' - 0" 18' - 0" 20'-0" 20'-0" 20'-0" 15' 17'-0" 17'-0" 17'-0" 20'-0" 20'-0" 17'-0" 17'-0" 17'-0" 18'-0" 18'-0" 18'-0" 22'-0" 22'-0" 22'-0" 25'-0" 25'-0" 25'-0" 28'-0" 28'-0" 28'-0" 20'-0" 20'-0" 20'-0" 20'-0" 20'-0" 20'-0" 15'-0" 15'-0" 15'-0" 15'-0" 15'-0" 15'-0" 15'-0" 15'-0" 15'-0" 22'-0" 18'-0" 18'-0" 18'-0" 18'-0" 18'-0" 20'-0" 20'-0" 20'-0" 20'-0" 23'-0" 23'-0" 23'-0" 23'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 28'-0" 22'-0" 22'-0" 22'-0" 22'-0" 22'-0" 22'-0" 17'-0" 17'-0" 17'-0" 20'-0" 20'-0" 20'-0" 23'-0" 23'-0" 23'-0" 28'-0" 28'-0" 28'-0" 30'-0" 30'-0" 30'-0" 30'-0" 30'-0" 30'-0" 30'-0" 30'-0" 30'-0" 30'-0" 30'-0" 30'-0" 30'-0" 20'-0" 1.38 0.03 Anchor Bolt Quantity (per Cage) See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations See Design Calculations Anchor Bolt Cage Unit Weight (Per Structure) 6455 1446 4203 5925 5955 6279 2428 2435 2444 4093 5730 4564 4579 6143 7707 7731 7772 12579 12636 12694 15593 17178 17232 19056 19159 21377 9615 9655 9696 4298 6244 6287 3063 3073 3073 3084 3095 3992 4006 4020 4034 5406 8841 8899 8995 10901 11023 11722 13203 14505 14607 14794 16610 16751 18228 21389 21339 21339 23306 23254 23302 23466 23413 25163 25227 25181 25181 25342 25277 27085 21348 21348 12160 12231 12303 22160 24932 25022 27794 27884 27972 11781 11845 13016 4529 4536 6062 11997 12074 12233 16444 16559 16700 23602 23722 23874 27909 27810 27834 29820 29719 29719 30032 29903 29930 23682 15044 15095 16949 2801 ANCHOR BOLT CAGE MODIFICATION Adder price of anchor bolt cage per bolt per additional foot = Reduced price of anchor bolt cage per bolt per subtraction of a foot = Additional nut per bolt = Anchor Bolt Cage Base Price (Per Structure) 8524 2164 5862 8058 8108 8560 3353 3363 3536 5547 7587 6460 6495 8462 10770 10813 10887 16840 16943 17047 20213 22186 22807 24651 24861 28089 12962 13035 13107 6312 8811 9289 4398 4418 4418 4440 4460 5659 5685 5712 5738 7318 12262 12366 12938 15578 15828 15721 18262 22508 22829 20211 26617 27106 29104 28113 27842 27842 33888 33697 33850 34390 34204 36404 36639 36463 36463 38155 37955 40390 28936 28936 15764 15891 8377 28884 33274 33434 36936 37096 37256 15872 15987 18012 6203 6216 8336 16797 19560 20061 25177 25539 26928 34815 36373 36902 44574 44410 44491 47161 46992 46992 47900 47643 47729 33241 19833 19922 22222 3582 Anchor Bolt Cage Current Quarter Price (Per Structure) 8386.9138 2129.1977 5767.7251 7928.4082 7977.6041 8422.3349 3299.0758 3308.915 3479.1327 5457.7911 7464.983 6356.1079 6390.545 8325.9109 10596.7928 10639.1013 10711.9112 16569.1728 16670.5163 16772.8438 19887.927 21829.1964 22440.2093 24254.5534 24461.1761 27637.2622 12753.5403 12825.3662 12896.2083 6210.488 8669.2982 9139.6108 4327.2697 4346.9481 4346.9481 4368.5943 4388.2726 5567.9898 5593.5717 5620.1375 5645.7193 7200.3092 12064.7979 12167.1254 12729.9262 15327.4688 15573.4482 15468.169 17968.3037 22146.0179 22461.8555 19885.9591 26188.9354 26670.0711 28635.9386 27660.8762 27394.2345 27394.2345 33343.0005 33155.0722 33305.6116 33836.9271 33653.9184 35818.5372 36049.7579 35876.5884 35876.5884 37541.377 37344.5935 39740.4329 28470.6404 28470.6404 15510.4774 15635.435 8242.2779 28419.4767 32738.8751 32896.3019 36341.9814 36499.4082 36656.835 15616.7405 15729.8911 17722.3243 0 6103.241 6116.032 8201.9373 16526.8643 19245.4287 19738.3715 24772.094 25128.2722 26494.9338 34255.0921 35788.0358 36308.5282 43857.1442 43695.7817 43775.4791 46402.5391 46236.257 46236.257 47129.6542 46876.7874 46961.4043 32706.4058 19514.0383 19601.6069 21864.6175 3524.3929 Pole Weight (Per Structure) 13589 8294 11714 12930 14000 7427 7969 9282 10257 9619 10237 21733 6557 7628 8328 13724 14723 15755 17699 13927 14980 15490 16801 18328 22528 25138 27043 31377 33837 36380 36977 39889 42930 40765 45341 47655 26081 28153 30249 24393 27215 29340 9304 10684 11394 13042 13833 15027 8656 9369 14235 10105 10863 13862 15229 16522 17863 21443 26473 29623 32311 34870 38779 28996 39269 42389 46443 35973 52050 60295 64164 38916 36680 39943 46978 48068 50620 52535 53530 55866 57860 56958 58235 62758 60977 64797 41469 49748 25849 27954 30144 49186 53878 59244 67448 72492 78210 38035 40920 43915 50292 9051 10731 11475 12426 13222 15757 17431 18794 38154 41005 46814 47944 53118 58492 62218 67535 73599 65935 62595 66061 69792 66338 71569 76660 80106 78494 52183 33441 35638 37867 4354 2825 2355 Todays Date: Mfg: Valmont - China Delivery ARO: 20 weeks Pole Base Price (Per Structure) 17122 10368 17784 19616 20641 8090 8456 9843 10610 14044 14741 29122 9810 11709 12317 15601 16353 17111 19436 21993 23006 18676 19620 20821 23294 28889 30336 40881 42878 46420 47802 51960 54796 54266 58181 60225 27224 28828 30483 30443 35402 37146 9205 10686 11210 12331 13695 20437 8867 9420 17352 10097 10605 15901 17211 18245 19305 24445 35024 38630 44120 46551 49937 35996 48580 54602 61036 44547 63112 70130 75354 48858 49510 52142 61714 62969 67019 66617 67983 73201 70693 72337 75020 75315 76221 84060 56200 67826 37671 39424 42304 54880 61214 67822 74690 83572 89284 48774 53029 58530 68816 9142 10905 11524 12134 13543 19573 20959 22158 51899 56763 65087 65009 69622 72942 79237 83937 88923 82665 83251 88856 86182 87566 94528 92635 104138 101073 72119 37981 40652 42423 6126 4885 3272 1/20/2015 Pole Current Quarter Price (Per Structure) 16869.6351 10215.1838 17521.8777 19326.8754 20336.7677 7970.7597 8331.3651 9697.9219 10453.6169 13837.0024 14523.7291 28692.7644 9665.4082 11536.4185 12135.457 15371.0534 16111.9695 16858.7972 19149.5285 21668.8403 22666.9095 18400.7303 19330.8165 20514.1147 22950.6646 28463.1987 29888.871 40278.4459 42246.0117 45735.8054 47097.4358 51194.1501 53988.3497 53466.1615 57323.4574 59337.3304 26822.7395 28403.0977 30033.7043 29994.2939 34880.2021 36598.4969 9069.3255 10528.4967 11044.7733 12149.2507 13493.1464 20135.7745 8736.3073 9281.1565 17096.245 9948.1781 10448.6906 15666.6317 16957.3233 17976.0829 19020.4593 24084.6998 34507.7735 38060.6239 43469.7056 45864.8745 49200.9675 35465.447 47863.9687 53797.2091 60136.3769 43890.4119 62181.7783 69096.3385 74243.3408 48137.8712 48780.2612 51373.4676 60804.3837 62040.886 66031.1922 65635.1173 66980.9836 72122.0743 69651.0403 71270.809 73914.2637 74204.9156 75097.5619 82821.0211 55371.6558 66826.2976 37115.7588 38842.921 41680.472 54071.1116 60311.7533 66822.3566 73589.1276 82340.2138 87968.0234 48055.1093 52247.3939 57667.3134 67801.7058 9007.254 10744.2688 11354.1452 11955.1543 13343.3867 19284.5092 20650.0807 21831.4083 51134.0492 55926.3576 64127.6683 64050.818 68595.826 71866.8918 78069.1084 82699.834 87612.3443 81446.5823 82023.9451 87546.3318 84911.7445 86275.3454 93134.7309 91269.6323 102603.087 99583.2627 71056.0221 37421.1897 40052.8212 41797.718 6035.7075 4812.9989 3223.7733 20 20 8 Amendement 6 Amendement 6 Amendement 6 Amendment 6 Amendment 6 Amendment 6 Amendment 6 Amendment 6 Amendement 5 Amendment 5 Amendment 4 Amendment 5 Amendment 6 Amendment 5