$(12$ points$)$ The President$$s Inn worksheet in the BAN $830$ M$1$ Week $2$ Homework #$1$ DATA Excel file 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.

$(5$ points$)$ Create a new column that displays the daily rate for each party considering the number of guests in the party.

$(2$ points$)$ Create a new column that displays the number of days stayed by each party.

$(5$ points$)$ Create a new column that displays the revenue generated by each party, considering the daily rate and number of days stayed you previously calculated for each party. Don$$t forget about meals and discounts, as appropriate.