Freight rate manager

• US 8,725,656 B1
• Filed: 08/24/2001
• Issued: 05/13/2014
• Est. Priority Date: 05/18/2000
• Status: Active Grant

• Current Assignee: United Parcel Service Of America Incorporated (United Parcel Service Incorporated)
• Original Assignee: United Parcel Service Of America Incorporated (United Parcel Service Incorporated)
• Inventors: Gill, James M., Awaida, Antony A., Williams, Ian J. H.
• Primary Examiner(s): MCCORMICK, GABRIELLE A
• Application Number:
  US09/939,206
• Time in Patent Office: 4,645 Days
• Field of Search: 705/1
• US Class Current: 705/335
• CPC Class Codes: G06Q 10/101 Collaborative creation, e.g. joint development of products or services

Abstract

A freight rate manager provides rules for calculating freight rates for use in delivering real-time costing information. The freight rate manager includes a rate sheet input module for accepting data describing a rate sheet. A rate sheet analyzer analyzes the rate sheet to identify potential errors and compares the rate sheet against rate sheet templates. If a template matches the rate sheet, then the rate sheet analyzer interprets the rate sheet according to the template. If the rate sheet analyzer does not find a matching template, a communications module sends the rate sheet to another location or otherwise stores the rate sheet for analysis. An accessorial charges module accepts information about accessorial charges. The outputs of the rate sheet analyzer and the accessorial charges module are provided to a rule generator which generates rules for calculating freight rates given the rates in the rate sheet and the accessorial charges.

Claims

1. A system for processing data associated with a freight shipment, comprising:

one or more computer processors configured to;

execute a rate sheet input module capable of accepting a plurality of rate sheets wherein each rate sheet specifies published freight rates and each rate sheet is associated with one of a plurality of freight carriers and is respectively structured according to one of a plurality of formats, the rate sheet input module receiving and storing a rate sheet associated with a specific freight carrier of a plurality of freight carriers and structured according to a specific format of the plurality of formats;

execute a rate sheet analyzer module adapted to interface with a template storage module storing a plurality of templates, wherein a specific template of the plurality of templates is associated with the specific freight carrier and is structured according to the specific format of the plurality of formats to interpret the rate sheet, the rate sheet analyzer module producing an output by;

(a) selecting the specific template of the plurality of templates by matching the specific freight carrier associated with the rate sheet with the specific freight carrier associated with the specific template; and

(b) interpreting the rate sheet by applying the specific template to the rate sheet; and

execute a rule generation module, the rule generation module receiving the output from the rate sheet analyzer module and generating computer code based on the output, wherein when the code is executed, the code generates a freight charge associated with the freight carrier.

2. The system of claim 1 wherein the rate sheet is in a spreadsheet format.

3. The system of claim 1 wherein the rate sheet specifies zone- based rates.

4. The system of claim 1 wherein the system further comprises a user-interface module adapted to receive input from a user indicating the specific freight carrier associated with the rate sheet.

5. The system of claim 1 wherein the rate sheet analyzer module selects the specific template to interpret the rate sheet based on a keyword in the rate sheet.

6. The system of claim 5 wherein the keyword identifies the freight carrier.

7. The system of claim 5 wherein the selection of the specific template to interpret the rate sheet based on the keyword in the rate sheet is based on the location of the keyword in the rate sheet.

8. The system of claim 1 wherein the template storage module is in a remote location with respect to the rate sheet analyzer module.

9. The system of claim 8 further comprising:

the one or more computer processors configured to execute a communications module for communicating the rate sheet to the remote location, receiving the specific template adapted to interpret the received rate sheet, and providing the specific template to the template storage module.

10. The system of claim 5 further comprising the one or more computer processors configured to execute a tariffs module for calculating a tariff charge, the freight charge comprising the tariff charge.

11. The system of claim 10 further comprising the one or more computer processors configured to execute a compliance module for determining whether a proposed shipment of goods to a destination country complies with import regulations of the destination country.

12. The system of claim 1 further comprising the one or more computer processors configured to execute a logging module wherein the freight charge is stored in a file.

13. The system of claim 1 further comprising the one or more computer processors configured to execute a packaging module wherein the freight charge is determined based in part on a package weight calculation provided by the packaging module.

14. The system of claim 1 further comprising:

the one or more computer processors configured to execute an accessorial charge module for accepting data representative of accessorial charges associated with the freight rates and determining an accessorial charge wherein the freight charge comprises the accessorial charge.

