Should be very easy for anyone who knows excel. I need this back in an excel sheet

 

Management 481Forecasting HomeworkEmail your completed homework to Prof Pagano (amp@uic.edu) on an Excel spreadsheetby Friday, Oct 23. This is a requirement of the class.If you do not submit yourhomework, you will be given an incomplete grade in the course until it is submitted.Homework problem session on Tues, Oct 27.Midterm on Oct 29.1.Given the following information:Year/QuarterSales111212144311741122116521923153414431209224031894176Assume that there is a trend and a seasonal factor at work in the series so that theunderlying model is O=TSI.Use the moving average approach to forecast sales for eachquarter of year 4.2.Given the following information:SALESDayFour WeeksThree WeeksTwo WeeksLast WeekAgoAgoAgoM$2,200$2,400$2,300$2,400T2,0002,1002,2002,200W2,3002,4002,3002,500TH1,8001,9001,8002,000F1,9001,8002,1002,000S2,8002,7003,0002,900\Assume that there is a trend and a day of the week factor at work in the series.Use themoving average approach to forecast sales for each day of this week.

Attachments:

• 1496033905-481 Homework 1.doc