Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

prepare a brief analysis of the data set. prepare an Excel analysis that will help you to address: Important trends/events in the appropriate marketing channels

prepare a brief analysis of the data set. prepare an Excel analysis that will help you to address:

  • Important trends/events in the appropriate marketing channels and products
  • A forecast of the next months expected sales (assuming no additional changes beyond whats 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

I can give the excel file below but not sure how else to submit this.

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Date 1/1/2018 1/1/2018 1/1/2018 1/1/2018 1/1/2018 1/1/2018 1/2/2018 1/2/2018 1/2/2018 1/2/2018 1/2/2018 1/2/2018 1/3/2018 1/3/2018 1/3/2018 1/3/2018 1/3/2018 1/3/2018 1/4/2018 1/4/2018 1/4/2018 1/4/2018 1/4/2018 1/4/2018 1/5/2018 1/5/2018 1/5/2018 1/5/2018 1/5/2018 1/5/2018 1/6/2018 1/6/2018 1/6/2018 1/6/2018 1/6/2018 1/6/2018 1/7/2018 1/7/2018 1/7/2018 1/7/2018 1/7/2018 1/7/2018 1/8/2018 1/8/2018 1/8/2018 1/8/2018 1/8/2018 1/8/2018 1/9/2018 1/9/2018 Product Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Channel Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Units 214 380 124 194 58 160 216 374 124 199 56 159 220 368 121 204 55 160 229 366 119 212 54 160 234 368 120 221 53 164 239 376 119 230 52 167 248 382 118 240 51 166 252 392 115 247 50 167 257 400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Revenue 3,210.00 5,728.50 6,697.24 10,499.28 1,627.25 4,408.32 3,175.37 5,530.28 6,854.05 10,766.39 1,550.40 4,371.43 3,277.58 5,436.27 6,550.08 11,073.93 1,519.57 4,423.90 3,454.42 5,458.57 6,406.35 11,621.95 1,492.36 4,431.76 3,498.08 5,557.62 6,641.70 12,159.54 1,449.39 4,607.71 3,563.42 5,541.09 6,569.34 12,721.85 1,465.50 4,676.79 3,729.58 5,619.41 6,425.84 13,257.20 1,403.43 4,563.65 3,719.78 5,798.24 6,221.42 13,445.49 1,396.49 4,641.78 3,839.28 5,916.29 116 256 50 169 266 415 115 265 49 1/9/2018 1/9/2018 1/9/2018 1/9/2018 1/10/2018 1/10/2018 1/10/2018 1/10/2018 1/10/2018 1/10/2018 1/11/2018 1/11/2018 1/11/2018 1/11/2018 1/11/2018 1/11/2018 1/12/2018 1/12/2018 1/12/2018 1/12/2018 1/12/2018 1/12/2018 1/13/2018 1/13/2018 1/13/2018 1/13/2018 1/13/2018 1/13/2018 1/14/2018 1/14/2018 1/14/2018 1/14/2018 1/14/2018 1/14/2018 1/15/2018 1/15/2018 1/15/2018 1/15/2018 1/15/2018 1/15/2018 1/16/2018 1/16/2018 1/16/2018 1/16/2018 1/16/2018 1/16/2018 1/17/2018 1/17/2018 1/17/2018 1/17/2018 1/17/2018 Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail 171 272 429 112 274 49 175 277 437 111 284 48 177 284 456 109 293 47 181 276 464 108 302 46 185 270 453 108 313 45 190 265 442 105 319 44 192 260 431 106 332 44 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 6,411.72 13,969.68 1,414.59 4,720.88 4,010.22 6,209.71 6,284.72 14,499.47 1,349.36 4,758.06 4,056.68 6,407.03 6,060.33 15,049.30 1,362.98 4,961.13 4,090.84 6,438.99 6,036.61 15,573.04 1,350.70 4,930.89 4,256.31 6,860.74 5,862.41 15,969.62 1,294.79 5,090.55 4,890.95 8,208.03 5,916.30 16,492.16 1,267.75 5,218.57 4,842.16 8,003.66 5,939.98 17.117.70 1,243.78 5,371.04 4,745.68 7,796.41 5,687.88 17,218.44 1,235.09 5,327.57 4,660.48 7,617.81 5,873.51 18,290.53 1,232.57 1/17/2018 1/18/2018 1/18/2018 1/18/2018 1/18/2018 1/18/2018 1/18/2018 1/19/2018 1/19/2018 1/19/2018 1/19/2018 1/19/2018 1/19/2018 1/20/2018 1/20/2018 1/20/2018 1/20/2018 1/20/2018 1/20/2018 1/21/2018 1/21/2018 1/21/2018 1/21/2018 1/21/2018 1/21/2018 1/22/2018 1/22/2018 1/22/2018 1/22/2018 1/22/2018 1/22/2018 1/23/2018 1/23/2018 1/23/2018 1/23/2018 1/23/2018 1/23/2018 1/24/2018 1/24/2018 1/24/2018 1/24/2018 1/24/2018 1/24/2018 1/25/2018 1/25/2018 1/25/2018 1/25/2018 1/25/2018 1/25/2018 1/26/2018 1/26/2018 Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website 192 253 423 107 342 43 187 249 422 108 347 41 184 242 414 111 357 40 177 233 407 111 365 39 174 230 401 110 367 40 183 223 403 108 377 42 191 222 398 107 383 44 198 216 398 107 386 45 205 209 396 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Wooooooooooooooo 5,277.93 4,499.05 7,511.69 5,783.85 19,012.32 1,207.57 5,235.47 4,467.47 7,610.61 5,929.42 19,009.03 1,155.06 5,141.04 4,286.68 7,347.31 6,084.36 19,799.68 1,129.41 4,878.29 4,121.15 7,222.86 5,966.13 20,115.61 1,071.58 4,868.18 4,137.95 7,150.93 6,069.62 19,948.03 796.05 3,703.09 3,954.52 7,324.10 5,835.52 20,904.61 843.75 3,793.19 4,034.01 7,114.67 5,806.76 20,921.14 873.14 3,944.07 3,855.87 7,186.14 5,953.55 20,956.23 901.72 4,043.44 3,692.00 7,121.73 1/26/2018 1/26/2018 1/26/2018 1/26/2018 1/26/2018 1/27/2018 1/27/2018 1/27/2018 1/27/2018 1/27/2018 1/27/2018 1/28/2018 1/28/2018 1/28/2018 1/28/2018 1/28/2018 1/28/2018 1/29/2018 1/29/2018 1/29/2018 1/29/2018 1/29/2018 1/29/2018 1/30/2018 1/30/2018 1/30/2018 1/30/2018 1/30/2018 1/30/2018 1/31/2018 1/31/2018 1/31/2018 1/31/2018 1/31/2018 1/31/2018 Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website 396 106 395 47 213 202 387 107 404 48 218 199 384 108 410 50 229 194 385 107 414 52 239 190 381 104 424 53 247 189 381 105 427 56 254 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7,121.73 5,824.07 21,808.40 925.62 4,225.55 3,560.25 6,833.31 5,953.07 22,244.66 953.02 4,275.15 3,592.74 6,909.93 5,970.85 22,418.38 986.19 4,590.56 3,454.52 6,965.10 5,858.54 22,569.85 1,047.38 4,787.59 3,406.23 6,820.23 5,632.19 23,463.20 1,049.50 4,888.68 3,439.77 6,902.31 5,821.93 23,151.29 1,123.67 5,011.69 Date 1/1/2018 1/1/2018 1/1/2018 1/1/2018 1/1/2018 1/1/2018 1/2/2018 1/2/2018 1/2/2018 1/2/2018 1/2/2018 1/2/2018 1/3/2018 1/3/2018 1/3/2018 1/3/2018 1/3/2018 1/3/2018 1/4/2018 1/4/2018 1/4/2018 1/4/2018 1/4/2018 1/4/2018 1/5/2018 1/5/2018 1/5/2018 1/5/2018 1/5/2018 1/5/2018 1/6/2018 1/6/2018 1/6/2018 1/6/2018 1/6/2018 1/6/2018 1/7/2018 1/7/2018 1/7/2018 1/7/2018 1/7/2018 1/7/2018 1/8/2018 1/8/2018 1/8/2018 1/8/2018 1/8/2018 1/8/2018 1/9/2018 1/9/2018 Product Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Channel Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Units 214 380 124 194 58 160 216 374 124 199 56 159 220 368 121 204 55 160 229 366 119 212 54 160 234 368 120 221 53 164 239 376 119 230 52 167 248 382 118 240 51 166 252 392 115 247 50 167 257 400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Revenue 3,210.00 5,728.50 6,697.24 10,499.28 1,627.25 4,408.32 3,175.37 5,530.28 6,854.05 10,766.39 1,550.40 4,371.43 3,277.58 5,436.27 6,550.08 11,073.93 1,519.57 4,423.90 3,454.42 5,458.57 6,406.35 11,621.95 1,492.36 4,431.76 3,498.08 5,557.62 6,641.70 12,159.54 1,449.39 4,607.71 3,563.42 5,541.09 6,569.34 12,721.85 1,465.50 4,676.79 3,729.58 5,619.41 6,425.84 13,257.20 1,403.43 4,563.65 3,719.78 5,798.24 6,221.42 13,445.49 1,396.49 4,641.78 3,839.28 5,916.29 116 256 50 169 266 415 115 265 49 1/9/2018 1/9/2018 1/9/2018 1/9/2018 1/10/2018 1/10/2018 1/10/2018 1/10/2018 1/10/2018 1/10/2018 1/11/2018 1/11/2018 1/11/2018 1/11/2018 1/11/2018 1/11/2018 1/12/2018 1/12/2018 1/12/2018 1/12/2018 1/12/2018 1/12/2018 1/13/2018 1/13/2018 1/13/2018 1/13/2018 1/13/2018 1/13/2018 1/14/2018 1/14/2018 1/14/2018 1/14/2018 1/14/2018 1/14/2018 1/15/2018 1/15/2018 1/15/2018 1/15/2018 1/15/2018 1/15/2018 1/16/2018 1/16/2018 1/16/2018 1/16/2018 1/16/2018 1/16/2018 1/17/2018 1/17/2018 1/17/2018 1/17/2018 1/17/2018 Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail 171 272 429 112 274 49 175 277 437 111 284 48 177 284 456 109 293 47 181 276 464 108 302 46 185 270 453 108 313 45 190 265 442 105 319 44 192 260 431 106 332 44 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 6,411.72 13,969.68 1,414.59 4,720.88 4,010.22 6,209.71 6,284.72 14,499.47 1,349.36 4,758.06 4,056.68 6,407.03 6,060.33 15,049.30 1,362.98 4,961.13 4,090.84 6,438.99 6,036.61 15,573.04 1,350.70 4,930.89 4,256.31 6,860.74 5,862.41 15,969.62 1,294.79 5,090.55 4,890.95 8,208.03 5,916.30 16,492.16 1,267.75 5,218.57 4,842.16 8,003.66 5,939.98 17.117.70 1,243.78 5,371.04 4,745.68 7,796.41 5,687.88 17,218.44 1,235.09 5,327.57 4,660.48 7,617.81 5,873.51 18,290.53 1,232.57 1/17/2018 1/18/2018 1/18/2018 1/18/2018 1/18/2018 1/18/2018 1/18/2018 1/19/2018 1/19/2018 1/19/2018 1/19/2018 1/19/2018 1/19/2018 1/20/2018 1/20/2018 1/20/2018 1/20/2018 1/20/2018 1/20/2018 1/21/2018 1/21/2018 1/21/2018 1/21/2018 1/21/2018 1/21/2018 1/22/2018 1/22/2018 1/22/2018 1/22/2018 1/22/2018 1/22/2018 1/23/2018 1/23/2018 1/23/2018 1/23/2018 1/23/2018 1/23/2018 1/24/2018 1/24/2018 1/24/2018 1/24/2018 1/24/2018 1/24/2018 1/25/2018 1/25/2018 1/25/2018 1/25/2018 1/25/2018 1/25/2018 1/26/2018 1/26/2018 Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website 192 253 423 107 342 43 187 249 422 108 347 41 184 242 414 111 357 40 177 233 407 111 365 39 174 230 401 110 367 40 183 223 403 108 377 42 191 222 398 107 383 44 198 216 398 107 386 45 205 209 396 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Wooooooooooooooo 5,277.93 4,499.05 7,511.69 5,783.85 19,012.32 1,207.57 5,235.47 4,467.47 7,610.61 5,929.42 19,009.03 1,155.06 5,141.04 4,286.68 7,347.31 6,084.36 19,799.68 1,129.41 4,878.29 4,121.15 7,222.86 5,966.13 20,115.61 1,071.58 4,868.18 4,137.95 7,150.93 6,069.62 19,948.03 796.05 3,703.09 3,954.52 7,324.10 5,835.52 20,904.61 843.75 3,793.19 4,034.01 7,114.67 5,806.76 20,921.14 873.14 3,944.07 3,855.87 7,186.14 5,953.55 20,956.23 901.72 4,043.44 3,692.00 7,121.73 1/26/2018 1/26/2018 1/26/2018 1/26/2018 1/26/2018 1/27/2018 1/27/2018 1/27/2018 1/27/2018 1/27/2018 1/27/2018 1/28/2018 1/28/2018 1/28/2018 1/28/2018 1/28/2018 1/28/2018 1/29/2018 1/29/2018 1/29/2018 1/29/2018 1/29/2018 1/29/2018 1/30/2018 1/30/2018 1/30/2018 1/30/2018 1/30/2018 1/30/2018 1/31/2018 1/31/2018 1/31/2018 1/31/2018 1/31/2018 1/31/2018 Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Hats Hats Shoes Shoes Sandals Sandals Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website Retail Website 396 106 395 47 213 202 387 107 404 48 218 199 384 108 410 50 229 194 385 107 414 52 239 190 381 104 424 53 247 189 381 105 427 56 254 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7,121.73 5,824.07 21,808.40 925.62 4,225.55 3,560.25 6,833.31 5,953.07 22,244.66 953.02 4,275.15 3,592.74 6,909.93 5,970.85 22,418.38 986.19 4,590.56 3,454.52 6,965.10 5,858.54 22,569.85 1,047.38 4,787.59 3,406.23 6,820.23 5,632.19 23,463.20 1,049.50 4,888.68 3,439.77 6,902.31 5,821.93 23,151.29 1,123.67 5,011.69

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services A Systematic Approach

Authors: William Messier, Steven Glover, Douglas Prawitt

5th Edition

007333720X, 9780073337203

More Books

Students also viewed these Accounting questions