Description:
The Transportation Costing Analysis V 2.4 Excel spreadsheet described here will provide a complete and comprehensive costing analysis for most of your freight and customs brokerage requirements.
Once all the pertinent freight rates and information is entered into the allocated locations, this spreadsheet will cut hours of tedious manual calculations and guess work.
The calculations will provide the landed costs for the following types of freight movement:
- LTL Truck - Direct and Consolidation
- FTL Truck - Direct and Consolidation
- Air Freight Movement
- Ocean Freight Movement
- Domestic Land Transportation
Each of the above will include the fees for the customs brokerage, duty and GST will be presented. (Excluding domestic transportation)
Every calculation will include the following details:
- Transit times from point of origin to destination.
- Carrier, supplier, and customs broker contact information.
For added convenience and ease of use, each calculation will also include:
- Dimensional weight versus actual weight costs.
- Actual costs versus "rounded up" costs for comparison.
- GST represented separately for use with your tax returns.