The worksheet President$$s Inn Guest provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed$-$and$-$breakfast inn during one month. Room rates are the same for one or two guests; however, additional guests must pay an additional $$20$ per person per day for meals. Guests staying for seven days or more receive a $10\%$ discount. Please set up the spreadsheet to calculate the total cost of each stay.

Question: What is the total revenue of President's Inn during the period according to your calculation?