15. A method of determining a charge associated with a freight shipment comprising:

receiving freight data associated with freight to be shipped;

receiving data representative of a rate sheet, the rate sheet specifying published freight rates associated with a freight carrier;

storing the rate sheet;

selecting a template from a template storage module, via one or more computer devices executing a rate sheet analyzer module, by matching a first freight carrier associated with the template with a freight carrier indicated in the rate sheet;

retrieving the template from the template storage module to interpret the rate sheet, the template storage module storing a plurality of templates wherein each template is adapted to respectively interpret a particular rate sheet;

producing output, via the one or more computer devices executing the rate sheet analyzer to interpret the rate sheet by applying the template to the rate sheet;

generating computer code based on the output via the one or more computer devices executing a rule generation module; and

generating a freight charge, via the one or more computer devices, by executing the computer code.

16. The method of claim 15 wherein the rate sheet is in a spreadsheet format.

17. The method of claim 15 wherein the rate sheet specifies zone- based rates.

18. The method of claim 15 further comprising:

receiving input from a user providing identifying information associated with the rate sheet.

19. The method of claim 18 wherein the rate sheet identifying information associated with the rate sheet identifies the freight carrier associated with the rate sheet.

20. The method of claim 16 wherein retrieving the template from the template storage module to interpret the rate sheet is based on a keyword in the rate sheet.

21. The method of claim 20 wherein the keyword identifies the freight carrier.

22. The method of claim 20 wherein retrieving the template from the template storage module to interpret the rate sheet is based on the location of the keyword in the rate sheet.

23. The method of claim 15 wherein the template storage module is in a remote location with respect to the rate sheet analyzer module.

24. The method of claim 23 further comprising the step of:

transmitting the rate sheet to the remote location; and

receiving an identifier associated with the rate sheet used by the rate sheet analyzer module to select the template.

25. The method of claim 15 further comprising:

receiving a second template for interpreting a second rate sheet; and

storing the second template in the template storage module.

26. The method of claim 15 further comprising:

accepting data representative of accessorial charges associated with the freight rates; and

generating the freight charge comprising an accessorial charge, via the one or more computer devices.

27. A computer-readable medium product containing code executable by a computer processor for determining a freight charge comprising computer- readable program instructions adapted for:

accepting a plurality of rate sheets associated with a plurality of carriers wherein each rate sheet specifies published freight rates and each rate sheet is respectively structured according to one of a plurality of formats;

receiving a specific rate sheet associated with a specific freight carrier and structured according to a specific format of the plurality of formats;

storing a plurality of templates wherein a specific template of the plurality of templates is adapted to interpret the specific rate sheet;

selecting the specific template of the plurality of templates to interpret the specific rate sheet by matching a first freight carrier associated with the specific template of the plurality of templates with the specific freight carrier associated with the specific rate sheet;

producing output by interpreting the specific rate sheet based on the specific template;

and

generating computer code based on the output, wherein when the code is executed, the code generates the freight charge associated with the freight carrier.

28. The computer-readable medium product of claim 27 wherein the specific rate sheet is in a spreadsheet format.

29. The computer-readable medium product of claim 27 wherein the specific rate sheet specifying zone-based rates.

30. The computer-readable medium product of claim 27 wherein the computer-readable program instructions are adapted for receiving input from a user to specify information about the specific rate sheet.

31. The computer-readable medium product of claim 28 where the computer-readable program instructions are adapted for selecting the template to interpret the specific rate sheet based on a keyword in the rate sheet.

32. The computer-readable medium product of claim 31 where the keyword identifies the freight carrier.

33. The computer-readable medium product of claim 28 where the selection of the specific template to interpret the specific rate sheet based on the keyword in the rate sheet is based on the location of the keyword in the rate sheet.

34. The computer-readable medium product module of claim 27 wherein the computer-readable program instructions are adapted for:

communicating the specific rate sheet to a remote system for analysis; and

receiving an indication from the remote system identifying the specific template to interpret the specific rate sheet.

35. The computer-readable medium product of claim 27 wherein the computer-readable program instructions are adapted for receiving the plurality of templates.

36. The computer-readable medium product of claim 27 wherein the computer-readable program instructions are adapted for accepting data representative of accessorial charges associated with the freight rates for generating an accessorial charge.

37. The computer-readable medium product of claim 36 wherein the computer-readable program instructions are adapted for calculating the freight charge comprising the accessorial charge.