ANSWER THE QUESTION BELOW USING EXCEL SOLVER

El Palacio Real is a beach resort in Virginia Beach, VA. It offers three types of rooms: Double rooms, Ocean view rooms, and Suites. It offers three fare classes for its guests: Discount, Deluxe, and Business. The profit per night for each room type and fare is summarized as follows:

		Profit per room per night
	Discount		Deluxe	Business
Double	$80		$100	$120
Ocean	$60		$70	$110
Suite	-		$50	$100

Note that suites are not available for guests booking under the Discount fares. The demand forecast for tomorrow is 130 bookings in the Discount class, 80 bookings in the Deluxe class, and 50 bookings in the Business class, while there are 100 Double rooms, 120 Ocean view rooms, and 80 Suites available.

Question 1 21 pts

Using the Excel solver, find the optimal allocation of rooms to guests (i.e., how many rooms for each type to allocate to each fare class) for tomorrow. Upload your Excel file containing the Solver model and your optimal solution. In your Excel file, clearly indicate the optimal decisions for the resort.

Question 2

How will the optimal objective value change if the profit of assigning a Deluxe guest to a Suite increases to $60? Did you have to resolve the problem to answer this and why? [~20 words expected]

Question 3

How will the optimal objective value change if the number of Double rooms available decreases to 80? Did you have to resolve the problem to answer this and why? [~20 words expected]

Question 4

How will the optimal objective value change if the number of Discount guests increases to 135? Did you have to resolve the problem to answer this and why? [~20 words expected]