View the step-by-step solution to:

Question

The Excel file Graduates' 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 amount (based on the room as shown in the table below) per person per day for meals


and other miscellaneous expenses. Guests staying for seven days or more receive a 10% discount


(applied to revenue per party transaction).


Screen Shot 2020-02-11 at 12.46.30 PM.pngScreen Shot 2020-02-11 at 12.48.15 PM.png

Screen Shot 2020-02-11 at 12.46.30 PM.png

The Excel file Graduates’ 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 amount [based on the room type as shown in the table below] per person per day for meals and other miscellaneous expenses. Guests staying for seven days or more receive a 10% discount
(applied to revenue per party transaction). Deliverable: Modified excel file with your name and student ID on it.
Modify the spreadsheet (add one column for each question from 1 to 3) to calculate: {1) The number of days that each party stayed at the inn [5 points] {2} Daily rates considering the number of guestis), Hint: Use VLookUp function. You will need to
create an additional cost table using the data available to you. [5 points] (3} Revenue collected from each party for their total stay at the guest house [2.5 points] and total
revenue generated for the month from all guests [2.5 points] Add one additional sheet to the spreadsheet to answer the following questions. {4} Use the SUMIFI) function to calculate the revenue collected from each room type for the whole
month. [5 pts] I5) Show a pie chart to display the revenue breakdown from (1(4) [2.5 points]. Which room type
generated highest revenue and how much revenue? [2.5 points]

Screen Shot 2020-02-11 at 12.48.15 PM.png

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Computer Science tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors