YO19_Excel_Capstone_Intro_Smart_Rental
expmen
Abc_Excel_Capstone_Intro_SmartRental1.xlsxRentalData
| Smart Retail Rental | Rental Payment Analysis | ||||||||||||||
| Rentals Initiated in Week Starting 7/11/2022 | |||||||||||||||
| Product | Product ID | Date Rented | Date Returned/or Expected Return | #Days Rented | Payment Method | Daily Rate | Amount of Discount | Total Sales | Analysis Criteria | Payment Method | Analysis Critieria | Average Total Sales | Total Sales | ||
| Designer handbag | 743 | 7/11/22 | 7/15/22 | Credit Card | 0 | Rewards | Rewards | ||||||||
| Designer handbag | 744 | 7/12/22 | 7/13/22 | Cash | 0 | Check | Check | ||||||||
| Designer handbag | 745 | 7/13/22 | 7/19/22 | Check | 0 | Credit Card | Credit Card | ||||||||
| Designer handbag | 746 | 7/11/22 | 7/19/22 | Credit Card | 0 | Cash | Cash | ||||||||
| Designer handbag | 747 | 7/12/22 | 7/13/22 | Rewards | 0 | ||||||||||
| Accessories | 550 | 7/13/22 | 7/19/22 | Rewards | 0 | ||||||||||
| Accessories | 551 | 7/11/22 | 7/22/22 | Credit Card | 0 | Sales Goal | |||||||||
| Accessories | 552 | 7/12/22 | 7/13/22 | Credit Card | 0 | Goal Met? | |||||||||
| Accessories | 553 | 7/11/22 | 7/17/22 | Credit Card | 0 | ||||||||||
| Accessories | 554 | 7/12/22 | 7/13/22 | Cash | 0 | ||||||||||
| Accessories | 555 | 7/12/22 | 7/13/22 | Credit Card | 0 | ||||||||||
| Accessories | 556 | 7/13/22 | 7/19/22 | Credit Card | 0 | ||||||||||
| Accessories | 557 | 7/11/22 | 7/18/22 | Rewards | 0 | ||||||||||
| Accessories | 558 | 7/11/22 | 7/17/22 | Check | 0 | ||||||||||
| Accessories | 559 | 7/12/22 | 7/13/22 | Cash | 0 | ||||||||||
| Dresses | 988 | 7/12/22 | 7/15/22 | Credit Card | 0 | ||||||||||
| Dresses | 989 | 7/12/22 | 7/16/22 | Rewards | 0 | ||||||||||
| Dresses | 990 | 7/13/22 | 7/15/22 | Credit Card | 0 | ||||||||||
| Dresses | 991 | 7/11/22 | 7/13/22 | Rewards | 0 | ||||||||||
| Dresses | 992 | 7/11/22 | 7/15/22 | Check | 0 | ||||||||||
| Dresses | 993 | 7/12/22 | 7/15/22 | Check | 0 | ||||||||||
| Dresses | 994 | 7/15/22 | 7/16/22 | Credit Card | 0 | ||||||||||
| Gowns | 356 | 7/11/22 | 7/17/22 | Rewards | 0 | ||||||||||
| Gowns | 276 | 7/11/22 | 7/14/22 | Credit Card | 0 | ||||||||||
| Gowns | 277 | 7/12/22 | 7/18/22 | Credit Card | 0 | ||||||||||
| Gowns | 554 | 7/15/22 | 7/17/22 | Cash | 0 | ||||||||||
| Daily Rental Rates | |||||||||||||||
| Designer Handbag | $22.00 | ||||||||||||||
| Accessories | $15.00 | ||||||||||||||
| Dresses | $55.00 | ||||||||||||||
| Gowns | $72.00 | ||||||||||||||
| Discount for Rewards | 20% | ||||||||||||||
Clients
| Client Data | Proper Name |
| DAWN SCHALOW | |
| LAUREL KALLIO | |
| YOUN THAO | |
| CARRIE CARR | |
| SUZETTE KARREN | |
| JERRA JACOBSON | |
| ANDREA RAMIREZ | |
| KAREN WREATH | |
| ALEX LINSER | |
| CONNARE CHING | |
| KELSEA VANBUREN | |
| ELLI ZIMMERMAN | |
| JAMIE MICKELSON | |
| DIANE KOPISKI | |
| RYIN KELLEY | |
| JOE KRUGER | |
| YANG VANG | |
| ERIN ATKINSON | |
| SUZETTE KERR | |
| FATIMA ABIB | |
| RAMONA UNGER | |
| TY NY | |
| NICOLA REYNOLDS | |
| SALLY JOHNSON | |
| ARRIANNE FRANCOIS |
LoanData
| Additional Inventory Loan | |
| Loan Amount | $ 10,000.00 |
| Rate of Interest | 5.50% |
| Number of Years | 5 |
| Montly Payment |
Sheet4
Sheet5
1
2
3
4
5
6
A
B
C
Product
Product ID
Date Rented
Designer handbag
743
7/11/2022
Smart Retail Rental
Rentals Initiated in Week Starting 7/11/2022
