AutoSave C - Glos Demand forecasting Fire Exercise NEF (1) Excel Scarch Rajesh Dip File Home Insert Page Layout Formulas Data Review View Help Share Comments Calibri AutoSum 12 A A == 89 Wrap Text Ceneral 4 Erill X Out [Copy Paste Format Painter Cupboard FH CA Insert Delete Format BIU Ideas Seng UVLY Merge Center $ % -8 Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Eding Font Alignment Number Cels dsas Sensity 013 2 H 1 L M N 4 A B C D E F G 1 OPM400 2 Student Name: 3 Student Number: 4 4 5 NOTE: Show and use excel formulas for each and all calculations and round to two decimals - 6 6 7 7 Q 1) Use the Historical demand data below to calculate THREE forecasts. (3 marks) 8 a) 3 Period Simple Moving Average 9 b) 3 Period Weighted Moving Average using weights of.65, 2,.15 10 c) Exponential Smoothing forecast using an Alpha of.25. and a Week 4 forecast of 396 units. 11 12 Week Demand SMA 3 Period WMA.65, 2,.15 EXP SM a 5.25 13 1 452 14 2 391 15 3 532 16 4 613 396 17 5 523 18 6 498 19 7 437 20 8 526 21 9 496 22 Instructions NEE + Select destination and press ENTER or chocs Paste Type here to search O 1209 ? 1:41 AM 2/4/2021