Need a brief analysis in Excel that will help to address:

• Important trends/events in the appropriate marketing channels and products
• A forecast of the next month's expected sales (assuming no additional changes beyond what's covered in the data set)
• Key insights/recommendations for next steps

Analysis:

• Ability to understand the important developments in these products and channels
• Use of common business methods to interpret and forecast the data
• Insights into non-obvious marketing performance trends

Events

Date Event

1/6/2018 New website promotion for hats

1/14/2018 Hats price change: $15 to $18

1/18/2018 Product launch: Shoe 2.0

1/22/2018 Sandals price change: $28 to $20

1/1/2018 Hats Retail 214 $3,210.00

1/1/2018 Hats Website 380 $5,728.50

1/1/2018 Shoes Retail 124 $6,697.24

1/1/2018 Shoes Website 194 $10,499.28

1/1/2018 Sandals Retail 58 $1,627.25

1/1/2018 Sandals Website 160 $4,408.32

1/2/2018 Hats Retail 216 $3,175.37

1/2/2018 Hats Website 374 $5,530.28

1/2/2018 Shoes Retail 124 $6,854.05

1/2/2018 Shoes Website 199 $10,766.39

1/2/2018 Sandals Retail 56 $1,550.40

1/2/2018 Sandals Website 159 $4,371.43

1/3/2018 Hats Retail 220 $3,277.58

1/3/2018 Hats Website 368 $5,436.27

1/3/2018 Shoes Retail 121 $6,550.08

1/3/2018 Shoes Website 204 $11,073.93

1/3/2018 Sandals Retail 55 $1,519.57

1/3/2018 Sandals Website 160 $4,423.90

1/4/2018 Hats Retail 229 $3,454.42

1/4/2018 Hats Website 366 $5,458.57

1/4/2018 Shoes Retail 119 $6,406.35

1/4/2018 Shoes Website 212 $11,621.95

1/4/2018 Sandals Retail 54 $1,492.36

1/4/2018 Sandals Website 160 $4,431.76

1/5/2018 Hats Retail 234 $3,498.08

1/5/2018 Hats Website 368 $5,557.62

1/5/2018 Shoes Retail 120 $6,641.70

1/5/2018 Shoes Website 221 $12,159.54

1/5/2018 Sandals Retail 53 $1,449.39

1/5/2018 Sandals Website 164 $4,607.71

1/6/2018 Hats Retail 239 $3,563.42

1/6/2018 Hats Website 376 $5,541.09

1/6/2018 Shoes Retail 119 $6,569.34

1/6/2018 Shoes Website 230 $12,721.85

1/6/2018 Sandals Retail 52 $1,465.50

1/6/2018 Sandals Website 167 $4,676.79

1/7/2018 Hats Retail 248 $3,729.58

1/7/2018 Hats Website 382 $5,619.41

1/7/2018 Shoes Retail 118 $6,425.84

1/7/2018 Shoes Website 240 $13,257.20

1/7/2018 Sandals Retail 51 $1,403.43

1/7/2018 Sandals Website 166 $4,563.65

1/8/2018 Hats Retail 252 $3,719.78

1/8/2018 Hats Website 392 $5,798.24

1/8/2018 Shoes Retail 115 $6,221.42

1/8/2018 Shoes Website 247 $13,445.49

1/8/2018 Sandals Retail 50 $1,396.49

1/8/2018 Sandals Website 167 $4,641.78

1/9/2018 Hats Retail 257 $3,839.28

1/9/2018 Hats Website 400 $5,916.29

1/9/2018 Shoes Retail 116 $6,411.72

1/9/2018 Shoes Website 256 $13,969.68

1/9/2018 Sandals Retail 50 $1,414.59

1/9/2018 Sandals Website 169 $4,720.88

1/10/2018 Hats Retail 266 $4,010.22

1/10/2018 Hats Website 415 $6,209.71

1/10/2018 Shoes Retail 115 $6,284.72

1/10/2018 Shoes Website 265 $14,499.47

1/10/2018 Sandals Retail 49 $1,349.36

1/10/2018 Sandals Website 171 $4,758.06

