You are a Toronto based tour operator with a series of flights starting up from Vancouver to Montego Bay, Jamaica. The charter will operate every Sunday and the duration of your package is 7 nights. The aircraft has 179 seats and the anticipated load factor is 81%. The first rotation is Nov 06, 2022, and the last flight rotation is on April 30, 2023. Operating costs are $100,000 for each live/live and $85,000 for rotations with a ferry portion. Air taxes per person are $220. The hotel has a rate of $121 per person per night plus $12 per person per night for hotel taxes, charges and service fees. Transfer (airport to hotel return) per person is $46. Credit card fees are high, so we need to cost them in at $6. 00 per person “below the line” (non-commissionable). Travel Agent commission is 8%. Find:- 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 = ?
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 Vancouver to Montego Bay, Jamaica.
- The charter will operate every Sunday and the duration of your package is 7 nights. The aircraft has 179 seats and the anticipated load factor is 81%.
- The first rotation is Nov 06, 2022, and the last flight rotation is on April 30, 2023.
- Operating costs are $100,000 for each live/live and $85,000 for rotations with a ferry portion.
- Air taxes per person are $220.
- The hotel has a rate of $121 per person per night plus $12 per person per night for hotel taxes, charges and service fees.
- Transfer (airport to hotel return) per person is $46.
- Credit card fees are high, so we need to cost them in at $6. 00 per person “below the line” (non-commissionable).
- Travel Agent commission is 8%.
Find:-
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 = ?
Note:-
All Answers Needed in Soft Form & Don*T Copy From others.
4. Margin Calculation:
|
Net Margin amount pp = $ Final Net Selling Price PP = $ |
|
5. Retail (Travel Agent) Commission Calculation:
|
Commission amount pp = $ Final Gross Selling Price PP $ |
|
6. Tax and Service Charges Calculation:
|
Final Tax, fees and service charges total Amount PP= $ |
|
Final Gross Selling Price PP = $ Final T&SC PP = $ |
NOTE:
NEED PART 4,5 & 6 ONLY ,I uploaded part a,b,c solved for Refrences
![This assignment is to be completed on an individual basis. Do not work in a group or with a partner.
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 Vancouver to Montego
Bay, Jamaica.
The charter will operate every Sunday and the duration of your package is 7 nights. The aircraft has 179
seats and the anticipated load factor is 81%.
➤ The first rotation is Nov 06, 2022, and the last flight rotation is on April 30, 2023.
Operating costs are $100,000 for each live/live and $85,000 for rotations with a ferry portion.
➤ Air taxes per person are $220.
The hotel has a rate of $121 per person per night plus $12 per person per night for hotel taxes, charges
and service fees.
Transfer (airport to hotel return) per person is $46.
Credit card fees are high, so we need to cost them in at $6.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 16% margin. Add lines as you need them. Submit under Costing Assignment in
Assignments folder in our Course site.
fi](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F964ac0ad-9641-4652-97f7-fd49279ce9f7%2F8a934e16-f67d-4ec5-91d1-671e4938cc53%2Fxuzpl_processed.jpeg&w=3840&q=75)
![1. Air Cost Calculation:
Total number of passengers Air tax per person
= 144.99 passengers (179*81%) * $220
= $31,897.8
Net Air Cost pp = $31,897.8||
Costing Calculations
2. Hotel Cost Calculation:
= Total number of passengers * Hotel charges
= 144.99 passengers (179*81%) * ( $121 + $12)
= $19,283.67
Net Accommodation Cost pp = $ 19,283.67
3. Transfer Cost Calculation:
= Total number of passengers * Transfer Charges per person
= 144.99 passengers (179*81%) * $46
= $6,669.54](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F964ac0ad-9641-4652-97f7-fd49279ce9f7%2F8a934e16-f67d-4ec5-91d1-671e4938cc53%2Fxoln66k_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Final T&SC PP = $ ? where answer for this.?
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)