A hotel which caters for airline passengers has 40 rooms. Because of possible cancellations, the hotel takes up to 45 reservations on any given day. Analysis of past records indicate that the number of daily bookings varies from 36 to 45 with each value in this range having a probability of 0.1. The probability of cancellations is represented by the following distribution table. Develop a model, utilising Excel's RAND() function, to simulate a fortnight's data and hence find the average number of room bookings per night, and the percentage of nights when the hotel is overbooked