1/11/2018 Hats Retail 272 $4,056.68

1/11/2018 Hats Website 429 $6,407.03

1/11/2018 Shoes Retail 112 $6,060.33

1/11/2018 Shoes Website 274 $15,049.30

1/11/2018 Sandals Retail 49 $1,362.98

1/11/2018 Sandals Website 175 $4,961.13

1/12/2018 Hats Retail 277 $4,090.84

1/12/2018 Hats Website 437 $6,438.99

1/12/2018 Shoes Retail 111 $6,036.61

1/12/2018 Shoes Website 284 $15,573.04

1/12/2018 Sandals Retail 48 $1,350.70

1/12/2018 Sandals Website 177 $4,930.89

1/13/2018 Hats Retail 284 $4,256.31

1/13/2018 Hats Website 456 $6,860.74

1/13/2018 Shoes Retail 109 $5,862.41

1/13/2018 Shoes Website 293 $15,969.62

1/13/2018 Sandals Retail 47 $1,294.79

1/13/2018 Sandals Website 181 $5,090.55

1/14/2018 Hats Retail 276 $4,890.95

1/14/2018 Hats Website 464 $8,208.03

1/14/2018 Shoes Retail 108 $5,916.30

1/14/2018 Shoes Website 302 $16,492.16

1/14/2018 Sandals Retail 46 $1,267.75

1/14/2018 Sandals Website 185 $5,218.57

1/15/2018 Hats Retail 270 $4,842.16

1/15/2018 Hats Website 453 $8,003.66

1/15/2018 Shoes Retail 108 $5,939.98

1/15/2018 Shoes Website 313 $17,117.70

1/15/2018 Sandals Retail 45 $1,243.78

1/15/2018 Sandals Website 190 $5,371.04

1/16/2018 Hats Retail 265 $4,745.68

1/16/2018 Hats Website 442 $7,796.41

1/16/2018 Shoes Retail 105 $5,687.88

1/16/2018 Shoes Website 319 $17,218.44

1/16/2018 Sandals Retail 44 $1,235.09

1/16/2018 Sandals Website 192 $5,327.57

1/17/2018 Hats Retail 260 $4,660.48

1/17/2018 Hats Website 431 $7,617.81

1/17/2018 Shoes Retail 106 $5,873.51

1/17/2018 Shoes Website 332 $18,290.53

1/17/2018 Sandals Retail 44 $1,232.57

1/17/2018 Sandals Website 192 $5,277.93

1/18/2018 Hats Retail 253 $4,499.05

1/18/2018 Hats Website 423 $7,511.69

1/18/2018 Shoes Retail 107 $5,783.85

1/18/2018 Shoes Website 342 $19,012.32

1/18/2018 Sandals Retail 43 $1,207.57

1/18/2018 Sandals Website 187 $5,235.47

1/19/2018 Hats Retail 249 $4,467.47

1/19/2018 Hats Website 422 $7,610.61

1/19/2018 Shoes Retail 108 $5,929.42

1/19/2018 Shoes Website 347 $19,009.03

1/19/2018 Sandals Retail 41 $1,155.06

1/19/2018 Sandals Website 184 $5,141.04

1/20/2018 Hats Retail 242 $4,286.68

1/20/2018 Hats Website 414 $7,347.31

1/20/2018 Shoes Retail 111 $6,084.36

1/20/2018 Shoes Website 357 $19,799.68

1/20/2018 Sandals Retail 40 $1,129.41

1/20/2018 Sandals Website 177 $4,878.29

1/21/2018 Hats Retail 233 $4,121.15

1/21/2018 Hats Website 407 $7,222.86

1/21/2018 Shoes Retail 111 $5,966.13

1/21/2018 Shoes Website 365 $20,115.61

1/21/2018 Sandals Retail 39 $1,071.58

1/21/2018 Sandals Website 174 $4,868.18

1/22/2018 Hats Retail 230 $4,137.95

1/22/2018 Hats Website 401 $7,150.93

1/22/2018 Shoes Retail 110 $6,069.62

1/22/2018 Shoes Website 367 $19,948.03

1/22/2018 Sandals Retail 40 $796.05

