Answer Happy

Do this with Excel. Go tohttps://www.netflixinvestor.com/financials/quar ... fault.aspx. Generate data into your spreadsheet arrangedby revenue per quarter fromMarch 31st of 2019 through March 31st of 2021 (click “Incomestatement sheet” in the“Financial Statements”). Do a forecast for total revenue of thesecond quarter in 2022 for Netflixby doing.1) Scatter plot the data using the Excel chart function underthe Insert tab andmake meaningful comments on your observation of the datapattern.2) Try 3 period moving average.3) Try the exponential smoothing with alpha =0.2. Assume that theinitialforecast (i.e. quarter 1 of 2019) is the same as the actual demandof quarter 1 of 2019 (i.e.$4,520,992).4) Try FIT with alpha=0.2, beta=0.3. Assume that the exponentialsmoothingcomponent of the initial forecast is the same as the actual demandof the first period andthe initial trend= 0. In other words, F(1) = Same as the actualdemand of the first period(i.e. $4,520,992) and T(1)= 0. This will give FIT(1)= actual demandof the first period($i.e. $4,520,992+0)= ( $4,520,992) . With this set up you canstart from F(2), T(2), andFIT(2). Continue the work until you forecast for the fourth quarterof 2021.5) Compare the two methods of exponential smoothing and FIT andcomment onthe superiority of the techniques.