LEARN MORE...

Cruise Case Study Questions.edited

Content type

User Generated

Subject

Management

School

university of the people

Type

Homework

Uploaded By

fgneqbanyq96

Pages

Showing Page:

1/6

CRUISE CASE STUDY QUESTIONS

Student’s Name

Department, Institutional Affiliation

Course Name

Instructor’s Name

Submission Date

Showing Page:

2/6

CRUISE CASE STUDY QUESTIONS

CHAPTER 8

Question One

The excel sheet attached from North America Cruise Data provides all the necessary

information and statistics required to predict the aggregate demand for cruises within the

industry and various regions. The demand prediction is calculated using a derived formula and a

linear regression chart. The forecast assumes that the company has a 5.5% capture of industry

capacity (CII) (Cruise International). With all regions consolidated, the company's data up to

2012 from 2004 was used to make the forecast.

Question Two:

Memo Explaining the Forecast Results

MEMO

To: Cruise International

From: Forecasting Analysts

Date:02/02/2021

Re: Forecast Techniques, Selection Basis, and Forecast Reliability.

Forecast Techniques

The forecasting project was finally completed, and the technique deployed in the project

was the Average Moving Technique, which was conducted for two years. This technique is very

suitable for long-term forecasting as the project's case gives the general pattern of data set trends.

Showing Page:

3/6

End of Preview - Want to read all 6 pages?

Access Now

Unformatted Attachment Preview

1 CRUISE CASE STUDY QUESTIONS Student’s Name Department, Institutional Affiliation Course Name Instructor’s Name Submission Date 2 CRUISE CASE STUDY QUESTIONS CHAPTER 8 Question One The excel sheet attached from North America Cruise Data provides all the necessary information and statistics required to predict the aggregate demand for cruises within the industry and various regions. The demand prediction is calculated using a derived formula and a linear regression chart. The forecast assumes that the company has a 5.5% capture of industry capacity (CII) (Cruise International). With all regions consolidated, the company's data up to 2012 from 2004 was used to make the forecast. Question Two: Memo Explaining the Forecast Results MEMO To: Cruise International From: Forecasting Analysts Date:02/02/2021 Re: Forecast Techniques, Selection Basis, and Forecast Reliability. Forecast Techniques The forecasting project was finally completed, and the technique deployed in the project was the Average Moving Technique, which was conducted for two years. This technique is very suitable for long-term forecasting as the project's case gives the general pattern of data set trends. 3 However, the method only uses sample data, so the results do not represent every data but rather provide the general pattern trend. Basis for Selection The Average Moving Technique was selected as it is very suitable for establishing trends of long-term data in your company data. Additionally, the tech ...
Purchase document to see full attachment

Tags: excel sheet Cruise International Forecast Results Selection Basis Forecast Reliability