Business Analytics
abparsley
Parsley_Excel_Ch01_Prepare_GolfCartAnalysis1.xlsxDocumentation
| Create Date | By Whom | Description | Workbook Name |
| 5/15/22 | Barry Cheney | Analyze the replacement of the Red Bluff Golf Course fleet of golf carts | e01ch01_PermLog_kaj-1_DE_to_AU_042218.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/15/22 | GolfCartPurchases | Barry Cheney | Compare price, financing terms, payments, and total cost of golf carts under consideration |
| 5/15/22 | MayUsage | Barry Cheney | Golf cart usage analysis |
| 5/15/22 | MowerPurchase | Barry Cheney | Fairway mower purchase analysis |
GolfCartPurchases
| Option 1 | Option 2 | Option 3 | Option 4 | ||
| Golf Cart Brand: | |||||
| Model: | TRZ | ||||
| Retail Price: | 8,137 | 8,195 | 7,135 | ||
| Purchase Price: | 6,495 | 6,515 | 5,995 | 6,495 | |
| Loan Annual Interest Rate: | 0.060 | 0.070 | 0.060 | 0.060 | |
| Number of Payments: | 48 | 48 | 48 | 48 | |
| Monthly Payment: | 152.54 | 156.01 | 140.79 | 152.54 | |
| Total Purchase Cost: | 7,321.69 | 7,488.47 | 6,758.05 | 7,321.69 | |
| 826.69 | 973.47 | 763.05 | 826.69 | ||
MayUsage
| Analysis of Cart Usage | ||||
| $ 25.00 | Cost of Cart Rental | |||
| 3 | Maximum # of times per day a cart may be used | |||
| May Cart Usage | ||||
| Day | # Available jkinser: # Available rentals: Each cart can be rented up to 3 times per day. This is the maximum number of rentals for the day. Some days carts are out of service for repair. | Demand jkinser: Demand: The number of carts that were requested for rental that day. If all carts were out, then the demand is higher than the # of available rentals. | $ Demand Not Met jkinser: $ Demand Not Met: If demand was greater than the number available, the resort turned away customers. This is the revenue amount that the resort could have made if customers had not been turned away. | $ Demand Not Used jkinser: $ Demand Not Used: If demand was less than the number available, the resort has excess carts not being used. This is the revenue amount that the resort could have made if customers had demanded the cart. |
| 5/1/22 | 30 | 60 | $ 750.00 | $ - 0 |
| 5/2/22 | 30 | 43 | $ 325.00 | $ - 0 |
| 5/3/22 | 27 | 41 | $ 350.00 | $ - 0 |
| 5/4/22 | 30 | 32 | $ 50.00 | $ - 0 |
| 5/5/22 | 24 | 48 | $ 600.00 | $ - 0 |
| 5/6/22 | 30 | 40 | $ 250.00 | $ - 0 |
| 5/7/22 | 30 | 31 | $ 25.00 | $ - 0 |
| 5/8/22 | 30 | 44 | $ 350.00 | $ - 0 |
| 5/9/22 | 30 | 26 | $ - 0 | $ 100.00 |
| 5/10/22 | 21 | 42 | $ 525.00 | $ - 0 |
| 5/11/22 | 30 | 40 | $ 250.00 | $ - 0 |
| 5/12/22 | 30 | 48 | $ 450.00 | $ - 0 |
| 5/13/22 | 30 | 39 | $ 225.00 | $ - 0 |
| 5/14/22 | 15 | 34 | $ 475.00 | $ - 0 |
| 5/15/22 | 24 | 32 | $ 200.00 | $ - 0 |
| 5/16/22 | 30 | 30 | $ - 0 | $ - 0 |
| 5/17/22 | 30 | 50 | $ 500.00 | $ - 0 |
| 5/18/22 | 30 | 50 | $ 500.00 | $ - 0 |
| 5/19/22 | 30 | 49 | $ 475.00 | $ - 0 |
| 5/20/22 | 27 | 37 | $ 250.00 | $ - 0 |
| 5/21/22 | 27 | 33 | $ 150.00 | $ - 0 |
| 5/22/22 | 27 | 43 | $ 400.00 | $ - 0 |
| 5/23/22 | 30 | 24 | $ - 0 | $ 150.00 |
| 5/24/22 | 30 | 20 | $ - 0 | $ 250.00 |
| 5/25/22 | 30 | 40 | $ 250.00 | $ - 0 |
| 5/26/22 | 30 | 42 | $ 300.00 | $ - 0 |
| 5/27/22 | 30 | 38 | $ 200.00 | $ - 0 |
| 5/28/22 | 30 | 29 | $ - 0 | $ 25.00 |
| 5/29/22 | 24 | 35 | $ 275.00 | $ - 0 |
| 5/30/22 | 30 | 37 | $ 175.00 | $ - 0 |
| 5/31/22 | 30 | 50 | $ 500.00 | $ - 0 |
MowerPurchase
| Red Bluff Golf Course & Pro Shop | |||||||||||||||||||
| Fairway Mower Purchase Analysis | |||||||||||||||||||
| Option 1 | Option 2 | Option 3 | Option 4 | Option 5 | |||||||||||||||
| Golf Cart Brand: | Toro | Toro | Jacobsen | Jacobsen | John Deere | ||||||||||||||
| Model: | 6700-D | 7000-D | LF-570 | LF-4677 | 7500 E-Cut Hybrid | ||||||||||||||
| Retail Price: | 52,995.00 | 52,995.00 | 52,995.00 | 56,995.00 | 56,995.00 | 56,995.00 | 53,595.00 | 53,595.00 | 53,595.00 | 60,695.00 | 60,695.00 | 60,695.00 | 54,796.00 | 54,796.00 | 54,796.00 | ||||
| Purchase Price: | 47,995.00 | 47,995.00 | 47,995.00 | 51,995.00 | 51,995.00 | 51,995.00 | 48,995.00 | 48,995.00 | 48,995.00 | 54,995.00 | 54,995.00 | 54,995.00 | 49,995.00 | 49,995.00 | 49,995.00 | ||||
| Annual Interest Rate: | 5.00% | 5.50% | 6.00% | 5.00% | 5.50% | 6.00% | 5.00% | 5.50% | 6.00% | 5.00% | 5.50% | 6.00% | 5.00% | 5.50% | 6.00% | ||||
| # of Payments: | 24 | 36 | 48 | 24 | 36 | 48 | 24 | 36 | 48 | 24 | 36 | 48 | 24 | 36 | 48 | ||||
| Monthly Payment: | $ 2,105.61 | $ 1,449.25 | $ 1,127.16 | $ 2,281.09 | $ 1,570.04 | $ 1,221.10 | $ 2,149.48 | $ 1,479.45 | $ 1,150.65 | $ 2,412.71 | $ 1,660.62 | $ 1,291.56 | $ 2,193.35 | $ 1,509.64 | $ 1,174.13 | ||||
| Total Purchase Cost: | 50,534.58 | 52,173.08 | 54,103.87 | 54,746.23 | 56,521.29 | 58,613.00 | 51,587.49 | 53,260.14 | 55,231.15 | 57,904.97 | 59,782.45 | 61,994.84 | 52,640.40 | 54,347.19 | 56,358.43 | ||||
| Total Interest Cost: | 2,539.58 | 4,178.08 | 6,108.87 | 2,751.23 | 4,526.29 | 6,618.00 | 2,592.49 | 4,265.14 | 6,236.15 | 2,909.97 | 4,787.45 | 6,999.84 | 2,645.40 | 4,352.19 | 6,363.43 | ||||
