Question
Use Excel Solver to determine the optimal price for a single product. Use the information below to formulate your pricing optimization problem. Demand as a
Use Excel Solver to determine the optimal price for a single product. Use the information below to formulate your pricing optimization problem.
Demand as a function of price: D(p)=2000-10p
Unit variable cost of product: c=$8 per unit
Price must be no more than $110 per unit to be competitive in the marketplace.
a) Provide the algebraic (mathematical) formulation of the pricing optimization problem that maximizes the total contribution.
b) Determine the optimal solution of the problem using Excel Solver. Select the GRG Nonlinear as your solving method in the Solver Parameters window before you solve the problem.
i. Present a screenshot of your Excel spreadsheet model, including the row and column headings.
ii. Present a screenshot of the Solver Parameter Window after you build your Solver model.
iii. Present a screenshot of your Excel spreadsheet model that shows the optimal solution, including optimal values of the decision variable(s) and the optimal value of the objective function.
Thank you!
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