Question

1 Approved Answer

Posted on Jul 10, 2024

Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Setup the spreadsheet with proper formatting and formulas so it can be

Read the brief case below. Using the Excel spreadsheet provided, complete the questions.

Setup the spreadsheet with proper formatting and formulas so it can be presented to management.
1. Change the tab called Quarterly to Q1 - Quarterly and move the tab to the first position.
2. Add a column to calculate the total for each product. Use the SUM function.
3. Add rows to calculate the Total, Average and Median sales for each quarter. Use the SUM, AVERAGE, and MEDIAN functions.
4. 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.
5. Format the total sales column to have a green background.
6. 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 quarters sales. This should be shown in one. You should have 1 bar for each product. Add a title to your chart.

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?
1. Change the tab called 2017 vs 2018 to Q2 2017 vs. 2018 and move the tab to the second position.
2. Add a new column to calculate the percentage change from 2017 to 2018. Percentage change is computed using the following formula: (current year saleslast year sales) / (last year sales). Represent the numbers as percentages.
3. Calculate the total, average, and standard deviation for each year.
4. 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.
5. Use conditional formatting to highlight the Percent Change cells that have a negative percent change in red.
6. Use conditional formatting to highlight the top 3 cells that had the highest increase in green.
7. 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.
8. Which product was the highest contributor in 2018? (write the answer directly into the worksheet).

Management would to predict sales for next year using an increase estimate that they can change.
1. 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.
3. Change the increase estimate to .10. The values should change automatically. Hint: Use an absolute reference: =B3+(B3*$B$7)
4. 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.
5. Create a chart showing the distribution of quantity sold in 2018 for each product category. Add a title to the chart.

image text in transcribed

Excel

