Required Refer to the GCB400 Sample Invoices from Expedia, RCI, NCL ExcerptsJuly2021 CGM that are under Course Documents, and Assignment 1 Please answer the following questions Make sure you include the applicable currency as well as the proper full monetary amount (Dollars and cents) Part A Refer to Invoice 500042 2021 00197 Marks 161 How much is the balance due for Invoice 5000042 2021 00197 issued by ExpediaCruises 2 Expedia Cruises receives 16 Commission with Royal Caribbean Calculate the commission earned on the cruise fare if the commission is 16 3 Name the accommodation category, and stateroom number on the ship 4 List the countries that are the ports of call on this itinerary (1 mark)5 How many day days at sea are there 6 List the discount names with the applicable amounts and the total that this client has received from RCI 7 The Insurance quote from Manulife World Travel Insurance is $307 75, plus$24 62 for the Harmonized Sales Tax, for a total of $332 37 How much commission would Expedia make if the rate were 46 8 Calculate the total amount of commission Expedia will make if the insurance is included for this reservation Part B Refer to RCI Booking Confirmation Guest How much is the daily gratuity charge that will be applied onboard if not prepaid 2 How much are the taxes, fees, and port charges 3 What is the charge for the prepaid gratuities Part C Refer to NCL Confirmation Guest Copy How much is the onboard credit per cabin 2 How much is the base guest cruise fare before the discount savings and additional charges 3 Calculate the commission due to Expedia if the rate is 16 Part D Commission Calculation Application You are a commissioned based TTANT Independent How much commission would you earn if you sold Around the World Cruise Fare which was commissionable at 18 The Cruise fare that is commissionable is $249,999 00 Canadian per person based on double occupancy, and you would only receive 50 of the commission since TTANT would share the 50 of total amount How much would you earn after TTANT received their 50 commission TRAVEL AGENT CONTACT NCL INVOICE DATE 9 Jul ZUZI EXPEDIA CRUISES 500042 (181849) BOOKING DATE 9 Jul 2021 4559 HURONTARIO STREET UNIT A 8B MISSISSAUGA, ON L4Z 3L9 CA NORWEGIAN RESERVATION FS GROUP ATTN WALKER CHERYL CRUISE LINE PROMO CODES AFBDSIOC DISC30 EASYFARE SOOI GAPOOO GROUP DEPOSIT B PPSRVCHG SHX50 CONFIRMATION GUEST COPY SHIP NORWEGIAN DAWN SAILING 14 May 2023 to 24 May 2023 CATEGORY STATEROOM MA 11598 ITINERARY 10 DAY BRITISH ISLES ROUND TRIP LONDON ENGLAND, IRELAND SCOTLAND EMBARKATION SOUTHAMPTON LONDON DISEMBARKATION SOUTHAMPTON LONDON CLIENT BOOKSAFE GUESTS AGE LATITUDES AIR CITY HOTEL TRAVEL PROTECTION 68 259367304 NO BOOKING COMPONENTS PER GUEST IN CAD Total Guest 1 Guest Fare 9,284 12 9,264 13 Gov Tax Port Exp Fees 347 38 347 38 Savings 1,758 3 1,758 3 Bev Siv Charge 247 50 247 50 Din Srv Charge 24 75 24 75 Prepaid Service Charges 193 75 193 75 Gross Total 8,319 12 8,319 15 PAYMENTS AMOUNT (CAD) PAYMENT SCHEDULE SECOND DEPOSIT due on 16 Jul 2021 11 59 pm Eastern Time 156 25 FINAL PAYMENT due on 14 Jan 2023 11 59 pm Eastern Time 8,162 88 PAYMENTS APPLIED PAID by AMEX on 9 Jul 2021 67 00 TOTAL PAYMENTS APPLIED 67 00 Balance Due on 14 Jan 2023 11 69 pm Eastern Time 3, 152 13 Reduced Deposit promotions do not apply to Concierge, Suites and Haven categories For an upgrade into a Concierge, Suite or Haven, full deposit is due immediately Add ons 1 x Shore Excursion Discount 1 x Prepaid Service Charge ULTIMATE B 1 x $100 PER CABIN ONBOARD CREDIT 1 x INTERNET 250 MINUTES PER STATEROOM ING PACKA Cancellation Fee Schedule can be reviewed at http www nick com about cancellation fee schedule IMPORTANT INFORMATION Norwegian Cruise Line recommends for all guests to follow, and where possible, sign up for notifications from their local government on international travel regulations that may prevent, restrict or require additional documentation when travelling to another country for embarkation or during their cruise All cancellation requests received by Norwegian are subject to terms and conditions, restrictions may apply Page

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 29, 2024

Required: Refer to the GCB400 Sample Invoices from Expedia, RCI, NCL ExcerptsJuly2021 CGM that are under Course Documents, and Assignment #1. Please answer the following

