HELP WITH MISSING BLANKS PLEASEHELP WITH MISSING BLANKS PLEASE

Burger Lover Restaurant forecasts weekly sales of cheeseburgers. Cheeseburger Sales Week 1 358 2 343 3 360 4 314 5 347 Based on historical observations over the past five weeks, make a forecast for the next period using the following methods: simple average, three-period moving average, and exponential smoothing with a = 0.3, given a forecast of 327 cheeseburgers for the first week. (Round your answers to 2 decimal places, e.g. 250.25) Simple average: F6 344.40 3-Period moving average: F6 = 340.33 Exponential smoothing: F6 = If actual sales for week 6 turn out to be 374, compare the three forecasts using MAD. Which method performed best? (Calculate your answers using the error only in period 6.) MAD (simple average) = 29.60 MAD (3-period moving average) = MAD (exponential smoothing) = Simple average provides the lowest MAD