Download the Chapter 16 Pt 2 Class Exercise

darr

Excel workbook and perform the following analysis:\ NatBike, a bicycle manufacturer, has identified two customer segments; one segment prefers a customized bicycle and is willing to pay a higher price whereas the other is willing to take a standardized bicycle but is more price sensitive.\ Assume the customized bicycle costs

$300

to manufacture, whereas a standardized bicycle costs

$200

to manufacture.\ Demand from the customized segment has a demand curve of

d_(1)=20,000-10p_(1)

and demand from the standardized segment has a demand curve of

d_(2)=40,000-30p_(2)

.\ Problem 1 ( 3 pts): Construct an optimization model to dtermine what price should NatBike charge each segment if there is no capacity constraint.\ Problem 2 (2 pts): What price should NatBike charge each segment if the total available capacity is 20,000 bicycles?\ Create a copy of your Problem 1 worksheet, rename the worksheet to Problem 2 (this will save you time!).\ Then, make the necessary adjustments to the worksheet model and Solver to find this new solution.

Download the Chapter 16 Pt 2 Class Exercise Excel workbook and pertorm NatBike, a bicycle manufacturer, has identified two customer segments; one segment prefers a customized bicycle and is willing to pay a higher price whereas the other is willing to take a standardized bicycle but is more price sensitive. Assume the customized bicycle costs $300 to manufacture, whereas a standardized bicycle costs $200 to manufacture. Demand from the customized segment has a demand curve of d1=20,00010p1 and demand from the standardized segment has a demand curve of d2=40,00030p2. Problem 1 ( 3 pts): Construct an optimization model to determine what price should NatBike charge each segment if there is no capacity constraint. Problem 2 (2 pts): What price should NatBike charge each segment if the total available capacity is 20,000 bicycles? - Create a copy of your Problem 1 worksheet, rename the worksheet to Problem 2 (this will save you time!). - Then, make the necessary adjustments to the worksheet model and Solver to find this new solution