Algebraic formulation of the pricing optimization problem

Assignment Help Operation Management

Reference no: EM132254825

Use Excel Solver to deteremine 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) = 2,000 – 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 (mathmatical) formulation of the pricing optimization problem that maximizes the total contribution.

b) Determine the optimal solution of the problem using Excel Solver. Select 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 colum 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 objective function.

Reference no: EM132254825

Questions Cloud

What is home health care and the types of services : What is home health care and the types of services they provide? Describe the reimbursement process for home health agencies by Medicare.

Identify the most challenging issue : Identify the most challenging issue during the integration of SANY and PM (i.e., post-M&A) and discuss how to solve the issue for successful integration.

Find order quantity that will minimize total annual cost : If carrying costs are $2 per year for each stone, find the order quantity that will minimize total annual cost.

Are attitudes towards immigration in the selected countries : Are attitudes towards immigration in the selected countries significantly different from each other? Have gaps widened or shrank

Algebraic formulation of the pricing optimization problem : Provide the algebraic (mathmatical) formulation of the pricing optimization problem that maximizes the total contribution.

List the four drivers of engagement : List the four drivers of engagement and briefly describe each one.

The types of data validation rules in the input process : Briefly describe (including examples in your answer) at least six of the types of data validation rules in the input process.

Demonstrate appropriate and meaningful professionalism : Be sure to demonstrate appropriate and meaningful professionalism for the intended audience which include proper pace, tone, inflection, pronunciation.

Discuss what the employer could have done differently : At times, an employee may claim he or she was terminated unjustly and attempt to litigate the termination. Research a case of wrongful termination.

User Account

All Pages