Dont use Excel

Dr. M's Sport Instruments now needs to forecast the demand for the 2015 season. Below is the data for the 2013 and 2014 seasons respectively. The data exhibits trend and seasonality. Determine a - d below. USE 4 SIGNIFICANT digits. Use Tau = 4; N = 4 to find a, . Beta Alpha [ Select] [ Select ] d Gamma [Select] [ Select] Forecast G+ St Demand Time (t) Year Quarter 120 Ct 0.7385 0.4923 0.9231 2013 1 1 80 2 2013 2 3 150 2013 3 1.8462 0.0000 300 4 2013 4 4.3333 0.7515 162.5000 184.1667 222.7875 160 5 2014 1 11.1908 0.5037 135 6 2014 2 10.6726 0.9215 231.3870 210 7 2014 3 10.8078 1.8469 242.7357 450 8 2014 4 [d] 1 2015 9 Dr. M's Sport Instruments now needs to forecast the demand for the 2015 season. Below is the data for the 2013 and 2014 seasons respectively. The data exhibits trend and seasonality. Determine a - d below. USE 4 SIGNIFICANT digits. Use Tau = 4; N = 4 to find a, . Beta Alpha [ Select] [ Select ] d Gamma [Select] [ Select] Forecast G+ St Demand Time (t) Year Quarter 120 Ct 0.7385 0.4923 0.9231 2013 1 1 80 2 2013 2 3 150 2013 3 1.8462 0.0000 300 4 2013 4 4.3333 0.7515 162.5000 184.1667 222.7875 160 5 2014 1 11.1908 0.5037 135 6 2014 2 10.6726 0.9215 231.3870 210 7 2014 3 10.8078 1.8469 242.7357 450 8 2014 4 [d] 1 2015 9