Home Insert Draw Page Layout Formulas Data Review View Tell me Arial V 10 v ' ' = v Paste B I U V V V . Av V V C23 fx A B D E F G H . L M N 1 You must do the necessary calculations in the colored answer cells. Simply providing a number in the answer cell will not receive any credit. 2 For example, if the question asks you to take the average of the values found in cells J3, K3, and L3 and put the answer in Cell M3: 3 10 12 11 11 4 Please note that the correct response (cell M3) includes a formula which uses cell referencing and appropriate excel functions. 5 The use of cell referencing and appropriate excel functions are a necessary part of a correct response in all Excel-based assignments. 6 7 8 There are three parts to this problem. Be sure to scroll down so that you can see all of them. 9 10 'art 1: Fill in the pink cells with forecasts. Round off to two decimal points. Grading Rubric 3 Period 5 period Exponential Exponential Moving moving Smoothing Smoothing Points Points 11 PART 1 Demand Average average alpha = .1 Alpha = .4 Possible Earned Comments 12 ay 1 2690.00 Part 1 13 lay 2 2700.00 3 pd MA 12 12 14 ay 3 2750.00 5 pd MA 12 12 15 ay 4 2690.00 ES a=.1 12 12 16 ay 5 2780.00 ES a= 4 12 12 17 ay 6 2530.00 Part 2 18 ay 7 2660.00 CFE 19 ay 8 2520.00 MAD 20 ay 9 2540.00 MSE 7 7 21 ay 10 2600.00 MAPE 22 ay 11 2640.00 Part 3 23 ay 12 Q1 8 24 Q2 25 Q3 26 'art 2: Fill in the yellow cells with measure of forecast error. Round off to two decimal places TOTAL 100 100 27 You may find it helpful to use the orange cells for intermediate calculations. Don't round off intermediate values in final calculations. 28 eriod Demand Forecast Error Abs Error Error2 abser/demand 29 1 10316.00 10300.00 30 2 12443.00 10565.00 31 3 11717.00 10562.00 32 4 11035.00 10755.00 33 5 12173.00 11377.75 34 6 11015.00 11842.00 35 7 11039.00 11485.00 36 8 11934.00 11315.50 37 9 11694.00 11540.25 38 10 10420.00 11420.50 39 40 Forecast 41 CFE 42 MAD 43 MSE 44 MAPE 45 46 'art 3: Answer the questions below (forecast errors below are based on different data than that shown above) 47 Forecast A Forecast B Forecast 48 CFE 22 -2.2 15 49 MAD 11.5 14.5 12.6) 50 MSE 177 149 -156 51 MAPE 0.11 0.21 0.16 52 53 Question 1: Which measure of forecast error is incorrect. Identify the mistake by indicating both 54 the measure of forecast error and the specific forecast (A, B, or C) in the green box 55 Question 2: Which forecast (A, B, or C) has the largest squared errors? Identify the error type 56 (e.g. CFE, MAD, MSE, MAPE) and the Forecast (e.g. A, B, C)- in the green box. 57_ Question 3. Which forecast AB or C) is the least 'biased'? Identify the error tine