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 (50), 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 20212 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 20217 4. Who is Eco Furniture's best sales representative by total sales in 20212 5 What is the best sales representative's best-selling product (by total sales) in 20217 Fle Home Insert Draw Page Layout Formulas Data Review View Help fx Insert Funcion Autolum Recently Financial Logical Test Date & Lookup & Math & More Used- Time-Reference - Functions Fundien Library 4 Marlene Ve Define Name Uve in Name Manager Create hom Selection ace Precedents Show ace Dependents Amp Checking- Al Defined Nemes C D Customer SalesRep Date Hem Cost Notem Subtotal Shipping Total Sale B&B Spaces Home USA Ellington Designs 7 Eington Designs B&B Spaces Ellington Designs PJ Helgoth 1/5/2021 205.35 1445.75 Roberta Cross Loraine Schultz 1/5/2021 329.95 655.00 1/6/2021 64.95 454.65 10 Home USA 11 Home USA 12 Home USA 13 Home USA 14 068 Spaces 15 Home USA Roberta Cross Loraine Schultz Loraine Schultz Roberta Cross Loraine Schultz Loraine Schults Loraine Schults Loraine Schult 1/1/2021 129.95 415.35 1/7/2021 1/5/2021 643.99 64.35 12 77540 2.599 1/10/2021 1/10/2021 64.35 643.99 10 643.50 1,29538 26 859 Spaces Loraine Schultz Loraine Schult 17 B&D Spaces 18 Ellington Designs 1988 Spaces 20 Home USA Roberta Cross Loraine Schultz Roberta Cross 1/10/2021 329.95 1/13/2021 139.95 1/13/2021 329.95 1/13/2021 329.95 1/14/2021 13995 1/14/2021 299.35 1/15/2021 64.95 1/15/2021 64599 1/16/2021 139.95 1,97570 10 1.399.30 13 4.289.35 1.319.80 11 1539.45 2.09965 11 71445 1871.34 10 1.199.50 21 & Spaces 23 Ellington Designs Roberta Cross 1/16/2021 299.95 1/21/201 329.95 14 4390.30 1.315.80 Data Solution 50Y Light rain 500 1000 1500 2000 Comments Sha Callate Nove Watch Window Calculation Ca Options Cases G44B 735 PM A17 2 3 Analysis Question 7 Who is Eco Fumture's best customer by total sales in 20212. Who is Eco Funiture's wont customer by total sales 20212 What is Eco Fumiture's best selling product by total sales 20217 30 Who is Eco Funiture's best sales representative by total sales 20212 11 What is the best sales presentative's best selling product (ty) 2017 12 13 14 25 38 17 38 SOY Dala Salut Name Total Formula Austing Calculation 2444 755 PM