The harriet hotel in downtown boston has 100 rooms that rent for $150 per night. it costs the hotel $30 per room in variable costs (cleaning, bathroom items, etc.) each night a room is occupied. for each reservation accepted, there is a 5% chance that the guest will not arrive. if the hotel overbooks, it costs $200 to compensate guests whose reservations cannot be honored. how many reservations should the hotel accept if it wants to maximize the average daily profit? you may use microsoft excel with aspe or r statistical programming to solve.

use ms excel aspe to solve and provide appropriate steps to complete. i have read the textbook solution, but it appears to have a circular reference in the model and provides very little detail to me understand the solution.