Project: Michelle's Teas Michelle has three stores named Michelle's Teas which sells different favors of teas. Michelle has been keeping the sales figures manually . She has decided that a spreadsheet application can help her keep better tabs on sales and allow her to analyze how well the stores are doing selling each tea. The sales data for Michelle's Teas can be found in the Michelle teas.xlsxworkbook. Michelle needs a worksheet for each store. Name the worksheets Boston. Austin and Charleston. Michelle needs to know the annual sales, cost of goods sold, annual gross profit , profit margin and markup percentage for each item for each store. 2. Michelle wants to know the sum, average, maximum and minimum for annual sales, cost of goods sold, and annual gross profit for each store 3. Michelle wants the worksheet to flag any item that has a markup of 25 or less so she can decide if the price needs readjustment for each store. The formula for Markup is (Price-Cost)/Cost 4. Michelle wants to identify the top two best selling items for each store. 5. Michelle wants to see a pie chart showing the percentages each tea makes up of gross profit margin for each store. 6. Michelle wants a line chart comparing the annual sales of the teas for each store. 7. Michelle needs a bar chart that compares Cost of Goods Sold with Annual Sales for each store. 8. Michelle wants a consolidated worksheet that calculates the total number of units sold for each tea, total sales for each tea, total cost of goods for each tea the total profit for each tea, and the average profit margin for each tea. The worksheet should highlight the two bestselling teas. 9. Michelle wants a bar chart comparing total sales to total costs for each tea. 10. Create a PivotTable, PivotChart and slicer by tea name for the consolidated worksheet .