Question
Suppose the company continues to manufacture its product in the United States, but now it sells its product in the United States, the united Kingdom,
Suppose the company continues to manufacture its product in the United States, but now it sells its product in the United States, the united Kingdom, and possibly other countries. The company can independently set its price in each country where it Sells. For example, the pace coup be $150 in the United States and ₤110 in the United Kingdom. You can assume Mat the demand function in each count, is of the constant elasticity form, each with its own parameters. The question is whether the company can use solver independently in each country to find the optimal price in this country. (you should be able to answer this question without actually running any Solver model(s), but you might want to experiment, just to verify your reasoning.
Put now assume that Madison manufactures its product in the United States and sell it In the United Kingdom (UK). Given the prevailing exchange We in dollars per pound, Madison wants to determine the price In pounds it should charge in the UK so that its profit in dollars is maximized. The company also want to see how the optimal price and the optimal profit depend On exchange rate fluctuations.
Objective To use a nonlinear model to find the price In pounds that maximizes the profit in dollars
Step by Step Solution
3.38 Rating (151 Votes )
There are 3 Steps involved in it
Step: 1
Solver uses a model created on an excel spreadsheet to generate the optimum solution given input var...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
Document Format ( 2 attachments)
609365587214b_23763.pdf
180 KBs PDF File
609365587214b_23763.docx
120 KBs Word File
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started