Business Analytics II
abparsley
Parsley_Excel_Ch02_Prepare_WeeklySales.xlsxWeeklySales
| 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 |
