Given the demand data for 15 months, find the solution to all the indicated problems. All terms have their usual meaning.

solve through excel

Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. J33 fx A C D E F H + 1 K M N 0 Q R s 4 Time (month) 1 2 3 4 5 6 7 8 9 Demand (tons) 20 25 30 40 45 50 70 90 60 What is the naive forecast for month 16 in tons? 10 11 12 13 14 15 50 40 30 25 40 50 5 7 8 10 What is the SMMA forecast for month 16 in tons? What is the 3PWMA forecast for month 16 in tons, using weights of 0.2, 0.6, and 0.22 17 20 22 What is the exponentially smoothing forecast for month 16 in tons, using F14=40 and a=0.2? (rounded whole number) 19 What is the regression forecast for month 16 in tons? (rounded whole number) slope= 0.75 int= 38.33 F16= 50.33 What is MAD for the regression forecast? (rounded whole number) What is MAPD for the regression forecast? (rounded percentage) Is the regression forecast under control based on the tracking signal? (State "YES" if in control and "NO" otherwise) 23 25 26 28 29