(Solved): WPC 300 Assignment 3...

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 guest(s), 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 SUMIF() function to calculate the revenue collected from each room type for the whole month. [5 pts]
5. Show a pie chart to display the revenue breakdown from Q(4) [2.5 points].  Which room type generated highest revenue and how much revenue? [2.5 points]

To get a unique copy of your answer, please contact us