Forecasting at Cruise International, Inc.

Forecasting at Cruise International, Inc. Use the provided North American Cruise Data spreadsheet for the next two questions.
• Develop a forecast of the demand for cruises the year beyond the last data time period both in aggregate demand for the entire industry and also by different regions. If Cruise International Inc. (CII) captures 5.5% of industry capacity, develop forecasts for CII from spreadsheet. Write up and justify the range of historical data used for forecasting and any consolidation of regions. (Learning Objective 3.1).

• Present your results in a memo that explains the forecasting technique used and the basis for its selection, and also illustrates the reliability of your forecast using linear regression chart and derived formula. (Learning Objective 3.1