Use Excel to solve, comment on answer for both questions

1. Use table 1; Develop three period moving average forecast Develop three period weighted moving average forecast by assuming the following weights n=0.5; n-1=0.3; n-2=0.2 Develop forecast smoothing forecast with alpha = 0.4 Develop regression table (summary outputs), graph and comment on your answer (r-squared, significance F, coefficient). Provide the forecast 2. Use Table 2 Develop regression table (summary outputs), graph by using two given inputs and the output Comment on your answer (r-squared, significance F, coefficients). Provide the forecast. Table 1 Table 2 Year Ents Quarter of a year 1 2 3 Data 1 2 Material Material Output input 1, $ input 2, $ quantities, kg Fn 600 200 150 650 205 200 2 3 3 660 200 250 4 620 210 200 1 4 1 5 650 206 350 6 680 220 250 N 7 680 3 215 225 8 690 2. 3 4 1 2 n sales 1500 2350 3250 4400 5450 6350 7200 8300 9350 10200 11150 12400 13550 14350 15250 16550 350 400 550 300 9 240 7710 750 10 240 11 800 250 350 3 12 800 250 350 3 13 4 1 850 270 400 14 900 275 550 2 15 950 300 450 3 16 990 310 500 4 4