Using Basic Excel Functions (Formatting, Formulas, Etc.)

Raw data Ord_id Order_Date Order_Priority Prod_id Product_Category Product_Sub_Category Cust_id Sales Discount Order_Quantity Profit Shipping_Cost Product_Base_Margin Ord_1343 1/3/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_501 434.77 0.02 37 -155.21 11.25 0.36 Ord_1438 1/4/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_540 2478.88 0.02 6 593.59 19.99 0.38 923.134912 Ord_131 1/4/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_78 1049.79 0.08 21 135.79 19.99 0.55 Ord_131 1/4/18 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_78 817.18 0.1 16 103.38 5.08 0.59 Ord_1044 1/5/18 CRITICAL Prod_10 FURNITURE BOOKCASES Cust_391 3904.12 0.07 50 -1508.46 55.81 0.6 Ord_1044 1/5/18 CRITICAL Prod_5 FURNITURE OFFICE FURNISHINGS Cust_391 343.64 0.06 41 13.29 3.44 0.49 Ord_1045 1/5/18 LOW Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_391 256.64 0.03 42 -28.29 3.37 0.54 Ord_1339 1/5/18 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_499 156.47 0.01 20 -39.23 6.05 0.39 Ord_1015 1/6/18 CRITICAL Prod_9 OFFICE SUPPLIES ENVELOPES Cust_370 124.06 0.09 17 15.74 2.5 0.38 Ord_1272 1/6/18 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_464 6739.92 0.01 35 957.29 30 0.69 Ord_1340 1/7/18 CRITICAL Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_511 1559.5 0.01 38 515.83 1.99 0.54 Ord_1083 1/11/18 LOW Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_418 192.33 0.01 44 48.54 1.2 0.44 Ord_1212 1/12/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_458 464.59 0.07 17 168.22 1.49 0.38 Ord_1212 1/12/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_458 316.68 0.06 47 -161 7.49 0.37 Ord_1338 1/12/18 LOW Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_490 194.29 0.09 29 -177.17 8.37 0.58 Ord_1338 1/12/18 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_490 1621.1 0.07 33 -971.36 35 0.83 Ord_1005 1/18/18 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_377 35.48 0.09 14 -9.19 1.3 0.59 Ord_1005 1/18/18 HIGH Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_377 15 0.05 1 -11.02 8.37 0.58 Ord_1020 1/22/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_1143 4584.73 0.07 27 812.38 19.99 0.48 Ord_1020 1/22/18 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_1143 2570.944 0.03 25 553.36 5.92 0.58 Ord_1020 1/22/18 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_1143 4039.72 0.02 44 -237.6 39.61 0.67 Ord_1020 1/22/18 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_386 562.8 0.02 36 -17.45 9.73 0.36 Ord_1002 1/26/18 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_375 1756.46 0.01 15 -101.19 30 0.69 Ord_1278 2/1/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_467 70.25 0.1 34 -133.06 5.33 0.43 Ord_1274 2/2/18 LOW Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_471 5.7 0.1 1 -2.34 2 0.53 Ord_1567 2/2/18 MEDIUM Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_540 66.41 0.04 36 0.37 0.79 0.5 Ord_1113 2/3/18 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_411 1375.3765 0.03 45 592.22 3.3 0.39 Ord_1121 2/3/18 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_428 11041.42 0.07 30 4456.25 19.99 0.38 Ord_1143 2/3/18 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_438 303.59 0.1 32 -45.99 6.22 0.55 Ord_1143 2/3/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_438 191.6 0.04 36 -150.74 7.44 0.36 Ord_1481 2/3/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_515 393.31 0.04 20 84.3 5.86 0.38 Ord_1289 2/4/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_454 513.74 0.02 32 -28.68 10.13 0.38 Ord_1289 2/4/18 NOT SPECIFIED Prod_5 FURNITURE OFFICE FURNISHINGS Cust_454 36.8 0 4 14.19 5.21 0.56 Ord_1486 2/4/18 MEDIUM Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_513 487.5 0.05 46 -25.88 4.68 0.59 Ord_1486 2/4/18 MEDIUM Prod_2 OFFICE SUPPLIES APPLIANCES Cust_513 97.93 0.07 14 -616.81 49 0.59 Ord_1486 2/4/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_513 25.52 0.07 4 -1.99 1.49 0.39 Ord_1051 2/6/18 NOT SPECIFIED Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_401 824.24 0.1 32 -127.23 5.89 0.75 Ord_1132 2/7/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_412 445.17 0.02 23 38.11 9.03 0.37 Ord_1120 2/7/18 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_416 1455.04 0.06 9 -7.58 19.99 0.66 Ord_144 2/8/18 NOT SPECIFIED Prod_17 TECHNOLOGY OFFICE MACHINES Cust_71 4865.72 0.03 24 1951.3 15.59 0.36 Ord_1154 2/9/18 NOT SPECIFIED Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_444 116.82 0.02 24 -42.05 2.39 0.72 Ord_1154 2/9/18 NOT SPECIFIED Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_444 483.64 0.1 45 28.39 3.37 0.57 Ord_1413 2/11/18 LOW Prod_6 OFFICE SUPPLIES PAPER Cust_488 83.31 0.06 13 22.8 1.34 0.36 Ord_1342 2/11/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_513 457.68 0.07 16 107.38 6.27 0.37 Ord_1028 2/12/18 NOT SPECIFIED Prod_11 FURNITURE TABLES Cust_384 10006.28 0.1 36 -760.98 61.76 0.78 Ord_1028 2/12/18 NOT SPECIFIED Prod_9 OFFICE SUPPLIES ENVELOPES Cust_384 407.17 0.04 36 -12.82 6.97 0.35 Ord_1368 2/12/18 MEDIUM Prod_12 OFFICE SUPPLIES LABELS Cust_527 66.19 0.02 22 15.84 0.99 0.36 Ord_1368 2/12/18 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_803 1100.21 0.03 50 433.59 1.99 0.43 Ord_1003 2/13/18 CRITICAL Prod_9 OFFICE SUPPLIES ENVELOPES Cust_376 49.04 0.02 8 9.29 1.39 0.38 Ord_1003 2/13/18 CRITICAL Prod_11 FURNITURE TABLES Cust_376 2320.35 0 6 -237.62 84.84 0.66 Ord_1016 2/16/18 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_383 138.05 0.09 19 -100.49 5.53 0.69 Ord_105 2/18/18 NOT SPECIFIED Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_74 10554.63 0.09 30 1240.25 58.92 0.64 Ord_105 2/18/18 NOT SPECIFIED Prod_11 FURNITURE TABLES Cust_74 1749.64 0.04 8 -533.23 69.64 0.77 Ord_1011 2/19/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_381 3465.97 0.08 4 194.32 19.99 0.38 Ord_1011 2/19/18 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_381 1307.88 0.06 13 206.86 7.18 0.46 Ord_1059 2/21/18 MEDIUM Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_393 71.12 0.1 38 -21.89 0.7 0.83 Ord_1030 2/23/18 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_374 834.81 0.03 22 1.98 12.9 0.57 Ord_1017 2/26/18 NOT SPECIFIED Prod_5 FURNITURE OFFICE FURNISHINGS Cust_384 433.44 0.1 29 147.46 3.73 0.46 Ord_1167 3/1/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_444 85.56 0.03 15 -41.58 5.66 0.4 Ord_1167 3/1/18 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_444 754.6555 0.01 8 -212.55 2.5 0.57 Ord_153 3/3/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_80 261.88 0.08 7 -59.2 1.99 0.54 Ord_153 3/3/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_80 593.73 0.04 15 108.01 13.26 0.36 Ord_1064 3/4/18 CRITICAL Prod_17 TECHNOLOGY OFFICE MACHINES Cust_404 1409.86 0.07 1 -3461.12 29.7 0.57 Ord_1375 3/4/18 NOT SPECIFIED Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_498 2703.37 0.09 18 -231.6 57.2 0.59 Ord_1375 3/4/18 NOT SPECIFIED Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_498 1538.17 0.02 39 -1119.64 35 0.8 Ord_1025 3/5/18 CRITICAL Prod_9 OFFICE SUPPLIES ENVELOPES Cust_376 364.8 0.01 42 149.45 1.39 0.38 Ord_1171 3/5/18 MEDIUM Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_448 150.33 0.08 15 -98.23 9.45 0.6 Ord_1591 3/5/18 LOW Prod_6 OFFICE SUPPLIES PAPER Cust_490 112.91 0.04 16 -72.81 8.4 0.37 Ord_1591 3/5/18 LOW Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_490 180.92 0.1 22 -82.54 6.14 0.59 Ord_1591 3/5/18 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_490 31.68 0.04 17 -23.69 1.99 0.51 Ord_1332 3/6/18 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_503 2508.673 0.03 23 417.47 7.69 0.58 Ord_1075 3/7/18 HIGH Prod_10 FURNITURE BOOKCASES Cust_411 1209.37 0.09 8 -407.85 66.27 0.65 Ord_1093 3/7/18 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_422 113.09 0.04 39 29.76 0.81 0.4 Ord_1231 3/7/18 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_467 5051.89 0.02 47 1708.84 5.81 0.65 Ord_127 3/7/18 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_86 54.78 0.02 32 -30.54 1.57 0.59 Ord_127 3/7/18 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_86 304.83 0.1 47 23.82 2.35 0.47 Ord_1073 3/8/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_410 270.43 0.07 37 -83.16 6.16 0.35 Ord_1575 3/10/18 LOW Prod_6 OFFICE SUPPLIES PAPER Cust_500 945.54 0.03 48 254.58 5.97 0.38 Ord_1585 3/12/18 NOT SPECIFIED Prod_5 FURNITURE OFFICE FURNISHINGS Cust_568 3234.1 0.03 32 2033.5 8.99 0.35 Ord_1039 3/23/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_398 188.07 0 27 -101.85 7.86 0.37 Ord_1024 3/24/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_373 75.27 0.06 13 -1.84 2.99 0.37 Ord_1024 3/24/18 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_373 3683.73 0.09 35 708.76 8.99 0.59 Ord_1024 3/24/18 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_373 1184.53 0.05 31 -26.49 7.12 0.67 Ord_1107 4/1/18 HIGH Prod_2 OFFICE SUPPLIES APPLIANCES Cust_428 876.75 0.02 3 -248.69 19.99 0.56 Ord_1107 4/1/18 HIGH Prod_14 TECHNOLOGY COPIERS AND FAX Cust_428 2249.05 0.02 5 -571.24 24.49 0.52 Ord_1107 4/1/18 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_428 4813.67 0.03 48 44.58 19.99 0.79 Ord_1344 4/1/18 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_514 218.77 0.03 38 -188.13 7.78 0.37 Ord_1122 4/2/18 MEDIUM Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_412 73.55 0.09 32 7.95 0.78 0.52 Ord_1122 4/2/18 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_412 4804.0385 0.08 46 1077.92 8.8 0.59 Ord_1139 4/2/18 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_422 69.66 0.07 40 -51.42 1.99 0.51 Ord_1021 4/3/18 CRITICAL Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_387 5544.99 0.04 43 -3404.24 130 0.78 Ord_1525 4/3/18 MEDIUM Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_501 11266.4 0.08 50 1902.99 43.32 0.55 Ord_1525 4/3/18 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_501 71.61 0.1 15 -70.31 4.93 0.66 Ord_1525 4/3/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_501 10.43 0.07 2 -4.72 0.8 0.36 Ord_1054 4/4/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_391 330.22 0.07 21 -51.72 10.91 0.36 Ord_1538 4/5/18 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_558 210.86 0.04 21 5.5 6.02 0.48 Ord_1564 4/7/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_500 916.05 0.08 39 -21.9 12.98 0.39 Ord_1473 4/7/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_554 99.36 0 18 -51.2 5.68 0.36 Ord_1473 4/7/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_554 510.15 0.04 49 -362.11 12.52 0.57 Ord_1473 4/7/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_554 735.09 0.1 27 153.5 7.87 0.54 Ord_10 4/8/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_10 80.61 0.02 15 -4.72 2.99 0.37 Ord_1501 4/8/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_508 191.43 0.06 20 39.5 2.99 0.39 Ord_1501 4/8/18 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_508 1234.85 0.03 34 212.2 8.22 0.57 Ord_142 4/8/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_51 17.19 0 1 -35.34 1.99 0.49 Ord_142 4/8/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_51 15.31 0.01 2 -8.15 4.86 0.38 Ord_142 4/8/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_51 2689.48 0.04 27 399.93 19.99 0.5 Ord_1133 4/10/18 MEDIUM Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_421 2329.4 0.08 37 189.77 6.88 0.73 Ord_1268 4/10/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_478 103.72 0.02 17 -72.06 6.98 0.39 Ord_1268 4/10/18 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_478 185.15 0.09 4 10.2 34.2 0.73 Ord_1268 4/10/18 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_478 308.64 0.03 15 91.08 6.38 0.56 Ord_1119 4/11/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_417 58.98 0 9 -17.79 4.97 0.35 Ord_1102 4/12/18 CRITICAL Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_427 54.8 0 5 -15.3 1.99 0.43 Ord_1102 4/12/18 CRITICAL Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_427 1038.19 0.07 40 230.69 4.08 0.57 Ord_1136 4/12/18 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_436 39.44 0 5 -0.94 2.99 0.35 Ord_1136 4/12/18 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_436 11.01 0.09 3 -1.42 5.33 0.43 Ord_1374 4/12/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_511 292.96 0.09 3 -322.95 19.99 0.52 Ord_1374 4/12/18 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_511 2206.991 0.04 13 -1.63 5.26 0.56 Ord_1236 5/1/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_468 154.44 0.06 33 54.62 0.88 0.39 Ord_1251 5/1/18 CRITICAL Prod_5 FURNITURE OFFICE FURNISHINGS Cust_469 4201.08 0.01 21 1162.76 11.54 0.59 Ord_1251 5/1/18 CRITICAL Prod_5 FURNITURE OFFICE FURNISHINGS Cust_469 8958.46 0.02 41 2593.14 21.21 0.59 Ord_1251 5/1/18 CRITICAL Prod_17 TECHNOLOGY OFFICE MACHINES Cust_469 4913.7 0 33 1054.93 17.85 0.56 Ord_1335 5/1/18 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_508 120.53 0.1 10 49.26 2.85 0.55 Ord_1052 5/2/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_398 438.47 0.02 14 157.89 2.99 0.35 Ord_1183 5/2/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_451 112.57 0.08 17 -28.53 5.14 0.37 Ord_1183 5/2/18 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_451 1562.69 0 43 287.74 8.22 0.57 Ord_1396 5/2/18 NOT SPECIFIED Prod_5 FURNITURE OFFICE FURNISHINGS Cust_512 75.19 0.06 22 -59.12 3.97 0.58 Ord_1396 5/2/18 NOT SPECIFIED Prod_11 FURNITURE TABLES Cust_694 3028.86 0.04 40 -2595.65 69 0.68 Ord_1128 5/3/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_435 186.67 0.02 9 2.06 8.68 0.37 Ord_1128 5/3/18 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_435 185.79 0.02 5 -159.68 7.53 0.76 Ord_1128 5/3/18 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_435 196.41 0.01 9 27.91 11.17 0.6 Ord_1128 5/3/18 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_928 2051.8235 0.01 36 350.36 8.8 0.58 Ord_1412 5/4/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_526 87.31 0.05 43 -15.09 1.49 0.36 Ord_1529 5/4/18 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_562 564.98 0.1 26 -107.51 15.1 0.38 Ord_1529 5/4/18 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_562 129.48 0.04 18 46.01 2.83 0.37 Ord_1546 5/5/18 LOW Prod_2 OFFICE SUPPLIES APPLIANCES Cust_519 5567.79 0.04 47 1726.66 3.99 0.6 Ord_1546 5/5/18 LOW Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_519 503.2935 0.02 10 -222.82 5 0.83 Ord_1546 5/5/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_519 796.03 0.05 32 -133.71 15.68 0.62 Ord_1061 5/6/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_397 333.3 0.03 15 71.04 1.99 0.43 Ord_1345 5/6/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_486 63.34 0.03 17 -76.02 6.27 0.4 Ord_1345 5/6/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_486 151.35 0.07 42 8.33 1.93 0.35 Ord_1112 5/7/18 NOT SPECIFIED Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_421 325.97 0.02 46 -255.22 8.37 0.58 Ord_1112 5/7/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_421 49.65 0.02 10 8.27 1.49 0.35 Ord_1185 5/7/18 MEDIUM Prod_12 OFFICE SUPPLIES LABELS Cust_451 12.11 0.02 3 -0.98 0.5 0.38 Ord_1137 5/8/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_416 195.51 0.03 26 -105.72 7.72 0.38 Ord_1137 5/8/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_416 377.13 0.02 38 -10.29 6.02 0.48 Ord_1141 5/8/18 LOW Prod_17 TECHNOLOGY OFFICE MACHINES Cust_416 1255.48 0.06 11 -292.65 56.14 0.4 Ord_1141 5/8/18 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_416 411.56 0.09 46 -188.02 7.28 0.57 Ord_102 5/8/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_43 128.21 0.05 19 -55.13 6.57 0.37 Ord_1411 5/8/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_493 1567.51 0.01 40 711.74 5.08 0.38 Ord_1411 5/8/18 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_493 1914.65 0.01 17 73.45 8.64 0.78 Ord_123 5/8/18 NOT SPECIFIED Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_75 82.61 0.08 49 -46.25 1.57 0.59 Ord_1092 5/9/18 NOT SPECIFIED Prod_5 FURNITURE OFFICE FURNISHINGS Cust_1426 927.82 0.02 43 255.03 6.67 0.49 Ord_1092 5/9/18 NOT SPECIFIED Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_1426 123.37 0.09 27 -6.69 0.7 0.8 Ord_1092 5/9/18 NOT SPECIFIED Prod_5 FURNITURE OFFICE FURNISHINGS Cust_413 90.75 0.02 6 -26.39 14.37 0.73 Ord_1386 5/9/18 HIGH Prod_10 FURNITURE BOOKCASES Cust_494 1992.45 0.05 40 -1609.92 54.11 0.69 Ord_1452 5/9/18 NOT SPECIFIED Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_528 4587.926 0.1 30 687.41 4.2 0.6 Ord_1452 5/9/18 NOT SPECIFIED Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_528 4541.924 0.01 42 1222.14 8.08 0.57 Ord_120 5/9/18 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_82 387 0.01 30 -31.45 6.13 0.57 Ord_1255 5/10/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_464 338.89 0.07 6 45.76 10.75 0.36 Ord_1255 5/10/18 MEDIUM Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_464 362.52 0.07 25 -68.49 7.51 0.57 Ord_1091 5/11/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_421 463 0.07 32 24.61 7.17 0.38 Ord_1057 5/12/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_403 436.98 0.07 35 75.61 4.98 0.48 Ord_117 5/12/18 NOT SPECIFIED Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_81 173.417 0 9 18.23 0.99 0.37 Ord_1067 5/16/18 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_397 7333.45 0.07 27 -207.28 35 0.8 Ord_100 5/16/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_58 121.12 0.1 3 -118.82 1.99 0.44 Ord_1019 5/17/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_385 112.36 0.08 33 -159.74 6.27 0.4 Ord_1019 5/17/18 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_385 481.049 0.09 16 46.51 1.1 0.55 Ord_1031 5/20/18 NOT SPECIFIED Prod_9 OFFICE SUPPLIES ENVELOPES Cust_390 335.35 0.05 39 -134.97 8.29 0.38 Ord_1031 5/20/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_448 148.31 0.03 20 37.33 2.17 0.38 Ord_1055 5/30/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_402 321.71 0.1 6 -2.73 16.11 0.39 Ord_1105 6/1/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_422 108.73 0.04 16 -22.21 5.22 0.6 Ord_1378 6/1/18 CRITICAL Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_532 1446.97 0 47 531.47 1.99 0.5 Ord_1181 6/2/18 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_444 7548.65 0.03 45 1385.35 30 0.62 Ord_1181 6/2/18 LOW Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_444 1318.8685 0.03 24 172.33 3.99 0.59 Ord_1599 6/2/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_542 643.53 0.05 32 175.97 5.77 0.38 Ord_1599 6/2/18 MEDIUM Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_542 1217.77 0.01 27 283.14 6.22 NA Ord_1163 6/4/18 LOW Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_442 77.96 0.05 16 16.65 0.71 0.52 Ord_1243 6/4/18 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_472 2227.34 0.09 20 -609.09 35 NA Ord_1447 6/4/18 MEDIUM Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_519 476.06 0.04 33 -120.48 9.37 0.56 Ord_1491 6/4/18 HIGH Prod_2 OFFICE SUPPLIES APPLIANCES Cust_555 67.87 0.07 29 -112.54 5 0.55 Ord_1491 6/4/18 HIGH Prod_9 OFFICE SUPPLIES ENVELOPES Cust_555 542.24 0.02 33 268.53 1.39 0.38 Ord_1491 6/4/18 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES Cust_555 15174.95 0.02 38 7251.92 48.26 0.36 Ord_1491 6/4/18 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES Cust_555 1084.12 0.04 45 294.43 6.3 0.38 Ord_1443 6/5/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_492 5382.24 0.1 37 14.85 4 0.79 Ord_1443 6/5/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_492 1035.95 0.08 30 342.41 1.99 0.43 Ord_146 6/5/18 CRITICAL Prod_17 TECHNOLOGY OFFICE MACHINES Cust_60 3051.27 0.1 41 121.48 33.6 0.37 Ord_1155 6/6/18 NOT SPECIFIED Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_440 33.64 0.07 4 -35.17 2.83 0.77 Ord_1155 6/6/18 NOT SPECIFIED Prod_17 TECHNOLOGY OFFICE MACHINES Cust_440 701.94 0.01 29 158.91 6.3 0.38 Ord_1357 6/7/18 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_522 482.91 0.1 29 -16.59 6.25 0.58 Ord_1357 6/7/18 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_522 2969.6365 0.04 23 383.45 8.99 0.58 Ord_1071 6/8/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_408 115.45 0.07 12 23.53 2.06 0.39 Ord_1071 6/8/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_408 163.89 0.02 31 -108.55 4.93 0.66 Ord_1049 6/9/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_397 42.67 0.06 10 -12.72 2.99 0.37 Ord_1327 6/10/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_506 391.42 0.04 38 25.03 5.12 0.4 Ord_1577 6/10/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_559 387.79 0.01 50 -56.51 5.83 0.36 Ord_1089 6/11/18 LOW Prod_2 OFFICE SUPPLIES APPLIANCES Cust_416 9046.33 0 46 1398.03 55.24 0.57 Ord_1089 6/11/18 LOW Prod_2 OFFICE SUPPLIES APPLIANCES Cust_416 367.96 0.06 43 -16.11 3.5 0.58 Ord_1089 6/11/18 LOW Prod_9 OFFICE SUPPLIES ENVELOPES Cust_416 159.05 0.04 27 21.46 2.5 0.36 Ord_1089 6/11/18 LOW Prod_12 OFFICE SUPPLIES LABELS Cust_416 116.14 0.01 39 50.44 0.5 0.36 Ord_1111 6/11/18 NOT SPECIFIED Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_421 1196.7915 0.07 26 265.39 1.25 0.55 Ord_1418 6/11/18 NOT SPECIFIED Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_539 442.57 0.01 27 -60.73 8.78 0.57 Ord_1418 6/11/18 NOT SPECIFIED Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_539 53.737 0.05 5 -28.44 5.03 0.6 Ord_1098 6/12/18 MEDIUM Prod_17 TECHNOLOGY OFFICE MACHINES Cust_424 5236.14 0.05 13 567.59 12.06 0.56 Ord_1098 6/12/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_424 74.02 0.07 11 -28.45 5.74 0.37 Ord_1239 6/12/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_472 87.23 0.09 14 -69.53 7.78 0.37 Ord_1597 6/12/18 NOT SPECIFIED Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_529 6123.48 0.08 44 1232.79 24.49 0.57 Ord_1022 6/22/18 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_363 2011.6355 0.01 12 -53.69 3.99 0.59 Ord_1023 6/26/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_388 260.59 0.09 43 -157.76 7.03 0.37 Ord_1068 6/26/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_398 503.08 0.01 12 -102.74 6.5 0.74 Ord_1068 6/26/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_398 4256.51 0.03 41 1653.96 7.18 0.46 Ord_1068 6/26/18 HIGH Prod_12 OFFICE SUPPLIES LABELS Cust_398 76.94 0 15 29.67 0.99 0.39 Ord_106 6/27/18 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_67 18.37 0.01 6 -4.06 1.2 0.58 Ord_106 6/27/18 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_67 1943.72 0.03 47 -1003.58 34.2 0.73 Ord_106 6/27/18 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_67 6175.777 0.07 49 1881.58 3.9 0.55 Ord_1211 7/1/18 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_458 50.07 0.03 19 -0.53 0.86 0.57 Ord_1211 7/1/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_458 147.16 0.01 21 -92.55 8.4 0.37 Ord_1211 7/1/18 MEDIUM Prod_11 FURNITURE TABLES Cust_458 6982.87 0.05 32 875.55 29.1 0.68 Ord_1256 7/1/18 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_469 607.597 0.07 11 -112.24 5.99 0.58 Ord_1042 7/2/18 CRITICAL Prod_10 FURNITURE BOOKCASES Cust_395 748.25 0.05 10 -86.99 26.74 0.6 Ord_1079 7/2/18 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_414 619.77 0.02 42 50.24 7.17 0.38 Ord_1499 7/2/18 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_487 3900.531 0.08 42 1144.63 2.5 0.57 Ord_1499 7/2/18 CRITICAL Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_487 248.42 0.02 35 -58.81 4.42 0.58 Ord_1439 7/2/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_527 3351.55 0.04 37 -1036.92 56.2 0.74 Ord_1189 7/3/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_452 49.61 0 1 -41.82 17.08 0.4 Ord_1379 7/3/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_502 711.1 0.08 36 241.08 2.99 0.36 Ord_1379 7/3/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_502 498.16 0.03 48 40.61 5.12 0.4 Ord_1381 7/3/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_533 351.49 0.03 8 107.32 2.99 0.35 Ord_1381 7/3/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_533 74.13 0.08 16 -69.34 6.72 0.4 Ord_1381 7/3/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_533 195.03 0.09 45 -148.87 5.74 0.4 Ord_1147 7/4/18 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_439 244.85 0.06 14 38.06 8.99 0.47 Ord_1099 7/5/18 CRITICAL Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_425 198.08 0.02 47 32.69 0.94 0.56 Ord_1209 7/6/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_463 28.65 0.02 16 -23.86 1.99 0.51 Ord_1209 7/6/18 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_463 201.535 0.09 12 -122.62 3.3 0.81 Ord_1435 7/6/18 CRITICAL Prod_9 OFFICE SUPPLIES ENVELOPES Cust_545 437.86 0.04 38 -4.17 6.97 0.35 Ord_118 7/6/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_63 23792.93 0 18 10951.31 19.99 0.35 Ord_115 7/6/18 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_79 234.28 0.09 8 -65.42 13.99 0.58 Ord_115 7/6/18 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_79 1779.8915 0.09 41 -250.17 5 0.8 Ord_115 7/6/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_79 207.08 0.09 48 -131.82 5.17 0.4 Ord_1560 7/7/18 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_512 870.75 0.09 35 100.5 5.3 NA Ord_1560 7/7/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_512 43.37 0.02 13 9.53 0.99 0.48 Ord_1497 7/7/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_557 121.19 0.09 30 -152.13 7.01 0.37 Ord_1010 7/8/18 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_366 195.23 0.08 35 -72.46 5.57 0.41 Ord_1010 7/8/18 HIGH Prod_11 FURNITURE TABLES Cust_366 4051.8 0.1 35 -684.07 51.94 0.63 Ord_1485 7/8/18 HIGH Prod_2 OFFICE SUPPLIES APPLIANCES Cust_550 385.99 0.09 48 -40.72 3.5 0.58 Ord_1145 7/9/18 NOT SPECIFIED Prod_12 OFFICE SUPPLIES LABELS Cust_439 48.37 0.02 16 18.02 0.5 0.36 Ord_1072 7/10/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_401 154.94 0.09 2 -358.43 4 0.76 Ord_1072 7/10/18 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_401 1642.642 0.08 44 314.84 4.99 0.56 Ord_1310 7/10/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_491 125.16 0.02 18 -23.48 5.14 0.37 Ord_1442 7/10/18 LOW Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_498 258.13 0.03 41 84.1 1.82 0.35 Ord_1078 7/11/18 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_413 257.97 0.03 19 33.18 4.98 0.4 Ord_1153 7/12/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_444 356.95 0.08 1 -228.24 19.99 0.38 Ord_1153 7/12/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_444 2063.42 0.03 38 989.95 5.15 0.36 Ord_1153 7/12/18 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_444 112.86 0.04 17 -56.78 4.07 0.66 Ord_1581 7/12/18 CRITICAL Prod_2 OFFICE SUPPLIES APPLIANCES Cust_519 382.19 0.03 24 11.39 6.75 0.52 Ord_1581 7/12/18 CRITICAL Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_519 2573.92 0.07 17 117.23 143.71 0.55 Ord_1581 7/12/18 CRITICAL Prod_17 TECHNOLOGY OFFICE MACHINES Cust_519 727.64 0.01 40 27.64 8.51 0.4 Ord_1581 7/12/18 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_519 2564.5775 0.07 25 331.29 7.69 0.58 Ord_1581 7/12/18 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_519 2795.004 0.02 16 311.09 8.99 0.58 Ord_137 7/12/18 CRITICAL Prod_12 OFFICE SUPPLIES LABELS Cust_81 78.47 0.06 27 17.99 0.99 0.36 Ord_137 7/12/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_81 108.42 0.02 16 -50.82 6.81 0.36 Ord_1004 7/20/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_365 139.54 0.01 26 -54.08 4.95 0.37 Ord_1004 7/20/18 NOT SPECIFIED Prod_5 FURNITURE OFFICE FURNISHINGS Cust_365 199.52 0.08 28 13.44 4 0.42 Ord_1004 7/20/18 NOT SPECIFIED Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_365 85.66 0.04 39 6.67 0.78 0.52 Ord_1058 7/22/18 NOT SPECIFIED Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_404 136.68 0.01 4 -125.16 4 0.75 Ord_1058 7/22/18 NOT SPECIFIED Prod_5 FURNITURE OFFICE FURNISHINGS Cust_404 1452.48 0.07 24 376.52 10.84 0.63 Ord_1058 7/22/18 NOT SPECIFIED Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_404 3555.29 0.09 19 183.28 19.99 0.71 Ord_103 7/22/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_48 252.79 0.09 9 58.23 2.99 0.35 Ord_1034 7/25/18 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_393 113.5 0.05 15 -46.35 6.28 0.4 Ord_1007 7/26/18 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_379 2766.818 0.03 47 846.95 5.92 0.55 Ord_1032 7/26/18 NOT SPECIFIED Prod_2 OFFICE SUPPLIES APPLIANCES Cust_391 1925.83 0.09 10 359.83 0.99 0.55 Ord_1046 7/29/18 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_391 185.64 0.1 25 -69.87 6.28 0.4 Ord_1046 7/29/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_391 225.98 0.01 34 -135.74 7.86 0.37 Ord_1076 7/30/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_412 404.24 0.02 23 -76.99 13.18 0.37 Ord_1076 7/30/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_412 1381.88 0.09 32 598.2 6.77 0.44 Ord_1354 8/2/18 CRITICAL Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_519 156.15 0.08 10 -37.6 7.42 0.56 Ord_1252 8/3/18 CRITICAL Prod_5 FURNITURE OFFICE FURNISHINGS Cust_465 119.63 0.03 22 -27.39 3.63 0.51 Ord_1252 8/3/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_465 177.92 0 40 -167.92 6.72 0.4 Ord_1228 8/3/18 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES Cust_473 2451.41 0.07 50 773.36 10.17 0.37 Ord_1228 8/3/18 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES Cust_473 851.24 0.1 11 -149.46 33.6 0.37 Ord_1366 8/3/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_488 25.52 0.01 2 21.77 6.22 0.55 Ord_1311 8/3/18 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_492 1246.52 0.01 50 52.48 12.98 0.39 Ord_1502 8/3/18 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_556 105.85 0.1 17 -44.86 2.74 0.71 Ord_1502 8/3/18 LOW Prod_9 OFFICE SUPPLIES ENVELOPES Cust_556 179.33 0 19 -58.76 8.29 0.38 Ord_1367 8/4/18 CRITICAL Prod_2 OFFICE SUPPLIES APPLIANCES Cust_493 1562.97 0.01 34 501.59 4.62 0.56 Ord_1394 8/4/18 NOT SPECIFIED Prod_5 FURNITURE OFFICE FURNISHINGS Cust_508 894.64 0.01 31 -27.79 19.46 0.44 Ord_1043 8/5/18 HIGH Prod_9 OFFICE SUPPLIES ENVELOPES Cust_400 260.39 0.09 15 -48.57 12.39 0.35 Ord_1130 8/5/18 LOW Prod_9 OFFICE SUPPLIES ENVELOPES Cust_428 171.52 0.1 32 46.61 1.39 0.38 Ord_1545 8/5/18 CRITICAL Prod_11 FURNITURE TABLES Cust_551 4201.47 0.04 19 199.25 52.2 0.64 Ord_1545 8/5/18 CRITICAL Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_551 55.66 0.08 17 -21.4 2.31 0.56 Ord_1296 8/6/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_484 115.54 0.04 24 43.35 0.8 0.36 Ord_159 8/8/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_89 270.23 0.08 12 52.02 5.47 0.39 Ord_159 8/8/18 NOT SPECIFIED Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_89 660.27 0.09 20 63.83 5.49 0.6 Ord_1035 8/9/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_394 357.43 0.08 17 -135.98 6.5 0.78 Ord_1035 8/9/18 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_394 4754.08 0 21 299.88 28.66 0.72 Ord_1419 8/9/18 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_487 1207.08 0.05 12 -351.3 58.2 0.58 Ord_1419 8/9/18 LOW Prod_11 FURNITURE TABLES Cust_487 2618.112 0.04 11 -139.27 61.76 0.78 Ord_1047 8/11/18 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES Cust_1145 6688.11 0.08 45 2872.88 13.99 0.38 Ord_1047 8/11/18 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_401 16.73 0.08 1 -6.96 4.98 0.48 Ord_1293 8/12/18 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES Cust_483 17717.34 0 37 8291.08 69.3 0.37 Ord_1037 8/17/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_396 264.75 0.08 43 -212.51 8.4 0.37 Ord_1069 8/20/18 NOT SPECIFIED Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_402 252.99 0.08 37 28.76 2.35 0.47 Ord_1048 8/30/18 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_401 518.8 0.1 17 54.63 11.63 0.37 Ord_1241 9/1/18 NOT SPECIFIED Prod_12 OFFICE SUPPLIES LABELS Cust_467 45.87 0.02 9 -38.9 6.89 0.39 Ord_1385 9/1/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_521 268.94 0.02 39 -87.52 6.41 0.37 Ord_1385 9/1/18 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_521 847.82 0.05 38 -1348.5 45 0.61 Ord_1590 9/2/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_556 47.03 0.08 4 -12.03 5.03 0.37 Ord_16 9/3/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_14 511.83 0.1 33 -172.88 13.18 0.37 Ord_16 9/3/18 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_14 184.99 0.05 38 -144.55 4.93 0.66 Ord_1579 9/3/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_566 23.38 0.08 3 -12.19 5.14 0.37 Ord_1579 9/3/18 CRITICAL Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_566 139.37 0.04 16 1.72 2.64 0.59 Ord_1579 9/3/18 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_566 1221.62 0.01 18 -468.64 35 0.8 Ord_1462 9/4/18 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_541 38.56 0.03 8 4.08 1.49 0.35 Ord_1498 9/4/18 CRITICAL Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_551 48.01 0.1 21 -6.85 1.12 0.58 Ord_1584 9/4/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_567 129.06 0.1 27 -75.13 4.97 0.38 Ord_1584 9/4/18 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_567 1236.64 0.01 43 518.81 1.99 0.4 Ord_101 9/4/18 NOT SPECIFIED Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_73 300.2 0 8 6.41 8.22 0.57 Ord_101 9/4/18 NOT SPECIFIED Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_73 1364.8025 0.07 29 -183.68 5 0.83 Ord_1588 9/5/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_518 36.37 0.07 19 -10.26 1.49 0.37 Ord_104 9/5/18 NOT SPECIFIED Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_62 50.97 0.09 10 4.45 0.73 0.56 Ord_104 9/5/18 NOT SPECIFIED Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_62 4.99 0.04 1 -3.06 1.32 0.83 Ord_1218 9/7/18 HIGH Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_468 9418.73 0 27 2245.24 58.95 0.57 Ord_1218 9/7/18 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_468 1265.497 0.1 13 -161.12 3 0.59 Ord_1218 9/7/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_468 5.68 0.02 1 -1.82 0.88 0.39 Ord_1218 9/7/18 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_468 174.59 0.08 42 25.88 0.94 0.56 Ord_1469 9/7/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_507 311.21 0.09 27 -14.03 6.47 0.38 Ord_1149 9/8/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_440 109.37 0.07 11 25.96 1.79 0.38 Ord_1284 9/8/18 NOT SPECIFIED Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_480 238.74 0.1 8 -38.89 8.99 0.58 Ord_1388 9/8/18 NOT SPECIFIED Prod_10 FURNITURE BOOKCASES Cust_495 633.13 0.05 10 -203.9 36.61 0.61 Ord_1389 9/8/18 NOT SPECIFIED Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_536 10.33 0.04 3 -3.86 1.58 0.39 Ord_1389 9/8/18 NOT SPECIFIED Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_536 14.39 0.07 2 -10.24 3.37 0.54 Ord_1230 9/10/18 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_465 96.75 0.04 22 -72.91 5.41 0.35 Ord_1449 9/10/18 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_511 1136.47 0.1 10 323.32 9.07 0.35 Ord_1449 9/10/18 CRITICAL Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_511 325.81 0.02 2 -522.78 6.5 0.74 Ord_1566 9/10/18 LOW Prod_2 OFFICE SUPPLIES APPLIANCES Cust_553 1223.11 0 21 161.72 13.22 0.56 Ord_116 9/10/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_80 114.12 0.05 30 15.73 1.49 0.38 Ord_116 9/10/18 NOT SPECIFIED Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_80 436.05 0.09 15 -92.58 4 0.75 Ord_116 9/10/18 NOT SPECIFIED Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_80 5247.4835 0 49 1465.87 8.08 0.57 Ord_1082 9/11/18 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_417 240.63 0.02 31 -117.92 5.53 0.69 Ord_1520 9/11/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_498 30.47 0.02 4 -10.7 5.15 0.36 Ord_1454 9/11/18 NOT SPECIFIED Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_523 1278.6465 0.01 7 -396.17 4.2 0.59 Ord_1138 9/12/18 MEDIUM Prod_2 OFFICE SUPPLIES APPLIANCES Cust_411 170.45 0.09 4 -30.27 4.62 0.56 Ord_1138 9/12/18 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_411 350.42 0.03 28 -37.3 5.81 0.6 Ord_1355 9/12/18 NOT SPECIFIED Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_520 1968.47 0.04 47 327.9 8.99 0.59 Ord_1012 9/24/18 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_382 104.51 0.04 13 -9.28 4.71 0.35 Ord_1001 9/27/18 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_374 1981.26 0.07 49 100.8 8.66 0.76 Ord_107 9/30/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_75 157.97 0.01 6 -42.38 16.87 0.39 Ord_1077 10/1/18 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_411 1307.35 0.05 43 -154.24 8.65 0.74 Ord_1077 10/1/18 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_411 523.58 0.01 3 -179.36 19.99 0.66 Ord_1203 10/1/18 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_458 69.98 0.06 12 -58.33 6.98 0.39 Ord_1203 10/1/18 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_458 418.34 0.08 35 73.57 5.16 0.43 Ord_1203 10/1/18 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_458 45.61 0.1 12 9.18 0.7 0.44 Ord_1203 10/1/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_458 17.7 0.06 3 -10.37 4.79 0.4 Ord_1571 10/1/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_514 188.34 0.04 36 -110.16 5.74 0.36 Ord_1571 10/1/18 LOW Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_514 1493.858 0.02 26 183.24 8.8 0.58 Ord_1571 10/1/18 LOW Prod_9 OFFICE SUPPLIES ENVELOPES Cust_514 32.49 0.08 3 -5.05 1.39 0.35 Ord_1353 10/1/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_518 111.66 0.06 21 -53.33 5.49 0.38 Ord_1353 10/1/18 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_518 231.95 0.03 24 44.14 1.99 0.43 Ord_1384 10/1/18 CRITICAL Prod_5 FURNITURE OFFICE FURNISHINGS Cust_521 199.12 0.01 24 73.33 0.96 0.43 Ord_1384 10/1/18 CRITICAL Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_521 63.14 0.06 19 -53.75 3.97 0.56 Ord_1226 10/2/18 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_470 1297.4485 0.04 18 4.21 10.78 0.58 Ord_1568 10/2/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_502 138.24 0.06 22 -48.22 5.19 0.38 Ord_1387 10/2/18 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_535 124.84 0.08 20 10.56 1.56 0.52 Ord_1399 10/3/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_496 2430.34 0.08 46 752.87 13.88 0.36 Ord_1399 10/3/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_496 218.6 0.05 36 -46.43 4.96 0.36 Ord_1431 10/3/18 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_540 450.39 0.07 23 152.79 6.15 0.44 Ord_1431 10/3/18 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_540 1193.1195 0.08 17 137.59 0.99 0.55 Ord_1009 10/4/18 NOT SPECIFIED Prod_17 TECHNOLOGY OFFICE MACHINES Cust_366 2219.79 0.1 30 -9.45 33.6 0.37 Ord_1009 10/4/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_366 237.36 0.07 25 -117.86 9.86 0.4 Ord_1164 10/4/18 NOT SPECIFIED Prod_2 OFFICE SUPPLIES APPLIANCES Cust_445 9492.92 0.05 29 772.04 91.05 0.57 Ord_1238 10/4/18 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_473 89.18 0.04 31 21.73 0.81 0.4 Ord_1238 10/4/18 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_473 1540.285 0.05 50 829.65 1.25 0.36 Ord_1578 10/4/18 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_501 3978.02 0.08 24 1336.96 19.99 0.4 Ord_1578 10/4/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_501 843.15 0 16 355 5.81 0.38 Ord_1414 10/4/18 MEDIUM Prod_2 OFFICE SUPPLIES APPLIANCES Cust_536 235.09 0.08 43 -1987.49 49 0.6 Ord_1414 10/4/18 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_536 187.46 0 10 49.85 8.99 0.47 Ord_1489 10/4/18 NOT SPECIFIED Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_544 203.4 0.04 29 24.59 2.35 0.47 Ord_1106 10/5/18 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_419 309.46 0.08 49 -82.64 2.74 0.71 Ord_1157 10/5/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_444 1538.33 0.03 39 471.35 1.99 0.54 Ord_1157 10/5/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_444 147.46 0.06 39 14.13 1.93 0.35 Ord_1247 10/6/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_472 132.72 0.05 14 -9.18 5.6 0.36 Ord_1395 10/6/18 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_515 138.96 0.03 49 19.87 0.7 0.56 Ord_1395 10/6/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_515 158.97 0.08 39 -30.27 2.99 0.37 Ord_1018 10/7/18 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_362 55.59 0.03 8 -17.95 5.74 0.36 Ord_130 10/8/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_1064 376.65 0 16 -52.65 15.1 0.38 Ord_130 10/8/18 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_1064 40.06 0.07 6 -24.44 4.69 0.68 Ord_1453 10/8/18 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_536 6163.52 0.02 26 755.95 28.66 0.72 Ord_145 10/8/18 CRITICAL Prod_5 FURNITURE OFFICE FURNISHINGS Cust_85 1003.31 0.01 23 51.9 14.45 0.57 Ord_145 10/8/18 CRITICAL Prod_11 FURNITURE TABLES Cust_85 6048.18 0.04 17 1418.36 60 NA Ord_130 10/8/18 LOW Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_89 1665.0395 0.02 35 366.51 3.3 0.59 Ord_1382 10/9/18 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_532 2367.99 0.04 14 320.1 11.87 0.62 Ord_1383 10/9/18 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_534 522.06 0.06 5 319.64 13.99 0.65 Ord_1383 10/9/18 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_534 1218.08 0.1 37 99.79 8.99 0.56 Ord_1213 10/12/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_462 172.9 0 23 51.43 2 0.39 Ord_1514 10/12/18 HIGH Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_529 7341.96 0 32 764.95 64.2 0.59 Ord_1 10/13/18 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_1 261.54 0.04 6 -213.25 35 0.8 Ord_1070 10/14/18 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES Cust_400 17304.85 0.05 36 7434.48 28.14 0.38 Ord_1070 10/14/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_400 794.32 0.08 20 67.61 17.48 0.36 Ord_1008 10/26/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_380 689.67 0.07 38 51.47 8.99 0.47 Ord_1029 10/29/18 HIGH Prod_2 OFFICE SUPPLIES APPLIANCES Cust_389 199.93 0.1 14 -105.33 13.32 0.43 Ord_1056 10/30/18 NOT SPECIFIED Prod_2 OFFICE SUPPLIES APPLIANCES Cust_395 5198.12 0.01 48 1481.67 15.66 0.57 Ord_1056 10/30/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_395 188.53 0 23 -27.49 5.96 0.38 Ord_1056 10/30/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_395 718.41 0.1 19 23.94 17.48 0.36 Ord_1065 11/1/18 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_407 9843.11 0.07 35 -384.6 57 0.78 Ord_1065 11/1/18 LOW Prod_17 TECHNOLOGY OFFICE MACHINES Cust_407 7190.06 0.08 15 1908.45 28.14 0.38 Ord_121 11/1/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_45 1143.45 0.06 31 304.42 1.99 0.51 Ord_1244 11/1/18 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_467 1965.21 0 24 830.75 19.99 0.43 Ord_1595 11/2/18 CRITICAL Prod_2 OFFICE SUPPLIES APPLIANCES Cust_541 1002.73 0.08 17 -563.86 49 0.59 Ord_1144 11/3/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_437 317.59 0.06 36 -46.12 6.19 0.38 Ord_1321 11/3/18 LOW Prod_17 TECHNOLOGY OFFICE MACHINES Cust_486 16587.13 0.08 7 -3476.86 29.7 0.57 Ord_1321 11/3/18 LOW Prod_6 OFFICE SUPPLIES PAPER Cust_486 507.98 0.05 9 170.9 4.86 0.36 Ord_1173 11/4/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_449 887.45 0.1 47 365.79 1.49 0.35 Ord_1173 11/4/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_449 355.97 0.03 7 -4.46 19.99 0.37 Ord_1192 11/4/18 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_455 430.55 0 35 120.01 2.85 0.55 Ord_1331 11/4/18 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_486 3821.039 0.05 38 1057.89 5.99 0.57 Ord_1178 11/6/18 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_451 1495.184 0 26 211.09 8.99 0.56 Ord_1266 11/6/18 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_477 1388.628 0.03 24 261.52 5.26 0.56 Ord_1266 11/6/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_477 21.46 0.05 3 -14.22 6.26 0.4 Ord_1358 11/6/18 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_523 165.37 0.06 26 -80.11 4.07 0.66 Ord_1358 11/6/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_523 1785.74 0.03 38 739.48 7.23 0.41 Ord_1459 11/6/18 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_529 127.56 0.03 22 -60.72 5.63 0.39 Ord_1377 11/8/18 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_531 37.3 0 7 5.03 0.71 0.52 Ord_1433 11/8/18 HIGH Prod_12 OFFICE SUPPLIES LABELS Cust_545 16.6 0.1 4 -2.06 0.99 0.39 Ord_1433 11/8/18 HIGH Prod_12 OFFICE SUPPLIES LABELS Cust_545 25.1 0.04 5 2.98 0.49 0.39 Ord_1424 11/9/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_492 125.46 0.07 34 -129.63 5.47 0.37 Ord_1434 11/9/18 NOT SPECIFIED Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_526 553.02 0.1 38 -49.38 6.5 0.48 Ord_134 11/10/18 HIGH Prod_11 FURNITURE TABLES Cust_138 6693.28 0.02 23 40.32 69 0.67 Ord_134 11/10/18 HIGH Prod_2 OFFICE SUPPLIES APPLIANCES Cust_138 1482.81 0.03 24 -678.63 49 0.59 Ord_134 11/10/18 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_91 275.91 0.1 44 -162.37 5.03 0.6 Ord_1503 11/11/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_498 378.08 0 17 70.48 1.99 0.43 Ord_1503 11/11/18 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_498 731.71 0 24 175.82 1.99 0.5 Ord_1027 11/13/18 MEDIUM Prod_10 FURNITURE BOOKCASES Cust_366 1118.82 0.04 8 -320.3 36.09 0.77 Ord_1027 11/13/18 MEDIUM Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_366 79.75 0.1 48 -41.32 1.56 0.49 Ord_1038 11/13/18 NOT SPECIFIED Prod_5 FURNITURE OFFICE FURNISHINGS Cust_397 3367.24 0.07 44 -1183.69 48.2 0.74 Ord_1038 11/13/18 NOT SPECIFIED Prod_11 FURNITURE TABLES Cust_397 5723.24 0 37 -194.97 51.92 0.69 Ord_1026 11/19/18 LOW Prod_17 TECHNOLOGY OFFICE MACHINES Cust_363 15602.93 0 48 4875.89 26.53 0.56 Ord_1062 11/21/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_397 85.77 0.03 27 -102.02 5.44 0.36 Ord_1062 11/21/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_397 149.31 0 13 7.77 5.14 0.36 Ord_1041 11/21/18 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_399 933.21 0.05 40 207.18 7.58 0.51 Ord_1066 11/23/18 NOT SPECIFIED Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_406 3701.5205 0.05 38 894.06 5.92 0.58 Ord_1437 12/1/18 CRITICAL Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_1307 6435.87 0.04 21 935.06 64.73 0.56 Ord_1437 12/1/18 CRITICAL Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_1307 312.03 0.08 11 -66.66 5.5 0.51 Ord_1094 12/1/18 NOT SPECIFIED Prod_2 OFFICE SUPPLIES APPLIANCES Cust_412 1603.27 0.01 27 452.49 3.99 0.57 Ord_1437 12/1/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_547 145.93 0 27 -113.32 7.44 0.36 Ord_1382 12/2/18 NOT SPECIFIED Prod_17 TECHNOLOGY OFFICE MACHINES Cust_532 3220.58 0.04 22 1046.69 13.99 0.38 Ord_1387 12/2/18 LOW Prod_12 OFFICE SUPPLIES LABELS Cust_535 103.62 0.1 15 39.98 0.49 0.38 Ord_15 12/3/18 NOT SPECIFIED Prod_12 OFFICE SUPPLIES LABELS Cust_4 59.03 0.1 13 26.92 0.5 0.38 Ord_15 12/3/18 NOT SPECIFIED Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_4 97.48 0.05 21 -5.77 0.7 0.8 Ord_1081 12/3/18 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_416 2853.8835 0.06 27 492.24 7.69 0.58 Ord_139 12/3/18 CRITICAL Prod_17 TECHNOLOGY OFFICE MACHINES Cust_45 2671.21 0.06 14 636.18 15.59 0.36 Ord_1428 12/3/18 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_501 583.56 0.02 26 -94.59 6.5 0.78 Ord_1428 12/3/18 LOW Prod_6 OFFICE SUPPLIES PAPER Cust_501 281.47 0.1 47 -190.57 7.37 0.37 Ord_1402 12/3/18 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_527 236.45 0.06 32 -259.02 9.69 0.83 Ord_1014 12/4/18 CRITICAL Prod_5 FURNITURE OFFICE FURNISHINGS Cust_368 131.09 0.01 10 10.94 2.85 0.55 Ord_1014 12/4/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_368 1817.9 0.06 33 700.31 10.75 0.36 Ord_1158 12/4/18 MEDIUM Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_445 473.88 0.01 4 -183.26 30 0.71 Ord_1158 12/4/18 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_445 849.031 0.07 50 -133.31 3.3 0.81 Ord_1475 12/4/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_518 167.46 0.09 40 -134.3 5.41 0.35 Ord_1277 12/5/18 NOT SPECIFIED Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_466 2255.1945 0.03 46 74.51 5 0.8 Ord_1277 12/5/18 NOT SPECIFIED Prod_5 FURNITURE OFFICE FURNISHINGS Cust_466 187.13 0.09 9 12.4 14.39 0.47 Ord_1275 12/5/18 LOW Prod_6 OFFICE SUPPLIES PAPER Cust_467 26.23 0 3 -13.72 6.6 0.37 Ord_152 12/5/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_60 557.23 0.09 24 -42.99 12.98 0.39 Ord_1191 12/6/18 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_1787 2612.89 0.04 25 490.99 10.12 0.79 Ord_1191 12/6/18 LOW Prod_11 FURNITURE TABLES Cust_1787 1146.992 0.07 47 -1643.74 45.51 0.65 Ord_1162 12/6/18 LOW Prod_9 OFFICE SUPPLIES ENVELOPES Cust_447 64.44 0 21 -89.02 6.35 0.36 Ord_1191 12/6/18 LOW Prod_10 FURNITURE BOOKCASES Cust_451 4581.41 0.04 36 -904.73 54.74 0.69 Ord_1271 12/7/18 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_466 128.5 0.02 17 -44.69 6.93 0.37 Ord_1409 12/7/18 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_496 311.65 0.03 45 -71.25 5.48 0.37 Ord_1409 12/7/18 LOW Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_496 101.19 0.06 28 32.47 0.71 0.39 Ord_1420 12/8/18 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_542 52.0965 0 1 -232.8 2.5 0.83 Ord_1318 12/9/18 MEDIUM Prod_12 OFFICE SUPPLIES LABELS Cust_499 102.56 0.06 40 36.62 0.5 0.39 Ord_1318 12/9/18 MEDIUM Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_499 15.87 0.01 3 2.53 0.76 0.39 Ord_1563 12/9/18 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_517 345.57 0.06 4 -218.77 35 0.81 Ord_1544 12/9/18 NOT SPECIFIED Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_564 60.92 0.07 33 -17.2 1.49 0.37 Ord_1544 12/9/18 NOT SPECIFIED Prod_5 FURNITURE OFFICE FURNISHINGS Cust_564 387.17 0.01 8 190.6 4.8 0.68 Ord_1006 12/10/18 NOT SPECIFIED Prod_2 OFFICE SUPPLIES APPLIANCES Cust_378 1758.41 0.06 18 238.52 15.66 0.57 Ord_1229 12/10/18 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_473 3505.6 0.03 26 1019.7 12.65 NA Ord_1000 12/11/18 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_373 334.71 0.01 25 31.74 6.47 0.38 Ord_1063 12/11/18 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_406 54.3 0.1 6 1.27 2.03 0.37 Ord_1050 12/12/18 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_402 690.88 0.08 32 119.25 7.58 0.51 Ord_1060 12/12/18 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_405 691.09 0.08 9 364.03 19.99 0.43 Ord_1060 12/12/18 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_405 713.7 0.02 33 176.09 2.87 0.55 Ord_1160 12/12/18 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_444 270.73 0.1 32 -54.57 6.28 0.35 Ord_1172 12/12/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_449 240.18 0.06 40 -160.21 7.64 0.36 Ord_1172 12/12/18 NOT SPECIFIED Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_449 529.28 0.1 45 -30.27 4.81 0.58 Ord_1232 12/12/18 HIGH Prod_11 FURNITURE TABLES Cust_471 302.91 0.04 2 -186.13 51.94 0.63 Ord_1232 12/12/18 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_471 842.6135 0.1 29 -208.43 5 0.82 Ord_1356 12/12/18 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_521 1082.43 0.06 23 23.97 3.61 0.71 Ord_1536 12/12/18 MEDIUM Prod_14 TECHNOLOGY COPIERS AND FAX Cust_561 14475.74 0.06 28 4963.89 49 0.35 Ord_1536 12/12/18 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_561 306.6205 0.08 3 -479.08 5.99 0.57 Ord_1053 12/14/18 NOT SPECIFIED Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_402 230.72 0.08 11 -68.76 5.99 0.65 Ord_1053 12/14/18 NOT SPECIFIED Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_402 142.15 0.09 10 -58.18 9.37 0.56 Ord_1053 12/14/18 NOT SPECIFIED Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_402 88.7 0.06 33 -89.13 4.28 0.44 Ord_1053 12/14/18 NOT SPECIFIED Prod_6 OFFICE SUPPLIES PAPER Cust_402 293.47 0.06 45 -205.38 8.4 0.37 Ord_1053 12/14/18 NOT SPECIFIED Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_402 262.78 0.04 23 19.36 3.37 0.57 Ord_1036 12/16/18 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES Cust_395 1601.32 0.04 13 377.81 14 0.36 Ord_1013 12/18/18 LOW Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_382 1064.7865 0.1 12 -181.01 2.5 0.58 Ord_1040 12/24/18 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_396 1281.28 0.05 43 415.85 6.27 0.37 Ord_1040 12/24/18 CRITICAL Prod_11 FURNITURE TABLES Cust_396 1940.31 0.03 13 -668.19 80.2 0.71 Ord_1040 12/24/18 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_396 430.848 0.06 4 -492.77 5.63 0.6 Ord_1074 12/31/18 LOW Prod_2 OFFICE SUPPLIES APPLIANCES Cust_411 1339.25 0.03 24 142.51 13.22 0.56 Ord_1033 5/6/18 NOT SPECIFIED Prod_2 OFFICE SUPPLIES APPLIANCES Cust_392 605.1 0.04 15 92.81 5.33 0.57 Revenue Analysis Office Supply Revenue Analysis Assumptions (based on last year): Revenue Amount Sales $ 713,932.37 Revenue $ 74,605.93 Discount 0.05 Profit Margin 0.11 Quantity Sold Quantity Sold Product Category Year 2018 Year 2019 (est) FURNITURE 2438 OFFICE SUPPLIES 6824 TECHNOLOGY 3075 2019 increase estimate 0.07 2017 vs 2018 Office Supply Company Quarterly Product Sales 2017 and 2018 Product Name 2017 2018 % Change APPLIANCES 1168254.7 43987.7 BINDERS AND BINDER ACCESSORIES 56557.6 64658.6 BOOKCASES 11153.55 14187.55 CHAIRS & CHAIRMATS 91493.8 93908.8 COMPUTER PERIPHERALS 34539.7 39655.7 COPIERS AND FAX 18621.79 16724.79 ENVELOPES 5364.74 3127.74 LABELS 550 751 OFFICE FURNISHINGS 59738.64 61445.64 OFFICE MACHINES 125411.79 132526.79 PAPER 20434.31 24042.31 PENS & ART SUPPLIES 12033.55 8028.55 RUBBER BANDS 6890.59 1259.59 SCISSORS, RULERS AND TRIMMERS 3299.05 2499.03 STORAGE & ORGANIZATION 38796.77 53796.77 TABLES 55314.294 56814.294 TELEPHONES AND COMMUNICATION 85759.419 95912.419 Total Average Standard Deviation Quarterly Office Supply Company Quarterly Product Sales 2018 Product Name Q1 Q2 Q3 Q4 Total APPLIANCES 97.93 15926.7 5650.54 22312.53 BINDERS AND BINDER ACCESSORIES 19512.77 4464.81 31240.1 9440.92 BOOKCASES 5113.49 1992.45 1381.38 5700.23 CHAIRS & CHAIRMATS 21754.38 30483.52 14070.48 27600.42 COMPUTER PERIPHERALS 11109.52 16658.19 3320.53 8567.46 COPIERS AND FAX 0 2249.05 14475.74 ENVELOPES 945.07 1036.64 1049.1 96.93 LABELS 66.19 205.19 172.71 306.91 OFFICE FURNISHINGS 14563.22 20323.21 9906.66 16652.55 OFFICE MACHINES 6275.58 31417.6 28435.74 66397.87 PAPER 3790.65 4686.49 5476.64 10088.53 PENS & ART SUPPLIES 700.51 1217.13 3388 2722.91 RUBBER BANDS 399.87 196.92 368.51 294.29 SCISSORS, RULERS AND TRIMMERS 1361.35 325.97 548.93 262.78 STORAGE & ORGANIZATION 6416.63 25196.44 11573.56 10610.14 TABLES 14076.27 3028.86 17854.252 21854.912 TELEPHONES AND COMMUNICATION 10893.379 33076.9085 25415.0255 26527.106 Total Average Median Assignment: Excel (100 points) Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Downtown Office Supply Downtown Office supply is a small family owned store in a small suburb. In order to maintain and grow the business the owners want to do some analysis to see how their sales are doing. Management wants to see how the company did last year and make some decisions about what products to keep along with staffing for busy times of the year. Instructions: In the Excel spreadheet provided, complete the tasks below. Upon completion you will submit a single, completed, Excel workbook. (No Google Sheets, nor Apple Numbers files will be accepted.) 1. Setup the spreadsheet with proper formatting and formulas so it can be presented to management. (10 pts) 0. Change the tab called “Quarterly” to “Q1 - Quarterly” and move the tab to the first position. 0. Add a column to calculate the total for each product. Use the SUM function. 0. Add rows to calculate the Total, Average and Median sales for each quarter. Use the SUM, AVERAGE, and MEDIAN functions. 0. Format the title at the top so it stands out. Add distinct formatting to the column and row headings. Format the data in the cells to show currency. 0. Format the total sales column to have a green background. 0. Create a bar chart showing for each product (a) the total sales for the year and (b) the proportion of the total contributed by each quarter’s sales. This should be shown in one. You should have 1 bar for each product. Add a title to your chart. 1. Management would like to decide whether they should discontinue any products. Any product which has had 50% less sales over the previous year should be discontinued. Are there any products that they should discontinued? List the product(s) and your recommendation in the worksheet. Which 3 products had the highest increase in sales? (15 pts) 1. Change the tab called 2017 vs 2018 to Q2 – 2017 vs. 2018 and move the tab to the second position. 1. Add a new column to calculate the percentage change from 2017 to 2018. Percentage change is computed using the following formula: (current year sales—last year sales) / (last year sales). Represent the numbers as percentages. 1. Calculate the total, average, and standard deviation for each year. 1. Format the title at the top so it stands out. Add distinct formatting to the column and row headings. Format the data in the cells to show currency. 1. Use conditional formatting to highlight the Percent Change cells that have a negative percent change in red. 1. Use conditional formatting to highlight the top 3 cells that had the highest increase in green. 1. Create a pie chart showing the contribution of each product to 2018 total sales. Make sure the percentages are displayed on the chart and the product names are displayed in the legend. Add a title to the chart. 1. Which product was the highest contributor in 2018? (write the answer directly into the worksheet). 1. Management would to predict sales for next year using an increase estimate that they can change. (15 pts) 2. Change the tab called Quantity Sold to Q3 – Quantity Sold and move the tab to the third position. 2. Compute the 2019 estimates for each group using the following formula: [2018 quantity sold + (2018 quantity sold * the increase estimate)]. The increase estimate is shown in cell B7. 2. Change the increase estimate to .10. The values should change automatically. When student create the formula they need to use an “absolute” reference: =B3+(B3*$B$7) 2. Format the title at the top so it stands out. Add distinct formatting to the column and row headings. Format the data in the cells to be whole numbers. 2. Create a chart showing the distribution of quantity sold in 2018 for each product category. Add a title to the chart. 1. Use the data in the sheet titled “Raw data” to calculate the profit for each product category and product sub category (ability to drill down). (15 pts) 3. Create a new worksheet titled – “Q4 – Profit by Category” and insert a new pivot table for the data in the sheet – “Raw Data”. Move the worksheet to the 4th position. 3. List the total profit for product categories and subcategories in this table 3. Format the numbers to reflect the “$” symbol before the figures and 2 decimal places. 3. Change the column headings to be meaningful. 3. Add a meaningful title to the worksheet at the top and center it across the pivot table. 3. Use conditional bars to highlight gains and losses. 3. Add another column to the pivot table display the profit or loss as a percent of the total. 3. Use conditional formatting to display the top 3 products that had the highest percentage. 1. Management would like to know when their busiest month for sales is. (10 pts) 4. Create a new worksheet titled – “Q5 -Sales by Month” and insert a new pivot table for the data in the sheet – “Raw Data”. Move the worksheet after Q4 worksheet. 4. List only the months in the 1st column and the sales in the 2nd column. To do this click on one of the dates. Then do a right mouse click to display a menu. Click the Group option. Another menu will display. Click on Months and Quarters. 4. Sort the sales in Descending order. 4. Format the numbers to reflect the “$” symbol before the figures and 2 decimal places. 4. Change the column headings to be meaningful. 4. Add a meaningful title to the worksheet at the top and center it across the pivot table. 4. Use to conditional formatting to highlight the top month for sales in green, the bottom month for sales in red. 4. Next, add a filter at the top so that you can filter out product sub categories. 1. Management would like to know – what is the split in terms of profit, across the Product Categories, for each quarter. Use a Line Chart to show the numbers. Rank the Product categories in terms of profit. (15 pts) 5. Create a new worksheet titled – “Q6 – Qtr. Profit” and insert a new pivot table for the data in the sheet – “Raw data”. Move the worksheet after Q5 worksheet. 5. List all the Product Categories in the 1st column. 5. Split the Quarter across the categories [ Hint: Drag the Date field in the “Column Label” area] . To group the date by Quarter – Click on the date field. Next, right mouse click to display a menu. Click the Group option. Another menu will display. Click on Months and Quarters. 5. Add the profit by category and quarter. Format the data in currency format. 5. Add meaningful column labels. 5. Add a meaningful title to the worksheet at the top and center it across the pivot table. 5. Select the Pivot Table and Click on Options> Pivot Chart 5. Insert a Column Chart of your choice. 1. One useful function of spreadsheet software is the ability to change input values and see the impact on outcome variables. For example, you can change sales projections and see the impact on net income. Excel’s Scenario Manager makes performing these sorts of sensitivity analyses much easier. Goal-Seek Analysis Scenario Manager helps examine how changes in input values impact outcome variables. To perform this analysis, go to the Data ribbon and select What-If Analysis, then Goal-Seek. (15 pts) 6. Change the title of worksheet “Revenue Analysis” to “Q7 - Revenue Analysis” and move it after Q6 worksheet. 6. Answer the following questions directly into the worksheet: 1. What do sales need to be in order to reach 100,000 in revenue? 1. What does the profit margin need to be to reach 100,000 in revenue? 1. Prepare your analysis for Management. Create a Table of Contents. (5 pts) 7. Create a new worksheet and move it to the beginning. This worksheet should list the contents of the workbook along with the purpose of the workbook, the current date and the name of the person who created the workbook. Be sure to have titles for each of these. 7. Make each list item a hyperlink to that particular workbook. For example, in the table of contents you will have an item titled “Q1 - Quarterly Sales”. Create a hyperlink to link to that particular workbook. 7. Move the Raw Data to the last position. 7. User proper elements to add the file name and current date to the header. DUE: April 4, 2021 11:50PM 2 | Page