Microsoft Excel Grader Assignment|Computer Science homework help

Microsoft Excel Grader Assignment|Computer Science homework help

I want assistance with this Excel homework involving pivot tables and formulas.

Office 2016 – myitlab:grader – Instructions Excel Project

YO16_XL_CH06_GRADER_PS1_HW – Gift Shop Sales Review 1.8

Project Description: The sales team at the Painted Treasures Gift Shop would like to review its staff’s sales after some of the new staff members have finished a sales training program. You have been given the data for May 2018 and more data will be added in the future. The sales team wants you to review the data, perform some data analyses, and answer some specific questions. This will help the sales team determine how well the staff is performing, and who needs further training.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Open the downloaded Excel file named e03ch06_grader_h1_ShopSales.xlsx. Save the file with the name e03ch06_grader_h1_ShopSales_LastFirst, using your last and first name. 0 2 Create a copy of the Sales worksheet, and then place it at the end of the workbook. Rename the Sales (2) worksheet as SalesBackup 6 3 On the Sales worksheet, insert a table with headers that uses the range $A$15:$I$212. With the data table selected, create named ranges using the top row as the names. 16 4 Copy range A15:I15, and then paste the range in cell A1. In cell G2, type Receptionist. In cell I2, type Card 4 5 Create an advanced filter using the data in range A1:I2 as the Criteria range and A15:I212 as the List range. Filter the list in-place to display the filtered data on the Sales worksheet. Insert a new sheet, and then rename the new sheet Filter. Copy the filtered data from the table on the Sales worksheet, and then place it in cell A1 on the Filter worksheet. Resize the columns so all the data is visible. 8 6 On the Sales worksheet, in cell J15, type Subtotal. In cell J16, enter a formula using structured references that multiplies Units and Retail_Price. Format the Subtotal column as Accounting Number Format. Create a named range for the Subtotal column that uses the column heading as the name. Note, Mac users, copy the formula down through the column, if necessary. 10 7 Use the SUBTOTAL function to complete the following: In cell H7, insert a formula that counts the number of cells in the Category field that are not empty. In cell H8, insert a formula that sums the cells in the Units field. In cell H9, insert a formula that sums the cells in the Subtotal field. In cell H10, insert a formula that averages the cells in the Retail_Price field. 8 8 On the Sales worksheet, using the range A15:J212, insert a PivotTable in cell A12 on the SalesAnalysis worksheet. 8 9 Configure the PivotTable using the following. Add Units, Staff, and Staff Category to the PivotTable. Move Staff Category to the COLUMNS area. Using the Column Labels arrow, uncheck Manager. Right-click cell E14, point to Sort, and then sort the data in ascending order. 4 10 View the data in the PivotTable to determine the employee with the highest number of units sold. In cell A2, click the drop-down arrow, and then select the name of the employee with the highest number of units sold. In cell A3, click the drop-down arrow, and then select the name of the employee with the second highest number of units sold. 4 11 View the PivotTable data to determine the employee with the lowest number of units sold. Click cell A5, click the drop-down arrow, and then select the name of the employee with the lowest number of units sold. Click cell A6, click the drop-down arrow, and then select the name of the employee who sold 30 units to answer question 2. 4 12 Modify the PivotTable as follows: Add the Category field to the PivotTable. Move Category to the FILTERS area. Add the Hotel_Guest field to the PivotTable in the ROWS area under Staff. In cell A15, replace No with Non-hotel Guest Resize column A so Non-hotel Guest is visible. In cell A16, replace Yes with Hotel Guest 8 13 On the Design tab, modify the grand totals so they display for just the columns. Modify the subtotals so they display at the bottom of the group. View the PivotTable data to determine the percentage of revenue for the massage therapists (% of Grand Total). Click cell A8, click the drop-down arrow, and then select the percentage of revenue of massage therapists. 6 14 On the SalesAnalysis worksheet, insert a slicer for the Trans_Type field. Select both cash and check in the Trans_Type slicer. Drag the Trans_Type slicer so the upper left corner is in the top left corner of G12. Drag the bottom edge of the slicer to adjust the height so the extra white space is no longer visible. Replace the Trans_Type caption with Payment Type 8 15 Using the PivotTable, create a Clustered Column PivotChart. Move the PivotChart to a new sheet named SalesChart Add chart title above the chart with the text Percent Revenue Contribution Note, Mac users, select the range A13:D40, then insert a Clustered Column chart. Move the chart and complete the steps as specified. 6 16 Save the workbook, exit Excel, and then submit your files as directed by your instructor. 0 Total Points 100

Updated: 11/30/2017 1 Current_Instruction.docx

Sales
Date Units Product Category Retail_Price Staff Staff_Category Hotel_Guest Trans_Type
Receptionist Card
Transaction count
Units sold
Subtotal sum
Retail average
Date Units Product Category Retail_Price Staff Staff_Category Hotel_Guest Trans_Type Subtotal
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 36×96 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 36×96 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 36×96 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 36×96 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

Filter
Date Units Product Category Retail_Price Staff Staff_Category Hotel_Guest Trans_Type
5/5/18 1 Healthy Hands – rejuvenating Hand Care 9.25 Kelly Receptionist Yes card
5/7/18 1 Healthy Hands – dry Hand Care 8.5 Kelly Receptionist Yes card
5/8/18 2 Nail repair Hand Care 9.95 Kelly Receptionist Yes card
5/12/18 1 Nail protector Hand Care 9.95 Kelly Receptionist Yes card
5/15/18 2 Geranium Rose Bath Crystals Skincare 6.99 Kelly Receptionist Yes card
5/18/18 1 Water – mineral, 16 oz bottle Food 3.95 Kelly Receptionist Yes card
5/18/18 1 Spaaaaah – Hair Wrap Clothing 17.95 Kelly Receptionist Yes card
5/19/18 2 Sage reed oil Scents 6.95 Kelly Receptionist No 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/22/18 1 Sage reed oil Scents 6.95 Kelly Receptionist Yes card
5/25/18 1 Nail protector Hand Care 9.95 Kelly Receptionist Yes card
5/28/18 2 Nail repair Hand Care 9.95 Kelly Receptionist Yes card
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

SalesBackup
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 36×96 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 36×96 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 36×96 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 36×96 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