Complete the following items: Build a model in Excel that calculates the profitability of Apples AirPods Pro sales if Apple charges a price of $250 Change your model to calculate the profitability if Apple charges a price of $270 Change your model to calculate the profitability if Apple charges a price of $300 Optional (advanced): use online resources to learn how to use Excels Data Table function to show how the profitability would change from a price of $200 to $300 in increments of $10 (e.g., $200, $210, $220, $230, etc.)

Criteria: To successfully execute this, you should focus on the following: Model Accuracy: ensure you do the math first and your model accurately completes all of the calculations required in the case Dynamic Structure: your model should include a control panel with inputs that can be changed and affect the model calculations Clean Formatting: follow the guidelines provided in the Quantitative Analysis presentation on best practices for Excel model formatting (e.g., labels, lines, font color)