all problems are included in attachment added/ excel solutionsheet that problems

all problems are included in attachment added/ excel solutionsheet that problems should be done on is not provided yet/ itscoming soon.not provided as of yet . MAT540 Homework Week 4 Page1 of 4 MAT540 Week 4 Homework Chapter 15 1. The manager of theCarpet City outlet needs to make an accurate forecast of the demandfor Soft Shag carpet (its biggest seller). If the manager does notorder enough carpet from the carpet mill customers will buy theircarpet from one of Carpet Citys many competitors. The manager hascollected the following demand data for the past 8 months: MonthDemand for Soft Shag Carpet (1000 yd.) 1 9 2 8 3 7 4 8 5 10 6 11 713 8 12 a. Compute a 3-month moving average forecast for months 4through 9. b. Compute a weighted 3-month moving average forecastfor months 4 through 9. Assign weights of 0.50 0.30 and 0.20 tothe months in sequence starting with the most recent month. c.Compare the two forecasts by using MAD. Which forecast appears tobe more accurate?