Spreadsheet: 55635d1255723274-hlookup-in-hlookup-base-estimate-table-in-excel-excel-freight-cost-calculator-short-version
Sheet: FRTCOST

 |  | Zip |  | 03801
 |  | Zip |  | 38 | CITY, STATE |  | PORTMOUTH NH
 |  | Pounds |  | 22053 | [NAME] |  | 03801
 |  | Cost $/# |  | 0.18288627 |  |  |  |  | #N/A
 |  | RATE X WEIGHT |  | 4033.19091231
 |  | NEXT RATE UP |  | 4630.913100000001
 |  | MININUM |  | 117.683835 | 0 | 300 | 700 | 1200 | 2000 | 4000 | 8000 | 12000 | 18000 | 26000 | 35000 | 10000000000
 |  | [NAME] DISCOUNT |  | 0.5054400000000001 | 1.15 | 1.035 | 0.9176999999999998 | 0.8079500000000001 | 0.7257600000000001 | 0.6532350000000002 | 0.6063200000000001 | 0.5493600000000001 | 0.5054400000000001 | 0.474032 | 0.4494 | 0.4452
 |  | CORRECT FREIGHT COST |  | 2359.69 | Reflects Central Transport 5.5% rate increase 21-Apr-2005 and second price increase of 6% + $30 30-Dec-2005
 |  | ROUND TRIP MILES |  | 3718
 |  | IN COMMERCIAL TRUCKING THE CORRECT FREIGHT CHARGE IS EQUAL TO EITHER RATE
 |  | X POUNDS SHIPPED OR NEXT WEIGHT CLASS UP X NEXT RATE CATEGORY UP, WHICH
 |  | EVER IS LESS OR THE MINIMUM CHARGE IF THE MINIMUM CHARGE IS GREATOR THAN
 |  | EITHER RATE X WEIGHT.
28-Mar-2005, [NAME] increased by the following formula: @if(cv23-450.1<0,1,((cv23-450)*.0001)+1) which has the effect of increasing freight prices for far away destinations
 | Zip | Minimum | <500 | 500<1,000 | 1,000<2,000 | 2,000<5,000 | 5,000<10,000 | 10,000<20,000 | 20,000<30,000 | 30,000<40,000 | >40,000
 |  | IN US $ | VALUES LISTED IN US DOLLARS PER POUND
10/10/2006, Increased minimum charge to 118.04 + 15
 | FILE XTRACT HERE |  | 0 | 500 | 1000 | 2000 | 5000 | 10000 | 20000 | 30000 | 40000
 |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ZIP | CITY | STATE | ONE WAY MILES | 10 SERIES HEADS