A482 x fc Ord_1060 O od 41 2.5 A B C D G H I J K L M N 1 Ord_id Order_Da - Order_ Prod_ic Product_Categ Product_Sub_Category Cust_id Sales Discour Order Profit Shippir Producase_Margin 2 Ord_1343 1/3/2018 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_501 434.77 0.02 37 -155.21 11.25 0.36 3 Ord 1438 1/4/2018 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust 5402478.88 0.02 6 593.59 19.99 0.38 923.1349 4 Ord_131 1/4/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_78 1049.79 0.08 21 135.79 19.99 0.55 5 Ord_131 1/4/2018 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_78 817.18 0.1 16 103.38 5.08 0.59 6 Ord_1044 1/5/2018 CRITICAL Prod_10 FURNITURE BOOKCASES Cust_391 3904.12 0.07 50 -1508.46 55.81 0.6 7 Ord_1044 1/5/2018 CRITICAL Prod 5 FURNITURE OFFICE FURNISHINGS Cust_391 343.64 0.06 13.29 3.44 0.49 8 Ord_1045 1/5/2018 LOW Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_391 256.64 0.03 42 -28.29 3.37 0.54 9 Ord_1339 1/5/2018 HIGH Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_499 156.47 0.01 20 -39.23 6.05 0.39 10 Ord_1015 1/6/2018 CRITICAL Prod_9 OFFICE SUPPLIES ENVELOPES Cust_370 124.06 0.09 17 15.74 0.38 11 Ord 1272 1/6/2018 LOW Prod 15 FURNITURE CHAIRS & CHAIRMATS Cust_464 6739.92 0.01 35 957.29 30 0.69 12 Ord_1340 1/7/2018 CRITICAL Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_511 1559.5 0.01 38 515.83 1.99 0.54 13 Ord_1083 1/11/2018 LOW Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_418 192.33 0.01 44 48.54 1.2 0.44 14 Ord_1212 1/12/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_458 464.59 0.07 17 168.22 1.49 0.38 15 Ord_12121/12/2018 NOT SPEC Prod_6 OFFICE SUPPLIES PAPER Cust_458 316.68 0.06 47 -161 7.49 0.37 16 Ord_1338 1/12/2018 LOW Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_490 194.29 29 -177.17 8.37 0.58 17 Ord 1338 1/12/2018 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_490 1621.1 0.07 33 -971.36 35 0.83 18 Ord_1005 1/18/2018 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_377 35.48 0.09 -9.19 1.3 0.59 19 Ord_1005 1/18/2018 HIGH Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_377 15 0.05 1 -11.02 8.37 0.58 20 Ord_1020 1/22/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_1143 4584.73 0.07 812.38 19.99 0.48 21 Ord_1020 1/22/2018 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_1143 2570.944 0.03 553.36 5.92 0.58 22 Ord_1020 1/22/2018 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_1143 4039.72 0.02 -237.6 39.61 0.67 0.09 a A482 - X Fact Ord_1060 J N L 9.73 30 5.33 2 0.79 M 0.36 0.69 0.43 0.53 36 15 34 1 36 45 30 32 36 0.5 I 0.02 0.01 0.1 0.1 0.04 0.03 0.07 0.1 0.04 0.04 0.02 3.3 20 23 Ord_1020 24 Ord_1002 25 Ord_1278 26 Ord_1274 27 Ord_1567 28 Ord_1113 29 Ord_1121 30 Ord_1143 31 Ord_1143 32 Ord 1481 33 Ord_1289 34 Ord_1289 35 Ord 1486 36 Ord 1486 37 Ord_1486 38 Ord_1051 39 Ord_1132 40 Ord_1120 41 Ord_144 42 Ord_1154 43 Ord_1154 44 Ord_1413 G 1/22/2018 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_386 1/26/2018 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_375 2/1/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_467 2/2/2018 LOW P rod_7 OFFICE SUPPLIES RUBBER BANDS Cust_471 2/2/2018 MEDIUM Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_540 2/3/2018 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_411 2/3/2018 HIGH Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust 428 2/3/2018 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust 438 2/3/2018 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_438 2/3/2018 HIGH Prod 6 OFFICE SUPPLIES PAPER Cust_515 2/4/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_454 2/4/2018 NOT SPEC Prod_5 FURNITURE OFFICE FURNISHINGS Cust_454 2/4/2018 MEDIUM Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_513 2/4/2018 MEDIUM Prod 2 OFFICE SUPPLIES APPLIANCES Cust_513 2/4/2018 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_513 2/6/2018 NOT SPEC Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_401 2/7/2018 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_412 2/7/2018 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust 416 2/8/2018 NOT SPEC Prod_17 TECHNOLOGY OFFICE MACHINES Cust_71 2/9/2018 NOT SPEC Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_444 2/9/2018 NOT SPEC Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_444 2/11/2018 LOW Prod_6 OFFICE SUPPLIES PAPER Cust_488 H 562.8 1756.46 70.25 5.7 66.41 1375.377 11041.42 303.59 191.6 393.31 513.74 36.8 487.5 97.93 25.52 824.24 445.17 1455.04 4865.72 116.82 483.64 83.31 K -17.45 -101.19 -133.06 -2.34 0.37 592.22 4456.25 - 45.99 -150.74 84.3 -28.68 14.19 -25.88 -616.81 -1.99 -127.23 38.11 -7.58 1951.3 -42.05 28.39 22.8 0.05 0.07 32 4 46 14 4 32 23 9 24 24 19.99 6.22 7.44 5.86 10.13 5.21 4.68 49 1.49 5.89 9.03 19.99 15.59 2.39 3.37 1.34 0.39 0.38 0.55 0.36 0.38 0.38 0.56 0.59 0.59 0.39 0.75 0.37 0.66 0.36 0.72 0.57 0.36 0.07 0.1 0.02 0.06 0.03 0.02 0.1 0.06 2 1 101 LAU CUDDLI DIMIDEOCAM DIMINEALDIA a . Arco 10 492 J N I 0.07 0.1 0.04 0.02 0.03 0.02 0.09 0.09 0.04 A 45 Ord_1342 46 Ord_1028 47 Ord_1028 48 Ord_1368 49 Ord_1368 50 Ord 1003 51 Ord_1003 52 Ord 1016 53 Ord_105 54 Ord 105 55 Ord_1011 56 Ord_1011 57 Ord_1059 58 Ord 1030 59 Ord_1017 60 Ord 1167 61 Ord_1167 62 Ord_153 63 Ord_153 Ord_1064 65 Ord_1375 66 Ord_1375 B C D E G H 2/11/2018 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_513 457.68 2/12/2018 NOT SPEC Prod_11 FURNITURE TABLES Cust_38410006.28 2/12/2018 NOT SPEC Prod_9 OFFICE SUPPLIES ENVELOPES Cust_384 407.17 2/12/2018 MEDIUM Prod_12 OFFICE SUPPLIES LABELS Cust_527 66.19 2/12/2018 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_803 1100.21 2/13/2018 CRITICAL Prod 9 OFFICE SUPPLIES ENVELOPES Cust_376 49.04 2/13/2018 CRITICAL Prod_11 FURNITURE TABLES Cust_376 2320.35 2/16/2018 LOW Prod 8 TECHNOLOGY COMPUTER PERIPHERALS Cust_383 138.05 2/18/2018 NOT SPEC Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_74 10554.63 2/18/2018 NOT SPEC Prod 11 FURNITURE TABLES Cust_74 1749.64 2/19/2018 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_381 3465.97 2/19/2018 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_381 1307.88 2/21/2018 MEDIUM Prod 7 OFFICE SUPPLIES RUBBER BANDS Cust_393 71.12 2/23/2018 CRITICAL Prod 1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_374 834.81 2/26/2018 NOT SPEC Prod_5 FURNITURE OFFICE FURNISHINGS Cust_384 433.44 3/1/2018 CRITICAL Prod 6 OFFICE SUPPLIES PAPER Cust_444 85.56 3/1/2018 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_444 754.6555 3/3/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_80 261.88 3/3/2018 HIGH Prod 6 OFFICE SUPPLIES PAPER Cust_80 593.73 3/4/2018 CRITICAL Prod_17 TECHNOLOGY OFFICE MACHINES Cust_404 1409.86 3/4/2018 NOT SPEC Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_498 2703.37 3/4/2018 NOT SPEC Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_498 1538.17 K 16 107.38 36 -760.98 36 -12.82 22 15.84 50 433.59 8 9.29 6 -237.62 19 -100.49 30 1240.25 8 -533.23 4 194.32 13 206.86 38 -21.89 1.98 29 147.46 15 -41.58 8 -212.55 7 -59.2 15 108.01 1 -3461.12 18 -231.6 39 -1119.64 0.08 0.06 0.1 0.03 0.1 0.03 0.01 0.08 0.04 0.07 0.09 0.02 L 6.27 61.76 6.97 0.99 1.99 1.39 84.84 5.53 58.92 69.64 19.99 7.18 0.7 12.9 3.73 5.66 2.5 1.99 13.26 29.7 57.2 35 M 0.37 0.78 0.35 0.36 0.43 0.38 0.66 0.69 0.64 0.77 0.38 0.46 0.83 0.57 0.46 0.4 0.57 0.54 0.36 0.57 0.59 0.8 22 4482 A U _1000 N A B C D E G 67 Ord_1025 3/5/2018 CRITICAL Prod 9 OFFICE SUPPLIES ENVELOPES Cust_376 68 Ord_1171 3/5/2018 MEDIUM Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_448 69 Ord_1591 3/5/2018 LOW Prod 6 OFFICE SUPPLIES PAPER Cust_490 70 Ord_1591 3/5/2018 LOW Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_490 71 Ord_1591 3/5/2018 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_490 72 Ord 1332 3/6/2018 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust 503 73 Ord_1075 3/7/2018 HIGH Prod_10 FURNITURE BOOKCASES Cust_411 74 Ord_1093 3/7/2018 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_422 75 Ord_1231 3/7/2018 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_467 76 Ord_1273 /7/2018 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_86 77 Ord_127 3/7/2018 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_86 78 Ord_10733/8/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_410 79 Ord_1575 3/10/2018 LOW Prod_6 OFFICE SUPPLIES PAPER Cust_500 80 Ord_1585 3/12/2018 NOT SPEC Prod_5 FURNITURE OFFICE FURNISHINGS Cust_568 81 Ord_1039 3/23/2018 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_398 82 Ord 1024 3/24/2018 MEDIUM Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust 373 83 Ord_1024 3/24/2018 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_373 84 Ord_1024 3/24/2018 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_373 85 Ord_1107 4/1/2018 HIGH Prod 2 OFFICE SUPPLIES APPLIANCES Cust_428 86 Ord_1107 4/1/2018 HIGH Prod_14 TECHNOLOGY COPIERS AND FAX Cust_428 87 Ord 1107 4/1/2018 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_428 88 Ord_1344 4/1/2018 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_514 H 364.8 150.33 112.91 180.92 31.68 2508.673 1209.37 113.09 5051.89 54.78 304.83 270.43 945.54 3234.1 188.07 75.27 3683.73 1184.53 876.75 2249.05 4813.67 218.77 I 0.01 0.08 0.04 0.1 0.04 0.03 0.09 0.04 0.02 0.02 0.1 0.07 0.03 0.03 0 0.06 0.09 0.05 0.02 0.02 0.03 0.03 J 4 2 15 16 22 17 23 8 39 47 32 47 37 48 32 27 13 35 31 3 5 48 38 K 149.45 -98.23 -72.81 -82.54 -23.69 417.47 -407.85 29.76 1708.84 -30.54 23.82 -83.16 254.58 2033.5 -101.85 -1.84 708.76 -26.49 -248.69 -571.24 44.58 -188.13 705 L 1.39 9.45 8 .4 6.14 1.99 7.69 66.27 0.81 5.81 1.57 2.35 6.16 5.97 8.99 7.86 2.99 8.99 7.12 19.99 24.49 19.99 7.78 070 M 0.38 0.6 0.37 0.59 0.51 0.58 0.65 0.4 0.65 0.59 0.47 0.35 0.38 0.35 0.37 0.37 0.59 0.67 0.56 0.52 0.79 0.37 00 lord 112 12010 MADA Drod 7 orric Unnur Dunnen DAMIDE Cuct A1 EE 27 N 7 - 2 A B C D G 88 Ord_1344 4/1/2018 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_514 Ord_1122 4/2/2018 MEDIUM Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_412 90 Ord_1122 4/2/2018 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_412 91 Ord_1139 4/2/2018 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_422 92 Ord_1021 4/3/2018 CRITICAL Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust 387 93 Ord_1525 4/3/2018 MEDIUM Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_501 94 Ord 1525 4/3/2018 MEDIUM Prod 8 TECHNOLOGY COMPUTER PERIPHERALS Cust_501 95 Ord_1525 4/3/2018 MEDIUM Prod 6 OFFICE SUPPLIES PAPER Cust 501 96 Ord_1054 4/4/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_391 97 Ord_1538 4/5/2018 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust 558 98 Ord 1564 4/7/2018 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_500 99 Ord 1473 4/7/2018 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_554 100 Ord_1473 4/7/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_554 101 Ord_1473 4/7/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_554 102 Ord_10 4 /8/2018 NOT SPEC Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust 10 103 Ord_1501 4/8/2018 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_508 104 Ord_1501 4/8/2018 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_508 105 Ord_142 4/8/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_51 106 Ord_142 4/8/2018 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_51 107 Ord_142 4/8/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_51 108 Ord_1133 4/10/2018 MEDIUM Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_421 109 Ord_1268 4/10/2018 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_478 110lard 12601 /inn10 MEDIUM Drod S CUDNITIDE ACCICC CUDNIISUINIGS Cuct 170 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly H 218.77 73.55 4804.039 69.66 5544.99 11266.4 71.61 10.43 330.22 210.86 916.05 99.36 510.15 735.09 80.61 191.43 1234.85 17.19 15.31 2689.48 2329.4 103.72 105 15 I 0.03 0.09 0.08 0.07 0.04 0.08 0.1 0.07 0.07 0.04 0.08 0 0.04 0.1 0.02 0.06 0.03 0 0.01 0.04 0.08 0.02 nna J K 38 -188.13 32 7.95 46 1077.92 40 -51.42 43 -3404.24 50 1902.99 15 -70.31 -4.72 21 -51.72 21 5.5 39 -21.9 18 -51.2 49 -362.11 153.5 -4.72 39.5 34 2 12.2 -35.34 -8.15 27 399.93 37 189.77 17 -72.06 - 102 L .78 0.78 8.8 1.99 130 43.32 4.93 0.8 10.91 6.02 12.98 5.68 12.52 7.87 2.99 2.99 8.22 1.99 4.86 19.99 6.88 6.98 212 M 0.37 0.52 0.59 0.51 0.78 0.55 0.66 0.36 0.36 0.48 0.39 0.36 0.57 0.54 0.37 0.39 0.57 0.49 0.38 0.5 0.73 0.39 72 15 20 N O P A B C D E G 110 Ord_1268 4/10/2018 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_478 111 Ord_1268 4/10/2018 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_478 112 Ord_1119 4/11/2018 NOT SPEC Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_417 113 Ord_1102 4/12/2018 CRITICAL Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_427 114 Ord_1102 4/12/2018 CRITICAL Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_427 115 Ord 1136 4/12/2018 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_436 116 Ord_1136 4/12/2018 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_436 117 Ord_1374 4/12/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_511 118 Ord_1374 4/12/2018 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_511 119 Ord_1236 5/1/2018 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_468 120 Ord 1251 5/1/2018 CRITICAL Prod 5 FURNITURE OFFICE FURNISHINGS Cust_469 121 Ord_1251 5/1/2018 CRITICAL Prod_5 FURNITURE OFFICE FURNISHINGS Cust_469 122 Ord 12515/1/2018 CRITICAL Prod 17 TECHNOLOGY OFFICE MACHINES Cust_469 123 Ord_1335 5/1/2018 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_508 124 Ord 1052 5/2/2018 NOT SPEC Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust 398 125 Ord_1183 5/2/2018 HIGH Prod 6 OFFICE SUPPLIES PAPER Cust_451 126 Ord_1183 5/2/2018 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_451 127 Ord_1396 5/2/2018 NOT SPEC Prod_5 FURNITURE OFFICE FURNISHINGS Cust_512 128 Ord 1396 5/2/2018 NOT SPEC Prod 11 FURNITURE TABLES Cust_694 129 Ord 1128 5/3/2018 MEDIUM Prod 6 OFFICE SUPPLIES PAPER Cust_435 130 Ord_1128 5/3/2018 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_435 131 Ord 1128 5/3/2018 MEDIUM Prod 5 FURNITURE OFFICE FURNISHINGS Cust_435 122 and 1120 5/9/2010 MEDIUM Drod A TECUNOLOGY TCICDUONCS AND COMMUNICATION Cuct 020 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly + H 185.15 308.64 58.98 54.8 1038.19 39.44 11.01 292.96 2206.991 154.44 4201.08 8958.46 4913.7 120.53 438.47 112.57 1562.69 75.19 3028.86 186.67 185.79 196.41 2051 02 I 0.09 0.03 0 0 0.07 0 0.09 0.09 0.04 0.06 0.01 0.02 0 0.1 0.02 0.08 J K 4 10.2 15 91.08 9 -17.79 5 -15.3 40 230.69 5 -0.94 3 -1.42 3 -322.95 13 -1.63 33 54.62 21 1162.76 41 2593.14 33 1054.93 10 49.26 14 157.89 17 -28.53 43 287.74 22 -59.12 40 -2595.65 92.06 5 -159.68 9 27.91 - 26250 26 L 34.2 6.38 4.97 1.99 4.08 2.99 5.33 19.99 5.26 0.88 11.54 21.21 17.85 2.85 2.99 5.14 8.22 3.97 69 8.68 7.53 11.17 M 0.73 0.56 0.35 0.43 0.57 0.35 0.43 0.52 0.56 0.39 0.59 0.59 0.56 0.55 0.06 0.04 0.02 0.02 0.01 001 0.35 0.37 0.57 0.58 0.68 0.37 0.76 0.6 n 50 A514 - x fic J K N A 132 Ord_1128 133 Ord 1412 134 Ord 1529 135 Ord_1529 136 Ord_1546 137 Ord_1546 138 Ord 1546 139 Ord_1061 140 Ord 1345 141 Ord_1345 142 Ord_1112 143 Ord_1112 144 Ord_1185 145 Ord 1137 146 Ord_1137 147 Ord_1141 148 Ord_1141 149 Ord_102 150 Ord_1411 151 Ord_1411 152 Ord_123 153 Ord_1092 151 and 1002 B C D E G 5/3/2018 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_928 5/4/2018 NOT SPEC Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust 526 5/4/2018 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_562 5/4/2018 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_562 5/5/2018 LOW Prod_2 OFFICE SUPPLIES APPLIANCES Cust 519 5/5/2018 LOW Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_519 5/5/2018 LOW Prod 5 FURNITURE OFFICE FURNISHINGS Cust_519 5/6/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_397 5/6/2018 MEDIUM Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust 486 5/6/2018 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_486 5/7/2018 NOT SPEC Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_421 5/7/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_421 5/7/2018 MEDIUM Prod_12 OFFICE SUPPLIES LABELS Cust_451 5/8/2018 LOW Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust 416 5/8/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_416 5/8/2018 LOW Prod_17 TECHNOLOGY OFFICE MACHINES Cust_416 5/8/2018 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_416 5/8/2018 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_43 5/8/2018 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_493 5/8/2018 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_493 5/8/2018 NOT SPEC Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_75 5/9/2018 NOT SPEC Prod_5 FURNITURE OFFICE FURNISHINGS Cust_1426 sla/un10 NOT SDCC Drod z CCICC CUDDLICS DUIDDCD DANDC Cuct 1126 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly H 2051.824 87.31 564.98 129.48 5567.79 503.2935 796.03 333.3 63.34 151.35 325.97 49.65 12.11 195.51 377.13 1255.48 411.56 128.21 1567.51 1914.65 82.61 927.82 122 27 I 0.01 0.05 0.1 0.04 0.04 0.02 0.05 0.03 0.03 0.07 0.02 0.02 0.02 0.03 0.02 0.06 0.09 43 26 18 47 10 32 15 17 42 46 10 3 26 38 11 46 19 40 17 49 43 27 -15.09 -107.51 46.01 1726.66 -222.82 -133.71 71.04 -76.02 8.33 -255.22 8.27 -0.98 -105.72 -10.296 -292.65 -188.02 -55.13 711.74 73.45 -46.25 255.03 6.60 L 8.8 1.49 15.1 2.83 3.99 5 15.68 1.99 6.27 1.93 8.37 1.49 0.5 7.72 .02 56.14 7.28 6.57 5.08 8.64 1.57 6.67 M 0.58 0.36 0.38 0.37 0.6 0.83 0.62 0.43 0.4 0.35 0.58 0.35 0.38 0.38 0.48 0.4 0.57 0.37 0.38 0.78 0.59 0.49 0.05 0.01 0.01 0.08 0.02 nna A514 - X Fac J N O A B C D E G H 154 Ord_1092 5/9/2018 NOT SPEC Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_1426 123.37 155 Ord_1092 5/9/2018 NOT SPEC Prod_5 FURNITURE OFFICE FURNISHINGS Cust_413 90.75 156 Ord 1386 5/9/2018 HIGH Prod 10 FURNITURE BOOKCASES Cust_494 1992.45 157 Ord_1452 5/9/2018 NOT SPEC Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_528 4587.926 158 Ord_1452 5/9/2018 NOT SPEC Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_528 4541.924 159 Ord_120 5/9/2018 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_82 387 160 Ord 1255 5/10/2018 MEDIUM Prod 6 OFFICE SUPPLIES PAPER Cust_464 338.89 161 Ord_1255 5/10/2018 MEDIUM Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_464 362.52 162 Ord 1091 5/11/2018 LOW Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust 421 463 163 Ord_1057 5/12/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_403 436.98 164 Ord 117 5/12/2018 NOT SPEC Prod 4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust 81 173.417 165 Ord_1067 5/16/2018 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_397 7333.45 166 Ord_100 5/16/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_58 121.12 167 Ord 1019 5/17/2018 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_385 112.36 168 Ord_1019 5/17/2018 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_385 481.049 169 Ord_1031 5/20/2018 NOT SPEC Prod_9 OFFICE SUPPLIES ENVELOPES Cust_390 335.35 170 Ord 1031 5/20/2018 NOT SPEC Prod 6 OFFICE SUPPLIES PAPER Cust_448 148.31 171 Ord 1055 5/30/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_402 321.71 172 Ord_1105 6/1/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_422 108.73 173 Ord_1378 6/1/2018 CRITICAL Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_532 1446.97 174 Ord_11816/2/2018 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_444 7548.65 175 Ord_1181 6/2/2018 LOW Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_444 1318.869 176 and 1500 67/2010 MEDIUM Drod 6. OCCICE CUDDLICS DADCD Cuct 542642 52 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly + I 0.09 0.02 0.05 0.1 0.01 0.01 0.07 0.07 0.07 0.07 0 0.07 0.1 0.08 0.09 0.05 0.03 0.1 0.04 0 0.03 0.03 K 27 -6.69 6 -26.39 40 -1609.92 30 687.41 42 1222.14 30 -31.45 6 45.76 25 -68.49 32 24.61 35 75.61 9 18.23 27 -207.28 3 -118.82 33 -159.74 16 46.51 39 -134.97 20 37.33 6 -2.73 16 -22.21 47 531.47 45 1385.35 24 172.33 22 175 0 7 L 0.7 14.37 54.11 4.2 8.08 6.13 10.75 7.51 7.17 4.98 0.99 35 1.99 6.27 1.1 8.29 2.17 16.11 5.22 1.99 30 3.99 5 77 M 0.8 0.73 0.69 0.6 0.57 0.57 0.36 0.57 0.38 0.48 0.37 0.8 0.44 0.4 0.55 0.38 0.38 0.39 0.6 0.5 0.62 0.59 ! O Type here to search B A R - e_DEV 9 x ^ W - alla : A514 x for J N O P M 0.38 I 0.05 0.01 0.05 0.09 0.04 0.07 0.02 0.02 0.04 32 27 16 20 33 L 5.77 6.22 NA 0.71 35 NA 9.37 0.52 29 5 33 38 45 37 1.39 48.26 6.3 0.1 30 1.99 A B C D E G 176 Ord_1599 6/2/2018 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_542 177 Ord_1599 6/2/2018 MEDIUM Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_542 178 Ord_1163 6/4/2018 LOW Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_442 179 Ord_1243 6/4/2018 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_472 180 Ord_1447 6/4/2018 MEDIUM Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_519 181 Ord_1491 6/4/2018 HIGH Prod_2 OFFICE SUPPLIES APPLIANCES Cust_555 182 Ord_1491 6/4/2018 HIGH Prod_9 OFFICE SUPPLIES ENVELOPES Cust_555 183 Ord_1491 6/4/2018 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES Cust_555 184 Ord_1491 6/4/2018 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES Cust_555 185 Ord_1443 6/5/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_492 186 Ord_1443 6/5/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust 492 187 Ord_146 6/5/2018 CRITICAL Prod_17 TECHNOLOGY OFFICE MACHINES Cust 60 188 Ord_1155 6/6/2018 NOT SPEC Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust 440 189 Ord_1155 6/6/2018 NOT SPEC Prod_17 TECHNOLOGY OFFICE MACHINES Cust_440 190 Ord_1357 6/7/2018 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_522 191 Ord_1357 6/7/2018 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_522 192 Ord_1071 6/8/2018 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_408 193 Ord_1071 6/8/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_408 194 Ord_1049 6/9/2018 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_397 195 Ord_1327 6/10/2018 NOT SPEC Prod_6 OFFICE SUPPLIES PAPER Cust_506 196 Ord_1577 6/10/2018 NOT SPEC Prod_6 OFFICE SUPPLIES PAPER Cust_559 197 Ord_1089 6/11/2018 LOW Prod_2 OFFICE SUPPLIES APPLIANCES Cust 416 100 lard 10005/11/anio w Drod 2. OCCICC SUDDLICS ADDLLANCES Cuct 116 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly H 643.53 1217.77 77.96 2227.34 476.06 67.87 542.24 15174.95 1084.12 5382.24 1035.95 3051.27 33.64 701.94 482.91 2969.637 115.45 163.89 42.67 391.42 387.79 9046.33 267 06 0.08 0.1 0.07 0.01 0.1 0.04 0.07 0.02 0.06 0.04 0.01 K 175.97 283.14 1 6.65 -609.09 -120.48 -112.54 268.53 7251.92 294.43 14.85 342.41 121.48 -35.17 158.91 -16.59 383.45 23.53 -108.55 -12.72 25.03 -56.51 1398.03 16 11 33.6 2.83 6.3 6.25 8.99 2.06 4.93 2.99 5.12 5.83 55.24 25 0.56 0.55 0.38 0.36 0.38 0.79 0.43 0.37 0.77 0.38 0.58 0.58 0.39 0.66 0.37 0.4 0.36 0.57 050 10 0 46 12 006 J N O P A514 2 A 198 Ord_1089 199 Ord_1089 200 Ord_1089 201 Ord_1111 202 Ord 1418 203 Ord 1418 204 Ord_1098 205 Ord_1098 206 Ord 1239 207 Ord_1597 208 Ord_1022 209 Ord_1023 210 Ord_1068 211 Ord_1068 212 Ord_1068 213 Ord_106 214 Ord_106 215 Ord 106 216 Ord_1211 217 Ord_1211 218 Ord 1211 219 Ord 1256 220 and 1012 : X fic B C D E G 6/11/2018 LOW Prod_2 OFFICE SUPPLIES APPLIANCES Cust_416 6/11/2018 LOW Prod_9 OFFICE SUPPLIES ENVELOPES Cust_416 6/11/2018 LOW Prod_12 OFFICE SUPPLIES LABELS Cust_416 6/11/2018 NOT SPEC Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_421 6/11/2018 NOT SPEC Prod 1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_539 6/11/2018 NOT SPEC Prod 4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust 539 6/12/2018 MEDIUM Prod_17 TECHNOLOGY OFFICE MACHINES Cust_424 6/12/2018 MEDIUM Prod 6 OFFICE SUPPLIES PAPER Cust_424 6/12/2018 NOT SPEC Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust 472 6/12/2018 NOT SPEC Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_529 6/22/2018 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_363 6/26/2018 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_388 6/26/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_398 6/26/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_398 6/26/2018 HIGH Prod_12 OFFICE SUPPLIES LABELS Cust_398 6/27/2018 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_67 6/27/2018 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_67 6/27/2018 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_67 7/1/2018 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_458 7/1/2018 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_458 7/1/2018 MEDIUM Prod 11 FURNITURE TABLES Cust_458 7/1/2018 HIGH Prod 4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust 469 77/anio CPITICAL nrod 10 CUDNITUDE DOOKCASES Cuct 205 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly H 367.96 159.05 116.14 1196.792 442.57 53.737 5236.14 74.02 87.23 6123.48 2011.636 260.59 503.08 4256.51 76.94 18.37 1943.72 6175.777 50.07 147.16 6982.87 607.597 710 25 I 0.06 0.04 0.01 0.07 0.01 0.05 0.05 0.07 0.09 0.08 0.01 0.09 0.01 0.03 0 0.01 0.03 0.07 0.03 0.01 0.05 0.07 nos K 43 -16.11 27 21.46 39 50.44 26 265.39 27 -60.73 5 -28.44 13 567.59 11 -28.45 14 -69.53 44 1232.79 12 -53.69 43 -157.76 12 -102.74 41 1653.96 15 29.67 6 -4.06 47 -1003.58 49 1881.58 19 -0.53 21 -92.55 32 875.55 11 -112.24 100600 L 3.5 2.5 0.5 1.25 8.78 5.03 12.06 5.74 7.78 24.49 3.99 7.03 6.5 7.18 0.99 1.2 34.2 3.9 0.86 8.4 29.1 M 0.58 0.36 0.36 0.55 0.57 0.6 0.56 0.37 0.37 0.57 0.59 0.37 0.74 0.46 0.39 0.58 0.73 0.55 0.57 0.37 0.68 0.58 5.99 26.71 A514 - J N O P A 219 Ord_1256 220 Ord 1042 221 Ord_1079 222 Ord 1499 223 Ord 1499 224 Ord_1439 225 Ord_1189 226 Ord 1379 227 Ord_1379 228 Ord_1381 229 Ord_1381 230 Ord_1381 231 Ord_1147 232 Ord 1099 233 Ord_1209 234 Ord_1209 235 Ord 1435 236 Ord_118 237 Ord_115 238 Ord_115 239 Ord_115 240 Ord_1560 21 and 1560 x for B C D E 1 G 7/1/2018 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_469 7/2/2018 CRITICAL Prod 10 FURNITURE BOOKCASES Cust_395 7/2/2018 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_414 7/2/2018 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust 487 7/2/2018 CRITICAL Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_487 Cust_487 7/2/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_527 7/3/2018 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_452 7/3/2018 NOT SPEC Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust 502 7/3/2018 NOT SPEC Prod 6 OFFICE SUPPLIES PAPER Cust_502 7/3/2018 NOT SPEC Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_533 7/3/2018 NOT SPEC Prod 6 OFFICE SUPPLIES PAPER Cust_533 7/3/2018 NOT SPEC Prod_6 OFFICE SUPPLIES PAPER Cust_533 7/4/2018 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_439 7/5/2018 CRITICAL Prod 13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_425 7/6/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_463 7/6/2018 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_463 7/6/2018 CRITICAL Prod 9 OFFICE SUPPLIES ENVELOPES Cust_545 7/6/2018 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_63 7/6/2018 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_79 7/6/2018 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_79 7/6/2018 CRITICAL Prod 6 OFFICE SUPPLIES PAPER Cust_79 7/7/2018 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_512 7/7/2010 low Drods. CUDNITUDC ACCICC CUDNIISUINGS Cuct 512 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly H 607.597 748.25 619.77 3900.531 248.42 3351.55 49.61 711.1 498.16 351.49 74.13 195.03 244.85 198.08 28.65 201.535 437.86 23792.93 234.28 1779.892 207.08 870.75 12 27 I 0.07 0.05 0.02 0.08 0.02 0.04 0 0.08 0.03 0.03 0.08 0.09 0.06 0.02 0.02 0.09 0.04 0 0.09 0.09 0.09 0.09 002 K 11 -112.24 10 -86.99 42 50.24 42 1144.63 35 -58.81 37 -1036.92 1 -41.82 36 241.08 48 40.61 8 107.32 16 -69.34 45 -148.87 14 38.06 47 32.69 16 -23.86 12 -122.62 38 -4.17 18 10951.31 8 -65.42 41 -250.17 48 -131.82 35 100.5 12 0.52 L 5.99 26.74 7.17 2.5 4.42 56.2 17.08 2.99 5.12 2.99 6.72 5.74 8.99 0.94 1.99 3.3 6.97 19.99 13.99 5 5.17 5.3 NA non M 0.58 0.6 0.38 0.57 0.58 0.74 0.4 0.36 0.4 0.35 0.4 0.4 0.47 0.56 0.51 0.81 0.35 0.35 0.58 0.8 0.4 n10 2 - J M N O A 240 Ord_1560 241 Ord_1560 242 Ord_1497 243 Ord_1010 244 Ord_1010 245 Ord_1485 246 Ord_1145 247 Ord_1072 248 Ord_1072 249 Ord_1310 250 Ord_1442 251 Ord_1078 252 Ord_1153 253 Ord_1153 254 Ord_1153 255 Ord_1581 256 Ord_1581 257 Ord_1581 258 Ord 1581 259 Ord_1581 260 Ord_137 261 Ord_137 262 ard 1004 B C D E G 7/7/2018 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_512 7/7/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_512 7/7/2018 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_557 7/8/2018 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_366 7/8/2018 HIGH Prod_11 FURNITURE TABLES Cust_366 7/8/2018 HIGH Prod_2 OFFICE SUPPLIES APPLIANCES Cust 550 7/9/2018 NOT SPEC Prod_12 OFFICE SUPPLIES LABELS Cust_439 7/10/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_401 7/10/2018 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_401 7/10/2018 NOT SPEC Prod_6 OFFICE SUPPLIES PAPER Cust_491 7/10/2018 LOW Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_498 7/11/2018 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_413 7/12/2018 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_444 7/12/2018 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_444 7/12/2018 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_444 7/12/2018 CRITICAL Prod_2 OFFICE SUPPLIES APPLIANCES Cust_519 7/12/2018 CRITICAL Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_519 7/12/2018 CRITICAL Prod_17 TECHNOLOGY OFFICE MACHINES Cust_519 7/12/2018 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust 519 7/12/2018 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_519 7/12/2018 CRITICAL Prod_12 OFFICE SUPPLIES LABELS Cust_81 7/12/2018 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_81 _7/an/2010 NOT SDCC Drod 2 CCICE SUDDLICS DINIDCDS AND DINDCD ACCESSODICS Cuct 265 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly H 870.75 43.37 121.19 195.23 4051.8 385.99 48.37 154.94 1642.642 125.16 258.13 257.97 356.95 2063.42 112.86 382.19 2573.92 727.64 2564.578 2795.004 78.47 108.42 120 54 I 0.09 0.02 0.09 0.08 0.1 0.09 0.02 0.09 0.08 0.02 0.03 0.03 0.08 0.03 0.04 0.03 0.07 0.01 0.07 0.02 0.06 0.02 n1 K 35 100.5 13 9.53 30 -152.13 35 -72.46 35 -684.07 48 -40.72 16 18.02 2 -358.43 44 314.84 18 -23.48 41 84.1 1933.18 1 -228.24 38 989.95 17 -56.78 24 11.39 17 117.23 40 27.64 25 331.29 16 311.09 17.99 16 -50.82 5400 L 5.3 NA 0.99 7.01 5.57 51.94 3.5 0.5 4 4.99 5.14 1.82 4.98 19.99 5.15 4.07 6.75 143.71 8.51 7.69 8.99 0.99 6.81 105 0.48 0.37 0.41 0.63 0.58 0.36 0.76 0.56 0.37 0.35 0.4 0.38 0.36 0.66 0.52 0.55 0.4 0.58 0.58 0.36 0.36 027 Clipboard Font Alignment Number Styles L Cells Editing Ideas A514 J N O I 0.01 0.08 L 4.95 26 28 0.04 0.78 4 4 24 19 | AB G 262 Ord_1004 7/20/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_365 263 Ord_1004 7/20/2018 NOT SPEC Prod_5 FURNITURE OFFICE FURNISHINGS Cust_365 264 Ord 1004 7/20/2018 NOT SPEC Prod 7 OFFICE SUPPLIES RUBBER BANDS Cust_365 265 Ord 1058 7/22/2018 NOT SPEC Prod 8 TECHNOLOGY COMPUTER PERIPHERALS Cust 404 266 Ord_1058 7/22/2018 NOT SPEC Prod_5 FURNITURE OFFICE FURNISHINGS Cust_404 267 Ord_1058 7/22/2018 NOT SPEC Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_404 268 Ord 103 7/22/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_48 269 Ord_1034 7/25/2018 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_393 270 Ord_1007 7/26/2018 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_379 271 Ord_1032 7/26/2018 NOT SPEC Prod 2 OFFICE SUPPLIES APPLIANCES Cust_391 272 Ord 1046 7/29/2018 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_391 273 Ord 1046 7/29/2018 CRITICAL Prod 6 OFFICE SUPPLIES PAPER Cust_391 274 Ord_1076 7/30/2018 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_412 275 Ord_1076 7/30/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_412 276 Ord_1354 8/2/2018 CRITICAL Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_519 277 Ord_1252 8/3/2018 CRITICAL Prod_5 FURNITURE OFFICE FURNISHINGS Cust_465 278 Ord_1252 8/3/2018 CRITICAL Prod 6 OFFICE SUPPLIES PAPER Cust 465 279 Ord 1228 8/3/2018 HIGH Prod 17 TECHNOLOGY OFFICE MACHINES Cust_473 280 Ord_1228 8/3/2018 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES Cust_473 281 Ord_1366 8/3/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_488 282 Ord_1311 8/3/2018 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_492 283 Ord_1502 8/3/2018 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_556 201 and 1503 o/o/onio iw Drod O OCCICE SUDDUCS CAIVCLOCS Cuct 556 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly H 139.54 199.52 85.66 136.68 1452.48 3555.29 252.79 113.5 2766.818 1925.83 185.64 225.98 404.24 1381.88 156.15 119.63 177.92 2451.41 851.24 25.52 1246.52 105.85 170 22 0.01 0.07 0.09 0.09 0.05 0.03 0.09 0.1 0.01 0.02 0.09 0.08 0.03 10 K -54.08 13.44 6.67 -125.16 376.52 183.28 58.23 -46.35 846.95 359.83 -69.87 -135.74 -76.99 598.2 -37.6 -27.39 -167.92 773.36 -149.46 21.77 52.48 -44.86 50 76 M 0.37 0.42 0.52 0.75 0.63 0.71 0.35 0.4 0.55 0.55 0.4 0.37 0.37 0.44 0.56 0.51 10.84 19.99 2.99 6.28 5.92 0.99 6.28 7.86 13.18 6.77 7.42 3.63 6.72 10.17 33.6 6.22 12.98 2.74 020 34 23 32 10 0.4 40 50 11 0.07 0.1 0.01 0.01 0.37 0.37 0.55 0.39 0.71 20 10 Number Styles Cells Editing Ideas N O P Clipboard Font to Alignment A514 : * fic A B C D E 284 Ord_1502 8/3/2018 LOW Prod 9 OFFICE SUPPLIES ENVELOPES 285 Ord_1367 8/4/2018 CRITICAL Prod 2 OFFICE SUPPLIES APPLIANCES 286 Ord_1394 8/4/2018 NOT SPEC Prod_5 FURNITURE OFFICE FURNISHINGS 287 Ord_1043 8/5/2018 HIGH Prod 9 OFFICE SUPPLIES ENVELOPES 288 Ord_1130 8/5/2018 LOW Prod_9 OFFICE SUPPLIES ENVELOPES 289 Ord_1545 8/5/2018 CRITICAL Prod_11 FURNITURE TABLES 290 Ord_1545 8/5/2018 CRITICAL Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES 291 Ord_1296 8/6/2018 MEDIUM Prod 6 OFFICE SUPPLIES PAPER 292 Ord_159 8/8/2018 NOT SPEC Prod 6 OFFICE SUPPLIES PAPER 293 Ord 159 8/8/2018 NOT SPEC Prod 1 OFFICE SUPPLIES STORAGE & ORGANIZATION 294 Ord_1035 8/9/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS 295 Ord_1035 8/9/2018 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION 296 Ord_14198/9/2018 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS 297 Ord_14198/9/2018 LOW Prod_11 FURNITURE TABLES 298 Ord_1047 8/11/2018 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES 299 Ord_1047 8/11/2018 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS 300 Ord_1293 8/12/2018 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES 301 Ord_1037 8/17/2018 CRITICAL Prod 6 OFFICE SUPPLIES PAPER 302 Ord_1069 8/20/2018 NOT SPEC Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES 303 Ord_1048 8/30/2018 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES 304 Ord_1241 9/1/2018 NOT SPEC Prod 12 OFFICE SUPPLIES LABELS 305 Ord_1385 9/1/2018 CRITICAL Prod 6 OFFICE SUPPLIES PAPER 206 and 1285 o/1/2010 PITICAL Drod 1 ACCICE SUDDLICS STORAGC . ORGANIZATION Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly G Cust 556 Cust_493 Cust_508 Cust_400 Cust_428 Cust_551 Cust_551 Cust_484 Cust_89 Cust_89 Cust_394 Cust_394 Cust_487 Cust 487 Cust 1145 Cust_401 Cust_483 Cust_396 Cust_402 Cust_401 Cust_467 Cust_521 Cuct 521 H 179.33 1562.97 894.64 260.39 171.52 4201.47 55.66 115.54 270.23 660.27 357.43 4754.08 1207.08 2618.112 6688.11 16.73 17717.34 264.75 252.99 518.8 45.87 268.94 01702 I 0 0.01 0.01 0.09 0.1 0.04 0.08 0.04 0.08 0.09 0.08 0 0.05 0.04 0.08 0.08 0 0.08 0.08 0.1 0.02 0.02 J K 1 9 -58.76 34 501.59 -27.79 -48.57 46.61 199.25 -21.4 43.35 52.02 20 63.83 17 - 135.98 21 299.88 12 -351.3 11 -139.27 45 2872.88 1 -6.96 37 8291.08 43 -212.51 28.76 17 54.63 -38.9 39 -87.52 2012105 L 8.29 4.62 19.46 12.39 1.39 52.2 2.31 0.8 5.47 5.49 6.5 28.66 58.2 61.76 13.99 4.98 69.3 M 0.38 0.56 0.44 0.35 0.38 0.64 0.56 0.36 0.39 0.6 0.78 0.72 0.58 0.78 0.38 0.48 0.37 0.37 0.47 0.37 0.39 0.37 061 8.4 2.35 11.63 9 6.89 6.41 45 0 - - J N O 38 4 33 38 3 18 27 43 A 306 Ord_1385 307 Ord_1590 308 Ord_16 309 Ord_16 310 Ord_1579 311 Ord 1579 312 Ord_1579 313 Ord_1462 314 Ord_1498 315 Ord 1584 316 Ord_1584 317 Ord_101 318 Ord_101 319 Ord 1588 320 Ord_104 321 Ord_104 322 Ord_1218 323 Ord_1218 324 Ord_1218 325 Ord_1218 326 Ord_1469 327 Ord_1149 220 ard 1201 B C D E G H 9/1/2018 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust 521 847.82 9/2/2018 MEDIUM Prod 6 OFFICE SUPPLIES PAPER Cust_556 47.03 9/3/2018 LOW P rod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_14 Cust_14 511.83 9/3/2018 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_14 184.99 9/3/2018 CRITICAL Prod 6 OFFICE SUPPLIES PAPER Cust_566 23.38 9/3/2018 CRITICAL Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_566 139.37 9/3/2018 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust 566 1221.62 9/4/2018 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_541 38.56 9/4/2018 CRITICAL Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_551 48.01 9/4/2018 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_567 129.06 9/4/2018 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_567 1236.64 9/4/2018 NOT SPEC Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_73 300.2 9/4/2018 NOT SPEC Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_731364.803 9/5/2018 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_518 36.37 9/5/2018 NOT SPEC Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_62 50.97 9/5/2018 NOT SPEC Prod_16 OFFICE SUPPLIES SCISSORS, RULERS AND TRIMMERS Cust_62 4.99 9/7/2018 HIGH Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_468 9418.73 9/7/2018 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_468 1265.497 9/7/2018 HIGH Prod 6 OFFICE SUPPLIES PAPER Cust_468 5.68 9/7/2018 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_468 174.59 9/7/2018 HIGH Prod 6 OFFICE SUPPLIES PAPER Cust_507 311.21 9/8/2018 CRITICAL Prod 6 OFFICE SUPPLIES PAPER Cust_440 109.37 alo/anio NOT nec rod 12 OCCICE SUDDUCS DENIS ADT CUDDLICS Cuct non 720 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly I 0.05 0.08 0.1 0.05 0.08 0.04 0.01 0.03 0.1 0.1 0.01 0 0.07 0.07 0.09 0.04 0 0.1 0.02 0.08 0.09 0.07 01 K L -1348.5 45 -12.03 5.03 -172.88 13.18 -144.55 4.93 - 12.195 .14 1.72 2.64 -468.64 35 4.08 1.49 -6.85 1.12 -75.13 4.97 518.81 1.99 6.41 8.22 -183.68 -10.26 1.49 4.45 0.73 -3.06 1.32 2245.24 58.95 -161.12 -1.82 0.88 25.88 0.94 -14.03 6.47 25.96 1.79 20 00 000 M 0.61 0.37 0.37 0.66 0.37 0.59 0.8 0.35 0.58 0.38 0.4 0.57 0.83 0.37 0.56 0.83 0.57 0.59 0.39 0.56 0.38 0.38 050 8 29 19 10 1 27 13 42 11 A514 J 0 8 10 I 0.1 0.05 0.04 0.07 0.04 0.1 0.02 0 0.05 0.09 A A 328 Ord_1284 329 Ord_1388 330 Ord_1389 331 Ord_1389 332 Ord_1230 333 Ord_1449 334 Ord_1449 335 Ord_1566 336 Ord_116 337 Ord_116 338 Ord_116 339 Ord_1082 340 Ord_1520 341 Ord_1454 342 Ord_1138 343 Ord_1138 344 Ord_1355 345 Ord 1012 346 Ord_1001 347 Ord_107 348 Ord 1077 349 Ord_1077 250lard 1202 B C D E H 9/8/2018 NOT SPEC Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_480 238.74 9/8/2018 NOT SPEC Prod 10 FURNITURE BOOKCASES Cust_495 633.13 9/8/2018 NOT SPEC Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_536 10.33 9/8/2018 NOT SPEC Prod 7 OFFICE SUPPLIES RUBBER BANDS Cust_536 14.39 9/10/2018 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_465 96.75 9/10/2018 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_511 1136.47 9/10/2018 CRITICAL Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_511 325.81 9/10/2018 LOW Prod 2 OFFICE SUPPLIES APPLIANCES Cust_553 1223.11 9/10/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_80 114.12 9/10/2018 NOT SPEC Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_80 436.05 9/10/2018 NOT SPEC Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_805247.484 9/11/2018 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_417 240.63 9/11/2018 HIGH Prod 6 OFFICE SUPPLIES PAPER Cust_498 30.47 9/11/2018 NOT SPEC Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_523 1278.647 9/12/2018 MEDIUM Prod 2 OFFICE SUPPLIES APPLIANCES Cust_411 170.45 9/12/2018 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_411 350.42 9/12/2018 NOT SPEC Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust 520 1968.47 9/24/2018 CRITICAL Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_382 104.51 9/27/2018 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_374 1981.26 9/30/2018 MEDIUM Prod 6 OFFICE SUPPLIES PAPER Cust_75 157.97 10/1/2018 LOW Prod 8 TECHNOLOGY COMPUTER PERIPHERALS Cust_411 1307.35 10/1/2018 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_411 523.58 in/1/2010 DIGU. Drod 2. OCCICE SUDDUCS DINDCDS AND DINDED ACCESSODICS Cuct 150 6000 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly + 2 22 10 2 21 30 15 49 31 4 7 K -38.89 -203.9 -3.86 -10.24 -72.91 323.32 -522.78 161.72 15.73 -92.58 1465.87 -117.92 -10.7 -396.17 -30.27 -37.3 327.9 -9.28 100.8 -42.38 -154.24 -179.36 50 22 L MN 8.99 0.58 36.61 0.61 1.58 0.39 3.37 0.54 5.41 0.35 9.07 0.35 6.5 0.74 13.22 0.56 1.49 0.38 4 0.75 8.08 0.57 5.53 0.69 5.15 0.36 4.2 0.59 4.62 0.56 5.81 0.6 8.99 0.59 4.71 0.35 8.66 0.76 16.87 0.39 8.65 0.74 19.99 0.66 600 20 0.02 0.02 0.01 0.09 0.03 0.04 0.04 0.07 0.01 0.05 0.01 006 43 3 12 A514 x for J N O 12 35 12 3 36 26 3 21 24 2 A 350 Ord_1203 351 Ord_1203 352 Ord_1203 353 Ord_1203 354 Ord_1571 355 Ord_1571 356 Ord_1571 357 Ord_1353 358 Ord_1353 359 Ord_1384 360 Ord_1384 361 Ord_1226 362 Ord 1568 363 Ord_1387 364 Ord_1399 365 Ord_1399 366 Ord 1431 367 Ord_1431 368 Ord_1009 369 Ord_1009 370 Ord_1164 371 Ord_1238 272 lord 1720 B C D E G 10/1/2018 HIGH Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_458 10/1/2018 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust 458 10/1/2018 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_458 10/1/2018 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_458 10/1/2018 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust 514 10/1/2018 LOW Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_514 10/1/2018 LOW Prod_9 OFFICE SUPPLIES ENVELOPES Cust_514 10/1/2018 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_518 10/1/2018 MEDIUM Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_518 10/1/2018 CRITICAL Prod_5 FURNITURE OFFICE FURNISHINGS Cust 521 10/1/2018 CRITICAL Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_521 10/2/2018 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_470 10/2/2018 MEDIUM Prod 3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust 502 10/2/2018 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_535 10/3/2018 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_496 10/3/2018 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_496 10/3/2018 MEDIUM Prod 5 FURNITURE OFFICE FURNISHINGS Cust_540 10/3/2018 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_540 10/4/2018 NOT SPEC Prod_17 TECHNOLOGY Cust_366 10/4/2018 NOT SPEC Prod_6 OFFICE SUPPLIES PAPER Cust 366 10/4/2018 NOT SPEC Prod_2 OFFICE SUPPLIES APPLIANCES Cust_445 10/4/2018 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_473 in /10 MEDIUM Drod A TCCUNOLOGY TCICDUANES AND COMMUNICATION Cuct 172 Raw data Revenue Analysis Quantity Sold 2017 Ys 2018 Quarterly H 69.98 418.34 45.61 17.7 188.34 1493.858 32.49 111.66 231.95 199.12 63.14 1297.449 138.24 124.84 2430.34 218.6 450.39 1193.12 2219.79 237.36 9492.92 89.18 1540 205 I 0.06 0.08 0.1 0.06 0.04 0.02 0.08 0.06 0.03 0.01 0.06 0.04 0.06 0.08 0.08 0.05 0.07 0.08 0.1 0.07 0.05 0.04 nos 24 19 18 22 20 46 36 23 17 30 25 29 31 so K -58.33 73.57 9.18 -10.37 -110.16 183.24 -5.05 -53.33 44.14 73.33 -53.75 4.21 -48.22 10.56 752.87 -46.43 152.79 137.59 -9.45 - 117.86 772.04 21.73 020 65 L 6.98 5.16 0.7 4.79 5.74 8.8 1.39 5.49 1.99 0.96 3.97 10.78 5.19 1.56 13.88 4.96 6.15 0.99 33.6 9.86 91.05 0.81 __125 M 0.39 0.43 0.44 0.4 0.36 0.58 0.35 0.38 0.43 0.43 0.56 0.58 0.38 0.52 0.36 0.36 0.44 0.55 0.37 0.4 0.57 0.4 n 26 A514 - x fix J N O P I 0.05 0.08 . A B C D G 372 Ord_1238 10/4/2018 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_473 373 Ord_1578 10/4/2018 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_501 374 Ord_1578 10/4/2018 CRITICAL Prod 6 OFFICE SUPPLIES PAPER Cust 501 375 Ord_1414 10/4/2018 MEDIUM Prod_2 OFFICE SUPPLIES APPLIANCES Cust_536 376 Ord_1414 10/4/2018 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_536 377 Ord_1489 10/4/2018 NOT SPEC Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_544 378 Ord_1106 10/5/2018 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust 419 379 Ord 1157 10/5/2018 HIGH Prod 8 TECHNOLOGY COMPUTER PERIPHERALS Cust_444 380 Ord_1157 10/5/2018 HIGH Prod 6 OFFICE SUPPLIES PAPER Cust_444 381 Ord_1247 10/6/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_472 382 Ord_1395 10/6/2018 MEDIUM Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_515 383 Ord 1395 10/6/2018 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_515 384 Ord 1018 10/7/2018 MEDIUM Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_362 385 Ord_130 10/8/2018 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_1064 386 Ord_130 10/8/2018 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_1064 387 Ord_1453 10/8/2018 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_536 388 Ord_145 10/8/2018 CRITICAL Prod_5 FURNITURE OFFICE FURNISHINGS Cust_85 389 Ord_145 10/8/2018 CRITICAL Prod_11 FURNITURE Cust_85 390 Ord 130 10/8/2018 LOW Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_89 391 Ord_1382 10/9/2018 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_532 392 Ord_1383 10/9/2018 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_534 393 Ord 1383 10/9/2018 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_534 201lard 1212 16/12/2010 MEDIUM Drod & OCCICE CUDDUCS DADCD Cuct 162 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly H 1540.285 3978.02 843.15 235.09 187.46 203.4 309.46 1538.33 147.46 132.72 138.96 158.97 55.59 376.65 40.06 6163.52 1003.31 6048.18 1665.04 2367.99 522.06 1218.08 0.08 0 0.04 0.08 0.03 0.06 0.05 0.03 0.08 0.03 0 0.07 0.02 0.01 0.04 0.02 0.04 0.06 0.1 K 50 829.65 24 1336.96 16 355 43 -1987.49 10 49.85 29 24.59 49 -82.64 39 471.35 39 14.13 14 -9.18 49 19.87 39 -30.27 8 -17.95 16 -52.65 6 -24.44 26 755.95 23 51.9 17 1418.36 35 366.51 14 320.1 5 319.64 37 99.79 22 51 42 L 1.25 19.99 5.81 49 8.99 2.35 2.74 1.99 1.93 5.6 0.7 2.99 5.74 15.1 4.69 28.66 14.45 60 NA 3.3 11.87 13.99 8.99 M 0.36 0.4 0.38 0.6 0.47 0.47 0.71 0.54 0.35 0.36 0.56 0.37 0.36 0.38 0.68 0.72 0.57 0.59 0.62 0.65 0.56 n20 1 A514 - x fix N P I 0 0.04 0.05 0.08 0.07 0.1 0.01 0 5 A B C D E G 394 Ord_1213 10/12/2018 MEDIUM Prod_6 OFFICE SUPPLIES PAPER Cust_462 395 Ord_1514 10/12/2018 HIGH Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_529 396 Ord_1 10/13/2018 LOW Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_1 397 Ord 1070 10/14/2018 HIGH Prod_17 TECHNOLOGY OFFICE MACHINES Cust_400 398 Ord_1070 10/14/2018 HIGH Prod_6 OFFICE SUPPLIES PAPER Cust_400 399 Ord_1008 10/26/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_380 400 Ord_1029 10/29/2018 HIGH Prod_2 OFFICE SUPPLIES APPLIANCES Cust_389 401 Ord_1056 10/30/2018 NOT SPEC Prod_2 OFFICE SUPPLIES APPLIANCES Cust_395 402 Ord_1056 10/30/2018 NOT SPEC Prod_6 OFFICE SUPPLIES PAPER Cust_395 403 Ord_1056 10/30/2018 NOT SPEC Prod_6 OFFICE SUPPLIES PAPER Cust_395 404 Ord_1065 11/1/2018 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_407 405 Ord_1065 11/1/2018 LOW Prod_17 TECHNOLOGY OFFICE MACHINES Cust_407 406 Ord_121 11/1/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_45 407 Ord_1244 11/1/2018 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_467 408 Ord_1595 11/2/2018 CRITICAL Prod_2 OFFICE SUPPLIES APPLIANCES Cust_541 409 Ord_1144 11/3/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_437 410 Ord_1321 11/3/2018 LOW Prod_17 TECHNOLOGY OFFICE MACHINES Cust_486 411 Ord 1321 11/3/2018 LOW Prod 6 OFFICE SUPPLIES PAPER Cust_486 412 Ord_1173 11/4/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_449 413 Ord_1173 11/4/2018 NOT SPEC Prod_6 OFFICE SUPPLIES PAPER Cust_449 414 Ord_1192 11/4/2018 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_455 415 Ord_1331 11/4/2018 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_486 116 and 1170 11/6/2010 JIGU Drod TECUNOLOGY TELEDUONES AND COMMUNICATION Cuct 151 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly H 172.9 7341.96 261.54 17304.85 794.32 689.67 199.93 5198.12 188.53 718.41 9843.11 7190.06 1143.45 1965.21 1002.73 317.59 16587.13 507.98 887.45 355.97 430.55 3821.039 1105 104 0.1 0.07 0.08 0.06 0 0.08 0.06 0.08 0.05 0.1 0.03 J K 2 3 51.43 32 764.95 6 -213.25 36 7434.48 20 67.61 38 51.47 14 -105.33 48 1481.67 23 -27.49 19 2 3.94 35 -384. 6 15 1908.45 31 304.42 24 830.75 17 -563.86 36 -46.12 7 -3476.86 9 170.9 47 365.79 -4.46 35 120.01 38 1057.89 26 211 no L M 2 0.39 64.2 0.59 35 0.8 28.14 0.38 17.48 0.36 8.99 0.47 13.32 0.43 15.66 0.57 .96 0.38 17.48 0.36 5 7 0.78 28.14 0.38 1.99 0.51 19.99 0.43 49 0.59 6.19 0.38 29.7 0.57 4.86 0.36 1.490 .35 19.99 0.37 2.85 0.55 5.99 0.57 DOO 56 0.05 7 - HJ14 - JE I J N O H 1495.184 1388.628 21.46 165.37 8 5 0.03 0.05 0.06 0.03 0.03 0 L .99 .26 6.26 4.07 7.23 5.63 M 0.56 0.56 0.4 0.66 0.41 0.39 0.52 0.71 0.39 A B C D E G 416 Ord 1178 11/6/2018 HIGH Prod 4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust 451 417 Ord_1266 11/6/2018 CRITICAL Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_477 418 Ord_1266 11/6/2018 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_477 419 Ord_1358 11/6/2018 LOW Prod 8 TECHNOLOGY COMPUTER PERIPHERALS Cust_523 420 Ord_1358 11/6/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_523 421 Ord_1459 11/6/2018 CRITICAL Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_529 422 Ord_1377 11/8/2018 HIGH Prod_13 OFFICE SUPPLIES PENS & ART SUPPLIES Cust_531 423 Ord_1433 11/8/2018 HIGH Prod_12 OFFICE SUPPLIES LABELS Cust_545 424 Ord_1433 11/8/2018 HIGH Prod_12 OFFICE SUPPLIES LABELS Cust_545 425 Ord_1424 11/9/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_492 426 Ord_1434 11/9/2018 NOT SPEC Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_526 427 Ord 134 11/10/2018 HIGH Prod_11 FURNITURE TABLES Cust_138 428 Ord_134 11/10/2018 HIGH Prod_2 OFFICE SUPPLIES APPLIANCES Cust_138 429 Ord_134 11/10/2018 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_91 430 Ord_1503 11/11/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_498 431 Ord_1503 11/11/2018 HIGH Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_498 432 Ord_1027 11/13/2018 MEDIUM Prod_10 FURNITURE BOOKCASES Cust_366 433 Ord_1027 11/13/2018 MEDIUM Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_366 434 Ord 1038 11/13/2018 NOT SPEC Prod 5 FURNITURE OFFICE FURNISHINGS Cust_397 435 Ord_1038 11/13/2018 NOT SPEC Prod_11 FURNITURE TABLES Cust 397 436 Ord_1026 11/19/2018 LOW Prod_17 TECHNOLOGY OFFICE MACHINES Cust_363 437 Ord_1062 11/21/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_397 olard 1060 11/01/2010 NOT SDCC Drod 2 CICC SUDDLICS DINDERS AND DINDCD ACCESCODICE Cuct 207 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly + 127.56 37.3 16.6 25.1 125.46 553.02 6693.28 1482.81 2 75.91 378.08 731.71 1118.82 79.75 3367.24 5723.24 15602.93 85.77 110 21 0.04 0.07 0.1 0.02 0.03 0.1 0 K 26 211.09 24 261.52 3 -14.22 26 -80.11 38 739.48 22 -60.72 7 5.03 4 -2.06 5 2.98 34 -129.63 38 -49.38 40.32 24 -678.63 44 -162.37 17 70.48 24 175.82 8 -320.3 48 -41.32 44 -1183.69 37 - 194.97 48 4875.89 27 -102.02 12 777 0.99 0.49 5.47 6.5 69 49 5.03 1.99 0 1.99 0.39 0.37 0.48 0.67 0.59 0.6 0.43 0.5 0.77 0.49 0.74 0.69 0.56 0.36 n 26 0.04 0.1 0.07 36.09 1.56 48.2 51.92 26.53 5.44 51 0 0.03 N O P L 5.14 5.92 64.73 5.5 2 A B C D E G 438 Ord_1062 11/21/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_397 439 Ord_1041 11/21/2018 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_399 440 Ord_1066 11/23/2018 NOT SPEC Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_406 441 Ord_1437 12/1/2018 CRITICAL Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_1307 442 Ord_1437 12/1/2018 CRITICAL Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_1307 443 Ord_1094 12/1/2018 NOT SPEC Prod_2 OFFICE SUPPLIES APPLIANCES Cust_412 444 Ord_1437 12/1/2018 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust 547 445 Ord_1382 12/2/2018 NOT SPEC Prod_17 TECHNOLOGY OFFICE MACHINES Cust 532 446 Ord_1387 12/2/2018 LOW Prod_12 OFFICE SUPPLIES LABELS Cust_535 447 Ord_15 12/3/2018 NOT SPEC Prod_12 OFFICE SUPPLIES LABELS Cust_4 448 Ord_15 12/3/2018 NOT SPEC Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_4 449 Ord_1081 12/3/2018 HIGH Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_416 450 Ord_139 12/3/2018 CRITICAL Prod_17 TECHNOLOGY OFFICE MACHINES Cust 45 451 Ord_1428 12/3/2018 LOW Prod_8 TECHNOLOGY COMPUTER PERIPHERALS Cust_501 452 Ord_1428 12/3/2018 LOW Prod_6 OFFICE SUPPLIES PAPER Cust_501 453 Ord_1402 12/3/2018 HIGH Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_527 454 Ord_1014 12/4/2018 CRITICAL Prod_5 FURNITURE OFFICE FURNISHINGS Cust_368 455 Ord_1014 12/4/2018 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust 368 456 Ord_1158 12/4/2018 MEDIUM Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_445 457 Ord_1158 12/4/2018 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_445 458 Ord_1475 12/4/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_518 459 Ord_1277 12/5/2018 NOT SPEC Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_466 160 and 1777 17/5/2010 NOT SDCC Drod 5 CUDNITUDC OCCICE CLID NIISUINGS Cuct 166 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly H 149.31 933.21 3701.521 6435.87 312.03 1603.27 145.93 3220.58 103.62 59.03 97.48 2853.884 2671.21 583.56 281.47 236.45 131.09 1817.9 473.88 849.031 167.46 2255.195 107 12 I 0 0.05 0.05 0.04 0.08 0.01 0 0.04 0.1 0.1 0.05 0.06 0.06 0.02 0.1 0.06 0.01 0.06 0.01 0.07 0.09 0.03 nna J 13 40 38 21 11 27 27 22 15 13 21 27 14 26 47 32 10 33 4 50 40 46 0 K 7.77 207.18 894.06 935.06 -66.66 452.49 113.32 1046.69 39.98 26.92 -5.77 492.24 636.18 -94.59 - 190.57 -259.02 10.94 700.31 -183.26 -133.31 -134.3 74.51 124 3.99 7.44 13.99 0.49 0.5 0.7 7.69 15.59 6.5 7.37 9.69 2.85 10.75 30 3.3 5.41 5 1120 M 0.36 0.51 0.58 0.56 0.51 0.57 0.36 0.38 0.38 0.38 0.8 0.58 0.36 0.78 0.37 0.83 0.55 0.36 0.71 0.81 0.35 0.8 017 O P - - - J N O I 0.09 0 0.09 0.04 0.07 0 0.04 0.02 0.03 0.06 A B C D E G H 460 Ord_1277 12/5/2018 NOT SPEC Prod_5 FURNITURE OFFICE FURNISHINGS Cust_466 187.13 461 Ord_1275 12/5/2018 LOW Prod 6 OFFICE SUPPLIES PAPER Cust_467 26.23 462 Ord_152 12/5/2018 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES 557.23 463 Ord_1191 12/6/2018 LOW Prod_5 FURNITURE OFFICE FURNISHINGS Cust_1787 2612.89 464 Ord 1191 12/6/2018 LOW Prod_11 FURNITURE TABLES Cust_1787 1146.992 465 Ord_1162 12/6/2018 LOW Prod_9 OFFICE SUPPLIES ENVELOPES Cust_447 64.44 466 Ord_1191 12/6/2018 LOW Prod_10 FURNITURE BOOKCASES Cust_451 4581.41 467 Ord_1271 12/7/2018 MEDIUM Prod 6 OFFICE SUPPLIES PAPER Cust_466 128.5 468 Ord 1409 12/7/2018 LOW Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_496 311.65 469 Ord_1409 12/7/2018 LOW Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_496 101.19 470 Ord_1420 12/8/2018 MEDIUM Prod_4 TECHNOLOGY TELEPHONES AND COMMUNICATION Cust_542 52.0965 471 Ord_1318 12/9/2018 MEDIUM Prod_12 OFFICE SUPPLIES LABELS Cust_499 102.56 472 Ord_1318 12/9/2018 MEDIUM Prod_7 OFFICE SUPPLIES RUBBER BANDS Cust_499 15.87 473 Ord_1563 12/9/2018 CRITICAL Prod_1 OFFICE SUPPLIES STORAGE & ORGANIZATION Cust_517 345.57 474 Ord_1544 12/9/2018 NOT SPEC Prod_3 OFFICE SUPPLIES BINDERS AND BINDER ACCESSORIES Cust_564 60.92 475 Ord 1544 12/9/2018 NOT SPEC Prod 5 FURNITURE OFFICE FURNISHINGS Cust_564 387.17 476 Ord_1006 12/10/2018 NOT SPEC Prod 2 OFFICE SUPPLIES APPLIANCES Cust_378 1758.41 477 Ord_1229 12/10/2018 LOW Prod_15 FURNITURE CHAIRS & CHAIRMATS Cust_473 3505.6 478 Ord 1000 12/11/2018 HIGH Prod 6 OFFICE SUPPLIES PAPER Cust_373 334.71 479 Ord_1063 12/11/2018 CRITICAL Prod_6 OFFICE SUPPLIES PAPER Cust_406 54.3 480 Ord_1050 12/12/2018 MEDIUM Prod_5 FURNITURE OFFICE FURNISHINGS Cust_402 690.88 481 Ord_1060 12/12/2018 HIGH Prod_5 FURNITURE OFFICE FURNISHINGS Cust_405 691.09 102 and 1060 19/12/2010 JIGU Drod 12 OCCICE SUDDUCS DENIS 2. ADT SLIDDLICS Cuct 105 7127 Raw data Revenue Analysis Quantity Sold 2017 vs 2018 Quarterly + K 9 12.4 3 -13.72 24 -42.99 25 490.99 47 -1643.74 21 -89.02 36 -904.73 17 -44.69 45 -71.25 28 32.47 1 -232.8 40 36.62 2.53 4 -218.77 33 -17.2 8 190.6 18 238.52 26 1019.7 25 31.74 6 1.27 32 119.25 9 364.03 22 176.no L 14.39 6.6 12.98 10.12 45.51 6.35 54.74 6.93 5.48 0.71 2.5 0.5 0.76 35 1.49 4.8 15.66 12.65 NA 6.47 2.03 7.58 19.99 207 M 0.47 0.37 0.39 0.79 0.65 0.36 0.69 0.37 0.37 0.39 0.83 0.39 0.39 0.81 0.37 0.68 0.57 3 0.06 0.01 0.06 0.07 0.01 0.06 0.03 0.01 0.1 0.08 0.08 002 0.38 0.37 0.51 0.43 55 Lupbudlu PUPIL Allyrirleri Nulber Styles Lens LUILINU A514 J N O L 2