| Year | Customer # | Number of orders per year | $ Sales per year | Coupon Value | | SCENARIO & QUESTIONS |
| 2018 | 123228 | 215 | $ 308,202 |
| 2018 | 190347 | 822 | $ 271,848 | | | The Excel table shows years 2018 and 2019 data related to the number of orders and $ sales per customer for a certain company. The manager asked you to perform the following analysis related to sending discount coupons. |
| 2018 | 103339 | 377 | $ 384,960 |
| 2018 | 121959 | 682 | $ 324,685 |
| 2018 | 145784 | 750 | $ 105,331 | | | Q1- (2 points) Develop a pseudo code that will offer the following discounts: |
| 2018 | 185008 | 734 | $ 159,702 | | | 10% coupon for those customers whose $ Sales per year were less than $200,000 |
| 2018 | 135101 | 286 | $ 147,704 | | | 20% coupon for those customers whose $ Sales per year were between $200,000 and $300,000 |
| 2018 | 180643 | 972 | $ 203,781 | | | 30% coupon for those customers whose $ Sales per year exceeded $300,000 |
| 2018 | 150454 | 495 | $ 354,516 |
| 2018 | 142618 | 825 | $ 140,862 | | | Provide your answer below |
| 2018 | 178586 | 728 | $ 273,881 |
| 2018 | 153882 | 959 | $ 197,774 |
| 2018 | 154210 | 429 | $ 289,290 |
| 2018 | 170639 | 649 | $ 287,928 |
| 2018 | 108237 | 756 | $ 406,182 |
| 2018 | 185934 | 932 | $ 267,018 |
| 2018 | 135464 | 730 | $ 445,120 | | | Q2- (4 points) Develop your if statements in column E so that E2 … E49 will show the coupon value based on Q1: |
| 2018 | 192185 | 666 | $ 111,456 |
| 2018 | 196741 | 194 | $ 326,290 |
| 2018 | 137436 | 280 | $ 315,003 |
| 2018 | 152854 | 461 | $ 312,765 | | | Q3- (2 points) Format $ Sales per year column have a graded color scale (do not manually highlight). |
| 2018 | 185096 | 742 | $ 273,152 |
| 2018 | 142718 | 912 | $ 206,862 |
| 2018 | 198289 | 930 | $ 301,515 | | | Q4- (1 point) Edit your work so that random number generations stops in both Number of orders and $ Sales per year columns |
| 2018 | 163071 | 806 | $ 101,804 |
| 2018 | 198012 | 269 | $ 204,116 |
| 2018 | 147668 | 686 | $ 459,485 | | | Q5- (1 point) Rearrange your spreadsheet so that listing will be orgnized based on coupon value. |
| 2018 | 117799 | 209 | $ 241,132 |
| 2018 | 113916 | 816 | $ 368,371 |
| 2018 | 181187 | 289 | $ 205,592 | | | Make sure you keep saving your file and submit to Blackboard before time is up. |
| 2018 | 199516 | 771 | $ 394,963 | | | You may email me your file as a last resort; however, it won't be considered submitted on time and therefore graded if modifications took place past due date (submit as is). |
| 2018 | 135059 | 374 | $ 202,612 |
| 2018 | 158257 | 798 | $ 331,345 |
| 2018 | 190495 | 399 | $ 227,039 |
| 2018 | 194305 | 640 | $ 101,145 |
| 2018 | 173213 | 279 | $ 200,098 |
| 2018 | 163640 | 641 | $ 392,383 |
| 2018 | 199029 | 970 | $ 219,672 |
| 2018 | 152551 | 452 | $ 442,009 |
| 2018 | 188212 | 410 | $ 476,326 |
| 2018 | 193239 | 108 | $ 350,255 |
| 2018 | 133758 | 110 | $ 182,638 |
| 2018 | 136788 | 299 | $ 417,104 |
| 2018 | 150143 | 189 | $ 318,837 |
| 2018 | 172593 | 945 | $ 179,311 |
| 2018 | 156038 | 420 | $ 246,124 |
| 2018 | 183858 | 910 | $ 203,426 |
| 2018 | 138926 | 151 | $ 299,406 |
czh1211
1.xlsx
