Spreadsheet: 48120d1247275345-hlookup-in-hlookup-base-estimate-table-in-excel-excel-20freight-20cost-20calculator-1-
Sheet: FRTCOST

 |  | Zip |  | 10001
 |  | Zip |  | 100 | CITY, STATE |  | LITTLETON NH
 |  | Pounds |  | 5000 | [NAME] |  | 03561
 |  | Cost $/# |  | 0.2975529 |  |  |  |  | #N/A
 |  | RATE X WEIGHT |  | 1487.7645
 |  | NEXT RATE UP |  | 1.678212
 |  | MININUM |  | 117.28155 | 0 | 300 | 700 | 1200 | 2000 | 4000 | 8000 | 12000 | 18000 | 26000 | 35000 | 10000000000
 |  | [NAME] DISCOUNT |  | 0.6532350000000002 | 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 |  | 95.68 | Reflects Central Transport 5.5% rate increase 21-Apr-2005 and second price increase of 6% + $30 30-Dec-2005
 |  | ROUND TRIP MILES |  | 3640
 |  | 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.1375 | 957 | 158.613 | 0.6496262500000001 | 0.5262074999999999 | 0.448175 | 0.37674 | 0.32475625 | 0.26628875 | 0.23375625 | 0.20145125 | 0.18837 | 95701 | ALTA | CA | 1825
1.1307 | 958 | 131.364726 | 0.5379870600000001 | 0.43565871 | 0.37120881 | 0.3120732000000001 | 0.26899353 | 0.22059957 | 0.19357584 | 0.16677825 | 0.15592353 | 95812 | SACRAMENTO | CA | 1757
1.1471 | 960 | 181.654756 | 0.74400906 | 0.60268634 | 0.51332725 | 0.43153902 | 0.37200453 | 0.3051286 | 0.26773314 | 0.2305671 | 0.21576951 | 96001 | REDDING | CA | 1921
1.1581 | 961 | 178.567439 | 0.7313401499999999 | 0.5923681499999999 | 0.5045841699999999 | 0.42421203 | 0.36572798 | 0.29983209 | 0.26335194 | 0.22675598 | 0.21216392 | 96101 | [NAME] | CA | 2031
1.1649 | 970 | 148.862571 | 0.60970866 | 0.49380111 | 0.42064539 | 0.35354715 | 0.30485433 | 0.24987105 | 0.21946716 | 0.18894678 | 0.17683182 | 97001 | ANTELOPE | OR | 2099
1.1728 | 971 | 154.86824 | 0.63425024 | 0.51380368 | 0.43768896 | 0.36790736 | 0.3172424 | 0.26000976 | 0.22834416 | 0.19656128 | 0.18389504 | 97101 | AMITY | OR | 2178
1.1686 | 972 | 149.335394 | 0.61164524 | 0.4953695400000001 | 0.42198146 | 0.3546701 | 0.30582262 | 0.2506647 | 0.22016424 | 0.18954692 | 0.17739348 | 97201 | PORTLAND | OR | 2136
1.1614 | 975 | 143.4329 | 0.58743612 | 0.47582558 | 0.4053286 | 0.34075476 | 0.29371806 | 0.24075822 | 0.21149094 | 0.18210752 | 0.17037738 | 97501 | MEDFORD | OR | 2064
1.161 | 976 | 139.81923 | 0.5726052 | 0.4638195000000001 | 0.3950883 | 0.3321621 | 0.2863026 | 0.2347542 | 0.2060775 | 0.1775169 | 0.166023 | 97601 | [NAME] | OR | 2060
1.1473 | 978 | 133.293314 | 0.54588534 | 0.44205469 | 0.37665859 | 0.3166548 | 0.27294267 | 0.22383823 | 0.19641776 | 0.16922675 | 0.15821267 | 97801 | PENDLETON | OR | 1923
1.1313 | 979 | 127.882152 | 0.52367877 | 0.4242375 | 0.36133722 | 0.30375405 | 0.26189595 | 0.21472074 | 0.18847458 | 0.16245468 | 0.15182046 | 97901 | ADRIAN | OR | 1763
1.1761 | 980 | 150.293819 | 0.6155707399999999 | 0.49854879 | 0.4246897099999999 | 0.35694635 | 0.3077853699999999 | 0.25227345 | 0.22157724 | 0.19076342 | 0.17853198 | 98001 | AUBURN | WA | 2211
1.1791 | 983 | 163.104903 | 0.66807806 | 0.54108899 | 0.4609101900000001 | 0.38745226 | 0.33403903 | 0.27390493 | 0.2405364 | 0.20704996 | 0.19372613 | 98303 | [NAME] | WA | 2241
1.18 | 984 | 150.7922 | 0.6176119999999999 | 0.5002019999999999 | 0.426098 | 0.3581299999999999 | 0.308806 | 0.25311 | 0.222312 | 0.191396 | 0.179124 | 98401 | TACOMA | WA | 2250
1.179 | 985 | 154.36647 | 0.6321798000000001 | 0.5120397000000001 | 0.43623 | 0.366669 | 0.3160899 | 0.2591442 | 0.2276649 | 0.1959498 | 0.1833345 | 98501 | OLYMPIA | WA | 2240
1.1708 | 986 | 149.616532 | 0.61279672 | 0.49630212 | 0.42277588 | 0.3553378 | 0.30639836 | 0.2511366 | 0.22057872 | 0.18990376 | 0.17772744 | 98601 | AMBOY | WA | 2158
1.169 | 988 | 144.3715 | 0.5912802 | 0.4789393 | 0.407981 | 0.3429846 | 0.2956401 | 0.2423337 | 0.2128749 | 0.1832992 | 0.1714923 | 98801 | WENATCHEE | WA | 2140
1.1528 | 990 | 138.831704 | 0.56856096 | 0.4605436000000001 | 0.39229784 | 0.32981608 | 0.28428048 | 0.23309616 | 0.204622 | 0.17626312 | 0.1648504 | 99001 | AIRWAY HEIGHTS | WA | 1978
1.1581 | 991 | 151.630033 | 0.62097322 | 0.50296283 | 0.428497 | 0.3601691 | 0.31048661 | 0.25455038 | 0.22362911 | 0.19247622 | 0.18008455 | 99101 | ADDY | WA | 2031
1.1521 | 992 | 138.747403 | 0.56821572 | 0.46026395 | 0.3920596299999999 | 0.32961581 | 0.28410786 | 0.23295462 | 0.20449775 | 0.17615609 | 0.1647503 | 99201 | SPOKANE | WA | 1971