INTL704-Mod-10-ActivityAirFreightConsolidation12.docx

INTL 704 CENTENNIAL COLLEGE Global Logistics

INTL 704

Course Name:

Global Logistics

Module 10: Activity: Calculating Air Freight Charges

In this activity you will consolidate air freight, calculate air freight charges, and complete an air waybill.

Your company offers a weekly consolidation service to Sao Paulo Brazil (GRT), via Air Canada (AC). The carrier has given you a +500 kg buying rate of CAN $1.70/kg and a +1,000 kg buying rate of CAN $1.20/kg. You sell this service to clients who ship +500 kg at a rate of CAN $2.50/kg and for clients who ship +1,000 kg at a rate of CAN $2.20/kg. This is an all–in rate, no additional charges.

Shipment #1

Shipment #2

Shipper:

Pella Windows Co. Ltd.

123 Bloor Ave.

Toronto, ON, Canada, M5H 3K5

Buyer:

Joao’s Windows, 234 Rio de Janeiro, Brazil

Shipment: 30 tempered glass thermo-sealed windows

Total weight: 550 kg

Dimensions of each sheet: 250 cm x 70 cm x 5 cm

Total value: CAN $17,000.00

Goods sold: collect

Shipper:

Canada Goose Canada Ltd. 456 Avenue Road, Toronto, ON, Canada, K2S 1R2

Buyer:

Canada Goose (Brazil) Ltd.,132-0023, Sao Paolo, Brazil

Shipment: 100 boxes of Canada Goose Parkas

Total weight: 200 kg

Dimensions of each box: 20 in x 20 in x 20 in

Total value: CAN $50,000.00

Goods sold: collect

1. Based on the information provided above and using the TACT rate table below, calculate the air freight charges for those shipments. (use Exercise 10.1 for guidance)

a. What is the total actual weight of the consolidation?

b. What is the total volume weight of the consolidation?

c. How much will you charge each customer?

d. How much will you pay the air carrier?

e. What is the gross profit on this shipment?

2. Based on your answers and the above information:

a. Prepare the 2 house air waybills (HAWB)

b. Prepare a master air waybill for the consolidation

c. Prepare the shipment manifest.

TACT Rates:TORONTO

Currency: CAD$

CA

YTO

Weight: kg

To Brazil

Via Air Freight

Weight (kg)

Minimum

Nominal (<45)

TACT Rate ($/kg)

$150.00

11.84

+45

6.62

+100

5.67

+300

5.08

+500

4.64

+1000

FCL (ULD) Rates:

4.10

/H 0660

1051

7355.00

/H 0661

1051

6897.00

/H 0662

1051

8156.00

Shipper’s Name and Address

Shipper’s Account Number

Not negotiable

Air Waybill: 125-7654

Issued by: JAPAN AIRLINES

_________________________________________________________________

Copies 1, 2, ands 3 of this Air Waybill are originals and have the same validity.

CIFFA Forwarder

480-170 Attwell Dr.

Toronto, ON, , M9W 5Z5, Canada

It is agreed that the goods described herein are accepted in apparent good order and condition (except as noted) for carriage SUBJECT TO THE CONDITIONS OF CONTRACT ON THE REVERSE HEREOF. THE SHIPPER’S ATTENTION IS DRAWN TO THE

NOTICE CONCERNING CARRIER’S LIMITATION OF LIABILITY. Shipper may increase such limitations of liability by declaring a higher value for carriage and paying a supplemental charge if required.

Consignee’s Name and Address

Consignee’s Account Number

CIFFA Forwarder’s Agent

12 Pall Mall

Narita, Japan

Issuing Carrier’s Agent Name and City

Accounting Information

Agent’s IATA Code

Account No.

Airport of Departure (Address of First Carrier) and Requested Routing

To

By First Carrier

Routing and

To

By

To

By

Currency

CHGS

Code

WT/VAL

Other

Declared

Value for

Carriage

Declared

Value for Customs

$

Destination

Airport of Destination

Flight/Date

For Carrier Use Only

Flight/Date

Amount of

Insurance

INSURANCE – If carrier offers insurance, and such Insurance is requested in accordance with the conditions thereof, indicate amount to be insured in figures in box marked “Amount of Insurance.”

Handling Information:

SCI

No. of

Pieces

RCP

Gross Weight

kg/lb

Rate Class

Chargeabl Weight

e

Rate/Charge

Total

Nature and Quantity of Goods

(incl. Dimensions or Volume)

Commodity Item No.

Prepaid

Weight Charge

Collect

Other Charges

Valuation Charge

Tax

Total Other Charges Due Agent

Shipper certifies that the particulars on the face hereof are correct and that insofar as any part of the consignment contains dangerous goods, such part is properly described by name and is in proper condition for carriage by air according to the applicable Dangerous Goods Regulations.

Signature of Shipper or his Agent

Total Other Charges Due Carrier

Total Prepaid

Total Collect

Currency Conversion Rates

CC Charges in Destination Currency

