Costing details to use for the assignment, all are Canadian dollars-

#You are a Toronto based tour operator with a series of flights starting up from Halifax to St. Lucia

#The charter will operate every Thursday and the duration of your package is 7 nights. The aircraft has 182 seats and the anticipated load factor is 87%.

# The first rotation is Nov 04, 2021 and the last flight rotation is on April 28, 2022.

#Operating costs are $69,000 for each live/live and $60,000 for rotations with a ferry portion.

# Air taxes per person are $178.

# The hotel has a rate of $96 per person per night plus $15 per person per night for hotel taxes, charges and service fees.

# Transfer (airport to hotel return) per person is $38.

#Credit card fees are high so we need to cost them in at $7. 00 per person "below the line" (non-commissionable).

#Travel Agent commission is 8%.

On the Costing Calculation page below, outline each formula in your calculation, provide a costing amount for each section including the final gross selling price per person for a one-week package based on double occupancy including a 21% margin. Add lines as you need them.

Costing Calculations

1) a. Air Cost Calculation

b Hotel Cost Calculation

c. Transfer Cost Calculation

d. Margin Calculation (Net Margin amount pp = Add PP net costs and margin to get - Final Net Selling Price PP = $ )

e. Retail (Travel Agent) Commission Calculation ( Commission amount pp = Add Final Net Selling Price PP to get - Final Gross Selling Price PP )

F. Tax and Service Charges Calculation(Final Gross Selling Price PP = ? Final T&SC PP = ?