Instructions: This is an individual assignment - Students are required to build an Excel spreadsheet for the forecast and the forecast errors. Students are required to turn in BOTH the Excel Spreadsheet AND this Document with the answers completed in Bold or Highlighted). TYPE YOUR NAME on THIS DOCUMENT and Save File with your LAST NAME listed. Please do this also on your EXCEL File - List your last name- upload both files in the Modules using the upload link. Case Study: Flying Diss. Inc. has recorded the number of flying discs it has sold in each of the last 15 months of business. Use the recorded demand data below to develop three-period and four-period simple moving average forecasts for flying discs. Round off all calculations to two decimal places. Maintaining two decimal places is required for all calculations. Period Demand Period Demand Period Demand 1 850 6 890 11 880 2 890 7 920 12 850 3 925 8 895 13 865 4 880 9 865 14 890 5 860 10 910 15 895 1) What is the forecast for period 16 using the three-period moving average? The final forecast for period 16 should be rounded off to the nearest whole number. A) B) C) D) E) Less than or equal to 860 Greater than 860 but less than or equal to 875 Greater than 875 but less than or equal to 885 Greater than 885 but less than or equal to 895 Greater than 895 2) What is the forecast for period 16 using the four-period moving average? The final forecast for period 16 should be rounded off to the nearest whole number A) B) C) D) E) Less than or equal to 860 Greater than 860 but less than or equal to 875 Greater than 875 but less than or equal to 885 Greater than 885 but less than or equal to 895 Greater than 895