Most recent 13 weekly sales of six-pack beer at a local supermarket given in the excel worksheet

A. Develop forecasts week 14 using exponential smoothing method with smoothing constant ? = 0.8

b. Develop forecasts week 14 using simple 4-week moving average

C. Which one of the above 2 forecasts you recommend? Why?

Home Insert Draw Page Layout Formulas Data Review View Tell me LE Share Comments Arial 10 VA A ab v % Conditional Formatting Format as Table v Paste BI UV MvAv Number Cells Editing Analyze 87 V Cell Styles v Data B14 X V fx 22 A B C D E F G H I J K L M N O P Q R Week Unit Sales 25 13 22 31 19 13 WNS OO OO VO U A W N - 16 10 28 22 22 43 44 Q1-Edison Q2-TV News Q4-Six-pack Q5-Statistics Q6-Facebook + Ready 12 Accessibility: Good to go + 100%