PLEASE ANSWER QUESTION 12 AND 13 !!!!! That is what I need to be answered!

14.7. Prepare a spreadsheet model for the Saturday hotel occupancy data in Table 14.3 C, and recalculate the forecasts using an a of 0.3. What is the new MAD? TABLE 14.3 Simple Exponential Smoothing: Saturday Hotel Occupancy (a = 0.5) Actual Smoothed Absolute Error Squared Error Percent Error Saturday Period Occupancy Value Forecast Error A-Fil t At St Ft A,- Ft IA-FI (At-F)2 At Aug. 1 1 79 79.00 8 2. 84 81.50 79 5 25 6 _ 15 3 83 82.25 82 = 0 1 1 1 22 4 81 81.63 82 -1 1 1 1 un 29 5 98 89.81 82 16 16 256 16 Sept. 6 100 94.91 90 10 10 100 10 Total 31 33 383 34 Forecast CFE MAD MSE MAPE Error 31 6.6 76.6 6.8 Problem 14.7 Use your results for homework problem 14.7 to answer the following questions. By the way, I do not care if you used a spreadsheet or hand calculations to work the problem. a Question 12 (5 points) 1) Listen What is the revised forecast (Ft) for September 5? Do not round your forecast to a whole number. Your Answer: Answer Question 13 (5 points) Listen What is the new MAD? Your