Stat 1102
dfd213
Guo_e03ch06_grader_h1_ShopSales.xlsxSales
| Transaction count | ||||||||
| Units sold | ||||||||
| Subtotal sum | ||||||||
| Retail average | ||||||||
| Date | Units | Product | Category | Retail_Price | Staff | Staff_Category | Hotel_Guest | Trans_Type |
| 5/1/18 | 1 | Spaaaaah - Hair Wrap | Clothing | 17.95 | Kendra | Massage Therapist | Yes | cash |
| 5/1/18 | 2 | Sandalwood Massage Oil | Massage Oil | 19.95 | Kelly | Receptionist | Yes | check |
| 5/1/18 | 2 | Vanilla Bean Massage Oil | Massage Oil | 19.95 | Kelly | Receptionist | No | check |
| 5/1/18 | 2 | Water - rejuvenating, flavored, 12 oz bottle | Food | 4.19 | Pat | Massage Therapist | No | card |
| 5/1/18 | 2 | Geranium Rose Bath Crystals | Skincare | 6.99 | Kendra | Massage Therapist | Yes | card |
| 5/1/18 | 1 | Vanilla Bean reed oil | Scents | 6.95 | Irene | Manager | No | cash |
| 5/1/18 | 1 | Vanilla Bean Massage Oil | Massage Oil | 19.95 | Kendra | Massage Therapist | Yes | card |
| 5/1/18 | 1 | Nail repair | Hand Care | 9.95 | Jason | Massage Therapist | Yes | cash |
| 5/2/18 | 2 | Nail repair | Hand Care | 9.95 | Christy | Massage Therapist | No | check |
| 5/2/18 | 4 | Geranium Rose Bath Crystals | Skincare | 6.99 | Susan | Nail Technician | Yes | cash |
| 5/2/18 | 1 | Nail repair | Hand Care | 9.95 | Jason | Massage Therapist | Yes | card |
| 5/2/18 | 1 | Sandalwood reed oil | Scents | 6.95 | Jason | Nail Technician | Yes | card |
| 5/2/18 | 1 | Vanilla Bean reed oil | Scents | 6.95 | Pat | Massage Therapist | Yes | cash |
| 5/2/18 | 3 | Healthy Hands - extra dry | Hand Care | 8.5 | Christy | Massage Therapist | Yes | check |
| 5/2/18 | 1 | Nail repair | Hand Care | 2.45 | Leslie | Nail Technician | Yes | cash |
| 5/2/18 | 1 | Turquoise Oasis Exfoliating Sponge | Skincare | 6.99 | Kendra | Massage Therapist | No | card |
| 5/3/18 | 2 | Nail repair | Hand Care | 9.95 | Pat | Massage Therapist | Yes | cash |
| 5/3/18 | 1 | Water - rejuvenating, flavored, 12 oz bottle | Food | 4.19 | Kendra | Massage Therapist | Yes | cash |
| 5/3/18 | 1 | Bergamot Massage Oil | Massage Oil | 19.95 | Leslie | Nail Technician | No | cash |
| 5/3/18 | 3 | Water - rejuvenating, flavored, 12 oz bottle | Food | 4.19 | Kendra | Massage Therapist | Yes | cash |
| 5/3/18 | 2 | Ylang Ylang Massage Oil | Massage Oil | 19.95 | Kendra | Massage Therapist | Yes | card |
| 5/3/18 | 2 | Ginseng Tea | Food | 2.45 | Kendra | Massage Therapist | No | card |
| 5/4/18 | 1 | Spaaaaah - Hair Wrap | Clothing | 17.95 | Kendra | Massage Therapist | Yes | card |
| 5/4/18 | 1 | Vanilla Bean Massage Oil | Massage Oil | 19.95 | Irene | Manager | Yes | card |
| 5/4/18 | 2 | Healthy Hands - extra dry | Hand Care | 8.5 | Kendra | Massage Therapist | Yes | check |
| 5/4/18 | 1 | Water - rejuvenating, flavored, 12 oz bottle | Food | 4.19 | Susan | Nail Technician | No | cash |
| 5/4/18 | 2 | Nail repair | Hand Care | 9.95 | Kendra | Massage Therapist | Yes | card |
| 5/4/18 | 1 | Cordial glasses set of 2 | Housewares | 13.95 | Irene | Manager | Yes | check |
| 5/4/18 | 1 | Orange reed oil | Scents | 6.95 | Christy | Massage Therapist | Yes | card |
| 5/4/18 | 1 | Bathrobe - Persian Silk | Clothing | 73.49 | Kendra | Massage Therapist | Yes | card |
| 5/4/18 | 1 | Nail protector | Hand Care | 9.95 | Kendra | Massage Therapist | Yes | cash |
| 5/5/18 | 1 | Vanilla Bean Massage Oil | Massage Oil | 19.95 | Christy | Massage Therapist | Yes | card |
| 5/5/18 | 1 | Skin Toner | Skincare | 9.95 | Kendra | Massage Therapist | No | card |
| 5/5/18 | 2 | Geranium Rose Bath Crystals | Skincare | 6.99 | Meda | Manager | Yes | cash |
| 5/5/18 | 2 | Bergamot Massage Oil | Massage Oil | 19.95 | Kendra | Massage Therapist | Yes | card |
| 5/5/18 | 1 | Ginseng Tea | Food | 2.45 | Leslie | Nail Technician | No | card |
| 5/5/18 | 1 | Vanilla Bean Massage Oil | Massage Oil | 19.95 | Pat | Massage Therapist | No | cash |
| 5/5/18 | 1 | Healthy Hands - rejuvenating | Hand Care | 9.25 | Kelly | Receptionist | Yes | card |
| 5/5/18 | 3 | Water - mineral, 16 oz bottle | Food | 3.95 | Irene | Manager | Yes | card |
| 5/5/18 | 1 | Spaaaaah - Bath Towel 36x96 | Clothing | 21.99 | Irene | Manager | Yes | card |
| 5/6/18 | 1 | Healthy Hands - rejuvenating | Hand Care | 9.25 | Kendra | Massage Therapist | Yes | check |
| 5/7/18 | 1 | Healthy Hands - rejuvenating | Hand Care | 9.25 | Kendra | Massage Therapist | Yes | cash |
| 5/7/18 | 1 | Vanilla Bean Massage Oil | Massage Oil | 19.95 | Kendra | Massage Therapist | Yes | check |
| 5/7/18 | 1 | Healthy Hands - extra dry | Hand Care | 8.5 | Meda | Manager | Yes | card |
| 5/7/18 | 1 | Healthy Hands - dry | Hand Care | 8.5 | Kelly | Receptionist | Yes | card |
| 5/7/18 | 2 | Spaaaaah - Bath Towel 36x96 | Clothing | 21.99 | Meda | Manager | No | card |
| 5/7/18 | 2 | Sandalwood Massage Oil | Massage Oil | 19.95 | Susan | Nail Technician | Yes | card |
| 5/7/18 | 1 | Orange reed oil | Scents | 6.95 | Pat | Massage Therapist | Yes | card |
| 5/7/18 | 1 | Nail repair | Hand Care | 9.95 | Christy | Massage Therapist | Yes | cash |
| 5/7/18 | 1 | Sandalwood reed oil | Scents | 6.95 | Meda | Manager | Yes | card |
| 5/8/18 | 1 | Ginseng Tea | Food | 2.45 | Kendra | Massage Therapist | Yes | check |
| 5/8/18 | 2 | Nail repair | Hand Care | 9.95 | Kelly | Receptionist | Yes | card |
| 5/8/18 | 1 | Healthy Hands - dry | Hand Care | 8.5 | Kendra | Massage Therapist | Yes | card |
| 5/8/18 | 1 | Sandalwood reed oil | Scents | 6.95 | Kendra | Massage Therapist | Yes | card |
| 5/8/18 | 1 | Ginseng Tea | Food | 2.45 | Irene | Manager | Yes | check |
| 5/8/18 | 1 | Ginseng Tea | Food | 2.45 | Susan | Nail Technician | Yes | check |
| 5/8/18 | 1 | Healthy Hands - rejuvenating | Hand Care | 9.25 | Christy | Massage Therapist | Yes | card |
| 5/8/18 | 1 | Nail repair | Hand Care | 9.95 | Jason | Massage Therapist | Yes | card |
| 5/8/18 | 1 | Healthy Hands - extra dry | Hand Care | 8.5 | Irene | Manager | Yes | cash |
| 5/8/18 | 2 | Healthy Hands - dry | Hand Care | 8.5 | Kendra | Massage Therapist | Yes | card |
| 5/9/18 | 1 | Water - mineral, 16 oz bottle | Food | 3.95 | Christy | Massage Therapist | No | card |
| 5/9/18 | 1 | Healthy Hands - rejuvenating | Hand Care | 9.25 | Jason | Massage Therapist | Yes | card |
| 5/9/18 | 4 | Healthy Hands - dry | Hand Care | 8.5 | Leslie | Nail Technician | Yes | cash |
| 5/10/18 | 2 | Water - mineral, 16 oz bottle | Food | 3.95 | Irene | Manager | Yes | card |
| 5/10/18 | 1 | Nail repair | Hand Care | 9.95 | Kendra | Massage Therapist | Yes | card |
| 5/11/18 | 1 | Healthy Hands - dry | Hand Care | 8.5 | Pat | Massage Therapist | Yes | card |
| 5/11/18 | 1 | Ylang Ylang Massage Oil | Massage Oil | 19.95 | Irene | Manager | No | card |
| 5/11/18 | 1 | Orange reed oil | Scents | 6.95 | Jason | Massage Therapist | No | card |
| 5/12/18 | 1 | Nail protector | Hand Care | 9.95 | Kelly | Receptionist | Yes | card |
| 5/12/18 | 1 | Nail strengthener | Hand Care | 9.95 | Kendra | Massage Therapist | Yes | card |
| 5/12/18 | 2 | Healthy Hands - dry | Hand Care | 8.5 | Kendra | Massage Therapist | Yes | card |
| 5/12/18 | 1 | Ginseng Tea | Food | 2.45 | Irene | Manager | Yes | cash |
| 5/12/18 | 1 | Healthy Hands - extra dry | Hand Care | 8.5 | Susan | Nail Technician | Yes | cash |
| 5/12/18 | 3 | Nail strengthener | Hand Care | 9.95 | Irene | Manager | Yes | cash |
| 5/12/18 | 1 | Vanilla Bean Massage Oil | Massage Oil | 19.95 | Kendra | Massage Therapist | Yes | card |
| 5/12/18 | 1 | Healthy Hands - extra dry | Hand Care | 8.5 | Kendra | Massage Therapist | Yes | check |
| 5/12/18 | 1 | Sandalwood Massage Oil | Massage Oil | 19.95 | Leslie | Nail Technician | Yes | check |
| 5/12/18 | 1 | Vanilla Bean Massage Oil | Massage Oil | 19.95 | Leslie | Nail Technician | Yes | cash |
| 5/12/18 | 2 | Turquoise Travel Mug - 16oz | Housewares | 15.99 | Christy | Massage Therapist | Yes | cash |
| 5/12/18 | 1 | Nail repair | Hand Care | 9.95 | Irene | Manager | Yes | card |
| 5/13/18 | 1 | Ginseng Tea | Food | 2.45 | Leslie | Nail Technician | Yes | check |
| 5/13/18 | 1 | Water - mineral, 16 oz bottle | Food | 3.95 | Pat | Massage Therapist | Yes | card |
| 5/13/18 | 2 | Spaaaaah - Hair Wrap | Clothing | 17.95 | Irene | Manager | Yes | card |
| 5/13/18 | 1 | Healthy Hands - rejuvenating | Hand Care | 9.25 | Jason | Massage Therapist | Yes | card |
| 5/13/18 | 1 | Ginseng Tea | Food | 2.45 | Kendra | Massage Therapist | Yes | card |
| 5/13/18 | 1 | Nail protector | Hand Care | 9.95 | Meda | Manager | No | card |
| 5/14/18 | 1 | Nail strengthener | Hand Care | 9.95 | Christy | Massage Therapist | No | card |
| 5/14/18 | 1 | Ginseng Tea | Food | 2.45 | Jason | Massage Therapist | Yes | card |
| 5/14/18 | 2 | Ginseng Tea | Food | 2.45 | Kendra | Massage Therapist | Yes | card |
| 5/14/18 | 2 | Sandalwood reed oil | Scents | 6.95 | Kendra | Massage Therapist | Yes | card |
| 5/14/18 | 2 | Orange reed oil | Scents | 6.95 | Irene | Manager | Yes | card |
| 5/14/18 | 2 | Healthy Hands - dry | Hand Care | 8.5 | Leslie | Nail Technician | Yes | cash |
| 5/15/18 | 1 | Healthy Hands - rejuvenating | Hand Care | 9.25 | Kendra | Massage Therapist | Yes | card |
| 5/15/18 | 1 | Water - rejuvenating, flavored, 12 oz bottle | Food | 4.19 | Christy | Massage Therapist | Yes | check |
| 5/15/18 | 2 | Geranium Rose Bath Crystals | Skincare | 6.99 | Kelly | Receptionist | Yes | card |
| 5/16/18 | 1 | Ylang Ylang Massage Oil | Massage Oil | 19.95 | Kendra | Massage Therapist | Yes | cash |
| 5/16/18 | 1 | Healthy Hands - extra dry | Hand Care | 8.5 | Christy | Massage Therapist | Yes | cash |
| 5/16/18 | 1 | Spaaaaah - Bath Towel 36x96 | Clothing | 21.99 | Christy | Massage Therapist | Yes | card |
| 5/16/18 | 1 | Water - mineral, 16 oz bottle | Food | 3.95 | Kendra | Massage Therapist | Yes | card |
| 5/16/18 | 2 | Vanilla Bean reed oil | Scents | 6.95 | Jason | Massage Therapist | No | card |
| 5/16/18 | 1 | Ylang Ylang Massage Oil | Massage Oil | 19.95 | Susan | Nail Technician | Yes | card |
| 5/16/18 | 1 | Water - mineral, 16 oz bottle | Food | 3.95 | Pat | Massage Therapist | Yes | check |
| 5/16/18 | 4 | Vanilla Bean Massage Oil | Massage Oil | 19.95 | Jason | Massage Therapist | Yes | card |
| 5/16/18 | 1 | Nail protector | Hand Care | 9.95 | Leslie | Nail Technician | No | card |
| 5/16/18 | 4 | Healthy Hands - dry | Hand Care | 8.5 | Christy | Massage Therapist | Yes | cash |
| 5/16/18 | 1 | Vanilla Bean reed oil | Scents | 6.95 | Kendra | Massage Therapist | Yes | cash |
| 5/16/18 | 1 | Sage reed oil | Scents | 6.95 | Pat | Massage Therapist | No | card |
| 5/16/18 | 2 | Sage reed oil | Scents | 6.95 | Kendra | Massage Therapist | Yes | check |
| 5/16/18 | 1 | Orange reed oil | Scents | 6.95 | Kendra | Massage Therapist | Yes | card |
| 5/17/18 | 2 | Orange reed oil | Scents | 6.95 | Christy | Massage Therapist | No | card |
| 5/17/18 | 1 | Vanilla Bean Massage Oil | Massage Oil | 19.95 | Kelly | Receptionist | No | check |
| 5/17/18 | 2 | Skin Toner | Skincare | 9.95 | Irene | Manager | No | card |
| 5/17/18 | 1 | Orange reed oil | Scents | 6.95 | Christy | Massage Therapist | No | card |
| 5/17/18 | 2 | Nail repair | Hand Care | 9.95 | Susan | Nail Technician | Yes | card |
| 5/17/18 | 1 | Nail repair | Hand Care | 9.95 | Irene | Manager | No | card |
| 5/17/18 | 1 | Sage reed oil | Scents | 6.95 | Susan | Nail Technician | Yes | cash |
| 5/17/18 | 1 | Ylang Ylang Massage Oil | Massage Oil | 19.95 | Kendra | Massage Therapist | No | card |
| 5/17/18 | 1 | Nail protector | Hand Care | 9.95 | Kelly | Receptionist | No | cash |
| 5/17/18 | 1 | Healthy Hands - extra dry | Hand Care | 8.5 | Kendra | Massage Therapist | No | cash |
| 5/17/18 | 3 | Water - mineral, 16 oz bottle | Food | 3.95 | Irene | Manager | Yes | card |
| 5/17/18 | 2 | Nail strengthener | Hand Care | 9.95 | Leslie | Nail Technician | No | card |
| 5/17/18 | 1 | Water - mineral, 16 oz bottle | Food | 3.95 | Pat | Massage Therapist | Yes | card |
| 5/18/18 | 1 | Skin Toner | Skincare | 9.95 | Jason | Massage Therapist | Yes | check |
| 5/18/18 | 1 | Turquoise Ceramic mug -15oz | Housewares | 11.29 | Meda | Manager | Yes | check |
| 5/18/18 | 1 | Non-allergenic scent free Massage Oil | Massage Oil | 22.95 | Kendra | Massage Therapist | Yes | card |
| 5/18/18 | 1 | Water - mineral, 16 oz bottle | Food | 3.95 | Kelly | Receptionist | Yes | card |
| 5/18/18 | 1 | Bergamot reed oil | Scents | 6.95 | Jason | Massage Therapist | No | card |
| 5/18/18 | 2 | Water - rejuvenating, flavored, 12 oz bottle | Food | 4.19 | Susan | Nail Technician | Yes | check |
| 5/18/18 | 1 | Avocado Foot Care Cream | Foot Care | 4.95 | Pat | Massage Therapist | No | card |
| 5/18/18 | 2 | Water - rejuvenating, flavored, 12 oz bottle | Food | 4.19 | Kendra | Massage Therapist | No | card |
| 5/18/18 | 1 | Spaaaaah - Hair Wrap | Clothing | 17.95 | Kelly | Receptionist | Yes | card |
| 5/18/18 | 1 | Water - rejuvenating, flavored, 12 oz bottle | Food | 4.19 | Pat | Massage Therapist | Yes | card |
| 5/19/18 | 3 | Nail protector | Hand Care | 9.95 | Leslie | Nail Technician | Yes | check |
| 5/19/18 | 1 | Nail strengthener | Hand Care | 9.95 | Kendra | Massage Therapist | Yes | card |
| 5/19/18 | 2 | Sage reed oil | Scents | 6.95 | Kelly | Receptionist | No | card |
| 5/19/18 | 1 | Sandalwood reed oil | Scents | 6.95 | Kendra | Massage Therapist | Yes | cash |
| 5/19/18 | 2 | Nail repair | Hand Care | 9.95 | Pat | Massage Therapist | Yes | cash |
| 5/20/18 | 1 | Sandalwood reed oil | Scents | 6.95 | Kendra | Massage Therapist | Yes | card |
| 5/20/18 | 2 | Geranium Rose Bath Crystals | Skincare | 6.99 | Christy | Massage Therapist | Yes | cash |
| 5/20/18 | 1 | Vanilla Bean reed oil | Scents | 6.95 | Jason | Massage Therapist | No | card |
| 5/20/18 | 1 | Skin Toner | Skincare | 9.95 | Meda | Manager | Yes | card |
| 5/20/18 | 2 | Bergamot Massage Oil | Massage Oil | 19.95 | Kelly | Receptionist | Yes | card |
| 5/20/18 | 3 | Ginseng Tea | Food | 2.45 | Kelly | Receptionist | Yes | card |
| 5/21/18 | 1 | Healthy Hands - dry | Hand Care | 8.5 | Jason | Massage Therapist | Yes | cash |
| 5/21/18 | 3 | Sage reed oil | Scents | 6.95 | Susan | Nail Technician | Yes | cash |
| 5/21/18 | 1 | Sandalwood Massage Oil | Massage Oil | 19.95 | Kendra | Massage Therapist | No | card |
| 5/21/18 | 2 | Geranium Rose Bath Crystals | Skincare | 6.99 | Christy | Massage Therapist | No | card |
| 5/21/18 | 1 | Spaaaaah - Bath Towel 36x96 | Clothing | 21.99 | Jason | Massage Therapist | No | card |
| 5/21/18 | 1 | Water - mineral, 16 oz bottle | Food | 3.95 | Kendra | Massage Therapist | Yes | card |
| 5/21/18 | 1 | Orange reed oil | Scents | 6.95 | Pat | Massage Therapist | No | check |
| 5/21/18 | 1 | Geranium Rose Bath Crystals | Skincare | 6.99 | Susan | Nail Technician | Yes | card |
| 5/22/18 | 1 | Vanilla Bean Massage Oil | Massage Oil | 19.95 | Irene | Manager | Yes | card |
| 5/22/18 | 1 | Water - mineral, 16 oz bottle | Food | 3.95 | Kendra | Massage Therapist | No | card |
| 5/22/18 | 2 | Vanilla Bean Massage Oil | Massage Oil | 19.95 | Kendra | Massage Therapist | Yes | card |
| 5/22/18 | 2 | Nail strengthener | Hand Care | 9.95 | Pat | Massage Therapist | No | card |
| 5/22/18 | 1 | Water - mineral, 16 oz bottle | Food | 3.95 | Christy | Massage Therapist | Yes | cash |
| 5/22/18 | 1 | Sage reed oil | Scents | 6.95 | Kelly | Receptionist | Yes | card |
| 5/22/18 | 2 | Skin Toner | Skincare | 9.95 | Meda | Manager | Yes | card |
| 5/22/18 | 1 | Sandalwood reed oil | Scents | 6.95 | Kendra | Massage Therapist | No | card |
| 5/23/18 | 1 | Orange reed oil | Scents | 6.95 | Kendra | Massage Therapist | Yes | card |
| 5/23/18 | 2 | Healthy Hands - extra dry | Hand Care | 8.5 | Leslie | Nail Technician | Yes | card |
| 5/23/18 | 1 | Sand Brush - dry skin exfoliator | Skincare | 10.99 | Pat | Massage Therapist | Yes | cash |
| 5/23/18 | 2 | Water - rejuvenating, flavored, 12 oz bottle | Food | 4.19 | Leslie | Nail Technician | Yes | check |
| 5/24/18 | 1 | Sand Brush - dry skin exfoliator | Skincare | 10.99 | Christy | Massage Therapist | No | card |
| 5/24/18 | 1 | Cilantro Foot Bath Crystals | Skincare | 6.99 | Pat | Massage Therapist | Yes | cash |
| 5/24/18 | 1 | Sand Brush - dry skin exfoliator | Skincare | 10.99 | Christy | Massage Therapist | Yes | card |
| 5/24/18 | 1 | Nail repair | Hand Care | 9.95 | Kendra | Massage Therapist | No | cash |
| 5/24/18 | 1 | Ginseng Tea | Food | 2.45 | Kendra | Massage Therapist | Yes | cash |
| 5/24/18 | 1 | Sandalwood Massage Oil | Massage Oil | 19.95 | Irene | Manager | Yes | check |
| 5/24/18 | 1 | Geranium Rose Bath Crystals | Skincare | 6.99 | Pat | Massage Therapist | Yes | cash |
| 5/24/18 | 2 | Water - mineral, 16 oz bottle | Food | 3.95 | Pat | Massage Therapist | No | card |
| 5/25/18 | 1 | Skin Toner | Skincare | 9.95 | Kendra | Massage Therapist | Yes | card |
| 5/25/18 | 1 | Spaaaaah - Hair Wrap | Clothing | 17.95 | Pat | Massage Therapist | Yes | card |
| 5/25/18 | 1 | Turquoise Travel Mug - 16oz | Housewares | 15.99 | Kendra | Massage Therapist | Yes | card |
| 5/25/18 | 3 | Vanilla Bean Massage Oil | Massage Oil | 19.95 | Kendra | Massage Therapist | Yes | card |
| 5/25/18 | 2 | Ginseng Tea | Food | 2.45 | Irene | Manager | Yes | card |
| 5/25/18 | 1 | Water - rejuvenating, flavored, 12 oz bottle | Food | 4.19 | Kendra | Massage Therapist | Yes | card |
| 5/25/18 | 1 | Water - rejuvenating, flavored, 12 oz bottle | Food | 4.19 | Susan | Nail Technician | Yes | cash |
| 5/25/18 | 1 | Nail repair | Hand Care | 9.95 | Jason | Massage Therapist | Yes | card |
| 5/25/18 | 1 | Cordial glasses set of 2 | Housewares | 13.95 | Christy | Massage Therapist | Yes | card |
| 5/25/18 | 1 | Nail protector | Hand Care | 9.95 | Kelly | Receptionist | Yes | card |
| 5/26/18 | 3 | Bathrobe - Persian Silk | Clothing | 73.49 | Pat | Massage Therapist | Yes | card |
| 5/26/18 | 1 | Cilantro Foot Bath Crystals | Skincare | 6.99 | Kendra | Massage Therapist | Yes | cash |
| 5/26/18 | 2 | Nail repair | Hand Care | 9.95 | Irene | Manager | Yes | card |
| 5/27/18 | 1 | Healthy Hands - dry | Hand Care | 8.5 | Irene | Manager | No | card |
| 5/27/18 | 1 | Ylang Ylang Massage Oil | Massage Oil | 19.95 | Jason | Massage Therapist | Yes | card |
| 5/27/18 | 1 | Cilantro Foot Bath Crystals | Skincare | 6.99 | Pat | Massage Therapist | Yes | card |
| 5/27/18 | 3 | Turquoise Oasis Moisturizing Cream | Skincare | 13.99 | Leslie | Nail Technician | Yes | card |
| 5/27/18 | 1 | Healthy Hands - extra dry | Hand Care | 8.5 | Pat | Massage Therapist | Yes | card |
| 5/27/18 | 4 | Turquoise Oasis Exfoliating Sponge | Skincare | 6.99 | Jason | Massage Therapist | Yes | cash |
| 5/28/18 | 2 | Ylang Ylang Massage Oil | Massage Oil | 19.95 | Irene | Manager | Yes | cash |
| 5/28/18 | 2 | Healthy Hands - extra dry | Hand Care | 8.5 | Susan | Nail Technician | Yes | card |
| 5/28/18 | 1 | Nail strengthener | Hand Care | 9.95 | Susan | Nail Technician | Yes | card |
| 5/28/18 | 2 | Nail repair | Hand Care | 9.95 | Kelly | Receptionist | Yes | card |
| 5/28/18 | 1 | Orange reed oil | Scents | 6.95 | Jason | Massage Therapist | No | card |
| 5/28/18 | 1 | Geranium Rose Bath Crystals | Skincare | 6.99 | Leslie | Nail Technician | No | cash |
| 5/28/18 | 1 | Ginseng Tea | Food | 2.45 | Susan | Nail Technician | Yes | card |
&F
SalesAnalysis
| 1. Who were the top two sales people in terms of units sold (non-managers)? |
| 2. Who was the bottom sales person in terms of units sold (non-managers) and the sales person with 30 Units? |
| 3. What percentage of revenue came from the massage therapists? |
&F
