Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Specific subject: Business Analytics Instructions a. Build the model for profit model for gaming mouse in Excel. b. Answer questions 1-10 in the Blackboard module.
Specific subject: Business Analytics 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. 6. At what price for the gaming mouse is projected demand maximized? 7. At what price for the gaming mouse is projected profit maximized? 8. At what price for the gaming mouse is projected revenue maximized? 9. True/False: Costs are projected to increase as the price for gaming mouse goes up. 10. True/False: The lower the price for the gaming mouse, the higher the projected demands
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started