alzoabi_Excel_Ch06_Prepare_SalesAnalysis.xlsx
SalesData
| Pro Shop Sales Database |
|
|
|
|
|
|
|
|
|
|
|
| Filtered Records |
| TransID |
TransDate |
EMP-ID |
ItemID |
PaymentType |
Quantity |
GrossRevenue |
ClubMember? |
Coupon |
CashDisc |
NetRevenue |
TotalDiscounts |
| TransID |
TransDate |
EMP-ID |
ItemID |
PaymentType |
Quantity |
GrossRevenue |
ClubMember? |
Coupon |
CashDisc |
NetRevenue |
TotalDiscounts |
| P000100 |
10/3/25 |
EMP-00076 |
C884P23 |
Cash |
3 |
$ 171.00 |
No |
15% |
5% |
$ 136.80 |
$ 34.20 |
| P000101 |
10/3/25 |
EMP-00038 |
T822Z48 |
Cash |
2 |
$ 65.90 |
No |
|
| $ 65.90 |
$ - 0 |
| P000102 |
10/3/25 |
EMP-00024 |
F232P37 |
Apple Pay |
1 |
$ 129.00 |
Yes |
|
| $ 119.97 |
$ 9.03 |
| P000103 |
10/5/25 |
EMP-00015 |
C583K29 |
Apple Pay |
3 |
$ 177.00 |
No |
|
| $ 177.00 |
$ - 0 |
| P000104 |
10/6/25 |
EMP-00026 |
F232P37 |
Credit |
3 |
$ 387.00 |
No |
15% |
5% |
$ 309.60 |
$ 77.40 |
| P000105 |
10/12/25 |
EMP-00076 |
F375P67 |
Cash |
3 |
$ 46.35 |
Yes |
15% |
| $ 36.15 |
$ 10.20 |
| P000106 |
10/16/25 |
EMP-00038 |
X740Q29 |
Apple Pay |
1 |
$ 453.00 |
Yes |
|
| $ 421.29 |
$ 31.71 |
| P000107 |
10/22/25 |
EMP-00024 |
T981Q11 |
Credit |
1 |
$ 12.00 |
No |
|
| $ 12.00 |
$ - 0 |
| P000108 |
10/25/25 |
EMP-00015 |
C884P23 |
Cash |
2 |
$ 114.00 |
No |
| 5% |
$ 108.30 |
$ 5.70 |
| P000109 |
11/2/25 |
EMP-00026 |
X487P48 |
Credit |
3 |
$ 1,257.00 |
No |
10% |
| $ 1,131.30 |
$ 125.70 |
| P000110 |
11/7/25 |
EMP-00076 |
R483P24 |
Apple Pay |
1 |
$ 2.00 |
No |
10% |
| $ 1.80 |
$ 0.20 |
| P000111 |
11/10/25 |
EMP-00038 |
R483P24 |
Card |
1 |
$ 2.00 |
Yes |
15% |
| $ 1.56 |
$ 0.44 |
| P000112 |
11/13/25 |
EMP-00024 |
X349R39 |
Credit |
3 |
$ 149.85 |
No |
5% |
| $ 142.36 |
$ 7.49 |
| P000113 |
11/23/25 |
EMP-00015 |
F833K19 |
Apple Pay |
3 |
$ 17.85 |
No |
5% |
| $ 16.96 |
$ 0.89 |
| P000114 |
12/13/25 |
EMP-00026 |
R239T57 |
Card |
2 |
$ 194.00 |
No |
15% |
| $ 164.90 |
$ 29.10 |
| P000115 |
12/14/25 |
EMP-00076 |
C583K29 |
Card |
1 |
$ 59.00 |
No |
|
| $ 59.00 |
$ - 0 |
| P000116 |
12/16/25 |
EMP-00038 |
F375P67 |
Cash |
3 |
$ 46.35 |
No |
|
| $ 46.35 |
$ - 0 |
| P000117 |
12/18/25 |
EMP-00024 |
X487P48 |
Apple Pay |
2 |
$ 838.00 |
Yes |
|
| $ 779.34 |
$ 58.66 |
| P000118 |
12/24/25 |
EMP-00015 |
F833K19 |
Apple Pay |
4 |
$ 23.80 |
No |
|
| $ 23.80 |
$ - 0 |
| P000119 |
12/29/25 |
EMP-00026 |
F232P37 |
Card |
1 |
$ 129.00 |
Yes |
5% |
| $ 113.52 |
$ 15.48 |
| P000120 |
12/31/25 |
EMP-00076 |
X487P48 |
Apple Pay |
2 |
$ 838.00 |
No |
|
| $ 838.00 |
$ - 0 |
DatabaseTotals
| Field |
| Sum |
| Average |
| Count |
| Max |
| Min |
olaz
