Create a new $$Dashboard$$ sheet. On it$,$ add a section called $$Add$-$on Option Profitability$.$ For this section, use the data on the $$Add$-$on Info$$ sheet. In the section: Add two drop$-$down lists: one for $$Vehicle Model$$ and one for $$Add$-$On Option$.$ Add output cells that show the: $1)$ Price, $2)$ Cost, $3)$ Gross Profit, and $4)$ Gross Margin $\%.$ These output cells should update based on the selection combination in the two drop$-$down lists described above, and they should only reference the data on the $$Add$-$on Info$$ sheet. Please go back to the $$Sales Data$$ worksheet and add additional columns for the following: Twelve columns showing the price for each of the $12$ different add$-$on options. Of course, only show the price if a $1$ is entered in the applicable column. Hint: Consider the same type of formula you used in Step $1$ above. Also, to keep this more simple, you may want to remember that any price multiplied by a ZERO quantity is still ZERO. A total column showing the total price for all add$-$on options. Please note that if the customer purchased three or more add$-$on options, then they receive a $15\%$ discount on all add$-$on options. Twelve columns showing the cost for each of the $12$ different add$-$on options. Again, only show the cost if a $1$ is entered in the applicable column. One total column showing the total cost of all add$-$on options. Two total columns, showing: $1)$ the grand total sales price $($Base sales Price $+$ Add$-$on option total sales$),$ and $2)$ the grand total cost $($Base Cost $+$ Add$-$on option total costs$).$ A column showing the gross profit for the vehicle sale $($grand total sales price less grand total costs$).$ On the $$Dashboard$$ sheet, add a section called $$Sales Person Key Performance Indicators$.$ Include the following in this section: Add two drop downs lists $$ one for sales person and one for month. Add output cells that use formulas to summarize the total units sold, total sales, total costs, total gross profit, and total gross margin $\%$ for the sales person and the month selected in the drop down lists. Note: there can be multiple sales transactions for a given salesperson in a given month. Thus, the need to summarize rather than mere