1/22/2018 Sandals Website 183 $3,703.09

1/23/2018 Hats Retail 223 $3,954.52

1/23/2018 Hats Website 403 $7,324.10

1/23/2018 Shoes Retail 108 $5,835.52

1/23/2018 Shoes Website 377 $20,904.61

1/23/2018 Sandals Retail 42 $843.75

1/23/2018 Sandals Website 191 $3,793.19

1/24/2018 Hats Retail 222 $4,034.01

1/24/2018 Hats Website 398 $7,114.67

1/24/2018 Shoes Retail 107 $5,806.76

1/24/2018 Shoes Website 383 $20,921.14

1/24/2018 Sandals Retail 44 $873.14

1/24/2018 Sandals Website 198 $3,944.07

1/25/2018 Hats Retail 216 $3,855.87

1/25/2018 Hats Website 398 $7,186.14

1/25/2018 Shoes Retail 107 $5,953.55

1/25/2018 Shoes Website 386 $20,956.23

1/25/2018 Sandals Retail 45 $901.72

1/25/2018 Sandals Website 205 $4,043.44

1/26/2018 Hats Retail 209 $3,692.00

1/26/2018 Hats Website 396 $7,121.73

1/26/2018 Shoes Retail 106 $5,824.07

1/26/2018 Shoes Website 395 $21,808.40

1/26/2018 Sandals Retail 47 $925.62

1/26/2018 Sandals Website 213 $4,225.55

1/27/2018 Hats Retail 202 $3,560.25

1/27/2018 Hats Website 387 $6,833.31

1/27/2018 Shoes Retail 107 $5,953.07

1/27/2018 Shoes Website 404 $22,244.66

1/27/2018 Sandals Retail 48 $953.02

1/27/2018 Sandals Website 218 $4,275.15

1/28/2018 Hats Retail 199 $3,592.74

1/28/2018 Hats Website 384 $6,909.93

1/28/2018 Shoes Retail 108 $5,970.85

1/28/2018 Shoes Website 410 $22,418.38

1/28/2018 Sandals Retail 50 $986.19

1/28/2018 Sandals Website 229 $4,590.56

1/29/2018 Hats Retail 194 $3,454.52

1/29/2018 Hats Website 385 $6,965.10

1/29/2018 Shoes Retail 107 $5,858.54

1/29/2018 Shoes Website 414 $22,569.85

1/29/2018 Sandals Retail 52 $1,047.38

1/29/2018 Sandals Website 239 $4,787.59

1/30/2018 Hats Retail 190 $3,406.23

1/30/2018 Hats Website 381 $6,820.23

1/30/2018 Shoes Retail 104 $5,632.19

1/30/2018 Shoes Website 424 $23,463.20

1/30/2018 Sandals Retail 53 $1,049.50

1/30/2018 Sandals Website 247 $4,888.68

1/31/2018 Hats Retail 189 $3,439.77

1/31/2018 Hats Website 381 $6,902.31

1/31/2018 Shoes Retail 105 $5,821.93

1/31/2018 Shoes Website 427 $23,151.29

1/31/2018 Sandals Retail 56 $1,123.67

1/31/2018 Sandals Website 254 $5,011.69

6,965.10 1/29/2018 Shoes Retail 107 $5,858.54 1/29/2018 Shoes Website 414 $22,569.85 1/29/2018 Sandals Retail 52 $1,047.38 1/29/2018 Sandals Website 239 $4,787.59 1/30/2018 Hats Retail 190 $3,406.23 1/30/2018 Hats Website 381 $6,820.23 1/30/2018 Shoes Retail 104 $5,632.19 1/30/2018 Shoes Website 424 $23,463.20 1/30/2018 Sandals Retail 53 $1,049.50 1/30/2018 Sandals Website 247 $4,888.68 1/31/2018 Hats Retail 189 $3,439.77 1/31/2018 Hats Website 381 $6,902.31 1/31/2018 Shoes Retail 105 $5,821.93 1/31/2018 Shoes Website 427 $23,151.29 1/31/2018 Sandals Retail 56 $1,123.67 1/31/2018 Sandals Website 254 $5,011.69