Please take the data set given below and make all required calculations by using only MS EXCEL. The results should be submitted in a format of excel to the Blackboard system (submission of a student in every group will be enough) and if you have any questions, please do not hesitate to ask to your TA (neslihan.cevik@aicu.cdu.tr). Please do not submit your home works in a hard copy or on papers, also data analysis tool of Excel is not allowed. Table 1: Sales figure of the product in a unit of thousands a) Make your forecast for "Year 6" by using two-ahead moving average method b) Make your forecast for "Year 7"by by using exponential smoothing (Hint you should find the optimal value of before starting your solution, format of 0,X (one digit after coma) will be enough) c) Make your forecast for "Year 7 by using Holt's method ( =0,15& use same that you obtained in previous section) d) Make your forecast for "Ycar 7 by using Winter's method (=0,15 \& use same that you obtained in previous section) e) Draw a single diagram to show your original data and four different forecasted values separately and make your comments