Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Problems In State High School Finance

Authors: Julian Edward Butterworth

1st Edition

0554798298, 9780554798295

More Books

Students also viewed these Finance questions