Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AG22 A B C EFGHIJK In the green cells calculate Shipping Expense using the data on the Region and Customer data tables in columns 1

image text in transcribedimage text in transcribedimage text in transcribed

AG22 A B C EFGHIJK 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.252 (where A->- >C= 2). Date Product Region Sales Rep Customer Sales COGS Shipping Exp Region Warehouse 5 4/28/2020 Product 3 Region3 Sales Rep2 Customer16 $ 14.046 $ 5,337 Region1 Warehouse B 4/28/2020 Product Region 4 Sales Rep15 | Customer72 $ 2.504 s 1.703 Region2 WarehouseB 7 4/28/2020 Product Region 4 Sales Rep18 Customer71 $ 1.505 8 43 Region 3 Warehouses 8 4/28/2020 Producto Region 4 Sales Rep 14 | Customer88 S 4.232 S 2.793 Region 4 WarehouseA 9 4/28/2020 Product Region 4 Sales Rep3 | Customer05 S 5.947 $ 3.390 Region5 WarehouseC 10 4/28/2020 Product Region8 Sales Repo I Customer1001 $ 5.721 ls 3.204 Regiono WarehouseF 11 4/28/2020 Product 10 Regions Sales Rep16 | Customers $ 14.744 S 5.308 Region 7 WarehouseC 12 4/28/2020 Product Region2 SalesRep1 Customer85 $ 4.018 $ 2,371 Region8 WarehouseB 13 4/28/2020 Product 10 Region5 Sales Rep Customer $ 6,442 $ 4,445 14 4/28/2020 Producto Region4 Sales Rep7 Customer1 $ 8,160 $ 3,509 Customer Location 15 4/28/2020 Product Region2 Sales Rep17 Customer28 $ 7,520 $ 4.738 Customer Location B 18 4/28/2020 Product Region 4 Sales Reps Customer18 S 11.981 5 8 .387 Customer Locationc 17 4/28/2020 Products Region4 Sales Rep1 Customer95 $ 2,468 $ 1,209 Customer Location B 18 4/28/2020 Product Region2 Sales Rep Customer85 $ 14,239 $ 7,120 Customer4 Locationc 19 4/28/2020 Product Region Sales Rep18 Customer89 $ 2,455 $ 1,056 Customer5 LocationF 20 4/28/2020 Products Region Sales Rep10 Customer10 $ 11,538 $ 3,577 Customero Location A 21 4/28/2020 Product 10 Region Sales Rep15 Customer14 $ 4,341 $ 1,823 Customer7 Location 22 4/28/2020 Product Region Sales Rep3 | Customer74 | $ 9,948 $ 5,670 Customer Location E 23 4/28/2020 Product Region Sales Rep17 Customer89 $ 6,525 $ 2,675 Customer Locationc 244/28/2020 Product Region 5 Sales Rep3 | Customer7 S 7.354 S 4.559 Customer10 LocationA 25 4/28/2020 Product Region Sales Rep7 Customer49 $ 12,132 $ 7,888 Customer11 Location 28 4/28/2020 Producto Region5 Sales Rep1 | Customer88 S 8.853s 3.984 Customer12 Location 274/28/2020 Product Region Sales Rep18 Customer13 $ 14,718 $ 5,887 Customer13 LocationF 28 4/28/2020 Product Region8 Sales Rep17 | Customer52 S 7.299 $ 4.890 Customer14 Locationc 29 4/28/2020 Product4 Region7 Sales Rep15 Customer82 $ 5,125 $ 1,589 Customer15 Locationc 30 4/28/2020 Product 10 Region Sales Rep12 Customer39 $ 9,010 $ 2,793 Customer16 Location E 31 4/28/2020 Products Region Sales Rep11 Customer05 $ 9,725 $ 3,209 Customer17 LocationF 32 4/28/2020 Product Region Sales Rep15 | Customer95 S 8.443 S 4.644 Customer18 Location A 33 4/28/2020 Product Region2 Sales Rep10 | Customer73 $ 12.727 S 4.838 Customer19 LocationF 34 4/28/2020 Product Region4 Sales Rep11 Customer88 $ 7,108 $ 4,903 Customer20 LocationF 35 4/28/2020 Product4 Region7 Sales Rep18 Customer37 $ 8,479 $ 5,851 Customer21 Location E 38 4/28/2020 Product Region2 Sales Rep11 | Customer89 S 13.338s 6.001 Customer22 Locationc 374/28/2020 Product Region7 Sales Rep3 | Customer71 $ 7,034 $ 4,502 Customer23 Locationc 38 4/28/2020 Product Region8 Sales Rep11 | Customer24 S 11.587 $ 7.647 Customer24 Locations 39 4/28/2020 Product Region Sales Rep9 | Customer19 $ 14,745 $ 8,994 Customer25 LocationF 40 4/28/2020 Product Region7 Sales Rep9 | Customer54 11.045 S 7.089 Customer28 Location A 41 4/28/2020 Producto Region8 Sales Rep2 | Customer10 S 13.787 S 5.644 Customer27 Locations 42 4/28/2020 Product Region2 Sales Rep3 | Customer21 $ 3,712 $ 2,561 Customer28 Location E 43 4/28/2020 Products Region Sales Rep13 | Customer47 $ 7,145 $ 3,573 Customer29 Locationc 44 4/28/2020 Product7 Region5 SalesRep 17 I Customer1081 7 .843 $ 3.808 Customer30 Location 45 4/28/2020 Producto Region4 Sales Rep7 Customer48 $ 8,425 $ 2,885 Customer31 Location E 48 4/28/2020 Producto Region5 Sales Rep 14 | Customer445 9.711 1 s 6.701 Customer32 Location A 47 4/28/2020 Product 10 Region4 Sales Rep15 Customer57 $ 2,477 $ 1,115 Customer33 Location E 184/28/2020 Product Region Sales Rep12 Customer1001 $ 14,587 $ 7,138 Customer34 LocationF 49 4/28/2020 Product Region Sales Rep15 Customer83 $ 7,588 $ 5,083 Customer35 Location E 50 4/28/2020 Product Region4 Sales Rep Customer84 $ 4,679 $ 3,229 Customer38 Location A 51 4/28/2020 Product 10 Region Sales Rep9 Customer78 5 8 .790 s 3.692 Customer37 Locationc 52 4/28/2020 Products Region Sales Rep18 Customer98 $ 1,689 $ 885 Customer38 LocationF 53 4/28/2020 Producto Region Sales Rep18 Customer23 $ 3,957 | $ 2,770 Customer39 Location E 544/28/2020 Product Region Sales Rep17 Customer74 $ 13,490 $ 5,531 Customer40 Location 55 4/28/2020 Product 10 Region1 Sales Rep10 | Customer25 $ 2,191 $ 1,380 Customer41 Locationc 58 4/28/2020 Producto Region5 Sales Rept Customer57 $ 9,444 $ 5,688 Customer42 Location E 57 4/28/2020 Product Region Sales Rep14 Customer97 $ 8,280 $ 4,130 Customer43 LocationF seasessenlessssssssssssssssssssssssssss H I L M G 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 54 4/27/2020 55 4/27/2020 58 4/27/2020 57 4/27/2020 58 4/27/2020 59 4/27/2020 60 4/27/2020 61 4/27/2020 62 4/27/2020 63 4/27/2020 64 4/27/2020 65 4/27/2020 68 4/27/2020 67 4/27/2020 68 4/27/2020 69 4/27/2020 70 4/27/2020 71 4/27/2020 72 4/27/2020 73 4/27/2020 74 4/27/2020 75 4/27/2020 76 4/27/2020 77 4/27/2020 78 4/27/2020 79 4/27/2020 80 4/27/2020 81 4/27/2020 82 4/27/2020 83 4/27/2020 84 4/27/2020 85 4/27/2020 86 4/27/2020 87 4/27/2020 88 4/27/2020 89 4/27/2020 90 4/27/2020 91 4/27/2020 92 4/27/2020 93 4/27/2020 94 4/27/2020 95 4/27/2020 96 4/27/2020 97 4/27/2020 98 4/27/2020 99 4/27/2020 100 4/27/2020 101 4/27/2020 102 4/27/2020 103 4/27/2020 Product3 Product10 Producto Product Product1 Product 1 Product Product1 Product3 Product10 Products Product7 Products Product7 Product2 Products Product7 Producto Products Product10 Product 10 Product Product7 Product10 Product3 Producto Products Product7 Producto Product1 Product10 Products Product10 Products Product Product3 Product2 Products Producto Region 1 Region1 Region5 Region6 Region2 Region6 Region7 Region4 Region8 Region7 Region6 Region2 Region7 Region7 Region7 Region3 Region3 Region6 Region4 Region4 Region2 Region6 Region5 Region2 Region6 Region1 Region 3 Region1 Region4 Region8 Region2 Region8 Region1 Region5 Region3 Region5 Region4 Region7 Region7 Region1 Region6 Region4 Region2 Region8 Region6 Region3 Region4 Region8 Region7 Region4 SalesRep17 Customer74 S Sales Rep10 Customer25 S Sales Rep1 Customer57 S Sales Rep14 Customer97 $ Sales Rep6 | Customer95 $ Sales Rep11 Customer57 S Sales Rep12 Customer46 S Sales Rep11 | Customer24 $ Sales Rep16 Customer59 S Sales Rep13 Customer44 S Sales Rep13 Customer92S Sales Rep1 Customer85 $ Sales Rep12 Customer59 S Sales Rep16 | Customer58 $ Sales Rep3 Customer48S Sales Rep15 Customer7 | $ Sales Rep13 Customer 103S Sales Rep17 | Customer66S Sales Rep4 | Customer41 S Sales Rep7 Customer9 S Sales Rep12 Customer27S Sales Rep12 Customer86 S Sales Rep1 Customer94 S Sales Rep10 Customer4 S Sales Rep16 Customer57 S Sales Rep13 Customer33 $ Sales Rep 16 Customer35 S Sales Rep17 | Customer88 $ Sales Rep4 Customer 76 $ Sales Rep11 Customer 70 $ Sales Rep11 Customer30 $ Sales Rep4 Customer3S Sales Rep2 | Customer 11 S Sales Rep1 Customer96 S Sales Rep15 Customer72S Sales Rep9 Customer17 S Sales Rep3 | Customer73 $ Sales Rep10 Customer97 $ Sales Rep8 Customer19 $ Sales Rep16 Customer9 $ Sales Rep17 | Customer 75 $ Sales Rep. Customer43 $ Sales Rep13 Customer31 S Sales Rep15 Customer44 S Sales Rep13 Customer925 Sales Rep1 Customer87 $ Sales Reps Customer 48 $ Sales Rep1 Customer13 S Sales Rep7 | Customer85 S SalesRep15 Customer17 S F 13,490S 2,191 S 9,444S 8,260 S 4,348S 2,485 S 14,228 S 8,267 S 6,343S 9,381 S 11,364S 7,986 S 11,126S 10,766S 8,639S 4,992 $ 12,439S 4,128S 6,464 S 3,122 $ 2,180 S 12,241 $ 11,129S 9,302 $ 14,856 $ 3,598 S 11,876 S 11,821 $ 11,398S 2,615S 6,544 S 3,677 S 9,814S 13,823 S 6,575 S 11,895S 14 707 14,707 S 10,877 S 5,788 S 5,141 S 3,418 S 5,865 S 11,198S 6,068 S 9,873 $ 9,409S 2216 2,216S S 7,284S 14,973 S 13,535 S 6,232|| 10,102 2,447 6,888 4,374 3,761 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 5,175 1,086 4,192 8.834 5,955 Customer 40 Customer41 Customer42 Customer43 Customer44 | Customer45 Customer 46 Customer47 Customer48 Customer49 Customer 50 Customer51 Customer52 | Customer53 Customer54 Customer 55 Customer 56 Customer57 Customer58 Customer59 Customer60 | Customer61 Customer62 Customer63 Customer64 Customer65 Customer66 Customer67 Customer68 Customer69 Customer 70 Customer71 Customer72 Customer73 Customer 74 Customer75 Customer 76 Customer77 Customer78 Customer79 Customer80 Customer81 Customer82 Customer83 Customer84 Customer85 Customer86 Customer87 Customer88 Customer89 LocationE Locationc LocationE LocationF LocationB LocationA Location Location Locationc LocationB LocationE Locationc Locations Location LocationF Location LocationD LocationD LocationE LocationF LocationB LocationB LocationB Location Locationc LocationD LocationE LocationE LocationE LocationE LocationD LocationE LocationB LocationA LocationE LocationB Locationc LocationF LocationD LocationA Location A Location LocationC LocationD LocationC LocationA Location LocationB Locationc Location Product1 Product2 Product9 Products Product2 Product3 Product Product Product9 Product2 | | | | | | | 85 4/27/2020 86 4/27/2020 87 4/27/2020 88 4/27/2020 89 4/27/2020 90 4/27/2020 91 4/27/2020 92 4/27/2020 93 4/27/2020 94 4/27/2020 95 4/27/2020 98 4/27/2020 97 4/27/2020 98 4/27/2020 99 4/27/2020 100 4/27/2020 101 4/27/2020 102 4/27/2020 103 4/27/2020 104 4/27/2020 105 4/27/2020 106 4/27/2020 107 4/27/2020 108 4/27/2020 109 4/27/2020 110 4/27/2020 111 4/27/2020 112 4/27/2020 113 4/27/2020 114 4/27/2020 115 4/27/2020 116 4/27/2020 117 4/27/2020 118 4/27/2020 119 4/27/2020 120 4/27/2020 121 122 123 124 Products Product10 Products Product4 Product3 Product2 Products Producto Product4 Product1 Product2 Product9 Products Product2 Product3 Product1 Product4 Product9 Product2 Producto Product4 Products Products Product7 Products Product9 Product3 Product7 Product2 Products Products Product7 Product4 Product10 Product7 Product7 Region8 Region1 Region5 Region 3 Region5 Region4 Region7 Region7 Region1 Region6 Region4 Region2 Region8 Region6 Region3 Region4 Region8 Region7 Region4 Region4 Region7 Region5 Region4 Region 6 Region 3 Region2 Region4 Region1 Region8 Region4 Region 6 Region2 Region7 Region4 Region3 Region8 Sales Rep4 Customer3 $ Sales Rep2 | Customer11 S Sales Rep1 Customer96 S Sales Rep15 Customer72S Sales Rep9 Customer17 S Sales Rep3 | Customer73 $ Sales Rep10 Customer97 S Sales Rep8 | Customer19 S Sales Rep16 Customer9 S Sales Rep17 | Customer75 $ Sales Rep6 Customer43 S Sales Rep13 Customer31 S Sales Rep15 Customer44 $ Sales Rep13 Customer92 S Sales Rep1 Customer87 S Sales Reps Customer 48 $ Sales Rep1 Customer13 S Sales Rep7 | Customer85 $ Sales Rep15 | Customer17 S Sales Rep16 Customer59 S Sales Rep10 Customer38 S Sales Rep4 | Customer65S Sales Rep11 | Customer28 S Sales Rep. Customer58 S Sales Rep5 Customer58 $ Sales Rep7 | Customer99 $ Sales Rep10 Customer56 S Sales Reps Customer84 $ Sales Rep7 | Customer87 $ Sales Rep3 | Customer91S Sales Rep13 | Customer47S Sales Rep17 Customer77 S Sales Rep3 | Customer40 $ Sales Rep14 Customer81 $ Sales Rep1 Customer41 S Sales Rep15 Customer70S 3,677 $ 9,814 S 13,823 S 6,575 S 11,895 $ 14,707 S 10,877 S 5,788 S 5,141 $ 3,418 S 5,865 S 11,198 S 6068 S 9,873 S 9,409S 2,216 S 7,284 S 14,973S 13,535 S 5,753 S 1,781 $ 3,842 S 7,1875 7,643 S 6,451 S 5,405 S 13,179 S 6,199 S 2,742 2 742 5 S 3,338 S 13,609 S 8,812S 2,499 S 8,013 S ,777 $ 6,160 S tatutututututulatatututututolulululululululululululullah 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 5,175 1,086 4,192 8,834 5,955 3,394 730 1,959 2,228 4,586 2,451 2,378 5,799 3,223 932 932 1,369 7,621 | 5,199 1,499 3,846 3,408 3,018 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 Customer95 Customer96 Customer97 Customer98 Customer99 Customer 100 Customer 101 Customer 102 Customer103 Customer 104 Customer 105 Customer 106 LocationE Location LocationA Location LocationB Locationc LocationF Location Location A Location A LocationB Locationc Location Locationc LocationA Location A Location B Locationc LocationD LocationE LocationF Location Locationc LocationB Locationc LocationF Location Locationc LocationE LocationB LocationB LocationA LocationC Locationc LocationB LocationE | | | | 5 AG22 A B C EFGHIJK 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.252 (where A->- >C= 2). Date Product Region Sales Rep Customer Sales COGS Shipping Exp Region Warehouse 5 4/28/2020 Product 3 Region3 Sales Rep2 Customer16 $ 14.046 $ 5,337 Region1 Warehouse B 4/28/2020 Product Region 4 Sales Rep15 | Customer72 $ 2.504 s 1.703 Region2 WarehouseB 7 4/28/2020 Product Region 4 Sales Rep18 Customer71 $ 1.505 8 43 Region 3 Warehouses 8 4/28/2020 Producto Region 4 Sales Rep 14 | Customer88 S 4.232 S 2.793 Region 4 WarehouseA 9 4/28/2020 Product Region 4 Sales Rep3 | Customer05 S 5.947 $ 3.390 Region5 WarehouseC 10 4/28/2020 Product Region8 Sales Repo I Customer1001 $ 5.721 ls 3.204 Regiono WarehouseF 11 4/28/2020 Product 10 Regions Sales Rep16 | Customers $ 14.744 S 5.308 Region 7 WarehouseC 12 4/28/2020 Product Region2 SalesRep1 Customer85 $ 4.018 $ 2,371 Region8 WarehouseB 13 4/28/2020 Product 10 Region5 Sales Rep Customer $ 6,442 $ 4,445 14 4/28/2020 Producto Region4 Sales Rep7 Customer1 $ 8,160 $ 3,509 Customer Location 15 4/28/2020 Product Region2 Sales Rep17 Customer28 $ 7,520 $ 4.738 Customer Location B 18 4/28/2020 Product Region 4 Sales Reps Customer18 S 11.981 5 8 .387 Customer Locationc 17 4/28/2020 Products Region4 Sales Rep1 Customer95 $ 2,468 $ 1,209 Customer Location B 18 4/28/2020 Product Region2 Sales Rep Customer85 $ 14,239 $ 7,120 Customer4 Locationc 19 4/28/2020 Product Region Sales Rep18 Customer89 $ 2,455 $ 1,056 Customer5 LocationF 20 4/28/2020 Products Region Sales Rep10 Customer10 $ 11,538 $ 3,577 Customero Location A 21 4/28/2020 Product 10 Region Sales Rep15 Customer14 $ 4,341 $ 1,823 Customer7 Location 22 4/28/2020 Product Region Sales Rep3 | Customer74 | $ 9,948 $ 5,670 Customer Location E 23 4/28/2020 Product Region Sales Rep17 Customer89 $ 6,525 $ 2,675 Customer Locationc 244/28/2020 Product Region 5 Sales Rep3 | Customer7 S 7.354 S 4.559 Customer10 LocationA 25 4/28/2020 Product Region Sales Rep7 Customer49 $ 12,132 $ 7,888 Customer11 Location 28 4/28/2020 Producto Region5 Sales Rep1 | Customer88 S 8.853s 3.984 Customer12 Location 274/28/2020 Product Region Sales Rep18 Customer13 $ 14,718 $ 5,887 Customer13 LocationF 28 4/28/2020 Product Region8 Sales Rep17 | Customer52 S 7.299 $ 4.890 Customer14 Locationc 29 4/28/2020 Product4 Region7 Sales Rep15 Customer82 $ 5,125 $ 1,589 Customer15 Locationc 30 4/28/2020 Product 10 Region Sales Rep12 Customer39 $ 9,010 $ 2,793 Customer16 Location E 31 4/28/2020 Products Region Sales Rep11 Customer05 $ 9,725 $ 3,209 Customer17 LocationF 32 4/28/2020 Product Region Sales Rep15 | Customer95 S 8.443 S 4.644 Customer18 Location A 33 4/28/2020 Product Region2 Sales Rep10 | Customer73 $ 12.727 S 4.838 Customer19 LocationF 34 4/28/2020 Product Region4 Sales Rep11 Customer88 $ 7,108 $ 4,903 Customer20 LocationF 35 4/28/2020 Product4 Region7 Sales Rep18 Customer37 $ 8,479 $ 5,851 Customer21 Location E 38 4/28/2020 Product Region2 Sales Rep11 | Customer89 S 13.338s 6.001 Customer22 Locationc 374/28/2020 Product Region7 Sales Rep3 | Customer71 $ 7,034 $ 4,502 Customer23 Locationc 38 4/28/2020 Product Region8 Sales Rep11 | Customer24 S 11.587 $ 7.647 Customer24 Locations 39 4/28/2020 Product Region Sales Rep9 | Customer19 $ 14,745 $ 8,994 Customer25 LocationF 40 4/28/2020 Product Region7 Sales Rep9 | Customer54 11.045 S 7.089 Customer28 Location A 41 4/28/2020 Producto Region8 Sales Rep2 | Customer10 S 13.787 S 5.644 Customer27 Locations 42 4/28/2020 Product Region2 Sales Rep3 | Customer21 $ 3,712 $ 2,561 Customer28 Location E 43 4/28/2020 Products Region Sales Rep13 | Customer47 $ 7,145 $ 3,573 Customer29 Locationc 44 4/28/2020 Product7 Region5 SalesRep 17 I Customer1081 7 .843 $ 3.808 Customer30 Location 45 4/28/2020 Producto Region4 Sales Rep7 Customer48 $ 8,425 $ 2,885 Customer31 Location E 48 4/28/2020 Producto Region5 Sales Rep 14 | Customer445 9.711 1 s 6.701 Customer32 Location A 47 4/28/2020 Product 10 Region4 Sales Rep15 Customer57 $ 2,477 $ 1,115 Customer33 Location E 184/28/2020 Product Region Sales Rep12 Customer1001 $ 14,587 $ 7,138 Customer34 LocationF 49 4/28/2020 Product Region Sales Rep15 Customer83 $ 7,588 $ 5,083 Customer35 Location E 50 4/28/2020 Product Region4 Sales Rep Customer84 $ 4,679 $ 3,229 Customer38 Location A 51 4/28/2020 Product 10 Region Sales Rep9 Customer78 5 8 .790 s 3.692 Customer37 Locationc 52 4/28/2020 Products Region Sales Rep18 Customer98 $ 1,689 $ 885 Customer38 LocationF 53 4/28/2020 Producto Region Sales Rep18 Customer23 $ 3,957 | $ 2,770 Customer39 Location E 544/28/2020 Product Region Sales Rep17 Customer74 $ 13,490 $ 5,531 Customer40 Location 55 4/28/2020 Product 10 Region1 Sales Rep10 | Customer25 $ 2,191 $ 1,380 Customer41 Locationc 58 4/28/2020 Producto Region5 Sales Rept Customer57 $ 9,444 $ 5,688 Customer42 Location E 57 4/28/2020 Product Region Sales Rep14 Customer97 $ 8,280 $ 4,130 Customer43 LocationF seasessenlessssssssssssssssssssssssssss H I L M G 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 54 4/27/2020 55 4/27/2020 58 4/27/2020 57 4/27/2020 58 4/27/2020 59 4/27/2020 60 4/27/2020 61 4/27/2020 62 4/27/2020 63 4/27/2020 64 4/27/2020 65 4/27/2020 68 4/27/2020 67 4/27/2020 68 4/27/2020 69 4/27/2020 70 4/27/2020 71 4/27/2020 72 4/27/2020 73 4/27/2020 74 4/27/2020 75 4/27/2020 76 4/27/2020 77 4/27/2020 78 4/27/2020 79 4/27/2020 80 4/27/2020 81 4/27/2020 82 4/27/2020 83 4/27/2020 84 4/27/2020 85 4/27/2020 86 4/27/2020 87 4/27/2020 88 4/27/2020 89 4/27/2020 90 4/27/2020 91 4/27/2020 92 4/27/2020 93 4/27/2020 94 4/27/2020 95 4/27/2020 96 4/27/2020 97 4/27/2020 98 4/27/2020 99 4/27/2020 100 4/27/2020 101 4/27/2020 102 4/27/2020 103 4/27/2020 Product3 Product10 Producto Product Product1 Product 1 Product Product1 Product3 Product10 Products Product7 Products Product7 Product2 Products Product7 Producto Products Product10 Product 10 Product Product7 Product10 Product3 Producto Products Product7 Producto Product1 Product10 Products Product10 Products Product Product3 Product2 Products Producto Region 1 Region1 Region5 Region6 Region2 Region6 Region7 Region4 Region8 Region7 Region6 Region2 Region7 Region7 Region7 Region3 Region3 Region6 Region4 Region4 Region2 Region6 Region5 Region2 Region6 Region1 Region 3 Region1 Region4 Region8 Region2 Region8 Region1 Region5 Region3 Region5 Region4 Region7 Region7 Region1 Region6 Region4 Region2 Region8 Region6 Region3 Region4 Region8 Region7 Region4 SalesRep17 Customer74 S Sales Rep10 Customer25 S Sales Rep1 Customer57 S Sales Rep14 Customer97 $ Sales Rep6 | Customer95 $ Sales Rep11 Customer57 S Sales Rep12 Customer46 S Sales Rep11 | Customer24 $ Sales Rep16 Customer59 S Sales Rep13 Customer44 S Sales Rep13 Customer92S Sales Rep1 Customer85 $ Sales Rep12 Customer59 S Sales Rep16 | Customer58 $ Sales Rep3 Customer48S Sales Rep15 Customer7 | $ Sales Rep13 Customer 103S Sales Rep17 | Customer66S Sales Rep4 | Customer41 S Sales Rep7 Customer9 S Sales Rep12 Customer27S Sales Rep12 Customer86 S Sales Rep1 Customer94 S Sales Rep10 Customer4 S Sales Rep16 Customer57 S Sales Rep13 Customer33 $ Sales Rep 16 Customer35 S Sales Rep17 | Customer88 $ Sales Rep4 Customer 76 $ Sales Rep11 Customer 70 $ Sales Rep11 Customer30 $ Sales Rep4 Customer3S Sales Rep2 | Customer 11 S Sales Rep1 Customer96 S Sales Rep15 Customer72S Sales Rep9 Customer17 S Sales Rep3 | Customer73 $ Sales Rep10 Customer97 $ Sales Rep8 Customer19 $ Sales Rep16 Customer9 $ Sales Rep17 | Customer 75 $ Sales Rep. Customer43 $ Sales Rep13 Customer31 S Sales Rep15 Customer44 S Sales Rep13 Customer925 Sales Rep1 Customer87 $ Sales Reps Customer 48 $ Sales Rep1 Customer13 S Sales Rep7 | Customer85 S SalesRep15 Customer17 S F 13,490S 2,191 S 9,444S 8,260 S 4,348S 2,485 S 14,228 S 8,267 S 6,343S 9,381 S 11,364S 7,986 S 11,126S 10,766S 8,639S 4,992 $ 12,439S 4,128S 6,464 S 3,122 $ 2,180 S 12,241 $ 11,129S 9,302 $ 14,856 $ 3,598 S 11,876 S 11,821 $ 11,398S 2,615S 6,544 S 3,677 S 9,814S 13,823 S 6,575 S 11,895S 14 707 14,707 S 10,877 S 5,788 S 5,141 S 3,418 S 5,865 S 11,198S 6,068 S 9,873 $ 9,409S 2216 2,216S S 7,284S 14,973 S 13,535 S 6,232|| 10,102 2,447 6,888 4,374 3,761 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 5,175 1,086 4,192 8.834 5,955 Customer 40 Customer41 Customer42 Customer43 Customer44 | Customer45 Customer 46 Customer47 Customer48 Customer49 Customer 50 Customer51 Customer52 | Customer53 Customer54 Customer 55 Customer 56 Customer57 Customer58 Customer59 Customer60 | Customer61 Customer62 Customer63 Customer64 Customer65 Customer66 Customer67 Customer68 Customer69 Customer 70 Customer71 Customer72 Customer73 Customer 74 Customer75 Customer 76 Customer77 Customer78 Customer79 Customer80 Customer81 Customer82 Customer83 Customer84 Customer85 Customer86 Customer87 Customer88 Customer89 LocationE Locationc LocationE LocationF LocationB LocationA Location Location Locationc LocationB LocationE Locationc Locations Location LocationF Location LocationD LocationD LocationE LocationF LocationB LocationB LocationB Location Locationc LocationD LocationE LocationE LocationE LocationE LocationD LocationE LocationB LocationA LocationE LocationB Locationc LocationF LocationD LocationA Location A Location LocationC LocationD LocationC LocationA Location LocationB Locationc Location Product1 Product2 Product9 Products Product2 Product3 Product Product Product9 Product2 | | | | | | | 85 4/27/2020 86 4/27/2020 87 4/27/2020 88 4/27/2020 89 4/27/2020 90 4/27/2020 91 4/27/2020 92 4/27/2020 93 4/27/2020 94 4/27/2020 95 4/27/2020 98 4/27/2020 97 4/27/2020 98 4/27/2020 99 4/27/2020 100 4/27/2020 101 4/27/2020 102 4/27/2020 103 4/27/2020 104 4/27/2020 105 4/27/2020 106 4/27/2020 107 4/27/2020 108 4/27/2020 109 4/27/2020 110 4/27/2020 111 4/27/2020 112 4/27/2020 113 4/27/2020 114 4/27/2020 115 4/27/2020 116 4/27/2020 117 4/27/2020 118 4/27/2020 119 4/27/2020 120 4/27/2020 121 122 123 124 Products Product10 Products Product4 Product3 Product2 Products Producto Product4 Product1 Product2 Product9 Products Product2 Product3 Product1 Product4 Product9 Product2 Producto Product4 Products Products Product7 Products Product9 Product3 Product7 Product2 Products Products Product7 Product4 Product10 Product7 Product7 Region8 Region1 Region5 Region 3 Region5 Region4 Region7 Region7 Region1 Region6 Region4 Region2 Region8 Region6 Region3 Region4 Region8 Region7 Region4 Region4 Region7 Region5 Region4 Region 6 Region 3 Region2 Region4 Region1 Region8 Region4 Region 6 Region2 Region7 Region4 Region3 Region8 Sales Rep4 Customer3 $ Sales Rep2 | Customer11 S Sales Rep1 Customer96 S Sales Rep15 Customer72S Sales Rep9 Customer17 S Sales Rep3 | Customer73 $ Sales Rep10 Customer97 S Sales Rep8 | Customer19 S Sales Rep16 Customer9 S Sales Rep17 | Customer75 $ Sales Rep6 Customer43 S Sales Rep13 Customer31 S Sales Rep15 Customer44 $ Sales Rep13 Customer92 S Sales Rep1 Customer87 S Sales Reps Customer 48 $ Sales Rep1 Customer13 S Sales Rep7 | Customer85 $ Sales Rep15 | Customer17 S Sales Rep16 Customer59 S Sales Rep10 Customer38 S Sales Rep4 | Customer65S Sales Rep11 | Customer28 S Sales Rep. Customer58 S Sales Rep5 Customer58 $ Sales Rep7 | Customer99 $ Sales Rep10 Customer56 S Sales Reps Customer84 $ Sales Rep7 | Customer87 $ Sales Rep3 | Customer91S Sales Rep13 | Customer47S Sales Rep17 Customer77 S Sales Rep3 | Customer40 $ Sales Rep14 Customer81 $ Sales Rep1 Customer41 S Sales Rep15 Customer70S 3,677 $ 9,814 S 13,823 S 6,575 S 11,895 $ 14,707 S 10,877 S 5,788 S 5,141 $ 3,418 S 5,865 S 11,198 S 6068 S 9,873 S 9,409S 2,216 S 7,284 S 14,973S 13,535 S 5,753 S 1,781 $ 3,842 S 7,1875 7,643 S 6,451 S 5,405 S 13,179 S 6,199 S 2,742 2 742 5 S 3,338 S 13,609 S 8,812S 2,499 S 8,013 S ,777 $ 6,160 S tatutututututulatatututututolulululululululululululullah 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 5,175 1,086 4,192 8,834 5,955 3,394 730 1,959 2,228 4,586 2,451 2,378 5,799 3,223 932 932 1,369 7,621 | 5,199 1,499 3,846 3,408 3,018 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 Customer95 Customer96 Customer97 Customer98 Customer99 Customer 100 Customer 101 Customer 102 Customer103 Customer 104 Customer 105 Customer 106 LocationE Location LocationA Location LocationB Locationc LocationF Location Location A Location A LocationB Locationc Location Locationc LocationA Location A Location B Locationc LocationD LocationE LocationF Location Locationc LocationB Locationc LocationF Location Locationc LocationE LocationB LocationB LocationA LocationC Locationc LocationB LocationE | | | | 5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting Fundamentals Essentials Concepts And Examples

Authors: Steven M. Bragg

7th Edition

1642210846, 978-1642210842

More Books

Students also viewed these Accounting questions