Please help me!!

Hint(s) Check My Work B Spreadsheet A restaurant wants to forecast its weekly sales. Historical data (in dollars) for fifteen weeks are shown below. Use Excel and the Moving Average template to answer the following questions. Time Period Observation 1 2 1,669 1,553 1,402 3 4 5 1,213 1,250 1,390 6 7 1,504 8 1,310 9 1,241 10 1,546 1,395 11 12 1,541 13 14 1,609 1,548 1,358 15 a. Plot the data and provide insights about the time series. The correct graph is graph A V N 3 4 3 10 11 12 13 14 13 Time Period b. What is the forecast for week 16, using a two-period moving average? Round your answer to the nearest cent. $ C. What is the forecast for week 16, using a three-period moving average? Round your answer to the nearest cent. $ d. Compute MSE for the two- and three-period moving average models to determine the best model. Do not round intermediate calculations. Round your answer to two decimal places. 2-period MA 3-period MA MSE The 3-period V moving average is a better model. Hide Feedback Partially Correct Hint(s) Check My Work Toan To Cynthia's Design Studios had sales the last four months of $13,700, $15,400, $17,400, and $18,550. Sales are related to how many designers Cynthia has on-duty. The sales forecast helps her decide on the proper staffing levels. Round your answers to the nearest whole number. a. What is the forecast for the fifth month using a two-period moving average? $ 17975 b. What is the forecast for the fifth month using a = 0.8 in an exponential smoothing model with A4 = 18,550 and F4 = $16,983 to get things started. $ Hide Feedback Partially Correct Check My Work Not Answered Exotic WCs, III. wants to use exponential smoothing with a = 0.3 to forecast demand in bottles sold. The demand the last four months are 2,521, 3,197, 3,145, and 4,512 bottles. The forecast for bottles was 2,521 bottles for the second month. What is the forecast for the fifth month? Round your answer to the nearest whole number. bottles Check My Work Icon Key