Instructions a. Build the model for profit model for gaming mouse in Excel. b. Answer questions 1-10 in the Blackboard module. c. Add answers to questions 11-16 to your Excel model. d. Submit your Blackboard module and upload your Excel file to Blackboard. You have one attempt for this assignment and must work individually. Model A manufacturer of wireless gaming mouse is preparing to set the price on a new model. Demand (D) is thought to depend on the price (P) and is represented by the model: D = 2500 - 3P The accounting department estimates that the total costs (C) can be represented by C = 6000 + 4D Develop a model for the total profits (Revenues minus Costs) and represent it on an Excel spreadsheet. Consider demands as units sold. Create columns for price, demand, revenue, costs, and profits. Use a table and a graph with $ on the y-axis and Demand on the x-axis to find the price at which profit is maximized. Questions to Answer in Blackboard Module 1. When the price for the gaming mouse is set to $100, what is the corresponding prediction for demand? 2. When the price for the gaming mouse is set to $100, what is the corresponding projected revenue? 3. When the price for the gaming mouse is set to $100, what are the corresponding costs? 4. When the price for the gaming mouse is set to $100, what are the corresponding projected profits? 5. Build a column in Excel for Price and consider price in $10 increments from $50 to $600. (This means your column should have $50, $60, $70, $80, etc. all the way to $600.) At what price for the gaming mouse is projected demand minimized?