1. Business
  2. Operations Management
  3. operations management i have answers in for a but im...

Question: operations management i have answers in for a but im...

Question details

Operations Management, I have answers in for A but I'm not sure if I'm on the right track, the original info is only Demand and PART 1 Column. B and C haven't been done yet but would appreciate help with those too. Thanks for your help!0 You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not receive any credit. When look at the answer cell, I want to see a number, when I click on the cell I want to see the excel formula, for example, if I asked you the sum of cells B7 through B14, this is what I want to see: 21320.0 or 21320.0 5 Part: Fill in the pink cells with forecasts. Round off to two decimal points 3 Period5 period Exponential Exponential movingSmoothing Smoothing Alpha = .4 2690.00 2690.00 2713.3 2690.00 2690.00 2690.00 2740.02682.00 2691.00 2694.00 2666.7 2636.00 2696.90 2714.60 2656.72606.00 2696.21 2694.14 2570.0 2570.00 2704.59 2729.73 2573.3 2604.00 2687.13 2634.75 2553.3 2072.00 2684.42 2676.28 2613.3 1568.00 2667.98 2618.65 Moving 6 PART 1 Demand Average avera 7 Day 1 8 Day 2 9 Day 3 alpha = .1 0.1 2690.0 2700.0 2750.0 2690.0 2780.0 2530.0 2660.0 2520.0 2540.0 Grading Rubric oints possible points earned Part 1 11 Day 5 12 Day 6 13 Day 7 14 Day 8 5 pd MA ES a-.4 Part 2 CFE MAD MSE MAPE Part 3 16 Day 102600.0 1766.71060.00 2655.18 2616.79 17 Day 11 18 Day 12 2700.0 900.0 540.00 2649.66 2633.11 20 21 Part 2: Fill in the yellow cells with measure of forecast error. Round off to two decimal places 22 Period Demand Forecast 1 10316.0 10300.0 2 12443.0 10565.0 3 11717.0 10562.0 4 11035.010755.0 5 12173.011377.8 6 11015.01842.0 7 11039.0 11485.0 8 11934.011315.5 9 11972.011540.3 10 10518.011490.0 Error Abs Error Error 2 abserr/demand Q3 TOTAL 100 24 25 29 Forecast MAD MSE MAPE 39 40 Part 3: Answer the questions below (forecast errors below are based on different data than that shown above) Forecast A Forecast B Forecast C 43 MAD MSE MAPE 145 0.11 14.5 169 0.21 12.6 156 47 Question 1: Which measure of forecast error is incorrect. ldentify the mistake by indicating both the measure of forecast error and the specific forecast (A, B, or C) 49 50 Question 2: Which forecast (A, B, or C) has the largest squared errors? Question 3: Which forecast (A, B, or C) is the least biased?

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution