Complete the following 1. Open the Module 5 - Bikes xlax workbook and save the file as Mod5Bikes(your last name).xlsx. In the Sales worksheet, insert a new column B. In B1, name the header as "Sales Manager". Add the sales manager's name to the date in column B using VLOOKUP to determine which sales manager sold a particular product. 3. Format each column of date as the appropriate date types and formatting that appeals to the user of this sheet. 4. Create a Date Model in Power pivot that includes the two worksheets of data. Name the sheets in the data model appropriately. Establish the relationship that exists between the two worksheets. To complete the following requirements, you will need to create any calculated field or measure you will need to complete the analysis inside the date model. All price calculations are to be rounded up to two decimal places and formatted as currency. 5. Create a new sheet to the right of Managers named Manager Performance. Create a Pivot Table from your data model that shows annual sales manager performance per product. This pivot table needs to compare the total sales by sales managers for each year. 6. Create a new sheet to the right of Manager Performance called Timeline. Create a Pivot Table from your data model that shows all sales amounts by sales manager over time. Use a timeline to display sales for 2007 and 2006. 7. Create a new sheet to the right of Timeline called Countries. Create a Pivot Table from your data model that shows total sales to different countries for each year. To visualize sales to the countries, create a bar chart showing the purchases by countries. Add data labels to the highest sales amount in each year. Format the chart appropriately for ease of understanding the data. 8. Create a new sheet to the right of Countries called KPI. Create a Pivot Table from your data model that shows profitability of each sales manager. To do this, you will need to create a KPI that assesses profit by manager (Profit is Unit Price - Cost). Set your first milestone to 500,000. Set your second to 1,000,000. Pick a visualization that suits the data. Use this KPI in your Pivot Table to display a symbol for each manager's profit. 9. Save your file and submit to the dropbox