Hotel-Hilton-spreadsheet (XLSX)
The average room rate is £80 (assume this is the profit as marginal costs are 0). When a customer is denied a room due to overbooking, it costs the hotel roughly £200 (goodwill, finding other accommodation).
How many rooms should the hotel overbook during the graduation period?
