****** I NEED THE EXCEL FORMULAS, FOR EXAMPLE =AVERAGE.... PLEASE SHOW EXCEL FORMULAS USED FOR ALL************** I NEED THE EXCEL FORMULAS, FOR EXAMPLE =AVERAGE.... PLEASE SHOW EXCEL FORMULAS USED FOR ALL********

11) What is the mean average deviation (MAD) for the forecast with a = 0.2 as of week 10? A) B) C) D) E) Less than or equal to 2.00 Greater than 2.00 but less than or equal to 4.00 Greater than 4.00 but less than or equal to 6.00 Greater than 6.00 but less than or equal to 8.00 Greater than 8.00 12) What is the mean square error (MSE) for the forecast with a = 0.6 as of week 15? Do not use week one in your calculations. A) B) C) D E) Less than or equal to 63.00 Greater than 63.00 but less than or equal to 66.00 Greater than 66.00 but less than or equal to 69.00 Greater than 69.00 but less than or equal to 72.00 Greater than 72.00 13) What is the period 15 tracking signal for the forecast with a = 0.2? A) B) C) D) E) Less than or equal to 2.00 Greater than 2.00 but less than or equal to 4.00 Greater than 4.00 but less than or equal to 6.00 Greater than 6.00 but less than or equal to 8.00 Greater than 8.00 14) What is the period 15 tracking signal for the forecast with a = 0.6? A) B) C) D) E) Less than or equal to 2.00 Greater than 2.00 but less than or equal to 4.00 Greater than 4.00 but less than or equal to 6.00 Greater than 6.00 but less than or equal to 8.00 Greater than 8.00 15) Assume that the control limits for the tracking signal are +4. What can be concluded about the quality of the forecasts using a=0.20 or a=0.60? A) B) C) Both forecasts are unbiased. The forecasts using alpha = 0.2 and alpha=0.6.both produce no tracking signal that falls outside the tracking signal limits. Both forecasts are biased. The forecasts using alpha=0.2 and alpha = 0.6 both produce at least one tracking signal that falls outside the tracking signal limits. The forecast using alpha = 0.2 is unbiased. The forecast using alpha=0.2 produces no tracking signals that are outside the tracking signal limits. The forecast using 0.6 falls is biased since it produces at least one tracking signal that is outside the tracking signal limits. The forecast using alpha = 0.2 is biased. The forecast using alpha = 0.2 produces at least one tracking signal that falls outside the tracking signal limits. The forecast using alpha = 0.6 is unbiased and produces no tracking signal that falls outside the tracking signal limits. D) Week 1 2 3 4 5 Demand 55 50 57 60 58 Week 6 7 8 9 10 Demand 63 50 50 58 73 Week Demand 11 69 12 52 13 67 14 63 15 70