The Astoni Hotel in anyer is considering to determine the best rates and room sizes to maximize revenues. Currently, the hotel has 120 rooms with the following history: (USING EXCEL)

From the management meeting decision, the director want to keep the price of a single bed room between Rp 1.000.000 and Rp 1.800.000, a Double bed room between Rp 2.000.000 and Rp 2.800.000, and a Family room between Rp 3.000.000 and Rp 3.800.000. a. Create an excel spreadsheet hotel price model for this case and find the optimal new price b. How many estimated revenue increased if the director plan to open another 50 rooms

Room Type Rate (in Thousand Daily Average Room Rp) Sold Single Bed Room 1300 60 Double Bed Room 2200 55 Family Room 3500 25 Market segment price/demand elasticity estimates as follows: Room Type Price Elasticity of Demand Single Bed Room -1.5 Double Bed Room - 1 Family Room -0.5 Room Type Rate (in Thousand Daily Average Room Rp) Sold Single Bed Room 1300 60 Double Bed Room 2200 55 Family Room 3500 25 Market segment price/demand elasticity estimates as follows: Room Type Price Elasticity of Demand Single Bed Room -1.5 Double Bed Room - 1 Family Room -0.5