Quiz 3 Line Chart.xlsx - Time Period Sales($1000s Forecast...

This preview shows page 1 - 6 out of 6 pages.

Time Period Sales ($1000s) SMA Forecast Forecasting Bias Abs. of Errors Jan Year1 242 Feb Year1 235 March Year1 232 April Year1 178 236 -58 58 May Year1 184 215 -31 31 June Year1 140 198 -58 58 July Year1 145 167 -22 22 Aug Year1 152 156 -4 4 Sept Year1 110 146 -36 36 Oct Year1 130 136 -6 6 Nov Year1 152 131 21 21 Dec Year1 206 131 75 75 Jan Year2 263 163 100 100 Feb Year2 238 207 31 31 March Year2 247 236 11 11 April Year2 193 249 -56 56 May Year2 193 226 -33 33 June Year2 149 211 -62 62 July Year2 157 178 -21 21 Aug Year2 161 166 -5 5 Sept Year2 122 156 -34 34 Oct Year2 130 147 -17 17 Nov Year2 167 138 29 29 Dec Year2 230 140 90 90 Jan Year3 282 176 106 106 Feb Year3 255 226 29 29 March Year3 265 256 9 9 April Year3 205 267 -62 62 May Year3 210 242 -32 32 June Year3 160 227 -67 67 July Year3 166 192 -26 26 Aug Year3 174 179 -5 5 Sept Year3 126 167 -41 41 Oct Year3 148 155 -7 7 Nov Year3 173 149 24 24 Dec Year3 235 149 86 86 Jan Year4 Not Collected Yet 185.33 #VALUE! #VALUE!
EMA Forecast Forecasting BiAbs. of Errors 232 -54 54 194 -10 10 187 -47 47 154 -9 9 148 4 4 151 -41 41 122 8 8 128 24 24 145 61 61 188 75 75 240 -2 2 239 8 8 245 -52

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture