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