(1.1) Calculate the number of nights for the first transaction. - Copy and paste the formula down the column to calculate the nights for the other transactions. 10 (1.2) Calculate the "Rojom Total" for the first transaction. - Use an IF function to calculate a 10% discount for any stay greater than or equal to 7 nights. - Copy and paste the function down the column to calculate the room total for the other transactions. (1.3) Calculate the "Add-On Total" for the first transaction. Rooms with 3 or more guests are required to pay the add-on fee. - Use an IF function with a nested VLOOKUP to calculate the total based on the number of guests, number of nights and the room type. - Use the data in (P4:Q6) to look up the cost based on the room type. - The add-on fee is per person per night. - If there is no add-on fee display a zero (0) in the cell. - Copy and paste the function down the column to calculate the add-on total for the other transactions. Foot Alignment Guests staying for seven nights or more receive a 10% discount which is applied to the room total before addons and taxes. The manager also gave you a worksheet with the January Bookings. He would like you to do calculations that he can use to help Him schedule the cleaning staff for the next month. The Quincy Adams and Truman rooms are the least popular rooms reserved at the inn. Because of this the manager has decided to remodel the rooms. The manager has asked you to complete the "Remodel" worksheet to help him schedule employees for the remodel. MyEducator Tasks 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 of 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. Tell us what you think about Search