1. Using the Tissue.xlsx data file, and assuming that each type of toilet tissue should be assigned to one of the following brands: Charmin, Dominick's, Kleenex, Northern, Scott, answer the following questions: a. What is the average profit per case sold at each of the stores in the data set? b. Which brand (Charmin, Dominick's, Kleenex, Northern, Scott) is the market leader based on total number of packages sold? How many packages did this brand sell? c. Which brand is the market leader based on total revenue? What is the total revenue for this brand? d. Look more carefully at total sales of Scott brand tissue by week. Do you see anything that would cause you concern in thinking that there might be additional data errors? If so, what would cause you concern?

CASE MOVE SALE SIZE 4 CT QTY 1.00 12 24 WEEK 383 384 385 386 17 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 12 12 12 12 20 31 28 1.00 1.00 1.00 1.00 1.00 387 12 28 12 14 1.00 12 17 12 4 CT 4 CT 388 389 390 391 392 383 384 PRICE 2.59 2.59 2.59 2.59 2.59 2.59 2.59 2.59 2.49 2.49 2.59 2.59 2.59 2.59 2.59 2.59 2.59 1.00 1.00 S 1.00 S 1.00 12 33 94 25 25 12 12 12 STORE 100 100 100 100 100 100 100 100 100 100 101 101 101 101 101 101 101 101 101 101 102 102 102 102 385 10 12 8 12 18 COM_CODE UPC DESCRIP 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 12 18 NITEM 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 12 PROFIT 18.61 19.38 18.61 18.61 18.61 18.61 18.61 18.61 15.34 26.98 18.61 19.38 18.61 18.61 18.61 18.61 18.61 18.61 15.34 26.98 18.61 19.38 18.61 18.61 0.00 0.00 0.00 0.00 0.00 26.98 18.61 19.38 18.61 12 OK 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 12 15 386 387 388 389 390 391 392 383 384 385 386 12 24 12 40 2.59 2.49 2.49 2.59 2.59 12 4 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 S 1.00 S 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 S 1.00 1.00 1.00 12 3 1 11 0 0 12 12 12 102 387 12 12 0 12 2.59 2.59 0.00 0.00 0.00 0.00 0.00 2.49 2.59 0 12 0 102 102 102 102 102 103 103 103 4 CT 4 CT 388 389 390 391 392 383 384 385 12 165 9 12 4 CT 4 CT 2.59 12 12 9 6 4 CT 2.59 1.00 CASE MOVE SALE SIZE 4 CT QTY 1.00 12 24 WEEK 383 384 385 386 17 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 12 12 12 12 20 31 28 1.00 1.00 1.00 1.00 1.00 387 12 28 12 14 1.00 12 17 12 4 CT 4 CT 388 389 390 391 392 383 384 PRICE 2.59 2.59 2.59 2.59 2.59 2.59 2.59 2.59 2.49 2.49 2.59 2.59 2.59 2.59 2.59 2.59 2.59 1.00 1.00 S 1.00 S 1.00 12 33 94 25 25 12 12 12 STORE 100 100 100 100 100 100 100 100 100 100 101 101 101 101 101 101 101 101 101 101 102 102 102 102 385 10 12 8 12 18 COM_CODE UPC DESCRIP 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 552 3600060610 KLEENEX COTTONELLE U 12 18 NITEM 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 1100571 12 PROFIT 18.61 19.38 18.61 18.61 18.61 18.61 18.61 18.61 15.34 26.98 18.61 19.38 18.61 18.61 18.61 18.61 18.61 18.61 15.34 26.98 18.61 19.38 18.61 18.61 0.00 0.00 0.00 0.00 0.00 26.98 18.61 19.38 18.61 12 OK 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 4 CT 12 15 386 387 388 389 390 391 392 383 384 385 386 12 24 12 40 2.59 2.49 2.49 2.59 2.59 12 4 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 S 1.00 S 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 S 1.00 1.00 1.00 12 3 1 11 0 0 12 12 12 102 387 12 12 0 12 2.59 2.59 0.00 0.00 0.00 0.00 0.00 2.49 2.59 0 12 0 102 102 102 102 102 103 103 103 4 CT 4 CT 388 389 390 391 392 383 384 385 12 165 9 12 4 CT 4 CT 2.59 12 12 9 6 4 CT 2.59 1.00