1. 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).

I just need to know how to calculate in Excel - the text book is not providing a clear equation and now my anxiety is so high I can't make heads or tails of it.