Question: Use data provided to answer the following: ) Promotional effect on sales for each product 2) Daily Breakdown of sales for each product (Monday, Tuesday,
Use data provided to answer the following: ) Promotional effect on sales for each product 2) Daily Breakdown of sales for each product (Monday, Tuesday, etc.) 3) Monthly breakdown of sales for each product (January, February, March, etc.)
| daywk | weekday | Date | Cakes | Pies | Cookies | Smoothies | Coffee | promotion | |||||
| Tuesday | 2 | 1/1/13 | 79 | 46 | 518 | 60 | 233 | none | |||||
| 1 | Monday | Wednesday | 3 | 1/2/13 | 91 | 50 | 539 | 161 | 427 | none | |||
| 2 | Tuesday | Thursday | 4 | 1/3/13 | 47 | 60 | 222 | 166 | 347 | none | |||
| 3 | Wednesday | Friday | 5 | 1/4/13 | 89 | 64 | 734 | 153 | 358 | none | |||
| 4 | Thursday | Saturday | 6 | 1/5/13 | 112 | 73 | 764 | 240 | 392 | none | |||
| 5 | Friday | Sunday | 7 | 1/6/13 | 89 | 57 | 922 | 259 | 510 | none | |||
| 6 | Saturday | Monday | 1 | 1/7/13 | 70 | 50 | 476 | 120 | 334 | none | |||
| 7 | Sunday | Tuesday | 2 | 1/8/13 | 70 | 48 | 496 | 222 | 316 | none | |||
| Wednesday | 3 | 1/9/13 | 59 | 37 | 587 | 181 | 156 | none | |||||
| Thursday | 4 | 1/10/13 | 71 | 36 | 488 | 178 | 298 | none | |||||
| Friday | 5 | 1/11/13 | 74 | 50 | 645 | 100 | 490 | none | |||||
| Saturday | 6 | 1/12/13 | 119 | 71 | 438 | 162 | 416 | none | |||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
