(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:
- The number of days that each party stayed at the inn [5 points]
- 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]
- 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.
- Use the SUMIF() function to calculate the revenue collected from each room type for the whole month. [5 pts]
- 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