PRACTICE QUESTIONS:

Please answer a-d.

Please show all actual calculations (not excel functions)!!!!!!!!!!!!!!!!!!!!!!!!!

Table 2. The manager of Carpet City outlet store needs to be able to forecast accurately demand for Soft Shang carpet. Demand for the past 20 weeks appears in table 1 below week Demand Forecast Error Abs.Dev SQ Error APE 1 20 2 28 3 22 4 18 5 22 6 22 7 22 8 26 9 23 10 23 11 23 12 27 13 25 14 22 15 23 16 14 17 14 18 15 19 11 20 16 21