Calculate the daily cost of each destination

Reference no: EM133557797

It is important that you explain what you did and why you did it at each step, interpret your results and discuss the limitations of these results. The data for the project can be found below.

1. calculate the cost (pre-tax and destination fees) of each mode of touring to each destination based on the season (peak, shoulder, trough).

2. Calculate the daily cost of each destination, including the opportunity cost of the extra days associate with a cruise.

Project One Data

Important Notes

Cruise and Airplane Quotes are per passenger.
The All-Inclusive Quote is per two individuals.
Final Quotes and Comparison should be based on two individuals.
Individuals expect to spend five days across physical locations.
Individuals are leaving from the Quad Cities.
The All-Inclusive Quote includes flights/all transportation, accommodations, meals, and activities, and the trip is assumed to allow for five days at physical locations.

Alaska (Hubbard Glacier)

The only feasible way to see the Hubbard Glacier that does not involve dangerous overland or short-hop flights is via a cruise. Five-day excursions are round-trip from Vancouver, British Columbia. The cost of a high-quality cruise is:

Activity	Peak	Shoulder	Trough
Air Round-trip	$650	$600	$525
Cruise	$2,100	$1,750	$1400

Hawaii

Any high-quality cruise departs from Oahu and returns to Vancouver, British Columbia.

Due to sailing time, the cruise takes 11 days to allow for five days at physical locations.

Activity	Peak	Shoulder	Trough
Air - QCA to Oahu	$900	$600	$400
Air - Vancouver to QCA	$400	$350	$325
Cruise	$3,100	$2,250	$1,700
All-Inclusive	$8,700	$7,200	$6,500

Netherland Antilles

Any high-quality cruise will have a round-trip from Fort Lauderdale.

Due to sailing time, the cruise takes nine days to allow for five days at physical locations.

Activity	Peak	Shoulder	Trough
Air Round-trip	$550	$405	$350
Cruise	$2,170	$1,500	$1,060
All-Inclusive	$7,200	$6,200	$4,600

Western Caribbean

Any high-quality cruise will have a round-trip from Fort Lauderdale.

Due to sailing time, the cruise takes nine days to allow for five days at physical locations.

Activity	Peak	Shoulder	Trough
Air Round-trip	$550	$405	$350
Cruise	$2,300	$1,780	$950
All-Inclusive	$6,900	$5,900	$4,000

Opportunity Cost

Each individual has a daily opportunity cost of $200 for every day beyond the planned five-day excursion.

Reference no: EM133557797

Questions Cloud

How does their point of view affect your understanding : Identify the author's point of view. How does their point of view affect your understanding of the text? Briefly explain.

State the net cash position with and without : State the net cash position with and without the put protection, if the spot price of copper in 3 months' time turned out to be:

Discuss the use of satire in candide : Discuss the use of satire in Candide. How does Voltaire highlight injustices in the 18th century? Is this effective? Explain. Base your analysis on the themes

Identify the risks and thoroughly explain their causes : PAD 645- Identify these risks and thoroughly explain their causes. Explain the barrier that may be faced in dealing with the risks and justify ultimate benefit.

Calculate the daily cost of each destination : Calculate the daily cost of each destination, including the opportunity cost of the extra days associate with a cruise

Explain how financial intermediaries reduce transaction : Explain how financial intermediaries reduce transaction costs thereby allowing small savers and borrowers to benefit from the existence of financial markets.

Explain how each poem works, what each poem message is : explain how each poem works, what each poem's message is, and how the form and/or language help along this message. In other words, how does one poem present

What type of order would you place for this particular : What price would you face a 30% maintenance margin call? Explain based on your rationale, why would you consider shorting Qantas stocks

Compare the income statements of two different companies : Compare the Income Statements of two different companies in the same industry Target and Walmart 2. Identify any significant differences

User Account

All Pages