Use the Excel template provided by your instructor. Compute MAD for the following data, showing actual and forecasted numbers of accounts serviced. Use the Excel template provided by your instructor. Compute a three-period moving average forecast given demand for shopping carts for the last five periods. Problem 3 Computing Weighted Moving Average Use the Excel template provided by your instructor. Compute a weighted average forecast using a weight of 40 for the most recent period, 30 for the next most recent, .20 for the next, and 10 for the next. What is the weighted average forecast for period 6 ? Numeric Response Use the Excel template provided by your instructor. Cell phone sales for a firm over the last 10 weeks are shown below. Plot the data and visually check to see if a linear trend line is appropriate. Then using the trend line, predict sales for week 11. Use the Excel template provided by your instructor. The manager of a call center recorded the volume of calls recelved between 9 and 10am for 21 days and wants to obtain a seasonal Index for each day for that hour. For practical purposes, you can round the relatives (Indeces) to 2 decimal points. What is the seasonal standard index value for Monday? Day Volume Tues 67 Wed 75 Thurs 82 Frl 98 Sat 90 SunMon3655 MonTues5560 Wed 73 Thurs 85 Fri 99 SatSun8640 SunMon4052 MonTues5264 TuesWed6476 Thurs 87 Frl 96 Sat 88 SunMon4450