Honeywell Bakery has been offering a new vegan cupcake and wantsto know the demand in the future. For the past six weeks, thedemand has been 60 cupcakes, 55 cupcakes, 75 cupcakes, 60 cupcakes,80 cupcakes, and 75 cupcakes respectively. 1. a) Using a simplefour-week moving average, calculate a forecast for next week. (4points) b) If the forecast for week 6 was 85 cupcakes, then usingsingle exponential smoothing with ?=0.2, calculate a forecast fornext week. (4 points) 2. a) Using simple linear regression,calculate the trend line for the historical data. X- Axis shouldrepresent the period (e.g. week 1 = 1, week 2 = 2, and so on),while the ? axis is demand. (12 points) b) Calculate a forecast fornext week. Is this forecast different from the ones calculated in1a and 1b? If so, please explain the difference. (10 points)
