L M A B C D E F G H I K In the green cells calculate Shipping Expense using the data on the "Region" and "Customer" data tables in columns 1 and J. If "Warehouse" and "Location" comprise the same letter (i.e., "WarehouseF" and "LocationF"), then Shipping Expense is $15. For every letter in the alphabet further away, add $3.25-X. [EX: If a transaction comprises a sale from "WarehouseA" to "LocationC", then Shipping Expense is equal to $15 +$3.25^2 (where A-->-->C= 2). HINT: This worksheet can and probably should be broken down into a series of steps, where: (1) you need to convert Region --> Warehouse and convert Customer --> Location using the orange and green reference tables respectively; (2) you need to extract the letter from Warehouse/Location; (3) you need to convert that letter using a new table of letter --> number combinations; (4) then lastly you can calculate the absolute value difference of both numbers, and that is what will be plugged in for "X" in your shipping expense calculation. I recommend referring back to Beginner Topics and Intermediate 1 Topics for appropriate formulas. Shipping Exp 5 Region Region Region2 Region3 Region4 Region5 Region6 Region 7 Region8 Warehouse WarehouseE WarehouseB Warehouse WarehouseA W arehouseC WarehouseF WarehouseC WarehouseB | 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Date 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 Product Product3 Product7 Product2 Producto Product3 Product Product10 Product Product10 Producto Product Product2 Product Product7 Product2 Products Product10 Product4 Product4 Product2 Product Product9 Product2 Products Product Product10 Products Product2 Product3 Product9 Product4 Product7 Product Product3 Products Product1 Producto Product1 Product9 Product7 Producto Product9 Product10 Product4 Product7 Product Region Region3 Region4 Region4 Region4 Region4 Region8 Region8 Region2 Region5 Region4 Region2 Region4 Region4 Region2 Region8 Region8 Region3 Region6 Region1 Region5 Region 1 Region5 Region3 Region8 Region7 Region6 Region6 Region6 Region2 Region4 Region7 Region2 Region7 Region8 Region1 Region7 Region8 Region2 Region6 Region5 Region4 Region5 Region4 Region8 Region8 Region4 Sales Rep Customer Sales COGS Sales Rep2 | Customer16 S 14,046S 5,337 Sales Rep15 Customer72 $ 2,504 S 1,703 Sales Rep18 Customer71 S 1,505 S 843 Sales Rep 14 Customer88S 4,232S 2,793 Sales Rep3 | Customer65S 5,947S 3,390 Sales Rep6 Customer 100 S 5,721S 3,204 Sales Rep16 Customer68 $ 14,744S 5,308 Sales Rep1 Customer85 $ 4,018 S 2,371 Sales Rep6 Customer6 S 6,442S 4,445 Sales Rep7 | Customer1 S 8,160 S 3,509 Sales Rep17 Customer28 S 7,520 S 4,738 Sales Rep8 | Customer 16 S 11,981 S 8,387 Sales Rep1 Customer95S 2 ,468 S 1,209 | SalesRep6 Customer65 S 14,239 7,120 Sales Rep 16 Customer69 S 2,455 S 1,056 Sales Rep10 Customer 10 S 11,538 S 3,577 Sales Rep15 Customer14 S 4,341 S 1,823 Sales Rep3 | Customer74 S 9,948 $ 5,670 SalesRep17 Customer695 6,525 $ 2,675 SalesRep3 Customer7 $ 7,354 $ 4,559 Sales Rep7 | Customer49 S 12,132S 7,886 SalesRep1 Customer88S 8,853 $ 3,984 Sales Rep16 Customer 13 S 14,718 S 5,887 Sales Rep17 Customer52S 7,299 $ 4,890 Sales Rep15 Customer82S 5,125 S 1,589 Sales Rep12 Customer 39 S 9,010 $ 2,793 SalesRep11 Customer655 9,725 3,209 Sales Rep15 Customer95S 8,443S 4,644 Sales Rep10 Customer73S 12,727 $ 4,836 Sales Rep11 | Customer68 S 7,106S 4,903 Sales Rep18 Customer37 S 8,479 5,851 Sales Rep11 | Customer89 S 13,336 S 6,001 Sales Rep3 | Customer71 S 7 ,034 S 4,502 SalesRep11 Customer24 S 11,5875 7 ,647 Sales Rep9 Customer19 S 14,745 S 8,994 Sales Rep9 | Customer54 S 11,045 S 7,069 Sales Rep2Customer 10 S 13,767 S 5,644 | Sales Rep3 Customer21S 3,712 $ 2,561 SalesRep13 Customer47 $ 7,145 S 3,573 SalesRep17 Customer 106 $ 7,843 $ 3,608 Sales Rep7 Customer 48S 8,425 $ 2,865 Sales Rep14 Customer445 9,7115 6,701 Sales Rep15 Customer57S 2,477 S 1,115 Sales Rep12 Customer 100 $ 14,567 S 7,138 Sales Rep15 Customer83 $ 7,586 S 5,083 Sales Rep. Customer84 S 4,679 S 3,229 Houstolululululululululululululululululululululululululululululululululululu | ] 1 Customer Customer Customer2 Customer3 Customer4 Customers Customer6 Customer7 Customer8 Customer9 Customer 10 Customer11 Customer12 Customer13 Customer14 Customer15 Customer16 Customer17 Customer18 Customer19 Customer20 Customer21 Customer22 Customer23 Customer24 Customer25 Customer26 Customer27 Customer28 Customer29 Customer 30 Customer31 Customer32 Customer33 Customer34 Customer35 Customer36 Location LocationB Locationc LocationB Locationc LocationF LocationA LocationD LocationE Locationc LocationA Location LocationD LocationF Locationc Locationc LocationE LocationF LocationA LocationF LocationF LocationE Locationc Locationc LocationB LocationF LocationA LocationD LocationE Locationc LocationD LocationE LocationA LocationE LocationF LocationE LocationA I 14 x fx H | 5 Sales Reple | Customer57 AB 51 5/4/2020 Product10 52 5/4/2020 Product9 53 5/4/2020 Producto 54 5/4/2020 Product3 55 5/4/2020 Product 10 56 5/4/2020 Producto 57 5/4/2020 Product 58 5/4/2020 Product1 9 5/4/2020 Product 60 5/4/2020 Product9 61 5/4/2020 Product1 62 5/4/2020 Product3 63 5/4/2020 Product 10 64 5/4/2020 Products 65 5/4/2020 Product7 68 5/4/2020 Products 67 5/4/2020 Product7 68 5/4/2020 Product2 69 5/4/2020 Products 70 5/4/2020 Product 71 5/4/2020 Producto 72 5/4/2020 Products 73 5/4/2020 Product10 74 5/4/2020 Product10 75 5/4/2020 Product7 76 5/4/2020 77 5/4/2020 Product10 78 5/4/2020 Product 3 79 5/4/2020 Producto 80 5/4/2020 Products 81 5/4/2020 Product7 82 5/4/2020 Producto 83 5/4/2020 Product 1 84 5/4/2020 Product10 85 5/4/2020 Products 86 5/4/2020 Product 10 87 5/4/2020 Products 88 5/4/2020 Product4 89 5/4/2020 Product3 90 5/4/2020 | Product2 91 5/4/2020 Products 92 5/4/2020 Producto 93 5/4/2020 Product 94 5/4/2020 Product 95 5/4/2020 Product2 96 5/4/2020 Product9 97 5/4/2020 Products 98 5/4/2020 Product2 99 5/4/2020 Product3 100 5/4/2020 Product1 101 5/4/2020 Product4 102 5/4/2020 Products 103 5/4/2020 Product2 104 5/4/2020 Producto 105 5/4/2020 Product 106 5/4/2020 Products 107 5/4/2020 Products 108 5/4/2020 Product7 C Region 6 Region 6 Region 6 Region1 Region 1 Region5 Region6 Region2 Region Region6 Region7 Region4 Region8 Region7 Region6 Region2 Region7 Region7 Region7 Region3 Region 3 Region6 Region4 Region4 Region2 Region6 Region5 Region2 Region 6 Region1 Region3 Region1 Region4 Region8 Region2 Region8 Region1 Region5 Region3 Region5 Region4 Region7 Region7 Region 1 Region 6 Region4 Region2 Region8 Region6 Region3 Region4 Region8 Region7 Region4 Region4 Region7 Region5 Region4 Region 6 D E Sales Rep9 Customer78 S Sales Rep18 Customer98 S Sales Rep18 Customer23 S Sales Rep17 Customer74 S Sales Rep10 | Customer25 S Sales Rep1 Customer57 $ Sales Rep14 Customer97 $ Sales Rep6 | Customer95 $ Sales Rep11 | Customer57 SalesReplica Sales Rep12 Customer46 S Sales Rep11 | Customer24 S Sales Rep16 Customer59 $ Sales Rep13 Customer44 S Sales Rep13 Customer92 $ Sales Rep1 Customer85 $ Sales Rep12 Customer59 $ Sales Rep16 Customer58 S Sales Rep3 Customer48S Sales Rep15 Customer7S Sales Rep13 Customer 103 S Sales Rep17 | Customer66 $ Sales Rep4 | Customer41 $ Sales Rep7 Customer9 $ Sales Rep12 Customer27 S Sales Rep12 Customer86S Sales Rep1 Customer94 $ Sales Rep10 Customer S Sales Rep 16 Customer57 Sales Rep13 Customer33 $ Sales Rep16 Customer35 S Sales Rep17 | Customer88 $ Sales Rep4 | Customer76 S Sales Rep11 | Customer70 S Sales Rep11 Customer30 S Sales Rep4 Customer3 S Sales Rep2Customer11 S Sales Rep1 Customer96 $ Sales Rep15 Customer 72 $ Sales Rep9 | Customer17 S Sales Rep3 | Customer73 $ Sales Rep10 Customer97 S Sales Rep8 Customer19S Sales Rep16 Customer9 S Sales Rep 17 Customer75 $ Sales Rep. Customer43 S Sales Rep13 Customer31 S Sales Rep15 Customer44 $ Sales Rep13 | Customer92 $ Sales Rep1 Customer87 $ Sales Reps Customer 48 $ Sales Rep1 Customer13 S Sales Rep7 Customer85 S Sales Rep15 Customer17 $ Sales Rep16 Customer59 S Sales Rep10 Customer38S Sales Rep4 Customer65S Sales Rep11 Customer28 S Sales Rep6 Customer58 S G 3,692 8 85 2,770 5,531 1,380 5,666 4,130 1,522 1,715 7,256 2,645 1,903 6,098 7,728 3,913 4,450 5,706 4,579 3,494 6,468 2,848 2,909 1,374 1,177 5,631 7,011 6,232 10,102 2,447 6,888 4,374 F 8,790S 1,669 5 3,957S 13,490 S 2,191 $ 9,444S 8,260 S 4,348 S 2,485 S 14,228S 8,267 $ 6,343 S 9,381 S 11,364S 7,986 S 11,126 S 10,766S 8,639S 4,992 S 12,439 S 4,128S 6,464 S 3,122S 2,180 S 12,241 S 11,129S 9 ,302 S 14,856 S 3,598S 11,876 S 11,821 S 11,398S 2,615S 6,544S 3,677 S 9,814S 13,823S 6,575 S 11,895 S 14,707 S 10,877 S 5,788 S 5,141 S 3,418 S 5,865S 11,198 S 6,068S 9,873 S 9,409S 2,216 S 7,284S 14,973S 13,535 S 5,753 S 1,781S 3,842 S 7,1875 7,643S bolo Customer37 Customer38 Customer39 Customer40 Customer41 Customer42 Customer43 Customer44 Customer45 Customer46 Customer47 Customer 48 Customer49 Customer 50 Customer51 Customer 52 Customer53 Customer54 Customer55 Customer56 Customer57 Customer58 Customer59 Customer60 Customer61 Customer62 Customer63 Customer64 Customer65 Customer66 Customer67 Customer68 Customer69 Customer 70 Customer71 Customer72 Customer73 Customer74 Customer75 Customer 76 Customer77 Customer78 Customer79 Customer80 Customer81 Customer82 Customer83 Customer84 Customer85 Customer86 Customer87 Customer88 Customer89 Customer90 Customer91 Customer92 Customer93 Customer94 KL. Locationc LocationF LocationE Location Locationc Location LocationF LocationB LocationA LocationE LocationE Locationc LocationB Location LocationC Location LocationD LocationF LocationE Location LocationD LocationE LocationF LocationB LocationB LocationB Location Locationc LocationD Location Location LocationE Location E LocationD Location LocationB LocationA Location LocationB Locationc LocationF Location LocationA LocationA LocationB Locationc LocationD LocationC LocationA Location A LocationB Locationc LocationD Location LocationF LocationD LocationC LocationB | 1,334 2,945 1,949 5,300 4,838 2,433 4,520 4,853 3,263 3,299 2,725 1,812 3,402 4,927 2,063 4,443 | 1,086 4,192 8,834 5,955 3,394 1,959 2,228 4,586 L M A B C D E F G H I K In the green cells calculate Shipping Expense using the data on the "Region" and "Customer" data tables in columns 1 and J. If "Warehouse" and "Location" comprise the same letter (i.e., "WarehouseF" and "LocationF"), then Shipping Expense is $15. For every letter in the alphabet further away, add $3.25-X. [EX: If a transaction comprises a sale from "WarehouseA" to "LocationC", then Shipping Expense is equal to $15 +$3.25^2 (where A-->-->C= 2). HINT: This worksheet can and probably should be broken down into a series of steps, where: (1) you need to convert Region --> Warehouse and convert Customer --> Location using the orange and green reference tables respectively; (2) you need to extract the letter from Warehouse/Location; (3) you need to convert that letter using a new table of letter --> number combinations; (4) then lastly you can calculate the absolute value difference of both numbers, and that is what will be plugged in for "X" in your shipping expense calculation. I recommend referring back to Beginner Topics and Intermediate 1 Topics for appropriate formulas. Shipping Exp 5 Region Region Region2 Region3 Region4 Region5 Region6 Region 7 Region8 Warehouse WarehouseE WarehouseB Warehouse WarehouseA W arehouseC WarehouseF WarehouseC WarehouseB | 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Date 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 5/4/2020 Product Product3 Product7 Product2 Producto Product3 Product Product10 Product Product10 Producto Product Product2 Product Product7 Product2 Products Product10 Product4 Product4 Product2 Product Product9 Product2 Products Product Product10 Products Product2 Product3 Product9 Product4 Product7 Product Product3 Products Product1 Producto Product1 Product9 Product7 Producto Product9 Product10 Product4 Product7 Product Region Region3 Region4 Region4 Region4 Region4 Region8 Region8 Region2 Region5 Region4 Region2 Region4 Region4 Region2 Region8 Region8 Region3 Region6 Region1 Region5 Region 1 Region5 Region3 Region8 Region7 Region6 Region6 Region6 Region2 Region4 Region7 Region2 Region7 Region8 Region1 Region7 Region8 Region2 Region6 Region5 Region4 Region5 Region4 Region8 Region8 Region4 Sales Rep Customer Sales COGS Sales Rep2 | Customer16 S 14,046S 5,337 Sales Rep15 Customer72 $ 2,504 S 1,703 Sales Rep18 Customer71 S 1,505 S 843 Sales Rep 14 Customer88S 4,232S 2,793 Sales Rep3 | Customer65S 5,947S 3,390 Sales Rep6 Customer 100 S 5,721S 3,204 Sales Rep16 Customer68 $ 14,744S 5,308 Sales Rep1 Customer85 $ 4,018 S 2,371 Sales Rep6 Customer6 S 6,442S 4,445 Sales Rep7 | Customer1 S 8,160 S 3,509 Sales Rep17 Customer28 S 7,520 S 4,738 Sales Rep8 | Customer 16 S 11,981 S 8,387 Sales Rep1 Customer95S 2 ,468 S 1,209 | SalesRep6 Customer65 S 14,239 7,120 Sales Rep 16 Customer69 S 2,455 S 1,056 Sales Rep10 Customer 10 S 11,538 S 3,577 Sales Rep15 Customer14 S 4,341 S 1,823 Sales Rep3 | Customer74 S 9,948 $ 5,670 SalesRep17 Customer695 6,525 $ 2,675 SalesRep3 Customer7 $ 7,354 $ 4,559 Sales Rep7 | Customer49 S 12,132S 7,886 SalesRep1 Customer88S 8,853 $ 3,984 Sales Rep16 Customer 13 S 14,718 S 5,887 Sales Rep17 Customer52S 7,299 $ 4,890 Sales Rep15 Customer82S 5,125 S 1,589 Sales Rep12 Customer 39 S 9,010 $ 2,793 SalesRep11 Customer655 9,725 3,209 Sales Rep15 Customer95S 8,443S 4,644 Sales Rep10 Customer73S 12,727 $ 4,836 Sales Rep11 | Customer68 S 7,106S 4,903 Sales Rep18 Customer37 S 8,479 5,851 Sales Rep11 | Customer89 S 13,336 S 6,001 Sales Rep3 | Customer71 S 7 ,034 S 4,502 SalesRep11 Customer24 S 11,5875 7 ,647 Sales Rep9 Customer19 S 14,745 S 8,994 Sales Rep9 | Customer54 S 11,045 S 7,069 Sales Rep2Customer 10 S 13,767 S 5,644 | Sales Rep3 Customer21S 3,712 $ 2,561 SalesRep13 Customer47 $ 7,145 S 3,573 SalesRep17 Customer 106 $ 7,843 $ 3,608 Sales Rep7 Customer 48S 8,425 $ 2,865 Sales Rep14 Customer445 9,7115 6,701 Sales Rep15 Customer57S 2,477 S 1,115 Sales Rep12 Customer 100 $ 14,567 S 7,138 Sales Rep15 Customer83 $ 7,586 S 5,083 Sales Rep. Customer84 S 4,679 S 3,229 Houstolululululululululululululululululululululululululululululululululululu | ] 1 Customer Customer Customer2 Customer3 Customer4 Customers Customer6 Customer7 Customer8 Customer9 Customer 10 Customer11 Customer12 Customer13 Customer14 Customer15 Customer16 Customer17 Customer18 Customer19 Customer20 Customer21 Customer22 Customer23 Customer24 Customer25 Customer26 Customer27 Customer28 Customer29 Customer 30 Customer31 Customer32 Customer33 Customer34 Customer35 Customer36 Location LocationB Locationc LocationB Locationc LocationF LocationA LocationD LocationE Locationc LocationA Location LocationD LocationF Locationc Locationc LocationE LocationF LocationA LocationF LocationF LocationE Locationc Locationc LocationB LocationF LocationA LocationD LocationE Locationc LocationD LocationE LocationA LocationE LocationF LocationE LocationA I 14 x fx H | 5 Sales Reple | Customer57 AB 51 5/4/2020 Product10 52 5/4/2020 Product9 53 5/4/2020 Producto 54 5/4/2020 Product3 55 5/4/2020 Product 10 56 5/4/2020 Producto 57 5/4/2020 Product 58 5/4/2020 Product1 9 5/4/2020 Product 60 5/4/2020 Product9 61 5/4/2020 Product1 62 5/4/2020 Product3 63 5/4/2020 Product 10 64 5/4/2020 Products 65 5/4/2020 Product7 68 5/4/2020 Products 67 5/4/2020 Product7 68 5/4/2020 Product2 69 5/4/2020 Products 70 5/4/2020 Product 71 5/4/2020 Producto 72 5/4/2020 Products 73 5/4/2020 Product10 74 5/4/2020 Product10 75 5/4/2020 Product7 76 5/4/2020 77 5/4/2020 Product10 78 5/4/2020 Product 3 79 5/4/2020 Producto 80 5/4/2020 Products 81 5/4/2020 Product7 82 5/4/2020 Producto 83 5/4/2020 Product 1 84 5/4/2020 Product10 85 5/4/2020 Products 86 5/4/2020 Product 10 87 5/4/2020 Products 88 5/4/2020 Product4 89 5/4/2020 Product3 90 5/4/2020 | Product2 91 5/4/2020 Products 92 5/4/2020 Producto 93 5/4/2020 Product 94 5/4/2020 Product 95 5/4/2020 Product2 96 5/4/2020 Product9 97 5/4/2020 Products 98 5/4/2020 Product2 99 5/4/2020 Product3 100 5/4/2020 Product1 101 5/4/2020 Product4 102 5/4/2020 Products 103 5/4/2020 Product2 104 5/4/2020 Producto 105 5/4/2020 Product 106 5/4/2020 Products 107 5/4/2020 Products 108 5/4/2020 Product7 C Region 6 Region 6 Region 6 Region1 Region 1 Region5 Region6 Region2 Region Region6 Region7 Region4 Region8 Region7 Region6 Region2 Region7 Region7 Region7 Region3 Region 3 Region6 Region4 Region4 Region2 Region6 Region5 Region2 Region 6 Region1 Region3 Region1 Region4 Region8 Region2 Region8 Region1 Region5 Region3 Region5 Region4 Region7 Region7 Region 1 Region 6 Region4 Region2 Region8 Region6 Region3 Region4 Region8 Region7 Region4 Region4 Region7 Region5 Region4 Region 6 D E Sales Rep9 Customer78 S Sales Rep18 Customer98 S Sales Rep18 Customer23 S Sales Rep17 Customer74 S Sales Rep10 | Customer25 S Sales Rep1 Customer57 $ Sales Rep14 Customer97 $ Sales Rep6 | Customer95 $ Sales Rep11 | Customer57 SalesReplica Sales Rep12 Customer46 S Sales Rep11 | Customer24 S Sales Rep16 Customer59 $ Sales Rep13 Customer44 S Sales Rep13 Customer92 $ Sales Rep1 Customer85 $ Sales Rep12 Customer59 $ Sales Rep16 Customer58 S Sales Rep3 Customer48S Sales Rep15 Customer7S Sales Rep13 Customer 103 S Sales Rep17 | Customer66 $ Sales Rep4 | Customer41 $ Sales Rep7 Customer9 $ Sales Rep12 Customer27 S Sales Rep12 Customer86S Sales Rep1 Customer94 $ Sales Rep10 Customer S Sales Rep 16 Customer57 Sales Rep13 Customer33 $ Sales Rep16 Customer35 S Sales Rep17 | Customer88 $ Sales Rep4 | Customer76 S Sales Rep11 | Customer70 S Sales Rep11 Customer30 S Sales Rep4 Customer3 S Sales Rep2Customer11 S Sales Rep1 Customer96 $ Sales Rep15 Customer 72 $ Sales Rep9 | Customer17 S Sales Rep3 | Customer73 $ Sales Rep10 Customer97 S Sales Rep8 Customer19S Sales Rep16 Customer9 S Sales Rep 17 Customer75 $ Sales Rep. Customer43 S Sales Rep13 Customer31 S Sales Rep15 Customer44 $ Sales Rep13 | Customer92 $ Sales Rep1 Customer87 $ Sales Reps Customer 48 $ Sales Rep1 Customer13 S Sales Rep7 Customer85 S Sales Rep15 Customer17 $ Sales Rep16 Customer59 S Sales Rep10 Customer38S Sales Rep4 Customer65S Sales Rep11 Customer28 S Sales Rep6 Customer58 S G 3,692 8 85 2,770 5,531 1,380 5,666 4,130 1,522 1,715 7,256 2,645 1,903 6,098 7,728 3,913 4,450 5,706 4,579 3,494 6,468 2,848 2,909 1,374 1,177 5,631 7,011 6,232 10,102 2,447 6,888 4,374 F 8,790S 1,669 5 3,957S 13,490 S 2,191 $ 9,444S 8,260 S 4,348 S 2,485 S 14,228S 8,267 $ 6,343 S 9,381 S 11,364S 7,986 S 11,126 S 10,766S 8,639S 4,992 S 12,439 S 4,128S 6,464 S 3,122S 2,180 S 12,241 S 11,129S 9 ,302 S 14,856 S 3,598S 11,876 S 11,821 S 11,398S 2,615S 6,544S 3,677 S 9,814S 13,823S 6,575 S 11,895 S 14,707 S 10,877 S 5,788 S 5,141 S 3,418 S 5,865S 11,198 S 6,068S 9,873 S 9,409S 2,216 S 7,284S 14,973S 13,535 S 5,753 S 1,781S 3,842 S 7,1875 7,643S bolo Customer37 Customer38 Customer39 Customer40 Customer41 Customer42 Customer43 Customer44 Customer45 Customer46 Customer47 Customer 48 Customer49 Customer 50 Customer51 Customer 52 Customer53 Customer54 Customer55 Customer56 Customer57 Customer58 Customer59 Customer60 Customer61 Customer62 Customer63 Customer64 Customer65 Customer66 Customer67 Customer68 Customer69 Customer 70 Customer71 Customer72 Customer73 Customer74 Customer75 Customer 76 Customer77 Customer78 Customer79 Customer80 Customer81 Customer82 Customer83 Customer84 Customer85 Customer86 Customer87 Customer88 Customer89 Customer90 Customer91 Customer92 Customer93 Customer94 KL. Locationc LocationF LocationE Location Locationc Location LocationF LocationB LocationA LocationE LocationE Locationc LocationB Location LocationC Location LocationD LocationF LocationE Location LocationD LocationE LocationF LocationB LocationB LocationB Location Locationc LocationD Location Location LocationE Location E LocationD Location LocationB LocationA Location LocationB Locationc LocationF Location LocationA LocationA LocationB Locationc LocationD LocationC LocationA Location A LocationB Locationc LocationD Location LocationF LocationD LocationC LocationB | 1,334 2,945 1,949 5,300 4,838 2,433 4,520 4,853 3,263 3,299 2,725 1,812 3,402 4,927 2,063 4,443 | 1,086 4,192 8,834 5,955 3,394 1,959 2,228 4,586