View Single Post
  #4 (permalink)  
Old December 5th, 2007, 23:31
AlejandroBarba AlejandroBarba is offline
Senior Member and Blogger
 
Join Date: Nov 2006
Location: San Diego, CA
Posts: 76
Blog Entries: 2
Thanks: 0
Thanked 18 Times in 17 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 3
AlejandroBarba is on a distinguished road
Re: How to model TL and LTL rates based on zip codes

Hi OTMrookie,

In OTM there is usually more than one way to achieve something but the way that I have done this in the past is (at a high level):

1. For every origin, check which Zip Codes share the same weight break rates
2. Create Regions for all the Zip Codes that were identified in the previous step as sharing the same weight break
3. Create rate records from that particular origin to each region created in step 2 and using the weight break rates that they share

If you have any more questions, please let me know.

Good luck,

Alejandro B.
Reply With Quote
The Following User Says Thank You to AlejandroBarba For This Useful Post:
otmrookie (December 6th, 2007)