The company Eco Furniture just hired you as a new business analyst. Its stakeholders want to hear your thoughts and ideas on how to improve the business and help the company build a strong lasting relationship with its customers. The company has provided you with 2020-2021 sales information in a datafile. Project focus: Calculate subtotals, shipping costs, and total sales of the company Eco Furniture company has to apply a shipping charge on each sale When the subtotal of a sale is 0-500 shipping is 6%, 500-1000 shipping is 4%, 1000-1500 shipping is 2% and over 1500, then we want that shipping charge to be free ($0), no shipping charge Analyze their sales by using a PivotTable to determine the following 1. Who is Eco Furniture's best customer by total sales in 20217 2. Who is Eco Furniture's worst customer by total sales in 20212 3 What is Eco Furniture's best-selling product by total sales in 20212 4. Who is Eco Fumiture's best sales representative by total sales in 2021? 5. What is the best sales representative's best-selling product (by total sales) in 20217 # 154 5 M N Shipping % 500 1000 1500 2000 6% 4% 25 C D E H 2 3 Customer SalesRep Date Item Cost No.Items Subtotal Shipping Total Sale 4 B&B Spaces Pi Helgoth 1/5/2021 289.95 5 1,445.75 5 Home USA Roberta Cross 1/5/2021 329.95 2 659.90 6 Ellington Designs Loraine Schultz 1/6/2021 64.95 7 454.55 7 Ellington Designs Roberta Cross 1/7/2021 139.95 3 419.85 5085 Spaces Loraine Schultz 1/7/2021 64.35 12 779.40 9 Ellington Designs Loraine Schultz 1/9/2021 649.99 4 2,399.36 10 Home USA Roberta Cross 1/10/2021 64.95 10 645.50 11 Home USA Loraine Schultz 1/10/2021 649.99 2 1.299.98 12 Home USA Loraine Schultz 1/10/2021 325.95 6 1975.70 13 Home USA Loraine Schultz 1/13/2021 139.95 10 1.399.50 14 888 Spaces Loraine Schulta 1/13/2021 129.95 11 4.289.35 15 Home USA Loraine Schultz 1/13/2021 329.95 4 1,319.00 16 B&B Spaces Loraine Schultz 1/14/2021 139.95 11 1539.45 20 17 05 Spaces 18 Ellington Designs 19 888 Spaces Home USA PI Helgoth 1/14/2021 299.95 7 2,099.65 Roberta Cross 1/15/2021 64.95 11 714.45 Loraine Schultz 1/15/2021 543.99 1895.54 Roberta Cross 1/16/2021 139.95 10 1,399.50 21 968 Spaces Loraine Schultz 1/16/2021 299.95 14 4.195.30 22 Ellington Designs Roberta Cross 1/21/2021 329.95 4 1.315.00 Data Solution O sy Accesy Good to ge SOF Light rain unction 17 Analysis Used Function Library A Question Time Reference Trig Functions Who is Eco Furniture's best customer by total sales in 20212 8 Who is Eco Furniture's worst customer by total sales 20212 9 What is Eco Furniture's best selling product by total sales 20212 10 Who is Eco Furniture's best sales representative by total sales 2021? 11 What is the best sales representative's best selling product (by total sales) 20212 12 13 14 15 16 17 18 19 20 Manager Create from Selection Defined Names B Name Total