1.1281 | 10 | 112.415165 | 0.56393719 | 0.47932969 | 0.40036269 | 0.3553515 | 0.2819121900000001 | 0.2651035 | 0.17282492 | 0.14575052 | 0.12961869 | 01001 | AGAWAM | MA | 1731 | [NAME] revised per Michelle Spicer 16-Jan-2004
1.1237 | 12 | 110.066415 | 0.54915219 | 0.46678498 | 0.3899238999999999 | 0.34598723 | 0.27463228 | 0.25811389 | 0.16821789 | 0.14203568 | 0.12619151 | 01201 | PITTSFIELD | MA | 1687
1.1306 | 13 | 112.66429 | 0.56518694 | 0.48039194 | 0.40124994 | 0.356139 | 0.28253694 | 0.265691 | 0.17320792 | 0.14607352 | 0.12990594 | 01301 | BREENFIELD | MA | 1756
1.1329 | 14 | 113.85645 | 0.57268095 | 0.48680713 | 0.4067111 | 0.36082865 | 0.28639712 | 0.26917704 | 0.17548621 | 0.14795674 | 0.13152969 | 01420 | FITCHBURG | MA | 1779
1.1322 | 17 | 114.74847 | 0.57900708 | 0.49216734 | 0.41110182 | 0.36468162 | 0.28950354 | 0.27206766 | 0.17741574 | 0.14967684 | 0.1330335 | 01701 | FRAMINGHAM | MA | 1772
1.1363 | 18 | 116.186675 | 0.5878079900000001 | 0.49963111 | 0.41736299 | 0.3703201700000001 | 0.29384718 | 0.27623453 | 0.18010355 | 0.15192331 | 0.13510607 | 01801 | WOBURN | MA | 1813
1.1399 | 25 | 124.192105 | 0.63982587 | 0.54384629 | 0.45425015 | 0.40306864 | 0.31985594 | 0.30070562 | 0.1960628 | 0.16539949 | 0.1470471 | 02532 | BUZZARDS BAY | MA | 1849
1.1347 | 27 | 116.023075 | 0.58698031 | 0.49892759 | 0.41677531 | 0.36979873 | 0.29343342 | 0.27584557 | 0.17984995 | 0.15170939 | 0.13491583 | 02702 | ASSONET | MA | 1797
1.1285 | 34 | 112.455025 | 0.5641371500000001 | 0.47949965 | 0.40050465 | 0.3554775 | 0.28201215 | 0.2651975 | 0.1728862 | 0.1458022 | 0.12966465 | 03431 | KEENE | NH | 1735
1.137 | 35 | 117.28155 | 0.5951058 | 0.5057376 | 0.4225092 | 0.3749826 | 0.2975529 | 0.279702 | 0.1822611 | 0.1538361 | 0.1367811 | 03561 | LITTLETON | NH | 1820
1.1285 | 34 | 112.455025 | 0.5641371500000001 | 0.47949965 | 0.40050465 | 0.3554775 | 0.28201215 | 0.2651975 | 0.1728862 | 0.1458022 | 0.12966465 | 03431 | KEENE | NH | 1735
1.137 | 35 | 117.28155 | 0.5951058 | 0.5057376 | 0.4225092 | 0.3749826 | 0.2975529 | 0.279702 | 0.1822611 | 0.1538361 | 0.1367811 | 03561 | LITTLETON | NH | 1820
1.1335 | 36 | 112.953275 | 0.56663665 | 0.48162415 | 0.40227915 | 0.3570525 | 0.28326165 | 0.2663725 | 0.1736522 | 0.1464482 | 0.13023915 | 03601 | ACWORTH | NH | 1785
1.1355 | 37 | 115.082925 | 0.5806946999999999 | 0.49360185 | 0.41230005 | 0.36574455 | 0.2903473499999999 | 0.27286065 | 0.17793285 | 0.1501131 | 0.13342125 | 03740 | BATH | NH | 1805
1.1409 | 38 | 117.683835 | 0.59714706 | 0.50747232 | 0.42395844 | 0.37626882 | 0.29857353 | 0.2806614 | 0.18288627 | 0.15436377 | 0.13725027 | 03801 | PORTMOUTH | NH | 1859
1.1425 | 39 | 119.9625 | 0.61180875 | 0.520066 | 0.4343785 | 0.3854795 | 0.3059615 | 0.28756725 | 0.18748425 | 0.158122 | 0.1405275 | 03901 | BERWICK | ME | 1875
1.128 | 943 | 131.05104 | 0.5367024 | 0.4346184 | 0.3703224 | 0.311328 | 0.2683512 | 0.2200728 | 0.1931136 | 0.16638 | 0.1555512 | 94301 | PALO ALTO | CA | 1730
1.1261 | 952 | 127.294344 | 0.5212716900000001 | 0.4222875 | 0.35967634 | 0.30235785 | 0.26069215 | 0.21373378 | 0.18760826 | 0.16170796 | 0.15112262 | 95201 | STOCKTON | CA | 1711
1.1191 | 953 | 128.841983 | 0.5276556499999999 | 0.42738429 | 0.36415514 | 0.30607385 | 0.26388378 | 0.21632203 | 0.19002318 | 0.16350051 | 0.15298097 | 95301 | ATWATER | CA | 1641
1.1354 | 954 | 131.910772 | 0.54022332 | 0.4374696199999999 | 0.37275182 | 0.3133704 | 0.27011166 | 0.22151654 | 0.19438048 | 0.1674715 | 0.15657166 | 95401 | SANTA ROSA | CA | 1804
1.1569 | 955 | 190.529861 | 0.7802133600000001 | 0.63201447 | 0.53842126 | 0.45257928 | 0.39022237 | 0.3198828500000001 | 0.28089532 | 0.2417921 | 0.22628964 | 95501 | EUREKA | CA | 2019
1.1308 | 956 | 133.796256 | 0.5478726 | 0.443839 | 0.37813952 | 0.3177548000000001 | 0.27399284 | 0.22468996 | 0.1973246 | 0.16984616 | 0.1588774 | 95601 | AMADOR CITY | CA | 1758