Freight Shopping

We are working on building an application that would allow us to shop rates from our Shipping Vendors (UPS, Fed Ex, Expediters, etc.). We ship International by Air, Truck, Train and Cargo Ship.

This is being done to solve a Business process that makes it difficult to shop rates and find the best and most cost effective method to ship a product. Think of it like an Expedia type tool that would allow you to key in certain parameters and return a list of shipping options.

My question is has anyone done anything like this?

Are you using Agile or Insite, and if so do either of these offer this type of functionality?



See Deliverables below...

Simple Tool to calculate Shipping rates based on the following user nput.

Part Number
Quantity
From
To
Shipper (Optional)
Shipment Type (Optional)
Warehouse and Bin (Optional) - This is to support shipping all material that is located in a particular staging bin. If this is selected then Part and Qty are ignored.

Based on Selection Criteria tool should return the rates listed in order by lowest to highest cost.

The following Setup screens will be created in Epicor for managing Cost. Each Rate Maintenance Entry screen will have a "List" view that allow for copying and pasting from an excel spreadsheet.

Shipper Maintenance
Shipment Type Maintenance
Base Rate Maintenance
Fixed Rate Maintenance
Misc Rate Maintenance

Report Will Show the following Information
Shipper, Shipment Type, Base Rate Total, Fixed Rate Total, Misc Rate Total, Extended Total

Grouping By Shipper, Shipment Type

Sorted By Lowest Shipment Cost (ascending)