Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

File 3: Sales Data Analyst You are the chief analyst that is responsible for monitoring sales at your company. The CEO has tasked you with

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
File 3: Sales Data Analyst You are the chief analyst that is responsible for monitoring sales at your company. The CEO has tasked you with providing the board of directors with some high-level insights regarding the sales trends of the company and its various locations. He has provided you with customer orders from various sales centers and other data that might be helpful in your analysis. He noted the following: The company sells five different items, each with its own selling price. Customer loyalty is important. Customers with a code of 2 receive a 2% discount of the total price, code 3 customers receive a 4% discount, and code 4 customers receive a 6% discount. The company charges a flat shipping fee based on the shipping mode selected: Standard Class - $0 (free), First Class - $100, Second Class - $50, Same Day - $150. Note that the shipping fee is NOT revenue for the company. It is what is being charged by the carrier. As such, the fee should NOT be incorporated into revenue, discount, and net sale calculations. . Font o Requirements: 1. Create 4 descriptives that provide insights into the profitability of the venture. Each of the following variables MUST show up in at least once: Order Date (feel free to analyze by month) Region Product Quantity Revenue (Price) Discounts Net Sales (Revenue - Discounts) 2. A descriptive that answers the following: Are customers who paid for quicker shipping getting their orders processed quicker? O o AutoSave OFF OA AGA Home Insert Draw Page Layout Formulas Data Review View TE X Calibri (Body) 11 == 4 V - A OLA Paste A = Ini DO HI EM E2 + x fx 2 tttt WSPOTZDEVE Y IZACE 1/72 E C D 1 Order ID Customer Code Order Date Ship Date Shipping Mode Region Code Quantity purchased 2 CA-2021-04574 1/1/21 1/4/21 2 24 3 CA-202104575 4 1/1/21 1/1/21 a central 21 CA-2021-04570 1 1/1/21 1/1/21 Central 15 $ CA 202104577 2 1/1/21 1/2/21 4 Central 12 6 A 2021-64570 5 1/1/21 4 East C 3 CA-2025-04579 1 1/11 1/4/21 3 South 14 A 2011-04580 6 1/1/21 1/1/21 South 19 5 CA-2021-00001 3 1221 1/3/21 4 East C 10 CA 2021-00002 19 1 12:21 1/5/23 2 E 16 11 CA 2021-04581 2 1/2/23 W/M 4 East c 1 CA-2021-04582 17 1 1/2/21 1/6/21 1 East E 2 1/2/21 1/4721 3 Et 14. CA 2021-04534 30 1/2/21 1/4/21 1 CA-2001 1 Last 1 19 1/2/21 1/4/21 15 A 2021-04586 1 10 3 1/22 11 CA-201104587 Increase indent 19 127 1/2 CA 2016 4 tas 1 12/21 10 1 CA-2011-04549 1/5/23 1 East D 3 1/2:21 15 2 CA-2021-04590 13 21 CA 19104553 1/5/21 4 1/22 1/421 11 22 A-2001-0452 1 w 1/2:21 C 22 CA 2021-04543 1/5/21 2 West D 2 1/2/21 36 - 1/1/23 15 1 Wit 2 15 CA 2021-0489S 12/21 1/3/26 4 West 3 1/2/21 26 CA 200104596 1/7/20 1 West 2 21 2011- 12/21 1/07 2 Wet D 2 25 A-045 1/21 2 WC 21 1 1/21 19 C-1000 1/1/21 3 Wet 25 D. 30 42011-00004 1923 1 West 1 11 A 0000 1/3 1923 1 1/2/ A 1/4/ 2 12/21 4 W 1/2 1/11 1/6/23 1 1/2 3 we D 3 2 W 10 1/23 D 16 A 2010 122 2 We W 10 1 A 2 19 1/1/ CA 1 1 - 1 we 20 w 17/ 104 Sove 23 1/6/21 101 wa Potos 1/5/21 D CA2010 1 11 1921 CA w Der 25 AL 1/ 2 West + 15 47 A 0010 AI 0610 WARI 2 We 1 1 West 24 23 1/41 15 ET ME TT 2000-LET 10000 TE TUT ET VOLVO EL th 2 UT TWT FE TRE TA E 1 1/23 ENE SE 10 SC LEAR OTIVAS TU 10 We Purchase Listing TER 24 2 . Sraig Discount 20 AutoSave OFF ayCBD Home Insert Draw Page Layout Formulas Data Review View Tel Calibri (Body) 11 ' III 2. W Paste B 1 U a. Av 2012 Mel E2 x fx 2 B 0 1 G H 20 1/272 1/5/21 1/7/21 1/4/21 17 1/6/23 2 1 3 1 3 2 1 2 3 4 2 3 2 2 3 3 C 1/4721 1/4/21 1/4/21 1/4/21 1/4/21 1/4/21 1/4/21 1/4/21 1/4/21 1/5/21 1/5/21 1/5/21 1/5/21 1/5/21 1/5/21 1/5/21 1/5/21 1/5/21 1/5/21 1/6/21 1/6/21 1/621 1/6/21 1/4/21 1/7/21 1/7/23 1/7/20 1/10/21 1/6/21 1/7/21 1/8/21 OC 12/23 GEOB386863EUWEN 1/7/23 "512021-00013 52 CA 2021-00014 53 CA 2021-00015 54 A 2021-04611 55 A 2021-04612 56 CA 2021-04613 57 CA 2021-04514 58 CA-2021-04635 59 CA 2021-04616 GOCA 2021-0001 61 CA 2021-00017 62 CA 3021-00015 6 CA 2021-00019 54 C1-2021-04617 65 CA 2001-04618 56 CA 2021-04519 ST CA 2001-0050 2021-0451 CA 202104622 90 CA 20210000 71 CA 2021-00021 73 2003-00022 21 A-2021-00023 76 A-2021-00024 75 CM-2001- 76 CA 2001-0002 73 CA 2001-00027 7 A 2021-0062 7 A 2021-0423 0 A-3020-062 BL CA 2021-00 A 2021-00030 SA 2001-00033 CA2021-000 55 A 2021-000 2015 SA 2001-000 CA 2016 2010006 SO 2013 E 16 Increase indent 2 2 1/6/21 1/6/21 1/6/21 1/7/23 1/1/21 1/1/21 East E D 2 South & South D 2 West D 4 west 3 1 CD 2 Central 1 Central 1 East E South D South E 3 South E 2 Et E 1 East 2 East D 4 Central 4 G C 3G D 1 South E 2 GB 2 South Sot D 4 South E SU South D 1 South 2 . & West we CE West 5 so D 1 W D E E E TUISE 3 2 3 1 1 1 2 2 2 2 2 1 1 1 1 1621 1/6/21 1/6/21 1/6/21 1/6/21 1/6/21 1/4/23 1/23 1/7/21 1/7/21 1/6/21 1/10/21 1/1/21 1/621 17/2 25 21 14 20 15 20 10 14 /1 It 1 WT 1/7/21 1/21 1/9/21 E W/23 1/9/21 0-16 1/72 1/7/21 1/7/21 1/1/21 1/7/21 12 1/8/21 1/8/21 1/12 121 1am 123 1/1/21 1/21 1/1/21 1/8/21 4 2 2 4 1 4 17 25 22 24 12 14 12 92 426 91 2001-02 1/11/21 1/3 TELE ST 21 1 S Sot 1 W 1 3 GA 1 ' 15 25 TE 021- 31.00 1. 700.000 COD 100 Con-000 Sales Data 1 1 ws GE ALE // 10 1/12 1/ 22 22 13 DI w Purchase Listing D Shipping into 12 14 23 Discount + AutoSave OFF 2 Home Insert Draw Page Layout Formulas Data Review View Tell LL Calibri (Body) 11 ' Wrap Paste B IU v v A Merge E2 x fx 2 B E G 22 10 21 + 18 13 21 Increase indent 2 4 3 1 3 1 4 2 4 3 3 4 2 1 2 2 1 3 4 4 4 1 2 3 2 3 4 1 4 3 1 2 3 2 2 2 3 101 CA 2021-00042 102 CA-2022-00043 103 CA 2021-04632 104 CA 2021-04533 105 CA 2021-04634 105 CA-2021-04635 107 CA 2021-04636 108 CA 2021-00044 109 CA-2023-30045 110CA-2021-00046 111 CA-2021-00047 112 CA 2021-00048 113 CA 2021-0427 114 CA 2021-04638 115 CA 2021-00049 116. CA-2021-00050 117 CA-2021-00051 118 CA-2021-00053 119 CA-2001-0003 120 CA-2023-0459 121 A 2021-04540 1221CA2022-04541 123 CA. 2021-04543 124 CA 2021-043 125 CA 2021-04644 126 CA-2023-00044 12 CA-2021-00055 13 CA 2021-0005 125 2021-00051 110 CA 2021-00058 131 A 2001-000 2021-00060 1 2001-0006 021-0002 135 2001-0063 150064 W 2001- 2001 O 1. CA 2001 10 C1- 11 - 1 CA- CZ CA 21045 1 2010 12001 14.000 CAN 2001- 2016 11 - Sales Data Ready Central E 2 East D 2 South B 2 South c 3 South E 3 South 2 Guntral A 1 South A 2 South D 1 Central 4 Central 1 Central D 1 East A 1 East D 1 East D 1 East B 1 East 4 East 0 1 East 1 East E 4 E E 1 East D 2 East E 4 East 2 South 2 East 2 E 1 Central 3 Cart C Central 4 South C 1 South C 4 South D South D South C 1 l 4 East C D 1/9/21 1/10/21 1/9/21 1/11/21 1/9/21 1/12/21 1/9/21 1/10/21 1/9/21 1/12/21 1/9/21 1/12/21 1/9/21 1/11/21 1/10/21 1/13/21 1/10/21 1/11/21 1/10/21 1/12/21 1/10/21 1/11/21 1/10/21 1/15/21 1/10/21 1/12/21 1/10/21 1/13/21 1/11/21 1/14/21 1/11/22 1/15/21 1/11/21 1/14/21 1/11/21 1/12/21 1/11/21 1/11/21 1/12/21 1/14/21 1/12/21 1/16/21 1/12/21 1/22/21 1/12/21 1/14/21 1/12/21 1/15/21 1/12/21 1/13/21 1/11/21 1/14/21 /13/21 1/15/21 1/11/21 1/16/21 1/13/21 1/15/21 1/11/21 1/14/21 1/11/21 1/14/21 1/13/21 1/13/21 1/13/21 1/10/23 1/11/21 1/12 11 1/10/23 1/30/22 1/15/21 1/1972 1/17/21 1/13/1 1/15/21 2 1/11 1/1772 3 1/12 1/17/21 3 1/2/21 1/1631 2 1/21 4 1/13/21 1/14/21 1/11 1/15/ 1/ 1/15/21 1/14 2 W17 1/14/21 4 1/14 1/11/21 1 w 1/ 14 WW 10m Purchase Listing REARNSHARANORARARAABERSE: 19 24 13 30 11 15 20 1 ml 0 1 S 2 10 20 wet 12 4 0 5 14 D 2W w 34 25 10 1 W Shipping Info A C Discount TS + AutoSave OFF y Home Insert Draw Page Layout Formulas Data Review View Tell me | Calibri (Body) 11 ' !!! I Wrap Text Paste BIU a. Av IMI IM Merge & Cen E2 x fx 2 B E G + 151 CA 2021-04655 152 CA-2021-00068 151 CA-2021-00069 154 CA-2021-00070 155 CA-2021-00071 196 CA 2021-00072 157 CA 2021-0003 1 CA 2021-00074 159 CA 2021-00075 10 A 2021-00076 161 CA-2091-04557 152 CA 2021-6465 163 A-2021-04659 164 CA 2001-04660 165 A-2021-04561 106 1021-02 109 CA-3023-0456 110010 10 CA 2021-665 170 A 2021-04566 171 CA 2021-04667 1 A 2021-04 2021 114 A 2021-04570 11 CA TICH 1 2011-04672 177 2021-04571 176 2021-04576 179 2021-00072 1 2001-0001 101 31-000 2001-2008 021-000 - 2 1/14/21 1 1/15/21 2 1/15/21 3 1/15/21 1 1/15/21 2 1/15/21 3 1/15/21 4 1/15/21 2 1/15/21 1 1/15/21 2 1/15/21 3 1/15/21 3 1/15/21 4 1/15/21 2 1/15/21 2 1/15/21 1/15/21 3 1/15/21 3 1/15/21 2 1/15/21 1/15/21 1 1/15/21 4 1/15/21 4 1/15/23 > 1/15/23 3 1/15/21 2 1/15/21 1/15/21 1/1/21 4 1/1721 4 1/16/21 1 1/11/21 1 1/16/21 2 1/16/21 4 1/11 1 1/10 3 V121 4 4 11/21 4 1/17 1 4 1/16/21 3 1/17 3 1/21 3 D 1/17/21 1/16/21 1/16/21 1/17/21 1/17/21 1/18/21 1/15/21 1/18/21 1/18/21 1/17/21 1/18/21 1/18/21 1/11/21 1/15/21 1/17/21 1/17/21 1/20/21 1/16/21 1/18/21 1/19/21 1/18/21 1/18/21 1/17/21 1/15/21 1/17/21 1/15/21 1/20/21 1/12 1/11/21 1/17/21 1/16/21 1/19/21 1/15/21 1/11/21 1/11/21 1 West C 4 South D 3 East C East B 2 East D 3 East A 4 East 2 Last E 2 East D 1 East B 3 West C 2 West 3 West E 4 West 3 West D 1 West B 1 West D 4 West D 1 South 1 South 3 South E 2 South D 3 South D 4 South C 2 South E 4 Cal 1 Central 2 Catral 4 East D 4 Et 4 st 0 1 Cast & Co 4D 2 Et 4 1 East BE West 0 & West D 3 we 1 W 0 1 S -2 3 D 0 H 16 11 24 24 25 18 22 25 14 17 17 13 11 19 20 Increase Indent 11 15 19 16 18 18 19 18 15 14 15 14 24 19 12 13 19 24 15 22 23 21 16 14 19 12 24 13 12 11 10 14 24 15 CA-ADS 17 A 2021-04 AT 11 2011 ITAL 111001000 2001- 2 w12 V1 1/17/ 1/19/21 1/10/23 1/3 1123 1/2012 1 11- 1 3 1 1 1/3 12/11 1/10 wum 1/11 1/10/23 w with Purchase Listing 1 > West Sales Date Hea GA Shipping into Discount 12 + File 3: Sales Data Analyst You are the chief analyst that is responsible for monitoring sales at your company. The CEO has tasked you with providing the board of directors with some high-level insights regarding the sales trends of the company and its various locations. He has provided you with customer orders from various sales centers and other data that might be helpful in your analysis. He noted the following: The company sells five different items, each with its own selling price. Customer loyalty is important. Customers with a code of 2 receive a 2% discount of the total price, code 3 customers receive a 4% discount, and code 4 customers receive a 6% discount. The company charges a flat shipping fee based on the shipping mode selected: Standard Class - $0 (free), First Class - $100, Second Class - $50, Same Day - $150. Note that the shipping fee is NOT revenue for the company. It is what is being charged by the carrier. As such, the fee should NOT be incorporated into revenue, discount, and net sale calculations. . Font o Requirements: 1. Create 4 descriptives that provide insights into the profitability of the venture. Each of the following variables MUST show up in at least once: Order Date (feel free to analyze by month) Region Product Quantity Revenue (Price) Discounts Net Sales (Revenue - Discounts) 2. A descriptive that answers the following: Are customers who paid for quicker shipping getting their orders processed quicker? O o AutoSave OFF OA AGA Home Insert Draw Page Layout Formulas Data Review View TE X Calibri (Body) 11 == 4 V - A OLA Paste A = Ini DO HI EM E2 + x fx 2 tttt WSPOTZDEVE Y IZACE 1/72 E C D 1 Order ID Customer Code Order Date Ship Date Shipping Mode Region Code Quantity purchased 2 CA-2021-04574 1/1/21 1/4/21 2 24 3 CA-202104575 4 1/1/21 1/1/21 a central 21 CA-2021-04570 1 1/1/21 1/1/21 Central 15 $ CA 202104577 2 1/1/21 1/2/21 4 Central 12 6 A 2021-64570 5 1/1/21 4 East C 3 CA-2025-04579 1 1/11 1/4/21 3 South 14 A 2011-04580 6 1/1/21 1/1/21 South 19 5 CA-2021-00001 3 1221 1/3/21 4 East C 10 CA 2021-00002 19 1 12:21 1/5/23 2 E 16 11 CA 2021-04581 2 1/2/23 W/M 4 East c 1 CA-2021-04582 17 1 1/2/21 1/6/21 1 East E 2 1/2/21 1/4721 3 Et 14. CA 2021-04534 30 1/2/21 1/4/21 1 CA-2001 1 Last 1 19 1/2/21 1/4/21 15 A 2021-04586 1 10 3 1/22 11 CA-201104587 Increase indent 19 127 1/2 CA 2016 4 tas 1 12/21 10 1 CA-2011-04549 1/5/23 1 East D 3 1/2:21 15 2 CA-2021-04590 13 21 CA 19104553 1/5/21 4 1/22 1/421 11 22 A-2001-0452 1 w 1/2:21 C 22 CA 2021-04543 1/5/21 2 West D 2 1/2/21 36 - 1/1/23 15 1 Wit 2 15 CA 2021-0489S 12/21 1/3/26 4 West 3 1/2/21 26 CA 200104596 1/7/20 1 West 2 21 2011- 12/21 1/07 2 Wet D 2 25 A-045 1/21 2 WC 21 1 1/21 19 C-1000 1/1/21 3 Wet 25 D. 30 42011-00004 1923 1 West 1 11 A 0000 1/3 1923 1 1/2/ A 1/4/ 2 12/21 4 W 1/2 1/11 1/6/23 1 1/2 3 we D 3 2 W 10 1/23 D 16 A 2010 122 2 We W 10 1 A 2 19 1/1/ CA 1 1 - 1 we 20 w 17/ 104 Sove 23 1/6/21 101 wa Potos 1/5/21 D CA2010 1 11 1921 CA w Der 25 AL 1/ 2 West + 15 47 A 0010 AI 0610 WARI 2 We 1 1 West 24 23 1/41 15 ET ME TT 2000-LET 10000 TE TUT ET VOLVO EL th 2 UT TWT FE TRE TA E 1 1/23 ENE SE 10 SC LEAR OTIVAS TU 10 We Purchase Listing TER 24 2 . Sraig Discount 20 AutoSave OFF ayCBD Home Insert Draw Page Layout Formulas Data Review View Tel Calibri (Body) 11 ' III 2. W Paste B 1 U a. Av 2012 Mel E2 x fx 2 B 0 1 G H 20 1/272 1/5/21 1/7/21 1/4/21 17 1/6/23 2 1 3 1 3 2 1 2 3 4 2 3 2 2 3 3 C 1/4721 1/4/21 1/4/21 1/4/21 1/4/21 1/4/21 1/4/21 1/4/21 1/4/21 1/5/21 1/5/21 1/5/21 1/5/21 1/5/21 1/5/21 1/5/21 1/5/21 1/5/21 1/5/21 1/6/21 1/6/21 1/621 1/6/21 1/4/21 1/7/21 1/7/23 1/7/20 1/10/21 1/6/21 1/7/21 1/8/21 OC 12/23 GEOB386863EUWEN 1/7/23 "512021-00013 52 CA 2021-00014 53 CA 2021-00015 54 A 2021-04611 55 A 2021-04612 56 CA 2021-04613 57 CA 2021-04514 58 CA-2021-04635 59 CA 2021-04616 GOCA 2021-0001 61 CA 2021-00017 62 CA 3021-00015 6 CA 2021-00019 54 C1-2021-04617 65 CA 2001-04618 56 CA 2021-04519 ST CA 2001-0050 2021-0451 CA 202104622 90 CA 20210000 71 CA 2021-00021 73 2003-00022 21 A-2021-00023 76 A-2021-00024 75 CM-2001- 76 CA 2001-0002 73 CA 2001-00027 7 A 2021-0062 7 A 2021-0423 0 A-3020-062 BL CA 2021-00 A 2021-00030 SA 2001-00033 CA2021-000 55 A 2021-000 2015 SA 2001-000 CA 2016 2010006 SO 2013 E 16 Increase indent 2 2 1/6/21 1/6/21 1/6/21 1/7/23 1/1/21 1/1/21 East E D 2 South & South D 2 West D 4 west 3 1 CD 2 Central 1 Central 1 East E South D South E 3 South E 2 Et E 1 East 2 East D 4 Central 4 G C 3G D 1 South E 2 GB 2 South Sot D 4 South E SU South D 1 South 2 . & West we CE West 5 so D 1 W D E E E TUISE 3 2 3 1 1 1 2 2 2 2 2 1 1 1 1 1621 1/6/21 1/6/21 1/6/21 1/6/21 1/6/21 1/4/23 1/23 1/7/21 1/7/21 1/6/21 1/10/21 1/1/21 1/621 17/2 25 21 14 20 15 20 10 14 /1 It 1 WT 1/7/21 1/21 1/9/21 E W/23 1/9/21 0-16 1/72 1/7/21 1/7/21 1/1/21 1/7/21 12 1/8/21 1/8/21 1/12 121 1am 123 1/1/21 1/21 1/1/21 1/8/21 4 2 2 4 1 4 17 25 22 24 12 14 12 92 426 91 2001-02 1/11/21 1/3 TELE ST 21 1 S Sot 1 W 1 3 GA 1 ' 15 25 TE 021- 31.00 1. 700.000 COD 100 Con-000 Sales Data 1 1 ws GE ALE // 10 1/12 1/ 22 22 13 DI w Purchase Listing D Shipping into 12 14 23 Discount + AutoSave OFF 2 Home Insert Draw Page Layout Formulas Data Review View Tell LL Calibri (Body) 11 ' Wrap Paste B IU v v A Merge E2 x fx 2 B E G 22 10 21 + 18 13 21 Increase indent 2 4 3 1 3 1 4 2 4 3 3 4 2 1 2 2 1 3 4 4 4 1 2 3 2 3 4 1 4 3 1 2 3 2 2 2 3 101 CA 2021-00042 102 CA-2022-00043 103 CA 2021-04632 104 CA 2021-04533 105 CA 2021-04634 105 CA-2021-04635 107 CA 2021-04636 108 CA 2021-00044 109 CA-2023-30045 110CA-2021-00046 111 CA-2021-00047 112 CA 2021-00048 113 CA 2021-0427 114 CA 2021-04638 115 CA 2021-00049 116. CA-2021-00050 117 CA-2021-00051 118 CA-2021-00053 119 CA-2001-0003 120 CA-2023-0459 121 A 2021-04540 1221CA2022-04541 123 CA. 2021-04543 124 CA 2021-043 125 CA 2021-04644 126 CA-2023-00044 12 CA-2021-00055 13 CA 2021-0005 125 2021-00051 110 CA 2021-00058 131 A 2001-000 2021-00060 1 2001-0006 021-0002 135 2001-0063 150064 W 2001- 2001 O 1. CA 2001 10 C1- 11 - 1 CA- CZ CA 21045 1 2010 12001 14.000 CAN 2001- 2016 11 - Sales Data Ready Central E 2 East D 2 South B 2 South c 3 South E 3 South 2 Guntral A 1 South A 2 South D 1 Central 4 Central 1 Central D 1 East A 1 East D 1 East D 1 East B 1 East 4 East 0 1 East 1 East E 4 E E 1 East D 2 East E 4 East 2 South 2 East 2 E 1 Central 3 Cart C Central 4 South C 1 South C 4 South D South D South C 1 l 4 East C D 1/9/21 1/10/21 1/9/21 1/11/21 1/9/21 1/12/21 1/9/21 1/10/21 1/9/21 1/12/21 1/9/21 1/12/21 1/9/21 1/11/21 1/10/21 1/13/21 1/10/21 1/11/21 1/10/21 1/12/21 1/10/21 1/11/21 1/10/21 1/15/21 1/10/21 1/12/21 1/10/21 1/13/21 1/11/21 1/14/21 1/11/22 1/15/21 1/11/21 1/14/21 1/11/21 1/12/21 1/11/21 1/11/21 1/12/21 1/14/21 1/12/21 1/16/21 1/12/21 1/22/21 1/12/21 1/14/21 1/12/21 1/15/21 1/12/21 1/13/21 1/11/21 1/14/21 /13/21 1/15/21 1/11/21 1/16/21 1/13/21 1/15/21 1/11/21 1/14/21 1/11/21 1/14/21 1/13/21 1/13/21 1/13/21 1/10/23 1/11/21 1/12 11 1/10/23 1/30/22 1/15/21 1/1972 1/17/21 1/13/1 1/15/21 2 1/11 1/1772 3 1/12 1/17/21 3 1/2/21 1/1631 2 1/21 4 1/13/21 1/14/21 1/11 1/15/ 1/ 1/15/21 1/14 2 W17 1/14/21 4 1/14 1/11/21 1 w 1/ 14 WW 10m Purchase Listing REARNSHARANORARARAABERSE: 19 24 13 30 11 15 20 1 ml 0 1 S 2 10 20 wet 12 4 0 5 14 D 2W w 34 25 10 1 W Shipping Info A C Discount TS + AutoSave OFF y Home Insert Draw Page Layout Formulas Data Review View Tell me | Calibri (Body) 11 ' !!! I Wrap Text Paste BIU a. Av IMI IM Merge & Cen E2 x fx 2 B E G + 151 CA 2021-04655 152 CA-2021-00068 151 CA-2021-00069 154 CA-2021-00070 155 CA-2021-00071 196 CA 2021-00072 157 CA 2021-0003 1 CA 2021-00074 159 CA 2021-00075 10 A 2021-00076 161 CA-2091-04557 152 CA 2021-6465 163 A-2021-04659 164 CA 2001-04660 165 A-2021-04561 106 1021-02 109 CA-3023-0456 110010 10 CA 2021-665 170 A 2021-04566 171 CA 2021-04667 1 A 2021-04 2021 114 A 2021-04570 11 CA TICH 1 2011-04672 177 2021-04571 176 2021-04576 179 2021-00072 1 2001-0001 101 31-000 2001-2008 021-000 - 2 1/14/21 1 1/15/21 2 1/15/21 3 1/15/21 1 1/15/21 2 1/15/21 3 1/15/21 4 1/15/21 2 1/15/21 1 1/15/21 2 1/15/21 3 1/15/21 3 1/15/21 4 1/15/21 2 1/15/21 2 1/15/21 1/15/21 3 1/15/21 3 1/15/21 2 1/15/21 1/15/21 1 1/15/21 4 1/15/21 4 1/15/23 > 1/15/23 3 1/15/21 2 1/15/21 1/15/21 1/1/21 4 1/1721 4 1/16/21 1 1/11/21 1 1/16/21 2 1/16/21 4 1/11 1 1/10 3 V121 4 4 11/21 4 1/17 1 4 1/16/21 3 1/17 3 1/21 3 D 1/17/21 1/16/21 1/16/21 1/17/21 1/17/21 1/18/21 1/15/21 1/18/21 1/18/21 1/17/21 1/18/21 1/18/21 1/11/21 1/15/21 1/17/21 1/17/21 1/20/21 1/16/21 1/18/21 1/19/21 1/18/21 1/18/21 1/17/21 1/15/21 1/17/21 1/15/21 1/20/21 1/12 1/11/21 1/17/21 1/16/21 1/19/21 1/15/21 1/11/21 1/11/21 1 West C 4 South D 3 East C East B 2 East D 3 East A 4 East 2 Last E 2 East D 1 East B 3 West C 2 West 3 West E 4 West 3 West D 1 West B 1 West D 4 West D 1 South 1 South 3 South E 2 South D 3 South D 4 South C 2 South E 4 Cal 1 Central 2 Catral 4 East D 4 Et 4 st 0 1 Cast & Co 4D 2 Et 4 1 East BE West 0 & West D 3 we 1 W 0 1 S -2 3 D 0 H 16 11 24 24 25 18 22 25 14 17 17 13 11 19 20 Increase Indent 11 15 19 16 18 18 19 18 15 14 15 14 24 19 12 13 19 24 15 22 23 21 16 14 19 12 24 13 12 11 10 14 24 15 CA-ADS 17 A 2021-04 AT 11 2011 ITAL 111001000 2001- 2 w12 V1 1/17/ 1/19/21 1/10/23 1/3 1123 1/2012 1 11- 1 3 1 1 1/3 12/11 1/10 wum 1/11 1/10/23 w with Purchase Listing 1 > West Sales Date Hea GA Shipping into Discount 12 +

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

Auditing and Assurance services an integrated approach

Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley

15th edition

978-0133125634, 9780133423815, 133125637, 133423816, 978-0133125689

More Books

Students also viewed these Accounting questions

Question

What are the outcomes the client wants?

Answered: 1 week ago

Question

What has been done before?

Answered: 1 week ago