please do it on excel if required. one chegg tutor did it before but some of the answers are wrong.

Current Attempt in Progress - Your answer is partially correct. Burger Lover Restaurant forecasts weekly sales of cheeseburgers Cheeseburger Sales Week 1 346 2 340 3 374 313 5 360 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 337 cheeseburgers for the first week. (Round your answers to 2 decimal places,e-3. 250.25) 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 337 cheeseburgers for the first week. (Round your answers to 2 decimal places.e.g. 250.25) Simple average: Fo- 3466 3-Period moving average: Fo = 349 Exponential smoothing: Fo= 343.90 If actual sales for week 6 turn out to be 369, compare the three forecasts using MAD. Which method performed best? (Calculate your answers using the error only in period 6.) MAD (simple average) - 224 MAD (3-period moving average) - 20 MAD (exponential smoothing) - 25.1 Simple average provides the lowest MAD