Operations management discussion

profilepcwc0506
BUS520_Discussion5_table.xlsx
Home>Business & Finance homework help>Operations Management homework help>Operations management discussion

Table 1

Cutting Board Small Bowl Large Bowl Drying Racks
Month Actual Sales Last Year Actual Sales Last Year Actual Sales Last Year Actual Sales Last Year
Dec 85 94 49 200
Jan 49 73 14 209
Feb 21 75 13 222
Mar 20 212 37 208
Apr 41 172 35 223
May 97 89 10 197
Jun 94 233 18 197
Jul 38 66 35 212
Aug 33 60 30 164
Sep 17 222 38 175
Oct 57 55 39 153
Nov 84 72 13 225

Tables 2_5

Alpha 0.35
Forecast for Cutting Board
Month Actual Sales Last Year Naïve 3PMA 3PWMA Exp Weighting
Dec 85 Most recent 0.6
Jan 49 85 85 2nd month back 0.3
Feb 21 49 72 3rd month back 0.1
Mar 20 21 52 36 54
Apr 41 20 30 23 42
May 97 41 27 33 42
Jun 94 97 53 73 61
Jul 38 94 77 90 73
Aug 33 38 76 61 61
Sep 17 33 55 41 51
Oct 57 17 29 24 39
Nov 84 57 36 43 45
Alpha 0.32
Forecast for Small Bowl
Month Actual Sales Last Year Naïve 3PMA 3PWMA Exp
Dec 94
Jan 73 94 94
Feb 75 73 87
Mar 212 75 81 76 83
Apr 172 212 120 157 128
May 89 172 153 174 143
Jun 233 89 158 126 124
Jul 66 233 165 184 162
Aug 60 66 129 118 129
Sep 222 60 120 79 105
Oct 55 222 116 158 146
Nov 72 55 112 106 114
Alpha 0.3
Forecast for Large Bowl
Month Actual Sales Last Year Naïve 3PMA 3PWMA Exp
Dec 49
Jan 14 49 49
Feb 13 14 39
Mar 37 13 25 17 30
Apr 35 37 21 28 32
May 10 35 28 33 33
Jun 18 10 27 20 25
Jul 35 18 21 17 23
Aug 30 35 21 27 27
Sep 38 30 28 30 28
Oct 39 38 34 35 32
Nov 13 39 36 38 34
Alpha 0.4
Forecast for Drying Racks
Month Actual Sales Last Year Naïve 3PMA 3PWMA Exp
Dec 200
Jan 209 200 200
Feb 222 209 204
Mar 208 222 210 216 210
Apr 223 208 213 212 209
May 197 223 218 218 214
Jun 197 197 209 206 208
Jul 212 197 206 200 204
Aug 164 212 202 206 207
Sep 175 164 191 182 192
Oct 153 175 184 175 186
Nov 225 153 164 161 174