Have a Question ?

Home / Answered Questions / WPC 300 / wpc-300-assignment-3-q-171

(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.

  1. Use the SUMIF() function to calculate the revenue collected from each room type for the whole month. [5 pts]
  2. 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



We have an Answer from Expert View Expert Answer

Expert Answer


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

 

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

We have an Answer from Expert
Buy This Answer $15

-- OR --

Subscribe To View Unlimited Answers
Subscribe $12 / Month