Simulation problems/ templates for Chapter 14 ManagementScience text by Bernard

Simulation problems/ templates for Chapter 14 ManagementScience text by Bernard W. Taylor III. Chapter 15 ( Forecasting)problems: Q1..Use template 15-2 ( file attached): The managerof carpet City.has collected the following demand data for thepast 8 months: Month Demand for Soft Shag carpet( 1000yd) 1 8 2 123 7 4 9 5 15 6 11 7 10 8 12 a) compute a 3- month moving averagefor months 4 through 9. b) compute a weighted 3-month movingaverage forecast for months 4 through 9. Assign weights .55 .33and .12 to the months in sequence starting with the most recentmonth. c) compare the two forecasts by using MAD. Which forecastappears to be more accurate?