QUESTION 5

User Generated

ZnexGbc1999

Business Finance

acc

UCI

Description

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...

Similar Content

Related Tags