Aswer

m_e01ws02_grader_a1.xlsx

Sheet1

Turquoise Oasis Spa Schedule
Spa Manager:Irene Kai
Date	Day	Time	Client's Last Name	Client's First Name	Treatment	Consultant	Payment Method	Price	Daily Total
2/15	Tuesday	10:00:00 AM	Jacobs	Sharon	European Facial	Keen	Cash	75
15-Feb	Tuesday	12:00:00 PM	Robbins	Kaylee	European Facial	Rose	Credit	75
15-Feb	Tuesday	1:00:00 PM	Rinker	Danie	European Facial	Keen	Charged to Room	75
15-Feb	Tuesday	4:00:00 PM	Eatton	Michael	Men's Facial	Keen	Charged to Room	75
16-Feb	Wednesday	12:00:00 PM	Jacobs	Sharon	French Manicure	Garrison	Cash	19
16-Feb	Wednesday	2:00:00 PM	Robbins	Kaylee	French Manicure	Garrison	Credit	19
16-Feb	Wednesday	5:00:00 PM	Jacobs	Sharon	Hot Stone Massage 1.5 hours	Rose	Credit	110
16-Feb	Wednesday	3:00:00 PM	Rinker	Danie	Foot Reflexology 1/2 hour	Padar	Charged to Room	35
16-Feb	Wednesday	4:00:00 PM	Rinker	Danie	French Manicure	Garrison	Charged to Room	19
16-Feb	Wednesday	6:00:00 PM	Robbins	Kaylee	Hot Stone Massage 1.5 hours	Gargha	Credit	110
17-Feb	Thursday	10:00:00 AM	Rinker	Danie	Mud Wrap	Rose	Charged to Room	65
17-Feb	Thursday	6:00:00 PM	Eatton	Michael	Swedish Massage 1 hour	Gargha	Charged to Room	70
18-Feb	Friday	10:00:00 AM	Eatton	Michael	Rosacea Treatment	Keen	Charged to Room	75
18-Feb	Friday	2:00:00 PM	Reed	Amy	Swedish Massage 1 hour	Padar	Credit	70
Highest Daily Sales
Lowest Daily sales

Turquoise Oasis Spa Consultant Availability
Spa Manager:Irene Kai
Consultants
Last Name	First Name	Days Available	Hours Available
Istas	Christy	Monday	N/A
		Tuesday	10:00 am - 6:00 pm
		Wednesday	N/A
		Thursday	N/A
		Friday	10:00 am - 5:00 pm
		Saturday	1:00 pm - 8:00 pm
		Sunday	N/A
Mault	Kendra	Monday	N/A
			10:00 am - 7:00 pm
			12:00 am - 8:00 pm
			12:00 am - 8:00 pm
			N/A
			10:00 am - 7:00 pm
			N/A
Niese	Jason	Monday	N/A
			12:00 am - 8:00 pm
			1:00 am - 8:00 pm
			10:00 am - 5:00 pm
			N/A
			10:00 am - 2:00 pm
			N/A