Compute the ocean and air freight costs with the dimensional information provided. You must clearly show your work and the logic for arriving at your answer in an Excel spreadsheet.
Origin: Omaha, NE.
Destination: Barcelona, Spain
Dimensions: Each pallet is 42”x42”x 30”
Weight: 600 pounds per pallet
We are shipping 3 pallets
The product is ceramic industrial water knobs
Rates:
Air:
$4.00/kilo with a $100 minimum per bill of lading the dimensional factor is 166
Ocean:
$50 weight/measure (1000 kilos or cubic meters)
Minimum is $100 per bill of lading
C.A.F. is 30%
B.S.C. is $5 weight/measure or minimum of $5 per shipment
Forwarding and Documentation Fees:
Air is $125 per bill of lading
Ocean is $150 per bill of lading