Executed on (Date)at (Place) Signature of Issuing Carrier or its Agent

Shipper’s Name and Address

Shipper’s Account Number

Not negotiable

Air Waybill: AX-0912-001

Issued by:

_________________________________________________________________

Copies 1, 2, ands 3 of this Air Waybill are originals and have the same validity.

It is agreed that the goods described herein are accepted in apparent good order and condition (except as noted) for carriage SUBJECT TO THE CONDITIONS OF CONTRACT ON THE REVERSE HEREOF. THE SHIPPER’S ATTENTION IS DRAWN TO THE NOTICE CONCERNING CARRIER’S LIMITATION OF LIABILITY. Shipper may increase such limitations of liability by declaring a higher value for carriage and paying a supplemental charge if required.

Consignee’s Name and Address

Consignee’s Account Number

Issuing Carrier’s Agent Name and City

Accounting Information

Agent’s IATA Code

Account No.

Airport of Departure (Address of First Carrier) and Requested Routing

To

By First Carrier

Routing and

To

By

To

By

Currency

CHGS Code

WT/VAL

Other

Declared

Value for

Carriage

Declared

Value for

Customs

$

Destination

Airport of Destination

Flight/Date

For Carrier Use Only

Flight/Date

Amount of

Insurance

INSURANCE – If carrier offers insurance, and such Insurance is requested in accordance with the conditions thereof, indicate amount to be insured in figures in box marked “Amount of Insurance.”

Handling Information:

SCI

No. of

Pieces

RCP

Gross Weight

kg/lb

Rate Class

Chargeabl Weight

e

Rate/Charge

Total

Nature and Quantity of Goods

Commodity Item No.

(incl. Dimensions or Volume)

Prepaid

Weight Charge

Collect

Other Charges

Valuation Charge

Tax

Total Other Charges Due Agent

Shipper certifies that the particulars on the face hereof are correct and that insofar as any part of the consignment contains dangerous goods, such part is properly described by name and is in proper condition for carriage by air according to the applicable Dangerous Goods Regulations.

Signature of Shipper or his Agent

Total Other Charges Due Carrier

Total Prepaid

Total Collect

Currency Conversion Rates

CC Charges in Destination Currency

Executed on (Date)at (Place) Signature of Issuing Carrier or its Agent

Shipper’s Name and Address

Shipper’s Account Number

Not negotiable

Air Waybill: AX-0912-002

Issued by:

_________________________________________________________________

Copies 1, 2, ands 3 of this Air Waybill are originals and have the same validity.

It is agreed that the goods described herein are accepted in apparent good order and condition

(except as noted) for carriage SUBJECT TO THE CONDITIONS OF CONTRACT ON THE

REVERSE HEREOF. THE SHIPPER’S ATTENTION IS DRAWN TO THE NOTICE CONCERNING CARRIER’S LIMITATION OF LIABILITY. Shipper may increase such limitations of liability by declaring a higher value for carriage and paying a supplemental charge if required.

Consignee’s Name and Address

Consignee’s Account Number

Issuing Carrier’s Agent Name and City

Accounting Information

Agent’s IATA Code

Account No.

Airport of Departure (Address of First Carrier) and Requested Routing

To

By First Carrier

Routing and Destination

To

By

To

By

Currency

CHGS

Code

WT/VAL

Other

Declared Value for Carriage

Declared Value for Customs

$

Airport of Destination

Flight/Date

For Carrier Use Only

Flight/Date

Amount of

Insurance

INSURANCE – If carrier offers insurance, and such Insurance is requested in accordance with the conditions thereof, indicate amount to be insured in figures in box marked “Amount of Insurance.”

Handling Information:

SCI

No. of

Pieces

RCP

Gross Weight

kg/lb

Rate Class

Chargeable Weight

Rate/Charge

Total

Nature and Quantity of Goods

Commodity Item No.

(incl. Dimensions or Volume)

Prepaid

Weight Charge

Collect

Other Charges

Valuation Charge

Tax

Total Other Charges Due Agent

Shipper certifies that the particulars on the face hereof are correct and that insofar as any part of the consignment contains dangerous goods, such part is properly described by name and is in proper condition for carriage by air according to the applicable Dangerous Goods Regulations.

Signature of Shipper or his Agent

Total Other Charges Due Carrier

Total Prepaid

Total Collect

Currency Conversion Rates

CC Charges in Destination Currency

Executed on (Date)at (Place) Signature of Issuing Carrier or its Agent

CARGO MANIFEST FOR MAWB:

Date:

Flight:

Departure:

Destination:

Agent at Destination:

Shipper

Consignee

Pieces

Gross Weight

Nature of Goods

POR#

Total Pieces:

Total Gross Weight:

Total HAWB:

Declared by:

Signed by:

© 2020 CENTENNIALCOLLEGE.CA All rights reserved. 1

© 2020 CENTENNIALCOLLEGE.CA All rights reserved. 6

image1.jpg

Our customer support team is here to answer your questions. Ask us anything!