Required: Refer to the GCB400 Sample Invoices from Expedia, RCI, NCL ExcerptsJuly2021 CGM that are under Course Documents, and Assignment #1. Please answer the following questions. Make sure you include the applicable currency as well as the proper full monetary amount. (Dollars and cents)

Part A:

Refer to Invoice # 500042-2021-00197 Marks: 161. How much is the balance due for Invoice #5000042-2021-00197 issued by ExpediaCruises?

2. Expedia Cruises receives 16% Commission with Royal Caribbean. Calculate the commission earned on the cruise fare if the commission is 16%

3. Name the accommodation category, and stateroom number on the ship?

4. List the countries that are the ports of call on this itinerary. (1 mark)5. How many day/days at sea are there? 6. List the discount names with the applicable amounts and the total that this client has received from RCI.

7. The Insurance quote from Manulife World Travel Insurance is $307.75, plus$24.62 for the Harmonized Sales Tax, for a total of $332.37. How much commission would Expedia make if the rate were 46%?

8. Calculate the total amount of commission Expedia will make if the insurance is included for this reservation.

Part B: Refer to RCI Booking Confirmation - Guest

How much is the daily gratuity charge that will be applied onboard if not prepaid?

2. How much are the taxes, fees, and port charges?

3. What is the charge for the prepaid gratuities?

Part C: Refer to NCL Confirmation Guest Copy

How much is the onboard credit per cabin?

2. How much is the base guest cruise fare before the discount savings and additional charges?

3. Calculate the commission due to Expedia if the rate is 16%.

Part D: Commission Calculation Application

You are a commissioned based TTANT Independent. How much commission would you earn if you sold "Around the World Cruise Fare" which was commissionable at 18%. The Cruise fare that is commissionable is $249,999.00 Canadian per person based on double occupancy, and you would only receive 50% of the commission since TTANT would share the 50% of total amount. How much would you earn after TTANT received their 50% commission?

TRAVEL AGENT/CONTACT NCL INVOICE DATE: 9-Jul-ZUZI EXPEDIA CRUISES #500042 (181849) BOOKING DATE: 9-Jul-2021 4559 HURONTARIO STREET UNIT A-8B MISSISSAUGA, ON L4Z 3L9 CA NORWEGIAN RESERVATION: FS GROUP: ATTN: WALKER CHERYL CRUISE LINE PROMO CODES: AFBDSIOC DISC30 EASYFARE SOOI GAPOOO GROUP DEPOSIT B PPSRVCHG SHX50 CONFIRMATION GUEST COPY SHIP: NORWEGIAN DAWN SAILING: 14-May-2023 to 24-May-2023 CATEGORY / STATEROOM: MA / 11598 ITINERARY: 10-DAY BRITISH ISLES ROUND-TRIP LONDON: ENGLAND, IRELAND & SCOTLAND EMBARKATION: SOUTHAMPTON LONDON DISEMBARKATION: SOUTHAMPTON LONDON CLIENT / BOOKSAFE GUESTS AGE LATITUDES AIR CITY HOTEL TRAVEL PROTECTION 68 259367304 NO BOOKING COMPONENTS PER GUEST IN CAD Total Guest 1 Guest Fare 9,284.12 9,264.13 Gov Tax/Port Exp/Fees 347.38 347.38 Savings 1,758.3 1,758.3 Bev Siv Charge 247.50 247.50 Din Srv Charge 24.75 24.75 Prepaid Service Charges 193.75 193.75 Gross Total 8,319.12 8,319.15 PAYMENTS AMOUNT (CAD) PAYMENT SCHEDULE SECOND DEPOSIT due on 16-Jul-2021 11:59 pm Eastern Time 156.25 FINAL PAYMENT due on 14-Jan-2023 11:59 pm Eastern Time 8,162.88 PAYMENTS APPLIED PAID by AMEX# on 9-Jul-2021 67.00 TOTAL PAYMENTS APPLIED 67.00 Balance Due on 14-Jan-2023 11:69 pm Eastern Time 3, 152.13 Reduced Deposit promotions do not apply to Concierge, Suites and Haven categories. For an upgrade into a Concierge, Suite or Haven, full deposit is due immediately. Add-ons: 1 x Shore Excursion Discount 1 x Prepaid Service Charge ULTIMATE B 1 x $100 PER CABIN ONBOARD CREDIT 1 x INTERNET 250 MINUTES PER STATEROOM ING PACKA Cancellation Fee Schedule can be reviewed at http://www.nick.com/about/cancellation-fee-schedule. *IMPORTANT INFORMATION Norwegian Cruise Line recommends for all guests to follow, and where possible, sign up for notifications from their local government on international travel regulations that may prevent, restrict or require additional documentation when travelling to another country for embarkation or during their cruise. All cancellation requests received by Norwegian are subject to terms and conditions, restrictions may apply. Page