Method of calculating and displaying premium freight costs

A method for calculating and displaying premium freight costs, the method comprising:

• providing a first database containing shipment data comprising date, cost, weight, source, origin and destination;
• providing a second database containing a source optimality table comprising data regarding at least a first shipping mode and a second shipping mode;
• receiving, by a computer system, a selection of a time period of interest;
• selecting, by the computer system, all shipments occurring within the selected time period and indexing the shipments into a list;
• for each shipment in the list, evaluating by the computer system whether the shipment was delivered from the optimal source, and when a non-optimal source was used, calculating, by the computer system, a source premium freight cost;
• when the source premium freight cost is not negative, adding, by the computer system, the source premium freight cost to a lane for the non-optimal source;
• for each shipment delivered from the optimal source, evaluating by the computer system whether the shipment was delivered by an optimal carrier, and when a non-optimal carrier was used, calculating, by the computer system, a carrier premium freight cost;
• when the carrier premium freight cost is not negative, adding, by the computer system, the carrier premium freight cost to a lane for the non-optimal carrier;
• displaying each of the source premium freight cost and the carrier premium freight cost by lane on a computer screen.

A system, comprising:

• a first database containing shipment data comprising date, cost, weight, mode, origin and destination;
• a second database containing a mode optimality table comprising data regarding at least a first shipping mode and a second shipping mode;
• a computer screen;
• a computer processor;
• a computer readable medium having stored thereon instructions which, when executed by a processor, cause the processor to:
• select all shipments occurring within a selected time period and index the shipments into a list;
• for each shipment in the list, evaluate whether the shipment was delivered in the optimal mode, and when a non-optimal mode was used, calculating a mode premium freight cost;
• when the mode premium freight cost is not negative, add the premium freight cost to a lane for the non-optimal mode;
• and
• for each shipment delivered from the optimal mode, evaluate whether the shipment was delivered from an optimal source, and when a non-optimal source was used, calculating a source premium freight cost;
• when the source premium freight cost is not negative, adding the source premium freight cost to a lane for the non-optimal source;
• display each of the mode premium freight cost and source premium freight cost by lane on the computer screen.