Description

Explanation & Answer

Attached.
Sales Order
Quantity
Product
ID
Date
Sold
Description
20001
11/1/2019
10 Pale Ale
20005
11/1/2019
8 Pale Ale
20017
11/7/2019
1 Pale Ale
20080
11/29/2019
11 Pale Ale
20140
12/20/2019
5 Pale Ale
20183
1/1/2020
7 Pale Ale
20223
1/13/2020
1 Pale Ale
20224
1/13/2020
1 Pale Ale
20227
1/14/2020
2 Pale Ale
20229
1/14/2020
9 Pale Ale
20280
1/30/2020
7 Pale Ale
20305
2/10/2020
4 Pale Ale
20378
3/3/2020
7 Pale Ale
20379
3/3/2020
12 Pale Ale
20440
3/19/2020
3 Pale Ale
20457
3/26/2020
10 Pale Ale
20513
4/13/2020
10 Pale Ale
20518
4/14/2020
8 Pale Ale
Price
per
Unit Location
95 KS
95 TN
95 TX
95 OK
95 TX
95 NE
95 MO
95 TX
95 OK
95 TX
95 AR
95 OK
95 AR
95 MO
95 TX
95 TX
95 OK
95 IA
Total
Sales
950
760
95
1045
475
665
95
95
190
855
665
380
665
1140
285
950
950
760
Total Price
Including
Sales Tax
1011.75
813.2
100.94
1092.03
504.69
701.58
99.01
100.94
198.55
908.44
708.23
397.1
708.23
1188.17
302.81
1009.38
992.75
805.6
20013
11/4/2019
4 Imperial IPA
120 OK
480
501.6
20031
11/12/2019
4 Imperial IPA
120 MO
480
500.28
20090
12/1/2019
10 Imperial IPA
120 TN
1200
1284
20093
12/2/2019
1 Imperial IPA
120 KS
120
127.8
20183
1/1/2020
10 Imperial IPA
120 NE
1200
1266
20230
1/15/2020
6 Imperial IPA
120 MO
720
750.42
20282
1/31/2020
7 Imperial IPA
120 OK
840
877.8
20451
3/24/2020
2 Imperial IPA
120 NE
240
253.2
20516
4/13/2020
11 Imperial IPA
120 TX
1320
1402.5
20564
20013
20020
20033
20040
20056
20063
4/28/2020
11/4/2019
11/7/2019
11/12/2019
11/14/2019
11/21/2019
11/22/2019
6 Imperial IPA
2 IPA
6 IPA
1 IPA
2 IPA
8 IPA
4 IPA
120 IA
100 OK
100 TX
100 MO
100 NE
100 OK
100 NE
720
200
600
100
200
800
400
763.2
209
637.5
104.23
211
836
422
20097
20098
20103
20137
2015...
