i need question B and C

Th3 CM 1500 Forecasting COVID-19 New Cases in Thailand Introduction Thailand has been facing COVID-19 pandemic since January 2020. Almost 2 years that there were many disruptions in many areas such as tourism, manufacturing, import & export, education, and healthcare, etc. Thai government has spent huge budget to help Thai citizens and business sectors. However, many firms closed down and workers were out of jobs and went back to their hometowns. There were 4 phases and a number of virus variants during these 2 years such as Alpha, Beta, Delta, Gamma, and so on. The 4-phase pandemic can be summarized as shown below. Phase 1: it started in March 2020. The virus came with inbound tourists, passed through the airspace and hit tourism. The main cluster was a boxing stadium. Phase 2: it started in December 2020. The virus spread from the borders and hit major labor cities in Thailand such as Samut Prakarn, Rayong, and Chiang Mai. Phase 3: it started in April 2021. The main cluster was club and bar businesses in Thonglor district, Bangkok. Then the pandemic quickly distributed to the communities such as markets, workers' camps, prisons, and factories. Phase 4: it started in July 2021. The discovery of the 2 mew virus variants. The outbreak began in workers' camps and also found in the southern part of Thailand. We had the serious problems because of limited vaccines, field hospitals, medical doctors and equipment Next page are the data of World Health Organization's COVID-19 new cases in Thailand since the beginning until the end of November 2021. . WPXOM po Month Month January 2020 February 2020 March 2020 April 2020 May 2020 June 2020 July 2020 August 2020 September 2020 October 2020 November 2020 December 2020 Number of new cases 23 19 1,609 1,303 127 90 139 102 152 216 218 2,886 January 2021 February 2021 March 2021 April 2021 May 2021 June 2021 July 2021 August 2021 September 2021 October 2021 November 2021 December 2021 Number of new cases 11,898 7,169 2,912 36,290 94,639 99,509 337,986 607,442 398,746 308,549 203,848 ? Students use excel program to answer questions a to d. For question e, students discuss within the group or search information via online. Each question is worth 1%. a. Forecast number of new cases for April 2020 to December 2021 by using 3-month moving average method. b. Forecast number of new cases for April 2020 to December 2021 by using 3- month weighted moving average method. Use 0.5 for the most recent month, 0.3 for two months ago and 0.2 for three months ago c. Forecast number of new cases. Assume that the initial forecast for January 2020 is 50 persons. The smoothing constant a is 0.5 d. Calculate two measures of forecast errors (MAD and MAPE) for the above three methods. Based on these two measures, which forecasting method is the best? And Why? e. Give three reasons about COVID-19 situations that can cause the above forecasts highly inaccurate. In case students search the information via online. Please give the references