Assignment Questions: PROBLEM 1: (20 marks) The Fowler Martial Arts Academy trains young boys and girls in self- defence. Joan Fowler, the academy owner, notes that monthly revenue is higher when school is in session but quite low when school is out (because many children are away on vacation or at summer camp]. She has researched revenues for the past four years and obtained the information shown MonthlyRevenueFZZ Excel file {see the attachment). Answer the following questions based on the data provided in the file. a] Forecast the revenue for January Year 5 using the moving averages method. Consider three different numbers of periods for the moving average calculation (3, 6, and 9 months}. (10 marks] 1. Does the January forecast for Year 5 change if you change the number of periods to calculate the moving average? Enumerate the three different forecasts {using the three periods - 3, 6, and 9 months) for January Year 5. (3 marks) 2. Plot both the actual and predicted revenue for all three moving average calculations {You will have four plots in total on one chart the actual data and the three forecasts). {3 marks} 3. Which model is the best (the one based on a 3, 6, or 9-month moving average)? Why? Show your calculations. {4 marks} b) Using multiple regression analysis, forecast revenues for each month of Year 5 (8 marks) c] Which model is better - the one based on the moving average or the regression analysis? Why? Show your calculations. Note: compare the best moving average model in question 3 above with the regression model in question b. (2 marks] Assignment #2: Time Series Forecasting and Linear Programming (40 points and 10% of Final Grade] Due date: November 25, 2022, 11:55 PM via Sakai INSTRUCTION o Use Microsoft Excel ONLY to solve the problems. If an answer requires written arguments or explanations, you must do it in the Excel file. o You are required to submit ONE Excel file only. Answer questions 1a, 1b and 1C, and problem 2 on different worksheets. Altogether you will have four worksheets in one workbook, including the cover sheet (next bullet point]. t The file you submit must have a cover sheet that shows your first and last name, student number, and course and section numbers. Use the first worksheet in the Excel workbook you will submit as a coversheet. . The file must be uploaded to Sakai using the Asst}! link in the assignment folder by the due date to get a credit. Email submission is neither accepted nor credited. . The file you are submitting MUST be an Excel file and must be openable in the Windows environment. . Verify that your assignment file is correctly submitted through the course website. A 10% deduction per day will apply to late submissions for the first three days only; wrong files will automatically receive a grade of zero