You must do the necessary calculations in the colored answer cells. Simply providing a number in the answer cell will not receive any credit. For example, if the question asks you to take the average of the values found in cells 33,K3, and L3 and put the answer in Cell 3: Please note that the correct response (cell M3) includes a formula which uses cell referencing and appropriate excel functions. The use of cell referencing and appropriate excel functions are a necessary part of a correct response in all Excel-based assignments. 12 Grading Rubric There are three parts to this problem. Be sure to scroll down so that you can see all of them. ill in the pink cells with forecasts. Round off to two decimal points 3 Period 5 period Exponential Exponential Moving moving Smoothing Smoothing Demand Average average 1 Alpha 2690.00 2700.00 2750.00 2690.00 2780.00 2530.00 2560.00 2520.00 2540.00 2000.00 2640.00 Points Points Poss Famed Com Part 1 pd MA 12 12 5d MA 12 12 ES a 12 12 ES 4 12 12 PM2 CFE 7 2 MAD 2 2 NSE 71 2 MAPE 7 1 Part 3 Q1 100 100 os all in the yellow cells with measure of forecast error. Round off to two decimal places TOTAL You may find the pful to use the onge ces for temediate calculations. Don't round off interdite van final calculations Demand Forecast Er Abe ERO Eirberedemand 10316.00 10300.00 12443.00 10565.00 11717.00 10562.00 11035.00 10755.00 1217300 11377.75 1101500 11842.00 1109 Sheet1 Sheet2 Sheet3 es 8 8 100 100 25 02 26 Part 2: Fill in the yellow cells with measure of forecast error. Round off to two decimal places TOTAL 27 You may find it helpful to use the orange cells for intemediate calculations. Don't round of intermediate values in final calculations 28 Period Demand Forecast Emor Abs Emor Emor2 absem demand 29 1 10316.00 10300.00 30 2 12443 00 10565.00 3 11717.00 10562 00 32 4 11035.00 10755.00 33 5 12173.00 11377.75 34 611015.00 11842.00 35 7 11030.00 11485.00 36 11034.00 11315.50 37 9 11694.00 11540.25 38 10 10420.00 11420 50 39 40 Force 41 CFE 42 MAD MSE 44 MAPE Part 3: Answer the questions below (forecast errors below are based on different data than that shown above) Forecast A Forecast Forecast CFE 22 -22 15 MAD 11.5 14,5 12.6 MSE 177 149 -156 MAPE 0.11 0.16 021 Question 1: Which measure of forecast error is incorrect. Identify the mistake by indicating both the measure of forecast error and the specific forecast (A, B, or C) in the green box Question 2: Which forecast (A, B, or C) has the largest squared errors? Identify the enor type (e.g. CFE, MAD, MSE, MAPE) and the Forecast (og A, B, C) in the green box Question 3: Which forecast (A, B, or C) is the least biased? Identify the error type leg. CFE, MAD, MSE, MAPE) and the Forecast (eg, A, B, C) - In the green box 0 1