Purpose Develop experience in forecasting using simple analysis and judgmental methods for the Wilkins Demand Forecasting project. The Wilkins Demand Forecasting case can be purchased from Harvard Business Cases using the link in Canvas. Note that while we are using the case, the deliverables are defined in the assignment document. The Chapter 10 analysis can he performed using Microsoft Excel. T e W Wilkins Demand Forecasting is an individual project. Requirements 1. Utilize the Excel Judgments] Forecasting Template in Canvas. 2. The analysis will use observations through 2004. The forecasts and forecast accuracy will be estimated using 2005 Q1. 3. Compute the individual product shares of the product line for each year and quarter. 4. Compute individual product share percentages of the product line as follows. 3. Average the product shares of the product line across all observations. b. Average the product shares of the product line for Q1 observations. c. Compute the growth rates in each product and the product line using Q1 observations. 5. Develop a forecast for each product and the product line using: a. Individual growth rates b. Product line growth rates and the average product market shares. 6. Compute forecast errors for: a. Individual growth rates In. Product line growth rates and the average product market shares. T. After analyzing the data and reviewing the case determine whether you prefer one of the analytical forecasts, the forecast in the case in Exhibits 1, 3, and 4 using the Plan Bill '34:, or an alternative forecast using your judgement