this is a revenue management problem. excel solver recommended

203-3 Capacity contain Home Insert Draw Page Layout Formulas Data Review View Tell me Calberley 12 A 13 Wrap Test General Due QA Xf A B D E F G H 1 EX3-3 Price optimization with capacity constraints 2 You are running a hotel and have only two market segments. The demand 3 functions and costs are listed below. Use Solver to answer the following two 4 questions 5 Segment 1: 300-SP; cost per room $6 6 Segment 2: 200 - 3P; cost per room $4 7 a. If you always have rooms to accomodate the demand, what are your optimal 8 prices? 9 b. If you have only 200 rooms, what are your optimal prices? 10 How does the constraint in room number affect your optimal prices and total 11 contribution? 12 . Find the optimal prices given the demand functions below. (unconstrained) 13 function cost Contribution 300-5p 15 2 200-3p 16 17 6: What if the hotel has only 200 rooms? function 0 cost Contribution 19 sega 300-50 6 200-3p 4 125 21 MacBook Air esc BO 1 0 > F1 $ 3 . 2 8 203-3 Capacity contain Home Insert Draw Page Layout Formulas Data Review View Tell me Calberley 12 A 13 Wrap Test General Due QA Xf A B D E F G H 1 EX3-3 Price optimization with capacity constraints 2 You are running a hotel and have only two market segments. The demand 3 functions and costs are listed below. Use Solver to answer the following two 4 questions 5 Segment 1: 300-SP; cost per room $6 6 Segment 2: 200 - 3P; cost per room $4 7 a. If you always have rooms to accomodate the demand, what are your optimal 8 prices? 9 b. If you have only 200 rooms, what are your optimal prices? 10 How does the constraint in room number affect your optimal prices and total 11 contribution? 12 . Find the optimal prices given the demand functions below. (unconstrained) 13 function cost Contribution 300-5p 15 2 200-3p 16 17 6: What if the hotel has only 200 rooms? function 0 cost Contribution 19 sega 300-50 6 200-3p 4 125 21 MacBook Air esc BO 1 0 > F1 $ 3 . 2 8