December Guests

The manager at the Graduates' Inn has asked you to do some analysis of December's transactions.

The December Guest worksheet provides a transaction list of customers, rooms they occupy, arrival and departure dates, number of occupants, and daily rate data for the month of December.

Guests have a choice oi rooms based on availability and room rates. Room rates are the same for one or two guests; however, additional guests must pay an additional fee which is per person, per night for meals and other miscellaneous expenses.

Guests staying for seven nights or more receive a $10\%$ discount which is applied to the room total before add$-$ons and taxes.

The manager also gave you a worksheet with the January