Business Analytics II
WeeklySales
Weekly Sales Anlysis
44694
Total
Comissions
Golf Equipment
Clubs
576.67
309.6
214.02
349.16
450.5
450.95
552.35
Golf Balls
72.08
26.2
22.93
28.64
55.06
61.2
61.37
Accessories
152.18
-49.7
50.96
54.41
105.12
111.35
136.38
Clothing
Red Bluff Logo Wear
123.89
35.59
51.93
-62.8
114.04
106.42
141.64
Brand Name Logo Wear
213.6
64.82
77.89
114.38
157.64
208.9
253.97
Accessories
89.71
26.69
-32.46
47.1
63.73
78.83
92.8
Consumables
Drinks
40.2
32.78
29.16
31.18
23.48
73.18
109.36
Snack Food
25.7
22.78
29.44
22.58
17.71
44.85
64.23
Services
Green Fees
1650
660
577.5
866.25
1031.25
1402.5
2062.5
Golf Cart Rentals
440
176
154
231
275
374
550
Deposit Returns
-110
-44
-38.5
-57.75
-68.75
-93.5
-137.5
Golf Club Rentals
55
22
19.25
28.88
34.38
46.75
68.75
Deposit Returns
-11
-4.4
-3.85
-5.78
-6.88
-9.35
-13.75
Lessons
440
176
154
231
275
374
550
Golf Club Commission
0.15
Golf Ball & Acc. Comm.
0.1
Pro Shop Min. Commission
350
Golf Lessons Commission
0.7
Golf Lessons Min. Commission
1750
Golf Equipment Target
0.135
Clothing Target
0.115
Consumables Target
0.03
HourlySales-Sunday
Sales by Time of Day
5/13/22
Friday
Golf Equipment
Clothing
Consumables
Services
Time
Clubs
Golf Balls
Accessories
Red Bluff Logo Wear
Brand Name Logo Wear
Accessories
Drinks
Snack Food
Green Fees
Golf Cart Rentals
Deposit Returns
Golf Club Rentals
Deposit Returns
Lessons
0.375
34.98
75.00
20.00
100.00
0.3958333333
24.99
14.48
100.00
25.00
29.99
49.99
6.00
75.00
19.99
3.00
100.00
25.00
13.75
23.00
75.00
75.00
14.99
8.47
100.00
100.00
10.00
50.00
50.00
(7.50)
19.99
15.00
3.99
75.00
80.00
333.00
78.98
7.99
100.00
25.00
(7.50)
(3.00)
5.99
50.00
13.75
24.99
100.00
25.00
(15.00)
80.00
39.99
75.00
6.13
100.00
25.00
(7.50)
27.49
100.00
25.00
(7.50)
105.00
26.11
75.00
25.00
(3.00)
80.00
19.99
75.00
25.00
(7.50)
13.75
7.98
9.14
75.00
50.00
(7.50)
36.17
100.00
50.00
13.75
63.67
6.99
100.00
50.00
(7.50)
36.43
6.20
6.73
50.00
20.00
(7.50)
14.99
(15.00)
7.99
(15.00)
(3.00)
57.23
10.99
(15.00)
(3.00)
TOTAL
AVG. SALE
# OF SALES
MAX. SALE
MIN. SALE
HourlySales-Monday
Sales by Time of Day
5/13/22
Friday
Golf Equipment
Clothing
Consumables
Services
Time
Clubs
Golf Balls
Accessories
Red Bluff Logo Wear
Brand Name Logo Wear
Accessories
Drinks
Snack Food
Green Fees
Golf Cart Rentals
Deposit Returns
Golf Club Rentals
Deposit Returns
Lessons
9:00 AM
14.99
19.99
1.99
9:30 AM
7.98
10:00 AM
24.99
10:30 AM
25.00
20.00
11.00
11:00 AM
9.90
9.72
100.00
11:30 AM
3.00
12:00 PM
75.00
25.00
20.00
12:30 PM
9.99
5.00
6.99
50.00
1:00 PM
4.99
50.00
(5.00)
(2.20)
1:30 PM
25.00
20.00
2:00 PM
70.93
24.71
20.60
12.99
4.99
9.00
50.00
2:30 PM
6.00
50.00
20.00
(5.00)
3:00 PM
50.00
20.00
75.00
3:30 PM
1.78
50.00
4:00 PM
50.00
20.00
(5.00)
11.00
4:30 PM
9.99
9.99
50.00
5:00 PM
50.00
(5.00)
5:30 PM
8.32
50.00
20.00
(5.00)
6:00 PM
8.00
10.80
50.00
20.00
6:30 PM
25.00
20.00
(5.00)
(2.20)
7:00 PM
63.67
11.86
7:30 PM
(5.00)
8:00 PM
(10.00)
Documentation
Create Date
By Whom
Description
Workbook Name
5/12/18
Aleeta Herriott
Analysis of Pro Shop weekly sales
Excel_Ch02_Prepare_WeeklySales.xlsx
Mod. Date
By Whom
Mod. Description
Last Version Backup Name
: VERSION BACKUP NAME :
Before modifying any worksheet, save the original workbook with the following name format:
Original name_yyyymmdd
Create Date
Sheet Name
Creator
Purpose
5/12/18
WeeklySales
Aleeta Herriott
Examine Pro Shop sales by day and category
5/12/18
HourlySales-Sunday
Aleeta Herriott
Examine Sunday sales in 1/2 hour increments
5/12/18
Hourly ales-Monday
Aleeta Herriott
Examine Monday sales in 1/2 hour increments
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
