The Excel file Graduates Inn Guest provides a transaction list of customers, rooms they occupied, arrival and
Question:
The Excel file Graduates Inn Guest provides a transaction list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate data for a small bed-and-breakfast inn for the month of December. Room rates are the same for one or two guests; however, additional guests must pay a resort fee which is an additional amount (based on the room type as shown in the table below) per person, per day for meals and other miscellaneous expenses. Room Type Additional cost/person/day Ocean $35 Bay-Window $30 Side $20 Guests staying for seven days or more receive a 10% discount (applied to revenue per party transaction upon checkout when the final bill is tallied). Before commencing the Assignment quiz, prepare a spreadsheet using the following guidelines. Modify the spreadsheet (add at least one column for each item 1 to 3) to calculate: (1) The number of days that each party stayed at the inn. (2) Daily rates considering the number of guest(s), Hint: Use VLookUp function; create a resort fee table using the data above. (3) Revenue collected from each party for their total stay at the guest house (4) Total revenue generated for the month from all guests Add one additional sheet to the spreadsheet to address the following items: (5) Create a pivot table to calculate the total revenue categorized by each room type for December. (6) Show a pie chart to display the revenue breakdown by room type from the previous item.
I cannot get past step 2. I keep getting an N/A value because of the formula. If the value is false it will only give me NA.
Expert Answer:
